Program Analyst Resume
SUMMARY
- 10 + experience in application development (ASP.NET MVC, Web Form, Web API, WCF, Web Services), MVVM, WPF, SQL Database, EF/ LINQ/ ADO.NET, SSRS/SSIS.
- Strong skills in Analyzing, Debugging, Problem solving, coding and Designing Application Systems, SDLC, Waterfall and Agile.
TECHNICAL SKILLS
Programming and Designing Skills: C#.NET, OOP, ASP.NET MVC, Web API/WCF/Web Services, JavaScript, JQUERY, JSON, HTML, CSS, XML, AJAX, Infragistics, EF/LINQ/ ADO.NET, T - SQL, MS SQL DB, Schema Design, SP, Trigger, View, Function, SSRS/SSIS, Design Patterns, MVVM, WPF, and Multithreading.
Software Development Environments: MS VS.NET 2005/ 2008/2, .NET Framework, MS IIS Services, MS SQL Server 2000/ 2005/2008/2012 , SSRS/SSIS, MS TFS, SVN, HP Quality Center, JIRA, MS Office, MS Windows, MVC, Web Server/Client Applications and MVVM, WPF applications.
PROFESSIONAL EXPERIENCE
Confidential
PROGRAM ANALYST
Responsibilities:
- The Contractor Registration Project is an ASP.NET MVC Web Application Project. Worked on the project primitively, analyzed and debugged project codes, added new features and fixed defects as well as UNIT Tests successfully. Used C#, .NET framework 4.6, Entity Framework 6, ASP.NET MVC, MVC Design Pattern, MVC Validations, SQL server 2008/2016 Tools, VS.NET 2013.
- The Piedmont Online Project is a ASP.NET and Silver Light Web Application Project. Worked on moving it from Windows 2003 server to Windows 2012 server, installed IIS service, the Web Application, Silver Light, DEVART and Oracle Database Client 11g, as well as did settings in the new Windows 2012 server that made the 32bits web application to work in the 64bits Windows 2012 server successfully. And also used Oracle Database 11g to replace old version of Oracle Database Client in the Web Application successfully.
- The Curtailment Project is a classic ASP, JavaScript, and COM components project. Worked on moving it from Windows 2003 server to Windows 2012 server, install IIS, Oracle database client 11g, and Curtailment Web Application, Analyzed System requirements, configured various settings on IIS, ODBC, OLEDB for Oracle, Registry and COM+ in the new Windows 2012 server that made a 32bits Web Application to work in a 64bits Windows 2012 server successfully. Debugged ASP and JavaScript codes in VS.NET 2013, analyzed, rebuilt and redesigned COM DLL, modified ASP codes. Used ASP, JavaScripts, COM Components, and also used dbForge Tool, Oracle Stored Procedures in Packages, used Oracle Database 11g to replace old version of Oracle Database.
Confidential
APPLICATION SYSTEM ENGINEER
Responsibilities:
- Worked on Application Development for Risk Management (Risk Analysis, Capital Control, Governance, etc.) of investment and security.
- Coded in both client and server sides: C#, OOP, ASP.NET, ASP.NET Web Form, JavaScript, JQuery, JSON, HTML, CSS, Entity Framework, LINQ, ADO.NET., SQL Server Databases, Tables, Triggers, SPs, FNs, analyzed complex problems, added new features, fixed defects, Service Design Pattern, MVC, MVVM, WCF, WPF, and WWF.
- Worked on Complex Problems Analyzing, Debugging, Problem Solving, Coding and Designing, developing, implementing existing application and adding new features, as well as build, deployment, and release of Web Applications and SQL Scripts.
- WPF and MVVM projects
Confidential
CONTRACT WEB DEVELOPER
Responsibilities:
- Worked on a new web application, CRM Sharing, which displays CRM Sharing information, creates, edits, views details, and audits, generates Excel files, and prints data. It provides different way to access data from controllers and Web API. Worked on creating Models, Views, and Controllers; Web APIs, Routes, Filters, Bundles; coded for server and client sides including C#, OOP, MVC, Web API, Razor, Html Helper, JS, JQuery, Ajax, JSON, Html, CSS, Infragistics, SQL, EF, LINQ, ADO.NET, caches (application & output), Errors/Exceptions, built Rest services and clients application, etc.Worked on existing web application, PWO, which is bank referral system.
- Fixed bugs, added new features, WCF Operation and Data Contracts, new SPs, and improved system performances on listing city/county-zip, customer information, and updating multiple records. In this project, I used C#, WCF, MVC, Razor, Html Helper, JS, JQuery, Ajax, JSON, Html, CSS, XML Schema Data Access Model, ADO.NET, LINQ, XML, OOP, and Multithreading.
Confidential
SOFTWARE ENGINEER
Responsibilities:
- Working on SQL Programming and SSRS reports to perform business tasks and generate SSRS reports. Install SSRS Report Server, manage and maintain SSRS Report Server, initiate/modify/change report site settings, user role setting, report schedule settings, report subscriptions, generate/upgrade/modify/convert SSRS reports for various business tasks (billing, invoice, year/monthly/daily report, status, etc.). Working on SQL programming to provide high performance, non-redundancy records, easy reading, and fast running SQL scripts and convert SQL to simplicity from complexity, and working on fast running SSRS reports. Using SQL, write SQL queries, stored procedures, functions, triggers, tables, temporary tables, and views for various tasks(SSRS reports, application invocation of ASP.NET, Web Service and ETL), business requests).
- Working on 3 Web Sites with hundreds of pages, 2 Web Services, 2 Reporting Services, internal/external software libraries to provide business service and report services (SSRS) on web, file generating/converting services (Excel, PDF). Working on web site project, web app project, web service project, library project, set up web site, web service, application pools, and virtual directories. Create new web services, new pages and new features; manage, support, maintain and test web sites, web services, and reporting service; write codes for code behind, server side, and frontend. Using C#, ASP.NET, JavaScript/JQuery/JSon, AJAX, HTML, CSS, XML, SQL/LINQ/ADO.NET, SSRS report, 3rd Party components (Excel, PDF, etc.), classic ASP and VB.
- Working on WCF/WPF project to collect data, transfer data between WPF client application and data center via WCF. Using C#, XML/XAML, WCF, WPF, ADO.NET and LINQ.
- Working on ETL Data Export/Import project, import data into database and export data from database via FTP and ETL applications, using C#, LINQ/ADO.NET, FTP programming.
- Working on VS 2008/2010/2012 , .NET Framework 1.1/2.0/3.5/4.0 , SQL Servers 2005/2008/2012 , SSRS Reports 2003/2008/2012 , BI 2008/2010/2012 , Report Builder 3.0, Web Services, WCF/WPF, MVC, ASP.NET AJAX Extension, AJAX Control Toolkit, 3rd Party Components, and Tortoise.
Confidential
CONTRACT SOFTWARE DEVELOPER
Responsibilities:
- Worked on SQL queries, stored procedures, functions, constraints, indexes, tables for performing business tasks and reports and working on multiple Databases in multiple SQL servers and linked servers. Analyzing large amount data and hundreds of business logical rules to extract, combine, compare, merge, and store data. Working on SQL performance tuning and optimizing. Developing new solutions to replace existing solutions, correcting problems existed in current system, fixing bugs/defects in new solution. Write SQL scripts for various testing purposes, test tip document for QA team and conducting QA team to do tests, and maintaining and optimizing new solution. QA test and business users have reported new solutions correct hundreds of wrong data in existing system and 10 times faster than existing solutions in average.
- Created C# test codes and windows services programs, which simulate concurrency situations of SQL Stored Procedures being called from web applications, use multithreading and synchronization techniques, and perform hammer tests for finding and helping to solve concurrency issues.
- Created C# test codes for hosting WCF service components, which can be invoked from ASP.net web application; created C# test codes, SQL scripts and SSIS/SSRS, which are for processing ETL data, generating reports, and comparing ETL data between diff solutions.
- Using VS.NET 2008, SQL Server 2005/2008, SQL Server client Tools/Bids/SSIS/SSRS.
Confidential
CONTRACT SQL DEVELOPER
Responsibilities:
- Worked as SQL Developer, in Healthcare Services industry. Worked on SQL Server Database and analyzing database, writing, modifying and documenting SQL scripts, including tables, views, stored procedures, functions, triggers, indexes, etc. Also using temporary table, temporary stored procedures, and SQL Server System Stored procedures to do electric healthcare data exchange and conversions as well as document and illustrate completed and large size stored procedures up to 3000 lines. Used MS SQL Server 2005/2008, BIDS/SSIS/SSRS.
Confidential
CONTRACT WEB APPLICATION DEVELOPER
Responsibilities:
- Worked on Web Applications, Web Forms and Reports using Visual Studio 2010 Premium, SQL Server 2008 and Share Point Designer 2007. Generating Web and Excel Reports, writing, modifying and debugging application codes including C#, JavaScript, ASP.NET, HTML, CSS and AJAX.
- Worked on Fund Analysis Database System, Multi-tired Web and Database Application Development. Maintained existing Web Application; Accessed, Audited, extracted, and Processed Data on Database; Solved issues came from users; Designed new Web UI and new pages, Added New Functionalities, implemented new codes and performed new unit tests.
- Released and deployed web application on different web servers, configured database on different SQL server databases monthly. Wrote test tips for QA team, fixed bugs and defects found in QA team.
- Worked with clients and wrote the Business Requirement Document for clients and development team reviews, and followed the BRD to implement codes.
- Programmed codes using C#, ASP.NET, VB.NET, T-SQL, SSIS, HTML, JavaScript, CSS, and SSRS Reports on both web applications and reporting service components. Wrote console and windows application al well to automatically extract SQL scripts from SQL database and generate hundreds of stored procedures, functions, triggers, views and tables into files and analyzed codes in those files.
Confidential
LEAD/SR. SOFTWARE ENGINEER
Responsibilities:
- Developed software on Windows Applications, Win Form, WPF, Database Access, Software Globalization, System Integration using C#, C++, VB.NET, VB/VBA, VBScript, JavaScript, COM+, OOP, ADO.NET, SQL, XAML, XML/XSL, HTML, and .NET Framework 2.0/3.5.
- Created User Layer Software on Windows Form UI using Windows Form, Windows Control, User Control, Controls, WPF and XAML. Created Middle Layer Software Components to handle business rules. Created Data Layer Software Components including T-SQL Queries, Stored Procedures, Views, ADO.NET, Data Provider Objects, Dataset Objects, DataBinding, BindingSource, XMLDOM, XML Files and Text Files, and display Data on UI.
- Created software components to communicate and exchange data between servers and clients. Used Multithreading, Synchronization, Singleton, COM Interface, Windows API, third party API, Network Protocol, OPC Server/Client technologies to monitor and control network and remote devices, listen to real-time value changes in RTDB, transfer data packets between server and client. Enabled work crossover different software components written in .NET technologies and legacy technologies.
- Created software applications and test tools for helping software developments and software tests, which visualize various data and randomly generate test data to implement software component tests in database, XML files, and text files, display network status and status of remote devices, automatically create database tables and load data into tables from text files.
- Provided solutions for Software Globalization. Analyzed complex software system for software globalization, provided multilingual support for Client software and server software products, implemented multilingual support in codes and integrated the software system, tested the software product and made sure the solutions effectively and efficiently. The software globalization includes various software components programmed by C#, VB/VB.NET, C++, SQL Server, and Scripts.
- Created kernel device drivers for multiple function PCI cards, PLC, and SNMP network devices. Used Microsoft DDK, Win32 SDK, Windows API, APC, COM and COM interface, Multithreading, Synchronization, Network Protocol, Packet and integrated the device driver, user API, and Windows UI into embedded real time industrial control systems.
Confidential
CONTRACT SOLUTION WEB DEVELOPER
Responsibilities:
- Created 3-tier Web client/server Application with online security and eBusiness using C#, VB.NET, ASP.NET, .NET Framework 2.0, SQL Server Database, SQL Server Analyzer and Management Tools, Oracle 9i Database, SQL*Plus, Developer 2000.
- Developed Presentation Layer Web GUI using Web Control, HTML Control, Validation Control, Master Page and Content Page, and Windows Form and Control; Developed Business Layer using Business Rules and Data Layer using ADO.NET, Data Provider Objects, Dataset Objects, XML, XMLDOM; and Created Database, Tables, Views, T-SQL Queries, and SQL Stored Procedures.
- Worked on Architecture Design, Activity Diagrams, Use Cases, Functional Requirement, and Business Rules.
Confidential
CONTRACT WEB DEVELOPER
Responsibilities:
- Created 3-tier Web client/server Application with eBusiness using ASP/ASP.NET, VB/VB.NET, VBA, VBScript, JavaScript, HTML, DHTML, COM+, CSS, XML, and XSL. Used SQL Server Database, SQL Server Analyzer and Management Tools, MS Visual Studio and MS IIS.
- Developed Presentation Layer Web Form and Windows Form Application; Developed Business Layer using Business Rules and Data Layer using ADO/ADO.NET, XMLDOM; and Created Database, Tables, Views, T-SQL Queries, and SQL Stored Procedures.
- Wrote software DLLs in server side, which access database, dynamically generate Crystal Report and convert Crystal Report to PDF file, automatically send email, register software DLL as COM+ component, integrated Web Server Components into MS IIS system.
- Created Server Modules for Database Access and Client Applications for wire and wireless connections, Migrated ASP to ASP.NET.
- Worked on Architecture Design, Web Form Design, Functional Requirement Design, Business Rules Design, and Database Design.