DICKSON ATUAHENE

P O BOX *****

MORENO VALLEY, CA 92552

951-***-**** e-mail: abgt5s@r.postjobfree.com

SOFTWARE ENGINEER / PRODUCTION SUPPORT ENGINEER

TECHNICAL SKILLS

Legacy Languages VB6 / VB5 / VB4 / VB3 / VBA / ADO / MTS

.Net Technologies VB.NET / C# / ADO.NET / LINQ / WCF / WPF / .NET 1.1 – 3.5

Databases MS Access / MS SQL Server 7 - 2008 / T-SQL / SQL CLR / SQL Query Analyzer /

SQL Server Management Studio (SSMS) / Oracle 7.3 – 10g / PLSQL / TOAD

Web Technologies ASP.NET / ASP / HTML / CSS / JavaScript / AJAX / XML / XSL / XSLT / XPATH

ASP.NET Web Services / WCF SOAP-Based and WCF REST-Based Web Services

Development Visual Studio 6 / 2003 / 2005 / 2008

Environment

Version control Tools Visual SourceSafe 6.0 / SCM / Clear-Case

Reports Crystal reports / MS Excel / SSRS

Data Migration/Loading Bulk Insert / BCP / DTS / SSIS / SQL*Loader / External Tables / ADO /

ADO.NET

PROFESSIONAL SUMMARY

* Gather requirements / work closely with clients to define the best possible solutions and t ranslate them into Business

solutions.

* P rovide Support / Modifications / Bug-Fixes / Enhancements to existing VB6 /.NET / Stored Procedures / Views

Applications.

* Lead projects and take responsibility for providing tasks and developing project plans / Participate in code and design

reviews.

* Experience with VB6 / MTS / COM+ / VB.NET / C # /.NET 1.1-3.5 / ADO / ADO.NET / LINQ / JavaScript /Jscript / AJAX /

XML / XPATH / Silver Light / Encapsulation / Polymorphism / Inheritance / Interface / WPF / XAML / WCF Web Services

* Develop AJAX UI using JavaScript to Send AJAX Request / Process AJAX Response / Error Handling and Form Validation

* Use N-Tier architecture for Presentation Layer / Business Tier (Business Logic Layer and Data Access Layers) / Database Tier

* Develop database reports using SSRS by creating Functions / Expressions / Parameters / Sub-Reports / Sorting and Grouping.

* Implement Multi-Threading to divide the code into smaller jobs and run each job on a separate CPU to speed up data access.

* Create WCF SOAP-Based / REST-Based Web Services (Hosting in IIS / Self Hosting/Windows Service and Channel Factory)

* Document program Design / Coding / Maintenance / Enhancement and Bug-Fixes to allow for future changes and code reuse.

* Convert Microsoft Access / VBA Application to SQL Server and .NET by converting MS Access Forms to Windows-Forms

* Create/Troubleshoot Stored Procedures /Views/Functions /Triggers/Indexes /SQL Scripts /Complex SQL /DML / DDL / Joins

* Experience with SQL Server performance tuning and t roubleshooting. Tune /Optimize Complex SQL queries for

performance

* Experience with MS Access / SQL Server 7.0 – 2008 / T-SQL / Query Analyzer / SSMS / Oracle 7.3 -10g / PL-SQL / TOAD

* Compress SQL Server Database / Implement Clustered / Non Clustered / Full-Text / Included Columns and Filtered Indexing.

* Delete duplicate records from MSSQL Tables with Primary Keys/Without Primary Keys using Self Join/CTE/

Row_Number * Experience with Oracle PL/SQL BULK COLLECT / Different Types of PL-SQL Cursors (IMPLICIT/EXPLICIT CURSORS)

* Create SSIS packages using SQL Server Management Studio (SSMS) and Business Intelligence Development Studio (BIDS)

* Design OLTP databases/Modify existing database structure /Perform SQL Server Backup and Restore/Database Normalization

* Automate Data Migration and Data Loading of Excel Spreadsheets / Text Files / CSV Files / MS Access with data Interfaces

Using DTS / SQL Server Integration Services (SSIS) / Bulk Insert / BCP / SQL*Loader / External Tables / ADO / ADO.NET

* Create Crystal Reports by creating Formulas / Parameters / Sub-Reports / Sorting / Grouping / Summary / Cross Tabs / Charts

* Create new / Maintain / Bug-Fixes and Enhance existing Excel Spreadsheets / Write Formulas within cells / Format data /

Sort / Filter / Charts / Pivot Tables / Macro Security on Excel / VLOOKUP / Remove Excel Duplicates and Recording Macros

* Write user and technical documentations and Update the existing system documentations to describe the new functionality.

EMPLOYMENT

VB6 / .NET / SQL SERVER DEVELOPER

FARMERS MUTUAL HAIL WEST DES MOINES, IA 03/10 – Present

TOOLS: VB6 / C# 3.5 / ADO / ADO.NET / MS Access 2007 / SQL SERVER 2008 / T-SQL / SSIS / MS Excel

• Develop Insurance Application using VB6 / C# 3.5 / ADO / ADO.NET / Access 2007 / SQL Server 2008 / T-SQL / SSIS

• Provide Support / Modifications and Enhancements to existing VB6 and MS Access Application. Comment out all code.

• Compact / Repair and Backup MS Access 97 database using DAO / VB6. Link MS Access to MS-SQL 2008 database.

• Use N-Tier architecture for Presentation Layer / Business Tier (Business Logic Layer/ Data Access Layers) / Database Tier

• Create Windows-Forms using Text-Boxes / Command Buttons / Radio Buttons / Check Boxes / Labels / Input Boxes /

Combo Boxes / List Boxes / List View / MS-Flex Grid / Date Picker / Frame / Common Dialog Control and Tab Control

• Develop SSIS (ETL) using SQL Server Management Studio (SSMS) / Business Intelligence Development Studio (BIDS)

• Automate Data Migration and Data Loading of Excel Spreadsheets / Text Files / Comma Delimited Files (CSV) with data

Interfaces using Bulk Copy Command (BCP) / SQL Server Integration Services (SSIS) / Bulk Insert / ADO (using VB6)

• Create / Troubleshoot Stored Procedures / Views/Functions / Indexes / SQL Scripts / Complex SQL queries / DML / DDL

• Compress SQL Server Database. Implement Clustered / Non Clustered / Full-Text / Included Columns / Filtered Indexing.

• Delete duplicate records from SQL Server tables with and without Primary Keys using Self Join / CTE / Row Number • Troubleshoot/Optimize MS-SQL database/SQL queries / VB6 code for performance / Create Ad-Hoc request using TSQL.

• Troubleshoot / correct unexpected failures in production programs in a timely manner. Participate in code /design reviews

• Mentor developers in TSQL / Software Development/Design. Implement version control system using Visual Source Safe.

• Document program Design / Coding / Maintenance / Enhancement / Bug-Fixes to allow for future changes and code reuse.

• Create Crystal Reports by creating Formulas /Parameters /Sub-Reports /Sorting / Grouping /Summary /Cross Tabs/ Charts.

• Support and enhance existing Crystal Reports / Document complex custom reports. Review and test Crystal Reports code.

• Create new/maintain existing Excel Spreadsheets /Write Formulas within cells / Filter /Format data / Graphs/ Pivot Tables.

• Write test case scenarios. Perform unit / full-life cycle testing. Support QA through testing and validation of applications.

PROJECT LEAD

THE COFFEE BEAN & TEA LEAF LOS ANGELES, CA 11/08 – 02/10

TOOLS: VB6 / VB.NET / MS Access 2007 / SQL Server 2008 / SSIS / WCF Web Services / VBA MS Excel 2007

• Develop Payroll / HR Applications using VB6 / VB.NET 3.5 / MS Access 2007 / SQL Server 2008 / WCF Web Services

• Create new / Maintain / Bug-Fixes and Enhance existing Excel Spreadsheets / Write Formulas within cells / Format data /

Sort / Filter / Charts / Pivot Tables / Macro Security on Excel / Recording Macros / Remove Excel Duplicates / Ranges

• Lead projects/take responsibility for providing tasks and developing project plans / Participate in code and design reviews.

• Design and Implement MS Access 2007 database / Normalize the database / Link MS Access to MS-SQL 2008 database.

• Compact / Repair / Backup Access database using DAO and VB6. Enhance/Optimize VB6 Application for performance

• Provide Support / Modifications / Bug-Fixes / Enhancements to existing VB6 /.NET Applications. Comment out all code

• Convert VB6 to VB.NET / Windows Forms to Win Forms / ADO to ADO.NET / VB6 Inline SQL to Stored Procedures.

• Develop Multi-Threading to divide the code into smaller jobs and run each job on a separate CPU to speed up data access.

• Use N-Tier architecture for Presentation Layer / Business Tier (Business Logic Layer/ Data Access Layers) / Database Tier

• Automate Data Migration and Data Loading of Excel Spreadsheets / Text Files / Comma Delimited Files (CSV) with data

Interfaces using Bulk Copy Utility (BCP) / SQL Server Integration Services (SSIS) / Bulk Insert /ADO.NET (using .NET)

• Create SSIS packages using SQL Server Management Studio (SSMS) / Business Intelligence Development Studio (BIDS)

• Create Stored Procedures / CLR Stored Procedures / Views / Indexes / SQL Scripts / Complex SQL queries / DDL / DML

• Troubleshoot/Tune and Optimize SQL queries/SQL Server database for performance / Create Ad-Hoc request using TSQL

• Compress SQL Server Database. Implement Clustered / Non Clustered / Full-Text / Included Columns / Filtered Indexing.

• Delete duplicate records from SQL Server tables with and without Primary Keys using Self Join / CTE / Row Number • Document program Design / Coding / Maintenance / Enhancement / Bug-Fixes to allow for future changes and code reuse.

• Summarize SQL Server Data with ROLLUP to generate a result set showing aggregates using T-SQL to generate Reports

• Troubleshoot/correct unexpected failures in production programs in a timely manner. Write user/technical documentations

• Write test case scenarios. Perform unit / full-life cycle testing. Support QA through testing and validation of applications.

.NET DEVELOPER

DELTA DENTAL SAN FRANCISCO, CA 06/07 – 10/08

TOOLS: VB6 / C# / ADO.NET / ASP.NET / JavaScript / XML / XPATH / SQL Server 2005 / Oracle 10g / MS Excel 2003

• Provide Support / Modifications / Bug-Fixes / Enhancements to existing Billing Application using VB6 / C# 3.0 / ADO /

ADO.NET / ASP.NET / JavaScript / XML / XPATH / Web Services / AJAX / SQL Server 2005 / T-SQL / Oracle 10g

• Gather requirements / work closely with users to define the best possible solutions / translate them into Business solutions.

• Troubleshoot and correct unexpected failures in production programs in a timely manner. Comment out all code created.

• Identify/Prevent Memory Leaks in code - Leaking Stack Memory/ Leaking Unmanaged Heap and Managed Heap Memory

• Modify existing MSSQL database structure - Add Columns / Change Data Type / Perform MS-SQL Backup and Restore

• Create SSIS packages using SQL Server Management Studio (SSMS) / Business Intelligence Development Studio (BIDS)

• Use N-tier architecture for Presentation Layer / Business Tier (Business Logic Layer and Data Access Layers) / Data Tier

• Create Ad-Hoc Requests using T-SQL / PL-SQL and convert the data to Excel files and validate the accuracy of the data

• Develop Multi-Threading to divide the code into smaller jobs and run each job on a separate CPU to speed up data access.

• Create Stored Procedures / Sequences / Packages / Views / Indexes / SQL Scripts / Complex SQL queries / DML / DDL

• Troubleshoot /Tune and Optimize SQL Server and SQL queries for performance. Develop Relational (OLTP) Data Model.

• Create PL/SQL Collections / Select data from Oracle tables using Bulk Collect /Use FORALL to Insert/Update and Delete

• Partition Oracle Tables for optimization / Use Cursors to return result set from Oracle Packages and Stored Procedures

• Optimize PL/SQL Packages / Stored Procedures using EXPLAIN PLAN / Bulk Collect / FORALL / Bind Variables/ Hints

• Automate Data Migration and Data Loading of Excel Spreadsheets / Text Files / Comma Delimited Files (CSV) with data

Interfaces using Bulk Copy Command (BCP) / SSIS / DTS / BULK INSERT/ External Tables / SQL*Loader / ADO.NET

• Document program Design / Coding / Maintenance / Enhancement / Bug-Fixes to allow for future changes and code reuse.

• Develop Health Care Reports using Crystal Reports 9.0 - create Formulas / Parameters / Sub-Reports / Sections / Sorting.

• Create / Enhance Excel Spreadsheets / Charts / Write Formulas within cells / Filter / Sort / Format data using Excel 2003

• Mentor junior programmers in T-SQL / PL-SQL / Software Development. Implement version control system using VSS

• Write test case scenarios. Perform unit / full-life cycle testing. Support QA through testing and validation of applications.

PROJECT LEAD / VB6 / .NET DEVELOPER

IMS CALABASAS, CA 03/05 – 05/07

TOOLS: VB6 / VB.NET / C# / VBA Access 2003 / Oracle 9i / XML / XPATH / ASP.NET / Web Services / MS Excel

• Develop Credit Card Processing Application using VB6 / VB.NET / C# / .NET 2.0 / Oracle 9i / PL-SQL / XML / XPATH

• Lead projects/take responsibility for providing tasks and developing project plans / Participate in code and design reviews.

• Provide Support / Modifications /Bug-fixes/Enhancements to existing VB6 /.NET / ASP.NET /Web Services Applications

• Gather requirements / work closely with users to define the best possible solutions / translate them into Business solutions.

• Create / Modify and Enhance Windows-Forms using Labels / Text-Boxes / Command Buttons / Radio Buttons / Check

Boxes / Input Boxes / Combo Boxes / List Boxes / List View / Flex Grid / Frame / Common Dialog Control / Tab Control

• Use N-tier architecture for Presentation Layer / Business Tier (Business Logic Layer and Data Access Layers) / Data Tier

• Develop AJAX UI using JavaScript to Send AJAX Request / Process AJAX Response / Error Handling / Form Validation

• Optimize VB6 Code / Convert VB6 to VB.NET / Convert ADO to ADO.NET / Convert Inline SQL to Stored Procedures

• Convert MS Access database to Oracle 9i – Design / Develop new database for the application and Normalize Database

• Automate Data Migration/Loading of Excel Files/Text Files / CSV Files using External Tables / SQL*Loader / ADO.NET

• Create Win-Forms (Graphical User Interface) using Windows Common Controls/ Containers / Data Controls/ Components

• Develop Oracle Packages / Stored Procedures / Views / Indexes / SQL Scripts /Complex SQL queries / Joins / DML /DDL

• Troubleshoot and Optimize SQL queries for performance / Create Ad-Hoc request using PLSQL and convert data to Excel

• Partition Oracle Tables for optimization / Use Cursors to return result set from Oracle Packages and Stored Procedures

• Optimize PL/SQL Packages / Stored Procedures using EXPLAIN PLAN / Bulk Collect / FORALL / Bind Variables/ Hints

• Develop Financial Reports using Crystal Reports 9.0 by creating Formulas / Parameters / Sections/Sub-Reports/ Grouping

• Support and enhance existing Crystal Reports / Document complex custom reports. Review and test Crystal Reports code.

• Create new and maintain existing Excel Spreadsheets / Charts / Write Formulas within cells / Filter / Sort and Format data

• Write test case scenarios. Perform unit / full-life cycle testing. Support QA through testing and validation of applications.

• Troubleshoot and correct unexpected failures in production programs in a timely manner. Write technical documentation.

PROJECT LEAD / VB6 DEVELOPER

IDS HEMET, CA 05/01 – 02/05

TOOLS: VB6 / MTS / ADO / MS Access 97 / SQL Server 2000 / T-SQL / DTS / ASP / VBA MS Excel 97

• Develop Insurance Certificate Application using VB6 / ASP / VBScript /Crystal Reports / VBA / MS-SQL 2000 / T-SQL

• Design / Develop MS Access database / Normalize the database / Compact and Backup MS Access database using DAO

• Lead projects/take responsibility for providing tasks and developing project plans / Participate in code and design reviews.

• Create Windows-Forms using Labels / Text-Boxes / Command Buttons / Radio Buttons / Check Boxes / Input Boxes /

Combo Boxes / List Boxes / List View / MS-Flex Grid / Date Picker / Frame / Common Dialog Control and Tab Control

• Provide Support / Modifications / Enhancements to existing VB6 Production Application. Comment out all code created.

• Use N-tier architecture for Presentation Layer / Business Tier (Business Logic Layer and Data Access Layers) / Data Tier

• Develop new (OLTP) Database. Write FTP Application to upload and download flat files to and from clients FTP Server.

• Develop/maintain existing Stored Procedures/Views/ Functions / Triggers / Indexes / SQL Scripts / Complex SQL queries.

• Troubleshoot/Optimize MS-SQL database/SQL queries / VB6 code for performance / Create Ad-Hoc request using TSQL.

• Research/evaluate the system for effectiveness / restructure the code for efficiency. Delete duplicate records from database

• Automate Data Migration and Data Loading of Excel Spreadsheets / Text Files / Comma Delimited Files (CSV) with data

Interfaces using BULK INSERT / Bulk Copy Command (BCP) / Data Transformation Services (DTS) /ADO (using VB6)

• Convert MS Access/VBA Application to SQL Server and VB6 by converting MS Access Forms to VB6 Windows-Forms

• Convert MS Access database to SQL Server – Design / Develop new database for the application and Normalize Database

• Convert Microsoft Access 97 VBA Queries to SQL Server Stored Procedures / Views and Functions using Transact-SQL

• Develop Insurance Reports using Crystal Reports 8.5 - Create Formulas / Parameters / Sub-Reports / Sections / Grouping.

• Develop Summary /Cross Tabs /Section Suppression /Mail Labels/Expressions /Field Mapping / Formatting /Pivot Tables.

• Create new / Maintain / Bug-Fixes and Enhance existing Excel Spreadsheets / Write Formulas within cells / Format data /

Sort / Filter / Charts with Multiple Types / Recording Macros / Remove Excel Duplicates/Ranges using VBA MS Excel 97

• Document program Design / Coding / Maintenance / Enhancement / Bug-Fixes to allow for future changes and code reuse.

• Write user and technical documentations and Update the existing system documentations to describe the new functionality

• Write test case scenarios. Perform unit /full-life cycle testing to discover mistakes and verify programs meet specifications.

• Support Users / QA Department through testing and validation of applications. Move SQL Scripts to Testing environment

SR VISUAL BASIC DEVELOPER

UNION BANK OF CALIFORNIA MONTEREY PARK, CA 11/99 – 04/01

TOOLS: VB6 / ADO / MTS / MS Access 97 / Crystal Reports

• Develop / Maintain Mortgage Loan / Payroll System Applications using VB6 / MTS / ADO / Access 97 / Crystal Reports

• Gather requirements / work closely with users to define the best possible solutions / translate them into Business solutions.

• Provide Support / Modifications / Bug-fixes / Enhancements to existing VB6 Application. Comment out all code created.

• Create VB6 Windows-Forms using Labels / Text-Boxes / Command Buttons / Radio Buttons / Check Boxes/Input Boxes /

Combo Boxes / List Boxes / List View / MS-Flex Grid / Date Picker / Frame / Common Dialog Control and Tab Control

• Develop software in a Client/Server environment/ Develop Relational Data Model / Optimize VB6 codes for performance.

• Design and implement MS Access 97 Database. Compact / Repair and Backup MS Access 97 database using DAO / VB6.

• Evaluate/redesign existing program logic to improve system performance / Delete duplicate records from Access database.

• Create Ad-Hoc queries using JET-SQL and convert the result set into Excel Spreadsheet / Load Excel data into MS Access

• Write automation FTP Application to upload and download files to and from clients FTP Server into MS Access database

• Compute Monthly Loan Payment and Amortization/Wages and Salaries/Social Security taxes/SDI/Federal and State taxes.

• Create Payroll Register / Reconciliation / General Ledger / Garnishment and Mortgage Loan reports using Crystal Reports.

• Support and enhance existing Crystal Reports / Document complex custom reports. Review and test Crystal Reports code.

• Develop / modify /enhance existing Excel Spreadsheets / Write Formulas within cells / Filter / Format data / Sort / Charts.

• Troubleshoot and correct unexpected failures in production programs in a timely manner/Perform design and code reviews

• Document program Design / Coding / Maintenance / Enhancement / Bug-Fixes to allow for future changes and code reuse.

• Mentor developers in SQL / Software Development/Design. Implement version control system using Visual Source Safe.

• Write user and technical documentations and Update the existing system documentations to describe the new functionality

• Write test case scenarios. Perform unit / full-life cycle testing. Support QA through testing and validation of applications.

PROGRAMMER ANALYST

FRAME-N-LENS FULLERTON, CA 07/94 – 10/99

TOOLS: VB3-6 / DAO / ADO / MTS / Oracle 7.3-8/ PLSQL / MS Access / MS Excel / Crystal Reports / PeopleSoft

• Develop Manufacturing Application using VB 3-6 / DAO / ADO / MTS / Oracle 7.3/8 / PL-SQL / MS Access / SDLC

• Develop / maintain PeopleSoft PEOPLETOOLS / PEOPLECODE / PS-QUERY. Create Crystal Reports / Ad-Hoc Query.

• Develop MS Access database / Normalize the database / Create queries using JET-SQL / Create Reports and Access Form

• Use N-tier architecture for Presentation Layer / Business Tier (Business Logic Layer and Data Access Layers) / Data Tier

• Convert Excel Spreadsheets / Text Files / Comma Delimited Files (CSV) to Oracle database using SQL*Loader and ADO

• Support and enhance existing Crystal Reports / Document complex custom reports. Review and test Crystal Reports code.

• Document program Design / Coding / Maintenance / Enhancement / Bug-Fixes to allow for future changes and code reuse.

• Evaluate/redesign existing program logic to improve system performance . Develop user- interfaces using Windows Forms.

• Provide Support / Enhancements and Maintenance for existing applications. Optimize Visual Basic code for performance.

• Convert VB3 to VB4 / VB4 to VB6 / DAO to ADO. Create Excel Spreadsheets. Read data to / from Excel Spreadsheets.

• Gather requirements and translate it into Business solutions / Create Stored Procedures and Views /Optimize SQL queries.

• Troubleshoot and correct unexpected failures in production programs in a timely manner. Comment out all code created.

• Implement version control system for the application using VSS / Compact and Backup MS Access database using DAO.

• Develop test plans and perform QA activities. Perform Black Box and White Box Testing Manually on Unit / Regression /

Integration / Performance Testing to discover mistakes and verify programs meet specifications and record testing results.

EDUCATION

MA.,COMPUTER SCIENCE Ball State University, Muncie, IN

BA.,MATHEMATICS Westfield State College, Westfield, MA

Training in PEOPLESOFT and ORACLE

Courses taken at University of California, Riverside: JAVA, ASP, XML and PERL.

Contact this candidate