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