SUMMARY:

Positions and projects in boutique consulting, software, construction, cable/telecomm, manufacturing, and health care. Extensive experience in customer facing projects and positions in high profile companies, serving as implementation manager, project manager, and business/requirements analyst. Functional positions as IT manager, sales support repre­sentative, implementation technician, pro­grammer, and classroom instructor/trainer.

CORE COMPETENCIES:

• executing high risk/high profile implementations, conversions, and development projects creating/modifying table, forms, queries, macros, and reports developing detailed project proposals, plans, budgets, and metrics performing full SDLC development, including project management, requirements analysis, modeling, and coding applications by performing “client facing “ interviews to determine status of current applications (“as - is” state) performing gap analysis and requirements analysis to determine, recommend, and plan development and/or modification of applications (“to-be” state) developing data maps, models, and entity relationship diagrams to verify and communicate design specifications working with existing staff and contractors to effect development and modification of applications developing testing and validation plans specifying tight requirements to speed development and reduce defects validating progress for accuracy and completeness to improve overall end user satisfaction evaluating business processes to ensure alignment with business and IT strategies and standards using UML diagrams to depict use cases, states, activities, collaborations, and deployments black box\white box decomposition of existing applications performing data mining/data analysis/reporting using standard tools (Excel/Access/VBA/cubing) using RUP, XP, RAD, Waterfall, and Agile development and tools evaluating vendors and preparing ROI analyses and recommendations to management implementing and supporting OTS/ Confidential ERP packages

TECHNICAL & METHODOLOGICAL CAPABILITIES:

• RDBMS packages (MS Access, MS SQL Server, Pervasive, Oracle), including design, development, and administration, plus legacy RDBMS packages (dBase, RBase, Paradox, FoxPro)
• MS Office/Office365 (MS Access/MS Excel/MS Word) with extensive ODBC and VBA utilization
• Visual Basic for Applications (VBA and VB) to support MS Office suite applications
• UML modeling and design, plus project control tools (MS Visio, MS Project, Enterprise Architect)
• Agile, RAD, SCRUM, and RUP procedural techniques and tools (Caliber, Rational, Rally, JIRA)
• SSIS, SSAS, SSRS, SSMS, ETL processes, Crystal Reports, Business Objects, Subversion
• Confidential ERP and CRM packages, both current and legacy (CMS, Lawson M3, Merge, others) exposure to ICP9/10 and HCPCS coding; medical billing coding exposure to healthcare applications (Corepoint, Fluency/M*Modal, Speec hQ, TriMed, Merge)

PROFESSIONAL EXPERIENCE:

Confidential, Denver, CO

IT consulting

Responsibilities:

• formed upon my return to Denver to work with old and new clients work can be performed on a W2/1099/corp-to- corp basis through staffing firms or directly with client retained to develop application to reduce reporting backlog; undocumented process; "SME" had 2 months experience in role when I joined the effort used RAD/Agile techniques to upsize an Excel app to SQL Server backend and Access frontend; used SQL Server ETL tools to refine table structures produced test templates in 60 days, production reports a week later documented process using Visio

Confidential, Salem, OR

Responsibilities:

• retained to document Confidential DOS current application(minimally documented), with developer(s) no longer available documented database schema, menus, reports, labels, indexes, batch jobs, and command files converted R:BASE-based proprietary application which processes mental health assistance claims conversion from Confidential DOS version to To-Be Windows version to allow the app to run on Windows7 converted batch processes converted ETL’s from/to external systems, both mainframe and PC based effected primarily remotely

Confidential, Greenwood Village, CO

Responsibilities:

• used proprietary software to extract data from existing Confidential package for conversion used Access macros and VBA to transform extracted data for new Confidential package used Excel macros and formulas to prepare existing data for loading into new Confidential package effected primarily remotely

Confidential, St. Louis, MO

Responsibilities:

• BA retained in an Agile/SCRUM group maintaining online and mobile applications to improve user experience (UX) developed an understanding of the business process, business flow, data flow and business rules in order to translate them into crisp business requirements and technical system specs wrote user stories and test cases using Rally participated in testing and releases participated in standups, backlog grooming, release planning, and sprint demos, reviews, and retrospectives

Confidential, Columbus, OH

Responsibilities:

• Retained to use SQL Server Management Studio and Confidential to data mine multiple applications used Excel, Access, Crystal Reports, T-SQL, and SQL Server Reporting Services to report to “C/D” level executives developed complex table joins to accomplish selects, updates, deletes, and inserts utilized Power Pivot and cubing evaluated Tableau as a replacement for Excel presentations

Confidential, Columbus, OH

Responsibilities:

• BA retained in an Agile/SCRUM group developing and maintaining online and back office applications primary responsibility was to cover for non-US citizens during their extended trips home

Confidential, Marysville, OH

Responsibilities:

• Used Excel and VBA to convert raw dynamometer data to executive level charts and graphs resource reallocation resulted in abandonment of project

Confidential, Columbus, OH

Responsibilities:

• BA retained to evaluate a project which had taken 4+ years without reaching completion milestones reviewed conversion of receivables collection process from Excel to SQL Server/Access by reverse engineering 20+ Excel workbooks to create unified Access front end linked to SQL Server backend reviewed numerous stored procedures and Visual Studio used for ETL/DTS/SSIS functionality

Confidential, Urbana, OH

Responsibilities:

• BA retained to review 12 mission critical Access 2007 applications in view of company-wide conversion to Win7/Office 2010 prepared effort estimates for conversion of over 200 Access/Excel/Word-based applications focused primarily on VBA and macro compatibility issues plus Office integration issues resulting from potential file type/extension changes in Office 2012 as firm partner, primary responsibilities and experiences included: creating, developing, and modifing specialized applications and utility programs leading, communicating, influencing, and negotiating with clients and teams; collaborating with supporting resources across business and/or functional lines utilizing both oral and written methods; facilitating and participating in meeting and work sessions; working independently and as part of a team; managing time and resources to meet multiple concurrent deadlines;
• prioritizing activities based on elicitation of system and/or user requirements; planning, problem solving, and decision-making based on organizational and analytical skills.
• projects were performed on W2/1099/corp-to- corp basis through staffing firms or directly with client developed operational SSRS reports unavailable in the ERP package being implemented researched a partially documented (no data model or ERD diagram), non-normalized Confidential package containing 3500 tables to overcome limitations of the internal report writer evaluated existing Excel-based market forecasting tools in view of conversion to Access effected enterprise level functional analysis and preliminary functional decomposition of existing apps effected functional decomposition of existing Access-based applications developed specs to port apps to an Oracle/.NET platform designed outputs to replace Excel/Word reports and mail merges