PROFESSIONAL SUMMARY:

• Professional .NET Developer with 20+ years of experience in software design development and support. Experienced working in various systems using C#, COBOL, CICS, JCL, SQL Server and SSIS package, DB2, IMS DB/DC, and CICS. Proven ability to easily debug and resolve technical issues. Experienced managing and guiding a team of developers in various projects. Have worked on financial, inventory and maintenance software.
• 10 years of .Net, C#, asp.net Experience both in development and support role
• 12 Years of experience in SQL Server, SSIS Package and SSRS
• 20 Years of Cobol, DB2, CICS, IMS DB/DC
• 2 years of angular JS experience
• 6 months of experience in Angular 5
• 6 months of Web API development

TECHNICAL SKILLS:

Microsoft: .Net (VB, C#), SQL Server 2012, SSIS, SSRS, Angular JS, Angular 5,MVC, JWALK

Mainframes: Cobol, Pl1, DB2, CICS, IMS DB/DC

PROFESSIONAL EXPERIENCE:

Confidential, Miami, FL

Senior Developer

Responsibilities:

• Due to continuous change in business model in PM - Form, IT is renovating the PM-Form application in .net Core environment to provide the following features:
• The Inspection lines can be categorized into multiple groups.
• The additional data can be entered and validated while inspecting the Items.

Technology: Rest WCF service, .net Core, API Controller, Angular 5

Confidential

Senior Developer

Responsibilities:

• The process will run every hour to look for PM “inspection” tasks that are completed and finalized for any open case which does not have yet an attachment with Description = “PM Form”
• Invoke Attachment service to insert the attachment into SharePoint.
• If Customer is Decisive send the note to Customer

Technology: C#.net, SQL Server

Confidential

Senior Developer

Responsibilities:

• The Preventive maintenance Coming due and Overdue information is transferred to APS system
• APS System sends an Email notification as soon as the unit is 21 days prior to become overdue
• APS System sends Reminder after each 48 hours
• When Customer schedules the units, it attaches the coming due record with the appointment number. This is displayed in the existing PMABC report

Senior Developer & Technical Lead

Confidential

Responsibilities:

• The existing mainframe and IMS. This system as used to record the claim information, transmit the claim to manufacturers and process the credit memo. This system is not integrated with our repair order system. So user has to enter all the repair data to create a claim.
• This new project is to transform the warranty application into a total integrated system
• The Claim Recording is done by a third party company (PTC).
• The Accounting system comprising of Credit memo, check and accounting balancing is done in .net environment.
• Transmission to Manufacturers happens through EDI process
• This cohesive system includes:
• SSIS package transfer the warrantable repair orders to SQL database
• These Repair data is transmitted to PTC via Biztalk
• Processors creates Dealer claims, Supplier claims in PTC
• Dealer and Supplier claims from PTC are transmitted to our SQL database
• The supplier claim data is transmitted to manufactures via EDI
• Manufacturers’ response is saved in our SQL database. The SQL Process creates Automatic Credit memo and post accounting transaction to our Accounting software.
• Manufacturer’s Check and EFT are reconciled against the check
• When manufacturers send Shipping request, the SQL job sends the request to AS400 (for our shop Users)
• In case Shop user does not send the parts, nightly SQL Job escalates the request. Finally, if no response is received from Shop (28 days), SQL Job creates penalization credit memo

Technology: C#.net, SQL Server, SSIS package, Angular JS, MVC, BizTalk, JavaScript, Bootstrap

Confidential

Responsibilities:

• In order to accommodate the Confidential ’s new system, I have redesigned our Confidential screens and Program.
• Confidential creates claims for this manufacturer.
• Our batch jobs send the files in EDI 1041 format to Confidential . C
• nfidential sends the credit memo and acknowledgement.
• Confidential needed more data items transmitted in different format to them.
• This necessitated the change of our programs

Technology: Cobol, DB2, IMS DB/DC

Confidential

Senior Developer

Responsibilities:

• Users maintain vendors, contracts and multi-tier rebate information in this application.
• The system calculates vendor rebate based on the amount of purchase on a monthly basis.
• This vendor rebate data is transmitted to AS400, so that Shop-users can create purchase order (debit memo).

Technology: C#.net, SQL Server, SSIS package

Confidential

Senior Developer

Responsibilities:

• This application maintains the Manufacturers, parts, Part Request and Price information
• Shop users create Repair order using the parts in AS400 system. So a SSIS package synchronizes the parts in Confidential with AS400. When Shop user nedds new parts, they creates a new Parts requisition in AS400. This data get transmitted to this system to this system via SSIS packages.
• Designed the application, later managing 5 team members to develop this integrated system.

Technology: C#.net, SQL Server, SSIS package

Confidential

Developer

Responsibilities:

• In order to accommodate the Confidential ’s new system, I have redesigned our Confidential screens and Program. Confidential creates claims for Confidential .
• Our batch jobs send the files in EDI 1041 format to Confidential .
• Confidential sends the creditmemo and acknowledgement.
• Confidential needed more data items transmitted in different format to them. This necessitated the change of our programs

Technology: Cobol, DB2, IMS DB/DC

Confidential

Senior Developer

Responsibilities:

• The PM Form system is equivalent to 27-point inspection the dealers performs for our car. Since we have variety of trucks, our inspection items vary with the truck and type of PM Task.
• This new system replaced the Paper form.
• User creates various form based on the VMRS Code (Task string). It includes the form, Inspection Line items and the follow-up task associated with the lines
• When our shop user creates an Inspection task, the system generates the a transactional form (SMOFORM) based on Master details dynamically.
• SSIS Package: Transmits the Master forms to AS400. The transactional form forms from AS400 is synchronized with SQL every night.
• Managed a team of 3 people during the development phase.

Technology: C#.net, SQL Server, SSIS package, JavaScript