Executive Summary

Highly skilled senior Architect / Manager with over 15 Years of experience in IT with very strong background in Architecting & Implementing several Enterprise Data Warehouses (EDW), Big Data Platforms, BI Dashboards / Analytics, BI Infrastructure including Data Governance, Data Federation Solutions and in managing full Project lifecycles. Experience analyzing business requirements and designing effective Big Data solutions, Data Warehouses / Systems, reporting solutions / BI solutions that facilitates an organization to detect and respond immediately to opportunities and issues. Hands-on development experience Big Data Platform (Hadoop, Hive, Impala), Oracle Business Intelligence (OBIEE 11g), QlikSense, Oracle BI Apps 7.9, Informatica 8.x (PowerCenter – Designer, Workflow, PowerExchange), Oracle Data Integrator (ODI 10.1), Oracle, SQL Server, DB2, IMS, PL/SQL (Stored Procedures, Functions, Triggers), T-SQL, Java J2EE, Web Services / SOA, JMS, TCL, ER Studio / ERWin / Oracle Designer (Data Modeling). Excellent Project Management skills using Agile, Waterfall methodologies, JAD, UML / Use Cases; Managed medium to large size Big Data, Data Warehouse, Data Mart Projects, managed / mentored project teams (10 to 50+ members), project planning, scheduling, budget management, risk management, On-site / Off-shore / Hybrid Models. Outstanding communication and liaison skills proven by effective interaction with clients, business stakeholders, management, and team members.

Core Competencies

Big Data / Data Warehouse / Data Mart / Data Governance / Data Federation / Change Data Capture (CDC) / Business Intelligence – Dashboards, Analytics / ETL -Architect & Development

Data Architect / Data Modeling (2NF, 3NF, 1NNF, Star) / Database Logical & Physical Design

Product / Project Management - On-site / Off-shore / Hybrid Models

Business Process Analysis, Deisgn & Modeling

System Analysis, System Integration

Application & Database performance Tuning

Database Architectural Design & Optimization

Web, e Commerce Application Architecture Design (N-Tier, MVC, Struts)

Industries

Financials Health Care

Insurance Banking

Oil & Gas Manufacturing

Technology

Technology proficiency

Windows 2003, Unix (HP/UX, Sun Solaris), Linux, Oracle 8i/9i/10g, DB2, IMS, SQL Server 2000 / 2005, Sybase.

Big Data (Hadoop, Hive, Impala, Sqoop, Pig, Flume, Python, Shell scripting)

Oracle Business Intelligence (OBIEE 11g) (BI Publisher, BI Answers, Dashboard), Oracle Discoverer 4.x/5.x, Oracle BI Apps 7.9, Oracle Financials 10.7, Oracle E Business Suite (Oracle EBS) 11.x, R12.

Informatica 8.x (PowerCenter – Designer, Workflow, PowerExchange), Oracle Data Integrator (ODI 10.1)

PL/SQL (Stored Procedures, Triggers), OCI, Pro*C, SQL*Loader, Exp/Imp, SQL*Plus, Query Analyzer, Explain Plan, Oracle Enterprise Manager (DB Console).

Java (JSP, Servlet, Beans), JavaScript, C/C++, PowerBuilder

SQL Server T-SQL (Stored Procedures, Triggers)

DB2 Connect, DataDirect zConnect

Unix Shell Scripting, TCL, ActivePERL,

ER Studio, ERWin, Visio, MS Office Applications

OLAP - Kimball Life Cycle / Dimensional Star Schema, Inmon

Project Management –UML / Use Case, Agile / Waterfall Methodology, JAD, MS project.

Education

MBA (Information Systems)

MS (Information Systems)

BS (Physics)

Projects

Voya Financials Fraud Analytics

Lead Big Data Architect 02/17 – Till Date

Built an enterprise wide Fraud alert system that pours over customer profile changes, money out transactions, customer interactions in the website to glean potential fraudulent financial transactions. Designed a Big Data adapter to intake Customer Profile, Transactions, Logs from over 200 systems, translate this into a meaningful data set that feeds into an array of consuming applications such as Splunk, Tableau, Machine Learning. The data that is processed on a daily basis runs into 100s of TB. Created a reusable Data Ingestion adapter, Data Transformation adapter that intakes the data from Source Systems and prepares a data set of potential fraudulent activities. Use Sqoop, Hive, Python in the Hadoop environment for data ingestion, data preparation.

Environment: Cloudera CDH 5.9, Hadoop, Hive 1.1, Sqoop, Impala, Python, Tableau, Linux Red Hat Linux 5.9, Oracle, DB2, IMS

State Street Procurement Analytics

Lead Architect 10/15 – 01/17

Built roadmap and implemented the Market Share Analytics platform that included milestones, infrastructure, design and key metrics. Provided leadership, technology direction, high level system analysis and architectural assistance for this DW/BI implementation.

Built an enterprise wide Procurement Data Mart in a Big Data environment that intakes procurement, market data, customer feedback, Transactions, Logs from both internal and external systems to translate this into a meaningful data set that feeds into an array of consuming applications such as OBIEE. Created a reusable Data Ingestion & Transformation framework that intakes the data from Source Systems and prepares a data set alogn with Type 2 and similar change tracking mechanism. Use Sqoop, Hive, Impala, Python in the Hadoop environment for data ingestion, data preparation.

Environment: Oracle Business Intelligence (OBIEE 11g), Cloudera CDH 5.9, Hadoop, Hive 1.1, Sqoop, Impala, Python, Linux Red Hat Linux 5.9, Oracle, DB2, SQL Server

Lam Research Market Share Analytics

Lead DW / BI Architect 01/15 – 10/15

Built roadmap and implemented the Market Share Analytics platform that included milestones, infrastructure, design and key metrics. Provided leadership, technology direction, high level system analysis and architectural assistance for this DW/BI implementation.

Managed several key DW/BI initiatives as part of this larger scheme spanning key business areas, worked with stake holders & business analysts (to gather business requirements, design data model, metadata model), designed data migration, data integration & interface models.

Provided key architectural insight and development assistance across several core business processes, customized / enhanced business model, tuned meta data for better analytics performance etc., Designed and implemented several key reporting baselines such as Region & Product hierarchies, Market Share configurations, external factors.

Environment: QlikSense, SQL Server, SAP (Source System), QlikSense, Web Services / SOA

American Tower Financials, Property, Procurement Analytics

Lead Architect / /BI Infrastructure Upgrades 04/12 – 06/14

The Goal is to provide measurable core performance metrics at various levels of the Organization across multiple functional areas – Finance, FP&A, Leasing using OBIEE and Cognos as the Business Intelligence Platforms. Built a technology roadmap to create this platform, milestones, and key metrics to achieve this goal. Provided leadership, technology direction, high level system analysis and architectural assistance for this BI implementation.

Managed several key BI initiatives as part of this larger scheme spanning key business areas, worked with stake holders & business analysts (to gather business requirements, design data model, metadata model), designed data migration, data integration & interface models.

Provided key architectural insight and development assistance across several core business processes, customized / enhanced business model, tuned meta data for better analytics performance etc., Designed and implemented several key reporting baselines such as Accounting hierarchies, business process re-engineering in Oracle R11/R12.

BI Server Upgrades:

Planned and performed several in-place and out-of-place BI Server upgrades from 11.1.1.4 to 11.1.1.6 and 11.1.1.6 to 11.1.1.7. Scope included upgrading DEV, TEST, UAT and PROD Servers and revamped Security Model to conform with 11g OPSS and Role based security, RPD Migration, Catalog Migration, Instance tuning and upgrade validation. Used accel-BI, that automates the upgrade validation by running 100s of reports before upgrade, takes a snapshot of the data and compares with the same report post upgrade, to drastically reduce the upgrade project cycle and helps to perform a thorough validation as well. It compares data and formatting as well and reports the variations.

Environment: Oracle Business Intelligence (OBIEE 11g), accel-BI, QlikSense, Oracle BI Apps 7.9 (Financial, Procurement & Spend Analytics), Oracle Apps 11.5/R12, Oracle 11g, Web Services / SOA.

State Street Financials, Procurement Analytics

Lead Architect /BI Infrastructure Upgrades 07/11 – 04/12

Developed a Business Intelligence roadmap to implement Oracle Financials and Procurement, Spend Analytics for this leading investment management firm. Analyzed the key business processes & requirements, against Oracle’s out of box solution, laid out the plan and business model that aligns with the Business Improvements Objectives. Provided leadership, technology direction and architectural assistance for this BI implementation. The key challenge was to build a model that is fed by both Oracle Apps R11 (Financials) and R12 (eProcurement), iSupplier Portal spanning multiple functional areas and also handle feeds from numerous legacy Financials and Procurement systems

Managed several key BI Projects spanning key business areas, worked with stake holders & business analysts (to gather business requirements, design data model, metadata model), designed data migration, data integration & interface models.

Provided key architectural insight and development assistance across several core business processes, customized / enhanced business model, tuned meta data for better analytics performance etc., Designed and implemented various customizations, such as custom supplier hierarchies, custom code sets, integrating web services based vendor & Product hierarchies, D&B feeds etc. Designed various interfaces to feed external Purchases Orders, Vendor Details, Product Details from various external hubs into the EPM Data Warehouse.

Environment: Oracle Business Intelligence (OBIEE 10.1 / 11g), Oracle BI Apps 7.9 (Financial, Procurement & Spend Analytics), Oracle Apps 11.5/R12, Oracle 11g, Web Services / SOA, SQL Analyzer, Explain Plan, Exp/Imp, SQL*Loader, ERWin.

Accenture / Wellington Investments Investment Analytics

Senior Manager – Business Intelligence 04/10 – 06/11

Developed a Business Intelligence roadmap for this leading investment management firm. Analyzed the key business processes against the vision, goals and strategic objectives, laid out the roadmap and business planning model that aligns the Business Improvements Objectives with the strategic objectives. Provided leadership, technology direction and architectural assistance for this BI implementation.

Several key business processes, in Fixed Income & Equity Trading, such as stock portfolio analytics, transaction analytics, performance, exposure analytics were built.

The analytics solution is implemented using OBIEE 11g and Oracle Data Warehouse. Analyzed the individual business processes, assisted in building the single enterprise data model with conformed dimensions across several key business areas; Developed best practices guide for OBIEE 11g for building the metadata and analytics.

Provided key architectural insight and development assistance across several business intelligence implementations, such as metadata design for business model, tuning meta data for better analytics performance, key decisions around data federation, data persistence etc., weighing in performance, data latency etc.,

Managed several key BI Projects spanning key business areas, worked with stake holders & business analysts (to gather business requirements, design data model, metadata model), designed data migration, data integration & interface models, managed a large DW & BI implementation team along with an off-shore team.

Environment: OBIEE 11g, Oracle 11g, SQL Developer / OEM, SQL Analyzer, Explain Plan, SQL*Plus, Exp/Imp, SQL*Loader, ERWin, Windows 2003.

Sterling Health Insurance, WA Product Profitability Analytics

Senior BI / Data Warehouse Architect 01/10 – 03/10

Developed a Data Warehouse and Technology roadmap for this leading Health & Life Insurance firm. The DW Solutions roadmap comprised of analyzing client’s strategic goals, high level business and analytic needs, Business Improvement Opportunities (BIOs), short term and long term implementation plan from a Top –Down approach. Designed, Modeled and Developed a Profitability Data Mart that consists of General Ledger, Premiums & Claims Systems. The Income, Expenses, Premiums, Claims Transactions were retrieved from several silo systems and loaded into this data mart at the member level grain to calculate the Profitability of the company at various levels – Organization, State, Cost Center, Products & Members. For accurate measures, the Direct and In-Direct Expenses incurred were allocated using over 10 different allocation models, such as by % Agency Sales, by % Revenue etc.

Environment: Informatica 8.6.1 (PowerCenter Designer, Workflow Designer, Workflow Monitor), DB2, DB2 Connect, zConnect, IMS, SQL Server, PL/SQL (Packages, Stored Procedures), SQL Developer / OEM, SQL Analyzer, Explain Plan, SQL*Plus, Exp/Imp, SQL*Loader, ERWin, Windows 2003.

DPSCS-ITCD, Maryland Local Law Enforcement Portal

Senior BI / Data Warehouse Architect 11/08 – 12/09

Local Law Enforcement Portal is a unified and consolidated view of information as an intuitive, user friendly BI Dashboard to share sensitive information in a secure manner across numerous law enforcement agencies.

Instrumental in architecting and implementing the Portal that includes Data loading, Data Federation in real time through DB Links, VPN Tunnel that spanned across flat files, legacy and Relational databases; in developing Data Governance programs to set standards and compliance levels, Risk Management, Security and Quality, involving key Data Stewards and Stakeholders; in designing the BI Layers using OBIEE; in developing & Consuming Web Services using Oracle, Java; in implementing Java JMS Queues.

Lead & mentored the BI Team, instrumental in Data Architecting and Data Modeling several large, high performance Databases and Enterprise Data Warehouses (EDW) to feed a variety of Dashboards. Wrote several data loader, data merging / Compression programs (ETL) using PL/SQL Procedures & Packages & Java to perform full and incremental loads.

Used ODI KMs, Tools, Scenarios, Procedures and Agents to connect to a wide variety of databases such as DB2, Oracle, Flat Files etc., to create Data Stores, Transformations and E-LT based Data loads and automatic scheduling, performance tuning etc; performed interfaces / transformation / E-LT infrastructure best practices review & fine tuning.

Environment: Oracle Business Intelligence (OBIEE 10.1) – BI Server, BI Cluster, BI Publisher, BI Answers, BI Dashboard, Oracle BI Apps 7.9 Oracle BI Apps 7.9 (Procurement & Spend Analytics),DB2, DB2 Connect, zConnect, IMS, SQL Server, PL/SQL,

SilverTide Software, Inc., Financials, Sales & Orders edw

Chief Architect – EDW & Business Intelligence 01/04 – 10/08

Instrumental is designing and architecting the Data Warehouse & Data Marts for the enterprise scale Financials, Online Sales & Order Fulfillment System to generate multi-dimensional business analytics.

Project Management, budget management, Risk Management / Risk mitigation, gathered business requirements, developed high level and detailed Project Plans, prioritizing / Scheduling, mentored, led a 30+ onsite / offshore project team.

Adopted Kimball Lifecycle, Bus Architecture & Dimensional Modeling to create a clean and effective Enterprise Data Warehouse and created high level and detailed Technical Architecture.

Performed OBIEE Administration, BI Server upgrade / migration, designed and created RPDs, Presentation Catalogs, Usage and Login Tracking, Catalog / RPD merging, BI Server Performance tuning using Connection Pool, Cache, Aggregate Tables etc & BI Application deployment in multiple BI Servers and Presentation Servers.

Used OBIEE’s BI Answers, Publisher to create various interactive Sales, Marketing, Order related reports drillable by Region, Time, Product, Volume, Dollar, Customer and built several Data Mining solutions. Reports were provided in several intuitive and visually appealing formats such as Charts, Graphs, Tables, Pivot, PDF. Designed and implemented an interactive Dashboard to launch these enterprise reports based on user privileges.

Used several features of OBIEE such as Initialization Blocks, Session and Repository Variables to track User specific values, Time Series measures, % Change, Image Prompts to implement visual filters etc.

Designed, built, validated high level and detailed Dimensional Model, Facts, Grains with emphasis on a clean and effective Data Warehouse that has conformed Dimensions, Atomic and Aggregate data, facilitates drill down / drill up / drill across queries at the presentation layer. Designed and developed ETL Maps, PL/SQL Transformations to handle SCDs Type 1 & 2, Load Historical and Incremental Data into Facts tables, handle “Late Arriving” Data, and handle Errors etc.

Environment: Oracle Business Intelligence (OBIEE 10.1), Oracle BI Apps 7.9 (Financial & Procurement Analytics), Oracle Data Integrator (ODI 10.1), Oracle Financials 11i, JBOSS, Java J2EE, Servlets, JSP / Web Services.

M A T Systems, Inc., Financials, E-Purchasing & Inventory edw

EDW & Business Intelligence Architect / Partner 01/01 – 12/03

Designed and Developed the Online purchasing and Inventory management system that is based in Java & Oracle. Conducted System analysis to identify and prioritize the BI requirements.

Developed System Scope, high level and detailed Project Plan, Use Cases, identified and tracked Key Result Areas (KRA), performance metrics and tracked ROI, managed, mentored, led a 50+ onsite / offshore project team. Gathered business requirements, outlined priorities, created high level and low level Technical Architecture documents, developed logical, physical, and enterprise Data Models.

Designed the dimensional model and developed several mappings to extract & cleanse data, conduct data profiling / data quality auditing, load dimensions & cubes using external tables and flat files.

Environment: Oracle Financials 10.7 SC, Oracle Discoverer, Java J2EE (JSP, Servlets, Beans).

References: Upon request.

Work Status: US Citizen.

Location: Boston, Massachusetts.

Contact this candidate