BHASKAR MITRA
12905 Morning Park Circle, Alpharetta, GA 30004
email: [email protected]
Over Seventeen years of experience in the Information Technology profession, worked in various capacities as an IT Director, Senior Data Warehouse Manager, Lead Data Warehouse Architect, Technical Leader, Project Leader. Successfully and repeatedly delivered, managed, executed, and implemented projects in the key areas of Enterprise Data Warehouse, Data marts and Operational Data Stores using Ralph Kimball and Bill Inmon Methodologies, Online Analytical Processing (OLAP), Enterprise Application Architecture, Real time Transactional Systems (OLTP) and Enterprise Resource Planning (ERP). Vast knowledge in Advanced Data Warehousing framework and methodologies, ETL Architecture, Multidimensional Data Modeling incorporating Star and Snowflakes and implementation techniques using Microsoft, Oracle and IBM BI Product Suites.
Management Issues (Technical Strategies, System Architecture, SDLC, Scope Changes, Role Management).
Ralph Kimball, Bill Inmon, IBM, Microsoft and Oracle Data Warehousing Methodologies.
Business Process Control (Business Discovery, Process Definition, Process Cycle, Data Interaction).
Analyzing customer needs, writing Proposals, Statement of Work and Technical Architecture Documents.
Data Warehousing and Modeling using Multi Dimensional (Star/Snowflake) and E-R approach in a large Enterprise Data Warehouse (EDW) applications, Operational Data Stores (ODS), Data Marts, Multi Dimensional Data Cube Design for various Industries (Financial, Healthcare, Insurance, Manufacturing).
Oracle PL/SQL 2.1, T-SQL, C, VB5.0, Visual SourceSafe, C, VA Java 3.5, EJB, XML, Unix shell scripts.
ERwin 3.5,4.0, 7.2, Embacardero ER/Studio 6.5, Power Designer 6.1, TOAD, Designer 2000/Developer 2000 (Schema Generation, Reverse Engineering, Stored Procedures, Indexes), Rational Suite (UML).
MS Project 2007, 2000 (Project Scheduling, Resource Allocation, Tasks, Sub Tasks, Charts).
Microsoft SSIS, DTS, Business Objects Data Integrator 11.5.2, Informatica PowerCenter and PowerMart 7.x, Oracle Warehouse Manager (OWH), IBM DB2 Warehouse Manager, DataJunction, Constellar v3.1.
ROLAP/MOLAP using MS Analysis Services 2005, Cognos PowerPlay/Impromptu 7.0, Business Objects.
Oracle Financials 11i (GL, AP, AR, PO, SO, INV, HR) technical implementation and interface design.
ASP/MTS/ADSI and security issues (SSL, key encryption, digital certificates, firewall, proxy server).
Oracle 10.g, 9i, 8i, 7.x, MS SQL Server 2005, 2000, 7.0 and 6.5., IBM DB2 v7, Teradata 2.4.
Dynamic Link Library (DLL), ActiveX, OLE DB, ODBC, JDBC (configuration, connection pooling).
Oracle PL/SQL 2.1 (Cursors, Triggers, Dynamic SQL, Stored Procedures), SQL Loader, SQL Plus 2.3.
Virtual PC, Windows 2003 and 2000, HP-UX (10.2, 11.0), (Solaris 2.5,2.6), AIX 4.3, N-Tier Architecture.
US Citizen, open to travel.
As a Consulting Data Warehouse Manager/ETL Architect for a Military Healthcare Project in Louisville, KY
Defined the scope, budgeted and presented to C-level personnel a detailed project charter for a $1M Military Healthcare Data Warehouse initiative using MS Project 2007.
As a Consulting DataMart Architect for a Automotive Insurance Project in Atlanta, GA
Architected,, managed and modeled (using Erwin 7.1) a $200K Policy Coverage and Driver Violation Datamart following Kimball methodology and implemented the Initial and Incremental data load processes incorporating Table Comparison, History Preservation and other advanced transformations techniques using Business Objects Data Integrator v11.7.2 as an ETL tool. Source and Target were in SQLServer 2005.
As a Lead Data Warehouse Architect for a Healthcare Data Warehouse Project in Raleigh, NC
Architected, budgeted, managed and delivered a $1M Healthcare and Hospital Management datamart following Ralph Kimball’s methodology and implemented using Microsoft Business Intelligence 2005 .
Designed and automated the Initial and Incremental ETL processes incorporating Slowly Changing Dimensions using MS SSIS. Source data were extracted from Informix to target in SQLServer 2005.
Trained offshore resources in India on Data Warehousing methodologies, multi dimensional data modeling using ERWin and ETL architecture/implementation using MS SSIS as part of knowledge transfer program.
As a Senior Data Warehouse Manager/Architect for a Financial Credit Union in Florida
Led, Architected, Scoped, Modeled and Implemented a $0.5M Financial Credit Union Data Warehouse for Credit Card, Service Participation and Fraud Management Program using ERWin 7.2 as modeling tool and BO Data Integrator v11.5.2 as an ETL tool with source and target databases in Oracle 10g.
As a Lead Data Warehouse Architect for a Communication Data Mart Project in Georgia
Architected, planned, managed, modeled (in Erwin 4.1), designed and implemented a $400K Communication Service Datamart in SQL Server 2005 using MS SSIS with source in IBM mainframe.
As a Lead Data Warehouse Architect for a Financial Data Mart Project in Charlotte, NC
Architected, managed, modeled (in Embacardero ER/Studio 6.5) and implemented a $300K Asset Liability Management Data Mart for Security Holding-Portfolio-Rating analysis and reporting following Ralph Kimball’s methodology using Microsoft Visual Studio 2005 Business Intelligence Product Suites.
Designed, tuned and automated the Initial / Incremental ETL processes incorporating Slowly Changing Dimensions using SQLServer Integration Services. Source and target were in SQLServer2000 and 2005.
Responsible for managing, designing and implementating a $400K Loan Officers Incentive Data Mart of a large banking institution. Modeled in Erwin 4.0, and designed the ETL framework using MS DTS packages with source data extracted from Teradata 2.4 and target in SQL Server 2000 and Cognos 7.0 as OLAP tool.
Architected and managed two offshore development projects – One for a Hospital Management Decision Support System and the other for a Hotel Management Warehouse. Modeled Multi Dimensional Star and Snowflake data marts for Patient Diagnostics, Tracking, Hotel Customer Analytics and Promotions.
As a Contract Data Warehouse Architect for a Logistics Data Warehouse Project in Georgia (for Cendian)
Architected, modeled and deployed a $300K for Order, Shipment and Invoice DataMart following Kimball’s methodology. Source data extracted from Oracle 11.5.6 using SQLServer 2000 DTS packages.
IBM GLOBAL SERVICES, Senior IT Architect, Atlanta, GA Aug, 2000 – Mar, 2002
Led, Architected, automated, implemented and deployed the extract, transform and data load process of a third party real time sports content data feed to a large enterprise data warehouse environment.
Crafted a generic algorithm to create a universal Oracle PL/SQL package, which read the Oracle internal data dictionary to perform data movement within different database instances of fifty large tables.
Actively contributed in several key areas of logical and physical data modeling, data access and security policy, metadata repository, database administration, performance and tuning.
Responsible for designing the logical data model in Erwin 3.5, defining data standards, maintaining data catalogue, projected data growth calculations and implementation of physical schema in SQL Server.
Designed the data load strategy, business metadata, implemented and automated ETL process using custom SQL, which resulted in expedited data loading.
Performed a High Level Infrastructure Assessment and Technical Gap Analysis with respect to the Macro Design Phase for an Internet Data Scrubber application project by reviewing the existing and to-be infrastructure architecture as recommended by IBM and conducting interviews with client representatives.
Confirmed the Enterprise Warehouse Data Model, disparate data feeds, scrubbing and loading strategies, XML architecture and document structure as a feed to the information warehouse.
Designed the OLAP data cubes for on-line analytical queries using Cognos PowerPlay Transformer, which was then accessed through Cognos Impromptu for ad-hoc reporting, multi dimensional analysis.
As a Senior Data Architect for an Enterprise Data Warehouse Project in California
Architected, Analysed, Designed and Developed HDS Global Product line Data Warehouse Project, involving development of Data Marts (Professional Services, Purchasing, Inventory, Project Accounting).
Reverse engineered, analyzed and designed interfaces of Oracle Financial modules using Power Designer Warehouse Architect to generate ERD and Data Dictionary for target Data Marts. Data source mapping, target database modeling for post extraction, transformation, business rule validation and target datamart loading into Oracle 9i database from Oracle Financial Applications v10.7 (PO, OE, SO, GL, INV).
FACTORY AUTOMATION SYSTEMS, Senior Engineer, Atlanta, GA Dec, 1996 – Aug, 1999
Designed, developed and implemented several Real Time OLTP systems in Oracle and SQL Servers.
VECTOR INTERNATIONAL, Systems Engineer, Atlanta, GA Nov, 1994 – Dec, 1996
Designed logical and physical data model for various Real Time OLTP systems using ERwin , PL/SQL.
R.E. PHELON, INC., Contract Engineer, Aiken, SC Jun, 1994 – Nov, 1994
Responsible for the design and development of a high-speed data acquisition system using LabVIEW.
UNIVERSITY OF SOUTH CAROLINA, Graduate Assistant, Columbia, SC Jan, 1990 – May, 1994
Coursework, research, lab setup, data acquisition, interface coding of a switching device for MS Thesis.
M. N. DASTUR & CO. LTD., Systems Engineer, India May, 1987 – Dec, 1989
Data related design, modeling and implementation for manufacturing and process industries.
MS in Electrical Engineering, University of South Carolina, Columbia, USA, 1993, GPA 3.7.
BS in Electrical Engineering, Jadavpur University, Calcutta, India, 1987, GPA 3.5.
CERTIFICATION
IBM Corporation: Advanced Data Warehouse and Multidimensional Data Modeling, DB2 Warehouse Manager, Business Intelligence and Systems Integration Methodologies, Advanced Java, WebSphere Applications Server Advanced Edition and EJB Workshop, XML and Related Technologies.