SUMMARY:

• Experienced applications manager, project manager, product owner, business analyst, systems analyst, developer, architect, database administrator, mentor and trainer supporting a wide and varied range of projects internationally.

TECHNICAL SKILLS:

Tools: Team Foundation Server, JIRA, Trello, Visual Studio, SQL Server, .Net Framework, Thunderhead, Deltek Vision, Adobe Creative Cloud, Actuate Reports, SQL Reports, Crystal Reports, SharePoint, Visio, K2 Black Pearl, InfoPath Designer, Project Dox, MS Access/Excel/Word/Outlook/One Note/Power Point, Infragistics NetAdvantage Controls, Component One Controls, AJAX Controls, Wacom Tablet, Skype, Ring Central, Team Viewer

Languages: Visual Basic, VB Script, VBA, SQL, T - SQL, XAML, XML, ASP, C#, HTML, Visual Fox Pro

Systems Designed: CRM Systems, ERP Systems, Accounting, Credit Consulting, Debt Management, Document Control, Financial Consulting, General Ledger, Geological Drilling Management, Human Resources, Insurance Collections, Inventory Control, Issue Tracking, KPI/KFI Forecasting, Learning Management, Leasing Management, Legal Case Tracking, Materials Tracking, Medical Collections, Patent Management, Payroll, Pipe Tracking, Project Controls/Services, Real Estate Investment Tracking, Retail Management, Recruitment Management, Revenue Tracking, Risk & Safety Incident Management, Tax Return & Audit Tracking, Time Tracking, Workflows: User Initiated & Automated

Other: Agile Scrum, Leadership, Management, Team player, Self-motivated, Strong Communicator, Fast learner, High integrity, Creative problem solving, Multi-Tasking, Organized, Open Minded, Analytical, Out of Box Thinking, Great at Conflict Resolution, Able to Motivate Others, Able to delegate work, Honest, Respectful, Great Listener, Loyal, Trustworthy, Responsible, Flexible

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, Georgia

Business Analyst/Consultant

Responsibilities:

• Project management through complete life cycle and build releases of all developed applications.
• Assess business requirements and deadlines to plan application releases.
• Manage team of analysts through the complete requirements gathering and design of projects.
• Manage team of subject matter experts to determine and guide the path forward of developed applications.
• Oversee day-to-day activities of staff, resolve any conflicts as they arise and conduct daily stand up meetings.
• Assign Development & QA staff workload based on skillset, system knowledge and needs.
• Administration
• Design documentation templates for business requirements and technical design to be used on all projects.
• Analysis
• Triage tickets and document business requirements and technical specifications for database and application design and development including diagrams and flowcharts.
• Meet with users, managers and subject matter experts to understand and obtain application requirements/use.
• Analyze requirements, business processes, existing applications and data storage to design a shared data application to improve processes and add automation.
• Additional requirement gathering and understanding obtained through code review and analysis, document analysis, surveys, business process flow charts and descriptions, use cases, scenarios, business analysis, data analysis and workflow analysis.
• Development
• Prototype screen layouts for web and XAML.
• Design application based on obtained requirements that are flexible for future use while fitting into the current processes and structure. Design database tables, views and functions.
• Convert MS Access Databases and Excel files to .Net/SQL applications.
• Develop SQL scripts for major and minor projects, reporting, analysis & research, data retrieval for testing, and every day needs.
• Develop scripts to capture data metrics for reporting purposes including KPIs, KFIs and KRIs.
• Perform Code Reviews to locate issues or deviations from requirements.
• Reporting
• Use MS Excel to create dashboards to display detailed project stats using Pivot Tables and Pivot Charts.
• Connect MS Excel to different data sources including data warehouses, SQL Databases, MS Access Databases.
• Documentation
• Create documentation on database and application design including diagrams and flowcharts.
• Write release notes for all application releases. Write user manuals.
• General
• Design testing procedures for users and development staff. QA Testing and troubleshooting on development work.
• Train users on application use.

Confidential - Sugar Land, Texas

Responsibilities:

• Manage a team of subject matter experts to determine and guide the path forward of a major cross departmental application.
• Manage a team of business liaisons and managers to properly prioritize issues and requests across all departments.
• Project management through complete life cycle and build releases including a multi-year, multi-phase multi-million dollar project.
• Oversee day-to-day activities of Development & QA teams to ensure projects stay on track and ensure requirements are fully understood and met while resolving any conflicts as they arise.
• Assign Development & QA staff workload based on skillset, system knowledge and needs.
• Assess business and regulatory requirements and deadlines to plan application releases.
• Initiate and conduct Developer & QA staff stand up meetings.
• Initiate and conduct monthly backlog grooming and prioritization meetings with Business Liaisons, Development and QA Teams.
• Implement a code review process as a standard to the development cycle.
• Implement a “buddy system” for development staff to work on certain tickets together so one developer could work with a more experienced peer in lesser known application areas to grow their skillset and provide staff backup.
• Implement lunch and learn sessions so Development and QA staff can peer train each other.
• Mentored and trained a QA Staff member to take over and manage the QA Team.
• Conduct and lead international video and phone conference meetings for all remote staff and external agency representatives.
• Implement status reports and IT time tracking on externally funded projects.
• Administration
• Team Foundation Server administration including work item templates and workflow design.
• Review Project Charters from all business areas prior to submission and provide feedback to ensure a more thorough charter and higher likelihood of acceptance and funding.
• Design documentation templates for business requirements and technical design to be used on all projects.
• Design, implement and manage IT ticketing processes.
• Analysis
• Triage tickets and document business requirements and technical specifications for database, application and report design and development including diagrams and flowcharts. Lead Business Analyst on team.
• Meet with users, managers and subject matter experts to understand and obtain application requirements/use.
• Meet with representatives from external agencies to obtain requirements for interfacing with their applications and/or data.
• Additional requirement gathering and understanding obtained through code review and analysis, document analysis, surveys, business process flow charts and descriptions, use cases, scenarios, business analysis, data analysis and workflow analysis.
• Analyze governmental regulations, compliance requirements, business processes and existing applications to design company wide tools and a shared data application replacing outdated technology to provide standardization, more efficiency & process automation, easily recognizable functionality, reduction of manual data entry and reliance on Excel spreadsheets.
• Understand company clientele to design website applications and functionality for public consumption.
• Development
• Design enhancements based on obtained requirements that are flexible for future use while fitting into the current processes and structure of the application.
• Design database tables, views and functions.
• Prototype screen layouts for web and XAML.
• Develop SQL scripts for major and minor projects, reporting, analysis & research, data retrieval for testing, and every day needs.
• Develop scripts to capture data metrics for reporting purposes including KPIs, KFIs and KRIs.
• Perform SQL, C# and ASP.Net Code Reviews to locate issues or deviations from requirements.
• Develop system correspondence using Thunderhead. Develop system workflows using K2 Black Pearl.
• Design testing procedures for users and IT staff. QA Testing and troubleshooting of new programs and enhancements.
• Reporting
• Develop and test Business Intelligence reports using SQL Server Reporting Services (SSRS).
• Use MS Excel to create dashboards to display detailed project stats using Pivot Tables and Pivot Charts.
• Connect MS Excel to different data sources including data warehouses, SQL Databases, MS Access Databases.
• Documentation
• Write IT Blog articles to creatively explain technical processes, upcoming & past changes, programming & IT terminology, how-to articles and whatever else is needed to help business users better understand what happens in IT on a day-to-day basis.
• Write release notes for major and minor application releases. Write user manuals.
• General
• Foster open communication, collaboration, accountability, ownership, integrity and creativity among IT staff.
• Able to clearly articulate ideas to others in all departments and external partners/agencies whether verbally or written.
• Promote and career growth using internal lunch & learns, vendor workshops and cross functional “buddy system” work.
• Train staff on Help Desk, Quality Assurance and Business Analyst duties. Train IT staff and business users on application use.
• Create department motto and tagline.
• Recipient of the Prime Player .

Confidential - Houston, Texas

Responsibilities:

• Manage an analysis team through the complete requirements gathering and design of 3 multi-million dollar projects.
• Analysis
• Meet with users, managers and subject matter experts to understand and obtain application requirements/use.
• Analyze business processes and departmental applications to design a shared data application that replaces over 100 MS Access database applications and provides more efficiency, company standardization, reduction in redundancy within departments, more process automation, reduction of manual data entry and functionality easily recognized by user.
• Design
• Design n-tier applications for ASP.Net and SQL Server. N-Tier applications consist of a combination of GUI Web based layer, business rules layer, web services layer, data access layer and data layer. One major application tracks tax audit cycle data across multiple departments and helps prepare future tax return adjustments. Another major application interacts with SAP and Data Flex financial reporting data to verify data integrity and accurate amounts within the global general ledger while also being the global data store for many corporate data structures.
• Design an application framework template for a basis of all future applications designed for and within the Business Line Applications division. Template application provides standardized applications within the division, reduces future development costs and provides tools and functionality easily recognized by users. Template application includes robust data filtering; user creatable metadata fields; automated and user definable workflow and alerts; customizable user interface including dashboard, taskbar and docking; integrated security using encryption; user audit trails; data import and export capabilities; general data validation; error handling, logging and reporting.
• Documentation
• Create documentation on database and application design including diagrams and flowcharts.
• Design documentation templates for business requirements, technical design, test plan and requirements traceability matrix.
• Write user manuals and help within applications.
• General
• Design testing procedures for users and development staff. QA Testing and troubleshooting of new applications.
• Train users on application use.

Confidential - Houston, Texas

Responsibilities:

• Project management through complete life cycle and build releases of all developed applications.
• Oversee day-to-day activities of Development & QA staff to ensure projects stay on track and ensure requirements are fully understood and met while resolving any conflicts as they arise.
• Assign Development & QA staff workload based on skillset, system knowledge and needs.
• Assess business requirements and deadlines to plan application releases.
• Initiate and conduct Developer & QA staff stand up meetings.
• Implement status reports and IT time tracking on externally funded projects.
• Analysis
• Meet with users, managers and clients to understand and obtain application requirements/use.
• Analyze business processes and data storage to develop new Work Breakdown Structure (WBS) coding structure to help integrate data within different systems throughout entire company.
• Analyze business processes and departmental applications to design and develop companywide tools and shared data that provide more efficiency, company standardization, reduction in redundancy within departments/locations, more process automation, eliminate paper activities, functionality easily recognized by users, reduction of manual data entry and reliance on Excel spreadsheets which in turn helps users be more productive, reduces human errors and frees up individuals’ time to handle other pressing matters.
• Administration
• SQL Server administration.
• Improve performance and functionality of existing databases.
• SQL database tuning, server logins and database permissions.
• Design SQL maintenance, security, tuning, backup and data recovery plans for all existing and new databases.
• Deltek Vision administration and customization.
• Development
• Complete database design including tables, indexes, views, triggers, stored procedures and user defined functions.
• Design, develop and monitor Data Transformation (DTS) Packages and Integration Services (SSIS) Packages in SQL Server to extract, transfer, load (ETL), gather and synchronize data from other databases, Excel and text files.
• Dimensional Data Modeling and Cube development in SQL Server Analysis Services (SSAS).
• Develop applications using VB.Net and ASP.Net to import data from web-based data or a file into different tables and/or databases. Automatically find duplicate, missing and incorrect data; if possible automatically correct data otherwise alert user.
• Develop algorithms to automate complex calculations for tracking man-hours used, earned and projected verses budgeted.
• Develop time and event tracking to track what users do within an application and store an audit trail using VB.Net.
• Develop n-tier applications using VB.Net, ASP.Net and SQL Server. N-Tier applications consist of a combination of layers for: GUI Windows based, GUI Web based, business rules layer, web services, data access and data. Major Document Control Application tracks documents, revisions, transmittals, client comments, due dates and return dates. Generates document numbers based on each project’s individual settings, duplicates entire project’s data within a few steps via a wizard and user customizable data extraction exported to Excel via a report generator. Customizable user interface including taskbar and docking.
• Develop integrated security using encryption in new and existing applications/databases using VB.Net, ASP.Net and SQL Server.
• Develop error logging in applications and ability for user to send error report via email from an error message box using VB.Net, ASP.Net, XML and SMTP.
• Develop web service using ASP.Net to access data layer for off-site users of application. Support applications at several off-site locations worldwide.
• Develop web forms using ASP.Net, JavaScript or VB Script and SQL to present and gather data from users.
• Design and develop web based Accounting tools to interact with General Ledger and other accounting data to find discrepancies and handle various internal departmental tasks.
• Develop windows and web based applications including reports to replace complex and manually intensive Excel Spreadsheets and Word Document forms using VB.Net and ASP.Net.
• Develop applications using VB.Net to use registry settings to indicate server/database to run from for using at different sites/servers and for testing purposes.
• Develop applications to export data to Excel, text or HTML file.
• Develop Excel Spreadsheets and Word Document Forms using VBA to handle complex functionality.
• Develop application to synchronize databases including SQL and Access. User selects two databases to compare, application lists all differences in structure and data. User would then select which changes to make to each database and application makes necessary changes.
• Develop Smart Client applications using Visual Studio .Net to install, run and automatically update from intranet site.
• Develop application that uses SQL data to update Primavera (P3) schedules automatically and vice versa using VB.Net.
• Improve application functionality, performance, appearance and speed. Modularize code and develop libraries to eliminate redundancy.
• Develop several MS Access Database Applications including Document Control, Project Controls/Services, Job Cards, Delta MTOs, S-Curves and Rainbow Charts, Inventory Control, Manpower Projections, Materials Tracking, Revenue Tracking, Time Tracking, Employee Tracking and General Reporting.
• Convert MS Access applications to Visual Basic .Net/ASP.Net and SQL Server applications.
• Enhancements/maintenance on new and existing applications and databases. Restructure to meet industry standards and for efficiency purposes.
• Develop Installation package for applications using Visual Studio .Net Package and Deployment feature.
• Develop testing procedures for users and development staff. QA Testing and troubleshooting of new and existing applications.
• Develop scripts to capture data metrics for reporting purposes including KPIs, KFIs and KRIs.
• Reporting
• Develop reporting website using SQL Reports (SSRS) and ASP.Net Forms to collect parameters.
• Develop multiple Actuate Reports for intranet site and Deltek Vision application including Invoicing, General Ledger, Time Tracking, Forecasting, Earned Hours, Project Detail, Actuals vs Budgeted and various other Reports. Enhancements to existing Actuate Reports.
• Develop multiple Crystal Reports embedded within applications and intranet site from CAD, SQL, Access and Excel data sources.
• Use MS Excel to create dashboards to display detailed project stats using Pivot Tables and Pivot Charts.
• Connect MS Excel to different data sources including data warehouses, SQL Databases, MS Access Databases.
• Documentation
• Create documentation on database and application design including diagrams and flowcharts.
• Develop help within applications, write user manuals and train users on application use and MS Access design.
• General
• Train junior developers on application use, Visual Basic .Net development, Crystal Reports, SQL Server and MS Access design.