PROFESSIONAL SUMMARY:

• Highly motivated MS BI Professional with over 7 years of experience in developing and implementing end - to-end Business Intelligence (BI) solutions for multiple domains such as Healthcare, Insurance and Banking.
• Expertise in gathering, understanding and analyzing the requirements and working with all phases of the Software Development Life Cycle (SDLC) process utilizing agile and waterfall methodologies .
• Extensive experience in implementing Microsoft Stack including SSIS, SSRS and SSAS.
• Expert in designing ETL data flows to extract data from heterogeneous sources, and data transformation from various data sources using SSIS.
• Strong experience in developing and deploying SSIS packages using dataflow and control flow components, creating SQL mail alerts and job scheduling using SQL Server Agent.
• Experienced in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Generated Ad-Hoc reports, Parameterized reports and other reports using SSRS.
• Extensive knowledge and experience in deploying reports, Subscriptions, scheduling Snapshots, managing snapshot history and managing the Report Server.
• Experience in Power BI, creating interactive visualizations, dashboards, reports based on business requirements.
• Experienced in designing and building OLAP cubes, fact and dimension tables with different architecture and data sources for business intelligence, and populating/maintaining data marts using SSAS.
• Excellent knowledge in performance tuning, query optimization, writing complex SQL Queries using functions, and stored procedures in T-SQL.
• Proficient in all phases of Data warehousing concepts, and experience in dimensional modeling using Star Schema and Snow-flake Schemas.
• Expert in creating Indexes, Triggers, Views, Stored Procedures, and User Defined Functions for optimum performance.
• Proficient in Data Migration and Metadata Management.
• A well organized, flexible, enthusiastic and project oriented team player, to develop creative solution for challenging client needs and strong in management and leadership skills.

TECHNICAL SKILLS:

Languages: T-SQL, PL/SQL, XML, HTML5, C#, ASP.NET, VB.NET

Databases:Microsoft SQL Server 2005/2008/2008- R 2/2012/2014/2016, MS Access, Oracle, Teradata, DB2, MS Azure

ETL & Data warehousing: SQL Server Integration Services (SSIS), SQL Server Business Intelligence Development Studio (BIDS), SAP Business Objects, OBIEE, SQL Server Analysis Services (SSAS), ERWIN

Reporting Tools: SQL Server Reporting Services (SSRS), Power BI ( Power Query, Power Pivot, Power View, Power Map), Tableau, Crystal Reports

Front End Tools: Microsoft Visual Studio 2013/2014

Operating System: Windows 95/2000/2003/ XP/VISTA/7/8/8.1, LINUX, UNIX

Tools: SQL Server Enterprise Manager, Microsoft Office, SQL Server Management Studio (SSMS), SQL Server Analyzer & Profiler, SQL Server Agent, SQL Server Data Tool (SSDT), DAX, Team Foundation Server (TFS), MS Visio, SharePoint, JIRA, QLIKVIEW, GIT

PROFESSIONAL EXPERIENCE:

Confidential- Basking Ridge, NJ

Sr. ETL / BI Developer

Responsibilities:

• Actively involved in requirement gathering, analyzing data sources, and in design and implementation of business logic.
• Designed Data Mapping documents, DDL scripts, Data Dictionary and Meta data of the models and maintained them.
• Worked on Creating, Configuring, and Fine-tuning ETL workflows designed in MS SQL Server Integration Services (SSIS).
• Designed and developed complex SSIS packages to validate, extract, transform and load (ETL) data to a centralized database using various data flow and control flow items from the existing diversified data sources using SQL Server Integration Services (SSIS).
• Used various SSIS tasks such as Conditional Split, Derived Column, Look-Up that were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data Warehouse.
• Created Alerts for using SQL Server Agent for implementing the Scheduled Jobs such as to call the packages and to transfer the files from one location to the other using FTP task.
• Worked on creating Stored Procedures, Triggers, Tables, Views, User Defined Functions, Cursors, Relational Database Models and Data Integrity by using T-SQL, PL/SQL.
• Built and maintained T-SQL scripts, indexes, and complex queries for data analysis and to improve existing processes.
• Implemented Incremental Loading by using the Slowly Changing Dimension transformation, and to maintain Historical Data in Data warehouse.
• Utilized Azure data warehouse for storing the data.
• Created Sub-Reports, Drill-Down reports, Ad-hoc reports, and Parameterized reports as part of the project according to business requirements using SQL Server Reporting Services (SSRS).
• Deployed and scheduled reports using SSRS to generate daily, weekly, monthly and quarterly reports to run periodically for statistical analysis of the data.
• Deployed the reports on the Report Server using Report Builder in SSRS and created roles for the users to restrict access to the reports.
• Creates new objects in the form of calculated fields, dynamic parameters, filters, etc. in order to enhance and optimize the report viewing experience.

Environment: MS SQL Server 2016/2014/2012, MS SQL Server Management Studio (SSMS), MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), Power BI, SQL Server Agent, MS Excel, MS Azure, T-SQL, PL/SQL, XML, Microsoft Visual Studio, .NET Framework.

Confidential - Edison, NJ

Sr. MS BI / ETL Developer

Responsibilities:

• Migrated data from Heterogeneous Data Sources and legacy system (DB2, Oracle, Azure, Sybase and Excel) to centralized SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
• Involved in performing incremental loads while transferring data from OLTP to data warehouse using different data flow and control flow tasks in Business intelligence studios using SSIS.
• Delivered fast iterations to the users by using agile methodology.
• Debugged SSIS ETL Packages using Data Viewers, Breakpoints and Checkpoints. Used various transformations like Derived column, Pivot, Un-pivot, copy column, merge join, union all, Lookup, audit, aggregate etc.
• Created SSIS Packages using Execute SQL Task, File System Task, Execute Package Task, Send Mail Task, Execute Process Task, Sequence container and For-Each Loop container.
• Worked for developing and designing Dashboards using Power BI.
• Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.
• Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements.
• Performed data analysis using SQL Reporting, prepared datasets supporting development of data products.
• Responsible for creating and changing the visualizations in Power BI reports and hierarchies using Bar charts and Pie charts according to the client requests.
• Generated reports like Tabular reports, Sub reports, Matrix reports, Drill down reports and Charts using SQL Server Reporting Services (SSRS) according to client requirements.
• Developed and rendered monthly, weekly and daily reports as per the requirement and gave roles, user access with respect to security in report manager.
• Worked on writing custom code expressions in SSRS.
• Extensive use of Data Analysis Expressions (DAX) expressions in tabular models as per business requirements.
• Experienced in using DAX to creating custom calculations in PowerPivot for Microsoft Excel workbooks and Analysis Services tabular model projects.
• Created OLAP cubes, facts and dimensions for the analysis of sales in different locations and process data from data mart using SSAS.
• Involved in building the dimensions, cubes with star schema and snowflake schema using SSAS.
• Worked with RDBMS concepts for creating database objects such as Tables, Functions, Stored Procedures, Indexes, and Views.
• Expertise in performance tuning of the SQL queries.
• Used SQL server agent to schedule the packages.

Environment: MS SQL Server 2014/2012, DTS, MS SQL Server Management Studio (SSMS), MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS), DAX, Power BI, SharePoint, MS Visual Studio 2012, MS Azure, MS Excel, PowerPivot, T-SQL.

Confidential - Cleveland, OH

MS BI/ SQL / SSRS Developer

Responsibilities:

• Worked on extracting the data from OLTP Systems to DWH using SQL Server Integration Services (SSIS).
• Have used BCP, Bulk Insert to transfer data from and to SQL server database.
• Responsible for Database and Log Backups & Restoration, Backup Strategies and Scheduling Backups.
• Created Packages, Jobs and Sending Alerts using SQL Mail, database Backup, Recovery and Disaster Recovery procedures.
• Performed data analysis using SQL queries to identify and track issues and anomalies.
• Extensively worked in data integration in developing ETL mappings and scripts using SSIS.
• Utilized data flow and Control flow Items for designing ETL Packages.
• Developed and modified the existing SSIS Packages to transfer data from various sources like MS Excel, MS Access, SQL Server using SSIS. Implemented Unit Testing on SSIS packages.
• Implemented various transformations such as Derived Colum, Look up, Conditional Split and Multicast and implemented the business logic.
• Created check constraints to maintain data integrity.
• Generated SSRS based reports by writing Stored Procedure using T-SQL with Input parameters.
• Created Linked reports, Ad-hoc reports (using Report Builder), and various Parameterized reports based on the requirements using SQL Server Reporting Services (SSRS). Linked reports are created in the Report Server to reduce the repetition of the reports.
• Developed reports in SSRS 2008 R2 and deployed reports into SharePoint Server 2010.
• Worked on SharePoint development and scheduling reports using it.
• Created change requests, problem tasks and incident management in Service now.
• Involved in developing reports from Cubes using the KPI's for decision-making, also debugged data connections, data sources and Data Source Views.
• Created various customer reports, executive management reports and types of report types like tables, matrix, sub reports etc.
• Implemented security to restrict the access to users and to allow them to use only certain reports.

Environment: MS SQL Server Management Studio (SSMS), MS SQL Server 2008R2/2012, T-SQL, SQL Server Data Tools, SQL Server Reporting services (SSRS), SharePoint 2010, SQL Server Integration Services (SSIS), SQL Server Agent, Microsoft Visual Studio, .NET framework 4.0, Service Now.

Confidential

SQL Developer

Responsibilities:

• Designed, developed, maintained and executed SQL scripts/queries and validated completeness, integrity and accuracy of data.
• Designed and developed Data Transformation Process (ETL) using Heterogonous Sources to Destination (SQL Server).
• Successfully created SSIS packages using Sequence Container, Data Flow, Execute SQL, Bulk Insert, and Send Mail Task.
• Used SQL Agent for job scheduling.
• Extensively worked with advanced features of T-SQL in order to design and tune T-SQL to interface with the database and other applications in the most efficient management.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler.
• Writing or modifying Stored Procedures in SQL Server 2005 to carryout database operations.
• Developed, and tested stored procedures, views and complex queries for creation of reports.
• Created monthly, weekly reports for our Clients. Generated different types of reports like List, Linked reports, and more.
• Involved in Tabular Data warehouse and DAX operations for SSAS 2012 and 2008 OLAP databases.

Environment: MS SQL Server 2008/2005, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS), DAX, MS Excel, SQL Server Management Studio, SQL server Profiler, SQL Server Agent, Microsoft office Suite (Word, Excel, PowerPoint) .