SUMMARY

• Informatica Certified Designer with over 15 years of IT experience in system analysis, design, development, testing and maintenance
• Over 12 years of Technical and Functional experience in Decision Support Systems - Data Warehousing and ETL (Extract, Transform and Load)
• Over 2 years of experience working with Business Intelligence/OLAP Tools such as Business Object and Crystal Reports
• Proficient in databases including Oracle, Teradata, Sybase, MS-SQL server
• Extensively worked on data extraction, transformation, loading with Oracle, Teradata, Sybase and MS-SQL Server using Informatica
• Experience with installation of PowerCenter 8.x/8.6.x/9.x/ 9.5.1/9.6.1 , IDQ 9.5.1/9.6.1 and Metadata Manager 8.6.1
• Expert understanding of Star schema and Snow flake schema
• Knowledgeable in OLAP concepts and experience in generating various reports according to business needs using Business Objects, Crystal Reports
• Experience in SQL, T-SQL, SQL *Plus, BTEQ, PL/SQL Procedures/Functions, Triggers and Packages
• Experience in programming using Shell scripting, PERL, C language, Python
• Familiarity with MicroStrategy Developer, Architect & Administrator building projects and creating drilldown reports and Dashboards using MicroStrategy 10.0
• Experience with TOAD and DBArtisan as an interface to databases, to analyze, view and alter data
• Experience in Software Development Life Cycle (SDLC) involving requirement gathering, designing, implementing and testing
• Experience in build and release management as well as product life-cycle management
• Team Player and Self Starter with excellent communication and interpersonal skills
• Ability to adapt quickly to challenges and changing environments
• Recognized as a creative and practical problem-solver
• Ability to coordinate multiple projects and meet deadlines under pressure

TECHNICAL SKILLS

RDBMS: Oracle (7.x/8.x/9i/10g/11g/12c), Teradata (7.1) Sybase-(11.x/ASE-12x), SQL Server 2005

ETL Tools: Informatica Power Center (10.1/9.6.1/9.5. x/9.x/8.x/7.x/6.2/5.1), Power Mart 4.5

Data Quality Tools: Informatica Data Quality 9.5.1/9.6.1

B2B: Informatica B2B Data Transformation, B2B SWIFT Libraries

Reporting / Analysis Tools: Business Objects-5x, Crystal Reports-9.0, MicroStrategy 10

RDBMS Tools: MLoad, FastExport, SQL *Loader, TOAD 7.6, Teradata SQL Assistant 7.1.0, Teradata Administrator 7.1.0, Embarcadero DBArtisan 8.x, SQL Server Management Studio 9.x

Data Mining: SPSS Clementine 7.0

Languages: Perl, C, C++, PL/SQL, SQL, UNIX shell scripting, BTEQ, Python

Methodologies: Kimball, Inmon, CRISP-DM, RUP, AGILE

Operating Systems: RHEL 5.3, UNIX, HP-UX, AIX, Windows 9x/NT/2000/XP

Project Management Tools: MS-Project

Release Management Tools: Mercury Quality Center 9.0

Other Tools: Erwin-3.x/4.x,Visible Analyst Workbench, Microsoft Visio

Scheduling Tools: Autosys, Control-M, Tidal

Source Control: Perforce, ClearCase, Visual SourceSafe

PROFESSIONAL EXPERIENCE

Confidential

Informatica Architect

Responsibilities:

• Defined the end-to-end architecture for the ETL Plant to support the new Prime Reporting Platform (PRP)
• Defined best practices for ETL code development, orchestration and deployment
• Defined the logistics/format of data flow from various source systems into PRP
• Worked with different source systems to procure data in the format defined for PRP
• Designed the Orchestration Framework responsible for handling the end-to-end daily DW load and report generation
• Involved in discussions related to the Client Portal functionality for viewing/regenerating/redistributing reports
• Involved in data modeling decisions for the DW STAR Schema and ETL Control Schema
• Developed the Informatica batch to consume real-time Customer Data(XML messages) from TIBCO queue
• Developed the Informatica batch to consume real-time Securities Data(JSON messages) from TIBCO queue
• Designed and developed the framework for SWIFT message generation and distribution using PowerCenter Webservice Hub and B2B DT SWIFT libraries
• Developed various Informatica processes to load Geneva RSL files, Pricing files, Options data files into the DW
• Developed the mapping for SWIFT messages using B2B DataTransformation (MT535, MT536, MT940, MT950, MT900, MT910) and integrated it with PowerCenter
• Developed PowerCenter JAVA transformation to process data returned by an Oracle Cursor Object
• Coordinated with various Infrastructure teams to setup the infrastructure to support PRP DW
• Defined the Infrastructure requirements for Informatica HA/Enterprise Grid setup
• Defined the Unix Security requirements for Functional(Application/SFTP) and regular Users
• Defined the DB requirement to setup Informatica PC/IDQ/Metadata Manager
• Installed and configured Informatica PowerCenter/IDQ/Metadata Manager version 9.6.1(HF2)
• Responsible for Administration/Patching of DEV/SIT/UAT/PROD environments
• Applied the HF3 to DEV/SIT/UAT/PROD environments
• Configured PowerExchange for JMS to read/write to TIBCO queues
• Configured PowerExchange for MongoDB to read/write to MongoDB
• Performed code migrations from SIT to UAT and Productions repositories
• Worked with Informatica support to resolve issues related to the Informatica plant
• Developed and implemented the necessary framework to support scripted deployment of Informatica objects using deployment groups
• Created supports scripts for backing up Informatica Domain and Repository information, truncating sessions logs and updating Repository tables statistics
• Created autosys jobs to schedule various Informatica PC flows, Scripts and other maintenance batches
• Created POC to Update from version Informatica 9.6.1 to Informatica 10.1
• Environment: Oracle 11g, Informatica 9.6.1/10.1, IDQ 9.6.1/10.1, RHEL, Oracle SQL Developer, TOAD, MicroStrategy 10, Mongo DB

Confidential

Informatica Engineer/Administrator/IDQ Developer

Responsibilities:

• Responsible for Administration of PowerCenter Plant, and apply hotfix’s/upgrades as needed
• Performed multiple upgrades (9.1.0 to 9.5.1 to 9.6.1)
• Installed and configured IDQ 9.5.1/9.6.1
• Migrated the PowerCenter Plant from Solaris to Linux
• Created profiles, profile rules, scorecards, reference tables using Developer and Analyst tools
• Implemented error handling framework using Human Task workflow
• Configured PowerCenter to consume data from Excel files and Access Databases using Sequelink
• Used HTTP transformation to read data files from SharePoint
• Used Web Services consumer transformation to request and consume data from Bloomberg
• Configured PowerExchange for JMS to post messages to a Topic
• Setup password less authentication with various third party data providers for file transfer
• Setup Informatica Administrator console to use Federal Reserve Information Technology Certificates
• Performed code migrations from development to QA and Productions repositories
• Worked with Informatica support to resolve issues related to the Informatica plant
• Defined best practices for ETL code development, orchestration and deployment
• Developed and implemented the necessary framework to support scripted deployment of Informatica objects using deployment groups
• Created supports scripts for backing up Informatica Domain and Repository information, truncating sessions logs and updating Repository tables statistics
• Assisted Application development team in design decisions for various projects

Environment: Oracle 11g/12c (ASO enabled), Informatica 9.1.0/ 9.5.1/9.6.1 , IDQ 9.5/9.6.1, Solaris 10, RHEL, Oracle SQL Developer

Confidential

Lead ETL Engineer

Responsibilities:

• Created project plan for Informatica upgrade from 8.6.1 to 9.5
• Created POC environment to upgrade 8.6.1 to 9.5
• Involved in POC to evaluate Hadoop integration with Informatica 9.5.1
• Developed scripts to parse Informatica session log files and provide information to aid in performance tuning Informatica batch processes
• Reviewed existing Informatica processes and suggested performance/process improvements
• Supported Application development team with Performance issues related to Informatica batch processes
• Participated in design discussions for new ETL processes

Environment: IBM DB2, Teradata, Informatica 8.6.1/9.1.0/9.5/9.5.1 , RHEL 5.3, IBM DB2 Client, Tivoli

Confidential

Technical Lead - Informatica

Responsibilities:

• Collaborated with Dean stakeholder to devise and create project charter, test plan, and project strategy and obtain sign-off for Informatica Upgrade
• Conducted a technical assessment to ascertain the list of necessary deliverables considered in scope for the upgrade
• Devised and completed project plan definition including effort estimation and resource/department assignment responsibilities
• Completed Version Control assessment and reported recommendations to Confidential .
• Completed high-level mapping impact assessment - identifying potential areas that could affect the upgrade.
• Defined a test plan including testing strategy and environment management strategy during the upgrade to limit extended periods of downtime to any one environment.
• Identified and uncovered potential risks and issues with existing environment setup, code assets, and processes that may be encountered during upgrade by conducting in-depth interviews with project resources
• Reviewed and established Informatica best practices
• Transitioned knowledge to Dean staff to make informed, knowledgeable decisions related to ETL in the future
• Acted as a technical lead and testing lead throughout the duration of the project by providing oversight

Environment: Oracle 11g, Informatica PowerCenter 8.1.1/9.1.0 , AIX 5.3, Oracle SQL Developer, Autosys

Confidential

ETL Architect

Responsibilities:

• Preliminary system review to fully understand existing ETL architecture and suggest system improvements
• Upgraded Informatica from 8.6.1 to 9.1.0 and performed regression testing of all batch processes
• Created and implemented a monitoring framework for Informatica environment to help pro-actively identify potential issues, system failures and degradation in performance
• Reviewed existing Informatica processes and suggested performance/process improvements
• Set up Reporting services to create and schedule reports based on management requirements
• Developed and implemented the necessary framework to support scripted deployment of Informatica objects using deployment groups
• Developed scripts to parse Informatica session log files and provide information to aid in performance tuning Informatica batch processes

Environment: Oracle 11g, Informatica PowerCenter 8.6.1/9.1.0 AIX 5, TOAD for Oracle, TIDAL

Confidential

ETL/Informatica Admin & Architect/Project Coordinator

Responsibilities:

• Developed and incorporated Data warehousing best practices and standards
• Involved in the high level design of the data warehouse architecture and the DR strategy
• Involved in project planning and budgeting for Hardware requirements
• Responsible for estimating the SAN and NAS requirements for various environments
• Installed and Configured Informatica PowerCenter 8.6.1 and Metadata Manager 8.6.1, and applied HotFix patches to Development, UAT, Production and DR environments
• Responsible for Administration of PowerCenter and Metadata Manager
• Setup appropriate ETL administration best practices and procedures
• Implemented and maintained the Informatica Enterprise Grid option to provide seamless failover and recovery
• Responsible for maintaining the Metadata Manager Repository and loading metadata from various sources, such as Oracle, Erwin, PowerCenter, etc.,
• Created supports scripts for backing up Informatica Domain and Repository information, truncating sessions logs and updating Repository tables statistics
• Created POC to use JMS powerexchange to read real-time data feeds
• Coordinated with various teams to set up Development, UAT, Production and DR environments
• Responsible for build and release management using Mercury Quality Center 9.0
• Support Deployment of application code across various environments

Environment: Oracle 11g, Informatica PowerCenter RT 8.6.1(64 bit) with Enterprise Grid Option on RHEL 5.3, Metadata Manager 8.6.1, Embarcadero ER Studio, DBArtisan 8.x, ClearCase, MQC 9.0, AutoSys

Confidential

Sr. Data Warehouse Consultant

Responsibilities:

• Involved in preparing detailed ETL design documents
• Responsible for the administration of the Informatica 811 environment through Informatica Admin Console
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval
• Created Support Documents to ensure off-shore Support Teams had adequate knowledge to support the daily loads

Environment: Oracle 10g, Informatica PowerCenter 8.1.1, Embarcadero ER Studio, DBArtisan 8.x, Perforce P4v, MS SharePoint, Altova XML Spy

Confidential

Team Lead/ETL Architect

Responsibilities:

• Collected business requirements from end users, analyzed the requirements to understand the feasibility and the impact of the change, if any
• Created and maintained the technical specification documentation based on the business requirements
• Involved in project task prioritization, planning, estimation and work assignment
• Prepared the two week development plan and provided daily status reports to the project manager
• Extensively used various transformations on Informatica including lookups, Stored Procedures, Update Strategy, Transaction Control, etc.
• Responsible for overseeing the deployment of code from Development to Test and then to Production environments

Environment: MS-SQL Server 2005, Informatica PowerCenter 8.1.1, Cygwin, MS-SQL Server Management Studio, DBArtisan 8.x, Visual Source Safe 8.x, MS SharePoint, Altova XML Spy, Regulator(Regex Generator)