Data Manager
Resume:
Ola Komolafe
**** ******** **** ****** **, ****4
adaxgx@r.postjobfree.com
Summary
Domain
•Over 8 years of professional experience as a Business Analyst in multiple industries including Healthcare, Finance, Manufacturing and Retail.
•Understanding of various financial instruments like Fixed Income, Swaps, Equities, Derivatives (Options, Forwards & Futures) including the corporate actions, Risk models for credit risk, fixed income quantitative models.
EXPERTISE
•Expertise in Business Analysis, Data Analysis, Business Rules, Business Process Modeling, GAP Analysis and creating business process documents.Implementation.
•Developed Project Plans, Functional Specifications, High-Level Designs for Business Process Refinement, Re-Engineering, Business Intelligence and Automation.
•Frequently conducted JAD sessions with management, vendors, users, and stakeholders for open and pending issues. Great facilitation skills in conducting walkthroughs, questionnaires, interviews, and JAD/JAR sessions.
DELIVERABLES
•Proficient in creating Business Requirements Documents (BRD’s), Use Case Specifications, Functional Requirement Documents (FRD’s), High-Level Designs, Technical Designs, and Workflows.
SQL
•Extensively used SQL for data manipulation such as to select, modify, delete and retrieve data and also to insert, delete or update records to a database.
•Good understanding of RDBMS concepts such as “Entity & Referential Integrity constraints”, familiar with stored procedures and triggers.
METHODOLOGIES
•Comprehensive knowledge about all stages of Software Development Life Cycle (SDLC).
•Worked with different methodologies such as SDLC, Agile, and Rational Unified Process (RUP).
QUALITY ASSURANCE
•Conducted Pre-UAT and User Accepting Testing (UAT) cycles with users and stakeholders, prepare Standard Operating Procedures (SOPs).
•Ability to analyze functional requirements, translates them into test cases, and prepares a Detailed Test Plan Specification utilizing knowledge of the functional application, Reviews of Test Cases and Documentation.
TECHNICAL SKILLS
MS-Office 2010: Word, Excel, PowerPoint, Outlook.
Content Management: Microsoft SharePoint Server, Knowledge Share Link
Testing / Reporting Tools: Quality Center 9.0, Crystal Report, and SSRS/SSIS.
Use Case Modeling: MS Visio 2008/2010.
CORE COMPETENCIES
Business Analysis / Business Integration
Business Requirement Document (BRD)
Software Development Lifecycle (SDLC), RUP
Use Case Document
Unified Modeling Language (UML)
Software Requirements Specification(SRS)
Requirement Scoping, Requirement Gathering, Requirement Elicitation
Functional and Non-functional Specification
Use case management
UML Diagrams MS Viso
Test Case Management / UAT
Business Process Document
Content Management
Prototypes (using Visio / PowerPoint)
Change Management
Training and User Manual
EDUCATION
Master of Business Administration, Project Management: Dallas Baptist University, Dallas, TX.
Bachelors in Science: OAU University, Ile-Ife, Osun State, Nigeria.
CERTIFICATION
Licenses/Certifications: Diploma in Informational Technology
PROFESSIONAL EXPERIENCE
AT&T
Product Owner/Business Analyst Nov 2017 - Current
• Generated automated reports by writing a macro using VB scripting which automatically cleaned data and calculated the risk percentage for all merchant processing accounts reducing 3 hours of daily data analysis time .
• Generated a forecasting report in Excel to predict future revenue by performing a data analysis on past and current data.
• Work with development, Chief Data Office to develop Data products, Data libraries, Mapping Interfaces and Applications to Data products and Data Libraries.
• Work with Data Architects and Analysts to develop Data libraries in central repository i.e AT&TWiki page and Data 360 for all mapped Interfaces and Applications.
• I researched huge number of Applications, Interfaces, Schemas and Tables based on various platforms ( Hadoop Hives, Teradata, EDW, eCDW, Vertical) and also reaserchesd their AIDs, User’s Stories and SLAs.
•Document results of JIRA workflows and process audits
•Assisting staff users with wiki design, integration & authoring
•Develop guides and documentation for JIRA features and best practices
•Strong knowledge of the underlying JIRA database structures
•Able to show in depth knowledge of confluence, Jira, bitbucket, and bamboo
• Work with development teams to create data products and other external materials
• Perform competitor analysis to benchmark improvements to our place data.
•Maintain a product management framework for all your product.
• Manage the development and implementation of new products and major product enhancements
• Created and maintain Application Reports for internal purpose and for business client with the help of SQL Queries and reporting tool.
• Creation of SQL queries to provide Operation critical data and reports
• Created SQL/UNIX script to check release errors on daily basis.
•Defined and documented business requirements. Mapped business requirements to standard SAP functionalities, perform gap analysis and design customization specifications.
•Configured FI application including GL and AP.
Product Owner/Business Analyst July 2013 –Nov 2017.
GE Health Care
6860 DALLAS PKWY Plano TX USA-75024-4232
Responsibilities:
•Generated a streamline process to understand the various steps of business process and desired functionality of the system by interacting with users, management, SME’s (Subject Matter Experts).
•Performed requirement analysis by gathering both functional, and non-functional requirements based on interaction with the process owners & SME’s and Document Analysis.
•Identified and documented issues, risks and gaps, their description, their impact and provided recommendation and alternatives to develop the application to meet the user requirement.
•Involved in back end testing using SQL Queries on Microsoft SQL Server 2008.
•Created Business Requirement Document, System Requirement Specification, High-Level Design Document, and Functional Requirement Document according to the User requirements and uploaded the document in Knowledge Link.
•Created SSIS packages for File Transfer from one location to the other using FTP task with Master SSIS Package to run all other packages
•Executed batch files using SQL Agent and developed Stored Procedures for schedules, reports and other client interfaces.
• Experienced in designing customized interactive dashboards in Tableau using Marks, Action, filters, parameter, calculations and Relationships. .
• Used SQL Server Integration Services (SSIS) to populate data from various data sources using the concept of OLEDB.
•Collecting and analyzing complex data using advanced excel techniques like VLOOKUP, pivot tables, goal seeker, etc to investigate potential risks involved in merchant account processing, to find potential fraud patterns.
•Prepared functional Unit and Integration Test Scripts for FI Journal, GL recurring entries.
•Accrual month-end postings, FI Invoicing, house banks, payment program, Inter-company clearing Items, and cash application.
•Executed testing and performed defect management using Test Director.
,
•Followed the RUP methodology for the entire SDLC.
•Coordinated with SQL Server DBA and SQL Developers for Migration/Conversion of Control-Z (Progress Database), Mortgage ware (SQL server 2000), Empower CONA (SQL server 2000), and GPM Empower (Oracle 9i) into SQL Server 2008R2.
•Expertise In Extracting, Transforming And Loading (Etl) Data From Excel, Flat File, To Ms Sql Server By Using Dts And Ssis Services. Develop Clinical Content For Cps And Emr Products Which Include Standard Terminologies Such As Icd-9, Icd-10, Loinc, Snommed Ct(Xml Files) Through Application, Storing, Releasing, Versioning And Generating Output Files(.Txt Files)Which Are Consumable For Various Ge Healthcare Departments.
•Designed and implemented Parameterized, Cascading parameterized, Drill -through and Tabular reports using SSRS.
•Set Up And Maintain Health Language\Ge Clinical Environment Which Includes The Lexscape(Production) And Leap Environments(Mapping). The Lexscape Is Where Ge Clinical Contents Qa, Updates Application And Processing, Import Terms\Mapping Into Lexscape, Release And Version Ge Content, Generate Data Cache, Backup & Restore Database For Release, Cedpi Documentation, Generating The Differential File And Delta Report.
Double Line Partners, Austin, TX August 2012 – July 2013
Business Analyst
Responsibilities:
•Responsible for managing and maintaining relationships with clients as they pertained to new enhancements, GAP analysis, monthly reporting, and current expectations.
•Documented system Non-Functional requirements (NFR’s) for data backup/recovery, security, high availability and performance/response time.
•Designed and developed Use Cases, activity diagrams using UML
•Documented and managed the completion of functional requirements and obtained sign-off for functional requirements from necessary parties.
•Conducted workflow, process diagram, and Gap analyses to derive requirements for existing systems enhancements.
•Assist with user acceptance testing of systems (UAT), developing and maintain quality procedures, and ensuring that appropriate documentation is in place.
•Responsible for the gathering of requirements, from clients, completing business analysis, and writing of the Data Dictionary, Preliminary and Final Function.
•Wrote Functional Specifications for a large domestic fixed income system.
•Responsible for the management of the software process from requirements gathering, documentation, management approval, client approval, development, to testing and final presentation to the client.
•Worked with development and testing teams to accomplish timely release objectives.
•Using detailed knowledge of application features and functions assess scope and impact of business needs throughout analysis and completion of all enhancement specifications.
•Developed timelines for project delivery, and managed projects and resources to successful completion.
•Extensively work on Access, Excel, Word, PowerPoint, MS SQL, and MS Project.
•Used detailed knowledge of application features and functions, assessed scope and impact of business needs throughout analysis and completion of all enhancement specifications.
Environment: Rational RequisitePro 7.1.1, Rational Clear Case, MS Visio 2010, MS Office 2010, UML, SQL Server 2008.
.
Home Depot, Atlanta, GA February 2010 – Aug 2012
Business Analyst
Responsibilities:
•Gathering requirements from business analysts with data validations for risk solutions.
•Producing and managed documentation on release activities to support problem resolution and post-release analysis.
•Creating Process Work flows, Functional Specifications, and responsible for preparing Software Requirement Specifications (SRS), Functional Requirement Document (FRD).
•Involving in process modeling, conducted & participated in Joint Application Development (JAD) sessions with System Users.
•Liaising with developers and users to clarify specifications as necessary.
•Involving in developing test case objectives to ensure accurate depiction and computation of risk of the securities, reported errors to the appropriate team.
•Working collaboratively with the User Experience Analysts, and System Analysts to help document custom and system modifications.
•Developing Traceability Matrix for maintaining/updating current and new system requirements using MS Excel.
•Auditing System availability & Performance using Excel based reporting Dashboard
•Reporting Presentation of Vendor system performance to Leadership
•Managing Extensive work with IT in process improvement, application research, and data vendor solutions. Developed process flows and system requirements when enhancements were requested.
•Developing system Use Cases for Client Web-site. Enabled developers and other stakeholders to understand the business process.
•Using problem and change management software to document work requests for release activities.
•Coordinating with teams within the organization to collect release requirements.
•Verifying the Business Scenarios on new builds to allow extended testing by the QA team.
•Using MS Visio to create business process flowcharts and workflow diagrams.
•Involving in detailing project mission, Data Process Flow Diagrams and timelines.
•Forming a bridge between the Project Manager and different teams with effective presentations.
•Preparing Workflow diagrams analyzed AS IS and TO BE scenarios, designed new process flows and documented the business process and various business scenarios.
•Involving in Functional testing of the application and co-ordinate with the QA for testing the coding of the application
•Assisting in the user acceptance test (UAT) and suggested recommendations for the applications
•Thorough documentation of the entire process along with all its activities.
Environment: Java, J2EE technology, SOA, SQL, PL/SQL, Windows 2000 Advanced Server, Liberty, UNIX / Oracle Platform, MS Visio, RUP, Agile, UAT, Rational Rose 2002, Rational Clear Quest, Rational Clear Case, Rational requisite pro, rational test manager, Rational Robot.
BHI, Austin, TX April 2009 - February 2010
Business Analyst
Responsibilities:
•Analyzed clients systems and business processes.
•Addressed all aspects of credit card business.
•Established a Business Analysis methodology around the Rational Unified Process
•Researched the various steps in the lifecycle and then constructed the system in a way that the High
•Risk customers would be easily identified and monitored
•Streamlined clerical work processes and mapped then into the new system
•Developed project plans and managed project scope
•Assisted in building a Business Analysis Process Model using Visio
•Performed extensive Requirement analysis and developed Use Cases and workflows
•Designed and developed Use Cases, Activity Diagrams, and Sequence Diagrams
•Played a key role in the Planning, User Accepted Testing, and Implementation of system enhancements and conversions
•Provided key input in working with users in defining project and system requirements
•Developed strategic partnerships with the business units to develop a solid knowledge base of the business line including the business plan, products, and process and revenue streams
•Documented and delivered Functional Specification Document to the project team
•Developed business requirement specification documents as well as high-level project plans.
•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
Environment: UML, Rational Requisite Pro, Rational Rose, MS Word, MS Power Point, MS Excel, MS Access 2003.
Database: MS SQL Server 2000/2005/2008/2012, Oracle 9i/8i/7.x DB2 UDB, MS Access 2000/7.0 and Teradata V2RX.
Testing Tools: Win Runner, Load Runner, Test Director, and Quick Test Pro.
Operating Systems: Microsoft Windows XP/2003/2000/9i/NT, IBM AIX UNIX 4.2, IBM OS/390
Contact this candidate