Business Analyst, Tester, Data

June C. Kao

Senior SAP Consultant

Phone: 650-***-**** Email: ********@*****.*********:********@*****.***

www.linkedin.com/in/junekaohttp://www.linkedin.com/in/junekao

SUMMARY OF QUALIFICATIONS AND SKILLS

Dependable GIS Business Analyst responsible for SAP data cleansing, ensuring that actual assets were correctly represented in the system of record. Collaborates with internal and external business team members to consistently meet or exceed timelines and resolve problems.

Area

Details

20+ years of experience in Utility Business Process at PGE

●Extensive understanding of the PGE Business processes

●Experience with working in different groups and organization

●Strong business process knowledge of multiple Lines of Business

10+ years of experience as SAP Developer/tester

●Experience in the development, implementation and deployment of SAP/ABAP applications

●Expertise in R3 SAP Work Management module

●Provides ABAP Functional and Technical design documentation and testing

15+ years of experience as database analyst and programmer

●Ability to take on difficult tasks and follow though to completion

●Designs, develops, modifies, debugs and evaluates application programs

●Extensive experience with data analysis and reporting

●Prepares development documentation, recommends changes in development, maintenance and system standards

●Develops conversion and system implementation plans and trains users

TECHNICAL SKILLS

Area

Expertise in

Languages

ABAP, HTML, Visual Basic, SQL

Database

MS SQL Server, MS Access

Software/Tools

SAP R3, SAP BW, Smartforms, SAPScript, MS Office, DMS

Reports

Crystal reports, SAP ALV, MS Visio

SAP Test Tools

Quality Center, LoadRunner

Other Tools

ET GIS Web Viewer

PROFESSIONAL EXPERIENCE

Pacific Gas and Electric Company (PG&E)

GIS Business Analyst

2015 to Present

Responsibilities:

I was responsible for creating the Requests for Work to update the SAP data with the information received from the field asset inventory being performed on approximately 450 transmission lines. I worked in the Electric Transmission Geographic Information System as part of the Electric Transmission Field Asset Inventory (ET FAI) team conducting data cleansing of SAP. Worked quickly to enable the project team to minimize the amount of time that work was suspended on the T-lines.

Responsible for creating any Requests for Work (RWs) which originate from the field asset inventory currently being performed. Having an Initiate and ensure accountability and timely resolution of requests to other business units.

Concurrently managed multiple work streams having overlapping and various schedules.

Evaluated and processed requests to modify SharePoint data, including data upload to SharePoint and associated Access database.

Located and analyzed information for gas pipelines in a Geographic Information System (GIS).

Reviewed and potentially annotated documentation related to gas transmission and distribution pipelines.

Performed large scale data analysis to identify and resolve issues with data quality and provide reports of corrective actions to team leadership.

Recorded all work performed in detailed and concise narratives as needed.

Pacific Gas and Electric Company (PG&E)

SAP Test Lead

2012 to 2015

Responsibilities:

As a senior SAP Consultant for SAP Test Team, my responsibilities include SAP table maintenance for the Work Management group in SAP Plant Maintenance module, design/development of Test Strategies, Test Plans, Data Analysis, Test Models, PT/Integration Test/UAT Use Cases and Test Scripts by utilizing my in depth technical and functional knowledge in SAP. O&M testing of Outage Management applications and related interfaces with CC&B and SAP for major Data Center Modernization project.

●Obtained extensive SAP cross functional module knowledge.

●Performed End-to-End Interface testing between SAP-OSB-GIS.

●Extensively worked on Data cleansing activities including the Business Users.

●Have been working on the RW (Request for Work) Notification process to get the data in sync between SAP and GIS.

● Analyzed user requirements, design specs and models for testability.

●Designed and Developed Test Models (Test Scenarios, TCERs) and data requirements, and executed Test Scripts using HPQC 11.

●Participated in functional and technical specifications meetings to evaluate requirements and implementation approach.

●Participated SAP EhP6 technical upgrade Regression Testing for building and executing end-to end RT scenarios/scripts in the EAM (WM) group.

●Supported SAP WM Table Maintenance and Change Requests for Production bugs and/or enhancements for Gas applications.

●Managed and tested post-Production defects following defect life cycle (from new to closing) in HPQC 11 (Defect repository). Followed up and reported defect status to the supporting teams.

●Developed other Test Documentation (i.e., Test Plans, Data Analysis, Test Summary Reports for business clients in accordance with ITM Methodology.

●Analyze requirements to develop test plans and test cases for Outage Management applications. Execute functional, regression and end to end test cases to verify business and technical requirements.

Pacific Gas and Electric Company (PG&E)

SAP Developer

2005 to 2012

Responsibilities:

Developed and maintained SAP programs for Work Management department. Well versed in SAP ABAP Programming (Reports, ALV, BDC, User exits (Enhancements), BADI implementations, BAPI interfaces, function modules), Testing, Technical specification preparation, Technical documentation, and SAP-script/Smart-forms for WM modules.

●Saved company millions of dollars by designed and implemented a Data Conversion project which imported raw data into the SAP Production for over a million gas equipment items. This helped centralized and eliminated user errors throughout the company territories

●Developed enhancements reports logs and summaries using ALV grids. The reports included ALV pop up boxes and ALV on ALV screens.

●Designed SAP interface, database, forms, portal, ALV reports, online screens, and batch job. Collaborated with internal and external business team members to evaluate business requirements, objectives, deliverables, and project deadline Analyzed and assessed existing business systems, processes, and procedures.

●Designed complex programming and analysis to ensure it thoroughly covered and applied to all business requirements.

●Consulted with clients to identify, understand, anticipate, and meet current and future business needs. Provided timely, professional, straightforward (non-technical) communications.

Pacific Gas and Electric Company (PG&E)

Programmer Analyst / Developer – IT Application Services

1999 to 2005

Responsibilities:

Provided operational support and enhancements to IT Application Services in depth experience with VB Programming (using Visual Basic to code a complex report for MS Access or Excel)

●As key analyst for eTimesheet, provided daily technical support for over 500 users, helped manager and team lead to run department budget report. Imported, deleted and modified users in eTimesheet. Helped admin to align the correct order number in SAP and monitor back end of SQL server.

●Prepared accurate and timely development and testing estimates for all programs, ensuring development effect met client budget.

●Provided on-call support for production systems in a timely manner.. Responded to ad-hoc questions and intra-departmental communications.

●Performed day-to-day tasks to ensure systems were up and running. Solved problems, fixed bugs, and applied repair patches.

●Created, modified, and configured applications/systems, as specified in the requirements and technical specification documents.

●Provided application design and implementation to automate data processing.

Pacific Gas and Electric Company (PG&E)

Database Analyst

1987 to 1999

Responsibilities:

Provided operational support and enhancements in Electric Transmission Service Department. Analyzed database for the department by using complex Excel v-lookups and pivot tables report.

●Created, maintained, and supported Access database programs and Excel macros for the billing administrators and coordinated the data for cash flow and booking.

●Prepared and analyzed accurate and complex Excel v-lookups and pivot tables report streaming data gathering for billing processor.

●Imported, manipulated, and analyzed raw meter usage data from MV90 (Legacy Meter System) and various other sources to create reports in Access and Excel for ISO upload to regulatory commission.

●Designed the Contracts Information Systems and Transmission Request Services database, to improve user interface by adding complex functions for data entry screens, report generation, maintenance screen, and utility screen.

●Created a complex Visual Basic macro that extracted raw data from various sources and generated a summary report in MS Excel format.

●Created PowerPoint presentations to improve reporting for management, staff, and outside audiences.

Contact this candidate