BANDHU PAREEK- 404-551-2642 Experience summary: 6 years of Total IT Experience 5 years of Hyperion Essbase System Development / Administration 3 year of HyperRoll Development / Administration 1 year of Informatica Development / Testing Strong Cross-functional skills and experience includes IT, business, project management, financial accounting. Hyperion consultant: Tasks include collecting user requirements, Analyze the requirements considering business, IT and user perspectives for creating and enhancing existing applications. Essbase system administration, developing new and maintaining existing Applications and databases. Business Analyst: Advanced reporting using Excel and Crystal Reports. Extracting data from several data sources like RDBMS using SQL queries, Import and export data from Text and Excel files. Created Spread sheet reports, Pivot Reports, Charts, Pivot lists using MS Query and SQL queries. Skills OLAP HyperRoll 4.X, Hyperion Essbase 7/6X, Hyperion MDM9.X, Hyperion Reports, Excel Add-Ins, Hyperion Planning ETL Hyperion Application Link (HAL), Informatica 7 Languages & Scripts Hyperion Calc and Report scripts, EssCmd, MaxL, Shell Script, SQL, VBA, Visual Basic, Java, C++, C, COBOL Databases Oracle 9, SQL server 2000, Access. Operating systems Windows 2000/XP, Unix Other applications and tools used Appworx, Cognos PowerPlay, Cognos ReportNet, Business Objects, Discoverer Reports, Oracle Apps, MS Excel, Word, Power point Academic qualifications: 1. Master in Computer Application 2. Bachelors in Commerce 3. Certification in Computing 4. Advance Diploma in Computer Technology Achievements: • Consultant of The Year 2006 award from current employer • Winner of Team of the Year award 2006, 2007 and 2008 • 5 Bronze award in till now, Based on performance and simultaneously delivering in Multiple projects Experience details: Projects 1: GE Capital Solution Oct’06- till date Role: Tech Lead (Hyperion Administrator Team) Danbury, CT Project Description: Capital Solution is one of the biggest leasing businesses of the world with balance sheet of $100BN. Cap Sol use Hyperion application for Budgeting/forecasting and closing reporting purposes. Capital Solution Hyperion Support is RTS engagement, with team strength of 6 (1 onsite and 5 offshore) supporting 24X7. Supporting Closing (HyperRoll) and Consolidation (Planning) Cube with user base of 1000 + users, spread across the glob. There are eleven sub-businesses rolling under Capital Solution, users are spread in US, Europe, Australia, Asia. Its one of the Biggest Hyperion Implementation in GE. Role and Responsibilities: • Handling Team of 5 working from Offshore (India) • Supporting 24X5, Users base of 1000 spread across US/Europe/Asia/ Australia • Setting up Processes and Workflows • Conducting Lean workouts on processes and finding improvement areas • Publishing Dashboards to Key stake holders and Businesses owners • Designed, Developing and Modified the Outline according to the business requirement • Conducting user training sessions • Creating Automators for Hyperion MDM • Maintaining Hyperion MDM 9.2 keeping multiple outlines in sync with one another and Corporate Systems • Maintaining system and keeping up to date with Re-orgs • Understanding new requirements, Converting functional requirement into Technical • Integrating new acquisitions in GE • Integrating new GL’s feeding in Hyperion System • Developing process map • Running Month and Quarter Close process • Setting up system for Planning Sessions • Developed Calc Scripts and Member Formulae • Optimized Outline and Calculations • Created numerous reports using Hyperion Reports Tool • Created users and user groups and applied security in planning and Essbase • Developed scripts to calculate the database on hourly and nightly incremental Data • Involved in analyzing the financial data and tying it with oracle GL • Created numerous reports using Hyperion Essbase Excel-Add in • Developed data load rules • Automated the data load process using MaxL, Esscmd, UNIX batches, Appworx • Created numerous web forms based on user requirements in Hyperion Planning • Created numerous business rules to calculate data inputs from Hyperion planning • Maintained Hyperion planning metadata using HAL routines • Managing 48 HR process of Weekend Maintenance Tools Used: Hyperion Essbase 7/6, HyperRoll 4.2, Hyperion Planning 3.2, Hyperion MDM 9.2, Appworx, EAS, Hyperion Reports, Windows NT, and UNIX. Project 2 GE Capital Solution Jan’06- Oct’06 Role: Hyperion Consultant Danbury, CT Project Description: Capital Solution Hyperion Implementation a Development project is still one of the biggest Hyperion development project in GE, developing Hyperion Database from Scratch, with team size of 8 resources (5 onsite and 3 offshore), Pulling Data from Multiple GL’s cleaning and formatting data in Data staging area then loading in Hyperion. Roles and Responsibilities: • Designed, Developed HyperRoll Closing Cube and Planning Consolidation Cube from Scratch • Designing Feeds from GL’s • Converting Financial requirement into Technical • Developed HyperRoll Definition Files • Developing HyperRoll XML Script • Writing Shell Scripts for Data Cleansing Process • Automating batch processes through Appworx • Setting up Servers Dev, QA and Production for HyperRoll, Essbase and Planning • Created users and user groups and applied security in planning and Essbase • Developed Calc Script, ESSCMD and MaxL Scripts for Batch Processes • Designing and Optimizing Essbase Outline • Developed the data load rules • Developing Web forms • Developing Business Rules • Conducted Load Testing on database and optimized to meet CTQ’s • Managing UAT process, Maintaining Error Log in Test Director • Conducting User Training Sessions Tools Used: Hyperion Essbase 6.5, HyperRoll 4.2, HyperRoll SQL Extractor, Hyperion Planning 3.2, Appworx, HMA, Windows NT, and UNIX. Project 3 GE Commercial Equipment Financial Sep’04 - Dec’05 Role: Hyperion Administrator Danbury, CT Project Description: CEF Hyperion was budgeting forecasting and closing cube. CEF Hyperion Support is RTS engagement, with team strength of 3 (1 onsite and 2 offshore) supporting 14X5. Supporting Closing cube, which was HyperRoll (ASO) cube and Consolidation (Essbase with Planning) Cube where all budgeting and forecasting numbers were uploaded and reported. Roles and Responsibilities: • Designed, Developed and Modified the Outline according to the business requirement • Running Monthly Maintenance with all changes having additions/ deletions/movements • Updating system with business Reorgs • Running Month and Quarter Close process • Making sure Ledger data tie out with Hyperion • Setting up system for Planning Sessions • Developing/Maintaining Business Rules • Developed Calc Scripts and Member Formulae • Optimized Outline and Calculations • Created users and user groups and applied security in planning and Essbase • Creating numerous Planning Webforms • Developed scripts to calculate the database on hourly and nightly incremental Data • Involved in analyzing the financial data and tying it with oracle GL • Created numerous reports using Hyperion Essbase Excel-Add in • Developed the data load rules • Automated the data load process using MaxL, Esscmd, UNIX batches, Appworx Tools Used: Hyperion Essbase 6, HyperRoll 4.2, Appworx, UNIX. Project 4 GE Vendor Financial Services Oct’03- Aug’04 Role: Hyperion Administrator Danbury, CT Project Description: VFS Hyperion was budgeting forecasting and closing cube. VFS Hyperion Support is RTS engagement, with team strength of 2 (1 onsite and 1 offshore) supporting 16X7. Supporting Closing cube which was HyperRoll (ASO) cube and Consolidation (Essbase) Cube where all budgeting and forecasting numbers were uploaded and reported. User base of 250 + users, spread across US, Canada and Asia. Roles and Responsibilities: • Designed, Developed and Modified the Outline according to the business requirement • Running Month and Quarter Close process • Setting up system for Planning Sessions • Automating HQ Submission Process through Batch Processes • Developed Calc Scripts and Member Formulae • Optimized Outline and Calculations • Created numerous reports using Hyperion Reports Tool • Created users and user groups and applied security in planning and Essbase • Developed scripts to calculate the database on hourly and nightly incremental Data • Involved in analyzing the financial data and tying it with oracle GL • Created numerous reports using Hyperion Essbase Excel-Add in • Developed the data load rules • Automated the data load process using MaxL, Esscmd, UNIX batches, Appworx Tools Used: Hyperion Essbase 6, HyperRoll 4.2, Appworx, UNIX. Project 5 GE CFS Feb’03- Sep’03 Role: Hyperion Consultant Norwalk, CT Project Description: CFS Planning Implementation a Development project, Project was to eliminate time consuming and error prone Excel Planning with use of Hyperion Planning. Developing Hyperion Database from Scratch which will be used for budgeting and forecasting, with team size of 8 resources (3 onsite and 5 offshore). Studying Multiple Planning Models and converting them into Hyperion Planning Solution. Roles and Responsibilities: • Studying Various Planning Models and converting them into Technical Specification • Developing Outline • Developing Webforms • Developing Business Rules for Various Financial Calculations across Business Platforms • Designing Planning Security for each business unit as well as for HQ • Designing and Optimizing Essbase Outline • Developed the data load rules • Developing Webforms • Developing Business Rules • Design Business Rule Security • Design HAL Jobs for Maintenance purpose • Automate processes using Esscmd, Maxl and Unix Scripts • Managing UAT process, Maintaining Error Log in Test Director Tools Used: Hyperion Essbase 6.5, Hyperion Planning 3.2, Windows NT, and UNIX. Project 6 GE Capital International Services (GECIS) Jul’02- Dec’02 Role: Technical Consultant Gurgaon, India Project Description: GECIS Enterprise Data Warehouse, GECIS is leading BPO of India now known as GENPACT, Primary objective of Data warehouse to provide in-depth analysis of key Metrics which would help track Client VOC for repeat Business, Reduction in Attrition (1% reduction would have saved $1MM annually), Tracking Collections process, which is one of the high revenue generating process and handled a Team of 20. Roles and Responsibilities: • Studying Heterogeneous source systems including MS SQL Server, Oracle, Excel, Flat File System • Data Warehouse with 4 Data Marts • Developing Informatica Mappings based on Business requirement and system architecture • Developing Workflows to extract, transform and load data in to warehouse • Developing ODS Mappings for warehouse purposes • Preparing System and Unit Test Scripts • Testing entire application for Unit Testing and System Integration Testing • Managing UAT and tracking and closing issues encountered • Rolling out solution on Production environment Tools Used: Informatica 7.1, Oracle 8i, Cognos 7 (PowerPlay/Reportnet) --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "DIRECT CLIENT IT NEED" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/direct-client-it-need?hl=en -~----------~----~----~----~------~----~------~--~---
