4 Restrick Ct, Princeton Junction, NJ 08550
Ph: 609-945-1160, Cell: 973-202-3384
Email: anupam@avenuesinc.com

 

Skills Summary

Over Twenty Five years of comprehensive & in-depth experience in the Information Technology (IT) industry with specialization and expertise in Data Warehousing and Business Intelligence area. Accomplished Data Warehouse Architecture, Data Modeler and Designer

• Performed overall project management, analysis, architecture, design, development and implementation of data warehousing / business intelligence initiatives for last eighteen years
• Worked on data warehousing projects from inception to implementation and delivered high quality solutions in a timely manner meeting and exceeding the business requirements. This involved working with the top management and executives, business sponsors and IT department
• Responsible for defining the information architecture and technology infrastructure along with the design of multi dimensional data models and the Business Intelligence delivery solutions
• Responsible for managing the data analysis, data sources, data mapping along with defining the meta data repository
• Managed the evaluation of ETL and OLAP tools and recommended the most suitable solutions depending on business needs
• Skilled in implementing Data Warehousing and Business Intelligence solutions. Expertise in Ralph Kimball and Bill Inmon’s Data Warehouse methodology
• Provided leadership roles including client mentoring

 

Technical Background

• HARDWARE SUN Solaris
  HP UNIX, IBM AIX, IBM Mainframes
• OPERATING SYSTEMS
  Windows XP, UNIX, Sun Solaris, MVS
• DATAWAREHOUSE TOOLS
  Oracle Business Intelligence Enterprise Edition (OBIEE), COGNOS, MicroStrategy, IBM Data Stage, Informatica, Oracle Warehouse builder, Oracle reports, Crystal reports
• CASE TOOLS
  ERWIN, Power Designer, Oracle Designer, LBMS, BACHMAN, EXCELERATOR
• METHODOLOGIES
  Bill Inmon’s, Ralph Kimball, Ed Yourdon, JAD
• LANGUAGES
  SQL, PL/SQL, COBOL, CICS, PVCS, TSO
• DATABASES
  IBM DB2 UDB,Oracle 11G, 10G, 9i, MS SQL Server, Sybase,

 

Education

Bachelor of Engineering (B.Tech) from Indian Institute of Technology ( I.I.T. New Delhi, India)

 

Professional Experience

1994 till Present Avenues International Inc.:

Working as Data Warehousing / Business Intelligent consultant
Following are clients and projects where I have worked:

Client : Bloomberg  L.P.
Providing Data Warehousing Architecture, Analysis and Modeling consulting along with establishing the data warehousing best practices for Bloomberg Customer Usage Data Warehouse.

 

Mathematica Policy Research Inc. (MPR), Princeton New Jersey

Consulted as a Data Warehousing advisor to MPR for their client Center for Medicare and Medicaid Services (CMS) in defining the data requirements for a Decision Support System to meet the needs of Disabled and Elderly Health Programs Group(DEHPG)

Analyzed MSIS, MAX data files coming from different states for Medicaid & Medicare claims data. In addition looked at the Federal Data Sources such as Social Security Administration, Temporary Assistance to Needy Families, Food and Nutrition Services, Veterans’ Administration, Vocational Rehabilitation

Worked with CMS to identify the data requirements and information gaps and outlined the diverse steps needed to build an integrated data system. Provided the data warehouse development methodology and created the architecture and dimensional model to develop an effective decision support system (DSS).

 

ADMINISTRATION FOR CHILDREN’S SERVICES (ACS) New York CITY

Worked for on Data Warehousing and Integrated Case Management Systems (ICMS) project. The responsibilities involved Project Management, Business analysis, Mentoring, Data Analysis, Systems Architecture, Data Integration, and Data Modeling.

Designed and implemented data integration and data warehousing solution for ACS. This involved analysis of key NY State systems such as CONNECTIONS, WMS & CCRS used for collecting and processing key data related to the Cases, Individuals, and Workers. This included understanding of “Statewide Automated Child Welfare Information System” (SACWIS) requirements along with the analysis of workflows, key data collection and processing rules particularly with regard to child protection and child welfare services.
Software: Oracle 10g, 9i, OBIEE, COGNOS, Oracle Reports, Oracle Discoverer, PL/SQL, SQL, Unix, Windows XP, Oracle
9i Application Server, PVCS

 

JPMORGAN CHASE BANK, New York
The ‘Customer Profitability data warehouse’ (awarded as best enterprise data warehousing solution by CIO magazine) enables easy access of 36 months of customer, product and financial data to the JPMorgan business users worldwide. The Data Warehouse is more than Terabyte in size and features powerful analytical tools, flexible reporting capability and leverages the corporation's authoritative sources of information.

 

• Original creator and architect of JPMorgan’s enterprise wide customer profitability Data warehouse. Worked on this project from inception. Conceived, designed, developed and implemented the data warehouse solution from scratch.
• Managed the complete project with a team size of over twenty five persons.
  
• Analyzed the existing systems and the business user requirements for tactical and strategic needs.
  
• Defined the Architecture and the various phases to create the data warehouse.
  
• Created the Multi Dimensional data model (STAR Schema) and enhanced it to meet the growing requirements due to corporate mergers.
  
• Created the ETL architecture and provided strategy related to data cleansing, data quality and data consolidation
  
• Interacted with the business users on regular basis to consolidate and analyze the requirements and present them the design results.
  
• Successfully designed and implemented a web based multi tier OLAP solution to the data warehouse.
  
• Designed the OLAP front-end in Oracle Discoverer. Responsible for incorporating the business requirements into the data model and the OLAP tool.
  
• Developed the EULs, Hierarchies, Item classes and reports using Oracle Discoverer.
  
• Provided a leadership role on the project and mentored the clients.

Environment Oracle 9i, 8i, Oracle Discoverer, Oracle Designer, Erwin, Ascential Data Stage, Oracle reports, Microstrategy, Sun Solaris, Oracle Application Server

 

 

KPMG PEAT MARWICK/NEXTEL COMMUNICATIONS, VA
Data Warehouse Consultant / Project Manager

• Worked on Design and development of Data Warehouse for Nextel Communications. This involved interacting and facilitating JAD sessions with the business users to gather and analyze the business requirements. Created the complete technical architecture including the Extraction, Transformation, Storage and Data Access method.

 

Verizon Communications
Data Warehouse Consultant / Project Manager

• Worked as the Data Warehouse consultant for creating a Database Marketing Data Mart Project for Price Waterhouse consultant for creating a Database Marketing Data Mart Project for Price Waterhouse. This turnkey project is been done for Bell Atlantic (Telecommunication company).

 

MERRILL LYNCH & CO., New JERSEY
DATA WAREHOUSE ARCHITECT


• Responsibility was to design and implement an enterprise Data Warehouse to meet the decision support needs of users in the area of Stock Options, 401K plans and the Brokerage activities.
During this project, specifically performed the following functions:

• Facilitated JAD sessions to gather the data warehouse requirements from the users.
• Designed a three tier based Data Warehouse architecture.
  
• Customized and Implemented Bill Inmon’s data warehouse development methodology for Merrill Lynch.
  
• Performed Vendor Product evaluation and Selection for: Data Extraction and Transformation Tools, Meta Data Tools, Database (DBMS), DSS OLAP tools (Product analysis included the World Wide Web/Internet Interfaces).
• Created the Data Warehouse Data Model to store atomic level data and the summarized data.
  
• Performed Dimensional Data modeling and created Star Schema and Snow Flakes Schema data model to meet the OLAP needs.
  
• Created a Prototype data warehouse and provided the OLAP front end to show the Drill Down, Roll ups, Pivoting, Slice and Dice features.
• Created the Design for Extraction process from legacy systems using combined techniques of Data Replication and Change Data Capture.
  
• Created the Sample Meta Data from perspective of technical and business users.

 

CITY OF New York, DEPARTMENT OF EMPLOYMENT (DOE), NY

• • Worked on Re-engineering of “Contract Development” process for Department of Employment Agency (DOE). Role included analysis of business requirements followed by preparation of a cost justified solution. After the acceptance of the proposed solution, worked to design and develop this new Re-engineered system.
  
• Consolidated the requirements and worked to create the Enterprise Data Model along with the Logical Data Model for the system using ERWIN CASE tool. Created Entities, attributes, relationships and the data dictionary for the system.
  
• In addition to transactional systems, also created Data Structures for Corporate Data Warehousing for Decision Support Systems (DSS). Analyzed, designed and created the Data Warehouse model which includes, data structures, Meta Data, and design to transform and load data into warehouse. Also looked into aspects of Multidimensional Databases verses the Relational/OLAP.

 

BMG/RCA CORPORATION, New JERSEY

• Worked on Analysis, Design, and Development of the Royalty Management System.
  
• Designed and created data model for Data Warehouse needs. Developed processes to extract, transform and integrate operational data into data warehouse. Evaluated ORACLE database for Data Warehouse needs.

 

WAKEFERN FOOD CORP, New JERSEY

• Reengineered the Electronic Coupon & Promotion sub system of the Price Plus system. Responsibility involved interaction with users to consolidate the requirements and perform extensive Data and Process analysis.
• Proposed and implemented effective System design. This included Extensive Data analysis, data modeling and database design. Performed logical and physical data modeling using EXCELERATOR CASE tool. Designed and developed online and batch processes.

 

5/1992 – 6/1994 SEARS CANADA INC.

• Responsible for the complete design and development of “Credit Card Rating System” and “Sears Apparel Merchandising System (SAMS)” for Sears Canada. Credit Card system created provided real time feature to get the Credit ratings from the Credit Bureaus.
  
• Responsible for entire analysis and design of both of these projects. Also included was client interaction, project planning and management.
  
• Designed both Operational and Data Warehousing data model. Created the data structures and the transformation processes along with the design of Meta Data for DSS.

 

11/87 – 4/92 SOFTWARE CONSULTING COMPANY (DSRC)

Worked as an employee of this consulting company. Performed consulting for following clients:

 

PILLSBURY & CO. 11/91 – 2/92
Worked as a Data Modeler and DBA.

 

JOHN DEERE & CO. 4/91 – 11/91
Worked on design and development of a new “Online Supplier Payment and Reporting System”.

 

NIELSEN MEDIA RESEARCH COMPANY 7/88 – 10/92
(DUN & BRADSTREET CO.)
Worked on various projects as programmer and analyst. Programmed applications in CICS and DB2. Also extensively developed programs for trend and rating analysis-using SAS.

 

UNISYS CORPORATION 10/87 – 6/88
Developed online payroll system for the State Education department. Worked on design and development of this system.

 

7/86/ – 10/87 TATA Engineering & Locomotive Co.

 

TATA ENGINEERING & LOCOMOTIVE CO. 7/86 – 10/87
Worked as a programmer analyst in the Management Information Systems Division.