Camy Lau Email & Phone Number

Greater Denver Area

Greater Denver Area

SAP Data Conversion Lead and Application Support Lead roles in Utility Industry. • Successful upgraded of MV90 (Software and Hardware) generated accurate gas readings (>10,000). Enhanced bill customers with correct gas usage to increase customer satisfactions.• Escalated and led the daily diagnose sessions resulted in fixing the slow performance issue with the application IEE. The fix was implemented in production that allowed business quick access to information, increasing our team’s productivity by 50%.• Led the meter resources worked with database team in completing 4 applications data encryptions to fix security gap. • Led a daily SWAT team to resolve the MV90 unresponsive port issue. The result highly reduced the costs of meter site visits by 50%.• Worked with client to prioritize incidents, defects, enhancements, issue and risk management.• Ensure consistent support and delivery for meter data management systems (MRAS, IEE, MDMS, FCS, ARCS) and system availability meets client expectations, and SLA management.Pre-CIS Planning Data Conversion Lead for a Regulated Public utility Company• Coordinated with business/data owners to gather requirements, established source systems listing and identified Conversion Object Inventories. Analyzed and performed legacy data mapping to SAP data model for data integration approach. Contributed to the project deliverables on data mapping and data cleansing profiles.

Data architect that has consistent proved track records of delivered successful technical and data architecture solutions with wide range of technologies: data warehousing, ETL, BI reporting, data modeling, SQL server and Oracle. Has substantial experience throughout all phrases of the software development lifecycle in scalable enterprise applications in multiple domains.Data Conversion Architect for an ERP back office transformation project • Led data conversion on an ERP Global 9.1 Implementation effort to move legacy ERP (Master and transaction) data to the new PeopleSoft applications for a multi-billions dollar agricultural client that has been formed through the merger of many smaller companies.• Collaborated with client on all aspects of planning, design, development, highly complex global requirements and conversion cycle execution. Managed 10 offshore technical resources to get the conversion processes completed.• Gained the trust of client and requested to perform data conversion lead on a newly acquired company in Australia upon Go Live to U.S. Account Payable and Account Receivable systems.Senior SQL Developer / DBA for a supply chain project for an American brewing company• Replaced legacy system by new SAP Infor brewery planning and packaging system in St Louis and Jacksonville breweries. Implemented functional & technical design requirements in the newly designed databases to address gaps in forecasting for brewery production planning and scheduling.• Developed stored procedures and views used to transform the data coming from the source systems into a format that can be interpreted by Infor. Provided guidance to SQL performance issues/indexing.• Worked on SQL object promotions, data load, go live support, Excel / VB reporting, applied SQL transactions code, and mass updates of SQL stored procedures.

Arvada Co

Toastmasters officer

Served the Board of Directors on Michigan Avenue Toastmaster. The club achieved the highest recognition within the Toastmaster organization. Developed simple visuals to improve general evaluation skills in the club. Completed the competent communicator program within the year of duty.

As Lead programmer, completed conversion from Access 2.0 to Access 97 for a complex, international accounting reconciliation system. An international Finance group of a Fortune 500 Corporation utilizes the system.Designed and developed an Access 97 Project Requirement Tracking application. The application allows the client's developers to store project requirement-related information into the database. It defines interrelationships between requirements and can produce various reports to analyze and manage requirements.Worked with a team that wrote a commercial product for a consulting firm's consumer marketing group. The application allows for a marketing research analyst to search through large amounts of grocery marketing data. Was developed in Visual Basic, Access, C, and C++.Developed and executed a test plan for a product written inb Visual Basic for an actuarial consulting firm.

Managed and coordinated the daily work activities of 15 field auditors and 2 data entry staff in the streetlight project for a major electric utility company. Designed, developed and coordinated a terrestrial microwave communication system. This requried the design of environment systems for communication shelters including HVAC and standby power systems.Developed an application PROMACS, a Windows based program for Monitoring the availability of component and systems. Development was done using C, Visual Basic, Access, Openscript and Toolbook (an object-oriented programming software tool). Developed a dBase IV application to track and isloate technical training requirements.

Had extensive experience with electrical power system analysis software including DAPPER (Distribution Analysis for Power Planning Evaluation and Reporting), CAPTOR (Computer Aided Plotting for Time Overcurrent Reporting)