SUMMARY:

• Confidential has 9 years of focused experience on designing and delivering large scale data warehouse and data management solutions.
• She has very extensive expertise with the ETL, data analysis, data modeling, data integration and SSIS.
• In addition, she is experienced with data management methodologies, financial models, and the investment lifecycle management.
• Confidential is a strong project leader, a quick learner, a creative designer, an excellent analyzer, a talented data modeler, and a fierce troubleshooter.
• She performs well under pressure, and has been demonstrating the ability to lead the team to timely produce project deliverables of quality.
• She has served in the financial services industry for 9 years.

SKILL:

Methodology: Data Management Methodologies, Financial Models (Option Pricing, Cashflow), Investment Lifecycle Management, Object Oriented Programming, SDLC, Agile Process

Data Warehouse & Data Management: Data Warehouse (OLTP, Data Modelling, Bi - temporal), Data Integration, Data Analysis, Change Data Capturing, Data Management (Market and etc.)

Financial Data: Bloomberg, Markit Partners

Database System: Oracle (10g, 11g), SQL Server (6.5 / 7.0 / 2008/2013 ), DB2

Development: PL/SQL, MarkitEDM, MS SSIS, VSTS, Tibco Messaging, Crystal Reports, ER Studio, T-SQL, XSLT, XML, SAS, Java, JavaScript, C#

Operating System: Windows, UNIX

EXPERIENCE HIGHLIGHTS:

Confidential

Lead Data Warehouse Programmer/Analyst

Responsibilities:

• Led the analysis and design to expand data processes and data models for the data integration
• Led the project team of three to expand table structures, views and mapping tables to in corporate new financial data structures
• Created a most optimal design to integrate new data via performance-tuned codes to process data volumes with huge scopes efficiently, which provided a best throughput for downstream processes
• Developed critical Oracle PL/SQL codes to integrate financial data into the data warehouse
• Data Warehouse Programmer / Architect of the Market data Project (10 months)
• Designed and led two programmers to build more than four hundreds mastering level data matching and transformation rules
• Designed and developed about sixty bi-temporal data models to manage data parental relationships and histories
• Designed and developed about twenty SSIS packages for managing data histories and versioning for our financial data
• Designed and implemented the Type 2 data capture and version management systems
• Lead Data Warehouse Programmer of the MarkitPartners Market Data Integration project (7 months)
• Designed and led two programmers to implement the fully automated MarkitPartbers Market Data solution, which has been very-well received and appreciated by the vital finance department. The solution utilizes the straight-thru workflow to obtain new deals and deal changes trading systems, send deals data to Markit for valuation; and return valuation data into our data warehouse, all in a fully automated mode
• Enhanced the MarkitPartners Index solution by designing and implementing the review module, which provides a very convenient avenue for users to revise deals data before the MarkitPartners valuates them
• Lead Data Integration Programmer of various third-party data (2 years)
• Designed and led the developments of solutions for integrating third-party financial data into the enterprise data warehouse. Worked with various types and formats of third-party data end-to-end (csv, xml, tab..etc)
• Designed and built a sophisticated solution for highly complex processes such as the Bloomberg Index, where comprehensive considerations were incorporated for dependency and timing requirements in upstream and downstream data flows
• Designed and led the implementation of various solutions to feed third-party bond pricing data
• Regularly worked with users in aforementioned divisions to define / clarify requirements, to suggest best technical solutions, and to troubleshoot UAT and in production issues Led and coached team members / consultants by providing the guidance, supports, and knowledge transfers on data processes, data enhancements, change managements, as well as new technologies

Confidential

Software Developer / Analyst

Responsibilities:

• Designed, and developed an automated report-checking system to analyze and compare the Crystal reports generated from the company's Performance, Attribution and Composite Management software.
• The system assured that the report data were completely accurate and current
• Performed detailed data analysis via in-depth SQL queries to analyze and eliminate data table discrepancies, which were caused by the adoption of an new data model for the Performance Measurement functionality
• Daily exposures to T-SQL and PL / SQL stored procedures, functions and triggers, performance tunings, data mappings, and relational database designs
• Data analyzed / quality assured the Performance Measurement functionality of the company's core Portfolio Management software
• Performed detailed data analysis and verifications on reports generated by the company's Investment Management software

Confidential

Financial Applications Developer

Responsibilities:

• Analyzed, designed, developed and supported the real-time stock trading front-end application for trading equities, options, and futures. Also developed dynamic link libraries for this front-end application to revise orders in baskets
• Improved the trading application's functionality by refining the data manipulation for databases and other market quote applications
• Developed and supported C++ embedded SQL, stored procedures, and triggers for Trading clearing back-end application
• Utilized Crystal Reports to retrieve clients' order history data from archival databases, and to generate position reports
• Transformed business requirements into applications' functional specifications
• Exposed to all SDLC phases, including the analysis, design, development, testing, customer and support
• Utilized MS Visual C++ 6.0, MFC 6.0, and SQL 6.5

Confidential

Mathematical Programming Intern

Responsibilities:

• Refined calculation methods of a nuclear physics scientific software
• Analyzed mathematical software modules, designed verification approaches, did thorough verifications, and wrote detailed reports
• Revised existing mathematical models with new algorithms and data structures
• Compared computer simulation results with experimental data, and wrote detailed analysis reports
• Designed and developed a UI prototype application via collecting end-user requirements, applying the GUI design methodology, and the JavaScript coding