James Coons



SummarySolution-Driven Data Analyst with TWENTY years of experience using analytical skills and passion to help solve “Big Picture” business problems and then to provide efficient business solutions. Strong design, organization, verbal and written communications skills and enjoy working as a team on projects. Skills include: Requirements Gathering ● User Acceptance Testing (UAT) ● ETL / Data Transformation ● Customer requirement eliciting and translating into business solutions ● KPI DashboardsProfessional ExperiencePiedmont Airlines, Technical Consultant, Louisville, KY11/2017 to PRESENTAssisted in solving problems in MicroSoft Access and Excel.Identified failure points in airport operations to improve effectiveness. Provided management with information to determine responsibility for failure points. Extracted and imported customer data into MicroSoft Access Tables.National Supply Network, Technical Consultant, Louisville, KY10/2017 to 12/2017Built a Contact Management System (CMS) in MicroSoft Access to increase efficiency in tracking customers.Solved a crucial customer problem in which their manual system became insufficient to track their customers. Created a Contact Management System (CMS) in MicroSoft Access to replace their manual system. Created Smart Search system to more easily locate customer records. Reduced errors, prevented duplication of data and improved efficiency. Ryder Integrated Logistics, Business Intelligence Analyst, Georgetown, KY02/2015 to 06/2015Improved management decisions at Toyota by providing dashboard of driver schedules, driving history, route data and other KPIs for inbound transportation to Toyota Manufacturing in Georgetown, KY.Decreased Costs by tracking driver speed, fuel usage, excessive idling and On-Time history. Developed Dashboards, Score Cards and Reports to monitor driver performance using SQL Services. Created automated system to import, analyze, validate and export performance data from external systems.Contract position with SGS (Software Galaxy Systems).U.S. Army Department of Defense, Sr. Business Analyst, Lexington, KY08/2011 to 06/2014Improved speed and accuracy of ordering system by creating a more modern system. ● Reverse-engineered the customer’s existing System. Created new web-based logistic application for customer. ● Worked with Business Analysts in Lexington and the remote Development Team at the Pentagon (U.S. Department of Defense). ● Held DoD Secret Security Clearance. ● Contract position with SSB, Inc with The Warriors.Gathered requirements from key stakeholders, including Programmers at the Pentagon.Created Functional Requirements, Business Rules, As-Is Docs, To-Be Docs, Use Cases, Test Cases, Test Plans and performed End-User Acceptance Testing (UAT).Participated in JAD/SCRUM/SPRINT sessions (Agile / SDLC method) and Waterfall Methodologies. Created and maintained a User Guide for the new system. Core Logic, Sr. Business Analyst, Louisville, KY12/2010 to 04/2011Analyzed mortgage products (including Foreclosure, Bankruptcy and Debt Collection) and provided programming details to off-shore programming team (India). Contract Position with Innovative Employee Solutions.Designed data export of customer’s files, including technical specifications, SQL Server Tables, Stored Procedures, data encryption, data export and transportation to FTP site. Wrote Technical Specifications for Loss Mitigation Plans.Analyzed customer’s Business Rules and created Business Requirements for software development.Created SQL Server Report for use by customers.JaCo Consulting, Technical Consultant, Louisville, KY04/2010 to 12/2010Created website for customer; created a Contact Management System and updated a customer’s website. Created website for customer’s web presence (The Kircher Group, Mast Construction).Updated customer’s website to provide a fresh format ().Created Contact Management System (JobEx) with calendar and reminders (VBA, Excel).Designed “web-scraping” techniques to pull website data into Excel (VBA, macros).Aspect Software, Jr. Business Analyst, Louisville, KY07/2008 to 01/2010Business Analyst on various team projects (formerly Quilogy).Created a Web Site Provisioning System for KCTCS University (SharePoint, InfoPath, SCRUM, Agile).Created a complex Human Resources system (Agile, InfoPath, SharePoint).Authored a 25 lesson training course for instructors (16 colleges on 68 campuses).Authored training materials and used to teach 12 classes (Nintex Workflows).Converted data for MicroSoft’s Amalga healthcare system (SQL, SSIS, MS Excel). Wrote procedure to convert 110,000 documents from DocuShare (SharePoint, Nintex Workflows).Temp Work, Various Positions, Louisville, KY08/2006 to 07/2008Various temporary positions after returning from Chile, including assembly line, technician and inventory system. Assembly Line (Greenlee-Textron through Willstaff Worldwide).Dell Diagnostic Technician (Trillium Industries through Robert Half International).Inventory and Warehouse (International Moulding Company); MS Excel inventory system, VBA.Chile Mission, Website Designer / Missionary, Santiago, Chile 01/2005 to 08/2006Created website for the mission in Santiago, Chile to attract public attention.Created the mission’s website to provide information for visitors (FrontPage).Taught English classes to attract people to the Mission.Performed administrative functions, including Missions budgets and expenses (MS Excel, Word and PowerPoint).Thomson IP Management, Data Conversion Analyst, Southfield, MI04/1995 to 10/2004Performed conversions (ETL) to import customers’ data into our company’s Intellectual Property database; created ProSpec data conversion system (formerly Master Data Center, then Thomson IP Management, then Clarivate).Improved data conversion process by creating ProSpec Tool in MS Access (VBA, ADO, T-SQL).Created 30+ data conversion tools used by programmers (VB, VBA, COBOL, DOS, QuickBasic).Saved estimated $3,000 on a data conversion project using the ProSpec tool (reduced conversion process time by 75%) and subsequently achieved similar time savings on all subsequent projects.Trained programmers on data conversion processes and techniques.U.S. Army Department of Defense, Jr. Business Analyst, Indianapolis, IN and MI12/1991 to 03/1995Worked on several projects in Michigan for the U.S. Department of Defense (DoD), including payroll automation and M1-Abrams tank tracking. Contract Position with CDSI (Computer Data Systems Inc).DFAS, Fort Harrison, IN: Automated customer’s Base Pay, Recruitment and Allowance Systems.TACOM, Warren, MI: Designed and programmed “Project Sword” logistics system to track M1-Abrams tanks as they moved from Production to the customer Site in Saudi Arabia. Corps of Engineers, Detroit, MI: Provided network support to Users at Corps of Engineers office. Saved customer $2,500 by recovering 6 weeks of data from a corrupt insurance file.Other ExperienceLucky’s MarketCulinary Associate Louisville, KY09/2017 to 02/2020Red Carpet Inn Front Desk Associate Louisville, KY12/2016 to 02/2017Direct Insurance Marketing Assoc. Life Insurance Interviewer Louisville, KY08/2016 to 10/2016EducationAssociate’s Degree, Info. SystemsITT Technical InstituteIndianapolis, IN1981 to 1983Bachelor’s Degree, Management Indiana Wesleyan UniversityIndianapolis, IN1992 to 1993SkillsSoftware:MicroSoft Office, SharePoint, Visual Studio, Nintex Workflows, Active Server Pages.Programming:Visual Basic 6.0, Visual Basic for Applications, Active Server Pages, HTML.Databases:MicroSoft SQL Server, Stored Procedures, SSIS, SSRS, T-SQL, MS Access, FoxPro, dBase.Processes:Data Analysis, ETL, Data Mapping, Agile, Scrum, Sprint, Use Case, User Stories, SDLC.Industries:U.S. Army and Department of Defense, Government, Logistics, Transportation, Banking, Mortgage, Intellectual Property, Insurance, Freelancing, Consulting. ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download