Sonji Ketiku
Bartlesville, OK
*****.**@*****.***
SENIOR IT BUSINESS SYSTEM ANALYST
SUMMARY:
* ***** ** ********* ********** as business analyst, business system analyst and data analyst.
Proficiency in business process and system analysis serving as an effective primary liaison between the business and technology groups.
Strong experience as a business system analyst in various functions including risk management, regulatory standards and reporting.
Expert in data analysis using various tools and writing SQL queries against various databases including Oracle
Effective leader and active participant in managing various aspects of full life cycle project including budget analysis, project scope and milestones, resource allocation, risk management, requirements gathering, requirements analysis and management, GAP analysis, quality assurance and testing and implementation.
Operations and Management Strengths
Includes: large and small project management experience, change management development, end-to-end system development life cycle requirements management, project risk assessment, software mitigation, stakeholder communication, quality assurance, technical documentation, operational and functional project alignment, data standardization, and proficient with SQL queries to support development of reports and dashboards.
Technical Experience
Operating Systems : MS Windows: Windows 7&8, Vista, XP, Mobile, Phone, SQL Server, Exchange, EHR, EMR, ClearHealth, iRise; Linux ( Google Chrome OS), Mac OS
Software Application: Oracle E-Business Suite (Supply chain, Inventory Mgmt, HR, Account Payable), MS Office (Project, Visio, Access, Power Point, Excel, Word, OneNote, Publisher, Outlook, Visual), MySQL, Teradata, Nexus DB, Sybase, Crystal Reports, SAP, Salesforce.com, ADP
ERP App Software: Microsoft Dynamics AX, SaaS (Saleforce.com, Legal Hold Pro), SharePoint 2007-2013, SAP Business All-in-One, Oracle E-Business Suite, JD Edwards, PeopleSoft, SQL Ledger, Epicor Enterprise, NetSuite, Primavera P3/P6
Project experience
SDLC Methodology: Agile & Waterfall
Requirement Skills: Experienced developing: RFP, project charter, business rules, business Requirements, functional requirements, non-functional requirements, user stories, design specification, test scripts, business workflow diagram, system test plans, end-user training material, use cases, end-user acceptance criteria
Professional Development/ Certifications/ Courses:
Year
Training Program
Training Source
2015
Detailing Business Data Requirements
B2T Training (LG&E IT BA Training Course)
2014
SharePoint Administration
LG&E SharePoint 2013 Training Course
2012
Centers for Medicare & Medicaid Services (CMS)
Oklahoma Healthcare Authority (OHCA)
Received 2009
Certified Business Analyst Professional (CBAP)
International Institute of Business Analysis (IIBA)
2005
SAS Certified Base Programmer for SAS9
SAS Institute
2004
Medicaid level One Certification
Stillwater Medical Center
Professional Experience:
Client: Louisville Gas & Electric – KU, PPL Company (Louisville, KY) Oct 2014 – Present
Title: Senior IT Business System Analyst (Consultant)
Responsibilities:
Translate formal business specifications into requirements document by walkthrough sessions with the technical team and business stakeholders
Blend technical and non-technical perspectives in verbal and written communications, focusing on the underlying business benefit and/or impact of proposed action
Facilitate and elicit requirement gathering meetings using agile or waterfall methodology
Build appropriate documentation which may include business requirements documents, functional/ non-functional requirements documents, process workflows diagrams, use cases
Send out minutes from requirement gathering meetings and track any action items
Fulfill agile methodology two week sprint requirement deliverables deadline
Gather requirements throughout SDLC from the client/ end users of the system
Maintained channels of organizational communication and acted as the point of contact between teams
Provide project/ task status updates during weekly steering committee meeting
Client: State of Texas, CVS Caremark (Richardson, TX) May 2013 – July 2014
Projects: Healthcare Domain, Medicaid Claims Capability Improvement
Title: Senior IT Business System Maintenance Analyst (Consultant)
Responsibilities:
Create and maintain narrative Use Cases (business use cases, system use cases), business process decomposition diagrams, project activity diagram, and data flow diagrams using MS Visio.
Performed gap analysis between current and future state requirements using iRise and visio.
Participate in business decision making by performing waterfall and agile methodologies, project analysis, producing decision documents, and facilitate decision meetings as needed.
Performed on-call responsibility for system de-begging
Fulfill agile methodology 10 day sprint requirement deliverables deadline
Facilitated and led group discussions to elicit requirements in Joint Application Development (JAD) sessions by presenting and verbally communicating documented requirements, business system prototypes, and As-Is/ To-Be work flow process diagrams.
Engaged in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
Organized and facilitated daily morning scrum meetings to track project sprint deliverables
Create current state gap analysis workflow Visio diagrams
Client: State of Oklahoma & Hewlett Packard (OKC, OK) Jun 2012 - Mar 2013
Project: Medicare Management Information Technology
Title: IT Business System Development Analyst (Consultant)
Responsibilities:
Documented the Use Cases and prepared the Use Case, Activity, Logical, Component and Deployment views using MS Visio and Rational Rose for a clear understanding of the requirements by the development team.
Used iRise to optimize the elicitation of requirements and managing scope of the project. Requirements captured in iRise are managed with the iRise.
Developed Test cases to perform GUI functionality testing
Aided in support and administration of SharePoint servers including; authentication issues, site templates, AD user account integration, and troubleshooting.
Created a requirements traceability matrix so each requirement was uniquely identified
Analyzed design specification to simple ETL coding and mapping standards.
Client: Best Buy Corp (Minneapolis, MN) April 2010 – May 2012
Project: Salesforce.com Implementation
Title: IT Business System Development Analyst (Consultant)
Responsibilities:
SharePoint development: InfoPath and SP Designer creating custom lists, libraries, workflows and forms
Developed screen mock-up’s using iRise Studio.
Customized page layouts for Campaigns, Leads, Opportunity, Contacts and Accounts depending upon user roles, and groups.
Developed SQR Interfaces (inbound & outbound) and Reports to load data from external systems into PeopleSoft GL.
Developed an automated system to upload of HRMS transactions into PeopleSoft. For this an Application Engine program and Component Interface was used to insert data into PeopleSoft HRMS Tables.
Primary and secondary support to PeopleSoft Finance and HRMS application.
Developed training material, and new in-house training methodologies
Design and integrate business processes and data flows between CRM applications and other applications, such as back office/ERP applications
Client: Flintco Construction Management (Stillwater, OK) Sep 2007 – Mar 2010
Project: Information System / Implementation
Title: IT Financial Business System Analyst
Responsibilities:
Developed queries using SQR and crystal reports
Tracked and managed project assigned tasks including; project planning, development, requirements, and testing
Supervised cross-functional teams, evaluated change requests, and tracked costs. Guided SDLC to ensure project timelines were met and charged hours remain within budget.
Prioritized, plan and managed multiple projects using Oracle Project Management Tool
Reviewed design documents, requirements analysis specifications with project managers, business owners and the technical leads to report requirement updates that potentially cause project schedule adjustment.
Created, maintained, tracked, scheduled and reviewed schedules per customers’ requirements and laid out the schedule in WBS standard and reviewed bi-weekly with customer or vendor on the status of the significant path.
Facilitate status meetings and provided meeting minutes
Client: Stillwater Medical Center (Stillwater, OK) Nov 2004 – Jul 2007
Projects: Information System / Healthcare Domain / EHR Implementation
Title: IT Data System Analyst
Responsibilities:
Transform processes/toolsets of geographically dispersed medical units into a cohesive, standardized set of solutions that elevated efficiency and accuracy across the company.
Understanding and documenting business processes and workflows and their relationships to current and future software solutions.
Gathered and created custom solutions to resolve issues (system slowdowns, virus outbreaks and process bottlenecks); and developed functional specifications.
Created flow diagrams for adequate matching of claims.
Performed data mapping flows by comparing the billing file and EDI claim file record claims received from Medicare and Medicaid agencies.
Validated the following: 837 (Health Care Claims for Encounters), 835 (Health Care Claims payment/ Remittance), 270/271 (Eligibility request/Response), 834 (Enrollment/ Dis-enrollment to a health plan) for Part A & B of Medicare health claims.
Education:
Mid-America Christian University Oklahoma City, OK
Masters of Business Administration (MBA)
Masters of Leadership in Business
Oklahoma State University Stillwater, OK
Bachelors of Business Economics Arts & Science
Minor in Pre-health Science
Minor in Business Accounting