SUMMARY:

• Having 9 years of total IT experience in System Analysis, design and production support and Enhancement implementation of Relational Database and BI applications, Data Warehousing Systems using Informatica 7.x/8.x/9.x and Business Intelligence tools like OBIEE 11g and Cognos 10 and Business Objects .
• Expertise, worked extensively on Informatica Power center 8.x; 9.x; 10.x and possesses good skills in Administration .
• Coordinated in analyzing the specifications provided by the clients and developing specification documents for reports as per client requirements.
• 1.5 years of experience as an Informatica MDM Administrator .
• Experience in 24X7 production support, ETL executions and resolving root causes.
• Configured and maintained Informatica 9.x High Availability and GRID environments.
• Installed and configured Informatica Cloud.
• Installed and configured Informatica 10.1 and upgraded to 10.2 Environment in Linux.
• Having good knowledge in Informatica AWS.
• Strong experience in installation / upgrade of Informatica Power center .
• Installation and configuration of IDQ and power center integration.
• Worked extensively with versioning repositories.
• Setup and maintain Power center ETL Administration best practices and procedures .
• Participate in key/critical design elements and interfaces, provide ETL approach.
• Worked with Service Now, BMC Remedy ticketing tool to address the issues within the SLA.
• Worked on Control - M scheduling tool to schedule the PROD loads.
• Involved in code migration for all the DEV, QA and PROD Environments .
• Documenting all the ETL activities and validating all the ETL process as per the company norms.
• Coordinating with the development teams and ensures of Informatica ETL design standards.
• Monitor the log files of Domain, Application services in frequent intervals and backup them accordingly.
• Installed and configured Native drivers, ODBC, JDBC, SFDC drivers to communicate with Databases.
• Maintain/Update Code pages for the Informatica repository service and integration service and administrator console.
• Creation/Deletion of users, groups and folder groups per the project requirement.
• Configured and synced LDAP user and groups of Active directory in power center.
• Participated in Planned and unplanned outages for all the three environments.
• Configured/Maintained Disaster Recovery, Scheduled backups for the PROD environments.
• Coordinate with the Developers, DBA’s and Sys Admins for the software upgrade s.
• Supported Informatica, SnapLogic AWS cloud implementation.
• Good understanding and Responsible for investigation, characterization, and communication of build and release problems; implementing corrective and preventive actions.
• Have good problem solving and analytical skills. Highly motivated professional, Team Player and the ability to effectively Work with, communicate and mentor people.
• Excellent communication skills: Able to interact with users and business owners and translate high-level business requirements into logical business model.

TECHNICAL SKILLS:

Operating Systems: Windows 95/98/2000/ NT, Linux, UNIX, AS400 and MS SQL SERVER 2000/2005/2008

ETL Tools: Informatica 7.x/8.x/9.x,10.x, MDM, B2B DX and IDQ

Business Intelligence tools: OBIEE 11g, Tableau, Cognos.

Database: Teradata, Oracle, DB2, SQL Server 2005, TOAD for Oracle 8.6, IIS 7.0. Oracle 9i, 10g,11g, SQL, PL/SQL 11.1

Version Control: Star Team, HPQC, Service Now, Rational Clear case/Clear quest

Scheduling Tools: Autosys 11, Control - M.

Ticketing Tools: HP Service Manager, Service Now and Remedy

Modelling Tools: ERWIN, ERStudio

PROFESSIONAL EXPERIENCE:

Confidential, Westbrook, Maine

Informatica Administrator

Responsibilities:

• Involved in the Requirements gathering, Analysis and support of Data Warehousing efforts.
• Upgraded Informatica from 9.6.1 to 10.1.1 & 10.2.
• Installed Informatica on Cloud .
• Installed and configured Informatica 10.2 in Linux environment.
• Installation and configuration of Power Center Repository service, Integration service.
• Installed and configured IDQ and power center integration .
• Installing and configuring various services like Model Repository Service, Data Integration Service, Analyst Service, and Content Manager Service and Business Glossary in IDQ.
• Configured Content Management service for analyst tool.
• Establishing connectivity with various data sources like Oracle, Green plum, sqlservers, Sybase and SAP.
• Upgrading the IDQ versions and EBF's.
• Updating the address doctor versions as per the business need.
• Having experience in architecting and DR process .
• Created projects in the IDQ developer tool.
• Monitoring the server for metrics like CPU memory IO swap etc.
• Configured Users/Groups from Informatica domain configuration.
• Involved in creation of folders/user permissions and folder groups for power center.
• Done LDAP configuration and synced users from the external active directory.
• Created technical support documentation for the team for production support.
• Worked on the three-tier model ( DEV, TEST, and PRODUCTION ).
• Scheduling the workflows using Informatica command-line utilities .
• Followed standard procedures to migrate the mappings from Development to Test and Production environments by creating deployment groups .
• Preparing weekly and monthly progress report including audits, creating reports for process followed in the project, thus helping the team in decision making and hence increasing productivity.
• Execution of patches and upgrade s to supported software.
• Attend planned Outages/Go-Lives and Unplanned Outages and coordinated with DBA’s.
• Procedures and scripts to tune and support environment and execute as required.
• Respond to Informatica Infrastructure monitoring (server/ performance alerts ).
• Perform repository backup and Domain backup in frequent intervals.
• Conducting route cause analysis for the jobs failed.
• Worked on performance tuning with the development teams.

Confidential, NJ

Informatica Administrator

Responsibilities:

• Involved in the Requirements gathering, Analysis and support of Data Warehousing efforts.
• Installed Informatica 9.x and configured in GRID.
• Upgrade d Informatica from 9.5 to 9.5.1, from 9.5.1 to 9.6.1, from 9.6.1 to 10.1.1 & 10.2.
• Installed Informatica on Cloud .
• Configured Secure Agent for Cloud on on-premise Unix servers.
• Installed and configured Informatica 10.1 in Linux environment.
• Installation and configuration of Power center Repository service, Integration service.
• Installed and configured IDQ and power center integration .
• Installation and configuration of Informatica MDM.
• Configure HubStore, HubServer and HubConsole for Informatica MDM.
• Installed Cleanse match server and resource kit.
• Installing and configuring various services like Model Repository Service, Data Integration Service, Analyst Service, and Content Manager Service and Business Glossary in IDQ.
• Configured Content Management service for analyst tool.
• Establishing connectivity with various data sources like Oracle, Green plum, sqlservers, Sybase.
• Upgrading the IDQ versions and EBF's.
• Updating the address doctor versions as per the business need.
• Enabling Ge-Coding as per the project need.
• Having experience in architecting and DR process.
• Created projects in the IDQ developer tool.
• Monitoring the server for metrics like CPU memory IO swap etc.
• Configured services like MFT, Activemq, and Dashboards in B2B data Exchange.
• Manage and backup the B2B Data Exchange repositories in frequent intervals.
• Configured Users/Groups from Informatica domain configuration.
• Involved in creation of folders/user permissions and folder groups for power center.
• Done LDAP configuration and synced users from the external active directory.
• Created technical support documentation for the team for production support.
• Worked on the three-tier model ( DEV, TEST, and PRODUCTION ).
• Worked on offshore/onshore model and coordinate with the team on regular calls.
• Scheduling the workflows using Informatica command-line utilities .
• Followed standard procedures to migrate the mappings from Development to Test and Production environments by creating deployment groups .
• Used the email task in the Production to keep the team posted on process status.
• Created stored procedures to implement the logics and using them in Informatica .
• Extensively used environments to create shell script and maintaining the logs of Informatica admin console.
• Schedule a call to the relevant teams if any abnormal job timing or any unexpected data arrived to understand the current scenario.
• Preparing weekly and monthly progress report including audits, creating reports for process followed in the project, thus helping the team in decision making and hence increasing productivity.
• Execution of patches and upgrade s to supported software.
• Attend planned Outages/Go-Lives and Unplanned Outages and coordinated with DBA’s.
• Procedures and scripts to tune and support environment and execute as required.
• Respond to Informatica Infrastructure monitoring (server/ performance alerts ).
• Perform repository backup and Domain backup in frequent intervals.
• Conducting route cause analysis for the jobs failed.
• Worked on performance tuning with the development teams.
• Involved in day to day Business Objects Server maintenance.
• Implemented best practices for using Business Objects Suite.
• Provided support to resolve client technical issues.
• Expertise in BO XI R2 CMS and complete security model at BO enterprise level.
• Well versed in BOE architecture, Services process flows, content, security, scheduling and publishing.
• Conducted end user training sessions and prepared training material.

Confidential, MA

Informatica Administrator

Responsibilities:

• Worked as an Informatica Consultant.
• Define the Naming Standards and Standard process for Informatica .
• Installed and upgrade d Informatica 9.x
• Developed multiple ETL process to synchronize the data between legacy and new system.
• Configured services like MFT, Activemq, and Dashboards in B2B data Exchange.
• Manage and backup the B2B Data Exchange repositories in frequent intervals.
• Configured load balancer in B2B environment.
• Providing the necessary privileges for team and maintaining the security and permissions to the Active MQ services in B2B DX.
• Configured the batch workflows to the particular integration service in B2B DX.
• Installed Data Archive service to archive the events in B2B DX.
• Installed and configured Informatica MDM.
• Setup Informatica AD Authentication.
• Configured Informatica High Availability setup.
• Performed the Setup of DR Servers.
• Worked with Informatica Data Quality (IDQ) toolkit, Analysis, data cleansing.
• Applied Informatica Patches to the Informatica servers.
• Troubleshooting the issues in Informatica .
• Involved and resolving the issues (Tickets) in Informatica Power center.

Confidential

Informatica Administrator

Responsibilities:

• Participation and consultation with GE in the design, validation and implementation of Infrastructure changes, new product and versions
• Support Design in additional education for user community with regard to tool’s capabilities.
• Support Design and Architecture teams
• Participated in build Informatica infrastructure as needed from approved reference architecture.
• Part of outages for application maintenances
• Assist with patch and break-fix module Installation, configuration, and application upgrade s.
• Documenting installations steps, guidelines, best practices, standards and ensuring the standards and best practices.
• Review capacity criteria data and ensure the design can accommodate the expected volumes and throughput rate.
• Query Optimization techniques.
• Execution of patches and upgrade s to supported software
• Attend planned Outages/Go-Lives and Unplanned Outages
• Procedures and scripts to tune and support environment and execute as required
• Respond to Informatica Infrastructure Monitoring (server/performance alerts)
• Oversee & assist the various development teams with the testing & verification of successful migration of all objects to the new environment.

Confidential

Informatica Administrator

Responsibilities:

• Setup and maintain ETL Administration best practices and procedures.
• Responsible to manage Development, QA and Production environments .
• Making sure that code is sync in all the three environments.
• Responsible for investigation, characterization and communication of build and release problems, implementing corrective and preventive actions.
• Involved in upgrade activities of Informatica 8.x.
• Involved in production support working with various migration tickets.
• Adding users and users groups modifying the users/user groups.
• Install quick fixes and patches and update users accordingly.
• Set up user level security for the users of Informatica .
• Set up user level, data level security for the Informatica folders
• Worked on performance tuning of various Informatica objects to handle requests better and optimize the performance of the application
• Worked with DBA’s in solving the production issues.
• Troubleshooting the environment in case the BI server goes down or contacts the DBA in case of the down time of the content store database.
• Coordinate with the IT computer and network support team to ensure continued hardware and networking availability of the Informatica services to users and programming staff.

Confidential

Informatica Administrator

Responsibilities:

• Support Design and Architecture teams
• Participated in build Informatica infrastructure as needed from approved reference architecture.
• Part of outages for application maintenances
• Assist with patch and break-fix module Installation, configuration, and application upgrade s.
• Documenting installations steps, guidelines, best practices, standards and ensuring the standards and best practices.
• Review capacity criteria data and ensure the design can accommodate the expected volumes and throughput rate.
• Query Optimization techniques.
• Execution of patches and upgrade s to supported software
• Attend planned Outages/Go-Lives and Unplanned Outages
• Procedures and scripts to tune and support environment and execute as required
• Respond to Informatica Infrastructure Monitoring (server/performance alerts)
• Oversee & assist the various development teams with the testing & verification of successful migration of all objects to the new environment.

Confidential

Informatica Administrator

Responsibilities:

• Session Migrations from Dev to QA, QA to PROD .
• Monitoring the scheduled workloads and coordinating with development teams for performance issues.
• Manually executing the loads as per the development team’s requirements.
• Respond to Informatica Infrastructure monitoring (server/performance alerts).
• Taking part in DB outages support and Password change management.