Management Sql Server

M anjunath Narayani

Address: **** ********* ******, *******, ** United States.

Contact: 314-***-****; E mail : ********.*********@*****.*** ; S kype I D:

m anjunath.narayani;

L inkedIn: h t tp://www.linkedin.com/in/manjunathnarayani

Database Management Business I n telligence ERP Implementation

E XPERT ISE PROF I LE

A versatile technocrat with over 8 years’ experience in database

Project Management

management, application development in T-SQL, ERP Implementation,

Database Management

solution architecture, design, solution engineering, service delivery and

Planning & Execution support and implementation

Has recently worked as Business In telligence developer and

Project Resourcing

administrator at Charter communications.

People Management

Unique blend of managerial, technical, functional and qualitative skills

Requirement Analysis w ith ability in all aspects of architecting, maintenance and

t roubleshooting

Stakeholder

Skilled in analysis and design of highly available and scalable databases

M anagement

across diverse industries

Troubleshooting Demonstrated skills in mapping client’s needs and conducting gap

analysis to devise cost effective end-to-end IT solutions to maximize

Analytical Skills

customer value perception

Team Management

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

TECHN ICAL SKILLS

Windows Family

Operating Systems:

MS SQL Server 2012/ 2008/ 2005, SSRS2012, SSIS 2012, and Oracle 9i

Database

(SQL & PL/SQL)

T echnologies:

C#, .Net 4.0

Programming

L anguages:

Visual Studio 2012, M icrosoft SSMS (SQL Server Management Studio),

Tools:

SSIS (SQL Server Integration Services, SSRS, PL/SQL Developer,

SQL*Plus, M icrosoft Team

Sage MAS500, GP 2010

ERP Products:

P ROFESSIONAL EXPER IENCE

CHARTER COM M UN ICAT IONS, St Louis, MO, USA

since JANUARY 2015

Senior developer and administrator for Business I ntelligence

Primary goal was to convert around 400 real time spreadsheet reports to concise SSRS

reports. This required deep analysis of the data coming from Oracle database.

Responsible for installing, configuring and managing SSIS and SSRS environment

a long with their databases.

Responsible for creating t-SQL queries, procedures and functions required to be used in

SSIS to migrate the data.

Responsible for designing and developing, maintaining and scheduling SSIS packages

for migrating customer data from Oracle to Microsoft SQL server 2012.

Responsible for generating analytical data, building complex SQL queries in T-SQL,

V iews, Stored Procedures, functions for real t ime reporting.

Responsible for designing, developing and maintaining SSRS reports as per the

requirement.

Make performance balance by making appropriate SQL tuning to reports tuning using

best practices and various tools like sql profiler.

Actively involved in getting the reports feedback from the end user and make

appropriate changes.

P roject: CSG – Billing operations.

IGN I FY SOFTWARE PVT LTD, PUNE M AY 2006

– N OVEMBER 2014

Senior Technical Analyst, Since Jun 2010

Junior Analyst, May 2006 - May 2010

Responsible for installing, configuring and managing the database in SQL server 2005,

2008, 2012.

Responsible for building T-SQL queries, Stored Procedures, Views, Functions in SQL

server and managing the database.

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

i nvoices and payments for integrating it with ERP MAS500 in T-SQL and SSIS 2008 for

m igrating the data.

Managing the dynamics AX database and MS CRM 3.0 / 4.0 databases to archive data

over a selected t ime period for the entire database for selected companies

Responsible for maintenance of the databases by making maintenance plan using SSIS

tool.

Configured log shipping at client environment for disaster recovery.

Responsible for overseeing the database server tuning including SQL tuning, SQL

i ndexes.

Responsible for designing and developing, testing, debugging and t roubleshooting 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

p roject planning, budgeting, resources deployment/utilization, r isk identification &

m itigation and project t racking

In teracting with users for system study, requirements gathering, analysis and testing

of system along with designing M icrosoft SQL Server & reports and installing, configuring

and upgrading Microsoft SQL Server products

In teracting with the compliance board toward implementation/execution of projects

related to sensitive data and providing extensive advisory/technical support

Responsible for completing the migration of the order management system from

ASP.Net to C# and ensuring robust implementation of SQL Stored Procedures and SQL

F unctions

• Key Projects:

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

o

Project: Ignify e-Commerce System

o

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

L anguages: C# .Net 4.0; O perating Systems: W indows Family;

D atabase: M icrosoft SQL Server 2012; O rganization: I gnify Software

Pvt L td; L ocation: Pune; M odule 1: M ulti-Store Order Management

Desk; D uration: Nov 2009 – Nov 2014

Project (Module 3): Real-Time Reporting

o

Tools: M icrosoft Client Side Reporting Services 2010

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

o

A rchaluminum and P r ide

Role: M SSQl DBA, SSIS Developer; C lient: Dallas Cowboys, Mercola,

Falcons 365, Kaba, US Digital Media; L anguages: C#; O perating

Systems: W indows XP; D atabase: SQL Server 2005 and 2008;

D uration: 6 Months

Project: Business I ntelligence Implementation for M icrosoft Corporation

o

Role: M SSQl DBA, SSIS Developer; C lient: M icrosoft Inc. ; L anguages:

C#; O perating Systems: W indows XP; D atabase tools: SSIS 2005;

O rganization: W ipro Technologies; L ocation: H yderabad; D u ration: 12

M onths

E DUCAT ION/ CERT I F ICAT IONS

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

MCSA M icrosoft SQL Server 2012, I ndia

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)

Contact this candidate