SUMMARY:

• Microsoft Certified Professional (MCP) for SQL Server 2000.
• Dedicated .NET and SQL Developer with more than twenty years of analysis and programming experience in the property management, financial, insurance, and human resource sectors.
• Developed, maintained, and supported front - end, middle-tier, and back-end web and desktop applications.
• Skilled in user requirements study, analysis, design, construction, testing (unit, regression, integration, and systems), implementation, troubleshooting, production support, operations support, help desk, training, and maintenance.
• Detail oriented and organized; comfortable taking the initiative and working independently and as part of team.
• Skilled in database design, administration, maintenance, monitoring, backup & recovery, troubleshooting, performance tuning, query optimization, and complex T-SQL queries and stored procedures.
• Excellent experience in using Active Directory, Visual Studio 2012/2008/2005 , SQL Server 2008R2/2005, .Net Framework 4.5/4.0/3.5/2.0 , Entity Framework, Microsoft Patterns and Practices, Design Patterns, WPF, MVC, Software Factories, ETL (Extract, Transform & Load), SSIS, SSRS, Web Services, WCF, and T-SQL.

TECHNICAL SKILLS:

Languages: C#, VB.NET, ADO.NET, ASP.NET 2.0, Front-end and back-end Web Development, Win Forms, Web services, WCF, XML, XSL, XSLT, SQL Server Reporting Services, T-SQL, DTS, OLTP & Batch SQL, VB, ASP, HTML, DHTML, JQuery, VBScript, and JavaScript.

Databases: SQL Server 2012/2008 R2/2005/2000, Active Directory, Ms Access, Excel.

Software/Tools: Visual Studio 2012/ 2010/2008/2005 , .Net Framework 4.5/4.0/3.5, Entity Framework, MVC, Web Client Software Factory, Repository Factory, Web Service Software Factory, VS Team Foundation Server, Visual SourceSafe, UML, Visio, Crystal Reports, Ms Office, Ms Project, Excel, and Access.

WORK EXPERIENCE:

Confidential, Torrance, CA

Software Engineer

Responsibilities:

• Provide d support including troubleshooting, problem determination, cod e fixes and enhancements to the company products and applications .
• Analyze d and correct ed software issues reported by our test team or customers.
• Participate d in all phases of software development: requirements analysis, design documentation, implementation, validation, and production release.
• Involved in l arge scale, multi-threaded, real-time system development .
• Developed and executed test cases and test plans using TestTrack Pro.
• Used C#, C++, SQL Server, Visual Studio, SCM, TTP, .NET 4.0/3.5/2.0, and Scrum for projects tracking.

Confidential, Santa Ana, CA

.NET Developer

Responsibilities:

• Developed and maintained new User Interface and functionalities for Human Resource’s web applications for personnel management (new hires, employee transfers, promotions and swapping of employees) and employee’s performance evaluation.
• Maintained and provided production support for HR front-end, middle-tier, and back-end web and desktop applications and Active Directory mirror SQL database.
• Migrated front-end web applications and backend processing from .NET Framework 2.0 to 4.5 and SQL 2005 to SQL 2008 R2.
• Developed SSIS package and C# application for integrating County’s data with in-house HR web application.
• Unit testing, integration testing, troubleshooting, debugging, and implementation of in-house HR web application.
• Integrated Active Directory updates with HR intranet applications.
• Used Active Directory, ASP.NET 2.0, C#, SQL Server 2008R2/2005, SSIS, SSRS, .NET 4.0/3.5/2.0, Visual Studio 2012/2008, MVC, Entity Framework, AJAX, Stored Procedures, User Defined Functions, and User controls.

Confidential, Monterey Park, CA

Application Support Engineer

Responsibilities:

• Provided business banking application support, including installation of third party software, and production on-call support.
• Acted as liaison officer between users of business units and third party vendors/developers in installing software and in troubleshooting production errors/issues.
• Worked with third party software like OpenText Document Manager, and Wall Street Systems’ Forex.

Confidential, Los Angeles , CA

.NET/SQL Developer

Responsibilities:

• Eliminated the manual process of compiling financial data (in various file formats and structure) of more than 1,500 residential properties and management companies by developing programs to automate the process of data extraction, transformation and loading into the in-house SQL database. Developed complex stored procedures.
• Developed Excel 2003/2007 macros and programs for asset management analysts to adjust, review and approve financial reports of 1,500 residential properties.
• Analyzed, designed and developed web-based interface web pages and stored procedures for mapping external chart of accounts from 200 property management companies into the in-house chart of accounts.
• Developed mid-tier modules, SQL Stored Procedures and web services for supporting frontend applications and web services
• Database administration, database maintenance, monitoring, backup & recovery, scripting, performance & index tuning, DTS, SSIS, and troubleshooting. Provides database support to end users. Developed relational database models using ORM and Entity Framework.
• Provided production support and correction of bad financial data from property management companies.
• Used ASP.NET 2.0, Win Forms, WPF, C#, VB.Net, Visual Studio 2010/2008/2005 , .Net 2.0/3.0, SQL 2008/2005/2000 Server, MVC, SSIS, SSRS, Web Client Software Factory, Repository Factory, Guidance Automation Extension, Microsoft Enterprise Library, VS Team Foundation Server, Web services, WCF, stored procedures, and Design Patterns.