SUMMARY:

• Senior Software Engineer with strong experience working in Visual Studio 2012/2015, .Net 4.5, C#, ASP.Net WebForms, ASP.Net MVC, WinForms, HTML, CSS, JavaScript, JQuery, WCF, Web API, ADO.Net, Telerik Tool, T - SQL
• Data analysis experience using TSQL, MS SQL Server 2008/2012/2014 and Sybase
• Great working experience in Business Intelligence Development for ETL and Reporting Services areas using Microsoft BI stack (SSIS and SSRS)
• Experienced with Data Modeling, Dimensional Modeling and Data Warehousing concepts
• Good working experience in tuning SQL queries for maximum performance
• Strong communication and interpersonal skills

TECHNICAL SKILLS:

Languages: C#, JavaScript, HTML, CSS, XML, T-SQL, PL/SQL, Java, X++, VBA

Database: MS SQL Server 2008/2012/2014, Oracle, Sybase

Web Technologies: .NET Framework, WebForms, MVC, WCF, Web API, HTML, CSS, JavaScript, JQuery

IDE: MS Visual Studio 2010/2012/2015

BI/DB Tools: SSMS, SSRS, SSIS, Toad, SQL-Programmer, Crystal Reports

Version Control Tools: MS TFS 2015, Tortoise SVN

Platforms: Windows

Web Server: IIS

PROFESSIONAL EXPERIENCE:

Confidential, San Diego, CA

Senior Software Engineer

Responsibilities:

• The main responsibilities are to design, implement, and unit test the backend services using WCF with C# and T-SQL for the enterprise web-based Tolls Collection System which is for providing toll collection, operation, system monitoring and maintenance functions. The WCF backend services are consumed by Angular JS to present the data. The System is architected with MVC design pattern. C#, Visual Studio 2015, and .Net 4.5 framework are used for development. SQL Server 2014 is used for database engine
• Creating and implementing various SSRS reports for Tolls Collection System
• Design and implement stored procedures using TSQL with SQL server 2014. The stored procedures are consumed by SSRS reports and backend services

Confidential, Santa Ana, CA

Senior Software Engineer

• Participated in the design, development and maintenance of software code for FAST Transaction System, a fully integrated, enterprise-wide, browser-based production system, geared to automate and centralize the production of title and escrow settlement products and services. The system is built with Visual Studio 2015, .Net 4.5, C#, WebForms, MVC, HTML, CSS, JavaScript, WCF, ADO.Net, SQL Server 2014, and T-SQL
• Troubleshoot complex bugs and resolve customer complaints with software and respond to suggestions for improvements and enhancements

Confidential, Anaheim, CA

Senior Application Developer

• Developed Web application using Visual Studio 2012, .Net 4.5, C#, MVC, HTML, CSS, JavaScript, Web API and ADO.Net
• Maintained and fix bugs for the in-house application that was developed with WinForms, C# and WCF
• Created new custom reports and maintain current reports using T-SQL of MS SQL Server 2012
• Performed T-SQL performance tuning using SQL Server Profiler, and Execution Plan for analysis

Confidential, Downey, CA

SQL Developer / Data Analyst

• Designed database tables and wrote T-SQL scripts to load data from production database to data analysis database
• Designed and performed the extraction and analysis of pertinent data that supports user needs; including importing, cleaning, transforming, and validating data for analysis
• Built and delivered reporting to meet ad hoc business requests
• Run routine, ad hoc and support information requests in a rapid and dynamic turnaround climate

Confidential, Irvine, CA

Software Developer

• Provided technical support to the Supplier Performance Platform (SPP) application built with WebForms, C#, HTML, CSS, JavaScript and T-SQL. SPP captures supplier performance data and delivers real-time status, results, KPIs, and trends. This information enables an optimized supplier performance strategy.
• Designed and developed SSRS reports using MS Visual Studio 2010 based on Business Operational requirements for the ERP application (MS Dynamic AX 2012)
• Designed and developed the Report Data Provider classes using X++ of MS Dynamic AX 2012. The Report Data Provider classes are developed and used as the data sources of the SSRS reports. X++ is very similar to C++ and Java
• Assisted in the development and maintenance of report design documents and guidelines
• Performed data extraction and analysis using Excel to analyze onsite consultants timecards and expenses related data for reporting purpose

Confidential, Irvine, CA

SQL Developer

• Developed and maintained the T-SQL stored procedures, functions, views, and triggers for the Microsoft in house reports. The development platform is MS SQL Server 2012, and the Pivot Table of Excel is used for presenting the reports in Excel
• Created ad hoc reports using SSRS Reports tool

Confidential, Lake Forest, CA

Software Developer

• Developed web based Inventory Control application using C#, ASP.Net, WebForms, HTML, CSS, JavaScript and Telerik tool
• Developed and supported T-SQL stored procedures, functions, views, and triggers with SQL Server 2008
• Maintained and fix bugs for the Warehouse Inventory application with WinForms, C# and T-SQL
• Developed and supported the SSRS reports for daily business activities
• Created Integration Service Packages (SSIS) to extract, load and transform data
• Enhanced and maintained the in-house application built with Dynamics GP/Great Plain
• Troubleshot the in-house application built with Salesforce.com
• Created ad hoc reports using Crystal Reports tool

Confidential, Newport Beach, CA

Software Developer

• Designed and created the Sybase relational databases, and programmed the stored procedures, triggers, functions, and views using T-SQL
• Designed and implemented new functionalities for client server applications using PowerBuilder
• Designed and implemented the new web based application from the new requirements using Visual Studio 2010, .NET Framework, C#, Silverlight, and Oracle database

Confidential, San Diego, CA

Principal Programmer Analyst

• Designed and implemented the materialized views as the dimension and fact tables which were used for creating ad hoc reports using Crystal Reports tool
• Designed and implemented new functionality and fixed bugs for the web based application using Java, J2EE (Servlet, JSP, JDBC), HTML, CSS and Oracle. The web based application is used for managing the building permits

Confidential, San Diego, CA

Software Engineer

• Designed and developed the solutions to enhance or correct a complex web based medical billing software package using Java, J2EE and Oracle database
• The application was developed under WebLogic with IntelliJ for IDE and HTML, XML and JavaScript for front end interfaces, JSP and Servlets for middle tier, and EJB, Java and PL/SQL for transaction processing

Confidential, San Diego, CA

Software Engineer

• Participated in all phases of software development life cycle including development, maintenance, evaluation, and enhancement of client/server application which is using PowerBuilder and Oracle database. The client/server software application was used by City of San Diego to manage the contracts and contractors' information

Confidential, San Diego, CA

Software Engineer

• Responsibilities included designing and implementing client/server based application for U.S. Navy Housing Management System using PowerBuilder and Oracle