Sql Server Project
Resume:
Suresh Nanubala
ac3mwg@r.postjobfree.com
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
42
Retail
Accounting
87
Iron &Steel
Automation
26
HealthCare
Health Care
10
Technical Expertise
Technology
Details
Experience (Months)
Packages (Include Versions)
Modules
Programming Language
ASP
VB Script
Java Script
95
90
150
Database
SQL Server 2008 R2/SQL Server 2000
DB2
144
119
Operating System
Windows
Unix
102
70
H/W platform
GUI
VB 6.0
VB.net
ASP.NET
C#.NET
130
76
83
108
Tools
VSS
SVN
SSIS
SSRS
Stash
80
20
74
38
95
Application Server
Windows
160
Design Methodology
Agile
Waterfall
48
60
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)
4
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)
8
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.
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)
NA
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)
NA
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)
NA
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)
NA
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)
NA
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)
NA
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