Objective:

13 years in IT Industry 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.

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

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

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

:

Databases

:

DB2, Oracle 11g/10g/9i, 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

Confidential
, New York NY

Oct ’09 - Current

Role/Project

Data Integration Architect for Global Data Management group

Technologies used

MS Visio, Windows XP, RHEL4 U7, Informatica PowerCenter 811/8.6.1HF9, IDQ8.6.2, IDE8.6.2, Oracle 9i/10g/11g, MS SQL 2005, Teradata V12R1, Informatica PowerExchange 811/861, MS Active Directory – LDAP, UC4

Accomplishments: Audit of Informatica DI platform 2 Months – Informatica, Datamirror

Project

Data Integration Architecture Audit/Health Check

• Audit/Review of existing Informatica deployments in Shared & Project Environments.
• 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.
• Initiated Powerexchange Setup & configuration for Complex data files from Oracle Clinical Solutions DB.
• Initiated & educated Customer /platform team on PWX 861 real-time CDC options/features which 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.
• Delivered Audit review report containing all of the above information.

Confidential,
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.
• Primary & Only Contact point to Informatica Global Customer Support for Installation & administration Informatica PowerCenter,Metadata Manager, Data analyzer.
• Architecture & Installation of Powercenter 8.6.1HF8 in Dev & Production Environment, User Security, Folder management.
• Integration of MS Active Directory LDAP Authentication of 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 backup scheduling using PMREP utility.

Imparting training :

• Datawarehousing concepts
• ETL Architecture, Design concepts & Development process using Informatica

Training:

• Informal training on Microstrategy 8.1

Nov ‘08 – Jul ‘09

Confidential,
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, Powerexchange 811, Oracle 9i/10g, 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 BIEE
INFORMATICA ADMINISTRATION:

• Installation/upgrade of Informatica from 7.1.3 to 8.1.1 to 8.5.1. Maintain metadata, Security and Reporting.
• Imported,validated 268 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.
• POC of Powerexchange CDC for WQX project
• 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.
• Metadata exchange & Management using ERWIN/Informatica Metadata bridge, & Informatica/BO Metadata bridge.
• 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.

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, 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, 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

Confidential,
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

Confidential,
Dulles, VA, USA

Nov 2003 – Oct ‘04

Project

Accounts Receivables system for Billing and Revenue systems’ division

Technologies used

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

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

Confidential,

May 2000 – June 2002

1. Product

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

• 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. Designed the PP transaction warehouse fed by user registration process.

Confidential,
– 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.

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

Confidential,
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: Confidential,

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.

BE (CSE) - Bachelor of Engineering, Computer Science