Eight to ten years experience in Design, Analysis and Development of Software applications using Visual Basic, C++, SQL Server, MySQL along with creating reports using Crystal Reports and Business Objects.
Strong Expertise in production support, using views and stored procedures to access data, client interaction, and creating and interpreting business requirements.
Strong Understanding of the SDLC process, especially in the area of development and testing.
Strong Background in Bank/Financial, Automotive, and Healthcare
Strong Expertise in writing complicated PL/SQL and T-SQL scripts for data mining, testing procedures and triggers.
Strong Understanding of SQL Server and Oracle 9i development and uses.
Skills:
Languages:
• Asp.Net
• Java
• MS Access/Vba
• Ms Visual Source Safe
• Pl/sql
• Pvcs
• Sql*plus
• Toad
• T-sql
• Visual Basic 5/6
• Visual Basic.NET
• Visual C++ 2003
Database Systems:
• Db2
• Ms Access
• Oracle 9i
• Rdbms
• Sql Server 2000/2005
• FoxPro
Reporting Tools:
• Business Objects
• Crystal Reports 5/7/8.5/11
Operating Systems:
• Novell Administer
• Windows 2000 Server/Professional
• Windows 2003 Server
• Windows 9x
• Windows NT 4 Server
• Windows XP Home /Professional
• UNIX
Email Systems:
• Exchange Server
• GroupWise
• Lotus Notes
• MS Outlook
Additional Applications:
• MS DOS
• MS Excel
• MS PowerPoint
• MS Word
• PC Anywhere
• Unica Affinium Campaign
• Unica Affinium Plan
• Veritas Backup Exec
• VPN
Known languages (and levels):
English-Very Good
Type of Employment wanted:
Contract
Full Time
Part Time
Temporary
Minimum Yearly Salary in Numbers:
25000 USD
Current Location:
USA, MI Michigan, Waterford
Education & Experience
Education History, Qualifications & other additional information:
Level of Education:
College
Certified in Windows Registry and Microsoft Outlook 98
Associates Degree in Computer Science
Work History & Experience:
Years of Work Experience:
10 to 15 Years
IEntertainment (Gaming Company) Cary, North Carolina
Application Developer October 2007 to Present
Responsibilities:
• Using VC++ 2003 to create and implement client program enhancements
• Adding new graphics to client and new object classes to enhance performance
• Adding MD5 security encryptions to safeguard the client from being “hacked”
• Updated client to Winsock 2.0 for better performance to connect to their current server
• Perform analysis, design, programming and debugging functions related to assigned project.
• Perform multiple testing methods to ensure stability of client
• Added new user friendly features to better serve the users
Environment: C++.NET 2003, C++.NET 2005, C++ 6, Winsock 2.0, SQL Server 2000
Systems USA Novi, MI
Application Developer August 2008 to October 2008
Responsibilities:
• Used Visual Studio .NET 2003/2005 to create and enhance ASP applications and websites
• Created and supported databases (MS Access, SQL Server 2005)
• Used Visual Basic 6 to create and enhance Insurance windows applications
• Perform analysis, design, programming and debugging functions related to assigned project.
• Perform multiple testing methods to ensure stability of client
• Created and enhanced Crystal Reports and Business Object Reports
Environment: ASP.NET 2003, ASP.NET 2005, VB.NET 2003, VB.NET 2005, Visual Basic 6, MS Access 2000, SQL Server 2005, Crystal Reports 9, Business Objects 11
ETech Design Studios Grosse Pointe, Michigan
Application Developer\DBA April 2007 to Janurary 2008
Responsibilities:
• Create applications using VB.NET 2005 to Import Data to MySQL Databases
• Use Dreamweaver to create Web Pages/Web Sites for clients
• Migrated Databases from multiple database types to multiple database types
• Use Dreamweaver to update and/or make enhancements to current Web Sites
• Perform analysis, design, programming and debugging functions related to assigned projects.
Environment: VB.NET 2003, Text Files/Flat Files, SQL Server 2000/2005, MySQL
Comerica Bank Auburn Hills, Michigan
Application Developer October 2006 - April 2007
Responsibilities:
• Worked with a team of 4 developers on a front end Visual Basic application.
• Performed analysis, design, programming, and debugging functions related to assigned tasks.
• Handled production support and new development/enhancements to existing applications.
• Created reports using Crystal Reports 7.0, using views and stored procedures to access data.
• Used PL/SQL to troubleshoot, debug, and run SQL statements.
• Took lead of primary support for high volume customer list (Comerica customers for Michigan, Florida, California, and Arizona).
• Demonstrated ability to manage time and priorities according to team/project objectives.
• Performed software package installations which spanned multiple areas and/or operating systems.
• Used PVCS for version control.
• Provided recommendations to Information Systems Management for new and/or improved procedures, technologies, or delivery methodologies.
• Participated in interviewing, hiring, and training of employees; Planning, assigning, and directing work.
• Connected to DB2 through Visual Basic using ADO connections in order to pull customer information.
Environment: Visual Basic 5.0, DB2, Oracle Rdbms, Pl\sql, T-sql, Crystal Reports 7, Business Objects, PVCS.
Valassis Livonia, Michigan
Application Developer May 2006 - October 2006
Responsibilities:
• Worked with a team of 3 developers on a front end Visual Basic 6.0 application.
• Received specifications from the sales analysis team, implemented, and tested upgrades through the QA and testing team.
• Created tables, views, stored procedures, user functions on SQL Server 2000/2005 and Oracle 9i Databases.
• Created reports using Crystal Reports 7.0, using views and stored procedures to access data.
• Used PL/SQL to Select, Update, Insert, and Delete statements as well as updated views and triggers.
• Used PL/SQL to troubleshoot, debug, and run SQL statements.
Environment: Visual Basic 6.0, Visual Basic.NET 2003, SQL Server 2000/2005, Oracle RDBMS, Crystal Reports 7, PL/SQL.
General Motors Detroit, Michigan
Decision Support Analyst August 2005 - April 2006
Responsibilities:
• Worked with a team of 9 other analysts in the CRM department of GM.
• Received specifications, from the operations manager, for who the promotion audience was and generated the customer data from our Oracle database.
• Used PL/SQL to troubleshoot, debug, and run SQL statements.
• Used TOAD for quick counts and verification of customer data output tables.
• Used Unica Affinium Campaign to build flowcharts for Campaign promotions.
• Used Unica Affinium Plan to setup program and promotions for campaigns.
Environment: Oracle 9i, UNIX, Windows 2003 Server, TOAD, Unica Affinium Campaign, Unica Affinium Plan, PL/SQL.
FDI Group/StarTech Software Novi, Michigan
Senior Application Developer July 2001 - August 2005
Responsibilities:
• Worked with a team of 5 developers on a Client/Server Healthcare program used by Universities and Hospitals that handled Bill Review and Work Comp Claims.
• The program had a Visual Basic 6.0 front end and a SQL Server 2000 Backend database.
• Created many stored procedures and approximately 200+ Reports written in Crystal Reports 8.5.
• Used T-SQL to Select, Update, Insert, and Delete statements as well as updated views, stored procedures, and triggers; troubleshoot, debug, and run SQL statements.
• Programmed the front end and developed the database architecture.
• Performed several database conversions from FoxPro, Access, etc to SQL Server 2000.
• Provided recommendations to Information Systems Management for new and/or improved procedures, technologies or delivery methodologies.
• Participated in interviewing, hiring, and training of employees; Planning, assigning, and directing work.
Environment: Visual Basic 6, SQL Server 2000, and Crystal Reports 8.5, T-SQL, SQL, FoxPro, MS Access
Jaffe, Raitt, Heuer & Weiss Detroit, Michigan
Hardware/Software Specialist June 1999 - June 2001
Responsibilities:
• Rotated backup tapes and created/verified backup operations using Backup Exec software for each server.
• Installed and upgraded PC, Laptop, and Server hardware and software.
• Troubleshot network, software, and hardware concerns.
• Maintained SQL and Access databases.
• Ran nightly billing reports for the bookkeeping department.
• Created client/server applications using Visual Basic 5.0 and 6.0.
• Created databases/tables using MS Access 97.
• Performed user technical support for over 200 users.
• Covered emergency department beeper one week every month.
Environment: Veritas Backup Exec, SQL, SQL Server, MS Access, Visual Basic 5.0/6.0
Ford Motor Company Dearborn, Michigan
Help Desk Support Analyst November 1997 - April 1999
Responsibilities:
• Troubleshot Satellite and PC communication and software concerns for Ford Dealerships over the telephone.
• Troubleshot DLU (Distance Learning Unit) communication and Hardware concerns as well.
• User support and communication.
• Detailed documentation and many unique software installations and usages, etc.
Local State & City Job Search for Alabama, Arizona-Maricopa County, Arkansas, California- Los Angeles/Orange County, Colorado, Connecticut, Florida-Miami-Dade, Georgia, Illinois, Cook County, Iowa, Kentucky, Maryland, Michigan, Minnesota, Missouri, New Jersey, New York, North Carolina, Ohio, Oregon, Pennsylvania, South Carolina, Texas- Harris/Dallas County, Virginia, King-Washington..
