NUMAN MIAN

Phone: 1-614-***-****

acz941@r.postjobfree.com

PROFILE:

Oracle Certified Professional having about six years of Hyperion Financial Management, FDMEE, Planning, Essbase, FRS, SQR, Smartview experience with system installations, configurations, data management, data migrations, patching, conducting disaster recovery, up-gradation, administrative & user support and system maintenance.

Involved on load data, extract data, inter-company transactions, journals, process management and created BI and audit reports for business users. Coordinated efforts for financial closings, financial planning, forecasting and budgeting reports.

Worked throughout the System Development Life Cycle (Agile & Waterfall methodologies) from analysis / design / development / testing / integration / implementation / support and user documentation / training.

Microsoft .NET Certified Solution Developer having more than twenty three years of professional systems analysis, system design, system/data architect, technical lead, team lead, development and system/user support experience.

Extensively worked on requirement/ information gathering with SMEs, documenting and prioritizing the user needs. Worked with multiple teams to implement solutions and to resolve issues. Coordination and communication at all levels, all stakeholders (users, SME, project management, business liaisons) to build effective solutions.

Demonstrated creativity, persistence and an ability to work effectively in both self-directed and team-oriented environments.

Strong analytical and problem-solving skills and noted for an ability to grasp new concepts introduced by rapidly changing information technology. Excellent team player and project leader/team leader, have strong communication and interpersonal skills.

EXPERIENCE:

Hyperion Consultant/Support Analyst at NiSource, Columbus, OH June 2011 – to date

As a primary/team/technical lead role to support multiple financial application in multiple environments. Installed, configured, maintained and supported multiple corporate financial applications including Hyperion HFM/FDMEE/Planning (load-balance environments), Longview7, Budgetwiser, Bottomline C-Series systems.

Working with Oracle vendor, installed configured Hyperion System v11.1.2.1 in three environments (development, stage & production [load-balance]).

Actively participated on working with FDM applications, script writing and deployments.

Setup multiple tasks in FDM Task Manager to process in-coming data feeds and files.

Migrated HFM and FDM applications between environments.

Setup user groups and provision users (150+) depending on business units in Shared Services and migrated user security, metadata, financial reports using LCM.

Successfully conducted multiple disaster recovery exercises for multiple applications including Hyperion System, Longview7 in client server and distributed environments.

Coordinated Oracle database migrations for multiple applications from 10g to 11g

Re-configuration for various financial systems including Hyperion System and Longview to accommodate database migrations on new Oracle database servers.

Provided production support (150+ Hyperion users and 100+ Longview users).

Provided Hyperion system maintenance, applied patches, resolve minor/major issues including performance issues.

Worked with Oracle Support to resolve priority issues came across during Hyperion production support since 2011.

Replicated the existing Hyperion System v11.1.2.1 (three load-balance environments) and migrate HFM/FDM applications into CPG domain during company split (CPG sold to Trans Canada)

Worked extensively with multiple IBM teams (Server/Oracle/Network/Storage, etc) to set up new Windows 2012R2 servers and Oracle 12C databases, NAS file shares and setup daily backups for new Hyperion environments v11.1.2.4

Installed, configured, new Hyperion system v11.1.2.4 (3 environments, dev/stage/prod) to replace/upgrade exist Hyperion v11.1.2.1. Applied numerous patches for all components of Hyperion system to bring the system up to date.

Migrated existing HFM applications, EPMA Metadata, BI Reports, User Security, etc. to new environments using LCM, backup/restore, import/export.

Setup new Financial Planning applications and Essbase databases, within the new system to migrate existing Longview planning & budgeting applications.

Coordinated in conversion and migration of existing Longview Planning applications into new Hyperion Planning system v11.1.2.4 and setup user security for different business unit users.

Worked on FDQM/FDMEE scripts modifications using ODI and script migration to other environments. Scripts include data file movement to specific folders, batch data load for single or multiple business units.

Created BI reports/books using Financial Reporting Studio (FRS), Smartview for Excel, SQR and deployed reports in workspace.

Worked extensively on supporting documentation for all of my financial applications for help desk support, system technical docs, application restoration/disaster recovery docs, data flow interfaces (in or out), user documentation, environment diagrams, installation and configuration docs.

Systems Analyst/Team Lead at Falcon Consulting Inc. Ottawa ON Jan. 2007 – May 2011

Inventory Control & Accounting System

Provided a complete analysis & design documentation for a new system development for client/server environment suite of web and desktop interfaces and back-end databases for inventory management combined with internal accounting system.

Lead the team of 4 developers for the development of desktop/web-interfaces/applications in Microsoft Visual Studio .NET 2010. Designed web base reporting system/Dashboard for senior management.

Extensive use of Ajax/SOAP technology. Web Services are used for all the database communication to keep the data layer transparent (client server environment).

MORE EXPERIENCE:

Working with many end clients designed and developed various system/applications

Systems Analyst/Team Lead at Pfizer Inc., New London, CT May 2005 – Dec. 2006

Global Project Management

Systems Analyst at URIX LLC, Cheshire, CT January 2005 – May 2005

UStart v2

Systems Analyst at The Hartford Insurance, Hartford, CT June 2004 – December 2004

Quality Assurance Suite of Applications

.NET Consultant/Team Lead at Imperium LLC, Westport, CT May 2004 – June 2004

StockAnalyzer.NET (Client & Server application)

Systems Analyst at ISI/Master Foods Ltd., Mt. Olive, NJ September 2003 – April 2004

Point Of Influence/Top Account/Sales Org Hierarchy

Systems Analyst at Serono Laboratories, Rockland, MA April 2003 – August 2003

Call Centre Applications (MS Lifelines, Success Canada, Connections for Growth)

Systems Analyst/Team Lead at Pfizer Inc. Groton, CT July 1997 – March 2003

Discovery Decision Support Environment (DDSE - Global Project System)

Pfizer Opportunity Evaluation and Tracking (POET)

Portfolio Management for Worldwide Discovery (PM)

Discovery Resource Utilization and Metrics (DRUM)

Technology Management for Worldwide Discovery (TM)

Systems Analyst at Nortel Inc. Ottawa, ON October 1996 – June 1997

Interactive Information Products

Systems Analyst at Mitel Corp. Kanata, ON June 1996 – September 1996

USB Phone Troubleshooting Utility, Mitel Soft User Guide

Systems Analyst at HRDC, Hull, QC November 1994 – May 1996

Client/Server AppliTouch

Systems Analyst at Canada Post, Ottawa, ON August 1994 - November 1994

Capital Cost Allowance Maintenance System

Systems Analyst at AxxSys Telemarketing Inc. Montreal, QC September 1993 - July 1994

TOUCHÉ (Multimedia Point of Sale Touch System)

CCM Customer Service

Canada Post Flyer Distribution System

Franchise Information System

EDUCATION:

DIPLOMA, COMPUTER PROGRAMMER (2 years)

1993 Algonquin College, Ottawa, Ontario

BACHELOR OF COMMERCE

1985 Punjab University, Lahore, Pakistan

ADDITIONAL COURSES/CERTIFICATIONS:

Oracle Certified Professional (OCP)

Oracle Certified Associate (OCA)

Microsoft Certified Solution Developer .NET (MCSD.NET)

Microsoft Certified Application Developer .NET (MCAD.NET)

Microsoft Certified Database Administrator (MCDBA)

Fundamentals of Supervision (part I and II)

Performance Management / Goal Setting

Software Systems Analysis and Design

Object Oriented Analysis and Design using UML

Hands-On Java Programming

Java for Enterprise Systems Development

Contact this candidate