SUMMARY

• Microsoft Certified Data Analyst Associate, seven plus years of experience in the IT industry as a MS SQL Server Developer include experience in design, development and implementation of database systems using MS SQL Server 2016/ 2014/2012/2008 R2/2008 for both OLTP & Data Warehousing Systems applications with various business domains.
• Experienced in all project phases using Agile and Waterfall Methodologies.
• Experienced in complete MSBI Stack with SSIS, SSAS and SSRS.
• Experienced in designing and developing BI solutions utilizing SQL server and using Power BI, Power BI report builder, Azure SQL Server, SSIS, SSAS, SSRS.
• Integrated Custom Visuals and KPI scorecards reports using Power BI desktop and published and collaborated dashboards and reports in Power BI Service.
• Prepared and structured Query using Power Query M Formula in the Query editor.
• Developed complex calculated measures using Data Analysis Expression (DAX).
• Highly Proficient in creating SQL Server Reports, handling sub - reports, and writing queries to perform Drill through and drill down operations.
• Extensive database programming experience in writing T-SQL queries, Common Table Expressions (CTE), User Defined Functions, Triggers, Views, Temporary Tables Constraints, Indexes, and appropriate Stored Procedures using DDL and DML command to facilitate data manipulation and data consistency.
• Practical understanding of Conceptual, Logical and Physical Database design and data Modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Proficient in Developing and designing of ETL (Extract, Transform and Load) SSIS/DTS Packages for integrating data from heterogeneous sources (Excel, Xml, Oracle, flat file, Text Format Data) to MS SQL Server Datawarehouse
• Create, backup and restore Azure SQL databases
• Migrate on prem SQL Server Databases to Azure SQL databases
• Conversant with all phase of Software Develop

PROFESSIONAL EXPERIENCE

Confidential

BI DEVELOPER/POWER BI DEVELOPER

Responsibilities:

• Participated BI software development, deployment, and maintenance independently as well as a proactive team member.
• Generated and upgraded Interactive, refresh scheduled Power BI and Paginated Reports and Dashboards from SharePoint and SQL server databases.
• Generated Power BI and Paginated Power BI reports based on business requirements and business logic.
• Setting business requirements and creating technical documentation for BI tools.
• Translating business requirements into technical documentation.
• Create, design and view power bi Paginated report by using Power BI Report Builder.
• Upload and save power bi paginated report to power BI Report Server Redesign power bi dashboards and paginated reports.
• Involved in Developing and Designing ETL process based on the schemas and business requirement by using SSIS.
• Creating and Publishing Power Bi Paginated Reports in Power BI Service and Power BI report Server.

Tools: & Technology in SEC: SharePoint; GitHub; Cisco Jabber; Cisco WebEx; Microsoft teams; C#; VB; Agile; Python; Power Bi report builder; service now; Azure DevOps.

Confidential

SQL Server/ BI DEVELOPER / ETL DEVELOPER

Responsibilities:

• Worked in Developing and designing of ETL SSIS/DTS Packages for integrating data from heterogeneous sources (Excel, Xml, Oracle, flat file, Text Format Data) to MS SQL Server data warehouse.
• Designed the ETL process based on the schemas (snowflake and star schema) for extraction and transformation of data from the source database and loading on to the target database.
• Resolved SSIS Performance, SSIS package tuning by configuring data flow task using SQL Server destination and fast load mode to resolve Performance issues, tuned a process and brought down the process time from 6 hours to less than 30 minutes.
• Implemented complex business rules using multiple transformations like Conditional Split, Look up Transform, Derived Column, and Union All. Also, handled errors efficiently.
• Developed several customized power BI reports, monitoring productivity in lab test per turnaround time (TAT), resulting in dramatically decreased TAT by 100%.
• Integrated Custom Visuals and KPI scorecards using Power BI desktop and published and collaborated in Power BI Service
• Prepared documents to show the details of packages and Reports created for future reference.
• Implemented the core business process using T - SQL, Stored Procedures and Functions
• Developed code, perform reviews to advance application upgrade, extension, or other development. Analyze application for data integrity issues.
• Ability to analyze and resolve performance issue with database code involving SSIS and MS SQL Server 2005/ 2008.

Tools: & Technology in Quest: ODATA API; MySQL; SharePoint; GitHub; Slack; Trello; Oracle Data Modeler; C#; VB; SMTP; JSON; XML; HTML; Snowflake; Azure SQL; ODBC; OLE DB; Data Cube; ADO.Net; Tableau; Data Factory; GoToMeeting; Jira; Agile; Python and R, D3Java, SAS.

Confidential

SQL Server/ ETL DEVELOPER

Responsibilities:

• Consolidated data from various sources into a common data warehouse for reporting and analysis purpose using ETL (Extraction, Transformation and Loading)
• Designed ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Created SSIS packages using proper control and data flow elements with error handling.
• Enhancing and deploying the SSIS Packages from development server to team foundation server (TFS).
• Developed the chart type, Tablix, matrix reports in SSRS (SQL Server Reporting Services) like lab test status, specimens flow, department productivity from the OLAP system.
• Created reports with different features like drill through capabilities. Involved in modifying report content and exporting reports in multiple formats based on the business requirements.
• Created derived columns on the final fact and dimension tables as per the business requirements.

Tools: & Technology in ICL: SQL Server; SQL Server Data Tools; Integration Service; Reporting Service; Visio; Analysis Service; Data Profiler; TFS; Team Viewer; Waterfall; DTSX