SUMMARY

• Almost Ten (10) years work experience in Business Intelligence, Project Management & Project Coordination. Experience in creating and maintaining Hyperion Essbase Cubes/ Planning Applications & Reporting (Using Excel add - in, Analyzer and Reports)
• Experience in maintaining data-marts, FDW (Finance Dataware House), Hierarchy and maintain BU reports.
• Full software life cycle experience in Hyperion including analysis, design, development and testing phases of application development
• Experience in providing L1 & L2 support to the end business user in MIS environment including Hyperion.
• Interacted directly with the clients, to gather requirements & generated project requirements.
• Handled 25 members team size and leading complete project activities. Experience in team leading/ project management activities
• Handled several successful project transitions from client, transition starting from planning, initiation phase, system appreciation phase, shadowing phase till steady state phase
• Analyzed the excel data and dashboards and give upper management with the Analysis of the business operations, strategic planning and business development techniques
• Provide user training prior to project rollout and as part of ongoing lifecycle with Strong understanding of SDLC
• Excellent interpersonal skills with analytical, problem solving, and conceptual skills with demonstrated experience documenting and working through issues as part of a team Demonstrated ability to adapt to changing business needs

TECHNICAL SKILLS

Languages: C, C++, Java, Pascal, Assembly Language.

SAP R/3: ABAP/4

Java Technologies: JDK 1-2, AWT, SWING, Java Beans, J2EE, Servlets.

Web Technologies: XML, VB, VB Script, JavaScript, JSP, ASP, HTML, CSS, Perl

Operating System: Windows 95/98/2000/ME/ NT, UNIX, LINUX.

Server Configurations: MS WS 2003, Web sphere, Apache Web Server, Jakarta Tomcat

Databases: Oracle 10g/9i/8i, DB2, SQL Server2000, MS-access, Sybase

Software Packages: CAD, MS Office Suite, Adobe Photoshop, VS6

Software Engineering Tools: Rational Rose, Easy Win Online Software, UML, MS Project, PERT, COCOMO Cost Estimation Tool

OLAP Development Tools: Hyperion Essbase 11/9./7.X/6.x, EAS 9.0/7.X, AIS, EIS 9X/7.X/6.x

Business Intelligence Tools: Hyperion Planning 3.3.x, H.A.L, EIS

Reporting Tools: MS Excel 2007/2003, Smartview, Web Analysis, FR, Brio

Web Design: HTML, MS FrontPage, Dream Weaver, Macromedia Flash

PROFESSIONAL EXPERIENCE

Confidential

Manager - IT

Responsibilities:

• Project Deliveries: Operational Planning Project, Financial Planning Project, Prepaid, iProcurement, Order Management (OM), Postpaid, Human Resources, I Expense Project, I Quality Projects.
• Operations, MRN, Centralized Procurement, MSD, Service PR
• ERP Analytics, audit & health check report created and documented along with requisite Excel templates to be used for analysis & decision support system purposes
• Managed Large and Complex Projects worth USD 300K - 5 million
• Project Management, Planning and Delivery - Own the complete Project Delivery following all through SDLC lifecycle - Maintaining the quality, Timely Delivery within the scope and budget of project.
• Project Monitoring & Control - Organize periodic reviews with the Vendors and business Manage Issues/Risks/Dependencies, Mitigating Issues & Risks, Maintain Daily Tracker
• Process Building - new processes governance & implementation, periodic reviews with vendors and business
• Ensuring successful operationalization of Projects according to processes, governance mechanisms with Vendors & Internal department
• User Manual Preparation, Documentation, Training, GoLive and Production Support, SLA Management
• Vendor Management, interacted, negotiated, managed & controlled projects with the vendors - IBM, Oracle, Tech M, KPMG, Amdocs.
• KPI & Sub KPI Analysis of Sales, Marketing, Customer Service Delivery (CSD), JD, KRA, KPI, Activity monitoring, Performance Management & Monitoring using Reports and Dashboards
• Effort Estimates, H/W Sizing Estimates, Licensing Estimation, Optimization, Documentation
• Acted as a liaison between various teams, business and external vendors.
• Ensure that all infrastructure and applications requirements are in place to ensure the successful delivery of the project.

Environment: MS Excel 2003/2007, MS Office, MS Project, MS Power point, MS Word, MS Visio.

Confidential

Project Manager

Responsibilities:

• Provided support in strategy, business planning, organization, finance, process design & workflow.
• Worked as consultant for the management of plans and integrating delivery systems.
• Involved in documentation, data delivery, data quality assessment & reconciliation.
• Managed projects, resources and project plans within and outside of department to accomplish tasks such as conducting ad-hoc meetings and working with clients to complete required tasks.
• Provided input to performance appraisals of associates assigned to project teams.
• Assigned work to all various team members, keep track of their work, and escalate & resolve the issues.
• Did the Resource Estimates, Budget & Project Plans for the Projects.
• Acted as a liasion between various teams, business and external vendors.
• Weigh and prioritize needs of all customers - corporate and external - and manage projects risks in a fashion that maximizes customer satisfaction and timely delivery.
• Lead the development and use of project design, development and deployment standards.
• Ensure that all infrastructure and applications requirements are in place to ensure the successful delivery of the project.
• Oversee & did the Documentation in all the areas, and see that standards are followed. Mentored and helped team members across teams to do the documentation for Manual.
• Created Excel Template and Structure with tables, graphs, formula, formatting for Effort Estimates, budget analysis, milestone compliance & risk mitigation plan.

Environment: MS Excel 2003/2007, MS Office, MS Power point, MS Word, Excel Templates.

Confidential, Charlotte, NC

Project Manager / Coordinator

Responsibilities:

• Did the Transition of HFR/FBS Applications & Information Publisher (IPub).
• Created Application Handbook Manual & Power point presentations for these Applications
• Managed projects, resources and project plans within and outside of department to accomplish tasks. Leads business processes with stakeholders to achieve business needs.
• Provided input to performance appraisals of associates assigned to project teams.
• Prepared the Weekly status Report, Take inputs from the Marketing, Pricing, Signing & Data warehousing teams.
• Assigned work to all team members, keep track of their work, and escalate & resolve the issues Did the Resource Estimates, Budget & Project Plans for the Projects.
• Lead the Hyperion Financial Reporting (HFR)/Financial Budgeting System (FBS) Applications.
• Lead the Marketing Workflow (MKW) application, which feeds the marketing needs of client.
• Lead the Pricing Management Facility (PMF) & Coupon (CPN) generation & compliance.
• Signing (SGN) Application, Oversee the Documentation in all the areas, and ensured standards.
• Mentored and helped team members across teams to do the documentation for Application Handbook Manual.
• Created the Presentations to be presented to the client for each Applications and helped team members in its preparation as well.
• Created the file structure & organization for deliverables

Environment: MS Excel 2003, MS Office, MS Power point, Hyperion, Unix, Mainframe, MSTR, MS Project, Excel Templates.

Confidential, Beaverton, OR

Project Leader

Responsibilities:

• Did Inventory of representative sample of Brio Reports and created an excel with Report Name, corresponding Brio Query Document & underlying Oracle Data Mart tables used in reports.
• Did the mapping for each report to corresponding .bqy file by finding files and folders across all servers, Run Brio Query Parser Utility which in turn generates output in the excel format.
• Underlying Oracle DM tables are outputted corresponding to each .bqy file.
• Did Inventory of representative sample of MSTR Reports (Micro Strategy) and created an excel.
• Involved in Impact analysis of the Reporting Objects each for Brio and MSTR Impacted Objects
• Involved with PM in creating and maintaining weekly Project Status Report. Collected inputs from all tracks, i.e. SAP R/3 - BW, Oracle Data Mart & Reporting and created PSR, tables, graphs etc on a weekly basis.
• Created the final presentation to be presented to the client about the Impact analysis of GBI systems due to SAP R/3 Upgrade.
• Created Excel Template and Structure with tables, graphs, formulas, formatting for Effort Estimates, Created the file structure & organization for deliverables: Analysis Summary, Inventory, Impacted Objects, Resource Loading Plan, Effort Estimates, Risks involved.
• Created word documentation of Analysis summary, Resource Loading Plan, Effort Estimates, Risks Involved.

Environment: Brio Insight 8.5, Brio Explorer, Micro Strategy (MSTR) client 8.0, MS Excel 2003, Brio Query Parser, Windows XP, Unix, SQL navigator, MS PowerPoint, Word

Confidential, Washington, DC

Project Leader / Coordinator

Responsibilities:

• Involved in the Maintenance of two Finance cubes in Test and Production Main & Staff
• Maintaining Main & Staff Cubes using EAS Console in Essbase and Hyperion Planning
• Created Metrics in Accounts Dimension like Expense as a percentage of total expense, expense as a percent of total revenue.
• Created a forecast model to do forecasting & trends.
• Created, maintained new members to be created to Planning, changes in hierarchy and member properties. Did Planning desktop refresh in Planning to synchronize the cube with Essbase.
• Created new and modified existing web form & business rules to be used by business users.
• Created Calc Scripts for Allocations, Roll ups, Expense calculation, clearing, copying data, GA Expense per FTE, Salary Allocations.
• Forecast vs. Budget variance, Forecast vs. Actual variance, Forecast vs. Forecast variance, Forecast Summary Reporting. Migrated Forecast business rules from test to prod

Environment: Hyperion Essbase 9.0, Excel Add-In, MS Excel 2003, Hyperion Planning 9.0, Windows XP/NT

Confidential, Hoffman Estates, IL

Lead Systems Engineer

Responsibilities:

• Involved in the Development & maintenance of three Finance cubes in UAT and Production SHC, Unit & Sale.
• Meet with decision makers, system owners, domain architect and end-users to Interpret issues and provide initial analysis towards resolution.
• Requirement gathering from end business users, and involved in creation of Business Requirements document, designed the cubes based on requirements and created Design Document.
• Involved in deciding the dimensionality of all the three cubes, SHC, Unit & Sale
• Modified and suggested the references to be used for flat files to be used as input file from Mainframe. Created the rules file from the flat files for dimension builds for dimensions.
• Provided Production Support for ULDB and NATPLAN applications
• Created Calc Scripts for External P&L and Home Services P&L. Mapping from Internal to External P&L and created the corresponding Home Services P&L.
• Internal Margin calculations and Gross Profit calculations for retail method and cost method.
• Created Users and User groups for accessing the applications on test and production environment
• Optimized the databases for Calculations and data load optimizations to reduce the load times and also calculation times. Involved in creating the scripts for running the batch programs
• Deployed the Applications on the Production Servers for go live and to be used by the end users.

Environment: Hyperion Essbase 9 X/7.0/6.5.4, Excel Add-In, MS Excel 2003, Unix, Windows XP/NT, Mainframe, C, Unix Shell script, FTP, Sun Solaris 2.6, PeopleSoft Financials 8.1