PROFILE:

• Seasoned IT professional with proven technical skills. More than 13 years of experience in information technology, with 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 InformaticaPowerCenter 9x/8x security, general administration upgrades. Extensive exposure to Informatica client/server installation procedure, 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 with 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:

WORK EXPERIENCE:

Confidential

Senior Informatica Developer/admin - Architect

• Setup of Informatica Environment and its upgrade.
• Sandbox testing of the tool.
• Setup of Best Practices Standards in line with 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 with them to rerun the job and ensure the completion of the load.
• Coordinate with 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 with us.
• Help the project in their design documents for the ETL process.
• Consult the project for the ETL Best Practices.
• Coordinate with different business groups for their resource needs and help them in design development of the project.
• Work with the project group to identify the process bottlenecks and helping the Project to an amicable solution.

Environment: Informatica Power Center 9x Informatica Power Exchange 9.1HF4, Oracle 11g, PL/SQL,

Confidential

Senior Informatica Admin/Architect

• 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, help 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 thereby 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 with DT tool.
• Used parallel processing capabilities, Session-Partitioning and Target Table partitioning utilities.
• Developed the production support technical documents.
• Conduct status meetings with project managers, escalate issues when necessary, conducting meetings for issues resolution
• Interacted with 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, 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

Senior ETL Informatica Developer

Responsibilities:

• Optimization/performance tuning techniques implemented to identify bottlenecks- Query tuning Explain Plan, SQL Trace , table partitioning, memory tuning and cache management.
• Experienced in writing Queries against DB2 on AS400 Environment.
• SQL Loader scripts for bulk data loads to Oracle tables and extracting Oracle dumps from Verizon.
• 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 then loaded into the inhouse DPI Billing system.
• Responsible for gathering Business requirements and translate into technical requirements.
• 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 exchange8.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

Job Title: Administrator / Lead Informatica Developer

Responsibilities:

As an Informatica Administrator:

• Setup of Informatica Environment and its upgrade.
• Sandbox testing of the tool.
• Setup of Best Practices Standards in line with Cephalon, Inc. 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 with them to rerun the job and ensure the completion of the load.
• Coordinate with 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 with us.
• Help the project in their design documents for the ETL process.
• Consult the project for the ETL Best Practices.
• Coordinate with different business groups for their resource needs and help them in design development of the project.
• Work with the project group to identify the process bottlenecks and helping the Project to a amicable solution.

As an Informatica Lead Developer:

• Developing Informatica codes for different business groups within 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 with DBA in discussing building tables and schemas according to the technical and functional requirements.
• Created mapplets for Audit fields so that 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

Job Title: ETL Administrator/ Team Lead

Responsibilities:

As an Informatica Administrator:

• 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 with 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 with 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 with us.
• Help the project in their design documents for the ETL process.
• Consult the project for the ETL Best Practices.
• Coordinate with the projects for their resource needs and help them in recruitment and development of an ETL Developer.
• Participate in the bi-weekly staff meetings to review the status of the group.
• Work with the project group to identify the process bottlenecks and helping up the Project to a resolution.
• Help the management in the initial technical talks with the prospective project groups and workout a plan for the initiation of the project.
• Participate with 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.