ERIC NANA-ATOO

Business Analyst

**+ years

Government Experience (Federal Reserve)

* ****

Requirement Elicitation & Analysis/JAD Sessions

+ years

Agile/Waterfall Methodologies

10+ years

Business Process/Re-engineering Experience

5+

Data Mapping/Data Modelling/ ETL

7+

Coordinating business users, technical staff, and architects to help analyze and define future needs and operations based upon use case and analysis of alternatives

9+

Tools

Visio, MS Office, Excel, Powerpoint, SQL, Azure DevOps, Rally, ALM

Communication Skills

Excllent

Location

Davie, FL

Availability

2 weeks

SUMMARY:

Detailed-oriented professional with 9+ years of IT Business Analyst experience in the Healthcare, Financial, Government, Insurance, Banking, and Commercial Mortgage Backed securities (CMBS)

EDUCATION:

Principia College, Elsah, IL; BA Economics and Business Administration, 2001 -2005

TECHNICAL COMPETENCE:

Experience with various SDLC including agile and UML modeling

Experience writing Business Requirement Document (BRD), Use Case and User Acceptance Testing.

Experience in SQL Server 2008, 2012 & 2014 platforms

SQL Server Management Studio, DTS, SSIS, SSRS, SSAS, Query Analyzer, Visual Studio

ERD, Data warehouse & modeling experience

Strong SQL query skills.

Experience in developing complex stored procedures and cursors

Experience with Tableau and Power BI dashboard development

Experience in Microsoft Office suite including Visio

Business Intelligence

Windows Server 2003, 2008, 2012

PC Tech and Desktop skills

FORMAL SKILLS:

SOFTWARE MS SQL Server 2005/2008/2012, Teradata 12/13, MySQL 5.2, 5.7, Oracle 9i, 10g, 11g, DB2

OTHER Informatica Power Center 8.6.1/9, SSIS (Visual Studio), ER Data Architect, Erwin Data Modeler, ER

Assistant, Tableau 9.1, 9.2, 9.3, Business Object xi3.1, Cognos, Excel, SSRS, REST and SOAP APIs.

PROFESSIONAL EXPERIENCE:

Blue Cross Blue Shield of Florida, Jacksonville, FL August 2019 – Current

Business Systems Analyst

Analyze business needs to determine technical requirements and identified impacted areas/systems/processes and evaluates alternative solutions.

Designs, develop, documents, test or support modification of computer programs and systems

Researches and assists in designs solutions for general maintenance requests to resolve system problems

Prepares detailed system requirements and assists in functional design solutions for new products/functionality and enhancements to existing products/functionality

Provide oversight and final review of design specification with Product Owner and Dev team

Assigned to highly complex projects and systems and take the initiative to seek out areas of improvement

Provides input into forecasting and project-planning for scope/requirements documents and/or vendor contracts to minimize risk to on time, cost effective solution fulfillment.

Leads a systematic process for capturing requirements.

Works with partners to capture requirements in a standard format that can serve as the foundation for developing technical documentation.

Using SDLC processes and associated tools, analyzes current system targeted for replacement/enhancement to determine business and technical functions to be included in design.

Prepare data mapping documents for moving data from one source systems to target systems.

Works with Developers and other IT staff to determine system components and functional flow of components and data between components.

Validates the design documentation with the appropriate parties and receives approval on these documents.

Reviews final design documents to ensure that they clearly explain the work expectations.

Continuously assesses systems as business direction changes for impacts to existing designs.

Partner with developers and other IT staff to ensure the design fulfills business and technical requirements

Rialto Capital Management Group, LLC, Miami FL April 2018 – May-2019

Technical Business Analyst/Data Modeler

led requirement gathering sessions among senior management groups and stakeholders to elicit and document requirements for Business intelligence (BI) integration project, automating reports, re-engineering business processes and posting data into different functional units.

Created User Stories, Features, Epics using Microsoft Azure DevOps in documenting detailed requirements for developers.

Conducted Backlog Grooming in explaining details of elicited requirement to developers and the team in an agile and waterfall environment.

Conducted Sprint Daily Standups to facilitate sprint progress and ensure burndown chart moves in the right direction

Conducted sprint planning with a 14-member agile team in setting and managing expectation for the sprint

Conducted UAT sessions to Senior Management Group and Business Users

Provided SQL analysis and resolution to discrepancies arriving in reports generated data.

Elicited requirement in modeling Database and generating scripts to create the Database tables.

Used ER Studio Data Architect for data modeling, modeling conceptual, logical and physical data models for SQL Server and Big Data Environment – Microsoft Azure platform to include both OLTP (Operational Data Store) and Dimensional Data Modeling

Used Power BI to analyze and generate reports for Business and perform demo to the reports.

Created Source to Target data Mapping Documents and generated Scripts for Database

Public Consulting Group, Inc. Washington DC November 2015 – November 2017

Technical Business Analyst

Provided SQL Analytical and reporting support for a data aggregation and analytical project to determine bank risk in a SQL Server environment.

Created a detailed functional and non-functional specification document for moving an old windows legacy system into and IOS environment for service technicians and managerial groups.

Conducted stakeholder interviews, elicited, analyzed, refined, completed and documented requirements and user stories for an agile team.

Created functional solution design and business process models in re-engineering service technician’s service protocols and overall business processes.

Wrote use cases and created use case diagrams in describing detail processes to help guide developers.

Conducted JAD session with management, SME, users and other stakeholders for adding newer features and moving an application into a newer system.

Designed and created tables, stored procedures, views and indexes.

Created workflow designs and used MS Excel to do data analysis, using pivot tables, VLOOKUP and functions.

Perform ETL tasks extracting data from multiple data sources and developed reports using Tableau and MS Excel.

Elicited, analyzed and refined business requirements from stakeholders, documents and reports and generated solutions.

Created Data Model Diagrams, Source to Target mapping document and Data Models using Erwin Data Modeler

Created Star Schema, Snowflake and operational data stores (OLTP) and data vault models.

Sandlot Solutions/Healthcare, Irving, TX December 2014 – November 2015

Technical Business Analyst

Conducted JAD Sessions and face to face interviews to elicit, analyze, document and understand requirements and business rules.

Created detailed functional specification documents for developing EHR for physicians’ practice groups and emergency services

Maintained patients’ information and supported the company’s healthcare software functions and training.

Performed Ad-hoc data extraction through queries in SQL Server 2012 and MS Access and presented report in MS Excel and SSRS.

Performed data migration and data integration development tasks to put data in a centralized location.

Used reverse engineering in creating Data Models and Data Model Diagrams

Weekly analysis of new data entered into database

Invesco Funds Group Boston, Massachusetts May 2013 – November 2014

Technical Business Analyst

Interviewed Business Users to gather functional, business and technical Requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.

Conducted extensive requirement analysis and user acceptance testing (UAT), collaborating with QA team to develop test plans and scenarios.

Helped the PM with strategic planning and sprint planning

Created complex SQL queries and scripts to extract and aggregate data to validate the accuracy of the data relating to Mutual Funds and Money Markets.

Performed database design, performance tuning, index analysis and T-SQL programing.

Performed daily integration and ETL tasks by extracting, transforming and loading data to and from different SQL Server databases with Informatica Powercenter

Performed Gap Analysis between SSIS and Informatica for switching to Informatica

Performed data analysis with MS Excel, using VLOOKUP, pivot tables, and excel formulas.

Cleaned, analyzed and validated invalid and missing data to ensure high data quality.

Identified and document limitations in data quality that jeopardize the ability of internal and external data analysts

Translated Mutual Funds and Capital Assets data into visual representation of information and present to appropriate department in an agile team.

Used Erwin Data Modeler for creating data vaults, star schema, snowflake and ER data models and operational data stores (OLTP) for over 100 entities relating to Mutual Funds and Capital Markets.

US Bank St. Louis, Missouri Dec 2009 – March 2013

Data/Business Analyst

Helped elicit, document, analyze and complete business requirements.

Played the role of a scribe in a JAD session

Worked with users and developers to verify impacts of changes to design and cost estimates of the designs.

Performed data modeling and ETL functions and data mapping for several systems using Microsoft Visual Studio 2010 for source control, Visual Studio 2008 for data mapping, and Microsoft SQL Server Management studio to hold code and run stored procedures.

Monitor, review and facilitate SharePoint-based Enterprise Change Management process.

Extracted, analyzed and built reports using MS Excel and Tableau.

Extensive use of T-SQL in writing Stored Procedures, Tables, User Defined Functions, Views and Indexes.

Users and developers were virtually connected throughout the United States. The project was to process mortgage loans for the various government refinance programs. We used government established rules to categorize loans as meeting (HAMP, FHA and FNMA) authorized refinancing options.

Contact this candidate