Professional Experience Summary:

• Over 16 years of experience in Information Technology serving diverse industrial segments including financial / manufacturing /pharmaceutical /service industries across private, public and government sectors.
• Well versed in the design and development of ERP systems / Commercial Applications / Packages.
• Through knowledge of entire software development deployment cycle.
• Excellent database programming, administration skills on various Operating Systems
• In-depth knowledge of emerging BI Data warehousing technology.
• An efficient team leader, with demonstrated ability to lead and manage others.

Technical Expertise:

PROFESSIONAL EXPERIENCE DETAILS

Confidential

Role: Principal Architect

• Responsible for planning, scheduling, conducting and coordinating the technical and management aspects on assigned hedge fund and trading projects.
• Assist in engaging right personnel assignments to projects.
• Review and approve technical design phases of projects and approve frameworks.
• Ensure effective communication and coordination on assigned projects between all disciplines and parties.
• Resolve disputes and conflicts related to assigned projects and Clients.
• Interact and negotiate with Client project representatives.

Environment: Oracle 11g, Metadata, IBM IDA, Informatica, OBIEE, Erwin

Confidential

Role: Senior Architecture lead consultant

• Define the domain specific target architectures and roadmaps for Global commercial investment banking.
• Working on data management access policy DMAP/ IDMP for corporate investments.
• Created frameworks for Metadata management, data federation and data provisioning.
• Working on Implementation strategy for IBM FSDM models.

Environment: Oracle 10g, Rochade Metadata,IBM IIS, Informatica Metadata,IDQ, Power Designer

Confidential

Role: Senior Architecture consultant

• As Wells Fargo's WBR Wealth, Brokerage and Retirement groups merge there is a business need to understand the true costs of Institutional Retirement Plan Administration Services. This project seeks to identify all expenses associated with Institutional Retirement Plan Administration activities and allocate all expenses to each individual plan. Additionally, Plan Administrations costs and Plan Administration revenue will be coupled to develop Plan Profitability reporting and in the process, create a higher degree of automation than is currently possible with the REX system.
• Define the strategy, target architectures and roadmaps for IRT capabilities, assets, investments and liquidity.
• Create dynamic blueprints for pertinent domain areas for Global Expansion.
• Analyze and define solutions for initiatives, including vendor assessments, application rationalization.
• Provide technology leadership and consulting and analysis across the portfolio.
• Define domain specific strategies and target architectures for strategic platforms in Institutional Retirement Trust.
• Risk analysis for integration, migrations and implementation process.

Environment: Oracle 10g, OBIEE, IBM Info sphere, Informatica Metadata, Netezza, Hibernate

Confidential

Role: Senior DB Architect

• The company implemented an enterprise wide OLTP system called as National Inability to Pay to know the risks involved in consumer space. This system measures consumer leverage growth by analyzing the relationship between personal spending and revolving debt. ITP leads net charge-offs by 6-12 months, but as in past periods of economic and credit stress, the lead time is compressing due to the severity of the cycle.
• Designed the HLD/LLD process.
• Designed and analyzed the end user reports.
• Involved in end-to-end integration process.
• Guided and co-coordinated the onsite team members.
• Designed High and low level detailed Extraction, load transform design strategies.
• Risk analysis for integration, migrations and implementation process.

Environment: Matlab, SAS, Oracle 10g, Micro strategy, Erwin, Informatica, Flex, Netezza, spring, Java

Confidential

Role: Enterprise DW Lead Architect

• The company implemented an enterprise wide data warehouse for Customer Value creation and re-engineered several mini OLTP systems and ODS systems to address customer billing and profitability. This system measured divisional performance at any point of time and generated matrix reports for upper management from Netezza data marts.
• Analyzed Offshore outsourcing risks and designed automated process to reduce the manual mistakes.
• Analyzed the end user reports performance issues and implemented in Netezza databases.
• Guided and co-coordinated the offshore and onsite team members.
• Designed High and low level detailed ETL BI designs migration strategies.
• Risk analysis for migrations and implementation process on Oracle 10g RAC.
• Developed detailed Netezza process and implemented the same in production environment.

Environment: AIX, Oracle 10g RAC, PL/SQL, Erwin, Informatica, Cognos, Data mirror, Netezza, CVS, Tivoli scheduling

Confidential

Role: Senior ETL Architect

• Re-Engineered several mini OLTP systems and ODS systems to address customer finance, profitability aspects and regulatory compliance issues. It provided streamlined process and system improvements. PMC system measures the performance of the customer reps, client portfolios and customer satisfaction for a variety of finances.
• Worked with the business owners directly and converted their needs to technical design.
• Implemented the best practices for ETL design which lead to optimum performance.
• Planned for reusable component level developments which yield a rapid delivery with less overall cost.
• High and low level detailed ETL BI designs for Transaction and Consolidation System.
• Risk analysis for integrations and implementations for the ETL streams.
• Developed detailed ETL mappings, Unit test ETL objects and implemented them in production environment.
• Identify issues potential risks, as well as identify potential resolutions in production environments.
• Transfer knowledge of developed ETL objects to other members of the T C team

Environment: Sun-Solaris, Oracle 8i, PL/SQL, Erwin, Informatica, Micro strategy, VSS

Confidential

Role: Senior DW Architect

• Initiated Financial Re-Engineering FRE Program to address legal and regulatory compliance issues and provide process and system improvements for Journal Entry Accountability, Inter-company Accounting, and Cash Flow processing.
• Implemented the company's first six sigma methods during the project life cycle.
• Mentored and supported the developers and analysts during the project crisis.
• Integrated the AS-400 systems with the data warehouse through CDC.
• High and low level detailed ETL designs for Transaction and Consolidation System.
• Risk analysis for integrations and implementations for the ETL streams.
• Reports design through Business Objects from the ODS systems.
• Developed detailed ETL mappings, Unit test ETL objects and implemented them in production environment.
• Identify team issues potential risks, as well as identify potential resolutions
• Transfer knowledge of developed ETL objects to other members of the T C team

Environment: AIX, Oracle 9i, PL/SQL, Designer 6i/9i, Informatica 7, Business Objects, VSS

Confidential

Role: Sr. BI Consultant

• Analyzed and prepared SRS docs and Data Flow Diagrams and laying out business intelligence strategies.
• Analyzing the business functionalities and building the fundamental blocks.
• Designing the Extraction sets for building the cubes and reporting.
• Designing the ETL process for loading data to dimensions and facts.
• Designing Schema ER diagrams in Designer data modeling tool.

• Extensive back end programming using stored procedures, functions, packages and triggers through Oracle PL/SQL.

Environment: HP-UX, Oracle 9i, PL/SQL, Designer 6i/9i, Informatica 7, VSS

Confidential

Role: Sr. Data Warehouse Architect / Aug'04 Jul '05

• A giant in manufacturing and services industry over 40 countries. TED is a hybrid Data warehouse of TYCO Electronics division which holds day to day Sales and marketing, budgeting and related finance information.
• Analyzed and prepared SRS docs and Data Flow Diagrams.
• Designed the Application interfaces after gathering the info from end users.
• Performance testing and load testing on various test systems for data conversions.
• Extensive back end programming using stored procedures, functions, packages and triggers through Oracle PL/SQL.
• Designed Schema ER diagrams in Designer data modeling tool.
• Scheduling batch jobs and monitoring through IBM Tivoli job scheduler.