Informatica PowerCenter Certified Designer - looking for contract assignments.

Hi,

I am a Senior Informatica Analyst with extensive experience in the Information Technology (IT) industry with specialization in the Analysis, Design, Data Modeling,
Development, Testing, Implementation and Maintenance of Data Warehousing/OLAP Reporting Applications.

• Informatica PowerCenter 6 Certified Designer
• Oracle Certified Associate (OCA)

I am a H1B visa holder looking for corp to corp contract jobs.

If you come across any suitable positions for me, please contact me with details.

Thanks,

Kapil

Resume
Kapil Vashishth
kapil.vaashishth@gmail.com
Summary:
• Senior Informatica Analyst with extensive experience in the Information Technology (IT) industry with specialization in the Analysis, Design, Data Modeling,
Development, Testing, Implementation and Maintenance of Data Warehousing/OLAP Reporting Applications
• Extensively used ETL methodology for supporting data extraction, transformation and loading process, in a corporate-wide-ETL Solution using Informatica
• Extensive Experience in data staging, database design, decision support system (DSS), Dimensional modeling, data warehouse requirement analysis and
Implementation
• Experience in designing the architecture for Extract, Transform, Load environment and development of mappings and processes using Informatica Power Center
and Power Mart
• Strong Knowledge in Logical/Physical Data model (LDM/PDM), with Normalized/ Denormalized Databases on both OLTP /OLAP environment using ERwin 4.0,
Designer 2000 and Ms Visio
• Extensive experience in database design for data warehouses with strong understanding of Dimensional Modeling, Star and Snowflake Schemas
• Experience in Informatica PowerCenter (versions 8.0/7.1), Mappings, Mapplets, Transformations, Workflow Manager, Workflow Monitor, Repository Manager
• Extensive experience with Data Extraction, Transformation, and Loading (ETL) from disparate Data sources using Informatica
• Strong experience with UNIX Shell Scripting, PL/SQL, Oracle
• Optimizing the SQL to improve the performances
• Experience in integration of various data sources with Multiple Relational Databases like DB2, Oracle, SQL Server
• Worked on integrating data from flat files, COBOL files and XML files
• Sound knowledge in UNIX shell scripting
• Good in communicating at all levels of management with experience in coordinating various client meetings, seminars, presentations and group discussions
• Ability to work in-groups as well as independently with minimum supervision and initiative to learn new technologies and tools quickly
• Efficient team player with excellent communication skills and good interaction with users
• Result oriented approach for task completion and desire to accomplish everything with perfection and within the stipulated timeframe

Education:
Bachelor of Engineering (Electronics & Communications Engineering)

Certifications:
• Informatica PowerCenter 6 Certified Designer
• Oracle Certified Associate (OCA)

Technical Skills:
ETL tools: Informatica PowerCenter/ PowerMart 8.0/7.1/6.2/6.0/5.1
Reporting Tools: Business Objects 5.X
Databases: DB2, Oracle 9.i/8i/7.x, Teradata, Sybase, MS Access, SQL Server 7.0/2000
Programming: C, C++, JAVA, Visual Basic, PL/SQL
Operating systems: Windows NT/95/98/2000, DOS, UNIX, LINUX
Scripting languages: JavaScript, Unix Shell (K-shell/C-shell)
Web technologies: HTML, DHTML, XML, ASP
Applications: MS Word, Excel, Outlook, FrontPage, PowerPoint, MS-Visual Studio.Net
Tools/Utilities: DBArtisan, Toad 7.x, SQL* PLUS, Erwin 4.0, Test Director
Job Schedulers: Maestro, Appworx, Cron

Project Profile:

National City Bank, OH Sr ETL Developer/Production Lead Mar '06 - Current
Project: Anti Money Laundering (AML)
The aim and objective of this project is to track the illegal money transactions in the accounts of National City Bank. This is mandated by the Federal Government of US under the bank secrecy act. The entire ETL implementation is done using Informatica ETL tool with Oracle as the back end.
Role:
• Working as the Production Lead of the project and coordinating with two technical resources from the TCS-India office and the resources at the present work
location in OH
• Worked on all phases of an ETL Project Life cycle
• Designed, developed Informatica mappings, enabling the extract, transform and loading of the data into target tables
• Worked on Informatica 8, for the new enhancements as National City Bank is upgrading to Informatica 8.
• Worked with Memory cache for static and dynamic cache for the better throughput of sessions containing Rank, Lookup, Joiner, Sorter and Aggregator
transformations
• Created and scheduled Workflows. Setup workflow and Tasks to schedule the loads at required frequency using Workflow Manager
• Designed and developed Informatica mappings for data loads and data cleansing.
• Extensively worked on Informatica Designer
• Extensively used almost all of the transformations of Informatica including lookups, Stored Procedures, Update Strategy and others
• Involved in the Informatica Administration activities involving creating and managing users, creating repositories, code migration from one environment to other
etc.
• Developed sessions using Informatica Server Manager
• Solely responsible for the daily loads and handling the reject data
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes.
• Involved in fixing invalid mappings, testing of Stored Procedures and Functions, Unit and Integrating testing of Informatica Sessions, Batches and the Target Data
• Sound understanding of DataWarehousing concepts
Environment: Informatica Power Center 8.0/7.x, Oracle, UNIX, PL/SQL, TBD (version control), Peregrine Service Center for Incident/Problem/Change management

National City Bank, US ETL Developer Jun 2005- Feb 2006
Project: Consumer Billing System (CBS)
National City Corporation is among the largest banks in the United States. CBS project is to replace the current CALMS system and is responsible for Gathering and processing analysis/billing data that includes data from DDA System (new accounts, ledger, float, and collected balances), Float Management (Pricing) System and Various other Treasury Management Systems.
Role:
• Created mappings to load different sources sent by IMS and CDC (Flat files, oracle tables) to Target Oracle 9i database.
• Have very good user interaction and developed detailed design documents and Business Requirements and Operational requirements documentations.
• Created UNIX shell scripts to run the workflows through UNIX using pmcmd command
• Worked with Workflow Manager, Workflow Monitor, Designer and Repository Manager, Source Analyzer and Warehouse Designer.
• Created Workflows / Worklets, Sessions and scheduled them using Workflow manager.
• Created Flat file sources, developed Stored Procedures and Queries.
• Involved in Unit testing of mappings, scripts Debugging regularly to track and find errors.
• Worked with all kinds of transformations and created mappings and worked with slowly changing dimensions.
• Involved in production support issues, Performance tuning through Informatica
• Involved in working with different schemas and Dimension and Fact Tables.
• Created stored procedures using PL/SQL and different kinds of sessions.
• Involved in Production support, Operations and Knowledge transfer.
• Wrote numerous Pre and Post session SQL and UNIX Commands.
Environment: Informatica Power Center7.x, Oracle, DB2, UNIX, PL/SQL, Serena ChangeMan DS, Peregrine Service Center for Incident/Problem/Change management

National City Bank, US ETL Developer Jan 2005 - Jun 2006
Project: Asset Management Account (AMA)
The AMA system is the part of DES application where AMA bank files are created with DDA data, combined statement data, and SWP investment and mutual fund data. The bank files produce monthly e AMA statements containing this data and the brokerage information. ¬¬¬¬¬¬¬¬¬The Asset Management Account (AMA) combines a convenient full service checking account with self-directed investment options and brokerage services. The idea is to provide a standard non-interest bearing checking account with the added ability to invest excess balances in a variety of Armada Mutual Fund (sweep) and/or NatCity Investments. AMA has been developed to meet the needs of:
Role:
• Used Team Based Development for version Control of Mappings, sessions and workflows
• Created Mappings using different transformations to load data to the target tables from different sources (Flat files, Oracle tables)
• Extensively worked with Workflow Manager, Workflow Monitor, Designer and Repository Manager, Source Analyzer and Warehouse Designer
• Created Workflows / Worklets and scheduled them using workflow manager and UNIX
• Involved in creating Migration instructions, Unit test plans and test cases etc
• Created various Reusable and Non-Reusable tasks like Session, Assignment, Command, Control, Decision, Event and Timer
• Created numerous sessions and worked on PL/SQL
• Wrote numerous Pre and Post session SQL and Unix Commands
• Have created Parameters and variables and used many different transformations for creating a Mapping
• Created workflow and work-lets to run it based on the decisions and conditions
• Worked on Unix and wrote shell scripts
• Worked with Joins and used all kinds of transformations in Informatica
Environment: Informatica Power Center7.x, Oracle, UNIX, PL/SQL, TBD (version control), Peregrine Service Center for Incident/Problem/Change management

National City Bank, US ETL Developer May 2004- Dec 2005
Project: Integrated Data Hub (IDH)
National City Corporation is among the largest banks in the United States. The IDH project will design, develop, and implement an Integrated Data Hub (IDH). This IDH, coupled with a Service-Oriented Architecture (SOA), is the central piece of a new enterprise architectural strategy for exchanging data between applications. In this initial phase, the IDH must be able to provide the data needed by the Statement Redesign project to replace the current functionality. In the longer run, IDH will be the main source of data needed by the downstream systems.
Role:
• Have good interaction with clients and users and involved in requirements gathering
• Have done knowledge transfer and preparing knowledge transfer documents and involved in creating detailed design documents and involved in walkthrough
meetings with clients
• Used VSS for version Control of Mappings, sessions and workflows
• Created Mappings using different transformations to load data to the target tables from different sources (Flat files, Oracle tables)
• Extensively worked with Workflow Manager, Workflow Monitor, Designer and Repository Manager, Source Analyzer and Warehouse Designer
• Created Workflows / Worklets and scheduled them using workflow manager and Unix
• Involved in creating Migration instructions, Unit test plans and test cases etc.
• Created various Reusable and Non-Reusable tasks like Session, Assignment, Command, Control, Decision, Event and Timer.
• Created numerous sessions and worked on PL/SQL.
• Extensively used Pre and Post session SQL and Unix Commands.
• Have created Parameters and variables and used many different transformations for creating a Mapping.
• Created workflow and work-lets to run it based on the decisions and conditions.
• Worked on Unix and wrote shell scripts
Environment: Informatica Power Center7.x, Oracle, UNIX, PL/SQL, Serena ChangeMan DS for version control.

P & O Nedlloyd, UK Production Support Sep-2003 to May-2004
Project: Full Focus 4
P & O Nedlloyd Shipping Corporation Ltd. is a global leader in shipping industry. The client's business is supported by Full Focus 4 application. Full Focus 4 was the main handler of the entire client's business from all the different sources viz. online, INTTRA portal, phone etc. Considered as the best in shipping industry, FF4 caters to all the needs of the shipping clients and customers, offering all the services in shipping to customers and helped increasing business manifolds. The main role was to develop the system to perform the desired functions and looking into the support issues.
Role:
• Client interaction and interaction with other teams.
• Unix Shell Scripting for automation of various processes.
• Developing of Stored Procedures using PL/SQL.
• Extensively worked on Oracle in day to day activities.
• ProC Code deugging
• Solving various user problems and providing efficient and timely solutions to those.
• Worked on Oracle 10g report Server for generation of reports.
Environment: Oracle 9i, Toad 7.0, UNIX (AIX), Sun Solaris, SQL* Loader, ProC, SQL, PL/SQL

P & O Nedlloyd, UK Production Support Jun-2002 to Sep-2003
Project: e-Focus
P & O Nedlloyd Shipping Corporation Ltd. is a global leader in Shipping industry. E-Focus, an interface between back-end processes at FF4 and online customers, is responsible for trapping and maintaining e-business for client. All the online business for P&O Nedlloyd went through eFocus. At EFocus, we offered a variety of services that includes Booking, Bills, Remote bill print at customer premises, Arrival Notification of cargo, schedules of vessels, container tracking and similar services to the business that came through INTTRA portal. The primary work was development and maintenance this business critical application, that included developing Unix shell scripts and Oracle Stored Procedures for the inbound and outbound flow of data and also to ensure timely solutions to the customer needs and business critical requirements.
Role:
• Client interaction and interaction with other teams.
• Unix Shell Scripting for automation of various processes.
• Developing of Stored Procedures using PL/SQL.
• Extensively worked on Oracle in day to day activities.
• ProC Code deugging
• Solving various user problems and providing efficient and timely solutions to those.
• Worked on Oracle 10g report Server for generation of reports.
• Involved with System testing and end to end testing of each module following every system delivery and enhancements.
Environment: Oracle 9i, Toad 7.0, UNIX (AIX), Sun Solaris, SQL* Loader, ProC, SQL, PL/SQL