OBJECTIVE:

• A self - motivated individual looking to secure a respectable position in a result oriented company, where I can use the noledge acquired through professional experience and educational background in helping the company reach its anticipated goals.

SUMMARY

• 5 Years of experience in Informatica wif a strong background in ETL Administering, developing and Data warehouse development and maintenance using Informatica Power Center 9.1/8.6.1,8.5.1.
• Expertise in Installation, Configuration and diagnosing of Informatica software tools like Power center, Power Exchange.
• Has good understanding on Informatica Administration, Admin Console, User and Domain, Node & Grid Management, VERITAS Cluster Server (VCS) to achieve High Availability (HA) on Informatica and Disaster Recovery (DR).
• Well versed in utilizing of Administrative tools like Informatica Admin Console
• Experienced in using B2B tools like Data Analyzer, Data Transformation, Analyst services.
• Experienced in LDAP Integration wif Informatica.
• Experienced in configuring web services wif Informatica using SSL.
• Expertise in migration of Informatica PC from one version to other version, code development & deployment and user access management.
• Special skills achieved in numerous performance optimization techniques using Informatica
• Expertise in Data Warehousing components. Strong expertise in building and maintaining a warehouse.
• Experienced in Enterprise Data Warehouse (EDW) and specialized in writing Teradata BTEQ, Fast Load, MLOAD, FAST EXPORT and SQL Assistant. Has strong noledge on using SET Theory and Multi level statements, JOINS, INDEXES, STATS and etc..
• Expertise in dealing Slowly Changing Dimensions, PWX CDC ( Change data capture) Delta, Append, Merge and Replace files wif Huge Volume (50 + million )
• Experience in integration of various data sources wif Multiple Relational Databases like Teradata, DB2, Oracle, SQL Server and Netezza.
• Well acquainted wif Informatica Designer Components - Source Analyzer, Transformation Developer, Mapplet and Mapping Designer
• Experienced in developing workflows, sessions, command tasks, complex mappings, mapplets and all types transformations wif excellent performance technique.
• Extremely specialized in designing distributed /ETL/Informatica batches, Job flows, schedule, NFR’s Operational needs, and Restartability and data quality improvements.
• Expertise in documentations, Proof of Concepts (POC), creating very detailed design documents (LLD, HLD, Visio Job Linkage and etc.) and support related documents.
• Expertise in Re-Engineering and Optimization, minor to major enhancements, reusable transformations, Cost Benefit Analysis and new proposals.
• Extensive experience in performance tuning of ETL process. Reduced the execution time significantly for huge volumes of data during company merger projects and many long running jobs in production by implementing Pushdown optimization, Native scripts and bulk loaders.
• Experienced in implementing Automated Error Reprocessing (AER) to ensure exceptions and errors are captured to maintain the Integrity between Source and Target systems.
• Experience in defining testing strategies, creating test cases for unit, functional and integration testing and getting UAT sign off from Business.
• Being the lead of Data Integration Governance, has reviewed and approved all ETL application design. And has maintained ETL design standards across the organization.
• Experienced in project estimation and resource management, developed more than 40 + ETL interfaces and expertise in SDLC deliverables. Involved in Design and Implementation reviews and transition to production support team.
• Expertise in utilizing scheduling tools like Control M and TWS
• Good noledge and experience in middleware tools like web MQ series.
• Experience in UNIX shell scripting, FTP and file management in various UNIX environments.
• Strong experience in Knowledge management, Incident Management and Change Management.
• Very Strong communication and leadership skills, inter personal and presentation skills. Ability to work independently wif customers and act as efficient coordinator for onsite-offshore resource model. Leading the team off 15+ at offshore and 3+ on onsite.
• Highly motivated individual wif excellent team building and playing skills

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.x, 8.x, Informatica Power Exchange for Mainframe, Informatica Admin Console, Support Console, Data Analyzer, Metadata Manager, Data Transformation, Analyst Tool etc.

Schedulers: BMC Control M and IBM TWS.

Programming Languages: C, C++, COBOL, JAVA, PL/SQL, VB.Net, HTML and XML

Scripting: UNIX Scripting and Teradata BTEQ, MLOAD, FASTLOAD and FAST EXPORT

Servers: Tomcat and VERITAS Cluster Server (VCS).

Databases: Oracle, Teradata, SQL Server, DB2 UDB/ZOS, Microsoft Access

Operating System: Windows NT/2000, UNIX, Linux, Solaris, AIX

Tools: & Utilities SQL*plus, PL/SQL developer, Win SCP, Lotus notes, Outlook, WSAD, Eclipse, Web sphere MQ, Manage now and Service Now.

Version Control Tools: VSS, GIT, Win CVS Others MS Visio, MS Power Point, MS word, MS Excel

PROFESSIONAL EXPERIENCE

Lead Platform Administrator

Confidential -Minneapolis, MN

Responsibilities:

• Stabilizing the platform so that the platform is robust enough to avoid frequent outages.
• Recycling of Informatica as part of regular maintenance activities.
• Promoting all application codes (both Informatica and Linux) to higher environments.
• Assisting cross commits in identifying and resolving any critical issues.
• Coordinating wif Informatica and IBM vendors in identifying resolving any issues.
• Installing and upgrading any EBFs patches on the Informatica Platform
• Providing architectural solution of any new projects/Interfaces using Informatica B2B tools or new utilities into the Informatica platform.
• Querying the repository databases in identifying the anomalies in code or run properties of various Informatica objects.
• Accomplished in maintaining a highly available platform wif > 99.96% availability.
• Accomplished in successfully resolving numerous issues wif code/limitations of Informatica and the differences in between the patches.

Confidential

Responsibilities:

• Provide SAN, VERITAS, Load Balancer related requirements to the related teams.
• To coordinate wif respective teams to get Oracle, Teradata, DB2 and NETEZZA clients installed on the servers.
• To install Teradata utilities like MLOAD, FASTLOAD etc. on all the servers
• To coordinate the install and configuration of WMQ and Connect: Direct services on the new servers.
• To install Informatica Domain on a highly available configuration in the six servers.
• To configure Informatica Repository on the six nodes.
• To install Informatica Power Exchange
• To configure Integration services using the Unicode and ASCII data movement.
• To configure Web Services using SSL certificates for HTTPS Scheme.
• Configuring LDAP autantication using Microsoft Active Directory.
• To configure and setup B2B services like Analyst Services, Metadata Manager and Data Transformation.
• Configure Tivoli Workload Scheduler wif broker agent on all the servers.
• To perform Domain level High Availability testing.
• To perform Repository Level High Availability testing.
• Repository restore and Backup for the Application cutover
• Developing custom scripts for firewall connectivity validation.

Environment: Informatica Power Center 9.1, Power Exchange, Admin Console, Informatica Analyst Data Analyzer, Red Hat Linux (Santiago), TWS, Teradata, Web service, WMQ, z/OS and VSAM files, MFT

Confidential

Responsibilities:

• Gathering all installed EBF details on the current environment
• Co-coordinating wif Informatica in gathering various required installables EBFs - For Eg: Power Center, Client, Power Exchange
• Coordinating wif various teams in identifying the different patterns across 180 applications across Informatica Platform - Flat File to Flat File, Flat File to XML, DB2 to Oracle, Mainframe to Teradata, Salesforce to Netezza etc.
• Perform AS IS, TO BE testing before and after installing the Hotfix
• Install Power Center 9.1 Hotfix 6 on thirteen Linux servers (Development, Test and Production together)
• Install Power Exchange Linux 9.1 Hotfix 6 on thirteen Linux servers (Development, Test and Production together)
• Coordinate installation of Power Exchange Mainframe on all three mainframe environments(Development, Test and Production together)
• Coordinate upgrade of Informatica Client on multiple Citrix servers.
• Identifying and fixing the post install issue wif any Power Exchange target using reserved keywords from Informatica

Environment: Informatica Power Center 9.1, Power Exchange, Admin Console, Red Hat Linux (Tikanga), TWS, z/OS and VSAM files, PowerCenter Designer, Repository Manager, WorkFlow Manager, WorkFlow Monitor.

Confidential

Responsibilities:

• Installing WMQ server on all six nodes per environment where Informatica is installed.
• Coordinating the creation of channel table and the channel table manager.
• To solution the architecture by identifying real time job run vs. trigger based run which satisfies the needs of the project.
• Setting up the Informatica profile to accommodate Informatica connecting to WMQ
• Identifying and resolving any issues in WMQ connectivity wif Informatica.
• Helping WMQ team in rerouting the message to the local queue node where the Informatica workflow runs once the message is received into one of the six nodes.
• Assisting the project team in having a lag between the start of the workflow and the actual read of the message to accommodate rerouting lag of the message between the nodes.

Environment: Informatica Power Center 9.1, Admin Console, Red Hat Linux (Tikanga), TWS, PowerCenter Designer, Repository Manager, WorkFlow Manager, WorkFlow Monitor, WMQ.

Lead Informatica Developer/Tech Lead

Confidential -Minneapolis, MN

Responsibilities:

• Led the team which successfully implemented ~40 interfaces into production wifin a period of 8 months where I was the single point of contact for all the projects.
• Roles and responsibilities included requirement gathering, design and implementation walkthroughs, code reviews etc.
• All the projects were installed wif 100% success ratio.
• Received acnoledgement and appreciation from all the cross commit leaders and directors towards continual support and quick turnaround time on all the projects.
• During crucial year end period accomplished in completing 12 projects in a period of five weeks.

Confidential

Responsibilities:

• Identifying the source systems involved in generating the Enterprise Identity file.
• Working wif Architects of multiple source systems and from Service now in identifying the requirements and assisting in creation of Mapping document
• Develop the High Level, Low Level design documents, Job Linkage Diagrams, Data Model Diagrams etc.
• Decide on the ETL Architecture to be used for generation of the Enterprise Identity files - Data Transformation vs. Power Center.
• Lead a team of five developers from offshore while assisting the team in developing the mappings and scripts along wif the Nonfunctional Requirements (NFR) components like Restartability, pre-check, duplicate file check and post balancing check, empty file check to improve data quality and Integrity between the systems.
• Review code, performance, standards and accuracy of the code developed by the team.
• Develop and Implement jobs in TWS, deliver SDLC documents, conduct reviews and walkthroughs, test sign off and manage deliverables.
• Follow change management process and perform Informatica Code, Data Map and UNIX code migration from lower environment to production.
• Lead both offshore and onshore team, work hand in hand wif offshore team for round the clock support, has daily calls to delegate tasks and updating them about the progress/next steps of the project

Environment: Informatica Power Center 9.1, Data Transformation, Red Hat Linux (Tikanga), TWS, PowerCenter Designer, Repository Manager, WorkFlow Manager, WorkFlow Monitor, Mainframe, PeopleSoft .

Confidential

Responsibilities:

• Identifying the source systems involved in generating the Partner Fund file.
• Working wif data analyst in identifying the different available source systems and their inter dependency.
• Working wif Business System Analyst in documenting the user requirements.
• Setting up meeting wif business in understanding the requirements and help identifying the easiest layout for the business understanding.
• Design a fault tolerant system to overcome if any manual mistakes are done in updating the table.
• Develop the Informatica mappings and the analyst interface to satisfy the business needs.
• Walk the business through the tool in getting hands on experience of the tool and make the business comfortable wif the tool.
• Review code, performance, standards and accuracy of the code developed by the team.
• Develop and Implement jobs in TWS, deliver SDLC documents, conduct reviews and walkthroughs, test sign off and manage deliverables.
• Follow change management process and perform Informatica Code, Data Map and UNIX code migration from lower environment to production.
• Lead both offshore and onshore team, work hand in hand wif offshore team for round the clock support, has daily calls to delegate tasks and updating them about the progress/next steps of the project.

Environment: Informatica Power Center 9.1, Analyst Tool, Red Hat Linux (Tikanga), TWS, PowerCenter Designer, Power Exchange, Repository Manager, WorkFlow Manager, WorkFlow Monitor, Mainframe, PeopleSoft .

Lead Informatica Developer

Confidential -Minneapolis, MN

Responsibilities:

• Working wif Data Architects and Business explaining the data model diagrams
• Identifying key fields in all the warehouse tables which the business wanted to validate.
• Writing validation scripts wif 250+ queries to validate the differences between the tables in older environment and newer environment.
• Analyzing the dependency of ETL code and modifying the code to adapt to newer environment.
• Installing Teradata client along wif components such as MLOAD and BTEQ on the new ETL servers.
• Validate the complete data in all the warehouse tables after NPARC using the pre written scripts
• Executing the entire batch in both the environments after the initial data migration.
• Validating the entire warehouse data after the load in lower environments using the pre written scripts.
• Upgrading the code to production and running the code in parallel for 10 batches.
• Providing the daily comparison results to business and notifying them in case of differences.

Environment: Informatica Power Center 9.1, Teradata 13, Teradata 12, Red Hat Linux (Tikanga), Unix AIX, TWS, Control-M, PowerCenter Designer, Power Exchange, Repository Manager, WorkFlow Manager, WorkFlow Monitor, Mainframe, XML.

Lead Informatica Developer/Tech Lead

Confidential -Minneapolis, MN

Responsibilities:

• Identify dependency and group applications by phase to define timeline for migration.
• Prepare plan where Informatica and Schedule migration (Control M-TWS) happens at same time to reduce cost and time.
• Take the back up of Informatica repository and restore them in new 9.1 DB servers. Create connection strings, db2 catalogs and implement firewall changes.
• Change script, pram files and all hard coded values according to 9.1 servers, Copy all session persistent or batch values like sequence number to the migrated session.
• Create new job stream, new jobs in TWS, ensures properties of the jobs are maintained by doing regression testing. Also create new event rules in TWS for better monitoring.
• Develop additional scripts/Informatica workflows which are required in order to meet the operational need. Regression testing in lower environment for schedule testing and performance testing.
• Perform Informatica Code, Data Map and UNIX code migration from one environment to another environment including Production and do post validation.
• Perform dry run testing (pre prod) to ensure schedules are correct and all dependencies are resolved and jobs are triggering automatically in new scheduler.

Environment: Informatica Power Center 9.1, Teradata, Red Hat Linux (Tikanga), Unix AIX, TWS, Control-M, PowerCenter Designer, Power Exchange, Repository Manager, WorkFlow Manager, WorkFlow Monitor, Mainframe, XML, Oracle, DB2, SQL Server.

Informatica EDW Developer

Confidential

Responsibilities:

• Perform Analysis, Design, Build, Testing, implementation and warranty support and respective deliverables and coordination wif all cross commit teams.
• Analyze business need and identify dependency system, create data mapping sheet.
• Engage data architects and come up wif DML diagram wif different core, alternate, surrogate key, Look up, Master load, CHECK SUM and relationship tables.
• Create all above tables, SET and MULTISET tables in Teradata based on the type of data.
• Develop PWX data map and Informatica mapping to read VSAM files and dump into flat file.
• Develop Teradata BTEQ, Teradata FAST load, Informatica mapping, Teradata MLOAD to extract and dump into stage table.
• Create and Maintain STAGE, CHECKSUM and Warehouse tables. Implement appropriate INDEXES, Primary keys, Constraints, Collect Stats.
• Identify the type of record, calculate checksum value for key columns and load them into stage table. Use dis checksum value to look up on the respective CHEKSUM table (and update record type (whether the record is new or changed) in the STAGING table.
• Load CHECKSUM table using Teradata MLOAD wif only Primary key, ROW START DATE and Checksum value. Develop BTEQ, MLOAD, Informatica mapping to load Warehouse table based record type on staging table whether INSERT or UPSERT. Maintain ROW END DT to define the record is active or not active.
• Implement table partition, DROP INDEX AND RECREATE INDEX, SET Theory, Multi statements, Collect stats and Teradata Multi statements to improve performance.
• Develop Unix Shell scripts, Informatica workflows, sessions, mappings, transformations, mapplets, and reusable transformations, utilize appropriate caches and performance techniques.
• Develop Materialized views and Data Marts for business analytical reporting.
• Optimizing Materialized view generation to reduce the entire run time of Materialization.
• Fixing the numerous non issues and code bugs to reduce data quality issues.
• Develop and Implement jobs in Control M, deliver SDLC documents, conduct reviews and walkthroughs, test sign off and manage deliverables.
• Implement Sweep processing, auditing, job restartability, pre check, duplicate file check, and post balancing check, empty file check to improve data quality and Integrity

Environment: Informatica Power Center 9.1, Teradata 13, Teradata 12, Red Hat Linux (Tikanga), Unix AIX, TWS, Control-M, PowerCenter Designer, Power Exchange, Repository Manager, WorkFlow Manager, WorkFlow Monitor, Mainframe, XML.

Informatica Developer

Confidential

Responsibilities:

• Data analysis on any data issues reported by business
• Fixing of any scheduling issues or code issues which result to any frequent failures in production and thus reducing the effort spent by Production Support
• Optimization of long running jobs using various optimization techniques to help the batches meet the SLA.
• Making certain code changes as part of business requirements to allow continuity of code and the application.
• Assisting the production support in case of any recoveries for any critical batches.
• Making modifications to the existing code so that they are adherent to the balancing and control standards.
• Modifying the existing code to ensure restartability.

Environment: Informatica Power Center 9.1, Teradata, Red Hat Linux (Tikanga), Unix AIX, TWS, Control-M, PowerCenter Designer, Power Exchange, Repository Manager, WorkFlow Manager, WorkFlow Monitor, Mainframe, XML, Oracle, DB2, SQL Server.