Data warehousing & ETL Intern Resume Denver, ColoradoÂ - Hire IT People

TECHNICAL SKILLS:

Databases: SQL Server, Teradata 14.x, Oracle 9i/10g, MS Access, SAP HANA

Data mining tools: Advanced Excel, SAS Enterprise Miner, R - Studio

Data Warehouse & ETL: Informatica 9.5.x, SSIS, Star and Snowflake modelling, SAP Universe Designer

Reporting tools: Tableau, QlikView, Qlik Sense, SAP Business Objects, SSRS

Programming: T-SQL, Python, Oracle PL/SQL, UNIX Shell Scripting, Java

Big Data Tools: Apache Hive, HDFS, Map Reduce, Sqoop, HDFS

Other tools: Google AdWords, CA Erwin, MS Visio

PROFESSIONAL EXPERIENCE:

Confidential, Denver, Colorado

Data warehousing & ETL Intern

Responsibilities:

Designed enterprise-wide data asset management solution as a proof of concept using Microsoft Azure Data catalog
Gathered requirements and created data pipeline for the North Americas mobile sales app to track $100 million in sales
Analyzed 100+ failed ETL jobs for frequent failures/performance bottlenecks, and reduced the failure rate by 30%
Performed data ingestion of structured and unstructured data in a newly created data lake for the data science team

Confidential

Associate Consultant

Responsibilities:

Modeled credit and market risk data marts for a government bank enabling 75% faster analysis of credit portfolio
Automated the liquidity forecast process for the client bank by developing liquidity reporting solution using Jasper reports
Replaced 200+ SQL load scripts with ETL SSIS packages reducing the issues with maintainability and version control
Lead analytic software suite training for 20 client employees to enable faster enterprise wide adoption of the system

Confidential

Software Engineer

Responsibilities:

Developed complex business logic in T-SQL as a part of database development for the Basel 2 risk analytics suite
Optimized slow database stored procedures resulting in 250% performance increase when compared to earlier benchmarks
Designed Tableau dashboard for credit risk KPI’s leading to proactive risk mitigation and management for managers
Created a portfolio tracking dashboards in Tableau, for single view tracking, monitoring and analyzing of bank’s portfolio
Mentored and trained two new team members on data warehousing, data mining, and business intelligence concepts
Predicted with 65 % accuracy the customers likely responsive to credit card campaign by creating statistical models in SAS based on techniques like decision tree, neural networks, regression and k-means clustering
Performed dimensional modelling of a task aggregator e-commerce website to create the data warehouse design in Erwin
Developed reports and dashboards for analysis of revenue and task metrics over the time dimensions using Tableau 9