Sql Server Project

LANKA VENKATA ADITYA

Mobile: 330-***-**** Email: ******.**@*****.***

CAREER OBJECTIVE:

To play a successful role and secure a promising position by providing value addition to the company through my structured learning and analytical skills.

PROFESSIONAL EXPERIENCE:

3 years of IT experience in the space of BIG Data - Analytics, Programming, Object Oriented Design & Concepts.

Hands on experience in building and performance tuning of core Java, JDBC, Servlets, JSP, JavaScript, HTML, CSS.

Hands on experience in Hadoop MapReduce, YARN(MR2), Hive, Pig, Sqoop, Hbase, Oozie,Flume. Strong knowledge on Spark with scala and kafka.

Strong knowledge of Object Oriented Programming (OOP) concepts.

Designed and developed JSPs as a presentation layer with using HTML, JavaScript, and CSS.

Experience in SOAP and REST for developing Web Services.

Proficiency in developing MVC2 based applications by using various integration of open source frameworks like Struts, Spring and Object Relational Mapping Technologies like Hibernate.

Good experience in using RDBMS concepts and worked with Oracle, SQL Server, DB2.

Detailed understanding of SDLC and sound knowledge of project implementation methodologies including Waterfall and Agile.

Good Knowledge in preparation of Dashboards using Tableau.

Extensive knowledge in developing ANT scripts to build and deploy application.

Strong technical and architectural knowledge in solution development.

Major strengths are familiarity with multiple software systems, ability to learn quickly new technologies, adapt to new environments, self-motivated, team player, focused adaptive and quick learner with excellent interpersonal, technical and communication skills.

Strong oral and written communication, initiation, interpersonal, learning and organizing skills matched with the ability to manage time and people effectively.

WORK EXPERIENCE:

Worked as Systems Engineer with Tata Consultancy Services Ltd. (TCS) from Aug 2012 to Aug 2014.

Worked as Software Developer with Amtrust Financial Services (KForce) from May 2015 to Aug 2015.

Worked as BigData Developer with Pax International from Sept 2015 to Dec 2015.

TECHNICAL SKILLS:

Hadoop Core Services

HDFS, Map Reduce, YARN.

Hadoop Distribution

Cloudera

NO SQL Databases

HBase.

Hadoop Data Services

Hive, Pig, Impala, Sqoop, Flume

Hadoop Operational

Services

Oozie.

Languages

C#, Java(J2EE), SQL, PL/SQL, Pig Latin, HiveQL, Unix, Java Script, Shell Scripting,VB.NET

Java & J2EE Technologies

Core Java, Servlets, Struts,JSP

Application Servers

Tomcat

Version Control

Github

Databases

Oracle, MySQL, Microsoft SQL Server.

Operating Systems

UNIX, Windows, LINUX.

Build Tools

ANT

Development Tools

Toad, Eclipse

Development Methodologies

Agile/Scrum, Waterfall.

EDUCATION:

Degree

Institute

Major and Specialization

Period

GPA

B. Tech

SASTRA University

Electronics and Communication Engg.

2008 Sep - 2012 May

3.9/4

Masters

University of Akron

Management of Information Systems

2014 Aug – 2015 Dec

3.2/4

PROFESSIONAL CERTIFICATION:

Oracle certified java developer

WORK EXPERIENCE:

Project: Multitenant Data Load into One Hadoop

Client: Pax International Sep’15 – Dec’15

Role: Developer (Entry level)

Description:

One Hadoop is the Hadoop cluster which is used to store all the Cusoastomer data from all the LOBs at one place.

This project involved developing a generalized framework to extract data from different relational databases to One-Hadoop. The data from a table is extracted either on incremental basis or upsert load based on the tables streaming frequency. Sqoop is used as the extraction tool. Tables are created on top of the extracted data with necessary optimizations and presented as views for analytics.

Responsibilities:

Highly involved in business requirement gathering, analysis, feasibility research of the project, estimation and enhancements.

Coordinated with onshore in designing the process flow for the project.

Designed a oozie work flow to perform series of actions like connecting to RDBMs, validating the records loaded.

Designed control table schema which is driving force for entire framework

Developed JDBC code to connect to RDBMs.

Imported Bulk Data into HBase Using Map Reduce programs.

Developed an automated process using Shell script which drives the data pull process from RDBMs to Hadoop using sqoop.

Developed automated processes for archiving, Merging and data conversions.

Highly involved in creating tables on Hive,views for the data pulled.

Developed Hive queries for performing DQ checks on the data loaded to HDFS.

Designed JILs for Autosys to schedule the jobs to run on production cluster as per frequency.

Designed test cases to test the connectivity to various RDBMs.

Handled SVN Version control as code repository.

Conduct Knowledge Transfer (KT) sessions on the business value and technical functionalities incorporated in the developed modules for new recruits.

Environment: CDH 5, Hive, Impala, Oozie, Sqoop, SQL server, Autosys, Shell script, Java

Project: Commercial Autos

Client: Amtrust Financial Services (KForce) May’15 – Aug’15

Role: Developer

Description:

The Insurance portal of the company was maintained by our team. Changes in premium values, ISO rating are mentioned by business analysts and based on that information we need to make the code change.

We used Git as version control tool and have tickets in sharepoint. Once we made the code changes testing analyst will go through it and process it.

Responsibilities:

Development environment has 3 tiers: Development, Stagging, Production. We need to take care of all 3 tiers.

Javascript is used for datapickers seen around the system.

Implemented JavaScript Client side validation and some server side validation with java code as per the requirements

Developed code across various LOBs and tested it.

Design UI screens using JSP, CSS, Struts Framework, Java Script and HTML.

Unit tested all the classes using JUNIT at various class level and method level.

Involved in database interaction using JDBC

Deployed applications in various Application servers like Apache Tomcat, and Web Sphere.

Designed test cases to test the connectivity to RDBMs.

Worked on a POC on Amazon web services.

Effective Cost Calculation using AWS Calculator.

Conducting Cost Optimization Audit for Clients AWS account.

Designed multi-region, disaster recovery and cost effective solution using various services of AWS and also provided a combination of In-house Infra and AWS Cloud.

Attended Insurance domain training.

Environment: JAVA, Shell Script,Junit, JSP 2.0, Servlets,JDBC, XML, SQL management studio, Git

Project: Web-Log Analytics

Client: LLOYDS BANK (TCS) May’13 – Aug’14

Role: Developer

Description:

The application has the ability to parse the log files generated by the Web Server and derive useful information for analytics of the Web-log. Using these analytical reports we can identify patterns of visitor’s interest. Some of the findings from the web-log data are visiting users, peak usage hours, frequently visited pages, most viewed pages/content, visit duration, navigation through which linked sites or search engines, etc.

Responsibilities:

Involved in analysis of the requirements.

Designed user interface layout using JavaScript, CSS, and HTML.

Implemented smooth pagination capability using Java script and JSP to remove existing pagination utility.

Designed, Developed and analyzed the front-end and back-end using JSP, Servlets and spring.

Developed several REST web services supporting both XML, JSON and to expose information from Customer Registration System

Created maven archetypes for generating fully functional REST web services supporting both XML and JSON message transformation. Archetypes built on Spring 3.0 technology.

Prepare builds for DEV and UAT environments.

Built the ETL (Extraction-Transform-Load) model using XML and Java.

Tested performance across platforms using SOAP UI.

Analyzed recorded and modified client-server traffic using an HTTP monitor in SOAP UI.

Created MOCKS for web services testing.

Designed the User Interface with JSF and displayed dashboards for different analysis parameters using Tableau.

Completely involved in generation of test plan and Result Documents.

Participating in the scrum meetings with the development team.

Performed the code reviews for the features developed by the scrum.

Environment: Java, Eclipse IDE, Tomcat Server,SOAP,HTML,CSS,SPRING,Junit,Java Script, JSF,Tableau

Project: SMART – Supply Management and Reporting Tool

Client: LLOYDS BANK (TCS) Aug’12 – Feb’13

Role: Developer and Production Support

Description:

It is a LLOYDS BANK in-house project for project and resource management.

This initiative facilitates the project managers to add the project details and track the details of the project. Also provides functionalities for resource allocation.

Enables user to generate various report based on projects, resource and resource allocated to the project.

Responsibilities:

Directly interacted with customer in seeking the requirements.

Analyzing requirements and seeking Functional Clarifications.

Designing and developing the technical framework for the systems to be integrated.

Developed a web UI based on customer needs using JSPs and struts 1.2.

Devised solutions to expedite the procurement of required data for unique website architectures comprised of HTML, JavaScript, jQuery, CSS, and AJAX.

Proficient in programming JavaScript data capture and event handling methods via the DOM event model

Designed complex queries and stored procedures in SQL server 2012 for generating various user reports.

Highly involved in creating the maintenance plan to back up the DB to a different server for every 24 hrs.

Highly involved in designing JAMS scheduler for data load from file to table.

Extensively involved in deploying the WAR files on Tomcat server and administered the server.

Facilitated migration of existing production database from SQL server 2008 to SQL server 2012

Highly involved in enhancements to the JSPs based on the customer requirement.

Generation of test plan and Result Documents

Analyzing requirements for the application improvements

Studying them and analyzing the impacts

Construction of code and code review.

Addressing production issues and resolving them within SLA.

Performance tuning and process improvements

Environment: MS Windows 2000, OS/390, J2EE ( JSP, Struts 1.2), SQL Server 2012, Eclipse, Tomcat 6

Contact this candidate