Senior .NET Developer Looking for H1B Visa Transfer
Overview
§ An IT professional with over 15 (fifteen) years of Combined Experience in
Technical, Development and Lead roles in different industries and consulting services.
§ An IT professional with over 14 years of combined experience in technical,
development and lead roles in different industries and consulting services.
§ Has over 5 years of functional/technical design, development and implementation
using VB.NET and ASP.NET (2002 and 2005 version). Currently using Visual Studio 2008
suite (Framework 3.5), LINQ and Crystal Report 10.5.
§ Good knowledge of web services.
§ Expertise in developing with Visual Basic 6.0 for over 10 years.
§ Good knowledge of Oracle 8i, 9i, 10g and 11g databases for backend, Stored
Procedure and functions, trigger, View and PL/SQL.
§ Good knowledge of MS SQL Server 2000, 2005 and 2008 including setup, and
database creation/administration, Stored Procedure and Functions for development
(backend).
§ Extensive knowledge of setup and management of Microsoft Access 97, 2000, 2002,
2003 and 2007 for application development and database implementation, and interfacing
with other relational databases for over 13 years.
§ Extensive knowledge of Microsoft Office 95, 97, 2000, XP, 2003 and 2007 products
installation, use, training and as a development tool.
§ Good knowledge of Crystal Report 7, 8.5 and 10.5 for report design and
integration
§ Expertise knowledge in Microsoft Excel for data management and automation using
VBA, interfacing to external relational database to create/run existing queries from
relational databases and training and user support.
§ Extensive knowledge in systems analysis, requirement specifications, designs,
implementation and data gathering.
§ Good experience in OOP, JavaScript,
DHTML, XML, Microsoft Office 2000/2003, CSS
and Themes, ODBC, XML, TOAD, Putty and Ghost Script
§ Good understanding of system cycle tests and deployment strategy.
§ Extensive knowledge in software installation and evaluation.
§ Proficiency in system cycle documentation and training of users.
§ Good knowledge of data sourcing, cleaning and migration.
§ Exposure to various IT hardware installations, integration and maintenance.
§ Good understanding of application integration and utilities development.
§ Working knowledge of Java.
§ Good knowledge of Windows 98, NT 4.0, 2000, XP, Vista and 2003 Server Operating
Systems.
§ Great ability to learn and adapt to new programming languages/tools and
challenges.
§ Familiar in Novel Netware 4.12 administration and UNIX printing administrations.
§ Excellence communication, interpersonal skills, team leadership/follower-ship
and mentoring of software developers
§ Great self driven and goal achiever
PROFESSIONAL EXPERIENCE
AFRA Consulting & Services, Inc. Jan 2008
to Present
Senior Programming/Analyst
Ø Team member in functional design of Employee Attendance & Performance Discussion
System for Staples Center, NOKIA Theater, and LA LIVE. Designed the backend, developed
the interfaces and implements the solution. This is a web-based system that handles
employee absences including readiness to work, and proper clocking, award for good
attendance, work performance violations and employee commendation. The system captures
the employee attendance, performance and commendation data, allows employee data upload
from Comma Separated Values format, evaluates employee data and recommend personnel
actions to take based on the business rules setup by the user, allows printing of
personnel forms/reports for discussions and updates of employee information from the
discussions. Also performs documentation, user training and support. It is implemented
on ASP.NET with .NET Framework 3.5 using Visual studio 2008, ADO.NET, CSS, and DHTML,
Crystal Report and Microsoft Access 2000 for backend
Ø Team member in technical and functional design of Applicant-Select System.
Solely develop and implement Applicant-Select System - a web-based system that
facilitates an employer’s registration and subscription on the various products offered
by the company.
The system maintains the products’ life spans and costs. The employer
modules include, but not limited to, creating a profile (organizational structure, user-
groups, users, notification, messages), publishing vacancies, vacancy requirement,
vacancy questions and answers, interview scheduling and ranking, intelligent evaluation
of the applications and short-listing, initiate a background screen request, and perform
mass hiring. The employer/company can build a unique user-profile for the system users.
The applicant modules include, but not limited to, applicant registration, creating
profiles (resume, preferences, education, languages, skill, licenses, job experience),
applying for published positions that meet his profile, searching and applying for other
positions, vacancy question and answer, reset password and monitoring vacancy statuses.
The system is offered as SaaS or outright license purchase.
The System is implemented
on ASP.NET with .NET Framework 3.5 using Visual studio 2008, ADO.NET, CSS, AJAX,
Validation Scripts, and DHTML, Oracle Packages, Views and PL/SQL on Oracle 10g and 11g
databases.
Ø Interfacing MS Access 2000 and 2003 database through ODBC to Oracle 10g and 11g
for database management.
Environment:
Ø Visual Studio .NET 2008 Suite, Share Point, JavaScript, DHTML, XML, MS Access
2000/2003, Microsoft Office 2000/2003, CSS, ODBC, PLSQL, Oracle Packages (Stored
Procedure and Function), Job Schedule and Views
Ø Windows 2003 Server, Windows Vista, XP and 2000 Professional Version
Ø Oracle 10g and 11g database, MS SQL Server 2000 and 2005, and MS Access
2000/2003.
First Bank Plc. May 2004 to Dec
2007
Developer/Analyst
Ø Involved in the technical/functional design, development and implementation of
Trade Tracker System, a web-based alert system on bank customer Trade Service. The
system is integrated into the Enterprise Banking Application to monitor customers’ trade
transactions (export, import and invisible trades), alerts the customer via SMS and
provides web-based Customer Portal for reporting.
Such timely alerting information
increases bank customers’ satisfaction through effective communication as well as bank-
customer relationship and confidence. Some of the transactions progress information
attracts request and additional information from the customer. The Customer Portal
provision was made available via the bank’s website. The customer can view or download
details of the life cycle of the transaction. The system model was implemented using
ASP.NET 2002 .NET Framework 1.0, ADO.NET, CSS, HTML, SMTP, JavaScript, Triggers and on
Oracle 9i as backend.
Currently migrated into ASP.NET 2005 with .NET Framework 2.0 and
SQL Server 2005 as backend. Interfaces Microsoft Access 2000 database to the Oracle
database via ODBC for easy development data analysis. Also developed the technical
manual and training of users. Interfaces the Oracle database with Microsoft Access 2000
via ODBC for data analysis.
Ø Key team member in the technical/functional design, development and
implementation of a web-based bank customer statement of account generating system for
major oil companies (prime customers).
The architectural design of the system was
optimized to facilitate the different request of these customers as either daily
automatic bank statement distribution via e-mail or download from the bank’s website.
Developed the Oracle SQL statements to analyze all financial transactions (debit and
credit) for the statement.
The project provides the statement in HTML, CSV, Excel or
XML format using the parameter query string in .NET technology.
A prototype of this
project was developed using ASP.NET Web Services protocol to produce an XML statement
for Shell Production Development Corporation. Designed and created the database and
coded all the pages, implemented using ASP.NET 2002, ADO.NET, JavaScript, CSS, COM,
SMTP, Microsoft Excel 2000 and HTML with Oracle 9i as backend and on Windows 2003
advanced server.
Ø Team member in development of National Agency for the Prohibition of Traffic in
Persons (NAPTIP) system, an enterprise web system for the registration, review and
litigation details of child abuse cases.
Developed the Case Registration and Case
Review pages and created the database objects. The implementation was implemented using
Visual Studio 2005 (ASP.NET) with SQL Server 2005 database for the backend
Ø Team member in implementing Finacle Treasury 6.51 application for the bank.
Responsible for the design of various deal tickets and letters, business and printing
rules, Unix environment file setup and implementation. Responsible for financial data
analysis and migration to the new Oracle database. Conducts diagnosing and correcting
printing problems between the IBM AIX Unix server and the network printers.
The deal
tickets/letters were designed using MS Excel, PostScript software and Unix scripts. The
business rules were built around SQL statement files, Finacle Treasury mapping file
utility and the PostScript files. Environment: AIX Unix server and Oracle 9i Database.
Prepared technical and user manual on system administration, report design and
implementation.
Ø Performed technical designed and development of a web based Customer Information
Capturing Application for bank-wide use.
The major functionality of the application is
to capture components of bank customers’ manifest/information not available in the
Enterprise Banking Application for reporting to regulatory bodies.
Implemented using
ASP.NET 2002, ADO.NET, CSS, and HTML on Oracle 9i as backend.
Used by more than 350
branches of the bank.
Ø Key member in the functional and technical design, develop and implementation of
bank’s Inward Fund Transfer Application.
This intelligent system monitor’s the SWIFT
Alliance Server for incoming transaction messages type MT103, MT940 and MT950 (foreign
financial payment instructions), reads the message, merges and validates the data
applying bank’s set rules and sending the transactions to the enterprise banking
application.
Quality and efficiency in processing a very high-traffic inward fund
transfer transactions for the bank was achieved. This was implemented using VB 6.0,
ODBC, Oracle 9i as backend and Crystal Report 8.5 for reporting.
The designed rules put
the transactions into various statuses pending a processing officer’s input if
necessary, or approval officer verifying the records, and finally an upload officer
uploading into the banking application.
This project was recognized by the Management
for the monitoring of Central Bank’s transaction of $10,000,00 and above.
Developed
Oracle triggers for the application.
Ø Performed the analysis, design and implementation of Western Union Dollar
Monitoring Package.
This application forecasts Dollar allocation based on consumption
pattern, interfaces with Enterprise Banking application’s Oracle database to verify
Dollar position and allocation to over 350 branches of the bank.
It is implemented
using VB 6.0, ODBC, Oracle 9i as backend and crystal report 8.5 for reporting. A
prototype of the application was built on MS Access database before porting to Oracle 9i
as backend.
Ø Responsible for analysis, design and implementation of Shell Vendor
Application.
This application reads SWIFT message types MT101 text file, validates the
data, creates and FTPs the output file to the enterprise banking application.
The
message type is specifically for processing a very large volume of payment transactions
made by Shell Producing Development Corporation to their vendors and staff in various
banks in the country.
File outputs are a text file format for banking application
upload and an XML file format for InterSwitch Autopay application.
Enhancement on the
project was to review outputting a .csv file format to be processed through Overseas
InterBank System.
Environment: Visual Basic 6.0, ODBC, Crystal Report 8.5, Windows 2000
Professional, AIX Unix Server and Oracle 9i database. A prototype of the application was
built on MS Access before migrating to Oracle 9i as backend.
Ø Team player in generating customer transaction alert for the bank. I developed a
module to generate on daily basis a MS Excel extraction of statement for Coca Cola
Company from Finacle Enterprise banking application database.
The statement is send as
an attachment to the beneficiary via e-mail. It is implemented using Visual Basic 6.0,
ODBC, Oracle 9i and MS Server 2000 databases.
Ø Key member in the functional and technical design and development of the
Electronic Financial Auditing and Surveillance System (eFASS) reporting system from the
bank’s MIS database. The system is used to render regulatory returns in MS Excel format
to banking regulatory authority.
It was implemented using VB 6.0, ODBC and Oracle 9i
database.
This application is an interface that connects to the MIS database to spool
data and to generate an Excel of various report types.
It is a parameter driven system.
Ø Conducted analysis, design and implementation of a web-based Customer Intersol
Salary Processing System.
The system reads customer salary schedules in either a text
or a MS Excel input format, validates the account in the enterprise banking
application’s database and FTPs a text file output to be applied into banking
application.
This application was adjudged one of the best product in giving the bank
an edge over competitors in customers’ salary processing. It is implemented bank-wide.
It attracted efficiency, low turn around time and customers’ satisfaction with the high
volume salary payment from both private and public sectors.
The success of
implementing the application was achieved using ASP.NET (.NET Framework 1.0), ADO.NET,
CSS, Microsoft Excel 2000, HTML and Oracle 9i database. Interfaces Microsoft Access 2000
database to the Oracle database via ODBC for easy development data analysis and database
amendment.
Ø Responsible for analysis, design and implementation of a web-based Pension Fund
Administration System. The application captures pension administrator’s payment schedule
in MS Excel format as input, validates the payment instrument in the enterprise banking
application’s database and sends the schedule in a comma separated values, .csv, to the
pension fund management application’s server.
The feat was achieved using ASP.NET (.NET
Framework 1.0), ADO.NET, CSS, HTML, Microsoft Excel 2000, FTP and Oracle 9i database.
The system automatically FTPs the output file to the pension fund management application
server.
Ø Performed the analysis, design and implementation of Custom Duty Collection
System.
This application is to collect custom duties for the government, and was
implemented using Visual Basic 6.0, ODBC, Oracle 9i (backend) and Crystal Report 8.5 as
reporting tool.
The application provides for various enquiries on custom duty
collections and generates reports
Ø Conducted the design and implementation of upload utility to generate text file
format output for routine upload of various financial transactions into the enterprise
banking application.
It was implemented using VB 6.0, ODBC and Oracle 9i database.
This application is an interface that connects to the database to fetch data or take as
input an Excel file and to generate a text file for upload into enterprise banking
application.
Ø Team member in the development and implementation of Integrated Cheque
Management System.
This application was implemented using ASP.NET and VB.NET 2002,
ADO.NET, CSS, HTML, Oracle Triggers on Oracle 9i (backend) and Crystal Report for
reporting.
Responsible for the maintenance of the cheque printing desktop module and
participated in the project implementation.
The application provides for requisition of
check booklets by customers, movement of blank checks from central store to vault;
movement from vault to operators/ returns to vault, allocation to operators, printing of
check using MICR printing machines, dispatching with unique dispatch number to the
branches, receiving by the user at branches through the enterprise banking application
and thereby debiting/ crediting respective accounts.
It also registers bad checks,
generates production reports of operators etc. Interfaces Microsoft Access 2003 database
to the database via ODBC for easy development data analysis and database amendment
Ø Conducted technical training for user support staff and participated in user
acceptance tests on the projects
Ø Participated in the development of installation and processing guides for the
applications.
This involved collating the interface installation and database
installation processes, testing the processes, screen capture of the various menu
options and documenting and proofreading of draft copies.
Ø Team member support for S.W.I.F.T alliance system.
Performs patches update of
the alliance system, supports users and liaises with vendors for maintenance when
necessary
Environment:
Ø Visual Basic 6.0, Visual Basic/ASP.NET (2002 and 2005 version), JavaScript,
HTML, XML, TOAD, ODBC, Putty, Ghost Script, Crystal Report 8.5, Microsoft Office
2000/2003, SWIFT Alliance Access/Entry 5.5.
Ø IBM AIX, Windows 2000, Windows XP, Windows 2000 (server and advance server)
Ø MS SQL Server 2000 and 2005, MS Access and Oracle 8i, 9i database running on AIX
and Windows platform.
Industrial & General Insurance Co. Ltd. June 1998 -
April 2004
Programmer/Analyst
Ø Conducted analysis, design and implementation of Treasury Daily Fund Flow
application.
The system was implemented using MS Access 2000 as database and VBA. The
application tracks daily payments and receipts, maintaining bank positions and generates
management reports for periodic decision-making. It has modules for Receipt, Payment,
Return Check, Amendment (both current and previous), Fund-flow Trial and Final Run
processes, and Data backup. It is a multi-user application with security and roles
implementation. Develop simple and complex query types for select, update, delete, make-
table and cross-tab operations, macros, form designs and parameter driven reports.
Ø Assisted in the formulation and implementation of data recovery and protection
policies; systems backup using tape media and library maintenance, firewall, McAfee and
Norton anti-virus and Veritas software.
Ø Team player (functional and technical) in implementation of the company’s
transactional website.
This was developed using ASP, HTML, Macromedia Flash on MS SQL
Server 2000 database. Maintains the SQL database and generates ad-hoc queries.
Ø Performed analysis, coding and implementation of Client Monitoring System. This
application was implemented using Ms Access 2000 with VBA.
The system keeps the
company’s client database, maintains marketers’ target/production analysis.
It is
implemented for multi-users and facilitates modules for enquiries and reporting analysis.
Ø Participated in formulating company’s IT policies and strategies on WAN,
Internet and software outsourcing/evaluation.
Liaising with vendors for the
implementation and assigning responsibilities to the technical personnel
Ø Functional/technical Team Leader in development of effective GUI based
applications. Leading a team of 4 developers.
Ø Responsible for the development of an interface to migrate data from GENSYS
insurance package to Tetra 2000 Accounting System using VB 6.0 on Ms Access 97. Data
from GENSYS application is derived in a text file and imported into MS Access 97
database for queries and reporting.
Ø Team member in Tetra 2000 accounting package implementation.
Participated in
installation, maintenance, training and user support.
Ø Maintenance of Debit Note Credit Control package using FoxPro 6.0.
The
application generates debit note for customers, accepts credit and consolidates all
transaction.
Performed support and occasional amendments
Ø Performed network administration on Novel Netware 4.12 and Windows NT
Ø Carried out installation and maintenance of Windows 9X/ME/2000/XP OS on IBM PCs
and compatible
Ø Performed setup and maintenance of Internet facility to users both via LAN and
dial-up
Ø Performed installation, troubleshooting and maintenance of the computer hardware
(IBM PCs and compatible)
Environment:
Ø Visual Basic 6.0, MS Access 7/2000, ODBC, FoxPro 6.0, Crystal Report 7,
Microsoft Office 97/ 2000.
Ø Windows 9X, Windows 2000 professional, Windows NT (workstation and server),
Windows XP, Novel Netware 4.12, and MS DOS 6.0.
Ø MS SQL Server 2000, MS Access 97, 2000 running on Windows platform.
Lagos & Niger Shipping Agencies Ltd. May 1996 – May
1998
Developer
Ø Conducted review of debit note process and developed a functional package to
implement it. This system maintains debit note transactions, and generates the debit
note for the shipping customers. Implemented using Microsoft Access 97 for both front
and back ends. It implements forms, complex and parameter-driven queries, macros and
reports. The prototype of this system was implemented using Microsoft Excel automation
(VBA).
Ø Design and implemented Debit Note Automation using Microsoft Excel 97 using
Visual Basic for Application (VBA). The system creates analysis of Debit Note by taking
appropriate cell entries to compute the various commissions and charges and printing of
the debit note on a special Debit Note paper.
Ø Performed maintenance of in-house payroll system developed using Microsoft
Access 97.
The system implements Access Forms, Queries, Macros and Reports. Implemented
integration of Timelog system to the payroll application.
This involved exporting the
data into MS Access table and applying it to compute staff salary
Ø Conducted network planning and administration on Novel Netware 4.12, and
configuration of Windows 9X workstations, resource sharing and transfer of telex
messages to the ZIM server.
Troubleshooting and maintaining the line network topology.
Ø Provided technical support and training of users on computer appreciation and
software application.
Also prepared the training materials
Ø Performed computer workstations installation, troubleshooting, maintenance on
the network, and implementation of resources sharing
Ø Installation and maintenance of TimeLog system and integration into the
payroll.
Debis Computers Limited. May
1994 - Sept 1995
Programmer/Instructor and Internship
Ø Team member in analysis, design and implementation of staff payroll application
for the branch office of Debis Computers Limited using Dbase III+
Ø Computer instructor in computer appreciation, Mathematics, Lotus 123 spreadsheet
and WordPerfect application software
Ø Guest lecturer/representative for Debis Computers Limited computer related topics
EDUCATION AND TRAINING
Ø M. Sc. Computer Science
Ø B. Sc. Computer Science
Ø Microsoft Certified Systems Developer (MCSD)
Ø Finacle Treasury Application
Ø Java for Developers plus
Ø Project Development Methodology
Ø SWIFTAlliance Access Technical on Windows 2000 and Release Seminar,
SWIFTAlliance Access/Entry 5.5
Ø Team Building
Ø VB 6.0 and MS SQL Server 7.0
|