Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Rehman Mehbubor

Columbus,Ohio

Summary

Innovative Business Analyst and Project Management Leader offering more than 10 years of progressive Information Technology expertise with background in design, development, and deployment of global solutions. Extensive expertise developing and implementing cross-functional department processes and methodologies, with specialized expertise creating and managing program level business requirements, performing gap and impact analysis, and designing process and system improvements. ServiceNow and JIRA experience. Exceptional ability to translate complex technical concepts into tangible business outcomes. Product Owner experience. Accomplished leader bringing clarity, direction, and execution to project teams by bridging specialized expertise in strategic planning using Agile Methodology.

Overview

18
18
years of professional experience
1
1
Certification

Work History

Sr. Systems Analyst

Sedgwick USA
05.2022 - Current
  • Working as a Senior Analyst for global Walmart Absent Management Systems
  • Creating and delivering end to end business and technical requirements
  • Creating traceability, process flows, system diagrams, rapid prototypes, and screen mock ups
  • Extensively worked on Business Process Re-Engineering and IT process streamlining
  • Performing system analyses on software programs, applications, and web services
  • Determining system efficiency and functionality by maintain liaison between the internal departments and the end-users
  • Reporting to Management and obtaining approval for system development projects
  • Efficiently integrating new systems, programs, and applications with business operations and services
  • Promoting system efficiency and security by integrating performance metrics
  • Implementing new upgrades and advancements of application systems and enterprise architecture
  • Produce data maps between source and target system
  • Communicate with 3rd party and partners to address technical issues and or change requests
  • Schedule plan and lead requirement gathering and review meetings
  • Communicate key decisions and action items
  • Analyze existing software applications and document all functionalities
  • Work closely with product owner and Scrum Master for Story boarding and Sprint planning
  • Design and development to convert business requirements into a developer friendly specification.

Sr. Systems Analyst

America Electric Power (AEP)
02.2020 - 11.2021
  • Worked as part of an Agile Scrum team to deliver high quality, secure, robust and scalable solutions that align with stakeholder expectations
  • Engaged with domain and subject matter experts to identify, develop, document, validate and endorse the requirements of their unit, demonstrating Agile behaviors that emphasize collaboration, delivery, reflection and improvement
  • Understanding AEP’s key business lines/processes (Generation, Transmission and Distribution) translating them into clear and structured requirements by conducting various elicitation techniques (such as, Brainstorming, Story mapping, Business process mapping, Interviewing, Focus Group Workshops, Interface Analysis, and Prototyping)
  • Facilitated and participated in relevant Scrum ceremonies and rituals (Backlog Refinement, Daily Stand-up, Iteration / Release Planning, Sprint Review, Retrospective, etc.)
  • Actively collaborated with other teams and cost centers to manage cross-functional dependencies and align the strategic goals for AEP’s Distribution division
  • Traced and catalogued data processes, transformation logic and manual adjustments to identify data governance issues
  • Highlighted Data Quality issues and areas of system control gaps
  • Defined and maintained effective communication (may it be face to face or on-line meetings) for concerned stakeholders (such as sponsors, departmental managers, architects, implementation group/partners, and quality assurance teams) to keep them aware of the project progress or roadblocks, if any
  • Extensively used JIRA and Service Now to manage, monitor and track story cards progress in the backlog and within sprints
  • Manage Change Control process and defect mitigation plans by providing guidelines for regression testing (RT) and user acceptance testing (UAT).

IT Analysis Sr. Consultant

Nationwide Insurance
Columbus, OH
06.2014 - 10.2019
  • Developed delivered end to end business and technical requirements for small projects to large programs for Property and Casualty side of Businesses / insurances
  • Created documents that may define, formulate, initiate and implement project/program requirements for the technical team to understand, develop, test and implement
  • Created requirements management plans and facilitate workshops to align responsibilities and scope of work for IT and business throughout the software development lifecycle (SDLC)
  • Created stakeholder requirements, functional and non-functional requirements, information management documents and align these to conform the decisions and objectives of the projects and or programs
  • Created traceability, process flows, system diagrams leveraging visual graphics such as Microsoft Visio
  • Reviewed and analyzed business and system processes, identify bottlenecks and redundancies and provide recommendations based on facts
  • Performed Gap Analysis between complex business processes and IT interfaces to understand and formulate the mitigation process
  • Facilitated, trained, guided and mentored junior analysts, team members and “Development Lines” (that may include Line Analysts, Developers and QA Analysts) in Agile environment
  • Provided guidelines to QA analysts, and tech leads in bug fixing by creating defect mitigation plan
  • Helped creating Business Process Modelling and Rapid Prototypes, Screen Mock Ups, UI and UX Designs
  • Worked on projects on Service Now, Clarity, SAS Grid (Cloud Technology), Click to Chat, Co Browse, Electronic Communication Archival (ECA)
  • Created User Cases, Story Cards Story mapping and store in RRC, RTC and JIRA
  • Extensively worked on Business Process Re-Engineering and IT processes, such as Operations Decision Management (ODM), Rapid Prototype and Robotic Process Automation (RPA).

Business Analyst / Project Portfolio Manager

State Auto Insurance
Columbus, OH
04.2009 - 06.2014
  • Performs responsibilities of a Project Portfolio Manager for SA Finance, Actuarial and Reinsurance Divisions
  • Actively manage the portfolio and prepare complex reinsurance financial, management and regulatory reports for the senior management
  • Interprets and validates applicability of reinsurance treaties
  • Identifies and gathers final bid information to update the portfolio database
  • Exhibits solid understanding of key regulatory implications on reinsurance processes to ensure compliance
  • Administers complex reinsurance processes, routine claims and update database with validated data through batch processing methods
  • Develop and track performance metrics; schedule risk and financial performance of assigned portfolio of programs/projects
  • Prepare and analyze business, technical and functional documents for SA Finance and Actuarial Division
  • Update project development matrix and monitor milestone project performance, facilitate meetings with lines of businesses, project team, QA testers and other stakeholders
  • Create and maintain General Accounting, Reinsurance and Accounts Payable departments’ crystal reports.

Business Analyst / Project Portfolio Manager

Consulting Firm
Columbus, OH
02.2006 - 03.2009
  • Client: Cardinal Health
  • Created functional documents for ADP data warehouse
  • Worked closely with Data architect to create mapping documents and ETL specifications
  • Worked in a team to create the semantic layer of Business Object universe for Info View reporting
  • Developed Pro Clarity visualization using SSIS cubes
  • Normalize and streamline IT and complex business process flows
  • Client: Office of Treasurer State of Ohio (TOS)
  • Developed reporting Use Cases detailing various enhancements for GrowNOW website following RUP methodology
  • Facilitated training session for Investment department stuff on Recon Processes and reporting
  • Completed detailed analysis of the website functionality to determine gaps between user interfaces and the application and analyzed data from the MS Visual.net server
  • Merged, consolidated and integrated Linked Deposit previously found in three different MS Access databases into one master database, including creating tables, queries, forms and macros
  • Set up new reconciliation process between QED Applications for investments and GrowNOW data and paper applications
  • Documented the analysis results of GrowNOW website after searching on various criteria, creating custom and ad hoc reports, and identifying process gaps, inefficiencies in functionality, improvement leads, and ways to fix bugs
  • Interviewed departmental SMEs and assessed data quality and data management
  • Audited the existing MS Access database of Investment Department where all tables of Linked Deposit/GrowNOW, Agriculture, and Flood Relief for Ohio reside
  • Client: Nationwide Bank – Bank Data Mart
  • Design, map, and create requirement documents of all financial data tables (including general ledger, deposits, and investment) that correlate to business processes
  • Provide source data files for bank data mart (Oracle) staging tables to upload target tables to the data store
  • Automate financial reporting in Business Objects (BO) which includes complex querying from Access, Oracle and BO Universe to feed Thrift Financial Reporting (TFR) Schedules
  • Created and formulated Derivation Rules for Deposits, Office of Investments and Loans (Mortgage, Consumer and Commercial) to specify particular source fields that may be derived and transformed to target tables in bank data mart
  • Created comprehensive user manual documenting business processes and functionalities of the newly created BO Universe
  • Customize managerial, financial and regulatory reports on Business Objects for Nationwide Bank’s Controller and CFO
  • Conduct BO Web Intelligence XI.2 training for Nationwide Bank Finance Group.

Education

Master of Business Administration (MBA) -

Franklin University
01.1998

Skills

  • Methodologies: Agile, RUP, SDLC, Consensus, ESDM, RRC, RTC
  • Project Tools: JIRA, Service Now, Project Portfolio Server (PPS), TOAD, Business Objects, MS Office, MS Visio, MS Project, Altova MLSpy,2016, RRC, Splunk, ODM Cloud, Crystal Reporting, Business Objects (BO), Pro Clarity, Consensus, SQL, SAP, Vision Data Warehouse (VDW), SAS Grid, Power BI

Certification

IIBA approved Certified Business Analyst (MACP)

Timeline

Sr. Systems Analyst

Sedgwick USA
05.2022 - Current

Sr. Systems Analyst

America Electric Power (AEP)
02.2020 - 11.2021

IT Analysis Sr. Consultant

Nationwide Insurance
06.2014 - 10.2019

Business Analyst / Project Portfolio Manager

State Auto Insurance
04.2009 - 06.2014

Business Analyst / Project Portfolio Manager

Consulting Firm
02.2006 - 03.2009

Master of Business Administration (MBA) -

Franklin University

Similar Profiles

CREATE PROFILE
Rehman Mehbubor