SUMMARY

• Experienced working on Agile Projects with Multiple Sprints cycles and Scrum meetings.
• Broad experience in different phases of Software Development Life Cycle (SDLC).
• Strong experience with demonstrated success in the Database Design, Development and Implementation using MS SQL Server 2016/2012/2008.
• Extensive experience in T - SQL for developing Stored Procedures, Triggers, Indexes, View, User Defined Functions, CTE, Temp Tables, Table Variables and SQL Joins.
• Experience in relational database and Data Warehousing Design concepts.
• Proficient in Data Modeling using ER Model and Multidimensional Model, Good knowledge in Star Schema and Snowflake Schema.
• Handful experience in design & creating SSIS packages for extracting, transforming & loading (ETL) data from Excel, Flat Files & other sources to different databases & data warehouses.
• Experience in providing Logging and Error handling by using Event handler, & Custom Logging
• Expertise in creating different reports like Drill-Down, Drill-Through, Parameterized, and Tabular reports based on client requirement using SSRS.
• Experience in designing, developing, and implementing Power BI solutions.
• Experience demonstrating Power BI building blocks including visualizations, dashboards, reports, apps, and datasets.
• Experience with interactive/dynamic report and dashboard development and leveraging all visualization and functionality options available in Power BI using Visual Insight Dashboard and Reporting Service Document.

TECHNICAL SKILLS

Databases: MS-SQL Server 2008/2012/2016/2017 , MySQL, MS-Access

BI Tools: SSIS, SSRS, SSAS, Power BI

Project Management Tools: Trello

Ticketing System: Zendesk

Version Control System: GitHub, TFS, Azure DevOps

Operating System: Windows 2008/2003 Advanced Server, NT & Windows 9x, Linux, Unix

Communication: Slack, Outlook, WebEx

PROFESSIONAL EXPERIENCE

ETL/Power BI Developer

Confidential

Responsibilities:

• Created Dimensional Data Model based on business specifications
• Involved in gathering business requirements & prepared technical specifications documents
• Created stored procedures, triggers, views, and functions and wrote complex queries using T-SQL to address various reporting operations and application development
• Created SSIS packages for data extraction from heterogeneous Sources
• Developed SSIS packages using Lookup Transformations, Merge Joins, Union all Fuzzy Lookup and Derived Columns with Multiple Data Flow tasks.
• Scheduled Daily, Weekly & Monthly SSIS package execution using SQL Server Agent
• Utilized event handling effectively to generate audits and logs for the SSIS packages.
• Migrated SSIS packages from SQL Server 2012 to SQL Server 2016.
• Generated parameterized reports, sub reports, tabular reports using SSRS.
• Actively supported business users for changes in SSRS report & Data flows processes
• Worked extensively on Power BI Services in creating Analytical and operational reports.
• Configured Power BI Workspace in Power BI Service
• Published Power BI Reports to Power BI Workspace
• Created SSAS Tabular and multidimensional cubes for data analysis
• Created Documents and Dashboards in Design mode and Executed in Web.
• Worked on developing complex reports which involved advanced metrics, filters, custom groups, and Consolidations using Power BI.

SQL/ETL Developer

Confidential

Responsibilities:

• Designed & developed T-SQL procedures, query performance tuning and SSIS packages.
• Analyzed the source data for data mapping to staging tables, data warehouse & data marts.
• Created functions to provide custom functionality as per the requirements.
• Created complex Stored Procedures, Triggers, User Defined Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
• Created indexed views and appropriate indexes to reduce complex queries runtime.
• Performed data cleansing & validation to support report requirements.
• Used SSIS to implement slowly changing dimensions to maintain historical data
• Used various SSIS transformations such as conditional split, look-up table and derived column for data scrubbing & data validation during staging process
• Deployed SSIS Package into Production and scheduled SSIS jobs through SQL Server Agent