Business Analyst Resume Example Tata Consultancy Services Client : Apple Inc

BUSINESS ANALYST

Summary

Data and Business Analyst with 5 years of experience driving excellence in implementation of business applications to achieve strategic goals. Seeking the opportunity to use expertise across various IT platforms to develop and integrate cutting-edge solutions.
Fair understanding of various machine learning models Regression,Calssification,Clustering
Solid Mathematics, Probability and broad practical statistical data mining techniques
Hands on experience on major component in Hadoop Ecosystem like SparkSQL,HDFS, Hive, Pig, HBase, Sqoop, Oozie, Flume and Avro,Kafka.
Experience in importing and exporting data using Sqoop from HDFS to Relational Database Teradata.
Hands on experience installing, configuring and using hadoop ecosystem components like Spark, Oozie, Hive, Sqoop, Kafka, Zookeeper and YARN.
Good experience in Hive partitioning, bucketing and perform different types of joins on Hive tables and implementing Hive SerDe's like REGEX, JSON and Avro.
Hands on experience in working on Spark SQL queries, Data frames, import data from Data sources, perform transformations, perform read/write operations, save the results to output directory into HDFS.

Skills

Experience

Business Analyst05/2015 to CurrentTata Consultancy Services- Client : Apple IncSanta Clara, CA

5 years experience in data mining and data analysis.
Identified business requirements and devised implementation strategies to solve the business problems.
Prepared Business Requirement Documents (BRDs) to provide scope of work for technical team.
Prepared data examples, runs and views for client meetings.
Mined data to uncover insights and identify market trends and inflection points.
Collaborated cross-functionally with business analysts, developers and testers to explain new process transformations.
Worked in Unix/Linux platform to develop shell scripts for task automation.
Developed SQL queries to obtain complex data from tables in remote databases.
Assessed data and issues and directed concerns to business unit leadership when appropriate.
Made actionable recommendations based on data trends.
Build Data Pipelines to get data from multiple source system and loading in EDW.
Creating Tableau Dashboards to cater the business needs.
Data visualisation for trand analysis and Activity rate calculations.
Extraction,transformation,loading through Alteryx and Python script.
Performance tuning of query optimization.
Data analysis for ad-hoc business questions/concerns.
Proof of Concept(on Hive,Spark)- for seeking new solution to handle increasing data volume.

Teradata Developer02/2013 to 04/2015Tata Consultancy Services- Client: Apple IncDelhi, IN

Drove continual improvement to system architecture by refactoring old legacy code.
Coordinated with QA testers for end-to-end unit testing and post-production testing.
Collaborated with product and engineering team members to define and develop new product concepts.
Created proof-of-concept prototype applications for demonstration and evaluation purposes.
Writing complex SQL code, stored procedures for Data Processing in Teradata.
Interacting with multiple support teams for end to end application go live support
Supporting ad-hoc data/reporting needs for client.
Data Migration from Oracle to Teradata.

Assistant System Engineer09/2012 to 01/2013Tata Consultancy ServicesKerala, IN

Education and Training

Bachelor of Science: Electronics and Instrumentation Engineering2012SRM UniversityChennai, Tamil Nadu, India

Activities and Honors

Automation of ad-hoc report genration process through Teradata utilities and Tableau.
Automation of ad-hoc data laod request from multiple source systems like 3rd party ftp servers and my sql data sources which saves nearly 10-15 hours of week effort of team.
Tableau based data health monitoring tool which keep tracks of key interfaces health(count and data completeness) on key factors.
Appreciation recived for supporting data needs for New Product Launch Report.
Migration of Reports/data from Oracle source to Teradata which is a Pioneer move for the Consumer of data in terms of response time and fast data availability.
Data Modelling and Testing skills to stablise various critical projects.

Certifications

Languages

Technical Skills

Skills	Proficiency	Total Years	Last Used
Alteryx	Good	1	2017
Teradata	Very Good	5	2017
Apache Spark	Good	0.8	2017
Windows, Unix, Linux, Mac OSX, VMWare	Good	5	2017
Autosys/Jenkins/Gitlab	Good	4	2017
Tableau	Good	1.5	2017
Oracle	Good	.8	2013
Unix/Linux	Average	2	2017
Python for Machine Learning	Average	.6	2017
Scala	Average	.6	2017

Resume Overview

Companies Worked For:

School Attended

Job Titles Held:

Degrees