02/2002 – Present:Administration For Children’s Services (ACS) New york CITY
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.
9/98 – 02/02 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.
3/98 – 8/98 KPMG Peat Marwick/Nextel Communications, VA
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.
This system is being developed in ORACLE EXPRESS Multi Dimensional Database. Created the MOLAP dimensional model and created the complete design of the Database.
Anupam Gupta
4 Restrick Court
Princeton Junction
New Jersey 08550
(973) 202-3384
Fax 609-228-6647 anupam@avenuesinc.com