Post Job Free

Resume

Sign in

Data warehouse Manager

Location:
Lewisville, TX
Posted:
June 21, 2017

Contact this candidate

Resume:

Shridharan Pattabhiramon (Shri) Mobile: 972-***-****

Email: ac0xv2@r.postjobfree.com

Professional Synopsis

Energy and Commodity Trading – Utilities – Retail Energy – Health Care – Mortgage - Retail

20+ years’ strong result-oriented information management professional in designing and implementing technical and strategic solutions

Exposure to Energy, Finance, Insurance, HealthCare and Marketing applications along with experience in designing solutions to extract data from wide variety of source system

Sound energy industry experience focusing on Trading, Risk Management, Utilities & Retail

Worked on projects including ETRM implementation, trading and risk data management, business process improvements, regulatory reporting, and change management efforts

Experienced in establishing strategic direction & delivering targeted and successful business solutions

Primary efforts focused on Architecting, designing, building, testing, and deploying business intelligence, decision support, and data warehouse solutions

Experience in designing solutions to extract data from wide variety of source system including SAP, Main Frame, ETRM’s, Flat files, COBOL Files, Oracle, SQL Server, XML Files etc.

Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Dimensional Models using Star schema and Snowflake schema used in relational, dimensional and multidimensional modeling. Physical and logical data modeling using ERWIN 7.0.

A Team Player with excellent leadership, analytical, organizational and communication skills.

Professional Experience

TechAnalytics Solutions Provider, Inc. Sept 2014 –Till Date

Freelancing with a product development company that provides energy, utility, and commodity trading organizations a holistic, cross commodity, business analytic, information management, data management, data integration, and master and metadata management platform. The Platform is an out of box solution to power a 360-degree view of any Energy clients’ business across the front, mid and back office.

The ETL and BI portion of the product is developed with Oracle 12c/ODI/OBIEE/Tableau/R/Hadoop/HBase.

There is an equivalent Microsoft Stack too with SSIS/SSRS/Tableau/R.

Sungard Consulting Services Apr 2010 – Aug 2014

$5 billion privately-held global business and information technology consulting firm specializing in project management, enterprise integration, custom development, and business intelligence

Senior Manager

Deliver large, complex, long-term engagements around energy technologies specific to energy trading, generation, wholesale, Utilities and retail electricity. Projects averaged $3 million over 2-3 years with teams of up to 15 people. Also, significantly contributed towards the Pre-sales and sales effort of multiple projects. Clients include public utilities, major oil and gas companies and Independent system operators.

Duke Energy – Data Integration Architect - Roadmap on IM Initiative in Trading Information

Duke Energy is considering revamping its business intelligence (BI), information management (IM) and reporting solutions to provide a collated, cohesive and coherent view of various business critical information solutions (e.g. position reporting, P&L reporting, risk analysis, performance management, portfolio management, trend analysis, risk management, profitability analysis, cash flow forecasting and variance analysis, gross margin analysis, etc.) to its business, by leveraging and/or consolidating data from disparate systems into an enterprise coherent view that represents the business model.

As part of the initiative, we did an eight (10) week Trading Information Management Master Plan exercise in conjunction with key business and IT personnel from Duke Energy. This plan comprised of a series of strategy sessions with IT SMEs and business management, followed by detailed benefits and gap analysis workshops with key SMEs from the relevant business groups in Charlotte (Regulated businesses) and Cincinnati (Unregulated businesses).

The Master Plan included: A business-prioritized phased implementation plan and roadmap; Project Plans and Cost Forecasts for each phase; Future State Environment Design

Oncor Electric Delivery – Data Integration Architect - Transmission Data Mart

The Oncor Transmission and Distribution Planning groups had a business need to report against historical data contained within various existing Oncor applications for business and operational analytics.

Activities undertook to ease their on-going issue:

»Single Repository – Consolidate Transmission related data from multiple Oncor Source systems into the Enterprise data warehouse

»Business Reporting – Provide Transmission group the ability to run canned/ad-hoc reports for business and operational analytics

»Strategic Alignment – House all current and historical data within the Enterprise Data Warehouse to align with Oncor IT Data Management strategy.

PPL EnergyPlus – Data Integration Architect – FTBO(Front-to-Back-Office) Project

PPL Corporations’s EnergyPlus subsidiary is a leading supplier of competitively priced electricity and energy services in the mid-Atlantic region, and sells wholesale and retail electricity in key U.S. states. It uses SunGard’s Aligne (formerly Zai*Net) energy trading & risk management platform.

Decision Support System

»Assigned to PPL for ZaiNet Reimplementation, DSS (P&L Data Warehouse) and BI Reporting Project.

»Led the design and development efforts for the decision support system initiative.

»Designed and developed various ETL process to capture data elements for trading and risk management system and assisted in integration with various Audit, Balance & Control

»Translated accepted Industry and Market procedures into technical rules to drive allocations process.

»Maintained integration and consistency with respect to database and Informatica architectures.

»Involved in setting up Microstrategy, Architecting and developing Reports/Cubes.

»Technology utilized within this project consists of Oracle 10g, SQL Server, Informatica, Microstrategy, SSIS/SSRS, Zainet, FuelWorx, LMP and Power ISO market systems.

JPMChase-Home Lending, Irving TX – Data warehousing System Jan 2009 –Mar 2010

Lead ETL Consultant

JPMChase Home Lending division helps families achieve and sustain homeownership. In 2008, through Chase and WaMu brands, they originated more than $290 billion in residential mortgages and home equity lending

The Business Intelligence system at JPMChase is designed to provide management with analytical information for decision making on the Loss Mitigation / Collection & Default information of various Loans.

Responsibilities:

Review Business user requirements and identify the best dimensional data model for each data extract

Architect, Design, Develop and integrate their business requirements to PL/SQL and Informatica mapping. Help the team in capturing data into the Meta Data Management.

Act as liaison between Business user, Data Architect and the Development Team.

Design and Develop the Shared usage and error exception handling across multiple business streams

Streamline Re-usable components and single point of Business Layer.

Implementation, Documentation & User Training.

Environment: Informatica PowerCenter 8.6.1, UNIX, Oracle 11G, SQL Server, SSIS/SSRS, SQL*Plus, Mortgage Tools.

HealthMarkets, Dallas TX – Data warehousing System Jun 2006 –Dec 2008

Lead ETL Consultant

The Business Intelligence system at HealthMarkets is designed to provide management with analytical information for decision making.

Responsibilities:

Review customer requirements and identify source systems for each data extract

Design ETL to load legacy mainframe data using Detail Listener, transactional OLTP data and historical data from SQL Server/Oracle databases into the Source tables

Use customer approved transform logic to populate Fact and Aggregate tables

Write Adhoc Oracle PL/SQL scripts to process historical data

Provide metadata definition for all Data elements.

Use Informatica scheduler to automate various process

Interact with Hyperion/Microstrategy Reporting team to ensure the integrity of the reported data

Upgrade Informatica Power Center from version 7.1.2 to Version 8.1

Managed all ETL architecture related work for Informatica

Provide consolidated estimates for the development effort to Project management

Establish ETL coding standards, use of dynamic parameters and accepted error handling techniques

Piloted Data Quality initiatives using Trillium Software

Assist with DW User problem resolution, data analyze, track and debug data issues

Environment: Informatica PowerCenter 7.x,8.x, Detail Listener 5.x, UNIX, Oracle 10G, SQL Server,Hyperion

Sodexho, Buffalo NY– Data warehousing System Aug 2000 – May 2006

ETL Lead /Data Architect

Sodexho is the leading food and facilities management Services Company in North America. The business intelligence system designed to provide downstream management with financial and performance statistics to aid with day to day decision making.

Responsibilities:

Lead Data Architect for the design, development and deployment of an enterprise data warehouse

Interact with SAP team to provide the appropriate upstream

Created mappings to move Financial Data from SAP, Transactional Data from OLTP, EDI data through Flat files, Legacy data from COBOL Files, Historical Data from Oracle Database into the Data Warehouse Source Table.

Developed standard and re-usable ETL code using various transformations

Upgrade Informatica Power Center from version 6.1 to version 7.1.

Developed SQL and PL/SQL codes through procedures, functions, and packages to implement the business logics in an Oracle database

Developed pre/post UNIX shell script to automate and execute jobs using Autosys Scheduler.

Created ETL technical design documentation, Unit Test plans and release notes.

Managed software releases by migrating mappings across various repositories.

Environment: Informatica PowerCenter 6.x, 7.x, UNIX, Windows XP, Oracle 9i, SQL*Plus, TOAD, Autosys.

Bluechip Computer Private Limited, India Mar 1998 – Jul 2000

OLAP Support Desk at Hindustan Unilever Limited – Team Lead

Environment: Oracle, Oracle Express, Progress and Digital Unix

Hindustan Unilever Limited, India Dec 1994 - Feb 1998

Project – Unit-wise Financial Accounting & Consolidation - Developer

Environment: SQL Server, OFA (Oracle Financial Analyzer), MFG/Pro (Progress 6.3)

Professional Training

“Informatica PowerCenter 6 - Level II Developer with new features” By Informatica.

“Data Warehouse Lifecycle in Depth (DWLD)” By Kimball University.

“Leadership Training for Managers” By Dale Carnegie

“Analyzing Requirements and Defining Microsoft .NET Solution Architectures” by HP

“Developing Microsoft .NET Applications for Windows” by HP

EMI – Energy Trading and Risk Management

EMI – Futures, Options and Derivatives

Educational & Technical Qualifications

M.C.A (Masters in Computer Application) - Bharathidasan University, India

B.Sc. (Computer Science) - Bharathidasan University, Bishop Heber College, India

Higher Diploma in Software Engineering - APTECH, India

Professional Skills

ETL - Informatica Power Center 9.x/8.6.1/7.1/6.2/5.1,

Power Exchange - Detail Listener, SAP/R3,XML

ODI, SSIS

OLAP Tools - Brio, Micro strategy, Hyperion IR, Cognos, OBIEE, Tableau

Scheduling Tools - Autosys, Informatica Scheduler, Crontab

ERP / Financial Packages - SAP, MFG/PRO 7.4i

ETRM - Align, CXL, Maximo

Languages - PL/SQL, COBOL, PROGRESS 4GL, .NET

Operating System - UNIX (SCO/Digital/AIX), Windows

RDBMS - Oracle 9i/10G/11G, SQL Server, PROGRESS 4GL

Scripting Language/Web - VB Script, Progress WebSpeed, ASP



Contact this candidate