Data Sql Server

Kaamini Tripathi Email: *****************@*****.***

[Big Data / Business Analyst] Phone: 932**-*****

Profile Summary

Professional experience of 6+ years in IT industries in increasing role of competencies.

Well conversant with Big Data (Hadoop) & Its eco-system components, Oracle and NOSql, Hql,

Expertise in Implementing Big Data, solution and analytics. Using Map Reduce, Pig, Hive, Hbase, Sqoop, Flume.

Exposure in deferent phases of software development life cycles.

Learning & researching machine learning algorithms using R language.

Area Technical Skill

Programming Language Oracle SQL, HQL, C, R language

Big Data Ecosystem Hive, Pig, Sqoop, Yarn, Hbase, Hdfs, Flume, Oozie, Zookeeper

Database Oracle 9i,10g, SQL-Server-2008

No SQL Cassandra (NoSql), HBase

Tools & Utilities R Studio, MySqL, SAP

Application servers Handling SAP(Production, Testing, Development) Servers with Solution Manager with Designation of SAP(Basis Administrator)

Operating System Windows, Linux, Ubuntu

Certification Oracle 9i Certified Associate

Others Oracle 6i Development forms and Reports Developer, SQL Server DBA,SAP (Hr & O&M) module user training and handling as IT core team member.

Experience

1 Years SQL Server DBA one Year handling SQL Server DBA 6 Months Big Data Analysis & Research using Hadoop Technologies (Spectralogics)

Education Qualifications

M. A. Barkatullah University Bhopal

P.G.D.C.A Barkatullah University Bhopal

B. Sc. Barkatullah University Bhopal

Big Data Platform (weblogs) Hadoop 2.6.0 With Others

Role Solution Architect

Team Size 5

Tools & Ubontu 14.04 LTS,Hadoop 2.6, Map-Reduce,Apache Hive,Apache Sqoop, HDFS, Technology Flume,MySql.

Project Description

Web Visitor log Analytics project is initiated to demonstrate our capability on Big Data Processing & Analytics.

This project involves analyzing log data of the web visitors coming from web server.Huge log data is first downloaded & ingested into HDFS - Hadoop Distributed File System using Apache Flume utility. After ingesting, data will be cleaned &transformed using Apache Pig/Hive utilities.Cleansed structured data is then transferred to a relational database storage system where it can be further used for reporting.

Big Data Analytics Performed

Which is the most viewed page on the web portal

Which is the most viewed products on the portal

Which is the most frequently used web browser

Generate a report with top 3 viewed products of year 2012 & 2011

Generate a report with top 3 IPs address accessing portal in year 2012 & 2011

Generate 3 different report showing products accessed by top 3 IPs address,

reports should have products names & their view count in descending order

Generate a report containing all products & their view counts in descending order

Generate a report containing all User IPs & their hit counts in descending order

Personal Information

Gender Female

Dob 2 Dec.

Marital Status Married

Address 124, Goyal Vihar, Indore ( MP), India

Contact this candidate