Gitesh Shiraskar

• Developed, modified SSAS cubes to fulfill business requirements as well as provided support in case of failures.
• Created SSRS as well as Power BI reports for the report migration project.
• Created SSIS packages, stored procedures and agent jobs to implement North America GO LIVE Project.
• Implemented value ideas to reduce the business cost as well as efforts.
• Performed SSAS cube migration from one server to another to streamline the process.
• Developed stored procedures for Business Critical report as a part of Finance as well as other reporting areas.
• Provided emergency support in case of ETL issues as well as trained people to handle emergency situations.
• Troubleshooting performance issues and fine-tuning queries and stored procedures.

• Software/Special Tools :

• MS SQL Server 2016, Business Intelligence Development Studio (BIDS), Visual Studio 2013 and Linux.

· Created and managed schema objects such as tables, views, indexes, stored procedures, triggers and ETL required for Business reporting.

· Created SSIS packages to automate the Business critical reports.

· Developed stored procedures for Business reports used by Carriers.

· Developed Power BI reports as per Business Requirements.

Handled BAU tasks as well as provided emergency support in case of ETL issues.

• Software/Special Tools :

• MS SQL Server 2016, Business Intelligence Development Studio (BIDS), Visual Studio 2012 and Power BI Desktop .

• Created and managed schema objects such as tables, views, indexes, stored procedures, triggers and ETL as a part of Penguin Update project
• Developed SSIS packages for data extraction from Excel Files, flat files and OLEDB to SQL Server and to automate ETL’s
• Created SSIS packages, stored procedures and agent jobs to implement cross server reconciliation project
• Developed stored procedures for Business Critical report as a part of Finance as well as other reporting areas
• Developed, modified SSAS cubes to fulfill business requirements as well as provided support in case of failures
• Created test environments, created database backup-restore jobs to restore databases in the test environments
• Provided emergency support in case of ETL issues as well as trained people to handle emergency situations
• Worked on python scripts and GCP to resolve Qualitrics API issue on the cloud
• Troubleshooting performance issues and fine-tuning queries and stored procedures
• Software/Special Tools:
• MS SQL Server 2016, Business Intelligence Development Studio (BIDS), Visual Studio 2013 and Tableau Dashboard.

• Lead team of 7 people which splits into 4 developers and 3 support members
• Created and managed schema objects such as tables, views, indexes, stored procedures and triggers & maintaining referential Integrity
• Implemented data mart solely to segregate the business critical reports using SSIS as well as SSAS
• Provided emergency support in case of ETL issues as well as trained people to handle emergency situations
• Created SSIS packages for data extraction from Flat Files, Excel Files and OLEDB to SQL Server
• Developed complex stored procedures for the reports along with tabular, ad-hoc, drill down as well as drill through reports using SSRS Report Designer
• Troubleshooting performance issues and fine-tuning queries and stored procedures
• Created PowerBI Reports as per business requirements
• Software/Special Tools:
• MS SQL Server 2014/2012, Business Intelligence Development Studio (BIDS), Visual Studio 2013/2012 and PowerBI Desktop.

• Created mines operation specific SSRS reports like Haul Truck Performance report, Mining Availability report, Equipment Performance report etc
• Created stored procedures and user defined functions for the reports
• Installed SQL server in windows as well as Linux environments
• Created various packages to extract and load data from different data sources using various transformations
• Used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc
• Creation of Package configurations, Logging, deploying of packages to target server
• Scheduled and automated SSIS packages using SQL Server Agent in SSMS
• Software/Special Tools:
• MS SQL Server 2008, Business Intelligence Development Studio (BIDS), Visual Studio 2008.

• Created SSRS and crystal reports for mining operations like production, machine downtime and break time reports
• Developed stored procedures as well as ad hoc queries for the reports
• Installed SQL server in windows and Linux environments
• Created SSIS packages to extract data and load data from different SQL server and MS Excel using different transformations
• Scheduled SSIS packages to run at different intervals to load the data
• Software/Special Tools:
• MS, 2008,Visual Studio 2008,Crystal Reports

• Created mining operation specific SSRS, Crystal reports like Shift Production report, Productivity report, Status report, Operator Summary report etc
• Developed stored procedures, created datasets using stored procedures, ad hoc queries and reports using multi value parameters
• Improved the performance of the queries using indexes and other optimizing techniques
• Certifications & Affiliations
• Completed SQL server,MSBI and PowerBI training from Enosis Learning
• Completed VMware vSphere 5.5 and 6.0 training programs
• Published & Presented / Awards
• Received Rockstar of the month award in year 2019
• Received Rising Star Peer to Peer award in year 2018.