Informatica Architect/Admin

Objective:

** ***** ** ** ******** working as Tech Manager/Architect/Lead having expertise in various domains/technologies with proven ability to achieve goals and driving projects to successful completion.

Seeking a challenging position in DWBI Architectures, Application, Data and ETL Architecture areas

Work Status: US Green Card Holder / Permanent resident.

Summary:

Domains: Environmental sciences & Financial domain(Accounts Receivables, GL and financial reporting, Banking - Lending, Credit Card & OLTP (Online Transaction Processing) using ISO8583 Messages)

Accomplishments:

1. AMEX: Managed development of OLTP engine of AMEX-Private Payments product within 3 months. Company was awarded more projects after successful delivery of this $70 Million high profile/visibility project at AMEX.

2. Lockheed Martin: Deployed product in 2 months working 80 to 103.5 hours, achieving 100% Performance award/bonus. As high performer, offered CTM role in 5 months. Nominated DWH, ETL, BI & A architect - for ITS-ESE program.

Technical Skills:

Domains : Environmental sciences & Financial domain(Accounts Receivables, GL and financial reporting, Banking - Lending, Credit Card & OLTP (Online Transaction Processing) using ISO8583 Messages)

SDLC Processes : ISO 9001, SEI CMM, Waterfall, Risk based Models and Rational Unified Process.

Architecture Tools : Rational Rose, MS Visio, ERWIN, Embarcadero DBArtisan -ERSTUDIO, Enterprise Architect, UC4

Data Warehousing & BI Tools : Datawarehousing, Data Governance/Federation.Informatica PowerCenter 8.6.1/8.5.1/8.1.1/7.1.3 High Availability (Repository Service, PM Server, Repository Server Administration Console, Source Analyzer, Data Warehouse designer, Mapping Designer, Workflow Manager, Workflow Monitor), Power Exchange 861, Netezza 4.6, Microstrategy 8.1, Business objects 9.x

Platforms : IBM AIX 5.2, HP9000, Sun Solaris, IBM Mainframes, TPF

Operating Systems : MS Windows 2003 Server/XP/2000/NT Server /95/98 (4.0) (Administration). HP-UX 10.2x SUN OS 5.0/6.0(Solaris 2.0 / 3.0).

Programming Languages : C++, STLs, C, RogueWave iTools++ 7.0.A, Pro*C, OCI, ODBC, Embedded SQL, PL/SQL, XML, COBOL, JCL

GUI : Visual C++, MFC + ODBC,

Databases : DB2, Oracle 11g/10g/9i, 9i/10g XML DB, MS SQL Server, Sybase ASE 12.5, UDB, Oracle DBA , PLSQL

Protocols : TCP/IP, SNA vide DCP, MS SNA LU0,MS Active Directory – LDAP

Sripting : Shell Scripting

Professional Experience:

Union Bank, Los Angeles CA Feb ’11 - Current

Role/Project Informatica/DWH Tech Lead

Technologies used MS Visio, Windows XP, RHEL4 U7, AIX, Informatica Power Center 8.6.1, Oracle 10g/11g, MS SQL 2005, MS Active Directory – LDAP, Autosys

Accomplishments: Setup a Grid in UB production environment to resolve production performance issues & meet SLAs

Project Informatica Platform & Data Integration Architecture

Audit/Review of existing Informatica deployments in Shared & Project Environments. Proposed enhancements, automation techniques for Platform/Data Integration Architecture. Informatica platform LDAP integration with corporate Active Directory. Instituting Innovative automated Deployment, build & release processes using pmrep / infacmd server scripts. Coordinated & worked with Infrastructure/DBA teams to setup Informatica Grid & DR architecture & setup Proposed Metadata manager setup & installation for project teams to leverage PCMR, Runtime statistics. Assisting & Training project teams on ETL Architecture/Design/ Development with a view to performance improvements/enhancements

Wells Fargo, San Francisco Mar ’10 – Jan ‘11

Role/Project Informatica/DWH Tech Lead

Technologies used MS Visio, Windows XP, RHEL4 U7, Informatica PowerCenter 8.6.1, Oracle 10g, MS SQL 2005, Teradata V12/13, MS Active Directory – LDAP, LSF, NDM, ER Studio 8.5

Accomplishments: Automated Informatica Deployment, Learnt LSF, NDM within one month of being on board and guiding team.

Project Data Integration ETL Design & development

Audit/Review of existing Informatica deployments in Shared & Project Environments. Proposed enhancements, automation techniques towards Data integration architecture: On boarding, Metadata & Data audit frameworks, & automating the generation of data audit mappings. Leading a team of 4 resources for Design & development of informatica ETL as part of replatforming existing SQL Server DTS packages into informatica. Coordinating, assisting & training team members on issues related to LSF & NDM Coordinating & working with Infrastructure/DBA teams to setup Informatica sandbox VMWare environment. MTS Datamart Dimensional modeling & round trip engineering of database. Envisioned, designed & developed perl scripts to automate Informatica deployment process, code standardization.

Pfizer , New York NY Oct ’09 – Mar ‘10

Role/Project Data Integration Architect for Global Data Management group

Technologies used MS Visio, Windows XP, RHEL4 U7, Informatica PowerCenter 8.6.1, IDQ8.6.2, IDE8.6.2, Oracle 10g/11g, MS SQL 2005, Teradata V2R5, Informatica PowerExchange 861, MS Active Directory – LDAP, UC4

Accomplishments: Audit of Informatica DI platform 6 weeks – Informatica, Datamirror, UC4

Project Data Integration Architecture Audit/Health Check

INFORMATICA & DWH ARCHITECT: Audit/Review of existing Informatica deployments in Shared & Project Environments. Delivered Audit review report Proposed enhancements, automation techniques to Data integration architecture: Infa861-LDAP Integration, Physical, technical infrastructure changes, Informatica Grid Design. Server Monitoring portal, on boarding & Server/DI Platform security access processes. Worked with Datamirror, to replicate Pfizer Research Informatics data into the RIF (warehouse) staging tables. Proposed Customer /platform team on PWX 861 real-time CDC options/featureswhich would create a Seamless Data Integration platform with a Horde of Sources & Targets, compounded by the recent Wyeth Acquisition. Participated in IDQ/IDE POC Pilot effort. Created Flow diagrams for Setup/installation procedure. Reviewed & isolated Composite 4.5 to Informatica 8.1.1 ODBC interface issues.

H&R Block, Kansas City, MO July’09 – Oct’09

Role/Project Data warehouse , BI&A Architect / H&R Block , CDR

Technologies used MS Visio, Windows XP, HPUX , Informatica PowerCenter 8.6.1, Oracle 10g, MS SQL 2005, Netezza 4.6, Informatica PowerExchange 861, Bash Shell scripts, Microstrategy, MS Active Directory - LDAP

Accomplishments: Target Deployment of Informatica Architecture in 3 weeks, interfacing with SQLServer 2005, Netezza

Project H&R Block , CDR

INFORMATICA & DWH ARCHITECT: Coordinating client groups, Onsite & offshore team to build the Informatica system/data architecture, component interfaces, Conceptual Process Models & data flows, Working with Business operations stake holders, analysts, business operations staff, data providers, developers and DBAs to Initiate Data Integration, Governance & Federation processes & policies. Providing technical leadership and direction to numerous stake holders from directors to junior team members. Architecture & Installation of Powercenter 8.6.1 HF8 in Dev & Production Environment, User Security, Folder management. MS Active Directory LDAP Integration for Informatica Users/Developers. Configuring PowerExchange & Data direct ODBC pointing to oracle 11g, SQL Server 2005, Netezza 4.6. Recommended PWX CDC strategy to customer for incremental loading from numerous source tables. User & Folder/Project management using Repository Manager Data integration architecture, architecting the full lifecycle environment, and the physical, technical infrastructure architecture. Delivered - PowerCenter lifecycle strategy, Security structure, Shared objects strategy, Development standards, Deployment of PowerCenter architecture, Installation and configuration of PowerCenter Develop/Deploy Shell scripts to be able to automate repository scheduled backups using PMREP utility.

Imparting training : Datawarehousing concepts ETL Architecture, Design concepts & Development process using InformaticaTraining: Informal training on Microstrategy 8.1 Nov ‘08 – Jul ‘09

Lockheed Martin Corp. VA, USA - ITS-ESE program July ’05 – Oct ‘08

Role/Project Data warehouse , BI&A, Lead Technical Architect, EPA - Office of Water

Technologies used MS Visio, XP, Solaris 5.9 & 10 , AIX, Informatica PowerCenter 8.5.1/8.1.1/7.1.3, Oracle 9i/10g, Relational & XML DB, TOAD 8.0, Oracle Enterprise Manager 8.0, Shell scripts, PVCS, Solaris 10, ERWIN 7.1, Business Objects 9.x

Accomplishments: Deployed product in 2 months working 80 to 103.5 hours, achieving 100% in Performance award/bonus. As a high performer,I was offered CTM role after only 5 months. Promoted as ETL, BI & A architect setting DWBI Strategy & roadmaps.

DWH, BI&A ARCHITECT: Create Program DWBI&A Strategy & Roadmaps.Product evaluation: Business Objects, Oracle BIEEINFORMATICA ADMINISTRATION: Installation/upgrade of Informatica from 7.1.3 to 8.1.1 to 8.5.1. Maintain metadata, Security and Reporting. Imported, validated ETLs post migration from Informatica 7.1.3/8.1.1/8.5.1 Repository Manager Configured INFA Data direct ODBC pointing to oracle 10g Datamarts. User/Project management using Repository Manager. Created Dual boot of XP and Sun Solaris 10 installation, Oracle 10g and Informatica 8.5.1 for Solaris 10g.INFORMATICA DEVELOPMENT:§ Design & development of ODS , warehouse , ETL from WQX ODS to STORETW Data warehouse§ Modeling dimensional models utilizing a combination of slowly changing dimensions type1, type2, type3§ Arch & design for Data Integration, Governance, Management processes & policies.§ Developed shell Scripts to be able to automate workflow scheduling/sychronization and monitoring using PMCMD utility.§ Building Informatica Mappings & Workflows, tuning mappings, sessions, workflows and SQL queries.§ Coordinated Design, development of Scripts to automate Code generation to load payroll information into Lockheed Systems.§ POC to directly absorb the WQX XML feeds into the WQX database using Oracle 10g XML DB Features.

Project EPA – Office of Emergency Management. Hurricane Response KATRINA & RITA.

§ Building the team: Interviewing, Hiring Decisions, Project scoping, planning and tasks assignments.§ Coordinated client groups, team to build the system/data architecture, component interfaces, and Process Models & data flows.§ Arch & design for Data Integration/Governance/Management processes & policies.§ Data Modeling & Design of distributed Equipment tracking system § OEM Katrina data reporting -creation of New Hurricane response warehouse § Provided O&M, post launch technical support of KATRINA reporting systems, working 80- 100 hours a week.

Appix VA, USA January ‘05– July ‘05

Role Technical Lead.

Technologies used Sun Solaris, Shell scripts, SuSe Linux, SubVersion, WebDAV protocol, Win XP, HTML, MS Visio

§ SubVersion Installation/Administration, automate/facilitate application DB creation, Version control operations using shell scripts

Sr. Tech Consultant NASD (National Association Of Securities Dealers) , MD, USA Oct 2004 – Dec ‘04

Project SONAR.

Technologies used C++, PVCS , Oracle 9i, PL/SQL , Win XP, Solaris , Shell scripts, ERWIN 4.1, Model Mart

§ Design and development of break generation framework and Business Objects for CORPorate BONDS as part of the SONAR application. Developed using C++, Oracle PL/SQL, Coordinating the team for peer-peer reviews of Design, Code & Test Cases.§ Prepared DB Migration strategy involving Schema/data migration from Oracle 8i to 9i and Application Migration.§ Update SONAR Model for bonds

Sr. Consultant - America Online, Dulles, VA, USA Nov 2003 – Oct ‘04

Project Accounts Receivables system for Billing and Revenue systems’ division

Technologies used Embarcadero, ER Studio DBArtisan 7.x, LINUX, C++, CVS, Sybase 12.5,Oracle 9i, T-SQL ,PL/SQL

Accomplishments: Initiated Oracle Infrastructure Setup: Worked with DBAs for Architecture (Partitioning/Archiving) and replication. Architected Data Integration, Governance, Management processes & policies as part of SOX compliance & reporting effort. DB migration (objects & data) from Sybase to Oracle using Migration tools. Translation of T-SQL to Oracle PL/SQL. Re-design and development of transaction framework and Business Objects of Workflow application.§ Interacting with client groups for system/component requirements and data flows for the existing systems.§ Update AR system Data Model (39 Tables) to align with customer requirements involving extensive roundtrip engineering.§ Design and development of interfaces, and transactional logic, design and code reviews.

S1 Corporation, West Hills, USA July 2002 – Nov 2003

Role/Product Lead Architect / Loans Origination System for Branch Automation Suite.

Technologies used VC++, Win2K, VSS, Clear Case, Redhat Linux, Shell Scripting, XML, PL/SQL (Stored Procs), MS Visio

Accomplishments: Was the Go-to person for clients, management & team whilst guiding application architecture & development. Arch & design for Data Processing/ Governance, Management processes & policies. Architected Redundant Database Infrastructure for the Loan Origination and BSI Printing interfaces. Tool: RADWare. Initiated revamp of Synovus network security to use IPSEC Routers.§ Extensive client facing for feasibility analysis, building proposals, user requirements and Coordinating team to create usable design§ Prepared concept papers, coordinated team to develop incremental prototypes § Planned and Initiated Procurement and Setup of Database/Configuration Management servers.§ Architected Loans Origination suite interfacing with Metavante, Equifax Credit Bureau, and BSI (Bankers Sys Inc) Print Interfaces.

American Express May 2000 – June 2002

1. Product AEGIS (AmEx Global Interface System) Apr’01 – May ‘02

Role Tech Architect.

Technologies used NT 4.0, Solaris 2.6, C++, VC++, COM, DCOM, COM+, MTS, UNICODE, Internationalization (UTF-8)

Accomplishment: Supported 2 projects working ~80 hours a week which earned the company kudos from AMEX (customer).§ Architected,delivered a robust, performance based, Fault tolerant system (wrt communication using TCP/IP, SNA, X.25 protocols, application components and links to the Stratus) delivering International ISO transactions into AMEX network for authorization.§ Designed and developed the core message transfer modules, and generic File I/O and IPC libraries.

2. Role/Product Lead Tech Architect / Private Payments May’00 – Apr ’02

Technologies used Sun Solaris 2.6, ISO C++ with RogueWave iTools++ 7.0.A, Multithreading, DB2, UDB, E-SQL, Datawarehousing, COBOL, JCL

Accomplishment: Managed development of OLTP engine of AMEX-Private Payments product within 3 months. Company was awarded more projects after successful delivery of this $70 Million high profile/visibility project at AMEX involving: Technical Coordination of over 75 People, 6 groups within American Express for dev of the OTLP authorization engine to prototype in 3 weeks, Product launch in 3 months ReArchitected CAS Private Payments / Authorization components (first in history of Amex) to Include (a) Fault Tolerance (b) A recovery mode for DCP Stand-in involving design changes to CAS (Credit Authorization System).§ Multi-Threaded D&D of PP TXN Authorization component. For AMEX, this project interfaced diverse systems/platforms. Post-launch technical consulting across multiple platforms. § Coordinate with web development team to design/develop trend charts with GAP Analysis of customer credit information.

Enterprise Software Solutions – Client PCORDER.COM August 1999 – May 2000

Role/Product Sr Consultant / Compaq Canada and Sales Force Intranet

GUI for a workflow based system (Image First Office) using VC++ 6.0 and Database APIs. Development of 4 Modal Dialogs.

IBM Global Services, Sydney, Australia February 1999 – August 1999

Role/Project Lead Technical Architect for Telecom infrastructures. ITP infrastructure development ,Sun Solaris, C++,Corba

Modified ‘Log Client’ CGI-Client called the Log Server Corba Stubs in the Proxy, validates & passes the txn to apple service.

Tata Consultancy Services(TCS) – Client : Hewlett -Packard ISO Nov ’96 - Dec 1998

Role / Product ChangeEngine - Development of a Test Harness for a Work Flow engine

Technologies CORBA (ORB+) & ISO C++ (STLs). MFC with ODBC, OCI, Oracle 7.3, Perl

§ Design and development of Test Harness for the work Flow engine – DB design, Proxy Business Objects and GUI Tools§ Developed a Db Replication Utility using C++ (STLs) & Oracle Call Interface (OCI) used to integrate muti-user test case data to be able to run a comprehensive test used for performance, volume, regression and robustness testing.

Client : Tokyo Stock Exchange Nov ’96 to Dec ‘97

Project Turn Key development of a Client-Server application for Tokyo stock exchange.

Technologies MFC, ODBC, eSQL, HPUX, Win NT/95, Shell scripts, Internationalization with UNICODE, MS-kanji

§ SDLC /Multi-process/threaded Message Processing system:GUI & Server processes, Shell/Awk scripts to automate the DB Design, Internationalization using UNICODE.

Education:

BE (CSE) - Bachelor of Engineering, Computer Science-Aug 1996, University Visveswaraya College of Engineering,Bangalore.

Contact this candidate