Imran Hussain

PROFESSIONAL SUMMARY:

An IT professional with 15+ years of experience in techno-functional roles in the telecom and financial industry. Five years of implementation and support experience in Oracle EPM (Hyperion) On-Prem and Cloud technologies for consolidation, financial budgeting, forecasting, and reporting applications. Excellent interpersonal skills, ability to work well with others in both supervisory or support staff roles. I am looking for a professional position within an organization that utilizes creative, organizational, and team skills with supplemental multicultural experience to increase productivity, market position, and profitability.

TECHNICAL SKILLS:

Advanced Word, Excel, PowerPoint, Access, Hyperion Essbase, Hyperion Planning, OBIEE, Smart View, SQL, Windows, Oracle, SQL Server, BI Publishers, Answers, FDMEE, PBCS, Financial Reporting, Dashboards, NetSuite, Map-info, TEMS Investigation, Asset, OptPcs, Actix Spotlight, Schema, Advanced Word, Excel, PowerPoint, Access, Arieso

EDUCATION:

1999 BS (Computer Engineering) from Sir Syed University of Engineering & Technology,

Karachi, Pakistan

2003 MS (Computer & Information Systems) from the University of Detroit Mercy,

Detroit, MI, USA

PROFESSIONAL EXPERIENCE:

Oct 2020 – Present

Oracle Hyperion PBCS Administrator

BI Tech Solutions - VA

Gather business user requirements for planning, budgeting and forecast processes.

Implemented Oracle EPM PBCS application with NetSuite for revenue and budget model.

Performed Month-end processes that included structure updates (Metadata load), data loads, validations, run reports.

Created test scripts, business rules for various validations.

Created an end-user training document and user manuals for various business processes, workflow for financial systems.

Created Financial reports and dashboards out of data forms for visualization.

Data analysis using ad-hoc queries in Excel SmartView.

Provided technical support to business units and end-users.

Created and maintain documentation for month-end processes. Create Business Rules for allocations, aggregations using Smart lists.

Configure Data Management (FDMEE) with NetSuite for PBCS application.

Created Financial Reports (Income Statement, Balance Sheet, Cash Flows, Expense reports, Variance reports).

Aug 2018 – Sep 2020

Oracle Hyperion EPM Developer / Administrator

GTA – Sprint, Reston VA

Involved in gathering business and functional requirements from varied users in a detailed business meeting and translating them into designed specification documents.

Worked on Hyperion Planning on Prem / Cloud environments to support complex financial applications for budgeting and forecasting.

Implemented Oracle EPM cloud solutions ( Workforce, Financial module ).

Integrate data from Oracle EBS, Workday and other systems.

Data integration and Dimensions member mapping in FDMEE on prem version.

Designed, developed, tested, and deployed a Hyperion Planning Application in Hyperion Workspace.

Responsible for data load for the month-end process, Load planning data through FDMEE/Data management.

Involved in loading metadata to Planning using Outline Load Utility.

Responsible for creating the Web Forms / Data Forms in Hyperion Planning to assist the users in successfully encapsulating accounting changes related to forecasting, Budget, actual, and other data.

Developed Task Lists, Work Flows, Menus, and Business Rules with an option for Run-time prompts.

Successfully migrated Financial Reports from Development to Production.

Defining/Designing the security roles based on business requirements by creating users, user groups, and filters to control data access in specific areas of Essbase and Planning Applications.

Used LCM (Lifecycle Management Utility) to migrate applications from one environment to another.

Extensively involved in designing and modifying the outlines for Aggregate Storage (ASO) & Block Storage (BSO) cubes in Essbase.

Optimized data loads' performance, calculations of Essbase cubes, changing dense/sparse settings, and other techniques.

Involved in Automation of the Reports to run in PDF and HTML formats and send attachments to people across the business.

Create and manage applications in OAC, PBCS, EPBCS, FCCS manage smart push jobs and data mapping.

Create a cloud instance for PBCS applications.

Responsible for the overall baseline support and on-going maintenance of all Hyperion Corporate Financial Consolidation System environments and the Hyperion Planning System budgeting and forecasting systems.

Install and configure Hyperion Essbase and planning applications, manage Hyperion infrastructure.

Install patches, upgrade to the latest Hyperion on-prem version.

Automate the process using EPM automate for the data load process and nightly backup.

Metadata - Added Accounts, Entities, and Custom Dimensions to Hierarchies.

Created multiple Hierarchical Rollups for both entities and accounts, including account hierarchies.

Engaged with IT partners to meet business needs including collaboration with support resources, interface and IT teams.

April 2018 – July 2018

Financial System Analyst

Conure Telecom - AT&T, San Francisco, CA

Performed data query, extraction, compilation, and reporting tasks.

Create Financial Reports (Income Statement, Balance Sheet, Cash Flows, Trend reports, Variance reports, Qtr. spending reports).

Involved in maintenance of web forms for data input for income statement accounts, balance sheet accounts, drivers, stats accounts, and actual adjustments.

Create SQL queries to run reports for data analysis and validation purposes.

Managed, updated, and manipulated report orientation and structures using advanced Excel functions, including Pivot Tables and V-Lookups.

Handled data collection, analysis, interpretation, and presentation to management and other team members gathered via a wide range of available means and methods from users and business partners.

Analyze financial statements and internal cost accounting records of manufacturing enterprises in terms of ratio analysis and account balance reconciliations.

Developed and maintained financial statements using Microsoft Excel, Tableau and Hyperion financial reporting studio to provide financial statements and reports to management.

January 2015 – February 2018

Hyperion Planning Developer / Administrator

Amdocs Inc - AT&T, Herndon, VA

Responsible for the baseline support and on-going maintenance of all Hyperion Planning budgeting and forecasting applications.

Implemented Hyperion Planning and Essbase for expense and revenue model.

Participated in business requirements for new enhancement of Financial reports and applications.

Created Hyperion reports for variance analysis and batch processes automation.

Managed all production Hyperion database maintenance / administration and organized, managed database administration.

Automate the process using PowerShell and Maxl for the data load process and nightly backup.

Maintain the security of the system using shared services for all the components.

Support users for their Smartview and excel add-in issues.

Maintain and monitor the nightly backup process and weekly maintenance.

Gathering functional user's requirements for modification on the current system with new features.

Working with Finance team for their Budget and monthly Estimates process.

Hands-on experience on Oracle Hyperion Essbase optimization, data flow, security, create new calc scripts.

Loading data and build the Essbase dimension using rules files.

Created documentation for reporting applications for end-users.

Created simple and composite web forms for data input and validation.

January 2014 – December 2014

LTE Optimization Engineer

AT&T Mobility, Wisconsin Market

Managed LTE Ericsson & ALU projects with vendor and carrier's Project Managers

Responsible for LTE optimization in Wisconsin Market

Overseeing pre and post launch optimization activities

Supervising market wide pre and post launches of Clusters & SSV's

Responsible for reviewing cluster / SSV drives and KPI reports with the vendor; proposing and implementing parameter, tilt and optimization changes to achieve optimum performance prior to final approval for launch

March 2010 – December 2013

UMTS Optimization Engineer

AT&T Mobility, Wisconsin Market

Responsible for 3G optimization in Wisconsin market.

Monitor the trend and performance of UMTS sites using CNN.

Post processing of the GWS drive test data using OptPCS by addressing the drop calls and call setup failures in the market.

Analysis of RSCP, Ec/No and Pilot pollution by using OptPCS.

Proposing the EDT and CPICH power changes for areas to improve RSCP and Ec/No using Schema tool.

Responsible for neighbor additions / deletions and priority changes in the market using OSS.

Meeting the KPI targets for the market by addressing the CS/PS accessibility and retainability issues.

December 2008 – December 2009

UMTS Optimization Engineer

T-Mobile USA, Philadelphia Market

Part of the team responsible for Pre & Post Launch 3G Optimization.

Post processing of the drive test data using Actix Spotlight.

Analysis of RSCP, E.C./No and S.C. plots in Actix Spotlight.

Investigation of weak RSCP, pilot pollution and missing neighbor issues.

Detailed analysis of drop calls and call set up failures in TEMS.

Analysis of single cell coverage, Azimuth Verification, Coverage Optimization and IRAT handover Optimization.

November 2007 - November 2008

RF Engineer

T-Mobile USA, Philadelphia Market

Responsible for the 2G Performance & Optimization of four Clusters in the area.

Optimize and troubleshoot the issues which are bound to affect the network such as Dropped Calls, Blocked Calls, Traffic and Handover Failures.

Responsible to improve the Network performance by working on different KPI's as MOU/drop; Net Access Failure Issues and top dropper sites.

November 2005 – October 2007

RF Engineer

T-Mobile USA, Washington DC Market

Optimize 2G network using system performance indicators such as Dropped Calls, Call Quality, Blocked Calls, H.O. failure and Missing Neighbors.

Responsible for Designing the network and bringing new sites On-air.

Responsible for Site Justification Packages justifying the need of the new site for the network.

Contact this candidate