Project Sql Server

MADHU SHR I RA JAGOPALAN

***, **** ******, ******** **-11232 973-***-**** *****@****.***

EDUC AT I ON

New Jersey Institute of Technology, Newark, NJ May 2015 Master of Science in Electrical Engineering GPA: 3.5 REC, Anna University, Chennai, India May 2013

Bachelor of Engineering in Electronics and Communication GPA: 3.3 T ECHN I C AL SK I LL S

Database: MS SQL Languages: C#, C, VB Web Technology: HTML, CSS, XML, JavaScript, AJAX, ASP.NET Platforms: Linux, Windows Others: TCP/IP, MATLAB, GitHub, Agile C ERT I F I CAT I ON

Microsoft Certified IT Professional (MCITP) – Database Developer 2008 (SQL) EXPER I ENC E

Developer Feb 2015–Present

Spectra Group, New Jersey, Client: Royal Bank of Canada Capital Markets Technologies: Microsoft Visual Studio 2010, SSIS, .NET Framework 4.0, ASP.NET, HTML, CSS, Subversion Source Control, IIS 8.0, SQL Server 2008/ 2012, Windows Server 2008/2012

Translated business requirements into software design and implemented the full SDLC for a web application

Performed distributed source code management for application milestones and managed user stories using SVN

Developed testing cases to manage code defects

Provided level 3 production support and monitored the applications Project: Retail Portfolio

Developed ETL for Retail Portfolio using SQL stored procedures, SSIS, VB.net and deployed the package as a SQL server agent job

Analysed large data to avoid redundancy and enhance performance Project: Municipal Bond/Swap Reconciliation

Developed a reconciliation job for Municipal bonds/Swap and generated excel reports (using SSIS)

Developed ETL for loading files to and from SQL database and created exception for expired bond/swap

Provided Support by monitoring the source file on daily basis Project: SSIS Migration

Involved in migrating more than 150 SSIS packages from 2008 servers to 2012

Configured similar packages together in a common configuration connection manager using SQL databases.

Tested all the migrated packages and monitored before deploying to production environment Project: Portfolio Analytics Website

Developed a SQL database-driven website for Portfolio Analytics using C#/.NET and SQL server

Developed UI with ASP.NET, AJAX, HTML, JavaScript and deployed the code to server using IIS 8.0 AC ADEMI C PRO J EC T S

Project: Mechanization of IT Progression Lead Direction Jun 2014– Aug 2014

Developed an ASP.NET web application to resolve technical issues of employees by raising a ticket

Used email engine, Database engine, custom controls, server controls, AJAX controls, sitemap detail, LINQ Project: CDS based Virtual Backbone Construction in Wireless Sensor Networks Jun 2014– Aug 2014

Developed an algorithm that leads to a connected domain set (CDS) with guaranteed routing cost using C#/ASP.NET

Developed directional antennas and directional virtual backbone technique to ensure that the signal is switched off or in standby state thus reducing the power consumption and limiting the bandwidth

Contact this candidate