Data Analyst

Email:adin92@r.postjobfree.com Maria Ake cell no:202-***-****

* * * * *

PROFESSIONAL PROFILE

A motivated and proactive IT professional with an extensive knowledge in ETL, Business Intelligence and Data Analysis gathered over the span of 6+ years in fields such as Healthcare, Business and Financial domain. Able to learn unfamiliar materials and techniques quickly, exhibit great attention to details, execute under aggressive deadlines, and adapt quickly to changing circumstances and systems to maintain strategic vision of the organization and link it with everyday work.

TECHNICAL SKILLS

Operating Systems Windows XP, Vista, 7, Windows Server 2003, 2008, 2010, R2(X32, X64), Unix Databases MS SQL Server 2005/2008/2012/2014, Teradata 12/13, MySQL 5.2, 5.7, Oracle 9i, 10g, 11g, v20.2, 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

Defect Management Tools HP ALM, JIRA, GitHub, 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.2, 10.4, 20.2, 20.3. Excel and PowerPivot, PowerBI, SSRS, SAS, Crystal Report

PROFESSIONAL EXPERIENCE

RAZOR TALENT AT BOOZ ALLEN HAMILTON, Remote July 2020 - Present Tableau Developer

Responsibilities:

Creating dashboards by leveraging techniques such as parameters, filters, sets, groups, and table calculations for a granular and drill-down perspective of the reports.

Creates drill through reports and variance dashboard using tableau to assist the UAT for data validation.

Executes data queries across multiple data sources in support of business intelligence reporting needs.

Extensive experience in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.

Provides input as to whether implementations have met requirements and are acceptable for release.

Perform Ad-hoc data extraction through queries in SQL Server 2008, Excel, Tableau report.

Experience in creating various views on Tableau (Tree maps, Heat Maps, Scatter plot)

Experience in creating Filters, quick filters, table calculations, calculated measures, and parameters

Performs smoke-testing and peer review of all created Dashboard

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

Utilizes JIRA as a Bug & Issue tracking tool in Agile Projects

Uses GitHub/Lab as the source code repository to manage each Projects lifecycle.

Involved in the interaction with Business Owners, gathering and managing delivery of reports. Email:adin92@r.postjobfree.com Maria Ake cell no:202-***-**** 2 P a g e

Structured dashboard with a consistent layout with visuals chart & trend at the top and corresponding crosstab data at the bottom

Excellent knowledge and usage of reporting tools such as Excel, Tableau.

Great Use and Understanding of SDLC methodologies such as Agile (SCRUM & KANBAN).

Maximize business efficiency and productivity through impactful business recommendations, based on data collected.

Created an appealing and easy-to-understand interface for end users to quickly identify key themes within large amount of complicated business data using data visualization tools.

Linked Tableau server to publish dashboard to a central location for portal integration in an accurate and timely manner.

Worked on the Implementation of hierarchies in Tableau with Portfolio at highest level followed by application and project details.

Creates Pivot Charts, such as pie chart, line chart, bar chart, and bubble chart for monthly metrics.

Ensure that the deliverables meet organization and performance requirements. ANNE ARUNDEL MEDICAL CENTER, Annapolis, MD. Feb. 2019 – June 2020 Data Analyst /Tableau Developer

Responsibilities:

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

Conduct internal reviews of CRs/SRs and assist in internal LOE estimation process.

Gather, analyze, and document business requirements, and develop supporting materials such as use cases, flowcharts, models, specifications, and reports.

Creating complex SQL queries and scripts to extract and aggregate data to validate the accuracy of the data

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

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

Produced Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, heat maps, bullet charts, Gantt charts to display relevant information for crucial business decision making.

Planned and executed project with budget of over $200K from conception to completion while finalizing deliverables within predefined deadlines and quality parameters.

Built peer quality performance metric and verified data and processes to ensure maximum data accuracy, completeness, and consistency using Tableau.

Utilize SSIS for ETL data modeling, data migration, and analysis.

Drafted and provided reports and design dashboards for executive management through qualitative and quantitative data analysis.

Business requirement gathering and translating them into clear and concise specifications and queries

Provides feedback on the quality of data including identification of billing patterns and outliers Email:adin92@r.postjobfree.com Maria Ake cell no:202-***-**** 3 P a g e

Developed Database Triggers and Views, Stored Procedures and Functions

Wrote complex SQL queries using advanced SQL concepts like Aggregate functions

Viewed duplicate data or errors in data to provide appropriate communication within the department and accurate monthly reports.

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

Wrote complex SQL queries to retrieve data from different tables utilizing Joins & Sub-queries.

Inspected reporting requirements and created various Dashboards.

Involved in extraction, transformation and loading of data directly from different source systems like, Excel, Oracle and flat files.

Experience in creating various views in Tableau (Tree maps, Heat Maps, Scatter plot). HEWLETT-PACKARD COMPANY, Berkley Heights, NJ Jun 2017 - Feb 2019 Business/Data Analyst

Responsibilities:

Worked closely with business and subject matter experts to gather, understand, and document business and technical requirements.

Facilitated the negotiation of requirements and gathered requirements.

Created workflows, solution design and deliverables for software documentation.

Identified current and future-state business processes by creating gap analyses.

Created, analysed, and validate detailed functional and system requirements and draft project documentation, including business requirement specifications.

Worked with customers throughout the business implementation process.

Provided accurate and timely drafting of quotes and change requests through needs assessments, detailed analysis, and customer interviews for existing as well as new customers’ projects.

Collected, organize, and supply technical feedback and product enhancements to engineering.

Provided technical sales assistance for sales team as required.

Executed troubleshooting when required both during project rollout as well as immediately post go live.

Assisted with quality assurance testing pertaining to project delivery.

Involved in extensive data validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.

Collaborate with QA analysts to elaborate and validate test cases and data quality checks.

Support the service/help desk in responding to technical and data questions that are received from end users, and support the users directly when necessary

Analysed duplicate data or errors in data to provide appropriate inter-departmental communication and monthly reports.

Created Users, Adding Users to a Site, Adding Users to a Group Viewing, Editing, Deleting Users 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.

Analysed reporting requirements and develop various Dashboards. Email:adin92@r.postjobfree.com Maria Ake cell no:202-***-**** 4 P a g e

Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel and SQL Server.

Responsible for developing, analysing, 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 fulfil data and reporting requirements including identifying the tables and columns from which data is extracted.

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. HACKENSACK MERIDIAN HEALTH, Hackensack, NJ. May 2015 - Jun 2017 Data Analyst / Tableau Developer

Responsibilities

Supported the company’s healthcare software functions, implementation, and training.

Developing SQL queries that were highly tuned using concepts like CTE, Partition, Cast and Volatile Tables.

Make business recommendations based on data collected to improve business efficiency.

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

Ad-hoc data extraction through queries in SQL Server 2008, Excel, SAS, Tableau report or PDF.

Supported business lead for special assignment and to ensure production efficiency.

Data analysis, reporting using Tableau and SAS.

Use data visualization tools to provide an easy to understand interface for end users to quickly identify key themes within their Data

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 dashboards to present to Senior Level Executives.

Worked on motion chart, Bubble chart, drill down analysis using tableau desktop.

Deployed Tableau Dashboards and worksheets in clustered environment.

Documented a whole process of working with Tableau Desktop and evaluating Business Requirements.

Interacted on a day to day basis with several different groups to achieve a common deliverable. EDUCATION

Coventry University Master of Science with Merit in Oil and Gas Management. Bingham University Bachelor of Science (Hons) in Biochemistry.

Contact this candidate