We provide IT Staff Augmentation Services!

Contractor Solutions Architect Resume

PROFESSIONAL SUMMARY:

Technical Business Systems Analyst with over ten years leadership experience managing database - driven application design and development projects, products and services. Roles have included client-facing requirements gathering, presentation delivery, and development of acceptance criteria, user training and support. Internal roles have included project scoping, estimating, documentation, testing, packaging and deployment. Proven ability to implement multiple small and large-scale projects from requirements gathering to user acceptance. Strengths include strategic planning, creativity, integrity and strong business acumen. Environments include Agile, Lean, Six Sigma, Traditional, and a mixture of above.

SPECIFIC EXPERTISE:

  • Reports directly to executive or C-level management as well as production staff.
  • Analysis and design, reporting, problem solving, strategic thinking, production support and leadership management skills including vendor, employee and customer relationship management.
  • Experience with value-stream mapping, production scheduling, and workflow solution design.

TECHNICAL SKILLS:

Tools: MS Office Including Microsoft Visio, Access, Excel, PowerPivot, Data Analysis Toolkit, SharePoint, InfoPath, Adobe Creative Suite, Crystal, Currently studying SSRS SSIS, Hadoop for Big Data Certification

Methodologies: Traditional WBS, Agile, Lean, BABOK, Six Sigma

Languages: VB, SQL, VBA, JAVA(course in progress)

Frameworks: .Net 2.0 - 4.0

Application Server: SharePoint 2007-2010, SAS

Databases: MS Access, MS SQL, Oracle Reporting, Hadoop

Operating Systems: Windows, Mac, CICS, Unix, Linux

PROFESSIONAL EXPERIENCE:

Confidential

Contractor Solutions Architect

Responsibilities:

  • Gathered requirements for a new software development project in an MDM (master data management) department lacking clear documentation and data governance. Conducted meetings, authored artifacts, set timelines.
  • Solely responsible for the design and development of a new automated validation and integration system designed to replace manual data entry to CICS mainframe.
  • Roles included documentation, design, use cases, test cases, development, testing, implementation, and support of new (front-to-back end) system.

Tools: VBA, Access 2010, CICS, SQL, Microsoft Visio, SharePoint.

Confidential

Production Data Business Analyst

Responsibilities:

  • Reporting directly to plant manager, maintained over 30,000 database objects for 1,519 users across five focus factories with 11 departments in a live production environment for vehicle manufacturing.
  • Created feature enhancements and break-fixes for applications for engineering, production scheduling, safety EH&S, invoicing, issue tracking, HR, EH&S training, inventory, purchasing, and logistics.
  • Solely responsible for the design, development and migration of MS Access solutions and workflows for product manufacturing to SQL Server.
  • My roles included the requirements gathering, design, use cases, test cases, development, testing, support of UX and backend database applications, ad hoc reports and queries, macros and modules.
  • Conducted RCI events to support Lean Continuous Improvement concepts in a Manufacturing environment. 5S, Kanban, and Value Stream Mapping
  • Created aggregated project tracking system using SharePoint across 5 US campuses locations.

Tools: VB.Net, Oracle 11, ETL, Access 97 - 2007, SQL, SSRS, Microsoft Visio, SharePoint.

Confidential

Project Leader / Data Analyst / BA

Responsibilities:

  • Reporting to the Vice President of Capacity Planning, Enterprise Resource Organization.
  • Roles included exporting, analyzing and reporting big data from Clarity Portfolio Project Management into SQL Server 2012. Transformed data and connected through PowerPivot to Excel for modeling supply and demand of internal resources.

Tools: used: SharePoint, PowerPivot, Excel, PowerPoint, Data Analysis Toolkit, Access, Clarity, ETL.

Confidential

Consultant

Responsibilities:

  • Designed, developed and installed a new permit-tracking system for EH&S (safety) department at 15 Ethanol manufacturing plant locations to comply with new OSHA requirement using Access, VBA and SQL.
  • Created new model for the Treasurer to forecast corporate liquidity.
  • Created live data collection system to feed new forecasting model on SharePoint 2010 with InfoPath.

Confidential

Math / Stats Tutor / PM

Responsibilities:

  • Tutored graduate and undergraduate math and statistics students.
  • Analyzed the tutoring center data against academic performance metrics to derive value of tutoring center.
  • Designed and implemented system for recruiting new students from the University web site using Type-03 and SalesForce.com workflows.

Confidential

Consultant AE / PM

Responsibilities:

  • Managed sales, marketing, event planning and post-sales support on Microsoft SharePoint custom software development projects.
  • Managed vendor relations with Microsoft Gold Partnership program.
  • Managed SharePoint Project Management system and SalesForce.com CRM.
  • Generated largest sales portfolio in company history, in addition to a single sale of $600,000.

Confidential

Information Security Grad Internship

Responsibilities:

  • Developed two new workflows for identifying the sources of vulnerabilities in a financial credit card processing firm.
  • Documentation of internal processes for Confidential Audit.
  • Results: Confidential Compliance granted in April 2009.

Confidential

Project Manager AE / BA

Responsibilities:

  • Managed sales, marketing, event planning and post-sales support on Microsoft SharePoint custom software development projects.
  • Designed and developed new product for brand extension to include barcode triggered workflows.

Confidential

Consultant / PM

Responsibilities:

  • Client-facing account executive, gathered requirements, developed statement of work, acceptance requirements, and project documentation.
  • Managed sales, marketing, event planning and post-sales support on Microsoft SharePoint custom software development projects.
  • Managed vendor relations with Microsoft Gold Partnership program.

Confidential

General Manager

Responsibilities:

  • Managed sales, vendors, service department, parts, and operations.
  • Created and managed Information Technology infrastructure.
  • Created the most advanced demonstration system in Canon’s Independent Dealer Network of 2,500 dealers.

Sales Manager

Confidential

Responsibilities:

  • Developed sales and marketing strategies to increase revenue in a declining economy
  • Increased revenue by going deeper and wider in entertainment
  • Maintained quota of $50,000 per month in hardware and software sales by adding new business sectors.

Hire Now