Profile

A result-oriented Software Developer with 10 years extensive experiences with diverse roles in IT industry focus on design, developing, integrating and deploying complex large-scale web and windows form applications. Proficiency in database design and development, data warehouse ETL process and analysis in fast-paced environments. Exceptional knowledge and expertise in architecting and developing complicated multi-process applications using .Net framework. Well-developed problem-solving, multi-task, organization skills, and competence under pressure in sophisticated environment.

Technical Skills

Languages/Software: ASP / ASP.NET ADO / ADO.NET IIS JavaScript JQuery Ajax XML Web Service HTML CSS Crystal Report VB / VB.NET C Java C C COBOL

Visio MS Project TFS Agile SharePoint Photoshop

Databases: SQL Server T-SQL SSIS DTS SSRS ETL MS Access / VBA Script

Operating Systems: Windows 95 / 98 / NT / 2000 / XP / Vista / 7 / 8

Professional Experience

Confidential

Computer Programmer

• Developed various dynamic, interactive web and window applications as well as reports centralized dashboard programs and SSRS reports. They were acting as important daily working tools for management and department employees, which helped make their healthcare service process more productive, efficient and created more profits to company's business. Fully responsible for applications' development, testing, implementation and deployment.
• Modified and upgraded existing programs by adding new features and functionalities to optimize and maximize users productivity.
• Responsible for SSRS reports design, deployment and setup.
• Maintained, troubleshot existing programs and provided users support when needed.
• We used Visual Studio 2013 .Net Framework 4.5 with source control under TFS, Asp.Net and VB.Net, JavaScript, Ajax, SQL Server 2014 and SSRS SQL Reports Builder.

Confidential

Senior Developer

• Developed a program to export employee tax file automatically to Equifax. To follow Equifax tax file specification, it designed T-SQL script to extract required data from SQL server, implemented it as SSRS report on report server designed and scheduled SQL job to retrieve and manipulate report data from report server created report subscription to export SSRS report in excel format via Windows File Share, and transmitted it to Equifax secured FTP site via EDI. The program was running completely automatically needless of any human touch, which replaced old tedious weekly manual process originally handled by accounting personnel.
• Designed and developed operation alert program for Red Prairie 'RP' warehouse system. The program evaluates warehouse inventory status based on written T-SQL script, automatically send out alert by email using SQL Database Mail to group of managers if operators fail to follow up some key process that will cause inventory balance and status not being updated correctly in time, and further cause errors on customer daily inventory reports. The alert program helps managers quickly identify and correct mal-

Confidential

• operations on warehouse production, prevents inventory errors on RP warehouse system and customer inventory reports.
• Designed SSRS reports on SQL report server, set up report subscriptions, delivered reports automatically via E-mail or Windows File Share to a file folder with report formats of excel, PDF, CSV files etc.
• Modified and troubleshoot various Access DBA programs for management and business units.

Confidential

Leading Software Developer

• Acting as industry-wide leading Software Developer, responsible for new applications development, existing applications upgrade and maintenance, management decision support analysis, production line systems trouble shooting and on-call users' support.
• Working with all level end users on their systems development requests. Have developed applications not only for Brother Industries U.S., but also for Brother international industry-wide like Brother Industries in Brazil, China and France, etc.
• Acting as architect of all systems design starting with business analysis, specification discussion, prototype design, flow chart, system design, coding, integration and testing, installation and deployment, users' training and system maintenance.
• All systems consist of process data collection to database system, self maintenance features like objects adding, deleting, searching and editing, and pre-designed live summary reports.
• All developed systems are using all or some of following technologies: .Net framework, Asp.Net, VB.Net, VB6, Access VBA Application, SQL Server table, view, stored procedure, function , Crystal Report, Visio, Bar Tender software, etc.
• Have experiences of .net applications configuration and deployment on IIS server. Also experienced cross-country applications configuration and deployment with language, keyboard and culture globalization setup.

Confidential

Consultant / Crystal Report Writer

• Intensively worked on data from financial system.
• Extracted data to MS Access, manipulated, designed and created crystal reports for Health Insurance Program, Long Term Disability Program, Retirement Program, Investment Loan Program and Growth Income Fund Report etc.

Consultant / SSRS Report Writer

• Worked on clients financial and accounting system.
• Extracted data to SQL Server, designed Account Receivable Aging Report, Invoice Statement, Monthly Revenue Report etc. for top management using SQL Server Reporting Services.
• Designed and developed web tools with security and login controls using ASP.Net to deploy monthly or quarterly updated Crystal Reports, SSRS reports on company's intranet for top management to review.
• Extensive excel experiences with formulas, functions, sort, filter, vlookup and pivot tables.

Confidential

Decision Support Analyst

• Designed and developed databases, tables, SQL queries, stored procedures and views for new clients.
• Provided professional information services to banks, insurance and financial clients. Conducted projects including weekly on-boarding, direct marketing campaign, campaign tracking, history promotion, and ad hoc researches.
• proficiency in advanced T-SQL scripts, batches, SSIS integration services and SSRS reporting services to automate complex process.
• Extracted data from outside data source including OLE DB source Access, Oracle, DB2 and SQL Server , excel and flat text files. Designed stored procedures and T-SQL scripts to transform extracted data to fit operational needs, and loaded into database in SQL Server.
• Designed codes and implemented a variety of marketing campaigns using effective segmentation and fulfillment models to approach target customers and grow clients' business.
• Designed and generated various campaign tracking result summary reports, exported to PDF, Excel or Text files using SSRS reporting services to analyze customer responses to marketing programs with focus on sales, incremental sales and profitability.

Confidential

Database Programmer Analyst

• Provided information services to multi-client via direct marketing campaigns, conducted professional database design, development, analysis, problem-resolution, and process development.
• Experienced and skilled in large-scale database design, stored procedures, views, transactions, locks, index, advanced SQL queries, linked server, DTS package design, and jobs scheduling.
• Extracted, transformed and loaded data into SQL Server from various data sources, including Access, Oracle, Excel, and Text files.

Confidential

Programmer Analyst

• Designed and developed integrated web-based Global Projects Reporting System and e-Procurement Management System. Online Reporting System greatly reduced operating cost and improved efficiency. E-Procurement Management System gained visibility and control over corporate purchasing and expenses. They had been highly appraised by President of Thyssen Northern American and widely used within organization and its affiliated companies.
• Experienced and in-depth understood software development full life cycle SDLC , including prototype design, specification, coding, testing, implementation, documentation, user instruction, training, and technical support.
• Provided all programming and analysis support for top management and internal departments on their decision making process using variety of programming languages, tools, and technologies.