OBJECTIVE:

A Software Developer position where excellent analytical problem solving skills and strong work ethic

SUMMARY:

• Solid experience in wide spectrum of complex IT projects
• Extensive experience in relational database design and implementation
• Experience working in Risk Management Confidential in Confidential
• Experience in developing HR Software in Confidential
• Outstanding expertise in system analysis, design and SDLC.
• Successfully design and developed complex and huge database application
• Expert in the Entity - Relationship Model and Relational Database Model (RDBMS)
• Self-motivated, honest, dependable, hard-working, flexible, team player, problem solving, committed to high quality work
• Effective verbal and in written communication at various levels with individuals and groups

TECHNICAL SKILLS:

• Relational Database Management Systems (RDBMS) such as SQL Server 2008, 2005, 2000, 7.0, MS ACCESS, FoxPro and familiar with My SQL and Oracle
• Experience with T-SQL and PL/SQL
• Data Base Administration (SQL-Server) including strategizing and implementing database Enterprise backup/recovery and disaster recovery, troubleshooting, optimization, database security and integrity roles
• Experienced in optimal logical and physical database design Normalization and demoralization
• Familiar with Microsoft Visual InterDev 6.0, Visual Studio, SQL Server Management Studio
• Creating application to read Electronic Data file and Import to database
• Familiar with IIS
• Creating DTS and ETL package using Microsoft SSIS
• Create Reports using SSRS
• Familiar with SAP
• Windows 2000/2003 Advanced Server, Win NT4.0, Linux, UNIX, Novell Netware, Win. XP/7,2000,9x,3.x,DOS
• V.B. 5,6.0, ASP, C#, VB.Net, WPF, .Net Framework 1.0,2.0,3.0 4.0 ADO,OLE DB, VB Scripts, VBA for Excel
• C, XML, Web Services, HTML and DHTML, Crystal Reports, ActiveX, FoxPro, Java Script, Java, Weblogic 10.3
• Entity-Relationship (ER) Modeling and Relational Database Model (RDBMS)
• Structured Systems Analysis and Design Method (SSADM) and UML.
• Object Oriented Programming methodologies (OOP).
• VMware, DbVisualizer, TOAD, Scarab, JIRA, Microsoft project, Microsoft Office, Microsoft Visual Source Safe (VSS), SharePoint

WORK HISTORY:

Software Developer

Confidential

Environnent : VB6, MS -Access 97- 2003 and 2007 and 2010, Excel VBA, Java Script, Java, T-SQL, Visio, Oracle 10g, .NET MVC C# and C# WPF

Responsibilities:

• Support existing MS-Access applications in Windows xp and Migrate them to MS-Access 2007, 2010 in Windows 7
• Creating Renewal Packages for existing and/or prospective clients
• Enhance application base on BRD using VBA and Ms-Access 97, 2003, 2007 and 2010
• Create new application for new accounts (Preventives Health group, Acord, Anglican and Lutheran churches using MS-Access 2010 from scratch (Designee the database and program VBA codes and generates all reports in MS-Word and Excel)
• Create New .net MVC using C# to create a new application for Group Business Department, for generates and renew policies, Generates renewal documents such as SOV, DOV, Policy Premium and manage Risk Analysis Report, Monthly Bordereaux Report
• Daily Support of existing Group Business Applications for HSC, Loblaw, PHSG, CGA, Conservation, Risk Control and Anglican in different MS-Access plat form (2002, 2003, 2007 and 2010)
• Create modules for mass Renewal Policy premium, commission and tax Calculation
• Create an interface for Mass Documents Generation for Renewal packages for existing and new clients
• Fix Tax calculation in existing MS-Access applications
• Create Rating Matrix for each clients in existing application using VBA module in MS-Access
• Create new module for Gross and Net Premium, commission and tax calculation base on new rating model received by insurer BRD for CGA clients
• Writing an Interface in VBA Excel for Synchronized the Client side application with in-house legacy system.
• Enhance CGA application in (MS-Access 2010 and Oracle database) to get another Line Of Business (Coverage) information for off line clients and refresh Web Service Reference Tool to Generates Credit Card Payment and Generates Web Base Document
• Daily support existing MS-Access application for AON head office and AON branches
• Migrate all Access Application in different version (Access 97, 2002, 2003 and 2007) to Ms-Access 2010 in Windows 7and fix all issues that was related to migration process like compatibility of Activex Library files, Web Services, PDF Generators and ..
• Enhance SoHo application and add new interface to get Tenant Support Services information in VB
• Modify necessary changes in Confidential application in VBA for renewal package, Bordereaux Reports
• Create Technical and user manual documents and Transfer knowledge base to the team support
• Design and developing new application to replace with some existing Ms-Access base application in C# .Net and WPF platform as development tools and use Ms-access and Oracle as database.
• Creating insecurely class module for use in GUI forms, premium calculation, renewal calculations and document generation, create tree view menu for fast access to client list in WPF C#
• Creates new database application for Pro-Bel Acord, Lutheran churches and Provincial Health Group Services to calculate policy information and document generating for mass insurance policy.

Sr. Software Developer

Confidential

Environnen t : VB .NET, VB6, MS -Access 2003, 2007 and 2010, Excel VBA, Java Script, Java, Weblogic 10.3, Oracle 10, SQL-Server 2008 , T-SQL, PL/SQL, Visio

Responsibilities:

• Reviewing Confidential business requirements and analyses, modify and enhancement the existing applications for Marketing and Risk Management department following the system development life cycle and project management methodology and scheduling
• Enhance and write new VBA procedures in MS-Access coding and Functions for existing client/server base application to read Hourly, Daily and Electric Bid/Offer price information from Source companies for Forecast and create Market price Curve for analysis and marketing decision and store to the Oracle Database and generate Market Price Curve File.
• Modify and create new chart for final sign-off sheet report base of trade was placing in FPC application in Excel 2003 and also convert to Excel 2007
• Create Pivot table report for using the back office employee for check the accuracy of trade in FPC application in Excel 2007 and 2003
• Enhance an existing integrated MS-Access client/server base application for Market control department to adjust with new Confidential rules. Create complex embedded query in SQL to read and write from deferent source (Flat, XML and MS-Access file) and store result into the Oracle data base and generate report in Excel.
• Enhance existing FPC application for Electric Price using VBA for excel and PL/SQL query, to read preliminary data from e-mail and e-mail attachments to eliminate manual inputs and multiple steps, then calculate and generate forward price curve using basis curves for using the energy market traders.
• Write a new VB module for existing FPC application in MS-ACCESS to read daily and forecast Gas & Oil Price read/write from/to Oracle Database and generate a Forward Price Curve file for upload to Zainet application for Energy Market users.
• Write a new module using VBA and PL/SQL for existing marketing application to generate forecast Price Curve for NGX market and Migrate reports and template files from Excel VBA 2003 to Excel VBA2010
• Generate complex Sign Off report sheets in Excel using Excel-VBA for finance department.
• Modifying an existing Web base application (Interregional Trade Management) for Confidential and Confidential new rules, using Java, Java Script, JSP and Weblogic 10.3. read & write from/to Oracle database by using PL/SQL query
• Perform Unit and System test for FPC, ITM and Confidential application according Confidential standard test policy
• Train clients to work with new changes in applications and knowledge transfer to permanents employee for continuing the support
• Crate/Modify User manual and Technical Reference using Microsoft office and Visio

IT Software Developer

Confidential

Environnen t : Microsoft -Access 2003 and 2007, SQL Server, T-SQL, VB6, VB .NET 2008, Excel VBA 2003 and 2007

Responsibilities:

• Reviewing Confidential and Telco’s business requirements for analysis, design, develop and implementation the client server base application for Finance department following the system development life cycle in a timely manner.
• Define business rules for create functions and procedures for design new application and conduct with management and business partners and contribute business meeting to ensure effective communication, integration of project issues and project milestones and overall project deliverables on time
• Designed and implement a logical and physical relational database including tables and queries and relations between on MS ACCESS for a Financing application
• Migrate Existing VB6 application to VB .Net 2008
• Write necessarily codes for create windows application forms using VB .Net 2008 for read and import Excel data input files to MS ACCESS database by using OLEDB technology
• Developed functions and procedures for calculating total amount, net amount, balance and applicable tax (HST, GST, PST, and QST) on Telco’s invoices depend on relation between each Telco with other Telco base on their jurisdiction policy using VB .Net 2008, Excel VBA and MS ACCESS T-SQL statements
• Create complex query using MS ACCESS T-SQL commands for calculating Tax, Net Amount, Balance, SAP interface and generating reports
• Design and develop template Financial reports using Excel and Excel macros for TC7 Application
• Create Data Cube and Pivot table and chart report for using Excel 2003 for analyzing the usage and cost of each Telco in the deferent Jurisdiction
• Developed Invoice package reports in Excel file format by using VB .Net 2008 and Excel VBA with several tabs include Invoice report, Detail information, summary information for each group and Pivot tables
• Automatically create Pivot tables for each report using VB .Net 2008 thru the application
• Developed windows data entry form for access to database and maintain the data in the reference tables
• Developed SAP interface file using VB .Net and make sure all billing information are balance and send it to the general accounting system
• Write unit Test Case for check the accuracy of application and test the application
• On-going support, maintenance and troubleshooting
• Generate necessarily queries for migrate data from Old application to new application
• Create data map table for make sure of accuracy of migration information from old system to new application
• Train client how to work with new application
• Crate User manual and Technical Reference using Microsoft office tools

Database Developer/Analyst

Confidential

Environment: SQL SERVER 2000 and 2005, Microsoft Access, VB6, T-SQL, C++, ASP, C#.NET 2.0, Crystal Report 8.5 and Excel VBA, Citrix, GoToMeeting

Other Tools: DbVisualizer, Microsoft office, Scarab

Responsibilities:

• Designed and Implement a Logical and physical relational database on SQL Server 2005/2000 for Energy management application (database has more than 250 tables)
• Performed SQL Server 2005/2000 administration (Backup and restore and recovery plan, Data integrity and Data security, Maintenance Plan, Tune and optimization, Normalization/ Demoralization and server monitoring)
• Wrote Advanced Stored Procedures, Queries, Views and triggers for use in Energy management applications for very large tables using T-SQL
• Analyze historical data received from clients, create data mapping and work on Excel file for data Reconciliation using VBA commands
• Wrote interface using C# .Net for convert Monthly Electronic Data file (in XLS and/or MS ACCESS or CSV format, Receive from multiple vendors) to Standards CSV format for import to ECAP application.
• Developed Interface for export data from Ecap application to GL or other accounting system according destination application format.
• Extract and transfer and validate existing historical data in Excel, Flat File and Access file format to SQL Server database using Microsoft ETL tools (SSIS) and translate to database
• Modify Macros and Module in their existing Microsoft Access application using VBA for Access.
• Create new query (Views) using MS ACCESS to derivation correct information for migrate to new system
• Create custom pivot table in Excel for find out client and vendor activities
• Create New report and modify existing reports using Crystal report 10.0
• Modifying existing web base application using ASP
• Create new tables and data entry forms using MS ACCESS to convert old facility management data from Excel to Microsoft Access database and create specified reports as request
• Helped production team to investigate complex problems by analyzing the SQL statements and queries using MS SQL Query analyzer and SQL profiler and MS ACCESS
• Assisted QA department to create test cases\scenarios for manual and automated testing.
• Maintained and debugged existing VB 6.0 application for existing customer.
• Get remote clients issue and participate to daily support in Citrix environment
• Organize and document users guide for do the better support, communicate with remote user with GoToMeeting to resolve issues

Database developer

Compusharp, Richmond Hill

Environment: Microsoft Access, VB 6.0, Crystal report, Excel and VBA for MS ACCESS and VBA for Excel

Responsibilities:

• Designed and developed relational database on MS ACCESS 2003
• Create custom data entry forms with complex calculation and data verification using VB 6.0 and connect to MS ACCESS using ADO technology
• Performed Macros and Modules functions and wrote Queries using T-SQL commands and VBA statements
• Wrote an application to convert windows text file format received from customer for work in MSDOS base application for using in printing machine using VB 6.0
• Create an application to data file (in EXCEL, Txt and CSV format) to the W.F Management system
• Serial number management
• Create a program for Inventory control using Visual basic 6.0
• Create a windows data entry form for Get, Store and Follow up customers orders with VB
• Wrote a program for Manage levels and items movements
• Designed and Execute various type of report using Crystal report and Excel with VBA for EXCEL.

Database support

Confidential

Environment: SQL Server 2000, Microsoft Access, VB 6, Crystal report 6, Excel

Responsibilities:

• Performed SQL Server 2000, MS ACCESS 2003 administration (Backup and Maintenance Plan, tune and optimization, normalization/ renormalizations)
• Work on secure and encrypted database
• Manage database security and integrity, full control user access and manage user log file
• Define and manage Database Server object roles and writing Stored Procedures, Query’s and triggers
• Define and develop new Data entry forms and customize existing windows forms for new clients using VB 6.0
• Developed and create various reports using Ms Access report with VB Scripts and SQL Script