OBJECTIVE:
To utilize my software design and development skills in a leading edge organization that will provide continuous opportunities for growth and advancement.

PROFESSIONAL SUMMARY

• Over 7 years of IT experience with more than 4 years experience as a Oracle Hyperion Consultant, Extensive hands on technical experience in many aspects of Data Warehouse and OLAP software systems design and implementation.
• Extensive experience in the development, design, analysis and Implementation of various applications in Client/Server environment using Oracle Enterprise Performance Management System 11 Software Suite, Oracle 11g, Hyperion Essbase 7.X/6.X, Essbase Integration Services, Hyperion Analyzer, Hyperion Reports, HAL, Hyperion Planning and Essbase Spreadsheet Add-In on Windows 2000/NT and Unix environments.
• Extensive knowledge and hands on experience in ESSCMD, MaxL, MDX Scripts, Calc Script optimization and UNIX Shell Scripting with proficiency in SQL and complex SQL queries. Excellent work experience of MOLAP and data extraction tools.
• Excellent Programmer in C, C++, C#, Java, VB, Perl, .NET and J2EE technologies.
• Proficient in software documentation, technical report writing, decisive with strong leadership qualities, flexible in work schedules.
• Managed onsite offshore teams. Good understanding of business, can relate to the business side of IT operations including S/W Process, Solution delivery, Risk management, Resource Planning.

EDUCATIONAL QUALIFICATIONS:

MS in Electrical Engineering
Bachelor of Engineering in Electronics & Communication

TECHNICAL SKILLS:

OLAP Hyperion Essbase 11.1.3/7.1.5/6.5.4/6.3/6.1, Hyperion Planning 11.0/3.3/3.5.1, ESSCMD, MAXL.
Reporting Tools Hyperion Reports, Hyperion Analyzer, Hyperion spreadsheet Add In, Business Objects 5.0, Informatica Power Center 7.0
Data Modeling Dimensional Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling,
Databases Oracle 11g RAC/9i/8i/8.0/7.0, Teradata, MS SQL Server 2000/7.0/7.0, ESSBASE-6.0/7.x/11.x
Programming C, C++, C#, VB, VBA, Java, Java Script, ASP, VB Script, Perl, SQL, PL/SQL, SQL*Plus 3.3/8.0
Testing Tools LoadRunner, Winrunner, Test Director, Quality Center
Operating Systems Win 3.x/95/98/2000/2003, Win NT 4.0, UNIX, LINUX
Software Applications Microsoft Office, Macro Media Flash, Adobe Photoshop, Lotus Notes, Novell
Delivered Applications, Microsoft Task Scheduler, Unicenter Autosys, Control-M scheduler, PSpice

PROFESSIONAL EXPERIENCE:

Company: Confidential (Basking Ridge, NJ) Jul 2008 Present
Department: VSO-IT Corporate Finance System
Role: Lead System Consultant
Verizon Communications Inc. (Verizon) is a provider of communications services. The Company has two primary reportable segments: Domestic Wireless and Wireline. Domestic Wireless’s products and services include wireless voice, data services and other value-added services and equipment sales across the United States. Wireline’s communications services include voice, Internet access, broadband video and data, next generation Internet protocol (IP) network services, network access, long distance and other services. It provides these services to consumers, carriers, businesses and government customers both in the United States and internationally in 150 countries.
Role & Responsibilities:

• Extensively involved in the complete Software Development Life Cycle for the Reporting Re-Arch cube and LTE implementation, worked actively in accomplishing and implementing the various phases such as the design, development, testing, defect/bug fixing, optimization, performance tuning, automation of the processes and deployment of the reporting cube in the production environment.
• Created relational database tables, configured Mapping tables, SQL Views, Stored Procedures, Triggers, Functions and Packages by implementing Oracle as the backend database for loading the GL, Customers and Statistical data to the Reporting cube.
• Developed and created new Rule files using Essbase SQL interface, implemented and standardized the solve order for the members across the different dimensions in the reporting cube to accurately calculate the data meeting the business requirements.
• Extensively involved in fixing and resolving the open defects in the Quality center. Troubleshoot and identified the problem, implemented the resolution and documented the details in the quality center.
• Implemented the Direct Adjustment load process which allows the users to make critical and vital manual adjustments/eliminations on demand dynamically through a web based .NET user interface MDUA that is deployed and maintained from a centralized repository. This adjustment data is uploaded immediately to the Reporting cube on the production Essbase server. The application delivers a secure and stable reporting environment and allows for rapid adoption of change / maintenance. Actively supported and maintained the MDUA web Application.
• Implemented Essbase Java API’s to extract Outline hierarchy and dimension information.
• Involved in the unit testing, system testing and integration testing for the backend Oracle database and the Essbase Reporting cube. Performed Integration testing by simulating a real time production environment prior to the deployment of the Reporting cube in production.
• Designed and Developed Automated and Manual Test Scripts for unit testing and validating the data against the legacy reporting cube for its accuracy and correctness.
• Responsible for Code Reviews, code testing and tuning associated with the automated scripts used to refresh and build the production Reporting cube unattended.
• Solely responsible for the design, development, testing and deployment of the FLASH/MEFR cube Management P& L implementation and downstream feed from the new Re-Arch Reporting cube.
• Optimizing the Balance Sheet cube’s retrieval response time by modifying the Essbase outline and performing performance tuning by aggregating the data.
• Created multiple Ad-hoc Reports using Hyperion Excel Add-In and automated excel templates using Essbase Visual Basic APIs.
• Implementing Subversion as the Version Control System for VZW Reporting for code migration and code versioning.
• Involved in defining requirements, functional specifications, designing approach documentations and testing strategies.
• Monitored and Supported the New Re-Arch reporting cube build and existing cubes Revenue, FLASH\\MEFR, PTRRPT and Location.
• Identifying and mitigating any production process/data issues as and when it occurred, troubleshoot and resolved them appropriately in a timely manner.
• Extensively Involved in creating security filters and assigning Essbase user’s and groups security.
• Provided 24/7 Essbase technical supports to the Corporate Reporting and Finance Group, actively interacted with the Finance group, offered suggestions and proposed solutions to resolve issues and involved in recovery and back up on NT Servers.

Environment: Windows NT/2003, UNIX, LINUX, Essbase 11.1.3, Java 6.0, VS 2005, Planning System 11, Analyzer, EIS, Hyperion Report 7.0, Maxl, ESSCMD, Excel Add-In, Oracle 11g, Linux, Teradata SQL Assistant 7.1, PeopleSoft, SQL Navigator, Microsoft Task Scheduler, Perl, Load Runner, Test Director
I worked as a Consultant through my parent Company

Confidential NJ for the projects below:

Client: Verizon Wireless (Basking Ridge, NJ) Nov 2006 Jul 2008
Department: Corporate ERP Information Systems
Role: Senior Application Developer/Support Analyst
Verizon Wireless, a sister concern of Verizon Communications Inc., is a leader in delivering broadband and other wireline and wireless communication innovations to mass market, business, government and wholesale customers. This position required understanding and evaluating business requirements, providing architectural code review, make strategic technical recommendations and comprehensive analysis of over all system reliability. In addition this position includes automating processes for reducing data redundancy and eliminating manual efforts, resolving system issues and review & document technical specifications.

Role & Responsibilities:

• Developing a fundamental understanding of multiple business functions and related production systems.
• Involved in analysis, development and enhancement of database (MDDB) outlines. Restructured and redesigned existing Essbase BSO and ASO cubes.
• Implemented Star Schema and used EIS to interface with the company’s existing Teradata data warehouse for Implementing Revenue Analysis dashboard. OLAP models and meta-outlinesdesigned through Essbase Integration Services.
• Designed and implemented Transparent partitioning from an ASO backend cube to a BSO front end cube.
• Involved in the performance tuning and optimization of data load, calc scripts, MDX Scripts. Extensively used MaxL, ESSCMDS, and Batch Scripts to run calculation scripts and report scripts. Created and modified Calc scripts for calculating Forecast and Trend data.
• Preparing and maintaining documentation including technical specifications, process flows and testing strategies.
• Designed and implemented ERD models for modeling logical and physical Oracle database architecture, used as Staging Area for distributed Legacy system data feed to Essbase cube.
• Extensively involved in the Unit, System and Integration testing of the Oracle Schema and the Essbase cube upload and build process. Involved in load and stress testing, simulating a real time production environment.
• Developing processes and reports to assist in identifying potential production issues and proactively mitigating them. Understanding and owning production code, processes and scripts in support of an enterprise data warehouse.
• Involved in developing Filters, creating users, groups as part of security mechanism for accessing the Application/database.
• Troubleshoot and resolved issues related with Analyzer Dashboard views and Hyperion Reports. Created and ran Report Books.
• Provided technical guidance concerning business implications of reporting applications and options on opportunities to leverage the tool and increase usage.

Environment: Windows NT/2003, UNIX, Essbase System 11, Planning 4.0, Analyzer, EIS, Hyperion Report 7.0, Maxl, ESSCMD, Excel Add-In, Oracle 11g RAC, Teradata SQL Assistant 7.1, PeopleSoft, SQL Navigator, Microsoft Task Scheduler, Load Runner, Test Director

Client: Confidential(Atlanta, GA) Aug 2006 Oct 2006
Department: Information Systems
Role: Senior Information Systems Programmer/Analyst

EarthLink is an Internet service provider, providing nationwide Internet access and related value-added services to individual and business customers. The Company\'s primary service offerings are narrowband Internet access services, including premium and value-priced access services; broadband or high-speed Internet access services; Web hosting, and advertising and related services. This position is focused on developing, maintaining, analyzing and improving production applications, overall data health, and day-to-day operations.

Role & Responsibilities:

• Translated end user requirements into application design specifications. Assured optimal match between cube design and report specifications.
• Developed Batch scripts, shell scripts using MAXL, ESSCMD’s and Rules files to upload data from financial system’s database to Essbase cube.
• Developed complex calculation scripts based on the financial and budgeting applications and optimized the running time for the Calc scripts.
• Created and mapped HAL jobs to load the hierarchies into different planning applications. Worked on Data Load through HAL to both ASO and BSO cubes.
• Utilized Application Manager/EAS: Model sizing, optimized cache settings, established user security, managed applications migration, established substitution variables and settings for dynamic time series, asynchronous processing, editing/validating scripts.
• Handled performance tuning, weekly back-ups and monthly consolidations of data and automated monthly/quarterly/annual report generation. Documented and issued procedures pertaining to Essbase applications.
• Involved in checking the status and progress of each planning unit so as to analyze variances in real time, revise, promote, reject and approve plans.

Environment: Windows NT/2003, Sun Solaris 8.0, Shell Script, Essbase 6.5.4/7.1.3, Planning 4.0, Maxl, ESSCMD, Excel Spreadsheet Add-In, Great Plains, MS Project, EIS, HAL, MS Task Scheduler

Client: Confidential (Houston, TX) April 2006 June 2006
Department: Corporate Information Systems (CIS)
Role: Hyperion Developer/Admin
BMC Software, Inc. is an independent systems software vendor. The Company provides software solutions that allow companies to manage their information technology (IT) infrastructure from a business perspective. Its portfolio of software solutions spans from enterprise systems, applications, databases and service management. This position requires taking regular backup of the corporate Essbase databases, automating the database reload process and providing administrative support to the users. In addition, this position includes working with end users to define and create required outlines, database refreshes and reports.

Hyperion Developer/ Analyst:

• Implemented Essbase in connection with financial budgeting, sales forecasting and marketing analysis to produce ad-hoc reports.
• Created batch scripts and scheduled them using the in house developed tool called Control-M, automating the process to run ESSCMDS/Maxl to take regular backups, used Control-M to schedule these backup tasks.
• Created one Cube called PPM and generated reports for the users by using Hyperion Reports.
• Extensively used Informatica an ETL tool to load data from MS SQL Server, Teradata, Excel spreadsheet, flat files and XML files into the target Oracle 8i database.
• Extensively worked with Hyperion Reports, created reports, which produced the corporate consolidation reports, and financial planning and analysis reports for management. Developed Income and expense Statement analysis reports.

Hyperion Database Administrator:

• Responsible for Backup and Recovery. Monitor, Troubleshoot and Tune Database Performance.
• Extensively involved in Essbase Administration activities such as filter creation, creation of users, creation of groups and maintenance of Essbase Servers.
• Provided 24/7 Essbase technical supports to all business units, offered suggestions and proposed solutions to resolve issues and involved in recovery and back up on NT Servers.
• Involved in system installation, configuration and software upgrades of Hyperion family products.
• Greatly reduced the Essbase Calculation time from six hours to 1 hour by optimizing the Cache settings and changing sparse and dense dimensions. Wrote queries and stored procedures using SQL Plus.

Environment: Windows 2000/NT, Oracle 8i, Teradata, Hyperion Essbase 7.1.3/6.5.4, Control-M, Maxl, ESSCMD, Excel Add-In, MS Project, Test Director, Hyperion Report 7.0, Hyperion Planning 3.5.1, Informatica, Remedy Ticket

Client: Confidential(Woodland Hills, CA) Dec 2005 - March 2006
Department: Information Technology Group (ITG)
Role: Senior System Analyst/Admin
Health Net, Inc. is among the nation’s largest publicly traded managed health care companies. This position requires supporting the budgeting, planning and forecasting process for the Corporate Business Planning group by developing and maintaining analytical models or cubes using Hyperion Essbase, Planning, HAL, Reports and Excel Add-In. It also included assisting the business users with the projections of Gross Profit, Capital Expenditures and performing financial analysis on critical expense items by creating financial reports to help them analyze the business trends.

Role & Responsibilities as Hyperion Developer/Admin:

• Designed and developed Actual and FMRS cubes. Reviewed the cube design for Essbase Core Competency.
• Optimized structure, loading and calculations through appropriate dense and sparse settings of dimensions, storage allocations and by dynamic calculations and debugging. Performedintelligent calculations by optimization of calc scripts using Fix, Endfix and If functions.
• Developed outlines, load rules, calc, partitions and report scripts. Extracted and loaded data from Mainframe applications and the General Ledger database to Essbase cubes.
• Wrote batch scripts and scheduled them automatically to run ESSCMDS and Maxl to take regular backups. Used Autosys to schedule these backup tasks.
• Maintained 5 cubes including Actual cube, HNPL, HNPLAN, FMRS and History cubes, optimized cache settings, established substitution variables and settings for dynamic time series.
• Support existing Outline & Calc Script updating, scheduling batch scripts, responsible for monitoring the day-to-day activities for the application on the production environment.
• Used Hyperion Planning to create and maintain new dimensions in the outline and add security measures to various users and groups thereby maintaining data security.

Environment: Windows NT/2000, Hyperion Essbase 7.1.3/6.5.4, Hyperion Report 7.0, Hyperion Planning 3.5.1, Hyperion Analyzer 7.0, HAL 7.3, Maxl, ESSCMD, Excel Add-In, Mainframe, SAP, Lotus Notes, Novell Delivered Applications,

Client: Confidential(Chicago, IL) Jul 2005 - Nov 2005
Finance Service Center
Department: FSC Reporting Systems
Role: Tech Lead Hyperion Essbase/Programmer Analyst
Project Scope: This position is responsible for the development and ongoing support of the Essbase applications for Tribune Company and its business units. This includes implementing Essbase upgrades and patches; creating, scheduling and monitoring the batch processes that update Essbase; and monitoring and optimizing system performance.

Role & Responsibilities as a Developer/D.B.A:

• Provide technical and functional support to the Essbase applications.
• Develop detailed project plans for all new Essbase initiatives.
• Monitor system performance and implement required enhancements to assure acceptable response times.
• Work closely with Tribune Information Systems to assure that database backups are performed and that system recovery is readily available.
• Created new Batch jobs and scheduled the batch files for complete automation process for nights and weekends, calculations and backups. Created Business Object’s Universe for the Departmental P& L Reporting, scheduled and ran online reports.
• Monitor the daily database load processes to assure data availability and accuracy.
• Work closely with the end users to define new functionality and to implement new capabilities.
• Provide end user documentation and training.

Environment: Windows NT/2000, Oracle, PeopleSoft, Hyperion Essbase 7.1.3/6.5.4, Hyperion Report 7.0, ESSCMD, Excel Add-In, Business Objects 5.1.3, Informatica, AutoSys, MS Project, SQL Server 2000

Confidential,India, Jun 2002 - Dec 2003
Software Developer
Informatics was the technology company that dealt with Systems and Application level development. They offered a full range of services across various industries, including client side services for small scale development of critical applications.

• Responsible for designing and implementing Database architecture, system analysis, design, development, testing and implementation of projects, Designed process flow diagrams and UML diagrams to depict the data flow of the application.
• Worked on Oracle and SQL Server databases. Responsible for design of databases which identified the functional requirements, constructed E-R diagrams and mapped the referential integrity constraints.
• Developed database procedures, functions, packages and triggers for enforcing the business rules using PL/SQL. Created tables and views in oracle.
• Debugged, coded and compiled multiple projects in C, C++, Windows and HTML.
• Preparation of unit and system test plans. Debugged and worked with clients to resolve issues with bugs.
• Worked on client code internationalization. Implemented client installation program.

Environment: Windows OS, UNIX, C++, C, Oracle, SQL Server, PL/SQL, Perl, VB, HTML