Yan Zheng
Cell: 402-***-**** ********@*****.***
QUALIFICATION SUMMARY
• Four years of IT experience in applications development
• Familiar with all phases of SDLC using UML and solid knowledge of OOP
• Knowledge of other software design methodologies such as RAD, JAD, SCRUM
• Involved in developing n-tier enterprise applications using Microsoft .Net and SQL Server 2000/2005 technologies.
• Adept at developing web-based and desktop applications with great usability, high productivity, and easy code maintenance using .Net framework and T-SQL.
• T-SQL query performance tuning
• Quality-conscious programmer who KISSes (keep it simple, straightforward), embraces standards, and strives for bug-free and easy-to-maintain programs.
• Involved in project documentation including requirements, design, functional and technical specifications, test plans and user manuals
• Involved in project diagrams using Microsoft Visio
• Passionate self-starter and creative problem-solver.
• Conducting unit tests and integration tests for .Net applications and T-SQL
• Team player with strong work ethics and good interpersonal skills
• Highly-organized with the ability to multi-task and meet deadlines
• Driving production issues to resolution
• Certification: MCTS (Microsoft Certified Technology Specialist on web client development)
PROFESSIONAL EXPERIENCE
JP Morgan Chase, Chicago, Illinois Sept 2008 to Date
Commercial Card IT (CCIT) at Treasury Services
Engineer of GSA Project (Government Service Agencies)
Develop and enhance various components in multi-module multi-tier C#.Net-based web applications. Project highlights:
Pen Test project that validates user input through HTTP request and rejects user-supplied Cross Site Scripting. Specific technologies and tools: Telerik RadControls, ASP.Net Ajax, MS Anti-XSS Library, TamperIE
CapFraud web-based application that generates liability (fraud case) notification mail and reports in pdf and word format. Specific technologies and tools: Crystal Reports 11, SSRS
Email Alerts Module: a comprehensive C#.Net solution that enables the admin user to set up the frequencies, thresholds and recipients for different account/transaction/payment/statement-related email alerts. Work with Accenture designers and offshore Indian engineers. Technologies and tools: WCF web services, .Net remoting service, design patterns, MSMQ, ControlM scheduler, MSDTC, dtctester
Develop unit tests and test harness. Technologies and tools: NUnit 2.0, TestDriven.Net, Selenium IDE.
Plan and perform integration testing in staging environments. Management tool: Mercury Quality Center 9.2
Work with DBAs and SQL developers on the design, enhancement and performance-tuning of SQL stored procedures and triggers.
Coordinate with architects, designers, business analysts, QA, testers, production support and deployment team to track the life-cycle of code defects. Management tool: Mercury Quality Center 9.2
Instrumental in phased GSA releases to QA/UAT/production environments. Troubleshoot on Web/App/Instrumentation/SQL servers in staging and QA environments.
Programming Languages: C#.Net, ASP.Net, ADO.Net, JavaScript, T-SQL, XML
Main Environments and Tools: MS.Net Framework (1.1, 2.0, 3.0), MS WSE (2.0 & 3.0), WCF, Visual Studio 2005, .Net Framework SDK Command, MS Application Blocks, SQL Server 2005 Management Studio, IIS 5.1, CruiseControl.Net, IBM Rational ClearCase 7.0 thin/thick clients, Asp.Net Ajax
JP Morgan Chase, Chicago, Illinois Dec 2007 to Sept 2008
Commercial Card IT (CCIT) at Treasury Services
Level II Production Support Consultant
Take ownership of and troubleshoot production issues for the web applications and backend processes of critical commercial credit card applications: PaymentNet Legacy (VB6 and ASP based) and PaymentNet3 (.Net based).
Backend T-SQL development.
Co-ordinate bridge calls with multiple IT groups: Level I Production Support, SQL Server DBAs, Operations, Networks, Relationship Management
Assist in development, testing, QA, deployment and migration of new releases and hot fixes of the commercial card applications.
Programming Languages: C#.Net, ASP.Net, ADO.Net, JavaScript, T-SQL, XML, VB6, ASP
Main Environments: Visual Studio 2005, .Net Framework SDK Command, MS Application Blocks, SQL Server 2000 Enterprise Manager, SQL Server 2005 Management Studio, IIS 6.0, Visual Source Safe 6.0, IBM ClearCase, ControlM job scheduler, Ajax, Crystal Report 11
Third-Party Ticket Tracking Systems: HP Quality Center, IBM ClearQuest, Peregrine System
Accretive Health, Chicago, Illinois March 2007 to Nov 2007
.Net Application Developer
Member in the Front End Team focusing on cleaning and securing data early in the hospital revenue cycle in order to maximize regular reimbursement (middle) and minimize back end collection efforts.
Developed CDM (Hospital Charge Description Master) Management Tool built on top of ACH web portal and DotNetNuke framework. The tool allows CDM managers in multiple facilities to maintain the CDM list, examine the validity and accuracy of existing charges in reference to coding and rate standards issued by CMS (Centers for Medicare & Medicaid Services), and review the utilization volume of the charge items, and their impact on revenue over time.
Developed File Exchange Management Tool on top of ACH web portal and DotNetNuke framework which reports the life cycle and QA statistics of daily flat files transmitted and transformed among hospital facilities, ACH, and collections agencies. The tool also presents the configurable FTP locations, DTS packages, and allows scheduling for importing flat files into staging database and loading data from staging database to transactional database. This project has provided tremendous value to Site Leads, the Implementation team, the Data Integration team, and the Operations and Support team.
Designed and implemented reusable classes and user controls for ACH web portal:
Exception Handler class that integrates with DotNetNuke built-in exception handling routines, notifies subscribers for specific projects, and logs exception details to XML files and SQL server database.
Excel/CSV Exporter user control that contains Infragistics Net Advantage menu control. This user control converts dataset/datareader/datagrid into a user-friendly and downloadable file: well-formatted Excel worksheet or lightweight CSV file.
Advanced Filter user control that allows the user to define multiple criteria and formats them into an accurate query string for the parent control to process.
Team Project: Debugged, fixed legacy code in VB.Net 2003 and migrated it to VB.Net 2005
Programming Languages: VB.Net, C#.Net, ASP.Net, ADO.Net, JavaScript, T-SQL, CSS, XML, XML Schema, XSLT, DTD
Main Environments: Visual Studio 2005, .Net Framework SDK Command, MS Application Blocks, SQL Server 2005 Management Studio, IIS 6.0, Visual Source Safe 5.0/6.0, MS Visio, DotNetNuke 4.5
Third-Party Tools and Components: CCNet Engine, .Net Reflector, NUnit, Gemini Project Tracking Web Application, CodeSmith, Infragistics Net Advantage, TSQLUnit, RedGate SQL/Data Compare, BeyondCompare, FoxCop
West Corporation, Omaha, Nebraska June 2005 to Feb 2007
Direct Response Information Services Department
CAS&D (Client Applications Support and Development) Programmer
Clients: CitiBank, Chase, Sears, Shop NBC, Home Shopping Network, etc.
CRMS (Client Request Management System) Team Project
A workflow system for 260 users including account managers, account specialists and trainees (10 dedicated client services teams) to submit requests to 5 IS teams to set up new promotions at inbound call centers. The system streamlines the operations on the CS side and reduced staffing and errors of data entry on the IS side. The system generated soft and hard-copy paper trails intended for auditing purpose and generated periodical billing reports for IS managers.
Worked as part of the team to migrate the existing legacy VB6 Client/Server application to an object-oriented, multi-tier VB.Net enterprise system which spans over 2 databases, 101 tables, 35 stored procedures and 5 printer servers.
Designed and implemented additional features: email notification/confirmation, report archiving, and report lookup.
.Net XML Web Services Project Highlights:
Plus/Minus project: retrieves forecasting of call center agent assignments from the data center and parses compressed csv files into xml data.
Datapak project: enables cobol servers in IBM Tandem to submit order information in xml format to external web services on secured Datapak site.
Call Volume Report: retrieves real-time and historical statistics of call center operations from IBM Tandem and presents to clients via Extranet.
GEOTEL Data Extractors: transfer switch-level real-time statistics of call center operations from SQL Server to IBM Tandem
MS Excel VBA Project Highlights:
Results Analysis Tool: a powerful and flexible Excel workbook template that queries IBM Tandem for various statistics by different criteria. This tool is heavily used by account managers and account specialists.
Soap/Am Port Report: a tool that polls the connection status of 115 HTTP and HTTPS ports (58 call centers and 2 virtual IPs) set up for Soap/Am web services
Programming Languages: C#.Net, VB.Net, ASP.Net, ADO.Net, VB6, JavaScript, VBScript, VBA, T-SQL, CSS, XML, XML Schema, XSLT, DTD
Main Development Environments: Visual Studio.2005, .Net Framework SDK Command, SQL Server 2000 Enterprise Manager, MSIL Dissembler, IIS, Microsoft Visual SourceSafe, Visual Studio 6.0, Web Service Toolkit for Office, SOG (Server Object Gateway), Soap/AM, Microsoft Visio, Crystal Report
Third-Party Tools: NUnit, NetRefractor, Slick/Edit, Macromedia HomeSite 4.5, IBM Legadero
Union Pacific Railroad, Omaha, Nebraska May 2004 to June 2005
Intern for Destination Ramp Simulation Project (DRSIM), Decision Technology Group
• Environments: VB 6, VBA, Excel, Access, Oracle, Teradata, Simul8 Standard and Pro
• Retrieved, cleansed, analyzed and tested input and output data of DRSIM model for automobile inventory forecasting of 31 UP ramps.
• Programmed in VB and VBA to invoke Simul8 Pro via COM objects
• Designed and developed the user front-end.
• Utilized back-end data stores as input to DRSIM model.
• Integrated DRSIM output with data store for online Network Alert Map.
• Documentation of system life cycle including code migration.
University of Nebraska at Omaha, Omaha, Nebraska
Graduate Assistant, Department of Information Systems & Quantitative Analysis (ISQA)
August 2003 to May 2005
• Designed the dynamic website for Journal of Information Technology for Development (http://itd.ist.unomaha.edu) using ASP, VBScript, HTML, Dreamweaver MX, Macromedia HomeSite, ColdFusion Studio, MS Visual InterDev 6.0, Macromedia Fireworks
• Maintained the website for the E-Service Journal (http://www.e-sj.org).
• Redesigned the intranet website for AIS Council (Association for Information Systems).
• Data analysis using SPSS Version 12.
• Worked with Accounting Department on the transport of financial data provided by SEC using SAS programming, XML, XML Map, XML schema, Excel and VBA.
EDUCATION
University of Nebraska at Omaha, Omaha, Nebraska
The Peter Kiewit Institute, College of Information Science and Technology
May 2005, MS, Management Information Systems, GPA 3.923 on a 4.0 scale
References Available Upon Requests
Recommendations Available in LinkedIn
http://www.linkedin.com/profile?viewProfile=&key=27609008&trk=tab_pro