Lloyd Stewart

ad429i@r.postjobfree.com

804-***-****

TECHNICAL SKILLS

SQL Server

MS Access and Excel development VBA

Microsoft Dynamics AX

Agile

MDM Data Lead

SQL Server

Oracle

Data warehousing

Sybase and Citrix

SharePoint Development

Web analysis and development

ERP System life cycle development

Business Process Design

Business process re-engineering

System Testing

BODS

Technical Business Analyst

PowerPoint

SAP Data Migration

DB2/SQL Server

Cobol

PROFESSIONAL EXPERIENCE

Amazon 9/2021 to Present

• Use Scanner to process orders•

Data Analyst, DBHDS (Contract) 2/2021 to 1/2022

• Gather requirements for DOJ Projects

• Update short term data needs

• Prepare data to be reported in Tableau

• Identify data validity issues for various Project Managers

• Development in Power BI

Technician, DSV Dupont Films (Contract) 7/2020 to 2/2021

• Prepare film roll for shipping.

• Update rolls in SAP

• Prepare Labels and documentation for Tejin film rolls.

Sr. System Analyst, The Geo Group (Contract) 12/2017 to 11/2019

• Diagram current processes and proposed modifications using process flows, context diagrams and data flow diagrams of patient rehab results and drug arrest and outcomes.

• Discover and document requirements and user stories with a focus on improving both business and technical processing

• Designed and implemented Clinical data to new platform for vendor

• Utilize progressive elaboration; map stories to technical design specifications to be used by internal staff to develop the system modifications for Clinical billing

• Identify and group related user stories into Themes, document the dependencies and associated business processes

• Assist Product Owner in maintaining the product backlog

• Create conceptual prototypes and mock-ups of patient Clinical Behavioral Counseling data

• Propose alternative solutions that balance cost and benefit, and adequately test a solution’s feasibility for business and technical compatibility

• Collaborate with staff, vendors, consultants, and contractors as they are engaged on tasks to formulate, detail and test potential and implemented solutions.

• Perform Quality Analyst functions such as defining test objectives, test plans and test cases, and executing test cases (including regression testing)

• Assist Product Owners with testing the deliverables and coordinate User Acceptance Testing

Qualifications

Required:

Sr. Business Analyst, Amsted Rail, Prince George, Va. (Contract) 02/2014 to 12/2017

• Worked with the Product Owners to understand business processes and pain points

• Develop expertise in the customers’ business applications

• Conduct Root Cause Analysis to identify system gaps and deficiencies that require a business, technical or blended approach for resolution

• Conducted & managed weekly, and bi-weekly agile sprints with teams sizes over 20.

• Diagram current processes and proposed modifications using process flows, context diagrams.

Sr.Business Analyst, USDA, Washington D.C., (Contract) 02/2014 to 07/2016

Conducted user Testing

Analyze existing functionality requests with the goal of making business-value based recommendations to Product Owners

Developed requirements best practices for product delivery

Technical Resource for Architecture Updates in SQL Server Integration Services.

Developed Complex reports to accommodate New Data elements in Access

Managed Change Management Request for System Access for Government Employees on Daily Basis.

Sr. Analyst, MCV/VCU Hospital, Richmond, VA., (Contract) 10/2013 to 01/2014

Migration of 20 SQL Server Databases to Virtual Server. (SQL 2008)

Facilitating in workshops with key stakeholders to capture user stories Evaluation/Migration of ICD 9 Billing Codes to ICD 10.

Presentations of Changes to Emergency Room doctors and Nurses on Procedure Changes.

Defined user stories

Sr. Migration Analyst, GCSS Army, Fort Lee, VA., (Contract) 03/2013 to 09/2013

Successfully Engineered Training TDY data for Web Based SAP TDY Application.

Assisted on Technical Issues with Completion of HR SAP Implementation.

SQL Server 2008 Development

Sr. Migration Analyst, Utopia, Chicago Illinois, (Contract) 01/2012 to 11/2012

Lenovo Headquarters (Raleigh NC) SAP CRM Upgrade.

Assisted senior leadership teams in making sound, innovated decisions based on data validation rules and business/industry knowledge for Europe Upgrade.

Daily Transfer of CRM Data Validation Updates to be ran overnight by Japan to update data success rates.

Analyzed performance benchmarks, summarized key Insights and recommended actions to improve.

Sr. Database Analyst, Hampton Roads Transit, Hampton, Virginia, (Contract) 08/2011 to 12/2011

Analysis/Integration of New Rail Transportation Data with Access/People Soft.

Developed Complex Rail Data reports for Executive Business Unit to Follow Metrics on new business line.

Sr. Analyst, US State Department, Washington D.C., (Contract) 02/2010 to 06/2011

Identified Legacy programs for Data migration and tracked in Access

Developed using SharePoint in SQL and Microsoft Access to create dashboard customizations

Developed Transformation Logic for data Cleansing of Integrated Property Management division

Managed Business Rules for Migration

Developed/Conducted Workshops to Senior Managers

Conducted weekly status meetings with Department Leads throughout Agency

Sr. Migration Analyst, AES Inc. Washington D.C., (Contract) 07/2007 to 04/2009

Developed Migration Strategy for 18 Stand Alone Nuclear Plants

Traveled to Plants and delivered Migration Strategy to Plant Management

Managed Business Rules for Migration

Creation of Master Migration rules

ERS extraction of Plant materials

Conducted user workshops

Development of Migration Scripts for all SAP modules

Managed downloads from Plants

Successfully Merged all plants data for SAP

Sr. Migration Analyst, Naval Sea Systems Command. Washington D.C., (Contract) 1/2007 to 7/2007

Lead developer on Financial tool in Access to track employee billing hours for data mart.

Re-Engineered process to Track Naval Messages for reporting to Admirals.

Initial ERP assessment for SD Naval Submarine Command.

Sr. ETL Migration Analyst, Areva. Lynchburg, Virginia (Contract) 5/2006 to 12/2006

Design and create data migration system (VB/Access/SQL) for the conversion of Customer, Vendor, Material, and FI data; oversee the transfer of legacy data to business integration testing.

Serve as Business Analyst for the Sales and Distribution module; acquire, test and document Customer Master Rules.

Lead a "cleansing group" of legacy users to avoid bringing any poor, obsolete, or incomplete data into the new SAP system; structure a system, based on Access, SQL, and Visual basic, to normalize, cleanse, and transform data from the legacy system (JD Edwards) to the target system (SAP).

Provide data and suggestions for homogenization of multiple SAP systems; build shared access form for the users to enter, alter, and comment on legacy data.

Spearhead and manage cleansing of legacy data (JDE) and conduct weekly meetings with users to scrub selected data; trained 10+ users. Conduct master data integration workshops with functional consultants.

Oversee redundant data accuracy, and LSMW table preparation. Coordinated LSMW mapping and execution Manage highly complex conversions and unresolved business rules to create accurate conversion data.

Development of Cutover Task List, Run LSMW routines as necessary during cutover.

Convert the data for Materials, Vendors, Purchasing Information Records, Inventory on Hand (all MM module), Customers (SD module), GRIR (FI module), and support 6-8 technical team members.

Sr. Analyst, Patient Services Inc., Richmond, Virginia (Contract) 9/2005 to 3/2006

Assisted IT auditors by researching SQL Server for errors found in patient’s financial history.

Coding upgrades to check disbursement portion of application.

Support of existing SQL Server and Stored procedures for General Ledger.

Development of DTS for replication.

Access, SQL Server 2005, DTS, Black Baud, Financial Edge, VB.Net.

Sr. Analyst, Trilegant Loyalty Solutions. Richmond, Virginia., (Contract) 8/2005 to 9/2005

Upgrading application code for Oracle Migration

Sr. Analyst, Dynex Capitol. Richmond, Virginia (Contract) 4/2005 to 7/2005

SQL Server 2000 Upgrade to SQL Server 2005and migration of Apps to Office XP.

Upgrade of code from ADO to .Net

Creating test environment.

Updating of Stored Procedures where needed.

Access XP, SQL Server 2005, VB.Net, DTS

Sr. Analyst, Philip Morris Manufacturing/Sales. Richmond, Virginia, (Contract) 5/2004 to 2/2005

Developed POG Tool application that shows placement and look of a cigarette display based on the PM market share and sizes entered.

Provided business process analysis to the factory conformance analyst and production quality control department for the entire manufacturing plant.

Development of application for data collection and cleansing process for production hold work.

Developed database for tracking supplier vendor issues involving production.

Provided user training and management trend analysis.

Point of contact for ad hoc statistical reports.

Access, VB, Oracle, Crystal Reports, Excel, SQL Server, E-Doc.

Sr. Analyst, Demo Pro. Richmond, Virginia, (Contract) 4/2004 to 12/2005

Provided business process analysis and metrics for the process of products being scheduled for shipment and, arriving at stores along with the scheduling of people to demonstrate the product.

Also did the programming and the analysis of payments. Clients were Walmart, Food Lion and, ToysRUS. Designed an application to do research of products and, the analysis of demonstration effectiveness.

Developed user documentation, and system documentation

Utilized Access, SQL Server, and Office XP environment.

Web Developer, Technology Plus Corporation. Richmond, Virginia, (Contract) 11/2002 to 8/2003

Provided Analysis of new Internet line of business to recruit college applicants for government and private corporations.

Developed web site for students to register and, for companies to recruit students by qualification criteria.

Documented system requirements, and code.

Utilized Java, FrontPage, and SQL Server.

Lead Developer, Liggett tobacco. Durham, North Carolina, (Contract) 8/2001 to 11/2002

Provided Analysis and update designs to vendor created leaf-processing application. Consisted of streamlining the data to better fit the introduction of new processing machinery and, being able to change the temperature checks, and timelines.

Documented code changes and editions along with making amendments to existing user manuals

Utilized Visual Basic, VB.Net, Access, SQL Server 2000, and Crystal Reports 8.5.

Project manager/Developer, Allied Signal/Honeywell. Chesterfield, Virginia, (Contract) 7/1999 to 8/2001

Responsible for gathering management requirements, data marts and interacting with off shore web development,

Documentation of requirements changes.

Team manager on requirements.

Also required travel to corporate headquarters in NJ. To represent, Chesterfield Plant, and give Sr. management assisted presentations.

DEVELOPER, UPTIME PRODUCTION APPLICATION

Developed Access 97 database to extract data from plant hardware, and format to be uploaded to Cognos data cube for engineers to do ad-hoc analysis. Also developed Access 97 database to, track employee training records.

SR. ANALYST, ENGINEERING PLASTICS BUSINESS UNIT

Main responsibility was to assist with SASS and SAP technical issues for implementation team on SAP conversion.

Lead Analyst on Plastics Sales and Distribution SAP implementation.

Also some ASP development on existing Visual Basic Applications.

Database Developer, AutoTrader.com. Norfolk, Virginia, (Contract) 9/1998 to 6/1999

Analysis and development of database to data entry, ftp transfers and provide power user interface of information

Of 400 affiliate companies at headquarters. Developed in Visual Basic 5.0 and Access 7.0 also SQL server 6.5

DBA of sold.com ASP development, and stored procedures.

Analysis and development of Excel tracking application of web-site tracking using VBA.

Upgrade of VB 5.0 app to VB 6.0, usage of Ado technology.

Database Analyst, Phillip Morris USA Development Facility. Ashland, Virginia, (Contract) 1/1998 to 9/1998

Access 7.0 Development of sensitive testing activities and inventory, using SQL Server 6.5, Visio technical diagramming and scanner implementation.

Production process documentation.

Utilized DAO, stored procedures, and triggers.

Sr. Systems Analyst, Defense Commissary Agency. Fort Lee, Virginia, (Contract) 9/1997 to 1/1998

Implementation of SQL Server 6.5 and Systems Management Server.

Database development and analysis of help desk software using Access 2.0

Crystal reports manipulation.

PM/Developer, VDOT Headquarters. Richmond, Virginia, (Contract) 4/1996 to 7/1997

Development of emergency operations application using Access 97.

Analysis and Design of Budget and planning database of state maintenance budgets. (Visual Basic, and Access 97).

Team member of specifications group of statewide budget conversion.

Tracking in Microsoft project

Programmer Analyst, Universal leaf tobacco. Richmond, Virginia, (Permanent) 6/1991 to 4/1996

Responsible for full life cycle development of various corporate applications. Developed full life cycle Access 2.0 Inventory System to receive, track, and ship tobacco samples for universal headquarters and affiliates, sub-system development of executive on line inventory views. Windows 3.1, and SQL server. Developed Corporate Directory System to track all clients, agents and brokers of universal and worldwide affiliates to be deployed in a client-server environment.

Created Runtime versions using access for program for different user levels). Data Modeling using Ernest and Young Navigator for Human Resources Financial and Benefit Histories for headquarters and affiliates, also trained power users and handled implementation issues. Main contact for Blue Cross-on data transfer issues. (Access 2.0). Served on ten members Inventory Accounting Team. Team was responsible for developing a Request for Proposal to replace legacy systems in the following areas, Accounts Receivable, Budgets, Accounts Payable, Risk, Inventory, Plant Production, and, General Ledger Systems (Data Modeling Tools).

Responsible for testing of conversion from MS Access 2.0 to 7.0 in Windows 95 environments. Served as power user support also. Various other maintenance and development task in MS Access, PowerBuilder 4.0, COBOL, RPG II, Ideal, Monarch 4.0, and SQL LANGUAGE WIZARD

United States Air Force

Strategic Air Command

.

EDUCATION

Dale Carnegie Graduate

ECPI (Electronic Computer Programming Institute) Diploma

1991 Louisiana Tech University – Computer Science

1986 Business Information Systems - Virginia State University

Contact this candidate