Objective

• To broaden my competence in new technologies with skill set developed over 10+ years of my work experience and grow along the organization.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 7.x/8.x/9.x, Microsoft Business Intelligence Development Studio, SQL Server Integration Service

Business Intelligence/Data analytics: SQL Server Reporting Service, Business Objects 6.x, Cognos 7.x, Micro strategy 9.x, SAS enterprise guide 5.1, Cognos 10

Data Modeling: Erwin 4.1, ER Studio, Star - Schema and Snowflakes Modeling, Fact and Dimension Tables.

RDBMS: Oracle 9.i/10g/11g, SQL Server 2005,2008,Teradata,DB2

Programming: SQL, PL/SQL, Transact SQL, Unix Shell Scripting.

Environment: s: Win NT/XP/ 2003/2008/2012 server R2, Unix, Sun Solaris

PROFESSIONAL EXPERIENCE

Senior Data Analyst

Confidential

Responsibilities:

• Lead ETL Team in building Structured Solution DataMart.
• Contact points for team’s ETL needs for Business.
• Worked closely with business users and SMEs to gather requirements and build/make changes to the Model based on the requirements.
• Put In place Code Review process/documents and migration documents.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Designed SSISPackagesto transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS - 2008 and SSIS in Business Intelligence Development Studio (BIDS)
• Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications
• Createdparameterized reports, Drill downandDrill throughreports using SSRS

ETL Developer II/Informatica Admin

Confidential

Responsibilities:

• Worked with Power Center - Designer tool in developing mappings and mapplets to extract and load the data from flat, XML, COBOL files and Facets into the warehouse.
• Created reusable transformations and mapplets to use in multiple mappings.
• Used Dynamic parameter values using Automated Balance Concept.
• Extensively worked with architects on design and development of building a new DataMart.
• Participated in setting up an SDLC process in place with-in the warehouse team. Representing ETL team
• Extensively worked on Informatica 9.1 up-gradation and testing.
• Involved in Fine tuning the Informatica Code (mappings and Sessions) and SQL queries adding Indexes to the tables.
• Lead ETL Team in developing multiple projects.
• Developed and helped others developing UNIX scripts to archive Interface files and combine header, trailer and body files
• Used Cognos as a reporting tool to build multiple reports based on business requirements.

ETL Consultant

Confidential

Responsibilities:

• Worked with Business Users in gathering requirements and design data models for the new warehouse.
• Used Data modeling tool ERWIN r8.0 for data requirement analysis and data modeling Involved in creating Alerts so that notifications will be sent to user based upon a value range of a metric (KPI).
• Developed PL/SQL triggers and complex packages to maintain business logic and support business rules.
• Responsible for using Informatica parameters and variables in effectively developing mappings and change data capture process.
• Reported the performance issues with the help of Explain plan generated by the Query optimizer by checking the confidence-level on a table. Identifying the product joins when the confidence level is low, asking the development team to change the PI and if any.
• Worked with Micro strategy tool and developers building new reports for business users.

System Analyst

Confidential

Responsibilities:

• Provided Production support. Was actively involved in troubleshooting the issues related to ETL and reporting that occur on day-day basis Extracted the data from DB2, Oracle, Flat files and Access into Data warehouse.
• Developed complex mappings using multiple sources and targets in different databases, flat and XML files.
• Used Informatica Designer to create complex mappings using different transformations to move data from the source to the Data Warehouse
• Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target.
• Developed mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Source Qualifier, Expression, Lookup, aggregate, Update Strategy, Joiner. Used with connected unconnected, Static and Dynamic lookup transformations
• Wrote PL/SQL Procedures, Packages and Shell Scripts to apply and maintain the Business Rules.
• Created and executed Sessions and Batches using Server Manager.
• Provided Production support. Was actively involved in troubleshooting the issues related to ETL and reporting that occur on day-day basis

Junior Oracle Developer

Confidential

Responsibilities:

• Creating Data Structures. i.e., Tables & views and applying the referential integrity using SQL Used Data modeling tool ERWIN r8.0 for data requirement analysis and data modeling Involved in creating Alerts so that notifications will be sent to user based upon a value range of a metric (KPI).
• Tested and debugged the modules along with the other modules to implement the business logic and involved in designing database schema.
• Managed oracle data base by adding, deleting and updating users and implemented user security by creating user profile roles data capture process.
• Develop and maintain the documentation to support the team and business.
• Responsible for the fixation of the errors in data by utilizing the GUI interface of application and SQL scripting