Data Analyst Assistant
Resume:
*** * ******* ******, ************ PA *****
**********@*****.***
DATA ANALYST
ERNEST Y. DAVIS
PROFILE
An IT professional with over five (5) years’ experience in various domains such as Finance, Human Resource, Insurance, Retail and Healthcare. An enthusiastic individual with extensive experience in Data Analysis, Data manipulation, Data Extraction, Research and Reporting in different formats and from various sources. Proven ability to learn, utilize in-house databases and systems to maintain strategic vision of the organization and link it with everyday work. Able to perform multiple duties in business analysis, project or program management, and functional leadership. A wonderful team player who can relate and work efficiently with diverse groups.
SKILLS SUMMARY
• Utilized business intelligence tools to include OLAP (Online Analytical processing), data warehousing, reporting, querying tools and excel.
• Experience in Data Analysis and ETL techniques for loading enormous amounts of data.
• Experience with DATA MINING.
• Identified issues when reports are created from several and complex data sources.
• Performed DATA MODELING, DATA MIGRATION, consolidate and harmonized data. Hands-on data modeling experience using Dimensional Data Modeling, Star Schema, Snow-Flake, Fact and Dimension Table, Physical and Logical Data Modeling using ERwin 3.x/4. x.
• Excellent knowledge and usage of statistical/mathematical analytics software like Stata, SPSS, SAS and Minitab.
• Used SAS to import and export data from and into Teradata tables. Excellent knowledge of Teradata DWH platform including architecture.
• Knowledge of healthcare information systems, experience with Practice Management software and HIPAA Guidelines.
• Skilled in using SAS statistical procedures like PROC Report, PROC TABULATE, PROC CORR, PROC ANOVA, PROC MEANS, PROC TTEST, PROC FREQ, PROC UNIVARIATE, and PROC LOGISTIC.
• Hands on experience in SAS programming for extracting data from Flat files, Excel spreadsheets and external RDBMS (ORACLE) tables using LIBNAME and SQL PASSTHRU facility.
• Experience in working with SAS ENTERPRISE GUIDE SOFTWARE for reporting and analytical tasks.
• Strong ability to write SQL queries using PROC SQL.
• Possess strong computer and office administration skills with a vast knowledge of Windows and Microsoft Office Suite (Word, Excel, PowerPoint, Access, and Visio).
• Excellent knowledge and usage of reporting tools such as Tableau and SAS.
• Experience in data scrubbing and cleansing.
• Great understanding of SDLC methodologies such as Waterfall and Agile (specifically SCRUM).
• Possess a strong ability to adapt and learn new technologies and new business lines rapidly.
• Good knowledge of portfolio analysis, management and customer segmentation.
• Self-motivated individual with strong communication skills, great attention to details and the ability to work under pressure.
• Exceptional organizational and time management skills and the ability to work independently.
• Excellent team player with demonstrated experience of working diplomatically and collaboratively with all levels of staff to ensure successful implementation of assignments. TECHNICAL SKILLS
Operating Systems Win XP, Vista, 7, Windows Server 2003, 2008(X32, X64), Unix Databases MS SQL Server 2005/2008/2012, 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
Test Tools HP Quick Test Professional 10/11, HP Quality Center 10 Querying Tools SQL Management Studio 2008/2012, 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, Cognos, Excel and PowerPivot, SSRS Programming language SAS
WORK EXPERIENCE
ASTA CRS (Contractor, SwiftLearn IT Solutions, Inc.) Washington, DC 07/2019- Present
Reporting/Data Analyst /SQL
Responsibilities:
• Developed data quality and validation process.
• Convert SQL queries over to new environment and as help rewrite SAS programs based on best practice/rules.
• supporting the business in decision making and operations efforts by providing data
• Develop reporting solutions following internal reporting standards and best practices by translating business requirements for development within multiple reporting and prototyping platforms and determining appropriate solution design.
• Maintain and improve the reliability, efficiency and functionality of existing reports
• Facilitate team request intake sessions to collect reporting requirements and determine project prioritization
• Build and maintain reporting, data, and metrics governance processes
• Develop strategic partnerships with various levels of leadership within the organization, acting as a representative of the broader Reporting and Analytics team
• Coach and provide guidance to other members of the team and clients in the use and interpretation of data
Wells Fargo- Remote Contractor (SwiftLearn IT Solutions, Inc.) Greenbelt, MD 06/2017—06/2019
Data Analyst
Responsibilities:
• Wrote queries to gather data from different tables by using JOINs, sub-queries, correlated sub- queries and derived tables on SQL Server platform.
• Wrote SQL queries that were highly tuned using concepts like Explain, Stats, CAST and volatile tables.
• Wrote complex SQL queries using advanced SQL concepts like aggregate functions, Group by and OLAP (Online Analytical Functions).
• Used SAS to import and export data from and into SQL Server tables.
• Planned, analyzed and designed Universes using SAP Business Objects as per Business needs.
• Used Pivot tables to create reports that did dicing and slicing functions on data. This is called dimensional analysis and provides a 360 view of what is going on.
• Created numerous permanent tables, Volatile tables and Global Temporary tables.
• Developed dashboards in Tableau Desktop and published them in Tableau Server.
• Fulfilled numerous data requests for financial profiling.
• Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau reports.
• Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.
• Created and developed Parameterized, Drill Down and AD Hoc Reports using SQL Server 2014 Reports Services (SSRS)
LifeBridge Health (Contractor, SwiftLearn IT Solutions, Inc.) Baltimore, MD 06/2016 – 05/2017
Data Analyst
Responsibilities:
• Gathering and integrating data from disparate sources
• Building models and analyzing data to unearth trends and patterns
• Presenting and explaining information, and suggesting improvements
• Understand health care operations and systems
• Create and validate record-keeping processes
• Pull and integrate data from disparate sources (e.g. cost and claims or clinical data)
• Evaluate and preprocess raw information
• Delve into data to discover discrepancies and patterns
• Build models that capture a wide range of health care operations
• Present and explain information in an accessible way (e.g budgeting reports)
• Suggest ways to both increase healthcare quality and reduce costs (e.g. money spent in R&D)
• Collaborate with management and internal teams to implement and evaluate improvements
• Proven experience as a Healthcare Data Analyst
• Experience in data analysis and visualization methods
• Understanding of healthcare procedures
• Knowledge of Extract Transform and Load (ETL) frameworks
• Proficient in SQL and analysis tools (e.g. SAS) Tableau/Power Bi
• Knowledge of Enterprise Data Warehouse (EDW) and data management systems
• Excellent analytical and communication skills
• Outstanding organizational and problem-solving aptitude
• EPIC Training Informatics, Statistics, Mathematics or a related field EDUCATION
2015 : Bachelor’s degree of Arts Degree in Business Administration, Management African Methodist Episcopal University, Monrovia, Liberia 2011 -2012: Bachelor’s degree in computer science (Business Computing) DBA) Graduate, Centre for the Development of Advance Computing CDAC NSG IT Park,127/2B/2A, Near Hotel Sarja, Aundh, Pune 411007, India
Contact this candidate