SUMMARY

• Experienced working on Agile Projects with Multiple Sprints cycles and Scrum meetings
• Experienced using Agile Project management tools like Trello and JIRA
• Hands on experience working on Waterfall Projects with full SDLC
• Extensive experience in analysis, design and development of software applications in SQL Server.
• Extensive knowledge in ER Diagram and design of logical and physical data modeling using Erwin tool and Visio.
• Extensive experience in designing de - normalized data warehouse including Star Schema, Snow Flake Schema and data flow diagrams.
• Extensive experience in creating and using Stored Procedure, Views, Triggers, schemas and Complex queries on SQL Server Management Studio.
• Extensive work experience on Common Table Expressions, Cursors, Functions, User-Defined Types and Dynamic SQL.
• In depth experience in using SQL Server Data Tool (SSDT) and business intelligence development studio (BIDs)
• Hands on experience in configuring Data Flow source and destination connection strings
• Extensive experience in implementing event driven Error handlings and package logs.
• Expert in creating Dynamic SSIS Packages with Parameters, local and environmental variables, XML configuration and check points.
• Hands on Experience on SSIS package development, deployment and scheduling.
• Expert in creating data visualizations such as dashboards, parameterized reports, drill down reports, and interactive reports using SQL Server Reporting Service.
• Hands on experience on developing Page level Reports, Dashboards, and Stories Using Microsoft Power BI
• Extensive experience in implementing self-service reporting capabilities using SQL Server Analysis service, Power BI and Report Builder.
• Hands on experience on migration
• Hands on experience on creating user roles
• Good knowledge on programming
• Hands on experience on Azure service
• Experienced in Database Optimization using SQL Profiler, Database Tuning Advisor, and windows performance monitor.
• Strong interpersonal & communication skills, Competitive analytical, logical, and problem solving skills, Strong management, administrative and leadership skills to work in team.

PROFESSIONAL EXPERIENCE

ETL/POWER BI DEVELOPER

Confidential

Responsibilities:

• Involved with full development cycle of a Data Warehouse, including requirements gathering, design, implementation, and maintenance.
• Worked with Type 1 and 2 dimensions, Fact Tables, Star Schema design, Operational Data Store (ODS), leveling and other Data Warehouse concepts.
• Export and import data from Flat file, CSV file, Excel to/from SQL Server database using SSIS.
• Developed Complex SSIS Packages to load data into Staging, ODS, and Data Warehouse systems.
• Developed various T-SQL objects such as Functions, Tables, Views, Triggers, Indexes, Constraints, Stored Procedures and Queries to be used in the project.
• Building an end to end data warehouse testing strategy source extract to staging, dimension data to the ODS, fact data to the data warehouse and report and portal functions extracting data for display and reporting
• Optimized the performance of queries with modification in T-SQL queries, creating sub queries, establishing joins and creating indexes wherever necessary.
• Developed, monitored and deployed SSIS packages for ETL flow to validate, extract, transform and load data into database.
• Managed and monitored the system utilization by using the query optimizer and checking the execution plan.
• Generating reports using power BI Dashboard.
• Documented and delivered Functional Specification Document to the project team by using SQL Server.
• Imported data from SQL Server DB, Azure SQL DB and other data sources to Power BI to generate reports, to create dashboard, and to build content pack.
• Used KPI Scorecards to measure progress towards a set performance indicator.
• Created Dax Queries to generate computed columns in Power BI.
• Created Row level security with power bi and integration with power bi service portal.
• Generated computed tables in Power BI by using Dax.
• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
• Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps.
• Explored data in a Variety of ways and across multiple visualizations using Power BI.
• Created custom visuals for Power BI.
• Used Power BI Gateways to keep the dashboards and reports up to date.
• Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services.
• Created reports using time intelligence calculations and functions.
• Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.

SQL/BI DEVELOPER

Confidential

Responsibilities:

• Involved with full development cycle of a Data Warehouse, including requirements gathering, design, implementation, and maintenance.
• Worked with Type 1 and 2 dimensions, Fact Tables, Star Schema design, Operational Data Store (ODS), leveling and other Data Warehouse concepts.
• Export and import data from Flat file, CSV file, Excel to/from SQL Server database using SSIS.
• Developed Complex SSIS Packages to load data into Staging, ODS, and Data Warehouse systems.
• Developed various T-SQL objects such as Functions, Tables, Views, Triggers, Indexes, Constraints, Stored Procedures and
• Queries to be used in the project.
• Optimized the performance of queries with modification in T-SQL queries, creating sub queries, establishing joins and creating indexes wherever necessary.
• Developed, monitored and deployed SSIS packages for ETL flow to validate, extract, transform and load data into database.
• Managed and monitored the system utilization by using the query optimizer and checking the execution plan.
• Created SQL server Analysis Projects; created Multidimensional databases cubes, facts and dimensions for the analysis of products in specific areas using SSAS.
• Design and Developed multiple Enterprise reports using SSRS from both OLTP and OLAP databases
• Generating reports using power BI Dashboard.
• Documented and delivered Functional Specification Document to the project team by using SQL Server.
• Tested the reports and fixed bugs in the stored procedures. Involved in scheduling the reports and setting security for reports.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track report history using SSRS.