Sql Server Project

Manjunath

Sr. SQL Server Developer/Administrator

*********@*****.***

C: 703-***-****

Certifications:

MCSA Microsoft SQL Server 2012, India

OCA in PL/SQL(Developer) and Database Administration(Oracle 9i)

MS Office Suite (Outlook, Word, PowerPoint), ERP Sage MAS500, MS-SQL Server 2012/ 2008/ 2005 and

Oracle 9i (SQL & PL/SQL)

Summary:

A versatile technocrat with over 8 years’ experience in database management, application development,

ERP Implementation, solution architecture, design, solution engineering, service delivery and support and

implementation

Currently working as a Senior Software developer at Charter communications.

Unique blend of managerial, technical, functional and qualitative skills with ability in all aspects of architecting,

maintenance and troubleshooting

Skilled in analysis and design of highly available and scalable databases across diverse industries

Demonstrated skills in mapping client’s needs and conducting gap analysis to devise cost effective end-to-

end IT solutions to maximize customer value perception

A keen strategist with acumen in providing effective business solution and technical architecture to leverage

technology in creating revenue opportunities

Exceptional dedication to grow with cutting-edge technologies and seeking to achieve beyond expectation in

every endeavor

Technical Skills:

Operating Systems: W indows Family

Database Technologies: MS SQL Server 2012/ 2008/ 2005, SSRS2012, SSIS 2012, and Oracle 9i (SQL &

PL/SQL)

Programming C#, .Net 4.0

Languages:

Tools: Visual Studio 2012, Microsoft SSMS (SQL Server Management Studio), SSIS (SQL

Server Integration Studio, SSRS, PL/SQL Developer, SQL*Plus, Microsoft Team

ERP Products: Sage MAS500, GP 2010

Areas of Expertise:

Project Management, Database Management, Planning & Execution, Project Resourcing, People

Management, Requirement Analysis, Stakeholder Management, Troubleshooting, Analytical Skills, Team

Management

Education:

Bachelor of Electrical Engineering, Raisoni College, Nagpur University, 2005,India

Professional Experience:

Charter Communications, St Louis, MO, USA Jan 2015 - March 2015

Project: CSG – Billing operations

Senior software developer - Business Intelligence

Responsibilities:

Responsible for designing and developing SSIS packages for migrating customer data from Oracle to

Microsoft SQL server 2012

Create complex stored procedures as source for real time reporting and design SSRS reports

May 2006 – Nov 2014

Ignify Software Pvt. Ltd.

Senior Technical Analyst

Junior Analyst May 2006 - May 2010

Responsibilities:

Leading a team of 3 members in ERP and managing the - GP 2013 and MAS 500 along with performing the

duties of a Scrum Manager with a team of 4 members

Responsible for designing and developing, testing, debugging and troubleshooting of the application for

smooth implementation

Maintaining in depth interaction with the client across various functional areas to comprehend and implement

the delivery framework for optimization of delivery

Responsible for coordinating on various projects simultaneously with contributions in project planning,

budgeting, resources deployment/utilization, risk identification & mitigation and project tracking

Interacting with users for system study, requirements gathering, analysis and testing of system along with

designing Microsoft SQL Server & reports and installing, configuring and upgrading Microsoft SQL Server

products

Successfully developing various modules including customer/addresses, sales orders, invoices and

payments for integrating it with ERP MAS500 using SQL server 2008

Interacting with the compliance board toward implementation/execution of projects related to sensitive data

and providing extensive advisory/technical support

Responsible for overseeing the database server tuning including tuning the shared pool, database buffers

and redo buffers

Responsible for completing the migration of the order management system from ASP.Net to C# and ensuring

robust implementation of store procedures and functions

Managing the dynamics AX database and MS CRM 3.0 / 4.0 databases to archive data over a selected time

period for the entire database for selected companies

Overseeing the requirement gathering and preparing the technical specification for SSIS along with

monitoring the preparation of test cases

Key Projects:

Project (Module 2): e-Commerce Integration with Various ERPs

Project: Ignify e-Commerce System

Client: Dallas Cowboys, Mercola, Falcons 365, Kaba, US Digital Media

Module 1: Multi-Store Order Management Desk;

Duration: Nov 2009 – Nov 2014

Languages: C# .Net 4.0

Operating Systems: W indows Family;

Database: Microsoft SQL Server 2012;

Project (Module 3): Real-Time Reporting

Tools: Microsoft Client Side Reporting Services 2010

Project: Data Archival for Dynamics AX and CRM for clients like Archaluminum and Pride

Client: Dallas Cowboys, Mercola, Falcons 365, Kaba, US Digital Media

Role: MySQL DBA, SSIS Developer;

Languages: C#;

Operating Systems: W indows XP;

Database: SQL Server 2005 and 2008

Duration: 6 Months

Project: Business Intelligence Implementation for Microsoft Corporation

Client: Microsoft Inc Role: MySQL DBA, SSIS Developer

Languages: C#

Operating Systems: W indows XP

Database: SSIS

Duration: 12 Months

Contact this candidate