SUMMARY

• Having 8+ Years of experience in Business Intelligence and Data warehousing, Decision support Systems and extensive experience in implementing Full Life cycle Data Warehousing Projects.
• As a BI Lead, Extensive usage of BI tools like SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) (Tabular and Multi - Dimensional), SQL Server Reporting Services (SSRS) and Power BI (Power Pivot, Power View and Power Query).
• Extensive knowledge and experience in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export.
• Excellent experience in Database Design and Dimensional Data Modeling Star & Snow-Flake Schema (both OLTP & OLAP).
• Extensive experience in creating SSIS Packages for integrating data using OLE DB connection from different sources like Excel, CSV, Oracle, flat file, and Text Format Data by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Experience in providing Logging, Error handling using Event Handlers, Pre, and post for SSIS Packages, check points(package restart ability features), break points.
• Created various SSRS Reports involving variety of features like Reports, Charts, Filters, Sub-Reports, Drill Down, Drill-Through, Multi-valued parameters.
• Proficient in Calculating Measures and Members in SQL Server Analysis Services (SSAS) using multi-dimensional expression (MDX) and Created Parameterized Reports in MDX.
• Extensive experience in creating different kind of charts like Pareto, Bar and Line Charts by using Excel Power Pivot DAX and also automate the Excel refresh by using SSIS.
• Experience in migrating SSIS packages from SQL 2008 R2 to SQL 2012 also by using SQL 2012 new deployment mechanism and deployed packages into SSIS Catalog.
• Hands-On-Experience on Database deployment on Windows Azure (Cloud).
• Hands-On Experience on PowerShell Script to deploy BI Components.
• Hands-On Experience on writing Unit Test Cases to reduce the bugs.
• Experience in Onshore-Offshore Model.
• Ability to meet deadlines in a fast paced environment.
• Ability and passion to pick up new technologies and stay on the cutting edge of development.
• Good team player, Strong interpersonal and communication skills combined with self - motivation, initiative and ability to think outside the box.
• Proficient in giving Corporate Technical training (MSBI Stack) and handled 2 fresher batches.

TECHNICAL SKILLS

Operating System: Windows

RDBMS: Confidential SQL Server

DB Programming Languages: T-SQL, MDX

ETL Tools: SQL Server Integration Services (SSIS)

Cube Design Tool: SQL Server Analysis Services (SSAS)

Reporting Tools: SQL Server Reporting Services (SSRS)Excel Power Pivot, Power View

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Involved in entire product life cycle development from the requirement gathering through implementing in production.
• Excellent experience in Database Design and Dimensional Data Modeling Star & Snow-Flake Schema (both OLTP & OLAP).
• Loading data from different source systems like Sybase, SAP to SQL Systems SSIS and also by using SQL 2012 new deployment mechanism and deployed packages into SSIS Catalog.
• Developed SQL Server Integration Services (SSIS) packages to automate the nightly extract transform and load jobs.
• Experience in SSIS script tasks, Look up transformations and Data flow tasks using T- SQL.
• Implemented the Delta Pull for reducing the daily job time and maintain historical data.
• Created Load Control table for tracking the data load.
• Automated execution process of packages using SQL Server Agent by creating jobs and error reports using Alerts, SQL Mail Agent and SMTP.
• Hands-On experience on generating Cognos reports and scheduling the reports
• Prepared technical documentation.
• Worked on Coding, Code reviews Issue management and status reporting.
• Working with business and resolve ad-hoc queries.

Confidential, Houston, Texas

Responsibilities:

• Involved in entire product life cycle development from the requirement gathering through implementing in production.
• Worked with Data Modeller and DBAs to build the data model and table structures.
• Excellent experience in Database Design and Dimensional Data Modeling Star & Snow-Flake Schema (both OLTP & OLAP).
• Used BIDS to design SSIS packages to transfer data between servers, load data into database, and archived data file from different DBMS. Scheduled the job to do this task periodically.
• Developed SQL Server Integration Services (SSIS) packages to automate the nightly extract transform and load jobs.
• Implemented the Delta Pull for reducing the daily job time and maintain historical data.
• Created Load Control table for tracking the data load.
• Automated execution process of packages using SQL Server Agent by creating jobs and error reports using Alerts, SQL Mail Agent and SMTP.
• Experienced on creating SSAS tabular model, calculated measures and data security for report data.
• Prepared technical documentation.
• Worked on Coding, Code reviews Issue management and status reporting.
• Working with business and resolve ad-hoc queries.

Confidential

Responsibilities:

• Worked with Business Users and gathering the requirements.
• Design and developed the data model, SSIS Packages, Tabular Model and Power View reports.
• Developed SQL Server Integration Services (SSIS) packages to automate the nightly extract transform and load jobs.
• Experienced in using SQL 2012 new mechanism of deploy the SSIS packages in SSIS Catalog. Schedule the SSIS jobs by using SSIS Catalog.
• Prepared the PowerShell scripts to deploy BI (DB, SSIS, Model and Job Configuration) Components.
• Created the Unit Test Projects to deliver bug free solutions.
• Created the jobs for package automation using SQL Server Agent.
• Generate the Power View reports by using SSAS Tabular model.
• Provided data security in Power View reports by using DAX queries
• Implemented the Delta Pull for reducing the daily job time and maintain historical data.

Confidential

Responsibilities:

• Prepared complex T-SQL / MDX queries for creating PowerPivot and SSRS reports.
• Created different kind of charts like Pareto, Bar and Line charts by using Excel Power Pivot.
• Tuning the T-SQL queries and SSIS Packages.
• Upgrading the Excel Power Pivot reports from 2010 to 2013 with using Excel 2013 features.
• Generated Pivot reports by auditing the SharePoint and Excel Pivot logs.
• Created the ETL’s to download from SharePoint / shared folders and automated the Excel file refresh again published to shared folders.
• Created the jobs for package automation using SQL Server Agent.

Confidential

Responsibilities:

• Troubleshooting the SQL Queries to fix the bugs.
• Writing and Debugging T-SQL, stored procedures, Views and User Defined Functions
• Prepared complex T-SQL queries for creating Pivot table reports.
• Documentation - Created mapping documents among the report in different environments
• Generated Power Pivot reports and Graphs for market trends as per BRD.
• Prepared UAT scripts for validating the Pivot reports

Confidential

Responsibilities:

• Support existing DW platform/applications to ensure system availability and scalability.
• Work directly with functional analysts and business users in understanding the information needs of the business and involving in developing new data warehouse/BI functionalities or tools to meet these requirements.
• Worked with various teams for their data modelling, database design.
• Involved in writingstored procedures andViewsfor business logic and functionality of various modules.
• Developed the packaged for handled the huge amount of data from files and DB and also maintain the file status for tracking at any cost.
• Handled the errors in packages and also provided the error logging.
• Created the jobs for package automation using SQL Server Agent.

Confidential

Responsibilities:

• Studied the existing OLTP systems and facts, dimensionsandstar schemarepresentation for the data warehouse.
• Worked on developing Views, Creating complex stored procedures and user defined Functions.
• Report parameters includedsingle valued parameters,multi-value parameterswhich also consisted of different parameter types.
• Used multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.
• Created various kinds of reports like Drill-through, Parameterized, Linked, Chart, Plotting Reports