RESUME
OF
Shibu
OBJECTIVE
Seeking a challenging position as Data Warehouse/Data Architect that will capitalize on my
acquired expertise, creative talents and commitment to excellence and a quality environment
where my knowledge and experience can be shared and enriched.
SUMMARY
Over 9 years of progressive work experience in Information Technology industry with
background of increasingly responsible positions in business analysis, data architecture,
solution architecture, software design and software programming.
Innovative and technically competent professional with a strong background in analysis, design
and development of software applications using Unix, Oracle, PERL, J2EE Technologies,
Developer/2000, Designer/2000, Siebel Analytics and Business Objects tools.
Expertise in creating Data Warehouse applications for data extraction, transformation and
loading in a complex, high-volume environment using Ab initio ETL tools.
Highly skilled in the design and deployment of enterprise-wide technology solutions in areas like
Banking, Finance, Sales and Inventory management. Experienced in troubleshooting and
resolving software issues.
Exceptional analytical, multi-tasking, technical, administrative, problem solving and leadership
skills.
EDUCATION
Master of Computer Applications degree, Sardar Patel University, India 1996
Bachelor of Science degree, Electronics, Sardar Patel University, India 1993
DATES OF EMPLOYMENT
10/01 - Present Leading MNC
NC
02/01 - 10/01 APAR Infotech Corporation
Canonsburg, PA
03/00 - 02/01 Mascot Systems Ltd.
Pittsburgh, PA
09/98 - 03/00 Mahindra British Telecom Ltd.
Pune, India
08/96 - 08/98 DDE ORG Systems Ltd.
Baroda, India
COMPUTER SKILLS
OPERATING SYSTEM
UNIX Solaris, HP-UX, SCO, Windows NT/2000
PROGRAMMING
C, Pro*C, PERL, CGI, HTML, Korn Shell Scripts, Java, Applets,
Servlets, XML, SQL, JavaScript, PL/SQL, HTML, JDBC, JSP,
Perl/CGI
DATABASE
ORACLE 6.0/7.x/8.0/8i/9i
DESIGN TOOLS
ER win(3.0), Designer/2000 (v2.1), Rational Rose
CRM
Clarify (6.0)
APPLICATION
DEVELOPMENT TOOLS
Forms 9i, Developer/2000, PL/SQL, SQL*Plus, SQL*Loader
APPLICATION SERVER
Apache server, Borland Enterprise Server, WebLogic 8.1
ETL Tools
Abinitio (GDE 1.11.11/1.10.9.3/1.7.3, Co>Operating System
2.11/2.10/2.7), Oracle warehouse builder 9.2
BI Tools
Business Objects 5.1.X, Siebel Analytics 7.7,
Oracle*Reports2.5
Utilities
PVCS, CVS, TOAD, Visio, Apps*Integrity, Dollar Universe,
AutoSys Schedulers
Project Management Tools
MS Project 2002, MS Office 2003, EmPower
WORK EXPERIENCE
Role: Data Architect
12/04 - 05/05
Working with the Sales IT group of the organization on the
following projects:Sales Credit enrichment Project - Sales IT
(12/04 - 05/05) Sales Credit Assignment tool is a critical sub-
process within the commission's process. SCA determines
ownership and level of compensation for each order transaction
entered through order entry or channels process. A Large
percentage of transactions fail automation globally due to
incorrect or missing customer reference data. This results in the
Sales Force spending significant amounts of their time claiming
transactions for sales credits, which takes them away from their
primary Selling role. The aim of this project is to address
problems caused by Reference data to the SCA process.
Responsibilities as Data Architect includes:
* Detailed business requirements gathering and Use Case
Analysis
* Translate business-reporting requirements into data
warehouse architectural designs and analyzing source
and target data models and makes necessary changes
* Analyze and design the Data Marts, Dimensions and Fact
tables.
* Designed measures for OLAP models and Implemented
Star Schema methodology to organize the data in the
Warehouse database
* Responsible for the Application Development with a team
of 10 developers On-Site and Off Shore
* Process Change Management using PVCS and
Apps*Integrity
* Design of the metrics comparisons in Siebel analytics
* Technical Standards and Quality Management
* Weekly Status Reporting to the solution/engineering
management teams
* Readiness Review, deployment and post deployment
support activities.
Role: Tech Lead
05/03 - 11/03
Project Disti - POS company leverages the
Distribution Business to outsource its ordering process to channels
resellers. The orders processed by distributors that get
transmitted to org as Point of Sale (POS) data. POS has a lot
of implications to organization. The data is as critical as ERP orders for
the enterprise. However, due to the nature of origin for POS data
there are a few differences in the way processes work.
POS is focusing to address the issues around special
discount/pricing on channels orders and how we recognize revenue
and commission the sales force. Virtual Claiming, Serial Number
Validations, Reseller/End User Validations, Claim Validation
are some of components of this project. The responsibilities as
Project. Lead include
* Detailed business requirements gathering and Use Case
Analysis
* Develop Detailed Project Plan using MS-Project
* Compose Project Team, assessing skills and team sizes
across different phases of the Project for successful
completion of the project
* Develop design specifications using ERWin and Rational
tools.
* Translate business-reporting requirements into data
warehouse architectural designs and analyzing source
and target data models and makes necessary changes
* Analyze and design the Data Marts, Dimensions and Fact
tables.
* Designed measures for OLAP models and Implemented
Star Schema methodology to organize the data in the
Warehouse database
* Responsible for the Application Development with a team
of 10 developers On-Site and Off Shore
* Development of ETL to extract data from different
distribution submission methods
* Developed an executive dashboard for the sales analyst
and executives for data comparisons and bookings
analysis in Siebel Analytics
* Process Change Management using PVCS and
Apps*Integrity
* Technical Standards and Quality Management
* Weekly Status Reporting to the solution/engineering
management teams
* Co-ordinate with DBA, SysAdmin, Foundation and
Infrastructure group.
* Code Reviews
* Application Support and Maintenance
* Project closure activites
Role: Technical Lead
09/02 - 04/03
acquistion Integration With the acquisition by organization
Systems there is requirement to have a visibility into the total
amount of business that our Distributors are doing with organization.
That includes both the standard company POS information, as well
as the new POS data. This enhancement was to capture and
validate the point-of-sale and Inventory information from
distributors related to sales world wide. The
responsibilities as Tech. Lead include:
* Detailed business requirements gathering and Use Case
Analysis
* Develop Detailed Project Plan using MS-Project
* Compose Project Team, assessing skills and team sizes
across different phases of the Project for successful
completion of the project
* Developed design specifications using ERWin.
* Translate business-reporting requirements into data
warehouse architectural designs and analyzing source
and target data models and makes necessary changes
* Analyze and design the Data Marts, Dimensions and Fact
tables.
* Designed measures for OLAP models and Implemented
Star Schema methodology to organize the data in the
Warehouse database
* Responsible for the Application Development with a team
of 6 developers On-Site and Off Shore
* Development of ETL to extract data from different
distribution submission methods.
* Process Change Management using PVCS and
Apps*Integrity
* Technical Standards and Quality Management
* Weekly Status Reporting to the solution/engineering
management teams
* Co-ordinate with DBA, SysAdmin, Foundation and
Infrastructure group.
* Code Reviews
* Application Support and Maintenance
* Project closure activites
Role: Technical Lead
02/02 - 08/02
Credit Automation The credit tool application was
developed to provide a central Home Page from which the
distributors can extract processed POS data, submit claim files,
check claim status, and download submission
templates. Responsibilities include development, maintenance
and enhancement of application and supporting worldwide credit tool
users. Also involved in:
* Detailed business requirements gathering and Use Case
Analysis using Rational tools
* Develop Detailed Project Plan using MS-Project
* Compose Project Team, assessing skills and team sizes
across different phases of the Project for successful
completion of the project
* Develop design specifications using Designer/2000.
* Translate business-reporting requirements into data
warehouse architectural designs and analyzing source
and target data models and makes necessary changes
* Analyze and design the Data Marts, Dimensions and Fact
tables.
* Designed measures for OLAP models and Implemented
Star Schema methodology to organize the data in the
Warehouse database
* Responsible for the Application Development with a team
of 10 developers On-Site and Off Shore
* Development of ETL to extract data from different
distribution submission methods.
* Changing the DB schema as per the new interface
* Developing the Perl/CGI scripts for the Audit Checks
* Writing stored procedures, packages and triggers for
handling the the new enhancements
* Writing test cases for Testing of the credit tool Phase 3 release
* Application tunning of validation, claim maintenance,
Partner interface for better performance
* Supporting the End-Users with the day to day issues
Role: Technical Lead
10/01 - 01/02
POS Standardization The credit tool application was
developed to provide a central Home Page from which the
distributors can extract processed POS data, submit claim files,
check claim status, and download submission
templates. Responsibilities include development, maintenance
and enhancement of application and supporting worldwide credit tool
users. Also involved in:
* Detailed business requirements gathering and Use Case
Analysis using Rational tools
* Develop Detailed Project Plan using MS-Project
* Compose Project Team, assessing skills and team sizes
across different phases of the Project for successful
completion of the project
* Develop design specifications using Designer/2000.
* Translate business-reporting requirements into data
warehouse architectural designs and analyzing source
and target data models and makes necessary changes
* Analyze and design the Data Marts, Dimensions and Fact
tables.
* Designed measures for OLAP models and Implemented
Star Schema methodology to organize the data in the
Warehouse database
* Responsible for the Application Development with a team
of 10 developers On-Site and Off Shore
* Development of ETL to extract data from different
distribution submission methods using Informatica
PowerCenter.
* Changing the DB schema as per the new interface
* Developing the Perl/CGI scripts for the Audit Checks
* Writing stored procedures, packages and triggers for
handling the the new enhancements
* Writing test cases for Testing of the credit tool Phase 3 release
* Application tunning of autovalidation, claim maintenance,
Partner interface for better performance
Supporting the End-Users with the day to day issues
Technologies
Oracle (8i), PERL, CGI, HTML, PL/SQL, Unix Shell script,
BusinessObjects, Ab initio, JAVA, JavaScript, JSP, JDBC,
Servlets/Applets, XML, HTML, Developer/2000, Designer/2000,
Apache server, Borland Enterprise Server, WebLogic 8.1
APAR INFOTECH CORPORATION
Programmer Analyst
02/01 - 10/01
Under H-1B visa, assigned to the following projects to provide
computer software services:
Goal Processing System;
NC State (02/01 - 10/01) Primarily responsible
for interface of the system with other applications like sales
hierarchy, manager access and HR systems. Also responsible for
the following activities:
* Writing the technical specifications for the interface of
GPS with other systems like Sales hierarchy, manager
access and HR systems
* Changing the DB schema as per the new interface
* Modifying the Perl/CGI scripts according to the new
interface
* Writing stored procedures, packages and triggers for
handling the data interface with other applications
* Writing test cases for Testing of the interface
* Executing the test cases
* Modifying the newt reports as per the new requirements
* Modifying the Perl/CGI scripts as per the new
enhancements
* Supporting the End-Users with the day to day issues
Technologies
Oracle (8.0), PERL, CGI, HTML, PL/SQL, Unix Shell script,
BusinessObjects, JAVA, JavaScript, JDBC, Servlets/Applets,
HTML, Developer/2000, Designer/2000, Apache server, Borland
Enterprise Server, WebLogic 8.1, SQL*Loader
MASCOT SYSTEMS LTD
Software Engineer
03/00 - 02/01
Under H-1B visa, assigned to the following projects to provide
computer software services:
Remote Monitoring and Diagnostics System; GE
Transportation Systems, Erie, PA State (03/00 - 02/01)
Primarily responsible for customization of CRM. Also responsible
for the following activities:
* Worked with modules ClearSupport, Policies and
Customers, Product Manager
* CB programming to add new functionality in GUI,
workflow, business rule, data migration, and data
manipulation.
* Involved in Schema changes and customized several
existing Forms apart from developing new ones.
* Developed Crystal Reports and implemented the reports
in the Clarify application using Clear Basic code using the
ActiveX control
* Writing stored procedures, packages and triggers for
handling database transactions from the front-end
* Developed a user interface to access the download files
for the respective customers using PRO*C, PL/SQL,
HTML and PERL script.
* Enhancement of the Decoder module to incorporate new
functionality using PRO*C
Technologies
Oracle (7.3), Clarify src6, PL/SQL, PRO*C, PERL, Unix Shell
script, HTML
MAHINDRA BRITISH TELECOM LTD.
Software Engineer
09/98 - 03/00
Assigned to the following projects to provide computer software
services:
Automated Plant Information System APIS; Zubair
Automobiles LLC, Muscat, Sultanate of Oman (09/98 - 03/00)
Primarily responsible for design and development of workshop
Information system for the APIS project. Specific duties included:
* Analysis of User Requirements and Requirement
Definition Document preparation
* Design and development of the Prototype and
presentation to Client.
* System Design and Development which involves logical
and physical database design, preparing program
specifications
* Coding of the base form which is to be used as the
standard across the system
* Creation of Entity Relationship Diagram using
Designer/2000
* Creation of Functional Hierarchy Diagram using
Designer/2000
* Generation of DDL scripts using Designer tool
* Writing stored procedures, packages and triggers for
handling database transactions from the front-end
* Creation of Job Scheduler for the end of day processing
* Creating the libraries for workshop subsystem
* Development of the workshop menu using menu modular
* Coding of critical transaction forms using forms5.0
* Coding of reports using reports3.0
* Quality Checking like code walkthroughs
* Testing of release package
* Acceptance of the module at Client site (Oman)
* User Training
Technologies
Oracle (7.3), Designer/2000, Developer/2000, Unix Script,
PL/SQL, SQL*Loader
DDE ORG Systems LTD.
Software Engineer
02/98 - 08/98
Assigned to the following project to provide computer software
services:
Integrated Bank Automation System IBAS; Sikkim Bank Ltd.,
Siliguri, India (02/98 - 08/98) Primarily responsible for the
implementation of the package. This includes following activities:
* Installation of SCO operating system on Pentium server
* Installation of Oracle RDBMS and application packages
on SCO platform
* Creation of the database, including database objects like
redo log files, data files, control files and rollback
segments
* Tuning and optimization of the database for better
performance
* Developed and implemented proper backup and recovery
strategies
* Trouble shooting of Unix, Oracle and application software
* Customization of the Application software as per
customer requirement
* Providing training to Customer on Unix, Oracle and
Application Software
Software Engineer
08/96- 01/98
Integrated Bank Automation System IBAS; Punjab and Sindh
Bank Ltd., Delhi, India (08/96 - 01/98) Primarily responsible for
design and development of few of the modules like Savings
Bank, Inward and Outward Bills, Bank Guarantee and Clearing
House Operations. Specific duties included:
* Analysis, Screen Design and Validations of the said
modules
* Preparation of DFD and ER Diagram
* Design which involves Database Design, Program
Specification
* Coding of reusable codes which involves database
triggers, procedures, functions and packages
* Development of the menu using Pro*C
* Coding of the day end activities using Unix Shell scripts
* Creation of transaction and master forms
* Coding of daily and adhoc Reports
* Preparation of Test Plans for Unit and Module testing
* Testing as per Test plans and revision of Test plans
* Porting of the Application to different Platforms
* Enhancement of the S/w as per Customer Requirements
Technologies
Oracle (7.1), Forms 3.0, Reports 1.1, PL/SQL, Pro*C, Unix
Shells, SQL*Loader
Training/Certifications
--> Associate Certification in Project Management (George Washington University)
--> J2EE Training (Learning Patterns)
--> XML & Java Training (Learning Patterns)
--> Siebel Analytics 7.7 (Siebel University)
REFERENCE
References can be provided upon request
|