Peningo Systems, Inc.
OVERVIEW: My Skill sets includes over 7 years of exhaustive experience Designing and Implementing databases from ASP model to Web based Demand Driven Analytical Enterprise Software, which is totally Meta-Data driven. Besides designing large-scale relational databases, my expertise is also in Designing Multi-Dimensional OLAP Cubes in Hyperion Essbase. Have also used ETL tools such as Informatica PowerCenter and Datastage from Assential Software (former Informix).
Position: Software Engineer IV
Designed the National Ignition Facility (NIF) data warehouse,
comprising of Optics related scientific data, which is gathered when the laser
shots are fired. Collected measurements such as optic fluence, density, etc. as
· Also designed and implemented a manufacturing data mart aimed at supporting Optics Production Control and Material Requirements.
· Extracted data from ERP systems like GLOVIA, Excel, Flat files, MS Access on UNIX operating systems using Informatica PowerCenter 7.1 and Perl DBI.
· Implemented the population of ODS and Star Schema using Informatica PowerCenter 7.1 and Perl DBI. These data-marts were designed to be refreshed on a hourly basis allowing to capture near-real-time information.
· Supported legacy applications while we built new ones.
Position: Sales Engineer
Did Proof of Concepts for Company’s Data Aggregation software to m
· Configured the metadata layer in XML in order to integrate with Client’s environment.
· Used Business Objects and Micro Strategy as a reporting tool to query Hyperroll cube.
Performed on-site Essbase training to Company’s R&D division in
· Provided technical support to customers and helped resolve data issues in Oracle and Essbase environments.
· Represented the Company at Gartner Expo and Hyperion Shows.
Position: Lead Database Design Engineer 08/2001 - 09/2002
· Lead a team of Database Engineers and gave appropriate technical guidance and ensured the successive implementation of projects.
· Designed the Meta-Data Repository, which holds information about Dimensions, Facts, Measures, hierarchies, etc.
· Wrote PL/SQL to generate code dynamically by reading the information from this repository and process data from Operational Data Store (ODS) thru Star Schema.
Implemented Data Validation Routines using PERL DBI, which performs
Data-Checks at variou
· Did Effective planning for Data Migration from Development to Production Environments.
Projects: CISCO SYSTEMS 08/2001 - 09/2002
Designed the Operational Data Store (ODS) and Star Schema and the data
was extracted from ERP systems for Bookings, Inventory, Backlog, POS, Credit Memo
Designed, Implemented and Maintained huge Data Marts (ROLAP), which had
all the above measures side by side.
These Data-Marts were used for relational drill-thru via web-based
applications. These Data-Mart
· Designed and Implemented Archival Strategy, which archives data into historic tables/files when the current Fiscal period changes.
Implemented Incremental load strategy in ROLAP by creating temp tables
on a daily basis and Exchanging them with the appropriate concerned Partitions
and purging old partitions. Wrote PERL scr
· Implemented strategy, which reduced the time taken to load ROLAP from 15 hrs to less than 1 hr.
Reduced the most comp
Position: Senior Database Design Engineer 08/2000 – 08/2001
· Designed, Architected and Implemented the Data Warehouse / Data-Mart in First, Second and Third Generation of Company.
· Created Materialized Views using Summary Advisor which enabled more data to be aggregated in Data Warehouse with less maintenance.
· Used Query Rewrite feature in Oracle so that the Web-Application can query the base Fact table but gets results from underlying Materialized Views, which helped improving retrieval time significantly.
· Designed and implemented the ‘STAR SCHEMA’ for Music and Technology related Database for OLAP / ROLAP tools. Wrote exhaustive codes to load the Star, using ETL tools such as DataStage from Informix. Used PERL to Automate the End-to-End process.
Designed and developed ESSBASE Cubes from HYPERION. Wrote Report Specs,
Data Load Rules files, etc. Wrote PERL and SHELL scr
· Responsible for 24 / 7 Availability of Databases and Application in Mission-Critical environment.
· Provided Technical Guidance to DBA and the Development team and played a Lead Role in implementing the projects.
Position: Database Developer 02/1999 – 08/2000
As a Sole Database Programmer, wrote Comp
· Used Oracle built in packages such as UTL_FILE and DBMS_SQL.PARSE.
· Wrote Stored Procedures using latest Native Dynamic SQL.
Wrote PERL / Oraperl / DBI scr
Wrote PERL scr
· Supported application front-end developers and designed / developed data replication strategy.
· Created and managed numerous Forms 5x using Developer 2000 (Version 2.1) for the Data Entry. Also used many advanced Features in Oracle Forms such as LOV, Alerts, and Master-Detail etc.
· Developed Oracle Reports for Sales Analysis.
Developed dynamic HTML Reports for data Analysis using PERL / CGI / DBI
and Shell Scr
· Involved in SQL Performance tuning using Cost Based and Rule Based Optimizers with Hints.
· Heavily involved in doing DBA work and performed Routine Database Maintenance.
· Experience with Full Life-Cycle of Development & Deployment of the product.
· Solely responsible for maintaining the data Integrity and Accuracy.
WARNER MUSIC GROUP (WMG),
Position: Systems Programmer.
· Duties included Custom Oracle application development, programming, testing and implementation using PL/SQL. Version 3.3.
· Involved in upgrade and enhancement of the existing database and overall system in Oracle.
· Responsible for loading data from flat files into Oracle Databases and take care that no data is lost or destroyed.
· As a systems programmer, programming involved writing Cursors, Stored Procedures, Triggers, Functions, and Views in PL/SQL 3.3 on UNIX platform for populating the database.
· Also secured and maintained the database loading sequence from remote sites, as well as from work.
· Involved in the design and development of Oracle Products with front-end as well as Back-End using Forms, Reports, Cursors, Triggers, Functions and Procedures.
· Also called Functions from remote packages into Oracle Databases.
· Responsibilities included application and designing of dynamic web pages using applets and classes with
Java / Java Scr
SKILLS: Database Software:
ORACLE 10G / 9i / 805 / 8i / 8.1.6 / 8.1.7 / 22.214.171.124 / 7.3, SQL*PLUS 8, PL/SQL 3.3 / 8, Triggers, Functions, Procedures, Packages, Cursors, RDBMS, OLAP, ROLAP, HOLAP, FoxPro 2.6, DB2, Erwin, TOAD, ESSBASE 6.0 / 6.1 / 6.2 / 6.5, Informatica Powercenter 6 / 7 / 7.1, Ardent’s Datastage from INFORMIX (ETL tool)
PL/SQL, C++, C, PERL, DBI,
DBD, Oraperl, SPL, UNIX, SHELL, XML, JAVA, JavaScr
Application Development Software:
Business Objects, Micro Strategy, Informatica PowerAnalyzer, Developer 2000 Version 2.1 (Forms 4.5 & 5, Reports and Graphs), Visual Source Safe, Star Team.
Sun Solaris 2.6 / 7 / 8, AIX, Windows NT 4.0, Windows XP/ ME / 2000 / ‘98 / ‘95, Ms-Windows 3.x, MS- DOS.
Oracle 9.1 and Patch 2 on Sun Solaris 7
Oracle 8.0.5, 8.1.6 and 8.1.7 Patch3 (Server and Client) on Sun Solaris 2.6 / 7 /8
Ardent’s Datastage (Server and Client) on Sun Solaris 2.6 / 7
Hyperon’s ESSBASE Server on Sun Solaris 2.6
Netscape’s Enterprise Server on Sun Solaris 2.6 / 7
Netscape’s ECXpert on Sun Solaris 2.6
Apple’s Web Object on Sun Solaris 2.6
Net Graphs on Sun Solaris 2.6
Related Courses: ADVANCED POWERCENTER DEVELOPMENT, May 2004
Administration and Security, Advanced Mapping Techniques, Advanced Workflow Tools, Performance Tuning, Error Handling and Migration Strategies, Informatica Velocity Methodology.
Related Courses: ESSBASE ADVANCED TRAINING, April 2001.
Related Courses: DataStage Essentials for ETL (Extraction Transformation & Loading Software),
Related Courses: ESSBASE 6.0, June 2000.
ORACLE EDUCATION CENTRE,
Related Courses: PL/SQL Programming (Through Warner Music Group), November 1998.
IBM EDUCATION CENTRE,
Related Courses: Net.Commerce (IBM's Web Application Language) August 1998.
Oracle Developer 2000 Java / Java Scr
HTML 4.0 FoxPro 2.6 C/C++
TULEC COMPUTER EDUCATION,
Expertise in k-shell, c-shell
and borne-shell scr