SUMMARY:

• Around 8 Plus years of Experience in Microsoft BI tools (SSIS, SSRS and SSAS) and extensively worked on SQL Server 2008/2008R2/2012/2014 Versions, writing complex SQL queries, procedures, functions, packages, cursors, exception handling, triggers, collections and performance tuning.
• Expertise in Design, Development, Implementation & Administration of Database systems using MSSQL 2008/2008R2/2012/2014 for Batch Processing using DDL, DML, DCL commands for various business applications and Data ware - housing Systems (SSRS, SSIS, SSAS).
• Expert in designing ETL data flows using SSIS ; creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from DB2/Oracle/Access/Excel Sheets using SQL Server SSIS.
• Experience at Transforming and validating data using SSIS Transformations like Conditional Split, Lookup, Merge Join, Sort and Derived Column. Experience in Error and Event Handling: Precedence Constraints, Break Points , Check Points, Logging.
• Experience in data migration using tools like Data import/export, BULK INSERT and BCP between different heterogeneous systems and SQL Server.
• Scheduling and Monitoring ETL Processes using DTS Exec utilities and batch files.
• Strong experience in creating Ad Hoc Reports, parameterized Reports, Linked Reports, Snapshot Reports, Drilldown and Drill through reports using SQL SSRS.
• Experience in developing and deploying reports into Report Manager by using SSRS (SQL Serving Reporting Tools). Managing Report Manager Securities.
• Experience in writing expressions in SSRS and expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.
• Experience in creating regular & Data Driven subscriptions by using Report Builder in SSRS.
• Wide experience in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimension members in SQL Server Analysis Services (SSAS).
• Experience in Creating number of cubes, dimensions using SQL Server Analysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings.
• Extensively Worked on Data Marts, Data Warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.
• Experience in database programming in writing T-SQL Stored procedures, Triggers, Constraints (Primary Key, Foreign Key, and Unique) Indexes and Batch Scripts using various DDL and DML commands.
• Experience in Query optimization and performance tuning. Used SQL Profiler, Execution Plan and Performance Monitor.
• Experience in creating Jobs, and Sending Alerts using SQL Mail, backups, performance issues, connectivity to databases, upgrade strategies and capacity planning.
• Experience in migrating DTS packages, reports and analysis services projects from SQL Server 2008R2 to SQL server 2012 and 2014.
• Expertise in Database design, entity Normalization & database creation, maintenance and monitoring.
• Worked on SVN, Team Foundation server, Visual Studio online and the application lifecycle tools associated with it.
• Excellent communication and inter-personal skills with ability to develop creative solutions for challenging client needs using agile and sprint methodologies etc.

SUMMARY:

Databases: MS SQL Server 2008/2008r2/2012/2014

Database Tools: Enterprise Manager, Query Analyzer, SQL Server Management Studio (SSMS), SQL Profiler, Upgrade Wizard, Database Engine Tuning Advisor, Business Intelligence Development Studio (BIDS), SQL Server Data Tools (SSDT), SQL Server Analysis Services (SSAS), SQL Server Integration Services(SSIS), SQL Server Reporting Services (SSRS)

Reporting Tools: SQL Server Reporting Services (SSRS) 2012/2008

ETL Tools: SQL Server Integration Services (SSIS), Data Transformation Services (DTS), BCP.

Languages: T-SQL, PL/SQL, C#, .Net

Web Technologies: XML, HTML

Operating System: Windows XP/7/8/8.1/10, Windows Server 2003/05/08/10

Applications: MS Visual Studio 2010/2012, MS office 2003/2007/2010, XML, Visual Studio IDE

Data Modelling: Erwin Tool, MS Excel, Visio

PROFESSIONAL EXPERIENCE:

Confidential, Long Beach, CA

Sr. SQL BI Developer/SSIS/SSRS

Responsibilities:

• Analysis & Understanding of the BRD, FS and TS documents.
• Involved in project estimations based on complexity.
• Creating logical and physical diagrams in Visio.
• Team member of agile project and responsible for project planning for sprints, participated in story building for multiple sprints.
• Developing SSIS package templates to reduce the time while developing the packages.
• Developing User define transformations using with C# and .Net code.
• Implemented various tasks and transformations for data cleansing and performance tuning of packages by using SSIS.
• Involved in creating the database object like Tables, Indexes, Store Procedure, Trigger, Views, and Roles.
• Using with SQL Server Profiler and Execution plane to trace the slow running queries and tried to Optimize SQL queries for improved performance.
• Created UNIT test cases and prepared technical specifications for SSIS packages.
• Developed design documents, UAT and deployment specification documents.
• ETL Package Jobs Scheduled in Control-M to run daily during Night Hours.
• SQL Email configuration done to send Email Alert from Control-M to inform Job Status.
• Involved in high priority tickets based on user request.
• Maintained daily and weekly status report.
• Conduct KT/Trainee sessions to the new joins in the team.
• DW Schema designed and implemented Multi-Dimensional and Tabular Model.
• User Defined Hierarchies Created for proper drill down.
• Named Calculation, Growth Calculation, Previous Period Calculation done using MDX.
• Partitions creation for faster processing and speedy query of data.
• Utilizing Perspective to implement abstraction.
• Role based Security Implemented for proper data segregation as per role.
• Excel Pivoting given to user to Analyze their data on their own.
• Performance tuning of cube for faster Process of data and avoid unnecessary elements.
• Create data models, hierarchy, measures and KPI’s.
• To create data models from different data sources and creating relations as per requirements.
• Implement roles and row level security.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Developed Dimensions, Data source views, SSAS Cubes, deployed and processed SSAS objects, created SSAS storage and partitions and aggregations.
• Responsible for report generation using SQL Server Reporting Services (SSRS) and Crystal Reports based on business requirements.
• Identified the potential Issues that occur during the package execution by redirecting the rows from source component to Error Output.
• Created Cross-Tab, Drill-down and Sub-Report using RDL. Promoted RDLs to Reporting Service Server.
• Developed Parameterized, Drill-down, Drill-through, Sub-Reports and Charts in SSRS.
• Developed Stored Procedures for parameterized, drill-down and drill-through reports in SSRS 2012.
• Created dashboards using Performance Point Server, combining scorecards and reports generated in SSRS, PPS, and Excel Services.
• Configured Report Model for developing ad-hoc reports by the end-users.
• Uploaded reports on to the report manager and organized them into folders.
• Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries

Environment: T-SQL, MS SQL Server 2014/2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Visual studio 2012/2013, SVN, MS Excel, Microsoft windows server 2012, SVN (Subversion)

Confidential, St. Louis, MO

Sr. SQL BI Developer/SSIS/SSRS

• Work closely with business users to congregate and comprehend requirements.
• Designed and worked on extraction, Transformation and Loading (ETL) process by pulling up large volume of data from various data sources using SSIS.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send mail task etc.
• Worked on execute package task, for each loop container, sequence container.
• Worked on event handlers to prevent the error in propagating to rest of package, worked on native and custom logging.
• Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Coordinating post-implementation events such as testing.
• Designed SSIS packages for tracking the Audit time in multiple databases in multiple servers and Worked on data flow task, Script component, OLEDB command, derived column, data conversion.
• Optimized the stored procedures which are using cursors and increased the performance.
• Created different chart reports helped in analyzing perform counters using SSRS.
• Analyzed data contained in the corporate database and identify data integrity issues with existing and proposed systems.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Developed drill down, drill through, cascaded and parameterized reports using SSRS and developed excel pivot chart reports and pivot tables.
• Interacted with customers to analyze business needs. Provide software product design and developed technical roadmap for the solution through the project lifecycle and beyond.
• Designed package by placing data flow task in parallel to improve performance.
• Worked on loading XML files to database tables using SSIS package.
• Identified the potential Issues that occur during the package execution by redirecting the rows from source component to Error Output.
• Development experience with RDBMS such as SQL Server and ODBMS such as Geneva.
• Used Expressions in Data flow task and for each loop container or looping over multiple files in a folder.
• Performed Data migration from and Transformation from Oracle using SQL Server SSIS.
• Involving in extracting the data using SSIS from OLTP to OLAP.
• Effectively used various properties in SSIS package to improve the performance
• Written complex stored procedures to load the data to tables per the business rules.
• Created, maintained & scheduled various reports in SSRS like Ad-hoc Reports, Canned Reports, Master Reports & Parameterized Reports using SQL Server Reporting Services SSRS.
• Created different chart reports helped in analyzing perform counters using SSRS.

Environment: T-SQL, MS SQL Server 2014/2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Visual studio 2012,2013. Business Intelligence Development Studio (BIDS), Team foundation Server(TFS), SharePoint, MS Excel, Microsoft windows server 2012.

Confidential, LA, CA

Sr. SQL BI Developer

Responsibilities:

• Designed SSIS packages to transfer the data from flat files, Access database and excel documents to the Staging Area in SQL Server 2012.
• Designed cubes with star schema using SQL Server Analysis Services (SSAS).
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Regular responsibilities for updating staging and dimensional databases as well as rebuild the Dimensions and Cubes in Analysis Services (SSAS).
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Developed Dimensions, Data source views, SSAS Cubes, deployed and processed SSAS objects, created SSAS storage, partitions and aggregations.
• Extensively involved in the SSAS storage and partitions, and aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Created, maintained & scheduled various reports in SSRS like Ad-hoc Reports, Canned Reports, Master Reports & Parameterized Reports using SQL Server Reporting Services SSRS.
• Worked on Performance tuning the existing SSAS cubes/ SSIS Packages/ Stored Procedures and optimizing the MDX queries which are used in the Reporting.
• Performed Data migration from and Transformation from DB2/Excel sheets using SQL Server SSIS.
• Written stored procedures and used them in packages.
• Involved in high level architectural design discussions for designing the MDF (Metadata framework) tables which store the business and patient data.
• Created check constraints to maintain data integrity.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Created Business-Crucial stored procedures and functions to support efficient data storage and manipulation.
• Coordinating post-implementation events such as testing.
• Used T-SQL queries to insert the complete file information and layout to MDF tables.
• Worked on for each loop containers, sequence containers and used various tasks like Execute SQL task which calls stored procedures and takes parameters, Script component task for reading the file and removing trailer records.
• Created source, stage and archive folders as per the requirements using expressions in file system task.
• Worked with Result set locator(RSL) by extracting the data.
• Created package configuration using parent package as variable and used them to deploy packages into SQL server and various environments.
• Developed master package which calls the child packages and loads the files to stage and history tables in GDW.
• Created different chart reports helped in analyzing perform counters using SSRS.
• Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Determined the SQL Server Installation. Installed SQL Server Management tools using SQL Server Setup Program.

Environment: T-SQL, MS SQL Server 2012, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), SQL Server Data Tools (SSDT), Team foundation Server(TFS), MS Excel, Microsoft windows server 2012.

Confidential - Indianapolis, IN

Sr. SQL BI Developer

Responsibilities:

• Dynamically supported business users for given requirements and developed the reports accordingly.
• Designed SSIS packages to transfer the data from DB2, flat files and excel documents to the Staging Area in SQL Server 2012.
• Monitoring SSIS packages, Stored Procedures running in Agent job and support the Production Team.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Developed Dimensions, Data source views, SSAS Cubes, deployed and processed SSAS objects, created SSAS storage and partitions and aggregations.
• Responsible for report generation using SQL Server Reporting Services (SSRS) and Crystal Reports based on business requirements.
• Used SQL Server Destination in Data flow to improve a great performance changes in Replications. (Admin rights for this operation).
• Used various Data Flow Transformations, like Derived Column, Data Conversion, Union All, Multicast and Copy Column while developing the packages.
• Used Event Handlers for Error Handling and Alert Operations.
• Developed SSIS Packages using Look Up Values & implementing rules provided by Business in the mapping document.
• Scheduled Packages using SQL Server Agent Jobs, Monitoring nightly jobs.
• Used SSIS Variables for storing the values, which are used in various components of Data Flow Task.
• Created package configuration in XML and used them to deploy packages into SQL server.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Identified the potential Issues that occur during the package execution by redirecting the rows from source component to Error Output.
• Created Cross-Tab, Drill-down and Sub-Report using RDL. Promoted RDLs to Reporting Service Server.
• Developed Parameterized, Drill-down, Drill-through, Sub-Reports and Charts in SSRS.
• Developed Stored Procedures for parameterized, drill-down and drill-through reports in SSRS 2008.
• Created dashboards using Performance Point Server, combining scorecards and reports generated in SSRS, PPS, and Excel Services.
• Developed many asp.net web applications using SQL Server and C#, to provide solutions for companywide needs.
• Published dashboards on an intranet site using SharePoint Server.
• Configured Report Model for developing ad-hoc reports by the end-users.
• Uploaded reports on to the report manager and organized them into folders.
• Generated Sales Ranking reports using SQL Server Reporting Services for different subjects
• Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries

Environment: T-SQL, MS SQL Server 2008R2/2008 and 2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), MS Excel, Windows XP.

Confidential - Durham, NC

MSBI Developer

Responsibilities:

• Developed several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SSRS.
• Worked effectively on SQL Profiler, Index Tuning Wizard, Estimated Query Plan to optimize the performance tuning of SQL Queries.
• Extensively used SQL Server Reporting Services and Report Builder Model to generate custom reports.
• Wrote and executed complex T-SQL queries using SQL Management Studio for back end data validation testing.
• Closely worked with end-users to analyze, understand and gather report requirements.
• Worked on the Reports module of the project as a developer on MS SQL Server 2005 (using SSRS, T-SQL, scripts, stored procedures and views).
• Developed and created the new database objects like tables, views, index, stored procedures and functions, advanced queries and also updated statistics using query Analyzer and Enterprise Manager on the existing servers.
• Developed reports using SSRS, used table control, matrix control for cross tab reports.
• Successfully migrated the data between the heterogeneous sources like Flat File, Excel Source and SQL server using SSIS.
• Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
• Developed the front-end screens in C# .Net using Visual Studio.
• Worked on ADO.Net to access data from database.
• Developed reports using SSRS.
• Wrote queries to generate reports for analysis of data using SQL Server Reporting Services, Report Builder.
• Migrated all DTS packages to SL Server Integration Services (SSIS) and modified the package according to the advanced features of SQL Server Integration Services.
• Converted logical database design into physical schema using the balanced normalization in 2nd and 3rd Normal forms for highest performance.
• Handled issues like data correction and resolved error handling.

Environment: Microsoft SQL Server 2008 R2 Enterprise Edition, SSIS, C#, Share Point Windows Server, windows 7/XP, Visual Studio 2010 & TFS.

Confidential - Atlanta, GA

MSBI Developer / Analyst

Responsibilities:

• Generated and debugged complex stored procedures and functions for performance tuning and optimization.
• Created complex functions and views based on the business requirements.
• Data Transformation Activities using SSIS Import/ Export for transferring data between different databases like oracle. Design new SSIS packages as per needs, Resolve the Problems.
• Tested and standardized the data to meet the business standards using Fuzzy /exact lookups.
• Designed and deployed various reports using SSRS.
• Worked closely with business users in defining and documenting reporting requirements in order to design, develop and maintain SQL Server 2008 reporting services (SSRS).
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and MS Excel format using Reporting Services (SSRS).
• Developed dimensions, cubes by using SSAS.
• Defined relationships between Measure groups and Dimensions.
• Deployed the generated reports on to the Report server and fine-tuned the database objects and server to ensure efficient data retrieval.
• Developed stored procedures for complex sub queries and joins using multiple tables.
• Extensively used T-SQL in constructing user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Involved in creating SQL reports, data extraction and data loading scripts for different databases and schemas.
• Created and configured cubes using SQL Server 2008 analysis services.
• Coordinated with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema design (Star Schema) and maintenance.
• Developed and maintained various cubes using MDX complex queries in SSAS.
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.

Environment: MS SQL Server 2008, T-SQL, Windows Server 2008, Toad, SSAS-2008/SSIS-2008/ SSRS-2008.

Confidential

Database Developer

Responsibilities:

• Coded Stored Procedures, functions and triggers at high level.
• Fine Tuned the SQL queries using hints for maximum efficiency and performance.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Created/reallocated database objects on appropriate File groups to ease maintenance and improve data access performance.
• Closely worked with the end users to analyze, understand and gather report requirements.
• Participated in User Acceptance Testing for different modules.
• Implementing user training and providing technical support.
• Prepared proper backup and recovery plans.
• Merging data into a single server for achieving better control, consistency & security of data.
• Worked on the Logical and Physical design of database for projects on basis of user requirements.
• Extraction, transformation and loading (ETL) process by pulling large volume of data from various data sources using SSIS.
• Extensively used SQL Server Reporting services and report builder model to generate custom reports.
• Wrote and executed complex T-SQL queries using SQL Management Studio for back end data validation testing.
• DBA activities like creating users, roles and granting and revoking privileges.

Environment: MS SQL Server 2008, T-SQL, SQL Windows Server 2003, and MS Access and Excel, SSIS, SSRS.