Quality Assurance Analyst - Data Warehouse @ Case Technical Solutions
B.A., Computer Science @
Texas Lutheran University
I am a Quality specialist with detailed experience in a broad range of system and software development lifecycles and methodologies. I have substantial experience in data analysis and reporting, relational database design, data warehousing, and data extract, transform and load (ETL). I also have demonstrated expertise in continuous process improvement, including Lean Enterprise PDCA, Six Sigma DMAIC,
I am a Quality specialist with detailed experience in a broad range of system and software development lifecycles and methodologies. I have substantial experience in data analysis and reporting, relational database design, data warehousing, and data extract, transform and load (ETL). I also have demonstrated expertise in continuous process improvement, including Lean Enterprise PDCA, Six Sigma DMAIC, statistical process control, and quantitative project management. I posses strong analytical skills, am self-motivated and self-disciplined, with exceptional attention to detail and excellent communication skills.
My Specialties Include:
Database Development: SQL Server (2008 R2, 2012, 2014): SSMS, SSIS, T/SQL; MS-Access; Oracle 10g: SQL*Loader, SQL*Plus, PL/SQL, TOAD.
Data Analysis/Reporting: MS-Excel, Business Objects XI Release 2 (Designer, Reporter/Desk Intelligence, Info View, Web Intelligence), Minitab.
Quality/Process Models: ISO 9001:2008, ISO 13485:2003, AS9100 Rev C, CMMI V1.3, Six Sigma DMAIC, Lean Enterprise.
Languages: SQL, Visual Basic for Applications, Unix shell scripting (Korn, C).
Environments: Visual Studio/TFS, SharePoint/TeamCenter, Rational ClearCase/ClearQuest, DOORS, Apex.
Program Management: ServiceNow, HP Service Manager, Rational ClearCase/ClearQuest, DOORS, Open Plan, MS-Project.
Data Warehouse Developer @ Within the Analytic Center of Excellence; responsible for the full lifecycle of Business Intelligence development including requirements gathering, analysis, designing, writing, maintaining and deploying EDW/BI objects including extracts, queries and cubes for the purpose of enterprise analytical reporting. From August 2015 to Present (5 months) Quality Assurance Analyst - Data Warehouse @ QA Analyst: Responsible for the validation of application and system changes supporting Univita’s data warehouse implementation: the Enterprise Reporting Model (ERM). Established Test and QA environments for validating changes and managing production deployments. Developed complex SQL scripts for validating ERM entity consistency, providing deployment validation and regression testing capability. Developed and executed test strategies and scenarios for validating the loading of health plan enrollment (EDI 834) and medical claim (EDI 837I, 837P) data received in a variety of standard and proprietary formats.
Production Support: Provided daily monitoring for a variety of scheduled database backup/restore, ETL, and data feed jobs, providing status to key stakeholders. Responsible for analyzing failures and quickly initiating corrective actions to restore the production environments. Established dedicated Production Support environment for developing, testing and validating corrective actions.
KEYWORDS: SQL Server: SSMS, SSIS, T-SQL, ETL; EDI (834, 837I, 837P), Visual Studio/Team Foundation Service; ActiveBatch From December 2013 to July 2015 (1 year 8 months) Quality Assurance Analyst - Data Warehouse @ QA Analyst: Reponsible for the testing and validation of application and system changes supporting Univita's Data Warehouse applications and products (contract position with transition to direct). From September 2013 to December 2013 (4 months) Senior Mission Assurance Engineer @ Continuous Improvement Lead: Responsible for managing and facilitating Armament Systems Division’s execution of the Performance Enterprise System (PES), ATK’s adaptation of the Toyota Production System. Developed and maintained tools, processes, and data repositories supporting ASD’s continuous improvement portfolio and initiatives: Kaizen initiatives, continuous improvement projects, lessons learned, Failure Reporting Analysis & Corrective Action (FRACAS), and 8-D problem solving. Designed and delivered division-wide PES, Six Sigma and Lean training. Participated in preparing for and conducting audits to ensure continued compliance to AS9100C and CMMI standards.
KEYWORDS: Continuous Improvement, TPS, Six Sigma, Lean, AS9100, CMMI, MS-Excel, Visual Basic, MS-Access, SQL, SharePoint. From January 2010 to August 2013 (3 years 8 months) Staff Software Engineer @ Software Metrics Lead: Established and maintained project-level Oracle measurement repositories. Designed, tested, and deployed data extraction, transformation and load (ETL) mechanisms. Performed statistical analysis in support of project management and process improvement objectives. Developed and delivered Business Intelligence reporting capabilities to support project management and customer measurement and analysis requirements.
Software Process Manager: Developed and maintained the process suite supporting the Software Product Development Team. Identified, implemented, and evaluated process improvement opportunities. Designed and delivered training to engineers and managers on process improvement initiatives. Assembled and managed evidence of process implementation and compliance to support SEI CMM/CMMI and ISO appraisals.
KEYWORDS: CMM, CMMI, Statistical Process Control, Minitab, IBM ClearQuest, DOORS, SEER-SEM, BusinessObjects, Oracle, SQL, SQL*Loader, Korn Shell, Visual Basic, SunOS, Linux Redhat. From April 2000 to August 2009 (9 years 5 months) Software Section Chief @ HQ Air Force Personnel Center, Randolph AFB, TX
Team Lead: directed the software development and maintenance activities for two critical personnel systems; supervised 6 programmers, with responsibility for 1,210 software elements spanning 20 software languages.
Y2K Project Manager: coordinating activites for a 65-member team in renovating and certifying legacy personnel systems.
Lead Software Engineer: for overhaul of contractor-delivered configuration management subsystem.
Systems Analyst: primary government technical representative on a $3 million computer system enhancement project.
Database Administrator: served as primary Ingres database administrator, as well as principal system and security administrator for $1 millon worth of computer resources.
Customer Support: primary analyst supporting 24-hour, world-wide support for legacy system operations.
KEYWORDS: Ada, Korn Shell, SQL, COBOL, Assembler, Pascal, C, Ingres, Unix, ULTRIX, OSF/1, CADRE Teamwork and Knowledgeware CASE Tools, DECStation 3000/5000, Unisys 1100/2200/ClearPath, Burroughs 2900/3900. From February 1989 to April 2000 (11 years 3 months) Software Development Engineer @ HQ European Communications Division, Ramstein AB, Germany
Systems Analyst: lead analyst on project to field prototype command-and-control system; conducted user interviews, wrote technical specifications, performed software QA, conducted end-user training.
KEYWORDS: Model 204, IBM 4361, Zenith Z-248, IBM 3270 PC. From February 1986 to February 1989 (3 years 1 month) Computer Software Specialist @ Air Force Satellite Control Facility, Sunnyvale AFS, CA
Lead Software Engineer: researched, designed, co-wrote, and deployed a comprehensive Management Information System. Developed a presentation graphics package; adopted by numerous Air Force and Navy agencies.
KEYWORDS: BASIC, Pascal, JOVIAL, DBase, Zenith Z-100/150. From November 1984 to February 1986 (1 year 4 months) Computer Programmer @ Air Force Flight Test Center, Edwards AFB, CA
Programmer/Analyst: responsible for analysis, design, and implementation of two separate database conversion projects. Developed numerous graphical data analysis tools and presentation applications.
KEYWORDS: FORTRAN, BASIC, System 2000, CDC 740, Tektronix 4151/4164, Zenith Z-100. From June 1980 to November 1984 (4 years 6 months)
M.A., Computer Resources, Human Resources Development @ Webster University From 1997 to 1999 B.A., Computer Science @ Texas Lutheran University From 1989 to 1992 James Lindborg is skilled in: Lean Tools, Six Sigma, Continuous Improvement, Data Analysis, Database Design, SQL, Business Intelligence, Data Warehousing, ETL Tools, CMMI, AS9100, Business Objects, Minitab, SPC charts, Process Improvement
Looking for a different
Get an email address for anyone on LinkedIn with the ContactOut Chrome extension