Summary:

• A Microsoft Certified Solution Developer with 9 years of total IT experience in ETL Architecture, Development, Enhancement, Maintenance, Production support, Data Modeling, Reporting including Business requirement, system requirement gathering of Enterprise Data warehouses for mortgage, financial, payroll, insurance domains.
• Highly experienced in all aspects of system development life cycle such as requirement analysis, design, development, testing, implementation, deployment maintenance of projects. Capable of handling responsibilities independently as well as a proactive team member.
• Excellent knowledge in RDBMS concepts and constructs along with Database Objects creation such as Tables, T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions,CTEs, Views and Cursors.
• Expert in the Analysis, Design, Development, Implementing and Testing Client/server application using Microsoft SQL Server and developing BI solutions using BI suite DTS/SSIS,SSAS,SSRS
• Experience in developing applications using C .NET 2.0/3.0, VB.NET, ASP.NET 2.0/3.0 and .NET Framework 2.0/3.0/3.5.
• Excellent skills in High Level Design of and implementing ETL packages using SSIS 2012/2008/2005 for integrating data using OLE DB connection from heterogeneous sources Excel, DB2,Teradata, CSV, XML, Oracle, flat file, Text file by using multiple transformations available in SSIS toolbox such as Script task, Slowly Changing Dimensions, Data Conversion, Conditional Split, Bulk Insert, Merge, Fuzzy Lookup, Multicast, Lookup and Union all.
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging.
• Expert in designing reports using SQL Server Reporting Services SSRS and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.
• Strong experience in defining Referenced relationships in SSAS.
• Expert in creating SSAS2005/2008 cubes, MDX queries, working with facts, dimensions, hierarchies, Perspectives and various storage settings ROLAP/MOLAP
• Possesses excellent skills in Data Modeling using Erwin, Star and Snowflake Schema's.
• Expertise in creating different types of reports such as Cross-Tab, Drill-down, Top N, OLAP and Sub reports, and formatting them using both SSRS 2005/2008
• Developed,Deployed and supported complex SSIS Packages for Data Migration and Transferring Oracle/Access/Excel Sheets using SQL Server SSIS.
• Hands on experience using Informatica Power Center.
• Expertise in designing and developing Informatica mappings from varied transformation logic using filter, expression, rank, router, aggregator, joiner, lookup, and update strategy.
• Expertise in Developing Mappings, Define Workflows Tasks, Monitoring Sessions, Export Import Mappings and Workflows and Backup, Recovery.

• Possesses advanced knowledge of normalization techniques and implementation strategies, backup/recovery strategies, and performance tuning strategies.
• Experience in DTS, SSIS, Import/Export Wizard, SQL Server Enterprise Manager, and SQL Query Analyzer, Access 2000/2003, Excel 2003/2007.
• Worked extensively in MS-SQL Server /20082005/2000, Configuration, Backup Recovery, Database Security, Data Transformation Services, database designing and query optimization.
• Experience in SharePoint Portal integration using web parts and proficiency in VB.net based applications
• High-performing team player with expertise in building/optimizing process, tools and infrastructure to maximize results in various business settings.
• Extremely motivated, able to work smoothly even under pressure, meet deadlines in advance, ready to accept new challenges and adapt quickly to new technologies.

Technical Skills:

Languages : VB 6.0/VB.NET,VBA,C, C , C .NET.

Web Technologies : ASP/ASP.NET, HTML, XHTML, XML, VBSCRIPT

DBMS : Microsoft SQL Server 7.0/2000/2005/2008/2012,Teradata,DB2,PstgreSQL.

Other tools : MS SQL Server Reporting Service 2005/2008, MS SQL Analysis Services 2005/2008, MS SQL Integration Services 2005/2008/2012, Informatica Power center 9.x, Erwin, Programming SQL, Windows 2000/2003, Win NT 4.0, Windows 7 Pro/8.MS Office.

Projects

Confidential

SQL SSIS Lead / Informatica Developer

Responsibilities:

• Involved in all the phases of the SDLC requirement gathering, design, development, Unit testing, UAT, Production roll-out, enhancements and Production support.
• Worked closely with the business users to understand the requirements and converting them into project level technical capabilities.
• Worked with business analysts to identify the appropriate data elements for required capabilities.
• The project involved developing SSIS packages for moving data from varioues sources such as Teradata,DB2,PostgreSQL, SQL Server and external flat files to SQL Server 2012 Staging Area STG and then to Operational Data Store ODS .
• Created documented Detailed level ETL SSIS framework standards and a template package to help developers understand ETL development strategies.
• Created High level/detailed level design documents and also involved in creating ETL functional and technical specification.
• Involved in SQL Server 2012 installation and Upgrade in Test, Development, QA Production servers
• Created primary objects tables, views, indexes required for the application.
• Worked on SQL Server Integration Services SSIS to integrate and analyze data from multiple heterogeneous information sources like Teradata,DB2,PostgreSQL,SQL Server and external Flat files.
• Created Packages for Transaction processing using containers as For-Each Loop, Sequence controlling flow of data using tasks as Script, Data Flow, File System, and Execute Package.
• Extensively used Script task and Script component task to perform custom tasks and data cleansing.
• Developed packages to handle slowly changing dimensions, data cleansing, loading multiple files and executing tasks multiple times using For Each Loop .
• Developed and implemented error handling logics in all the SSIS packages to handle bad data and avoid package failures.
• Developed Custom Audit tables in SQL server to capture SSIS package logging information.
• Monitored performance of SQL Server, diagnosed the causes of poor queries, solved them by optimizing or tuning SQL
• Designed and developed ETL jobs by Using Informatica as ETL tool.
• Developed complex mappings in Informatica to load the data from source files using different transformations like Source Qualifier, Look up connected and unconnected , Expression, Aggregate, Update Strategy, Joiner, Filter, Stored Procedure, normalizer, Router and Mapplets.
• Developed Change Data Capture mappings for Incremental Aggregation.
• Created Slowly Changing Dimension SCD Type 2 mappings for developing the dimensions to maintain the complete historical data.
• Developed Mappings that extract data to Data Warehouse and monitored the Daily, Weekly, Monthly and Quarterly Loads.
• Involved in review of the mappings and enhancements for better optimization of the Informatica mappings, sessions and workflows
• Co-ordinate with the QA team in various testing phases by resolving the defects and ensuring smooth execution of the test plans.
• Creating the deployment documents and migrating the code to the production environment.
• Investigating and fixing the bugs occurred in the production environment and providing the on-call support.

Environment: SQL 2012,Teradata,DB2, PostgreSQL T-SQL,VBA,VB.NET,C .net Excel,flat files, SQL Server Integration Services SSIS ,Informatica Power center 9.x, Data Transformation Services DTS ,MS Office, MS-Project, MS-Visio, XML,Serena Dimensions.

Confidential

SSIS/ Sr.SQL BI Server Developer

Responsibilities:

• Involved in various stages of SDLC like gathering User requirement and System Specification. System Analysis, Design, Development, Testing and Implementation
• Designed, developed, debugged and tested SSIS packages, Stored Procedures, configuration files and implement best practices packages to maintain optimal performance.
• Used SSIS to create Dynamic ETL Packages to validate, extract, transform and load data from different data sources online transaction Processing OLTP databases, Flat Files, CSV, Excel source files, XML files etc to data warehouse databases and involved in Data cleansing in the data transfer.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Redesigned legacy SSIS packages and converted DTS packages to SSIS packages.
• Extracted data from various sources such as Pervasive database, SQL server, Excel, XML,Access and flat files using SSIS into destination tables as per the business requirements mapping documents.
• Extensively used Script task and Script component task to perform custom tasks and data cleansing.
• Variables and expressions were used in the packages to generate custom SQL code to make package tasks dynamic.
• Created tables using SSIS to load error data, error descriptions and package execution diagnostics.
• Performed unit, integration and functional testing of the packages.
• Developed SSIS Templates which can be used to develop SSIS Packages in such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Extensively used Script task and Script component task to perform custom tasks and data cleansing.
• Deployed packages to SSIS Package Store msdb database
• Migrated existing applications to SQL Server 2008
• Involved in the Migration of Databases from SQL Server 2005 to SQL Server 2008.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental Load
• Involved in SQL Server 2008 installation and Upgrade in Test, Development, QA Production servers
• Performed backup/restore, database objects such as tables, procedures, triggers, constraints, indexes and views and functions.
• Developed and Optimized Stored Procedures, Views, CTEs and User-Defined Functions for the Application.
• Supported front-end development team to resolve SQL related issues in Active Server Pages.

Environment: SQL 2005/SQL2008, T-SQL,VBA,VB.NET, Excel, Access, flat files, SQL Server Integration Services SSIS , Data Transformation Services DTS ,MS Office, MS-Project, MS-Visio, XML, Rational ClearCase, Rational ClearQuest,Informatica.

Confidential

SQL/BI Developer

Responsibilities:

• Gathered functional, Business requirements and wrote technical specifications for building the Database objects.
• Wrote user requirement documents based on functional specification.
• Performed database design by analyzing business requirements.
• Build and maintain SQL scripts, stored procedures, Views and complex queries for data analysis and extraction.
• Worked on optimization and tuning of SQL queries and indexes.
• Provide database coding to support business applications using T-SQL.
• Designed, developed, debugged and tested SSIS packages, Stored Procedures, configuration files and implement best practices packages to maintain optimal performance.
• Extracted data from various sources such as Pervasive database, SQL server, Excel, Access and flat files using SSIS into destination tables as per the business requirements mapping documents.
• Extensively used Script task and Script component task to perform custom tasks and data cleansing.
• Variables and expressions were used in the packages to generate custom SQL code to make package tasks dynamic.
• Performed backup/restore, database objects such as tables, procedures, triggers, constraints, indexes and views and functions.
• Performance tune Stored Procedures long running queries by looking at query plans, IO Statistics, Joining

Techniques and Indexes.

• Created Tabular, Matrix, and Chart and parameterized Reports using MS Reporting services 2005.
• Developed Reports for business end users using Report Builder with updating Statistics.
• Used cascaded parameters to generate a report from two different Data Sets.
• Involved with Query Optimization to increase the performance of the Report.
• Designed Reports by creating linked server Views against MySQL database tables.
• Debugged and deployed the generated reports directly onto the client's workstation.
• Developed physical data models and create DDL scripts to create database schema and database objects.
• Designed and implemented stored procedures and triggers for automating tasks.
• Assisted in troubleshooting and resolution of database issues.
• Tested applications for performance, data integrity and validation issues.
• Deployed packages to SSIS Package Store msdb database and Scheduled the jobs to do these tasks periodically

Environment: SQL 2005/SQL2008, Pervasive Database, T-SQL, VB.NET, Excel, Access, flat files, SQLServer Integration Services SSIS , SQL Server Reporting Services SSRS , Visual studio 2008, MS Office.

Confidential

ETL SSIS/Informatica Developer

Responsibilities:

• Designed, developed, debugged and tested SSIS packages, Stored Procedures, configuration files and implement best practices packages to maintain optimal performance.
• Redesigned legacy SSIS packages and converted DTS packages to SSIS packages.
• Created ETL packages with different data sources SQL Server, Flat Files, Excel source files, XML files etc and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Extracted data from various sources such as Pervasive database, SQL server, Excel, Access and flat files using SSIS into destination tables as per the business requirements mapping documents.
• Extensively used Script task and Script component task to perform custom tasks and data cleansing.
• Variables and expressions were used in the packages to generate custom SQL code to make package tasks dynamic.
• Created tables using SSIS to load error data, error descriptions and package execution diagnostics.
• Performed unit, integration and functional testing of the packages.
• Deployed packages to SSIS Package Store msdb database
• Developed Mappings, Sessions, and Workflows to extract, validate, and transform data according to the business rules using Informatica as ETL tool.
• Developed Mappings that extract data to Data Warehouse.
• Setup Schedule database maintenance jobs across all Servers running various DBCC Utilities
• Created and managed schema objects such as tables, views, indexes, procedures, triggers and maintaining referential integrity. Created indexes, constraints and rules on database objects to improve the data base performance to have best out of it.
• Performed backup/restore, database objects such as tables, procedures, triggers, constraints, indexes and views and functions.
• Performance tuned T-SQL code and Store Procedures.
• Supported front-end development team to resolve SQL related issues in Active Server Pages.

Environment: MS SQL Server 2005,T-SQL, VB.NET, Excel, Access, flat files, SQL Server Integration Services SSIS , Data Transformation Services DTS ,Informatica Power center 8.3, Oracle 10g, MS Office.

Confidential

SQL Server Developer / SSRS/SSIS/SSAS Developer

Responsibilities:

• Gathered functional, Business requirements and wrote technical specifications for building the Global Enterprise Data warehouse.
• Worked closely with developers, end users in designing and creating the Global Enterprise Data warehouse.
• Developed a multi-dimensional database and OLAP cube using SQL Server 2005 that stored and maintained data.
• Involved in the complete data warehouse development life cycle.
• Responsible for the design, development and maintenance of several cubes.

• Designed and implemented data mart, facts, dimensions and OLAP cubes using dimensional modeling standards
• Designed MDX in accessing cubes and hands-on experience in query structuring, performance optimization.
• Created SQL server Reports using SSRS 2005.
• Generated various reports with drilldowns, calculated members, dropdowns from the cubes by connecting to Analysis server from SSRS.
• Created Tabular reports, Cross Tab Reports and Sub Reports.
• Debugged and deployed the generated reports directly onto the client's workstation.
• Responsible for transferring data using SSIS packages.
• Analyzed reports and fixed bugs in stored procedures.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications. Data migration Import Export using BCP from text to SQL Server2005.
• Migrated the DTS packages to SSIS packages.
• Performed creating Stored Procedures for reports generation.
• Documented all kinds of reports and DTS and SSIS packages.
• Implemented constraints on tables.
• Developed complex T-SQL code for the application.
• Designed and implemented stored procedures and triggers for automating tasks.
• Maintained table performance by following tuning tips like normalization, creating indexes and collect statistics.
• Used SQL Profiler and Index Tuning Wizard for tracing slow running queries and stored procedures.
• Tested applications for performance, data integrity and validation issues.

Environment: MS SQL Server 2005, MS SQL Server Reporting service 2005,MS SQL Analysis Services 2005, MS SQL Integration Services 2005 T-SQL, Windows 2003.