Resume

Sign in

IDQ Developer

Location:
Mason, Ohio, 45040, United States
Posted:
June 05, 2019

Contact this candidate

Resume:

ROWENA ESTILLORE

**** ****** ****. *****, ** ****0

415-***-****

ac8vos@r.postjobfree.com

To obtain a position as an Analyst/Engineer/Developer in order to utilize and develop my skills.

Over 15 years of working experience as Sr. Business/Systems/Data/BI Analyst.

Worked on projects in various industries in Telecom, Biotech, Healthcare, Energy, Oil/Gas, Utility, Power, Media, and Retail.

Computer Trainings and Skills:

OS: DOS, Windows, Unix Solaris

Applications/Systems: MS Office (Word, Excel, Powerpoint, Access, Project, Outlook, OneNote), Office 365, SAP R/3 (MM, WM, SD, PM, PPM, PS, FI/CO, BPC), P6 Primavera, Sharepoint,Visio

Programming/Scripting: VB, Python, C++, Cobol, R

Database/Data Warehousing/Business Intelligence/Reporting: Foxpro, MS Access, MS SQL, SSMS, T-SQL, SSRS, Oracle 10g/11g, Cognos, Tableau, SAP (BW, BEX, BOBJ), Power BI, Hadoop, Apche Spark, Hive

ETL/Data Quality/Data Transformation: Data Stage, DTS, SSIS, Informatica Data Quality (IDQ Admin, Developer, Analyst)

Other Tools/Processes/Methodology, gRemedy, gMail, Lotus Notes, Clarity, Erwin, Salesforce, MDM, Data Governance, Data Warehousing (OLAP, OLTP, ROLAP, MOLAP), Client Server Methodology, AWS, Business Analysis (Gathering Requirements, System Requirements Specs., Functional Specs., Non-Functional Specs), SDLC, Agile, Waterfall, User Story, Planning, Requirement Analysis, Design, ETL, Data Conversion, Development, Integration and Testing, UAT, JIRA, HP QC, AB/Testing, Implementation, Operation and Maintenance, User Training, User Experience and Technical Documentation (Traceability Matrix, Workflow, Data Flow Diagram, Swim Lanes)

Worldpay Inc. (Vantiv) – Cincinnati, OH 10/2018 – 3/2019

Software Engineer IV - IDQ Developer/Analyst

Developed data objects, profiles, mapping, mapplets, rules, reference tables, scorecards from sources in Hadoop/Hive, Oracle, SQL in Informatica Data Quality for Billing, Customer Merchants, Ledger, Settlement domains.

Developed rules, profiles, scorecards, parameterization and transformation in IDQ Developer.

Utilized IDQ Admin, IDQ Developer and IDQ Analyst tools for Data Quality and Data Governance.

Created user stories, tasks, test cases, iteration status, backlog in Rally CA Agile Central for Agile/Scrum SDLC methodology. Attended daily stand up for Agile Scrum.

Coordinated rules and transformations with Data Stewards. Managed documents in Sharepoint.

Performed data profiling, data quality, and data discovery. Developed and applied rules.

Migrated object from Test Environment to Prod Environment.

Designed and created mapping transformation to run in Hadoop/Hive.

Querying data using SQL in Hue for Hive/Impala sources..

Write and developed queries, scripts, procedures in Oracle SQL Developer.

Created application to schedule mapping in Informatica Admin. Scheduled jobs, monitor runs/jobs in IDQ Admin.

Uwalo USA Consulting – Telecommute (HQ in CA) 06/2018 – Present

IT Consultant/PM

Assigned in IT Projects concerning Data Warehousing, Business Intelligence, Database, Data Visualization, Dashboards, Reporting, Metrics, KPI’s, MDM, Data Governance, ETL, ERP, Coding/Scripting and Business Systems Analysis.

Utilized Sharepoint for managing documents.

Manage skillset in the team for project deployment. Managed budgets and scheduling.

Supported and assisted in sourcing for prospective clients.

Determining projects for bidding and coordinating with Development team.

Conducted interviews for resources in the team. Managed Glassdoor, LinkedIn etc. recruitment dashboards.

IBM - Telecommute (HQ in NY) 09/2017 – 11/2017

Report Developer

Debugged, written and tested codes in VB codes to modify HR reporting templates to work for both Mac and PC.

Debugged and written codes in Lotus script to modify program in Lotus Notes in DEV environment for TCP Cycle Tool for HR to make it work for both Mac and PC.

make it work for both Mac and PC.

Tested codes in QA environment and deployment of script and new releases.

Attended conference calls concerning tasks/project status updates.

Rimini Street Inc. - Pleasanton, CA 11/2016 – 05/2017

Sr. Data Analyst – eDiscovery Group – Oracle Project

Worked on large data sets performing data analysis, data manipulation, data cleansing and data mining.

Applied various techniques like querying in Access SQL to extract and merge data or writing VB codes to automate tasks for Oracle contracts data. Validated data integrity and accuracy of data.

Attended daily meetings to report progress of tasks and projects.

Analyzed data and numbers/quantitative.

Assisted and helped in the team as needed concerning contracts data and building the database in Access/VB. Managed Excel spreadsheets with formulas, pivot tables and VB codes.

Gathered data from different sources to transform/convert into reports or analytical results.

Genentech Inc. - South San Francisco, CA 09/2015 – 11/2016

Sr. Business Analyst/VB IT Technology Consultant – MDM, Data Ops, Supply Chain, Materials

Imported tables from SAP and Oracle 11g/EDW into Access to design and develop programs/tools and GUI, data modeling for Data Operations group. Built latest master cube of all master data and production tables for auditing/reporting.

Analyzed, designed, debugged, developed and automated systems/processes in Access/VBA to gather and manipulate SAP MM and recipe data. Debugged existing programs/codes, created GUI interface and trained users.

Manipulated and processed data in Access and created codes in Excel and developed queries in Access SQL or VB codes. Developed queries utilizing SQL.

Extracted Material master tables and recipe tables from SAP MM via Oracle 11g and executing code/automation.

Developed ad hoc requests that involved modification of processes, programs, codes, metrics and reports. Supported the Supply Chain group and internal customers concerning requests and projects.

Attended weekly meetings for collaboration and project status/progress update.

Conducted testing to ensure that data/reports adhered to all business rules/processes/requirements.

Committed to continuous improvement of quality, processes, systems, analysis, data, reports, design, specs., modification and user support. Documented business processes when needed.

Pacific Gas and Electric (PG&E) - San Ramon, CA 06/2014 – 07/2015

Sr. Business Systems Configuration Specialist

Worked with Leadership and system users to validate and identify needs for developing custom reporting solutions to ensure alignment with changing system and/or end user needs. Worked with internal customers concerning requirements, specifications, documentation and reporting needs.

Designed codes, debugged, tested and documented solutions for users to ensure ease of use, efficiency and quality. Provided system and report configuration development using various tools and/or languages

Developed new and enhances existing reports, views, forms and other software functionality to meet clients need for assigned business systems/tools. Involved in other initiatives

Assisted with solutions test planning and execution. Collaborates with users to investigate and troubleshoot system. Participated in solutions design efforts. Contributes to solutions design, analysis, and application prototyping sessions

Managed data, business processes/workflows, data transformation, data integration, data warehousing

and data modelling. Involved in architecture, design of entity relationship diagrams and development of conceptual, physical and logical data modeling. Recommended solutions to existing processes and develop new processes. Built ER, data models and metrics.

Liaised and supported Transmission, Construction and Engineering in systems/reporting requirements.

Configured, extracted tables/queries, developed and supported applications/systems in Access, VB, Excel, SAP (WM, PPM, PM PS), BW, BEX, BPC, P6 Primavera, Clarity, SQL and Oracle 11g.

Assisted and supported in development of sites in Sharepoint. Supported Electric Operations in technical issues and requests in Clarity.

Involved in initiative to develop roadmap in Master Data Management and Data Governance to ensure data accuracy and data integrity. Involved in BOBJ project.

Developed documentations such as Technical Requirement/Specifications, Flowcharts, Workflow, Swim Lane and Data Flow Diagram as per request.

Kaiser Permanente - Oakland, CA 04/2013 – 11/2013

Sr. BIDW Data/Business Analyst

Developed Technical Requirement/Specifications, Flowcharts, Workflow, Swim Lane and Data Flow Diagram as per request.

Recommended solutions to existing processes and develop new processes. Committed to continuous business processes improvements and issues/concerns.

Worked in all phases of SDLC. Lead a project to rebuild existing Onsite Services process in Sharepoint in Access. Involved in Gathering Requirements, Planning, Requirement Analysis, Design, Data Conversion, Development, Integration and Testing, UAT, Implementation, Operation and Maintenance, User Training and Technical Documentation.

Developed documentations such as Gap Analysis, BRD, Flowcharts, Workflow, Process Flow diagrams.

Provided support concerning metrics, reports, dashboards and KPI’s to ensure accuracy of data/reporting in Sharepoint.

Coordinated with PM, BA’s and Business Users concerning project modification, status and updates.

Involved in architecture, design of entity relationship diagram and development of conceptual, physical and logical data models.

Designed and developed technical documents as needed.

Performed migration/testing across different environments (DEV/QA/PROD) and platforms.

Developed Use Test Cases and Test Scripts for UAT. Developed and executed test cases/scripts in UAT.

Trained users/clients within the department for supported applications/systems

San Diego Gas and Electric (Sempra Energy) – San Diego,, CA 07/2012 – 03/2013

Sr. BI Systems Analyst – IT, Finance, Transmission, Construction, HR, Engineering

Involved in Performance Management Reporting project for KPI’s/Reports/Dashboard in Business Objects.

Worked in all phases of SDLC and have used Agile methodologies/processes.

Involved in data migration/implementation project from Cognos to Business Objects and assigned in Gathering Requirements, User Story, Planning, Requirement Analysis, Design, ETL, Data Conversion, Development, Integration and Testing, UAT, Implementation, Operation and Maintenance, User Training, User Experience and Technical Documentation.

Developed tools/programs to support clients/users across all organization as per requirement.

Supported applications/systems like Cognos, BOBJ, SQL DTS, VB, Access, Excel, Sharepoint. Assisted in I.T. projects concerning Business Intelligence, Data Warehousing (OLAP, OLTP, ROLAP, MOLAP), ETL, Business Process etc.

Worked in ETL and build packages/cubes in SQL 2005/2008/2008 R2, SSMS, SSIS and Transformer. Assisted in SQL queries, stored procedures, triggers, and events in SQL Server 2008 R2.

Managed data, business processes/workflows, data transformation, data validation, data cleansing, data integration, and data modelling.

Involved in architecture, design of entity relationship diagram and development of conceptual, physical and logical data models. Provided support/help concerning metrics, reports, business intelligence tools, dashboards and KPI’s to ensure accuracy of data/reporting.

Assisted in PMR project in development of Universes, Queries, Dashboards Xcelsius and WEBI in BOBJ.

Attended meetings to identify/rectify issues/concerns and coordinating status/progress of the project.

Assisted PM and worked with Sr. Managers, SME’s, Data Owners, Business Process Owners, Consultants/Contractors, Vendor and Offshore Team to coordinate requirements/modifications of the project. Liaised and supported the Construction, Finance, Engineering groups in their reporting requirements.

Performed migration/testing across different environments (DEV/QA/PROD).

Assisted in Use Test Cases for UAT. Assisted in development and executed test cases/scripts in UAT.

Coordinate with Business Leads and internal customers in continuous business process improvements and issues/concerns. Involved in I.T. projects/initiatives.

Assisted in design and development of specifications such as Security Matrix, Process Flow diagrams with Swim Lanes, Flowcharts, Workflow, Systems Requirements Specs., Functional Specs., Non-Functional Specs., Data Requirements Specs and Traceability Matrix, UAT Test Plan/Test Cases and Cause/Effect Diagrams. Assisted in development of Training manuals and Quick Reference Guide for Users.

Received requests or ticket and solve/troubleshoot problems. Worked with the business to support/help in their requirements. Ensured proof of concept to establish whether the system satisfies some aspects of the purpose it was designed for.

Genentech Inc. - South San Francisco, CA 04/2009 – 03/2012

Business Systems Analyst/Software Engineer – MDM, Data Ops, Supply Chain, Materials

Imported tables from SAP and Oracle 11g/EDW into Access to design and develop programs/tools and GUI, data modeling for MDM and Data Operations group. Built latest master cube of all master data and production tables for auditing/reporting.

Build master cubes of all master data/production tables every week and send notification of update.

Manipulated and processed data in Access and created codes in Excel and developed queries in Access SQL or VB codes.

Analyzed, designed, debugged, developed and automated systems/processes in Access/VB/Excel/SQL for SAP Material Master/Recipes. Debugged existing programs in Access/Visual Basic/SQL. Created GUI/Interface and trained users.

Received ad hoc requests and produced reports depending on specs from different groups pertaining to Material Master, Bill of Material/Recipe and Business Rules/Processes/Audit Rules/Class A Data.

Developed/generated metrics for Class A, Pareto charts and publish report every week in Livelink to all Business Process Management, Business Process Owners, Data Content Owners and Data Stewards.

Extracted Material Master tables and Bill of Material/Recipe tables from SAP MM.

Supported MDM, data quality, data integration, data governance, data analysis, data extracts, data audits, data evaluation, data entry, data builds/synthesis, data mining, data validation, data cleansing, data transformation, data modelling and master data in SAP Material Master, Bill of Material/Recipe, monthly reports and ad-hoc reports.

Generated Daily Audit and Ad hoc Audit requests. Supported MDM and Data Ops Group/Supply Chain.

Managed and supported the Data Ops group and give directives to meet the deadline of the project. Worked and supported Directors, Sr. Managers, Managers and Supervisors in Reporting and Analytics.

Handled all ad hoc/monthly reporting requests for Clinical/Commercial, Supply Chain, Finance, Quality, Procurement and Logistics in SAP, BW, Access, VB, Excel, Oracle 10g/EDW. Supported with SAP/R3 functions in MM, Recipe Modules.

Involved in architecture, design of entity relationship diagram and development of conceptual, physical and logical data models.

Ensured that data/reports adhered to all processes/business rules/data dictionary and submitted gRemedy ticket for the business owner to make the necessary changes consistent to the business rules.

Maintained the database, data dictionary, business rules, system codes and programs.

Supported internal customers concerning business rules/processes/requirements, Material Master, Bill of Material/Recipe and all issues concerning SAP MM extracts, Access and Excel. Worked and involved in various projects and published weekly Class A Metrics for Business Process Owners and Data Content Owners.

Chevron Inc. – San Ramon CA 09/2008 – 06/2009

Data Conversion/Vaiidation – SAP Implementation and Data Conversion Project

Validated data integrity and accuracy of data from source to target in SAP.

Performed data analysis, data manipulation, data cleansing, data quality, data validation and data accuracy to ensure correctness of data in SAP.

Validated Customer Master, Vendor Master, Finance data etc, in SAP OTC, SAP PTR and SAP SCE.

Managed data extracts, data audits, data evaluation, data builds/synthesis and master data in SAP, Customer Master, Vendor Master, GL Master, Bank Master, Asset Master, P&L,Profit Center and Cost Center.

Executed codes for data validation/conversion for data accuracy.

Gathered data from different sources and convert/transform them into reports/analytical results.

Assisted in projects and other initiatives as per request.

Worked and supported in SAP FI/CO projects.

Assisted in development of Access database/VB codes for Finance. Designed and develop entity relationship diagram for database.

Managed spreadsheets, charts, comparison and analysis reports. Generated queries, modules and reports.

Developed documentation as per request.

AT&T – Los Angeles, CA 07/2007 – 06/2008

Design Engineer

Designed, aided and drafted engineering drawings in Autocad.

Attended weekly meetings concerning project status/updates.

Assisted in development of Access database/program for OSP Engineering. Managed spreadsheets.

Designed data modeling for database.

Attended trainings for continuous improvement of processes, systems and techniques.

BOC Gases (Linde Gases) Mississauga ON, Canada 04/2006 – 06/2007

Analyst – Marketing, Finance

Supported Master Data in SAP/R3 functions in CRM, Customer Master, Vendor Master, SD and FI/CO Modules. Supported Data Warehousing.

Worked comprehensively on BEx Analyzer, Report Writer, Query Designer, Web Application Designer and Administrator Workbench. Designed and implemented BEx, Web Reports and Templates in BW.

Assisted in architecture, design of entity relationship diagrams and development of conceptual, physical and logical data models.

Developed SAP BW cubes/queries for different groups to support accurate reporting.

Published scheduled weekly, monthly reports and ad hoc reports in BW Query Designer.

Developed ad-hoc queries/reports, static reports, dynamic queries and statistical analysis. Handled large volume of data.

Trained users on how to use BW, queries and report writing. Developed and maintained BW queries and workbooks.

Managed data extracts, data audits, data evaluation, data builds/synthesis and master data in SAP SD, Customer Master, Vendor Master, Sales and Finance Revenue.

Gathered data/information from different sources and convert/transform them into reports/analytical results.

Managed complex spreadsheets, charts and analysis reports. Developed numerous queries/reports based on specs.

Analyzed, designed, developed and maintained programs in Access/SQL.

Processed data in Access/Excel and creating macros in Excel and writing SQL queries/VB code in Access.

Involved in all project planning and forecasting using MS Project. Gathered functional and technical requirements.

Analyzed and developed and automated systems and applications for consistency and accuracy of data/reporting.

Committed to continuous improvement of quality, processes, system, analysis, data, reports, design, specs, changes and user support / training.

Ontario Energy Savings Corp. 07/2005 – 11/2005

Business Analyst – Finance, IT

Analyzed, designed, developed and maintained programs in Access/SQL. Developed numerous queries/reports.

Managed complex spreadsheets, charts and analysis reports. Generated/produced queries, modules and reports.

Validated data integrity/accuracy and used data manipulation, data cleaning and data mining.

Processed data in Access/Excel and creating macros in Excel and writing SQL queries/VB code in Access.

Liebert Canada (Emerson Network Power), Mississauga, ON 01/2004 – 04/2005

Analyst – Sales, Marketing

Developed ad-hoc queries/reports, static reports, dynamic queries and statistical analysis. Handled large volume of data.

Gathered data/information from different sources and convert/transform them into reports/analytical results.

Involved in all project planning and forecasting using MS Project.

Involved in architecture, design of ER Diagrams and development of conceptual, physical and logical data models.

Managed complex spreadsheets, charts and analysis reports. Generated/produced queries, modules and reports.

Analyzed, designed, developed and maintained programs in Access/SQL. Developed numerous queries/reports. Analyzed and developed and automated systems and applications for consistency and accuracy of data/reporting.

Validated data integrity/accuracy and used data manipulation, data cleaning and data mining.

Processed data in Access/Excel and creating macros in Excel and writing SQL queries/VB code in Access.

DOT, Toronto, ON 03/2003 – 01/2004

Analyst – Finance, Inventory, Logistics, Sales and Marketing

Liaised and coordinated with Store Manager and Operations in relation to Sales and Inventory.

Supported the Sales and Operations group in reporting and systems such as POS and Great Plains.

Analyzed, designed, developed and maintained programs in Access/SQL. Handled large volume of data.

Gathered/processed data in Access/Excel and creating macros in Excel and writing numerous SQL queries.

Processed data in Access/Excel and creating macros in Excel and writing SQL queries/VB code in Access.

Managed complex spreadsheets, charts and analysis reports. Generated/produced queries, modules and reports.

Validated data integrity/accuracy and used data manipulation, data cleaning and data mining.

Gathered data/information from different sources and convert/transform them into reports/analytical results.

Monitored/managed inventory and determine material for replenishment, obsolete items and handled reimbursements.

Committed to continuous improvement of quality, processes, system, analysis, data, reports, design, specs, changes and user support / training.

Immigrant Women Center-Community Employment Services 09/2002 – 10/2002

Human Resources Development of Canada (HRDC) Project, Toronto, ON Canada

Customer Service/Administrative Assistant (Temporary)

Scheduled and administered written tests and computer typing tests of clients.

Managed collection of data, inputting, printing and dissemination to the appropriate Federal/Provincial/Local or Third Party Providers. Produced weekly, monthly and quarterly statistical reports.

Perform any other duties necessary to facilitate the day-to-day operation of the center and its programs in a manner consistent with the center's philosophy and operating guides in an efficient and effective manner.

Entered clients information/records. Arranged files and records, maintained bulletin boards and display racks.

Entered and produced correspondence, proposals, contracts, work schedules, reports, agendas and minutes of the meetings using MS Word, Excel, Powerpoint and Access.

Ericsson Telecommunications Inc., 07/1996 – 03/2001

Engineer - Material Planning, Engineering and Contracts/Logistics/Inventory/Finance

Analyzed, designed, developed and maintained programs in Access/SQL. Handled large volume of data.

Gathered data/information from different sources and convert/transform them into reports/analytical results.

Validated data integrity/accuracy and used data manipulation, data cleaning and data mining.

Managed complex spreadsheets, charts and analysis reports. Generated/produced queries, modules and reports.

Analyzed and developed and automated systems and applications for consistency and accuracy of data/reporting.

Processed data in Access/Excel and creating macros in Excel and writing SQL queries/VB code in Access.

Gathered/processed data in Access/Excel and creating macros in Excel and writing numerous SQL queries.

Monitored/managed inventory and determine material for replenishment and obsolete items.

Involved in all project planning and forecasting using MS Project.

Committed to continuous improvement of quality, processes, system, analysis, data, reports, design, specs, changes and user support / training.

Siemens – Electronics Telephone Systems Inc. (ETSI), Manila Phils. 09/1994 – 06/1996

Technical Support Engineer - Transmission, Material Planning, Engineering, Logistics, Finance

Supported reporting and analytics for Transmission Systems.

Analyzed, designed, developed and maintained programs in Access/SQL. Handled large volume of data.

Gathered data/information from different sources and convert/transform them into reports/analytical results.

Managed complex spreadsheets, charts and analysis reports. Generated/produced queries, modules and reports.

Gathered/processed data in Access/Excel and creating macros in Excel and writing numerous SQL queries.

Processed data in Access/Excel and creating macros in Excel and writing SQL queries/VB code in Access.

Validated data integrity/accuracy and used data manipulation, data cleaning and data mining.

Monitored/managed inventory and determine material for replenishment and obsolete items.

Analyzed and developed and automated systems and applications for consistency and accuracy of data/reporting.

Involved in all project planning and forecasting using MS Project.

Committed to continuous improvement of quality, processes, system, analysis, data, reports, design, specs, changes and user support / training.

House of Representatives-Congress of the Republic of the Philippines 05/1992 – 08/1994

Legislative Executive Assistant II

Produced correspondence using MS Word and handled incoming and outgoing mails.

Prepared all schedules of privilege speeches, committee meetings and appointments.

Arranged filing system and kept all important/confidential documents.

Analyzed, designed, developed and maintained programs in Access and Foxpro.

Prepared MS Powerpoint presentations to be used in meetings. Produced reports using MS Excel.

ABS-CBN Broadcasting Corporation – Channel 2 03/1991 – 06/1991

Systems Analyst - Internship

Assisted the Research Department in all systems related activities.

Analyzed, designed, developed and maintained programs in DBase and Foxpro.

Maintained and track the commercials for each programs and episodes.

Prepared and produced automated reports.

DEGREE

St. Paul University Manila, B.S. in Computer Science, Manila Philippines, March 1992

University of the Philippines, units in M.S. in Computer Science, Quezon City Philippines, Dec. 1996

CERTIFICATE

Harvard University Online Continuing Education - Professional Certificate in Data Science – Ongoing

(R Basics (Done), Data Visualization (Done), Probability, Inference and Modeling, Productivity Tools, Wrangling, Linear Regression, Machine Learning and Capstone)

CAREER OBJECTIVE

SUMMARY OF QUALIFICATIONS

WORKING EXPERIENCE

EDUCATION



Contact this candidate