SUMMARY:

• Have 15+ years of experience in data analysis, data modeling, data migration, ETL(Extract, Transform & Load) solutions, Data warehouse, BI(Business Intelligence) reports, ORACLE physical data model, complex & sophisticated SQL, SQL & PL/SQL performance tuning, PL/SQL stored procedures & functions.
• Perform business requirements analysis, data analysis, data modeling.
• Design conceptual, logical and physical data models with TOAD/Erwin/Visio.
• Implement ETL(Extract, Transform & Load) solutions, Data warehouse and BI(Business Intelligence) reports.
• Implement ORACLE physical data model, complex & sophisticated SQL, SQL&PL/SQL performance tuning, PL/SQL stored procedures & functions.
• Design enterprise systems architecture(Web - based 3-tier Architecture).
• Manage the system development life cycle of enterprise systems with Agile/Scrum methodology.
• Implement data components to provide data layer API for the usage of business application developers.
• Perform Oracle application DBA work.
• Implement ETL solutions with programming languages, scripts, SQL & PL/SQL for Informatica Powercenter.
• Proficient in Oracle DDL, DML, PL/SQL, TOAD, SQL Developer, trigger, stored procedure, Python, Javascript, .Net, C#, Java, VB, ASP, C, C++...etc.
• Evaluate the outsourcing vendors and manage the oversea outsourcing work of business systems development.
• Propose the innovative operating infrastructures.
• Define IT operating methodologies/procedures/disciplines.
• Quick learner of the various business domains and IT technologies.

EXPERIENCE HIGHLIGHTS:

Confidential

Data Analyst, Data Modeler, DB(PL/SQL) Developer

Responsibilities:

• Performed business analysis, requirement analysis, data model design, ORACLE schema objects definition, system design and architecture for the electronic fabric manufacturing company.
• Designed conceptual, logical and physical data models.
• Implemented business rules with ORACLE triggers, PL/SQL, and stored procedures.
• Performed SQL& PL/SQL tuning to improve the enterprise systems response time.
• Implemented ETL solutions with programming languages, scripts, SQL & PL/SQL for Informatica Powercenter.
• Implemented data components to provide data layer API for the usage of business application developers.
• Designed web-based 3-tier system architecture.
• Managed the full software development life-cycle of Electronic Fabric Business System with Agile/Scrum methodology.
• Performed ETL solutions with Informatica Powercenter to build the data warehouse to support the implementation of Business Intelligence reports for the merchandise retail company.
• Performed business analysis and data warehouse solutions to implement analytical reports and provide on line inquiry to the customers of the beauty spa company.
• Implemented Visualized BI Reports with Tableau.

Confidential

Data Analyst, Data Modeler, DB(PL/SQL) Developer

Responsibilities:

• Performed business analysis on sophisticated credit checking processes of the commercial leasing business.
• Defined Standard Operating Procedures(SOP) for business operations.
• Conducted analysis walk-through with key users to confirm analysis deliverables: workflows, business rules and screen definitions.
• Designed relational data model & ORACLE schema objects.
• Managed the full software development life-cycle of Business Evaluation System with Agile/Scrum methodology.
• Implemented business rules with ORACLE triggers, PL/SQL, and stored procedures.
• Performed Extract, Transform and Load (ETL) solutions to move legacy data into ORACLE DB
• Performed system performance tuning (mostly ORACLE SQL&PL/SQL tuning) while tested with production data.
• Proposed the operating infrastructures, security policies, IT operating procedures/methodologies, change management as well as KM tools to achieve higher service levels and increase profitability.
• Analyzed business processes and organization chart to form business rules and formulas for each individual business unit so that profits and expenses for each unit can be measured.
• Managed the development of Business Intelligent reports for high-level decision makers.
• Performed heavy ORACLE SQL tuning so that report generating time can be dramatically reduced from minutes to seconds.

Confidential

Data Analyst, Data Modeler, DB(PL/SQL) Developer

Responsibilities:

• Performed business analysis on enterprise operations in commercial leasing industry.
• Defined Standard Operating Procedures(SOP) for business operations.
• Conducted analysis walk-through with key users to confirm analysis deliverables: workflows, business rules and screen definitions.
• Designed relational data model & ORACLE schema objects.
• Implemented business rules with ORACLE triggers, PL/SQL, and stored procedures.
• Managed the full software development life-cycle of Leasing ERP System with Agile/Scrum methodology.
• System performance tuning (mostly ORACLE SQL&PL/SQL tuning).
• Proposed the operating infrastructures, security policies, IT operating procedures/methodologies, change management as well as KM tools to achieve higher service levels and increase profitability.

Confidential

Business Analyst, Data Modeler, System Architect

Responsibilities:

• Performed business analysis on enterprise operations in commercial leasing industry.
• Defined Standard Operating Procedures(SOP) for business operations.
• Conducted analysis walk-through with key users to confirm analysis deliverables: workflows, business rules and screen definitions.
• Designed relational data model & ORACLE schema objects.
• Managed the full software development life-cycle of Leasing ERP System.
• System performance tuning (mostly ORACLE SQL tuning).
• Proposed the operating infrastructures, security policies, IT operating procedures/methodologies, change management as well as KM tools to achieve higher service levels and increase profitability.
• Performed business analysis on credit checking processes of the commercial leasing business.
• Designed relational data model & ORACLE schema objects.
• Managed the full software development life-cycle of Credit Checking System.

Confidential

Business Analyst, Data Modeler, System Architect

Responsibilities:

• Performed business analysis on call center operations.
• Defined workflows(steps, roles, responsibilities and business rules) for customer call-in service cycles.
• Defined KPI(Key Performance Indicator) to monitor more effectively the functioning of people and processes to improve customer satisfaction and achieve better enterprise performance management.
• Recommended redundant operational environments to ensure non-stop customer services.
• Designed relational data model & ORACLE schema objects.
• Managed the full software development life-cycle of Intelligent CRM.
• System performance tuning (mostly ORACLE SQL tuning).

Confidential

Business Analyst, Data Modeler, System Architect

Responsibilities:

• Integrated 3 KM key components: People, Process and Technology.
• Defined workflow procedures to capture business operational and IT problem-solving knowledge.
• Managed the development of Knowledge Management System to achieve KM objectives(Web-based 3-tier ORACLE system).

Confidential, DC

Consultant, Data Modeler, Application DBA

Responsibilities:

• Managed the development of new components of Satellite Operation Frequency Plan System (OFPS). Work including analysis, system design, ORACLE data model design, construction, testing, deployment and maintenance.
• Managed the outsourcing work of OFPS platform migration. Evaluated outsourcing vendors. Prepared OFPS data in ORACLE Database for oversea vendor’s developers: performed ETL solutions to scramble OFPS ORACLE Database to keep confidentiality while retain data integrity. Kept contact with vendor’s developers to resolve system migration issues. Verified the migrated system.
• Performed the work of OFPS interfacing with the satellite communications monitoring system. Implemented interface protocols using ORACLE PL/SQL triggers/packages/stored procedures.
• Produced instant Satellite services reports using PL/SQL upon business user requests.
• Performed SQL& PL/SQL tuning to improve the system performance.
• Performed ORACLE application DBA work.
• Adopted the repeatable process scenarios to deploy application patches and ORACLE SQL scripts to production environments.
• Managed the development of Confidential Operating Center issue tracking system (web-based 3-tier system IOC Logger). Performance benchmark had been done before deployment to ensure this web-based system responding promptly.

Confidential, McLean, VA

Expert System Developer

Responsibilities:

• Developed a rule-based expert system to help medical doctor on the accurate diagnosis.
• Converted the application’s platform from hierarchical to relational database.

Confidential, Rockville, MD

Consultant, Programmer/Analyst

Responsibilities:

• Enhanced Satellite Operation Frequency Plan System (OFPS) to satisfy users‘ change requests.
• Produced Satellite reports using ORACLE SQL & PL/SQL