PRANEETH VARMA

Sunnyvale CA, *****

480-***-**** adb05k@r.postjobfree.com

SUMMARY:

Experience in analysis, design, development, implementation and troubleshooting of Data Mart / Data Warehouse applications using ETL tools like SSIS, Tableau, Power BI.

Conduct reviews of Data assets and controls as part of monitoring capability and leading to improvements in data management practices.

Extensive integration experience as Data analyst by gathering data from different sources, data profiling, data definition, and loaded those data on business warehouse.

Worked on different kind of source systems and deeply understanding of business and accounting terms and formula.

Responsible for design and development of Python programs/scripts to prepare transform and harmonize data sets in preparation for modeling.

Provision of expert information governance, data management and security guidance across the stakeholder community.

Work with business users together and understand functional requirements develop complex queries and provide reports.

Application of various machine learning algorithms like decision trees, regression models, neural networks, SVM, clustering to identify fraudulent profiles using scikit-learn package in python.

Experience in developing Bidirectional cross-filtering in Power BI Desktop, Shape and combine multiple data source, importing and analyzing data from a web page using Power BI Desktop.

Analyzing data from excel and an OData feed, connect with Power BI Desktop (DXA formula compatibility in Direct Query Mode).

Responsible for analyzing simple and complex logic involving calculations of Ceded, Gross, Re-insurance premium amounts for fact tables for Power BI Reporting.

Knowledge in Collecting and aggregating large amounts of log data using Apache Flume and staging data in HDFS for further analysis.

Have good understanding in collecting Data required for testing various Map Reduce applications from different sources.

Participated in Exporting the analyzed data to the relational databases using Sqoop for visualization and to generate reports for the BI team.

Involved in creating Hive tables and loading and analyzing data by writing custom UDFs to process data in hive queries.

TECHNICAL SKILLS:

Skills : Data Analytics, Data Visualization, Machine Learning, PowerPoint/ Keynote, Artificial

Intelligence, NLP

Analytic Tools : PLX Dash boards, Tableau, Power BI, Office Suite, Google Sheets

Programming : SQL, Python, Javascipt, Java, R, MATLAB, C, Linux Shell

Packages : Scikit-Learn, TensorFlow, Keras, Azure ML

Big Data : Hadoop, HDFS, Map Reduce, Hive, Pig, Spark

EDUCATION:

W.P Carey School of Business (ASU)

Tempe, USA

M.S, Business Analytics (CGPA – 3.8/4.0)

May 2017

Coursework: Business Analytics Strategy, Applied Analytics, Enterprise Analytics, Data Driven Quality Management, Analytical Decision Modeling, Marketing Analytics, Data Mining and Machine Learning

Amrita School of Engineering

Bangalore, India

Bachelor of Technology, Electronics and Communication

May 2013

Coursework: Probability and Statistics, Image Processing, Operations Research, Speech Processing, Linear Algebra, Computer Programming, Computer Communications and Network, Information Theory and Coding Techniques

PROFESSIONAL EXPERIENCE:

Google (Shopping Transactions - Contract) Mountain View, CA

Data Analyst, Production/ Risk Operations March 2018 - Present

Developing new classification rules for the available training data sets.

Effectively worked on Repository Manager, Mapping Designer, worklet manager, Workflow Manager, and Monitor

Evaluate effectiveness of already existing classification rule sets and present recommended modifications to improve system performance.

Created report schedules, data connections, projects, groups in Tableau server

Refining use cases and backlog requirements provided by Product Owner, Business Analysts, Scrum master in creating user stories in JIRA boards from design team.

Led the analysis for various projects that resulted in improvements on crucial operational metrics (Salvage rate, POP, Fill Rate) closely linked with end customer satisfaction.

Evaluate effectiveness of already existing classification rule sets and present recommended modifications to improve system performance.

Built the logic and tools to identify and detect abusive patterns across Google Shopping Transaction with a recall of 60%

Enabled real-time abuse monitoring by creating alerting mechanisms, driving a potential reduction in transaction related losses by 50%

Built robust databases, work-flows and dashboards to track key business metrics and helped automate weekly reports

Conducted time sensitive investigations across a cross functional team, maintaining 100% SLA on all priority bugs.

Arizona State University Tempe, AZ

Data Analyst May 2017 - Dec 2017

Led a collaborative effort between Mayo clinic and ASU focused on early prediction of de-compensated heart failure (DHF) in patients by using sensory data

Built data pipelines to run Clustering/Predictive models on patient's sensory data which helped derive key data features to help detect DHF. Led discussions with doctors and ASU's hardware team to assess/scope the findings.

Evaluate effectiveness of already existing classification rule sets and present recommended modifications to improve system performance.

Transformed analytical findings into detailed report, including future road map. Managed a team of student researchers to effectively formulate and assign deliverables

IBM Hyderabad, India

Data Analyst, CBA (Payments and Banking Industry) Aug 2013 -Jun 2016

Design and generation of different database objects like Tables, Views, Synonyms and Sequences, Pl/SQL packages and database Triggers.

Created SSIS Packages for data transfer between servers, load data into database, and archived data file from various heterogeneous sources like SQL Server, Excel and CSV.

Product ownership of Bank's critical batch payment platform. Drove several projects to improve platform load handling capability and reduce product vulnerabilities. System outages cut down by 80% within an year.

Enhanced the operational work flows via process improvements and built data warehousing capabilities to drive report automation, improving turn-around time by 50%

Collaborated with bank's BPAY, Development, Front End and Product design to derive important customer

Metrics (Retention Rate) to bolster data- driven decision making

Awards and Accomplishments:

Awarded IBM’s ‘Best of IBM’ award for innovation and commitment to client (Top 5% Employee)

Executive member of IBM's prestigious employee engagement club. Helped conduct more than 20 cultural and sports events at scale for 2000+ employees over 3 years

Contact this candidate