We provide IT Staff Augmentation Services!

Senior Data Analyst Resume

Minnetonka, Mn

SUMMARY:

Focused and performance driven engineer with ten years of experience in data mapping, data integration data management, software development, quality assurance and issue resolution

TECHNICAL SKILLS:

Application Development: SAS, C#, .NET, Microsoft Visual Studio, Microsoft Test Manager (MTM)

Microsoft/Oracle BI Stack: SQL Server 2008 R2/2012, SSIS, SSAS, SSRS, Oracle BI 11g

Open Source BI Stack: Data Warehousing

Pentaho Data Integration, Pentaho 4J: Kimball Dimensional modeling technique includes Star - Schema and Snowflake-schema concepts

Big Data: Hadoop, Sparks, MAPR and Hive

Development Methodology: Agile (SCRUM), Waterfall

Concepts: Object Oriented Design/Principles/Patterns, UML, Refactoring

Version Control: Team Foundation Server (TFS), Microsoft Subversion (SVN)

Quality Assurance: Test Plan Development and Execution, Issue Tracking, Test Automation, Support/Incident Management, Release Management

PROFESSIONAL EXPERIENCE:

Senior Data Analyst

Confidential, Minnetonka, MN

Responsibilities:

  • Designed, developed and deployed decision based data systems on a daily basis using highly configurable and customized Reporting and Extracts (SSIS/SSRS) from complex data structures
  • Experienced in Erwin and SQL Workbench for Logical and Physical database modeling of data warehouse
  • Involved in performance tuning of targets, sources, mappings, and sessions design and developments.
  • Designed Microsoft 2008 SQL server - SSRS reports using configurable UI reports with drill-up/down
  • Extensively, used data manipulation language in SQL to retrieve, store, modify, delete, insert and update data in tables and database when and where needed.
  • Created data definition language in SQL to create and modify the structure of database objects
  • Designed and developed recursive CTEs, temp tables and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency as well as to support databases
  • Performed database recovery and backup using incremental and full back up when and where needed, and especially during new builds and table migrations.
  • Performed data analysis using Microsoft SQL (SSAS ) to derive analytic based decisions and trends.
  • Designed and created SQL queries and store procedures to handle data fetching and analyze trends
  • Working knowledge of CareOne along with proficiency in evaluating NCQA, STARS & HEDIS metrics
  • Translated business requirements into easily understandable business dashboard and reports.
  • Performed data modeling, design, mapping and analysis - using both ERD and dimensional data models
  • Conducted analysis and provided insight, trends and decision-based focus for the UHC clinical business.
  • Identified data challenges and defining those challenges and proposing solutions to remediate
  • Troubleshoot data issues, analyzed and corrected as needed and work through obstacles as they arise

Application Analyst

Confidential, Minneapolis, MN

Responsibilities:

  • Installed and configure Microsoft SQL Server systems on windows applications systems
  • Collect user needs and designed Microsoft SSIS packages and SSRS reports BI data marts.
  • Performed data integration and reporting using Oracle, Pentaho data integration and Pentaho 4J suites
  • Documented detailed design for technical development of software development projects.
  • Created, managed and executed system testing scripts, validation test scripts
  • Analyzed datasets and generated statistical reports using SAS and Tableau
  • Drive to effective decision making, issue resolution, timelines and deliverables

Software Engineer

Confidential, Eden Prairie, MN

Responsibilities:

  • Worked on a scrum team with an offshore counterpart to develop and support a comprehensive Data Warehouse platform for business reporting and billing needs.
  • Gathered, Manipulated, transferred and managed data in SAS development and reporting workflows
  • Built a framework using C#, .NET and using third party’s API to get data out from the third party application. De-serialized and Serialized data to Avro file to get it ready to ingest to Hadoop environment.
  • Enhanced and maintained in-house ETL framework using C#, .Net and XML technology.
  • Worked on all aspects of the ETL pipeline, as well as aggregated and reported on operational system metrics, using Microsoft BI stack like SQL Server, SSIS, SSRS and SSAS.
  • Design, Build and deploy Microsoft SQL Server Integration Services (SSIS)Packages for ETL system
  • Design, Create and deploy Microsoft SQL Server Reporting Services (SSRS) report definition modules
  • Managed a legacy system providing incident support and ensuring data consistency across multiple system
  • Participated and helped in writing user acceptance test (UAT) cases and be a liaison between project stakeholders Worked with customers in identifying and resolving problems and system improvements
  • Assisted with gathering the report requirements, enhancements, break/fix and report scheduling.
  • Performed trainings and implementation of new and existing application systems

Software Test Engineer

Confidential, Chaska, MN

Responsibilities:

  • Organized business stakeholders meetings to gather business cases and requirements
  • Translated requirements into Business Requirements or Functional Specifications
  • Worked with project stakeholders to translate and interpret business needs and requirements into product or service that developers can understand and work with.
  • Designed unit tests systems test to meet device capability and customer requirements
  • Performed quality assurance training and safety and quality enhancement for all employees.
  • Designed unit tests systems test to meet device capability and customer requirements
  • Managed infrastructure projects of system installation and configuration for Clinical IS

Data Architect

Confidential, Minneapolis, MN

Responsibilities:

  • Design an entity relationships diagrams and dimensional data models to meet the clients business goals
  • Performed data modeling in dimensional and entity-relational data modeling and OLAP cubes.
  • Developed and deployed real-time SSRS reports and objects in Oracle-based data warehouse.

Hire Now