Janice Margarita R. Cunanan

DATA ANALYTICS/ BUSINESS INTELLIGENCE CONSULTANT / SYSTEMS ANALYST / ANALYST PROGRAMMER/ REPORTING ANALYST/ BUSINESS ANALYST/SOFTWARE DEVELOPERs

+63-906-***-**** (also available thru viber)

adbwho@r.postjobfree.com

RELEVANT EXPERIENCE

Has more than 17 years of experience in the IT industry having both business and technical related roles; the recent 10+ years client/server and 3-tier based systems and 4 years in enterprise applications in the insurance industry

Has an experience in the application of Integrated systems

Making sure systems meet future business needs through evaluating strategic and operational plans and external environments.

Demonstrated analytical and problem solving ability in a medium to large organisation

Performs reactive, proactive maintenance and application change activities through various technologies and software

Ability to prioritise effectively and execute tasks in a high-pressure environment

Experience in software development for large organisations

Establish and develop BI reports needed for data warehouse

Knowledgeable in analyzing customer requirements

Translates business information needs into BI solution requirements. Collaborates with the user community, and other technical resources, to document requirements and develop design specifications.

Perform delivery of BI solutions using Crystal Reports/ Business Objects XI R3. Develops, validates, tests and promotes requested solutions and enhancements to satisfy business information needs.

Outlining of BI solution includes data modelling, data marts/warehouse design, Business Objects universes and reports design, and ETL design.

Analyses and communicates BI related data usage issues, including problems with data integrity, data design, and functional and technical software issues.

Analyses, designs, codes and tests software programs to monitor BI databases including archive databases.

Proficient in Crystal Reports 2008 and XI, Infoview (Web Intelligence), Business Objects XiR2, BO 6.5.1, Visual Basic, Sybase SQL Server, MS Access, UNIX, ActiveX/COM/DCOM and ODBC, ActiveX, Transact-SQL, Oracle/PL SQL, Informatica

Extensive experience in BO Migration from 6.5 to XiR2. Develop and create Dashboard reports that provides an intelligent navigation framework for contextual drill down and intuitive navigation through data using BO XiR2

Has an extensive work experience in the areas of systems analysis, programming, system development, testing, and management. Well versed in software development from planning to implementation of various systems ranging from medium to enterprise-wide, which includes but not limited to extended warranty insurance system, auto insurance and reporting system

Extensive experience in customizing stored procedures in MS SQL to extract data from the database and for system performance as well. Modified the batch program Interface data file extract to fix runtime errors and enhance its functionality. Modified system to meet user requirements

Proficient in report development / enhancement of complex reports

Highly involved in development and enhancement of a multi-tier application designed for processing insurance for extended warranty to meet user requirements from different countries using Visual Basic with Sybase as backend tool and Orbix ORB version 2.0.2 as the object request broker.

Strong business analysis skills and interacts with foreign and local clients.

Special competencies in Business Objects 6.5.1 and 5.4.1 includes Universe Design/Development, Advanced Report Writing (covering various formats, breaks and drilling hierarchies against a single source system), Management and Executive Level Report Writing, and Report Requirements Definition.

Disaster Recovery planning and implementation

Supporting, troubleshooting and resolving technical and functional issues related to our data warehouse and BI reporting processes

Providing design support for the development of business intelligence solutions

Translating defined and agreed new business needs into technical solutions

Developing, testing and delivering new data warehouse and reporting requirements for the business.

Providing direct support to our business users for Jedox reporting, CRM and Sharepoint.

Working with internal and external customers and IT partners to gather and validate requirements

Ensuring supports calls are responded to and resolved to meet the KPIs associated with the severity levels

Creating and maintaining documentation of system processes, data flow charts, user training material, data definitions

Knowledge of web orientated languages, including SQL, HTML, VB script and Java script.

4 years experience in Mining

ITIL V3 Certified

Tools:

Tableau, Qlikview, Infoview (Web Intelligence), Business Objects XiR2, BO 6.5.4, 5.4.1, Crystal Reports Viewer, Crystal Reports XI, (WEBI) Oracle 9i, 10g, Unix, Toad, Remedy User (tool to create requests), Infomatica, MS SQL, Oracle, PL/SQL, Mercury, QTP, MS Project, Microsoft tools (Excel, Word, Access, Powerpoint), Sharepoint, Cognos, Crystal Reports Viewer, Crystal Report Server 2008, Crystal Report 2008, Transact SQL, Qlikview, Sharepoint, HPQC, HTML, VB Script, Java Script, Sharepoint, SNOW, JIRA

CSC AUSTRALIA PTY LTD

OCT 2011 TO OCT 2015

AUSTRALIA

3W I.T CONSULTING /

I.T. CONTRACTING

OCT 2010 TO OCT 2011

AUSTRALIA

Business Intelligence Consultant

CLIENT: BHP BILLITON

OCT 2011 TO JUL 2015, AUSTRALIA

Role: BI Consultant / Developer /Applications Support / Technical Specialist

Responsibilities:

Responsible for working with colleagues to analyze, design, build, test deliver and maintain reports, dashboards and other data extracts requested.

Responsible for working on reported production issues in addition to contributing reporting expertise while assigned to project teams

Document business and system processes and procedures through the use of industry standard process flow

Supports other applications (BHP Portal, Business Objects Reports, BIMES Crystal Reports, DAS/ampla Reports, Snow Reporting, Mariweb, License file Servers used in drilling blastholes like GoCad, I-site, Insite, Vulcan, Minemarket etc)

Played a major role in Business Continuity / Disaster Recovery Planning and Implementation

Doing Supply chain report enhancements / support

Ensure that all documents has conformance with the BHP requirement, code of conduct and relevant obligations

Demonstrated Analytical and trouble shooting

Design, develop and implement systems

Supports MAS applications

Ensure continuous improvements in own area of accountability

Fixing issues raised

Perform doing Technical Operations Processes such as backup, restore, system start up etc.

Doing the application support following the right process such as Maintenance, Incident, Problem, Event, Request and Access Management

Supports BO SNOW reporting

Knows how PHD works

Application Support and Maintenance

Snow Reporting

Design, code, test, and document all new or modified BI systems, applications, and programs.

`Develop the semantic layer, metadata, reports, and report definitions.

Perform complex data analysis tasks to support the service.

Assist in the design of databases and data warehouses to ensure interoperability with BI solutions.

Analyse user requirements and, based on findings, designs, design functional specifications for BI front-end applications

Troubleshoot BI tools, systems, & software and tune the performance of these applications as necessary.

Design end deliver end-user training and training materials; provide technical support as necessary.

Conduct research and make recommendations on BI products, services, and standards in support of procurement and development efforts..

Promote BI benefits across the organization to optimise BI usage to relevant users.

Comply with enterprise change control and testing process for modifications to data system

Tools:

Business Objects, Crystal Reports 10, Oracle, Sybase, SharePoint, Visual Studio 2005, Citrix, Oracle, Sequel, HP QC, .Net, SNOW reporting

BI Consultant

CLIENT: BOOKTOPIA, SYDNEY, AUSTRALIA

Role: BI Consultant / Crystal Report Writer

Responsibilities:

Provided software demonstration, presentation, and conducted interviews with users during business data gathering. Prepared Business Requirement Document (BRD)

Review, analyse and evaluate business processes and user needs to translate them in business requirements and functional design specifications

Convert 200 queries to stored procedures

Create reports using Crystal Reports 2008

Manage Crystal Reporting Server 2008

Deploy reports using Central Management Console

Knowledgeable in importing data for use in report software, spreadsheets, graphs and flowcharts

Tools:

Crystal Server 2008, Crystal Reports 2008, MySql, Infoview, Crystal XI

CLIENT: PRAXA / TRANSPACIFIC BIRSBANE, AUSTRALIA

OCT 11, 2010 FEB 10, 2011

Role: Crystal XI Report Writer

Responsibilities:

Convert 30 reports driven by queries to stored procedure

Fix 107 reports from old database environment to JDE Environment

Fix 61 reports based on change in the stored procedure

Create reports based on exported queries

Create new reports for integration

Tools:

Crystal Xi, SQL Server 2008, XML

RCG INFORMATION TECHNOLOGY INC.

MAR 2009 TO OCT 2010

Senior BI Consultant

Role: Team Lead

Responsibilities:

Translates business information needs into BI solution requirements. Collaborates with the user community, and other technical resources, to document requirements and develop design specifications.

Managed internal project, Swipe Card Reporting System, using Sequel Server Reporting Services (SSRS) and Sybase as backend. Conducted data mapping and technical design analysis from initial stage until delivery of project.

Advises on the evaluation and selection of BI related tools.

Conducts training on Business Objects for resources on bench

Developed Internal timesheet for ADB using Business Objects.

In-house Training on Informatica

In-house training on OBIEE (Siebel)

HEADSTRONG PHILIPPINES, INC.

SEP 2006 – MAR 2009

BI Consultant

CLIENT: CREDIT SUISSE, NY

DURATION: JAN 2008 TO FEB 2009

Role: Technical Team Lead

Credit Suisse is a provider of wide-ranging financial services in Europe and other selected markets. It offers investment products, private banking and financial advisory services for private and corporate clients

The system provides market values and cash balances at a summary and account level. Data can be viewed and grouped by different parameters such as Currency, Account Type and Account. All portfolio positions and cash balances data are available online.

The online reporting has customizable views using Crystal XI thru XML which can be changed according to the needs of the user. These are Trade and Exceptions Reporting, Dividends and Interests, Futures and Options, Margin, Securities Lending and Credit Default Swaps

Responsibilities:

Project management that includes planning and scheduling, project estimation, delegating, coordinating and liaising with users, and overseeing the over-all progress of the project.

Review, analyze and evaluate the business requirements and functional design specification prepared by users before stakeholders sign-off

Develop Stored Procedures using Sybase/ SQL Server

Implement fixes and enhancements

Support existing reports

Create Detailed Design based on Functional Specs

Conducts technical analysis and data mapping functionality from the initial stage until delivery of the project.

Facilitate and attend scheduled/adhoc status meetings

Prepare documents for CMMI compliance

Participate in performing impact analysis

Tools:

XML, Crystal Xi, Oracle 9i, Sybase, Infomatica 7.1.4, DBArtisan, Mercury Quality Center, Sharepoint

CLIENT: ADT SECURITY, CHICAGO USA (ONSITE)

DURATION:DEC 2006 – DEC 2008

Role: BO Developer

Responsibilities:

Design, code, test, and document all new or modified BI systems, application, and programs.

Develop the semantic layer, metadata reports and report definitions.

Perform complex data analysis task to support the service.

Assist in the design of data bases and data warehouses to ensure interoperability with BI solutions.

Analyse user requirements and bases on findings. Design functional specifications for BI front-end applications.

Troubleshoot BI tools, systems and software and tune the performance of these applications as necessary.

Design and deliver end-user training and training materials, provide technical support as necessary.

Participate in the evaluation and selection of database/data warehouse components, including hardware, relational database management systems, ETL software, metadata management tools and database design solutions.

Promote BI benefits across the organization to optimise BI usage to relevant users.

Comply with enterprise change control and testing processes for modifications to data systems

Tools:

XML, BOXI, Oracle 9i,, Infomatica 7.1.4, DBArtisan, Mercury, Sharepoint, .NET, Infoview

CLIENT: SM GROUP OF COMPANIES

DURATION: OCT 2006 – NOV 2006

Role: Assistant Project Manager

Assigned in IT of Marketing Convergence, a subsidiary of the SM Group

Responsibilities:

Project management in the areas of Relational Database Management systems such as Oracle 9i/10g for Online Transaction Processing (OLTP) and Decision Support Systems (DSS)/Data Warehousing.

Monitor reports created in COGNOS Impromptu and COGNOS PowerPlay as an OLAP front end for DSS.

Keep tract of various EFT-POS Terminal based, magnetic strip and smart card systems which includes private label credit, stored value, petroleum fleet and customer loyalty programs.

Practices the SEI-CMM (Capability Maturity Model) quality standards.

Tools:

Cognos, Oracle 9i, Unix, Toad

RCG INFORMATION TECHNOLOGY INC.

FEB 1999 – SEP 2006

Senior BI Consultant

Awarded as Best in Attendance (1999)

Received an award as Rookie of the Year (2001) courtesy of AIU (client)

Responsibilities:

Almost (3) years of extensive training and experience in using Business Objects Intelligence Solution; supports US client for Business Objects’ Universe design and development in 5 Departments as follows: Corp Communication, HRPlan, Personnel Records, Training Services, Gov't &Community Relations and Compensation.

Comprehensive training and experience in implementing and customizing the major systems created by AIG New Jersey for the following countries: Australia, Singapore, Hong Kong, Taiwan, Malaysia and Philippines.

In-depth experience on business needs analysis, technical design, modification and batch reporting, Writing Function modules, core modifications and development using Visual Basic as the front-end tool and SQL as the back-end.

One (1) year of EDI (Extract Data Interface) experience in development, configuration and mapping of tables.

Excellent skills in application development using Visual Basic, Sybase SQL, and MS Access, and reporting applications using Crystal Reports.

Tools:

Crystal Reports, Business Objects, SQL, INFORMATICA

BUSINESS OBJECTS 6.5.1 INTERNAL TRAINING

DURATION:

may 2006

Role: Trainer

Responsibilities:

Conducted comprehensive Business Objects Training Course. The course covers the following topics: Simple, Intermediate and Advance Modules.

Provided all the skills needed to efficiently create and maintain universes for Business Objects and Web Intelligence allowing users to easily build, access, and run reports. A hands-on, real world approach helps quickly learn how to create, distribute, maintain, and optimize universes for Business Objects deployments.

Helped the participants to translate end user reporting requirements into an optimal universe design to ensure company's Business Intelligence needs are met

Received praises and good feedbacks from her participants during the course.

CLIENT: WALGREENS’ EMPLOYEE REPOSITORY PHASE 2 OFFSITE

DURATION:

SEP 2005 – APR 2006

Role: Team Lead / B.O. Report Designer and Technical Consultant (offsite)

This project is customizing HR and Resource Management key business functions by reorganizing corporate data into meaningful and comprehensive reports that supported and simplified day-to-day operations.

Responsibilities:

Enhanced/ Developed complex reports using Business Objects from ETL, troubleshoot Business Intelligence reports

Performed data analysis

Mapping of system data

Determined and documented the business rules to move data through various stages of the Data Warehouse

Supported the end-user delivery system for the existing data warehouse in Oracle

Involved in development of applications and reports using Oracle SQL, PL/SQL.

Formulated designs

Made technical decisions

Implemented and maintained sophisticated commercial and financial applications and designing and developing new database files, as well as manages the projects that is currently assigned.

Coordinated and resolve and/or address any client issues, problems and concerns in a timely manner

Set up test plans and scripts and oversee user acceptance testing

Tools:

Infoview (Web Intelligence), Business Objects XiR2, BO 6.5.4, 5.4.1, Oracle 9i, Toad

CLIENT: WALGREENS’ EMPLOYEE DEAL METRICS REL 1.1 (BUSINESS OBJECTS)

DURATION:

AUG 2005 – SEP 2005

Role: B.O. Report Designer and Technical Consultant(offsite)

Responsibilities:

Managed reports based from Client findings

Created classes and objects that were used by Business Objects and Web Intelligence clients to run queries and generate reports.

Optimized object definitions to enhance end user reporting for universe optimization and generate documents and reports

Tools:

Infoview (Web Intelligence), Business Objects XiR2, BO 6.5.4, 5.4.1, Oracle 9i, Toad

CLIENT: WALGREENS’ EMPLOYEE REPOSITORY PHASE 1

DURATION: MAR 2004 – MAY 2005

Role: Team Lead / B.O. Report Designer and Technical Consultant (offsite)

This project is customizing HR and Resource Management key business functions by reorganizing corporate data into meaningful and comprehensive reports that supported and simplified day-to-day operations.

Responsibilities:

Provided software demonstration, presentation, and conducted interviews with users during business data gathering. Prepared Business Requirement Document (BRD), test scripts, and test plans and clearly interprets them to users, systems analyst and programmers.

Reviewed, analyzed and evaluated business processes and user needs to translate them in business requirements and functional design specifications. Perform functional testing, system testing, performance testing, regression testing and security testing

Conducted technical design analysis and data mapping functionality from initial analysis stage until delivery of project. Facilitated and implemented creation of Database Universe from ground-up including database connection and parameters. Created classes and objects that are used by Business Objects and Web Intelligence clients to run queries and generate reports. Optimized object definitions to enhance end user reporting for universe optimization and generate documents and reports

Broadened and improved data analysis functionality and increased decision making capability of end-users by constructing and designing well-formatted Adhoc reports through extensive analysis of database and day-to-day business information and procedures. It also includes a facility for batch e-mail publication to concerned personnel. The system was developed using Java, ABInitio, Business Object and Oracle.

Administered 12 people (developers and testers)

Tools:

Business Objects 6.5.1, Oracle 9i, Toad, Erwin Data Modeler

PROJECT: CARNIVAL CRUISE LINES – INTERACTIVE RESERVATION INCENTIVES PROGRAM PROJECT

2 WEEKS

Role: Documentation Analyst and Lead Technical Writer

Responsibilities:

Co-authored online user’s guide by reviewing detailed business use cases and rules that streamlined user’s learning curve in using the system. Lead and mentored a team of 3 technical writers in documenting the user’s guide that suits the current business needs of the client.

CLIENT: AMERICAN INTERNATIONAL UNDERWRITERS CORP (AIU)

DURATION: JUL 2000- FEB 2004

Role: Lead Analyst/Programmer/ Crystal Report Developer

AIG Warranty® offers market-leading extended services contracts for consumer electronics, appliance and computer retailers and manufacturers. Extended warranty contracts protect the purchaser's investment by covering service or repairs generally required after the manufacturer's guarantee has expired. Programmes designed to extend a manufacturer’s warranty and service contract up to five years. The warranty will provide cover for the repair or replacement of the product should a defect occur during the warranty period. The product could be electronic appliances, TV, stereo, computers, cellular phones, Credit Card, Home Warranty’s.

Responsibilities:

Tasked to lead the implementation of Extended Warranty System projects for Australia, Singapore, Hong Kong, Taiwan, Philippines and marketed it via extensive interaction with clients on various requirements, functions gathering and acceptance testing.

Participate in the analysis of business requirements

Demonstrated proficiency in providing software demonstration, presentation, and in conducting interviews with users during business data gathering. Highly skilled in preparing Business Requirement Document (BRD), test scripts, and test plans and clearly interprets them to users, systems analyst and programmers.

Possesses competent skills in project management that includes planning and scheduling, project estimation, delegating, coordinating and liaising with users, and overseeing the over-all progress of the project.

Developed and implemented Claims Extended Warranty system in Hong Kong, Philippines, Malaysia, Taiwan, Singapore and Australia using VB/Crystal Report. Aside from the standard tasks given as Analyst/Programmer such as system analysis and design, coding, system testing, and documentation, was also gained extensive exposure in dealing and interacting with foreign users in liaising the production support issues via email and telephone.

Assigned to take the responsibility of providing programming expertise on a corporate pilot system which was successfully implemented across South East Asia and Australia.

Prepared priority list of issues per country regularly and submitted weekly status report indicating the severity issues.

Participate in performing impact analysis

Prepare technical specifications.

Create/ modify./ retrofit/ test reports based on business requirements

Tools:

Visual Basic 5.0, Sybase, Embarkadero, DBArtisan, Visual Sources Safe, MS SQL Server 7/2000, MS Access 97/2000, Crystal Report, Microsoft Visual Studio 6 IDE, MS Project, Rational Rose

CLIENT: AMERICAN HOME ASSURANCE CO., MELBOURNE, AUSTRALIA (ONSITE)

DURATION: OCT 2000 – DEC 2000

Role: Lead Analyst/Crystal Report Developer

Played major role in the implementation of Claims Extended Warranty system in Australia in supervising the User Acceptance Testing activity

Responsibilities:

Developed and implemented EDI (Electronic Data Interface) in Australia and Taiwan. It is a conversion tool using flat file submitted by the Manufacturers, Repairers, etc to be processed by the EDI Claims Interface module and populate the claim tables in GOAL/D so as to create a new claim.

Participate in the analysis of business requirements

Configured the mapping of tables from Underwriting side to AEGIS2EW tables to process the payments

Generated reports using Crystal Reports based on business requirements

Participate in performing impact analysis

Prepare technical specifications.

Tools:

Visual Basic 5, MS Access, Sybase, DBARtisan, Crystal Report

CLIENT: AMERICAN HOME ASSURANCE CO., SINGAPORE (ONSITE)

DURATION: JUL 2000 – SEP 2000

Role: Lead Analyst / Crystal Reports Developer

Used Visual Basic in the customisation and maintenance of the IHCBA software

Responsibilities:

In-charged in Business analysis, technical design, modification and batch reporting, write function modules, core modifications and development using Visual Basic as the front-end tool and SQL as the back-end.

Generated documentation such as users manual and technical manual

Modify front end applications and generated reports according to users request using Crystal Reports

Generated reports using Crystal Reports

Participate in performing impact analysis

Tools:

Visual Basic, Crystal Report, MS Access, Sybase, DBArtisan

CLIENT: PHILIPPINE LONG DISTANCE TELEPHONE CO. MANILA

DURATION: FEB 1999 – JUN 2000

Role: Lead System Analyst/ Programmer / Crystal Reports Developer

Played major role in the conversion of its existing Home Development Mutual Fund–Multi Purpose Loan and Group Insurance Loan done in Foxpro to be converted to Windows based system using Visual Basic version 5.0 and 6.0

Responsibilities:

Responsible in designing of screens, interface, reports and database tables and defined programming standards.

Analyzed the information based on the existing system and formulated the system specification, report analysis and timetable.

Provided fully functional codes and developed a graphical User Interface (GUI) using VB 5.0. Presented codes for data downloading and uploading of contribution payments to be posted to the Payroll System.

Modified the existing database (structure and tables). MS Access was extensively used to develop the optimized database model.

Generated reports for all transactions of the system using Crystal Reports.

Performed system testing to verify all changed components of the applications.

Acted as Database Analyst in taking charge of the database cleanup

Generated documentation such as users manual and technical manual

Create, modify, test reports based on user’s specifications

Tools:

Visual Basic, Crystal Report, MS Access, SQL

TRAININGS AND SEMINARS ATTENDED AND CONDUCTED (IF ANY)

ITIL V3 Certified

Supervisory Development Program (2008)

Java Application Development oriented to Japanese Enterprise with Struts, Tomcat and J2EE (Aug 2006)

Communications With Ease (2005)

Business Objects (Dec 2003)

Sequel Server Integration Services (2009)

QTP Training (2009)

Contact this candidate