PROFESSIONAL SUMMARY:

• Around 6 years of experience in complete MSBI Stack including data analysis, database design, data mapping and conversion and data load with SSIS, SSAS and SSRS.
• More than 2 years of experience in Microsoft Power BI, Power Query, DAX and Power Pivot
• Experienced in full life cycle ETL development using SSIS.
• Extensive experience in creating many complex SSIS packages using SQL Server Integration Services 2015/2012/2008 R2.
• Hands on experience in installing, configuring, managing, upgrading, and migrating, monitoring, and troubleshooting SQL Server 2016/2012/2008 R2.
• Thorough knowledge of database management concepts like conceptual, logical and physical data modeling and data.
• Experienced in Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
• Experience in Extraction and Migration of Data from heterogeneous data sources like flat files, CSV, Excel, MS Access, Oracle, XML & MS SQL Server using SSIS.
• Experienced in Microsoft Power BI to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel data in to database.
• Experience in creating Data Driven, Drill Through, Drill Down, Tabular, Matrix reports & created charts, graphs using SQL Server Reporting Services 2015/2012/2008 R2.
• Tuned and optimized queries by altering database design, analyzing different query options and indexing strategies.
• Well experienced in Published reports and dashboards using Power BI.
• Created reports in Power BI by importing data, shaped and transformed data for business intelligence (BI), Visualize data, author reports, scheduled automated refresh of reports and created and share dashboards based on reports in Power BI desktop. well experienced working with very large databases and Performance tuning.
• Experience in Designing reports using Report Designer, Report Builder3.1, Report Manager, creating parameterized reports & managing subscriptions.
• Worked on Report Manager to subscribe reports, Assign roles, user access with respect to security.
• Experienced in working in Agile and Scrum Methodology environment.
• In - depth understanding of all stages of software development life cycle (SDLC).
• Good knowledge and experience in Data Warehouse design (Kimball Group) of Dimensional Modeling, ETL Design and Dimensional and Facts Maintenance.
• Experienced in well document the requirements and well known of the change control process.

SKILL:

OLAP/Reporting Tools: SSRS, SSAS, MDX, Power BI

Relational Databases: SQL Server database 2014/2012/2008 R2/2005, Oracle 11g, SQL Server Azure, MS Access

SQL Server Tools: Microsoft Visual Studio 2010/2013/2015 , SQL server management studio

ETL Tools: SQL Server Integration Services (SSIS), SQL Server DTS

Other Tools: MS Office 2003/2007/2010 and 2013, Power pivot, Power Builder

C, SQL, PL/SQL, T: SQL, JAVA, Batch scripting, R, Python

Data Warehousing & BI: Star Schema, Snowflake schema, Facts and Dimensions tables

Operating Systems: Windows XP/Vista/7/8 and 10; Windows 2003/2008R2/2012 Servers

PROFESSIONAL EXPERIENCE:

SSIS, SSRS, POWER BI, AZURE SQL DEVELOPER

Confidential, Dulles, VA

Responsibilities:

• Involved in requirements gathering, analysis, design, development, change management, deployment.
• Designed, developed and deployed Business Intelligence solutions using SSRS
• Created Dax Queries to generated computed columns in Power BI.
• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
• Developed ETL packages in SSIS and pulling data from different data warehouse databases like Oracle, DB2
• Developed SSIS packages bringing data from diverse sources such as Excel, SQL server, flat files, Oracle DB for the daily load to create and maintain a centralized data warehouse.
• Designed and configured SSIS packages to migrate the data from Oracle, legacy System using various transformations.
• Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps
• Used Power BI Gateways to keep the dashboards and reports up to date and Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services.
• Scheduled and monitored the SQL Server Agent jobs to run the SSIS packages and stored procedures
• Analyzed and troubleshoot performance tuning SQL and complex SSIS packages.
• Generated customer reports using SQL Server Reporting Services 2012/2015/2017 from the OLTP data sources.
• Designed and deployed reports with Drill Down, Drill Through and Drop-down menu option and Parameterized and Linked reports.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including status.
• Created standard report Subscriptions and Data Driven Report Subscriptions.

Environment: SQL Server 2016/2017, Microsoft Visual Studio 2015/2017, MS Office, DAX, SSIS, SSAS, SSRS, SharePoint, Power pivot, Power view, Power BI, Azure SQL

SQL DEVELOPER/BI DEVELOPER

Confidential, PHOENIX, AZ

Responsibilities:

• Created Power BI Dashboards with Tiles and Pins from Reports, Insights and Workbooks
• Created new reports from Datasets using Power BI Cloud Worked with Edit Interactions
• Developed SSIS package for transferring the data between MS Excel, Flat Files and SQL Server.
• Working with Microsoft R Visuals for Data Automation and Forecasts and Running R Scripts
• Worked with DBA to perform data consistency and performance tuning effectively with SQL Profiler, Index Tuning Wizard.
• Worked with Power BI Report Publish options from Power BI Desktop.
• Worked on various Power BI Visuals and Visual Properties including Tree Map, Pie Chart, Funnel, Scatter Bar Chart and Column Charts
• Experience in Error Handling using global variables and logging of the errors into database
• Created various Tables, Views and Indexes.
• Created highly complex SSIS packages using various Data transformations like conditional splitting, Fuzzy Lookup, Multi Cast, column conversion, Fuzzy Grouping, Script Components.
• Wrote complex Stored Procedure, Queries, Triggers, Functions, User-defined functions and Cursors for application.
• Used SQL Profiler to trace out problems in slower execution plans.
• Administered Reporting Services by securing Report Server Content by defining roles, role assignments & assigning item level, system level security.
• Created Filtered reports using report parameters, stored procedures & cascading parameters.
• Created several report subscriptions to deliver reports to the end users via email.

Environment: SQL Server 2012/2014, Microsoft Visual Studio 2015, MS Office, DAX, SSIS, SSAS, SSRS, SharePoint, Power pivot, Power view, Power BI, Azure SQL

SQL DEVELOPER, DATABASE DEVELOPER

Confidential, HOUSTON, TX

Responsibilities:

• Developed SSIS package for transferring the data between MS Excel, Flat Files and SQL Server.
• Created highly complex SSIS packages using various Data transformations like conditional splitting, Fuzzy Lookup, Multi Cast, column conversion, Fuzzy Grouping, Script Components.
• Worked with DBA to perform data consistency and performance tuning effectively with SQL Profiler, Index Tuning Wizard.
• Experience in Error Handling using global variables and logging of the errors into database
• Created various Tables, Views and Indexes.
• Wrote complex Stored Procedure, Queries, Triggers, Functions, User-defined functions and Cursors for application.
• Used SQL Profiler to trace out problems in slower execution plans.
• Developed several reports with multi-level drill downs and used several Charts to represent the data in the reports using SQL Server 2008 Reporting Services (SSRS).
• Administered Reporting Services by securing Report Server Content by defining roles, role assignments & assigning item level, system level security.
• Created Filtered reports using report parameters, stored procedures & cascading parameters.
• Created several report subscriptions to deliver reports to the end users via email.

Environment: SQL Server 2008/2012 R2, Microsoft Visual Studio 2012, MS Office, SSIS, SSAS, SSRS, SharePoint

SQL DATA ANALYST

Confidential, NYC

Responsibilities:

• Designed and created Data Marts in data warehouse database
• Implementations of MS SQL Server Management studio 2008 to create Complex Stored Procedures and Views using T-SQL.
• Collecting the data from many resources and converting into flat text files with comma delimiter separator and importing the data to the SQL server for data manipulations.
• Responsible for deploying reports to Report Manager and Troubleshooting for any errors during the execution.
• Scheduled the reports to run on daily and weekly basis in Report Manager and emailing them to director and analyst to be reviewed in Excel Sheets.
• Created several reports for claims handling which had to be exported out to PDF formats.
• Analyzed business requirements and provided excellent and efficient solutions

Environment: SQL Server 2008, Microsoft Visual Studio 2008, MS Office, SSRS