SUMMARY

• Seasoned IT professional wif proven technical skills. More than 15 years of experience in information technology, wif specific focus on Data Architecture, Data Modeling, Data Conversion, Testing, design & implementation of large scale data warehouse, creation of data marts on various databases & operating systems.
• Proficient in Informatica PowerCenter 9x/8x security, general administration, migration & upgrades. Extensive exposure to Informatica installation in HA & Grid environments, updates and performance tuning.
• Extensive exposure to data extraction, conversion & loading from various sources including flat files, Oracle & SQL Server, DB2, Syndicated File System (IMS) and, SWIFT, HL 7 and EDI - X12 flat files. Adherence to and compliance of Business rules like HIPAA and SOX.
• Data warehousing concepts, star-schema & snowflake design (Inmon and Kimball), ETL & BI processes.
• Hands on experience in all aspects of software development life cycle (SDLC), including process flow diagram and process designing experience wif UML. Well versed in testing (like Unit, Integration, System and Performance testing).Excellent communication and interpersonal skills, ability to coordinate and motivate team members. Ability to conceptualize, document and communicate project ideas and plans.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter 9x/8xPower Connect and Power Exchange, Power Mart 6.x/5.1, PowerCenter Data Analyzer Mart 6.x/5.1, SQL Server 2005 Integration Services (SSIS).SSRSData modeling Tools Erwin 4.2, Dimensional Data Modeling, Star Schema Modeling, snow-Flake Modeling, Fact and Dimensions Tables.

RDBMS: Oracle 10g/9i/8i, SQL Server 2005, Teradata,DB2, Flat files, XML and MQ COBOL Files

Web Technologies: HTML, Java, JavaScript, Oracle MapViewer,JDBC, XML, XHTML,Web services, Dataflux

Programming Languages: SQL, PL/SQL and Shell Scripting.

Data Warehousing Methodologies: Dimensional modeling - Star schema, snow flake schema

Reporting Tools: COGNOS, Crystal Reports2008/XI R2, OBIEE 10.1.3.x, Siebel Analytics 7.5/7.7/7.8, Oracle BI Services, Oracle CRM on Demand.

Other Tools & Utilities: SQL * plus, Toad, SQL Server2005 SSIS, MS SQL Server Reporting Services (SSRS), AutoSys, Microsoft Visio, Clear case, Text Pad

Scripting Languages: Shell Scripting, Perl Scripting

Operating Systems: Windows 2008R2/XP/NT, UNIX (Sun Solaris, Linux, HP-UX), AIX

PROFESSIONAL EXPERIENCE

Confidential, Hoboken, NJ

Senior Informatica Lead

Responsibilities:

• Responsible for client interaction, daily status update to client.
• Preparing the weekly status update deck for weekly meeting.
• Managing development tracker for each projects.
• Providing value addition and process improvement plans to client.
• Responsible for Metrics management for the project.
• Requirement Study, Estimation and realizing business logic.
• Technical Design of different modules.(using Best Practices)
• Design of Power Center mappings (Informatica version 9.6.1) and workflows.
• Leading a group of 8 people (6 offshore resources & 1 on site).
• Finalizing the delivery templates (e.g. Functional Doc., Technical document, Unit testing document).
• Establishing the processes and the environments.

Confidential

Senior Informatica Admin/Architect

Responsibilities:

• Setup of Informatica Environment and its upgrade.
• Sandbox testing of the tool.
• Setup of Best Practices & Standards in line wif State Department and Velocity methodology
• Keep the Informatica service up and running for Dev., TEST and Production environments.
• Monitor the production jobs at regular intervals to ensure smooth running and proper completion of the jobs.
• In case of a job failure on the Informatica side, notify the user groups and work wif them to rerun the job and ensure the completion of the load.
• Coordinate wif different administrative services (like DBAs) for the upkeep of the environment.
• Create and maintain user accounts and folders for all the new projects who want to use the services of the group.
• Help projects in setting up the Informatica environment wif us.
• Help the project in their design documents for the ETL process.
• Consult the project for the ETL Best Practices.
• Coordinate wif different business groups for their resource needs and halp them in design & development of the project.
• Work wif the project group to identify the process bottlenecks and halping the Project to an amicable solution.

Environment: Informatica Power Center 9x Informatica Power Exchange 9.1HF4 HA/Grid, Oracle 11g, PL/SQLAIX 6.1, CA DATACOM, OZ/390.

Confidential ., Wilmington, DE

Senior Informatica Admin/Architect

Responsibilities:

• Involved in gathering and reviewing business requirements. Involved in Designing the specifications, Design Documents, Data modeling and design of data warehouse.
• Resolved the issues Remedy Tickets on Priority basis.
• Creating SR to Informatica Inc.- related to any Power center Suite product issues.
• Performed Upgrading Informatica Power center Version 8.x to Informatica Power center 9.X and moving to different MetLife Data Centers. Created SOPs, SLA and IQ/OQ process and documentations.
• Setup of B2B Environment for the processing of HIPAA, SWIFT, HL 7 and EDI-X12 type of files.
• Involving Testing, Debugging, Validation and Performance Tuning of data warehouse, halp develop optimum solutions for data warehouse deliverables.
• As per Fulfillment requests (FR) migration of objects in all phases (DEV, QA and PRD) of project and trained developers to maintain systems.
• Maintain all necessary updates and patches for the ETL environments.
• Creates and maintains all databases required for development, testing, education and production usage.
• Involved in the capacity planning requirement to create and maintain the databases.
• Monitoring the Jobs and sever space availability and CPU Process.
• Preparing Procedures for related Informatica issues.
• Created Logical & Physical models and used Erwin for data modeling and Dimensional Data Modeling.
• Created complex mappings in Power Center Designer using Expression, Filter, Sequence Generator, Update Strategy, Joiner and Stored procedure transformations.
• Modeling and populating the business rules using mappings into the Repository for Meta Data management.
• Involved in the development of Informatica mappings and also performed tuning for better performance. Schedules Informatica B2B Data Transformation.
• Designed and developed sophisticated workflows and data transformations involving Informatica B2B components DX (Data Exchange) and DT (Data Transformation).
• Extensively worked on tuning (Both Database and Informatica side) and theirby improving the load time.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Setting up sessions to schedule the loads at required frequency using Power Center, Workflow manager, PMCMD and also using scheduling tools.
• Converting unstructured data into an XML format. Used DTs to build platforms, scheduled the workflows wif DT tool.
• Used parallel processing capabilities, Session-Partitioning and Target Table partitioning utilities.
• Developed the production support technical documents.
• Conduct status meetings wif project managers, escalate issues when necessary, conducting meetings for issues resolution
• Interacted wif Lead Developers, System Analysts, Business Users, Architects, Test Analysts, Project Managers and developers to analyze system requirements, design and develop software applications.
• Created new extracts for external vendors and use Informatica ETLs for new workflows to move data out of multiple data sources.
• Unit test coding changes, fill out required documentation such as installation instructions, and follow standards and procedures.
• Provided Tier l support duties for Informatica Production Support, including off hours and weekends. Keep the Production Support team management informed of any issues or concerns. New development and support task responsibilities.
• Environment: Informatica Power Center 9x/8.6 GRID, Power Exchange, B2B, MFT, DT,AS400, SQL 2008 R2, SQL 2005, Erwin 4.0, SQL, PL/SQL, T SQL, TOAD, Active Batch, Power Shell, COGNOS 8.5.

Confidential, Rochester, NY

Senior ETL Informatica Developer

Responsibilities:

• Responsible for gathering Business requirements and translate into technical requirements.
• Involved in translating the functional requirements into technical mapping specifications and leveraged Informatica Power Center 8.6.1 to extract the data from AS/400 DB2 files, Oracle tables and flat files to populate billing, service order and plant interface files, which are tan loaded into the in-house DPI Billing system.
• SQL*Loader scripts for bulk data loads to Oracle tables and extracting Oracle dumps from Verizon.
• Experienced in writing Queries against DB2 on AS400 Environment.
• Optimization/performance tuning techniques implemented to identify bottlenecks- Query tuning (Explain Plan, SQL Trace), table partitioning, memory tuning and cache management.
• Expertise in debugging and production support.
• Experience in writing Shell scripts for file manipulation, extraction and execution of Workflows
• Extensive use of the STRSQL, AS/400 Query facilities in AS/400 and execution of SQL queries using PL/SQL Developer 7.1.0 and also used SQL Loader efficiently to load large volumes of flat file data.
• Developed mappings/sessions using Informatica Power Center 8.6.1 / Power exchange 8.5.1 for data loading.
• FTP scripts and Extraction of Unstructured Data from various Verizon Data formats using Perl/Shell Scripts. XML/flat file formats also extracted successfully.
• Responsible for managing Informatica Services like Repository Service, Integration Services, etc.
• Designed and developed error handling and rekey mechanism in Informatica
• Monitored daily loads and provided on call production support (L2) during data Loads.
• Creating Change Control Requests as required by assigned projects and ensuring end to end extensive support as Data Analyst and address overall data quality, including the design of ETL strategies to source, match a Merge from various disparate systems.
• Installation & configuration of Informatica services for 64 bit OS.
• Created repository & assigned grants to users to access the repository.
• Experienced in creating xsds and landing XML extracts.

Environment: ETL/Informatica PowerCenter 8.6.1/8.5.1, Informatica Power Exchange 8.6, Oracle 11g, PL/SQL, Telecordia,XML,Flat files, UNIX, Toad, SQL Developer, VSAM, CSV, XML files,AS400, DB2, Perl,Shell Scripting.

Confidential, Frazer, PA

Administrator / Lead Informatica Developer

Responsibilities:

• Setup of Informatica Environment and its upgrade.
• Sandbox testing of the tool.
• Setup of Best Practices & Standards in line wif Confidential . and Velocity methodology
• Keep the Informatica service up and running for Dev., TEST and Production environments.
• Monitor the production jobs at regular intervals to ensure smooth running and proper completion of the jobs.
• In case of a job failure on the Informatica side, notify the user groups and work wif them to rerun the job and ensure the completion of the load.
• Coordinate wif different administrative services (like DBAs) for the upkeep of the environment.
• Create and maintain user accounts and folders for all the new projects who want to use the services of the group.
• Help projects in setting up the Informatica environment wif us.
• Help the project in their design documents for the ETL process.
• Consult the project for the ETL Best Practices.
• Coordinate wif different business groups for their resource needs and halp them in design & development of the project.
• Work wif the project group to identify the process bottlenecks and halping the Project to an amicable solution.As an Informatica Lead Developer:
• Developing Informatica codes for different business groups wifin the company.
• Unit and Integration testing of the Informatica workflows, jobs/processes.
• Working in different Projects (ASRS, CCO, CONCUR, ACR) from the scratch and was involved in the SDLC Process.
• Worked ODS and moved data to Oracle data marts.
• Conversion process by extracting data from SQL Server and loading it into Oracle tables according to business logic and FDA regulations/guidelines.
• Involved wif DBA in discussing building tables and schemas according to the technical and functional requirements.
• Created mapplets for Audit fields so dat they could be used in all the conversion mappings for row inserts and row updates.
• Converted stored procedures and triggers which were used in the SQL Server into ongoing ETL codes/processes.

Confidential . West Point, PA

ETL Administrator/ Team Lead

Responsibilities:

• Keep the Informatica service up and running for Dev., QA, IT and Production environments.
• Monitor the production jobs at regular intervals to ensure smooth running and proper completion of the jobs.
• In case of a job failure on the Informatica side, notify the user groups and work wif them to rerun the job and ensure the completion of the load.
• Maintain the Informatica environment and support the project groups in moving their jobs to Production after the development and testing are completed.
• Coordinate wif different administrative services (like DBAs, Mainframe Admins, and Unix Admins) for the upkeep of the environment.
• Install and implement the upgrades available for the environment as needed for things like Oracle upgrade, UNIX O/S upgrade or Informatica version upgrade and Detail Driver upgrades after proper testing.
• Create and maintain user accounts and folders for all the new projects who want to use the services of the group.
• Help projects in setting up the Informatica environment wif us.
• Help the project in their design documents for the ETL process.
• Consult the project for the ETL Best Practices.
• Coordinate wif the projects for their resource needs and halp them in recruitment and development of an ETL Developer.
• Work wif the project group to identify the process bottlenecks and halping up the Project to a resolution.As a member of USHH DSS and CoE group:
• Participate in the bi-weekly staff meetings to review the status of the group.
• Help the management in the initial technical talks wif the prospective project groups and work out a plan for the initiation of the project.
• Participate wif the DBAs in finalizing the Data Warehouse Architecture and Data Modeling.
• Preparation and documentation of Merck SLC for Informatica (ETL) environment.
• Approving of the IRDs.
• Created On-Demand, Cached and Real-time reports.
• Hands on experience on Dashboards, Indicators and Filters.

Confidential, Dublin, OH

System Administrator/Sr. ETL Developer

Responsibilities:

• Worked in the OIU RDBMS Project from the scratch and was involved in the SDLC Process.
• Worked on SPD, PD Data Marts on ODS (Operational Data Store) and DDS (Definitional Data Store).
• Did conversion process by extracting data from SQL Server and loading it into Oracle tables according to business logic.
• Involved wif DMG in discussing building tables and schemas according to the technical and functional requirements.
• Created mapplets for Audit fields so dat they could be used in all the conversion mappings for row inserts and row updates.
• Converted stored procedures and triggers which were used in the SQL Server into ongoing ETL process.
• Did Ancillary Maintenance of ODS by purging inactive accounts according to business rules.
• To maintain consistency between the ETL process and another application hitting the same database used Stored Procedures for generating sequence numbers.
• Developed Unit Test cases for all the mappings me created before going to the testing phase.
• In the testing phase, conducted string and parallel testing to see if the records match wif the production data.
• Logged defects using Test Director.
• Doing support work as the project is due for the final release shortly.
• Created custom tailored reports for our esteemed customers.
• Extracted source from Teradata and written to flat files according to RDD and Ftp’d to the customer.
• Written SQL Overrides to filter records according to customer needs.
• Created parameter and variable mappings to run the custom generated mappings according to the RDD.
• Written UNIX Scripts to FTP custom reports to the customers automatically crossing the Firewall of Confidential after they are scheduled to run.
• Used Post Session commands to execute Shell Scripts and to write the output file to .CSV, .TXT according to the RDD and to create header and to append it the output file.
• Did uniting testing on Teradata SQL Assistant to verify if the session output matches wif the sql query result.
• Did customer support work for the custom reports running in Production.

Environment: Informatica PowerCenter 6.2/6.1, Oracle 9i, Teradata 6.1, Flat Files, HP-UX, Windows XP

Confidential

System Analyst

Responsibilities:

• Developed New Product Module. This module enables users to enter information through HTML forms, which will call Servlets to store data in database.
• Dealt wif enhancement and customization of User Autantication Module by integrating custom autantication rules wif the existing application.
• Involved wif content customization. Customization is achieved through maintaining the information in properties files. JSP files will pick up the information from these files.
• Involved in testing.
• Involved in reporting and fixing of bugs.
• Created Point of Sale (POS) interface using VB6.0 as front end and Access database as backend.
• Created and maintaining Inventory Management System.

Environment: JSP, Servlets, Java Beans, Java Scripts, JRUN 3.0, MS Access 2000, ORACLE 8i, SQL Server, Windows NT 4.0, Sun Solaris.