Key Skills

• Strong knowledge of dimensional data modeling methodologies
• Strong knowledge of ETL and EAI processes, with over 8 years of experience in Informatica products
• Architected solution implementations and solution patterns in healthcare, CRM and financial domains
• Knowledge of back office core banking systems and related functional areas
• Tools and Languages: Informatica PowerCenter 9.1, B2B DT 9.1, B2B DX 9.1, MDM, SQL, Cognos, Java, JSP, JavaScript, C, Visual Basic, Basic, MS Office, Erwin, XML
• Databases: Oracle 10/11, SQL Server 2005, MS Access 2003, DB2 8.1
• Operating Systems: Sun Solaris, HP-Unix, Linux, AIX, Windows Servers

Work Experience

Confidential Sr. Technical Delivery Manager / Principal Consultant Sep. 2008 – To date

This is a technology consulting position in the Professional Services division of the company. My main responsibility is to empower customers with the B2B Data Exchange product suite, setting them up with base line architecture for tackling business problem on hand and a long term blue print for using the product. Clients include Metlife, LexisNexis, Blue Cross Blue Shield of NJ, Barclays Capital, Tricare etc.

• Worked with clients, right from requirements gathering to go-live, tailoring the product to customer’s needs
• Installed and Configured Informatica product suite at the client site
• Designed, architected and implemented highly reusable and extensible solutions using PowerCenter / B2B DX 8/9
• Implemented data transformation logic using B2B DT 8.6.2 for converting data between formats using XML canonical representations
• Worked on capacity planning requirements and set up of integration competency centers
• Worked on a number of verticals including Banking, Data Aggregators, Insurance, Healthcare etc
• Led development of Informatica’s velocity methodology – authored methodology documents, best practices, templates, etc.
• Actively participated in Product enhancement / design discussions
• Worked with pre-sales and product marketing team in set up and demonstrations of the solution set
• Environments: Worked on multiple environments including –
• PC 8.6.1, B2B DX 9.0.1, B2B DT 9.0.1, 4 node grid on 64 bit AIX 5/6 set up in active-active HA configuration with Oracle 10/11
• PC 8.6.1, B2B DX 8.6.2, 2 node 64 bit RH Linux with Oracle 11/Netezza 5 in active-passive configuration
• PC 9.1.0, B2B DX 9.1.0, 2 node 64 bit Windows 2008 with SQL Server 2008 in active-passive configuration

Confidential. Informatica ETL Lead , North America, NJ Sep. 2003 – Sep 2008

The data mart is devoted to analysis of consumer’s interactions with BMW in all forms – Sales, Service, Warranty, Surveys, Leads etc. Data is sourced from multiple source that include SQL Server, DB2, Flat Files and Oracle and reports and cubes drive generating KPIs and even some of the marketing campaigns undertaken by the corporate.  Environment: Single node on 64 bit AIX 5/6 running PC 5/6 with SQL Server 2003/2005, DB2 8, Oracle 9/10/11 sources and targets

• Warehouse Architect Role
• Designed data marts using dimensional data modeling techniques
• Architected change data capture processes that drive the data load
• Designed the ETL error handling and trapping standards for the data mart
• Designer/Developer Role
• Designed and developed PowerCenter mappings/sessions and workflows that included sourcing from SQL Server, DB2, Flat Files and Oracle
• Tuned the sessions, processes and SQL queries for better performance
• Performed the PowerCenter upgrade from version 5.1 to 6.1
• Wrote shell scripts / JCLs for invoking workflows from mainframe scheduler
• Designed and developed mappings / SQL / Stored procedures for one time data fixes
• Developed daily / weekly reconciliation processes to improve data quality
• Production Support Role
• Data problem determination using SQL queries
• Process problem determination using PowerCenter process log files
• Project Management
• Estimating software size/completion dates using Microsoft Project
• Planned and prepared for Disaster Recovery

Confidential
Senior Analyst Nov. 2001 – July 2003 Confidential – Commercial Bank of Kuwait Implementation; Confidential is a comprehensive J2EE based retail banking product conceived and developed by the company. The suite includes all possible solutions that a retail bank would require with single sign-on, multi-branch and multi-POS design that could also be implemented as modules. Environment: Weblogic 4.5, Oracle 8 running on 32 bit Solaris

• Led a team of six programmers as part of second level support
• Managed a total of 8 modules including Funds Transfer, Reconciliation, Central Liability, Outward Clearing, Inward Clearing, Maintenance, Charges, Internet Banking
• Prioritized problems and suggested workarounds
• Problem determination using log information from web server and app. server
• Reviewed JSP, Java and Oracle programs and test plans

Confidential– Customization; the customization also involved a technical upgrade for compatibility of the product with IE 6.0 and Netscape 7.0 browsers

• Led a team of four programmers as part of the customization exercise
• Prepared the FS detailing the changes required and a project plan based detailing various phases involved
• Identified code patterns that require changes for browser compatibility
• Designed and Developed a tool to handle the browser compatibility changes automatically
• Enhanced the Financial messaging Java programs to generate messages in BACS and CHAPS standards
• Enhanced the Straight Through Processing (STP) routines to handle CHAPS and BACS messages as well
• Reviewed JSP, Java, Oracle programs and test plans

Confidential– Product Development

• Member of Product Architecture team
• Studied and evaluated suitability of various J2EE patterns including MVS and Session façade patterns
• Designed the generic Java components of architecture framework for the product including the EJB
• Evolved the standards for the usage of various J2EE components
• Module Lead - Led a team of four programmers; my team was responsible for Funds Transfer, Maintenance and Reconciliation modules
• Managed the product development cycles for the modules starting with prototype development culminating in System Testing including preparation of FS, Logical design documents and test plans
• Designed and Developed a tool to generate JSP and Java components for Table maintenance programs taking appropriate inputs
• Designed and Developed Straight Through Processing (STP) programs for SWIFT messages for financial transactions.
• Developed APIs for interfacing the Funds Transfer module with other products in the OrbiOne suite
• Designed set of interfaces for generating Financial Transfer SWIFT messages MT103 and MT202
• Reviewed JSP, Java, Oracle programs and test plans

Associate Consultant Sep.1999 – Oct. 2001 Confidential

• Led a team of two programmers; my team was responsible for supporting and enhancing the Corporate bank’s data warehouse by adding the accrual, exchange risk and profit/loss information
• Environment: SQL Server 2000 on 32 bit Windows 2000 servers
• Designed the data model and the data flow process for extracting FX, MM and LD deal information from legacy OLTP systems
• Designed, developed and tested MS-DTS packages to extract data from OLTP
• Designed SQL Server stored procedures for culling out the aggregate information and applying accrual / revaluation adjustments for the deals
• Tuned the process for better performance thereby reducing the running time of the batch process
• Interacted with users for generation of standard and ad-hoc reports

Confidential; IBBS stands for International Branch Banking Solution and is a legacy back office end to end core banking system used by the Corporate bank in CEEMEA region Environment: HP Unix

• System Test coordinator Role
• Prepared a comprehensive System Test plan for testing the enhancements release for Funds Transfer and Foreign Exchange modules
• Prepared the regression test plan to test some of the core functionality of the system
• Set up the control environment for the system test
• Enhancements lead role
• Designed a Retention Days feature in Auto-FT module where in messages sent from various external systems would be recycled under when Sufficient Funds are not present in the account (rather than message being rejected); this was a major enhancement for the bank as it added enormous value to the customer for a small fee and also saved millions of dollars on cost for the bank
• Designed and developed programs to add Credit Risk reporting functionality for FX forward deals; the enhancement involved re-valuation of the forward deals with forward rates maintained in the system and appropriately rising warning signals based on certain parameters
• Enhanced system to add interfaces to front office Funds Transfer system
• Performed quality control and assurance activities as well by reviewing code and test plans
• Involved in supporting 35 installations in Citibank branches in as many countries.
• Involved in development of the interface with the Account/Ledger maintenance system.

Confidential; RAS is Risk Administration System used by the corporate bank in the CEEMEA region for handling credit lines and preparing and storing customer credit information. GRR is Global Risk Reporting system that presents a global perspective of Customer Credit information for the bank.

• Environment: Windows NT 4
• Team Member – Support and Enhancements
• Supported 35 installations of RAS and GRR
• Developed programs to interface with the Account/Ledger maintenance system for intra-day information handoff
• Designed and developed front end for the Security and parameters modules

Accomplishments

• Stood third in State Level Mathematics talent exam on non-conventional problem solving
• Stood first in school in the Higher Secondary Certificate Exam
• Awarded the “best project” award during the final year in under-grad from amongst 25 projects
• Awarded the “best project” award during induction training from amongst 14 teams for outstanding quality and process adherence
• Awarded “Star Consultant” at Sogeti in recognition of consistent over achievement of client expectations
• Awarded “Infa Star” and “Best Consultant” awards in Informatica’s worldwide professional services practice

Education

• Bachelor of Engineering in Electrical Engineering