RESUME OF JAMES COONS
Download Resume (Microsoft Word Format)
James.Coons.Resume.docx |
James Coons, Data Analyst
Louisville, KY 40065 * 502-220-8569 * [email protected]
Summary
Experienced Business Intelligence Analyst, specializing in analyzing complex business requirements and translating them into final solutions (BI, ETL, SQL, KPI, SSMS, SSIS, SSRS).
Technical Highlights
Industries: U.S. Army and Department of Defense, Logistics, Banking, Mortgage, Insurance.
Software: MicroSoft Office, SharePoint (MOSS), Visual Studio, SharePoint Designer, Nintex Workflows.
Languages: Visual Basic 6.0, Visual Basic for Applications, Active Server Pages, HTML.
Databases: SQL Server (v2008, Stored Procedures, SSIS, SSRS, T-SQL, MS Access, FoxPro.
Processes: ETL, Data Analysis, Data Mapping, ETL, Agile, Waterfall, Use Case, Functional Specifications.
Professional Experience
Red Carpet Inn, Front Desk, Louisville, KY, 12/2016 to 02/2017
Front Desk Clerk.
* Guest Reception, Check-In and Check-Out, Answering Telephones, Daily Activities, Reports.
Red Carpet Inn, Front Desk, Louisville, KY, 12/2016 to 02/2017
Front Desk Clerk (Guest Service Associate).
* Guest Reception, Check-In and Check-Out, Answering Telephones, Daily Activities, Reports.
DIMA, Customer Support Interviewer, Louisville, KY, 08/2016 to 10/2016
Interviewed agents and customers for online applications of life insurance.
* Interviewed insurance agents to obtain HIPAA information for life insurance applicants.
* Interviewed insurance applicants to verify HIPAA details and gather additional information about their health, medical and prescription histories.
* Worked with Medical Information Bureau (MIB) and underwriters to approve or deny the application.
Ryder Integrated Logistics, Business Intelligence Analyst, Georgetown, KY, 02/2015 to 06/2015
Worked on projects in support of Toyota transportation logistics systems.
* BI: Analyzed Logistics data using MS Access and MS Excel, gathered user requirements, performed data mining and validation.
* ETL: Developed system to import and export logistics data (using SQL, VBA and MS Access).
* SQL: Developed complex SQL Server Queries (SSMS) and Stored Procedures.
* KPI: Developed Dashboards, Score Cards and Reports (SRSS) to monitor driver performance.
SSB, Business Analyst, Lexington, KY, 08/2011 to 06/2014
Provided Business Analysis for ATLAS (Automated Transaction Logistics and Accounting System), a logistics system developed for the HQDA (Headquarters Department of the Army, U.S. Department of Defense).
* Requirements: Gathered user requirements, created “as-is” and “to-be” diagrams and Use Cases.
* Analysis: Reverse-engineered legacy FoxPro Logistics system (ECHO) into a web application (ATLAS).
* Design: Worked with the Development Team to redesign the legacy system as a web-based application.
* Agile: Utilized Agile and Waterfall Methodologies; participated in SCRUM sessions (JAD).
* Technical Writer: Designed and updated the User Guide.
* Other: DoD Secret Security Clearance, Use Case, Logistics, SharePoint (MOSS).
Core Logic, Business Analyst, Louisville, KY, 12/2010 to 04/2011
Analyzed mortgage products (Loss Mitigation, Foreclosure, Bankruptcy and Debt Collection) and provided technical specifications to off-shore programming team.
* ETL: Designed data export of Customer’s files, including technical specifications, SQL Server Tables, Stored Procedures, data encryption, data export and transportation to FTP site.
* Technical Writer: Wrote Technical Specifications and data layouts for Loss Mitigation Plans.
* Business Rules: Analyzed Customer’s Business Rules and created equivalent Business Requirements for web software development.
* Report Writer - Analyzed current fields in SQL Server Report Writer, compared with new Plans and determined fields to add to enable Customer to write reports against them using Report Writer.
* Other: SQL Server, MS Excel (VBA, macros), SSIS, SSRS, CollabNet, TeamForge, VendorScape, Banking and Mortgage industries.
JaCo Consulting, Business Analyst, Website Designer, Programmer, Louisville, KY, 04/2010 to 12/2010
Freelance Business Analyst on various projects.
* Web Design: Created website for Customer’s web presence (The Kircher Group); Updated Customer’s website to provide a fresh format (www.ChileMission.org).
* Design: Created Contact Management System (JobEx) with reminders (VBA, Excel, macros).
* Creativity: Designed “web-scraping” techniques to pull website data into Excel (VBA, macros).
* Other: HTML, Expression Web Studio, Excel (VBA, macros), FrontPage.
Aspect Software, Business Intelligence Analyst, Louisville, KY, 07/2008 to 01/2010
Business Intelligence Analyst on various team projects (formerly Quilogy).
* Technical Writer: Authored a 25 lesson training course for college instructors to teach their students (16 colleges on 68 campuses).
* ETL: Converted data for MicroSoft’s Amalga healthcare system (SQL, SSIS, MS Excel); Developed project plan to convert 110,000 documents from DocuShare into SharePoint using Nintex.
* Development: Created a complex Human Resources system (Agile, InfoPath, SharePoint).
* Web Development: Created a Web Site Provisioning System for a university in Louisville (SharePoint/MOSS, InfoPath, ASP, Use Case, SCRUM, Agile).
* Technical Writer / Training: Learned Nintex Workflows and became the “point man” for Nintex Workflow projects; Authored training materials for Nintex Workflows and used to teach 12 classes.
* Other: SharedView, TFS, Communication Skills.
Relocation to the United States, Temp Manufacturing Positions, Louisville, KY, 08/2006 to 07/2008
Various temporary positions after returning from mission to Chile.
* Assembly Line: Greenlee-Textron (Willstaff Worldwide).
* Dell Diagnostic Technician: Robert Half International.
* Inventory and Warehouse: International Moulding Company (MS Excel inventory system, VBA).
NWCC Chile Mission, Website Designer, Missionary, Santiago, Chile 01/2005 to 08/2006
Website designer and missionary on a mission team in Santiago, Chile.
* Web Design: Designed the mission’s website to provide information for visitors (FrontPage, HTML)
* Teaching: Designed lessons for English class and taught classes to attract people to the Mission.
* Administration: Performed administrative work for mission, including budgets, projections, expenses and others (MS Excel, MS Word, MS PowerPoint).
Thomson IP Management, Data Conversion Specialist, Business Analyst, Southfield, MI, 04/1995 to 10/2004
Lead Data Conversion Specialist and Business Analyst for ETL projects (formerly Master Data Center).
* ETL: Reverse-engineered legacy data conversion process into ProSpec Tool written in MS Access (VBA, ADO, SQL Server, DTS, Stored Procedures, T-SQL).
* Creativity: Wrote over 30 conversion and programming utilities that were used during the Data Conversion process (VB, VBA, COBOL, DOS, QuickBasic).
* ROI: Using the ProSpec tool, saved estimated $3,000 on a data conversion project by reducing conversion time by 75% and achieved similar time savings on all subsequent projects.
* Training: Trained other programmers on data conversion processes and techniques.
* Other: Data Junction (Pervasive), COBOL, VSS.
Computer Data Systems Inc, Business Analyst, Programmer, multiple locations, 12/1991 to 03/1995
Worked for the U.S. Government Department of Defense (DoD) on several contracts, which included the Defense Finance Account Service (DFAS-IN), The Tank Automation Command (TACOM-MI) and the Corps of Engineers (COE-MI).
* Business Analyst: At DFAS-IN (Fort Harrison, IN), Automated customer’s Base Pay, Recruitment and Allowance Systems.
* Logistics / Business Analyst: At TACOM-MI (Warren, MI), designed “Project Sword” to track physical inventories of M1-Abrams tanks as they moved from Production to Customer Site.
* ROI: At COE-MI (Detroit,MI), saved Customer $2,500 by recovering 6 weeks of data from a corrupt insurance file.
* Network Support: At COE-MI (Detroit, MI), provided short-term network support.
* Other: Confidential Security Clearance, Department of Defense (DoD), Database (Clipper 5, dBase III Plus, dBase IV), QBX (QuickBasic-PDS), TB (TurboBasic), MS Word.
Education
A.S. Degree in Information Systems ITT Technical Institute Indianapolis, IN, 1981 to 1983
B.S. Degree in Management Indiana Wesleyan University Indianapolis, IN, 1992 to 1993
Skills Summary
Industries: U.S. Army, U.S. Department of Defense, Government, Logistics, Distribution, Banking, Mortgage, Intellectual Property, Insurance, Freelancing, Consulting, Contracting.
OS: MicroSoft Windows (7, XP, NT, 2000, 98, 95), Windows Server, Novell Netware, Unix/Xenix.
MS Office: Word, Excel, PowerPoint, Access, Outlook, Visio, Expression Web Studio / FrontPage, InfoPath (7, XP, 2000, 97, 95).
Methodologies: Agile Methodology (Scrum, Sprint), Use Case, SDLC (Software Development Life Cycle).
Data Conversion: ETL (Extract-Transform-Load), Data Conversion, Data Mining, Data Migration, Data Analysis.
SQL Server: v2008, SQL usage (T-SQL / TRANSACT-SQL, Queries, Views, Stored Procedures, Triggers), DTS (Data Transformation Services), SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services / Report Builder), Enterprise Manager / SQL Server Management Studio, Access SQL Builder.
xBase: Access (VBA, ADO / Active Data Objects), dBase 3 Plus, dBase 4, FoxBase, FoxPro, Clipper.
xBasic: VBA (Visual Basic for Applications, Access, Excel, ADO / Active Data Objects), VB6 (Visual Basic), QBX (QuickBasic-PDS), TB (TurboBasic), PB (Power Basic).
Environments: MS SPS (SharePoint Server / MOSS 2007), VS (Visual Studio), TFS (Team Foundation Server), MS Virtual Server/VM/RD, SharedView, VSS (Visual SourceSafe), MS Amalga.
Programming: ASP (Active Server Pages Classic), HTML, MS FrontPage, VB / Visual Basic 6, VBA / Visual Basic for Applications.
Technical Writing: Ability to create training materials and to train both technical and non-technical staff.
Legacy Systems: COBOL (ISAM, VSAM, JCL), Assembler, IBM Mainframe, CMS (MVS, ISPF, ECHO, PANVALET, SYNCSORT, FILEAID, ABENDAID), QUIKJOB, EASYTRIEVE.
Miscellaneous: Reverse Engineering, VBScript, XML, Exposure to CollabNet and TeamForge, Bilingual (English/Spanish).
Louisville, KY 40065 * 502-220-8569 * [email protected]
Summary
Experienced Business Intelligence Analyst, specializing in analyzing complex business requirements and translating them into final solutions (BI, ETL, SQL, KPI, SSMS, SSIS, SSRS).
Technical Highlights
Industries: U.S. Army and Department of Defense, Logistics, Banking, Mortgage, Insurance.
Software: MicroSoft Office, SharePoint (MOSS), Visual Studio, SharePoint Designer, Nintex Workflows.
Languages: Visual Basic 6.0, Visual Basic for Applications, Active Server Pages, HTML.
Databases: SQL Server (v2008, Stored Procedures, SSIS, SSRS, T-SQL, MS Access, FoxPro.
Processes: ETL, Data Analysis, Data Mapping, ETL, Agile, Waterfall, Use Case, Functional Specifications.
Professional Experience
Red Carpet Inn, Front Desk, Louisville, KY, 12/2016 to 02/2017
Front Desk Clerk.
* Guest Reception, Check-In and Check-Out, Answering Telephones, Daily Activities, Reports.
Red Carpet Inn, Front Desk, Louisville, KY, 12/2016 to 02/2017
Front Desk Clerk (Guest Service Associate).
* Guest Reception, Check-In and Check-Out, Answering Telephones, Daily Activities, Reports.
DIMA, Customer Support Interviewer, Louisville, KY, 08/2016 to 10/2016
Interviewed agents and customers for online applications of life insurance.
* Interviewed insurance agents to obtain HIPAA information for life insurance applicants.
* Interviewed insurance applicants to verify HIPAA details and gather additional information about their health, medical and prescription histories.
* Worked with Medical Information Bureau (MIB) and underwriters to approve or deny the application.
Ryder Integrated Logistics, Business Intelligence Analyst, Georgetown, KY, 02/2015 to 06/2015
Worked on projects in support of Toyota transportation logistics systems.
* BI: Analyzed Logistics data using MS Access and MS Excel, gathered user requirements, performed data mining and validation.
* ETL: Developed system to import and export logistics data (using SQL, VBA and MS Access).
* SQL: Developed complex SQL Server Queries (SSMS) and Stored Procedures.
* KPI: Developed Dashboards, Score Cards and Reports (SRSS) to monitor driver performance.
SSB, Business Analyst, Lexington, KY, 08/2011 to 06/2014
Provided Business Analysis for ATLAS (Automated Transaction Logistics and Accounting System), a logistics system developed for the HQDA (Headquarters Department of the Army, U.S. Department of Defense).
* Requirements: Gathered user requirements, created “as-is” and “to-be” diagrams and Use Cases.
* Analysis: Reverse-engineered legacy FoxPro Logistics system (ECHO) into a web application (ATLAS).
* Design: Worked with the Development Team to redesign the legacy system as a web-based application.
* Agile: Utilized Agile and Waterfall Methodologies; participated in SCRUM sessions (JAD).
* Technical Writer: Designed and updated the User Guide.
* Other: DoD Secret Security Clearance, Use Case, Logistics, SharePoint (MOSS).
Core Logic, Business Analyst, Louisville, KY, 12/2010 to 04/2011
Analyzed mortgage products (Loss Mitigation, Foreclosure, Bankruptcy and Debt Collection) and provided technical specifications to off-shore programming team.
* ETL: Designed data export of Customer’s files, including technical specifications, SQL Server Tables, Stored Procedures, data encryption, data export and transportation to FTP site.
* Technical Writer: Wrote Technical Specifications and data layouts for Loss Mitigation Plans.
* Business Rules: Analyzed Customer’s Business Rules and created equivalent Business Requirements for web software development.
* Report Writer - Analyzed current fields in SQL Server Report Writer, compared with new Plans and determined fields to add to enable Customer to write reports against them using Report Writer.
* Other: SQL Server, MS Excel (VBA, macros), SSIS, SSRS, CollabNet, TeamForge, VendorScape, Banking and Mortgage industries.
JaCo Consulting, Business Analyst, Website Designer, Programmer, Louisville, KY, 04/2010 to 12/2010
Freelance Business Analyst on various projects.
* Web Design: Created website for Customer’s web presence (The Kircher Group); Updated Customer’s website to provide a fresh format (www.ChileMission.org).
* Design: Created Contact Management System (JobEx) with reminders (VBA, Excel, macros).
* Creativity: Designed “web-scraping” techniques to pull website data into Excel (VBA, macros).
* Other: HTML, Expression Web Studio, Excel (VBA, macros), FrontPage.
Aspect Software, Business Intelligence Analyst, Louisville, KY, 07/2008 to 01/2010
Business Intelligence Analyst on various team projects (formerly Quilogy).
* Technical Writer: Authored a 25 lesson training course for college instructors to teach their students (16 colleges on 68 campuses).
* ETL: Converted data for MicroSoft’s Amalga healthcare system (SQL, SSIS, MS Excel); Developed project plan to convert 110,000 documents from DocuShare into SharePoint using Nintex.
* Development: Created a complex Human Resources system (Agile, InfoPath, SharePoint).
* Web Development: Created a Web Site Provisioning System for a university in Louisville (SharePoint/MOSS, InfoPath, ASP, Use Case, SCRUM, Agile).
* Technical Writer / Training: Learned Nintex Workflows and became the “point man” for Nintex Workflow projects; Authored training materials for Nintex Workflows and used to teach 12 classes.
* Other: SharedView, TFS, Communication Skills.
Relocation to the United States, Temp Manufacturing Positions, Louisville, KY, 08/2006 to 07/2008
Various temporary positions after returning from mission to Chile.
* Assembly Line: Greenlee-Textron (Willstaff Worldwide).
* Dell Diagnostic Technician: Robert Half International.
* Inventory and Warehouse: International Moulding Company (MS Excel inventory system, VBA).
NWCC Chile Mission, Website Designer, Missionary, Santiago, Chile 01/2005 to 08/2006
Website designer and missionary on a mission team in Santiago, Chile.
* Web Design: Designed the mission’s website to provide information for visitors (FrontPage, HTML)
* Teaching: Designed lessons for English class and taught classes to attract people to the Mission.
* Administration: Performed administrative work for mission, including budgets, projections, expenses and others (MS Excel, MS Word, MS PowerPoint).
Thomson IP Management, Data Conversion Specialist, Business Analyst, Southfield, MI, 04/1995 to 10/2004
Lead Data Conversion Specialist and Business Analyst for ETL projects (formerly Master Data Center).
* ETL: Reverse-engineered legacy data conversion process into ProSpec Tool written in MS Access (VBA, ADO, SQL Server, DTS, Stored Procedures, T-SQL).
* Creativity: Wrote over 30 conversion and programming utilities that were used during the Data Conversion process (VB, VBA, COBOL, DOS, QuickBasic).
* ROI: Using the ProSpec tool, saved estimated $3,000 on a data conversion project by reducing conversion time by 75% and achieved similar time savings on all subsequent projects.
* Training: Trained other programmers on data conversion processes and techniques.
* Other: Data Junction (Pervasive), COBOL, VSS.
Computer Data Systems Inc, Business Analyst, Programmer, multiple locations, 12/1991 to 03/1995
Worked for the U.S. Government Department of Defense (DoD) on several contracts, which included the Defense Finance Account Service (DFAS-IN), The Tank Automation Command (TACOM-MI) and the Corps of Engineers (COE-MI).
* Business Analyst: At DFAS-IN (Fort Harrison, IN), Automated customer’s Base Pay, Recruitment and Allowance Systems.
* Logistics / Business Analyst: At TACOM-MI (Warren, MI), designed “Project Sword” to track physical inventories of M1-Abrams tanks as they moved from Production to Customer Site.
* ROI: At COE-MI (Detroit,MI), saved Customer $2,500 by recovering 6 weeks of data from a corrupt insurance file.
* Network Support: At COE-MI (Detroit, MI), provided short-term network support.
* Other: Confidential Security Clearance, Department of Defense (DoD), Database (Clipper 5, dBase III Plus, dBase IV), QBX (QuickBasic-PDS), TB (TurboBasic), MS Word.
Education
A.S. Degree in Information Systems ITT Technical Institute Indianapolis, IN, 1981 to 1983
B.S. Degree in Management Indiana Wesleyan University Indianapolis, IN, 1992 to 1993
Skills Summary
Industries: U.S. Army, U.S. Department of Defense, Government, Logistics, Distribution, Banking, Mortgage, Intellectual Property, Insurance, Freelancing, Consulting, Contracting.
OS: MicroSoft Windows (7, XP, NT, 2000, 98, 95), Windows Server, Novell Netware, Unix/Xenix.
MS Office: Word, Excel, PowerPoint, Access, Outlook, Visio, Expression Web Studio / FrontPage, InfoPath (7, XP, 2000, 97, 95).
Methodologies: Agile Methodology (Scrum, Sprint), Use Case, SDLC (Software Development Life Cycle).
Data Conversion: ETL (Extract-Transform-Load), Data Conversion, Data Mining, Data Migration, Data Analysis.
SQL Server: v2008, SQL usage (T-SQL / TRANSACT-SQL, Queries, Views, Stored Procedures, Triggers), DTS (Data Transformation Services), SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services / Report Builder), Enterprise Manager / SQL Server Management Studio, Access SQL Builder.
xBase: Access (VBA, ADO / Active Data Objects), dBase 3 Plus, dBase 4, FoxBase, FoxPro, Clipper.
xBasic: VBA (Visual Basic for Applications, Access, Excel, ADO / Active Data Objects), VB6 (Visual Basic), QBX (QuickBasic-PDS), TB (TurboBasic), PB (Power Basic).
Environments: MS SPS (SharePoint Server / MOSS 2007), VS (Visual Studio), TFS (Team Foundation Server), MS Virtual Server/VM/RD, SharedView, VSS (Visual SourceSafe), MS Amalga.
Programming: ASP (Active Server Pages Classic), HTML, MS FrontPage, VB / Visual Basic 6, VBA / Visual Basic for Applications.
Technical Writing: Ability to create training materials and to train both technical and non-technical staff.
Legacy Systems: COBOL (ISAM, VSAM, JCL), Assembler, IBM Mainframe, CMS (MVS, ISPF, ECHO, PANVALET, SYNCSORT, FILEAID, ABENDAID), QUIKJOB, EASYTRIEVE.
Miscellaneous: Reverse Engineering, VBScript, XML, Exposure to CollabNet and TeamForge, Bilingual (English/Spanish).