SUMMARY:

• Over 11 years of Extensive experience in the Architecture, Design, Development, Implementation and Support of complex Data engineering solutions for building Confidential and Business Intelligence needs.
• Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Architecture, Analysis, Design, Development and Implementation.
• Hands on experience in Logical and Physical Database design & development, ORDBMS Concepts, Normalization and Data modeling using Erwin data model in relational databases such as SQL Server 2005/2008/2012.
• Extensive experience in leading Business Intelligence/ ETL implementations using MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), and MS SQL Server Analysis Services (SSAS).
• Proficient in using T - SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Relational Database Models and Data Integrity, SQL joins and Query Writing in SQL Server 2005/ 2008/2012.
• Expert in Design and optimization of OLTP, OLAP tools and OLAP Cubes.
• Led design, development, implementation of reports, and also development and management of the BI reporting environment.
• Involved in ongoing support, design, and development of healthcare based data warehouse, Confidential and online OLAP analytical applications.
• Have extensive experience in building BI Products and Solution frameworks through Meta Data driven approaches.
• Hands on experience on writing T-SQL Procedures, Functions, Views and Indexes.
• Hands on experience in writing MDX queries to work with cube data.
• Defined the custom data reader to read the data from flat files (Character data sets, delimited files, fixed text length) into Data Profiler and Data Cleanser.
• Strong Expertise in importing the Legacy Data Structures into Relational Data Structures and data mapping in the Relational database.
• Experienced in Developing, Deploying, Scheduling and Monitoring SQL workflows/sessions for ETL Purposes.
• Strong experience in handling Master Data (MDM), strong focus on the customer data.
• Very good Project management experience encompassing very aspects required for building Data & Information systems such as - Requirements gathering & Analysis, Stakeholder Analysis, Feasibility study, Effort and Cost Estimations, Project Planning, Risk
• Server/Database Migration or Upgrades - Migration of SQL 2000 databases to SQL 2005.
• Performance tuning of DTS/SSIS packages.
• Performance Tuning - Memory, CPU, I/O, Application, Hardware configuration (Different RAID levels) etc.
• Troubleshooting the long running queries and stored procedures to increase the performance by adding the index or by changing the query logic on need basis.
• Experienced in creating and scheduling of Markit EDM ETL tool.
• Created SSIS jobs, which run on daily, weekly and monthly basis to update fields in reporting files.
• Identified and made recommendations for the appropriated data sources for the best solution to extract the data for the project being worked on.
• Proficient in handling parameterized reports in SSRS 2008R2.
• Experience in integrating the SSRS reports into web applications using Report viewer control.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Experience with optimizing cube using partitions and aggregations.
• Worked in Data modeling, creating star and snowflake schemas in SSAS. Also used tools like Erwin.
• Experience in Excel pivot services.
• Worked on SQL BI solution integration with Microsoft share point server.
• Exposure to source safe, version controlling etc
• Played the role of Team Lead and On-Site coordinator and managed offshore associates.
• Experienced in creating build environment setup using TeamCity to deploy Web and batch applications.
• Proven organizational, time management and multi-tasking skills and ability to work independently while being a good team player who enjoys delivering high quality work
• Experience on leading, mentoring teams and strictly adhering to SDLC/Agile processes.

TECHNICAL SKILLS:

Operating System: MS Windows 2000/XP/7, MS Windows Server 2003/2008/2012, UNIX, Linux

Languages: SQL, PL/SQL, T-SQL, C#, Visual Basic, C, C++

Database: Microsoft, Oracle

Application Servers: Microsoft SQL Server 2000/2005/2008

Tools: SQL Server Integration Sevice (SSIS), Markit EDM, SQL Server Reporting Service,(SSRS), SQL Server Analytic Service (SSAS), DTS 2000

Scheduling Tools: Windows Scheduler, MS SQL Agent

Data Modeling Tools: Ms Visio, Erwin, Toad Data Modeler and SQL Developer Data Modeler.

Management: Bugzilla, Ms Visual Source Safe, Tortoise SVN, TFS, Clear Case, and Clear Quest Internet Tools: IIS, FTP, TCP/IP, SFTP, WinSCP

Testing Tools: Win Runner, Test Director

PROFESSIONAL EXPERIENCE:

Confidential,NJ

MSBI Data Analyst / Team Lead

• Involved in modifying the SSIS packages and optimising the package to fetch better performance and results.
• Responsible for modifying the SSIS package based on the new requirement of customer.
• Responsible for creating the package configuration and loggings for better handling.
• SSIS- re-write the package to reduce the redundant SSIS package doing same task.
• Reduced the manual effort by the run team on a daily basis.
• Prepared a complete flow of the application, suggested and successfully implemented the changes
• Scheduling the application and other automation for sending reports and emails.
• Performance tuning of DTS/SSIS packages.
• Performance Tuning - Memory, CPU, I/O, Application, Hardware configuration (Different RAID levels) etc.
• Troubleshooting the long running queries and stored procedures to increase the performance by adding the index or by changing the query logic on need basis.
• Analyzing the executing plan of SQL Server queries or stored procedures.
• Development and testing of new packages to ensure the data were extracted from database and presented for the project requirements and data validation.
• Created SSIS jobs, which run on daily, weekly and monthly basis to update fields in reporting files.
• Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Experience with optimizing cube using partitions and aggregations.
• Worked in Data modeling, creating star and snowflake schemas in SSAS. Also used tools like Erwin.
• Developed User Interactive Sheets & Reports as per business needs in SSRS.
• Developed complex Stored Procedures to generate various Drill-through reports, parameterized reports, Cascading Parameterized reports, sub-reports and linked reports using SSRS 2008 and integrated into the front end.
• Integrated the SSRS reports into web applications using Report viewer control.
• Develop and support SSRS reports on MOSS 2010.

Environment: Microsoft SQL Server 2008, SQL Server Integration Services (SSIS), SSRS 2008, Erwin, MOSS 2010

Confidential,CT

BI Data Analyst / Team Lead

Responsibilities:

• Worked in all aspects of SDLC such as requirement analysis, design, development, testing, implementation, deployment & maintenance.
• Involved in modifying the SSIS components based on requirement.
• CADIS/SSIS Package creation, management and scheduling SSIS package and Cadis package.
• Responsible for creating the best practices to be followed in Logging and Configuring the SSIS package.
• Performance tuning of existing stored procedures.
• Used TeamCity tool for building various solutions developed.
• Creating and scheduling of MARKIT EDM ETL package.
• Create Data Porter, Data Inspector, Data Matcher and Data Constructor for Back office data management.
• Played the role of Team Lead and On-Site coordinator and managed offshore associates.
• Helped team to create, modify and optimize SQL queries and stored procedures.
• Prepared the High and Low Level Process Flow design for ETL process using MS Visio.
• Review of T-SQLs, SQL Server Execution Plans and SSIS Optimizations
• Guided the Development teams on using SSIS Components - Data Flow tasks, FTP, Merge, SCD, Script components etc.
• Involved in writing T-SQL queries, Stored Procedures and designing SQL Server Integration Packages.
• Designed Metadata Strategy, Data lineage, Data Quality and Profiling.
• Developed the strategies and alternatives for the Data issue resolution and the software required to perform Data Analysis Services.
• Configured Sql Server Reporting Services in SharePoint Server mode as well as Native mode
• Created different kinds of reports using SSRS (2005/2008) like Tabular, Matrix, Chart, Parameterized Reports, Subreports and DrillDown Reports.
• Configured Sql Server Reporting Services in SharePoint Server mode as well as Native mode.
• Created Report Models and Adhoc Reporting using Report Builder 2.0
• Involved in training the end users in creating reports using Report Builder 2.0.
• Managed and Scheduled the SSRS Reports.
• Involved in Project Management activities reporting Risks and Mitigations, and Daily, Weekly & Bi-Weekly Status Reporting to respective Stakeholders

Environment: TSQL, Microsoft SQL Server 2005/2008, SQL Server Integration Services (SSIS), MARKIT EDM, SQL Server Reporting Service (SSRS), MS Visio, SharePoint

Confidential,SFO,CA

Sr. SQL Developer

Responsibilities:

• Gathered and Analysed the requirements and prepared Use cases, User Interface document, Traceability SRS and Site map.
• Scheduled daily scheduled SSIS package for transformation and storing of data.
• Asp Dot Net creation of web pages based on roles and setting the privileges to the users across the module.
• SSIS Package creation, management and scheduling SSIS package.
• Responsible for creating the best practices to be followed in Logging and Configuring the SSIS package.
• Performance tuning of SSIS packages.
• Performance Tuning - Memory, CPU, I/O, Application, Hardware configuration (Different RAID levels) etc.
• Troubleshooting the long running queries and stored procedures to increase the performance by adding the index or by changing the query logic on need basis.
• Expertise in analyzing the executing plan of SQL Server queries and stored procedures.
• Experience in integrating the SSRS reports into web applications using Report viewer control.
• Experienced in creating build environment setup using TeamCity to deploy Web and batch applications.
• Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Experience with optimizing cube using partitions and aggregations.
• Worked in Data modeling, creating star and snowflake schemas in SSAS. Also used tools like Erwin.

Environment: Microsoft SQL Server 2008, ASP.NET, SQL Server Integration Services (SSIS), SQL Server Reporting Service (SSRS), SQL server Analytic Service, C# .Net

Confidential,Louisville,KY

SQL Developer / Module Lead

Responsibilities:

• Developed SSIS packages in 2008 servers.
• Implemented so many SQL Server jobs to environment to manage the servers.
• Responsible for all the activities running behind servers.
• Developed stored procedures and user defined functions.
• Managed so many database designs to the applications.
• Managed all servers in the environment to provide the production support.
• Involved in DTS/SSIS Package creation, management, scheduling and migration to DTS/SSIS packages across instance, and from SQL 2000 to Legacy DTS (SQL 2005) and SSIS in SQL 2005.
• Worked on troubleshooting DTS/SSIS package and Performance tuning of DTS/SSIS packages.
• Involved in Performance Tuning - Memory, CPU, I/O, Application, Hardware configuration (Different RAID levels) etc.
• Worked in Troubleshooting the long running queries and stored procedures to increase the performance by adding the index
• Changed the query logic on need basis.
• Analysed and executed the plan of SQL Server queries and stored procedures.
• Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Experience with optimizing cube using partitions and aggregations.
• Worked in Data modeling, creating star and snowflake schemas in SSAS. Also used tools like Erwin.
• Helped team to create, modify and optimize SQL queries and stored procedure.
• Proficient in handling parameterized reports in SSRS 2008.
• Experience in integrating the SSRS reports into web applications using Report viewer control.

Environment: Microsoft SQL Server 2008, SQL Server Integration Services (SSIS), DTS, SQL Server Reporting Service (SSRS)

Confidential

SQL Developer / Module Lead

• Designed databases, migrated all the databases from 2000 to 2005 servers.
• Implemented so many SQL Server jobs to environment to manage the servers.
• Responsible for all the activities running behind servers.
• Used the latest technology to migrate the database from 2000 to 2005.
• Developed so many stored procedures and user defined functions.
• Managed so many database designs to the applications.
• Managed all servers in the environment to provide the production support.
• Involved in Server/Database Migration and Upgrades
• Migration of SQL 2000 databases to SQL 2005. Migrating databases from homogeneous to heterogeneous environment or heterogeneous to homogeneous
• Upgraded mission critical application databases from SQL Server 2000 to 2005.
• Worked on DTS/SSIS Package creation, management, scheduling and migration to DTS/SSIS packages across instance, and from SQL 2000 to Legacy DTS (SQL 2005) and SSIS in SQL 2005.
• Worked on troubleshooting DTS/SSIS package and Performance tuning of DTS/SSIS packages.
• Tuned the Performance by Troubleshooting the long running queries and stored procedures to increase the performance by adding the index
• Changed the query logic on need basis.
• Analysed the executing plan of SQL Server queries and stored procedures.
• Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Experience with optimizing cube using partitions and aggregations.
• Worked in Data modeling, creating star and snowflake schemas in SSAS. Also used tools like Erwin.

Environment: Microsoft SQL Server 2000&2005, SQL Server Integration Services (SSIS), DTS, SQL Server Analytic Server (SSAS), Erwin

Confidential

SQL Developer

• Involved in gathering requirements from business users.
• Involved in transformation of data from various sources and legacy systems like Teradata, SQL Server 2000 and Excel into SQL Server 2000 using DTS.
• Created triggers that capture the claims and wrote complex formulas that calculate the amounts related to those particular claims.
• Created number of complex formulas to calculate the amounts related to different claims in sub reports using different types of variables like shared variable and retrieved them from master report
• Created complex stored procedures to fetch and manipulate data in the databases.
• Created Tables, Stored Procedures, Views, Constraints and User Defined Functions.
• Wrote and Optimized Triggers, Stored Procedures and Queries in T-SQL.
• Managed SQL user logins, database user accounts, server roles, database roles and its permissions.
• Customized reports by adding new features such as report alerts, cross-tabs, running total, sub-reports and drill-down fields.
• Modified report content and exported reports in multiple formats based on user input.
• Designed/modified database schema objects to support existing and new business related application development for a global-application. Write/test SQL scripts to perform application specific data manipulation

Environment: MS SQL Server 2000, T-SQL, DTS, Teradata, Excel.