Data Analyst

Chanukya Reddy K

***** ******* ******* • Chantilly, VA 20152 • ********.*********@*****.***• 571-***-****

Education

American College of Commerce and Technology Falls church, VA

MS in Computer science, GPA: 3.5 Jun 2017

Relevant Coursework: Object-Oriented Design, Networking Technologies, Operating Systems, Computer Architecture, Algorithms, Practical SQL, Database Management System.

Design Project: Hadoop/Spark– Open-Source Software for Reliable, Scalable, and Distributed Computing.

Project Experience Summary

Excellent Business writing skills in writing Business requirements document [BRD], Use Case Specifications, Functional Requirement Specifications [FRS], Software Design Specification [SDS], Software Requirements Specification (SRS), Software External Specifications [SES], Software Requirement Document(SRD), Data Dictionary, Business Continuity Plan (BCP), Workflows and Unified Modeling Language (UML) diagrams such as Activity diagrams, Class diagrams and Sequence diagrams.

Excellent experience of databases such as MySQL, MongoDB, Oracle 8g/9g/10g, Microsoft SQL Server, PostgreSQL, SQL/PLSQL concepts such as procedures, functions, and triggers.

Knowledge in Create-Modify-Drop Teradata objects like Tables, Views, Join Indexes, Triggers, Macros, Procedures, and Databases.

Excellent knowledge in E-Commerce, Telecom Industry, UI design/implementation, and system capabilities CRM Products, Sales strategy and marketing sector and Strong Analysis knowledge of Financial Statements, Portfolio Analysis, Stock Valuation, Budgeting.

Proficient in Requirement Management, including gathering, documenting, verification, validation, analysis and design.

Solid experience in requirement gathering, documenting, verification, validation, analysis and design.

Developed thorough Use Case Diagram, Activity diagrams based on UML, methodology and business process flow diagrams, Data flow diagrams, state chart diagram using Microsoft Visio.

Strong organizational and planning skills, ability to work well under pressure, result-oriented, self- motivating and versatile in problem solving.

Areas of Expertise

Languages: R Languages, Advanced SQL, Python

Databases: Oracle, Microsoft SQL Server, MySQL, MS-Access, PostgreSQL, NoSQL (MongoDB), SQLite3.

Decision Analysis Tools: Knime, Tableau, SAP, SAS, SPSS

Platforms: Linux Red Hat/Ubuntu/CentOS, Windows, Macintosh, Linux.

Amazon Web Services: Redshift, S3, RDS, DynamoDB, Data Pipeline.

Experience

Hexistech In. http://www.hexistech.com North Brunswick, NJ

Data Analyst Jul 2017 – Present

Hexistech is a growing Product development company involved in providing wide range of application and development & Technical support to the various clients for past decade. Working as an active member of Reporting & Analytics team for providing business critical analysis/reports to multiple business groups across the company.

oResponsible for gathering requirements, system analysis, design, development, testing and deployment. Participated in the complete SDLC process.

oProvide ad-hoc reports to key business partners across different groups to help drive the business decisions.

oWrite complex SQL queries and optimizing them to pull the required data in an effective way.

oAutomated several critical reports and created reusable utilities using Unix Shell Scripting to reduce the number of repetitive requests from users.

oCoordinate with partners both inside and outside the company, understand the business need, perform the required data analysis and provide valuable insights.

oCreated an end-to-end automated process to run each unit through a rule engine before shipping to double check the quality of the products, which is very critical to the business.

oAd-hoc data analysis involving extensive data profiling.

oProvide data visualizations to the users using Tableau.

oDevelop and implement data collection systems and other strategies that optimize statistical efficiency and data quality.

oInterpret data, analyze results using statistical techniques and provide ongoing reports.

oAcquire data from primary or secondary data sources and maintain databases/data systems.

oIdentify, analyze, and interpret trends or patterns in complex data sets.

oWork closely with management to prioritize business and information needs Enabled Tableau actions to drill down from Dashboard to worksheet.

oActively participated in clarification meeting with the Clients.

oInvolved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.

oTested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.

oParticipated in meetings, reviews, and user group discussions as well as communicating with

stakeholders and business groups.

oUse Spark cluster to manipulate RDD’s (resilient distributed datasets) and also used concepts of RDD partitions.

oBuild servers using AWS: Importing volumes, launching EC2, RDS, creating security groups, auto-scaling, load balancers (ELBs) in the defined virtual private connection.

oMigrating physical Linux/Windows servers to cloud (AWS) and testing.

oDevelop applications that use MongoDB database and Pymong.

oWrote Python modules to extract/load asset data from the MySQL source database.

oHaving experienced in Agile Methodologies, Scrum stories and sprints experience in a Python based environment, along with data analytics, data wrangling and Excel data extracts.

oParticipated in writing scripts for test automation.

oSQL Server (experience in designing database, writing and implementing SQL stored procedures and scripts, and performance tuning).

oDesigned and crafted High-Performance Clusters in AWS along with AWS Red shift. Layout, Data Emphasis, Highlighting, Color, Fonts, Tooltips, and performance improvement of complex dashboards/reports.

Ask Mobi-Apps & Consulting Services Pvt. Ltd Hyderabad, India

Junior Data Analyst/Data Scientist Aug 2013-Sep 2015

oPerform Data Profiling to learn about user behaviour and merge data from multiple data sources.

oImplemented big data processing applications to collect, clean and normalization large volumes of open data using Hadoop ecosystems such as PIG, and HIVE.

oDesigning and developing various machine learning frameworks using Python and Scala.

oProgrammed a utility in Python that used multiple packages (SciPy, NumPy, pandas).

oIndependently coded new programs and designed Tables to load and test the program effectively for the given POC's using with Big Data/Hadoop.

oWorked on Clustering and classification of data using machine learning algorithms

oImplemented Classification using supervised algorithms like Logistic Regression, Decision trees, KNN, Naive Bayes.

oImplemented Text mining to transposing words and phrases in unstructured data into numerical values

oHandled importing data from various data sources, performed transformations using Hive and loaded data into HDFS.

oCollaborate with data engineers to implement ETL process, write and optimized SQL queries to perform data extraction from Cloud and merging from Oracle 12c.

oCollect unstructured data from MongoDB and completed data aggregation.

oExperience in working with Hadoop clusters using Cloud era distributions.

oConverting the existing relational database model to Hadoop ecosystem.

oStoring training features are stored in AWS S3.

oValidating and publishing-built model into s3.

oAbility to build ML pipelines in Python or Scala in Spark.

oPerform data visualization with Tableau and generate dashboards to present the findings.

oRecommend and evaluate marketing approaches based on quality analytics of customer consuming behaviour.

oDetermine customer satisfaction and help enhance customer experience using NLP.

oWork on Text Analytics, Naive Bayes, Sentiment analysis, creating word clouds and retrieving data from Twitter and other social networking platforms.

Contact this candidate