Sql Server Project

Location:

Cincinnati, OH

Posted:

December 07, 2017

Contact this candidate

Resume:

Suresh Nanubala

+1-513-***-****

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

Summary

Possess 14 + years of Software Application Development /Database Development experience in

Developing projects and providing support.

Over 10 years of database development experience with Microsoft SQL Server 2000/2008 R2.

Having good knowledge in Extraction, Transforming and Loading (ETL) data flows using SSIS.

creating mappings/workflows to extract data from SQL Server and Flat File sources and load into

Various Business Entities.

Handled development of some large/medium-sized applications using Microsoft Technologies

For developing Client-Server and Web applications.

Performed analysis, created functional specs, Design, development, testing, deployment

and documentation.

Provided production support for various applications.

A self-motivated team player with hands on experience in programming Real time applications.

Having good knowledge on Six Sigma and ITIL.

Self-motivated and able to work independently as well as in a group environment with an active

Team player attitude.

Excellent communication, interpersonal and analytical skills.

Extremely motivated, able to work smoothly even under pressure, meet deadlines in advance,

ready to accept new challenges and adapt quickly to new technologies.

Designed new reports and wrote technical documentation, gathered requirements, analyzed data, developed

and built SSRS reports.

Excellent knowledge in RDBMS concepts and constructs along with Database Objects creation

such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views,

User Defined Functions, Cursors and Triggers.

Hands on expertise on database migrations from MS SQL Server 2000 to MS SQL Server 2008 R2.

Domain Expertise: (State NA, if Not Applicable)

Domain

Specific Area in Domain

Experience (Months)

Retail

Merchandising

Retail

Accounting

Iron &Steel

Automation

HealthCare

Health Care

Technical Expertise

Technology

Details

Experience (Months)

Packages (Include Versions)

Modules

Programming Language

ASP

VB Script

Java Script

150

Database

SQL Server 2008 R2/SQL Server 2000

DB2

144

119

Operating System

Windows

Unix

102

H/W platform

GUI

VB 6.0

VB.net

ASP.NET

C#.NET

130

108

Tools

VSS

SVN

SSIS

SSRS

Stash

Application Server

Windows

160

Design Methodology

Agile

Waterfall

Education

Degree

Qualification

College / University / Institution

Year of Passing

Masters

M.sc(c.s)

Andhra University

2003

Bachelors

B.sc(c.s)

Andhra University

2000

Engagement Overview

Project Name

Merchandising Systems

Start Date

June 2014

Client

Kroger

End Date

Till Date

Project Location

Cincinnati, Ohio

Team Size handled (If applicable)

Project Description:

The Kroger Co. Headquartered in Cincinnati, Ohio, Kroger (NYSE:KR) is one of the nation's largest grocery retailers. It is the United States’ largest supermarket chain by revenue ($115.34 billion for fiscal year 2016). The Kroger Co. spans many states with store formats that include grocery and multi-department stores, convenience stores and mall jewelry stores. We operate under nearly two dozen banners, all of which share the same belief in building strong local ties and brand loyalty with our customers.

Kroger is also the third-largest retailer in the world and the second largest private employer in the United States. As of December 2015, Kroger operates, directly or through its subsidiaries, 2,778 supermarkets and multi-department stores.

Module Description:

The Merchandising applications help the sales managers and category managers to prepare sales plan, create advertisements, and assist in budgeting activities and also all sales related activities for all the divisions of the Kroger company. Enterprise Sales Planning, Meathead, Contract Reviewer, Trade point, AUTOAD, Promotional Review System, Budgeter, Sales Plan Generator, KCMSDW are some of the Key merchandising applications that are supported by the Merchandising Systems.

Role / Responsibilities

Responsibilities:

Database:

• Create and modify DB2 Stored procedures using Aqua data Studio.

• Execute SQL Statements, Stored Procedures using DB Visualizer.

• Develop SQL scripts, stored procedures, and SSIS/DTS packages to

accomplish various database tasks.

• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading

data into data warehouse.

• Involved in the Migration of Databases from SQL Server 2000 to SQL Server 2008 R2.

• Prepared the complete data mapping for all the migrated jobs using SSIS.

• Created databases and schema objects including tables, indexes and applied constraints,

connected various applications to the database and written functions, stored procedures

and triggers.

• Designed new reports and wrote technical documentation, gathered requirements, analyzed

data, developed and built SSRS reports and dashboard, supported general business reports.

• Developed different type of reports including: Ad Planning Reports, Sales report and other

Critical reports by using SSRS and SQL Server 2008/2012.

Application:

• Involved in Analysis, Design, Coding, Testing, and Post implementation support

phases of the project.

• Major and Minor enhancements in the Enterprise Sales Planning,

Kroger Category Management Systems Data Warehouse and AUTOAD

applications.

• Responsible for managing enhancement and incident requests and coordinating releases

between the development team and the business.

• Assisted in onsite development efforts as needed with a variety of technologies including

but not limited to: Visual Basic.net, C#, ASP.NET, classic ASP,

T-SQL and Visual Basic 6.0.

• Involved in complete software development life cycle (SDLC) i.e.

requirement Analysis & Specification, technical design and Implementation

• Contribute to process improvement initiatives.

• Participate in deployment, system testing, UAT (onsite and offshore).

• Used Jira/Infra ticket tracking systems.

• Create Test cases to test the functionality of newly developed features and upload

in Quality Center.

• Implemented business requirements in backend using efficient stored

Procedures and flexible functions, and facilitated easy implementation

to the front end applications.

• Debug recurring support issues and come up with permanent solutions.

• Use of CSC Proprietary tools and techniques (GHPAT, GPF) in the project

as needed.

• Deploy the developed code base in development environment and

perform unit testing.

• Create and Update technical documents and links in SharePoint server.

• Move Data extract shell scripts to Test and Prod Servers by using FileZilla.

• Debug recurring support issues and come up with permanent solutions.

• Create and Update technical documents and links in SharePoint server.

• Move Data extract shell scripts to Test and Prod Servers by using FileZilla.

• Execute Data extract shell scripts using Putty by running UNIX commands.

• Facilitate sprint planning, daily scrums, retrospectives, stakeholder meetings,

and software showcases meetings.

• Work closely with project owner in backlog management and continuous delivery of

Features.

• Educate and reinforce scrum methodology and agile framework to team members and

Key stakeholders.

• Protect development team from outside distractions, impediments or team conflicts and

maintain focus on product backlog and project timeline.

• To provide 24/7 production support and emergency handling within specified SLA for

Merchandising applications.

• Utilize the following tools:

Aqua data studio, DB Visualizer, Putty, FileZilla, JIRA, Infra Quality center (QC),

Stash, and Microsoft Visual Studio 2008, MS Access 2010,SQL Server 2008 R2 and

SQL Server 2000.

Production Support :

Provide technical second-level product support for merchandising applications developed in C#.net, ASP.net and VB6.

Responsible for tracking of trouble tickets and resolution of escalated support incidents using Infra and Jira tools.

Answers technical support queries and implements fixes for application problems.

Works on cross-functional teams to proactively address support issues.

Creates and maintains documentation for supported applications.

Coordinates with customers to resolve technical support issues.

Develop works plans and scheduled for testing activities.

Diagnose test results and document product defects.

Support in batch/online invoicing process developed in DB2 and SQL Server 2008 R2.

Monitor jobs in Tivoli Work Scheduler (TWS).

People / Team:

Involved individual IT team members in decision-making process through meetings.

Monitored team progress toward timely delivery of goals.

Resolved and provided guidance to team members for escalated technical issues.

Decreased product defects by 50% through implementing new best practices.

Do technical reviews of code and test plans created by team members.

Involved in client interaction meetings on regular basis.

Worked on task assignment, delegation of work.

Acted as subject matter expert (SME) for key applications.

Environment:

C#.NET, ASP.net, VB 6.0,DB2,Unix,SVN,Sharepoint,SQL Server 2008 R2

Operating System: Windows 7,Windows XP, Windows 2008

Project Name

RASC

Start Date

Mar 2007

Client

Kroger

End Date

May 2014

Project Location

Hyderabad

Team Size handled (If applicable)

Project Description:

Module Description:

The Regional Accounting Service Center (RASC) is used by The Kroger Co. to manage accounts for various divisions. RASC users perform various accounting formalities and sends information to Kroger Accounting System (KAS),SON-709 and the Vendor Payment System (VPS).

Role / Responsibilities

Responsibilities:

Database:

Worked on Database migration from SQL Server 2000 to SQL Server 2008 R2.

Migrated all DTS packages to SQL Server Integration Services (SSIS) and

Modified the Packages accordingly using the advanced features of SQL Server Integration

Services.

Played a major role in production support of SSIS jobs.

Migrated data from different sources (text based files, Excel spreadsheets,

and Access) to SQL Server databases using SQL Server Integration Services

Increased query performance, necessary for statistical reporting by more than

25% after Performing monitoring, tuning, and Optimizing Indexes tasks by using

Performance Monitor, Profiler, and Index tuning wizard.

Implemented complex business requirement in backend using efficient

stored procedures and flexible functions, and facilitated easy implementation

to the front end application.

Worked on table designing, writing stored procedures, triggers, functions

in SQL Server.

Worked on performance improvement of SQL Queries.

Involved in interacting with the business community to understand their

requirements

Design and developed PL/SQL procedures, packages and triggers

to be used by team members.

Developed packages using DTS.

Having good knowledge on SSAS and SSRS.

Created test cases and tested many database components.

Worked on resolving database related issues.

Actively involved in Unit testing, System Testing, UAT and implementation during project

Development.

Application:

Involved in Analysis, Design, Coding, Testing, and Post implementation

Support phases of the project.

Worked on Crystal reports for some of the applications.

Worked on Excel applications using VBA macros.

Migrated VB6.0 applications into ASP.net.

Migrated classic ASP applications into ASP.net.

Developed new applications in C#.net.

Contribute to process improvement initiatives

Participate in deployment, system testing, UAT (onsite and offshore).

Used Peregrine/Infra ticket tracking systems.

Having good Knowledge on ITIL.

Involved in complete software development life cycle (SDLC) i.e.

Requirement Analysis & Specification, technical design and Implementation.

Production Support:

Provide technical second-level product support for merchandising applications.

Responsible for tracking of trouble tickets and resolution of escalated support incidents.

Answers technical support queries and implements fixes for application problems.

Works on cross-functional teams to proactively address support issues.

Creates and maintains documentation for supported applications.

Coordinates with customers to resolve technical support issues.

Develop works plans and scheduled for testing activities.

Diagnose test results and document product defects.

Support in batch/online invoicing process developed in DB2(SQL),SQL Server 2008 R2.

Monitoring job schedules in Tivoli Work Scheduler (TWS).

People / Team:

Mentor and guide team, coach team members based on their

Developmental needs.

Onsite Assignment for Project Deployment (6 Months)

Enable knowledge sharing within and across teams.

Do technical reviews of code and test plans created by team members.

Involved in client interaction meetings on regular basis.

Worked on task assignment, delegation of work.

Acted as subject matter expert (SME) for key RASC applications and assisted

business and development team to provide efficient solutions.

Contribution:

Provided support for applications and worked to reduce the support tickets.

Worked on many enhancements on existing applications to save users time and effort and improve

Application performance.

Worked on Server Migration project from one location to another location.

Worked on Database migration from SQL 2000 to SQL Server 2008 by converting existing DTS packages into SSIS packages.

Environment:

ASP,ASP.NET,C#.NET,VB.NET, VB 6.0,SQL Server 2000, SQL Server 2008 R2,SSIS,

DTS packages, DOS,CD Utility

Operating System: Windows XP

Project Name

iReach

Start Date

Jul '2006

Client

Infocom Systems

End Date

Feb ‘2007

Project Location

Hyderabad

Team Size handled (If applicable)

Project Description:

iREACH streamlines the management of health information across the continuum of care and supports an integrated and coordinated approach to healthcare. iREACH allows each client to be screened across all services for which they may be eligible. Each client can be assigned a medical home for health services. Client records follow the clients throughout the Safety Net so informed decisions can be made regardless of point of care .iREACH can be customized to the specific needs and requirements of your programs. The system facilitates the process of eligibility screening, enrollment of Clients and Providers, referring the uninsured/underinsured to available health services, scheduling appointments, interpreters and transportation, case management and disease management.

The System is a web-based Application, using Microsoft's Internet Information Server, under Windows 2003 Server. The database is Microsoft's SQL Server 2000.

Value and Benefits:

• Customizable software application to meet your specific needs and tailored to meet your process

• A browser-based system that is flexible, easy to use and available 24/7

• Reduced administrative complexity

• All client data in a single system to streamline workflow

• Compliance with industry standards and trends, protection of investment

• Unprecedented service and support.

Role / Responsibilities

Developer

Contribution:

Coded for Claims Management module.

Involved in Unit Testing, Debugging and coordinated with Clients for delivery.

Created Tables and developed database schema scripts, stored procedures and triggers

Troubleshooting and Performance of SQL Queries and Stored Procedures

Environment:

ASP, VBScript, SQL Server 2000, JavaScript, SQL Server 2000

Operating System: Windows 2003 Server

Project Name

Employee Management System

Start Date

Jan '2006

Client

Raga Software

End Date

Jun `2006

Project Location

Hyderabad

Team Size handled (If applicable)

Project Description:

This project is to develop to manage employees and administration in company. There are four main modules of the

System. Employee Registration, Employee Details, Administration, Reports. Employee details are stored in

SQL-Server 2000. Time Clock, Leave and Salary details of the employees are the part of the project. Developed reports for Management to analyze Employee performance, expenditure details.

Role / Responsibilities

Developer

Contribution:

Developed Administrator module

Self Testing.

Developed database schema scripts.

Wrote stored procedures and triggers

Environment:

VB 6.0, Windows 2003 Server, SQL-Server 2000, Crystal Reports

Operating System: Windows 2003 Server

Project Name

Merchant Mill Monitoring System

Start Date

Jan'2005

Client

Automation Division, TATA STEEL

End Date

Dec `2005

Project Location

Jamshedpur

Team Size handled (If applicable)

Project Description:

The system is developed to check the behavior of the drives in the mill and also provide all users the facilities to view live status of the Mill. This project is developed to solve the high tension of the drives during mill running. Whenever tension of particular drive is high an alarm is displayed for operators. All the parameters of respected drives are stored in SQL-Server 2000. TOP Server reads parameters from all drives through an interface. OPC Clients are used to read drive parameters from TOP Server. Display of the Online Data, Mill Status, Billet Counting, and Temperature are done in this project.

Role / Responsibilities

Developer

Contribution:

Designed and developed Screens for the project. Involved in calculating Billets, Checking tension of the drives, Displaying Online Data and Generating Reports.

Developed dll files for the project.

Developed database schema scripts.

Environment:

VB.6.0, ASP.Net, Windows 2000 Server, SQL-Server 2000, TOP Server, OPC, ActiveX Control

Operating System: Windows 2000 Server

Project Name

Sanjeevini Health Care System

Start Date

Aug'2004

Client

S.E.Rly.Hospital, Chakradharpur, Tatanagar

End Date

Dec'2004

Project Location

Hyderabad

Team Size handled (If applicable)

Project Description:

This system is developed to automate the transactions of OPD section of Railway Hospital. Patient details and employee details are stored in SQL-Server 2000 Database. Auto captured data from different departments was brought at one place. Automatic Patient ID generation, Patient registration, Patient's history, Treatment details, Reports generation are of part the project. Operator will register a new patient. Registered patient details are stored in database and available for all doctors. Administrator can view the performance of departments and doctors for different time periods.

Role / Responsibilities

Developer

Contribution:

Designed Screens and coding

Developed database schema scripts and wrote stored procedures and triggers

Unit testing

Environment:

VB 6.0, SQL-Server 2000

Operating System: Windows 2000

Project Name

SYMS Offline Crane Simulator

Start Date

Mar'2004

Client

Automation Division, TATA STEEL, Jamshedpur

End Date

Jul'2004

Project Location

Jamshedpur

Team Size handled (If applicable)

Project Description:

This system is developed to train Crane Operator to perform various tasks in Slab Yard, Tata Steel.

This Crane simulator provides an environment, which acts exactly like real time Crane Operating System. This is designed for new crane operators to train them in a safe mode. Operators performs various tasks like slab pickup, lay down, moving

Crane to different places in yard, sending telegram messages to server. Serial communication, TCP/IP sockets are

Used to develop this system.

Role / Responsibilities

Developer

Contribution:

Designed Screens and coding project.

Developed database schema scripts, stored procedures and triggers.

Developed dll files and developed ActiveX controls for the project.

Unit testing

Environment:

VB 6.0, TCP/IP Sockets,RS-232

Operating System: Windows 2000

Project Name

Automated Data Logger and Weigh Bridge

Start Date

Oct'2003

Client

Automation Division, TATA STEEL

End Date

Mar '2004

Project Location

Tatanagar

Team Size handled (If applicable)

Project Description:

This Automated Data Logger and Weigh Bridge was developed to read online data from hardware, which is

connected to trailer. Data is downloaded from hardware and stored in SQL Server database. Reports and graphs are generated from database. The other part of the project is developed to read online data from Weigh Bridge, which is connected, to PC. The Key modules of are Automatic Bundle Id generation, Display of online data, Automatic Shift handling, Security to the system.

Role / Responsibilities

Developer

Contribution:

Designed and Developed screens of this project.

Coded for communication and downloading Data from Hardware to System.

Developed database schema scripts, stored procedures and triggers.

Environment:

VB 6.0, SQL SERVER 2000,RS-232

Operating System: Windows 98

Employment History

Company Name

Designation

Start date

End Date

DXC Technology, Cincinnati

Web Developer

June 2014

Till date

CSC India, Hyderabad

Senior Analyst

March 2008

June 2014

Datamatics Pvt. Ltd,Banglore

Software Engineer

March 2007

March 2008

Raga Software Solutions Pvt .Ltd,Hyderabad

Software Engineer

Jan 2006

Feb 2007

Napasoft, Tatanagar

Software Engineer

Oct 2003

Dec 2005.

Contact this candidate