We provide IT Staff Augmentation Services!

Senior Data Analyst Resume

Minnetonka, Mn


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


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


Senior Data Analyst

Confidential, Minnetonka, MN


  • 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


  • 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


  • 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


  • 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


  • 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