Post Job Free

Resume

Sign in

Data Analyst Power

Location:
Bellevue, WA
Salary:
70k to 85k
Posted:
February 09, 2021

Contact this candidate

Resume:

KIRAN JAMPANI

+1-949-***-****; adj161@r.postjobfree.com; Seattle

PROFILE SUMMARY

A Business Analytics Professional Data Analyst/Scientist

Proven expertise of solving complex business problems, applying data driven operational excellence models

Business IT professional with experience more than 9 years handling Aerospace Manufacturing and Reliability sectors, and demonstrated application of functional and technical skills in Data Warehousing

ACADEMIC CREDENTIALS

PG Diploma in Data Analytics IIIT-Bangalore CGPA 3.2 / 4 Since Mar 2019

A comprehensive 11-month program taught by Industry experts and IIITB faculty; 7 case studies & projects; 400+ hours of academic learning & 30+ hours of industry mentoring

Consistently scored >80th percentile on all projects for data management, statistics and predictive analytics courses

●BSc, AME/ AERONAUTICAL ENGINEERING CGPA 8.4/10 2014

Singhania University, Rajasthan

KEY PROJECTS

Customer Data Forecasting: Forecasted future data of the product users and helped reducing the delta between Actual Vs Predicted counts

Data Mining on End Product data: Applied vigorous algorithms and achieved about 94% accuracy after performing the text mining using different concepts in Natural Learning Programme

Clustered Customer Vs Non-Customer problems: Predicted Aviation/Aerospace product users’ data likely to be false about 40% of times with a 96.3% accuracy by analysing 300+ users’ data; identified best model out of KNN, Naïve Bayes, Logistic, and SVM

IDEA: Applied all understanding and knowledge of Azure Architect while migrating the existing RDBMS to NoSQL, provided input in about VNets, subnets, Gateways, Linus, power shell related knowledge during this process to business and IT (when required)

Data Warehousing: Part of Data Warehousing activities such as Mart refreshed, OLTP, OLAP loading, ETL (Extraction, transformation & Load), Reporting, Mart batch run processes etc.,

WORK EXPERIENCE

Associate Data Scientist, The Boeing Company, Seattle Feb 2017 – Present

Improved product performance at the minimum by 10% over the span of past two years, redefining the methods of reliability calculation by deep dive analysis on global product user’s environment/related issues after attaining the deep domain understanding, and eliminating the false quoted issues from the customer end product performance results. Tools/Concepts used are Statistics, EDA, Machine Learning, Natural Learning, Deep Learning, Python, R

Forecasted the future data trends, and visualized the delta of Actual Vs Projected data trends for better business understating using Time Series Forecasting (ARIMA, Moving Average)

Reduced a huge work load of almost 70% by web scrapping various websites using Beautifulsoap, HTML. Used programming languages like Python, and Vba

Built several machine learning algorithms (like Classification, Clustering, Naïve Bayes etc.) to apply the data mining concepts such as NLP. This solved so many problems and helped customer gain confidence about what is displaying in the reporting tools, this data will be included in the Customer product performance statistics, hence this deemed to be a major problem to Customer

Built a robust Power bi, Tableau dashboards displaying

oThe performance of the product over the span of time

oProduct delivery details across each country across the globe

Applied all the understanding and knowledge related to Cloud computing while migrating the existing RDMS DB to NoSQL DB to accommodate both structured and unstructured data. Used database/languages/tools/concepts such as Azure cloud computing, Apache Spark, HIVE, SQL, Power Shell, Teradata, Mongo DB, JavaScript (Introductory), Business understanding via RGD, HDFS, MapReduce, Yarn etc.

WORK EXPERIENCE - PREVIOUS

Senior Data Analyst, Cyient Ltd, Hyderabad Apr 2015 – Feb 2017

Client: The Boeing Company

Interact with active (200+) product consumers, data consumers and resolve their data related problems with an excellent business solving skills

Annotated, verified the Clustering, Classification machine learning algorithms inputs and outputs. Create a basic machine learning models such as NB, Regression on product makers data during data management

Built various Power bi (E-R modelling), Tableau and Alteryx dashboards as a customer reporting

Create the complex SQL queries as per business requirements such as building the scripts for batch run processes, back-end counting of automated charts metrics etc.,

Perform the EDA, Statistic Inferences, training model and fitting model tasks on complex datasets

Assisted IT while creating a MYSQL database (as received database) with different

Proficient in querying HDFS with HIVE

Data Analyst, Cyient Ltd, Hyderabad Nov 2011 – Mar 2015

Client: The Boeing Company

Trained as a Data Analyst for 6 months (Jr. Data Analyst)

Built and/or create different sorts of SQL queries either for data extraction or for data inclusion

Engineered in Data warehousing practices such as Data understanding, cleaning, Imputing, Mart, OLAP & OLTP

Acquired proficiency in data analysis techniques such as Exploratory Data Analysis. Used different concepts such as Uni-Variate, Bi-Variate analysis using Python and Excel pivot charts

Familiar with web tools such as XML, HTML, schemas, DTD, XQuery

Built different varieties of Tableau dashboards to demonstrate the insights to department heads

Automated some manual efforts using programming languages such as VBA, C#. Saved manual efforts of around 50%

Familiar with file encryptions such as PGP encryption, Message courier, Hub span, Outlook encryption and their importance for proprietary data

Consolidate the business requirements act as a bridge between business and data scientist

KEY SKILLS

• Machine Learning Regression, Clustering, Bagging, Boosting, Decision trees

• Analytics Languages: R (Intermediate), Python (Expert), BI Query

• Visualization tools: Tableau, PowerBi, Alteryx, Power pivot, QlikView

• Cloud Computing: Azure Administrator & Architect knowledge

• Hypothesis Testing • Databases: Teradata, Mongo DB, HBase

•Statistics & Exploratory Data Analysis • Programming: C, C#, VB.Net, Power Shell, SQL

•Web Technologies: XML, HTML, JavaScript (Basic) • Software Development Life Cycle (SDLC)

•Big Data: HDFS, MapReduce, Yarn • Operating systems: Windows, Linux

•Natural Learning Process – Chabot, Tensor flow, Lexical, Syntactical & Semantic Process

•Deep Learning: Neural Networking, ANN, CNN, RNN• Reinforcement Learning

•Project Management: Project Planner, Gantt Charts, Microsoft Visio, RCA, Fish Borne, MET (Organization Internal tool)

•Microsoft: Power point, Access, Word, Excel (Advanced Excel), Power pivot

•Apache – Spark, Airflow, Kafka • Cloud Computing – Azure (Admin & Architect knowledge), AWS (S3, Redshift)

ACCOLADES

3 Pride @ Boeing awards from the head of data Integration team for helping delivery team to accomplish its goals.

Exemplary performance award from the Analytic hub director for solving the complex problem which resulted 30% cost savings

Best Customer Centric award from best services, and interaction with global well reputed airlines and aerospace leading companies.

Kudos from Selective Client for delivering application with zero production defects in 60 days vs. budgeted 100 days.

Associate of the Month for leading a team to accomplish deliveries during an absence of the lead



Contact this candidate