Jr. ETL Analyst Resume

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Jr. ETL Analyst

Responsibilities:

Performing Extract, Transform and Load (ETL) development using SQL Server Management Studio and SQL Server Integrated Services (SSIS)
Performing ad hoc analysis, data processing and data visualization using Tableau and other SQL scripts tables
Creating and managing schema objects such as tables, views, indexes, procedures, and triggers and maintained referential integrity
Gathering extensive knowledge of claims department operations and insurance company databases
Improving customer satisfaction by assisting the technical team to reduce the application response times

Confidential, New York, NY

Intern, Junior Analyst

Responsibilities:

Analyzed financial reports and validated credits received from the vendor by apply statistical formulas on VBA based on key financial ratios and metrics
Applied regression and correlation analysis using Excel VBA to determine the key factors for back orders by the previous vendor
Calculated annual liquidating assets by clustering the transaction order dataset and analyzing the delays in shipments
Forecasted data discoveries and patterns to vendors and clientele to enhance data quality
Envisioned and built interactive dashboards using Power BI to assist the Business Intelligence team in reporting capabilities

Confidential, New York, NY

Statistical Consultant

Responsibilities:

Provided help in selection of appropriate statistical analysis and design of experiment
Conducted Regression Analysis and Hypothesis Testing to quantify student perception from questionnaire with their performance
Delivered documented analytical result with visualization to be part of the published paper
Explained statistical concept and analytic result to non - tech researchers