SUMMARY:

• Around 8 years of Strong experience in Data Quality and Data Warehousing (ETL) using Informatica 9.1.0, 8.x (Informatica Data Quality(9.1.0 HF4), Informatica Power Center - Designer, Workflow Manager, Workflow monitor, Repository manager), Data mart, OLAP, OLTP, SQL, PL/SQL Stored Procedures and utilities.
• Created specific transformations in Data Quality like Address Doctor, Standardization, Matching, Association and did profiling on the huge volume of retail customer data.
• Experience in Life Cycle Development of building a Data Warehouse for large technology projects including Analysis, Design, Development, Testing, Maintenance and Documentation
• Strong Database skills in Oracle 11g/10g, MS SQL Server.
• Ability to transition business expectations through IT's budgetary and technical limitations to design effective and efficient applications. As a Data Analyst I have successfully helped clients meet their business objectives by utilizing information technology
• Strong experience in designing and developing Business Intelligence solutions in Data Warehousing/Decision Support Systems using Informatica Power Center.
• Experience in integration of various data sources from Databases like MS Access, Oracle, SQL Server and flat file formats like dat files, TLV (Tag-Lenghth-Value) files, CSV files and XML files.
• Worked extensively in different Job Schedulers like Maestro, Tivoli Web Scheduler,Control-M and cron jobs in UNIX.
• Experienced in using parameter files, mapping parameters and variables in informatica mappings.
• Experienced in working with UNIX Shell Scripts and Perl (Basics) for invoking and executing sessions, aborting sessions and creating parameter files.
• Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals. Excellent written and verbal communication skills
• Experience in Coordinating onsite - offshore interaction, contributed suggestions and valuable solutions during the on-going. Good communication skills, interpersonal skills, self-motivated, quick learner and valuable team player.

SKILLS:

Data WareHousing Tool: Informatica Data Quality (IDQ) 9.1.0HF4Informatica Power Center 9.1.0/8.6 (Designer,Workflow Manager, Workflow Monitor, Warehouse Designer)

Databases: Oracle-11g/10g/9i, SQL Server

Scipting Languages: UNIX Shell Scripts

Project Tools: Informatica Data Quality, Informatica Power Center, TWS - Maestro, Control- M, Actuate, Telelogic- Change synergy, Remedy websystem, CITRIX, HP-QC, CRT-Unix/Linux box, Dimensions.

WORK EXPERIENCE:

Confidential, Minneapolis, MN

ETL Tool: Informatica Data Quality & Informatica Power Center

Database: Oracle 11G.

Server: Linux.

Responsibilities:

• Defined the high level scope of Application Architecture, provided the solution for the design changes, build the informatica data quality mapplets and powercenter mappings for the Customer Identification (CID) Project.
• Created Specific IDQ transformations for Standardization, Group key creation, AddressValidation, Matching (Different attributes) and Association based on the data profiling and cleansing rules provided by Business on high volume(400M) of Customer Data.
• Responsible for delivering artifacts as a part of Agile methodology
• Created concurrent and multi - thread solutions for better performance in creating the Data Quality mapplet and power center mappings.
• Working in the Oracle PL/SQL procedures & packages to analyse and develop the new business requirements and enhancements in the existing functionalities.
• Good hands on experience in performance tuning and maintanence on ETL tool (informatica) and Oracle Database.
• Created High and Low level design technical documents and specs
• Worked in the process of developing and scheduling Shell scripts to automate the sql packages and procedures

Confidential

ETL Tool: Informatica Power Center IDE, Data Quality (IDQ)

Database: Oracle 11G.

Server: Linux.

Responsibilities:

• Cordinated with onsite managers and get the SRS documents for implementing the mainframe.
• Allocate the reports to the individual team members
• Helping the team members to solve the issues and concerns on every report.
• Reviewing and validating the reports on all the development phase
• Presenting the reports to onsite managers and senior managements.
• Working on daily, weekly and monthly feeds and its corresponding maintanence activities pre and post batch completion.

Confidential

Languages: PL/SQL, UNIX-Shell script, Perl script

Database: Oracle 9i & Oracle 10g.

O/s: Windows XP and UNIX.

Responsibilities:

• Worked in the PL/SQL procedures & packages to analyse and develop the new business requirements and enhancements in the existing functionalities.
• Good hands on experience in performance tuning and maintanence of the Database.
• Worked in the development of PL/SQL procedures and anonymous blocks which supports the required module to fulfill the needs.
• Workied in developing and scheduling Shell scripts to automate these sql packages and procedures through Control - M and Sentry.
• Workied in the TableSpace creation scripts and Partition creation scripts for each quarter depends on the data flow comparing with the previous months.
• Prepared scripts to archive the old data from the UAT and Dev database s and purge them depends on the business approvals.
• Scheduled controlM setup based on the input flow of data which calls different Ksh file s which in turn call the required sql procedures and functions.
• Actively participating in Design calls and Customer calls, pre release call to PS Team.
• Provided Pre and Post deployment production supports and solved the issues during such situations.

Confidential

Languages: PL/SQL, UNIX-Shell script, Perl script

Database: Oracle 9i & Oracle 10g.

O/s: Windows XP and UNIX.

Responsibilities:

• Worked in the development of PL/SQL Procedures and Packages with respect to the design documents and User Stories.
• Worked in creating delay rules for generating TLV s(TagLengthValue) to send and receive these data s within various components in PL/SQL.
• Worked in XFB transformation protocols to transfer the feeds generated from particular entvironment to other components.
• Monitor the UNIX crontab entries for scheduled PL/SQL codes and shell scripts to generate the feeds.
• Written Perl Scripts with required milestone information to fetch the milestones from all the Order type (CTL)files.
• Receive requirements from the onsite coordinator or customers and seek clarifications about requirements from them.
• Preparing LLD and UTP for the pre and post requirements delivery to the test and production environments.
• Prepared Release requests,Installation Instructions for every release with required information.