Summary:

• A Microsoft Certified Professional in SQL Server 2008, Business Intelligence Development and Maintenance.
• 9 years of experience in Software Design, Development, Analysis, Testing and Business Intelligence tools.
• Strong hands-on experience in developing Business Intelligence solutions with the Microsoft Business Intelligence stack.
• Extensive experience in Information Technology with special emphasis on design & development of Database/Data Warehousing/Client-Server/e-commerce applications.
• Proficient in ETL (Extract – Transform – Load) using SQL Server Integration Services 2005 / 2008 (SSIS) and Informatica Power Center tool.
• Strong SSRS development skills, experience including tablix, Matrix, chart, graphic score card reports, sub-reports.
• Hands-on experience in design and development of ETL solutions for data warehouses and data marts, using different architecture, design techniques.
• Hands-on experience on SQL Server Reporting Services to design Reports.
• Expertise in OLTP/OLAP System Study, developing Database Schemas like Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling.
• Experience in analysis, design and construction of Data warehouses and Data marts.
• Strong experience in Source Systems Analysis, designing Packages with Source-Target Mappings.
• Extracted data from different sources including Oracle, Flat Files, Lotus notes, XML Files abd SQL Server.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Hands-on experience in Performance tuning, Query Optimization and Indexing of database using SQL Profiler and Query Analyzer.
• Ability to code and implement complex business rules in T- SQL using Functions, Triggers and Stored Procedures.
• Team player and self-starter with excellent communication and documentation skills, ability to work independently or as part of a team and capable of picking up new skills quickly.

Certifications Achieved:

• Microsoft Certified Technology Specialist (MCTS) – certified 2009
• SQL Server 2008, Business Intelligence Development and Maintenance – certified 2009

Technical Skills:

Data warehousing/ ETL Skills

• SQL Server Integration Services (SSIS) 2005/ 2008
• Informatica 8/ 7

BI Reporting Tools

• SQL Server Reporting Services (SSRS) 2005/ 2008
• Cognos 8

Programming Languages/ GUI

• SQL, PL/SQL, T-SQL, XML, C, C++.,Unix Commands ,Visual Studio

ETL Sources/ Databases

• Oracle 10g/9i/8i/8.x/7.x / Sybase
• §DB2/ Mainframes / SQL Server

Schedulers / Querying tools

• AutoSYS Job Scheduler
• TOAD
• SQL Server Agent

Data Modeling Tools

• Erwin 4.5/4.0/3.5, Embarcadero ER/Studio.

Other Technical Skills

• SSAS Cubes
• XML (Schemas & Transformations)
• Data Modeling
• Mercury Quality Center
• §Rational Rose & XDE

Professional Experience:

Designation: SSIS/ SSRS Lead Consultant
Duration: Oct’10 – Till Date

Description: The project was basically to calculate VaR using the new system formed, based on daily trade and sensitivities.

Responsibilities:

• Worked with the team to understand the probleblem in current Var calculation.
• Used Jira’s to organize and resolve day to day issues.
• Profiled data from the source, and transformed the data to meet the user’s requirement.
• Designed SSIS Packages using several transformations to perform Data profiling, Data Cleansing and Data Transformation.
• Designed BATCH scripts to automate and run jobs in different environment.
• Analyzed the data to implement incremental load.
• Extensively worked on Stored Procedures, Functions in T-SQL.
• Worked with AUTOSYS for Job status.
• Used Tabular and Matrix Reports Layout to design reports, based on the requirement.

Environment:
O/S: Windows 2003 Server
ETL Tools: SQL Server Integration Services 2008
Databases: SQL Server 2008, SQL Server 2005, Mainframes, DB2, MS Access
Programming: T-SQL & Stored Procedures
Reporting Tool: SSRS 2008

Designation: SSIS/ SSRS Lead Consultant
Duration: Oct’08 – Oct’10

Description:Consolidated Edison Company of New York (Con Edison), a regulated utility, provides electric service in New York City (except for a small area of Queens), and most of Westchester County. We provide natural gas service in Manhattan, the Bronx, and parts of Queens and Westchester. Con Edison also owns and operates the world’s largest district steam system, providing steam service in most of Manhattan. Today, Con Edison operates one of the world\'s largest and most complex yet most reliable energy delivery systems, in the world\'s most dynamic marketplace. As we look to the challenges of the future, Con Edison can count on one advantage that no other company has the energy of New York. The project is about creating a data warehouse that the Gas Operations Team can use to keep track of their Inspections and Assets.

Responsibilities:

• Involved in the complete SDLC including Requirement Specifications, Analysis, Design, Development, & Testing of application.
• Worked with data analyst and data modeler to design the complete warehouse Schema using Erwin with proper relationships defined.
• Worked with data analyst to figure out the business logic that needs to be implemented in the warehouse day to day load.
• Profiled data from the source, and transformed the data to meet the user’s requirement.
• Designed and developed the Staging Database and loaded from source to staging and from staging to the Destination tables applying different transformations.
• Designed SSIS Packages using several transformations to perform Data profiling, Data Cleansing and Data Transformation.
• Analyzed the data to implement incremental load.
• Implemented Slowly Changing Dimension (SCD) type 2 to maintain Historical Data.
• Designed Package to do ETL Auditing and designed Stored Procedure to keep track of Daily Load.
• Used different sources like DB2, Mainframes and Flat Files to Extract Data.
• Extensively worked on Stored Procedures, Functions in T-SQL.
• Used sysdts log table and configuration files in the packages.
• Used Tabular and Matrix Reports Layout to design reports, based on the requirement.
• Created Dashboards and KPI’s using SSRS.
• Worked on SSRS extensively to create and design reports.
• Worked with Report Builder to build Ad-hoc Reports.
• Used complex expressions to calculate, group, filter, parameterize, and format the contents of a report.
• Used SQL Profiler to trace Performance of Queries and to index the Tables.
• Created SSIS Jobs and scheduled Packages using SQL Server Management Studio for the Daily Load.
• Created Maintenance Plans to do Backups, and setup log files to monitor jobs.
• Worked extensively on the Query studio and canned reports to carry out the UAT.
• Worked on the ETL documentation for the packages.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables
• Attended functional testing and user acceptance sessions and worked on the feedback provided by them.

Environment:
O/S: Windows 2000 Server, Windows 2003 Server, IBM Rational ClearQuest
ETL Tools: SQL Server Integration Services 2008
Databases: SQL Server 2008, SQL Server 2005, Mainframes, DB2, MS Access
Programming: T-SQL, PL/ SQL, Triggers, Packages & Stored Procedures
Data Modeling: Erwin 4.2
Reporting Tool: SSRS 2008, Cognos

Designation: ETL /BI Lead Consultant
Duration: Jun’08 – Oct’08

Description: This project is for analyzing the Annuities and Life Reserves for different Allstate Policies, working with different LOBs. Annuities work like this. You pay money to an insurance company, and then they invest it. Over time, they\'ll pay you back while offering tax advantages. Life insurance is pretty simple. If you\'re protected and you pass away, your beneficiaries receive a cash benefit. They can use this for just about anything paying off debts, replacing income that you\'re no longer providing and of course, medical and funeral expenses. The warehouse is to help the company to check there monthly Reserves from different LOBs.

Responsibilities:

• Worked as an ETL Lead and was mostly leading a development team of two in offshore.
• Involved in complete SDLC including Requirement Specifications, Analysis, Design, Development, & Testing of application.
• Worked with the Data modeler in designing the Schema using Erwin with proper relationships defined.
• Designed the complex views that we can use from the source to populate the warehouse with required columns.
• Designed Reports in SSRS, with several prompts and built ad-hoc reports in Report Manager.
• Designed and developed the Staging Database and loaded from source to staging and from staging to the Destination tables applying different transformations.
• Worked with Data mapping, High level design and Detailed design documents.
• Used complex transactions and Validations to make sure that the data is correctly loaded into the warehouse.
• Used Balance and Control mechanism to make sure that the amounts we get from the source matches the amount loaded in the target.
• Helped offshore team on daily calls to design SSIS Packages using several transformations to perform Data profiling, Data Cleansing and Data Transformation.
• Created maintenance plans to load data and to backup 3 months data.
• Applied Security in Packages to safe guard sensitive data, and used log providers to log events.
• Performed ETL Auditing to maintain Loads report.
• Used Log providers to log error into the table and send the report to the concerned department.
• Used Configuration files to deploy and install a package from one environment to another.
• Used and set the threshold value to count for errors before failing the package.
• Extracted data from flat files and from RDBS sources like Oracle and SQL Server.
• Created recurring SSIS Jobs and scheduled Packages using SQL Server Management Studio for the Load.
• Worked on SSRS to design reports and deploy them to the Report Manager.
• Worked on SSRS with expressions and designing of reports.

Environment:
O/S: Windows 2000 Server, Windows 2003 Server, IBM Rational ClearQuest
ETL Tools: SQL Server Integration Services (SSIS 2005)
Databases: Oracle 9i/ 10g, SQL Server 2005, MS Access
Programming: T-SQL, PL/ SQL, Triggers, Packages & Stored Procedures
Data Modeling: Erwin 4.2
Reporting Tool: SSRS 2005

Designation: SSRS/ SSIS Consultant
Duration: Oct’07 – Jun’08

Description: This project is for the MIS department of the Prison systems. The goal of the project is to help the prison management in deciding who are to be held back and who are to be released to decrease the number of inmates in the prison, thereby reducing the crime in the city. The mission of Philadelphia Prison System is to provide a secure correctional environment that adequately detains persons accused or convicted of illegal acts; to provide programs, services, and supervision in a safe, lawful, clean humane environment and to prepare incarcerated persons for reentry into society.

Responsibilities:

• Involved in complete SDLC including Requirement Specifications, Analysis, Design, Development, & Testing of application.
• Designed the complete Data warehouse Schema using Erwin with proper relationships defined.
• Developed complex T-SQL queries and designed SSIS packages to load the data into warehouse.
• Designing SSIS Packages using several transformations to perform Data profiling, Data Cleansing and Data Transformation.
• Applied Security in Packages to safe guard sensitive data, and used log providers to log events.
• Designed Package to do ETL Auditing and designed Stored Procedure to keep track of Daily Load.
• Performed Data Migration from Oracle to SQL Server 2005 using SSIS 2005.
• Used different sources like Oracle, SQL, XML Files and Flat Files to Extract Data.
• Extensively worked on Stored Procedures, Functions in T-SQL.
• Explained the whole design of ETL Process using Visio tool.
• Used SQL Profiler to trace Performance of Queries and to index the Tables.
• Extracted data from flat files and from RDBS sources like Oracle and SQL Server.
• Created SSIS Jobs and scheduled Packages using SQL Server Management Studio for the Daily Load.
• Created Maintenance Plans to do Backups, and setup log files to monitor jobs.
• Worked on SSRS to design and develop Matrix and Tabular Reports.
• Used stored procedures and complex parameterized queries for Dataset of Reports.
• Created Cubes to analyze data.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables
• Attended functional testing and user acceptance sessions and worked on the feedback provided by them.

Environment:
O/S: Windows 2000 Server, Windows 2003 Server, IBM Rational ClearQuest
ETL Tools: SQL Server Integration Services (SSIS 2005)
Databases: Oracle 9i/ 10g, SQL Server 2005, MS Access
Programming: T-SQL, PL/ SQL, Triggers, Packages & Stored Procedures
Data Modeling: Erwin 4.2
Reporting Tool: SSRS 2005

Client: Confidential,Omaha, NE
Designation: SQL Developer
Duration: Apr ’07 – Sep’07

Responsibilities:

• Utilized SSIS (SQL Server Integration Services) to produce a Data Warehouse for reporting.
• Conduct code walkthroughs and review peer code and documentation.
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 changes.
• Performed Data Cleansing and Data Profiling using several transformations like Data Conversion and Derived Column.
• Work with developers, DBA, and systems support personnel in elevating and automating successful code to production.
• Designed and developed SSIS packages, designed stored procedures, configuration files, tables, views, and functions.
• Implemented best practices to maintain optimal performance and optimized SQL queries for maximum efficiency,
• Fine tuned of database objects and server to ensure efficient data retrieval.
• Developed complex programs using T-SQL queries, including Procedures, Triggers, and functions.
• Provided on-call support to production system to resolve any issues.

Environment:
O/S: Windows 2000 Server, Windows 2003 Server, Rational ClearQuest
ETL Tools: SSIS 2005, DTS
Databases: Oracle 9i/ 10g, SQL Server 2005, MS Access
Programming: T-SQL, PL/ SQL, Triggers, Packages & Stored Procedures
Data Modeling: Erwin 4.2
Reporting Tool: SSRS 2005

Client: Confidential,NJ
Designation: ETL Consultant
Duration: Oct’ 06 – Mar’07

Building Data Warehouse for customer billing information
Project Description:
Sprint Corporation is a global communications company offering an extensive range of communication products and solutions in US. A Datawarehouse was developed to maintain the customer billing information in a central repository. This was managed and implemented as a three-layer (staging, ODS, decision support) data warehouse and OLAP reporting system for the Customer Support Unit and the Market Services department.

Responsibilities:

• Involved in Business Analysis and Requirements collection.
• Used designers, tools, and wizards to work with the objects.
• Have used SQL Server 2005 Integration Services (SSIS) transformations in the data flow of a package to aggregate, merge, distribute, and modify data.
• Performed Data Cleansing and Profiling using Transformations in Packages.
• Involved in complete SDLC including Requirement Specifications, Analysis, Design.
• Handled performance tuning to optimize SQL queries using query analyzer
• Worked on several transformations in Data Flow including Derived-Column, Script, Slowly Changing Dimension, Lookup, Data Conversion, Conditional-Split and many more.
• Used .NET Provider Data Reader Source Task to Read from RDBMS sources.
• Worked on XML Web Services Control Flow task to read from XML Source.
• Performed Unit Testing and Prepared maintainance plans

Environment:
O/S: Windows 2000 Server, Windows 2003 Server, IBM Rational ClearQuest
ETL Tools: SSIS 2005
Databases: Oracle 9i/ 10g, SQL Server 2005
Programming: T-SQL, PL/ SQL, Triggers, Packages & Stored Procedures
Data Modeling: Erwin 4.2
Reporting Tool: SSRS

Client: Confidential,NYC
Designation: Informatica/ ETL Developer
Duration: Dec’05 – Sep’06

Transact, NY
Project Description:
Soverain’s flagship product Transact is an e-commerce system for businesses seeking to power high-volume, high-transaction commerce websites. Transact is built on a scalable & flexible architecture that supports the entire Internet commerce cycle: comprehensive order management, fulfillment, payment, customer service, and reporting. The Data warehouse built for the Products helps to Manage Data, Customer and order Information and is helpful in creating Reports.

Responsibilities:

• Developed many custom UNIX scripts, Informatica maps, PL/SQL programs and SQL*Loader scripts to provide a best-fit solution for varying data sources
• Used business requirements and functional specifications to generate logical data models
• Worked on complete SDLC from Extraction, Transformation and Loading of data.
• Responsible for the design, development and implementation of mappings /transformations based on source-to-target specifications, defining ETL (extract, transform, load) development standards and conventions
• Used Import/Export Wizard. to quickly move data into or out of SQL Server from or to a variety of sources, including text files and other SQL Server instances.
• Created, updated and maintained ETL technical documentation
• Experience in installation and configuration of Informatica Power Center on Client/Server environment
• Analyzed source system data and designed the star schema for the data warehouse to be developed.
• Assisted in fine-tuning transformations for increased performance and efficiency.
• Created reports using Business Objects functionalities like drill up/down etc.
• Worked Created test scenarios to complete the UAT for the quality of the extracted and merged data.

Environment:
O/S: Windows NT/2000/2003 Server, UNIX (Sun Solaris), Autosys 4.0
ETL Tools: SSIS 2005, Informatica PowerCenter 8
Databases: Oracle 9i/ 10g, SQL Server 2005
Programming: T-SQL, PL/ SQL, Triggers & Stored Procedures
Data Modeling: Computer Associates Erwin 4.2

Client: Confidential,Singapore
Designation: Informatica Developer
Duration: Dec’04 - Nov’05

Asia Data Warehouse
Project Description:
This project involved developing a Data Warehouse for General Electric’s Singapore workshop of Aircraft Engines (GEAE). The aim of the project is to source data from the present OLTP systems to the Data Warehouse and to create standard & ad-hoc reports from the Data Warehouse.

Responsibilities:

• One of the members in the three-member requirement study team
• Studied the existing OLTP Data structure and the gathered reporting requirements of the business users
• Involved in complete software development life cycle (SDLC) i.e. Requirement Analysis & Specification, technical design and Implementation.
• Documented Low Level and High level Design Specifications.
• Created Data Model using Embarcadero ER/Studio.
• Involved in Requirement Analysis, ETL Design and Development for extracting and loading data
• Used Informatica Power Center Workflow manager to create sessions and workflows to run the logic embedded in the mappings
• Created different transformations like Source Qualifier, Expression, Router, Filter, Lookup, Sequence Generator, Normalizer for loading the data into the targets
• Worked with Lookup, Aggregator, Expression, Router, Filter, Update Strategy transformations
• Involved in performance tuning of databases and mappings
• Actively involved in Unit testing, System Testing, UAT and Implentation of the project

Environment:
O/S: Windows NT/2000/2003 Server, UNIX (IBM/AIX)
ETL Tools: Informatica PowerCenter 8/ 7.1.2
Databases: Oracle 9i, SQL Server 2000
Programming: SQL, PL/ SQL

Client: Confidential,India
Designation: Oracle SQL Developer
Duration: Nov’02 - Nov’04

Virtual Delivery System
Project Description:
The project has over 200 associates working on different applications for the Virtual Delivery Portal. Applications include Idea Junction, HR Recruitment, HR Exit, eCoRCC, and Associate benefit, EMall, Web Conferencing and Survey.

Responsibilities:

• Installation and configuring Oracle client/server. Writing complex stored procedures
• I was involved in the entire development cycle of the project. It begins with gathering user requirements, constructing data models, writing code and testing applications, and ends with user support.
• Creation of packages and Performance tuning the database as and when required
• Responsible for creation of logical data models based on entity-relationship diagrams. The models were developed in accordance with the rules of referential integrity and normalization
• Involved in interacting with the business community to understand their requirements
• Design and developed PL/SQL procedures, packages and triggers to be used by team members
• Developed packages using DTS.
• Created materialized views to increase the speed of queries
• Created test databases to test and tune the SQL queries

Environment:
O/S: Windows NT/2000/2003 Server
Databases: Oracle 8i, SQL Server 2000
Programming: SQL, PL/ SQL, ASP, JAVA
Other Tools: TOAD 7.2

Education:

• B.Sc(Computer Science
• Master of Computer Applications (MCA)
• GNIIT NIIT,

Achievements & Training:

First class with distinction in Graduation (received Scholarship).
Excellent Grade (90% in GNIIT Course)
Best Project of the year award for final year Professional Practice.