SUMMARY:

• Hands - on senior level data professional with superior client-facing business skills in various industries.
• Accomplished IT professional with broad design, analysis and R&D project experience.
• Seasoned data architect and data modeler, excellent analytical skills and solution provision.
• Significant expertise in business application customer requirement analysis, analytics architecture, data analysis, data modeling, database design, implementation, and optimization, software system design and implementation, system optimization, system architecture.
• Good understanding of Software Life Cycle and OOD.
• Exceptional ability in concept development, prototype building.
• Innovative work, with patent writing and filing experiences.
• Unique mathematics and computer science background.
• Excellent verbal and written communication skills
• Led a performance tuning team for a real-time telecom network service monitor and provision system. The system-wide work encompassed all server system layers, from application on down to data repository and storage. I studied the entire system, synthesized opinions from task groups, identified performance issues, and mapped out solutions to boost performance, which, with the team effort, resulted in a total 2,100% improvement in system throughput through various releases.
• Led a number of data repository groups, performed hands-on SME interviews, synthesized business and system requirements, performed process and data flow analyses, data analysis, data solution, modeling, mapping, development & implementation, and performance tuning, encompassing entire database repository SDLCs, across multiple business channels.
• Designed and implemented a data-driven, rule-based double-entry financial journal sub-system that took financial business process logic out of software by moving and maintaining the business process logic from software into database, as data. This enabled flexibility of changing financial business processes through rule data changes, as opposed to undergoing development effort, speeding up delivery to clients by over 50%, with savings estimated at over $170,000 from development and testing effort per year.
• Designed and led the implementation of Enterprise DataBase (EDB) for a P&C insurance company’s new generation Policy Administration System (PAS). Following my design guidelines & methodology, while meeting requirements, the result design and implementation were very succinct, with much reduced overall complexity - which reduced both database and application layer development efforts & runtime overhead, achieved superb functionality, flexibility, extensibility, and excellent performance.
• Designed and implemented the Small Business Loan Application system overhaul for a financial institute, with bug fixes and new features for new business process solutions, and improved GUI. The deployment was flawless with superior quality, receiving zero (0) defect ticket before my departure.
• Led a 4-month financial Confidential project to its completion, with well executed plan and solution design, final delivery was two (2) weeks ahead of schedule.
• Performed high level system architecture designs, with standardization and consistency across the enterprise.
• Inventor of three (3) granted US patents, based on my data solution works.

EXPERTISE:

• Data Solution
• Data & Database Architect
• Data Modeling
• Database Design & Development
• Data Analysis & Science
• Performance Optimization
• Software Project Development
• System Analysis and Design
• Problem Formulation & Solution

TECHNICAL SKILLS:

Programming Languages: PHP 5, Perl 5, Python, C, C++, HTML, Apache/2.2.0, Visual Basic, Shell, SQL, PL/SQL, SybPerl, Transact-SQL, Open Client DB, TCL.

Databases & Tools: SQL Server, MySQL, Oracle, Sybase, Netezza, Berkeley DB, ERWin, ER/Studio, TOAD, SSMS, MySQL WorkBench, dbForge Studio, MS Office.

Platforms & Operating Systems: Linux/Fedora, Unix, Solaris, HP-UX, SunOS, FreeBSD, Windows XP/7/8.

WORK EXPERIENCES:

SR. DATA ARCHITECT

Confidential

Responsibilities:

• As the chief data architect and tech lead for the enterprise database project of a P&C insurance company, provided data solutions for their enterprise OLTP system’s data repository that replaced legacy systems.
• On the conceptual level, used the top-down, generic-detail design principles to simplify the overall design, achieved superb flexibility and extensibility, and with greatly reduced system complexity, which resulted in shorter development and test cycles for both database backend and application frontend layers, hence reduced overall project development costs, and future maintenance costs as well.
• Processed requirements from SMEs; coordinated with other teams on designs and activity planning.
• Designed and implemented enterprise data architecture, define data processes, and provide data solutions.
• Embedded performance measures into the data solutions and designs.
• Defined process flow, data flow, design data model (conceptual, logical, physical), create database.
• Defined, designed and implemented specialized triggers (i.e., functionalities beyond RI); designed and programmed complex stored procedures, with excellent performance.
• Helped application developers on their queries and accessing data repository; performance tuning.

INDEPENDENT DATA SOLUTIONS CONSULTANT

Confidential

Responsibilities:

• Worked on system revision and redesign according to new requirements, and performance improvements, involved in interviewing SME, defining project scope, and problem discovery, driving problem formulation and solution process.
• Defined new process and component solutions, and advised on their implementations.
• Created conceptual, logical and physical data schemas, implemented databases and tuned performances.

SR. DATA ARCHITECT, DATA MODELER, ANALYST

Confidential

Responsibilities:

• Worked in partnership with Business and IT at a major global financial institution to build a consolidated Retail and Wholesale Analytical Portfolio data warehouse supporting Consumer Finance, Account, Customer Analytics, and Credit & Risk Analytics for Consumer and Business banking sectors.
• This enterprise system will enable analytical models for risk strategy setting including risk rating and quantification, cross-sell measurement, and portfolio management/execution functions and empower underwriting department to make approval decisions in their loan portfolio.
• Analyzed and managed financial data quality/cleansing processes in data integration work, performed mapping and ETL process tasks.
• Contributed to data model revision process. My work helped to lay a solid foundation for the successful completion of the project.

SR. DATA MODELER & DESIGNER, SYSTEM ARCHITECT, ANALYST

Confidential

Responsibilities:

• Interviewed client SME (subject matter expert) to collect high level and detailed business requirements, wrote system requirements.
• Designed data architecture, created data models (conceptual, logical & physical) and database designs. Helped clients to establish data standardization. This work established directions and foundations for projects to build on, with a major impact throughout the project life cycle.
• Performed repository/database design and development across all systems, data analysis, and data quality processes, designed system and database performance tests, implemented performance tuning strategy and measures for storage system, schema adjustment, and tuned SQL queries, to improve system performance.
• Laid foundational work for an in-house e-commerce system (on a LAMP platform), including overall system design, process and data flow analyses, system architecture, data architecture, database models (conceptual, logical, physical) and database development.
• Designed and implemented a rule-based double-entry financial accounting journal sub-system for an in-house e-commerce system that allocates funds to all relevant parties and accounts based on financial business rules. The core of the system entails its rule database and rule engine processing business rules.
• Designed and developed a data mart for a financial sub-system, with analytical report modules. Performed conceptualization, data analyses and modeling, and designs of a POS (Point Of Sales) system, of a Labour Scheduling system, and of a shopping card sub-system.

DIRECTOR OF DEVELOPMENT, ARCHITECT

Confidential

Responsibilities:

• Interviewed business process SMEs, developed the Confidential (Enterprise Business Process) business and system requirements, system process and data flow, and the system conceptual framework, and the specifications of the architecture and high-level system and component designs.
• Created high level system architecture design, data architecture and data model (conceptual, logical, and physical) for the Confidential system. Designed and developed server backend database and modules.
• Hands-on experience on Confidential system development and test works. Led development team, achieved the various targets on time.
• Designed and developed a web-based return merchandise registry system, including its two-tier database system (for better real-time performance), created a prototype for the system, designed and executed performance tests and performance tuning for front end, backend, and component communication.

SENIOR MEMBER OF TECHNICAL STAFF

Confidential

Responsibilities:

• Worked on R&D of ServicePath, a telecom service providers’ real-time network service assessment, assurance and provision system.
• Led the repository team. Implemented a Confidential (Very Large DataBase), solving many related technical problems in the process.
• Established data standardization across the enterprise
• Made many technical contributions to the architectural and functional design and processes, algorithm designs and implementations, and various components, using my analytical and problem solving skills.
• Led company’s patent process, including patent evaluation, writing and filing.
• Personally wrote and filed five patent applications, of which three have been granted. My work had major impact on strengthening the company’s intellectual property position, and gained us a competitive advantage.
• Created interactive shell script to automate complete system install process at customer site, including DBMS installation and configuration, application installation and configuration, application database instance creation and configuration.

MEMBER OF TECHNICAL STAFF

Confidential, Murray Hills, NJ

Responsibilities:

• Undertook research and development of Confidential, a communication network usage data collection and usage-based network billing system.
• Managed, designed and implemented the data solution for Confidential system.
• Performance tests and tuning.
• Designed and implemented a prototype for Net Mediator, a key component of Confidential . Net Mediator analyses and aggregates raw data into a concentrated and refined form that is more palatable for network billing, services and various data analyses.
• Analyzed network traffic data en massy in search of user usage and traffic patterns. This work directly resulted in significant improvement on the abstract data model and network usage billing structures.

SENIOR SPECIALIST

Confidential

Responsibilities:

• Designed and implemented the process flow and some of the interactive financial service call center systems and their underlying financial data model, database design, and application components.
• Designed and implemented the Small Business Loan Application system overhaul.
• Led the Confidential project that was delivered satisfactorily two week ahead of schedule.