Sql Server Business Analyst
Resume:
Lloyd Stewart
********@*******.***
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