TECHNICAL SKILLS

Language/Frameworks: .NET 2.0 - 4.5 (MVC C# ASP.NET •VB LINQ WCF) XML/XSLT, VB6, VBA, COM, WebAPI, ReactJS, AngularJS, JQuery

Database: SQL Server 2005/2008, Oracle 9i/8i/7.3, PL/SQL, SSIS, Cognos, TOAD

Reporting: Crystal Reports 2008, ActiveReports

Source Control: VSS, TFS 2013, Subversion

SDLC: Agile

PROFESSIONAL EXPERIENCE

Confidential

Programmer/Analyst

Responsibilities:

• Participated in major overhaul and conversion of ASP.NET application to HTML5/JS client-side technologies.
• Supported MVC application as part of recent business acquisition. Leveraged knowledge of different systems for performing cross platform tasks. Attended daily scrum sessions and recommended and followed-through with establishing of testing protocols for use by QA team.
• Developed multithreaded scribe system using Open-Xml SDK content controls to translate schema based data into template based Word documents. This was used to support data groupings such as tables, groups, nested tables and delimited data.
• Established architecture for most ETL tasks. Created framework to move data from flat sources to hierarchical storage and migrating schema based data between different environments.
• Successfully architected data-model design of an Underwriting Guidelines configurable document.

Environment: MVC, C#, Data Modeling, ReactJS, SCRUM/Agile ASP.NET, XML, Multi-threading, OOP, LINQ, OpenXml, Functional JS, WebAPI

Confidential

Programmer/Analyst

Responsibilities:

• Designed and implemented web-based Inventory Level Management system. Worked closely with inventory specialists to establish architecture. Replaced access/excel process for tracking inventory stock status across multiple branch locations and roles. Implemented an OO based filtering matrix that enabled key players to maintain clutter-free views of data.
• Designed and implemented complex real-time process for updating sales tax rates/jurisdictions across multiple ERP modules during order processing. Vetted various products for relevance and cost.
• Implemented automated EDI process for positive-pay system for activating and reconciling check clearing for Citibank accounts.
• Designed application for automatic barcode label generation during user entry process. Barcodes were auto calibrated to allow different sizes to be printed for different items. Added new enhancements to sales order integration process involving e-commerce, queue management services and ERP.
• Created custom ETL tools for moving data between distributed sources.
• Created a scalable email alert system to replace ERP alerts module.
• Interfaced with sourcing, purchasing and finance departments for establishing business requirements. Maintained/created crystal reports and MS-Access databases.

Environment: ERP, C#, VB.NET, ASP.NET, DTS, COM, ActiveX, ERP, Multi-threading, OOP

Confidential

Programmer/Analyst

Responsibilities:

• Charged with migrating DTS processes to SSIS.
• Converted VB6 apps to .NET. Expanded reporting utility to creating excel reports.
• Converted VBA based bookkeeping processes to SQL. Created reports for Portfolio managers/back-office operations.
• Created application for parsing emails to generate request-tracking statistics. Created multithreaded application for extracting embedded HTML reports from GB sized files.

Environment: SSIS, SQL Server 2005, VB.NET, COM, XML, Multi-threading

Confidential

Software Engineer

Responsibilities:

• Developed/maintained applications for flagship product, using in-house object model.
• Put in charge of improving and extending functionality of “Maintenance” module.
• Devised and created XML codebase for building dynamic pages, enforcing permissions and validating controls.
• Added new product, while consolidating functionality on company’s ASP intranet site.
• Performed housekeeping on 500 district databases via batched queries.
• Performed late night deployments.

Environment: C#, ASP.NET, ASP 2.0, SQL Server 2000, XML, OOP

Confidential

Programmer/Analyst

Responsibilities:

• Designed and implemented an object model for processing forms. Significantly reduced coding and debugging time.
• Supervised colleague in Active Reports form development.
• Developed suite of admin tools for role impersonation, process monitoring, data synching, image-viewing and a custom printing application for printing grids and forms.
• Developed an XSLT based HTML reporting system. Of application with firewall, VPN Cell card, portable printer and scanner in Tablet environment.

Environment: C#, ASP.NET, ASP 2.0, SQL Server 2000, XML, OOP

Confidential

Data Warehouse Developer

Responsibilities:

• Developed ETL scripts for loading claims/membership Mainframe data to 1 TB Oracle Data-Warehouse.
• Designed and spearheaded implementation of star schema data mart prototype for claims department under tight time-lines.
• Created code framework for all future data-mart requests.
• Liaison to the Finance, Actuarial and Provider Relations depts.
• Headed documentation effort to extract financial business intelligence for Vytra Health Plan merger.
• Triaged/assigned priorities to trouble tickets and recommended performance improvement measures.
• Cube Developer/Admin. - Developed cubes for financial reporting using Dimensional Insight codebase. Balanced rigid memory v. build time requirements for implementation

Environment: ETL, PL-SQL, Oracle9i, VBA, Cognos, OLAP