CAREER OBJECTIVE:

Accomplished IT Consultant with a Doctorate in Physics and over 15 years of experience in Information Technology seeking a challenging career opportunity where expertise in a wide variety of computer applications, mathematical and analytical skills, technical consulting, data integration, systems design, and ERP’s such as PeopleSoft, Oracle Financials, Data Warehousing, Business Intelligence and Oracle Hyperion can be effectively applied to completing projects, full life cycle development, and achieving company objectives.

PROFILE:

• Over 15 years of IT experience.
• 14 years of experience in SQL and PL/SQL Programming and optimizing/fine tuning them.
• 14 years of experience in Oracle database tools like sql loader, import, export and other database utilities.
• 10 years of Dimensional and Relational data modeling experience.
• 10 years of Oracle Developer Forms, Reports and Discoverer experience.
• 10 years of Oracle Application Server experience.
• 2 years of experience in Oracle Data Integrator (ODI), Hyperion Financial Management (HFM), Planning, Essbase, Hyperion Financial Reports, Maxl, Calc scripts and Smartview.
• 2 years of experience in PeopleSoft HRMS, People Code, App Designer and SQR reports.

SKILLS/TECHNICAL SPECIALIZATION:

• SQL, PL/SQL, SQL Loader, Import, Export and other Oracle database utilities.
• Oracle Developer Forms Reports and Designer.
• Oracle databases 11g/10g/9i/8i/7
• Optimizing and fine tuning of sql, pl/sql and other Oracle applications.
• Oracle Application Server.
• PeopleSoft HRMS, People Code and Tools, App Designer and SQR
• Hyperion Financial Management, Planning, Essbase, Calc Scripts, Hyperion Financial Reports and Smartview.
• Oracle Data Integrator (ODI)
• Oracle Financial Analytics (OFA)
• Oracle Business Intelligence Enterprise Edition (OBIEE) and Crystal Reports.
• SQL Server and Visual basic.
• HTML, JavaScript, Java, C++, Remedy, PVCS, Kintana and Primavera

CAREER BACKGROUND:

Confidential, Richardson, TX

Consultant

Responsibilities:

• Worked on the PANY project to build interfaces for processing transaction data using pl/sql.
• One of the module was for maintaining patron account information and the other was for processing violations.
• This involved writing of complex pl/sql packages and functions.

Confidential, Houston, TX

Technical Consultant

Responsibilities:

• Worked/built interfaces to load and extract metadata and data using ODI, Oracle SQL and PL/SQL.
• Worked on different projects for various clients using Essbase, Planning, and Hyperion Financial Management.
• Designed and developed reports using Hyperion FR and SmartView.
• Developed an ASO Essbase application, rules files to build dimensions and attribute dimensions. Used oracle sql and pl/sql to populate the intermediate tables in the data warehouse. Created reports in FR and Smartview. Involved in system integration testing, user acceptance testing, user sessions and migration of code from development to test instance.
• Used sql and pl/sql to pull data out of the source system into a temporary staging area. Built interfaces using ODI to load data and metadata to Hyperion Planning and Essbase. Automated the load process and migrated the applications and ODI objects to the test environment.
• Built a Hyperion Financial Management application for their statutory reporting. Used sql and pl/sql to pull data from oracle apps to populate temporary tables. Built interfaces in ODI to load and extract data and metadata. Designed and developed reports using FR. Worked with client to perform integration testing and user acceptance testing (UAT). Implemented security and user provisioning.
• To demonstrate OFA to customer, installed and configured OFA and OBIEE to set up dashboard for Oracle Financial Analytics.
• Supported and maintained Hyperion Financial Management (Ver 11.1.2.1) and other applications used in the monthly close process.
• Worked on rules files to import metadata and data.
• Upgraded Essbase and Planning from version 11.1.1.3 to 11.1.2.1 and Financial Reporting from 9.3.3.to 11.1.2.1
• Developed a C# application for data extraction and load from Hyperion Financial Management to Hyperion Planning and vice versa based upon user provided specifications.

Confidential, Houston, TX

Senior Consultant

Responsibilities:

• Design and extracted data from Apps 11i for building OLAP cubes for detailed trending analysis, data mining and budgeting of sales and cost data using Hyperion Essbase and reporting tools.
• In the role of an architect have done, data modeling, designing and implementation of Fabnet portal based on Oracle Application Server 10g.
• Performed analysis, design, architecture, data modeling, writing technical & functional specifications, test cases and testing in Data Warehousing and Business Intelligence.
• As a part of the data warehouse/datamart data load (ETL) have written complex Oracle pl/sql procedures, functions and database triggers to load data from Oracle Apps. Optimizing sql, pl/sql and other applications.
• Have done lot of optimization of sql, pl/sql and other applications.
• Usage of Oracle backend tools like sql loader, import, export and other database utilities.
• Worked on PeopleSoft (Payroll, Human Resources, and Benefits) in a techno/functional role. Experience includes responsibility for analysis, detail design, coding, developing application test plans, user acceptance testing and system functions from technical and functional perspectives. Specialties also include customizations to PeopleSoft products that fit enterprise requirements while maintaining the integrity of the delivered functionality of PeopleSoft. Support and maintenance of PeopleSoft. Maintained/Built reports using SQR.
• Created new reports/interfaces as per specifications. Implemented changes to existing customizations, reports and adding in new customizations. Involved in the implementation of security and applying Tax Updates/Bundles.
• Worked on various PeopleSoft projects like Code of Conduct, Pension Path, Etime and Applicant Tracking System. As a member of the PeopleSoft upgrade team from 8.9 to 9.1, involved in analyzing customizations and applying changes to the customizations and implementation of security. Customized MSS (over 800) as per user requirements.

Confidential, Houston, TX

Senior Data Warehouse/DSS Analyst

Responsibilities:

• Performed detail analysis, designing, architecture, technical and functional specifications, test cases, and unit testing for Business Intelligence and Oracle Portals.
• Designed and migrated the sales portal to 9IAS as well as building data marts for varying business units.
• Performed analysis, design, architecture, data modeling, writing technical & functional specifications, test cases and testing in Data Warehousing and Business Intelligence.
• Written complex pl/sql procedures, functions and database triggers to load data into datamarts.
• Have done lot of fine tuning of sql and pl/sql and also the usage of Oracle backend tools.

Confidential, Houston, TX

Consultant

Responsibilities:

• Web portal development and maintenance, using Oracle Webdb and Oracle 9IAS. Design, development and support of the Data Warehouse and data marts.
• Development and support of Oracle Reports, forms and discoverer.
• Have written complex pl/sql packages as a part of the portal development.

Confidential

Programmer/Analyst

Responsibilities:

• Designed and developed an in house web based application using Java and HTML.
• Maintained and developed reports using Oracle reports designer for a client.
• Wrote stored procedures, functions and packages in the Oracle database.
• Maintained Oracle development and test instances for an ongoing project.

Confidential

Programmer/Analyst

Responsibilities:

• Analyzed project/client functionality, data modeling, project standards, and liaison with the client on project requirements, writing test specifications and unit testing
• Delivered highly complex forms as per specifications using Designer and Developer 2000. Was a technical mentor for team members.
• Enhanced and developed Oracle Packages, procedures and functions for data extraction from Oracle databases, writing test specifications and testing unit modules
• Developed modules using Visual Basic and created stored procedures, functions and packages on a SQL Server database.
• Maintained the admissions application software built by Confidential .
• Developed and tested a backup strategy for Oracle Databases.
• In house Projects - Installing Oracle Databases, Developer Server, Application Server, and Oracle WebDB on NT Servers and fine tuning oracle databases. Created test Intranet web site using Oracle WebDB.

Confidential

Programmer

Responsibilities:

• Worked on a project for the Indian Army (Army Group Insurance), which involved creating Oracle forms, reports and writing test specifications.