Aurea Muncal

Aurea B. Muncal Aquino Compound, Bacoor Blvd. Molino 2 Bacoor Cavite Philippines Mobile: - Landline: - Email –- Objective To leverage my experience in Information Technology in the field of development, L2 application support, data warehousing, business intelligence, reporting and data analyst. Summary An I.T. professional with more than 15 years working experience as a Lead Application Developer, L2 Application Support for Data Warehousing and Business Intelligence, including Data Analyst and Technical / Helpdesk Support. Proficient in providing project management support for multiple projects and processes as CPMO (Central Project Management Office) for IBM Philippines. Experience in using programming tools such as Nextouch and Visual Basic. Knowledgeable on Business Intelligence and Datawarehousing tools such as Hyperion Essbase, Hyperion Brio, Microstrategy, Tableau,Informatica, Teradata, Cloudera Hive, Dbeaver, Crystal Reports, DataStage, MS Access, Informix, Performance Monitor, Filezila, Winscp, Notepad++, BMC Remedy 7.1, Changeman DS, SQL and Control-M. Well experience in applications in relation to supporting Marketing Applications, Banking Systems, Grocery Application and ERP Systems. She is also familiar with tools such as Linux, AS400, and Equation. An expert in technical / helpdesk support. Work Experience 77 Global Services (Nov 9, 2020 to present) Big Data / ETL Developer Directly coordinates to the clients to understand the current business process and their target business goals. Gather/Analyze the requirements for Promo, Lead Generation, Adhoc and dashboard request that align to business needs. Gather and process raw data using Dbeaver, Hue, informatica and Power BI. Designing, developing, and maintaining user-friendly data visualizations and dashboards using complex datasets from different sources. Creating dashboard that align to business needs. Creating mapping and automation using informatica. Perform tasks such as writing scripts, write SQL queries, creating dashboard, workflows etc. Prepares documentation / ETL specification for approval and sign off. Support business decisions with ad hoc analysis as needed. Knowledge of data cleaning, visualization, and reporting, with an understanding of the best, most efficient use of associated tools and applications to complete these tasks. Use BMC Remedy for creating ticket and assigned ticket for Data Lakes Team IBM Philippines (April 2012 to April 2016) Application Developer Test SME (July 2015 to April 2016) Provide and understand the required configuration files as per the given test case description. Uploaded and reviewed using RTC. Test run/execute the approved test case description as per the given shell scripts, configurations files & test data at the test environment. Conduct and provide test evidences after each test execution run. Uploaded and reviewed using RTC. PMO Analyst (Feb 2013 to June 2015) Track, records and monitor project information through the project management system of record (Project Database, Document Tracker, Teamroom and 7keys). Ensure that all necessary documents are in place and inform Project Managers of variances. Verify compliance with mandatory deliverables at for project opening, project close out and ensure project documentation is executed. Assists the PM on the review of all deliverables throughout the project management process to ensure completeness, consistency, and quality in compliance with current Project Database requirements. Lead Batch Support (Aug 2013 Jan 2013) Proactively see the issues or improvements and follow-ups. Monitoring of scheduled jobs (daily, weekly, monthly) Assessment of current batch schedules and procedures; Tickets/Issue Resolutions within agreed SLA timelines Curriculum Development (May 2013 to July 2013) Create Analytics Curriculum Development and Rollout, for Commission on Higher Education. Lead Application Developer Teradata (Aug 2012 to April 2013) Trainor of BAO (Business Analytics and Optimization) Capability for Basic and Advance SQL, Teradata and its utilities. Technical Interviewer for Teradata and SQL Developer resources. Extract client data from different sources for processing, integration and business rule applications. Analyzed and modified existing ETL jobs for transforming data depending on the client’s current business need. Ensure data quality and data integrity throughout the ingestion process. Monitoring and resolving Data warehouse ETL Production issues. Worked in analyzing the issue, trace the problem area, suggest a solution, discuss with business. Teradata Philippines (October 26, 2010 to April 2012) Senior Technical Consultant Write test cases for all the business and technical requirements for each of the systems. These test scripts will be organized into test sets and will be uploaded into the QA tool in use. Execute test scripts against build of code presented to them as the development is accomplished. The results of the testing will be recorded in client’s Rational QA suite of tools and any defects will also be logged in the QA system. Accenture (April 5, 2010 to October 15, 2010) Senior Software Engineer Conducts training for BI Boot camp for IM Capability. Explain basic concepts of Business Intelligence, Datawarehouse and SQL. Oversee new hire to understand BI Concepts. Enhanced Timekeeper Application for Bench using MS Access Application. Customize application for Bench need. Safeway Manila (June 2008 to March 26, 2010) Programmer Analyst Food Flex Data Maintenance: Primary Support for Food Flex Project. Managed the creation, backup, data manipulation, and data integration. This system gives the nutritional and substitution information for a specific product the customers buy. Perform ETL data migration from extracting from various sources then transforming data obtained to a specified format/calculation and finally loading this to its target destination. Understanding the specification and analyzed data according to client requirement by analyzing the mapping document. Involved in creating database objects like tables, views, procedures, function using SQL to provide definition, structure and to maintain data efficiently. Managed data consolidation and apply data integration check before uploading nutrition and substitution info. Make enhancement of the existing process flow and application. Datawarehouse Support Provides 24x7 application/production support to the SAFEWAY USA users’ community by working on tasks like ticket/incident resolution, adhoc requests, etc. for Datawarehouse, Essbase, Seechain, Datastage and Crystal Reports Ensures that all tickets/incidents are properly addressed and resolved within the agreed SLA to ensure positive impact on customer satisfaction using Remedy 7 and Control-M Involves in trouble-shooting problems in Midrange environment by solving defects and code debugging Performs some development tasks that are essential to the problem resolution Involves in Minor Work Requests (MWRs) and Project assistance on Datawarehouse Creates design specification and SQL statements Performs Unit and UAT Testing Creates support documents (job set-up, abend handling, turnover document) Ensured availability of all support tools needed for the Teradata environments. Package creation through Changeman DS/Java Client for modified scripts to be deployed on production. TELUS International Philippines (February 2006 to June 2008) Practitioner Connecting to pull data from the client’s DB2 database using tool of QMF (query management facility), and Hyperion BRIO and apply SQL Code for a specific request in getting Audience or contact for a specific campaign or marketing strategies. Applying a Direct Marketing Association Mail Preference Service (MPS), Telephone Preference Service (TPS), and E-mail Preference Service (EMPS) to suppress name and contact information upon request. Using a CRM Siebel for allocation, loading, making a campaign and program setup for a specific marketing strategy. Produce reports/spreadsheets/lists using Excel, Pivot Table, Macro Excel. Development and execution of campaign analysis reporting including: forecasting and program results, validating campaign performance and identifying opportunities Supports strategic marketing decisions. Develop a thorough understanding of client data, integrate and analyze data from a variety of internal and external sources and manage client-reporting deliverables. Radix Systems Services Corporation (January 2005 to July 2005) Programmer Enhancement of program Interface for General Ledger (GL) migration. Enhancement of Macro Tool for Dividend Checks and Inward & Local Clearing Checks. Develop ATM Bills Payment Clearing module. Prepare system and user documentation. Assist in impact analysis and preparation of development plan and conduct technical interviews to gather user requirements. Apply corrections, changes or enhancements to existing programs and perform root cause analysis in defect resolution and debugging. Generate program documentation and amendment for program flow. Provide production support in Equation. Accenture (October 2004 to January 2005) Assistant Developed macro excel tool that will used to compare two reports, determine their differences and display the location that will used for UAT Report. Developed macro excel tool that is used to format a number cell into a currency with no decimal places. Used for formatting Estimate Report. Maintain and enhanced a macro excel tool for Health Summary, risk, Issue and Change report using an Ms Access Database. Support for DC Creation, which is used for reference for budget and material cost. Update Lotus Notes Database for Managers Reference. Maintenance and enhancement a macro excel tool for Estimates and Prioritization report using an Ms Access Database. Enhancement and maintenance of Lotus Notes Database for CPS Phase Outsource Advantage (July 2000 to October 2004) I.T. Helpdesk Assist the MIS Manager, The Network Engineer or the Systems Administrator in providing suppliers and vendors with the proper hardware or software specifications. Submit the Purchase Request (PR) and relevant CAPEX forms to the centralized CHI purchasing office for processing, upon approval of the MIS Manager. Provide follow-up inquiries to the vendor and supplier on the status of any IT acquisition. Assist MIS staff in securing MIS properties, either personal or departmental, by liaising with the proper security officers in the MIS compound. Installing software and repairing some pc troubles. Assist end-users in solving computer problems, both software and hardware Set-up and configure internet using proxy server and dial-up networking Performs computer diagnostics and corrective procedures at subsidiaries sites. Help the Technical support in the installation and configuration of new server. Education City College of Manila, Philippines,- Bachelor of Science in Computer Science Las Piñas Manpower and Youth Council (Technical Course) Computer Technician, June – Dec 1999 Consumer Electronics, April – June 1999 Training PM Essentials (Refresher) – IBM Solutions Delivery- February 19, 2016 Project Management Fundamentals -IBM Solutions Delivery- March 2016 Project Management Orientation-IBM Solutions Delivery - March 2016 People Manager Enablement Session - IBM Solutions Delivery- July 2013 Performance Management (Communicating a PBC Assessment) - IBM Solutions Delivery-February 2013 Performance Management-Team-Based Decision Making - IBM Solutions Delivery- December 2013 New Managers Orientation- IBM Solutions Delivery- December 2012 Business Object Training – Teradata. June 13 to 17, 2011 MSTR Desktop: Reporting Essentials – Teradata. May 31 to June 3, 2011 MSTR Architect:Project Design - Teradata. April 19 - 20, 2011 Informatica Training –Teradata. May 16 -27, 2011 Teradata Factory –Teradata. December 2 -15, 2010 HP Quality Center 9.2 -PPM. November 18, 2009 Datastage Essentials v8- Safeway Manila. September 15 to 18, 2009 Overview of Microsoft SQL Server 2008 Integration Services - DBWizards. August 19, 2009 WMB Training – Safeway Manila -March 26, 2009 CORE JAVA Training-Safeway Manila. December 10 to 18, 2008 Changeman DS - Eduardo Escandor. November 25, 2008 Safeway Rational Unified Process (SRUP) & SDLC - Marita Daza. October 20, 2008 Unified Modeling Language (UML) -PPM. July 24, 2008 SQL, BRIO and Siebel-Harte Hanks / IBM Asia. February 27, 2006 to March 20, 2006 Visual Basic 2 (Advance Database)-Genetics Computer Institute. November 6, 2004 – December 18, 2004 Visual Basic 1 (Basic Fundamentals)-Genetics Computer Institute. September 11, 2004 – October 30, 2004 Personal Information Married