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.

CAREER BACKGROUND

Confidential

Consultant

• 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

Technical Consultant

• 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.

Confidential

Senior Consultant

• 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.
• 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 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.
• 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

Senior Data Warehouse/DSS Analyst

• 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

Consultant

• 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

• 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

• 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 Praxa.
• 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

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

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