A dedicated, collaborative and results-oriented Computer Systems Analyst-Programmer with extensive experience in all phases of the systems development life cycle (SDLC) using SAS and SQL, passionate about learning, eager to employ outstanding analytical, quantitative, and problem-solving skills to meet clients’ needs.• Data Analysis • Systems Analysis• Systems Design & Development • Quality Assurance• Database Design • Documentation & ImplementationI am passionate about helping people, playing piano and classical music.
-
Sr. Computer Systems Analyst, Analyst ProgrammerPacific Gas And Electric Company 1999 - 2012San Francisco Bay Area• Nominated as Employee of the year in 2009 for Outstanding Customer Support.• Gathered system requirements and collaborated with business users on system re-engineering and improvement requirements for the interdepartmental sales revenue interface project . This included: o Performed systems analysis and created analysis report of findings. o Designed, developed, documented, and implemented the system, o Created interface file for the SAP system which enhanced the accuracy of effectively tracking PG&E interdepartmental sales revenue. o Performed testing of the interface system for SAP system upgrades.• Analyzed, designed and developed a time constrained 20/20 credit feasibility study project in SAS.• Initiated, designed and led the development and implementation of the system for generating discrepancy reports using SAS, SQL, and Excel to validate the database Interface System so as to ensure data accuracy and data integrity of the system..• Managed, coordinated, performed quality SOX compliance testing, End-to-End assurance testing for Financial Transaction/General Ledger interface and various billing interface systems to support companywide re-platform project in AIX/Oracle from Mainframe/DB2 . This included running CC&B background processes. -
Senior ConsultantKeane, Inc 1996 - 1999San Francisco, Ca-• Developed and maintained Employee Skills Inventory Database using MS Access• Coordinated, analyzed, designed, and tested various time-constraint Y2K projects for cooperations such as Levis Strauses & Co, Matson Navigation Company in San Francisco, and Sears Canada Inc., all projects completed on time and within budget. -
Systems AnalystMci Systemhouse 1993 - 1996Toronto, Canada AreaWorked on the outsourcing project for Ultramar Canada.• Performed consultations, root cause analysis, and feasibility study for sales and marketing.• Trained and assisted programmer analysts on SAS and QMF in project team.
Alice L. Lei Skills
Alice L. Lei Education Details
-
Mathematics And Computer Science -
Mathematics -
Lamp And Unix/Linux Fundamentals Certificates
Frequently Asked Questions about Alice L. Lei
What is Alice L. Lei's role at the current company?
Alice L. Lei's current role is SAS Developer.
What schools did Alice L. Lei attend?
Alice L. Lei attended San Francisco State University, San Francisco State University, City College Of San Francisco.
What are some of Alice L. Lei's interests?
Alice L. Lei has interest in Social Services.
What skills is Alice L. Lei known for?
Alice L. Lei has skills like Sdlc, Sql, Visio, Sharepoint, Systems Analysis, Requirements Analysis, Requirements Gathering, Database Design, Pl/sql, Unix, Integration, Microsoft Excel.
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial