PROFESSIONAL SUMMARY:

• Over 7+ years of experience in various domains like Healthcare, Insurance, Banking, and Retail with expertise in MS SQL Server SSIS, SSRS for versions 2012/2008r2/2008/2005
• Conversant with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Extensive experience in MS SQL Server 2012/2008r2/2008, and Business Intelligence tools such as SSIS, SSRS and SSAS.
• Expert in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from heterogeneous databases such as Oracle 11g, DB2.
• Highly proficient in using T - SQL for developing Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Data Integrity, SQL joins and Query Writing using SSMS.
• Strong experience in designing and developing more than 100+ enterprise reports (SSRS/ Business Objects) using the data from ETL Loads, SSAS Cubes and various heterogeneous data sources.
• Expert in creating MOLAP Cubes dimensions and facts tables and also optimized MOLAP Cubes by partitioning, designing aggregations, implementing hierarchies and calculated members.
• Assisted in production OLAP cubes, wrote queries to produce reports using SSAS and SSRS.
• Expert in Creating and Deploying SSRS Reports on the portal for user accessibility.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.
• Extensive experience in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2008r2, and 2008.
• Experienced in Conceptual, Logical and Physical Database design and development, Normalization and Data modeling using Erwin and MS Visio.
• Strong experience in SQL Server Installation, Capacity Planning, Creating and Implementing Backup and Recovery Strategy, Log Shipping, Replication, Attaching and Detaching the database, and database designing.
• Expert in using tools like MS SQL Profiler, Performance Monitor, Database Engine Tuning advisor, Index Tuning Wizard, and Execution Plan for Query Optimization, resolving Dead Locks, and Long/Slow running queries.
• Experienced in upgrading SQL Server r2.
• Scheduled jobs and alerts using SQL Server Agent and troubleshoot any failures or alert problems.
• Expert in Database Backup, Recovery and applied necessary SQL Server database Service packs, hot fixes and Security Patches.
• Defined and administered database standards, controls, procedures and documented the same.
• Extremely diligent strong team player with an ability to take new roles and ability to work under pressure in a highly visible role and 24x7 on call support.

TECHNICAL SKILLS:

• MS SQL Server 2012/2008r2/2008/2005
• Visual studio 2010/2008 (SSIS/SSRS)
• Microsoft Access 2007/2003, MS SQL Profiler
• SQL server Query Analyzer, Index Tuning Wizard
• Oracle 11g,10g, and 9i, DB2, MySQL, Cognos report
• Informatica, Windows Server, Microsoft SharePoint
• Erwin, SSMA, MS Access, Java, C++, MS Office.

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

MS BI/ SSIS/ SSRS Developer

Responsibilities:

• Wrote from simple to complex T-SQL queries in SQL Server Management Studio, for extraction of data from staging environment based on the requirement and pushed the required data to UAT environment.
• Created simple to complex Store Procedure to re-use all the complex queries that I wrote for the River Stone’s Enterprise Data Warehouse (EDW) in a specific format with the help of given template.
• Responsible to create various Tables, Views and Functions based on the requirement specified by EDW team and wrote complex Join statements for combining data from various Databases and tables in different relational model database server such as Oracle and DB2.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Fine-tuned SQL queries for maximum efficiency and performance using MS SQL Profiler, Database Engine Tuning Advisor, Execution Plan and Index Tuning wizard.
• Involved in improving database performance using SQL Profiler, Trace Flags, Execution plan and Index Tuning Wizards.
• Created appropriate measure groups and KPIs & deployed Cubes.
• Worked with a Cognos team and helped to create complex by weekly, quarterly and annual report by writing code based on the requirement.
• Produced operational reports in SSRS 2012/2008R2 i.e. Drill-Down, Drill-through, Dashboard, Sub-Report, and Matrix reports.
• Attained legacy data to use as a source to develop new reports previously compiled and maintained manually.
• Created SSRS Data Model projects using Microsoft Visual Studio 2010 and using Report Builder for report server to create reports.
• Converted manual reports pasted together into parameter driven stored procedures to be used with Microsoft Reporting Services 2012/2008R2.
• Involved in configured the report viewing security for various users at various levels using Report Manager.
• Maintained Backup of the data, created Job failure alerts using SQL Server Agent and restore data from the backup on request.
• Extracted data using SSIS packages (ETL) from different server locations and data sources like Excel, CSV, flat file, and Text Format Data, and load data using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse databases.
• Improved performance of SQL Queries using SQL Execution Plan and SQL Profiler.
• Helped in planning out the coding and offered different solutions in initial planning of the project.

Environment: MS SQL Server 2012/2008 R2, SSIS, SSRS, SSAS, T-SQL, Pl/SQL, C#, Windows 2008 Server, Erwin.

Confidential, NewYork, NY

MS SQL/ Data Warehouse Developer

Responsibilities:

• Developed SSIS packages and used Aggregate, Conditional split, Multicast, Derived column, Lookup and Fuzzy Lookup transformations.
• Migrated data from different sources like Text files, Excel spreadsheets to SQL Server databases using SSIS.
• Involved in planning, defining and designing data and provided documentation.
• Created SSIS Packages for Data Migration and Transformation.
• Configured and deployed SSIS packages.
• Worked on various database maintenance tasks in SSIS.
• Used ETL to implement slowly changing Dimension to maintain historical data in Data Warehouse.
• Developed reports using complex queries and filters as per client requirements.
• Created various database objects such as Stored Procedures, Functions, Triggers, Tables, and Views using T-SQL queries to retrieve data from various tables.
• Wrote from simple to complex T-SQL queries in SQL Server Management Studio, for extraction of data from staging environment based on the requirement and pushed the required data to UAT environment.
• Created and designed SSAS Cubes for as per business requirements.
• Created and added aggregations, partitions, and different dimensions in existing Cubes.
• Used SSAS Cubes to create various types of reports in SSRS.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, index tuning wizard and SQL Query Analyzer in MS SQL Server 2008.
• Improved Performance of the queries by creating Clustered and Non Clustered Indexes and by optimizing the T-SQL statements using MS SQL profiler, Job Activity Monitor and Performance monitor.
• Involved in improving database performance using SQL Profiler, Trace Flags, Execution plan and Index Tuning Wizards.
• Designed and implemented stored procedures and triggers for automating tasks.

Environment: Microsoft SQL Server 2012/2008r2, Windows 2008, T-SQL, PL/SQL, SSIS 2012/2008, and SSRS 2008, SSAS 2008.

Confidential, Hopkins, MN

MS SQL/SSIS/SSRS Developer

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Created effective functions, appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Transformed complex business logic into Database design and maintaining it by usingSQLobjects like Stored Procedures, User Defined Functions, and Views.
• Successfully implemented indexes on tables for optimum performance using execution plan and index tuning wizard.
• Extensively used Joins and Sub-queries for complex queries involving multiple tables from different databases.
• Worked with script task in SSIS with C# and VB.Net programming language.
• Involved in creating calculated members, named set, advanced KPI’S for the SSAS Cubes.
• Created monthly, quarterly and semi annually reports using SSRS 2012 and also worked with Cognos reporters to create new reports using data used to create old Cognos Reports.
• Designed and Created report from OLAP Cubes.
• Analyzed OLAP processing for changing and maintaining the Warehouse, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Use various SSIS transformations such as Conditional Split, Derived Column etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Applied ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Created ETL packages with different data sources (SQLServer, Flat files, Excel source files) and loaded the data into target tables by performing different kinds of transformations using SSIS 2008r2.
• Created SSIS packages to extract data from OLTP to Data warehouse systems and scheduled Jobs to call the packages and Stored Procedures.
• Performed Documentation for all kind of SSIS packages.
• Developed logging for ETL load at the package level and task level to log number of records processed by each package and each task in a package using SSIS 2012/2008r2.
• Schedule and maintain Full, Differential, Transactional Log backup and restore the data using restore with recovery and restore with no recovery option.
• Worked on locking, blocking and dead lock issues.
• Involved in performance tuning of slow running queries
• Scheduling jobs and alerts using SQL Server Agent and configures database mail for any job failure.

Environment: MS SQL Server 2012, T-SQL, SSIS 2012/2008r2, SSRS 2012, SSAS 2008r2, Cognos, Visual Studio, VB.net, C#, Windows XP, MS Office 2007/2010, MS Access, Oracle 11g, PL/SQL

Confidential, NewYork, NY

MS SQL BI/SSIS Developer

Responsibilities:

• Developed SSIS packages and used Aggregate, Conditional split, Multicast, Derived column, Lookup and Fuzzy Lookup transformations.
• Migrated data from different sources like Text files, Excel spreadsheets to SQL Server databases using SSIS.
• Involved in planning, defining and designing data and provided documentation.
• Created SSIS Packages for Data Migration and Transformation.
• Configured and deployed SSIS packages.
• Worked on various database maintenance tasks in SSIS.
• Used ETL to implement slowly changing Dimension to maintain historical data in Data Warehouse.
• Developed reports using complex queries and filters as per client requirements.
• Created various database objects such as Stored Procedures, Functions, Triggers, Tables, and Views using T-SQL queries to retrieve data from various tables.
• Wrote from simple to complex T-SQL queries in SQL Server Management Studio, for extraction of data from staging environment based on the requirement and pushed the required data to UAT environment.
• Created and designed SSAS Cubes for as per business requirements.
• Created and added aggregations, partitions, and different dimensions in existing Cubes.
• Used SSAS Cubes to create various types of reports in SSRS.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, index tuning wizard and SQL Query Analyzer in MS SQL Server 2008.
• Improved Performance of the queries by creating Clustered and Non Clustered Indexes and by optimizing the T-SQL statements using MS SQL profiler, Job Activity Monitor and Performance monitor.
• Involved in improving database performance using SQL Profiler, Trace Flags, Execution plan and Index Tuning Wizards.
• Designed and implemented stored procedures and triggers for automating tasks.

Environment: Microsoft SQL Server 2012/2008r2, Windows 2008, T-SQL, PL/SQL, SSIS 2012/2008, and SSRS 2008, SSAS 2008.

Confidential, Pittsburgh, PA

Jr. SQL Developer

Responsibilities:

• Created Complex Stored Procedures, Triggers, and Functions, Indexes, Tables, Views, T-SQL code and SQL Joins for applications.
• Created SSIS packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers from the existing diversified data sources.
• Designed SSIS packages to transfer data from various sources like XML files, Excel, MS SQL Server 2005.Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse databases. Extracted data using SSIS packages (ETL) from different server locations and data sources like Excel, CSV, flat file, and Text Format Data, and load data using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Migrated packages from development server to production server using package configuration.
• Worked with application developers and production teams across functional units to identify business needs and discussed solution options.
• Generated periodic survey, marketing and sales reports based on the statistical analysis of the data from various time frame and divisions using SSRS.
• Scheduled and maintained Backups, defined user roles and maintained Log Shipping and Replication. Checking and maintaining SQL query performance using SQL Profiler.

Environment: Microsoft SQL Server 2005, SSIS 2005, SSRS 2005, SQL Profiler