SUMMARY:

• Senior SQL/MSBI Developer and Data analyst with 10+ years of experience in SQL development, creating MSBI solutions, interpreting and analyzing data for driving business solutions.
• Seeking highly challenging, innovative and creative assignments where I can use my expertise, attention to detail, knowledge of customer satisfaction and effort to drive an End to End reporting solution that enables business users a robust set of standardized reports to make business decisions and drive cost savings within infrastructure.

CORE COMPENTENCIES:

• Data Analysis and Validation
• Project Management
• T - SQL
• Time Management
• Cosmos
• Client Interaction
• Azure SQL
• SQL Server 2008/2012/2014
• Azure Data Factory (ADF)
• Data Warehousing
• MS Excel
• MS Sales
• SSIS
• Power BI
• SSAS
• MS Team Foundation Server

PROFESSIONAL EXPERIENCE:

Senior Technical Lead

Confidential, Bellevue, WA

Responsibilities:

• Managing a team of 8 members that works in Onsite - Offshore model.
• Maintaining TFS/VSTS and assigning User stories and tasks to team members.
• Creating DRI schedule and assigning to team members.
• Working with users to understand and capture data requirements.
• Providing Estimations to the Client.
• Involved in migration of On-Premise SQL databased to Azure.
• Created pipelines in Azure Data Factory (ADF) to pull data from Cosmos and insert into Azure SQL tables.
• Pulling data from various data sources like Monetization view, Demand View, RvR Cube, Admad Columnstore and Admad Web API and maintaining 6 years of historical data.
• Creating charts and dashboards that are regularly checked by the senior Leadership team.
• Involved in Developing and implementing new SSIS packages and maintaining already existing SSIS packages and data pipelines.
• Created Scheduled jobs using SQL Server Agent that run on daily basis.
• Created SSAS cubes, defined perspectives and created various reports on top of the SSAS cubes.
• Writing Scope Scripts and pulling data using Cosmos
• Creating Power BI reports.
• Collaborated with multiple teams to understand and set priorities to ensure successful onboarding of new data source.
• Performed the automation deployment of database objects and SSIS package using PowerShell script.
• Implemented team guidelines to stream line processes to improve the quality of deliverables and reduced manual processes by 60%.
• On boarded and mentored new team members to assist in smooth transitions as they ramped up into new roles.
• Properly maintaining the tasks in visual studio team foundation server.
• Provided stakeholders and leadership project status communications to acquire sign-off and Go/No-Go decisions.
• Monitored and troubleshoot SQL Server 2012 and ETL’s as per SLA’s. Performed data validation between upstream tools and reports to identify and fix data anomalies.

Technologies Used: SQL server 2012, T-SQL, SSIS, SSAS, SQL Azure, Azure Data Factory, Cosmos, Power BI, PowerPivot, PowerShell, SQL Server Agent, SQL Server Profiler.

Technical Lead

Confidential, Redmond, WA

Responsibilities:

• Created charts and dashboards that are regularly checked by the clients.
• Involved in Developing and implementing new SSIS packages and maintaining already existing SSIS packages and data pipelines.
• Created Scheduled jobs using SQL Server Agent that run on daily basis.
• Created SSAS cubes, defined perspectives and created various reports on top of the SSAS cubes.
• Collaborated with multiple teams to understand and set priorities to ensure successful onboarding of new data source.
• Performed the automation deployment of database objects and SSIS package using PowerShell script.
• Created Power BI reports.
• On boarded and mentored new team members to assist in smooth transitions as they ramped up into new roles.
• Properly maintaining the tasks in visual studio team foundation server.
• Provided stakeholders and leadership project status communications to acquire sign-off and Go/No-Go decisions.
• Monitored and troubleshoot SQL Server 2012 and ETL’s as per SLA’s. Performed data validation between upstream tools and reports to identify and fix data anomalies.

Technologies Used: SQL server 2012, T-SQL, SSIS, SSAS, Power BI, PowerPivot, PowerShell, SQL Server Agent, SQL Server Profiler.

Technical Lead

Confidential

Responsibilities:

• Worked on Confidential Business Intelligence stack for Confidential Client.
• Involved in data analysis with various stakeholders using SQL 2012.
• Publishing Power BI dashboard for the stakeholders on weekly basis.
• Providing Estimations to the Client.
• Automated the entire process to pull data from upstream source MSSales, creating Expiration and Renewal tables and uploading Renewal reports to the sharepoint.
• On boarded and mentored new team members to assist in smooth transitions as they ramped up into new roles.
• Coordinated with the stakeholders to prioritize the project deliverables.
• Worked with Onsite team on the project deliverables
• Key contributor to data warehouse design and development.
• Developed the Powerpivot reports using the SSAS cube.

Technologies Used: SQL server 2012, T-SQL, SSIS, SSAS, Power BI, PowerPivot, PowerShell, SQL Server Agent, SQL Server Profiler.

Senior Software Engineer

Confidential

Responsibilities:

• Worked on Confidential Business Intelligence stack .
• Developed data warehouse solution and built the SSAS cube on top of the data warehouse.
• Developed the Powerpivot reports using the SSAS cube.
• Coordinated with the stakeholders to prioritize the project deliverables.
• Key contributor to data warehouse design and development
• Designed, developed and modified databases according to users requirement.
• Creating Stored Procedures, Functions and SQL queries.
• Developed and implemented SSIS packages for different stages of ETL.
• Involved in fixing the invalid packages and troubleshooting the technical problems of the database.
• Done extensive testing and wrote queries in SQL to ensure the good quality data.
• Performed unit testing at various levels of the ETL.
• Coordination in the System Integration tests, User Acceptance testing.
• Coordination in the Go-live phase.

Technologies Used: SQL server 2005/2008, T-SQL, SSIS, SSAS, SQL Server Agent, SQL Server Profiler, MS Access, VB.Net