Summary




Senior information systems professional with 19 years of experience spanned over various aspects of application architecture, design and development experience in diverse development environments and business verticals, especially in the area of Data Warehousing and Business Intelligence over the past 12 years
Performed various roles in DW and BI in building large data warehouses both in terms of entities and volume
Ability to think out of the box in identifying tool sets and process changes to improve productivity in all aspects of software development.
Demonstrated ability to strategize and lead changes successfully
Lead, inspire and motivate teams to exceed expectations
Having a good analytical approach in solving business problems, blending business process with a good technical experience
Demonstrated ability to communicate with all levels of organization
Good team player and has the ability to work independently


Achievements

Code Generator for Data Stage ETL Transformations
SOA Application to enhance Project Governance
Scheduler Enhancement
Data Quality Tool to enable early problem detection
Metadata Management tool to enforce standardization across various databases
Automated the process of conversion from IDMS to DB2 on MainFrames
Developed Code generator in Unix using Cobol and Unix Shell scripts

Shivakumar Gopalakrishnan
Page 4 of 4
Shivakumar Gopalakrishnan
Bangalore , India
91 - 99 - 4515 - 8589


Employment

February, 2007 -  Present
Dy . General Manager

May, 2007 -  June, 2007

October, 2007 -  November, 2007
Pre-sales Support

September, 2008 -  November, 2008

November, 2001 -  December, 2006
Senior Data Warehouse Designer

June, 1998 -  April, 2001
Data Administrator

January, 1998 -  May, 1998
Data Warehouse Consultant

June, 1992 -  December, 1997
Software Specialist

December, 1989 -  May, 1992
EDP Manager

Excellent Performance Award UNIX/COBOL Consultant Telecom Service Software

February, 2007 -  Present
Dy General Manager

Initiate and manage efforts on Knowledge Management
Reusable Components to improve Project Development Productivity and Quality
SOA applications for Project Governance
Metadata Magement
Contribute to various pre-sales efforts
In responding to RFP/RFI
Creation of Service offerings targeting telecom domain
Panel member of the Teradata Competency Team
Lead churning Reusable Components in the unit

Lead IP related activities in the unit and coordinate the efforts with the core team.
Estimations Conclave 2008
Publish and Present a paper on Data Warehouse Estimations
Publish a paper on Need for Actual Metrics

February, 2009 -  Present
Pre-Sales support

Provide consulting support to the pre-sales team for the RFP defense
Prepare Technical Solution
Collate supporting artifacts to be submitted with the RFP process
Create a resourcing model to estimate the financial aspect of the RFP

August, 2008 -  October, 2008
Project Manager

Manage and Architect. GAP Analysis effort for TESCO

Complexity involved in analysing 3000 JCL's and 7000 Teradata Scripts to extract metadata information mapping Applications to Source and Target Tables

Design the perl scripts to analyse the JCL, obtain the Teradata Scripts and read the scripts to parse the SQL statements to get the Source and Target information

October, 2007 -  November, 2007
Pre-Sales support

Provide consulting support to the pre-sales team for the RFP defense
Prepare Technical Solution
Collate supporting artifacts to be submitted with the RFP process
Create a resourcing model to estimate the financial aspect of the RFP

May, 2007 -  June, 2007
Consultant

Provide consulting experience in estimating the 2nd phase of Transformation Program
Create an estimation model which is reused in the subsequent phases
Complexity in estimation involved
Sizing 3 times the 1st phase
Timing 2nd phase to start before end of 1st phase
Budget Constraints
Provide Customer with various options to phase the project as per budget constraints

November, 2001 -  December, 2006
Senior Data Warehouse Designer

Lead a group of designers in designing the Data Warehouse for Orange, The Netherlands.
Formulate the Technical Architecture and Road Map for the Data Warehouse.
Establish standards and guidelines to improve the efficiency of the Data Warehouse Team.
Lead the effort in improving the performance of the interfaces with various source systems.
Lead the effort in identifying the Data Quality issues in the Data Warehouse.
Automated the process of configuring the scheduling tool to incorporate new modules.
Lead the effort of building a Customer Central Data Mart at the Orange Group Level.
Technology Used : Oracle, Power Center, Power Designer, Business Objects.

June, 1998 -  May, 2001
Data Administrator

Performed the role of Data Administrator for the Enterprise Data Warehouse of Agere Systems formerly Lucent Technologies Microelectronics Division, USA
Maintain the Data Model for the Enterprise Data Warehouse.
Collect and Publish the Metadata information to the user community.
Perform the role of a JAD facilitator for various groups.
Designed a Business Objects universe on the Designer/2000 repository to help in reporting the Metadata.
Implemented a bridge to update the Metadata information in Business Objects from the Data Model.
Developed an Access database to help in verifying the consistency of elements across various environments.
Technology Used : ERWin, Designer/2000, Business Objects, Oracle, Teradata.

January, 1998 -  February, 1998
Data Warehouse Consultant

Data model the Sales Data Warehouse to aid in Campaign Management and monitor the performance of various franchises for 1 - 800 Flowers, USA designed the interface from the source systems to the Data Warehouse and reporting.
Performed an independent role in the project.
Technology Used : Designer/2000, Discoverer, Oracle.

August, 1996 -  October, 1997
Data Warehouse Consultant

Designed, Developed and implemented the Financial Data Warehouse for General Electric-Aircraft Engines, USA

Involved in Training users to use the Data Warehouse.
Lead the effort in the development of Standard Reports from the Data Warehouse.
Performed independently in the successful implementation of the project.
Technology used : Oracle, ERWin, IQ, Smart Database.

May, 1994 -  May, 1996
Mainframe/COBOL Consultant

Maintain and improve the performance of IMPACT manufacturing system for General Electric-Aircraft Engines, USA
Implemented the entire manufacturing system in OS/2 using COBOL/2 and DB2/2 to reduce mainframe costs during development.
Designed various modules to reduce the cost.
Designed automated modules to convert reports from IDMS to DB2 with minimal manual intervention.

Redesigned to improve the performance of the LU 6.2 communication module which interacted with various other IDMS Systems.
Technology Used : COBOL, MVS-JCL, CICS, IDMS, DB2.

June, 1992 -  April, 1994
UNIX/COBOL Consultant

Maintain and improve the performance for Service*Plus S*Plus used by telecom companies all over the world, for Duck William Smith and Associates DWS and A, USA
Leader for a group of 7 consultants.
Wrote a code generator using COBOL and UNIX Utilities to improve productivity and increase the quality of deliverables in the project.

Performed the role of a consultant for another group in the organization which was responsible for converting the entire project to Progress.
Awarded for Excellent performance during the project.
Technology Used : COBOL, SCO-UNIX, Progress.

December, 1989 -  May, 1992
EDP Manager

Managed a group of 14 personnel.
Handled and implemented projects to improve productivity.
Lead a project to improve client handling and billing.
Technology Used : FoxPro.

Education