Quantcast

Sql Server Business Analyst Resume Richm...
Resumes | Register

Candidate Information
Name Available: Register for Free
Title Sql Server Business Analyst
Target Location US-VA-Richmond
Email Available with paid plan
Phone Available with paid plan
20,000+ Fresh Resumes Monthly
    View Phone Numbers
    Receive Resume E-mail Alerts
    Post Jobs Free
    Link your Free Jobs Page
    ... and much more

Register on Jobvertise Free

Search 2 million Resumes
Keywords:
City or Zip:
Related Resumes

Sql Server Business Intelligence Glen Allen, VA

Sql Server Ms Fredericksburg, VA

Business Process Financial Service Richmond, VA

Technical Support Sql Server Richmond, VA

Customer Service Business Development Petersburg, VA

Information Technology Business Continuity Colonial Heights, VA

Business Analyst Quality Assurance Chester, VA

Click here or scroll down to respond to this candidate
Candidate's Name
EMAIL AVAILABLEPHONE NUMBER AVAILABLETECHNICAL SKILLSSQL ServerMS Access and Excel development VBAMicrosoft Dynamics AXAgileMDM Data LeadSQL ServerOracleData warehousingSybase and CitrixSharePoint DevelopmentWeb analysis and developmentERP System life cycle developmentBusiness Process DesignBusiness process re-engineeringSystem TestingBODSTechnical Business AnalystPowerPointSAP Data MigrationDB2/SQL ServerCobolPROFESSIONAL EXPERIENCEAmazon 9/2021 to Present Use Scanner to process ordersData 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 BITechnician, 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 solutions 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 TestingQualificationsRequired: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/2016Conducted user TestingAnalyze existing functionality requests with the goal of making business-value based recommendations to Product OwnersDeveloped requirements best practices for product deliveryTechnical Resource for Architecture Updates in SQL Server Integration Services.Developed Complex reports to accommodate New Data elements in AccessManaged Change Management Request for System Access for Government Employees on Daily Basis.Sr. Analyst, MCV/VCU Hospital, Richmond, VA., (Contract) 10/2013 to 01/2014Migration 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 storiesSr. Migration Analyst, GCSS Army, Fort Lee, VA., (Contract) 03/2013 to 09/2013Successfully Engineered Training TDY data for Web Based SAP TDY Application.Assisted on Technical Issues with Completion of HR SAP Implementation.SQL Server 2008 DevelopmentSr. Migration Analyst, Utopia, Chicago Illinois, (Contract) 01/2012 to 11/2012Lenovo 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/2011Analysis/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/2011Identified Legacy programs for Data migration and tracked in AccessDeveloped using SharePoint in SQL and Microsoft Access to create dashboard customizationsDeveloped Transformation Logic for data Cleansing of Integrated Property Management divisionManaged Business Rules for MigrationDeveloped/Conducted Workshops to Senior ManagersConducted weekly status meetings with Department Leads throughout AgencySr. Migration Analyst, AES Inc. Washington D.C., (Contract) 07/2007 to 04/2009Developed Migration Strategy for 18 Stand Alone Nuclear PlantsTraveled to Plants and delivered Migration Strategy to Plant ManagementManaged Business Rules for MigrationCreation of Master Migration rulesERS extraction of Plant materialsConducted user workshopsDevelopment of Migration Scripts for all SAP modulesManaged downloads from PlantsSuccessfully Merged all plants data for SAPSr. Migration Analyst, Naval Sea Systems Command. Washington D.C., (Contract) 1/2007 to 7/2007Lead 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/2006Design 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/2006Assisted IT auditors by researching SQL Server for errors found in patients 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/2005Upgrading application code for Oracle MigrationSr. Analyst, Dynex Capitol. Richmond, Virginia (Contract) 4/2005 to 7/2005SQL Server 2000 Upgrade to SQL Server 2005and migration of Apps to Office XP.Upgrade of code from ADO to .NetCreating test environment.Updating of Stored Procedures where needed.Access XP, SQL Server 2005, VB.Net, DTSSr. Analyst, Philip Morris Manufacturing/Sales. Richmond, Virginia, (Contract) 5/2004 to 2/2005Developed 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/2005Provided 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 documentationUtilized Access, SQL Server, and Office XP environment.Web Developer, Technology Plus Corporation. Richmond, Virginia, (Contract) 11/2002 to 8/2003Provided 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/2002Provided 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 manualsUtilized 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/2001Responsible 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 APPLICATIONDeveloped 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 UNITMain 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/1999Analysis and development of database to data entry, ftp transfers and provide power user interface of informationOf 400 affiliate companies at headquarters. Developed in Visual Basic 5.0 and Access 7.0 also SQL server 6.5DBA 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/1998Access 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/1998Implementation of SQL Server 6.5 and Systems Management Server.Database development and analysis of help desk software using Access 2.0Crystal reports manipulation.PM/Developer, VDOT Headquarters. Richmond, Virginia, (Contract) 4/1996 to 7/1997Development 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 projectProgrammer Analyst, Universal leaf tobacco. Richmond, Virginia, (Permanent) 6/1991 to 4/1996Responsible 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 WIZARDUnited States Air ForceStrategic Air Command.EDUCATIONDale Carnegie GraduateECPI (Electronic Computer Programming Institute) Diploma1991 Louisiana Tech University  Computer Science1986 Business Information Systems - Virginia State University

Respond to this candidate
Your Message
Please type the code shown in the image:

Note: Responding to this resume will create an account on our partner site postjobfree.com
Register for Free on Jobvertise