|
Resume of Anupam Gupta
Data Warehousing Consultant
4 Restrick Ct, Princeton Junction, NJ 08550
Ph: 609-945-1160(res), 973-202-3384(cell)
Email: anupam@avenuesinc.com
Summary
Over twenty years of comprehensive & in-depth experience in the Information Technology (IT) industry with specialization and expertise in Data Warehousing and Business Intelligence area. Experienced in Financials, Brokerage, Telecom and Public sector business domain.
- Performed overall project management, analysis, architecture, design, development and implementation of data warehousing / business intelligence initiatives for last twelve 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 the project planning, budgeting, and resource allocations. Identified and resolved the critical path items to ensure successful completion of project in a timely manner
- 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
Oracle 10G, Oracle 9i, MS SQL Server, Sybase, DB2 UDB
Education
Bachelor of Engineering (B.Tech) from Indian Institute of Technology ( I.I.T. New Delhi, India)
Professional Experience
02/2002 – Present:
Administration For Children’s Services (ACS) New york CITY
Role: Data Warehouse Project Manager
Worked for over six years at ACS in New York City 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.
Developed 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.
Responsibility and Key achievements are:
- Interacted with the top executives, business sponsors, and ‘IT’ department to analyze and define the ACS data integration and reporting needs.
- Proposed overall strategy and phased approach for creating an Integrated Case Management and Data Warehousing solution.
- Created the Architecture to support both the short term and long term data integration and management reporting business needs of ACS. This involved integrating NYC applications to NY State applications along with centralized data repository and data warehouse.
- Developed central repository of Child cases, individual and worker data within the ACS enterprise database. Created Architecture for integrating the NY State WMS data feeds into the ACRSplus application.
- Worked on architecture, data modeling and overall design of the solution. Involved in the technology and software tools evaluation and recommendations.
- Managed a team of over twenty persons to perform the analysis, design, development, and implementation tasks.
- Created a centralized Operational Data Store which has complete caseload information residing in a single database. The ODS supported by data feeds from the New York State systems of record (Connections and WMS) as well as the data feeds of Child Protective Services (CPS) cases and preventive cases by ACS workers data from ACS database.
- Created data warehousing solution with the integrated Child, Case, Staff, Time and Organization data to provide management reports regarding caseloads and case activity. Also this data warehousing enables ACS to increase the rate of reimbursements through earlier identification of inconsistencies in case records, better tracking of eligibility determinations and earlier notification of compliance requirements.
Software: Oracle 10g, 9i, OBIEE, COGNOS, Oracle Reports, Oracle Discoverer, PL/SQL, SQL, Unix, Windows XP, Oracle 9i Application Server, PVCS
9/98 – 02/02 JPMorgan Chase Bank, New York
Senior Data Warehouse Consultant / Project Manager
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.
Responsibility:
- 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
3/98 – 8/98 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.
- Responsible for all the stages of this project. This included evaluation of toolsets, software and hardware, creation of the application architecture including the warehouse maintenance and change management. Created the methods and standards for data warehouse architecture, meta data, logical and physical database and front end OLAP access.
- This system is being developed in ORACLE EXPRESS Multi Dimensional Database. Created the MOLAP dimensional model and created the complete design of the Database. Developed Oracle Analyzer OLAP front end for users to perform adhoc queries with drill down capabilities. Create the Internet/Web OLAP front-end using Oracle Web Publisher.
1/97 – 3/98 Price Waterhouse/Bell Atlantic , New YORK
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).
- Worked on analyzing the requirements of Marketing department. Created Logical STAR/Snow Flake Data Model using ERWIN Case Tool. This Data Mart model had over fifteen dimensions including dimensions to reflect the customer demographics and segmentation details.
- Created the Data Mart Physical Data model on DB2 database. Designed the complete architecture of this Data Mart. Optimized the Database Storage and performance by creating suitable aggregated tables.
- Designed the Data Extraction, Cleaning and Transformation process. Integrated the External Source Data (PRISM, CLARITAS, Axiom) to the internal data and consolidated into the Data Mart.
- Developed MicroStrategy (DSS Agent/DSS Architecture) front end to perform OLAP analysis. Worked to establish the connectivity from MicroStrategy to DB2 using Client Application Enable (CAE) and ODBC. Designed the DSS Objects including Filters and Templates for OLAP analysis.
- Also evaluated the alternate Data Warehouse architecture for long-term needs using SMP Clusters and three-tier architecture with Oracle as the middle tier using DSS Serve.
6/96 – 1/97 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.
9/95 – 6/96 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.
- Responsibilities include interaction with the end users, analysis of business processes, consolidation of requirements followed by Business Process Re-engineering. Worked using Ed Yordon methodology for developing client server applications. This included techniques of Event driven approach, Joint Application Design (JAD) & Rapid Application Development (RAD).
- 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.
- Re-engineered, designed and created Enterprise Database in SQL Server running on Windows NT Server. Created Stores Procedures, Triggers, Rules & Defaults to ensure data integrity and consistency on SQL Server database.
- 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.
- Using PowerBuilder designed and presented Prototypes to end-users. Designed the GUI front end of Decision Support Systems (DSS) and transactional systems in PowerBuilder. Designed and developed the entire application using Object Oriented approach. Extensively used features like Object Inheritance, User Objects, DataWindows, Nested reports, etc. of PowerBuilder 4.0.
11/94 – 8/95 BMG/RCA Corporation, NEW JERSEY
- Worked on Analysis, Design, and Development of the Royalty Management System.
- Analyzed the existing system, interacted with the end users to consolidate the business requirements. Developed the Logical Data Model (Entities, attributes and relationships) using EXCELERATOR CASE Tool. Created the Data Dictionary and standardized the data elements and terminology.
- 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.
- Created the Physical Database on DB2/2 running on OS/2 based Client server. Also involved in system process design including creation of Event lists, Data Flow diagrams design of Presentation Manager, Business Logic and Database logic (a three tier clients server architecture).
- Created the Prototype of the system. Guided the team in developing the GUI based application. Used PVCS for version control and configuration management.
6/94 – 10/94 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/92 – 5/94 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.
- SAMS system, which was Relational/OLAP data warehouse based Decision Support System (DSS) was Prototype and developed on Sybase and PowerBuilder. It provided GUI based user-friendly interface for Forecasting & Trend analysis (for sales and inventory) for the different demographics and regions.
- Responsible for entire analysis and design of both of these projects. Also included was client interaction, project planning and management.
- Worked with the Sears personnel for requirement analysis and functional design. As a Business and Data Analyst, performed detailed analysis along with logical and physical data modeling using EXCELERATOR. Created and documented Business Process Model. This included all the function and process dependencies.
- 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. Worked extensively in data modeling, entity relationship diagrams and creation of logical data model using BACHMAN CASE Tool. Designed and successfully created Logical and Physical Data model for “Project Tracking System”. Provided DBA support for systems development group.
John Deere & Co. 4/91 – 11/91
Worked on design and development of a new “Online Supplier Payment and Reporting System”. Performed complete analysis, design, and development of this project in capacity of a Project Leader. It involved initial system study, requirement analysis, logical data modeling, physical database design, systems design and development. System was completed well in time and its structured design was greatly appreciated by the client.
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. Project was completed ahead of time and was used as model by clients to develop their other new applications.
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. Had very elaborate training in all the aspects of Computers and Information systems. Gained extensive experience in systems design and programming. Worked as a tem member for development of Inventory, Materials Management and Purchase Order Systems. |
