Data Analyst Intern Resume

TECHNICAL SKILLS

Databases: PostgreSQL, Redshift, Microsoft SQL Server, Oracle 10g and 11g, MySQL, IBM DB2, MongoDB

Business Intelligence Tools: Tableau v9.2 and 10.1, Informatica v8.1 and 9.5, Business Objects, Control - M

Programming Languages: PL/SQL, Hive, Impala, Java, Python, R, UNIX

Others: MS Office, Excel, Visio, PowerPoint, Apache Spark, AWS, SharePoint, Confluence, JIRA, Eclipse, Hadoop, Agile, SVN

PROFESSIONAL EXPERIENCE

Data Analyst Intern

Confidential

Responsibilities:

Generated dashboards, reports and conducted ad-hoc analysis with high attention to detail and fast turn-around deadlines.
Evaluated reports statistics and monitored business KPI's to recommend the areas of improvement in the system.
Extensively analyzed large data-sets to turn it into actionable insights and effectively communicated the metrics to key decision makers.
Communicated outcomes effectively to a wide variety of audiences and determined best audience for data-driven insights.
Supported ad-hoc business scenarios, by developing complex SQL queries and data visualization reports in Tableau.

Business Intelligence Engineer

Confidential

Responsibilities:

Worked on relational and multidimensional data model to implement optimized analytical data mart.
Devised strategies to implement change data capture to handle slowly changing dimensions.
Responsible for troubleshooting data issues and conducted root cause analysis when reporting data was in question.
Conducted deep dive analysis on the BI infrastructure to migrate, schedule and deploy ETL data flows.
Identified bottleneck within the mappings and improved the performance by using Pushdown optimization technique.
Collaborated with cross functional teams to meet tight deadlines, multi-task, and prioritize workload.

Predictive Analytics on Data Mart

Confidential

Responsibilities:

Interfaced with customers and end users of the system to understand the business needs and facilitate innovative solution.
Implemented business rules to calculate important business metrics and profit ratios, to be delivered to Sr. Leadership.
Optimized stored procedure by implementing database tuning techniques, thus reducing the execution time by 50%.

Data Warehouse Implementation

Confidential

Responsibilities:

Created detailed design document to educate clients on appropriate utilization of business intelligence entities.
Implemented Data Integration and Consolidation to integrate data from heterogeneous source systems and facilitate a strong foundation to build an ETL framework.
Devised error handling and error logging strategies to handle bad data and reprocess them.
Designed test cases based on technical requirements to test the code accuracy and conform if it meets project defined quality standards.
Analyzed and queried metadata repository to perform unit testing, isolate code defects and resolve them.
Developed several UNIX shell scripts to schedule, monitor and automate ETL pipelines.
Revised and improved standard development processes, thus reducing the development time by 30 percent.