Tauseef Khan
SUMMARY
**+ years hands on experience in software industry and a wide range of progressive experience in assisting business users with design, development, project management, production support, documentation, budget management and providing BI reports.10+ years of experience in data warehousing, development and administration using Hyperion Essbase 11.1.2.4, OBIEE, FR 11.1.2.4, Planning 11.1.2.4, Interactive Reporting, HFM. Proficient in all the phases of Data Warehousing life cycle, including Extraction, Transformation, Loading, dimensional modeling, reporting and end-user support. Extensive experience in OLAP development, administration, and maintenance in a client-server environment using Hyperion Essbase 7.x/6.x,9.x Hyperion Reports, ESSCMD, MAXL, Essbase Excel Add-In and Smart view, Financial Reporting studio, Web analysis, ODI, EPMA, OBIEE, Business Objects, ASO, BSO, MDX. Strong database development and business-intelligence modeling capabilities. Extensive experience on calculation scripts and Business Rule. Extensive experience on Smartview and Excell-Addin.Excellent understanding of fundamental concepts of Data Modeling, Schema Design, Design of Dimension and Fact Tables. Expertise in implementing Essbase formulas, optimizing database and developing automation scripts. Interacted and provided solutions to business professionals and end users.
Industries:
Public Sector, Manufacturing, Telecommunications, Hotel, Banking
Functional Areas:
Project Management, User-Acceptance Testing, Knowledge Transfer & Training, Financial Planning & Analysis, Financial Reporting, Corporate Consolidations, Annual Budgeting, Accounting, SEC, GAAP compliance, Compensation Metrics, Budgeting & Forecasting, Trouble-shooting & Problem Resolution, System Strategy & Implementation, Process Reviews & Improvements, Business & Operations Analysis
Methodologies:
Systems Development Life-Cycle (SDLC), Agile, Six Sigma, Waterfall
SKILLS PROFILE
Application Package:
Oracle Hyperion Planning, Oracle Hyperion Workforce Planning, Oracle Hyperion Capital Asset Planning, Oracle Essbase, Smart View for Microsoft Office, Essbase Add-In for Microsoft Excel, Oracle Hyperion Financial Data Quality Management (FDM), Oracle Hyperion Financial Reporting, Hyperion Interactive Reporting, Enterprise Reporting, Oracle, TOAD, SAP, Business Objects, OBIEE
Database / DB Tools:
Oracle, SQL Server, Neteza, Teradata, MS Access, People Soft, Lawson
Desktop Tools:
Microsoft Office
Operating Systems:
Windows, Unix,
Other:
Microsoft Project Manager, Visio, Publisher, Adobe,
PROFESSIONAL EXPERIENCE
BI Tech Solutions Inc.
09/15 – Present
Senior Principal Consultant
Designed and developed the complex reporting system, provide end user, system production support and administration for FP&A group.
Responsible for the overall baseline support and on-going maintenance of all environments of the Hyperion Corporate Financial Consolidation System and the Hyperion Planning System 11.1.2.4 budgeting and forecasting systems.
Participated in business requirements for new enhancement of Financial reports and applications and co-coordinating the delivery of multiple projects
Experience in budget planning, reporting, variance analysis, and month-end close process
Demonstrated experience working with formal software life cycle methodologies
Provided financial system support for all Accounting and Finance teams during month-end close
Managed all production Hyperion database maintenance and administration and organized and managed database administration within the company’s network operations Center
Lead performance tuning, execution plan analysis, and statistics monitoring activities operations
Excellent business presentation skills.
Ensure the timely and accurate generation of all corporate internal reporting, consistency and standardization amongst the various types of reports and databases and manage the various reporting tools utilized by the Company
Analyzed, interpreted and reported financial and operational performance trends from various channels & departments, identifying areas performing outside of expected results
Responsible for new data load for month end process
Responsible for all management, Corporate and Budget books.
Worked closely with multiple levels of the organization including management teams to support key systems, implement infrastructure improvements and ensured business units are able to operate efficiently and effectively.
Demonstrated experience interfacing and collaborating with peers, management, vendors, and other departments.
Communicating status and vision to client management and stakeholders
Change management and training of client staff for a successful deployment of the new process and system
Environment: Hyperion Essbase V 11.1.2.4 EMPA, Hyperion Planning, Oracle, Smart View, Excel Add-In, Hyperion Financial Reporting, UNIX, SQL Server, OBIEE
Ntt Data America Inc.
Client: Bio Marin, Wegmans
11/12 – 08/15
Senior Principal Consultant (Hyperion/OBIEE)
Provide production support for Hyperion Planning, Essbase, and Financial Reporting.
Work with functional team on enhancement of existing process for improvement..
Create financial reports, planning web forms and excel templates on Smartview.
Work on change management system, create test scenarios for UAT and move to production.
Hands on experience on Loading Metadata and data, using outline utility, ODI, rule files, and sql views.
Schedule monthly variance reports and trend reports using workspace with the bursting option,
Covert Classic application to EPMA for Long Range Planning.
Create composite form for better view after data submission.
Translate strategic business needs into practical consolidations and reporting solutions
Define systems strategy; develop systems requirements; design, prototype, implement and launch solutions
Create necessary project plans during client design sessions
Proactively and frequently communicate with customers to build and maintain a solid working relationship
Design and build required reports using Hyperion reporting applications including Smartview
Write and maintain clear, concise functional and technical specifications on HFM applications and business system processes
Optimization of HFM, Planning an Essbase applications
Maintain security of the system using shared services for all the components.
Support users for their Smartview and excel add-in issue.
Maintain and monitor nightly backup process and weekly maintenance.
LCM used for migration on ad-hoc basis for application artifacts, security.
Lead onsite and off-shore team for Hyperion.
Create Business rules and calculation scripts for allocation, forecast, aggregation etc.
Hyperion database maintenance and optimization (Calc scripts, outline, reports)
Worked extensively with Physical Layer, Business Layer and Presentation Layer.
Created numerous executive level reports. 'Dashboards' were generated to provide insight into the financial data.
Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
Created different types of Customized Reports Drilldown, Aggregation to meet client requirements.
Built Business model and established relationships & Foreign Keys Physical & Logical between tables.
Created business reports using BI Answers as per requirements.
Generated various Analytics Reports using global and local filters.
Identified the aggregate levels for each source and created dimension sources for each level of aggregates.
Added users and configured security in web logic console of OBIEE 11g.
Managed security privileges for each subject area and dashboards according to user requirements
Assembled subject areas and created execution plan and accommodated the new metadata mappings.
Trained End Users and Pilot Users about OBIEE Tools.
Create disaster recovery guidelines for Hyperion and relational database.
Create Out of the box application for Hyperion workforce planning and Capex module.
Environment: Hyperion Essbase V 11.1.2.1 EMPA, Hyperion Planning, Workforce Planning, Capex, Oracle, Smart View, Excel Add-In, Hyperion Financial Reporting, Window Server 2008, VM, Citrix, Oracle, Oracle EBS, SQL, OBIEE, HFM
Bi Tech solutions Inc
Client: Black & Decker, Federal Reserve Bank, Hilton Hotel
Manufacturing, Banking, Hotel
Principal Consultant(Hyperion/OBIEE)
07/08 – 11/12
Worked with the Architecture for Financial Application using Hyperion Essbase and gathered functional requirements for modification on current system. Worked with the finance team for their budget and monthly estimates process. Effectively trained end users for Hyperion Essbase, OBIEE and Smart view. Responsible for the coordination and project management. Provide a smooth transition, knowledge transfer, UAT and training within the integration timeline. Complete SDLC and provide production support. Create multiple cubes in ASO and BSO.
Hyperion Essbase, Hyperion Planning Installation, Configuration Upgrade from 7.1.6 to 9.3 to 11.1.3.
Responsible for complete SDLC until production support. Build, Design, configure Hyperion Essbase Architecture for Financial Application.
Gathering functional user’s requirements for modification on 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.
Create disaster recovery guidelines for Hyperion and relational database.
Maintain data flow, create test scenarios for UAT.
Create Financial Reports, (Trend reports, Variance reports, Qtr spending reports)
Automate financial reporting through workspace using bursting option.
Create Project Plan for Black & Decker financial System upgrade.
Involved in reporting and analysis requirements, documenting the reports specifications, implementing the metadata layers including Physical, Business Model and Mapping and Presentation layer.
Upgrade and migration of OBIEE between dev/test/prod environments.
Proficient in defining Key Performance Metrics (KPIs), facts, dimensions, hierarchies and developing StarandSnow Flake schemas.
Expertise in design and development of the three layers(Physical/Business Model and Mapping/ Presentation)of an OBIEE Metadata Repository (.rpd) using Oracle BI Administration Tool.
Highly skilled at configuring OBIEE Metadata Objects including repository, variables, interactive dashboards, and reports.
Experienced in designing customized interactive dashboards in OBIEE using drill down, guided navigation, prompts, filters, and variables.
Expert in using OBIEE Answers to create queries, format views, charts, and add user interactivity and dynamic content to enhance the user experience.
Experienced in working with Variable Manager to define session and repository variables and initialization blocks to streamline administrative tasks and modify metadata content dynamically.
Proficient in Installation, configuration, and administration of the OBIEE platform.
Experienced in developing Dimensional Hierarchies, Level Based Measures, and adding multiple sources to business model objects.
Cost Allocation and derived Budget by formulas.
Create Reporting package, which include Budget and Monthly Estimates on Financial Reporting studio.
MDX formulas for financial database. Conversion of BSO cube to ASO.
Transparent portioning for ASO and BSO cube.
Support Finance user with their Excel Add-In, lock and send and access issues.
Create Automation process for daily backups, weekly maintenance, daily loads.
Build dimension and load data using rules file.
Environment:
Hyperion Essbase V 11.1.1.3, EMP, HFM, Oracle, Smart View, Excel Add-In, Hyperion Financial Reporting,
Window Server 2003, VM, Citrix, Oracle, OBIEE, Upstream.
Client: FDA (Deloitte)
Federal Services
Senior Specialist Consultant (Hyperion/OBIEE)
05/10 – 06/11
Responsible for the scoping, design and delivery of data migration, model development, and reporting. Solicited user requirements with system stakeholders. Designed and built Hyperion Planning, Performance Scorecard, and Financial Reports
Responsible for the scoping, design and delivery of data migration, model development, and reporting. Solicited user requirements with system stakeholders. Designed and built Hyperion Planning, Performance Scorecard, and Financial Reports.
Automation process for daily backups, weekly maintenance, daily loads.
Create Business Rules, Calculation script, for financial process.
Working on Payroll application and provide end user support.
Hands on experience on Hyperion Server Migration for system 9.3.1 which includes installation, configuration, testing.
Gathering user requirments for re-organization.
Maintain Hyperion planning payroll application and essbase application.
Maintain Hyperion shared services for security and assign access to Hypeiron Planning.
Import and export of data, security, application.
Enhancement of Financial Reporting structure.
Created/modified Metadata repository using the OBIEE 10g's Physical, Business Model and Mapping and Presentation Layers.
Collaborated with Business Analysts, discussed and identified the analytics requirements to be obtained from various user groups.
Created star schemas in the repository. Used the foreign key link in the physical layer and the new complex joint key in the Business Model and Mapping layer to form relationships between fact and dimensional tables.
Communicated directly with the stakeholders to gather detailed requirements for business components, data interfaces, security and reporting through working sessions, walk-thru sessions and business process descriptions.
Facilitated and documented the business requirements
Evaluated information harvested and created the functional requirements documentation for application development.
Environment:
Oracle's Hyperion Planning, Hyperion Essbase, Financial Reporting Studio, HAL, FDM, Web Analysis, Windows, OBIEE
Client: Catalina Marketing
Marketing
OBIEE Hyperion Consultant
04/08 – 07/08
Upgrade to Oracle Hyperion System 9.3.1 for Hyperion Planning, Essbase and Financial Reporting. Responsible for the coordination and project management between the internal and external project team members, providing training and knowledge transfer within the timelines.
Upgrade Essbase 9.2 to 9.3, migration of Essbase application, database, and reports.
Create new reports for revenue analysis using Financial Reporting studio and Interactive Reporting and dashboards.
Working on ASO and BSO cube for financial database.
Using Maxl script for automation, and create Bath Files for Backups, Building Dimensions, loading data, and executing calc script.
Working on budget, revenue, salary and commission Applications.
Maintain Application Security; assign users on shared service environment,
Loading data and build dimension using rules files, EIS, and HAL process.
Create Reporting and Application documentation for end users.
Hyperion Planning Application Capex module and workforce for their budget and Planning Application.
Calc script and business rules for budget application.
Maintain Hyperion Planning/Essbase security.
Installation and Configuration system 9.3.
Environment:
Essbase Integration Services, System 9.2 Essbase, Smart View, HAL, Neteza, Redbrick, Web Analysis, Financial Reporting, Interactive Reporting, Oracle 10, Hyperion Planning, Lawson, AIX, Web sphere, Oracle 10g, MS Access
Client: EchoStar Satellite LLC 08/07 – 11/07
Telecommunication
Oracle Hyperion Developer Consultant
Upgrade to Oracle Hyperion Interactive Reporting 9.3.1. Gather user requirements and create new cube for supply chain department. Interact with client and provide solutions for HR database which calculated number of hrs for each employee.
Designed, developed, and implemented Cube for Item Transaction and Reporting System for the Supply Chain Department using EIS, for better decision-making for Top Management. Complete SDLC with short amount of time.
Create ASO cube for supply chain department and create MDX formulas.
Involved in gathering requirements and developing a project plan for Finance Department
Created Dynamic reports by using Interactive reporting based on the user requirements.
Created Outlines, Calc script, Load Rules for General Ledger using Essbase System 9 Application
Database applications Using Essbase that stored and maintained company Financial, operations, Employee, and Sales data, and also data loading and Manipulations into the database.
Created reports (POV, Prompt in a Page, Page) based on the user requirement using Financial Reporting Studio, Web Analysis and Dashboard (Demo)
Created Calc scripts using the Calc script editor for performing calculations.
Maintained security and added/deleted users per management requests.
Developed several Reports for Hyperion, validating and reconciling data using Interactive Reports and Smart View
Convert Oracle Reports from RDBMS to Multidimensional Database through EIS by creating OLAP MODEL and Meta outline
Used both Block storage and Aggregate Storage.
Convert Business Object universe to Essbase cube.
Maintain Hyperion Planning/Essbase security.
Installation and Configuration system 9.3.
Environment:
Essbase Integration Services, System 9.3.1 Essbase, Smart View, TOAD for Oracle, Teradata, Dashboard, Web Analysis, Financial Reporting, Interactive Reporting, Oracle 10g,
Brio, Visual Studio, MS Access, Business Object.
Client: XM Satellite Radio 04/07 – 05/07
Telecommunication
Hyperion Consultant
Create Hyperion reports form Hyperion Planning and Essbase, Calculate churn for monthly reports. Working with end users for their new requirements during transition period.
Involved in troubleshooting, Performance tuning and Performance monitoring.
Created customized and ad-hoc reports using Excel spreadsheet add-in
Creating and calculating Subscription Acquisition Cost (SAC) Reports for Management
Developed various management web Reports using Hyperion Reports and scheduled the reports
Extensively involved in using Hyperion Reports, Analyze and Brio (Interactive Reporting)
Provided technical support to business units and end users
Retrieved data in Excel for the analysts and other end users for the purpose of forecasting and analysis
Identifies the report as being either Fully Automated, Automated with Manual Adjustment,
Produce Monthly, Quarterly, and Trended SAC Reports
Create Snap Shot, Books on Workspace
Environment:
Hyperion Essbase 6.5.2, Hyperion Reports, ESSCMD, Excel Add-In, Windows NT/2000, Lawson G/L, Crystal Reports, Hyperion Planning. Brio
ComInfo
Client: Cable and Wireless, Capitol One 02/04 – 03/07
Telecommunication, Banking
Hyperion Developer
Designed Expense Planning and Report System for the Financial Department using Hyperion Planning. Gathered the user requirements and developed an effective project plan. Developed several reports for Hyperion, validating and reconciling data using Hyperion Reports. Responsible for the coordination and project management between the internal and external project team members, providing training and knowledge transfer within the timelines. Develop Essbase application for finance department.
Designed, developed, and implemented Expense Planning and Reporting System for the Financial Department using Hyperion Planning,
Involved in gathering requirements and developing a project plan.
Created forms based on the user requirement using Hyperion Planning.
Created Business Rules, using Hyperion Business Rules, to attach the forms in order to facilitate the business process
Database applications Using Essbase that stored and maintained company Financial, operations, marketing, and Sales data, and data loading and Manipulations into the database using the Hyperion Application Link (HAL).
Created reports (POV, Prompt in a Page, Page) based on the user requirement using Hyperion Reports and heavy use of brio..
Maintained security and added/deleted users per management requests.
Developed several Reports for Hyperion, validating and reconciling data using Hyperion Reports.
Created applications, databases and data outlines using Essbase Application Manager with excellent balance of dense and sparse dimensions, arranged in an hourglass fashion
Involved in defining requirements, functional specifications and transformation rules
Developed calc scripts for allocations, eliminations, moving the data, calculating formulae etc depending upon the business case
Developed Report Scripts for extensive reporting in Report Extractor.
Environment:
Hyperion Planning, Hyperion Essbase, Microsoft Excel Add In 2000, Hyperion Business Rules, Hyperion Application Link, Hyperion Reports, MS SQL Server 7.0, and Windows 2000 Server
EDUCATION
BS Computer Information System
2002
NED University
Karachi, Pakistan
Work Status:
US Citizen