SUMMARY:

• Demonstrated expertise in large scale project development,business requirement analysis, functional specification and development.
• Object Oriented Analysis and Design OOAD and n - tier architecture development for business applications.
• Strong planning skills combined with the ability to coordinate the efforts of many to meet organizational goals.

TECHNICAL SKILLS:

Software Tools/Skills: C (process, signal, multi-threading programming), Pro*C, Oracle Forms, PHP, VB6, VBA, ADO, ODBC, JDBC, subversion, Excel, VBA, Shell, gdb, makefile, COBOL

Web Skills: ASP.NET, VB.NET, C#, Web Services, winform, WPF, WCF, Entity Framework, Oracle Application Express, Java/servlet/JSP, HTML, DHTML, Javascript, JQuery, AJAX, XML, XSD, SOAP, IIS, CSS, XML-RPC

Middleware: COM/COM+/DCOM, MTS, ActiveX, Weblogic, CORBA, CGI, OpenView, Apache, TCP/IP

Databases: MS SQL Server, Transact-SQL, SSIS, SSRS, Oracle 8i/9i/10g, PL/SQL, MS Access, MySQL, PostgrepSQL

Design Tools/Skills: Visio, UML

Reports: Crystal Reports.Net /Active Report.NET/SSRS/Oracle Reports

Operating Systems: Windows, Solaris, SUN, AIX, HP, Linux

PROFESSIONAL EXPERIENCE:

Confidential, Irvine CA

Systems Analyst

Responsibilities:

• Responsible for consulting and delivery of full stack IT solutions to support business results for Sales /Finance/ Administration/CRM and data warehouse.
• Improved company’s customer acquisition and customer growth process by providing the most efficient and cost-effective solutions, system analyses, tables design, database management, user support and training for internal users of other departments.
• Analyzed database structures and built data warehouse, created scalable ETL packages to transfer from PostgreSQL to MS SQL Server using SSIS, generated finance documents/reports using SSRS.
• Finance - Increased database application speed by 80% by tuning stored procedures/indexes/queries
• Expert in merchant online payment implementation.
• Utilized trilingual language skills in collaborating with Hong Kong/Taiwan/Japanese branches to stay informed about current legislation, identified application functionality and business requirements to ensure applications met business requirements and technical and security requirements.
• Analyzed information processing and computation needs and architecturally designed Business Administration web application system using multi-layers framework.
• Designed and developed Interush-Payoneer Prepaid Card Management system.
• Upgraded ecommerce & member page websites.
• Diagnosed/conducted troubleshooting and coordinatedthe problem solving process to ensure that the business standards /requirements were met.
• Collaborated with banks and third party providers in planning, developing and implementing the Merchants online payment through different payment gateways such as UnionPay, Alipay, TenPay, 99Bill debit, Wisdtek, heartland/planet payment using REST/SOAP/PHP/Java/XML/JSON.
• Created company’s Japan/Taiwan credit card/postal recurring automatic payment batch.
• Collaborated closely with the management to prioritize business goals and information needs, software developers and other staff of other countries using trilingual ability.

ENVIRONMENT: C#, ASP.NET, WCF, Entity Framework, Angular JS, Notes, Java, JSP, JQuery, JavaScript, AJAX, PHP, laravel, HTML, HTTP, HTTPS, REST, SOAP, CSS, Linux, Postgresql, Microsoft SQL 2012, SSIS, SSRS, T-SQL, XML, JSON, Github, Eclipse IDE, subversion

Systems Analyst

Confidential, Santa Clara, CA

Responsibilities:

• Analyzed business requirements from finance department in a bilingual environment.
• Designed and implemented business rules, packages, procedures, functions, triggers, and Excel report generation engine.
• Researched and coded the finance data loading system from multiple data sources.
• Collaborated in architecting the system from application structure to database design.
• Designed, documented, installed and developed the web based system in three tiers Oracle environments.
• Designed and developed the web front end -user interfaces using Oracle APEX.
• Localization the system in Oracle environment.
• Provided the integration test plan and training.

ENVIRONMENT: Oracle 10g, APEX, Oracle API, Apache, JavaScript, HTML, CSS, PL/SQL, Linux, SQL*PLUS, subversion, Oracle Task Manager, PeopleSoft HRMS

Systems Analyst

Confidential, Minneapolis MN

Responsibilities:

• Analyzed and translated business requirements and business rules into highly technical specifications and planned schedule for completing the system.
• Participated in migration from C++ to .NET Platform.
• Architecture designed and developed into 3 tier web application system.
• Developed the front-end using ASP.NET, JavaScript, AJAX, C#.
• Implementation of business requirements and middleware components using C#, ADO.Net, T-SQL.
• Worked with DBA to write stored procedures for SQL Server 2005.
• Designed and developed Confidential Security Access SOAP web for Cognos Java clients.
• Defined query structure/interfaces with XML/XSD.

ENVIRONMENT: C#,.Net, Visual Studio 2005, ASP.NET, Microsoft AJAX Toolkit, SQL Server 2005, IIS, JavaScript, HTML, CSS, XML, XPath, XSD, web services, SOAP, VC++, Team Foundation Server