SUMMARY:

• Development of custom business applications with Winform, Confidential, Asp.Net Webforms / Confidential, Multi - threading

• Engaged with multiple clients on design and development of enterprise solutions. Solution involves working with big data, writing data transformation engine (rule based), creating data warehouse for running analytics, making report accessible on multiple devices (mobile phone, tablet, desktop).
• Developed Windows Services with C# / Asp.Net Web applications, Web services.
• Developed frontend UI with C# in Winform and Confidential for interfacing with Sql Server through Entity Framework
• Setup SQL Server environment - Provided clients with best practices on SQL Server installations to ensure uptime is at 99.9%. Patch maintenance, Disaster recovery. Also created a project using SSIS for running a C# assembly I created for downloading BIG DATA from ASW and reading into a Sql Server DB on a scheduled basis.
• Design the solution - Establish an AGILE / SDLC framework to enable consistent development methodology. Assisted clients with developing schema, data normalization, creating stored procedures for efficient processing of data.
• Writing export and import scripts - Provided guidance to clients on best practices for retrieving data from disparate data sources by utilizing rest API and Curl.exe.
• Assisted clients in project management to ensure timely and qualitatively completion of projects.
• Created powerful dashboard reporting for C-Level executives (e.g. sales providing big discounts impacting margins, Quality data, etc.), to provide vital information related to business health to remediate risk in a timely manner.
• Developing Confidential (MVVM) user interface for data manipulation with Entity Framework 6.0, developing OLAP Cube as data source for End User Presentation through Tableau, cloud presentation.
• Write articles for CodeProject.com on Confidential programming using ORM and implementing the MVVM pattern.
• Staying abreast of current developments with Microsoft Sql Server and Visual Studio.
• Some Familiarity with Jenkins Workflow plugin
• Developed extensively with MS Access (Access 2.0 through Access 2010) and Excel. Created several reporting systems with Excel interfaced with MS Access and Sql Server with ADO.

TECHNICAL SKILLS:

• .Net Framework through 4.5
• C# and VB.Net
• MS Office / Outlook
• Windows Forms, Confidential
• IIS
• JavaScript / JQuery / Json / Ajax / AngularJS
• ASP.NET / Webforms / Confidential / CSS / Bootstrap

• Structured Query Language (SQL/T-SQL)
• Oracle 11i PL Sql /Toad
• SQL Server Reporting Services (SSRS), SSIS, SSAS
• Entity Framework, LINQ
• Stored Procedures & User Defined Functions
• MongoDB
• MS Access
• MS Excel (All versions)
• Custom reports
• XML Data Structures
• VBA for MS Office/Access/Excel
• ADO, OLEDB & ODBC

• Visual Studio.NET
• Team Foundation Server
• SourceSafe
• SQL Server Management Studio
• TortoiseSVN subversion client
• VMware 64 bit and 32 bit
• Toad 11i

WORK EXPERIENCE:

Confidential, Fairfield, CA

.Net Developer

Responsibilities:

• Worked on a 4 member team working on a multi-million dollar web application. I was the front end developer, but I also wrote a lot of the back end stored procedures for this application, I also served as Secondary Team Lead responsible for Build Releases.
• Develop and maintain Asp.Net webforms with Master Page, content pages, html markup with client side maintained with JQuery/JavaScript, code behind with VB.Net and C# for the backend.
• Developed dynamic tooltips for Gridview Data Rows using JQuery/Ajax/Html tables/.svc Web services/Bootstrap/Css
• Developed Drag and Drop features for Dragging and Dropping Gridview Data Rows from one Gridview to another using JQuery Sortable events and various JavaScript Libraries.
• Created Packages and Stored Procedures using PL SQL in Toad for the backend of the webform applications.
• Created Web services with wsHttpBinding for use with JQuery Ajax calls with code behind functions that interfaced with the code behind of the web application. For the tooltips when a page was loaded I would load all the data for each Gridview into html tables with display: none and pass that html data to the Ajax function which passed it to the web service. Then when a user hovered over a given field in a given row the tooltip data would appear for that particular row.
• Developed JQuery functions to maintain scroll position for Gridviews displaying large datasets where a selected row is updatable.
• Implemented security features in the markup for Eval and DataBinder expressions.
• Developed Web based reports which could be saved down in Pdf or Xlsx format.
• Working in a team environment using Team Foundation Server (TFS) for source control.

Confidential, Pleasant Hill, CA

.Net Developer

Responsibilities:

• Developed an application in C# to be integrated into an Electrical Power Metering Device called PowerSight.
• The application allows a user to create an Electrical Power Meter Test Plan file which saves to a custom extension (.tpl) and is then consumed by the Power meter device.
• The file employs the xml and (custom) tpl format.

Confidential, Livermore, CA

.Net Developer

Responsibilities:

• Refactored an aging windows service for moving claims documents from active location to processed and inactive locations for diversified collection services - which had to comply with government regulatory compliance (HIPAA).
• Using VMware 64 bit.
• Using Visio to create flowchart for project design.
• Platform C# VS2012, LINQ, Regex.
• Using Informix database with WinSql for writing queries and stored procedures.
• Using Sql Server 2012
• Using TortoiseSVN subversion client for checking out and checking in program files and managing program files.
• Using Jira issue tracking/project management program for tracking my projects and work hours

Confidential, Alameda, CA

.Net Developer

Responsibilities:

• Collaborating on a team of four to maintain asp.net web forms code behind in C#, add features, modify features, fix features with Visual Studio 2013.
• This is a (very large) .Net 2.0 web app
• Maintain/modify/update asp scripts(.aspx/asmx), JavaScript, xml, add Ajax controls, add/maintain user controls (. Confidential )
• Maintain/update/modify UI on client side/server side, add fields, hidden fields, session objects
• Maintain sql server 2012 database for Union Members, write stored procedures with Tsql, also used Sql Server Profiler for isolating/debugging various stored Procedure code blocks
• Check out/in files with MS Visual Source Safe
• Create reports with SSRS

Confidential, New York

.Net Developer/.Net Architect

Responsibilities:

• Working as an independent contractor as a one man team
• Developed an assembly in C# with LINQ for reading large volume geological data on a scheduled basis from AWS and storing in Sql Server 2008 R2 database using Entity Framework (EF 5.0) ORM and WCF, XML
• Write stored procedures for processing the data collected.
• Report on this data in Excel and email to Client.
• Unit Testing with Ninject

Confidential, Emeryville, CA

Programmer/Administrative

Responsibilities:

• Write stored procedures in Sql Server 2008 R2 for data reporting in Excel
• Create Reports using SSRS-BI in Sql Server 2008 R2
• Create a Custom Calendar Reporting application in MS Access 2005 for reporting in Excel
• Unit testing various other applications
• Migrate Data from MS Access to Sql Server, create various applications with MS Access

Confidential, Walnut Creek, CA

.Net Developer/.Net Architect

Responsibilities:

• Developed a billing application for automatic generation of invoices to ensure optimal level of AR aging (Net 30 days). Application had a presentation layer, which was initially developed using winform and later migrated to Confidential (MVVM) for interfacing with SQL Server. The solution provided powerful reports in various formats (PDF, Word, excel). Prior to this business users would perform this activity manually and was prone to data entry error and collection of payment was not done in a timely manner (Aging was 180 days). This process consumed 8 hours work for a user to generate an invoice for a 10 customers. With automation it took only seconds, data accuracy improved and company receivable or aging improved (30 days).
• Ensured that solutions developed was scalable and flexible as business grew. The company objective was to develop invoicing components that allowed business users to add/delete without having to recode the solution and with minimum dependency on IT staff. To achieve this, introduced C# assemblies for use with SRSS.
• Established a SDLC framework to ensure consistent development methodology including best practices while using SQL server technology. Introduced to the company use of “Click Once deployment” a Visual Studio tool for rapid deployment of application into production environment.
• Created web services for management at different physical location to access the data within the corporate firewall for some of the solutions that were developed.
• VBA/SharePoint/VB.Net/C#/ASMX/XML/Tsql/ Confidential, developed Winform user interfaces - later migrated to Confidential (MVVM) for interfacing with SQL Servers (2000, 2005, 2008) with Entity Framework (EF 5.0), web services, SQL Server Reporting Services (SSRS), developed C# assemblies for use with SSRS, developed deployment process in C# for Click Once deployment (Visual Studio), developed reports in SSRS, MS Excel, created C# assemblies for converting Excel report sheets to single PDF format. Migrated MS Access ADP(s) to .Ne t platform with SQL Server as the backend database.
• The application utilized Asp.Net ( Confidential pattern) administration, web service (soap). The applications interfaced between MS Sql Server (2005) and a proprietary Database System called Archibus (for Facilities Management).
• Used Ajax to display Floor Plan drawings, web services (precursor to WCF) to populate Controls for navigating the application,
• Used Ajax for horizontal Menu Controls, utilized Component Art Libraries (JQuery/Ajax based). Created stored procedures against the Oracle Database (server 9i)