SUMMARY

• 15 years experience IT professional proved success in delivering and maintaining enterprise applications, B2B web applications build on various industries and technologies
• Subject Matter Expert and technical support for banking system built on SOA architecture utilize Spring, Hibernate, Strut2 framework
• System analyst and Subject Matter Expert for credit sales and acquisition system built on JAVA/C++/Oracle/Weblogic/Sun
• Software development in J2EE/C++/C for mutual fund pricing and reporting
• System analysis and design in UML
• Data analysis for credit card direct marketing
• System architecture and process flow analysis for B2B systems

TECHNICAL SKILLS

Project development management: SDLC, Agile, Six Sigma, PMLC

Cloud platform: AWS, S3, Heroku, Salesforce

Campaign management: Eloqua, Unica

Modeling: Rational Rose, Enterprise Architect, UML

Report: Oracle Application Express(APEX), Actuate, MS Excel

Programming Language: JAVA, C, C++, SQL, PL/SQL, Javascript, JSON, JQuery.

Database: PostGres, DB2, Oracle, MS SQL

Content Management System ( CMS ): Drupal 8

Framework: Struts, Spring, Hibernate

Scripting: XML, HTML, WSDL, JSP, PERL, AWK, SED, UNIX Shell, Perl, Javascript

Networks/Protocols: TCP/IP, HTTP, SMTP, SOAP

Development tools: Eclipse, SQL Developer, AQT, Websphere Studio, Oracle JDeveloper, VisualAge,, MS Visual Studio, Embarcadero Rapid SQL, IBM DB2 Stored Procedure Builder, Navigator, TOAD, SQL Programmer, Dream weaver, FrontPage

Build tool: Ant, Maven

QA tools: Jira, SOAPUI, Win Runner, Load Runner, Clear Quest, Test Director, Junit, Jtest

Version control: Clear Case, CVS, PVCS

Messaging: JMS, Web Services, WSDL, MQ Series, Axis

Scheduling: Autosys, Control - M

OS platforms: SUN Solaris, IBM AIX, Linux, WINDOWS/XP, MS-DOS

Web server: Weblogic, Websphere, Apache Tomcat

PROFESSIONAL EXPERIENCE

Business System Analyst

Confidential, San Francisco, CA

Responsibilities:

• Business requirement and system implementation research system analysis, functional analysis, identifies system process flows and data mapping information, create and maintain system functional documentations, provide enhancement recommendation for future release, propose different solutions base on different business requirements and available resource ( hardware, software, data, timing, etc) for existing production problems.
• Identify gaps between initial business requirement and production implementation, identify operation risk, customer impact and system impact, implement temporary fix and provide instruction on long term fix.
• Data analysis on complex data flow interweaving among different data sources and thru different processes, develop complex SQL and PL/SQL codes for reporting and research to improve product service. Data migration process exception analysis for Wachovia Conversion project.
• Document production issues and built them into knowledge base toolkit for the technical support team to help quickly identify problems and root causes
• Create and maintain working relationships with business owner, developer, infrastructure engineer, vendor and service provider, improve system operation by creating and managing effective communication channels
• Provide system support by researching system log, database, application source code, business requirements, team up with product managers, developers and infrastructure engineers to resolve issues
• Develope knowledge base application on Oracle Application Express(APEX) in PL/SQL, Javascript, AJAX, JAVA, HTML, DHTML, CSS
• Develope shell/perl/sql script to automate trouble shooting tasks, improve problem investigation efficiency by at least 50% on different applications

Confidential, San Francisco, CA

Sr. Analyst in Database Marketing

Responsibilities:

• Data analysis on web base real time prescreening process results, which is a special case of database marketing and campaign management process, conduct requirement analysis then translated to technical development requirements to database developers on how to implement new campaign products, which included credit suppressions, geographic suppressions and live bureau calls.
• Created and maintained MIS reports in SQL and Excel with pivot table features and embedded SQL/VB codes, diagnosed data movement anomalies, examined market response trends and suppression distributions, captured sales lift/drops, which then used in designing next campaign products. Reports include suppression reports, net down reports (for post to bureaus), sweep reports (confirm offer presented), waterfall reports, etc. Performed data audit on those reports.

Application Specialist/SME

Confidential

Responsibilities:

• Leaded and delivered multiple underwriting system projects, supervised application implementation through the whole development life cycle. Act as business-technical liaison for project initiatives. Technical lead in gathering and analyzing business requirements, created technical and functional specifications. Performed analysis of these specifications to ensure meet the business needs, ensure project delivered on time within budget.
• Streamlined process flow for underwriting systems in SSN Validation project. Resolved complex problems raised from integrating existing systems with new partner systems, meanwhile satisfy multiple credit models and new business needs.
• Resolved data discrepancies among different data models in Instant Credit Web Service project. Identified business concepts such as market channel, source case code, customer ID through whole data flow. Reconciled business process flow interacted among multiple systems.
• Prepared and executed UAT testing for new features, created test plan and test cases, coordinated with developers and internal users in testing and bug fixing
• Built the technical recovery plan from scratch while not too much information was available, completed system impact analysis, provided reports on potential lost in terms of system downstream impact, lost of accounts, if any of the components couldn't be recovered by planned recovery time, led recovery plan walk through, coordinated plan testing.
• Assist in handling production issues, trouble shooting, investigated problem tickets, provided impact analysis, root cause analysis and fix resolutions to reduce customer impact and keep customer loyalties. Recorded and reproduced production issues, system bugs, logged bug report, worked with developers and QA on functional test and UAT to verify bug fixed.

Confidential, Boston, MA

Software Engineer

Responsibilities:

• Implemented global pricing workstation project from project initiation to completion. Gathered business requirements, created use cases, logical design in Rational Rose with UML, functional specification and technical design in detailing code level specifications, programming in J2EE and PL/SQL.
• Created financial instrument reports in PL/SQL and Actuate, these reports were based on current market closing price, calculated open price for next hour/day, combine with business rules and financial factors. Reports generated from data in different database (Access, Oracle 8i and DB2).
• Created script and perform data import and export in different data formats such as from Excel to DB2, from DB2 to Oracle, created PERL and UNIX scripts to implement the data transformation. Identified segment data and consolidate with different data models to improved report accuracy
• Data analysis on market trends, holding distributions and cash percentage in a fund.
• Production support for existing system in C/C++, programming, testing and fixing bugs.