Post Job Free

Resume

Sign in

Software Engineer Sql Server

Location:
Briarcliff Manor, NY
Salary:
75000
Posted:
August 27, 2017

Contact this candidate

Resume:

JIBIN BABU

+1-716-***-****: LinkedIn: babujibin

ac11d7@r.postjobfree.com

Summary

Professional work experience in Financial and Retail domains in Software Engineer positions.

Experience in working under Agile Scrum methodologies and using Jira and BMC Remedy tool as an Agile task management, issue and bug tracking

Exposed to *nix Shell Scripting (Bourne/Bash), Ruby scripting as a part of various Networking projects done in Master's curriculum.

Exposure and Knowledge in Jenkins and its plugins as Continuous integration and deployment tool, especially using Build Flow Pipeline Plugins.

Exposure to Puppet, Ansible as a Configuration Management automation tools

Professional hands on experience working with Splunk, as an indexing DevOps monitoring tool and experience in developing Splunk search processing queries.

Knowledge on various Docker components like Docker Engine, Hub, Machine, Compose and Docker Registry. Knowledge on various Docker commands.

Excellent experience in using SQL in databases like Oracle, MySQL, SQL Server, PostgreSQL as a part of various curriculum and professional projects done.

Exposure to writing PL/SQL stored procedures, functions and triggers in Oracle database.

Exposed to using General purpose, Process management, and File manipulation Linux commands in Shell Scripts to automate repetitive tasks.

Hands on experience and working knowledge in Core Java and exposed to JDBC and Hibernate.

Worked on Eclipse tool for the development of various software projects in and out of curriculum.

Core Understanding of Computer Networking Principles and Protocols at all 7 layers (OSI layer Model). Experience implementing various Networking protocols using C programming and Verilog HDL.

Experience working in Data Warehousing project using SAP BW 7.0. Worked on reporting using BEx Query Designer, Analyzer.

Willing to learn new technologies/programming languages and possess great respect for integrity.

Academics

Master of Science [Electrical Engineering -Computer Networking Specialization]

State University of New York at Buffalo (2017) [3.367/4]

Bachelors in Electronics and Communication Engineering

Anna University, Chennai, India (2013) [8.21/10]

Technical Skills

Programming Languages

Core Java 1.8, SQL, C, Verilog HDL, Visual Basic 6.0

Scripting

Bourne/Bash, Ruby(beginner)

Databases

Oracle 11g, My SQL, SQL Server

DevOps Tools (beginner)

Git, Jenkins, Puppet, Ansible, Docker, Splunk

Operating Systems

Windows 10, Linux (Ubuntu LTS)

Task Management Tools

BMC Remedy Action Request System, Atlassian Jira

Tools/IDE

Eclipse Luna 4.4, Ns-3, SAP Net weaver 7.0,

Work Experience

Junior Software Engineer Intern May 2016-Aug 2016

Client: Financial Regulatory Authority (Finra), Rockville, Maryland, US

Description:

FINRA is a self-regulatory organization which regulates member brokerage firms and exchange markets like New York Stock Exchange. As an Intern my task was to get an insight about various DevOps tools used in Finra and to develop a dashboard in Splunk [Integrated Insights Dashboard] by integrating it with SQL Server database. Splunk is a powerful indexing DevOps tool. Updates were reported to Manager during daily stand up meetings and followed agile methodology while working on development tasks.

Responsibilities:

Analyzed and Queried Jira’s data base (SQL Server) to generate Bug report and Time to market Matrices. Bug Report and Time to Market Matrices are critical in bringing in DevOps practice into a project.

Involved in several meetings with Splunk team in Finra to discuss about setting up Splunk indexes on SQL Server so as to enable development of Splunk search processing language (Queries) to develop the Integrated Insights Dashboard.

Developed the dashboard UI design using XML and various visualizations including Pie Chart, Bar graphs, Tables etc. were included in Splunk dashboard.

Worked on Jira to update and view daily tasks set by the Manager. Developed code was committed onto Git repository on daily basis.

Received a working knowledge about Continuous Integration/Deployment tool (Jenkins) and Configuration Management tool (Puppet) and Containerization tool (Docker).

Environment: SQL, SQL Server, PostgreSQL, Git, Jenkins, Docker, Splunk, XML, Agile, NoSQL, AWS EMR.

Systems Engineer

Infosys Limited, Chennai, India Oct 2013-July 2015

Client: Systems and Services Company (Sysco), Houston Texas

Description:

Infosys is a Multi-National company which provides IT services across all parts of the world. Infosys provides world class Software Foundation Program for its full time employees to start off with. A four month training program included extensive hands on training on Core Java, RDBMS and on Data Warehousing using SAP tool. Worked on a data warehousing project with Sysco as client for about 18 months

Responsibilities:

Underwent hands-on sessions for three months in core Java, covering the fundamentals; Variable declaration, looping constructs, conditional statements, class modeling, exception handling, collection framework and Object Oriented Design.

Experienced in writing SQL queries and PL/SQL on Oracle database including Cursors, Triggers as a part of generic training program. Obtained a clear understanding on RDBMS.

Worked on Sysco’s Business Warehousing project using SAP BW 7.0 tool to appreciate the Extraction Transformation Loading(ETL) aspect to generate Analytic Reports from daily transaction data

Involved in understanding and modelling data warehouse by creating required data targets for ETL operations and handled several User service tickets and worked on to its resolution by updating it on BMC Remedy tool. Agile methodology was followed in the project.

Worked in a one month development activity of removing ‘#’ character from Sales and Marketing daily user Report by performing enhancement operation in Dev. environment and pushing it until production environment. Assisted in testing works in all environments

Performed daily monitoring work of transaction data using automated Process Chains which enables data loading onto targets by coordinating with multiple teams and attending Conference calls.

Environment: SAP Net weaver, BW 7.0/7.3, Business Objects, Hana Studio, BEx Query Designer, Eclipse Kepler 4.3, Oracle 11 g

Graduation Project

Implementation of Dynamic Host Configuration Networking Protocol [DHCP-Application layer]

Objective

To set up a Client Server architecture to assign an IP address dynamically when a new device connects onto a network. DHCP uses port 67/68 UDP.

Description

Involved in learning and understanding the principles behind working of DHCP networking protocol and developed a client-server architecture to implement the same by performing the 4-way DHCP handshake between client and server.

Connection between client and server was designed and programmed using Ethernet Cable and its specifications were done using various C programs in-built functions for Altera FPGA on Eclipse IDE.

Performed Ethernet request/acknowledgement frame generation using C program Arrays, IP pool at Server side was done using multi-dimensional C Arrays.

Developed Interrupt Service Routines at Client and Server which responds to incoming data in memory descriptors.

Hands on with Bash Shell scripting and various Linux commands for Process management as a part of learning networking protocols on Ubuntu LTS.

Environment: Eclipse Luna 4.4, Quartus II, C, Verilog HDL, Ubuntu LTS, Bash, Python embedded C, NS3, DHCP, IP, SSH, Telnet, SMTP, MAC, FPGA

References

Jaipaul Agonus [Director, Finra, Market Regulation]

+1-240-***-****, ac11d7@r.postjobfree.com

Sree Praveena Vogety [Team Lead, Infosys Ltd/Sysco]

+1-703-***-****, ac11d7@r.postjobfree.com

Jermaine Trice [ Product Manager,Finra]

+1-240-***-****



Contact this candidate