PERSONAL ATTRIBUTES:

• I am a decisive and enthusiastic team player who has undertaken a wide range of senior development roles in both the public and private sectors.
• I am Solutions focused, well organised individual with good verbal/written communication skills for customer and development interaction.
• I can readily identify key issues and solutions quickly in complex systems while prioritise work flows and able to work under pressure to meet organisational requirements.
• Strong analytical and technical skills with a keen eye for detail. I present a professional, conscientious, self - motivated, trustworthy persona. Able to work using my own initiative, self-directed, able to supervise staff and work well as part of a team.

KEY AREAS OF EXPERIENCE:

• Application design, new development, enhancements and maintenance of applications, database design, troubleshooting, testing at all different levels and implementation. Analysing business requirements, developing technical solutions tailored to meet business/client’s needs. Managing teams of developers, planning work flows and addressing performance issues. Training and supporting technical and system user staff. Fine tuning applications/configurations to receive the best performance.
• All aspects of Project Management including scoping, project initiation, resource allocation, project implementation, reporting, project closure contractor management, stakeholder and senior management engagement, user involvement, testing and post project support.

TECHNICAL SKILLS AND EXPERIENCE:

• SHELL SCRIPT
• Oracle 10g/11g PL/SQL
• LDAP - EXTERNAL SECURITY
• MS SQL Server 2008 R2
• SHAREPOINT 2010
• NINTEX WORKFLOWS
• BUSSINESS INTELLIGENCE
• VB.NET
• CSS
• XML
• DB2/SPUFI/QMF/SQL
• SCOBOL/APS
• COBOL II
• MVS/XA/ESA
• CICS
• MQSERIES
• JCL
• TSO/ISPF
• FILE-AID
• EASYTRIEVE
• XPEDITER
• VSAM
• MICRO FOCUS PRODUCTS
• TOAD
• INFOPATH - forms
• C#
• SQL Developer
• SSIS
• Bootstrap
• IIS
• 3 Months
• T-SQL
• Visual Studio 2012
• SSRS
• HTML

CAREER HISTORY:

Senior Programmer Analyst

• Company has an old CMS system that create manufacturing crystal reports. The data is extracted from Epicor and loaded into the CMS system for shortage reporting. The system is no longer supported nor is the system compatible with any operating system above windows XP. The reports were created in crystal in 1984 and are no longer compatible with current crystal version.
• This project has extensive research into the functionality of the old Micro Focus Cobol program mimic the current functionality.
• Due to the Epicor and the licensing guideline, an external Material Shortage database was created and a link server was used to extract from Epicor into the new external database.
• T-SQL scripts were built to extract the data and calculate shortages.
• SSRS report was built using external data sources directly into Epicor for reporting purposes.
• Company wanted to implement barcoding into the shop floor for users to manufacturing jobs within Epicor.
• Built scan sheets, for logging in and out of Epicor, Crystal job traveller report was changed to merge fields together to minimize number of bar code scans.
• Trained and supported users.
• Build enhancements to a pre-existing excel documents .net macros which tracked audit of manufacturing jobs. Any job that failed an audit a separate sheet was created with all the major details for reporting purposes and tracking progress.
• Assignment was to upgrade the application to use bootstrap functionality allowing the application to be used on mobile devices as well as upgrading the look and feel of the application. Development was complete in Visual Studio 2012.
• Implementing bootstrap into a pre-existing application requires additional icons, fonts, java scripting, style sheets etc. Every page was then changes to reformat pre-existing fields, panels, and buttons to use the bootstrap methodology.
• Once all the formatting, sidebars, menu bars, footer bars and formatting was complete extensive testing was complete to ensure all the pre-existing functionality was present and working as well as the new functionality

Consultant - Senior Programmer Analyst 

• Original assignment was to build a pro-type within SSIS to extract data from numerous tables and loading into a data warehouse tables. The same functionality was built within Transact-SQL (T-SQL) stored procedures and a demonstration was given to the client as well as pros and cons of both processes.
• The client decided to proceed using T-SQL, therefore I was tasked to design and build a process to extract data from 30 different databases. Data was then summaries and placed into the data warehouse tables. Some of these databases where in the same server and others on external servers
• Within the stored procedures extensive logging, and error handling was implemented as well as restart processing.
• Assignment was to upgrade the application to use bootstrap functionality allowing the application to be used on mobile devices as well as upgrading the look and feel of the application. Development was complete in Visual Studio 2012.
• Some minor MS Server table changes were necessary for the menu sidebar to add icons and separator lines.
• Implementing bootstrap into a pre-existing application requires additional icons, fonts, java scripting, style sheets etc. Every page was then changes to reformat pre-existing fields, panels, and buttons to use the bootstrap methodology.
• Once all the formatting, sidebars, menu bars, footer bars and formatting was complete extensive testing was complete to ensure all the pre-existing functionality was present and working as well as the new functionality
• External users requested additional functionality which included new pages, filters, fields and additional export capabilities.
• New T-SQL Stored procedures were created for maintaining new fields.
• MS Server Mail was added for sending notifications to users.
• Company was running out of space on the original web applications / database server. I was requested to move all the databases to a new server and redirect the corresponding applications to the new database. IIS as used to identify the original links and setup for the applications. Once the applications were linked to the new database everything was re-tested.
• After verifying all Database and applications where communicating correctly, I then moved all the applications and set up the IP address etc. within IIS.
• Assignment was to upgrade the application to use bootstrap functionality allowing the application to be used on mobile devices as well as upgrading the look and feel of the application. Development was complete in Visual Studio 2012.
• Some minor MS Server table changes were necessary for the menu sidebar to add icons and separator lines.
• Implementing bootstrap into a pre-existing application requires additional icons, fonts, java scripting, style sheets etc. Every page was then changes to reformat pre-existing fields, panels, and buttons to use the bootstrap methodology.
• Once all the formatting, sidebars, menu bars, footer bars and formatting was complete extensive testing was complete to ensure all the pre-existing functionality was present and working as well as the new functionality
• This is a new application and clients want to convert and migrate all pre-existing data which was being captured in SharePoint. Data was supplied by client in excel format and development was complete in Visual Studio 2012.
• There were no application table changes, however a number of table where built for the purpose of loading and converted reference values.
• Due to the quality of the data, I built multiple excel macros to cleanse the data, remove extra tabs and line returns. Also, to add a unique tracking number and capture the actual hyperlink for loading purposes.
• Loaded the main cleansed data into a MS Server baseline table for further processing as well as the hyperlink where the patients name was stripped for loading.
• The clients provide the application users and the physicians which were loaded directly into the application tables.
• The sequence of the loads within these tables was very important as well as linking the user, physician, remote physician and survey data with the correct Patient, user and event. This was a complex load with conversion of reference values to match the new system
• Included logging into all the procedures to ensure tracking of data being loaded for later verification as well as error handling.
• To enhance an existing application which tracked a single specialty to a multi-tracking specialty system, including new reports, screens and enhancements to existing tabs and reports. Development was complete in Visual Studio 2012.
• Specialty enhancements required additional tables as well as changed to other tables for specialty driven menus.
• To add new functionality that allowed the combination of multiple specialties.
• To add a general referral page that directed the user to the detailed specialty page depending which one was chosen.
• Modified existing application pages to display relevant specialty information when appropriate.
• Modified existing reports to filter by specialty and added additional reports for the specialty.
• Added additional field verification and messaging
• To upgrade the application to use bootstrap functionality allowing the application to be used on mobile devices as well as upgrading the look and feel of the application. Development was complete in Visual Studio 2012.
• Some minor table changes were necessary for the menu sidebar to add Icons and separator lines.
• Implementing bootstrap into a pre-existing application requires additional icons, fonts, java scripting, style sheets etc. Every page was then changes to reformat pre-existing fields, panels, and buttons to use the bootstrap methodology.
• Once all the formatting, sidebars, menu bars, footer bars and formatting was complete extensive testing was complete to ensure all the pre-existing functionality was present and working as well as the new functionality
• Designed and built a C#, PL/SQL interactive system where users can set up a contract configuration that identifies incentives, rules and processing for a back-end payment system. The system allows for multiple contracts for the same year to be created and maintained. The system used Windows authentication for security. Development was complete in Visual Studio 2012.
• Built a PL/SQL package which interfaces with the C# front-end and from parameters that are entered by the user will copy a full contract configuration for the user to modify were necessary for the next calendar year.
• Built an interactive system for the user to review the details of a payment run and drop down in to further details for research purposes.
• System tested and created to user specifications.
• Presented training to operations, management and users on the interactive system, how to troubleshoot and how to support clients using the system.
• Throughout the year supported external clients and implemented new functionality and gradually migrating new clients onto the system.

Consultant - Senior System Analyst Programmer

Responsibilities:

• Assisted in building a nightly batch process to extract data from an IMS database and load to an Oracle Database using an automated Shell script process which was triggered on the mainframe.
• Designed and built all the shell scripts and PL/SQL packages to convert the Oracle data back into IMS structure and load to the Mainframe.
• Designed and built an automated compare system that would compare results between the IMS data and the Oracle to ensure all records were present and correct.
• The company is presently working with a phased approach in replacing the current IMS Mainframe database with Oracle therefore part of my role is to design and assist in the building of an automated extract process and rewrite the nightly process.
• This involves analysing and understanding business requirements. Developing technical specifications and working with users and senior managers. I am heavily involved in the planning, coding and testing at a unit, system and user level through to full implementation and post implementation.
• Designing data verification reports to ensure quality of data for accurate migration into the Oracle system.
• Acquired test data and ran tests to determine the accuracy of the program logic to produce the required results.
• Identified and tracked anomalies providing developers specification changes for bug fixing.
• Redesigned and modularized the main PL/SQL package, into separate packages, functions and triggers which interface with the online Java modules.
• Modularized error handling to ensure all oracle abends where handled and sufficient information was passed back to the calling Java module.
• Researched the current IMS/Cobol programs and extracted all business rules for the business analysts to create technical specifications for the new Java modules.
• Researched and built technical specification for PL/SQL batch processing.

Consultant - Senior ICT Solutions/Business Analyst 

Responsibilities:

• The company is presently working with a phased approach in replacing the current Oracle ERP XAL system with SAP therefore part of my role is to design and assist in the building of an automated extract process from the XAL manufacturing system.
• Designing data verification reports to ensure quality of data for accurate migration into the SAP system.
• Acquired test data and ran tests to determine the accuracy pf the program logic to produce the required results.
• Identified and tracked anomalies providing developers specification changes for bug fixing.
• Technical lead identifying and implementing solutions to problems affecting XAL Manufacturing and accounting systems as well as supported the Dakar Payroll application.
• Providing 1st/ 2nd line support with a solid work experience with the ITIL approach, providing technical support via helpdesk systems, reporting and troubleshooting incidents, service management, and implementing change controls according to the company’s procedures.
• Due to new SOX audit controls part of my role was to redesign the security infrastructure within the XAL and Dakar Payroll systems and implemented new system audit trails.
• The technical environment is Oracle 10g on a Unix platform.

Senior ICT Solutions Analyst

• I was primarily responsible for ensuring that business requirements are met through the application design, development and implementation of a CRM software application to support the business needs and management information requirements. These systems were built using PL/SQL; SQL Stored Procedures, SQL Functions and Shell scripts on a Unix platform.
• This involves analysing and understanding business requirements. Developing technical specifications and working with users and senior managers. I am heavily involved in the planning, coding and testing at a unit, system and user level through to full implementation and post implementation.
• I have led SharePoint projects and design reviews which have resulted in new InfoPath and business intelligence solutions, improved system security, and more effective Nintex workflows. I regularly liaise with key stakeholders and suppliers throughout any project life cycle.
• I provide training to support staff post implementation and deputise for the ICT Manager in her absence. I take responsibility for project workflow, support and performance issues for a team of eleven staff including contractors, in-house programmers, service desk staff and commercial apprentices.
• Providing 3rd line day to day support for our social housing customers based in the UK. This included complex problem resolution, installations and data migration projects, account management, trouble shooting, user administration and support at all levels, as well as monitoring and distributing the roll out of Web syncs and hot fixes
• Developed, prepared and maintained documentation for the design of the CRM system.
• Designed, developed and maintained systems for automated data processing through CRM and SharePoint applications, including the security infrastructure.
• Developed and acquired test data for unit, system and user testing to determine the accuracy of the program logic to produce the desired result.
• Tracked bug fixes and all program revisions to ensure re-testing was complete and project documentation was maintained.
• The technical environment was SharePoint2010, Nintex, MS Sql, Pl/Sql, SQL Stored procedures and functions on Oracle 11g, Shell Scripting, VB.Net, XML, InfoPath forms, CSS and Business Intelligence.

Consultant Senior Support Engineer

• Providing day to day 3rd line support for customers based in the UK and Europe, in a Unix (Solaris, HP/UX and AIX) environment.
• This included complex problem resolution, installations and data migration projects, account management, trouble shooting, user administration and support at all levels, as well as monitoring and distributing the roll out of Web syncs and hot fixes.
• The Technical environment was SQL, IMS, Cobol, CICS and Web Services, Shell Scripting on a Unix Platform

Consultant - Team Leader

• Work-Lead with a team of 10 developers to convert new clients onto an existing Health Care Claims systems.
• Liaised with clients to establish requirements, translated requirements into technical specifications and ensure project was on track at each milestone.
• Monitored and mentored team through the analysis and design of customer’s requirements, programming, testing, quality assurance and a timely implementation.
• Completed extensive research, problem solving, designing, testing, and programming, the technical environment was SCOBOL, APS, SQL, IMS, MQ, Easytrieve, XPEDITER and ENDEVOR on a MVS operating system.
• Team Supported production support for new installations.
• I was senior developer on several projects to re-engineer existing processes which led to significant reductions in processing time (e.g. from 8 hours to 1 hour; a reduction of 43% in processing errors and 35% in research time)

Consultant - Senior Programmer Analyst

• Successfully designed a communication ERP interface process between different platforms for Java, CICS, UNIX and batch through MQSERIES. This allowed one crucial point for all data to pass through to be processing appropriately and passed to multiple platforms to keep data in sync. This eliminated all communication problems between platforms, providing an easy method for maintenance and created a faster communication process using stored procedure.
• Liaised with users to establish requirements, translated requirements into technical specifications.
• Developed, prepared and maintained documentation for the design of the ERP system.
• Designed, developed and maintained systems for automated data processing through ERP applications.
• Developed and acquired test data for unit, system and user testing to determine the accuracy of the program logic to produce the desired result.
• Trained users on new screens and functionality of the new ERP system.
• Held technical training to enhance technical skills of developers monthly.
• Designed and programmed a communicate interface for multiple data platforms (Web, Online and UNIX)
• Completed extensive research, problem solving, designing, testing, and programming, the technical environment was COBOL II, CICS, SQL, MQ, XPEDITER and ENDEVOR, on a MVS operating system.
• Supported production support for new installations.

Consultant - Senior Financial Programmer & Analyst

• This contract consisted of rewriting, designing and coding programs for various systems within the financial and agency department (Escheat daily & yearly, Voids, Stops, Apecs and bank processing). These projects were worked consecutively for quarterly installations that varied in length and complexity.
• For each project there was extensive research, design, problem solving, coding, testing and working directly with users to clarify the fixes or enhancements to the applications.
• Support existing applications and production support for new installations. Technical environment was COBOL II, VSAM, CICS and SQL and Easytrieve on a MVS operating system.

Consultant - Senior Financial Programmer & Analyst 

• This contract consisted of rewriting/coding, testing and implementing key folio system programs (auto, commercial, fire and P&C), which entailed major data research and analysis due to there being no documentation of the business processing rules. EXCEL was used to upload reconciliation and statistical reports to work with the accounting department to establish approval of processing and findings.
• Assisted on the project which consisted of rewriting and balancing of the property & casualty system for fire and losses, which entailed working with underwriter and agent rules and regulations, calculations of premium and different coverage’s to be applied.
• Support existing applications and production support for new installations. All system charts were created and maintained using VISIO for Windows. Program documentation and status reports were maintained in Word. Technical environment was COBOL II, VSAM, on a MVS operating system.

Consultant – Team Leader

• Worked with a team of 5 developers to do research and analyst on an existing financial royalties system to discover problems within the system that had caused the company to fail an IRS audit with over 1 million dollars of assets missing.
• Design resolutions plus an automatic audit tracking system, wrote program specification and implemented fixes across multiple systems. Liaison with auditors to track financial data and ensure system/financial validity and design fulfils business and audit requirements
• Monitored and mentored team through the program specifications, programming, testing, quality assurance and a timely implementation.
• Completed extensive research, problem solving, designing, testing, and programming, the technical environment was COBOL II, VSAM, NATURAL, SQL and CHANGEMAN on a MVS operating system.
• My team covered production support of new installations.

Consultant - Senior Programmer Analyst

• Successfully re-engineered a VSAM data structure to a DB2 structure with utility programs for initial data transfer.
• Created data mapping documents for user approval and verification within Excel.
• Designed new DB2 tables and programs to load data from VSAM to DB2
• Completed extensive research, problem solving, designing, testing, and programming, the technical environment was COBOL II, VSAM and SQL on a MVS operating system.

Consultant – Senior Programmer Analyst

• Interfaced with users and become familiar with their functions to identify accurate and achievable enhancements, which improved efficiency within their department.
• Once changes were approved, I was part of the development team doing coding, quality assurance, user testing and timely implementation of these modifications.
• Technical environment was COBOL/II, VSAM, and CICS on a DOS operating system and all project documentation (functional, detail design and program specifications) was produced using Word for Windows and all system charts were created and maintained using VISIO for Windows.
• Support existing applications and production support for new installations.

Consultant – Team Leader

• Worked with a team of 6 developers working on multiple claims projects.
• I tracked the life cycle of multiple projects, monitored and mentored my team through the analysis and design of end-user requirements, programming, testing, quality assurance, implemented and trained of user department’s requirements. These projects entailed complex programming, accurate tracking and tight deadlines for implementation.
• Project planning and tracking was maintained using Microsoft Project Manager and all system charts were created and maintained using VISIO for Windows.
• Technical environment was COBOL II, VSAM, CICS using Endevor.
• Support existing applications and production support for new installations.

Consultant – Senior Programmer Analyst 

• My first assignment was to interface with users and become familiar with their department functions to identify software package customizations and fixes, which improved accuracy and efficiency. My function was a technical liaison between the vendor and the users, to ensure compliance with requirements was successful. I would track and ensure deadlines were met by all parties and reported status to senior management.
• Working directly with users to evaluate requirements and created functional specifications using Word for Windows. Problem and element tracking using EXCEL.

Confidential

Consultant – Team Leader 

Responsibilities:

• Team Leader (Dec 94) position with 8 developers for the Interchange and Pre-Fm area, where my duties included planning and tracking of multiple projects, analysis/research, monitored team development, verified testing and implementation.
• Programmer ( Jan 94 – Nov 94 ) for several projects in the merchant business area, where I participated in the design, coding, testing and implementation of the new regulation enhancements for Visa and MasterCard
• Project plans were created and maintained using Microsoft Project Manager
• Working directly with users to evaluate requirement and created all project documentation (functional, detail design and program specifications) using WordPerfect 6.2 and Word for Windows and all system charts were created and maintained using VISIO for Windows. Technical environment was COBOL II, VSAM using Endevor.
• My team covered production support of new installations.