SUMMARY:

I wish to continue to grow as a BI developer. I enjoy software development and tend to build long lasting friendships with the team I work with. It’s the people that I work with day to day that makes work fun and exciting.

COMPUTER SKILLS & LANGUAGES:

• SSIS, SSRS, SQL Server 2005/2008/2012/2014 , Visual Studios 2005/2008/2012/2015 , Team foundation Services, Geneva, UltraEdit, SharePoint, Solomon, Great Plains, Concur, Action, Electra, Swift, Markit EDM, Autosys, NxR2 Risk Analytic System, Sungard PTA, CDOSuite, Macromedia Dreamweaver, MS Word, Access, Excel, Power Point, Project, Visio, Fireworks, Filezilla, IntexCalc, Intex API, Duco
• Power BI, Tidal, Trace Recon, Duco Recon
• C# .NET, VB.NET, ASP.NET, SQL, TSQL, PL/SQL, Visual Basic, HTML
• Fluent in English, Cantonese, and Mandarin
• Certificate in Markit EDM (Markit Enterprise Database Management Solutions), Medical Billing
• Certified Oracle Database Administrator 8i (OCP)

EXPERIENCE:

Associate / Senior Developer

Confidential, CA

Responsibilities:

• Lead group of 4 offshore BI developers to support data automated needs firm wide such as new custom reporting, third party ETL, and day to day support.
• Worked as a team to migrate hundreds of existing automated jobs from legacy in house build system to Tidal system. This involved different type of jobs such as ftp, sql, executable, powershell scripts, and custom tools.
• Migrated and upgraded legacy 2008 ssis packages to latest 2016 version.
• Lead IT SOX and SOC1 control, I had to make sure controls are being followed by all developers and entitlement reports.
• Implementing Power BI to firm for dynamic reporting.
• Project manage and lead quarterly disaster recover testing
• Responsible to integration data from our PAM accounting system to different systems such as Trace or Duco for cash recon.
• Create custom reports using SSRS and subscription framework.

AVP Software Developer

Confidential, CA

Responsibilities:

• Architecte data warehousing, reporting and business intelligence infrastructure and specializes in ETL and interfacing with third party applications.
• Manage and lead off shore development team on software development projects.
• Worked on major integration projects such as Geneva to Integration database (data warehouse), Solomon to Concur, OMS to Action settlement system to Swift custodian notification to Omega broker notification, and many more.
• Upgraded Action 7.2 to 8.0 and created custom scripts to interface with existing order management system and Swift.
• Upgraded Swift to Alliance Lite 2 from Lite 1. Lite 1 was very unstable and resource consuming.
• Upgraded SQL Server Integration Services from 2008 to 2012. Converted ssis packages from package deployment model to new project deployment model.
• Integrate with 3rd party pricing vendors such as Markit (Loan, CDS, Bond, IRS, IRCap, IRSwap), JPMorgan CLOs, Thomson and Reuters (secondary bond prices), and IDC (primary bond) using SSIS and Autosys to load prices to Geneva.
• Written SSRS Reports and used Subscription Services plus Autosy for night cycles automation.
• Handle PGP encryption and decryption between vendors and Ares.
• Had experince going through major company wide financial application upgrades such as going from Portia to Geneva. Geneva to security master Edm.
• Took charge as lead developer for SSNC Recon development, guaranteeing data quality and accuracy for data import automation such as cash transaction, backdated entries, and weekly holding.
• Automate process of sending reconciliation files to major trustees such as USBank, Bank of New York Melon and many others.
• Administer Dynamic SL Solomon 6.5 and 8.0 for all accounting department. Created custom report and customized interface.
• Administrator and perform jobs automation with Autosys. Perform code review with all Jil script developed by all developers.
• Design and develop using T - SQL to develop and maintain customize reports using Microsoft Reporting Services (SSRS).
• Automate Markit Loan and CDS pricing data import from pricing vendor into Portia, Geneva, and WSO.
• Create and enforce SSIS standard and guidelines and support documentations.
• Create support infrastruture for any new 3rd party applications we take on.
• Assist in IT audit process for SOC1.

C# ASP.NET Web Application Developer

Confidential, CA

Responsibilities:

• Create new reports and product enhancements using C#, .NET 2.0 Moving toward 3.0 and SQL
• SQL quality benchmark using SQL Server Query Optimizer prior rolling into production.
• Develop and debug using Visual Studio 2005 Team Environment.
• Perform Cold Fusion to Asp.Net file conversions.
• Create Reports with Reporting Services and SQL Server Reporting Web Services
• Participate in open team discussion on N-Tier architecture throughout development cycle.
• Participate in peer code review with team members
• Assist with creating demo environment in cold fusion and .net.
• Assist troubleshooting on existing issues.
• Take ownership on projects such as Reporting Services, Audit Trail, and Version Division.
• Persistent on creating detail documentation on all software enhancements.
• Setup tools for traffic monitoring in company job portal.

Software Engineer

Confidential, CA

Responsibilities:

• Patented Proprietary Web Referral Module
• Using VB Classes, function calls, pass by value, pass by reference to achieve results.
• Features allow physicians to view patient report online
• Schedule appointment requests
• Using Secure Socket Layer (SSL) certificates to produce 128 bit encryption, HIPPA requirement.
• Language was coded in ASP, Visual Basic, and Java.
• Object Oriented Programming with Relational Diagrams
• Database skills use are such as Triggers, Store Procedures
• Used Profiler, Query Analyzer, and Enterprise Manager for Database Development.
• Use Macromedia Dreamweaver and Visual Studios combined to produce development and test environment.
• Team lead with Database Administrator to set objectives and timelines.
• Demo and done presentation to gain customer and management buy-in.
• Online Registration Web Form (Tri-Tab)
• Build using ASP, ASP.NET, ADO, Visual Basic .NET 2.0
• Using Code Behind and Web Configuration files
• Design Database Schema for relational database
• Setup IIS (Internet information Services)
• Use Master Page and Place Holders in .Net 2.0 for easy maintenance
• Customer Support Ticket Tracking System (Support System)
• Build 3 versions of the ticket tracking system
• Started off with classic ASP with Object Oriented Programming
• Programming Languages use are Visual Basic, Java
• Markups used are such as CSS, HTML
• Easy Maintenance and Upgrades with proper include files
• Software Migration from ASP to ASP.NET
• Prototype and draft initial Graphical User Interface for best usage prior to system development.
• Work with Chief Information Officer to draft specification and best documentation.
• Team lead to set timelines, develop objectives and timelines
• Written complete SQL Migration script to convert and transfer data from different support systems.
• Develop future enhancements and provide support to software usage
• Development educational and training classes for corporate usage
• Create, market, support, maintain company’s current website. Designed, develop, debug, and update consecutive versions of web applications for internal Support ERP Systems and Sales System and Clinical use electronic medical record systems using ASP, ASP.NET, VB .NET, C#, Dreamweaver, Fireworks and SQL. Custom made financial and managerial reports for client use and internal use using MedReport, SQL, ASP.NET, and Crystal Reports. Coordinate development meetings for company’s development department.
• Coordinate backup and recovery plans for SQL Server 2000 databases. Performance tune databases with industry database tuning standards. Write SQL scripts for database data and object migrations. Mine random data for valuable financial reports.
• Redefined company training workflow. Created central information source and proper sub teams and team leaders. Renewed company wide training materials. Maximize training revenue through redesigning training class room layouts, curriculums, class size, and sales methods. Coordinated meetings for training team of more than 10 people. Teach company basic and advance level Electronic Medical Record (EMR) and Practice Management (PM) Courses.
• Set company hiring benchmarks. Travel to client sites for training, sales, and support. Daily on call bases for company EMR and PM medical product support.

Project Manager

Confidential

Responsibilities:

• Project manages largest account in company history. Interview, document and setup workflow analysis with client.
• Setup and clarify communication channels with client and team members.
• Host weekly project client and team meetings.
• Gain commitment for tasks, dates, and personal assignments from resource managers.
• Update project plans throughout life of the project and provide updates to external and internal team members.
• Make rational decisions for crisis handling to achieve timely project sign off.
• Present the facts and follow up with invoice payment.
• Report directly to upper level management.
• Estimates work, evaluates trade-offs with schedule, scope, risk, performance, maintainability, operability.