SUMMARY

• Notable Informatica Administration career spanning over 8 years including technical and leadership innovation in requirements gathering, planning, execution and management of technology - led business transformations
• Self-motivated and goal-driven Informatica Administrator with substantial experience in requirements gathering, planning and delivery of technology led business transformation initiatives.
• Quickly grasps business models/processes, formulates roadmaps and devises solutions that address critical business challenges.
• Wealth of experience as an Informatica Administrator, in the energy and utilities and financial services industry, particularly in utility billing systems and Investment banking operations.
• Well versed with RDBMS like Oracle and OS concepts. Experienced on multiple Operating Systems and worked on Windows NT, Windows XP Professional and UNIX platforms.
• Conversant with SEI CMM quality procedures while executing the projects and have undergone preliminary training on SIX-SIGMA methodologies and GB training and fully capable of implementing world class Quality Standards.
• MCA Masters in Computer Applications and Oracle Certified Associate (OCA 9i SQL & PL/SQL).

TECHNICAL SKILLS

Hardware: Confidential, Dell, Compaq Compatibles

Operating Systems: Windows NT 4.0, Sun Solaris 5.10

Tools: & Utilities: Informatica Power Center (9.1& 8.6), TOAD 7.1, Secure CRT, CAWA and Maestro schedulers.

Domain Knowledge: Energy and Utilities and Investment Banking

Database: Oracle 10g R2

PROFESSIONAL EXPERIENCE

Confidential, DALLAS, TX

Senior Informatica Administrator

Responsibilities:

• Worked on successful installation and implementation of the Informatica 9.1 binaries on Production servers as Domain and Worker node using grid architecture after installation, upgrade and testing in the Quality environment.
• Upgraded all the repositories in the development, QA and Production environment from Informatica 8.5.1 version to Informatica 9.1.
• Created new repository services and integration services for Informatica 9.1 version.
• Changed all the Parameter files and Scripts after making path changes in the appropriate newly created directories structures and provided appropriate file permissions.
• Changed the execution path of the .profile in the scripts from OS user inform to oncor inform by executing the UNIX global change command on Production servers.
• Installed and configured Informatica 9.1 client.
• Creating Informatica folders, users, groups and handling permissions, security.
• Backup informatica repository and informatica domain.
• Informatica server space management and cleanup.
• As a data specialist, my role includes administration of Informatica environments, troubleshooting, maintaining some the critical applications, providing solutions, recommendations and ongoing support.
• Provide the Informatica Expertise and ongoing support for a critical application which is 24x7
• Responsibility to migrate ETL Informatica code by using team based versioning.

Confidential, Newark, NJ

Informatica Administrator

Responsibilities:

• I have done successful installation and implementation of the Informatica 9.1 binaries on two PRODUCTION servers at Plano and Newark as Domain and Worker node using grid architecture after installation, upgrade and testing in the Quality environment at Newark.
• Upgraded three repositories (one Development and two PRODUCTION repositories) from Informatica 8.5.1 version to Informatica 9.1.
• Created new repository services and integration services for Informatica 9.1 version.
• Placing the Solaris 64-bit Unicode RFC SDK libraries i.e. Informatica SAP 9x transports in appropriate paths on the servers for communication between Informatica 9.1 and SAP R/3 Production systems.
• Changed the execution path of the .profile in the scripts from OS user informat to informatp9 by executing the UNIX global change command on PROD servers.
• Installed and configured Informatica 9.1 client and registered the Informatica 9.1 SAP transports for Informatica and SAP communication.
• Creating Informatica folders, users, groups and handling permissions, security.
• Backup informatica repository and informatica domain.
• Migrating mappings, sessions and workflows from one environment to another.
• Responsible for the schedule/reschedule of jobs and also maintain optimal system’s health by taking required proactive actions such as cleanup.
• Work with the ETL development team, DBAs and application administrators and coordinates downtime with the application support team to implement patches/bug fixes and responsible for environment uptime.
• As a data specialist, my role includes administration of Informatica environments,

Confidential

Senior Software Engineer

Responsibilities:

• Designed ETL Logic for mappings and extensively worked on Power Center Designer (Source Analyzer, Warehouse designer, Transformation Developer, Mapping Designer and Mapplet Designer).
• Developed ETL mapping Documents, Data Migration documents,
• Creation of Mapplets to reduce the development time and complexity of Mappings and better maintenance.
• Creating/ Building and scheduling Batches and Sessions using the Server Manager.
• Developing Reusable Transformations, Aggregations and created Target Mappings that contain business rules.
• Optimizing/Tuning mappings for better performance and efficiency.
• Testing - Unit Testing, System Testing, Integration Testing.

Confidential 

Software Engineer

Responsibilities:

• Designed ETL Logic for mappings and extensively worked on Power Center Designer (Source Analyzer, Warehouse designer, Transformation Developer, Mapping Designer and Mapplet Designer).
• Developed ETL mapping Documents, Data Migration documents,
• Creation of Mapplets to reduce the development time and complexity of Mappings and better maintenance.
• Creating/ Building and scheduling Batches and Sessions using the Server Manager.
• Developing Reusable Transformations, Aggregations and created Target Mappings that contain business rules.
• Responsible for design documents, creation of ETL mappings and testing.
• Coordinated with the team members in conducting the reviews and discussion.
• Diagnosed the technical problem and determined the test solution.
• Interacting with the client for the requirement gathering.
• Managing team in terms of resource allocation and meeting the deadlines specified for the releases.