Sign in

Data Microsoft Office

Jersey City, New Jersey, United States
January 24, 2018

Contact this candidate


SURESH PERATLA, *** Irving Street, Jersey City, NJ – 07307 609-***-****


• Research Analyst with 2+ years of experience in Business Logistics and Data Analytics domains in providing productive solutions.

• Exceptional at extracting, cleansing, integrating data from disparate sources by leveraging available technologies & BI tools.

• Experience in gathering requirement, writing user stories, creating use cases and preparing Business Requirement Document.

• Extensive experience in Analytics reporting, Automated reports using macros, nested formulas, functions, Index and match.

• Demonstrated excellence in creating eye catching and lucid visualizations utilizing advanced features of Tableau.

• Extremely proficient at transforming data into meaningful, actionable information to enable strategic and operational decision making.


Analytical Tools: Tableau 10, Rattle, Gephi, Google Analytics, SSRS, SSIS Software’s / Tools: Browser Stack, JIRA, Microsoft Office Suite (MS Excel, MS PowerPoint, MS Outlook) Languages: C, C++, Java, SQL, PLSQL, R, Python, Javascript Databases/Warehouses: MySQL, PostgreSQL, Teradata, Oracle 11g, MS Access, Microsoft SQL Server Algorithms: Predictive Modeling, Regression Analysis, Clustering, Decision Trees, K-Means Methodologies: SDLC, Agile, Waterfall

Marketing Skills: Data Mining & Analysis, Competitor Analysis, Brand Tracking & Planning, Strategic Decision Making CERTIFICATIONS:

• “Lean SIX SIGMA proficiency as a “GREEN BELT“ holder under the guidance of TATA Consultancy Services.

• SQL/PLSQL languages


TATA Consultancy Services Limited - Chennai, India Research Analyst in R&D July 2014 - July 2016

• Developed and maintained ‘Application Analyzer’ of TCS R&D Products likes Bioinformatics Solutions, Mastercraft and Application Life Cycle Manager (ALM) using Java as the core technology.

• Improved the performance of ALM by User Acceptance Testing (UAT), SDLC concepts of Bug tracking and also defined the Test Conditions/Expected results for it.

Client: Kaiser:

• Performed data cleaning, data mining, and exploratory data mining in Biomedical data for enhanced healthcare using Pandas, Numpy packages in Python.

• Developed Python scripts for data extraction & used dimensional modeling technique in PostgreSQL to store the data for reporting.

• Developed complex SQL queries to query data, designed dashboards for data visualization (Tableau) & generated ad-hoc reports. Client: Zebra Technologies:

• Performed the complete analysis on Procure to pay and Order to cash cycles of the current logistics domain.

• Improved business performance through 15 % by reviewing Business Requirement Document (BRD) and performed Gap Analysis for new functionality requirements.

• Worked on defining complex business requirements and providing analysis towards operational efficiency.

• Developed sales tables using BOL (Business Object Layer) for the client to handle the database.

• Implemented new strategies and designed the Order Management templates based on BRD using PLSQL language.

• Developed and maintained the Customer data integration system based on Oracle DB,PL/SQL Client: Motorola Solutions:

• Developed components for Motorola website using Adobe Experience Manager Tool, which helps to create, manage and optimize customer experiences across every channel including web, mobile apps and other digital forms.

• Performed testing for core functionalities of designed components of Content Management System (CMS) using Load Runner, JIRA and Browser stack platforms

• Developed the scripts using Vugen and had performed the test for 200, 500 and 1000 users by using different geographic load generators to achieve the real time usage of website at different regions.

• Provided a complete analysis on the performance results and their Root causes for the pages which are having high response times.

Centre for Advanced Research in Indian System of Medicine (CARISM) - Tamil Nadu, India. Research Internship Sep 2013 - May 2014

• Performed extraction, isolation, purification and characterization of active compounds (Cancer Drug) from “Tecomella undulata”

(plant) along with its therapeutic analysis and submitted Research paper to Journal of Pharmacy Research reports. Indian Academy of Sciences (IAS) - IISER Kolkata, India. Fellowship May 2013 - Aug 2013

• Worked on real time kinetics and dynamic modeling that involved in the gene activity of Bacteria. EDUCATION

Stevens Institute of Technology - Hoboken, NJ Expected Dec 2017

Master of Science in Engineering Management, Specialization in Data Exploration and Visualization for Risk and Decision Making, GPA –3.92/4

Coursework – Informatics for Engineering Management, Data Science & Knowledge Discovery, Decision Making via Data Analytics, Data Warehousing for Business Intelligence, Dynamic Modeling of Systems & Enterprises. SASTRA University, Thanjavur - Tamil Nadu, India

May 2014

Bachelor of Technology in Industrial Biotechnology, CGPA - 8.59/10 Completed with “HONORS” & Merit Scholarship (3 years) Coursework – Bioinformatics, Mathematical Modeling, Optimization Techniques, Organizational Behavior. ACADEMIC PROJECTS

Stevens Institute of Technology - Hoboken, NJ

Data Mining & Analysis of Pesticides on Food Products and its Impact (Pesticide Data Program) Fall 2016

• Analyzed the dataset, classified and extracted the most frequently used pesticides on Food Products.

• Computed the Tolerance and Toxicity levels of the pesticides using Python programming and identified their impact.

• Interpreted graphically and visualized the correlations of analyzed data using Bokeh and Matplotlib concepts. Data Mining, Analysis & Dynamic Modeling of Quality of Red Wine. Spring 2017

• Performed the CRISP-DM framework analysis on the dataset and created a model to classify individual features to finally target their quality factor prediction.

• Prepared the data using R studio (Rattle), transformed the classified data and interpreted the correlations of all the quality factors of the wine.

• Performed modeling techniques like K-Means Algorithm and Decision Tree analysis in order to segregate the dataset into useful clusters.

• Evaluated and reviewed the steps executed to construct the model and finally determined the influence of different chemical properties of Red Wine on its quality by calculating their accuracy and error rate.

• Visualized the correlations of analyzed data using Tableau as the platform. SASTRA University - Thanjavur, Tamil Nadu, India Aug 2013

• Developed a biological database using Data Mining concepts for analyzing the biological impact of diseases. HONORS & ACCOLADES

• Scholar with Recognition, Stevens Institute of Technology December 2016- Present

• Awarded Certificate of Appreciation as a “HARBINGER” for outstanding performance in TCS. June 2015 ACTIVITIES/INTERESTS

Active member of Stevens Language Exchange Club.

Contact this candidate