Business Analyst Resume Example
Love this resume?Build Your Own Now
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.
Skills
|
|
Skills and Accomplishments
- Worked on various complex Deliverables which supports critical Business Driven Reports.
- Automated various complex data load process which saved nearly 10 hours per week of team and reduced manual intervention to support such activities.
- Strong Analytical skills to analyse the problem and provide efficient solution in Timely manner.
- Fair understanding of Repair and Installed Base data, which acts as prime source for various complex Business driven Reports.
- Experience to work and support various Busieness Critical Activities like New Product Launch and Product Filed analysis.
- Fair understanding of technolgies like Hadoop, Hive, Spark, Machine Learning to think out of shell and innovate existing models.
- Great Development and Testing experience of working on various data Models from Tax to Repair.
Experience
01/2016 to Current
Business AnalystHcl Technologies Ltd. － Delaware , NY
Project
The objective of Apple Care Business
Insight Project is to support various critical Business Activities in terms of
analysis and Developments of assets which can be used by Business users and
Teams for planning and Analysis of Apple Care Business. The data is exposed through
a Tableau layer, which is accessible, by corresponding consumers of data. Apart
from this this team also takes care of ETL activities through Alteryx and
Tableau Dashboard Development bases on the business needs. This project is a
centralized project of major Apple Care users and Planners who sends various
requests for data Analysis ,Development and Support and Enhancements. Apart
from this ACBI Team also plays a key role in various NPI (new Product
Introduction) and EFFA (Early Filed Failure Analysis) activities by
creating/enhancing assets and supporting the NPI Reporting needs.
Responsibilities
- Understanding Business requirements and check the feasibility of the requirement
- Tuned database SQL statements and procedures by examining explain plans, monitoring run times and system statistics. Applied database hints, fine-tuned indexes and rewrote code to improve performance.
- Creation of BTEQ, Fast export, Multi Load and Fast load scripts for extracting/loading data from various production systems.
- The automation of getting the file feeds, loading, transformation is done using Unix Scripts/Jenkins/Alteryx.
- Designed and built tables in Biz App layers on top of Semantic layer in Teradata for reporting
- Report Generation through Tableau and Teradata utilities.
- Worked on Data extraction- Performance Tuning for faster data retrieval from tables by improving skew factor of tables.
- Writing complex SQL for Processing data and building Reports.
- Generating Tableau Reports which are used by various users and Decision makers.
- Writing stored procedures and BTeq scripts for new Business Requirements.
- Tracking and Fixing Defects
05/2015 to 12/2015
Teradata DeveloperInfosys Ltd － Northbrook , IL
Project
The objective of Apple Care Repair and Enhancements Project is to support various critical Business Activities in terms of analysis and Developments of assets which can be used by Business users and Teams for planning and Analysis of Apple Care Business.
Responsibilities.
- Understanding Business requirements and check the feasibility of the requirement.
- Tuned database SQL statements and procedures by examining explain plans, monitoring run times and system statistics.
- Applied database hints, fine-tuned indexes and rewrote code to improve performance.
- Creationof BTEQ, Fast export, Multi Load and Fast load scripts for extracting/loading data from various production systems.
- The automation of getting the file feeds, loading, transformation is done using Unix Scripts/Jenkins/Alteryx.
- Designed and built tables in Biz App layers on top of Semantic layer in Teradata for reporting.
- Report Generation through Tableau and Teradata utilities.
- Worked on Data extraction- Performance Tuning for faster data retrieval from tables by improving skew factor of tables.
- Writing complex SQL for Processing data and building Reports.
- Impact analysis of changes to be implement.
- Analysis and Testing of code for new Functionalities.
- Extracting data through Alteryx workflow.
- Generating Tableau Reports which are used by various users and Decision makers.
- Writing stored procedures and BTeq scripts for new Business Requirements.
- Tracking and Fixing Defects.
- Maintaining data integrity between Primary and Secondary Production Systems.
- Supporting NPI and EFFA Activities by maintain data availability in Reporting System and taking care of issues reported during Reporting.
- Enhancements of ACBI codes based of changing Business requirements.
- Extracting ad-hoc reports from Teradata through TPT and BTeq scripts.
03/2013 to 06/2013
DeveloperTata Consultancy Services － City , STATE
Project
The objective of ICA team is to deal with iTunes related data that is used in order to build aggregates that are used for analytics that enables business users to make better business decisions.
Responsibilities.
- Understanding Business requirements and check the feasibility of the requirement.
- Application Development, Maintenance and Support.
- Preparation of high and low level designs, test cases and test plans.
- Perform Unit testing, System testing and Integration test.
- Studying existing application and doing the impact analysis for the new changes to be incorporated.
- Studying the aggregates that are working at the backend of various ICA applications.
- Attended knowledge transition sessions and prepared the KT docs for the same.
06/2013 to 05/2015
Teradata DeveloperCompany Name － City, State
Project
The objective of GBI-Tax-Audit project is
to generate the SAP equivalent reports for Tax Department and Internal Revenue
Service (IRS) authorities for Tax paid by Apple .These requests are both adhoc
and schedule. GBI tax audit team generates and provide these report to Apple
tax Department and IRS authorities. Apart from providing Tax Reports the scope
of project is also extended to work on New Tools and Technologies to make Tax
Reporting easy and convenient for both IRS and Tax Team.
Responsibilities
- Application Development, Maintenance and Support
- Preparation of functional and technical specifications
- Preparing implementation strategy and plan as to how the requirements are going to implemented and prepare the execution plan
- Perform Unit testing, System testing and Integration test.
- Tracking and fixing defects.
- Resolving Production Issues
- DaRT activity for Monthly and Yearly files received from SAP.
- Automating the Report Generation process so as to reduce the dependability from Support teams and save countless hours of manual validation and testing.
- Report generation from EDW and Flatliners as per the ad-hoc Requests asked by various users for various Tax Agency of US and Canada.
Education and Training
2012
Electronics and Instrumentation EngineeringSRM University － City, State, India
- CGPA 8.9
- Emphasis in Electronics and Instrumenation
Certifications
- Teradata Basics TE0121 certified.
- Teradata 12 Technical Specialist Certified
- Certified Cloudera Certified Developer for Apache Hadoop
Languages
- English (read, write, speak)
- Hindi (read, write, speak)
Skills
- Teradata
- Oracle
- Unix
- Tableau
- Apche Spark
- Alteryx
DISCLAIMER
Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.
How this resume score could be improved?
Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:
Resume Strength
- Formatting
- Word choice
- Length
- Measurable results
- Strong summary
- Typos
Resume Overview
School Attended
- SRM University
Job Titles Held:
- Business Analyst
- Teradata Developer
- Developer
Degrees
- Electronics and Instrumentation Engineering
Similar Resumes
