SUMMARY:

• Over 9.5 years of experience in the information technology field as a hands on Data Architect, ETL Architect and Data Warehouse Designer.
• Designed and implemented technical solutions for companies spanning several industries.
• Data profiling, mapping, cleansing and integration, architecture and development of complex ETL processes between heterogeneous data sources and Enterprise Data Warehouse / application Data Marts
• Dimensional and Entity - Relationship (E-R) modeling, Variable Depth Hierarchy, Slowly Changing Dimensions
• Database Conceptual, Logical and Physical design, forward and reverse engineering, back-end processes implementation utilizing data driven approach, shared business components and advanced functionality in Oracle and SQL Server environments
• Key player in defining the complete data warehouse architecture (ODS, Enterprise Data Warehouse, Data Marts)
• Data-oriented solutions including business requirements analysis, data profiling, analysis and cleaning, design, and implementation for data integration, data consolidation and data migration, capacity planning
• Database optimization and performance tuning to address data latency requirements utilizing performance analysis, execution plans, Bitmap Indexing, Partitioning, Materialized Views, Parallel Queries, Merge and Pipelining
• Enterprise wide applications security and compliance, corporate standards and best practices
• Excellent in communicating well with all stakeholders, optimize objectives, use state of the art tools and best practices, integrate into corporate systems and deliver on time
• A critical thinker and team energizer filled with passion for delivering high quality results
• Create and enforce policies around data, establish and manage development standards
• Experienced in Agile methodology of project execution

SKILLS INVENTORY:

• Data Architecture & Design
• Dimensional & OLTP Modeling
• Data Analysis
• Data Warehouse Design
• ETL Architecture & Design
• Team Lead
• Business Requirements Gathering
• Technical Documentation
• Financial Services
• Leasing and Lending Industry
• Travel & Transportation
• Pharmaceutical
• Consumer Goods
• Information Technology

TECHNICAL SUMMARY:

Databases: Oracle 8i, 9i, 10g, 11g; SQL Server 2005,2008; Microsoft Access

Oracle Products: MVIEWS, SQL*Loader, All Oracle Data Warehousing APIs, APEX

Data Modeling Tools: Embarcadero Data Architect, ERWin, Visio, UDM

ETL Tools: Data Stage, SQL Server SSIS

Reporting Tools: Business Objects; Microstrategy, QlikView, Spotfire

Languages: Java, PL/SQL, SQL, TSQL, Perl Scripting

Packaged Solutions: Loan IQ, Kalido DIW, MDM

PROFESSIONAL EXPERIENCE:

Confidential, Livingston, New Jersey

Enterprise Data Warehouse Architect

Responsibilities:

• Functioned as the Data Architect to integrate business functions across CIT in Enterprise Data Warehouse.
• The data warehouse was designed to integrate data from 14 disparate source systems.
• Core responsibility was to define and design architecture and strategy for the data warehouse. Key projects:
• Defined and documented the data mapping specification (DMS) and functional approach document that formed the blue-print for development for the ETL team
• Worked with the ETL team to define the architecture and optimize performance
• Worked with the Data Governance and Master Data Management (MDM) teams to resolve data issues
• Designed the operational metadata framework to capture statistics related to data loads
• Defined and reinforced development standards and best practices
• Conceived the complete ad hoc reporting environment

Technologies: SQL Server 2008, SSIS, Oracle 10g, Embarcadero ER Studio Data Architect, Business Objects

Confidential

Data Warehouse Architect

Responsibilities:

• Functioned as the Lead Architect to strategically design and implement a solution replace the legacy data warehouse that was in use and evolving for 10 years and functioned as the core HR reporting solution for Confidential
• Architected ETL strategy and framework design for large daily loads to application Data Marts
• Designed and developed data and ETL architecture with Metadata, Staging, Core, Mart and Logs & Exception tables
• Designed and implemented a data migration and data cleansing solution to migrate the historical data from the legacy reporting database to the new enterprise data warehouse. The entire effort from analysis, cleansing, development, testing and migration was achieved within 3 months - well within the initial estimate of time and resources by the management team.
• Defined and reinforced development standards and best practices
• Performed data profiling analysis, process flow definition, schema design and modeling
• Interacted directly with clients to address change requests and development scoping
• Undertook the complete technical ownership of the project

Technologies: Oracle 9i, DataStage, PL/SQL, SQL, ERWin, Business Objects

Confidential

Data Architect

Responsibilities:

• Carried out interviews with various stakeholders in the team to understand the various challenges being faced with data loads and reporting
• Assessed the DataStage jobs that were causing long load times to understand the pain areas
• Carried out Proof of Concepts by recommending design changes that caused significant reduction in the load time
• Assessed the reporting solution that was generating hundreds of SQL statements and hence causing delays in report generation. There was a 40% improvement in load performance and 92% improvement in reporting performance

Technologies: Sybase ASE, Sybase IQ, DataStage 7.5, MicroStrategy 8.3

Confidential

Data Architect

Responsibilities:

• Designed the logical and physical data models
• Undertook the complete technical ownership of the project and mentored the team
• Conceived the various stages of the calculation engine with appropriate exception handling and exit criteria
• The deployed system uses fares data provided by Confidential as input, applies the different allocation rules as metadata and generates the FlesFares. The high performance route algorithm calculates the optimum route between any two given city pairs using Djikstra’s algorithm

Technologies: Oracle 10g, Sunopsis, PL/ SQL, Oracle Application Express (APEX), ERWin 7.0

Confidential, Madison, New Jersey

ETL & Data Architect

Responsibilities:

• Carried out requirement gathering to understand the nature of POS datawarehouse to implement
• Carried out a Proof of Concept to successfully demonstrate Kalido’s capability to handle Wyeth’s Point of Sales data
• Successfully demonstrated Kalido’s ability to implement a data warehouse by using Transaction DataSets, Attributes and Classes

Technologies: Kalido DIW 8.3, Oracle 10g

Confidential

Data Modeler

Responsibilities:

• Liaised with the individual data warehouse teams to understand the nature of ERP data
• Implemented a Master Data Management solution on top of a consolidated DIW on sample data to cleanse and consolidate data from across multiple data sources in a single repository
• The solution enabled consolidation, harmonizing of product, organization data along with implementation of workflow and security to ensure that only the authorized people had the necessary accesses

Technologies: Kalido MDM 8.3, SQL Server 2000

Confidential

Data Modeler, Technical Lead

Responsibilities:

• Designed and developed data and ETL architecture with Metadata, Staging, Core, Mart and Logs & Exception tables
• Responsible for the complete technical ownership of the project
• The new automated system enabled the CEO report generation time from 3 weeks to 1 week

Technologies: Oracle 10g, PL/ SQL, Perl Scripting, Sunopsis, ERWin 4.0, Business Objects

Confidential

Technical/ Business Analyst

Responsibilities:

• Carried out interviews with CEOs of the different countries to understand the business and data
• Carried out data analysis on the parameters of Completeness, Accuracy and Precision and ranked the quality of data as a percentage and depicted through a Bar graph
• Organization structure was also proposed to assign data ownership to create a centralized regional master data management team rather than localization

Confidential

Technical Consultant

Responsibilities:

• Used the Kalido DIW with assistance of consultants from Kalido to implement a Kalido Datawarehouse and populate the data
• Classes, Attributes and Transaction Data Sets were used
• Tested the new features of Kalido v8.2 that were not available in Kalido v8.0 and it was assessed that some of the features were still not defect free

Technologies: Kalido MDM v8.0 & v8.2, Kalido DIW v8.2, SQL Server 2000