Summary of Qualification:

10 years experience in Information Technology field including marketing and analysis skills.
Successful in meeting new technical challenges and find solutions to meet customer satisfaction.
Dedicated, professional, hard working and posses positive communication skills.

Certificates & Training:

Training on IFIS Oracle AP, GL, PO, PA modules from MGS.
Training on Treasura reporting and Crystal Reporting from Thompson Routers.
Essbase Cube Analytics 9.3.1Bootcamp Training from Oracle University.
Trained on Hyperion/Brio Reporting/Administration from Enbridge Consumer Gas.
Trained on Discoverer Plus 10g, Discoverer Administrator Government Services Ontario.
Trained on GIS system- MapPoint, SAS and Data warehouse from Direct Energy.
Exchange Server and SQL Server 2005.
CompTIA A+ certified, MCSE (Microsoft Certified Systems Engineer)
OBIEE 301- Dashboard/Report Application Development Training from BIGG University.

 Technical Skills

Programming Languages : Visual Basic, C, C++, SQL, COBOL, and HTML, JavaScript, SQR Scripting.
Reporting Software Tools : Hyperion Reporting 8.3, Hyperion Planning, Hyperion Analyzer, Oracle Discoverer suite 10g, Treasura Reporting Manager, Microsoft Reporting Services, OBIEE, Crystal Reporting, Essbase Cube, Essbase Application Manager 6.5, Brio Enterprise Server Administrator Tool, Brio Query Designer Application, Brio Explorer, EFS Portal, Brio One Administrator Tool
Operating Systems : UNIX/ LINUX (Bash Shell/Fedora 6), Windows NT/2000/XP/vista/2000/2003 server
Software Tools : Microsoft Office Suite, Microsoft Project, Visio, Lotus Notes R5, MapPoint, Print Audit 6 Administrator, Netscape 4.7/ Internet explorer, Tivoli Desktop, WinRunner, Remedy, Toad for Oracle v8.5.1, Clarify Client 8.5SR2, Smarterm Telnet, Adobe Acrobat 4.0/5.0, Adobe Photoshop CS, PC Anywhere32 v.8/ v.9
Databases : MS SQL, MySQL, SAS, Access, Essbase Cube

Work Experience

Confidential, (December 2011 – June 2012) Toronto, Ontario
Oracle Business Intelligence Analyst

Currently as part of the Business Intelligence team my duties are to enhance and provide solutions to any problem tickets, analyze business risk, data fix or change requests regarding existing Discoverer reports; gather business requirement for new reports from IFIS stakeholders, testing reports and attend the user forum to present the user group with the new reports, get user feedback to meet their expectation. Besides developing reports, my tasks also require working on developing and enhancing functional, technical design documentations, quality assurance documentations, test scripts to maintain the standard of the organization. My recent assignment was to document and capture the technical design and business process of the new portal and created discoverer reports that provide Ministry of Aboriginal Affairs with the expenditure analysis reports and ability to maintain vendor information efficiently. My future project involves enhancing the portal and reports on Phase 2 for Ministry of Aboriginal Affairs. I have been recently involved in testing the Enhanced Contract Reporting portal, Ministry of Aboriginal Affairs Portal and all related reports as part of the upgrade project from Oracle Discoverer 10g to Oracle Discoverer 11g, as well as installing Discoverer 11g application on the desktop. Currently working on Expenditure Analysis report for Ministry of Education to investigate the discrepancies in data and fixing the code behind the views/logics to provide accurate dollar values that will include HST amount for expenditures, which is currently not added properly. This will as well fix data issue with all the other ministry expenditure. I am working on providing solution to another discrepancy issue between existing Oracle core reports and IFIS discoverer reports.

Confidential, (January 2010 - 2011) Calgary, Alberta
Enterprise Reporting Analyst

My projects involved having all data transferred to existing oracle system from old SQL server and creating improved reports in Oracle Discoverer, this project will increase the revenue due to more efficient and effective planning, improve market share due to improved customer service, reduce the cost of old hardware cost and eliminate other application support cost and as well as improved security and workflow. My daily responsibilities are collecting, defining and documenting functional business intelligence reports requirements, mostly for Oracle E-business suite, Discoverer, Microsoft Reporting Services, OBIEE, etc. As well as designing, building reporting solutions, managing portals to ensure end users can easily access information. Provide training, identifying and recommending enhancements to business intelligence infrastructure.

Confidential, (July 2008 – December 2009) Mississauga
System Analyst/Hyperion/Essbase Developer

Worked as a Hyperion/Crystal Report Developer and Essbase Cube support Analyst, my tasks were to gather business requirement, provide Hyperion reports to higher management level, work with the finance team to provide data fix, worked on calculating forecasting, budgeting process in Hyperion Planning, HAL interface, running Hyperion Essbase calcsripts to produce data for monthly and quarterly forecasting and budgeting reports. My task required understanding of Essbase database, understanding of dimension outline and efficient design of the outline, create and running business rules, create and run Calc Script, making sure all the Hyperion application and servers available for business user to use the application, prepare for disaster/recovery process; auditing the usage and security of the applications, publish reports on web, work on change management process and document on those. Also, I have worked on Hyperion upgrade project to analyze the flaws in current system and areas that we need improvement, help analyze the system and prepare RFP documents to suggest better/upgraded technology solution.

Confidential, (May 2008 - June 2008) Downtown, Toronto
Business Object Consultant/ Programmer Analyst

I have worked on a contract project to build the process in SQL server/database to capture performance of the service technicians, to provide enhanced Business Intelligence reports, which illustrates in depth view of performance of employees /technicians who worked on fixing the ATM machines in banks, as well as to keep track of services and service hours. These reports involve working with SQL scripting, building store procedures in SQL server, DTS Package creation, and provide the end result on user friendly Business Objects Dashboard.

Confidential, (Apr 2006 - Aug 2006) Downtown, Toronto
Brio/ SQR Developer, Reporting Analyst

Worked on a contract project to provide all the branch/operator performance reports to the higher level Managers; using SQR, Brio Tools. This project requires knowledge of SQL/Java/Visual basic coding, batch file creation and Database/Schema experience.

Confidential, (Jan 2006 - Mar 2006) Victoria Park, Toronto
Hyperion Consultant

Worked on a contract project to convert around 100 Envmon Reports (JavaScript and SQL code combined reports) into Hyperion Reports, customize reports, debugging or fixing existing reports, publishing reports on web.

Confidential, (Nov 2002 -Nov 2005) Markham, Toronto
Marketing Product & Campaign Analyst

I have worked with Clarify, Smarterm Gers System, SAS, SQL and process queries against Oracle database. Campaign and Marketing Analysis and provided campaign list based of Protection Plan, Gas and HVAC products. Forecasting profit and loss of the company based on Gas/Protection Plan products and provided requested financial reports and KPI reports to the Mangers and Directors using Hyperion/Brio/Business Object. Automation of Several tasks and automation of Reporting to the Management using Access Database, Excel, Brio, and Visual Basic coding. Design Brio query using Java Scripting, processing and testing queries in development and production environment and registering documents to the OnDemand Server. Define users and groups authorized to access the OnDemand Server and Broadcast Server. Used the Remedy User Application to view the problem tickets from the clients, analyze the problem, log information and fixed the problem.
Worked on Projects using Win Runner doing Software Testing, Stress testing for new applications with Quality Assurance Team

Confidential, (June 2001 – October 2002) Victoria Park, Toronto
Brio Administrator

Worked as an Intern to provide support in small application, fix programming codes in application, and make small enhancement changes. Later was hired as contractor to work as Brio Administrator and Brio Reporting Analyst, where I received training on reporting tools such as Brio, Cognos and also took part on providing training on Brio reporting tools to the end users.

Academic Qualifications

• TRIOS College- Network Engineering, Mississauga, ON, January 2008
• York University- Business Economics, North York, ON, Sept 2005 - present
• Centennial College- Computer Programmer, Scarborough, ON, August 2001