Safdar Khan
***********@*****.***
SUMMARY:
> More than 6 plus years of IT experience in design, analysis, and
development of various applications in Client/Server OLAP environment
using Hyperion Essbase, Hyperion Planning, Hyperion Integration Services,
Hyperion Reports, and Hyperion Business Rules .
> Experience as Planning admin, Analysis & Design, Maintenance, Database
backups, Performance tuning, Optimization, Forms and design.
> Strong implementation, enhancement, support experience on Hyperion
Planning & Essbase applications to facilitate global financial planning
and analysis.
> Experience includes good working knowledge on Hyperion Planning and
Essbase, Financial Reporting, and Web analysis
> Business process improvement, financial management, Hyperion
Implementation Support for Essbase, Planning, Hyperion reports, Hyperion
smart view.
> Worked on several financial projects with different responsibilities
include creating Essbase Cubes, Developing Hyperion Planning
applications, Developing Reports, Training Users, and creating User
Manuals.
> Worked with different clients with various backgrounds includes Banking,
Financial,Oil& gas.
> Extensive experience in building reports using Financial Reporting Tool,
Hyperion Web Analysis and Interactive Dashboards with drill-down& drill-
across.
> Have Knowledge of EPMA and its related modules .
> Experience in Software Development Life Cycle (SDLC) that include duties
like providing documentation on design, testing, and migration from
development to production.
> Highly organized with proven ability to prioritize, manage multiple
tasks, and meet deadlines with deliverables.
> Strong team management skills on highly complex projects and experience
in managing cross-functional teams across various geographies.
> Administered employee professional growth management - able to motivate
and maximize productivity of employees.
TECHNICAL SKILLS:
OLAP Hyperion Essbase System 11.X/9.X, Hyperion Planning 11x,9.X,
Expansion Essbase Integration Services, and Essbase Administration Services.
Tools
Reporting Hyperion Web Analysis 9.3.1, Brio 6.x,, Smart View, Hyperion SQR,
Tools Financial Reporting, Hyperion spreadsheet Add In, Smart VIew
Databases Programming SQL, PL/SQL, Oracle EBS11i, R12, Oracle 9i, Oracle
10g, Oracle 11i, SQL Server.
EDUCATION:
Associate in Business Administration
Bachelor of Science in Business Management
Hyperion 11i Fusion Edition experience
CERTIFICATION:
Essbase 11i Administrator Certified Expert
Hyperion Planning 11i Administrator I & II
Certified Expert
PROFESSIONAL EXPERIENCE:
Company: Oasis Holding
Customer: Avon Inc, Bank of America, Dell, Techumshe
Period: July 2006 - Mar 2013 (Multiple Projects)
Role: Hyperion Consultant
> Implement Hyperion 11.1.x versions and also involved in upgrade to
latest Hyperion versions.
> Worked as admin to manage security, application deployment, Meta data
maintenance, reports and forms design and user supports
> Developed calc scripts for performing calculations, batch scripts for
automating Essbase applications and load rules for loading flat files
such as *.csv, *.xls, *.txt.
> Installed and configured Hyperion Analyzer/ Hyperion Reports and
created user accounts in it.
Migrated reports into latest version.
> Prepared quarterly forecasts, annual budget, ad-hoc reporting and
management reports in Hyperion Analyzer/ Hyperion Reports by working
with the business managers
> Responsible for designing and implementing the security of Hyperion
Planning Application.
> Was responsible for the Design and Development of planning
applications, ASO reporting cubes, financial reports and dashboards
using Hyperion Interactive Reporting.
> As Hyperion Planning Techno-Functional resource gathered requirements
and documented all the requirements in Functional Design Documents and
Technical Design documents.
> Very good knowledge of Budgeting, Forecasting, Financial planning,
Balance Sheet, Income Statement,P&L Statements, Cash Flow Statement
and Human Resource management.
> Created Planning Applications to manage all their Budget, Forecast and
Financial planning using Classic planning application.
> Created custom dimensions along with default dimensions in Hyperion
Planning and Workforce Planning as per the requirement.
> Used all 5 databases in planning application each for Revenue, PnL,
Balance sheet, Capital and Workforce data..
> Developed Webforms for both Budget and Projections for users to enter
data in the input members in the outline.
> Developed composite webforms and used smart lists, Task lists and
Menus as per the user requirements.
> Designed and developed various types of reports (Pivot, Tabular, and
Chart reports) to be used by different user groups using Hyperion
Interactive reporting.
> Created Data model for the End users and scheduled the IR reports from
the Workspace.
> Used various conditional, date, data, numeric functions to add
computed columns in query, result, pivot and report sections.
> Migrated Planning Applications, Interactive reports and Web Analysis
reports from one environment to another environment.
Company: Zaman & sons inc.
Period: Dec 2000 - Mar 2006
Role: Accountant
> Provided accurate preparation, analysis, and reporting of financial
performance. .
> Proficient in management of accounts payable, accounts receivable,
financial reporting, and account reconciliations.
> Exceptional financial analysis skills.
> Responsible for streamlining office functions to automate systems,
enhance productivity, and maximize financial control.
> Analyzed situations effectively and provided innovative solutions.
> Very good knowledge of Financial Reporting, Accounts Payable/
Receivable, Payment Processing, Inventory Count/ Value, Financial
Statement Preparation, Journal Entries, Sales Costs/ Profits, Month
End Reporting