SUMMARY:

• 10+ years of Data Integration and Warehousing experience primarily using Informatica PowerCenter;
• Extensively worked on Data Analysis, Data Profiling and Data Cleansing;
• Solid experience in relational and multi dimensional modeling (logical and physical);
• Model and build ETL mappings for Data Warehouse, BI and data delivery to sub - systems;
• Performance tune mappings, sessions and configure workflows for efficiency;
• Manage PowerCenter Repository services and agents in a GRID configuration;
• Solid experience in version upgrades and repository Version Control;
• Monitor, troubleshoot and resolve issues with PowerCenter Repository, services and agents;
• 24/7 Admin support for Informatica PowerCenter production servers, Repositories and agents.
• Experienced in administration and development on Informatica PowerCenter versions 8.x/9.x; SQL Server, Oracle and other database technologies in support of Enterprise Data Integration, Business Intelligence Systems and Data Warehouses. Key member of team that implemented automated code review and migration using Performance Monitor and currently implementing migration of enterprise applications and data marts to Amazon Cloud.
• Administration includes Install, Upgrade, Configuration for Load-Balancing and Redundancy, Security, Backup & Recovery, Monitoring, Data Analysis, Documentation of architecture and associated processes. Development includes ETL processes to extract data from various disparate data sources, Transform and load target systems for Enterprise Data Integration, Warehousing and Business Intelligence Systems.
• Information Systems experiences with financial, manufacturing, military and telecom industries as an Informatica ETL Developer/Administrator, Database Administrator and Production Systems Manager.
• Audit experience in areas of corporate compliance under SOx controls.
• 24/7 Administration and support of Production Microsoft SQL Server 7.0/2000/2005 and Oracle 9i/10g/11g Databases for multiple instances of Transactional, Decision Support (BI), WEB and Large Databases (Warehousing); Tuning, DTS, Replication, Security, Code Review and all aspects of administrative tasks; DBMS Monitoring with PerfMon, Profiler and Quest Tools; SQL Log Shipping/Oracle Data Guard for standby databases; Database version upgrades; Disaster Recovery planning, documentation, process implementation and testing exercises; Implementation of pro-active processes to alert on issues.
• Primary focal for Enterprise Financial Systems Data Warehouse, Reporting and Portal environments.
• Determine production resource requirements and manage resource teams for production support as well as month and quarter end processing. Identify production issues and risks and coordinate resources to provide quick resolution inside and outside the company. Communicate environment status to senior management and customers daily. Utilize Change Control software to manage issues and resolution under SOx controls.

TECHNICAL SKILLS:

• Informatica PowerCenter MS SQL Server Database Oracle Database
• Informatica Proactive Monitor Data Warehouse Lifecycle Data Governance
• Informatica Data Explorer DB Monitoring Disaster Recovery Planning
• High Availability/Redundancy Data Integration System Controls under SOx
• Code Review

PROFESSIONAL EXPERIENCE:

Confidential

Informatica Administrator

• Member of Informatica Administrator Team for GE Aviation Group. The team supports over 1650 developers based in various US cities but mostly offshore. The environment is Informatica 8x/9.1 Enterprise Grid on LINUX, Oracle, SQL and Teradata databases in support of GE’s Secured Export Controlled Aviation business. Currently provisioning Informatica environments for migration to AWS Cloud.
• The team’s responsibilities include the following for Development, QA and Production environments:
• Informatica PowerCenter 8x/9.1 Grid administration for very large and diverse warehouses
• Informatica security - Developer/User access to multiple Secured/Non Secured repositories
• Provisioning of legacy code for upgrade to current version and the Cloud
• Mapping design/code review to enforce Standards and Best Practices
• Code migration (mappings, sessions and workflows) following Code Review
• Implemented auto code review and migration if prerequisites are met
• Mentor Junior developers in coding standards and Best Practices
• Troubleshoot and resolve PowerCenter issues through a Help Desk System
• Troubleshoot and resolve related Database and System issues with appropriate resources
• 24/7 On-call rotation for world-wide production support
• System wide communication for outages and maintenance exercises
• Other duties as assigned

Confidential - Aliso Viejo, California

Database Consultant/Information Systems Consultant

• Operating a Database/Information Systems consulting company advising and resolving systems issues.
• Services include analysis, planning, designing and implementation of new systems/databases; training and mentoring administrators of existing systems on industry Best Practices; training Systems Administrators on problem solving methodology; review and implementation of disaster recovery procedures.

Confidential

• Systems Analysis Project to resolve systemic IT issues
• SQL Server 2005 Data Integration Project for reporting using TSQL and Integration Services

Confidential

• Systems Analysis Project to resolve systemic IT issues

Confidential

Production Manager

• Primary focal for Enterprise Financial Systems Data Warehouse, Reporting and Portal environments.
• Determined production resource requirements and managed resource teams for production support as well as month and quarter end processing. Identified production issues and risks and coordinated resources to provide resolution inside and outside the program. Communicated environment status to management and customers. Utilized Change Control software under SOx controls.

Confidential - Irvine, CA

Senior Informatica/Database Administrator

• Primary administrator of Informatica PowerCenter version 7x/8x for data warehouse
• Managed Informatica Repository upgrades, patches, backup, restore, tuning and security
• Support for Real-Time data extracts and loads into data warehouse
• Participated in developer code review to encourage use of coding standards and best practices
• Logical and physical data/database modeling using multi dimensional models
• Development of re-usable objects to standardize data cleansing and programming functionality
• Standardized procedures for code migration to QA and production environments
• Implemented Version Control in QA and production environment and synchronized environments
• Database support (SQL 2k5 & Oracle 10g) for new and existing production data warehousing projects
• Business Intelligence/Reporting database support on Oracle and SQL Server
• Managed and monitored all SQL Server and Informatica Repositories; Services and Agents
• Designed and implemented database strategies to improve query performance
• Documented administration tasks and procedures
• Mentoring junior developers on mapping techniques, best practice and standards
• Troubleshoot DBMS issues using Performance Monitor, Profiler and Quest Tools

Confidential - Monterey Park, CA

Senior Business Intelligence (Informatica) Developer

• ETL development with Informatica PowerCenter version 7x on UNIX
• Documented detailed coded strategies and processes using Visio
• Logical data modeling using slowly changing dimensional model
• Built Informatica maps to extract, transform and load data into Data Warehouse
• Participated in code reviews for compliance with established development processes
• Collaborative efforts with Business and Data Analysts to develop coding requirements

Confidential - San Diego, CA

Senior Database Administrator (Consultant)

• Coordinated multiple transactional and decision support databases on assigned servers
• Managed server patches and updates for operating systems and database systems
• Managed database requirements on new projects with project managers and developers
• Database administrative support for new Oracle on Linux Data Warehousing initiative
• Database support for on-going application development and pro-active systems processes
• Monitored and troubleshoot systems issues with Performance Monitor and Profiler
• Managed code review, analysis and tuning of developed script before production rollout
• Trained and mentored new staff on database best practices and standards

Confidential - San Bernadino, CA

Contractor SQL Server DBA

• Worked with analysts to convert and merge an existing Call Center MS-Access database into a new SQL Server 2000 proprietary application database. My duties included analysis, extraction, transformation, and mapping of disparate fields from source MS-Access database to SQL Server 2000 database using TSQL scripting and DTS.