Naga K
Analytics Engineer @TechStar Group
Signup · Get unlimited contacts
WORK HISTORY
Analytics Engineer @TechStar Group
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
Koneru Lakshmaiah College of Engineering
Bachelor of Technology (B.Tech.), Mechanical Engineering
SKILLS
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.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.