Sr. Business Analyst

Location:

Loganville, GA, 30052

Salary:

110000

Posted:

March 31, 2017

Contact this candidate

Resume:

Harry James Williams III

770-***-**** (H) 678-***-**** (C)

**** ******** ***** *****, ********** GA 30052

******@*****.***

SUMMARY

Senior Analyst focusing on the application of technology system that improves the business functions. Detail focused and uses technical expertise competently producing software system applications; critically evaluate information gathered from multiple sources, reconcile conflicts, loyalty, decompose high-level information, and distinguish user requests from their underlying true needs.

Industry Experience: Information Technology, Telecommunication, Banking, Health Care, Medical Claims, Insurance, Manufacturing, Customer Relationship Management, Supply Chain, Analytics, Retail and Consumer Good industries

Domain Experience: Business Analysis & Development, Marketing & Loyalty, Project Management, Banking (Retail and Consumer Banking), Small Business Loans, Investment Banking, Life Insurance, Property Insurance, General Insurance, Call Center based applications, CRM, Website Design and Development, E-Commerce, Web Applications, Fraud Prevention, IAM, Anti-money Laundering (AML) and Services

Interpersonal Skills: Effective communicator with ability to work with the team and independently; Structured, well-organized & detail oriented; Ability to build strong client relationships; Strong facilitation and collaboration skills; Excellent written, oral, and presentation skills

ACCOMPLISHMENTS

•13+ years of experience as a Business and System Analyst, assisting in various stages of Software/System Development Life Cycle (SDLC), such as defining scope, product design, development strategy, production and quality assurance. Experienced in Statistical Data Analysis, Gap Analysis, Feasibility Analysis, Impact Analysis, Risk Analysis, Change Management, Business Process Re-engineering and Cost-Benefit Analysis.

•Proficient in Understanding User Stories, Requirement Elicitation, Requirement Documentation, Validation, Modeling, IAM, HL7 and Analysis; Proficient in interviewing stakeholders at all levels and in conducting JAD sessions (both onsite and using video-conferencing). In depth knowledge of SDLC: Rational Unified Process (RUP), Agile, and Waterfall methodologies. Proficient in business modeling using Work Flow Diagrams, offshore, Data Flow Diagrams and UML Diagrams (Use Case Diagrams, Activity Diagrams, State Chart Diagrams).

•Proficient in writing Use Case Specifications, IAM, Goggle Analytics, Functional Requirement Specifications (FRS), Technical Requirements Specifications (TRS), BRD, PRD, and Requirements Traceability Matrices (RTM). Utilized Business Analysis tools such as MS Visio, Word, Excel (including Pivot tables, Macros and Vlookup), Rational Requisite Pro, and iRise. Proficient in SQL querying with Databases, SQL Server Integration Services (SSIS) and developing reports/dashboards.

•Experienced with development of Web Applications and Enterprise Software; experienced in System Testing, Data Mapping, UAT Testing & writing Test Plans & Test Cases. Proficient in creating ad-hoc reports using Business Objects Web Intelligence tool. Experienced with giving PowerPoint presentations and performing product demonstrations to customers; handled projects in extremely challenging situations and delivered good quality product. Excellent communication and interpersonal skills with strong Customer orientation and Client interfacing skills

•6 years experience in retail operations with a proven record of accomplishment of achievement in point-of-sale systems, installations/implementations, systems analyst, business analysis, vendor management and Consulting in Logistics and Supply Chain Management. Evaluated, documented business, functional requirements, asset protection (loss prevention/safety), prepared use cases, T-SQL, Stored Procedure, Triggers, Data Modeling/Mapping, sequence diagrams and class diagrams with Rational Rose. Supported UAT activities for all products utilizing Rational Clear Quest and implemented SQL queries with Toad application services.

•Experience creating documentation for development projects, including technical specs for SharePoint development team. Developed Forms, Reports, and SQL Queries using TOAD tool with Oracle database; website layout prototyping uses iRise. Performed Data Analysis and Data validation by writing complex SQL queries using TOAD against the ORACLE database; created data models and data flow diagrams for the to-be process.

•Gathered requirements from the business and technical end to develop the mainframe, e-commerce and the web portal backend. Actively participated during the Production releases of the products and provided go-live support during Production deployments. Performed maintenance to existing software as needed for WMS and Supply Chain systems. Resolved system issues as they relate to production processing, report applications and system output. Designed SQL queries for Backend Testing and Report Generation accordingly based on the specifications.

•Prepared Test Reports and submitted the Bug Findings to the Bug Tracking system using Quality Center and its modules (Requirements, Test Plan, Test lab and Defects). Liaised between client and client project teams as PM to ensure work met client requirements. Communicated to client team when business requirements changed. Assisted project leader for project management and delivering project. Analyzed operational results for variances of actual to plan and prior year for P&L and balance sheet accounts and provide financial narratives summarizing significant variances.

•As a member of production support team, I have provided on-call support to all enhancements done on production servers and e-commerce. Performed Functionality, Integration, GUI, Regression, Usability and System testing. Involved in creating a detailed System Test Plans, Test Cases and Test Scripts for different modules in the Application according to the Business Requirement Documentation. Extensive usage of analytical, collaborative and operational customer relationship management (CRM) like Oracle, Salesforce, and JDA.

•Executed Oracle responsibilities and supported system privileges and updated Oracle applications for OM and other business processes. Participated in requirements gathering and documented structured procedures. Maintained user documentation, prepared test scripts, designed automated solutions and assisted in gap analysis. Formulated functional specifications for new business tasks and suggested improvements for business tasks utilizing Order to Cash apps.

•Supported functional solutions, analyzed business requirements, reviewed system performance and maintained system legal aspects. Executed Oracle application upgrades and supported application maintenance. Executed Oracle application upgrades and supported application maintenance. Documented business requirements, prepared conceptual designs and conducted user acceptance testing.

•Communicated with project managers, client support contacts, firewall engineers, system administrators, account security officers, implementation teams, and compliance management to achieve required goals. Followed change management procedures. Prepared the financial reporting, forecasting and analysis monthly to compare numbers versus our plan, forecast and prior year and to report and present any variances for each of the scenarios.

•Partnered with project managers, client support contacts, firewall engineers, system administrators, account security officers, implementation teams, and compliance management to achieve required goals. Followed change management procedures. Provided mobile device support for smart phone and tablet devices. Support included application, wireless and email configurations for Blackberry, iPhone and iPad devices. A liaision for the business leaders to ensure all estimates are updated and validated with supporting data. Independently track costs related to all specific warranty matters.

PROFESSIONAL EXPERIENCE

AT&T North Highland Atlanta, GA 01/2017 – 03/2017

System Analyst

•Reviews, analyzes and modifies systems including configuring, testing, debugging and installing POS system; as well as manages software updates, T-SQL, SQL Server Integration Services (SSIS), Stored Procedure, Triggers, Data Modeling/Mapping, configuration changes and maintains existing hardware. Uses internal systems and resources, as well as external where necessary, to access sales numbers including customer, market and shopper data, category sales, and SKU level sales.

•Achieves specified success metrics and for recommending improvement programs. Run customized customer reports to support sales, trade teams in analyzing current business (Vendor Performance Scorecards, POS Reports, Distribution Gap Trackers, etc.). Maintain standard reports to track business (Lost Sales, In-stock %, Fill rates etc.). Identify opportunities and improve business with Replenishment / Demand Planning teams. Diagnose success of promotional activities.

•Forecasting – comparison of forecasts in customer system vs. actual orders, Work with internal demand planning team to assess item level forecasts and make necessary adjustments. Monitor PO’s to ensure on-time delivery for large orders / big hits. Communicated with project managers, client support contacts, firewall engineers, system administrators, account security officers, implementation teams, and compliance management to achieve required goals. Followed change management procedures.

•Communicated with project managers, client support contacts, firewall engineers, system administrators, account security officers, implementation teams, and compliance management to achieve required goals. Followed change management procedures. Provided mobile device support for smart phone and tablet devices. Support included application, wireless and email configurations for Blackberry, iPhone and iPad devices.

NICE-Actimize, LLC, Alpharetta, GA 07/2015 – 11/2016 (11625 Rainwater DR # 600, Alpharetta, GA 30009)

Business System/Analyst:

•Communicate with clients to gather, document requirements, fraud management, data mapping, write business specifications, write test plans and conduct testing. Prepare use cases, test cases, test data, and perform data analysis, strong writing skills, T-SQL, Stored Procedure, SQL Server Integration Services (SSIS), Triggers, Data Modeling/Mapping, SQL knowledge. Consult with key stakeholders on client and internal requirements, projects and proposals, audit responses and new business opportunities. Experience writing detailed specifications, team oriented, and the able to thrive in a fast passed environment.

•Utilized User Stories, offshore teams, Requirement Elicitation, Anti-money Laundering (AML), Fraud Management, IAM, Risk Analyst, Requirement Documentation, Validation, Modeling, and Analysis; Proficient in interviewing stakeholders at all levels and in conducting JAD sessions (both onsite and using video-conferencing); Closely interacted with designers and software developers to help them understand application functionality and navigational flow, by creating MS PowerPoint presentations and Wireframes within a MEAN stack.

•Utilized business modeling using Work Flow Diagrams, Goggle Analytics, Data Flow Diagrams and UML Diagrams (Use Case Diagrams, Activity Diagrams, and State Chart Diagrams); Proficient in writing Use Case Specifications, .Net, Java, Functional Requirement Specifications (FRS), Technical Requirements Specifications (TRS), BRD, SRD, and Requirements Traceability Matrices (RTM).

•Communicated with project managers, client support contacts, firewall engineers, system administrators, account security officers, implementation teams, and compliance management to achieve required goals. Followed change management procedures. Analyzed operational results for variances of actual to plan and prior year for P&L and balance sheet accounts and provide financial narratives summarizing significant variances.

•Communicated with project managers, client support contacts, firewall engineers, system administrators, account security officers, implementation teams, and compliance management to achieve required goals. Followed change management procedures. Provided mobile device support for smart phone and tablet devices. Support included application, wireless and email configurations for Blackberry, iPhone and iPad devices.

Capgemini, Inc., Atlanta, GA 10/2014 – 07/2015 (3475 Piedmont Rd Ne, 30305)

Sr. Business Solution/Analyst:

•Utilized User Stories, Requirement Elicitation, Requirement Documentation, Validation, Modeling, Risk Analyst and Analysis; Proficient in interviewing stakeholders at all levels and in conducting JAD sessions (both onsite and using video-conferencing); Closely interacted with designers and software developers to help them understand application functionality and navigational flow, by creating MS PowerPoint presentations and Wireframes within a MEAN stack. Performed unit integration testing, system implementation, and maintained system software functions utilizing SYNON, Embedded SQL, T-SQL, SQL Server Integration Services (SSIS), Stored Procedure, Triggers, Data Modeling/Mapping, RPGIV and ILE on the ICOMS SQL/AS/400 Platform. A liaision for the business leaders to ensure all estimates are updated and validated with supporting data. Independently track costs related to all specific warranty matters.

•Utilized business modeling using Work Flow Diagrams, offshore teams, Data Mapping, Data Flow Diagrams and UML Diagrams (Use Case Diagrams, Activity Diagrams, and State Chart Diagrams); Proficient in writing Use Case Specifications, Functional Requirement Specifications (FRS), Technical Requirements Specifications (TRS), Anti-money Laundering (AML), Fraud Management, BRD, SRD, and Requirements Traceability Matrices (RTM). Performed maintenance to existing software as needed for WMS and Supply Chain systems. Prepared the financial reporting, forecasting and analysis monthly to compare numbers versus our plan, forecast and prior year and to report and present any variances for each of the scenarios.

Rollins, Inc., Atlanta, GA 04/2014 – 10/2014 (3500 Lenox Road NE, 30326)

Sr. Business Solution/Analyst:

•Experienced creating documentation for development projects, including technical specs for SharePoint development team; Developed Forms, T-SQL, SQL Server Integration Services (SSIS), Stored Procedure, Triggers, Data Modeling/Mapping, Reports, and SQL Queries using TOAD tool with Oracle database; website layout prototyping uses iRise. Performed Data Analysis and Data validation by writing complex SQL queries using TOAD against the ORACLE database; created data models and data flow diagrams for the to-be process.

Atlanta Housing Authority (AHA), Atlanta, GA 03/2014 – 04/2014 (230 John Wesley Dobbs Ave NE, 30303)

Sr. Business Solution/Analyst:

•Evaluated, reviewed SOA activities, financial information, business drivers, participated in professional development activities, webcasts reviewed and documented payroll allocations as per education margins. Developed, maintained margin analysis reports for professional development, conducted research and analytical activities for exam candidate trends. Evaluated, documented business, functional requirements, prepared use cases, sequence diagrams and class diagrams with Rational Rose. Supported UAT activities for all products utilizing Rational Clear Quest and implemented SQL queries with Toad application services.

The Weather Channel, Inc., Marietta, GA 07/2013 – 03/2014 (300 Interstate North Parkway SE 30339)

Sr. System/Analyst:

•Closely interacted with designers and software developers to help them understand application functionality and navigational flow, by creating MS PowerPoint presentations and Wireframes. Worked in an AGILE/SCRUM environment which posed initiating several JAD Sessions and active interaction with business, technical teams, activity and state. Perform usability testing and organizing focus groups to discuss and ensure effective adoption of feedback to improving the usability of the mobile applications and web based applications within a MEAN stack.

SunTrust, Inc., Atlanta, GA 01/2012 – 05/2013 (303 Peachtree Street Northeast 30308-3201)

Sr. Business System/Analyst:

•Evaluated, reviewed SOA activities, offshore teams, financial information, risk analyst, business drivers, participated in professional development activities, webcasts reviewed and documented payroll allocations as per education margins. Developed, maintained margin analysis reports for professional development, conducted research and analytical activities for exam candidate trends.

•Prepared the financial reporting, forecasting and analysis monthly to compare numbers versus our plan, forecast and prior year and to report and present any variances for each of the scenarios. A liaision for the business leaders to ensure all estimates are updated and validated with supporting data. Independently track costs related to all specific warranty matters.

•Supported budgeting, Anti-money Laundering (AML), Fraud, IAM, projection processes, analyzed monthly variances, implemented SOA suite activities, platform modernization and business analytical services. Reviewed product drawings, formulated packaging specifications, created business processes, software flow processes and user stories. Analyzed operational results for variances of actual to plan and prior year for P&L and balance sheet accounts and provide financial narratives summarizing significant variances.

Interactive College of Technology Chamblee, GA 03/2011 – 04/2013 (5303 New Peachtree Road, GA 30341)

Instructor/Analyst

•Utilized an Analysis approach based on SDLC process, maintaining dashboard, SQL Server Integration Services (SSIS), Data Mapping, design architecture of IT Portal, joint application design (JAD)/joint requirement planning (JRP), and perform Stakeholder Analysis. Hosted formal security requirements reviews, obtain sign-offs on security requirements, and work to make sure requirements become part of project requirements. Assess and validate project solutions against security requirements.

AT&T, Inc., Atlanta, GA 10/2011 – 11/2011 (7000 Central Parkway Northeast 30328-4592)

Sr. Business System/Analyst:

•Developed Forms, T-SQL, Stored Procedure, SQL Server Integration Services (SSIS), Triggers, Data Modeling/Mapping, Reports, and SQL Queries using TOAD tool with Oracle database; website layout prototyping uses iRise. Analyzed raw marketing data using SQL Queries and tools like MS Access and Excel to identify growth opportunities into new and existing markets; worked closely with project manager to determine areas for product quality enhancement and cost reduction.

IHG, Inc., Alpharetta, GA 2/2011 – 7/2011 (4170 Ashford Dunwoody Rd #580 30319)

Sr. IT Security/Analyst:

•Utilized an Analysis approach based on SDLC process, maintaining dashboard, design architecture of IT Portal, and perform Stakeholder Analysis. Created a Requirements Communication Plan while work with Security team to refine Risk Assessment requirements, Data mapping, T-SQL, SQL Server Integration Services (SSIS), SQL Server Integration Services (SSIS), Stored Procedure, Triggers, Data Modeling/Mapping, Supply Chain, and ERP systems.

•Participated in project effort estimations on behalf of Information Security Department to ensure appropriate trusted data sources. A liaision for the business leaders to ensure all estimates are updated and validated with supporting data. Independently track costs related to all specific warranty matters.

SunTrust, Inc., Atlanta, GA 6/2010 – 9/2010 (4170 Ashford Dunwoody Rd #580 30319)

Sr. Business System/Analyst:

•Provided thorough documentation of all BI applications and processes to be used in the event of equipment or system failure; assisted in the integration efforts for merging BI platforms with enterprise systems and applications. Analyzed and consolidated data across the business/system, Data Mapping, SQL Server Integration Services (SSIS), maintaining dashboard, Supply Chain, and made effective planning decisions.

•Participated in project improvement opportunities using LEAN, XML, XML Schema, joint application design (JAD)/joint requirement planning (JRP), and Sig Sigma. Analyze operational results for variances of actual to plan and prior year for P&L and balance sheet accounts and provide financial narratives summarizing significant variances.

Verizon Wireless, Inc., Alpharetta, GA 3/2009 – 4/2010 (1145 Sanctuary Pkwy # 270, 30009)

Sr. Business System/Analyst:

•Utilized process and documented support (Marketing, vision, scope, UML diagrams, context diagrams, joint application design (JAD)/joint requirement planning (JRP), and use-cases, maintaining dashboard, mockups, Test Director, traceability matrix) to gather requirements for products, projects and system innovations / enhancements across key functional stakeholders. Drove out business/system needs with cross-functional teams for data cleansing & conversion.

Networks Communication, Inc., Lawrenceville, GA 1/2008 – 11/2008 (2305 Newpoint Parkway 30043-5539)

Sr. Business System/Analyst:

•Translated conceptual user requirements into functional requirements in a clear manner that is comprehensible to developers/project team, maintaining dashboard and project planning/scheduling/change management. Created as-is and to-be process models, Data Mapping, specifications, joint application design (JAD)/joint requirement planning (JRP), and diagrams.

•Validated data and coordinated data validation with Business/system Process Owners and other SMEs. Performed maintenance to existing software as needed for WMS and Supply Chain systems. Experienced in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.

Plaid Enterprises, Inc., Norcross, GA 4/2007 - 9/2007 (3225 Westech Dr 30092-3500)

Sr. System/Analyst:

•Integrated and resolved web applications, business/system process errors, Data Mapping, maintaining dashboard, performed maintenances to existing software as needed. Supported all production operation activities, SQL Server Integration Services (SSIS), with focus on integration and development of new and existing products and services. Performed analysis of products, joint application design (JAD)/joint requirement planning (JRP), processes and software capabilities.

•Created UML diagrams, system process analysis, VISIO, mockups, MS-Project, design and prototyping. Prepared the financial reporting, forecasting and analysis monthly to compare numbers versus our plan, forecast and prior year and to report and present any variances for each of the scenarios. A liaision for the business leaders to ensure all estimates are updated and validated with supporting data. Independently track costs related to all specific warranty matters.

NexPak, Inc., Duluth, GA 1/2007 - 4/2007 (2444 Meadowbrook Parkway 30096-4635)

Sr. Programmer/Analyst:

•Generated new applications utilizing SDLC concepts, RPG, JWalk, UML diagrams, mockups, Supply Chain, and created software test plans, procedures, system implementation, SQL Server Integration Services (SSIS) and maintained system software functions for manufacturing/multi-media application on the AS/400 Platform. Drove out business/system needs with cross-functional teams for data cleansing & conversion. Experienced in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.

EVANT, Inc., Atlanta, GA 1/2005 - 8/2006 (1100 Circle 75 Pkwy SE 30339-3064)

Business System/Analyst

•Identified data issues, joint application design (JAD)/joint requirement planning (JRP), and provide recommendation for resolution to ensure optimal performance. Integrated and resolved web applications and business/system process errors. Performed maintenance to existing software as needed for WMS and Supply Chain systems. Assembled data using SQL Query, SQL Server Integration Services (SSIS), T-SQL, Stored Procedure, Triggers, Data Modeling/Mapping, Data Mapping, RPG, JWalk, and Interacted with IT professionals and members of the business to understand the business/system rules behind data processing systems. Experienced in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.

AMAC, Inc., Atlanta, GA 06/2004 - 1/2005 (1200 Ashwood Parkway # 350-*****-****)

Business System Engineer:

•Responsible for the mainframes that receive the HL-7 message in pre-approved format from the middleware as disclosed in the documentation. Validated the following: 837 (Health Care Claims or Encounters), 835 (Health Care Claims payment/ Remittance), 270/271 (Eligibility request/Response), 834 (Enrollment/Dis-enrollment to a health plan). Worked on EDI transactions: 270, 271, 834, 835, and 837 (P.I.D) to identify key data set elements for designated record set; Interacted with Claims, Payments and Enrollment hence analyzing and documenting related business/system processes.

Cingular Wireless, Inc., Alpharetta, GA 1/2001 - 3/2004 (12525 CINGULAR WAY, STE 3210, 30004-8502)

Sr. Business Analyst

•Utilized order management within the Oracle ERP system. Created a unified logical view of corporate data through the ODS design. Coordinated Data Requirements amongst different project execution teams to fulfill data needs of the project along the project lifecycle. Experienced in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.

•Developed use cases, workflow, screen mock-ups, Data Mapping, conversion requirements, prioritized outstanding defects, client-server architecture solution alternatives and system problems, ensuring that accuracy, asset protection (loss prevention/safety) and deadlines were met. Participated in project improvement opportunities using LEAN and Sig Sigma. Analyzed operational results for variances of actual to plan and prior year for P&L and balance sheet accounts and provide financial narratives summarizing significant variances.

Club Car, Inc., Augusta, GA 5/2000 - 1/2001 (4125 Washington Rd, 30917-4658)

Business System/Analyst

•Trained and assisted staff and customers in all company requirements, Data Mapping, ERP, and provided technical support. Coordinated with logistics team and analyzed end user requirements and drafted improvements to present process. Experienced in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.

•Prepared instructional materials for programmers and operators to describe effects of new requirements resulting from changes to system software responsible for directing EDI interfaces application, SQL Server Integration Services (SSIS), asset protection (loss prevention/safety), UML, mockups, joint application design (JAD)/joint requirement planning (JRP), rationale unified process, and monitoring.

The Sports Authority, Inc., Englewood, CO 10/1998-5/2000 (705 W Hampden Ave, 80110)

Business System/Analyst

•Accumulated, developed, coordinated, Data Mapping, UML diagrams and maintained business requirements for various projects and/or systems from initial phase to final implementation. Assured requirements meet standards by designed software in a Client-Server, EDI application, client-server architecture solution alternatives and mainframe utilizing Embedded SQL, SQL Server Integration Services (SSIS), RPGIV and ILE on the JDA, INFINIUM, MMS, SQL/JAVA/AS/400 platform.

CONVERGYS, Inc., Sunrise, FL 9/1997 - 10/1998 (1551 Sawgrass Corporate Ste 300, 33323)

Programmer/Analyst

•Evolved, Data Mapping, joint application design (JAD)/joint requirement planning (JRP), enhanced, trained, tuned, and created software development tools, performed unit integration testing, system implementation, and maintained system software functions utilizing SYNON, Embedded SQL, SQL Server Integration Services (SSIS), JWalk, RPGIV and ILE on the ICOMS SQL/AS/400 Platform. Experienced in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.

EDUCATION

Bachelor of Science of Computer Science, Albany State University, Albany, GA Completed 1996

Oracle 9i DBA certificate - Silicon Valley Inc., Marietta, GA Completed 2008

Health Insurance License, Alliance For Affordable Health Care Completed 2009

Project Management Certification (PMP) in progress

TECHNICAL SKILLS

Contact this candidate