Manager Data

G aurav (Ga ry) Agrawal

Enterprise Information Architect / Technical Solutions Director / Sr. Development Manager

954-***-**** *************@*****.***

Executive Summary

• Hands-On Information Architect / Solutions Architect / Development Manager with 15 years

experience.

• MBA (IT) and Bachelor of Science (Computers) degrees.

• Certifications in project management (PMP) and Oracle development (OCP).

• Experience in Energy, Utilities, Supply Chain, Banking / Finance and Insurance sectors.

• Expert at data warehousing, master data management, business intelligence, data quality /

governance

• Expert as architecting high volume billing, CRM, ETRM and other OLTP applications

Education & Certifications

• MBA Degree in Information Technology

• Bachelor of Science Degree in Computers & Electronics

• Project Management Professional (PMP) certification

• Oracle Certified Professional (OCP) Certification

• Oracle E- Business Suite Certification from Oracle Corp.

Skill Set

• Solution Design

G aurav (Ga ry) Agrawal

Enterprise Information Architect / Technical Solutions Director / Sr. Development Manager

954-***-**** *************@*****.***

o Data-warehouses, Business Intelligence, Custom business applications

o Custom CIS & ETRM applications for Energy / Utility companies

o Analysis, planning and customizations for packaged software implementations

• Project & Resource Management

o Certified PMP with experience in Waterfall, Agile and RAD environments.

o Experience managing software development teams of up to 15 members

o Experience supervising SLA driven software support teams

• Development Tools

o DW/BI – Oracle Business Intelligence (OBIEE), Discoverer, Qlikview, BIRT

o ETL - Oracle Warehouse Builder, Informatica, Talend

o Databases - Oracle, MySQL, PostgreSQL

o Languages / Frameworks - PL/SQL, PSQL, PHP, WaveMaker (Java Studio)

o Packaged Solutions - Oracle E-Business Suite, Oracle Customer Care & Billing

o CMS - Wordpress, Joomla.

2007 to P resent Stream Energy, Dallas

TX

Roles: Enterprise Solutions Architect / Software Development Manager

G aurav (Ga ry) Agrawal

Enterprise Information Architect / Technical Solutions Director / Sr. Development Manager

954-***-**** *************@*****.***

Stream Energy is a retailer of energy (Electricity and Gas) in Texas, Georgia, Maryland

and Pennsylvania. Stream was named by McGraw Hil l as the fastest growing company in

t he history of American business, having achieved $1.7 Billion in revenue within its fi rst 3

years of business.

I n 2007, I a rchitected and lead the development of Stream’s E nergy T rade & Risk

M anagement (ETR M) application.

• The ETRM application is used to forecasting customer demand and usage patterns,

record purchase orders and produce reports for reconciliation with suppliers.

• Informatica PowerCenter 8.1 was used to capture customer data from internal

b illing systems, usage data from suppliers' systems, weather data from weather

banks and commodity price data from syndicated data providers.

• The data extracted from various sources was consolidated in a partially normalized

operational data store (ODS) and integrated into a packaged t rade capture solution

called “Allegro”.

• Trade data was also integrated into Oracle E-Business Suite's Payables and General

Ledger modules for financial reporting and reconciliation purposes.

I n 2008, I was promoted and given additional responsibili ty to oversee the design,

development, rollout and support of Stream’s second generation C ustomer I nformation

System (C IS) t hat would facilitate the fi rm’s expansion into the deregulated Natural

G as market within state of Georgia . I served as the primary solution architect and

managed a development team comprised of 10 to 15 members including architects,

developers and DBAs.

• The application used an Oracle 10g database for storage

G aurav (Ga ry) Agrawal

Enterprise Information Architect / Technical Solutions Director / Sr. Development Manager

954-***-**** *************@*****.***

• Batch processes for billing, payments processing etc were developed in PL/SQL

• Web services and data integrations were developed using PHP and Zend Framework

• The User In terface was developed in Flash using Adobe Flex Builder Framework.

• Informatica mapping and workflows were used for data integration with several

vendors and t rading partners including Enrollment Channels, EDI Providers,

Payment Aggregators, Print Vendors and Third Party Quality Control services.

I n 2009, I was promoted for a second t ime and given additional responsibility to oversee

t he operational support of the CIS application serving the Texas Electricity market.

• The Texas CIS system was developed in PHP/MySQL and processes invoices and

payments for around h alf million utility customers each month.

• I implemented A pplication & Process monitoring controls by developing system

components for recording batch execution performance and exception rates. The

performance / failure metrics were t rended and analyzed to develop SLA based

objectives for the operations team.

I n 2010, I t ook on additional responsibili ty to lead the design and development of Stream's

E nterprise Data Warehouse ( EDW) and B usiness I ntelligence p latform.

• Customer, Invoice, Payments, Demand, Supply, Price data was extracted from the

i nternal and external OLTP systems as well as syndicated data sources using

I nformatica PowerCenter

• Transformation logic was built in Informatica and PL/SQL.

• Data was stored in a star schema structure with dimensions for customer, product,

geography, time, load profile etc.

G aurav (Ga ry) Agrawal

Enterprise Information Architect / Technical Solutions Director / Sr. Development Manager

954-***-**** *************@*****.***

• Type 2 slowly changing dimensions were employed to capture changes to customer,

p roduct and price data.

• Several fact tables were implemented to capture enrollments, revenue, cost, demand,

supply and att r i tion metrics over time.

• Data was visualized for various departments using Oracle Publisher for pixel perfect

canned reports, Oracle Discoverer for ad-hoc analysis and QlikView for executive

dashboards.

Additionally, I t ook over the responsibility to oversee the design and development of

S tream’s corporate w ebsites. Stream’s primary websites (www.streamenergy.net and

w ww.igniteinc.com) were redesigned and developed using Wordpress C MS in order to

s treamline publication of web content via self service methods. I also star ted working with

S tream’s S EO/ORM consultants to manage and enhance Stream’s web presence.

I n 2011, I p lanned and lead the enhancement of Stream's M aster Data Management

( MD M) i ni tiatives. Due to multiple OLTP systems being in operation, a centralized system

of record was required for Product and price data. In addition, an approval work-f low

p rocess was required to monitor and control the publication of new products and prices.

• Analyzed and documented an enterprise wide “master product definit ion” in

collaboration with various architects and SMEs.

• Developed a data model to capture products and related att r ibutes along with

references to the various source systems.

• Developed and implemented Conflict resolution rules to handle inconsistencies in

data across systems

G aurav (Ga ry) Agrawal

Enterprise Information Architect / Technical Solutions Director / Sr. Development Manager

954-***-**** *************@*****.***

• Developed a process for management of unresolved conflicts by storing conflict

i nformation in exception tables and a user interface to allow super users to manually

resolve the exceptions.

• A separate “enterprise product management” application was developed using

P HP/MySQL that used an asynchronous subscribe mechanism to capture product

and price data from the EDW. The application allowed executives to securely add /

u pdate product/price data. The added/changed information would then pass through

an approval process and signoff.

• The new/changed product and price data is published out to the various OLTP

systems as well as internal and external websites thus creating a feedback loop

necessary for effective management of master data.

My cur rent portfolio of activities at Stream Energy includes:

• Manage and oversee a software development team comprising of 20 members.

• Guide solution architects and developers to maintain standards and consistency

across platforms and projects.

• Work with enterprise architects to develop a long term technical strategy and

f ramework for application development, integration, security and data governance.

• Lead the design and development of the Enterprise Business Intelligence /

A nalytics / MDM platforms.

• Work with the Program Management Office (PMO) on project proposals, portfolio

management, project management, t ime t racking and process efficiency metrics.

• Work with the IT Infrastructure team to plan the hardware/software footprint for the

organization’s application, storage, security, redundancy, archival, telecom and

d isaster recovery needs.

G aurav (Ga ry) Agrawal

Enterprise Information Architect / Technical Solutions Director / Sr. Development Manager

954-***-**** *************@*****.***

• Work with the CIO and other executives on enterprise strategy and planning

i ncluding business case development, prioritization, enterprise architecture,

resource planning, vendor selection, technology selection, budget planning etc.

G aurav (Ga ry) Agrawal

Enterprise Information Architect / Technical Solutions Director / Sr. Development Manager

954-***-**** *************@*****.***

2005 to 2007 Applica Consumer P roducts I nc.,

F lorida

Roles: Enterprise Data-Warehouse Architect / Business I n telligence Manager

Applica Consumer Products I nc., markets and distributes small household appliances

u nder industry leading brand names such as George Foreman and B lack & Decker. I

worked closely with Applica’s executives, directors and department managers, to develop an

enterprise business intelligence strategy that would provide analytical information for

supply chain / logistics planning of the t iming of shipments from China and to ensure

appropriate warehouse storage space was purchased and allocated efficiently.

• Lead the analysis and subsequent compilation of a list of strategic and tactical KPIs

based on the industry standard Supply Chain Operations Reference (SCOR) Model.

• Lead a team of architects, developers and DBAs to design and develop the EDW/BI

p latform.

• An Oracle 10g database was used to store a star schema structure consisting of

d imensions for customer sites, supplier sites, warehouse sites, shipping ports,

p roducts, sales channels etc.

• Fact tables stored metrics on sales, purchases, shipments etc.

• Oracle Warehouse Builder (OWB) was used for ETL purposes

• Oracle Discoverer was used for reporting and charting.

• Oracle Portal was used for a publication and collaboration platform

• Oracle Identity Management was used for integration with M icrosoft Active

D irectory for Single Sign On functionality.

G aurav (Ga ry) Agrawal

Enterprise Information Architect / Technical Solutions Director / Sr. Development Manager

954-***-**** *************@*****.***

• Additionally, Oracle OLAP server was employed to create analytical workspaces that

were presented via Oracle Discoverer OLAP for ad-hoc analysis by executives.

• The primary source of data was Oracle E-Business Suite with Financials, Order

M anagement, Inventory, Supply Chain, Demand Forecasting and Trade

M anagement modules. Additional Customer and Sales data was captured from

m ultiple t rading partners' point of sale systems to create t rends for demand

forecasting purposes.

• The forecasted demand combined with supply data collected from offshore suppliers

as well as shipping / logistics data collected from shipping agents to create a forecast

of inventory levels and warehouse space required. This allowed for inventory, space

and cash f low optimization.

I n 2006, I was promoted and given additional responsibili ty to spearhead the evaluation of

m ultiple packaged business intelligence solutions for Applica’s analytical and reporting

needs. I lead a team of consultants and business liaisons in performing feature-set

comparisons of a number of BI solutions including Oracle Business Intelligence (OBIEE),

Cognos, Business Objects and MicroStrategy. OBIEE was selected after a successful pilot

p roject conducted in collaboration with Oracle Consulting.

G aurav (Ga ry) Agrawal

Enterprise Information Architect / Technical Solutions Director / Sr. Development Manager

954-***-**** *************@*****.***

April ‘05 to July ’05 Cinergy Corporation, Cincinnati

OH

Roles: Senior Data-Warehouse Architect / Business I ntelligence Consultant

Cinergy Corporation (now part of Duke Energy) is a public utili ty company that provides

electric and gas services in the states of Ohio, Kentucky and Indiana. I was responsible for

redesigning Cinergy’s Enterprise Data Warehouse that consolidates data from i ts Power

and Gas t rading applications. The EDW moves over 400 GB of data per day and was

suffering from acute performance problems. I lead a team of architects and developers to

enhance the ETL performance by:

• Reducing the number of joins performed by queries by increased de-normalization of

t he star schema and consolidation of some dimensions to form junk dimensions

• Using t ransportable table-spaces and part it ion exchange techniques to move data at

t he file system level rather than the database level

• Pin dimensions and frequently used tables to RAM for faster access.

ETL tools employed at this location were Informatica and Oracle Warehouse Builder.

Cognos was used for data presentment.

October ‘04 to M a rch ’05 Bristol West I nsurance, Davie

FL

Roles: Senior Data-Warehouse Architect / Business I ntelligence Consultant

G aurav (Ga ry) Agrawal

Enterprise Information Architect / Technical Solutions Director / Sr. Development Manager

954-***-**** *************@*****.***

Bristol West I nsurance Group (BWIG) is a leading provider of non-standard automobile

i nsurance services. I lead the design and development of an enterprise data-warehouse /

business intelligence platform to capture and report insurance policy, subscriber and claims

data and utilized for data mining purposes to identify statistical relationships between

customer and vehicle att ributes and incident rates.

• Primary data source was an IB M AS/400 based DB2 t ransactions processing system.

A dditional data sources include an Oracle based custom OLTP system and a Lotus

Notes based CRM system.

• The data was captured in a star schema structure stored in an Oracle 10g database.

M ajor dimensions included Customer, Vehicle, Policy, Geography, Product, Agent,

I ncident and Time. Facts included premium receivables and payments, incident

occurrences, claims, settlements and payouts.

• Oracle Warehouse Builder combined with Oracle Heterogeneous ODBC Services was

used for data extraction and load.

June ‘03 to October ’04 Citigroup, Tampa

FL

Roles: Senior Data-Warehouse Architect / Business I ntelligence Consultant

Citigroup, p rincipally through Citibank, is a global provider of financial services.

C itigroup has implemented Oracle’s packaged Embedded Data Warehouse solution (Oracle

E DW) that is part of the Oracle E-Business Suite toolset. I helped design and develop an

E DW that facili tated financial reporting of the payables t ransactions.

• The primary data source was an Oracle Procure To Pay system (Oracle E-Business

Suite 11i AP, PO and GL modules). Additionally, there were several legacy system

feeds from Citigroup’s more than 100 branches and subsidiaries across the globe.

G aurav (Ga ry) Agrawal

Enterprise Information Architect / Technical Solutions Director / Sr. Development Manager

954-***-**** *************@*****.***

• Due to the extremely large data volume, the EDW was refreshed once a month before

t he closing of the financial period. Most major tables were partitioned by month and

business unit for performance and storage optimization purposes.

• Transportable table-spaces and partit ion exchange techniques were employed to

move data from source to staging to presentation databases.

• ETL mappings were developed in Oracle Warehouse Builder and financial reports

were delivered using Oracle Discoverer business areas and reports.

Sept ‘99 to Jun ’03 World Fuel Services, M iami

FL

Roles: Senior Data-Warehouse Architect / Business I ntelligence Consultant

World Fuel Services Corp. (WFS) is the world's largest independent marketer of aviation

and marine fuel products.

2000 to 2003 Oracle Data-warehouse Lead Developer

o Designed and developed a Multi Dimensional Oracle Data Warehouse.

o Developed Oracle Discoverer Business Areas and reports

o The primary source of data was Oracle Financials 11.0.3 (AR, AP and GL).

1999 to 2000 Oracle Applications Lead Developer

o Revived an unsuccessful implementation of Oracle Financials 11.0.3

o Developed over 100 Custom Reports using Reports 2.5 across all modules.

o Developed several Custom Forms using Forms 4.5 across all modules

G aurav (Ga ry) Agrawal

Enterprise Information Architect / Technical Solutions Director / Sr. Development Manager

954-***-**** *************@*****.***

Contact this candidate