PROFESSIONAL SUMMARY:

• Confidential has about Fifteen years of experience in IT and Finance industries.
• About 9 years of experience, about 8 years of SAP, OLAP techno - funtional(IT/Finance) areas like SAP SRM, ABAP, Hyperion’s Essbase, Enterprise, Java/J2EE,Perl, Oracle, Planning, ESSCMD, EIS, Analyzer, Alphablox, Financial Reporting, HFM and shared services 11.x/9.3,System 11.x/9,SQL Server.
• Excellent experience in ESSBASE, ORACLE and UNIX/SHELL PROGRAMMING.
• Excellent analytical and programming skills.
• Over two years of experience on Java, J2EE, EJB, Servlets, JSP, with Weblogic 3.5.
• Around three years of experience on Mainframe programming using COBOL, MVS, CICS, DB2 and JCL.

TECHNICAL SKILLS:

Operating Systems: MS Windows 95/98/2000/NT/XP, Unix, MVS

Languages: Java2.0, J2EE, C, C++, Cobol, SQL

Databases: SQL Server,Db2 7.0, Oracle 8i,9i,10g,MySql3.2.3, Teradata, IMS DB/DC,DB2

Web Related: JDBC2.0, Servlets2.3, JSP1.2, JSTL, Struts1.1, EJB2.0, HTML4.0, JavaMail, Perl, JNDI, RMI, JavaScript, Tomcat5.0, Web logic 7.0, WebSphere 5.0. JBoss3.2.3

Tools: & Utilities: SAP, Essbase OLAP server 5.x/6.x/7.1, Essbase application- Manager and spreadsheet add-in with VBA, Planning 4.1, Analyzer5.5, HAL, ODI, Alphablox 3.5 & 5.1, HFR 9.3

PROFESSIONAL EXPERIENCE:

Confidential, Tulsa, OK

Computer Systems Analyst

Environment: Hyperion Planning (EPMA)11.1.1.2.Essbase 11.x, Hyperion Financial Management, Java/J2EE, Planning 9/11.x,ODI, Oracle 11i, SAP, Financial Reports 9/11.x,Unix, Windows XP, EXCEL.

Responsibilities:

• Loading Forecast data weekly into applications for business review.
• Scheduling batch jobs on Unix Environment.
• Monitor and Trouble shoot issues with Calc scripts and Business Rules.
• Gathering business requirements for enhancements and create design for new reports/webforms.
• Supporting Month End, Quarter End and Year End changes.
• Monitoring overall server and load balancing.
• Failover process in case of disaster.

Confidential, Atlanta, GA

Computer Systems Analyst

Environment: Hyperion Enterprise6.5.1,.Essbase 9/11.x, Hyperion Intelligent explorer 8.2, Java/J2EE, Planning 9/11.x,ODI, Oracle 11i, SAP, Financial Reports 9/11.x,Unix, Windows XP, EXCEL.

Responsibilities:

• Loading data into applications for business review.
• Development of new application for Juarez manufacturing plant.
• Gathering business requirements for enhancements and create design for new reports
• Building Financial reports, Business formulae changes.
• Supporting Month End, Quarter End and Year End changes.
• Tie out Balance sheet/GL reports to SAP.
• Development of reports in SAP.
• Creating Balance sheets and Income Statements for the complete year/Cost center.

Confidential

Onsite Project Lead

Environment: Hyperion System 9.3.Essbase 9, Planning 9.3,ODI, Oracle 11i, Financial Reports, SAP ABAP, Java/J2EE,,Unix, Windows XP, EXCEL.

Responsibilities:

• Building webforms, Business rules for Capex, Opex and Workforce modules.
• Development of ODI interfaces to build dimensions from SAP.
• Development of ODI interfaces for dataloads from SAP.
• Took active part in development of ELT process to get data from ERP systems to Oracle Staging tables using ODI.
• Development of Business Rules for calculating Depreciation, Amortization, Accum. Depreciation, Licence Fee and Employee Transfers.
• Creating Balance sheets and Income Statements for the complete year/Cost center.
• Development of Business Rules for Carry Forward values into Next year Budget based on Current year s closing balance.
• Automating dimension builds/dataloads using ODI.
• Cordinating with Onsite/Offshore team.

Confidential

Onsite Project Lead

Environment: Hyperion System 9.3.Essbase 9, Web Analysis 9,Planning 9.3,ODI, SAP SRM, Oracle 10 g, Windows XP, Sun Solaris 64 bit, Java/J2ee, EXCEL.

Responsibilities:

• Development of Forecast and Budgeting process thru Planning Dataforms.
• Income statement and Balance sheet reports using Webanalysis.
• Dimension Building using ODI mappings from SAP.
• Development of Business Rules using the logic from SAP.
• Development of calculation scripts.
• Automation using Maxl.
• Development of Data load Rules
• Webform development using Java/J2EE for better presentation.

Confidential

Project Lead

Environment: Hyperion System 9.3.Essbase 9, SAP Web Analysis 9,Planning 9.3,ODI, Oracle 10g, Informatica, Windows XP,HP Unix, EXCEL.

Responsibilities:

• Detailed Design and Data Model for the PSI application
• PSI(Production, Shipment and Inventory) application development
• Creating web analysis reports Item Financial and Item Detail Reports.
• Adjustments captured from front end (web forms) for the estimated values based on the forecast from SAP.
• Introduced Profile concept.
• Developing Formulae for Measures.
• Security: Provisioning is done using Shared Services with Single Sign On Authentication(SSO
• UAT: Reconciliation of reports as per the business requirements.
• Used Informatica for ETL
• Oracle Data Integrator (ODI) for dimension building.

Confidential

Team Member

Environment: Essbase 7.1.5 & 9, SAP Web Analysis 9, Oracle 8i & 9i,, Java, Windows XP, EXCEL.

Responsibilities:

• Creating web analysis reports as per the business requirements.
• Loading budgeting, actual and Commit data as per the Confidential s fiscal calendar from SAP.
• Validation of the accounts formulae.
• Reconciliation of reports as per the business requirements.

Confidential

Team Member

Environment: Essbase 6.x & 7.1.5, SAP,Planning 4.1, Oracle 8i & 9i, Windows XP, HP UNIX, Shell, Perl, EXCEL.

Responsibilities:

• Creating Applications/metadata/security in Planning and maintenance.
• Refreshing Applications/Security as per the metadata in SAP.
• Associate Business Rules with the DataForms for business users.
• Helping the users with Smart View to work with Excel.
• Web enablement for the users with Java/J2EE.
• Responsible for enhancements and supporting of financial reporting Profit and loss cubes for CA - Finance
• Responsible for enhancements and supporting of financial reporting Bookings and Revenue cubes for CA-Finance
• Responsible for enhancements and supporting of financial reporting Metrics cubes for CA-Finance
• Written calc scripts to customize the functionality
• Written EssCMD and shell scripts, Perl to automate the cube refresh process
• Responsible for developing load rules using pl/sql queries
• Responsible for managing security filters/groups for Planning and the underlying Essbase cubes
• Responsible for implementing the SOX compliance across all the cubes
• Responsible for upgrading the ESSBASE version 6.5.4 to 7.1

Confidential

Team Member

Environment: Essbase 6.5,VB, Oracle, C++, XML, Planning 3.5, Alphablox 3.5 and 5.0, Java 1.4, Windows XP, EXCEL, NCR’s Teradata, IBM’s DB2.

Responsibilities:

• Responsible for creating reports for Liability Rating, estimating the finances for Opportunity Pipeline to save and Management Decision Tools Dashboard application. The process uses an automated feed of actuals from TERADATA and DB2 which in turn feeds the Essbase cubes.
• Developed Drill Thru functionality for certain fields using Java.
• Developed stored procedures to feed the data from Teradata to Essbase.
• Report scripts, shell scripts and calc scripts have been established to forecast the finances for rest of the current year and the next year.
• Developed Alphablox5.0 and Alphablox 3.5 templates for user’s convenience.
• Attained expertise in Data warehousing and OLAP technologies.
• Fine tuned all applications that reduced the calculation times by 60%.
• Developed Batch files and scheduled.