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)

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, ActivePERLER 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.

PROFESSIONAL EXPERIENCE:

Confidential

Lead Big Data Architect

Responsibilities:

• 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

Confidential

Lead Architect

Responsibilities:

• 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

Confidential

Lead DW / BI Architect

Responsibilities:

• 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

Confidential

Lead Architect / /BI Infrastructure Upgrades

Responsibilities:

• 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.
• 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.

Confidential

Lead Architect /BI Infrastructure Upgrades

Responsibilities:

• 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.

Confidential

Senior Manager - Business Intelligence

Responsibilities:

• 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.

Confidential, WA

Senior BI / Data Warehouse Architect

Responsibilities:

• 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.