Management Sql Server

PRANATHI KARRA

Phone: 732-***-**** Email: ************@*****.***

SUMMARY

2+ years of experience in Database engineering, server, network administration to provide technical and functional guidance and achieve operational excellence.

EDUCATION & CERTIFICATIONS

New Jersey Institute of Technology United States

Masters in Information Systems GPA: 3.8

Aug 2014 – Aug 2015

Jawaharlal Nehru Technological University India

Bachelors in Computer Science GPA: 8.4

Jun 2007 - May 2011

ITIL V3 CERTIFIED

WORK EXPERIENCE

HCL Technologies

Project: IKEA; Inventive Health

Senior Analyst- Database Engineer June 2011 – Sep 2013

Worked on Microsoft SQL Server and gained extensive experience in RDBMS concepts, and developed

Database Objects such as Tables, Indexes, Stored Procedures, Views, Triggers, User Defined Data Types and User Defined Functions

Design database diagrams, E-R diagrams for certain functional requirements.

Experience in requirement analysis, coding and testing various modules in a software development life cycle.

Maintained re-runnable SQL scripts, indexes and complex queries for analysis and extraction to generate ad-hoc reports.

Organized performance optimization including database performance tuning for faster execution time.

Recommend solutions and define database physical structure, functional capabilities, database security, data back-up, and recovery specifications.

Worked on debugging code base for front end applications.

Adept in application support including user issue resolution, troubleshooting, defining user requirements and priorities, and facilitation of IT/user communication.

Extensive knowledge of Windows Server operating systems and Active Directory.

Worked on manually updating the storage firmware for more than 500 Windows servers.

Adept in User experience design, storyboarding & interacting with users to better understand requirements.

Web (IIS)/ File/Application server’s deployment and support and creation of websites, troubleshooting in IIS.

Good Knowledge of VMware Hosts/VSphere and support of the servers and deployments of VM clients in VSphere console.

Expertise Knowledge on Incident management, problem management and Change Requests/ITIL processes and making sure SLA is met with.

Familiar with agile methodologies and scrum techniques.

Hands on experience in managing and communicating with servers and in troubleshooting IT/Software application related technical issues.

Highly motivated, enthusiastic & thorough professional, with proven correctness and credibility with a systematic approach and a single-minded dedication towards the task at hand.

Strong analytical and problem solving skills coupled with interpersonal and leadership skills.

Key projects:

Worked with Ikea Sweden application team on four projects.

Application Calc that supports the internal pricing process for Ikea by calculating cost based prices for all items sold.

Distribution management system, Gemini for North America region to handle store replenishment and customer order fulfilment. s

Claim case handling system, Casy a legacy system for handling product and supply quality deviations and as sales stops and alarms.

A financial system called Coda used as an accounting software solution for number of companies within Ikea.

TECHNICAL EXPERTISE

Database design & Tuning Microsoft SQL Server Mongo DB

Stored procedures Machine Learning ITIL Process

PL/PGSQL T-SQL DDL/DML/DCL

SDLC Data structures Data warehousing, architecture & design

Active directory Agile Methodologies User experience design

Tableau Dependency Injection Story boards

Weka Data mining Axure

VMWare/VSphere R, Python (Beginner) TCP/IP

UML Citrix JavaScript

DFD Windows Server HTML

Knowledge management REST/SOAP ITSM

IIS Teradata

Contact this candidate