Software Development Developer

Location:

Posted:

November 16, 2024

Resume:

OBJECTIVE

Experienced SQL Developer /.NET Software Developer with skills in creating, development and reverse engineering software for the companies in government, banking, finance and manufacturing institutions seeking a challenging position in software development .

TECHNICAL BACKGROUND

22+ years’ experience in software development using object-oriented languages and relational databases

12 Years Production Support in automotive, market analysis, banking, healthcare, contracts, and insurance institution

Recipient of MOHLTC ACE (Accomplishment, Commitment, and Excellence) Award for Stakeholder/Partner Relations

Experience in project coordination, management, and technical support in North America, Americas, Europe, and Asia

Demonstrated leadership skills in software development and end-user training

Highly adaptive as well as detail oriented, well-organized and reliable

Strong ability to convert business requirements to technical implementation

Created data

Provides Quality-Assurance through extensive unit testing and User-Acceptance testing

Demonstrated ability to multitask and work with a team

University Scholarship educated in Japan

Dual Bachelor of Science Degree in Engineering

PROJECT DETAILS

1.HMG Information Systems/Micro Mainframe Inc.

https://www.mmcinc.com

.NET Programmer/Developer

May 30 2023 to August 2024

Maintenance and development of fuel sales, credit and distribution software

Databases : MS-SQL Server 2019

Languages : VB.NET, VB 6.0, HTML5, T-SQL, JavaScript, Webforms Applications, WCF Services, ASP.NET

Software Tools : Visual Studio .NET 2019-2022, SSMS, SSRS, Atlassian Jira, Team Foundation Server (TFS), Microsoft Excel, Microsoft Word, Microsoft Access

Documentation : Microsoft Office 365 (Word, Excel, Visio, and Access)

oDevelopment, maintenance and upgrade of web application functions for client AEG Fuels World Services Jet Fuel Application Management Client portal

oProvide expertise in reverse-engineering existing software applications for modifications and enhancements

oCollaborate with various AEG Fuels teams to include accounting, sales, marketing, and administration

oCreated WCF Service for database information query integration with user-interface

oCreate reports and custom queries for sales, credit risk and projection analysis

oProvide testing, production support, monitor, investigate and resolve application processing issues

oWork in an Agile environment using Jira to provide rapid application development for production issues and new features/enhancement

oCreate tables, functions, stored procedures and triggers in SQL Server

oCreate custom Crystal Reports forms

2.RLDatix, Incorporated (Remote)

IT Team

http://www.rldatix.com

Technical Solutions Analyst

October 2021 to March 2023

Per customization of contracts and forms for Contract Management application

Operating System : Windows 10 Professional 64 bit

Databases : MS-SQL Server 2017

Languages : VB.NET, C#, XML, JSON, VSTO, T-SQL

Software Tools : Visual Studio .NET, SQL Server, WCF Services, Microsoft Excel, SSMS, SSRS, Atlassian,Microsoft Word, GitHub, Atlassian Jira, IIS

Documentation : Microsoft Office 365 (Word, Excel, Visio, and Access)

oCustomize Contract Management application to conform with client

oProvide solutions for issues and enhancement to application using Jira in Agile environment

oDeploy applications enhancements

oProduction support, monitor, investigate and resolve application processing issues

oModified WCF Services to accommodate additional data requests

oCreate, update and add XML documents

oDevelop, enhance and troubleshoot applications and utilities

oUpdate and create stored procedures for MS-SQL Server

oWrite application flowcharts, manuals and other documentation

3.Verisource Services, Incorporated

IT Team

http://www.verisource.com

Programmer Analyst III

October 2018 to July 2021

Maintain/Migrate Healthcare benefit plan administration, Cobra, and Financial accounting legacy Applications to C# Windows Application

Operating System : Windows 10 Professional 32/64 bit

Databases : MS-SQL Server 2017/ Visual Fox Pro

Languages : VB 6.0, VB,NET, C#, MVC, HTML5, T-SQL, JavaScript, Webforms Applications, WCF Services, ASP.NET Core, Entity Framework Core, WCF, MFC

Software Tools : Visual Studio .NET 2017-2019, SSMS, SSRS, Atlassian Jira, Syncfusion, Team Foundation Server (TFS), Microsoft Excel, Microsoft Word, Microsoft Access

Documentation : Microsoft Office 365 (Word, Excel, Visio, and Access)

oReverse-engineer existing legacy both windows and web software to C# Windows Application

oProduction support, monitor, investigate and resolve application processing issues

oCreate custom Crystal Reports data analysis reports and custom queries

oETL data Multi-threading calculations and processing of health benefit data

oModified and added WCF Services for data retrieval from database

oEnsure database connectivity via Visual Fox Pro, MS-SQL Server, and Access

oOrganize coding from various business logic libraries

oWrite application flowcharts, manuals and other documentation

4.Toshiba International Corporation

Infrastructure System, Application Development Group

https://www.toshiba.com/tic/

Programmer Analyst III

March 2011 to September 2018

Project : Hybrid Electric Vehicle Support and Maintenance

Operating System : Windows 10 Professional 32/64 bit

Databases : Oracle 12/SQL Server 2012

Languages : C#, VB.NET, Entity Framework, ASP.NET, Webforms Applications, WCF Services, JavaScript, VSTO, VBA, MS Office JavaScript Library, WCF Services, MVC, HTML5, Silverlight, VBA,T-SQL, PL/SQL

Software Tools : Visual Studio .NET 2008-2017, SSMS, SSRS, SSRS, Oracle, Toad, Visual SourceSafe, Team Foundation Server (TFS), SharePoint, ServiceNow, Syncfusion, Telerik, Microsoft Excel, Microsoft Word, Microsoft Access

Documentation : Microsoft Office 2016 (Word, Excel, Visio, and PowerPoint)

oSupport production line activities by maintain Quality Control/Defect Management applications

oDevelop QC and Defect Management related web and client applications

oCreate custom quality control data analysis reports (graphical and data calculations) outputs in web and SSRS

oEnhancement for WCF service data retrieval based on client requirements.

oProvide production support and troubleshooting

oCustomize existing production line applications to coincide with manufacturing requirements

oEnsure minimum downtime due to application issues

oRevise applications according to the “Change Request” of HEV Personnel

oMigrate all applications created from IIS 6.0 to IIS 7.0

Project : Motor net II Reporting Tool/ Laser Name Plating App

Operating System : Windows 7 Professional 32/64 bit

Databases : MS-SQL Server 2000/2008 R2, Oracle

Languages : C#, VB.NET, VBA,Silverlight, WPF, MFC, WCF Services, T-SQL, PL/SQL

Software Tools : Visual Studio .NET 2008/2010, SSMS, SSRS, Atlassian, PDF Tech, Telerik, Syncfusion, Microsoft Excel, Microsoft Word, Microsoft Access, Entity Framework, Blend

Documentation : Microsoft Office 2010 (Word, Excel and PowerPoint)

oUpgrade Motornet II Excel-Add in from Visual Studio 2008 to Visual Studio 2010

oMigrate related database from SQL-Server 2000 to SQL-Server 2012

oProvide additional export control to Spanish version PDF generated motor specification

oModify application based on corrected business requirements from the Motornet Engineering Team

5.Cameron (now Schlumberger)

Sales and Marketing Division, Houston, Texas

https://www.slb.com/companies/cameron

Programmer Analyst

Nov 2010 to March 2011

Project : Well Market Share Reporting

Operating Systems : Windows XP Professional 64-bit

Databases : Microsoft SQL-Server 2008

Languages : ASP.NET, C#, VB.NET, DHTML, T-SQL

Software Tools :Microsoft Excel, Microsoft Word, Microsoft Access

Documentation : Microsoft Office 2003 ( Word, Excel, and PowerPoint)

oAnalysis and creation of new web-based Oil Well Market Data Share Analysis (Crude Oil, Natural Gas, etc) for publication to yearly book report and ad-hoc requests

oRedesign and revision of existing WMS Financial Reports for faster response time and user-friendly display

oCreation of database tables and views

oPublishing of web pages to web server

oCoordinated with Marketing analyst concerning business requirements for reports

6.Ministry of Children and Youth Services, North York, Ontario

Community and Social Services, SMIS Team

http://www.children.gov.on.ca/htdocs/English/index.aspx

Software Developer/Database Administrator

October 2009 to March 2010

Project : CSV Data Conversion Application

Operating Systems : Windows XP Professional

Databases : Microsoft SQL-Server

Languages : Visual Basic Application (VBA), T-SQL, VSTO

Software Tools :Microsoft Excel

Documentation : Microsoft Office XP ( Word, Excel, PowerPoint, and Visio)

oIdentified, evaluated and provided technical implementation solutions for storage of Excel data collected agency budget, amendment, service contract, quarterly, and year-end submissions

oDevelop multiple independent universal CSV Data Extractor with user-friendly graphical user

oETL Data processing Canadian Mental Health Data Care information

oDocumented technical proposals and specifications

oProvided support for both the Information Policy & Integration Unit (Social Policy Development Division) and the Service Management Information System (Children, Youth and Social Services I&IT Cluster)

7.University Health Network, Toronto, Ontario

Shared Information Management System

http://www.uhn.ca

Senior Technical Support Analyst – Infrastructure Team, Corporate Intranet

February 2008 to December 2008

Projects : MS-SharePoint Migration, Ad-hoc System and User Technical Support/Assistance

Operating Systems : Windows 2000/2003 Server Edition, Windows XP, UNIX

Database : MS-SQL Server 2000/2005, Oracle 8.5/9i and Microsoft Access

Languages : Visual C#, VB.NET 2003/2005, XML, ASP, Phyton, T-SQL, PL/SQL, ASP.NET 1.1/2.0/3.0/3.5, JavaScript

Software Tools : Visual Studio .NET 2003/2005, SSMS, SSRS, Dreamweaver, Adobe Photoshop, TOAD, ODBC, ActiveX, and OLE

Reporting Tools : .NET Reporting Services, Cognos and Crystal Reports

Documentation : Microsoft Office 2007/2003/97 (Word, Excel, PowerPoint, Visio and Project)

oDeveloped, installed and supported of both intranet and extranet sites and applications used by UHN employees (TGH, TGWHF, PMH, St. Michael, St. Joseph, etc. that are under the umbrella of the Shared Information Management Infrastructure )

oCreated and developed web, databases. and windows application for the University Health Network Corporate Intranet

oProvided 3rd level Technical Support and ad hoc services to end-users

oMigrated and configured of UHN Sites and applications to new servers

oInstalled Virtual Machine Server Setup and application tools

oSupported Third-party and in-house third-level

oProvided ad hoc site modification and improvements on both extranet and intranet sites

oManage and maintain all shared healthcare related information of UHN

oMigrated data using Stellent to Microsoft SharePoint Web Content Portal

oMaintained all UHN Intranet Servers relating to TCP/IP, DNS, HTTP, FTP, SMTP, SSL, Firewalls, server architecture, load balancers, and Website monitoring

oCreation of documentation using software design support tools and productivity suites such MS Visio, Office and Project

8.Ministry of Health and Long Term Care, Toronto, Ontario

Health Services Cluster, I&IT (Secondment for Trillium Hospital)

Policy and Planning, Information Management

http://www.health.gov.on.ca/en/

Information Management Analyst

January 2007 to December 2007

Projects : CDS-MH, Residence Code, Master Number, Information Management System, Ontario Case Costing Initiative, etc.

Operating Systems : Windows 2000 Professional/Windows Server 2003, Windows XP

Database : MS-SQL Server 2000/2005 and Microsoft Access

Languages : Visual C#, VB.NET 2003/2005, DHTML, T-SQL, XML, VSTO, ASP.NET 1.1/2.0, JavaScript, UML

Software Tools : Visual Studio .NET 2003/2005, SSMS, SSRS, IIS Web Server, ADO, ODBC, ActiveX, and OLE

Reporting Tools :.NET Reporting Services, Cognos and Crystal Reports

Documentation : Microsoft Office 2007/2003/97 (Word, Excel, PowerPoint, Visio and Project)

oDeveloped, deployed, implemented and supported of Canadian Mental Health and Addictions Program’s Common-Data Set Web Submission Tool providing “concurrent/simultaneous” submission of vital data from over 400 agencies all over Ontario

oDeveloped web and windows based applications from planning to delivery for data collection system, analysis, and other applications for Finance Information Management Branch using various languages such as C#, Visual Basic .NET/6.0, XML, VBA, etc. as per client requirement

oRevamped CDS-MH Web submission tool to include modular programming design techniques and to improve efficiency of data transfer via the network

oRestructured CDS-MH SQL Server database to include stored procedure validations and server-side calculations

oInstalled, configured, and published websites, reports, and publications in IIS (web server) and as well as related database connection

oProvided Quality Assurance and User Acceptance Testing through rigid unit testing, performance, stress

oManaged and coordinated technical software development and support to the mental health agencies

oResponded to ad hoc technical support inquiries from internal branches and external agencies

oConducted installation and configuration of software and third party application integration

oCreated business report generating tools using Microsoft Access

oAdded prototype business intelligence reports using .NET Reporting Services

oProvided detailed technical documentation (flowcharts, UML, processes and structure)

oInitiated study for possible use of Cognos for reporting services

oPerformed routine database and application maintenance/support activities during submission period

9.MOHLTC, Toronto, Ontario

Finance and Information Management (Secondment for CMH&A)

http://www.health.gov.on.ca/en/

Programmer Analyst

September 2005 to December 2006

Project : Common Data Set – Mental Health Project

Operating Systems : Windows 2000 Professional/Windows Server 2003, Windows XP

Databases : MS-SQL Server 2000/2005, and Microsoft Access

Languages : Visual C#, VB.NET, DHTML, T-SQL, JavaScript, SOAP, XML

Software Tools : Visual Studio .NET 2003, SSMS, SSRS, IIS Web Server, ADO, ODBC, ActiveX, and OLE

Reporting Tools :.NET Reporting Services and Crystal Reports

Documentation : Microsoft Office 2003/97 ( Word, Excel, PowerPoint, and Visio)

oLed development of web-based CDS-MH Data reporting and feedback system

oReceived MOHLTC ACE (Accomplishment, Commitment, and Excellence) Award

oConsulted with users and team members to clarify project objectives

oTranslated business requirements to technical design specifications

oReviewed, evaluated, designed implemented and maintained CS-MH database

oIdentified data sources, constructed data decomposition diagrams, provided data flow diagrams and documented the process

oImplemented and maintained controls for database access

oDeveloped web forms for data collection using web programming and development tools such as Visual Studio .Net or other Microsoft Development Tools

oReviewed analyze, and modified programming systems including encoding, testing, debugging and installing to support applications

oWrote documentation to describe program development, logic, coding, and corrections

oWrote user guides to access and utilize web-based data collection tool

oInstalled configured and maintained application development software tools

oInstalled, configured and maintained application development software tools

oPerformed system backups on internal and external network servers

oResponded to team and user requirements for technical support

10.Siemens Building Technologies Limited, Brampton, Ontario (Part-time)

http://www.ca.sbt.siemens.com

Software Consultant

August 2002 to September 2006

Project : National Sales Tracking Database Systems

Operating Systems : Windows 2000 Professional/Unix

Databases : Oracle 9i, MS-SQL Server 7.0, and Microsoft Access

Languages : Visual C++, Visual Basic 6.0, Structured Query Language (SQL), T-SQL, VBA

Web Languages : VB.NET, JavaScript, XML, HTML, DHTML, XHTML,PL/SQL

Software Tools :Visual Studio .NET, SSMS, SSIS, Web Sphere, Web logic, Dreamweaver MX 2004

Documentation : Microsoft Office XP ( Word, Excel, PowerPoint, and Visio)

oDeveloped and tested a centralized multi-user national sales forecasting database for Sales Executives and Sales Representatives

oCreated a user-friendly graphical interface integration

oUpgraded database system using Oracle 9i with Visual C++ based user interface. Analyzed business needs to customize forms, reports and SQL queries for financial forecasts and projections

oDesigned prototype ASP.NET-based prototype migration software for costumer accessibility in placing orders

oImplemented training schedules and instructed new users on “Tracking System Application” features

oSubmitted project proposals, cost estimate, project status reports, software testing reports, quality assurance, time schedules, and user manuals

oIncorporated forecasting data to in-house “Estimating System” that uses Oracle 9i platform

oResolved and maintained data integrity and synchronization efficiency of both end-user and database issues

11.Advanced Software Design, Toronto, Ontario

http://www.asdc.com

Senior Technical Support Analyst

January 2005 to August 2005

Project : Software Installation and Network Deployment

Operating Systems : Windows XP

Databases : Microsoft SQL-Server 2000

Languages : Visual Basic .NET, VB Shell Script, SQL, Visual C++, Java, PHP

Web Languages : VB.NET, XML

Software Tools : Install shield Developer 8.0, SSMS, SSRS, PC Anywhere, Eblvd.com, Virtual Network Connection

Documentation : Microsoft Office XP ( Word, Excel, PowerPoint, and Visio), Visual SourceSafe)

oCustomized software installation and configurations settings using Install shield Developer 8.0 relating to check fraud detection and security products to maximize efficiency and minimize cost in deployment and implementation to client site

oConducted preliminary Quality Assurance and User Acceptance Testing for software installation packages to ensure that programs are working properly at customer site with minimal customization requirements

oDeployed and implemented both on-site and remote installation in the U.S. of SQL Scripts, Dynamic Link Libraries, Executables and configurations to clients

oProvided technical support, test, and troubleshooting requirement on production issues concerning programming, database connectivity, and configuration

oCoordinated schedules on upgrades and software releases to avoid delays on client processing

oIdentified escalation issues due to defect/bugs and enhancements reported by the customer

oFormulated version controlled release documentation and manuals for every versions releases

12.Promeric Technologies Limited, Toronto, Ontario

http://www.promeric.com

Software Developer

August 2004 to November 2004

Project : Financial Insolvency Tool Development, Deployment and Network Deployment

Operating Systems : Windows XP

Databases : Microsoft SQL-Server 2000, ZIM

Languages : Visual Basic .NET, VB Shell Script, SQL,XML

Software Tools : SSMS, SSRS, Turbo SFX, WEBEX, Buggy

Documentation : Microsoft Office XP ( Word, Excel, PowerPoint, and Visio), Visual SourceSafe

oDeveloped. revised, tested and implemented a multi-user accessible database system using VB.NET, SQL Stored Procedures, and Microsoft SQL-Server for Credit Counseling Organizations.

oPerformed data conversion using DTS to extract data from ZIM to MS SQL-Server format to populate table requirements for the database

oCustomized user-friendly graphical user interfaces forms and report.

oReprogrammed stored procedures to improved efficiency of for other existing databases

oCreated manuals and technical specifications for client use and references

oDocumented bugs and fixes to keep track of issues and upgrade required on releases

13.IBM Canada – Global Services, Markham, Ontario

http://www.ibm.ca

Software Integrator

Sep 2003 to March 2004

Project : Software Installation and Network Deployment

Operating Systems : Windows XP/NT

Databases : Oracle 8.0, Microsoft Access

Languages : Visual Basic 6.0, VB Shell Script, Structures Query Language (SQL)

Web Languages : VB.NET, VB Shell Scripts, JavaScript, XML, HTML, DHTML, DHTML

Software Tools : Visual Studio, VMWare V4.0, SMS Installer V2.0 and Wise Professional Installer

Documentation : Microsoft Office XP ( Word, Excel, PowerPoint, and Visio)

oCreated software installation packages in the form of MSI/MST/EXE using Install shield/SMS/Wise Installation for distribution to global Deutsche Bank branches and other IBM client

oProgrammed, integrated, configured, and deployed the installation packages for Market Data Applications, web-applications, databases, and system drivers. Communicated and gathered information on application directly with clients from Japan, Taiwan, Australia, China, Brazil, London and New York concerning support and revisions concerning packages

oConducted preliminary Quality Assurance (QA) testing using core build images via ghosting and virtual machines

oSubmitted installation reports and updates to testing and production repository servers

oProvided escalation support as requested by the client on technical issues relating to configuration of setup program

14.DANA Brake Parts Canada, Mississauga, Ontario

http://www.dana.com

Software Consultant.

July 2003