SUMMARY

• Total 14 years of professional experience in IT consulting and services for Finance, Banking, Communications, Mortgage, Insurance, Sales and Health Care industries. Having experience in Data Warehousing, Business Intelligence, ETL/ELT, EAI, OBIEE, EDI - B2B, Netezza/Teradata appliance, Data Profiling/Quality and Big Data projects. Involved to virtualize IT infrastructure, better utilize resources, provide better service to application development and production support.
• 7+ years of experience on Administration with Informatica products
• 7+ years of experience on ETL Design/Development using Informatica and Ab Initio tools
• Life cycle experience in Data Warehouse, Business Intelligence, ETL/ELT, EAI, OBIEE, EDI-B2B, Data Profiling and Big Data projects
• Installed/Upgraded Informatica PowerCenter 5.x/6.x/7.x/8.x/9.x on Red Hat Linux, IBM AIX and Sun Solaris Applied Hot Fixes as required.
• Has experience with Informatica Performance Tuning, Troubleshooting, Backup & recovery, Code Deployment & Pro-active health check
• Co-ordinate with Informatica Technical Support for any issues or hot fixes/patches
• Setup and Maintain Disaster Recovery services for Informatica PowerCenter
• Has experience to provide technical support for teh Informatica environment
• User and Application/Project setup for Informatica security management
• Installed and configuredInformaticaData Quality (IDQ)
• Experience with analyze compatibility of Informatica products with teh hardware/software
• Performed Root Cause Analysis, performance monitoring and application related issues
• Experience in creation and maintains new user accounts, permissions for different folders
• Experience in taking periodic backups and restores as required
• Configured Team-based development, Real-time edition and Change data capture
• Has experience creating and maintaining Prod and Non-Prod Environments.
• Experience on Enterprise Grid clustering, Load Balancer, Failover and High Availability.
• Experience with authentication methodologies: Active Directory, and/or LDAP
• Experience in UNIX shell scripting, automation of ETL processes using Crontab, Autosys, Tidal, DAC and Tivoli.
• Worked with Informatica SRs (support requests) and infrastructure support team to investigate and resolve issues
• Experience in Performance Tuning and Optimization of Informatica Power Center mappings, sessions and workflows
• Experience in advanced Power Center features like Recovery and Pushdown Optimization
• Experience in Integration of various data sources like Oracle, SQL Server, Flat Files, XML files, COBOL files and Mainframe
• Has experience on 24X7 Production Support for Informatica Product Suite Services

TECHNICAL SKILLS

Big Data: Hadoop - HDFS, Map Reduce, Hive, Pig, Sqoop, Flume, Oozie and ZooKeeper

Monitoring tools: Ganglia, NagiOS and Pro-Active monitoring

Operating Systems: Linux (Red Hat Enterprise, Cent OS, Ubuntu), AIX, Solaris, HP-UX and Windows

Languages: C, C++, Java, SQL, PL/SQL and Shell Scripting (Bash, Korn and C)

ETL Tools: Informatica Power Center 5.1/6.2/7.1/8.1/8.6/9.0/9.1/9.5/9.6, Informatica Big Data Edition 9.5.1, AB Initio 1.11/1.12/1.13, Co>Operating System 2.11/2.12/2.13

Change Data Capture: PowerExchange for Netezza, Oracle, DB2, Mainframe and TIBCO

Data Quality Tools: Informatica Data Quality (IDQ) 9.1/ 9.5.1/9.6.1, Informatica Data Explorer (IDE) 9.1/ 9.5.1/9.6.1, Informatica Developer/Analyst, Address Doctor, DVO (Data Validation Option) and Master Data Management (MDM) 9.5.1/9.6.1

EDI Tools: B2B Data Exchange 9.0.1/9.1.0/9.5.1 (DX), B2B Managed File Transfer (MFT) 4.2/4.3, B2B Data Transformation 9.0/9.1/9.5 (DT), VLTrader 4.3 and TIBCO

Databases: Oracle EBS, Oracle 8i/9i/10g/11g, TeradataV2R5/6/V12/V13, SQL Server 2000/2005/2008, DB2 8.1, Netezza 6.x/7.x and MySQL

Database Utilities: Teradata Parallel Transporter (TPT), Multi-Load, Fast Load, Fast Export, TPump, BTEQ, SQL Loader, Netezza utilities (NZLoad, NZSQL and NZPLSQL)

Developer Tools: Aginity, Toad, SQL Developer and SQL Assistant

Testing Tools: Test Director 7.6 and Quality Center 8.2/9.2/10.0

Scheduler Tools: TIDAL 5.3, Active Batch V7/V8, DAC 7.9.5/7.9.6 /10 g, Crontab, Tivoli 5.0/8.3, Maestro, Autosys and Control-M

Version Control Tools: Clear Case, Harvest CM 5.1.1, Visual Safe Source 6.0 and Share point

Ticketing Tools: Microsoft Service Manager, JIRA and BMC Remedy

PROFESSIONAL EXPERIENCE

Confidential, Carrollton, Texas

Senior Informatica Consultant

Responsibilities:

• Installed/Upgraded Informatica products 9.5.1 HF2 to 9.6.1 HF1
• ConfiguredInformaticaPower Center repository service, Integration service, Web services hub, Metadata Manager and Reporting Service (Data Analyzer)
• Configured Model Repository, Data Integration and Analyst services for Data Profiling and Quality
• Configured Enterprise Grid clustering and High Availability
• Worked on MDM installation and configurations
• Worked on Security management, creating Groups, Users and Folders
• Involved in code reviews and migrations from DEV -> QA -> UAT -> PPRD -> PROD
• Configured LDAP security
• Created Shell scripts to automate code deployment, monitoring, backups and cleanup
• Worked with different teams on POC for new implementations
• Support for Informatica environment Maintenance
• Configured Reporting and Dashboard services for PowerCenter, Metadata Manager and Model Repository (Data Quality)
• Installed/Configured Test Data Manager (TDM) service for Data Subset, Data Masking and Data Generation
• Migrated Non-production environments from physical machines to VMware vCloud
• Created vApps templates and reused them as needed
• Migrated Production environments from physical to virtual machines
• Installed Netezza drivers and configured odbc.ini file
• Installed and configured Netezza Bulk Reader/Writer plug-in
• Worked with DBA’s, Linux, Network, Storage and Exchange teams
• Worked as Production support on call rotation basis
• Involved in Change and Incident Management process
• Created Request For Change (RFC) and reviewed with CAB members
• Monitor Memory & CPU utilization of Linux machines; provide recommendations on capacity planning (Disk Space, Memory & CPU etc).
• Monitors and tunes ETL repository and system for performance improvements
• Identifies, researches, and resolves ETL root cause of production issues or system problems
• Worked on Informatica command line utilities
• Ensures to follow standards, policies and procedures set by client and Informatica best practices
• Created UNIX Shell Scripts for add/remove users through command line.
• Created Script to cleanup/remove teh Session/Workflow log files.

Environment: Informatica Power Center 9.5.1/9.6, Informatica Data Quality (IDQ) 9.5.1/9.6, Master Data Management (MDM), Oracle 11g, Netezza 7.x, Aginity, SQL Server, Linux, SQL Developer, Windows 7, Microsoft Service Manager, Vmware, vCloud and Cognos.

Confidential, Philadelphia, Pennsylvania

Senior Informatica Administrator

Responsibilities:

• Installed/Upgraded Informatica products 9.1.0 HF3 to 9.5.1 HF2 to 9.6
• ConfiguredInformaticaServices for PowerCenter, Data Quality (IDQ), Data Profiling
• Configured Enterprise Grid clustering and High Availability
• Installed and configured Data validation Option (DVO)
• Worked on Security management, creating Groups, Users and Folders
• Used/Created OS Profiles for directory level security
• Created shell scripts for file cleanup and archival
• Involved in code reviews and migrations from DEV -> TEST -> PROD
• Worked on capacity planning and performance tuning
• Used Pro-Active monitoring tool for monitor Informatica services
• Worked on Root Cause Analysis for Production down time
• Implemented Disaster Recovery, Backup and Restore strategy
• Worked on monthly scheduled maintenance
• Configured LDAP security
• Created Shell scripts to automate code deployment, monitoring, backups and cleanup
• Setup DR Environment and testing
• Worked with different teams on any POC for new implementations
• Support for Informatica environment Maintenance
• Configured Reporting and Dashboard services for PowerCenter, Metadata Manager and Model Repository (Data Quality)
• Configured Informatica Big Data Edition to Hadoop connectivity and execution

Environment: Informatica Power Center 9.1/9.5.1/9.6, Informatica Big Data Edition 9.5.1, Informatica Data Quality (IDQ) 9.1/9.5.1/9.6, DVO, Oracle 11g, Netezza 7.x, Lawson 9.1, Hadoop (HDFS, MapReduce, Hive and Pig), Linux, AIX, Erwin 7.3, Toad 10.5, Windows 7, Business Objects and QlikView.

Confidential, Delaware

Senior Informatica Administrator

Responsibilities:

• Was responsible to setup for Development, Testing and Production environments
• Installed 9.0 for Informatica PowerCenter, B2B Data Exchange, B2B Data Transformation and Managed File Transfer tools
• Upgraded 9.0 to 9.5 Informatica PowerCenter, B2B Data Exchange, B2B Data Transformation and Managed File Transfer tools
• Applied Patches/Hot Fixes (HF)/Emergency Bug Fixes (EBF) as required
• Worked on PowerCenter Administration, B2B Data Exchange and MFT console
• Install/upgrade Informatica B2B and HIPAA (EDIFECS) validator components.
• Created Users, Groups and Folders
• Installed and configuredInformaticaData Quality (IDQ) and Data Explorer (IDE)
• Created directory structure on NAS (Network Attached Storage) and SFTP server for Partners/Countries and Accounts/Departments
• Created code migrations plans DEV -> UAT -> Prod
• Created backup and restore procedures for PowerCenter and B2B Data Exchange repositories.
• Created UNIX shell scripts for start, stop Informatica services and for deployment DT projects/services and PowerCenter mappings/sessions/workflows
• Created Grid clustering, Load Balancer, Failover and High Availability.
• Worked with teh BI Application Analyst to implement vendor ETL software patches and updates
• Created Prod DR Environment and tested periodically
• Worked on Root Cause Analysis for Informatica and ETL job failures
• Worked on monthly scheduled maintenance, Cleanup and Archival scripts
• Worked with Informatica vendor for any product related issues

Environment: Informatica PowerCenter 9.0/9.5, B2B Data Exchange (DX) 9.0/9.5, B2B Managed File Transfer (MFT) 4.2/4.3, B2B Data Transformation (DT) 9.0/9.5, Informatica Data Quality (IDQ) 9.1/9.5.1, Informatica Data Explorer (IDE) 9.1/9.5.1, Address Doctor, Geocoding, MS SQL Server 2005/2008, Oracle 11g, IBM AIX, TIBCO, Erwin 7.3, Windows 2008 server, Windows XP SP3, Windows 7, Ipswitch WS FTP 12, ActiveBatch V7/V8, AS/400, Java, Web Services, Windows PowerShell, SSIS, DCS, Cognos 8, IBM Unica Campaign 8.x and SharePoint

Confidential, Philadelphia, Pennsylvania

Senior Informatica Administrator

Responsibilities:

• Informatica Administration includes managing domain, grids, nodes, services, folders, installing and applying patches/HotFixes, starting and stopping of Informatica server and services.
• Installed and configured Informatica 8.1.1 on Red Hat Linux.
• Upgraded Informatica 8.1.1 to 8.6.1 with HotFix11
• Installed Teradata Utilities and Teradata Parallel Transporter (TPT) on Linux machine
• Tuned ETL processes inside and outside of teh Informatica.
• Created UNIX scripts for running Cron jobs
• Involved in migrating teh repository objects from Development to Testing to Production systems with necessary Manager’s approvals
• Involved in Administration - creation of Folders, Users, User Groups, and giving privileges.
• Worked with DBA in order to do some performance tuning for ETL
• Configured DAC-Data warehouse Administration Console for running of ETL jobs/Informatica workflows.
• Created and scheduled UNIX script for daily backups of teh Informatica repository for production environment.
• Used DAC to schedule Informatica workflows for Full and Incremental ETL loads
• Written scripts for FastLoad, MultiLoad and TPump to load data into NDW Teradata
• Involved in DAC code migration process
• Used Pushdown Optimization (PDO) for ELT jobs
• Worked on Production Support and Root Cause Analysis documentation
• Designed SCD Type II for Dimension Tables using Dynamic lookup
• Involved in sending Informatica downtime notification emails to Informatica users
• Involved in performance tuning of ETL transforms and workflows
• Upgraded DAC 7.9.5 to 7.9.6
• Worked on Enterprise Grid clustering, Load Balancer, Failover and High Availability.
• Installed and Configured DAC 10.1.3.4 on Non OBI projects
• Configured Metadata Manager and Data Analyzer Services

Environment: Informatica PowerCenter 8.1.1/8.6.1/9.0, OBI Apps 7.9.5/10.1.3.3, Oracle EBS, Oracle 10g/11i, Amdocs, Mainframe, SQL Server 2005, Teradata V12, Erwin 4.1, Red Hat Linux, Windows XP, OBI Reporting, Shell scripting, Crontab, DAC 7.9.5/7.9.6, Toad 9.1, SQL Assistant 12.0, Hadoop and SharePoint.