Amy Liu

Mobile: 469-***-****

Location: McKinney, TX 75070

Email: acq3wl@r.postjobfree.com

QUALIFICATIONS

• Extensive experience in PL / SQL coding (8 years)

• Extensive experience in writing Oracle stored procedures, functions, triggers, objects, tables (8 years)

• Expert knowledge in Enterprise Oracle 11g Database, SQL Server 2008, Data Warehouse, RDBMS (8 years)

• Extensive experience in star schema models, import/export, SQL Loader, AWR reports

• Excellent SQL Query Performance Tuning and Optimization, execution plans

• Database administration and performance tuning (Oracle db)

• TOAD v11, SQL Server Management Studio SQL application development experience

• Experience with Teradata, Hadoop, Hbase, Hive – Big Data

• Business Intelligence: Business Objects XI R2, WEBI, SAS, SAP Business Warehouse, SSIS (5 years)

• Experience with ETL / Informatica

• Experience with programming languages: C++, Java, HTML, CSS, JavaScript, JQuery

• Spring / Eclipse IDE development experience with Java, Grails, Groovy (2 years)

• Experience with XML, JSON, REST Interfaces, Mule ESB and API testing

• Application Development experience in a team environment, Agile/Scrum methodology, SVN, GIT, JIRA

• Strong analytical and problem solving skills

• Testing – Functional, Unit, Integration, Regression, UAT

• Bachelor's degree in Engineering (CS and EE core)

PROFESSIONAL EXPERIENCE

JPMorgan Chase, Dallas, TX

Application Developer, 2011 – May 2015

Database Development:

Successfully built the team’s Oracle database for the ‘Feed Management’ enterprise-wide project including the design and development of Oracle table structures, stored procedures, functions and objects.

Written PL/SQL code in stored procedures/functions (approx. 300) for UI automation such as search requests with pagination, pipelined table functions that utilize recursive algorithm to compute the status of feeds and its dependencies (time elapsed from its SLA) for the feed monitoring project.

Optimized database schema, table structures (indexes and partitioning) and optimized SQL (bulk binds and parallelized pipelined functions).

Developed SQL Server 2008 packages / procedures utilizing SQL Server Management Studio.

Successfully migrated (full life-cycle) month end process, tables, views, sampling methodology from SQL Server 2008 to Oracle database by understanding the current process to future end state and created an improved automated sampling methodology for the ETL of month end data.

Improved accuracy of data and reduced load time. Developed SQL (PL/SQL) code per business requirements in the DEV environment for production. Performance tuned Oracle database schema . Performance tuned SQL queries utilizing explain plans. Integrated Oracle SQL advanced querying techniques and hints in query for faster retrieval of data.

Database Administration:

Administered team’s Oracle 11g Database for DEV, QA and Prod environments. Created and maintained users and roles.

Other Development Experience:

Developed REST web services in Java, within Mule ESB, with stored procedures in Oracle for read / write actions. Familiarized with Groovy programming using Grails framework which included querying from Big Data database (Hadoop/Hbase/Hive) and UI development with HTML, CSS, JavaScript, JQuery. Participated in Scrum meetings utilizing the Agile methodology and contributed in a team environment to develop end-to-end applications that include the UI layer, the intermediate Enterprise Service Bus (ESB) layer written in Java utilizing JSON / XML, and the Oracle database layer.

McKesson Corporation, Carrollton, TX

Financial Application Developer, 2009 - 2010

Business Intelligence:

Successfully developed financial month end reports in Business Objects, SAP BW (Business Warehouse) and SSIS utilizing SQL. Developed ad-hoc queries for the business in PL/SQL for Oracle. Worked with IT to help in building Business Objects data mart (Universe) for A/R data for reporting in Oracle database.

Essilor of America, Inc., Dallas, TX

Application Specialist, 2008 - 2009

Oracle Demand Planner and ETL:

Successfully performed ETL for a new business segment historical data into Oracle Demand Planner database and successfully ensured accurate sales forecast was generated for future months.

Support Oracle Demand Planner (ODP) application in Oracle EBS for monthly forecast of sales. Performed statistical data modeling and ETL of sales history at month end for forecast in ODP. Queried sales, inventory data from SAS (downstream and upstream data from ODP). Other applications supported: DRP, MRP in Oracle EBS. Participated in Oracle 10g database upgrade and testing Oracle EBS modules before go-live: unit, functional, integration, regression and user acceptance testing.

Frito-Lay, Inc., PepsiCo, Plano, TX

Supply Chain IT Analyst, 2004 - 2008

Development Experience:

Analyzed and mined data to support Supply Chain business initiatives utilizing TOAD for Oracle 9i (in SQL), Business Objects (Business Intelligence) for sales history and inventory levels, Hyperion Essbase for future sales forecast. Performed data modeling on I2 Demand Planner sales forecast data. Performed root cause analysis on sales/forecast/inventory data utilizing all data sources mentioned. Worked with IT on requirements and user acceptance testing of company wide system enhancements. Gained knowledge in C++ development for applications. Gained knowledge in ETL utilizing Informatica.

EDUCATION

Bachelor of Science, Engineering, University of Texas – Dallas, 2003

(Core in EE and CS); 3.5/4.0 GPA, Cum Laude Graduate

Contact this candidate