Resume

Sign in

Data programmer Intern, Data Analyst, SQL developer

Location:
Exton, Pennsylvania, 19341, United States
Salary:
70000
Posted:
October 29, 2016

Contact this candidate

Resume:

SEKHAR S

acxaus@r.postjobfree.com

West Chester, Pennsylvania, 19382, 959-***-****

SUMMARY

Master’s Degree in Business Analytics at UCONN and 4 + years of professional work experience in IT & Analytics

Strong experience on RDBMS and data architecture and all phases of data warehouse development life cycle, from gathering requirements to testing, implementation and support

Data Visualization & Machine Learning skills using R, Tableau, SAS to predict the business outcomes

Excellent programming skills with experience in Java, SQL/PLSQL, Oracle server and Python Programming

Academic level understanding on Hadoop architecture and different daemons of Hadoop clusters

EDUCATION

UNIVERSITY OF CONNECTICUT SCHOOL OF BUSINESS, Hartford, Connecticut, United States 2015-2016

Master of Science in Business Analytics and Project Management (Statistics- MSBAPM) GPA: 3.6/4.0

Bapatla Engineering college, ACHARYA NAGARJUNA UNIVERSITY, AP, INDIA 2007-2011

Bachelor’s degree in Electrical and Electronics engineering GPA: 3.7/4.0

TECHNICAL SKILLS

Big Data Ecosystem

:

HDFS, MapReduce, Pig, Hive, YARN, Impala, Sqoop, Flume, Spark, Scala, Storm, Kafka, HBase, (1 yr.)

Databases

:

Oracle, MySQL, SQL Server, MongoDB (4 yrs.), Cassandra

Data Visualization Tools

:

Tableau, Cognos, SAS Enterprise guide, SAS Enterprise miner (2 yrs.)

Machine Learning

:

R, SAS, JMP, SAS Base, Python (2 yrs.)

Programming Languages

:

C++, Java, J2EE, Shell scripting, Scala, Core Java, JDBC, C, PL/SQL, Perl (3yrs.)

Web Technologies

:

HTML, JavaScript, CSS, Jquery, J2EE (1yr.)

Ericsson R&D Tools

:

JIRA, TPT2/TL2000 for test reporting, MIA, Infobank, Junit Framework (4yrs.)

Development Environments

:

Eclipse (4yrs.)

Operating System

:

Linux, Unix, Windows (4yrs.)

Integration Tools & others

:

Clearcase, Git, Gerrit, Jenkins, ant, Maven, pivot tables (3yrs.)

ACADEMIC PROJECTS

SAS Shootout Challenge (CAPSTONE): Forecasted the data provided by US Census Bureau and Center of Disease Control to predict effects of Baby Boomers Population on disease prevalence, labor force using SAS and SAS Enterprise

Predictive Modeling (NYC Motor Vehicles collisions): Developed a predictive model that anticipates most serious motor vehicle collisions in New York City using JMP to reduce the fatalities using techniques like Multivariate Analysis, Hypothesis testing, Random forest, ANOVA, A/B testing, T-tests and regression models

Data mining on Walmart customer Data: Developed a time series model to forecast the buying trends of the customer in all the quarters of the year to optimize the revenue of WALMART using SAS and Python through clustering

Sentiment Analysis on AMERICAN EXPRESS: Conducted sentiment analysis for the AMEX twitter data using R

Text Mining on Rotten Tomatoes Movie Review: Implemented the text mining concepts on Movie reviews data to analyze the patterns and trends through statistical pattern learning using Enterprise Miner

Social Network Analysis and Cluster Analysis: Performed the network analysis of the senators across the states of USA from Democratic and Republican political parties using Tableau and R

Business Process Modeling: Created centralized Relational Database for change management in an Agile media lab using SQL and performed ERD diagrams, swim lane diagrams using MS Visio

Decision Modeling for Insurance company: Developed a decision model to help employees choose better insurance plan based on their demographics and socio-economic factors using Analytical solver

Wiki leaks Network Analysis: Performed Network Analysis using twitter data of Wiki leaks using Gephi

Visual Analytics for SWISS RE: Created dashboard for the visualization of different geographical regions where the insurance bonds are concentrated for the SWISS RE insurance company using Tableau

PROFESSIONAL EXPERIENCE

Cloud Source Inc Exton, Pike, PA, USA

Data Programmer - Intern Aug 2016- Till date

Responsibilities:

Provided visualization using Tableau to enhance the performance of marketing team by identifying the areas of the potential customers in the available industries for IT services

Executed the SQL queries to extract the real-time data from the database and utilized analytical tools to create demos

Attended business meetings with clients to collect requests, communicated with engineering team to create technical solutions that meet clients' business needs. Gained thorough knowledge in Big data Hadoop eco system

Applied time series analysis, linear regression, logistic regression and decision trees to the company’s data

ERICSSON Stockholm, Sweden

Data Analyst-(onsite consultant) June 2014 – Aug 2015

Responsibilities representing TCS:

Led the script development team responsible for WCDMA/LTE software test data analytics and quality assurance

Utilized and maintained various business intelligence (BI) systems (SSIS, SSAS, and SSRS), Oracle, SQL for ETL tasks

Proficient in performance analysis, monitoring, query tuning, Collect Statistics and creation of logical and physical DB

Quantifying hidden patterns in the Data warehouse data using predictive analytics using Python programming

Developed various dynamic dashboards for ERICSSON products using Tableau across several KPI’s and Metrics

Segmented and profiled customers across multiple geographic regions to forecast the demand using SAS Enterprise Miner. Applied pattern matching using Python in build logs to format errors during user acceptance tests

Performed Geospatial modeling using R to analyze the product concentration areas of the Ericsson Market

Performed root cause analysis FST for software issues and developed automated suites during engineering test cycles

Forecasted the regression models using SAS on the network data sets to identify and analyze data transmission trends

Analyzed the Business processes using ERD diagrams in MS Visio and predicted sales of Ericsson products using Python in the financial year of 2015. Performed Geospatial analysis on the product data using R.

Implemented data mining algorithms like Clustering in R to conduct Customer Segmentation & analysis of clients

Tata Consultancy Services (TCS) Hyderabad, AP, India

SQL Developer Oct 2011 – June 2014

Responsibilities:

Providing data driven insights in TCS Analytics services for the 2G and 3G telecom products of our client Ericsson

Enhancing customer satisfaction and provided insightful information on market trends in 7 countries

Worked on GitHub and Jenkins continuous integration tool for deployment of project packages

Defining Views and Materialized views for simplifying reporting queries using PL/SQL stored procedures

Installing the revised systems by proposing specifications and flowcharts and implementation of ETL using SSIS

Creating SQL queries using joins, sub queries and correlated sub queries for different reports like Network Transmission, Products performance in each software version

Creating Triggers to keep the track of DML operations and deployed indexing on partitioned tables for faster retrieval of the data to enhance database performance

Developing the Shell scripts and PHP scripts to automate the batch and test jobs and creating status reports and reporting to internal manager and onsite team

Building queries & Creating reports, Risk Management Metrics and dashboards for Senior Management

Unit testing the enhanced code in the UNIX environment and automating test jobs in Eclipse using Java script

Delivered customer reports consolidating test results of various software features, throughput and performance testing, regression analysis. Engineered and delivered software and hardware support in the product life cycle

AWARDS & ACHIEVEMENTS

Received on the spot award for the good performance at my work at TCS

Received star of the quarter award from the Ericsson branch department head

Client appreciation from the Ericsson for successfully deploying the objects in the financial year of 2014



Contact this candidate