SUMMARY

• 10 - year experiences in Financial, Tech, Insurance and Semiconductor industries
• Extensive experience in Database and SQL Server
• Familiar with VBA and EXCEL expressions to perform Data Analysis
• Experience in Business Intelligence(BI) Tools including Tableau, SSIS, SSRS, MicroStrategy, BO
• Experience in data reverse engineering using Microsoft Visio
• Experience in Python
• Experience on project management, collected and analyses user requirements, documented the Technical Specifications, develop and deploy solution
• Excellent communications and positive working attitude

TECHNICAL SKILLS

Databases: SQL Server 2000/2005/2008 , MS Access, Object Oriented Database

Data Modeling: ER-Win, Visio

Programming Languages: T-SQL, SQL, C++/C#, VBA, Python

BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Service (SSAS), Data Transformation Services (DTS), MicroStrategy, Business Object, TABLEAU

Development Tools: Eclipse, Net beans, Visual Studio, MATLAB

PROFESSIONAL EXPERIENCE

Confidential, NYC

Business Analyst/Project manager

Responsibilities:

• Business proposal and marketing research for mobile application development
• Formed relationships and close contact with key decision makers of the account
• Analysis user requirement and develop business requirements and functional design documents
• Estimate and track expense, timeline and resources of the project
• Analyze data and aggregate modules for reuse
• Design and perform functional test, prepare testing documents
• Analyze Federal Reserve Report and Translate into Business and Technical Requirement
• Collects quantitative information on selected assets, liabilities, funding activities and contingent liabilities on a consolidated basis and by material entity subsidiary
• Retrieve trade data including Fixed Income and Equity products from various source including Anvil, Wall street Money Market, MMI, FFI etc
• Classify LST class mapping by product type, legal entities, business line, maturity date etc, leverage on Bloomberg LCR class
• Design and architect the reports to identify and monitor overall liquidity profile supervised by the Federal Reserve
• Using Tableau to automate monthly and daily reports
• Coordinate with various departments and personnel to retrieve and validate key information
• Provide report of timely information on liquidity risks during periods of stress in different Scenario and Behavior Assumption
• Support daily issues and client’s Adhoc requests.
• Provide training and support of Tableau reports to the team
• Analysis user requirement and develop technical solutions, prepare documents
• Use Syncova to calculate margin, develop and override margin rules, making margin calls, running sample profiles of different margin processes.
• Load Price, FXRate, Position, MarketData, Instrument etc data into database using Syncova and Job Scheduler
• Schedule Reports using Job Scheduler by writing shell script and SSRS subscription.
• Develop Margin Details, Margin Summary etc reports in SSRS

Environment: Microsoft SQL Server 2008, Microsoft Visual Studio 2008/2010, Syncova, Job Scheduler

Confidential, NYC

Architect/Developer

Responsibilities:

• Design and implement frontend and backend trade booking system for MBS/ABS Strategies
• Architected new database in SQL Server to provide easier, more accurate and much faster system for clients, structure tables, views, developed functions, table functions, triggers and procedures
• Integrate legacy data with current system
• Develop ETL process for data migration
• Perform Analysis in EXCEL, SQL Server and ACCESS for reconciliation data from two system, find out any missing trades, securities or incorrect records
• Develop a process to calculate PnL, Accrual, Adjustment, Risk and generate Daily, Month to date, year to date reports. Calculate PnL by Security, Strategy, Portfolio level
• Develop several EXCEL sheets for clients to load, update, delete and retrieve data from database using VBA and T-SQL including Securities, Trades, Factors, Accrual rate from Bloomberg.
• Automation of the Adjustment process by creating SSIS package
• Export data to Mid-office for further analysis as well as getting feeds from mid-office for adjustments
• Provide technical training to the group on SQL Server and ETL tools

Environment: Microsoft SQL Server 2008, Microsoft Visual Studio 2008/2010, Team foundation Service

Confidential, Jersey City

Application Developer

Responsibilities:

• Interacting with Business Analyst, translate business logic into technical requirement
• Developing reconciliation process and matching logic for Credit Risk and Market Risk between different data sources by creating complex stored procedures, triggers, views and functions
• Running and monitoring reconciliation process and analyzing breaks.
• Preparing various reports for Counter Party, MTM, Trade Pop Summary in format of SSRS, UI, excel to support Risk Data Management analysis team
• Working with Quartz team perform analysis on Object Oriented database
• Create Technical Design Document and deployment document for release

Environment: Microsoft SQL Server 2008, Microsoft Visual Studio 2008/2010, Team foundation Service

Confidential

Database Developer

Responsibilities:

• Modeling the Data Warehouse for Data Mining and reporting
• Created stored procedures, triggers and functions to support efficient data storage and manipulation
• Design the ETL process to clean and feed data warehouse
• Improve the query performance with best practice
• Architect Microstrategy projects, create Logic model and Facts, Attributes, Metrics, Hierarchies
• Create complex Microstrategy reports by designing filters, prompts, Threshold, Drill etc.
• Deliver Predictive analysis by using Clustering, Regression, Decision Trees, and Association algorism
• Build different models for Data Mining purpose
• Design and develop SSIS packages for downloading, cleaning and mapping the data in ETL process

Environment: Microsoft SQL Server 2008, Windows 7, Microsoft Visual Studio 2008, Microstrategy

Confidential, Parsippany, NJ

Database Developer

Responsibilities:

• Analysis, Design, Model and Create the HCPRM database objects for healthcare project
• Participate in conference with customer to gather user requirement, prepare, modify and review Interface Agreement
• Created stored procedures and functions to support efficient data storage and manipulation
• Filtered bad data from legacy system using various T-SQL, and implemented constraints and triggers into new system for data consistency.
• Create varies complex Stored Procedures for loading, exception handling and de-duping process
• Created views as required by front end developers for easier implementation on web pages
• Optimized the query performance by index/re-index, updated statistics
• Design and develop SSIS packages for downloading, cleaning and mapping the data in ETL process
• Response for loading initial and historical data in format of Flat Files, Excel File and legacy System from different feeds using SSIS packages
• Design and create SSIS packages for automation process for daily, weekly and bi-weekly loading
• Regular back up production database and restore the reporting databases, monitoring SQL jobs.
• Design and develop multi-dimension cubes for complex reports requested by client by using SSAS and SSRS
• Using Excel pivot table to generate complex reports
• Documented the database objects, procedures, functions for future references and maintenance

Environment: Microsoft SQL Server 2008, Windows Server 2003, Microsoft Visual Studio 2008

Confidential, Marlton, NJ

Database Developer

Responsibilities:

• Interact with internal users and customers, documented the Business Requirement and Work Flow
• Response for developing Repricing rules for Core Engine using T-SQL
• Query performance improvement and enhancement in programming point of view.
• Create varies DTS and SQL Server Integration Service (SSIS) packages Extract Transform and Load (ETL) data from different data source (csv, flat file, Excel).
• Lead of Florida, New York and New Jersey Auto Insurance Medical Fee Schedule Update by using DTS packages and .NET programs
• Create Stored Procedures and Functions for Data cleansing and validating
• Involved in Migration project to SQL Server 2008, migrate DTS packages to SSIS packages and reports to SSRS reports
• Create varies reports including Excel, Access, Crystal and SSRS reports for internal users, management and customers
• Response for developing numerous complex Stored Procedures, Functions, Tables and Views to support .NET application(Spectrum) and Reporting Service
• Response for developing .NET applications in C# for Document Mapping, Invoice, Bill Editing and Repricing, and Ad-Hoc reports using C# and T-SQL
• Response for developing Access application for Requests, Dashboard, Claimant information using VBA
• Prepare Release Documents and supporting Production Deployment
• Investigate and Analysis the help tickets and provide third level production support.

Environment: Microsoft .NET Framework 3.5, Microsoft SQL Server 2000/2008, Microsoft Access 2003, Windows Server 2003 SP2, Microsoft Visual Studio 2005/2008/Team Foundation Server

Confidential

Process Engineer

Responsibilities:

• Review manufactory design, generate layout, set up profile to run qualification, perform testing and finalize machine programs/parameter for new IC products.
• Create SOP for existing and new procedures, support and provide training to production line.
• Work with ETL team to design and built Extract Transform and Load process of production data from FAB 300 to Manufactory Database System
• Worked closely with the data warehouse team to create various reports such as failure code, yield by using Business Object with Oracle
• Using EXCEL and VBA to perform Data Analysis of yield, trend, major defect and reason, generate rework plan and adjustment process
• Weekly presentation to the company with other departments
• Documentation of Failure Mode Effects Analysis (FMEA), Control flow, EFC, etc.
• Perform production audit and response to customer complaint