Informatica developer

SREENI

*********@*****.*** Cell: 860-***-****

** ***** ** ***** ** experience in in phases of the software development lifecycle (SDLC) like business requirement gathering, Application design, development, testing, project implementation and post implementation support. 6 years of experience in Data warehousing and ETL Using Informatica power center 8.6/9.1.0/9.5.1. Business Analysis experience on Data Analysis, User Requirement Gathering, User Requirement Analysis, Gap Analysis, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis.

Education

Master of Technology (M. Tech) in Engineering,

Bachelor of Technology (B. Tech) in Engineering

training

Data ware house & Informatics, Data Modeling Concepts

SAP Basis

Professional Experience Summary

6 years of experience in development of Data warehouse using Informatica.

Strong Data Warehousing ETL experience of using Informatica 9.5.1/9.1.0/8.6

PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools – Informatica Server, Repository Server manager

Exposure to Data Warehousing Design development, implementation and Implementation of data warehousing projects.

Efficient in Performing data cleansing, scrubbing and validating the data before loading the data into Data warehouse

Expertise in analyzing customer needs and taking appropriate steps to implement them in the application development.

Efficient in ETL Procedures, Star Schema, Snow Flake, Dimensions and Fact tables.

Extensive testing ETL experience using Informatica and knowledge on developing simple Stored Procedures and SQL queries using Oracle PL/SQL.

Experience in the Integration of various data sources with multiple relational databases like Oracle11g /Oracle10g, DB2, VSAM files and Flat Files into the staging area, ODS, Data Warehouse and Data Mart.

Knowledge on with slowly changing dimensions

Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.

Having experience on Oracle and UNIX.

Basis R/3, Net weaver 700 and 701.

Working with business partners to gather security requirements in order to design and build appropriate role-based security for the SAP environment

Updating user profiles in a non-production environment and addressing any user requests that are received

Installation of Additional application servers on ECC, SCM and BW Environments

Experience in Applying Support Packages to Abap Stack, Java Stack and Dual Stack SAP instances

Manage SAP users, authorizations, and profiles.

Manage online SAP user workload and monitor and manage the SAP background job workload.

Monitor all SAP systems (work processes, users, system logs, short dumps, locks, developer traces – work with developers on analyzing long running SQL’s, system traces, disk space, etc.).

Complete operation mode maintenance, overview, job assignment, scheduling of background job processing, day & night job processing management.

Develop and maintain system documentation for all SAP instances and interfaces.

Setup and manage RFC destination, and configuration of Transport management system.

Good experience in UNIX, Linux and Windows operating systems.

Creating and documenting installation, configuration and technical details and sharing with team.

Work as part of a project team to coordinate with different teams and get project scope and requirements.

Technical Lead & Player

Committed team player with strong analytical and problem solving skills, willingness to quickly adapt to new environments & technologies, dedicated to successful project completion and excellent communication and interpersonal skills.

Team-oriented work ethic that includes willingness to help others. Ability to work independently and share results of assigned projects with team members

Understands the impact of new projects and technical impacts to supported systems

Interact effectively with Functional, Development, and other IS/IT teams on projects

Good experience in Microsoft Suite application (Word, Excel, Access, Lotus Notes) and MS Project.

Support

Experience with on call duty for 24x7 production support, Support Month End, On-calls, should be able to support weekend support and long hours.

Organizes prioritize, and track incidents and support requests through Service-Now Tool per SLA’s and corporate policy

Escalate issues based on severity and impact, including coordination with vendors.

TECHNICAL SKILLS:

RDBMS: Oracle 11g/10g, DB2

ETL Tools: Informatica Power Center v9.5.1/9.1.0/8.6

Programming: SQL, PL/SQL, JCL

Operating Systems: WINDOWS 7/XP, UNIX, LINUX.

Others: ALM, HP Quality Center, JIRA, ITSM, WinSCP, Version One, Perforce,

Service Now, putty.

PROFESSIONAL EXPERIENCE

May 2014 – Till Date, Sr. ETL/Informatica Developer, Corning Incorporated.

Involved in requirement Gathering and analysis of source data as data comes in from different Source systems.

Mainly involved in ETL developing Creating the mappings and transformations using Informatica.

The data from the staging area was transformed and loaded to the target on Oracle using Informatica Tool.

Developed Workflows using task developer, worklet designer, and workflow designer in Workflow manager and monitored the results using workflow monitor

Extracted data from Heterogeneous source systems like Oracle, SAP, and flat files.

Worked with SAP and Oracle sources to process the data.

Optimizing/Tuning mappings for better performance and efficiency.

Extensively used transformations like Filter, Aggregation, Joiner, Expression, Lookup, Router, and Update Strategy.

Creating validation and loading the rejected records into the relevant tables and send to the users for re-submitting.

Involved in designing the maplet and reusable transformation according to the business needs.

Implemented SCD methodology including Type 1, Type 2 to keep track of historical data.

Used the mapping parameter to make the mapping more flexible.

Created mapping documents for data mart deliverables. Maintained mapping documents throughout development lifecycle.

Involved in Unit testing.

Checked the output according to the specifications.

Collaboration with DBA and Informatica Admin teams to ensure best possible performance and smooth running of systems.

Environment: Oracle 11g/10g, Informatica Power Center v9.5.1, SQL, WINDOWS 7/XP, Linux, ALM, ITSM, WinSCP, Version One, Perforce, Service Now

Feb 2011 – May 2014, ETL/Informatica Developer, Client: Southern California Edison, USA

Designing of models for data flows and ETL components, creation of mappings, mapplets, sessions, workflows using Informatica PowerCenter

Involved in gathering requirements. Designed and developed Data warehouse using Informatica 8.1.0.

Created Informatica Mappings to build business rules to load data using transformations like Source Qualifier, Aggregator, Expression, Joiner, Connected and Unconnected lookups, Router and Update strategy.

Involved in designing the ETL testing strategies for functional, integration and system testing for Data warehouse implementation

Created Informatica sessions and workflows to cater for different situations

Identification and Documentation of various data sources including the detailed Table/File/Field level mappings between the source and target systems.

Created necessary test plans and design documents for the mappings.

Tested mappings and sessions using various test cases in the test plans.

Prepared SQL Queries to validate the data in both source and target databases.

Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.

Environment: Informatica 9.1.0/8.6,, UNIX, Windows XP, Oracle 10g, SQL, PL/SQL, DB2, SAP, Toad, HP Quality Center.

Aug 2010 – Feb 2011, Inofrmatica Testing/ SAP BASIS Admin, Client: Blockbuster US, Dallas, USA

Preparing Test Plan and traceability matrix.

Test Scenario and Test Case preparation based upon Functional specifications.

Validation of data in Oracle Production tables.

Creation of Test closure Report.

Provided support to Production support team.

Conducted the peer review and debugging for mappings developed and tested.

Defect Tracking, Data Verification with development team and users

Configuration of Transport management system (TMS)

Printer setup and troubleshooting issues related to printer problems.

Assisting end-users in daily activities.

Involved in the landscape and project planning for the new projects

Creation of Clients and Client copies

Spool Administration and Printer Configuration.

Kernel upgrades and support pack implementation in Dev and QA Systems

Participated in implementation & installation of ECC 6.0

Executed a daily basis administration task in SAP and OS systems.

Environment: Informatica 8.6, UNIX, Windows XP,SQL, SAP, HP Quality Center

Jan 2009 – Jul 2010, SAP BASIS CONSULTANT, Client: Travelers, Hartford, USA

Daily performing system check, monitoring system logs and ABAP dumps, Monitor locks and failed updates. Performance monitoring such as Database monitor, Buffer monitor and operating system monitor, spool related errors

Install SAP kernel, ABAP support packages

Perform routine system health checks in the Basis, Oracle DB, and OS / Linux areas

Perform routine transport migration

Analyze system performance and troubleshooting system / application issues as needed

Day to day support for the Development, Testing and production environments.

Batch Job administration and review batch jobs, short dump analysis and checking system logs

Upgrading kernel patches and support packages.

Worked on SAP Security & User administration and support

Responsible Client Copies

Scheduling Backup Policy

Working with BRTOOLS and Online and Offline backups

Aug 2005 – Dec 2008, Team Lead, Client: Travelers, Hartford, USA

As a Team Lead responsible for Requirement gathering, Analysis, design, development, testing and implementation of customized projects for new implementations for our Cognizant Technology solutions US Customer Travelers Company

Program Management Support through the Software Development Life Cycle of on-going projects using SAP PS Module

Configuration of project work breakdown structure templates for all customer projects in SAP

Creating “Work orders” for all the assigned projects and linked any applicable child work orders with the master work orders whenever necessary through SAP.

Configuration of “Cost plans” for all the assigned projects through SAP.

Creating Milestones and assigning them to WBS Elements and Activities

Creating Release Management “Notifications” for all new projects through SAP and HPSM tools

Creation of resources planning and allocation of resources to the different projects through SAP

Perform complex and customized SAP queries to extract financial performance data. Develop new templates for project managers to use in their work.

Generated SAP Customized time sheet reports for different projects in a timely manner.

Coordinate with Supply chain management for the PO creations for the procurement contracts.

Work with Business Analysts in translating business requirements into system requirements Document and to Detailed Design Documents

Lead analysis sessions, gather requirements and write specification documents for enhancements and customization projects

Involved in the development phase in developing and reviewing the program specifications for both online and batch programs for remittance project

Configuration of test environments & Test bed preparation and setting up Customer acceptance testing Cycles on bigger Projects

Involved in technical support and production support for the end user

Involved in analyzing the service requests given by end user and fixing the production problems and data changes in the database and program changes for the existing systems

Post implementation support includes solving the service request raised by the end user.

June 2002 - Aug 2005, Cognizant Technology Solutions, India, Client: AMEX

Resolving the day-to-day problems of the user, customer satisfaction as a top priority.

Architectural evaluation of client application development framework

Involved in System testing of Different Work Authorizations, Adhoc requests and MR’s.

Test Environment Setups

Test Execution

Preparation of test plans and test conditions

Scheduling of Applications/Jobs in Control-M scheduler

Customization of Jobs from other environments to suit TS environment

Automation of work process with using Sort JCLS, File-Aid and Easytrive.

Review Deliverables.

Analyzed abends, generated alternatives and the best technical Solutions and explained them to the team members.

Post implementation support includes solving the service request raised by the end user.

Analyzing the errors, searching for causes of errors, provided corrective solutions and suggested for preventive actions to avoid recurrence.

Prepared KT documents and conducted KT sessions for new joinees.

June 2000 - May 2002, Syntel India Ltd, India, Client: AMEX

Team member of offshore team for Maintenance, Enhancement, Development and Production support with utilities like Chgman, Info man, CA-11 Scheduler.

Job Monitoring and providing on call support

Fixing up bugs/issues by analyzing code of Cobol/DB2, Cobol/IMS DB programs, and Jcls. Same way clarifying user’s doubts.

The job involved writing new Cobol/DB2, Cobol/IMS DB, Easytrieve programs, modifying the existing Cobol/DB2/IMS DC programs, setting up of JCL’s for unit & system testing.

Contact this candidate