SUMMARY

• Informatica consultant and a solution architect with close to 8 years of experience in ETL Infrastructure Administration/Architecture and Informatica ETL development.
• Demonstrated excellence in design, development and support of Informatica ETL solutions using different data sources. Defining Informatica standards and best practices.
• Good experience in designing and implementing ETL environments using ETL strategies as well as tools Like Informatica Power Center 8.x/9.x, Power Exchange, Metadata Manager, IDQ and B2B.
• Skilled in designing and implementation of Informatica Infrastructure Architecture for better cost effective and efficient environment.
• Special proficiency in installing Informatica 8.x/9.x and upgrading Informatica Version 8.x to Version 9.x. Experience in applying Informatica Latest Hot fixes/Patches. Installation & configuration, Domain/multi - node setup, High Availability setup, Load balancing, Server performance tuning, User management, etc.
• Extended exposure in designing, implementing and coordinating the DR strategy/plan for all Production infrastructure build.
• Extensive experience in error handling and problem fixing in Informatica. Installing and configuring Oracle DAC server and client. And integrating it with Informatica.
• Good ability in developing, modifying and testing UNIX shell scripts and necessary test plans to ensure the successful execution of the data loading process and automated processes for informatica administrators.
• Extended experience in 24X7 on call Production support and preparing procedures/documentation whenever necessary.
• Good experience in configuring and use of Informatica cloud services. Part of Informatica partner program on spreading knowledge and major advantages of using Informatica cloud services.
• Excellent communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high adaptability to new technologies and tools.
• Act as a point of technical escalation and resolution during the project lifecycle as it relates to technical decisions.
• Proactively work with partners to ensure that appropriate staffing resources are assigned, put in place, and effectively utilized at the appropriate time.
• Experience in all aspects of Project Management from requirements through development, planning, business analysis, execution, monitoring, scheduling and estimation of medium to large sized projects involving complex business solutions.
• Capable of managing clients for entire business practices and procedures; expertise in analyzing client's business and requirements, suggesting and implementing processes to deliver high quality business solutions and recommendations.
• Recognized for managing complex projects (with tight timelines), Building and Leading Teams, Cultivating and nurturing relationships, and Critical Problem-Solving.
• Motivating and enthusiastic professional with an excellent approach to achieve triumph in all projects.
• Capable of delivering success in a complex project with scope for learning and challenge.

TECHNICAL SKILLS

Operating Systems: Windows XP Professional, Windows 7, UNIX, Linux

Databases: Oracle, MySQL

Internet Tools: HTML, XML, CSS

Languages: PL/SQL, Java, J2EE

Others: MS Office, EDI, Informatica 8.x/9.x, Informatica B2B, Informatica Metadata Manager Informatica PowerExchange, Informatica IDQ, Tomcat, Eclipse, Control-M, OBIEE, Qlikview, Oracle DAC, Autosys, Informatica cloud.

PROFESSIONAL EXPERIENCE

Confidential

Informatica Architect/Administrator - Tech Lead

Responsibilities:

• Install, upgrade and configure Informatica 8.x/9.x, B2B, PowerExchange, Metadata Manager and IDQ on Linux.
• Install and configure Oracle DAC server and client, and integrated with Informatica.
• Design and implement a complete DR setup for all Production environments.
• Coordinate and conduct complete DR test early twice to ensure business continuity even at an event of disaster. Also document all steps, process and procedures to be carried out at the event of a disaster.
• Manage user account, groups and workspace creation for different customers.
• Support Informatica infrastructure/workflows 7am to 7pm(EST) on weekdays and 48 hours support on weekends.
• Outage Handling - Notify the user group on scheduled outage during the weekend, bringing down the Informatica service and restarting once the change is done.
• Test and troubleshot mappings, sessions and workflows in DEV/QA environment before Migration to PROD.
• Troubleshooting user's problems (application and infrastructure related).
• Raise SR and coordinate with Informatica global support for unresolved issues/concerns.
• Create process documents for ETL infrastructure run activities.
• Research on new innovative ideas to build cost effective and efficient Informatica infrastructure.
• Coordinate with the client for gathering the business requirements.
• Setup new Informatica infrastructures for different business units, as per requirement.
• Developed and setup scripts for Informatica domain and repository backup.
• Mentor new comers in team. Lead and guide the team.
• Create reports and dashboards for task progress and performance statistics using Qlikview.
• Infrastructure architecture planning, project planning and operational activities.
• Identify project resources and directed work efforts for deadline-driven assignments.
• Manage change control, procurement, and project escalations with internal Dept.’s and third-party vendors.
• Coordinate solutions vendors (hosting, software, security, content delivery), resolving issues with appropriate hardware requirements, data dependencies, and solution architecture.
• Conduct Weekly status meetings to track the tasks progress.

Confidential, Merrimack, NH

ETL & OBIEE Developer

Responsibilities:

• Identify Source tables (OLTP, ODS) and Target tables (OLAP) for Data mapping.
• Development of mappings workflows and session tasks using Informatica Power Center. Test and troubleshot mappings, sessions and workflows in DEV/QA environment before Migration to PROD.
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Involved in Dimensional modeling (Star Schema) of the Data warehouse
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Installation of OBIEE 11.1.1.6.5 Enterprise Server in windows and Linux machine(DEV, UAT & PROD ENV’s)
• Configured OBIEE Repository (Physical, business and presentation layer) to provide Analytical Reporting solutions to business.
• Worked on RPD part to develop custom logical tables, Columns and hierarchies in BMM Layer & Presentation Layer.
• Identified joins, tables, Dimensions, Facts, Aggregates, and Measures etc.
• Implemented Dimensional Hierarchies, Aggregate navigation, Fragmentation content, and other various features.
• Created role based dashboards, pages, reports with various views i.e. table, pivot, charts, narrator, column selector etc. and various report prompts.
• Created drill down charts and drill down tables to gather more information.

Confidential

Informatica ETL Developer

Responsibilities:

• Coordinate with the client for gathering the business requirements.
• Translate business requirements into Informatica PowerCenter mappings/sessions/workflows.
• Develop mapping design document for ETL process.
• Enhancement of existing processes to support changes of clients.
• Support Informatica workflows 7am to 7pm(EST) on weekdays and 48 hours support on weekends.
• Test and troubleshot mappings, sessions and workflows in DEV/QA environment before Migration to PROD.
• Contact with Informatica technical support group regarding any unknown issues.
• Create scripts for transforming unstructured data to structured format using Informatica B2B Data Transformation.
• Self Learning to expertise on Informatica B2B - Data Transformation and Data Exchange.

Confidential

Informatica ETL Developer and Informatica Administrator

Responsibilities:

• Coordinate with the client for gathering the business requirements.
• Translate business requirements into Informatica PowerCenter mappings/sessions/workflows.
• Create process documents for ETL infrastructure run activities.
• Develop mapping design document for ETL process.
• Write stored procedures, functions, packages for the migration project without affecting the existing functionality.
• Test and troubleshot mappings, sessions and workflows in DEV/QA environment before Migration to PROD.
• Support Informatica infrastructure/workflows 7am to 7pm(EST) on weekdays and 48 hours support on weekends.
• Enhancement of existing processes to support structural changes of source.
• As a part of this project, we added Service center, Asset center, Enterprise Registry, ITG Central, magic data from various sources to ODS.

Confidential

Web Application developer

Responsibilities:

• Develop CRUD application.
• Coordinate with onsite team members and partners.
• Implement encryption technique for password as per standard.
• Develop stored procedure and implemented Ibatis to access it.
• Implement Abstract Factory and Factory Pattern.
• Perform end to end testing of website.
• Develop Phase 2 of project with new enhancements.
• Took initiative and implemented same website for Confidential Information Processing Team.

Confidential

Web Application developer

Responsibilities:

• Perform end to end testing of the application.
• Perform rigorous testing of - Telephony, Resource menu and Siebel.
• Analyze Performance Logs - capturing data based on various parameters and display them as per requirements.
• Analyze Error Logs - analysis and interpretation of errors in various environments and assigning them to the concerned developers.
• Develop the CCW Testing Manual - encapsulates the detailed testing procedure and the installation of certain third party modules.
• Support the creation of the CCW User Manual.

Confidential

Informatica Admin

Responsibilities:

• Install/Upgrade and configure Informatica 9.5.1.
• Identified potential risks/sub-standards and fixed them in the setup.
• Worked on ETL Architecture to furnish business requirement specs and document them for Informatica developments.
• Design and implement a complete DEV, SIT, UAT, Pre-Prod, Prod and BCP/DR setup.
• Manage user account, groups and workspace creation for different users.
• Infrastructure architecture planning, project planning and operational activities.
• Prepare monthly/weekly reports and present it to the management.
• Developed and setup scripts for Informatica domain and repository backup, truncate logs and housekeeping.
• Supported implementation of DIS to support the servicing of downstream consumers which require HR data.
• Scheduling and setting up jobs in autosys.
• Proposed the solution to bundle the existing Informatica work package of downstream GRW application with the new Informatica work package to be used to get data from Fusion.
• Designed the new end to end architecture providing solution on how the existing downstream application GRW would align itself and cope with this Fusion change.
• Designed the Informatica Upgrade approach.
• Capacity planning and overlook of architecture plan of all integrated systems.
• Provide timely advice to management and the project team on environmental issues.
• Implement all aspects of the Environmental Management Plan and ensure compliance.