Arun Kumar Dash

914-***-****

acvr6d@r.postjobfree.com

PROFESSIONAL SUMMARY

Experienced Data Professional with around 5 years of diverse experience in system analysis, databases, data warehousing and business intelligence. Looking for a challenging position to utilize knowledge of implementing and designing low cost solutions for enterprise data integration.

Team player

Strong interpersonal and leadership skills

Positive attitude

Effective communication skills

CERTIFICATIONS

Certified Scrum Master December 2014

Oracle Certified Associate October 2011

EDUCATION

University of South Florida – Tampa, FL

Master of Science in Management Information Systems, GPA: 3.6 Aug 2014 – Aug 2015

Mumbai University – Mumbai, India

Bachelor of Science in Computer Science July 2007 - July 2011

TECHNOLOGY SUMMARY

• Informatica

• SSIS

• SSRS

• SSAS

• Oracle 11g

• MS SQL Server 2014

• SQL

• T-SQL

• PL/SQL

• Unix Shell Scripting

• Java

• C++

• HTML

• XML

• TFS

• Autosys

• Office 365

• SharePoint

• Power BI

• Dapulse

PROFESSIONAL EXPERIENCE

WellCare Health Plans – Tampa, FL

Business Analyst/BI Developer August 2015 – Present

Collaborated in requirement meetings with stakeholders to understand analytical content needs, assisted in documenting these requirements, resolving ambiguities, conflicts, and ensuring requirements are complete.

Translated stakeholder requirements into over 10 different tangible deliverables such as business requirement document, functional specification document, project charters, feasibility reports, stakeholder register, risk register etc.…

Identified data sources to work with source system developers and business owners for defining data extraction methodologies.

Worked with Data / Data Warehouse Architect on logical and physical model designs.

Analyzed data values, relationships from legacy systems, relational databases, non-relational databases, ERP systems, file formats to check compliance with existing standards and business rules.

As the Lead of the BI team was responsible for prioritizing all the technical projects and implementing a combination of waterfall and agile methodologies to achieve strategic goals.

Implemented Star-Schema data modeling, Data Cleansing, Logical and Physical data model design process.

Created detailed current and future state diagrams using Microsoft Visio to clarify business requirements and communicate project requirements to management.

Analyzed data trends to suggest process improvements and implemented change control.

Used ETL (SSIS and Informatica) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.

Prepared the complete data mapping for all the migrated jobs using SSIS.

Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS.

Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).

Developed reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS.

Developed Informatica workflows and sessions associated with the mappings using Workflow Manager.

Developed complex mappings using transformations such as the Source qualifier, Conditional Split, Data Conversion, Derived Column, Merge Join, Aggregator, Expression, Static Lookup, Dynamic Lookup, Filter, Router, Rank, Union, Normalizer, Sequence Generator, Update Strategy, and Joiner.

Designed and Implemented Tables, T-SQL Functions, Stored Procedures and Triggers in SQL Server 2014.

C-Vision – Troy, MI

ETL Developer/ Business Analyst June 2015 – August 2015

Involved in complete SDLC including Requirement Specifications, Analysis, Design, Development, & Testing of application.

Designed the complete Data Warehouse Schema using Erwin with proper relationships defined.

Designed and developed the Staging Database and loaded from source to staging and from staging to the Destination tables applying different transformations.

Elicited requirements using interviews, document analysis, workshops & workflow analysis.

Developed complex T-SQL queries and designed SSIS packages to load the data into warehouse.

Designed SSIS Packages using several transformations to perform Data profiling, Data Cleansing and Data Transformation.

Implemented Slowly Changing Dimension (SCD) type 2 to maintain Historical Data.

Utilized several Transformations like Lookup, Fuzzy Lookup for implementing the Transformation Logic in the Packages.

Lead a team of 5 junior business analysts to implement technical projects using scrum methodology to plan, implement and deliver within budget and timelines.

Used SQL Profiler Monitor Performance of Queries and to index the Tables. Explained the whole design of ETL Process using Visio tool.

Infosys Ltd – Pune, India

BI Analyst/Database Developer July 2011 – July 2014

Wrote Procedures/Stored Procedures/Functions/Triggers in PL/SQL for various applications which sit on top of the database.

Performed backup/restore, and managed user security. Created database objects such as tables, procedures, triggers, constraints, indexes and views.

Implemented the indexes on columns having high selectivity, and low density to speed up the execution of data retrieval queries and stored procedures.

As a part of a scrum team, created test plans and performed black-box, user acceptance and agile testing for the code to go-live.

Extracted data from flat files and from RDBS sources like Oracle and SQL Server.

Created Jobs and scheduled Packages using SQL Server Management Studio for the Daily Load.

Created Maintenance Plans and setup log files to monitor jobs. Assisted BI Developers to fetch Reports using Cognos.

Developed Entity-Relationship modeling for OLTP system using MS Visio.

Maintained the physical database by monitoring performance, integrity and optimized SQL queries for maximum efficiency using SQL Profiler.

Created the Design and Technical specifications for the ETL process of the project.

Extensively used Informatica power center for extraction, transformation and loading process.

Extracted data from various sources like Oracle, flat files and SQL Server.

Worked extensively on Source Analyzer, Mapping Designer, Mapplet designer and Target designer and Transformation Developer.

Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.

Contact this candidate