SUMMARY

• Outstanding Informatica Administrator with 10 plus yrs of experience in installation, configuration, maintenance and support of Informatica 8.x/9.x on Unix and Windows environments.
• Experienced in Capacity planning, Performance, Architecture Management and Security Management.
• Successfully installed and supported Informatica PowerCenter in DEV, QA & PROD environments.
• Strong administration and support expertise in Informatica PowerCenter 8x, 9x including IDR and IDQ.
• Worked with Systems Administrators and DBA’s. Scheduled and implemented patches and upgrades.
• Experience with static and dynamic deployment methodologies to migrate code from Development to Test to Production environments.
• Detail oriented with effective presentation skills, excellent communication skills and wonderful work ethics.
• Installed & configured various versions of Informatica PowerCenter and Repository Databases. Upgraded Informatica from 8.x to 9.x and later versions.
• Created/Supported Oracle databases (UNIX & Windows) - - Oracle 8i, 9i, 10g, 11g.
• ETL Architect; Informatica and SQL Server Integration Services - Informatica Power Center 7, 8.x & 9.x
• Scheduled and implemented software patches and updates.
• Expertise with Informatica PowerCenter, PowerExchange, DataQuality, Big Data Edition, Enterprise HA/Grid, pmcmd command line interface, LDAP and Native security.
• Installed and managed SQL Server 2008 R2 clusters - SQL Server 2000, 2005, and 2008.
• Installed and managed Windows 2008 R2 clusters - Windows 2000, 2003, and 2008.
• Configured Java development environment; Tomcat 6, Eclipse, Maven 2, Struts 2, and JQuery.
• Monitored different components of the system such as the operating system, network traffic, database memory usage, database me/O, OS processes and database processes.
• Established a backup and recovery strategy including Oracle RMAN.
• Created professional grade documents with images.
• Troubleshooting long-running queries, operating system bottlenecks, me/O bottlenecks, and memory problems.
• Followed proven methodologies, applied best practices, enhanced existing processes, and implemented optimal solutions.
• Developed commercial software applications using Microsoft Visual Basic 6.0

TECHNICAL SKILLS

Operating Systems: Windows 7/ Vista/ XP / 2008 R Unix - Sun Solaris 8.1, 9, 10 | Linux - Red Hat 5.1 | AIX 5.2 | HP - UX11

Databases: Microsoft SQL Server 2000, 2005, 2008, Informix 7, DB2, MS AccessOracle 8i, 9i, 10g, 11g

Data Warehousing & Business Intelligence: Data Warehousing Architecture, ETL Architecture, OLAP, OLTP Informatica Std, Adv & Big Data Editions. IBM Datastage, MicroStrategy.

Programming Languages: VB, Unix Scripting SQL, PL/SQL, Java, JavaScript, HTML, XML

Tools: & Utilities:: SQL Navigator, Secure CRT, WinSCP, Toad, MS Office, SOAP UI

PROFESSIONAL EXPERIENCE

Confidential, Dallas,TX

Sr. Informatica Administrator

Responsibilities:

• Established Data Warehouse Governance for the projects encompassing Data Profiling, Data Quality, Data Security and Data Integration; created a comprehensive technical Data Warehouse Governance Document.
• Installed, configured and supported Informatica PowerCenter 8x, 9.1 HF3, 9.5.1 HF4, 9.5.2 HF3, 9.6 in cross platform environment (AIX and LINUX).
• Built 90+ Informatica systems across all environments and LOB’s at JP Morgan Chase
• Installed and configured Power Center, Power Exchange, Data Quality, Metadata Management, TDM / PDMDS,
• Upgraded power Center from 8.6.1 to 9.5.2 HF3 and applied Hotfixes and EBF patches.
• Designed security template for PowerCenter Roles and Responsibilities.
• Implemented Grid services and configured High Availability (HA) in PowerCenter
• Captured Installation and Configuration steps for each environment as part of Q and A process.
• Created DR plans and sent it to hygiene group for feedbacks and approvals.
• Created OS Profiles and configured pmimp process with sticky bit permissions.
• Configured ODBCINI for SQL Server databases.
• Scheduled Informatica sessions and work flows using Control M.
• Verified license information and made sure its applied to all the services in the Domain. Also applied incremental keys as and when required.
• Worked with stored procedures (PL/SQL) for lowering memory requirements and invocation overhead.
• Installed Informatica Big Data Edition on Standard version of PowerCenter in both Single Node and Cluster Environments.
• Worked with Teradata SQL statements for storing, retrieving, and manipulating data in a relational database.
• Provided Informatica Application Support such as troubleshooting the issues for workflow failures.
• Worked with Teradata utilities such as Multiload, FastLoad, Parallel Transporter, BTEQ and TPump.
• Installed and Configured Power Exchange Adapters for HDFS and Hive.
• Used Stored Procedures stored procedures to be executed with a single call to minimizes the use of slow networks and reduces network traffic.
• Used Teradata utilities to import and export data to and from host-based and client-resident data sources.
• Worked with Control M for creating Batch Jobs and monitor Jobs in Batches.
• Configured Pushdown properties for the Data Integration Service.
• Used Control M for getting Alerts to Remedy,ECS notification and probable Cause Analysis
• Developed house keeping scripts for startup and shutdown of PowerCenter services and also to take backup of repositories and shared directories.
• Worked in an L2 / L3 support model. Provided one on one knowledge transfer to L2 support team and provided them with health checks and trouble shoot information composed into Run books.
• Generated and uploaded Diagnostics Reports / CSM (Configuration Support Management) files to support portal
• Updated Connection String Information in nodemeta.xml using UpdateGatewayNode Command.
• Widely used PMCMD, PMREP, ISP, and INFACMD commands to manage and support Informatica implementation.
• Worked on clean up items post completion of the projects.

Confidential, Plano, TX

Sr. Informatica Administrator

Responsibilities:

• Performed Informatica administration within DEV, TEST, PROD and DR environments for both dedicated and multi-tenant client deployments.
• Configured High Availability, Setup grid environment & upgraded repositories from 8.x to later versions.
• Built and maintained Informatica Data Exchange/Data Transformation (DX/DT) environments.
• Installed / configured IDQ 9 components (Content Basic, Content Accelerator & Content MO).
• Scheduled Informatica jobs. Monitoring, troubleshooting, and optimizing the entire Data Warehouse system stretching from the source data to NetApp storage (me/O).
• Installed and configured SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS) for creating DTL packages.
• Created and maintained Nodes and Grids. Configured Master Node and Backup Nodes under High Availability Environment.
• Worked with Teradata SQL statements for storing, retrieving, and manipulating data in a relational database.
• Performed Informatica capacity planning and on going monitoring (e.g. CPU, Memory, etc.) to proactively increase capacity as needed to comply with SLAs and avoid impacting users.
• Worked with Control M for creating Batch Jobs and monitor Jobs in Batches.
• Provided Informatica Application Support such as troubleshooting the issues for workflow failures.
• Created and maintained users, groups, roles and privileges and assigned them to user groups.
• Provided 24/7 supports for the applications and databases. Optimized nightly ETL jobs to meet SLA.
• Scheduled Informatica sessions and work flows using Control M.
• Managed several Oracle Databases (8i, 9i, 10g, and 11g), one of which is a Data Warehouse storing two terabytes of data; upgraded several Oracle Databases from 8i and 9i to 10g.
• Managed multiple SQL Server Databases, and upgraded from 2000 and 2005 to SQL Server 2008 R2.
• Installed Windows 2008 R2 cluster on VMware and installed SQL Server cluster 2008 R2.
• Managing J2EE 6.1 environment on Tomcat 6, Eclipse 7, Maven 2, struts 2, Hibernate, JQuery, and JSP.
• Established a backup and recovery strategy including Oracle RMAN.
• Wrote T-SQL and Oracle stored procedures, functions, and packages. Created and monitored Database auditing jobs.

Confidential, Columbus, OH

Sr. Informatica Administrator

Responsibilities:

• Installed, configured and administered Informatica PowerCenter 8.x/9.x. including but not limited to proactive resource monitoring (CPU, memory, workflow run times etc.), monitoring physical and logical Informatica services
• Worked closely with the Info Delivery Team, provided operational support to development teams for new client solutions and deployments.
• Performed Informatica capacity planning and on going monitoring (e.g. CPU, Memory, etc.) to proactively increase capacity as needed to comply with SLAs and avoid impacting users.
• Installed and configured Informatica components on Windows and Linux, including high availability; managed server activations and de-activations for all environments; ensured that all systems and procedures adhere to organizational best practices
• Provided subject matter expertise in Informatica 9.x, Power Center, IDR and IDQ
• Forecast and plan for both applications functionality and capacity requirements in a rapidly growing, changing and complex environment
• Established and coordinated system backup/restore of required Informatica components
• Provided strong administration and support for Informatica PowerCenter 9.1, including IDR and IDQ.
• Performed impact assessments for major releases, Hot Fixes, and patches (as needed) for all Informatica products from a system perspective; Planned and executed installations / upgrades following organizational standards (e.g. SLAs, audit trail, ability to rollback, etc.).
• Maintained cross-business responsibilities by providing end-user support to multiple organizations within the company when issues arise.
• Supported production implementations and migrations.
• Setup and administered Informatica PowerCenter Security including Native and LDAP security.

Confidential, St.Louis,MO

Informatica Admin

Responsibilities:

• Managed day-to-day activities of databases (source, target, and MicroStrategy), and provided 24/7 support.
• Identified source systems and data to be extracted from various sources based on user requirements.
• Improved Data Warehouse daily refresh execution time by monitoring, measuring, and adjusting ETL components.
• Built the infrastructure and the star schema for the membership Data Mart.
• Developed Oracle packages, stored procedures, and triggers.
• Developed Power Center maplets, mappings, worklets, and workflows for membership data integration.
• Monitored and tuned different components of the Database Servers such as shared memory, disk me/O, Users, processes, logs, disk space, locks, and latches.
• Automated database monitoring and reporting functions utilizing UNIX SHELL scripts, and PERL scripts.
• Implemented Oracle Data Guard for disaster recovery.
• Cloned an Oracle database for the purpose of testing.
• Upgraded Informatica Power Center 7.1.1 to 8.1 and Oracle 9i to Oracle 10g.
• Served as ETL expert in all phases of development, implementation, and production support.
• Worked with Legacy application teams to determine best approach of procuring source data.
• Performed data mappings from source systems to new target structures on the database platform.
• Worked with System Admins and Network teams to eliminate the events that increase load time or job failures.
• Worked with MicroStrategy/OLAP developers to ensure that they has the database objects they needed.

Confidential, Plano, TX

Informatica Admin

Responsibilities:

• Participated in creating the Data Warehouse architecture
• Established procedures pertaining to the database design, security, and maintenance.
• Built the infrastructure and the star schema for the Accounting Data Mart.
• Implemented the Logical/Physical Data Model.
• Defined and built the Logical and Physical stages for Data Transformation.
• Designed and created the summary tables.
• Developed ETL mappings in Power Center 7.1.2
• Performed data mappings from source systems such to new target structures on the database platform.
• Designed, developed and maintained Power Center workflow load processes to data warehouse.
• Designed, wrote, and implemented procedures that controlled Data Warehouse refresh strategies.
• Wrote shell programs for the automation of Data Warehouse Autosys Job Control.
• Designed and implemented utilities, which automated several DBA functions and maintenance activities including setting up alerts and collection of important database health indicators.
• Generated web reports using Shell scripts and HTML.
• Monitored activities related to data growth, performance and availability.
• Modified and Maintained existing Java programs.
• Migrated a Sybase Database to an Oracle Database

Confidential, Irving, TX

Informatica Specialist

Responsibilities:

• As an Informatica Admin me was responsible for maintaining, improving, and monitoring the system.
• Elicited and documented business requirements from the user community.
• Modified existing data models to accommodate new business requirements.
• Merged several databases into one database. Handled repository backups, restoration, and failover.
• Performed system testing and assisted users in User Acceptance Testing.
• Performed database sizing and capacity planning.
• Performed DBA tasks such as disk layout architecture, performance tuning, and backups.
• Assisted developers with issue resolution and patch/fix identification and implementation.
• Helped in Deploying of major software releases, feature enhancements, and bug fixes.
• Implemented data replication and Materialized Views between production & Real-time reporting systems.