We provide IT Staff Augmentation Services!

Sr. Business Analyst Resume

Novi, MI

SUMMARY

  • 6+ years of Industry experience as a Business Analyst with solid understanding of Business Requirements Gathering, Evaluating Data Sources, Translating Requirements into Specifications, Application Design.
  • In depth knowledge of SDLC processes using Waterfall and Agile software development methodologies.
  • Strong experience with Scrum methodology and well versed in writing User Stories.
  • Solid understanding of Business Requirements, Gathering Techniques, Business Process Flow Diagrams and Business Process Models.
  • Data visualization knowledge for Enterprise Reporting Applications with Cognos, Tableau, and SSRS.
  • Experience in identifying the key stakeholders through Stakeholder Analysis (RACI) understanding existing process flows, Standard Operating Procedures and analyzing the gaps.
  • Adept in BPM, SOA and Re - Engineering (As-Is & To-Be modeling/mapping) systems applications and business processes.
  • Expert in creating Business Analysis artifacts such as Use Cases, Activity Diagrams, Entity Relationship Diagrams and extensive Data Modeling using MS Visio.
  • Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
  • Develops workflow, control, and exception reports in SQL and creates SSIS packages for automation.
  • Adept at preparing Business Requirements Documents (BRD), writing System Requirements Specifications(SRS) and Functional Requirements Specifications (FRD) with use of Unified Modelling Language (UML).
  • Elicited Functional Requirements and refined of those requirements into Non-Functional Requirements, definition of and adherence to business rules, appropriate documentation, refinement to the level of a product specification, and analysis of requirements to ensure they effectively meet business needs.
  • Have extensive experience with Hybrid, waterfall, and agile methodologies.
  • Coach waterfall teams through the transition process of becoming a mature agile team.
  • Used Excel and company software (SAP) to manage accounting data.
  • Provided complex end to end integration solutions, using SAP technology as a base to integrate with non-SAP systems for Work Management and Asset Management
  • Facilitated User Acceptance Testing (UAT) with the stakeholders and the business users as well as trained users to use the system configured.
  • Expertise in broad range of technologies, including business process tools such as Microsoft Project, Primavera, Promodel, MS Excel, MS Access, MS Visio, technical assessment tools, Data Warehousing concepts and web design and development.
  • Developed BI reporting solutions in Power BI, Reporting Services (SSRS), Tableau and MicroStrategy
  • Design interactive report solutions for users comparing Tableau, and MicroStrategy reporting functionalities. implementations involving city/county governments, utility electric, water, wastewater, sanitation, and gas
  • In depth knowledge Rational Unified Process (RUP) methodology, Use Cases, Software Development Life Cycle (SDLC) processes, Object Oriented Analysis and Design (OOA/D).
  • Experienced in manual and automated testing for both front-end and backend. Extensively used automated test tools of Mercury like Quality Center, Quick Test Pro, Win Runner, Test Director, Performance and Load Runner Testing.
  • Valuable experience in designing and developing Tableau Visualizations
  • Strong understanding of the business processes, and translation of business requirements into SAP solutions in the most cost effective and client servicing manner.
  • Deep working knowledge of design and development of Tableau visualization solutions.
  • Highly analytical with experience in Extensive Data Analysis using SQL. Multi-Dimensional Modeling (STAR Schema), Advanced Excel (Pivots, Vlookups etc.), Statistical Analysis, Data Cleansing, Data mapping and Data Transformation.
  • Participated in JAD sessions with superior organization and presentation skills.
  • Coordination and active participation in GAP Analysis, UAT (User Acceptance Testing) for the application including meetings with business for the Walkthroughs of defects rose during UAT.
  • Fetched data with SQL (Structured Query Language).
  • Developed Test Plans and Test Cases based upon business requirements to perform QA.
  • Excellent communication skills both verbal and written and worked with higher management and technology teams in a collaborative manner.

TECHNICAL SKILLS

Operating Systems: Microsoft Windows /XP/VISTA/7, UNIX

Languages: T-SQL, HTML, UML, UNIX SAS

Databases & Tools: SQL Server 2005 & 2008, MYSQL, SSMS, SAS

Web Technologies: HTML, XML, JAVA Script, .Net

Quality Management: IBM Rational Manual Tester, HP QC, QTP

Business Modeling Tools: Microsoft Visio, IBM BPM

Enterprise Content Management Systems: OpenText ECM, Live Reports and Web reports

Change Management Tools: Team Foundation Server (TFS), SharePoint, Rational RequisitePro

ETL Tools: Clover

Reporting Tools: Crystal Reports

SDLC Methodologies: Waterfall, RUP, Agile (Scrum)

PROFESSIONAL EXPERIENCE

Confidential - Novi, MI

Sr. Business Analyst

Responsibilities:

  • Understood and documented the requirements for the integration with the intranet portal.
  • Performed business using case wise modeller
  • Identified internal and external system Requirements, design and configuration set-up.
  • Developed strategic partnerships with the Business units to develop a solid knowledge base of the Business line, including the Business Plan, Products, and Process.
  • Translated the Business needs into system Requirements, communicating with the Business on a broader scale and with an in-depth view.
  • Included projects to accommodate client's new Market Settlement and Reporting System and changes to marginal cost analyses.
  • Peace Software Oracle based Utility Billing software project, requirements documentation, gap analysis, user acceptance testing management, business process documentation, data conversion consulting.
  • Created UAT plans with several test cases for each project to ensure that the system runs smoothly after the proposed enhancements or changes have been made.
  • Created weekly reports using Excel, Tableau, and word, Confluence & PowerPoint compiling production issue trends (Incidents) to drive continuous improvement and drive down re-occurring incidents.
  • Process Visualization for new development using IRISE.
  • Designed and developed Project document templates based on SDLC methodology.
  • Analysed the business processes and mapped to SAP functionality
  • Integration of SAP work management execution with external scheduling system
  • Developed Business Requirement Document as well as High-Level Project Plan.
  • Provided documentation such as requirements management plans, functional requirements, test plans and test cases.
  • Experienced working with various Project Management methodologies including Scrum, Agile and Waterfall
  • Explore data in variety of ways and across multiple visualizations using Power BI.
  • Developed a process for the mass-update of billing determinant data stored in BLOBs on SQL Server.
  • Executed extensive and detailed design workshops and review sessions to finalize the overall work management solution
  • Conducted Functional Walkthroughs, User Acceptance Testing (UAT), and supervised the development of User Manuals for customers.
  • Work with Scrum Master in implementing Agile SDLC processes, including ticketing system, burn down charts, scrum sessions, and sprint and product backlogs.
  • Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access.
  • Coordinated defects routing in the team and created Excel macros to generate daily defects report status from Quality center across multiple teams.
  • Studied andanalysed client's Business Processesand mapped them into SAP.
  • Created key metrics and KPI and ensured it is met using Tableau, Excel, and writing simple to complex SQL queries.
  • Hampton Roads Sanitation District, Hampton Roads Utility Billing Services
  • Applied Tableau visualization for geographic data analysis by default loan size or type
  • Connected Tableau to Azure which allowed to easily access the cloud storage and perform data visualization for that cloud data.
  • Conducted User Acceptance Testing(UAT), gathered and documented User Manuals and Business Rules
  • Working extensively with SAP external service management functionality.
  • Converted manually maintained spreadsheets to an automated process in SAP’s Work Management module.
  • Involved in Managing Data modeling project from Logical design and implementation of Sybase Database
  • Develop Logical and Physical data models that capture current state/future state data elements and data flows using Erwin.
  • Experience in Reporting Services, Power BI (Dash Board reports), Crystal Reports, SSRS using MS SQL Server and in in supporting services MDX technology of the analysis services.
  • Designed Power BI data visualization using Density charts, Maps, Cross tabs, Scatted plots, Pie and bar.
  • Participated in the Logical and Physical Design sessions and developed Design Documents.
  • Worked cross-functionally with business stakeholders and ISD to test and support an enhancement implementation to SAP Partnered with the Technical Areas in the research and resolution of System and User Acceptance Testing (UAT).
  • Worked on Event hub to pull the real time data into Power BI dashboard.
  • Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
  • Worked with Quality Control Teams to develop Test Plan and Test Cases.
  • Develop User Manuals, and Training Manuals as per Project Specifications and timelines.

Confidential - New York City, NY

Sr. Business Analyst

Responsibilities:

  • Assisted the Project Manager in setting realistic Project expectations and in evaluating the impact of changes on the organization and plans accordingly and conducted Project related presentations.
  • Identified internal and external system Requirements, design and configuration set-up.
  • Responsible for leading and facilitating JAD sessions with Key Business Stakeholders and Developers for understanding and defining Business Requirements and Technical Criteria for developing Non-Utility Billing Application
  • Support the Electric Operations Project Management Center of Excellence of defining, implementing and reporting on key performance indicators and metrics and other defined measurements related to key business deliverables and processes.
  • Experience engaging in the design, build, test, and deployment of software by detailing the BRD, FRD, the Design Document, and RTM's in Waterfall, or Epics and User Stories, in Agile.
  • Developed User Stories for a new rollout and for some of the minor enhancements (Agile /Scrum project).
  • Plays a critical role in providing valuable insight and guidance to the Electric Operations Project Management leadership team.
  • Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access.
  • Reviewed business current SAP testing requirements process and functionality to identify for improvements to business
  • Reviewed Stored Procedures for reports and wrote test queries against the source system (SQL Server) to match the results with the actual report against the Data mart (Oracle).
  • Wrote many SQL scripts for exporting SAP data from their ERP system for feather analysis and reporting to business owners.
  • Worked for various Maintenance orders set up and enhancements in work management application
  • Worked on Oracle Lodestar (Oracle Utility Billing) modules for non-enterprise billing application.
  • Execute Test Plan (execute test cases- system and UAT) on integrating SOA interfaces with JD Edwards.
  • Extensively involved in the automation of Regression Test Cases by scripting.
  • Used Test Director and Mercury Quality Center for updating the status of all the Test Cases & Test Scripts that are executed during testing process.
  • Developed strategies with Quality Assurance group to implement Test Cases in Mercury Test Director for stress testing and UAT (User Acceptance Testing).
  • End To end testing from legacy systems to SAP - Work management time and expense confirmations
  • Verified the Business Scenarios on new builds to allow extended testing by the QA team.
  • Use my information of SQL, Java Script, and XML to retrieve information from database tables.
  • Establish foundation data models and reporting capabilities on SAP cross functional business teams including
  • Worked on Lead Management, Campaign Management and Order Management projects
  • Assisted Agile Scrum teams in documenting and tracking project initiatives and progress using JIRA and Confluence
  • Well versed in working with key performance indicator (KPIs) metrics and have extensive background in producing various levels of metrics and reporting.
  • Used Power BI Gateways to keep the dashboards and reports up to date.
  • Created policy and procedure documents to assist end users in new or revised systems and tools used in their daily work. Assisted user with content management systems.
  • Proven success in establishment of agile test practices including acceptance test automation using UFT during acceptance test driven development methodology.
  • Facilitated the User Acceptance Testing (UAT) with Pega System Administrators and Business Users, documented any issues or defects and eventually got sign off from the right parties.
  • Assured that all Artifacts are in compliance with corporate AGILE Policies and guidelines.
  • Involved in Inception Phase and prepared Logical Data Models that contains set of diagrams and BRD (Business Requirement Documents) supporting documents containing the essential business elements, detail definitions, and descriptions of the relationships between the actors to analyze and document business data requirements.
  • Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
  • Responsible to import the parts of the existing reports using Business Objects Live Office to develop the required reports in Microsoft Excel and Word.
  • Designed Power BI data visualization using Density charts, Maps, Cross tabs, Scatted plots, Pie and bar.
  • Deploy and manage SSRS environment to support custom reports for city utility billing, financials and planning.
  • Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Visio.
  • Stay abreast of relevant reporting and visualization tools to continually improve the enterprise reporting and analytics environment.
  • Created Mock-up forms in MS Access for better visualization and understanding of the software solution.
  • Developed enterprise reporting, dashboards and scorecards using data visualization, SQL, and statistical reporting applications such as, Tableau, MS Excel, Aginity, SPSS, Showcase, and Cognos.
  • Creates and executes tests in Excel predicated on investor guidelines and state regulations
  • Created Data Stage jobs to extract, transform and load data into data warehouses from various sources like relational databases, application systems, temp tables, flat files etc.

Confidential - Juno Beach, FL

Sr. Business Analyst

Responsibilities:

  • Gathered user and business requirements through surveys, prototyping and observing from portfolio managers and UI (User Interface).
  • Stored and modified requirements in MS - Word and using Test Director.
  • Analysed and prioritized user and business requirements as system requirements that must be included while developing the software.
  • Performed Requirement Gathering & Analysis by actively soliciting, analyzing and negotiating customer requirements and prepared the requirements specification document for the application using MS Word.
  • Involved in understanding the business opportunity, client and stakeholder kick off meetings and requirement gathering of the initiative and understanding and level setting the expectations of the stakeholders and their needs.
  • The technology was designed to meet the needs of the Business (EnCana) by providing a system capable of serving data, maps, and control points through visualization tools to end users in real time. The enterprise platform consisted of the required architecture, software and databases to deliver these tools via web services. These services ultimately provided access to online mapping and integration with existing databases and other software systems such as IMS (Incident Management System), SCADA (etc.
  • Extensively Used Microsoft Project Plan, MS Excel-VBA and UFT (QTP)
  • Tracked the defects in legacy reports as per account managers and end users. Compared the results and tracked the differences in excel.
  • Experienced in designing, creating, testing, and implementing complex reports and dashboards using SSRS, Power BI, Crystal Reports, Webi reports and Business Objects Enterprise reporting tools
  • Experienced in all phases of the Software Development Life Cycle for both Agile and Waterfall methodologies.
  • Responsible for monitoring the project progress by tracking activities, resolving problems, publishing progress reports, recommending actions, checking trends, patterns and building charts using visualization tools
  • Created Mock-up forms in MS word for better visualization and understanding of the software solution.
  • Defined charter, scope, schedule, and resources for projects productizing R&D programs, managing (and often defining and delivering) customer needs via marketing requirement documents (MRD).
  • Identified opportunities for business process improvement through various meetings with business users and developers and initiated efforts to make improvements.
  • Design and build components (Rate schedule and Rider) in Oracle Utilities - Billing (OUB-Lodestar) in Rules Language.
  • Integrations of SAP Work management process with CMS in order to carry out Substation inspections
  • Developed the project plan with assistance from the management, and included provisions for project scope changes and issues and initiated efforts to make improvements.
  • Utilized Agile-Scrum methodologies for software engineering to ensure high quality software from project initiation to completion
  • Updated and maintained SharePoint site with monthly announcements, calendar, useful documents, and links.
  • Liaison between Engineers, IT Director and SharePoint Developers to gather business requirements and test system. Created the SharePoint Sites, metadata, document hierarchy, taxonomy, and permissions. ITIL process research for development of a continuity plan for the Engineering and Land documents.
  • Manage data conversion into MS Excel based reporting, Dashboards, and Visualization tools
  • Worked with SQL queries using MS Access for data manipulations.
  • Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
  • Worked on Proof of Concepts to decide Tableau as Confidential BI strategy for enterprise reporting.
  • Created RUP activity diagrams and sequence diagrams to analyses the requirements and recommend solutions.
  • Created specifications for data cleansing and conversion programs, EDI sales data loading processes and procedures, mapping of client/territory alignments and hierarchies.
  • SQL app included integration with 'Vendavo Pricing System' application, SAP ERP systems (R3, BW, CRM) and flat file import files as inputs.
  • Assisted PM in Developing Project plan and tracking project Process, Scheduling and organizing group meeting, as well as developed Risk Management Plan
  • Designed the business requirement collection approach based on the project scope and SDLC methodology.
  • Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.
  • Organized meetings to discuss outstanding issues with QA and developers.
  • Wrote test scripts for User Acceptance Testing (UAT).

Hire Now