Data Analyst Intern Resume

SUMMARY:

Agile and resilient professional with 3 years of data analytics and reporting experience in logistics, insurance and healthcare sectors.
Adept in writing complex SQL queries, triggers, views, user defined functions (UDF) & stored procedures using MS SQL server to cleanse data and prepare it for high performance analytics. Good Understanding of SDLC and Agile.
Proficient in extracting data from heterogenous sources using SSIS ETL packages for the staging server and data warehouse. Designed data warehouse fact and dimensional tables having star and snowflake schema design as per business requirements.
Well versed in designing OLAP cubes using multiple dimensions & measures; modifying relationships between measure group and dimensions as well as creation of calculated members and KPI’s using SSAS ( MDX ).
Accomplished in creating interactive Tableau/ Power BI dashboards, charts & pivot tables using MS Excel , graphs, maps and ad - hoc reports using SSRS (MSBI) to serve business stakeholders (finance, supply chain, healthcare & customer service).

TECHNICAL SKILLS:

Programming Languages: T-SQL , MDX, R Other Tools Word, Advanced Excel (Pivot Tables, VLOOKUPs) , PowerPoint, TFS

Database(s): MS SQL server, Oracle, Access ETL Tool SQL Server Integration Services (SSIS)

Business Intelligence/Data Mining Tools: Tableau Desktop, Power BI , SQL Server Analysis Services ( SSAS) , SQL Server Reporting Services (SSRS), SQL Server Management Studio (SSMS), Business Intelligence Design Studio (BIDS) , Visual Studio 2012-2015

PROFESSIONAL EXPERIENCE:

Data Analyst Intern

Confidential

Responsibilities:

Acted as a liaison between the business stakeholders and cross technical teams for business requirement gathering via brainstorming sessions, interviews and through questionnaire-feedback process .
Analyzed transactional data & utilized statistical techniques to derive key descriptive statistic s like variance- covariance matrix to support effective decision making for a financial corp. by leveraging the power of T-SQL scripts, MDX queries and Power BI.

SQL Developer Intern

Confidential

Responsibilities:

Prepared tableau dashboards indicating the key performance metric and geographical presence of child nonprofit organizations which facilitated easier decision making for future financial aid disbursement.
Detected anomalies in transactional data to determine root cause behind failure of SSIS DTS packages bringing in data from Access and SQL server databases which lead to the restoration of the tableau reports associated with finance.
Efficiently handled IT vendors, gathered requirements and carried on designing, coding, testing and debugging custom SQL queries and scripts to migrate data from legacy data warehouse (EDW) to newly developed SQL data warehouse using Kimball design method.

Business Intelligence Analyst

Confidential

Responsibilities:

Designed supply chain BI reports using Tableau and SSRS depicting supplier performance measured with the help of metrics such as purchase order acknowledgement status, percentage of accepted receipt quantity & rejected receipt quantity.
Created OLAP cube s using supply chain related dimensions(CDC,SCD) and measures essential for monitoring the day-to-day demand for vehicle parts , inventory and supplier order management. Involved in creation supply of chain calculated members and KPIs using MDX .
Developed SSIS Packages to extract data from various data sources such as Excel and flat files into SQL server using different transformations like derived column, sort, and aggregate transformations to prepare data for ad hoc reports associated with order status and vendor performance.
Employed SSIS Data Profiler Task to profile target source systems and build ETL solutions, which was helpful in designing the table structures and cleaning data for data consistency.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship