Clarence Tunstall's Resume
to

Web development and upgrade of Intranet applications using C#, Visual Basic, MVC 5, HTML5, Bootstrap, and Entity Framework. UML design and documentation. Agile development process. Install, configure, and write API methods for OnTime project management system. Develop MS Excel 2013 Add-ins.


MS Visual Studio 2013, C#, .NET 4.5, Subversion, MVC 5, Entity Framework 6.0, JQuery, Bootstrap 3.0, JSON, HTML5, MS SQL, JavaScript, Axosoft OnTime

to

Maintenance development of large scale application for highly visible product for a well-known client in support of conversion or product from client server to cloud. WCF web service development. Entity Framework development. Unity dependency injection. Xml & JQuery development.


MS Visual Studio 2010, C#.NET 4.0, TFS, JQuery, Javascript, MS Enterprise Library

to

Lead the development of several in house applications and system upgrades. Develop Corporate portal C#,.NET 4.0, and Business Objects API. Develop several applications for in house use to eliminate manual processes using VBA, Excel, and Visual Studio 2010. Analyze system for best practices and approach for development, advancement of system features, including maintenance . Design and develop formal system documentation, coding standards and best practices. Maintain and upgrade company’s external website. Team lead for the setup, installation, and migration of a new reporting system from Crystal Reports 2008 to Edge Enterprise 4.0. Installed the server application and client tools. Develop the Universe and data connections. Converted Crystal Reports 2008 to Crystal Reports Enterprise 4.0. Spearheaded the upgrade efforts of new the development environment from .net 2.0 and Visual Source Safe to Visual Studio 2010 and TFS. Interview and made recommendations of hire for new staff. Oversee work done by team members of varying degree of expertise, implemented brown bag sessions and write the technical article for company newsletter.


MS Visual Studio 2010 C#.NET 4.0, TFS, SAP Edge Business Objects IX 4.0, JavaScript, HTML, CSS, MS SQL 2008 R2, SQL development

to

Used Waterfall development process to analyze, design, and develop or upgrade features for an a C++ embedded application for a new medical device. Upgrade features: Petri dish streaking and system file housekeeking and exception detection and alarm. Utilized heavy threaded process based upon the Petri net architecture to manipulate instrument motors and robotics. Upgraded the features of the simulation model to match the features developed for the product.


MS Visual Studio 2008 C#.NET 3.5, Windows Embedded C++, Petri Net, PVCS, Waterfall

to

Gather requirements: 1. Meet with user groups to gather tasks. 2. Coordinate and detailed department functions. 3. Compiled the requirements into services and designed service based UML diagrams. 4. Coordinated with the .NET architect to design application structure. Meet with development team to design flowcharts, promote project understanding, assign team members to projects, and designate a lead. Determine timelines based upon user need, coding methods, and resource ability. Coordinate with Architect to create database design. Monitor project progress to establish milestones, maintain coding standards, coding best practices, and development route to complete project within the timeline using MS Project. Administer Team Foundation Server (TFS) to manage projects. Created testing documentation in Excel. Generated a list of testing requirements based upon noted risks, known development issues, function points, and bug list. Assigned resources for testing team, deployed solution onto testing servers complete with a version of the application, necessary services and the database. Developed SQL scripts for database setup and upgrade of tables, initialization data, and Stored Procedures. Design windows, web, and WCF Services to act as communication lines between separate databases on separate servers to maintain data purity. These services act as the base of an SOA architecture, featuring one service as the main hub, (called Central Nervous System), which manages the data between services per perspective databases. The individual database services would be the manager of data going in and out, although the application tied to that database did not require use of the service. Coordinate with the architect to design a task notification system using windows messaging, WCF and Windows Services. Coordinate with architect to design rules based artificial intelligence system housed in a database design which would use those rules to present results via stored procedures based upon data entered. This set of results determines workflow and basic requirements to automatically set the rate for insurance applications, determine policy forms for policies for client review, and generate premiums to be reviewed via intranet web application, effectively performing basic underwriting of insurance applications. Design admin system for underwriter and executive staff to review rules for update, removal, or augmentation. Develop C# code in various circumstances and proof of concepts. Code objects based windows forms and asp.net applications using C# and ADO.NET for backend development on .net 3.5. Develop many SQL scripts, stored procedures, and functions. Extend Outlook and TFS by designing and creating add-in to integrate with other office products or MS SQL Database. Coordinate with architect to interview and hire staff. Managed Agile development as scrum master. Modeled applications using UML and database modeling using Visio. Utilize client involvement in the development process, having a version of the application for client review highlighting requirements on a given test, QA, or development server released generally atdevelopment milestones. Prioritize new requirements into categories for current and future versions to meet application and timeline expectations. Designed and developed C# code for services, utilizing XML for portability and configuration. Deployed applications through installation and script processing.


MS Visual Studio 2008 C#.NET 3.5, Visual Studio Team System 2008, MS SQL 2005, Javascript, Project Management Server 2007, MS Office 2010, MS Visio

to

All positions marked with an asterisk were assignments while on staff with Sogeti thus all of the position accomplishments marked are under this title


C#, MS SQL, TFS, ASP.NET

to

Develop Windows and Web .NET projects with MS SQL back-ends that capture, manipulate and process data for workflow process using C# and the development of Web services Managed, maintained, stabilized and repaired current .NET applications using Visual Studio 2005 and MS SQL 2005 Optimized performance indicators for all databases related to the projects with which I am involved, their index usage, and data manipulation through stored procedures and programming Assigned as the Lead Programmer for all development Created documentation supporting database and windows and web applications. Maintenance development of unit tests and C# code as it pertains to persistence of the application code. Serve on interview team for new staff members. Train and setup new staff members. Assist with the creation of development policy, procedures and methodologies Analyze current processes and develop system architecture and recommend SOA architecture considerations to the Chief architect for development of future projects Developed stored procedures, installation scripts for the creation of new classes and insertion of data for new and existing databases. Agile development methodologies. Gather requirements, interview customers and generate application design


MS Visual Studio 2008 (C#), Team Foundation Server, MS SQL / T-SQL, SMSS 2005, CSS, XHTML, SOAP, XML, IIS

to

Develop, maintained, and upgraded multiple Windows and Web C#, asp.NET applications supporting various business workflow processes of a health care maintenance service company from accouting to health care support. Developed complex algorithms using MS Access, VBA, SQL and integrating with an MS SQL database for calculating commission based payments, advancements, commissions calculationsUpgraded payroll application converting multiple MS Access applications to MS Windows C#.NET applications using Visual Studio 2003 and .Net 2.0 converting MS SQL 2000 databse to 2005 database. Develop several applications for Windows and the Web from current Excel spreadsheets. Maintained and Converted PHP websites to ASP.Net and maintained PHP/MySQL websites.Optimized database performance as Lead database developer using various statistical information to adjust and update index usage, stored procedures, DTS objects, and jobs. Updated Web applications as Technical Lead, rebuilding or upgrading websites from older to new servers. Created documentation supporting database and windows and web applications. Serve on interview team for new staff members, train and setup base setup for new staff members development environment. Assist with the creation of development policy, procedures and methodologies. Analyze current processes and develop system architecture and recommend SOA architecture considerations to the Chief architect for development of future projects. Developed stored procedures, installation scripts for the creation of new classes and insertion of data for new and existing databases. Utilized both Waterfall and agile development methodologies.


MS Visual Studio 2003-2008 (C# & VB), Team Foundation Server, MS SQL, MS Access 97, MS Office Suite 2003-2007, SQL Server Management Studio 2005, DevExpress v2007, PHP, MySQL, CSS, XHTML, SOAP, XML, IIS, VMWare

to

Developed SQL scripts for creating and altering stored procedures, constraints, tables, indexes and other database objects, took ownership of the database. Developed windows forms based applications as SQL/Oracle database tools to perform functions such as data cleansing, TSQL/PLSQL scripting and automatic SQL and stored procedure creation based on the current database specification using C#. Optimized performance for all database functions, and index usage. Created documentation supporting all database functionality. Maintenance development of unit tests and C# code as it pertains to persistence of the application code.


T-SQL, PLSQL, SQL Server Management Studio 2005, ORACLE 10G, Team System.NET, C#.NET

to

Developed SQL scripts to manage database objects and retrieve date for reports in JSP web pages. Added stored procedures, tables, constraints and relationship through scripts to accomplish support tasks for data retrieval and established rules and created documentation on best practice for development of database related objects. Adjusted and maintained JSP pages to accommodate SQL changes or new development of web reports using JSP & Hibernate.


T-SQL, SQL Server Management Studio 2005, Java, JSP

to

Developed, fixed and maintained Crystal Reports. Heavy SQL coding developing stored procedures to retrieve and manipulate report data. Database analysis for best case scenario in developing new MS SQL databases, tables, and stored procedures. Developed MS Access interface to allow client to change data as required. Used Agile development for changing requirements. Produced design documents and documented all code, processes and data enhancements. Interface with the client to gather requirements and develop a design process.


T-SQL, SQL Server, Crystal Reports 11, MS Access 2003

to

Developed highly visible, parent facing Crystal Reports projects. Designed objects, formulas, and access models for the reports. Developed Visual Basic code to access reports, set report parameters, and change report appearance based on current application workflow conditions and in support of product development. Developed SQL for stored procedures to access and manipulate for the reports. C#.Net code maintenance for existing web service. Created test environment for upcoming new systems development and testing. Interfaced with the client to gather requirements and develop a design process. Documented all new and maintenance development tasks.


T-SQL, SQL Server 2005, Visual Basic 6.0 and .NET, Crystal Reports 9

to

Developed a printing process workflow management application. Maintained and upgraded Web based order application and web setup program. Designed and developed MS SQL database for application backend including all necessary database objects, access and integration with existing database to share certain database objects. Interfaced with the client to gather requirements and develop a design process. Documented all new and maintenance development tasks.


T-SQL, SQL Server, Visual Basic 6.0, Visual Basic.NET, Crystal Reports 11, Word 2003, Excel 2003, VBA

to

Developed and fixed existing reports. Publish existing and new reports on web portal. Developed PL/SQL for Oracle database for report data.


PL/SQL, Oracle, Crystal Reports 10

to

Analyze requirements and systems for the development of enhancements for new version of a child support payment processing system. C++ development of a DLL to integrate with OPEX ASi300 Mail Processing and OCR reader machine. Visual Basic development of several modules and classes per the given tasks. T-SQL programming of stored procedures for data access and manipulation. Database analysis and optimization. Development of reports for current system and processing status, payment and performance indicators. Documented all code and tasks using design documents.


C++, T-SQL, Database Development

to

Developed COBOL II/IMS data access applications and forms under MVS. Database analysis and integration. Developed Visual Basic modules to receive data downloaded via COBOL/IMS code.


COBOL II/IMS, Visual Basic 6.0, ANSI SQL

to

Developed PL/SQL stored procedures and functions. Developed Adobe data access smart forms in XML. Developed Active X objects for web projects. Large team development project.


PL/SQL, TOAD 7.4, Active-X Development, Visual Basic.Net, .NET 2.0, Adobe Data Access, XML

to

Developed an integrated resource scheduling system attached to the client's MS Exchange cluster. Developed pages for MS Outlook and objects to integrate with MS Exchange system administration and set up and for intranet catering system. Developed usage statistics and resource availability status reports.


MS Outlook VBA, MS Outlook VB Scripting, Visual Basic.Net, .NET 1.1, DOS, LDAP, MS Exchange Programming

to

Full life cycle development of budget systems applications. Multiple project development for several government agencies in various phases of development from requirements gathering to product demo. Team lead or technical lead. Interviewed and analyzed staff for hiring. Developed Visual Basic applications and COM objects. Developed ASP applications for the web. Developed Crystal Reports.


Visual Basic 6.0, Crystal Reports 6.4, T-SQL, Crystal Reports 8.5, MS SQL 7, True DBGrid, Oracle 9i, Classic ASP

to

Full life cycle development of application to process HIPAA EDI documents. Analyzed and integrated systems, platforms and client/server databases. Technical lead. Developed the open ended back-end. Heavy ANSI SQL development. VBA development of office workflow system integration projects. Quality control. Developed Crystal Reports, user guides and system documentation.


HIPAA, VBA for Word, ANSI SQL, Report Development

to

Full life cycle development of high profile Windows NT/2000/98 and Web applications. N-tier applications development included Mainframe integration. Development of Web applications and conferences. Designed, developed and administered databases. Lead responsibilities on several Projects VBA and MS Access applications development Designed and developed of IIS platforms for HTTP, HTTPS and FTP website for development and production.


VBA for MS Access, Crystal Reports, Visual Basic 4.0, IIS, HTML

to

Developed VBA projects integrating MS Access, MS Excel, MS PowerPoint, MS Outlook and MS Word to retrieve, catalog, and manage the workflow and analysis of client survey and report data. Distributed the data to the appropriate contract managers and clients. Heavy analysis of business systems, corporate missions and workflow to configure the code to fit each process and tailor data for their best use. Developed code for desktop and client/server database systems. Problem solved integration issues between data capture equipment and output resources. Developed Crystal Reports.


VBA for Excel, VBA for MS Access, VBA for Word

to

Full life cycle development of enhancements for the product Digital Dining for Windows. Developed several inter office applications for business workflow. Created an online user manual and help guides. Developed application automated the conversion of product documentation, including User Guides and other help manuals from MS Word documents to the automated help files for the product.


Visual Basic 4.0, Foxpro, VBA for MS Word

to

Develop, Upgrade and maintain Visual Basic applications with Oracle, MS SQL and MS Access back ends and applications. Managed multiple clients and multiple projects. Network Engineering duties, including COTS integration, T1 connectivity and Windows NT server administration and management.Web server and IIS systems management. HTML programming.Developed Crystal Reports.


Visual Basic 4.0, IIS, HTML, Crystal Reports, MS Access, Oracle, Windows NT server administration

to

Develop, debug and maintained MS Access databases and applications. Developed Word templates using VBA MS Access back ends. Enhanced reports.


VBA, Visual Basic 3.0, MS Access, VBA for Word, Crystal Reports

to

Developed, upgraded and maintained application testing scripts.The scripts would test the HMS CIMPLICITY and CIMPLICITY applications. Switches and hubs at each testing station would be seen registering the values sent through clicks, registries, and LED readouts to determine test success or failure aside from QA Partner exposing syntax errors. Developed and implemented automated test suites. Each suite would simulate a particular use of the application depicting robotic arms or car wash sequences. Confirmed errors within the application verified resolutions and generated findings and error reports. Regression testing


C++, QA Partner, HMS CIMPLICITY

to

Supervised temporary and student employees. Full Life Cycle Development of various projects for support of the radar and sensor division Digital and Video Signaling, Low level programming and Systems Engineering. Assembly language and DOS programming. Multi-project development. Converted C application to Visual Basic 4.0, using Access as the backend and Crystal Reports (then a part of VB) for reporting Used GPIB/HPIB codes to send the appropriate code to move positioners, send and receive the signals from the DSP through the antennae at a given set of frequencies picked up by the receiver and returned to the application which would record it, and run the next test. The digital signal processers, microwave antennae, and positioner all had their own set of codes transported in FIFO format that the application would use to mimic the horizon and a ship at sea within an anechoic chamber to get readings to test and establish standards for a given antennae or antennae type. Expanded the programmability feature to set up testing parameters and tests to run at certain times or in certain sequence. Once programmed, they could run on until completion.


GPIB/HPIB, Visual Basic 4.0, C, DOS, Crystal Reports, MS Access, Digital and Video Signaling