Naga K

About Naga K

An Experienced Business, Data Analyst with a total 7+ years of Experience worked on various projects related to fraud analysis, revenue assurance etc using various tools Oracle, SQL, Hive etc, and generating reports out of them to make a better understanding with the help of insights to the business. Apart from the mentioned:1. Cost and Time optimization for logistics based work.2. Data Analyst with data analysis of data sets with the help of PL/SQL.3. Quality Assurance Engineer4. Oracle ERP Domain Specialist with HRMS module.5. Performance Test Engineer.6. Automation Test Engineer.Additional Skillset:• Applied statistics & advanced analytics – Correlation & Regression analysis, ANOVA, Design of Experiments, Time Series AnalysisLean Techniques: Kaizen, POKA-YOKE, TQM, 5S, Value Stream Mapping, Kanban, TPM, OEE, SMED, TAKT time, Line Balancing.Six Sigma Techniques: DMAIC, FMEA, ANOVA, DOE, Hypothesis Testing, MSA, SPC, QFD, Process Mapping, Multivariate tools.• Supply Chain Management – Linear programming, Operations Research,• Proficient in statistical and analytical packages – R, AMPL, Minitab, Advanced Excel• Programming skills – Python, SQL, HTML/CSS, C,Java, PL/SQLSoftware Tools - HP Quality Center, Load Runner, Tosca Test Suite, Selenium, AutoCAD, MS Power Point, MS Word, MS Excel, MS Project.

Experience

1. Analytics Engineer

   TechStar Group

   Dec 2018 — Present · Dallas, TX, US

   Working with the business team to understand the customer data and gather the requirements to develop and analyze required systems using SQL.• Working with the upstream team to understand the data flow for different use cases.• Develop required Models to find fraud based on the features available.• Data Reporting Activities are done using Tableau and Qlik Sense etc.• Data cleaning to be done on the available data to make it available as per need to perform data analysis to find various risks involved while performing fraud analysis using Oracle.• Developed required platform for Data Migration/Data Engineering activities from Oracle to Hadoop using SQL queries.• Developed dashboards on Qlik sense/Tableau to monitor daily ordering from each customer as per the business requirement.• Performed Data analysis to understand the fraud data by writing complex SQL queries, and also experienced in writing UDF’s, derived tables, views, subqueries and multiple joins.• Knowledge in various reporting objects such as Dimensions, Measures, Filters, Actions, Sets, Groups, Bins etc, for summarizing and analyzing key findings from the data. • Creation of Unix scripts for automating the data extraction from EDW (Teradata) and loading into Oracle.• Time series Analysis is done, Forecasting is performed to predict the amount of sales at the Point of Sales/Demand Forecasting.• Pandas profiling is done on various variables to analyze the data distributions, correlations are found to eliminate variables with the use of Dimensionality reduction methods to develop data models to perform Fraud Analytics and display charts using Tableau.• Developed and loaded tables into Subex ROC Tool.• Converted LEC data into Vision system for Reverse IRB project in Revenue Assurance.• Data Ingestion using Sqoop, Kafka, Bteq & TPT.• Developed required Data Ware housing views, tables in Hive, Teradata, and Oracle etc as per the business requirements.

Education

• University at Buffalo

  Master's degree, Industrial Engineering

  2016

• Koneru Lakshmaiah College of Engineering

  Bachelor of Technology (B.Tech.), Mechanical Engineering

  2009 — 2013

Skills

• Manual Testing
• Logistic Regression
• Python
• Autocad
• Requirements Gathering
• Hp Quality Center
• Material Requirements Planning (Mrp)
• Microsoft Excel
• Ansys
• C
• Programming
• Pl/Sql
• R
• Html
• Ansi C
• Turbo C++
• Test Cases
• Functional Testing
• Java
• Sql
• Hypermesh
• Hp Performance Center
• Quality Assurance
• C++
• Microsoft Office
• Machine Learning
• Microsoft Powerpoint
• Linear Regression
• Catia
• Data Analysis
• Radview Webload
• Requirements Analysis
• Software Development Life Cycle (Sdlc)
• Minitab
• Regression Testing
• Microsoft Word
• Core Java
• Testing
• Tosca
• Agile Methodologies