We provide IT Staff Augmentation Services!

Systems Consultant Resume

2.00/5 (Submit Your Rating)

Dayton, OH

SUMMARY:

  • Project Management.
  • Business Analysis (document business processes, define process standards and performance metrics, define software system requirements),
  • Data Analytics (analyze data, process mining, identify process improvement opportunities, create dashboards to measure process performance and KPIs)
  • Six Sigma and Continuous Improvement (identify and eliminate wastes, do root cause and pareto analysis of failures, VOC, QFD, SIPOC, control charts, A3, 5S, FMEA, Design of Experiments with Systems Simulation),
  • Business Architecture (design to be process models),
  • Software Development (implement processes improvements through applications development, enterprise systems integration, application of business rules, algorithms, messaging etc.)
  • Perform software and system testing

TECHNICAL SKILLS:

Business Analysis: Business Case and ROI, Process Mapping (BPMN), Process Design (Visio, ARIS), Six Sigma (Green Belt), Functional and Nonfunctional Requirements, Use Cases, Test Case Development.

Development Methodologies: Agile, Waterfall, Microsoft Solutions Framework

Application Architecture: OOAD, UML, Aris UML Designer, Design Patterns (SOA, Client - Server, n-tier etc.), ESB.

Performance Monitoring: Precise 9.01 for Web, .NET, J2EE, Oracle and Precise for SQL Server.

IDEs & Utilities: Microsoft Visual Studio Ultimate 2013/2012 and Team Foundation Server 2013.

Version Control: Microsoft Team Foundation Server, SVN and SCCS (Unix)

Languages: C #, ASP .NET, C, C++, Java, SQL, PL/SQL, SQL Plus, HTML, XML, CSS, Java Script.

Distributed Computing: Cloud Computing, Web Services, Windows Services, Sockets, Messaging (Service Broker, MSMQ), FTP, Transactions, Multi-threading and Event based programming.

Databases Design, Implementation & Programming: SQL Server 2012/2008, Oracle 10g and IBM DB2. Requirements, Logical and Physical Design, Database objects (Tables, keys, constraints, indexes, triggers etc.), Database Programming (T-SQL, Stored Procedures, Functions, Transactions etc), Service Broker.

Database Tools: SQL Server Management Studio, Toad.

Testing: Microsoft Test Manager 2013, Functional, System & End-to-End testing using HP QC, UFT, AQT.

Business Intelligence: Business Performance Monitoring (Score Cards, KPI, Dashboards), Data Analytics (DSS, Optimization, Statistical Analysis, Data Mining, Data Visualization, GIS).

Databases Infrastructure: SQL Server 2012 & 2008 - Administration Installation, configuration, Backup, Recovery, Logs, Maintenance, Performance Monitoring and Optimization.

Operating Systems: Windows 10/8/7, XP, Windows Server 2012, DOS. UNIX Red Hat Linux, System V, Sun Solaris. Mainframe & Other MVS, TSO, Clist, SKELS, JCL and ISPF. AS400.

PROFESSIONAL EXPERIENCE:

Confidential, Dayton, OH

Systems Consultant

Responsibilities:

  • Provide strategic planning, project management, process design and software implementation services on a contract basis to clients.
  • Customers include Government, global Fortune 500 companies in the Financial Services, Legal,, Automated Materials Handling, Manufacturing and Supply Chain industries.

Confidential, Fort Wayne, IN

Software Automation and Test Engineer

Responsibilities:

  • Worked on the WinT - RPS project comprising of Mircrosoft and General Dynamics Software Engineers in a Scrum environment to develop, implement and test automation software to provision virtual machines.
  • Technologies include Windows Power Shell run books, C#, SQL Server 2012, Windows Server 2012, Visual Studio 2013 and Microsoft Team Foundation Server 2013..
  • Tasks include Sprint Planning, daily Scrum meetings, writing code as per user stories, updating Scrum board on progress, unit testing, integration testing, branching and merging code into TFS, doing code review and updating software based on reviews.

Confidential, Cincinnati, OH

Test Architect

Responsibilities:

  • Worked with projects run in an Agile as well as Waterfall environment.
  • Analyzed project plans, Business Requirements Documents, Functional Requirements Documents, Application Architecture documents to scope the work for functional and API testing.
  • Reviewed test plans, test cases and approved RTMs from analysts working on the projects.
  • Tested customer facing web applications (Direct, eCentral, Vantiv iQ), mobile applications (Mobile Card Services, Vantiv Mobile Checkout), cloud based SaaS applications (Bolt, ATT, i.e. CRM applications built with Sales Force for customer, merchant or financial institutions on-boarding), client server applications (thick clients like Direct for financial institutions to view and research customer transactions) and legacy mainframe systems (for credit, debit, sales transaction processing via the networks such as Tandem and RAFT), mainframe systems for settlement processing (Bank Card Issuer, Bank Card Acquirer), Fraud Analytics (using SAS engine to detect fraud transactions), Mainframe Reporting Systems (Dialogue)
  • Worked with tools such as HP’s Quality Center, HP’s UFT, STARC, Visual Studio 2010, TFS, SQL Server 2008, DB2, AQT, Rally, Visio, MS Office, Share Point, and MS Project.

Confidential, Dayton, OH

Technical Account Manager

Responsibilities:

  • Responsible for on-site technical services and management of the $ 600K plus account for Precise Software. Worked with the client’s global team to deploy and manage Precise software and agents on hundreds of servers in a federated environment to monitor, manage and improve end-to-end application performance of complex customer facing and backend middleware systems running in high availability clustered environments on Windows and Linux platforms.
  • Interfaced with Lexis Nexis business units personnel to understand application architecture, define and write business and performance requirements, design Precise deployment plan, install, configure and setup Precise software on web servers such as ASP .NET, Apache and Web Sphere, application servers running Microsoft .NET, J2EE, Oracle’s Web Logic, Oracle Service Bus, database servers such as Microsoft SQL Server and Oracle
  • Interfaced with the Precise Network Operations Control staff in Boston, to open or manage cases and technical issues associated with real-time monitoring of Precise servers. Built custom reports, setup alerts based on SLAs, carried out analysis to understand and diagnose application performance issues using Precise for Web, .NET, J2EE, SQL Server and Precise for Oracle and made presentations to customers. Worked with Precise Engineering to resolve level 2 and 3 application support issues

Confidential, Memphis, TN

Technical Project Manager

Responsibilities:

  • Business and functional requirements definition for interfaces between OneSource (an ERP system) and an IBM mainframe system for inventory, purchase orders and vendor information. Held extensive requirements definition meetings with users, Confidential IT teams (applications development and infrastructure support) and created requirements documents.
  • Project planning with Celero Partners, Confidential IT and Shelby County IT teams for implementing a data warehouse and business intelligence solution (OtisEd iMart) for the combined Confidential and Shelby County School districts. Reviewed RFP and Project Proposal, worked on the development of Project Charter and Project Management Plan. Analyzed KPIs and Dashboards.

Confidential, Indianapolis, IN

WCS Project Engineer

Responsibilities:

  • Responsible for implementing Middleware to control the transport and routing of products in the warehouse via Intelligrated's automated materials handling system (InControlware). Worked with the customer and Intelligrated's Engineering team (Mech., Elect. & Software Controls) to create the description of operations and functional requirements.
  • Created project plans for software implementation. Collaborated with other vendors (Muratec Inc. and TGW Cranes), Intelligrated's Controls Engineers and client’s IT team members. s include requirements completion, successful middleware design using UML, software development,
  • Project was completed on-time and on budget. Overall Project size was over 2 million dollars. Skills: Project Management (planning, tracking hours & dollars), Operations Analysis, Software Engineering and IT. Technologies include C#, SQL Server 2005, ICW libraries, XML, Service Broker, SQL Server Reports (SSRS), VS 2008, SVN, MS Project, Visio, MS Office, AutoCAD Viewer.

Confidential, Dayton, OH

IS Manager

Responsibilities:

  • Setup project plans for the various IS projects and prioritized project portfolio.
  • Identified reporting needs and wrote requirements for the purpose of setting up the reporting infrastructure for the joint venture company using SQL Server 2005.
  • Designed a data mart and implemented physical design as proof of concept.
  • Worked with Confidential Data Warehousing team to perform ETL tasks and uploaded Product Master, part pricing and sales data.
  • Designed and created monthly sales reports using SQL Server 2005 and SSRS.
  • Worked with Architecture and Network Administration to design a network for CTCT consisting of Windows Server 2003, ISA Server, IIS, SQL Server, Share Point Services & SSL. Coordinated Trimble resources to implement infrastructure.
  • Conducted Business Process Reengineering of the order processing function via process mapping (UML and Visio) and Six Sigma. Led CTCT and Trimble’s teams on the project.
  • Solved communication and collaboration problems between employees by using a web based architecture consisting of Share Point Services 2003 and SSL.
  • Managed construction of a Customer Support site for the Product Support Dept.
  • Formulated policies and procedures and managed an annual IS budget of $ 250,000.

Confidential, Dayton, OH

Lead Systems Engineer

Responsibilities:

  • Developed the business requirements, architected, developed and implemented an enterprise real-time system using SOA to display thousands of shipments, in containers, service centers and onboard flights & trucks.
  • Project team consisted of on-site as well as off-site development staff. Managed the development of the Official Airline Guide application, a web based system for Sales and Marketing
  • Designed and implemented intranet web reports that accessed data warehouse and OLTP production databases. Reports are used by Worldwide Operations, i.e.
  • Service Center personnel and Executive Management to track performance and shipment exceptions. Collaborated with external contractors and vendors and integrated an in-house Menlo
  • Worldwide Aircraft Load Planning System with the vendors FAA approved Load Planning Systems, thereby streamlining workflow, eliminating duplicate data entry and ensuring mission critical data accuracy to ensure safe loading of aircraft. Created Tailsheets for flights from the DB2 database using Excel, Microsoft Office object model for Excel, VBA, COM, stored procedures in DB2 and DB2 Connect. Supported and maintained intranet, client-server and desktop systems (tier 2 & 3 support).
  • Technologies include VB .NET, ADO .NET, COM proxies, Oracle 8, PL/SQL, SQLPLUS, SQL Server, T-SQL, DB2, Brio, Excel, IIS, Visual Interdev and Visual Studio IDE.

Confidential, Dayton, OH

Sr. Systems Engineer

Responsibilities:

  • Project Lead responsible for the operations, maintenance, implementation of new business rules, upgrades & providing support to end users for the Crew Payroll application. Payroll $ 35 million/year
  • Worked in a team of six developers to elicit requirements, design, develop, test and produce a prototype decision support system to enable Operations to plan the routing of the aircraft at minimal cost.
  • Did requirements, design and development of a Crew Scheduling web site to communicate available bids to the pilots. Technologies include 3 tier architecture with VB6 for
  • Windows clients, C, C++, Java and CPLEX for implementing the optimization engine, Oracle 8 database, PL/SQL for database business rules, SQL scripts for ETL and UNIX make files for build scripts.

We'd love your feedback!