SUMMARY:

• Overall 14 years of IT experience and 8 years of experience as a Hyperion Essbase developer, with extensive knowledge of Hyperion Planning and Essbase.
• Extensive experience in developing ad - hoc reports required for business needs using Hyperion Reports and Hyperion Analyzer.
• Strong background in writing custom Essbase Calculations Scripts and complex business rules.
• Strong knowledge-base of business requirements and software development cycles in the Hyperion environment.
• Expert in automation of Hyperion planning and Essbase dimension build and data load.
• Experience in optimization of Hyperion Essbase to decrease execution time and improve performance.
• Extensive experience in creating and developing Hyperion planning web forms.
• Extensive experience with SmartView integration of Hyperion and Confidential Office.
• Experience implementing security and granting role-based permissions to users, based upon business requirements.
• Extensive experience in troubleshooting computer problems and network issues.
• Experience with VBScript in Confidential Excel.
• Created database to record medical case logs, including capturing data on specimens, images, and diagnoses.
• Designed and developed multiple business websites, integrating with client-end needs.
• Versatile team player with excellent analytical, presentation and interpersonal skills with an aptitude to learn new technologies.
• Solid time management and multitasking skills, which help in conducting project meetings, reviews, walkthroughs, and customer interviews and user trainings as required.
• Excellent written and oral communication skills and a team-player with a results-oriented attitude.

TECHNICAL SKILLS:

• Proficient in Hyperion Planning and Essbase development and implementation
• Proficient in C, C++, HTML, JavaScript, Visual Basic, Visual Basic Script (asp), Basic, AutoHotkey, and web design
• Have built multiple PC’s, including full hardware and software installation
• Advanced Windows knowledge
• Extensive experience and knowledge of Word, Excel, PowerPoint, Access, OneNote
• Optimization of Windows to ensure fastest and most efficient output
• Troubleshooting of most problems
• Use with AutoHotkey to automate several processes and make overall use easier
• Have set up home and business internal networks
• Work experience with troubleshooting computer problems and implementing solutions
• Have trained Brazillian Jiu-Jitsu
• Mixed martial arts enthusiast and analyst

PROFESSIONAL EXPERIENCE:

Confidential, Rochester Hills, MI

Hyperion Essbase Specialist

Responsibilities:

• Acquired a detailed knowledge of project environment business processes.
• Gathered requirements from stakeholders and prepared business requirement documents.
• Setup backups of the Essbase database and restored the Essbase application whenever required.
• Created Load rules for Dimension Building and Data Loading into the Hyperion Cube.
• Developed Calculation Scripts for aggregating data based on the business requirements.
• Utilized dynamic and two-pass calculations, user-defined attributes (UDA), member formulas, and XREF functions for cube aggregation.
• Optimized and fine-tuned the Essbase application in order to decrease calculation times.
• Automated the monthly loading process using MaxL and Shell Scripts.
• Created reports required for the business needs using Hyperion Financial Reporting.
• Developed Business Rules to facilitate user data aggregation based on their input.
• Worked with users in troubleshooting computer and network issues.
• Responsible for user security, application and server maintenance.
• Utilized Confidential SmartView add-in and worked with users to troubleshoot issues.
• Documented technical and functional issues for user and administrator reference.
• Attained a strong knowledge-base of business requirements and software development cycles in the Hyperion environment.

Hyperion Essbase Developer

Responsibilities:

• Responsible for the Essbase applications, as an application administrator
• Created alternate hierarchies to enable visibility for balance sheets and income statements.
• Created Hyperion financial reports to fulfill client-reporting requirements, such as variance analysis.
• Performed application development tasks using Hyperion Essbase
• Implemented security based upon business requirements and granted role-based permissions to users.
• Created Load rules for building dimensions and loading data into Hyperion Cube.
• Created a partition to transfer data portions from one Essbase cube to another, significantly improving performance.
• Used Essbase Administration Services for filter creation, user creation, group creation, migration of cubes, and maintenance of Essbase Servers.
• Utilized Confidential SmartView add-in and worked with users to troubleshoot issues.
• Acquired extensive experience in writing Member Formulas and Calculation Scripts.
• Acquired extensive experience in developing Hyperion planning web forms.
• Created scripts for tax and benefit calculations, and reports for head count & expenses.
• Designed, created, and developed web-forms in Hyperion planning and provided user security.
• Installed and automated Essbase utilities to simplify user/supervisor interaction with Essbase cubes.
• Automated forecast closing processes and other monthly maintenance activities.
• Developed functional and technical documentation for Essbase cubes and financial reports.

IT Specialist

Responsibilities:

• Created database to record case logs for all the residents, capturing data on specimens, images, and diagnoses.
• Used VBScript in Excel to automate scanning of the schedule and identifying relevant cases.
• Used AutoHotkey to automate data entry into the pathology database system used in the hospital.
• Used and became familiar with Centricity and Citrix for accessing patient records.
• Troubleshot computer problems for all pathology residents, and created an internal network for resident computers.
• Generated documentation on autopsies, microbial cultures, cell cultures, blood typing, and gel electrophoresis.

IT Analyst / Lab Supervisor

Responsibilities:

• Created a database of all chemicals, reagents, and tools used in the lab, and updated as needed.
• Created a database of templates used for specimen descriptions, and updated as needed.
• Supervised the technical component of the lab, including grossing, staining, and computer imaging of slides.
• Generated documentation on biopsy and cytologic specimens, including examination, immunostaining, and computer imaging of glass slides.
• Gained valuable experience with working in a private laboratory, working first hand with immuno-stainers, ThinPrep machines, Cytospin, allowing me to further expand my technical knowledge.
• Installed and setup a microscope/camera system with computer interface, enabling electronic imaging of glass slides.
• Set up internal network in order to share templates and other data.
• Troubleshot computer hardware, software, and network problems.

Research / IT Assistant

Responsibilities:

• Worked with and programmed in several languages, including C, C++, JavaScript, Visual Basic Script, HTML, SAS, as well as Confidential Word, Excel, PowerPoint, etc.
• Developed a parser, which scanned through and selected various variables and data points from a database, compiling them all into an easily accessible document.
• Attained skills working in social research environment, examining incomes and demographic data, for use by economists, lawmakers, and the public.