Summary:

• Over 7+ years of IT experience as a SQL/BI Developer
• Strong experience in MS SQL Server suite of products like SSIS, SSAS and SSRS.
• Expert level knowledge in ETL - Data Extraction, Transformation, Loading with Oracle, Access and SQL Server using– DTS/SSIS. Experience in Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Developed ETLs using transformations like OLE DB, Derived Column, Data Conversion, and OLE DB command, slowly Changing Dimension (SCD), Union All, Script Task, Flat file, Conditional Split.
• Experience in using tools like Bulk Copy, Import and Export Wizard, Package Execution and SSMS (SQL Server Management Studio) and BIDS (Business Intelligent Development Studio).
• Migration of DTS packages to SSIS packages
• Using Checkpoints in packages to enable the package to run from the point of failure.
• Using Configurations to make dynamic changes to packages. Configurations like XML, SQL Server and Environment Variables have been used.
• Excellent knowledge of Software Development Life Cycle (SDLC), data modeling, and data warehousing (DW)
• Knowledge of Dimensional Data Model concepts, Dimension and Fact tables, Surrogate keys, Star and Snow Flake Schema, Physical and Logical Data modeling
• Strong T-SQL Programming experience with developing Stored Procedures, Views, Triggers, and Complex Queries on SQL Server 2008
• Experience in installation, configuration and maintenance of SQL Server 2008
• Advanced extensible reporting skills, developed SQL Server reports using SSRS 2008
• Used Subscriptions and Snapshots to set up Push based Report Delivery.
• Designed and created OLAP cubes defining the dimensions and relationship between dimensions and measure groups
• Experience in identifying and analyzing source data, data discovery and data cleansing according to the business requirements
• Ability to successfully collect, analyze, and formulate effective data and reporting design specifications based on end-user requirements
• A Team Player with excellent communication, analytical, verbal and writing skills. A quick learner, organized, resilient and self-motivated.

CertificationS:

• Microsoft SQL Server 2005 - Implementation and Maintenance
• Microsoft SQL Server 2005 Business Intelligence – Implementation and Maintenance
• Microsoft .NET Framework 2.0 Application Development Foundation (C#)

TECHNICAL SKILLS:

Languages\\
SQL, PL/SQL, HTML, XML, C, C++, \\
Visual Basic 6.0, Java, ASP, ASP.NET, \\
COBOL, MDX, DMX\\

Scripting Languages\\
Perl, Bash-UNIX- Shell scripting\\

Operating Systems\\
HP-Unix, LINUX, Windows XP/NT/2000\\

Reporting Tools\\
Crystal Reports\\ SSRS\\ Dundas Charts\\

Databases\\
SQL Server 2000/7.x, Oracle 11g, 10g, DB2, \\
MS Access\\ SQL Server 2005\\SQL Server 2008

Query Tools\\
Toad, SQL Query Analyzer\\

Data Warehousing\\
SQL Server Integration Services (SSIS)\\
Oracle Data Integrator (ODI)

Data Modeling\\
ERWIN4.0/3.5/3.x, Visio 2000\\

.Net Technologies\\
APS.NET, XML, HTML, WSDL, SOAP, \\
Web Services\\

Professional Experience:

Confidential,Danville, PA April 2011 – Till Date
SSIS/SSRS Developer

Project Description:
Confidential,a not-for-profit health maintenance organization (HMO), serves the health-care needs of members in 43 counties throughout central and northeastern Pennsylvania. The program name was called “CRMS REPLACEMENT “which supports PHYSICIAN PROFILIFING. The Healthcare Effectiveness Data and Information Set (HEDIS) is a tool utilized by health plans to annually measure performance on important dimensions of care and service, and is administered by the National Committee for Quality Assurance (NCQA). Physician Profiling provides a picture of how a provider\'s utilization management compares to their peers in the same specialty.
Build CRMS Data Store by pulling data from 14 different sources which mainly contains Member, Provider and Claims data which was use to source both HEDIS and PHYSICIAN PROFILIFING applications.

Responsibilities:

• Responsible to meet the information demands of our business users by delivering timely, accurate, meaningful and standardized data and reporting.
• Created a Data Model for the Operational Data Store to support HEDIS and PHYSICIAN PROFILING Using Erwin.
• Created a dynamic process for Auditing & Error handling the entire ETL process from source to target.
• Responsible for creating views out of business rules Specified for Data Profiling.
• Created Data Mapping template for storing the Technical requirement.
• Created a High Level Data Flow Diagram using Visio.
• Created several Staging Databases for each source and was involved in daily incremental loads and trouble shooting process issues.
• Create SSIS template package to standardize on logging, event handling and made the Package machine-independent using Configuration.
• Designed SSIS packages dealing with different data sources (Oracle, SQL Server, Flat Files and Excel Files) and loaded the data into target database by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Created SSIS package to get data from different sources, consolidate and merge into one single source.
• Developed SSIS Packages to Load data from Staging database into the ODS using different transformations: Derived Column, Sort, Aggregate, Merge Join, Union All, Multicast, Conditional Split, Lookup, Merge Join ,RowCount
• Used various Control Flow items such Different Containers, ExecuteSqlTask ,Execute Package Task ,Send Mail Task etc
• Made SSIS packages parameterized using Package Configuration.
• Created an SSIS package to run the Data Validation Scripts and generate an Email Report at the End of the ETL process.
• Created Summary reports based on the requirements: Tabular, Matrix, Parameterized and Drill down using SSRS.
• Scheduled the SSRS reports to refresh and run on daily, weekly and monthly basis in the report manager.
• Created Ad Hoc reports by building models in Report Builder using Model Designer and Report Builder.
• Created parameters (multivalve, hidden, default etc...) for the required fields using the report designer in order to see the dropdowns in the end report.
• Created documentation of ETL process and reports in order to support the system.
• Created a Coding Standards document for T-SQL, SSIS and SSRS.
• Managed index statistics, Tables, Views, cursors and optimizing queries by using execution plan for tuning the database.
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Developed Stored Procedures, Functions, Cursors and Triggers using SQL Server Management Studio.
• Used T-SQL Grouping Sets and CTE’s for write Effective Performance Queries.

Environment:
Microsoft SQL Server 2008 R2, SSIS ,SSRS , .NET Framework, C#, VB, ASP.NET, SQL Server Management Studio, Flat Files, Excel Sheets

Confidential,Victor, NY June 2009 – April 2011
SSIS / ODI (Oracle Data Integrator) Developer

Project Description:
Confidential,I was part of the Information Management initiative which focused on satisfying critical data and information needs of various business initiatives. The objectives in the Stage 1 thread is to provide the initial process to obtain and normalize a set of master and transactional data from the external data sources .The process will consist of pulling the external data into a SQL Server 2005 Staging area where the data will be transformed and cleansed then moved to a Global Organization Data Storage and then delivering the data from Global Organization Data Storage to the shared drive using SSIS packages and store procedures.
The Staging database were used for discovering the structure and data capabilities, abnormalities and provide the opportunity to begin addressing any key points or issues as related to future stage work within the FUSION project . A part from building the Global Organization Data Storage we supported JD Edwards(JDE) , End2End and Global Spend Intelligence by implementing data management solutions to meet their needs.

SSIS Responsibilities:

• Design and Develop a SSIS template that would serve as the standard template which all other SSIS developers would use.
• Designed ETL packages dealing with different regions (US, new Zealand and Canada ) and loaded the data from the staging databases into target data sources by performing different kinds of transformations (For loop Execute SQL Task, Union All, Merge Join, Lookup, OLE Db Command as well as Slowly Changing Dimension etc) using SQL Server Integration Services (SSIS).
• Designed, and implemented SQL Server database objects (stored procedures, functions, views, complex T-SQL/queries) to support data integration (SSIS), analysis, and various business processes.
• Created mappings/workflows to extract data from JDE into SQL Server and then extracting the data from SQL Server into Flat Files in Multiple folders to support the E2E Application.
• Analyze existing source system data structures and map them to data warehouse schemas; incorporate future data sources into schemas.
• Create ETL logic to load data in the Global Organization Data Storage.
• Analyze data integration problems, provide solutions and recommend and execute corrective actions.
• Experience with full life-cycle from large data set migration to Data Warehouse loading production, data analysis, and cleaning, scrubbing, manipulation, data extraction for reporting and data management.
• Involved in job scheduling and performance optimization /normalization
• Experience in business process and data with hands-on technical skills in complex data warehouse and database design, structure, relational, data/system analysis, and complex coding/queries.
• Taking care of day-to-day related issues; importing/loading huge amount of data, user related, performance tuning.
• Worked on designing the target database in the data warehouse environment.
• Optimize data warehouse to support business users and Business Intelligence (BI) applications such as Cognos and other analytics tools.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views.
• Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.

ODI Responsibilities:
Constellation Brands Enterprise Data Warehouse Integration

• Used ODI Designer for importing tables from database, reverse engineering, to develop projects, and release scenarios.
• Developed various transformations for load the data from source to target using the Oracle Data Integrator (ODI).
• ODI Graphical Modules (Designer, Topology Manager, Operator, Security Manager)
• Involved in maintaining and creating new data servers, connections for different data sources through the Topology manager.
• Created data servers for sources that included SQL Server, DB2 and Flat File sources.
• Validated the logical and physical architecture in ODI topology and context models.
• Responsible for creating, modification, performance tuning and debugging of ODI Objects.
• Defined data stores, interfaces and packages in ODI Designer.
• Created Custom Knowledge Modules for loading the data from SQL Server for performance.
• Created Looping logic in the packages to create Multiple Flat File.
• Created Error Handling wrapper to run any ODI Scenarios for success and failure
• Responsible for viewing and managing production integration jobs using ODI Operator.
• Used ODI Security Manager for adding users and maintaining and restricting their privileges depending on the role of a team member.
• Monitor ETL ODI Jobs and provided On-Call support in Trouble shooting and debugging.

Environment:
SQL Server 2005/2008 , Windows 2003, Windows XP, SQL Server Management Studio, Flat Files, Excel Files, Oracle 11g, Oracle Data Integrator

Confidential,Lexington, KY Dec 2008 – June 2009
SSRS / SSIS Developer

Project Description:
Involved in creating a SSIS template that would serve as the standard on which other SSIS packages would be developed. The SSIS template would log the events taking place as well as keep track and inform in case of error.

The SSIS template was used to create the Data Warehouse package for Lexmark. The Data Warehouse package would load the data into Lexmark Data Warehouse which is then analyzed using Analysis Services and Reports generated through Reporting Services.

Also had the opportunity of migrating SQL Server 2000 DTS packages to SSIS Packages and implementing the Pricing Data Mart.

Responsibilities:

• Design and Develop a SSIS template that would serve as the standard template which all other SSIS developers would use.
• Develop SSIS packages to load the Lexmark Data Warehouse.
• Develop ETL Design and Package to Load the Lexmark Pricing Data Mart
• Variety of transformations like Execute SQL Task, Union All, Merge Join, Lookup, OLE Db Command as well as Slowly Changing Dimension, Pivot and Unpivot was used.
• Using Checkpoints in packages to enable the package to run from the point of failure.
• Creating package dependencies by calling Child packages within Parent.
• Using Configurations to make dynamic changes to packages. Configurations like XML, SQL Server and Environment Variables have been used.
• Using the Default logging as well as Custom Log to keep track of the package.
• Passing variables from Parent to child and vice versa using Standard SSIS procedure as well as using scripts.
• Migrating SQL Server 2000 DTS packages to SSIS Packages.
• Modifying existing packages to add new logic as well as increase performance
• Writing .Net scripts to perform complex logic.
• Testing and Migrating packages between environments
• Used various report controls like Tables, Matrix, List, Chart and Image to create reports with drill down, document map, dropdown menus and linked reports using SSRS.
• Used Subscriptions to set up Push based Report.

Environment:
SQL Server 2005 SQL Server SSIS, SSRS, Windows 2003, Windows XP, SQL Server Management Studio, Flat Files, Excel Sheets

Confidential,Broomfield, CO June 2008 - Nov 2008
SSIS ETL Developer/SSRS

Project Description:
Confidential,is a leading provider of strategic, ROI-focused email communications solutions and marketing automation technologies. Through its combination of innovative technologies, professional services and vertical market expertise, Epsilon Interactive helps marketers acquire, grow and retain profitable customer relationships through highly relevant and personalized email communications and to produce email programs that generate measurable results throughout the customer lifecycle.

Gap is the name of the project I worked for. GAP is one of the world\'s largest specialty retailers, with more than 3,000 retail stores. They now have launched a new Online Shoe Shop called PIPERLIME. The goal of the project GAP was to create a data warehouse in SQL Server 2005 which would enable Epsilon Interactive to keep track of email communications as well as create metrics which would be used for reporting purposes. They operate four of the most recognized apparel brands in the world — Gap, banana republic, Old Navy and Forth & Towne.

Responsibilities:

• Design and development of Packages and Data flows in SQL Server Integration Services.
• Complex business requirements were transformed into ETL’s using a variety of transformations like Aggregate, Derived Column, Data Conversion, And Union All; Merge Join, Lookup, OLE Db Command as well as Slowly Changing Dimension and Pivot.
• Developing Batch scripts that were integrated in the SSIS packages to add headers to flat files as well as renaming flat files with date and time stamp.
• Automation of packages using SQL Server Jobs and creating tables to keep track of Audit.
• Migrated packages from the File System to MSDB across different environments.
• Using Checkpoints in packages to enable the package to run from the point of failure.
• Using XML Configurations to make dynamic changes to packages.
• Used Log Providers to keep track of the Log History.
• Performed tuning on packages to avoid bottlenecks and improve performance.
• Involved in monitoring jobs, testing, modifying and making enhancements to existing packages.
• Development of Standard Reusable Packages to perform certain tasks like Zipping, Unzipping, Encrypting and Decrypting files.
• Involved in creating technical documents like Source-to-Target mappings as well as transformation logic.
• Created reports that have features like drill down, document map and linked reports using SSRS.
• Used a variety of controls like Tables, Matrix, List, Chart and Image.
• Created reports that are based on data selected from dropdown menus.
• Used Subscriptions to set up Push based Report.
• Set up both Push and Pull Based Report Delivery.

Environment:
SQL Server 2005 - SQL Server SSIS, Windows 2003, Windows XP, SQL Server Management Studio, Flat Files, Batch files, Visio 2003

Confidential,Radnor, PA Sep 2007 – May 2008
SSIS/SSAS/SSRS

Project Description:
Confidential,has grown to become the leading provider of health insurance for international students at U.S universities and an innovator in online healthcare information, medical assistance and insurance services for leisure and business travelers around the globe.
S6_MIS is the name of the project I worked for. System6 is a database developed by HTH World Wide Insurance in Oracle for storing customer and his/her insurance related information. MIS is a database that I developed using SSIS for storing the same information in SQL Server tables. MIS is the project developed to replace System6 that can be used by all the branches of HTH World Wide Insurance.
Responsibilities:

• Developed and designed SSIS packages using SQL Server Integration Services for loading data into Oracle tables and SQL Server tables.
• Developed packages for calling multiple Oracle stored procedures in different Sequence Containers in parallel to improve performance and load data into respective Oracle tables.
• Transformed Oracle stored procedures into a package with Data flows, For Each Loop, Sequence Containers, Execute SQL Tasks and Bulk Insert Tasks.
• Converted Oracle stored procedures to SQL Server stored procedures for loading data into dimension and fact tables.
• Developed scripts using Script task transformation for creating files, assigning values to variables and extracting row counts from text files.
• Used Package Configurations to pass parent package variable values to child package variables.
• Developed ETL’s using transformations like OLE DB Source, OLE DB Destination, Derived Column, Data Conversion, OLE DB command, Slowly Changing Dimension, Union All, Script Task, Flat file Source, Flat file Destination, Conditional Split.
• Created SQL tables for storing Rejected rows.
• Developed Event Handlers for executing Stored Procedures and storing the rows Inserted, rows Selected, rows Rejected, rows Updated and rows Unchanged in appropriate SQL Tables.
• Used Stored Procedures and Log Providers to keep track of Log History.
• Designed, administrated and developed Star Schema Data marts
• Designed and created OLAP cubes defining the dimensions and relationship between dimensions and measure groups
• Worked on Data Mining Models using Different Algorithms and queried the output data using DMX.
• Created reports in Excel, SSRS using the OLAP Cubes.
• Used Excel 2007 pivot table to leverage SQL Cube analysis function.
• Used Rich server controls of ASP.NET like Data Grid and Data List controls.
• Responsible for connectivity of database using ADO.NET and used Stored Procedure, parameterized queries & Datasets.
• Used the Single Report viewer control for embedding multiple Reports

Environment:
SQL Server 2005 - SQL Server SSIS, Windows XP, SQL Server Management Studio, Flat Files, DB2 Control Center, Visual SourceSafe 6.0

Confidential,Hyderabad, India Aug 2006 – June 2007
SQL Server Developer /SSIS/SSAS

Project Description:
The project involved extracting data from heterogeneous data sources, transforming the data and then loading the data into the target Data Mart for Warehouse operations. This central location of data will make it easier to acquire tool(s) to create and manage common reports so that each group can benefit from or leverage work done by other groups and packages that will help extract data from decommissioned systems (SOM and One Form) and load them into the Data Warehouse for consolidation and building reports

Responsibilities:

• Develop SSIS packages to load the Data Warehouse from SOM and One Form Databases.
• Created SSIS packages using a number of transformations including Execute SQL Task, Union All, Merge Join, Lookup, OLE Db Command as well as Slowly Changing Dimension, Pivot and Unpivot Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions
• Installed and Configured SQL Server 2005.
• Involved in Import/Exporting of Data to/from SQL database.
• Migration of Packages between various environments and loading the packages in Integration Services (MSDB).
• Automation of packages using SQL Server Jobs.
• Monitoring jobs through Log providers and creating tables to keep track of Audit.
• Tested and maintained ETL and integration for SQL-based applications supporting dimensional data modeling
• Designed, administrated and developed Star Schema Data marts
• Used SSIS as ETL tool to capture, load and new customer data to OLAP servers and responsible for scheduling of jobs to load historical business data into OLAP Reporting Databases
• Designed and created OLAP cubes defining the dimensions and relationship between dimensions and measure groups
• Advanced extensible reporting skills developing SQL Server reports using SSRS 2005
• Created reports that are based on data selected from dropdown menus.
• Used a variety of controls like Tables, Matrix, List, Chart and Image for Reports
• Developed Master Pages, Web User Controls, and Custom Controls.
• Used Rich server controls of ASP.NET like, Data Grid and Data List controls.
• Responsible for connectivity of database using ADO.NET and used Stored Procedure, parameterized queries & Datasets.
• Used XML, XSLT, and XPATH for parsing the response

Environment:
MS SQL Server 2005/2000, Windows 2003 Advanced Server, OLAP, MS Visio 2003, SSAS, SSRS, SSIS, IIS 6.0

Confidential,Bangalore, India Nov 2005 – July 2006
SQL Server Developer/SSRS

Project Description:
Confidential, is the world’s leading producer of CDMA/GSM handsets, air conditioners, front-loading washing machine, optical storage products, DVD players, flat panel TV’s and home theater systems. A large amount of customer-related data from diverse sources was consolidated, including customer billing, ordering, support and service usage. Involved in ETL (Extraction, Transformation and Loading) and Business Intelligence processes and creating Reports based on the requirements.

Responsibilities:

• Designed databases for different projects and resolved database issues.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Implemented the SQL login security for developers and users
• Running DBCC consistency checks, and fixing data corruption in user databases.
• Worked on DTS packages to import the data from Oracle, Access & text files.
• Setting up backups for the newly created databases.
• Responsible for change managements, created the documentation for SQL server and service packs installations.
• Automation of packages using SQL Server Jobs.
• Advanced extensible reporting skills developing SQL Server reports using SSRS 2005
• Created reports that are based on data selected from dropdown menus.
• Used a variety of controls like Tables, Matrix, List, Chart and Image for Reports
• Installation of Microsoft SQL Server 2000/2005, Service packs,
• Designed application forms and client side validation in ASP.NET using JavaScript.

Environment:
Microsoft SQL Server 2005, Windows 2000 Advance Server /2003 Server, SSIS, SSRS, T-SQL

Confidential,Bangalore, India Oct 2004 – Sep 2005
SQL Server Developer

Responsibilities:

• Involved in developing E-R diagrams, logical & physical data modeling, development and implementation of the system.
• Created tables, Stored Procedures, Trigger, views, indexes and user defined functions.
• Actively designed the database to fasten certain daily jobs and some stored procedure.
• Optimized query performance by creating indexes.
• Involved in performance tuning of TSQL queries and Stored Procedures.
• Loaded the data from multiple systems to the Reporting Data warehouse database.
• Created DTS Packages and T-SQL Stored Procedures for the ETL Process.
• Developed distributed transactions to access databases using .NET
• Prepared and maintained performance reports, production and analysis of month end statistics.
• Created web pages, deploying it and implementing it with the database for online transactions.
• Worked with XML files validation and verification.

Environment:
MS SQL Server 2000, Windows 2000 Server Edition, Reports in Microsoft Excel, Visual Basic 6, VB Script, C#.NET, ASP.NET, MS Visio, UML, XML, XMLSPY

Confidential,Hyderabad, India April 2004 – Sep 2004
MS SQL Developer

Responsibilities:

• Created tables, Stored Procedures, Trigger, views, indexes and user defined functions.
• Create joins and sub-queries for complex queries involving multiple tables.
• Developed Views and complex stored procedures to create various reports.
• Worked on DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server
• Wrote PL/SQL stored procedures using Toad.
• Filtered bad data from legacy system using complex T-SQL statements, and implemented various constraint and triggers for data consistency.
• Responsible for developing report templates using ASP.NET user controls
• Developed C# modules for implementing business logic.

Environment:
MS SQL Server 2000, Win 2000, Win 2003, C#, ASP.NET 1.0, IIS 5.0, Oracle 9i

EDUCATION:

• Masters in Software Engineering