We provide IT Staff Augmentation Services!

Data Analyst Resume

SUMMARY:

  • Data analyst with advanced SQL and 16 years experience finding answers in large data sets. Complex quantitative analysis, data reporting, and data QA in the insurance, financial, and telematics industries, with an emphasis on translating data insights into actionable business knowledge. Expert in Amazon Redshift, Snowflake, MySQL, Teradata, Oracle, SQL Server, and data visualization with Tableau and D3. Experience in Google Analytics, ElasticSearch, Cassandra, MongoDB, and Amazon EMR Hadoop. I am looking for the biggest data and the most interesting puzzles.
  • The data analyst skill set - 16 years experience - data analytics, data mining, data reporting, data discovery and data quality validation in large data sets. I excel at answering complex business questions, identifying trends, answering “what if?” scenarios, and finding needles in haystacks, with experience in presenting data to the VP and CEO level
  • The business systems analyst skill set - 11 years experience - requirements gathering, process flow diagrams, business process analysis, data flow diagrams, business requirement documentation, functional and detailed technical specifications, systems analysis and documentation of every step of the waterfall SDLC (Analyze Design Build Test Deploy), plus modern iterative (Agile/Kanban/Scrum) methodologies
  • Predictive analytics, statistical modeling, and data visualization with R
  • Python for data manipulation and discovery
  • Communication - outstanding written, verbal, and interpersonal communications skills - able to explain technical issues to vice-presidents and entry-level users
  • Expert at data integration, data migration, and data quality issues in relational databases, with extensive experience in integration of external data and validating ETL processes
  • Data quality assurance of large data sets including data profiling and data cleansing
  • Testing - including developing test plans and test strategies, creating testing documentation, identifying issues, creating test cases, test scripts, user acceptance testing (UAT), regression testing, automated testing, system integration testing, managing test environments, quality assurance methodologies, and quality assurance of system changes
  • Deployment coordination, verification, documentation, training, and on-call production support
  • A strong team player able to build relationships and good lines of communication across business areas
  • Researching data flows and relationships, data integration analysis, data mapping across multiple systems, data quality for ETL processes, and file transfer of external data
  • Project management background - able to step into the project manager role when required, with understanding of project scope, project deliverables, scheduling, change control, exit criteria, and task management
  • Able to think outside the box and see the big picture, and how the stories in the data can serve the business
  • A data innovator with advanced analytical skills, a love for solving puzzles, and a lengthy track record of identifying and resolving complex issues under pressure

SOFTWARE:

  • Amazon Web Services Redshift
  • Snowflake Data Warehouse
  • MongoDB
  • Cassandra
  • Amazon EMR Hadoop
  • ElasticSearch
  • R
  • Python
  • Tableau 10
  • D3
  • Google Analytics
  • Teradata 14
  • Oracle Database 12c
  • Oracle Database 11g Release 2
  • Microsoft SQL Server 2008 R2
  • Microsoft SQL Server 2012
  • Oracle SQL Developer
  • Toad for Oracle
  • Toad Data Point
  • Toad Data Modeler
  • Toad for SQL Server
  • Quest SQL Optimizer for Oracle
  • Hewlett-Packard Quality Center
  • HTML, Javascript and CSS
  • Teradata SQL Assistant the complete Microsoft Office Suite
  • Microsoft Access (advanced user)
  • Microsoft Excel (advanced user)
  • Microsoft PowerPoint (advanced user)
  • IBM z/OS mainframe with Rumba user interface

EXPERIENCE:

Confidential

Data Analyst

Responsibilities:

  • Expanded Confidential ’s knowledge of cellular provider coverage with SQL analysis of cell strength data mapped out by latitude and longitude
  • Conducted a year-long study of starter disable effectiveness using GPS data in AWS Redshift, along with data visualizations in Tableau. My predicted percentage matched real world performance exactly.
  • Innovated “day in the life” studies using GPS and timestamp data to map out daily activity and locations for specified devices
  • Empowered the Tier 2 customer support team with a weekly SQL class
  • Supported new business and improved customer experience with complex, multi-level SQL analysis of device and geospatial data in AWS Redshift
  • Assisted the product team with data analysis to support new and current products
  • Delivered analysis and weekly reporting of device performance
  • Discovered patterns and pattern disruptions in billions of rows of device, vehicle, and GPS data

Confidential

Functional Data Analyst

Responsibilities:

  • Ensured flawless migration of data from legacy databases with data QA analysis and profiling
  • Achieved simultaneous centers of excellence in Teradata, Oracle, and MS SQL Server
  • Developed detailed technical specifications for ETL and reporting
  • Developed testing strategy and conducted appropriate testing to identify and resolve issues
  • Developed detailed technical specifications for ETL & reporting in collaboration with data warehouse architect and senior ETL and business intelligence developers

Confidential

Data Analyst

Responsibilities:

  • Data QA analysis and profiling of acquisition data
  • Validation and quality assurance of Informatica ETL from a wide range of data sources
  • Developed process design and data flow documentation that made an extraordinarily complex process understandable
  • Reported and resolved data quality issues guaranteeing a smooth transition of acquisition data

Confidential

Data Analyst

Responsibilities:

  • Always the first responder at “the scene of the crime”, ensured a successful audit outcome with SQL queries of millions of records of audit data, including statistical analysis to form a complete business picture
  • Reporting and analysis of escheatable funds, including multi-dimensional breakdowns with metrics including average policy face value, number of policies sold by year, number of policies sold by date of birth, max policy amounts, number of policies sold by state, insured ages, policy status, etc
  • Analytic studies to determine data quality, integrity, completeness and accuracy, including analytic studies to determine invalid or fraudulent data and uncover market conduct violations
  • Documentation and reporting on incoming data to support business decisions
  • Successful ETL (extract, transform and load) of large volumes of contradictory and challenging data to create the analytic superset
  • Metadata analysis, discovery, management and documentation
  • Supported high level negotiations with states and audited companies with time-sensitive, complex SQL queries in the Oracle database
  • Data analysis in support of ad hoc and standing user requests
  • Data cleanup, de-duplication and validation, including data from legacy mainframe systems
  • Creative and critical thinking to research and recognize connections, abstract patterns and multi-level relationships between apparently unrelated facts
  • Wide range of ad hoc financial studies and reporting
  • Analysis of data from every major life insurance and annuities administration system
  • Recognized by upper management for dedication to processing integrity, new ideas, inquisitiveness and thinking outside the box

Confidential

Business Systems Analyst

Responsibilities:

  • Performed in-depth data analysis covering a full range of technical and business problems, including production numbers for select agents, QA of data integration issues, QA of system updates, licensing and contract questions, research of agent payment hierarchies, research of agents in particular distribution channels, and resolving incorrect agent data
  • Data integration - successfully met the challenges of mapping and resolving large volumes of data moving between Confidential 's 90+ systems
  • Data modeling for new projects that enhanced Confidential 's competitiveness
  • Writing detailed technical requirements/functional specifications for system modifications and interfaces with other systems
  • Testing, including developing test plans, identifying issues, creating test cases, test scripts, user acceptance testing (UAT), regression testing, managing test environments, and quality assurance of system changes
  • Requirements gathering, documenting process flows and use cases
  • Researching business needs and creating business requirement documents for complex technology projects
  • Deployment, including user training, verification of system changes, overall coordination and communication with IT in the production deployment of all new code changes, and continuing production support
  • Outstanding written, verbal, and interpersonal communication across business units to deliver enterprise-wide solutions
  • 24 hour on-call responsibility to assist developer staff in resolving production issues
  • Developed and implemented a new testing workflow which reduced the rate of errors deployed in production to virtually zero.

Hire Now