SUMMARY:

• A Principal Level IT Consultant with over 16 years of experience as a Data Architect, Master Data Management Expert, Data Warehouse Manager, Data Modeler/Designer and Hands - on Developer with strong delivery experience with many Fortune 500 companies namely Confidential, Confidential, Confidential and many others.
• I have been responsible for managing, architecting, designing, delivering and implementing data intensive applications to enable high performance Master Data Implementations, Data warehousing Solutions and Online Transaction Processing systems for clients in the Mortgage, Finance, Logistics, and Manufacturing industries. An organized problem solver, excellent communicator and superior team leader.

TECHNICAL SKILLS:

Technology and Tools: Informatica MDM version 9.7.1 Informatica Data Director Ab Initio GDE v1.13/1.15, Co>operating System v2.13/15, EME, Informatica Power Center 9.5, IDQ IBM WebSphere DataStage8.0 Oracle8/8i/9i/10g, Sybase, MS SQL Server, Teradata ver2R5 Korn Shell Scripting Database utilities like Rapid SQL and T.O.A.D Data Modeling using Erwin (3.5 - 4.0) and Sybase Power Designer Informatica Power Center/IDQ Database Administration Oracle8/9i/10/11g Requirements/specifications/design

PROFESSIONAL EXPERIENCE:

Confidential, Washington DC

Party Master Lead

Responsibilities:

• Implement central repository for all Confidential counterparty data and master it using Informatica s MDM tool and Informatica Data Director (IDD).
• Leading the MDM initiative to provide best version of the truth, enable 360 degree view of mortgage counterparties. Managing project, reporting weekly status to senior management, developing master project plans, managing risk and issues, estimating and analyzing schedules, engaging senior business executives to collaborate, and leading MDM developers for loading critical business data from RiskNet, Stamps, Siebel, GPP, DAN, ABA to Invoke, and Concur to MDM Hub, while defining trust validation, match and merge rules. Involved in Data Quality Scorecard definition.
• Manage project estimation, development and delivery.
• Currently leading Master Data Management, ETL and Data Quality teams for Party Master Project.

Confidential, Washington DC

Application Analyst

Responsibilities:

• Application Analyst for Financial Data Warehouse (FDW) development team under Shared Services data space. FDW is designed to capture daily portfolio positions and characteristics in support of Capital Markets Strategy.
• XML based Enterprise - wide source interfaces to feed the data warehouse using Ab Initio and Informatica.
• Leading the team s Data Quality effort to adhere to Confidential s enterprise wide DQF goals using Informatica s Data Quality Suite.

Confidential, Chicago, IL

Delivery Manager

Responsibilities:

• Manage project development and delivery. Experience in working with teams across the globe.
• Define project scope, goals and deliverables that support business goals in collaboration with senior management and client. Identify and manage project dependencies and critical path.
• Estimate the resources and participants needed to achieve project goals.
• Develop full - scale project plans and associated communication documents.
• Defining standards and best practices for ETL (Informatica & Ab Initio) and all other existing operational processes.
• Manage ETL technology migration of from Informatica to Ab Initio.

Confidential, Chicago, IL

Senior Consultant

Responsibilities:

• Designed and built multiple Data Warehouses, Flows, Marts and Metadata Repositories within the company for various groups including Data Readiness, Accounting Data Warehouse, Hedge, Credit Surveillance and Financial Data Warehouse using a combination of technologies like Ab Initio, Oracle, Kalido, Sybase and Autosys.
• Defining standards and best practices for ETL and operational processes.
• Built Operational dashboard for enterprise wide Service Level Agreement reporting.
• Utilize and promote Autosys framework as an easily usable operational Event Driven Architecture.
• Interface ETL processes with Web based applications namely Enterprise Production Framework.
• Built utility using perl and shell scripts to manage and merge different versions of code within Ab Initio s Enterprise Meta Environment. Restrictions Apply.
• Mentor client developers and consultants.
• Conduct interviews on behalf of the client for client and contractor positions.
• Hands on experience using tools BMC - Remedy, IBM Rational ClearCase and ClearQuest.

Confidential

Ab Initio Consultant and Oracle DBA

Responsibilities:

• Designed and developed variety of ETL programs using Ab Initio Continuous and Batch processes to gather data from a variety of sources including Oracle based OLTP databases, messaging backbones built using TIBCO and Legacy systems to finally make it into a Teradata warehouse.
• Performance Tune the loads for optimal performance and maintain 100% uptime to these global applications.

Confidential, Detroit, MI

Delivery manager and project coordinator

Responsibilities:

• Effectively communicate project expectations to team members and stakeholders in a timely and clear fashion.
• Data Modeled, Designed and implemented the J2EE based AutoQuote system to generate values for used automobile. Performed all aspects of database administration including data modeling, data migration, data loads, backup and recovery schemes. Migrated data from Sybase11.0 using Oracle Migration workbench as is into Oracle9i database. The transformations and business rules were implemented using PL/SQL and External Tables into the project PDM.
• Performance tuning at various levels like SQL tuning, Instance tuning, Space management, Partitioning, I/O tuning etc.
• Backup and recovery schemes tested and documented.

Confidential

Oracle DBA

Responsibilities:

• Designed and implemented a range of products for financial institutions. Designed and developed OLTP to DSS systems using Oracle8i and Sybase Power designer. Extensive programming using PL/SQL for data transformations and inter Media for advanced text searching. The DSS were designed to use most of the data warehouse features offered by Oracle like materialized views, query rewrites, partitioning, bitmaps, analytics etc.
• Oracle utilities like Import, Export, TKPROF, SQL Loader and Statspack etc were used in a variety of situations.

Confidential

Oracle DBA

Responsibilities:

• · Support production databases and develop new applications to implement client requirements. Development involved data modeling, writing stored procedures and optimized SQLs for the interfaces.

Confidential

Oracle Developer

Responsibilities:

• Develop stored procedures and SQL for various reporting modules of the Invoicing and Reporting system which was a part of the whole system. Learnt various other aspects of programming in a J2EE based multi - tier enterprise application. Additionally administer the development databases and update the database with structural changes.

Confidential

Oracle Developer

Responsibilities:

• Writing SQL and modify existing Power Builder 5.0 code for the Production Planning and Control system. Develop programs to load data from various systems into the Sybase database for report generation.