PRACHI KHER

Tel No.: 631-***-****

Email: qrk3pt@r.postjobfree.com

Summary

• Around 7 years of professional experience in Information Technology with extensive experience in the field of Enterprise Data Warehousing (EDW) and Data Integration.

• Extensive design, development and testing experience with Informatica PowerCenter v8.6/7.x/6.x/5.x.

• Excellent hands-on experience in Korn shell scripting.

• Strong background in Oracle RDBMS v10g/9i/8i.

• Expertise in working with SQL queries and PL/SQL (Stored Procedures, Triggers, Packages/Functions).

• Excellent knowledge of the design and implementation of the Data Warehouse life cycle.

• Familiarity with entity-relationship/multidimensional modeling (star schema, snowflake schema).

• Knowledge of Data Warehouse/Data Mart design concepts.

• Experience with business requirements gathering, business analysis and documentation.

• Expertise in applying data integration concepts in Finance, Mortgage and Retail business verticals.

• Good programming skills using C/C++, PL/SQL, Informatica, ksh.

• Hands-on experience with PowerCenter command-line utilities.

• Experience in troubleshooting and handling production support duties on a 24x7 basis.

• Experience working in an Agile/Scrum environment.

• Experience in delivering projects in a SOX compliant environment.

• Strong analytical skills with a knack for problem solving.

• Highly skilled, motivated team player with excellent communication and inter-personal skills.

• Ability to work well under pressure and meet deadlines.

Technical Skills

Programming Languages: C, C++, SQL, PL/SQL

Scripting: UNIX Shell Scripting (ksh), DOS scripting

Databases: Oracle 10g/9i/8i, SQL Server, Sybase, Teradata

ETL Tools: Informatica PowerCenter/PowerMart 8.6/7.2/6.2/5.1

Scheduling tools: Autosys R4, Maestro (Remote Console/Job Scheduling Console 1.3)

Other Tools: SQL*Plus, TOAD, Mload, Teradata SQL Assistant,

IBM Rational ClearCase, Perforce, Rapid SQL.7.3.1, MS Visio 2000

Operating Systems: Windows 95/98/NT/2000/XP, MS DOS, Solaris, HP-UX

Methodologies: ER/Multidimensional Modeling (Star/Snowflake), Data Warehouse Lifecycle

Education

• Oracle Certified Professional Exams: 1Z0-007 Introduction to Oracle 9i: SQL (Feb 2008, Score: 96%)

• Master of Science, Computer Engineering, State University of New York at Stony Brook, (GPA 3.6).

• Bachelor of Engineering, Electronics, University of Mumbai, India, (GPA 3.8).

Professional Experience

The Capital Group Companies, Irvine, California Jan 2006 – March 2010

Business sector: Finance – Mutual/Pension Funds

The Capital Group Companies serve the needs of individual and institutional clients by managing their investments. In my first assignment, I worked with the Technical Architecture team primarily responsible for automation of Informatica PowerCenter administration tasks. In my second assignment, I worked with the Trading team (Currency/Equity/Foreign Exchange) to maintain and enhance PowerCenter code as per business requirements. In my latest assignment at Capital, I was part of the Portfolio Accounting team assisting with PowerCenter Upgrade effort.

Project: Portfolio Accounting Team

Role: Senior Informatica Developer

Responsibilities:

• Performed analysis/design/development/unit testing for PowerCenter upgrade from 7.2 to 8.6.

• Analyzed UNIX ksh scripts to eliminate redundancy. Consolidated 153 scripts into 33 scripts maintaining the functionality, thus reducing maintenance.

• Modified workflows to use parameter file by replacing hard-coded database connections with $DBConnection session parameters.

• Provided support to Quality Assurance team with troubleshooting of issues.

• Conducted code reviews for peers to verify program logic and identify design flaws

• Demonstrated ability to quickly grasp team guidelines, processes, practices and procedures.

• Worked independently and completed assigned project responsibilities under limited supervision and aggressive deadlines.

Environment: Windows XP, HP-UX B.11.11/64, Informatica PowerCenter 8.6/7.1.2, Sybase, Rapid SQL 7.5.5, Autosys R4, Perforce.

Project: Currency/Equity/Foreign Exchange Trading Team

Role: Senior PowerCenter Programmer/Analyst

Responsibilities:

• Assisted with PowerCenter upgrade for portability between PowerCenter 7.2/8.6 including backward compatibility for workflows/sessions and script changes for pmcmd.

• Assisted with PowerCenter technical planning for the team’s total hardware/software infrastructure split, including implementation approach and rollback strategy.

• Designed phased approach for PowerCenter migrations to reduce complexity, mitigate implementation risk and to reduce batch processing outage.

• Performed unit testing, point-to-point testing and integration testing to confirm ETL code integrity.

• Gained working knowledge of Autosys jils at command line for loading/force starting jobs, changing job status and monitoring job progress.

• Documented the technical description of the entire PowerCenter code for the teams’ reference.

• Conducted training sessions to provide insight of the working/functionality of Informatica workflows.

• Team representative for inter-team meetings to perform impact analysis of cross-team INFA changes.

• Spearheaded projects in Quality Center adhering to SDLC step-by-step approach.

• Developed and maintained project-related audit artifacts and SOX compliance documentation.

Environment: Windows XP, HP-UX B.11.11/64, Informatica PowerCenter 8.6/7.1.2, Oracle 10g/9i, Sybase, Rapid SQL 7.3.1, SQL*Plus, Mercury Quality Center 9.0, Autosys R4, Perforce.

Project: Technical Architecture Team

Role: Informatica Consultant/Assistant to Informatica Administrator

Responsibilities:

• Extensively used pmcmd to design automated utilities.

• Designed and developed utility for PowerCenter folder-level migration and rollback.

• Designed and developed utility for operations team to UNLOCK/LOCK user for PowerCenter emergency access without requiring tool expertise.

• Designed and developed utility for DBA to update Informatica relational connection password.

• Designed and developed utility to assist administrators in creating/editing PowerCenter users. Editing involved resetting password and altering group membership.

• Gained hands-on experience in PowerCenter versioning.

• Scripting in ksh with extensive use of awk, sed and grep to improve efficiency.

• Configured test sessions to get performance details to identify and eliminate source/target bottlenecks.

• Performance tuning for Informatica mappings and sessions.

Environment: Windows XP, HP-UX B.11.11/64, Informatica PowerCenter 7.1.2, Oracle 9i, Sybase, Rapid SQL 7.3.1, SQL*Plus.

Ameriquest Mortgage Company, Orange, California Feb 2005 – Nov 2005

Role: ETL Developer

Business sector: Mortgage

Ameriquest is a leading company in the field of home loans. My project was based in the Loan Servicing sector of the company. One of the main business lines of Loan Servicing is Default Management, which is responsible for servicing delinquent loans. My project work involved implementing the business functionality of all areas that lie within the Default management group.

Responsibilities:

• Worked on a total of 70 mappings, 10 stored procedures and 5 DOS scripts.

• Develop, test and maintain ETL procedures employing both ETL tools and custom PL/SQL

• Participated in the development and maintenance of a Date Warehouse / Data Mart Routine Load Schedule.

• Performed production support duties on a 24/7 basis.

• Involved in business requirements gathering to enable Data Integration across all business groups.

• Extensively used PL/SQL to embed complex business logic in stored procedures.

• Employed expression transformation to perform aggregation through the use of expression variables.

• Extensive involvement with the Quality Assurance team for building exhaustive set of test cases.

• Implemented logic to control job dependencies between ETLs solely through the use of event-raise and event-wait tasks and entries made by ETLs in pilot database tables.

• Used most of the transformations such as the Connected & Unconnected lookups, Filters, Routers, Joiners, Stored Procedure transformations & Sequence Generators.

• Worked on making session runs more flexible through the use of mapping parameters and variables and used parameter files and variable functions to manipulate them.

• Configured the mappings to implement Slowly Changing Dimensions (Type-2).

• Defined Target Load Order Plan and Constraint based loading.

• Wrote DOS scripts to merge files, append timestamp to filenames and move files.

• Implemented entire ETL job plan (50 jobs) through Informatica Scheduler.

Environment: Windows 2000, Informatica PowerCenter 6.2, Oracle 9i, SQL Server, SQL*Plus, TOAD, IBM Rational ClearCase versioning tool.

Best Buy Co. Inc., Richfield, Minnesota Aug 2004 – Dec 2004

Role: ETL Developer

Business sector: Retail

Best Buy is a leading retailer of consumer electronics. The project was implemented in two modules. First module involved migrating daily shipment data from Oracle database (Enterprise Data Warehouse) to Teradata database (Operational Data Source). The second module involved picking up purchase orders data from flat files placed by mainframe (on a daily basis) and loading it in the ODS.

Responsibilities:

• In-depth understanding of processes involving data modeling and building data marts.

• Translated the business processes into Informatica mappings.

• Responsible for coordinating development and testing efforts with offshore team members.

• Involved in optimization of Lookup SQL queries in order to reduce lookup cache size.

• Involved in the deployment of restartibility logic in mappings to enable failed sessions to be rerun without any modifications.

• Design and development of CDC process using time-stamping method.

• Developed ETL sessions for initial full loading and incremental loading.

• Worked with heterogeneous sources including relational sources and flat files

• Extensively worked with Teradata external loader (Mload) in upsert mode.

• Unit and Integration testing of Informatica mappings.

• Developed daily schedules for jobs to be run on Maestro considering various job dependencies.

• Provided production support for both the modules.

Environment: Windows 2000, Informatica PowerCenter 6.2, Oracle 9i, DB2, SQL*Plus, TOAD, Mload, Teradata SQL Assistant, Maestro JS Console 1.3, Unix.

Rave Technologies, Mumbai, India Jan 2001 – June 2002

Role: Database Developer

Rave Technologies is a software solutions provider. The project involved maintaining a database for its business client in the area of Telecommunication and Networking. The database included information such as status and location of the hardware, upgrade information, vendor details, problems encountered and rectification details. The database platform was Oracle 7.x and the application development was done in C/C++.

Responsibilities

• Developed the database schema design using the Entity-Relationship model as per user requirements.

• Conformed the database model to the rules of referential integrity and Normalization (BCNF, 3NF) in order to maintain its consistency.

• Used complex SQL to query the database and was involved in SQL optimization of existing queries.

• Extensively involved in writing Oracle PL/SQL Stored Procedures/Functions/Packages and Triggers.

• Worked with materialized views to obtain optimal query performance.

• Supported the database application development team to tune their applications to suit the database needs.

Environment: Windows 98/2000, Oracle 7.x, SQL, PL/SQL, Visual Studio (C/C++).

Academic Experience

Master of Science, State University of New York at Stony Brook

Design Automation Tool Development and Algorithm Implementations in C/C++

• Partitioning of gate-level VLSI circuits using Simulated Annealing algorithm.

• Global Routing for multi-terminal nets using Soukup’s algorithm.

• Minimization of logic expressions using Quine McCluskey & Branch and Bound algorithm.

Algorithms tested using the IBM ISPD98 Circuit Benchmark Suite.

Data structures like singly linked-lists, doubly linked-lists and binary trees were extensively used.

References: Available upon Request.

Contact this candidate