SUMMARY:

• A highly - motivated masters student with around 9 years of extensive experience in Information Technology aspiring for opportunities in data analytics.
• Involved in all the phases of Data Analysis Life Cycle including data preparation, exploration, predictive modeling, and visualization
• Experience in working with Time Series Models (ARIMA, Moving Average and Exponential Smoothing). Also worked on descriptive and predictive data analytics
• Experience in banking & financial applications, retail and manufacturing industries as well as in domains like supply chain, customer relationship and content management system. Worked in SAP (Sales & distribution) and Hybris (Ecommerce Platform). Worked in Agile / Scrum, Iterative & Waterfall SDLC models
• Knowledge on big data framework Hadoop (Hive), Pig Platform and HDFS distributed system
• Worked on algorithms (Models) like k means clustering, apriori, decision trees and Regressions(SLR/MLR)
• Expertise in Designing Reports from Relational/Dimensional databases as per Business requirements
• Knowledge on page ranking components like search engine, web crawler, etc.
• Proficient on querying and extracting data from repositories such as Oracle, SQL Server, etc.
• Expertise in Requirement Gathering and System Analysis, High Level and Low level design documents, Functional Verification process(with manual and automation testing), maintanence and support
• Sound knowledge and exposure in working with various relational databases like oracle, SQL Server, etc and Excel Analytical functions, Exposed to all required tools such as MS-Word, MS Visio, Excel, Power Point and MS Project
• Experience in playing lead role for various assignments suchas facilitating scope, managing customer expectations, monitoring day to day execution and ensuring the project is on schedule

TECHNICAL SKILLS:

Domain Knowledge: Insurance, Retail, Banking, SAP (SD),Capital Marketing

Languages: Java,Java script,J2ee,Sql,css,html,Visual Basic Scripting, Macros

Analytics Techniques: Sampling, hypothesis testing, Pivot Table

Defect Tracking Tool: JIRA, Quality Center

Machine Learning: Regression, K-Means, Decision Tree, KNN

Configuration Management Tool: SVN

Documentation Tools: Microsoft Office, Open Office, omni plus, Matchware MindView

Design Tools: MS Viso, Draw.io, DT Designer

Software Tools: Tableau, Excel, XLMiner, Toad, MS Sql Server 2008, Heidi, RAD, Eclipse, Beyond Compare, XL Miner, MS Access

PROFESSIONAL EXPERIENCE:

Confidential

Information Systems Manager Intern

Responsibilities:

• Worked on data profiling, cleasing, and analysis.
• Performed regression, sentiment analysis, clustering, associative rule mining to understand data patterns.
• Designed interactive Tableau dashboard identifying the prospective customer to help business in decision making.
• Predicted the percentage of chemical application reduction for the next 5 years using Moving Average forecasting techinique. This prediction is performed to identify the effectiveness of the policies implemented for pest control by county.
• Performed descriptive data analysis on identifying the effectiveness of county policy on chemical treatment application.
• Infered complex requirement and communicated the same to sub-ordinates in understandable manner
• Provided technical assistance to the subordinates .Creating Work Breakdown structure, allocating resources, budgeting and monitoring the status.
• Explored data analysis by collecting and assimilating data from multiple sources.
• Worked on complex queries to generate reports using SQL
• Involved in all project management related activities and handling team
• Acted as a solution architect for business as well as technical
• Configured the network communicators using the database
• Developed web portals using Angular JS, CSS, HTML, Jquery, JavaScript, Bootstrap, JSON

Confidential

System Analyst

Responsibilities:

• Worked as a business architect defining product requirements, writing functional specifications, establishing process and data flow between ecommerce platform (Using Hybris) and ERP (SAP), and leading testing activities.
• Wrote complex SQL queries to perform ETL operations on customer's data from sales&Distribution data warehouses.
• Used PowerPivot, VLOOKUP, Pivot Tables for data cleansing, validation & transformation
• Ran multiple linear Regression & Decision Trees on global customer data to perform client classification.
• Worked on database queries using MS sql server and Oracle 10 G
• Prepared adaptable project plan, Estimation Efforts, Test plan, Test strategy, Requirement Traceability Matrix
• Generated complex SQL Queries Using MS SQL Server, preparing defect reports, document maintenance in SVN, test execution, Managing defects raised in QC and conducted regular defect status meetings
• Interacted exclusively with onshore team for clarification and status reporting

Confidential

Java Developer

Responsibilities:

• Analyzed Functional Specification, Prepared Impact Analysis, class and sequence diagrams, workspace setup, code development and enhancement, Managing Configuration using version control ( Confidential, Confidential team), Raising formulae (Change Request) for technical/system errors, Identify and fixing Bugs.
• Created user interfaces using Presentation Services framework.(Derived using Struts Framework)
• Implemented business logic using spring framework and writing backend model logic using hibernate and JDBC, Deploying Build & merging using configuration management, Performed UI & System testing
• Tracked work status through task tracker Change synergy, Onshore interaction during each release
• Prepared Minutes Of Meetings, Knowledge base on entire application, Conducted core java training for the team members, Performing Quality Assurance Audits like Internal Quality Assurance, External Quality Assurance and FI Process