We provide IT Staff Augmentation Services!

Data Analyst Resume

3.00/5 (Submit Your Rating)

St Petersburg, FL

Hire Now

SUMMARY

Senior data analyst with experience across several industries, providing meaningful insight into company data utilizing report building and visualizations. Built Excel macros to automate data transformations. Skilled at developing fully functioning MS Access database reporting applications. Expertise in producing innovative Informatica PowerCenter workflows connecting to 1000+ SQL Server and Oracle databases for the protection of PII data.

TECHNICAL SKILLS

  • Advanced SQL Skills
  • PowerCenter
  • ETL
  • MS Excel
  • MS Access
  • Informatica Data Confidential
  • PowerShell
  • VBA
  • Oracle
  • Business Requirement Gathering
  • MS Visio
  • SharePoint
  • SDLC
  • Tableau
  • Service Now

CORE COMPETENCIES

  • Project Management
  • SQL Server
  • Data Science
  • Big Data
  • Business Analysis
  • Software Documentation
  • Leadership
  • Public Speaking

PROFESSIONAL EXPERIENCE

Confidential, ST. PETERSBURG, FL

Data Analyst

  • Automated the PowerCenter work flows for PII analysis and masking of 1000+ SQL and Oracle databases.
  • Developed proficiency in UAT on Informatica POC software Confidential project.
  • Managed a 3 - node Ambari Hadoop service cluster to monitor health and for metrics collection.
  • Wrote complex SQL scripts and Excel formulas to automate day-to-day tasks.
  • Built out PowerCenter ETL automation workflows for Enterprise Data Protection.
  • Permissioned service account access grants and roles to SQL Server databases.
  • Conducted and hosted Zoom meetings, coordinating the efforts of several departments.
  • Implemented Excel formulas, such as VLOOKUP, Index + Match.
  • Performed root cause analysis testing to resolve data masking errors.
  • Developed complex SQL queries for smart BI tool.

Confidential, ST. PETERSBURG, FL

Data Analyst - Contractor

  • Automated excel spreadsheets with Macros and VBA.
  • Managed monthly UPC database automation updates, using MS Excel and MS Access.
  • Created Oracle Hyperion string reports for various departments.
  • Produced SQL scripts to update tables and research, and to create ad hoc reports.

Confidential, ST. PETERSBURG

Database Administrator Intern

  • Designed SQL Server subset databases for Developers and QA testing environments.
  • Constructed and ran data masking packages with IBM Optim and SQL Redgate tools.
  • Wrote SQL/TSQL queries to retrieve/modify data.
  • Ran SQL scripts to create database backups and data refreshes.

Confidential, TAMPA, FL

Database Architect & ASP.net developer (Contractor)

  • Developed SQL server manufacturer part database with MS Access client app to input data, search records, and generate complex quality control reports.
  • Successfully designed and implemented customer portal with asp.net in Visual Studio.
  • Gained expertise in gathering business requirements for quality control reports.

Confidential, TAMPA, FL

Database & Business Intelligence Analyst (Contractor)

  • Wrote SQL scripts for data reports and created Tableau dashboards to provide actionable insights.
  • Produced Data visualizations in Microsoft Visio.
  • Wrote VBA code to enhance database functionality.

Confidential Confidential, ST. PETERSBURG, FL

Business Analyst

  • Innovated data cleansing methods, enabling insight for operating cost reduction and maximized revenues.
  • Introduced data mining to enhance marketing strategies.

ADDITIONAL RELEVANT EXPERIENCE

Confidential, St. Petersburg, FL

Senior Tax Analyst

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship