Data Analyst

PROFILE

Highly skilled IT professional with over Five (5) years of experience in the Healthcare, Financial and Banking domain. Excellent understanding of Business Intelligence, ETL and Analytics tools for the effective Analysis, Extraction, Manipulation, Research and Reporting of Data in different Visualization formats with the ability to translate them into clear and concise specifications. Proven ability to learn unfamiliar materials and master new concepts and technologies quickly, exhibits great attention to details with the ability to adapts to changing circumstances and systems to maintain strategic vision of the organization and the business logic.

TECHNICAL SKILLS

Operating Systems

Win XP, Vista, 7, Windows Server 2003, 2008(X32, X64), Unix

Databases

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

ETL/ Other Tools

Informatica Power Center 8.6.1/9, SAS Base 9.x, SAS Enterprise Guide, SSIS(Visual Studio), Erwin Data Modeler, ER Assistant

Management Tools

HP ALM, JIRA, MTM

Querying Tools

SQL Management Studio 2008/2012/2014, Teradata SQL Assistant, SQL Plus, SQL Developer, Teradata-BTEQ, PL/SQL

Querying Language

SQL, PL/SQL, TSQL

Business Intelligence Tools

Tableau 9.1, 9.2, 9.3, 10.4, Excel and PowerPivot, PowerBI, SSRS, SAS, Crystal Report

PROFESSIONAL EXPERIENCE

Bank Of America Laurel, MD August 2018 – Present

Senior BI Developer/ Analyst

Wrote complex SQL queries for extracting data using SQL concepts like Aggregate functions, JOINs, Sub-queries and derived tables to meet Business requirements.

Developed Database Triggers, Views, CTEs and Stored Procedures

Performed ad-hoc reporting analysis as well as manipulated complex data on MS SQL server.

Configured the Data mapping between Oracle and SQL Server, using SSIS.

Worked with QA analysts to perform routine testing of imported data and result sets.

Formatted reports with Excel using advanced excel functions: pivot tables, v-lookups, etc.

Utilized BI tools to Identify gaps through the study of discount data to revealed patterns in discounts that could easily be corrected thereby increasing revenue.

Gathered, analysed, and documented business requirements, and developed supporting materials such as use cases, flowcharts, models, specifications and reports.

Performed daily integration and ETL tasks by extracting, transforming, and loading data to and from different RDBMS.

Experienced in creating various views in Tableau such as Tree maps, Heat maps, Scatter plots.

Created quick filters, action filters, table calculations, calculated parameters and measures.

Performed Tableau Server admin duties, add users/groups from Active Directory and schedule instances in Tableau Server including weekly data dump.

Utilized SSIS for ETL data modeling, data migration, and analysis

Prepared high level analysis reports with Excel and Tableau.

Provides feedback on the quality of data including identification of billing patterns and outliers.

Created User stories, Motion charts, Bubble charts, drill down analysis using Tableau Desktop.

Responsible for developing, analyzing and reporting key risk indicator and key performance indicator metrics that enable management to make timely and effective decisions related to threats, risks and control requirements.

Strong ability in developing SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted.

Involved in the SDLC of multiple projects, utilizing Agile environment.

Johnson & Johnson Healthcare System New Brunswick, NJ May 2016 – July 2018 Business/Data Analyst

Generated KPI’s for customer satisfaction survey results.

Maintain test log and test evaluation summary reports.

Maintain departmental metrics in accordance with goal plan

Maintain test log and test evaluation summary reports

Implemented hierarchies in Tableau with portfolio as the highest level followed by application and project details

Responsible for the interaction with business stakeholders, gathering and managing delivery of reports.

Created Visualizations for logistics calculation and department spending analysis.

Created users, adding users to user site, adding users to a group of viewing, editing, deleting and activating their Licenses, distributed environments, installing worker servers, maintaining a distributed environment, high availability.

Worked on SQL control files to load data through SQL Loader & Oracle data pump.

Experienced in Data mapping, Data transformation between sources to target data models.

Extensive experience in creating interactive dashboards and the application of Global filters/Action filters.

Harmonizing disparate data sources for use in tableau by leveraging data blending and joins.

Developed complex Proc SQL queries within SAS environment using advanced SQL concepts like aggregate functions, group by, string functions and joins.

Used statistical techniques such as regression, cluster analysis, factor analysis, time series forecasting, experimental and design, etc. to solve business problems

Used SAS to solve problems with data and analytics

Developed and produced peer quality metric performance: validated data and processes to ensure accuracy, completeness, and consistency of data using SAS.

Created, Organized, Customized analysis, and Visualized Projects and Dashboard to present to Senior level Executives.

Created demos in Tableau Desktop and published onto Tableau Server

Provided data architecture and modeling to ensure that data within the Claims Management System (CMR) was in line with compliance guidelines.

Performed data integration and configuration using SSIS.

Worked with a team of QA testers, inserted checkpoints in Oracle database to check the functionality and data integrity of the AUT.

Performed ETL data loads from flat files, DB2, Teradata, PL/SQL etc. to transform data into complex scripts and codes for software application testing

Enhanced the PL/SQL test scripts for data driven tests

Conducted JAD sessions with CMS and other stakeholders to identify, document and communicate business and system requirements.

Converted user requirements into business requirements, analyzed the same, and segregated them into high level and low-level business requirements

Worked with the ETL Process which includes SSAS, SSIS, and SSRS. Worked with Business Intelligent tools, including Tableau and Power BI on SQL server mainframe.

Newark Community Health Center Inc, Irvington, NJ April 2015 – May 2016

Data Analyst/Tableau

Utilized data visualization tools, including Power BI and Tableau, to provide an easy-to-understand interface to end-users for quick identification of key themes within Data.

Per client requirement, designed and created reports using Excel file, SQL Server and Oracle databases.

Created Tableau dashboards using stack bars, bar graphs, scattered plots, geographical maps, heat maps, bullet charts, etc to demonstrate key information for decision making.

Utilized SAS, and other software, to provide ad hoc reporting, tables and listings and graphs for clinical trial data, regulatory submissions, Risk-Based Monitoring, and publications.

Developed and produced peer quality metric performance: validated data and processes to ensure accuracy, completeness, and consistency of data using SAS.

Extracted, manipulated and built complex formulas in Tableau, in addition to using LOD calculations, for various business calculations.

Involved in resolving to report and designing issues throughout the reporting life cycle.

Demonstrated strong ability in developing SQL queries to extract, manipulate, and/or calculate information to fulfil data and reporting requirements including identifying the tables and columns from which data is extracted.

Worked in an Agile Environment.

Daily interactions with several groups to achieve a common deliverable based on the business requirements

Involved in the SDLC of projects

Responsible for interactions between stakeholders, requirement gathering and managing delivery.

EDUCATION AND QUALIFICATIONS

University of Liberia Bachelor of Technology in Information Technology

Contact this candidate