SUMMARY:

I have 15+ years in IT Industry working as Enterprise/Solution/Datawarehouse/Informatica Architect 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

TECHNICAL SKILLS:

Domains: Environment al 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:

Confidential, Los Angeles, CA

BI Architect/Manager - Solution/Informatica platform/DWH Architect

Technologies used: MS Visio, Windows XP, RHEL5.7, Informatica Power Center 9.0.1, Oracle 10g/11g, MS SQL 2005, MS Active Directory - LDAP, ORACLE Datawarehouse Administration Console DAC 10.1.3.4.1 , OBIEE 10g/11g, QlikView

Responsibilities:

• Worked with various Business users for expanding Order Management reporting through Warehouse Redesign - Model existing Datawarehouse / expand on existing Order Management information
• Coordinated & worked with Infrastructure/DBA teams to setup Informatica, DAC & Oracle EBS Database Environments - Dev, QA, UAT & PROD.
• Instituted and trained team on Informatica Platform Administration, Developers Standards, Guidelines & Best practices
• Managed a team of 8 people from Analysis, ETL Architecture, Design, Development & Deployment of 45 Informatica Mappings for the OWB to Informatica Migration effort.
• Deliverables: DTMs (Data Tranformation Matrices), UTP (Unit Test Plans), UTR (Unit Test Results)
• Assisting & Training project team on ETL Architecture/Design/ Development .
• Building/Integration of all Informatica workflows into DAC tasks which is the Process Automation & Monitoring tool of choice.
• Informatica Platform Administration: Environments setup, User administration, Deployments, Backup/Restores.
• Participated in QlikView POC for real time Analytics & Data Visualization
• Proposed Platform/Data Integration Architecture/Roadmaps for Q4 ’12 to Q2 ’13

Confidential, Los Angeles CA

Solution/Informatica platform/DWH Architect

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

Responsibilities:

• 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

Confidential, San Francisco

Solution/Informatica platform/DWH Architect/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

Responsibilities:

• 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.

Confidential, New York, NY

Data Integration Architect

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

Responsibilities:

• 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 Confidential 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.

Confidential, Kansas City, MO

Data warehouse, BI&A Architect

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

Responsibilities:

• 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.

Confidential

Data warehouse, BI&A, Lead Technical Architect, EPA

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

Responsibilities:

• 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.
• 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.
• 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.
• 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.

Confidential, VA

Technical Lead.

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

Responsibilities:

• SubVersion Installation/Administration, automate/facilitate application DB creation, Version control operations using shell scripts
• 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