Data Warehouse Management
Resume:
Ash Banerjee
Phone: 571-***-****
Ashburn, VA, 20148
*************@*****.***
[pic]
OBJECTIVE
To obtain a senior level technology management position that will leverage
my experience in implementing and supporting enterprise data warehouse and
business intelligence programs.
[pic]
SUMMARY
Mr. Banerjee has over 14 years of experience leading the design,
development and implementation of Enterprise Data Architecture, Enterprise
Data Warehouse and Data Management solutions, delivering increased
operational efficiency, improved business performance and a clearer view of
the enterprise. He has employed leading edge data warehouse platforms that
have been leveraged for revenue assurance, financial regulatory audits, and
business activity monitoring. He has developed Data strategies,
architectures and roadmaps, managed large scale operational data stores,
dimensional data marts, and highly effective business intelligence
applications. Mr. Banerjee has extensive expertise in evaluating,
recommending, defining and advocating enterprise business architecture
models, standards, and platforms to enable end-to-end business and IT
transformations across complex environments, and align technology
investments with strategic goals to deliver high business automation value.
He has extensive experience with Financial Data Warehouses intended to
assist in risk analysis and management. He partners with clients and
external customers to understand business objectives, articulate a vision,
evaluate risks and define roadmaps to strengthen IT capabilities,
processes, and technology investments. Mr Banerjee has presented at several
chapters of the Teradata Partners Conference on data warehouse maturity and
active data warehouse solutions.
[pic]
PROFESSIONAL EXPERIENCE
Booz Allen Hamilton, Herndon VA
2010- Present
Sr. Enterprise Data Warehouse Architect
. Provide business development and technical leadership for the
Enterprise Data Warehouse and Data Management technology groups at
Booz Allen's Financial Services Division.
. Manage proposal development and delivery for several clients in the
Financial Services Industry related to Data Management, Data
Governance, Data Warehouse Architecture and Data Mining and
Analytics including SEC (Securities and Exchange Communication) and
FRB (Federal Reserve Board).
. Provide assessment and perform evaluation of current application and
data architectures at Fannie Mae and PBGC (Pension Benefits
Guarantee Corporation) and contribute towards documenting the
proposed target state of the enterprise data architecture at these
firms.
. Provide architecture and technology services for a Strategic
Workforce Planning application leveraging SAP Business Objects and
SAS Analytics to deliver dashboards, reports and analytics for the
IRS.
. Supporting a National Data Warehouse build-out effort for the EERE
(Energy Efficiency and Renewable Energy) division within Department
of Energy for collecting renewable energy sources of data across the
federal and commercial industries and establishing standard
reporting and analysis.
Network Solutions, Herndon VA
2003 - 2010
Senior Manager, Enterprise Data Warehouse
. Responsible for managing the Enterprise Data Warehouse development,
architecture and operations at Network Solutions.
. Involved in planning and execution for the transformation, consolidation
and migration of several legacy Operational Data Stores and Data Marts
into the Enterprise Data Warehouse.
. Led the development of the logical and physical data models for several
subject areas of the integrated data warehouse based on Communication
Logical Data Model standards from Teradata.
. Responsible for leading the design and architecture of several corporate
data warehouse initiatives to serve internal data consumers such as
Finance, Marketing, Sales, Customer Service and Product Management.
. Responsible for leading the design, architecture development and
implementation of a robust Operational Dashboard product for Call Center
Operations at Network Solutions using innovative Business Intelligence
technologies.
. Involved in planning and setup of IT General Controls for Sarbanes Oxley
for several key financial subject areas of the Enterprise Data Warehouse.
. Led the architecture and design of integration of the data warehouse with
downstream Hyperion and Oracle Financial applications for revenue
reconciliation and month-end financial close.
. Supported data mining efforts in establishing market segmentation and
creating models for predictive analysis to provide effective risk
management and prevent customer churn.
. Managed the implementation of an Enterprise Data Quality Solution using
IDQ (Informatica Data Quality) software product.
. Led several key infrastructure initiatives for the data warehouse such as
capacity expansion, software upgrades and technology refresh.
. Managed the implementation of Operational Dashboards for key performance
metrics such as system availability & uptime, resource and bandwidth
utilization among others for the enterprise data warehouse
infrastructure.
. Implemented a comprehensive data profiling capability for the customer
data leading to a strong customer segmentation model for campaigns and
marketing efforts.
. Responsible for overseeing the implementation of a comprehensive data &
application security model for the enterprise wide access for analysis
and reporting.
. Responsible for leading a team of data analysts for data cleansing and
other data services related to data warehouse and operational databases.
. Informatica Data Explorer utilized for discovering and analyzing data
anomalies across all customer centric data sources.
. Involved in operational analysis of web server logs for the purpose of
identifying and processing traffic, visitor and customer information.
[pic]
VERIZON, Arlington VA
2001 - 2003
Data Warehouse Lead, NMP (Network Metrics Performance) Enterprise Data
Warehouse
. Managed a centralized 3.5 TB enterprise data warehouse, collecting more
than a million
records per day from various legacy operational systems within Verizon
including Pre-Order and Order processing, Billing systems, Provisioning
and Maintenance & Repair.
. Responsible for building a team of database specialists to support design
and implementation
of the multi terabyte data warehouse system.
. Led the implementation of a data quality solution for the enterprise data
warehouse using Informatica ETL technology supplemented with a robust
data cleansing and data validation rule engine.
. Led the planning and execution of several cross organization and multi
faceted software
upgrades and technology refresh activities for the data warehouse
systems.
. Supported Meta Data Management Initiatives and Standardization of data
elements that affected several downstream database applications.
. Provided strategic guidance on Metric design and management, enterprise
reporting, analytics and data mining.
. Led the architecture and framework development for the Reporting platform
using Business Objects and Crystal Reports to support scheduled, adhoc
and other forms of reporting and analytical needs .
. Led the efforts for designing archival strategies to recycle large
amounts of data and achieve
effective management of storage.
[pic]
BT ( British Telecom), Reston, VA
2000 - 2001
Data warehouse Architect/Technology Lead, Financial analysis and Reporting
System (FARS), Revenue Planning Model (RPM)
1. Led several multi-user data mart applications primarily focused in
financial analysis and reporting.
2. Responsible for Planning and coordinating all design and developmental
activities for the data marts, leading user-support for reports, adhoc
analysis and resolving data and system issues.
3. Supported Corporate Initiatives in Risk Management and Analysis through
data mining by designing effective analytical models in SPSS.
4. Led the architecture redesign initiative for the Corporate Budget and
Forecasting application revamping several cross organization data and
platforms and reporting systems .
[pic]
CONCERT ( a BT and AT&T company), Reston,VA
1997 - 2000
Development Lead, Inter Business Charging (IBC)
Served as the Development lead for the IBC/ Crescendo project which is the
Settlement system for Concert.
5. Involved in Design, Development and Support of several software products
for the settlement system.
6. Manage the production support for the batch cycles for the nightly and
monthly back end processes for the settlement system.
7. Lead technology refresh efforts pertaining to the software and the
hardware hosting the IBC and its subsidiary applications.
8. Provide data analysis, data cleansing and database optimization support
for the applications on a continuous basis.
[pic]
Stock Holding Corporation of India Ltd, India
1994 - 1997
Lead Developer, Corporate Actions Division
Worked as the Lead Developer for the Corporate Actions Division for the
Stock Holding Corporation of India Ltd. SHCIL is India's leading Custodial
Service.
9. Involved in application and database design, database maintenance and
support, backups and recovery.
10. Designing and developing 24x7 database monitoring scripts using shell
and awk.
11. Responsible for setting up a security system for the corporate actions
division for governing the access to the database using dynamic controls.
12. Designed and Developed self-recoverable re-executable batch programs
which would be deployed in case of application failures.
National Depository System, Stock Holding Corpn of India Ltd. India
Developer
Served as the Developer/DBA for the national depository system. This system
was a legacy repository with above 200 GB of data.
13. Led the design, development for database applications to analyze the
schema and collect statistics on a regular basis for efficient space
management in the database.
14. Oracle version upgrades from 7.0 to 7.2 and 7.3.4
15. Normalization of data from legacy database and performance
optimization.
Primary Market Operations, Stock Holding Corpn of India Ltd. India
Developer
The system required the development of modules for handling the
initial public offerings and new issues from various companies and
generates reports to the clients about their eligibility for the primary
market application.
16. Involved in the development and implementation of the system using
Oracle Standard Procedures, Triggers, Pro*c's, Report Writers, Forms etc.
17. Responsible for migration of legacy data from several desktop database
applications to a centralized market data warehouse.
QUALIFICATION HIGHLIGHTS
OPERATING SYSTEMS Sun Solaris, HP-UX, Windows, Red Hat Linux
RDBMS Teradata 12.0, Oracle10.x, Oracle 9.x, MySQL 5
MS SQL Server 2005,MS
SQL Server 2007
RDBMS Tools Oracle Enterprise Manager, Quest
Database Tools,
Teradata Client and
Database Management Tools, Coffing DW
Products, Erwin Data
Modeler, SQL, Transact SQL, PL/SQL
BI TOOLS Informatica 8.1, Informatica 7.x, SAP Business
Objects, Microstrategy
8.0, Microsoft Office, IBM Cognos,
Sharepoint 2007 Report
Services,
OBIEE,MS-SIS,MS-SAS
Data Mining Tools IBM SPSS Statistics, Teradata
Warehouse Miner
[pic]
EDUCATION and CERTIFICATIONS
Bachelor of Engineering from GGD State University, INDIA - 1993
(Electrical Engineering)
Oracle Database Certification - 1998
Teradata Certified Professional - 2006
Contact this candidate