SUMMARY:

I have extensively worked on suite of Informatica products (Power Center 9.6.1HF2, Informatica Data Quality 9.6.1HF2, Metadata Manager 9.6.1 HF2, Dash Board & reporting, TDM - Data Masking Data Sub setting 9.6.1 HF1, ILM 6.4 Data Archiving, Data Validation etc.). I was involved in establishing Business Intelligence Competency Center, Data Governance, Metadata Maturity Model For Business Terms & Information linkages to data assets. Implemented Enterprise Data Warehouse for a Major Bank which includes many subject area like Core Bank, Debt Investments, Foreign Trade, Fixed Deposits, Credit swaps, Anti Money Laundry, Basel II etc. being with Enterprise Architecture team I was able to establish the linkages between Business services, Business process, Data & IT assets, future state an IT organization and define touch points between each framework (ADM, OPM, SDLC/ADUP, and ITIL). Member of Enterprise Architecture Board and Change Management, worked with EAO, PMO, SMO, and CMO to ensure outcomes are business driven.

TECHNICAL SKILLS:

DWH ETL Tools: Specialized in Informatica 9.6.1 HF2, Power Exchange 9.6.1 HF2Informatica IDQ 9.6.1HF2, ILM-TDM 9.6.1 HF1 and B2B etc.

Databases: Oracle All Version, SQL Server

Oracle HA: RAC on Linux/Solaris, shareplex, golden gate, VERITAS Cluster etc.

EMC Storage: Tier 2 Clariion CX Series.2

OS: Solaris/SunOS, Red hat Linux, IBM AIX, Windows

File Systems & VM: VERITAS Volume Manager, VXFS, VERITAS cluster file systemASM, NFS, ZFS, CIFS etc.

Databases: Oracle 7/8i/9ir2/10gr2/11gr2/12c, DB2 UDB 9.7, SQL Server 2k, 2008

Data Quality: Informatica IDQ (Athenor and Axio), Siperian MDM Administration.

BI Tools: OBIEE 10g, 11g

Storage: Tier 2 NetApp (ONTAP 8.1)

Apps servers: IBM Web Sphere 6.1,15, 7.0.0.17, Hadoop Cloudera Hadoop Cluster (HDFS)

RDBMS: Oracle 11g, 10g R2, 9.2.6(9iR2), 9.0.1(9iR1), 8.1.x(8i), 7.3.4,8.0.x, SQL Server 2005, 2000, DB2 UDB 9.7,9.5,9.1,8.2

Replication/Integration tools: SharePlex 5.1, Oracle Streams, Power Exchange

ETL/BI Tools: OBIEE 10.x (DAC, Informatica, OBIEE Reporting tools, BI Apps), Informatica PC 5/6/7/8.1.1,9.0.1, PWX 5.2/8.1.1, Metadata Manager 8.1.1, Informatica IDQ Athenor/Axio etc

Operating Systems: Solaris 10, 9, 2.7, 2.6, 2.5.1, Red hat 4.x/5.x/6.2, IBM AIX 4.1, 5.1, 5.2,6.1

Query Languages: SQL ISQL PL/SQL, TSQL.

Hardware Worked On: Sun Enterprise Server 3500,3400,Sun fire 10k, 12k, 6800, 3800, 880, 480

Storage & SAN: DMX1000, DX4, Clariion CX4, CX700, CX600 (SAN/SAN). Netapp FAS 6040

WORK EXPERIENCE:

Confidential, New York

Informatica Admin/Architect

Responsibilities:

• Installed Informatica in all environments, Upgraded Informatica Platform from 8.6.1 to 9.5.1/9.6.1 HF2, Maintaining Informatica Platform (Power Center, IDQ, MM, PWX, DVO, and ILM-TDM), Applied Hotfixes and EBFs. All changes are applied following SDLC process.
• Proposed migration strategy of Informatica Objects (PC, IDQ, MM etc.)
• Used versioned repository, dynamic deployment group for migration, used SVN version control for other objects like shell scripts & database scripts.
• Supporting developers and suggesting them Informatica to use best practices, helped developer in setting up the right encoding, helped developer in resolving common issues. Configured PWX for SQL Server & Oracle with TDE enabled.
• Suggested alternate architectures for HA & DR based on Enterprise Architecture team input on RTO, implemented systems in DR using Informatica spanning domain architecture.

Confidential

Informatica Architect

Responsibilities:

• Installation, maintenance and upgrade of Informatica Power Center from 7.1/ 8.1.1 to 9.5, configured and maintained session on grid control 2 node cluster environment, Power Exchange 9.5, Informatica Data Quality 9.5, Oracle Golden Gate 11g and Metadata Manager 9.5.
• Setup Code Migration strategy according to SDLC process and Informatica velocity best practices, used Version control repositories, create dynamic deployment groups and roll back of deployment if necessary. Responsible for preview and code migration to SIT/UAT/PROD.
• Maintained PCI compliance for data stored onto the file system data masking, write shell script to automate jobs using third part scheduler, wrote shell scripts for archiving and cleanup, backup the Informatica repository etc.
• Integrated Power Center & Metadata Manager with Active Directory (LDAP) and deployed Metadata Manager on IBM WebSphere Application Server (network deployment).
• 30% of the time developing complex mappings using Informatica velocity best practices mapping standards, extracted data from AS/400 DB2, VSAM (VMS Cobol) file, XML, DB2, Oracle, SQL Server, MQ, Swift format file etc.
• Involved in the full implementation of DWH project, developed new maps (slowly changing Dimension Type 2), modified existing one for data warehousing and BASEL II project; suggested and implemented error handling. Assisted in data reconciliation process for ALGO, ACLM and Basel II.
• Implemented load control tables for recovery and reload of data into the target systems, automate the generating parameter file for daily and monthly load from the control tables.
• Excellent skill on performance tuning of database SQL, Informatica Power Center and inefficient mappings.
• Used Power Center data profiling to identify the Data Quality issues and scheduled reporting to source system owner for getting it fixed.
• Installed, configured and maintained Informatica Siperian MDM, established to other systems using MQ & Adaptors. Established Data Governance which includes Data steward, Business Analyst and source system business owners.
• Installed DB2 software, created databases and Upgraded DB2 databases from DB7.2 to 9.1 twostep upgradeConfigured backups exported and imported database objects, performance tuning, migrated full databases from DB2 9.1 to Oracle 11g and taken care of different Foreign character encoding as part of DB2 decommissioning projects...
• Installed and configured WAS 6.1 and 7.1 application servers (3 node Cluster), maintained, upgraded, applied fix packs and deploying code provided by development team into production following complete release management process. Applying configuration changes as required, writing shell scripts for archive log files and automation, write maintenance jython scripts.

Type of Sources/Target used: Oracle, DB2, Informix, Sybase, SQL Server, XML, Cobol Copy Book using Power Exchange, Informatica Data Quality, Data Masking etc.

Confidential, California

Informatica Professional Services (IPS) Consultant

Responsibilities:

• Installed, configured and supported Siebel Analytics which is also known as OBIEE suite.
• Designed database for company standards where entire enterprise lookup for company standards.
• Involved in the full Data Quality life cycle (Assessing Data Quality, Defining Data Quality Targets, Designing Quality Enhancement plans, Implementing Quality Enhancement Plans, and Monitoring Data Quality Vs Targets).
• Analysis phase includes (Assess data, completeness, conformity, consistency, data duplication, integrity, accuracy )
• Designed and developed complex mappings from source systems to Enterprise Data Warehouse and from EDW to Data Marts. - Type 2, Type 3 dimensions, designed and developed complex mappings from xml and cobal sources to EDW, designed Crosswalk tables for translation between new and old systems for data integration, designed Job processing control tables to monitor jobs (number of rows loaded, job kickoff time, job end time, job status, Batch ID, etc.).
• Designed and developed complex workflows using command task, decision task, assignment, timer, Event waits, Event Raise, custom shell scripts etc.
• Designed and developed recoverability procedures if the job fails. Implemented error handing to capture errors into database tables for reconciliation purpose.
• Analyzed applicability of new features to enhance existing session performance, analyzed Informatica mappings and sessions for performance impact, helped customer in educating the impact of repository configurations on performance and load on the system, implemented session partitioning and explained Informatica partitioning benefits.
• Upgraded Informatica for more than 9 customer sites (Upgraded options metadata manager, SAP Power Connect, Teradata, etc) Upgraded from 4.7 Power Mart to Informatica 8.1 (two/three steps upgrade), moved repository from Informix to oracle database, and wrote shell scripts for clean shutdown/startup of all services including MM, backup shell script, file parsing script, etc.
• Developed blue print for data warehouse initiative, baseline architecture, proposed architecture (applications, high level data entities, prebuild analytics, Hardware & Software Infrastructure), guidelines on data governance, business Intelligence competency, etc.
• Developed and enhanced TRM, looking at the corporate strategic initiatives, added software and hardware products by looking at the current infrastructure, Gartner & Forrester rating wherever necessary, and consulted with ARB & APC for final approvals.
• Implemented Power Exchange CDC for Oracle/SQL/DB2.
• Gave training on PWX CDC for Oracle/SQL server.
• Followed Velocity Methodology in the development of Informatica ETL mappings.
• Configured Active registration for CDC objects enabled supplemental Logging for oracle objects, installed and configured power exchange listener for Oracle and SQL Server, configured ODBC interface using power exchange ODBC drivers and developed mapping using Power Exchange for providing change data captures (CDC) from OLTP to ODS.
• Responsible to design, development and unit test different components (Informatica mapping, PL SQL, UNIX shell scripts) to maintain the data marts (Extract data, Transform data, Load data), Setup Procedures & Mappings to Extract, and Transform and Load (ETL) data from Operational and Legacy Systems to the Data Warehouse tables by using Informatica.
• Created partitioned on tables and indexes for better performance, tuned SQL statement, and added hints.
• Exported, Imported and customized table statistics for SQL Plan analysis.
• Created outlines for existing statements to use proper indexes.
• Collected Statistics and histograms for oracle to generate accurate SQL Plan.
• Tuned database using STATPACK, AWR, OEM diagnostics and tuning pack, also used Spotlight.
• Created functional index, bitmap index, materialized view for better performance.
• Activated SAR reports and OEM reports for capacity planned and tuned the database.
• Proactively catching top SQL s, tuned them and worked with the application team to implement it.

Confidential, California

Team Lead for Production/Development DBA

Responsibilities:

• Supported 128 Oracle Instances from 200Gb to Multi Terabytes under mission critical environment, 26 SQL Servers and 10 DB2 Instances.
• In charge of relocation of all databases of Confidential data center from San Rafael, CA to Petaluma, CA Data Center and collaborated with Sun Team, Firewall team, Storage team, etc.
• Planned and Consolidated Databases into a single Sun 6800 multi domain machine to save licensing cost and to better the utilization of resources. Also activated SAR reports on Unix servers to generate performance analysis reports and for capacity planning, involved in the change control meetings during consolidation and conducted frequent meetings with system admin to migrate applications and databases from other Solaris machines to shared server environment with a minimum downtime of few minutes using various methods like mirroring, deporting and importing EMC volumes, configured high availability shared server environment using Veritas cluster software
• Implemented EMC power path host base software for SCSI IO load balancing and automatic path failover, Migrated database from E4500 machines to E6800 multi domain sun enterprise server, Configured LAN based Backup using Veritas NETBACKUP and SAN based backup using EMC replication Manager tool and shell scripts.
• Installing oracle binaries 7.x/8.x/9.x/10gR1, creating databases, upgrading databases 7x/8.x/9.x configuring kernel parameters, reorganizing databases, migrating VLDB using transport tablespace, performance tuning, SQL Tuning, configuring remote backups using RMAN & Netback up, recovering database in case of media recovery
• Supporting oracle optional products like Oracle Spatial Data, Oracle Intermedia, Oracle Internet File System, providing reports and discussing with management for capacity planning, providing weekly status reports, attending change control meetings, and taking ownership for critical problems.
• Developed company standard for Solaris machines like disk layouts with respect to application best practices, naming convention, etc. and automated Solaris Installation using Jump Start Server.
• Configured HBA to use EMC disk array(FA ports) encapsulated EMC LUN s into Veritas volume manager
• Automated EMC snapshot or shot splits for all the databases using shell scripts.
• Setup and Configure Disaster recovery site using EMC replication technology and SharePlex 5.2.
• Installed and configured Oracle10g Real Application Cluster used ASM for disk management.
• Configure Logic/physical standby database for reporting and high availability.
• Configured LAN Backup for OS, Oracle using RMAN(Oracle agent) and SQL Server(SQL Server agent) Veritas NetBackup.
• Implemented Oracle Streams downstream capture for real time change data capture.
• Developed Oracle Standards for database Layout and followed Optimal Flexible architecture
• Mostly used VXFS, OCFS, ASM, UFS, NTFS, HTFS, Veritas Cluster file system for Oracle RAC on Solaris.
• Configured Oracle Real Application Cluster (RAC) on Linux and Solaris.
• Upgraded around 60 oracle database instances from 7.x to 8i/9i and from 8.x to 9i release.
• Implemented and Configured Oracle Enterprise Manager for database monitoring and database alerts, used Diagnostic and tuning pack for performance analysis.
• Installed SQL server 2000 under Active/Passive cluster environment. Created & registered databases, Configured mails agent, applied service packs & security “hot fixes”, migrated databases from one machine to another machine.
• Managed User security, Used DTS package to load and unload data from flat file, spread data file on different LUN to avoid data access and update contention. Configured snapshot and transactional replication environment for reporting.
• Installed, configured, applied fix packs, upgraded, configured HACMP, configured SAN/Network backup using EMC Replication manager and veritas netbackup, performance tuning, SQL tuning, analyzed system using snapshot & DB2Top monitoring and providing reports for capacity planning, managed security, integrated with LDAP, implemented and supported DPF(Data Partitioning), troubleshooted for any errors, analyzed db2diag.log / notification log / memory tracker / db2pd etc.

Environment: OS Platforms: Sun Solaris 5,6,7,8,9, Win2k

Hardware Platform: Sun Fire 280, V880, 3800, 6800. HP DL580’s, DEL 2250 etc

Software: Oracle 7.3.4, 8i,9iR2, Oracle Enterprise Manager, shareplex 5.2, Spotlight, ERWIN 3.5 etc

Storage Area Network: EMC Sym 5 Symmetrix 8xxx, Clariion CX600/500. SunT3 etc.