Data Analyst Resume
Tallahassee, FloridA
SUMMARY
- Over 5 years of experience as a Business Data Analyst
- Designing with Conceptual, Logical, and Physical Modeling
- Experience in analyzing, manipulating large sets of data and presenting to internal/external clients.
- Expertise in Business Intelligence Tools with use of ETL tools such as SSIS and DTS, Data Integration, Data Profiling, Data Cleansing, and Data Integrity.
- Interacting with stakeholders, gathering requirements and assigning priorities to each task.
- Experience in creating reports from raw data to readable format for higher management, internal and external clients.
- Expertise in querying data using Python, R, Tableau, Power BI, SQL and MySQL for data cleaning, data visualization, risk analysis, predictive, and prescriptive analytics
- Excellent facilitation skills and adept at managing the interactions between end - users and management.
- Experience in reusable transformation (joiner, sorter, aggregator, expression, look up, router, filter, update, strategy, sequence generator, normalizer, and rank) to move data from multiple sources to target.
- Experience in De-duping, cleaning and address correction for improving data quality.
- Over 10 years of Healthcare experience
- Aided in research to produce for a textbook of pathology where through applied research and analytics, insight was received on how to boost efficiency and ultimately experience growth
- Management initiatives and projects to provide alternative approaches for improved communication, automation and turn around time
- Built reports and compiled metrics with company data and converted it to presentable information with Excel for identifying relationships and making data driven decisions.
- Ability to be an effective team player to work in conjunction with other team members.
- Excellent documentation, communication, interpersonal and customer service skills.
- Exceptional problem solving and sound decision making capabilities.
- Ability to multi-task independently with minimal supervision in a fast pace environment.
- Proficient in Microsoft Application: Word, Excel (Pivot Tables, V-Lookup, Graphs), PowerPoint, Access, Outlook, and Teams.
TECHNICAL SKILLS
Soft Skills: Report Writing, Teamwork, Critical Thinking, Communication, Networking, DevOps, Agile
Programming Languages: Python, SQL, R, ETL, RDBMS MySQL, PostgreSQL, DB2
Data Visualization Tools: Cognos, Analytics, Power BI, MS Excel, Tableau, Asana
Other Tools: Microsoft Office (PowerPoint, Word, Outlook, Teams), Apache Airflow, Java, Workspace
AWS Tools: AWS Cloud, Amazon DynamoDB, Cloud Storage, Cloud Computing Architecture and Security
PROFESSIONAL EXPERIENCE
Confidential
Data Analyst
Responsibilities:
- Responsible for eliciting, understanding, interpreting, and representing business requirements and act as the conduit between the customer and technical teams to ensure requirements are understood.
- Provide subject matter expertise on the use of data as well as educate teams on business model, metadata, and standards.
- Responsible for understanding source systems and its data models.
- Develop source to target mappings for data lineage.
- Document source architecture to include data flows.
- Responsible for analyzing data to validate business domains and requirements.
- Responsible for data profiling and ensuring data quality requirements are accurate and complete.
- Act in an advisory capacity in data model reviews, architecture approach and solution design to ensure high quality deliverables.
- Responsible for partnering with management and business units on innovative ways to successfully utilize data and related tools to advance business objectives.
- Works with governance council to establish data governance standards and guidelines.
- Assist with business data lake testing / experimentation
- Assist with coordinating data dictionary completions
- Mentor Project DA resources
Environment: MySql, Power BI, MongoDB, Podio, Data Synchronization Studio
Confidential, Tallahassee, Florida
HRIS (Human Resource Information Systems) Analyst
Responsibilities:
- Propose new quantitative analysis on various projects on customer retention analysis, promotion program evolution and anomaly detection, corporate with client managers and prepare the slides.
- Research and test statistical models and machine learning to analyze and predict customers behaviors and visualize the final results, implemented in R code.
- Connected to SQL databases such as internal CRM or ERP systems, loaded data from Excel or log files, scraped data from web, or extended data from a variety of other different sources, as and when required.
- Performed data cleaning, exploration implementing R and Python.
- Reporting designs based on business specific problems and implementation on Tableau.
- Profiling based on content access reports, event trigger reports and navigation reports using R. Profiles are then used for target marketing and segmentation.
- Custom website strategy for segments.
- Performed data visualization implementing ggplot2 package in R.
Environment: R, Tableau, SQL, R Studio (ggplot2)
Confidential, Tallahassee, Florida
Healthcare Data Analyst
Responsibilities:
- Utilized machine learning techniques for predictions and forecasting based on the sales data.
- Executed overall data aggregation/alignment and process improvement reporting within the sales department,
- Managed data quality and integrity using skills in Data Warehousing, Databases & ETL.
- Monitored and maintained high levels of data analytic quality, accuracy, and process consistency.
- Assisted sales management in data modeling.
- Designed and developed the visualizations on Tableau including publishing reports and managing data sources on Tableau Server for business and sales insight.
- Developed R scripts to automate data sampling process. Ensured the data integrity by checking for duplication, completeness, accuracy and validity.
- Designing automated dashboards and data visualization to extract relevant and targeting market insights. Data classification using Python.
- Application of various machine learning algorithms and statistical modeling - decision tree, logistic regression to identify key features using various packages in R.
- Retrieved and analyzed data by writing complex ad-hoc SQL queries across large scale dataset. Managed data migration over different platforms.
- Structured business problems and gathered/documented business requirements for developing analytical solutions. Communicated analysis results with senior managers.
- Created a forecasting model for sales prediction and performed statistical analysis to deliver actionable insights to the Sales team.
- Performed tests on import programs, analyzed results, and modified programs.
- Developed visualization reports on Tableau to correlate site serving areas and standard issues to analyze network availability.
Environment: SQL, R, Python, MS office, MS Excel, Tableau, Linear Regression
Confidential
Histotechnologist
Responsibilities:
- Streamlined operations to improve efficiencies; identified changes to processes and procedures in collaboration with colleagues to identify gaps in performance and troubleshoot resolutions with rapid and lasting positive impacts.
- Managed and updated clients; records within the IntelliPath database for seamless workflow between dermatologists and pathologist
- Tracked and Monitored data within the company platform while building reports within excel