Post Job Free

Resume

Sign in

Data Sql Server

Location:
Lorain, OH
Salary:
60000
Posted:
May 19, 2017

Contact this candidate

Resume:

Objective

Experience in designing solutions as a SAP ABAP consultant and looking for job opportunities as a data analyst. I am a programmer, problem solver and fast learner.

Highlights

Vast experience of understanding business requirements, writing functional specification and technical specification.

Expertise in designing new relational database management system.

Expertise in performance tuning of SQL queries

Experience Extract/Transform/Load (ETL) in SAP.

Expertise in creating application in MVC architecture in Java as well as ABAP.

Experience of working in network programming in UNIX/LINUX environment.

Expertise in creating interactive, tabular, graphical reports in ABAP as well as from relational, multidimensional using SSRS.

Worked in SSIS package to transfer data from heterogeneous database and different file formats (Text file, CSV file) to SQL server.

Deep knowledge of SQL Server developing store procedure, View, Functions, Complex queries, Triggers and cursor.

Strong proficiency analyzing data with a big data environment on Hadoop using noSQL database like mongoDB, Hive and Sparks)

4 - Full life cycle implementation of SAP projects –SIT, BAT, Go live and Support.

Proficient in SAP Finance and Controlling Functional Modules, IS-OIL and IS Retail.

Technical Skills

Databases: SQL Server 2012,SAP

Database Technologies: SQL Server Enterprise manager-SQL, OLTP, SQL, SSIS, SSRS

Programming Languages: C, C++,C#,Java,Python,HTML,PhP,ABAP, SQL, R, Network programming C

Tools: Microsoft Excel using VBA coding, Microsoft PowerPoint

Education

M.S in computer Science, Cleveland State University – GPA 3.93 4 2015-2017

B.E in Computer Science, Amravati University – 76% with Distinction 2000-2004

Experience

Working as a Research Assistance at Cleveland State University:

Project for the CWRU-CSU Federated Experimental Cyber Infrastructure Testbed using SVM in python

Recognizing individuals in a given photo using a classification algorithm that is trained from independent datasets at CWRU and CSU.

Working on developing the training datasets to be used at CWRU and CSU and programming the learning algorithm for the classifier using the demo system at CWRU.

Develop the classifier using the complete dataset on our system and demonstrate its recognition performance, and then to distribute the training data and the computations on the two demo systems at CWRU and CSU and to develop a new classifier.

Compare performance in terms of both recognition accuracy and computational speed.

Projects at Cleveland State University

1.Sentiment Analysis on “airlines” data and applied Data mining algorithms on twitter data:

Web Application: Twitter

Stream/Loader: Python API”TWEEPY”

Database: SQL server 2012

Visualization: Python Plotly

Process:

Python API “TWEEPY” is installed to help extract data from twitter

Python program -Clean the text data and create a structured data (CSV file)

Data is transferred into SQL server by SSIS as well as SSRS for analysis

Applied MDX and DMX queries on the data for sentiment analysis

Associate rule mining and clustering algorithm are applied for data mining

2. Big data (Hadoop)-Processing and Analyzing Twitter JSON data

Web Application: Twitter

File System: Hadoop Cluster

Stream/Loader: Flume

Database: MongoDB/HIVE

Visualization: Python Plotly

Process:

Use Hadoop file system to store the data

Use Apache Flume to load data into hadoop’s file system

Create a basic MapReduce job to aggregate data

MongoDB for processing and querying data

Create pie chart representation of data set

3. Big data analysis on amazon product review

Data Source: Amazon

Database: Hive

Visualization: Tableau

Process:

1.Setup Hadoop cluster on Amazon product review data

2.Involved in creating Hive tables loading with data and writing hive queries, which will run internally in map, reduce way.

3.Worked on analyzing Hadoop cluster and different big data analytic tools including Hive database

4.Creating Hive tables and working on them using Hive QL.

5.Create visualization graphs for queries using Tableau and Microsoft excel.

6.Trust and helpfulness of reviews using Logistic regression using Sparks machine learning algorithm.

Achievements:

Coached the Northeast Ohio’s first Data Science (Kaggle – like) Competition for High School students

Received Gold medal from Amravati University, India for meritorious result at College level.

Participated and won Medals in State Level Badminton Competitions

Certified Level-1 Microsoft Certified Professional (2005) - 100% score

Awarded Best Employee for the SAP Implementation project with Chevron.

Actively involved in social service activities

Past Experience:

INFOSYS Cincinnati, Ohio

Technology Lead Analyst (Client: Proctor & Gamble) 03/2010 - 02/2013

Managed a team of 5 SAP consultants and worked as a Solution designer analyst

for complex client requirement.

Recommended and executed (coded) enhanced Finance and Controlling modules concerning

G/L accounts and Accounts Receivable, which resulted in an increase in customer satisfaction.

Gathered Requirements, Designed, Developed and Tested SAP objects .

Worked on SAP business object and implemented ABAP Dictionaries, Classical and

Interactive Reports (ALV) within the R/3 architecture.

Worked in object oriented ABAP, programming Classical R/3 objects like BADIs/BAPIs,

User exits, Enhancement spots, BDC, LSMW, Function Modules, RFCs, Module Pools,

Scripts and Smartforms.Configured ALE, EDI and Inbound/Outbound IDOCs.

SAP archiving and Performance tuning of ABAP objects and Scheduling and Processing.

SAP BASIS administrator maintaining user roles and authorizations, system backup and monitoring

Implemented Workflow procedures in Finance and Controlling module to automatically notify

users of Account postings

KPIT CUMMINS INFOSYSTEM LIMITED Pune, India

SAP Project Leader /Workflow and Webdynpro consultant, 04/2009-03/2010

Managed a team of 8 SAP consultants and 10 Dot Net consultants to convert the existing Dot net

Platform into SAP. Worked as a Solution architect as well as Data architect

Dot net were converted in SAP Webdynpro ABAP and approval process was mapped into

Business workflow.

Integration and configuration on content management of Enterprise portal with Webdynpro.

SAP ABAP consultant (Clients: Bosch USA), 11/2008 – 04/2009

Interacting with Business to analyze requirements and providing technical designs.

Development of Upload Programs through BDC/LSMW to upload the master data related to SD,

MM,FI, PP, PM and QM modules .

Worked on SAP Script and Smart forms design for check payments, purchase order, Excise invoice,

Rejection invoice, GR label printing, and debit/credit notes.

Development of Custom User Reports both in Standard Format and Interactive ALV to develop

Consumption Reports, Purchase Registers, and Sales Registers.

LARSEN AND TOUBRO INFOTECH LIMITED Mumbai, India

SAP ABAP Consultant (Clients: Chevron, USA), 08/2006-11/2008

Development of Upload Programs through BDC/LSMW

Worked on MM Pricing Routines and sales view enhancement through user exists

Development of Custom User Reports both in Standard Format and Interactive ALV tool.

Unit testing and integration testing of Objects developed as well as creating Unit testing script.

Worked on support phase of the project and solved production defects

SAP ABAP/Enterprise Portal Analyst, 05/2005 – 08/2006

Created Webdynpro perspective of NWDS.

Applications includes, Links to various internal systems (such as payroll, employment information,)

in one iView, Updated news in Chevron SBU,application calling RFC from backend R/3 system

Single SignOn to various applications using the SpNego technology



Contact this candidate