Consultant Resume
Marysville, OH
SUMMARY:
- 12+ years of overall experience in the IT industry as a Software Engineer.
- Very proficient with VB/VB.net/SQL Server/DB2/Oracle/MS Access
- Excellent analytical skills, very proficient in writing complex SQL scripts and shredding XML
- Have considerable production support experience up to 3000 users.
- Proficient in development of web - based and Client/Server applications using DNA, ASP.NET, AJAX, VB.NET, Remoting, Web Services, WCF, SSIS, Enterprise Services, ASP, Visual Basic, VBA, Java Script, VB Script, COM, COM+, HTML, DHTML, XML, IIS, MS Access, MS SQL Server and Oracle Database.
- Intensive project experience in the field of Retail, Manufacturing and Finance Industries.
- Involved in system study, design, development, testing and implementation of 3-tier architecture applications.
- Have extensive knowledge and experience in working with SQL Server, Oracle Database and also have played the role of SQL Server Database Administrator in various Projects.
TECHNICAL SKILLS:
Operating System: Windows 95,98,NT, 2000, XP, UNIX
Hardware: Pentium PCs, HP3000
Language: Visual Basic 3.0/4.0/5.0/6.0 , JAVA, Pascal, C++, FoxPro, VBA, C#,VB.net
Web Technologies: ASP.NET, ASP, ASP.net, JSP, IIS, MTS, Applets, HTML, DHTML, XML, XSL, AJAX
Tools: Office 2007, Visual Interdev, FrontPage, Visual Source Safe, MS Access - VBA, Excel - VBA, VS2003, VS2005,VS2008,VS2010, Install Shield 2011, 2010
RDBMS: MS SQL Server 7.0, 2000, 2005 & 2008, Oracle9i/11G, DB2
PROFESSIONAL EXPERIENCE:
Confidential, Marysville OH
Consultant
Responsibilities:
- Created multi-threaded assembly line applications using MVP design pattern
- Wrote views/stored procedures for SQL server 2005
- Architected assembly line applications to run with different interfaces for Cognex camera
- Validate VIN from OCR and PLC
- Wrote purge app to delete aged files
- Created secured FTP Sites
Environment: VB.net, VB6, SQL Server 2005/2008, Linq to XML, VS2005, VS2010
Confidential, OH
Consultant
Responsibilities:
- Created web site (C#) for testing AIX web services
- Added functionality to existing HotDocs web service (C#) for performance monitoring and logging
- Created DCR/EARS (VB.net) windows service for uploading files to a ftp site
- Created windows service (C#) for purging aged performance log files
- Created web site for online printing of barcode labels (ASP.net/Vb.net). It included creating & signing of COM visible dll (C#) and installation package for handling label printers
- Added functionality to existing winform applications (C#)
- Configuring IIS7/7.5 for WCF targeting framework 2.0/4.0 32/64 bit
- Template development using HotDocs tools
- Updated oracle packages encapsulating business logic
- Got the corporate technology recognition for performance
Environment: VB.net, C#, SQL Server 2005/2008, SSIS, Oracle 11G, Squirrel, Toad, ASP.net, AJAX, XML, VS2008, VS2010, TFS, JQuery, Install Shield 2011
Confidential, Russell’s Point, OH
Consultant
Responsibilities:
- Responsible for migrating VB6 app “Associate Reports” to VB.net
- Migrated existing AssociateProfile asp web site to Ajax enabled asp.net web site
- Service web site to set user authorization & authentication
- Created installation packages
- Pilot WPF project for Exclude Lots application
Environment: VB.net, SQL Server 2005, ASP.net AJAX, XML, Excel COM interops, TrueDBGrid, SSRS, SSIS, Install Shield
Confidential, Columbus, OH
Consultant
Responsibilities:
- Responsible for adding additional features to the GUI
- Gathering user requirements for update of business logic viz. Sales and promotions
- Incorporating the new business logic into COM+ components/ Oracle packages
- Creating test cases
- Deployment packages using install shield
- SSIS packages for excel reports using views
Environment: VB6, Oracle 9i, Toad, COM+, Activex dll/exe, VS2005, SQL Server 2005, Install shield
Confidential, Columbus, OH
Sr. Programmer
Responsibilities:
- Responsible for developing, enhancing, coordinating and maintaining the software.
- Implement HttpReq using MSXML and VB6.
- Implement complex pricing and costing strategies using VB6
- Implementing Insurance Claim using ACORD XML standards
- Creation of PDF and Word files using VB6.
- Design and Develop front end GUI using Winforms in VB.NET.
- Design and Develop business logic components in VB.NET
- CRUD operations on Oracle 10G DB for exception price maintenance. Front end VB.net
- Develop web services in C# under SSL
- Production support by shadowing users in Citrix
- B2B using web Services, SFTP
- Create VB 6.0 forms based on user/business requirements. Used extensively listview, sstab and farpoint controls viz. grid, datetimepicker etc.
- Responsible for creating screens using VB 6.0 for user approval
- Ensured that all buttons/tabs can be reached by shortcut keys.
- Update and reuse existing VB / COM objects
- Excel automation
- Created parameterized Crystal Reports for customer/ deductible invoicing
- SSIS/DTS packages, stored procs, views, functions, triggers
- SSIS experience includes using DataFlow objects for stored procs and views to export data to excel spread sheets
- Backup and restoring SQL Server databases
- Created forms, forms with sub forms, reports with sub reports in Ms Access
- Used triggers for history tracking
- Created database schema for different business requirements
- HTML/CSS/ASP.net/AJAX updating / maintaining VendorPartsList intranet site
- Fax Scrapper around XP fax components
Environment: VB 6.0, VB.NET, C#, Interop, Oracle 10G, TOAD, ASP, ASP.net, MS ACCESS, SQL Server 2005, COM, HTML, CSS, PHP, winforms, web services, Excel, SSIS, Crystal Reports XI, Crystal Reports 8.5, ACORD, xmlserializer, xmlwriter, xmlreader, xmlValidator, XPATH
Confidential, Scranton, PA
Sr. Programmer
Responsibilities:
- Responsible for developing, enhancing, coordinating and maintaining the software.
- Responsible for creating screens using VB 6.0 for user approval
- Update, reuse, create VB Confidential + objects
- Used MS Access to access SQL server table data
- Design and Developed business logic components in VB
Environment: VB 6.0, ASP, MS ACCESS, SQL Server 2000/2005
Confidential, Minneapolis, MN
Sr. Programmer
Responsibilities:
- Responsible for developing, enhancing, coordinating and maintaining the software.
- Design and Develop front end GUI using Winforms in VB.NET.
- Design and Develop of business logic components in VB.NET
- Update and reuse existing VB / COM objects
- ASP.net intranet site for downloading various documents
- Develop forms with various data-bound and advanced controls such as Data Grids, List boxes etc.
- Develop Classes in VB.NET to implement common functions.
- Develop Classes in C# to implement web services.
- ADO.NET has been used for data connectivity
- Responsible for writing Stored Procedures, Triggers and Views.
- Responsible for Review, Testing and Debugging.
- Responsible to interact with the users directly and understand their requirements.
- Responsible to deliver the product in time
- Performing version control using Visual Source Safe.
Environment: VB 6.0, VB.NET, C#, ASP, ASP.net, SQL Server 2000 windows 2000, Excel 2002, VSS
Confidential, Miramar, FL
Consultant/Project Manager
Responsibilities:
- Responsible for developing software architecture
- Design and Development of business logic components in VB
- Migrated VBA code from MS Access to VB
- Created Dynamic MS Access reports
- Enhanced/ added forms, macros, reports to the CIUMC MS Access db.
- Develop Classes in VB to implement common functions.
- ADO along with transactions has been used for data connectivity
- Responsible for writing Stored Procedures, Triggers and Views.
- Responsible for Review, Testing and Debugging.
- Responsible to interact with the users directly and understand their requirements.
- Responsible to deliver the product in time
Environment: VB 6.0, VBA, ADO, SQL Server 2000, Windows XP, MS Access 2000, VSS
Confidential, Columbus, OH
Programmer
Responsibilities:
- Responsible for adding additional features to the software
- Design and Development of business logic components in VB
- Develop Classes in VB to implement common functions.
- ADO along with transactions has been used for data connectivity
- Responsible for writing queries, macros, tables in the backend Access database.
- Responsible for Review, Testing and Debugging.
- Responsible to interact with the users directly and understand their requirements.
- Responsible to deliver the product in time
Environment: VB 6.0, ADO, ASP, SQL Server 2000, Windows 2000, Access 2000
Confidential, Columbus, OH
Programmer
Responsibilities:
- Responsible for migrating from FoxPro 2.6 to Access 2000
- Coded in MS Access using VBA
- ADO was used for data connectivity
- Responsible for writing queries, creating tables
- Responsible for Review, Testing and Debugging.
- Responsible to interact with the users directly and understand their requirements.
- Responsible to deliver the product in time
Environment: VBA, ADO, FoxPro 2.6/6.0, Windows 2000, Access 2000
Confidential, Marysville, OH
Programmer
Responsibilities:
- Added additional features like macros, reports and forms to MS Access based PQTS app.
- Created sub forms and sub reports in MS Access
- Migrated access based forms to VB
- Responsible for writing procedures in SQL Server 7/2000
- Responsible for Review, Testing and Debugging.
- Responsible to interact with the users directly and understand their requirements.
- Responsible to deliver the product in time
- Incorporated spell checking in VB app using Word Automation
Environment: VB 6.0, ADO, ASP, SQL Server 7.0/2000, Visual Sourcesafe, Word, Crystal Reports 6.0, MS Access 7.0
Confidential, Lancaster, OH
Programmer
Responsibilities:
- Added additional features such as distribution of reports by email.
- ADO was used for data connectivity
- Migrated database to SQL server for scalability
- Responsible for writing queries, reports, forms etc.
- Responsible for Review, Testing and Debugging.
- Responsible to interact with the users directly and understand their requirements.
Environment: VB 5.0, ASP, ADO, Access 2.0, SQL Server 6.5
Confidential, Worthington, OH
Programmer
Responsibilities:
- Added additional features such as distribution of reports by email.
- Responsible for writing queries, reports, forms etc.
- Developed forms with various data-bound and advanced controls such as Data Grids, List boxes etc.
- Running SQL script from UNIX environment
- Responsible for Review, Testing and Debugging.
Environment: VB 4.0, Oracle 7.0, FarPoint Grid, UNIX
Confidential, Columbus, OH
Consultant
Responsibilities:
- Responsible for gathering requirements from the clients
- Responsible for Review, Testing and Debugging.
- VBA code to screen scrape legacy code.
Environment: Infomaker 6.0, Oracle 7.0, SAS, ROSCOE
Confidential, Marysville, OH
Consultant
Responsibilities:
- Added additional features such as distribution of reports by email.
- Responsible for writing queries, reports, forms, Crystal Reports etc.
- Developed forms with various data-bound and advanced controls such as Data Grids, List boxes etc.
- Responsible for Review, Testing and Debugging