Sql Server Software Engineer

Education

M.S., Computer Science from New Jersey Institute of Technology, Newark, NJ Completed December 2016

Bachelor of Technology, Information Technology from CITM, Faridabad, India Completed May 2011

Skills

Technical Skills

Extract Transform Load, T-SQL, PL/SQL, Data Warehousing, SQL Server Integration Services, Java/J2EE, Model View Controller, Map Reduce, Pig, NoSQL, C++, HTML, JavaScript, CSS, Python

Frameworks/

Software

MS SQL Server 2008/R2, Microsoft Business Intelligence, Eclipse 3.7/4.5, Struts MVC, Angular JS, Microsoft Visual Studio, Apache Hadoop, Apache Spark, Oozie, Adobe Photoshop, Flash, Dreamweaver

Operating System/Server

Windows, Linux, Apache Tomcat

Domain

Insurance/Reinsurance

Experience

Senior Software Engineer, NIIT Technologies Limited, Gurgaon (Sept 2013 – Aug 2015)

Client: Aspen Insurance, London

Technical Skills/Tools involved: Extract Transform Load (ETL), Data Warehousing, SQL Server Integration Services (SSIS), T-SQL, Microsoft SQL Server, Microsoft Business Intelligence, Eclipse, Java/J2EE

Awards: Star of the Quarter (Oct 2014 – Dec 2014)

Description:

oDeveloped facts/dimensions for all metrics to get in line with the clients’ financial system.

oOptimized the procedures/triggers and created indexes resulting in 40% faster job execution

oTransformed the batch processing system to SSIS packages for the Data Warehouse

oInvolved in the Estimation, Development, Code Review, Delivery and Release deployment

Software Engineer, NIIT Technologies Limited, Gurgaon (Aug 2011 – Aug 2013)

Client: Aspen Insurance, London

Technical Skills involved: Extract Transform Load (ETL), T-SQL, Microsoft SQL Server, Eclipse, Java/J2EE, Spring, SSIS

Description:

oDeveloped claims/messaging modules in Java.

oAdded SSIS packages for job notification and restarting purposes.

oCreated SQL scripts for month end activities for the client.

oServed as a member of the Electronic Data Interchange team responsible for fixing the data driven issues

Key Courses

Big Data: Prepared Hadoop project on Flight Data Analysis involving Map Reduce programming and Oozie workflow scheduler using AWS environment. This project works on 20 years of flight data to extract probabilities of flight delays, cancellations and Taxi-In/Taxi-Out times in requisite order

Data Mining: Created a project that uses 2 classification algorithms to perform supervised data mining on a particular dataset.

Cloud Computing: Learnt about AWS, Google AppEngine and Microsoft Azure. Prepared and Deployed a project using Pig Latin on AWS that analysis correctness of various Football(EPL) betting companies odds w.r.t climate, referee and crowd anomalies.

Other Relevant Experience/Projects/Achievements

Graduate Projects

Worked under supervision of Dr Chase Wu for a research to determine the scenario for the most efficient usage of Map/Reduce programmability

Prepared a Chat Server/Whiteboard Java Project for the course Java Programming

Undergraduate Projects

Prepared SMS Planner Cloud using Java as final year project

Prepared ATM Software using Java/Swings

Trainings

Web Designing from Centre for Development and Advanced Computing, Chandigarh

Achievements

Won the OSUM project competition-2009 for the project ATM Software held at Manav Rachna College of Engineering,

Faridabad

Contact this candidate