SUMMARY:

• Information Systems Senior Enterprise Data Warehouse and IBM Information Server (Datastage, Qualitystage) ETL Architect/Business Intelligence Specialist & Data Modeler, with 18+ years of successful experiences in Business, Client/Server, Unix, Windows, and Mainframe environment. Proven expertise in all aspects of Business and Data Integration, Master Data Management (CDI, PIM), Service Oriented
• Architecture, Enterprise Data Warehouse Architecture (Design & Modeling), ODS, Relational and Dimensional Modeling (Star and Snowflake Schema), adherence to Ralph Kimball's & Bill Inmon’s Data warehouse methodology, Data Mart, Meta Data management, ETL strategy, design and processing, Risk Management and Project Management, with a track record for delivering high quality results on time and under budget. Extensive experience with multiple application technology platforms including SAP, Peoplesoft, Oracle Financials, Siebel, CRM, SCM, HR, EPM, Web, etc.

TECHNICAL SKILLS:

Technology and Tools: Data Warehouse Data Integration Business Intelligence MDM CDI Online Analytics...CRM...SCM ERP EPM Product Planning Re - engineering Content Technology Relational Databases EII Internet Unix Windows Mainframe Business Objects Cognos Peoplesoft SAP Oracle Financials IBM-Information Server (Datastage Qualitystage) Informatica IBM WCC Siperian Erwin ER/Studio Visio DB Artisan Toad CA-Autosys C/C++ Java J2ee Xml Xslt Vb T-Sql Pl/Sql Pascal Fortran Websphere Weblogic Oracle Sybase MS Sql Server DB2-Udb Teradata

PROFESSIONAL EXPERIENCE:

Confidential, Whippany, NJ

Enterprise Data Architect, Modeler & ETL Specialist

Responsibilities:

• Directed and managed multiple enterprise architectures and designs across the firm that encompassed OLTP systems, data warehouses, IBM Information Server (Datastage, Qualitystage) ETL and data quality services, infrastructures supporting these requirements, IBM product licensing, etc
• Managed multiple licenses and deployed several key architectures and design across various business units related to Ops, Fixed-Income, Equity, MeasureRisk, AML, Risk Management, Back-office, Front-Office, Mortgage, etc
• Assessed several business units and set strategy, roadmap, and designed customized optimal data model to support Customer Data Integration as part of the enterprise Master Data Management initiative and presented to senior management and key stakeholders. Promulgated data governance and data stewardship with process-oriented design to abet the management with clearer picture on roles and responsibilities and what it takes to get the job done.
• Involved in the assessment and implementation of Siperian that included design of MDM data model and set up strategy for loading from source to landing tables to MDM final tables structures maintained in Oracle.
• Architect, model, designed and developed 2 key phases of data cleansing process using IBM Datastage & Qualitystage that involved standardizing, correcting, validating and enriching customer contact data within a firm (Phase I) and customer contact data across the firm (Phase II), thereby allowing business analyst to inspect the data for correctness and eliminating duplicate customer contact data thus providing master/golden copy for easy maintenance and reporting. Developed on Windows 2003 and Linux (Suse 10) platforms, Oracle 9i/10g.
• Liaise with Senior Management and communicate strategies and technology roadmap that contributes to corporate growth and potential business buy-in.
• Led a team of software, hardware, network engineers, DBA's and ETL and Reporting specialists.
• Coordinated with managers, market data vendors, users and team of in-house developers to gather functional and technical requirements of systems/applications
• Developed and maintained the project plans that identify and schedule project deliverables, milestones, project dependencies, and required tasks.
• Conducted project risk assessment, quantification, response planning and control.
• Defined clear roles and responsibilities for project stakeholders and obtained commitment of all involved.
• Provided guidance in identifying and promulgating 'best practices' in IT across the entire group.

Confidential, NY

Senior Data Warehouse/ETL Architect/Data Modeler

Responsibilities:

• Perform business assessment, collect inventory of systems and applications including silo’d data warehouses and develop a technology and strategy roadmap, high-level data model and recommendation for a 5-year migration plan.
• Conduct workshops with various business units to evaluate, assess and gather business requirements including process and work flows and collect issues and ideas and understand areas that require compliance directives such as Sox and Regulatory adherence and reporting.
• Perform detail analysis on systems and validate findings with the business and technical users.
• Review various tools in place, evaluate and recommend tools and solutions for enterprise standardization.
• Performed value assessment of Eagle Pace product that is in use for the last 3 years and recommend innovative solutions that resulted in higher ROI and eliminating lot of issues and redundancies.
• Architect and directed implementation of a successful of Eagle pace proprietary ETL to Informatica ETL maps.

Confidential, NY

Enterprise Data Warehouse/BI Architect and ETL Specialist

Responsibilities:

• Perform business assessment, current environment assessment and analysis, data model, develop and implement Common Data and Enterprise Data Warehouse architecture, facilitate requirement gathering, and Metadata Management.
• Set up ETL strategy, design, model a data warehouse and migrated Ascential Datastage ver. 3.5 environment to the latest Datastage ver. 7.5b. I was also involved in providing production support on existing infrastructure when the migration was going on in parallel.

Confidential, Silver Springs, MD

Ascential DataStage Specialist

Responsibilities:

• Data Warehouse (HealthCare, Life and Annuity), Architect and Designed an customer centric Data warehouse capable of capturing customer data from various data sources
• Insurance De-mutualization, Deployed a Data warehouse capable of capturing customer data and various aggregates to assist the client in De-mutualizing their insurance service and policies thus allowing customers details of stock transfer and ownership.
• Business Analytics/Data warehouse, Implemented Database Marketing and Campaign Management, Data warehousing & OLAP Reporting, Data Management and Knowledge Management thru Siebel Call Center, Sales Force Automation, Customer Service program.

Confidential

Senior Data Architect/Data Warehouse Specialist

Responsibilities:

• Trusted Global Advisor, Directing the smooth, on-time delivery of the data migration stage for a $600 million dollar migration of customer database management applications, from mainframe to client servers.
• Mutual Fund, Designed and implemented a Data warehouse and managing the migration of service-provided data (LIPPER analytical service, Reuters) from mainframe to client servers, thus establishing and implementing infrastructure requirements and coordinating, liaising with the service provider to complete the project ahead of schedule, with a $500,000.00 dollar savings for the client.

Confidential

Senior Data Architect/Technical Lead

Responsibilities:

• Data Architect/Migration, Performed business needs analysis and provided business solution to protect the client's investment in hardware and software, resulting in a $12 million dollar savings.

Confidential

Senior DBA Consultant

Responsibilities:

• Fixed-Income Trading, Championed the development and administration to provide 24x7 post-implementation support, troubleshooting and monitoring services including setting up disaster recovery techniques ensuring a successful, on-time rollout, saving the client $1.2 million dollar.
• Foreign Exchange, Managed and deployed mission critical application involving functional analysis, design, and development involving heavy s to rate conversion table, automating data delivery schedules, and high availability.

Confidential, NY

Senior DBA

Responsibilities:

• Travel Related Services, Implemented a huge customer related data bank on the lines of Data warehouse. Lead a team of 12 internal staff and 5 consultants, implementing all project aspects on-schedule, assisted in creating complex algorithms, aligning business functions/rules with project details, ad-hoc query and complex reporting capabilities.

Confidential, NJ

Senior DBA

Responsibilities:

• Systems Consultant, Provided database and client/server management services.

Confidential, Fort Belvoir, Virginia

Senior Consultant

Responsibilities:

• Performed and implemented a major confidential project for DOD/DOT that was deployed to U.S. facilities across the globe for tracking and maintaining equipments and hazardous/non-hazardous materials.