Data Oracle
Resume:
Ashok Sami
(US Citizen)
*********@*****.***
* **********, *******-****** ********** leader, strategist &
architect with 16+ years experience in management and Data warehouse,
combined with 4+ years in the Financial Services industry and 8+ years in
the Energy & Utilities industry. Other accomplishments include, delivering
high impact technology and strategy projects, driving process improvement
and re-engineering initiatives for Booz Allen Hamilton (Clients) and Oracle
Corporation (Clients & Internal).
Professional Skills
Work closely with 'C' level executives to enhance IT capabilities
Excellent communications skills, presentation skills, attention to detail
and commitment to meeting customer expectations.
Proactive achiever who empowers staff and guides teams to top performance.
Respected professional who utilizes operational, technical and people
acumen to solve today's business challenges
Keep in touch with current and emerging technologies to provide the best
solution for clients
Expert in design and creation of Decision Support Systems (DSS), Data
Analysis & Modeling, Budget Forecasting Application, Database Development,
Business Intelligence Modeling & Data Warehouse Architecture Design &
Solutions
Specialized in Business Intelligence Technologies, ETL tools & Data
Warehousing tools
Extensive experience in database administration (Installing, administering,
performance tuning implementing and troubleshooting SQL Server
7/2000/2005/2008, Sybase 15.x and Oracle 8i/9i/10gR2
Experience of managing off-shore team, a team of 40 software engineers
and more than 200 staff
Strong Functional Experience in Finance, Budgeting, Energy, Utilities,
Health Care, Content Management and inventory control management
Technical Skills
Databases: SQL Server, Oracle, Sybase, My SQL
Case Tools: ER Studio, Power Designer, Oracle Designer, Erwin
Data Modeling: Dimensional Data Modeling, Star Join Schema Modeling, Snow
Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data
Modeling, Erwin 3.5.2/3.X & Toad 8.0/9.1
DW tools: SSAS, SSIS, Oracle Warehouse Builder (OWB)
ETL tools: SSAS, SSIS, PL/SQL, T-SQL, SQL*Loader & other customized
programs
BI Reporting tools: Oracle discoverer, Oracle reports, SSRS, JSP
Rules Engine: Blaze Advisor and Provenir
Data Quality: Microsoft Master Data Services (MDS), Microsoft Data Quality
Service (DQS), Data Flux, Oracle Enterprise Data Quality
ERP: Oracle E-Business Suite, Oracle CRM, Oracle 10.7, SAP
Languages/Technologies: C, C++, Perl, Shell scripting, Oracle forms, Java,
J2EE, XML, Web Services, Oracle PL/SQL, T-SQL, VS.NET (C#, VB, ASP)
Professional Experience
VP of Data Services, Thinkfinance - 07/2009 - Present
Thinkcash is an online financial services company, my work involves the
following:
Work with the CIO and CTO to make strategic architecture decisions across
the organization to align business with IT.
Lead the Decision support system design, ETL process, reports and dashboard
design using SSRS, SSIS, and SSAS tools
Incorporated data governance and data quality using Microsoft Master Data
Services (MDS) and Microsoft Data Quality Service (DQS)
Worked with the risk team to architect a custom solution for predictive
modeling based on historical customer data
Architected a data hub which incorporates third party data from multiple
vendors and technology, integrating with the decision engine and SAP
Working on incorporating cloud database from Amazon Web Service (AWS) and
GoGrid as a cost effective option to in-house database servers
Engagement Manager / Associate, Booz Allen Hamilton - 09/2006 - 07/2009
Worked with 'C' level executives of fortune 100 companies on their BI
strategies, data strategies and dash board effectiveness. Here are a few
sample client deliverables:
BI strategy and architecture for spin off (Duke Energy):
Performed comprehensive assessment of the current dashboards and reports
across all departments.
Architected and designed new reports based on the current business strategy
and requirements
Lead the architecture efforts in creating a new data warehouse with
multiple data marts for superior scalability and performance
Formed a program management body (PMO) to oversee and lead the transition.
Developed going forward overall BI Strategy, covering assets, delivery
model, organization, roles, and IT governance
BI architecture evaluation and risk report analysis (BP):
Evaluated existing CRM system, SCADA systems and IT systems to determine
the database collection strategy.
Performed gap analysis and identified potential risks.
Re architected their Data warehouse and BI system with a truly integrated
web dash board with defined user levels and functionalities.
Designed and configured sessions with effective caching and logging
DW Architecture Readiness and Data Governance (Toyota Financial Services):
Performed a complexity analysis of their main frame system to identify best
candidates for migration to a web platform and developed a proof of
concept.
Studied and analyzed their overall corporate data architecture to provide a
new, efficient and single source of truth data model using a federated data
model.
Developed a data governance model to ensure data consistency and integrity
for future developments.
The total savings from architecture readiness and improvement in data
quality was estimated to be $4.8 M and a cost reduction of $6.2 M.
ERP BI Architecture Simplification and IT Governance (BP)
Examined and cataloged the various IT applications, ERP systems (SAP) and
interfaces used within the Fuels Marketing department of their US
operations.
Identified pain points to provide recommendations and road map for
application retirement and consolidation. Provided the new IT governance
model to move forward for efficient management.
Presented a business case to save $2.5 M over a period of 4 years.
IT data center and process strategies (BP):
Provided data center consolidation strategy and modeling for management
efficiency.
Realized one time savings of $12 M and $3 M in operating costs.
Worked with executives in developing new IT processes and mapping.
BI/Data Warehouse Architect & Director, Oracle Corporation / Petroleum
Place Energy Solutions (P2ES) - 02/2000 - 09/2006
Integrated Reporting & Analytics
This is an enterprise wide integrated electronic environment for all
applications. Oracle E-business Suite was used for the functional needs of
Human Resources, Finance's General Ledger System and the Materials
Management system. The Integrated Analytic & Reporting Project provided
enterprise wide strategy for information management.
Responsible for architecture & design analysis
Overlook development of Conceptual and Physical Data Model
Source Transaction data Process Analysis
Creation of custom ETL process
Manager Development & deployment of Oracle OLAP Cubes
Development of Reporting strategies
iReports: I was the chief architect and manager of this DSS project.
Designed the OLAP database to integrate data from Oracle Financials, Oracle
CRM, Oracle Revenue & Production Management. Environment: ERwin, Oracle 9i,
Oracle Forms, OWB, Oracle Reports, PL/SQL, Oracle Discoverer, XML, HTML,
Java, JSP.
Production Management DW: I acted as the data architect for this huge
datawarehouse project. The database contains information about wells,
facilities, completions, allocations etc. The main challenge we faced here
is the sheer amount of data to be dealt with. Environment: ERWin, Oracle
9i, Oracle Discoverer, PL/SQL, XML, Shell Scripting.
Principal Consultant, Oracle Corporation (01/1998 - 02/2000)
As a managing principal consultant with Oracle Corporation I managed
and lead multiple projects for fortune 500 companies in different
environments.
Lead a thirteen-member team to convert Sybase to Oracle data warehouse
Lead a sixteen-member team to convert Sybase to Oracle database
Clients: Kaiser Permanente, GE Capital, Phillips 66, Pfizer
Other:
Database Administrator, Transamerica Life (05/1996 - 12/1998)
Sr. Software Engineer, Workers Compensation Board (06/1995 - 05/1996)
Montana State University (06/1993 - 06/1995)
Railways Information Systems, India. (05/1991 - 01/1993)
1 Education
Master of Science, Electrical Engineering, Montana State University, 1995
Bachelor of Engineering, ECE, Tamil Nadu College of Engineering, 1991
Contact this candidate