CHINELO JULIET NJOKU

add3cr@r.postjobfree.com www.linkedin.com/in/juliet-n-6438621ab +1-660-***-****

Detailed oriented and problem-solving Technical Business Data Analyst with 7 years of exceptional experience in project management, Agile methods, Leading Safe practices, and scrum processes having solid foundation and efficient working experience in Banking, Pharmaceutical, and IT domains. Exceptional leadership skills in managing, mentoring, and leading cross-functional teams in achieving high-reaching individual and organizational goals and objectives. Proven ability in successfully applying quantitative, analytical skills in evaluating data and recommending action plans. A proactive, analytical, and self-organized Business analyst with a good technical background, good years of experience in Scrum Master, Project Management, and Client management. Articulate communicator, with great emotional intelligence and proven track record of establishing solid relationships with key internal and external stakeholders to enhance organizational effectiveness.

Areas of Expertise:

Business Analysis

Written Communication

Team Leadership

Data Analytics

Business process mapping

Regulatory Compliance

Agile Project Management

Data modeling and Mining

Training and Development

Data Migration and Mapping

Data processing

Project Management

Digital Marketing

Risk Analysis and Management

Clinical Trial phases

Query Writing

Stakeholder Engagement

Financial Modeling

Data Manipulation

Quality Control

Interpersonal skill

Certifications:

Certified Scrum Master (CSM)

Certified RPA Business Analyst

Certified Google Analyst

AWS Certified Solution Architect-Associate (in view)

Technical Skills

SDLC

Waterfall, Agile, Scrum, Hybrid, TDD, SAfe, XP, Kanban

Modeling tools

MS Visio, Balsamiq, Tableau, Power BI, TriZetto FACETS, MS Excel, Alteryx, Oracle Argus, SSRS, SSIS

Business Analysis tools

SharePoint, JIRA, Rally, MS Project,

Operating Systems

Windows, Unix, Linux, VMware, IOS, Android,

Languages

SQL, PL SQL, Java, SAS,

ELN Tools

Dotmatic studies Notebook, eLabFTW, Benchling

Web Technologies

XML, HTML, SOAP, Web Services, Microservices CSS, AJAX

Defect Tracking Tools

HP ALM QC 11.0, Team Foundation Server 2011-2013

Testing Tools

Selenium, Microsoft Test Manager 2013, Jenkins, Kubernetes, SoapUI, Junit

Documentation

Microsoft Visio, Microsoft Office, MS PowerPoint

Compliance

ACID, HL7, Hipaa, ICD-10, EDI (834,835,820,276,277,270 & 271), FHIR, GxP, CFR, GCP, GLP, GMP, SOX, BITS, FDA, FIPS, FISMA

Protocols

Http, Https, SMTP, FTP, SOAP, REST

ETL

SAP Data Services, SAS Data Management, Alooma

Databases

SQL Server Management Studio, Oracle 11g – 12c, MS SQL Server 2012, MS Access,

PROFESSIONAL EXPERIENCE

Client: NWMSU Office of President August 2019- December 2019

Role: Business Analyst / Data analyst

Project: Enhancement of Comment Card System Location: Maryville MO

Scope: To enhance the legacy system by automating processes and adding new key functionalities and tools that will reduce the amount of time spent to process comment and provide feedback. Monitor process and streamline workflows among involved departments.

Acted as a Hybrid Business analyst and took up Project Manager responsibility to ensure that requirements get developed on a schedule.

Worked closely with Project manager and acted as a liaison among different functions in the organization.

Prepared artifacts like Project Charter, Work Breakdown Structure, RACI Matrix.

Elicit requirements through One on One interview, Active Observation, Brain Storming and performed analysis like Document analysis, GAP analysis, Root Cause analysis, Impact Analysis during various stages in the project.

Assisted in creating the Business Requirements Document (BRD) which consists of Summary, Scope, UML Diagrams, Use Cases and Business Requirements

Created wireframes, mockups and protypes for UI/UX developers using HTML and CSS.

Facilitated and took part in multiple Joint Application Development Sessions with Technical team and translated Functional Requirement into System Requirement Specification (SRS).

Facilitated a walkthrough session with Key stakeholders where business Artifacts was shared and signed off using SharePoint.

Involved in scripting business logic in the Web methods of the Web services and documenting the WSLA document using XML.

Integrated Microsoft dynamic 365 CRM Customer service module to monitor and improve the patient satisfaction.

Resolved patient issues and complains by creating cases using MD 365 (Microsoft dynamic) and following through to ensure that case is resolved.

Organized, prioritize, and monitored progress workflow of activities in Queues both public and private queues

Involved in setting up Operational Data Store (ODS) where data is Scrubbed, redundancy is resolved, and Compliance checked for corresponding business rules.

Participated in designing Data Marts, organizing reports and in Data Migration processes

Created reports, analyze data, visualizing data, and creating story using Tableau which helped to expedite decision making process.

Collaborated with the Data Analyst to design, build, and test ETL processes using Alooma Tool, Cleaning and Cleansing Data, Data Table Structures, Schemas, Data Marts and OLAP operations, Roll-up, Drill-down, Slice, Dice and Pivot.

Facilitated Testing sessions including User Acceptance Testing (UAT), designed Test Plans, Test Strategy and Manual Test cases.

Forwarded the tickets raised for Bugs and Enhancements in the Maintenance phase to the concerned team.

Documented the performance of the application in Pre-Production and Postproduction.

Client: Northwest Missouri State University January 2019-August 2019

Role: Business Analyst/Teaching Assistant Location: Maryville MO

Identified and categorized Stakeholders into Responsible, Accountable, Consult and inform using RACI Matrix

Created the Business Requirement Document (BRD) which includes Scope, Objectives, Risk, Budget etc.

Created UML Diagrams, DFDs, Context Flow Diagrams, ER Models and Use Cases.

Facilitated the Joint Application Development Session and Assisted in creating the Systems Requirement Document and put forward Class Diagram, Sequence Diagram and Communication Diagram.

Extensive use of SQL queries, to check the tables and the data in the database.

Involved in scripting business logic in the web methods of the web services and documenting the WSLA document using XML.

Worked with Subject Matter Expects (SME’s) in understanding how the organization manages IT services for customer, contributed towards consistent measuring and process improvement.

Actively Involved in setting up the SOA Architecture and performing Container Orchestration using Kubernetes.

Utilized PowerBI in interpreting and visualizing data for higher management decision making.

Developed data mapping spreadsheets for (ETL) team with source to target data mapping with physical naming standards, datatypes, volumetric, domain definitions, and corporate metadata definitions

Played an important role in setting up Web Services, Web Methods and implementing AJAX in various areas in the Application.

Assisted the team in setting up Client-Side Validation, Server-Side Validation and Database Side Validation.

Played a crucial role in setting up Business Rule Engine and External API’s.

Coordinated the execution of Unit Testing, System Integration Testing (SIT), Performance & Service level testing and User Acceptance Testing (UAT).

Facilitated several Triage calls whenever there was a Technical Bug, Functional Bug, Enhancement request.

Played a crucial role in Production Support and Going Live.

Client: Agary Pharmaceutical Limited November 2016 – July 2018

Role: Business Data Analyst

Project: Enhancement of CTMS & LIMS Location: Lagos Nigeria

Scope: To deploy a BPM solution (PerfectForms) that helps in implementing efficient and automate processes towards end- to- end approach that will concurrently provide visibility into clinical trial costs, Manage lab data, resources, workflow and regulatory risks, in other to reduce the burgeoning cost of clinical trial, easy record keeping and reporting.

Articulated project goals and scope, translated business needs into technical terms, prepared detailed work breakdown structures (WBS) and instilled shared accountability for achieving project milestones using MS Project

Elicited functional/non-functional requirements and conducted the reviews and walkthroughs with designers, developers, SME’s, and stakeholders

Performed Gap analysis, Impact analysis, Cost benefit analysis, Risk analysis, and ROI Analysis on the business requirements.

Created BRD, UML diagrams, wireframes, mockup screens, and dynamic prototyping using HTML.

Facilitated JAD Sessions and work together with developers and subject matter experts (SME's) in to establish technical vision and analyze tradeoffs between usability and performance need for BPM solution.

Collaborated with the business and technical teams to ensure deliverables are consumable and aligned with business needs.

Performed exploratory data analysis of both existing and new data sources. Transformed data to unified data sources.

Worked with the technical team to ensured that both the XML and JSON format support the proper integration with third party tools.

Worked closely with the organization SME’s in Understanding regulatory compliances such as Clinical Laboratory Improvement Amendments (CLIA), Good Laboratory Practices (GLP) and Good Automated Manufacturing Practice (GAMP)

Facilitated and worked closely with the validating team in performing CSV to ensure good organizational practices of some regulatory standards like GxP and FDA.

Assisted in Performing Orchestration processes for CTMS and LMS utilizing BPM Solution as an automation tool.

Worked with the development team in integrating API, Web services and Identify Web services with the help of UDDI and WSDL documents.

Worked closely with SME’s in utilizing Dotmatic Studies Notebook to capture, store and search experiments

Created new experiments, paste and lookup for reactions using Dotmatic Studies.

Actively involved in documenting and analyzing RFI/RFP in other to expedite Vendor selection and submission process.

Involved in performing ad-hoc Report and analyzing Pre-case and Post-cases using Oracle Argus.

Wrote SQL Queries which includes DDL, DML, Left Join, Right Join, Inner Join, Outer Join.

Extensively used XML in SOAP UI tool to test web services data in development phase.

Assisted the Data governance team by contributing the design and support for end to end Data management.

Used Tableau to answer additional questions within the dashboard, where viewers can dynamically filter, highlight, drill-down and link across the multiple views.

Created dashboards, Graphs, and Visualizations on data and provided support to daily, weekly, or monthly key performance indicator (KPI) reports and review meetings.

Involved in Data Analysis, Data Cleansing, Data Classification, Data Mining, Data Modeling, and Data Migration for understanding and outlining required data needs for visual reporting and dashboards.

Assisted in Data migration, mapping data from OLTP to OLAP by performing ETL processes and implementing data transformation rules.

Performed API testing using Postman and created API documentation of request and response parameters using Swagger tool

Worked Closely with the Test lead in adopting a BDD method and writing Acceptance Criteria following Gherkin Language for performing Unit testing.

Client: Ecobank Nigeria October 2015 – October 2016

Role: Business Analyst

Project: Enhancement of Wealth Management System Location: Lagos Nigeria

Scope: To improve the legacy system functionality by integrating a wide range of decision-making tools that will strengthen advisor decision and investment performance recommended to customers. It is targeted at improving better user experience across operational and compliance-related tasks that would automate processes and reduce (operational) risks.

Analyzed and translated business requirements into Functional Requirement utilizing UML in Waterfall methodology.

Conducted walkthrough session with business end users, Stakeholders, SME’s, Project Manager etc. to discuss and resolve various issues.

Conducted JAD sessions with key business users to make them understand the project scope and deliverables and to check the feasibility of the project.

Assisted in writing both Technical User Stories, and Functional User Stories including Acceptance Criteria

Interpreted and visualized data using Power BI in other to assist higher Management in making quick business decision.

Involved in Utilizing Power Query to pull data into power pivot from new data sources, such as XML, and file folders as refreshable connections.

Assisted in identifying Web services with the help of UDDI and WSDL documents.

Used various SQL commands like Create, Delete, Update, Inner, Outer, Left, and Right Joins to update the database and retrieve data for data analysis and validation along with creation of stub data.

Involved in the implementation of SOAP and Restful API services ensuring that its architectural constraints are well followed.

Assisted in the creation of Data Dictionary and facilitate different governance activities.

Involved in the use of SSRS in create reports with tables in form of data, Graphs, Images and Charts

Interpreting data and creating visual report dashboard with Tableau to help organization with high level decision making.

Involved in identifying trends through data analysis and querying methods by closely working with the senior data analyst.

Worked with the IT team in utilizing content management tools like SharePoint CMS in Managing content, creating, publishing content on the web.

Effectively used process improvement tools (Gantt charts, Pivot tables, Graphs) to display project schedules, evaluate and assess data, and isolate obstacles.

Assisted testing team in writing Test Plans, Test Scenarios, and Test cases. Planned, facilitated, and reported on quality assurance testing efforts.

Worked closely with development and QA team to identify solutions for system deficiencies

Client: New Horizons May 2013 – August 2015

Role: Intern IT Junior Data & Business Analyst Location: Nigeria

Provided assistant in the use of personal computer hardware, software, and specialized computer technologies

Provided customer services and monitoring progress to ensure customer satisfaction

Maintained and developed relationship matrix using Zoho CRM

Interpreting and visualizing data using Tableau and performing joins on different tables to visualize trend in data and relationship.

Maintained an Issue List to make sure the assigned owners for the defects are working as per the prioritized schedule and the interdependent bugs are resolved.

Worked closely with Technical team in implementing and hosting SSRS on client base server.

Wrote SQL Queries like DML, DDL, TCL, and worked as a database administrator giving and revoking users privileges within organization.

Monitored and restricted access to unauthorized users in other to keep everyone and business in check

Perform joins and retrieved data from multiple tables using their different.

Creation of business-process model diagrams, mock-ups, wireframes, and Data Modeling using MS Visio.

Maintained a Data Dictionary/Data Definition Matrix to provide detailed information about business data.

Operated multi-platform computer environment, monitored production scheduling, execution, and successful completion of production jobs

Education

M.Sc. Information Science

Northwest Missouri State University. Maryville MO

B.Sc. Computer Science

University of Nigeria Nsukka. Nigeria

Contact this candidate