Lea Chen
SR. CONSULTANT - PARADIGM GLOBAL - BP, PROS PRICING AND MORE
Houston, TX
-(281) 907-3572
Work Experience
SR. CONSULTANT - PARADIGM GLOBAL
BP, PROS PRICING AND MORE
-
Houston, TX
2008 to Present
MY CLIENTS INCLUDE HEWLETT PACKARD, BP, PROS PRICING AND MORE
BUSINESS CONSULTANT/ADVISOR
• Work with small to med size businesses to understand their needs; review and provide specific points for improvement of profits.
• Review business documents, gather requirements, define and develop solutions, give presentations regarding to operations, P & L, business structures, break even analysis, sales & marketing, tax advantages and more.
• Create strategies and procedures for clients to improve their services and efficiency.
SOLUTIONS ARCHITECT
• Work with cross function global teams to organize and manage Information Gateway / Business Data Repository
• Communicate with all level Business/IT owners to evaluate problems, identify risks and provide solutions to ensure successful project completion
• Provide leadership in strategic project planning and systematic process design across multiple domains, mentor
and assign developers for development activities
• Lead conference calls with senior managers & clients to discuss product design and project roadmap, present
solutions and provide analysis on critical issues, manage cloud services, data warehouse and SaaS projects
• Review business documents, gather requirements, define and develop solutions, give technical presentations
• Influence clients and help define technical standard for business needs, identify value opportunities and provide
process optimization
• Provide data warehousing solutions, work with marketing department on EDW (Enterprise Data Warehouse) to define data transfer and data mapping solutions, support user BI dashboards (Qlikview) and marketing and sale
channel data reporting
• Facilitate information gateway data transformation/migration (ETL), and provide directions to technical staff
• Define Informatica data transfer solutions to bring data from SQL Server to Vertica database
• Work with Vertica database , SQL Server, Hadoop; define and review data schema, and data mapping
SR. ENERGY CONSULTANT
• BP upstream data management, MDM, BHDM, ORACLE databases, SQL, Linux, Recall, Mirror, PWE
• Effectively led and managed cross function projects; meticulously assessed business process and provided
solutions; identified and mitigated project risks; managed master data and ensured data quality
• Gathered, prepared and defined business requirements, integrated business needs into IT solutions; performed
data analysis through SQL and BI systems
• Provided business evaluation; developed business system requirements for software package
• Worked with business and development teams to optimize processes and improve end results, 20% improvement
• Effectively defined data requirements, performed data modeling, created database structures; managed detailed
data reporting; implemented business solutions using Oracle, SQL
• Created business cases, performed business modeling with Excel for budgeting and forecasting
• Shell scripting development to improve the efficiency of processes and to manage delivery time line
SOFTWARE DEVELOPER/CONSULTANT
• Effectively trained, managed, and mentored development team on software development projects
• Optimized processes for projects, generating a substantial time savings of 50% and cost savings of 20%
• Managed product development & delivery; communicated effectively with all level personnel and customers
• Developed automation testing tool using Microsoft PowerShell, C#, UISpy, SQL
• Gathered requirements and designed software products. Provided problem resolution to critical problems
BUSINESS ANALYST/SOLUTIONS ENGINEER
• Led pre-sale projects; reviewed business process/solutions; translated business requirements into system
requirements, provided pre-sales technical assistance and product demonstration & education
• Provided BI solutions, generating more than $5M in sales for pricing and business intelligence software
• Configured business systems; mapped data to database; performed data analysis to ensure quality
• Collaborated with business and financial analysts, reporting, forecasting, budgeting, as well as pricing and revenue management; created effective solutions for Sonoco, Conoco Phillips, and Anheuser-Busch
• Provided data solutions for optimization, used OLAP cubes, Microsoft SQL Server Analysis Services(SSAS)
• Designed data warehouse used dimensional modeling and star schema. Provided leadership in the BI product
design, development and implementation.
2 Page
Houston, TX (281) 907-3572
SOFTWARE DEVELOPER/CONSULTANT
HEWLETT PACKARD
-
Houston, TX
2007 to 2008
• Integrated business requirements into system designs; managed development team of 4-6 professionals
• Developed and implemented software automation tools for firmware testing using C/C++, Linux, SVN, SCSI,
BMIC, RAID and smart array controllers, increasing production time by 100%
• Developed website interface for testing results and triage with Java, XML, AJAX, Google Web Toolkit (GWT),
Eclipse IDE, Toad and MySQL - web solution populated daily testing results and tracked feedback, increasing
productivity by 20%
BUSINESS ANALYST/CONSULTANT - PROSPERITY WORLD TRADER
Houston, TX
2002 to 2007
• Successfully managed comprehensive projects to meet deadlines and budget requirements
• Gathered requirements and created business cases; provided training to business users
• Communicated with all level management to resolve problems and provided solutions
• Managed complex data/data modeling; generated various reports with SQL and Oracle database
• Used C++ to create applications for business transactions
SYSTEMS/SOFTWARE ENGINEER
COMPAQ COMPUTER CORP
-
Houston, TX
2000 to 2001
• Developed firmware flush and upgrade application tool in the Linux environment using C/C++, resulting in a substantial 50% upgrade time savings for customers.
• Tested Compaq controller firmware, meeting deadline 100% of the time
• Programmed and customized the functions for the firmware testing tool according to the firmware specifications
SYSTEMS ANALYST
MEMORIAL HERMANN
-
Houston, TX
1996 to 2000
• Provided technical support and service to the nurses and doctors for various software systems
• Implemented, assessed, and supported Cerner Healthcare Management System
• Provided dynamic technical solutions for users within functional areas in regards to software applications,
improving operations by 25%
• Generated clinical data reports (CCL, PL/SQL stored procedures, ORACLE EBS) customized applications
• Improved proficiency by successfully developing a 30% time saving application for physicians and nurses
3 Page
Education
Master of Business Administration in Finance
University of Houston Main Campus- C.T. Bauer College of Business
Master of Science in Computer Science
University of Southern Mississippi
Bachelor of Engineering in Electronic Engineering
University of Science and Technology of China
Skills
business intelligence (9 years),Linux (10+ years),ORACLE (10+ years),solutions (10+ years),SQL (10+ years)
Links
Additional Information
Core Competencies
• Business/Financial Analysis • Develop Solutions • Cloud Computing
• Managerial Leadership • Communication Skills • Data ETL
• Client Service/Relation • Development/Implementation • SDLC
• Strategic Analysis • Business Intelligence • Data Warehouse
• Budget Analysis • ORACLE /SQL Server • C++/Java/OO
• Create Application Systems • SQL/T-SQL/XML • Big Data
• Data Management • Data Mining and Analysis • Supply Chain Management
• ERP • Linux/Windows