Summary of Experience and Qualifications

• Currently working as a Data Conversion/SSIS/ETL Lead Developer at Deloitte Consulting LLP for the Commonwealth of Pennsylvania.
• 4 years of experience in the IT industry in Public Sector,State & Local Govt. and Education,Banking,Manufacturing Domains. Experience includes design, development and testing as an ETL developer in SQL Server 2005/2008/2008R2 and trainee in SQL Server DBA,SQL Server 2005/2008 BI Suite,Microsoft .Net,Oracle ERP,testing tools(Load Runner,WinRunner,Quality Center,and RFT) and Oracle DBA technologies.
• Involved in the entire conversion lifecycle stages of Requirement Analysis, Data Profiling, Logical and Physical Data Mapping, Strategy, design,development,Unit testing, conducting conversion mock runs,SIT,UAT,Data Reconciliation and validation.
• Proficient in Transact SQL development, SQL Server Integration Services (SSIS).
• Proficient in scripting T-SQL queries, Ranking functions,Derived tables, common table expressions (CTEs),stored procedures, views, user defined functions (UDF), constraints & Database triggers.
• Proficient in the use of majority of the SSIS transformations,Containers,Tasks,migration of data from various source DB' s like Sybase,Access,Excel,Flat File to SQL Server 2005/2008,package configurations,logging,checkpoints,master and child packages,packagedeployment,variables and expressions,error handling and troubleshooting.
• Experience in Installation, Configuration of SQL Server/BI Suite (2005/2008), Creation and Management of Logins, Users, Schemas and Permissions, Automation of SSIS package execution using Sql Server Agent Jobs ,Database Backups and Restoration.
• Hands on experience in designing complex reports using SQL Server Reporting Services (SSRS) based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix reports, Drilldown reports, Drill through Reports,Adhoc Reports, Parameterized reports, Sub reports and filters, charts in SSRS 2005/2008.
• Good knowledge of Normalization, Collations, Data Modelling like Star Schema Modelling, Snow-Flake Modelling, FACT and Dimensions Tables using Analysis Services.
• Excellent hands on experience in developing Windows applications, Web applications using ASP.NET, C#.NET and ADO.NET.
• Exceptional academic record. Achieved 3.89/4.0 GPA and Dean's List for 2 of 2 semesters.
• Self-starter, hardworking, and a consistent performer with the ability to work both as a team player and as an individual.
• Strong analytical knowledge coupled with excellent communication and interpersonal skills.
• Proficient in developing clear and concise documentation of all work performed.

EDUCATION

Master of Science in Management Information systems
Bachelor of Engineering in Information Technology

TECHNICAL SKILLS

Certifications:

• Microsoft Certified Professional in .NET Framework 2.0- Web based Client Development.
• Oracle Certified Associate administrator (10g)
• Oracle Certified PL/SQL Associate Developer
• Oracle 11i Install, patch and maintain Oracle applications

Database: MS SQL Server 2005/2008R2,MS SQL Server Integration Services (SSIS 2005/2008R2)(SSIS),T-SQL ,MS SQL Server Reporting Services 2005/2008, ,Analysis Services (SSAS 2008), Oracle 9i/10g/11g-PL/SQL,Reports, XMLPublisherReports,Oracle Applications E-business suiteR12,Sybase ASE 15.5
Software Applications:Microsoft Visual Studio, BIDS, TFS, Clear Case,Oracle SQL Developer,Microsoft Visual Source Safe, HP Project Portfolio Management, HP Quality Centre, Eclipse,MS Office, Microsoft SQL Server Management Studio,TechnoSolutions Top Team.
Programming Languages: C#, VB.Net, core Java, C, C++
Web Technologies: HTML, CSS, XML, ASP.NET (2.0), AJAX, Cold Fusion (Basics)
Modelling&Reporting: Erwin,UML, Microsoft Visio, R2M Case tool
Operating Systems:WINDOWS, UNIX, Linux
Testing Tools: Winrunner, Load Runner, Quality Center, QTP

PROFESSIONAL EXPERIENCE

Role: Conversion Specialist/ETL Lead Developer April 2011 to till date
Deloitte Consulting LLP Camp Hill, PA
Client: Confidential

Project Description: Integrating the Department of Labor and Industry (L&I)' s legacy Workers Compensation Claims, Adjudication and Appeals applications into a custom-built integrated solution (called Workers' Compensation Automation and Integration System -WCAIS). A multi-year data migration project to bring the legacy data into a Microsoft SQL Server based solution.

Technical Environment: SSIS 2008,BIDS,SQL Server 2008 R2, T-SQL,Visual Basic .NET, C# .NET, XML, TechnoSoultionsTop Team, Microsoft TFS, Microsoft Project, Sybase ASE 15.x, Microsoft Access, SSRS,MicrosoftExcel,QAS

Role Description:

• Loaded legacy source data from Sybase, Access, and Sql Server DB' s into SQL Server 2008 R2 staging DB' s using SSIS Import & Export Wizard, Sql Server Migration Assistant (SSMA) and SSIS packages.
• Performed data profiling, data analysis to identify legacy data that needs to cleansed prior to the migrations using SSIS Data Profiling Task, Data Profile viewer and T-SQL queries.
• Worked with L & I Subject Matter Experts, and Deloitte Database Architects to create data mappings. Performed GAP Analysis on data mappings, and data element transformations.
• Used majority of the transformations, tasks, containers present in SSIS which include Fuzzy grouping,Derived Column, Conditional Split, Aggregate, Lookup, Row Count, Merge Join, Union All,Multicast,Sort,Copycolumn,Data conversion and other transformations during development.
• Used Fuzzy grouping transformation to consolidate data and submitted data cleansing reports to the client.
• Created custom Logging and Auditing framework incorporated in an SSIS package template that was used in the project' s ETL packages.
• Identifying, and documenting ETL Standards and best practices for the development team.
• Participate in creating data conversion and migration strategy, conversion design and conversion development documents. Participate in Data Modeling Sessions.
• Hosted SSIS knowledge transfer, data quality issue meetings with the client on a weekly/biweekly basis.
• Wrote T-SQL queries to validate the error reports being given to the client and prepared T-SQL scripts for the Application team,Reports team during development. T-SQL development included queries using joins,subqueries,Rankingfunctions,Derived tables, common table expressions (CTEs),stored procedures, views, user defined functions (UDF), constraints & Database triggers.
• Improved the performance of SSIS packages by enabling Parallelism in the Control and Data Flows, usage of synchronous transformations.
• Used dynamic connection managers using SSIS expressions to load data from 25 databases into a single DB.
• Deployment of SSIS packages to the conversion server and create and schedule SQL Server Agent jobs to automate the run of SSIS packages on a weekly basis.
• Experience in creating master and child packages,using package configurations (XML,SQL Server)and SSIS logging.
• Experience in usage of variables and expressions in packages, writing VB scripts in script component task.
• Conduct Code Walkthroughs, and perform SSIS peer reviews.
• Performed SQL Server DBA tasks like Conversion DB backups using compression, restore and disk space management on the conversion server, disabling and enabling constraints and triggers, applying DB Change requests, lookup data changes incorporation,logins& permissions. Created linked servers to write validation queries against the source and target present on different servers.
• Used Team Foundation Server 2010 to check in code artifacts and Techno solutions Top Team third party tool for process oriented tasks like assigning tasks, logging & assigning code defects, check in key decisions, documents etc.
• Created database staging tables for running the QAS batch for Postal Address Validation.
• Implemented framework for Reference/Lookup data changes,Automation of Applying Database Change Request scripts to the target DB.
• Developed data reconciliation SQL queries to validate the overall data migration. Prepared data reconciliation reports for conversion team/business. Maintained ETL functional specifications, test plans and data for data conversions.Automated the data reconciliation process to minimize the developer involvement in validating production migrations.
• Involved in the entire conversion lifecycle stages of Requirement Analysis, Data Profiling, Logical and Physical Data Mapping, Strategy, design,development,Unit testing, conducting conversion mock runs to provide data for the Development DB,SIT,UAT,Data Reconciliation and validation.
• Documentation of Business Rules, Data Mapping Spreadsheet, Meeting Minutes, Key decisions from the client,SSIS introduction material to the client.
• Worked with Managers to prepare WBS for SSIS/Database development work.

SQL Server/SSIS/SSRS Developer August 2010-December 2010
Confidential,TX,USA
Environment :MS SQL Server 2005/2008, MS SQL Server Reporting Services 2008, VISIO, T-SQL,SSIS 2008

Responsibilities:

• Installed and configured SQL Server 2008, SQL Server Integration Services and SQL Server Reporting Services
• Involved in requirements analysis, development, deployment and unit testing of components.
• Created SSIS packages to import data from MS Access, Excel to SQL 2008.
• Created Complex SQL queries, Derived tables, common table expressions (CTEs), stored procedures, views, user defined functions (UDF).
• Performed T-SQL tuning and optimization of queries that take longer execution time using MS SQL Profiler, Indexes and Execution plans in MS SQL Server 2008.
• Designed and developed various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSISPackages.
• Deployement of SSIS packages to the Conversion Server.
• Create and configure SSIS logging to capture log-enabled events that occur at run time.
• Developed staging tables to house the data and developed exception/error handlers to prevent issues with data being written to the new DB within SQL SERVER SSIS.
• Used XML Package configurations to allow users to modify the package without using BIDS.
• Designed and deployed reports with Drill Down, Drill Through, and Drop down menu option, Parameterized, Sub-reports and Linked reports.
• Deployed and scheduled Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Involved in optimizing report performance using Report Caching and Snapshots.
• Converted Crystal Reports to SSRS reports.

SQL SERVER DEVELOPER March 2010-August 2010
Confidential, Laredo, TX
Environment :MS SQL Server 2008, MS SQL Server Reporting Services 2008, VISIO, T-SQL, Microsoft Office.

Responsibilities:

• Development and maintenance of the department website.
• Involved in designing the Entity Relationship Diagram using VISIO applying normalization principles.
• Involved in Creation of database,tables, storedprocedures,triggers,and user defined functionsfor dealing with studentdata.
• Involved in Installation and configuration of SQL Server 2008 for reporting purposes on Windows 7,Vista Systems.
• Data Mapping between the source and the destination and documentation of the data mapping spreadsheet.
• Created SSIS packages to import data from MS Access, Excel to SQL 2008
• Wrote SQL queries and stored procedures to generate data for reports.

SQL SERVER/SSIS DEVELOPER October 2009-March 2010
Confidential,Texas A & M International University, Laredo, TX
Environment :MS SQL Server 2005/2008, MS SQL Server Reporting Services 2005/2008, T-SQL, Microsoft Office.

Responsibilities:

• Development and maintenance of the university website.
• Dealing with troubleshooting of software, hardware and installation of software and basic networking. Providing Customer Service to Professors and Students on computer related issues.
• Installed and configured SQL Server 2005, SQL Server Integration Services and SQL Server Reporting Services
• Usage of Import/Export Wizard,SSIS packages to import various files,data from other DB' s into SQL Server 2008.
• Generating database Reports to determine lab usage statistics and I.T infrastructure deficiencies.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Created Stored Procedures for commonly used complex queries involving join and union of multiple tables. Wrote SQL queries and stored procedures to generate data for reports.
• Performed backup/restore, created database objects such as tables, procedures, triggers, constraints, indexes and views.

Associate Software Engineer-MS SQL SERVER/SSIS DeveloperJune 2008 – July 2009
Confidential, India
Environment :MS SQL SERVER 2005/2008,SSIS,Visual Source Safe,ClearCase,HP Quality Center,SSRS,SYBASE ASE 15,Oracle 9i DB

Responsibilities:

• Complete RFP requirement analysis from the database perspective.
• Participated in the conversion of legacy DB into SQL Server staging areas using SSIS packages and migration assistants.
• Profiling of the legacy database tables and documenting the list of tables that need to be converted.
• Profiling of the legacy database tables using T-SQL queries to provide data cleansing issue reports to the Client.
• Import of legacy data from Access,Excel,Flat files into SQL Server using SSIS packages.
• Development of SSIS packages during Conversion,UnitTesting,Defect resolution in the Tesing Phases of the project.
• Deployment of SSIS packages to the Conversion server.
• Worked in collaboration with Deloitte,Indiawhich includes knowledge transfer and functional interaction.
• Interaction with the client and understanding functional requirements and meeting project deadlines.Unit Testing of Components delivered by me and my colleagues and finding bugs in code, gaps in design and getting them fixed.

Software Developer Dec 2007-May 2008
Confidential, India
Environment :MS SQL Server 2005,T-SQL,C#,ASP.NET 2.0,Microsoft Office,Visio,Crystal Reports

Responsibilities:

• Interaction with business analysts to gather and understand the business requirements.
• Involved in requirements gathering, analysis, design, development, change management, deployment.
• Creation of Stored Procedures for Application Development.
• Usage of T-SQL constructs like Joins,Subqueries,DerivedTables,Views for querying data
• and generating database reports.
• Development of ASP.NET webforms and webpages involving usage of User Controls,MasterPages,CSS,Authentication,Application and Session State Management,Configuration in C# code.
• Preparation of Entity-Relationship diagrams using Microsoft Visio.
• Creation of Views,User Defined functions,StoredProcedures,triggers,Foreign key and check constraints,tables.02
• Understanding and usage of 3NF Database Normalization form while creating database tables.
• Usage of Visual Source Safe for check in of code artifacts.
• Unit testing of Application screens,Database stored procedures.

ACADEMIC PROJECTS

• Database Design and Report Generation Project:

Environment: Oracle, Microsoft Visio
Responsibilities: To describe data requirements and assumptions in the system using E-R diagrams and designing a normalized database and generation of database reports as per requirements.

• GUI implementation and development of University Registration:

Environment: C#, SQL Server 2008, ADO.NET
Responsibilities: Creation of student registration software using C# as front end and SQL Server as backend

• E-commerce website and Business Process Redesign Project

Client: Confidential, Laredo, Texas
Environment: C#.NET 3.5, ASP.NET 3.5, Microsoft SQL Server 2008, Oracle 10g

Responsibilities: Business process redesign and implementing an online perfume store for the client. Usage ofCSS,Master Pages, User Controls, Session management,Caching,T-SQL and Stored procedures and database independent coding(factory classes).

• Solving a game problem:

Environment: C#.NET2.0
Responsibilities: Implementing a multi user snakes and ladders game using random number generation and many other programming concepts.

• RSS Reader

Environment: C#.NET, SQL Server 2008
Responsibilities: Designing and implementing RSS reader software. Usage of XML & Stored Procedures.

ACHIEVEMENTS

• "Peer Award" for excellent Conversion/ETL development at Deloitte Consulting LLP,USA
• "Outstanding Performance" award during the Greenfield Learning Program by Accenture Services Private Limited, India.
• Graduate Business Fellowship award, Texas A & M International University, USA.