Project Sql Server
Resume:
Ramesh Thotapalle Venkatesan (******) TCS
SQL Server Lead/DBA/SQL Developer/SSIS/SSRS
******.**********@***.*** / ************@*****.***
SUMMARY
V Having 9+ years of experience in the analysis, design, development,
implementation, testing, and maintenance of application systems in the
Client Server application environments, worked as a SQL Server Developer,
Application level DBA/ETL developer.
V Handled team about size of 5 members for development and testing.
V Maintaining clear track about status from each associate in the team
regarding their individual development items.
V Maintaining documents related to the project deliverables as per the
standards expected by customer.
V All documents are maintained in VSS once after completing the Final
review by any one team member.
V Excellent backend skills in creating SQL objects like Tables, Stored
Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data
types and functions.
V Very good T-SQL Programming skills. Experience in query optimization &
performance tuning. Used SQL Profiler, Execution Plan, Performance
Monitor and DBCC Commands
V Experience in loading different format of files into SQL database using
BCP/Bulk Insert commands.
V Experience in Database backup, restore and disaster recovery procedures.
V Expertise in writing T-SQL Queries, Dynamic-queries, sub-queries and
complex joins for generating Complex Stored Procedures, Triggers, User-
defined Functions, Views and Cursors.
V Has very good experience in complete ETL cycle including data analysis,
database design, data mapping and conversion and data load.
V Created SSIS Packages for Data Transformation from flat files into
database
V Experience in using SSIS tools like Import and Export Wizard, Package
deployment in SQL Server.
V Executing stored procedures from SSIS packages for loading the data into
database tables.
V Has very strong background experience in a disciplined software
development life cycle (SDLC) process and has excellent analytical,
programming and problem solving skills.
V Excellent verbal/written communication skills and having the ability to
work in a fast paced environment. Good team player and can work
independently. Helped the database developers on technical issues.
V SQL Server Development and Application level DBA Production Support
V Developed Crystal Reports and generated the reports by executing the SQL
stored procedure for many business requirements.
V Proven background improving process quality, performance tuning and
providing system automation recommendations and solutions to manage data
efficiently.
V Experience in creating jobs, Alerts, SQL Mail Agent, Database Mails and
Scheduled DTS and SSIS Packages.
V Visual Basic6.0 stand alone executable files created and deployed in
production environment for banking domain (HKCOA).
V Developed and implemented Visual Basic (Excel Macros) in real time
environment for extracting records from backend using SQL Server stored
procedures.
V Developed Stand alone executable application in Visual Basic for
preparing Delivery Challan using Crystal Reports and deploy the crystal
report into Visual basic application.
V Stand alone Visual Basic exe applications also developed and implemented
for Change of Address of a customer in banking system. This resulted in
reduction of resource in team for every year of successive deliverables.
V Having hands on Experience in Retail domain and Banking domain.
Achievements
V On The Spot Award for Awards for Excellence on Oct-2013.
V Star of the Month Awards for Excellence on Feb-2013.
V Star of the year Awards for Stella 2.0 release by Nielsen Customer on Dec
2012.
V Best Business Champ of Award for Automations developed and released by
BTU from SCOPE on Feb-2011.
Technical Skill and Software Proficiency
Computer System Programming Special Software
Languages
Windows 7, XP, Microsoft SQL Server SQL Server Management
Vista 2005/2008/2014 Studio(2000,2005,2008)
SQL DBA SQL Profiler, SQL Query
SSIS, Visual Basic Analyzer, MS SQL Server
Applications Index Tuning Wizard,
Crystal Reports Execution Plan
SSIS
SQL DBA
Performance Tuning
Crystal Reports
Visual Basic 6.0 and Visual
BasicA (Excel Macros)
Education
Educational Degree Specialization University Year of
Qualificatio Passing
n
MCA Computer PABCET 2004
Applications -Bharathidasan
University-Trirch
irapalli
B.SC Computer Science SCSVMV - 2001
Sankara
university.
Kancheepuram
Career Profile
Since Dec - 2014 Tata
Consultancy Services
PROJECT EXPERIENCE - TATA CONSULTANCY SERVICES (Dec 2014 - May2015)
#1 Project Title: Entertainment - Stella, Connect Music
Client Follett Group
Industry Retail ISU
Solution Environment Application Development, AVCO and
Reconciliation
Work Location Westchester, Illinois, USA
Duration Aug 2014 - Oct 2014
Team size 5
Role Lead
Technology Used Mail Order application. SQL Server 2014
Responsibilities Managing team size of 5 members
Developed Stored Procedures, Functions, and
Triggers.
Understanding the requirement from different
specification documents and maintaining track
of clarifications from customers.
Maintenance of scheduled SQL jobs.
Performance tuning & code review.
Creating SSIS packages and executing stored
procedures, to load the files into destination
tables.
Developing ETL packages.
Maintaining project related documents in TFS .
Company Description: Every day, Follett serve over half of the students
in the United States, and work with 80,000 schools as a leading provider
of education technology, services and print and digital content. Follett
higher education's largest campus retailer and a hub for school spirit
and community as we operate more than 940 local campus stores and over
1,300 virtual stores across the continent.
Project Description: AVCO - Average costing is the accounting method used
for analyzing the cost of gods sold in every month period. Also process
the FIFO - first in first out method of calculation for Rental and Sales
transactions of each books given to different customers. Reconciliation
team uses the ETL process method for loading data into database tables
also generating flat files from different source of database into
different format flat files.
From Apr 2014 -Till Date Tata Consultancy
Services
PROJECT EXPERIENCE - TATA CONSULTANCY SERVICES (Aug 2014 - Oct 2014)
#1 Project Title: Entertainment - Stella, Connect Music
Client CVS Caremark, Buffalo Grove, Illinois. USA
Industry Retail & Pharmacy
Solution Environment Mail Order application.
Duration Aug 2014 - Oct 2014
Team size 5
Role Lead
Technology Used Mail Order application. SQL Server 2014
Responsibilities Managing team size of 5 members
Developed Stored Procedures, Functions, and
Triggers.
Understanding the requirement from different
specification documents and maintaining track
of clarifications from customers.
Maintenance of scheduled SQL jobs.
Company Description :
CVS Health (formerly CVS Caremark Corporation [4]) is an American
retailer and health care company. CVS Health operates over 7,700 CVS
Pharmacy and Longs Drugs stores;[5] a pharmacy benefit manager, mail
order and specialty pharmacies, a retail-based health clinic subsidiary,
MinuteClinic; and an online pharmacy, CVS.com. CVS Health is chartered in
Delaware, and is headquartered in Woonsocket, Rhode Island, where its
four business units are also headquartered. As of 2014[update], it ranked
35th in the Fortune Global 500 list of the world's largest companies, and
12th in the United States-only Fortune 500.
Project Description: Mail order is an intranet based client server
application developed and tested to maintain the records of daily orders
received from customers of CVS Caremark. System having user friendly
screen to interact with end user in the operations team and all database
architecture are maintained in SQL Server transactions are recorded into
database tables by writing stored procedure and reports also generated
from system on daily basis.
Since Apr 2011 Tata
Consultancy Services
PROJECT EXPERIENCE - TATA CONSULTANCY SERVICES (Apr 2012 - June 2014)
#1 Project Title: Entertainment - Stella, Connect Music
Client The Nielsen Company, USA
Industry Media & Entertainment
Solution Environment SQL Server 2008, 2005, 2000 Application DBA,
SSIS.
Work Location Nielsen, TCS-Chennai, India
Duration Apr 2012 - Till Date
Team size 7
Role Lead
Technology Used SQL Server 2005
Responsibilities Managing team size of 7 members
Developed Stored Procedures, Functions, and
Triggers.
Understanding the requirement from different
specification documents and maintaining track
of clarifications from customers.
Maintenance of scheduled SQL jobs.
Performance tuning & code review.
Creating SSIS packages for executing stored
procedures, to load the files into destination
tables.
Creating & restoring backups and involved in
scheduled job maintenance as Application level
DBA activities.
Implementing "Best Practices" and plan for
continuous improvement of processes.
Maintaining project related documents in share
drive.
Client Description :
Nielsen- Entertainment business provides weekly point-of-sale data with
the highest possible degree of accuracy and integrity.
Project Description:SoundScan is an application used for tracking sales
of music and music video products throughout the United States and
Canada. Data is collected weekly and made available every Wednesday to
subscribers, who include record companies, publishing firms, music
retailers, independent promoters, film and TV companies, and artist
managers. SoundScan is the sales source for the Billboard music charts,
making it the official source of sales records in the music industry.
Team worked on converting a legacy application into latest .Net/SQL
server technology. The product went live in December 2012. This team
started working in a program - Connect MusicConnect Music is a platform
to Consolidate and unify Entertainment Data Sources and furnish users
with a unique reporting platform. Integrated data warehouse to furnish
centralized management of entertainment datasets. One frontend for
internal/external users to quickly access connected datasets with
customizable reports, graphs, and dashboards across multiple dimensions.
#2 Project Title: Michaels, Marketing Portfolio
Client Michael's
Industry Marketing
Solution Environment SQL Server 2008, 2005, 2000 Application
DBA, SSIS.
Work Location Nielsen, TCS-Chennai, India
Duration Apr 2011 - Apr 2012
Team size 5
Technology Used Visual Basic 6.0, SQL Server
Role & Responsibilities As a Lead /Developer, I have involved in
Created Visual Basic macro Application for
maintaining the attendance of employees in
the project module. Attendance is
calculated based on the working hours each
one spent in project.
Understanding the requirement from
specification documents and maintaining
track of clarifications from customers.
Coordinate and Communicate with the Onsite
Coordinator/Clients.
Implementing "Best Practices" and plan for
continuous improvement of processes.
Description :
Michaels Stores, Inc. is an arts and crafts retail chain. Its currently
operates more than 1040 Michaels Arts and Crafts Stores located in US
and Canada.
Team working for the project "ECO SYSTEMS", which is to collect
informations about point of sales happening across branches in
Michaels, Texas.
"Loyalty Microsites" is one other project developed using Dot and SQL
Server. The website provided to customer having sales reports in
different format.
Load Sales data from POS into database using SSIS package.
This load process was handled earlier using PERL script, which will
load the limited number of file size. Incase of the file size is huge,
and then main file is splitted into different files with same size, So
that the automation can load into database.
This automation is can load the file size as maximum as possible.
Developed SQL server stored procedures for loading data and generating
reports for Loyalty Microsites project.
Scope International India Pvt. Ltd
PROJECT EXPERIENCE - Scope International India Pvt. Ltd (Apr 2010 - Apr
2011)
#3 Project Title: Visual Basic Automations
Client Scope International India Pvt. Ltd
Industry Banking
Solution Environment SQL Server 2008, 2005, 2000 Application
DBA, SSIS.
Work Location Haddows Road Chennai
Duration Apr 2010 - Apr 2011
Technology Used Visual Basic 6.0, Visual Basic
Applications, SQL Server
Team size 5
Role & Responsibilities Application Developer. Handled all Visual
Basic6.0 and Visual Basic applications
extracting report from backend using
automations (Excel Macros)
Handled juniors for understanding the
requirement and getting proper requirement
from operations team.
Involved in System study and application
designing
Created SQL objects like Tables, Stored
Procedures.
Managed a team of 5 Members
Created basic Reports to meet Ad hoc
business requirement and developed
automations using Visual Basic6.0/Visual
BasicApplication/SQL.
HKCOA is the application delivered
successfully which will allow operations
to do the change of address and account
details of customer.
Company Description: SCOPE use global capabilities and deep local
knowledge in India to provide a wide-range of products and services to
meet the needs of personal banking and business for their customers.
Project Description: Team working as a group "BTU" Business
Transformation Unit, providing IT System automations and process
improvements for the works carried out by operations team manually.
Dowell Technologies Pvt.
Ltd (Vendor for Ramco Systems)
PROJECT EXPERIENCE - Dowell Technologies Pvt. Ltd (Jul 2009 - Jan
2011)
#4 Project Title: Ramco ERP Front end
Client Ramco Systems
Industry Retail
Solution Environment SQL Server, Database Administration - SQL
Server, Netezza and Remedy.
Work Location Chennai, India
Duration Jul 2009 - Jan 2010
Team size 8
Technology Used Visual Basic 6.0, SQL Server
Role & Responsibilities Developed and implemented Visual Basic
applications in real time for generating
different reports for the operations team
requirement.
Maintenance and bug fixing of reports
developed in SQL Server and report
generation from Ramco ERP Front end.
Applied patches and service packs to keep
the database at current patch level.
Created Database and Database Objects like
Tables, Stored Procedures.
Deliverable objects controlling using VSS.
Description: DOWELL Technologies has been established in 1984 at
Chennai, India as Dowell Consultants by a group of Dynamic Software
Professionals with rich experience in IT, driven by high values and
integrity among themselves. DOWELL's major strength is in the Design,
Development & Deployment of Business Process & Applications using Web
Technologies (i.e. JAVA/J2EE, .Net, PHP), ORACLE DB, MS-SQL, Mysql,
Oracle Tools, Visual Basic, Powerbuilder, Visual FoxPro & other latest
Technologies.
Project Description: Team work for 24/7 to support the product from
RAMCO ERP is also known as Ramco Marshall. Design, Development and
Testing of new enhancements are taken care at Dowell-offshore and the
completed project is delivered to client Ramco Systems on time as per
the commitment. All work-item for support and enhancement developed
and delivered using SQL Server backend.
RadhaKrishna FoodLand Pvt. Ltd
(Client of Ramco Systems)
PROJECT EXPERIENCE - RadhaKrishna FoodLand Pvt. Ltd (Sep 2008 - Jun 2009)
#5 Project Title:
Client Radhakrishna Foodland
Industry Retail
Solution Environment SQL, Database Administration - SQL Server,
Netezza and Remedy.
Work Location Mumbai, India
Duration Sep 2008 - Jun 2009
Technology Used Visual Basic 6.0, SQL Server 2000
Team size 4
Role & Responsibilities Developed visual basic applications using
Excel Macros for extracting records from
backend using stored procedures with
reference to the user requirement from
operations team.
Stand alone Visual Basic executable file
developed and implemented for maintaining
the Sales order application in the company.
(SOMA)
Involved in Analysis and Design
Documentation, User requirements and
maintained good documentation.
Database objects version control using VSS.
Backup and Recovery plans for Field office
and Headquarters database servers
Maintained the field office database
backups through SQL Server management.
Coordinated with offshore team, Chennai for
raising tickets in order to fix the issues
in production server.
Description: "Radhakrishna Foodland Private Limited", established in
the year 1989, is a
single point supply chain management (SCM) solutions provider to some
of the world's largest companies in India. Head office located in
Mumbai, India. Having branches across major cities in across India.
Project Description: Team work for 24/7 to support the product from
RAMCO ERP 3x version. Design, Development and Testing of new
enhancements are taken care at client site and implemented in
production server once after completing successful testing in test
server. Applications such as Shipping, Inventory, Sales, Accounts
Payable, Accounts Receivable are the main modules used for maintaining
the regular day to day work of operations team.
Ramco Systems Pvt. Ltd
PROJECT EXPERIENCE - Ramco Systems Pvt. Ltd (Mar 2008 - Aug 2008)
#6 Project Title: Microsoft Server/Client products and implementation
Client Ramco Systems Pvt. Ltd
Industry ERP
Solution Environment SQL Server, MS Visual Source Safe 6.0.
Work Location Ramco Systems Pvt. Ltd, Mumbai, India
Duration Mar 2008 - Aug 2008
Technology Used Visual Basic Application, SQL Server 2000
Team size 5
Role & Responsibilities As a Module Lead, I have involved in
Developed and implemented Visual Basic
application (Excel Macros) for generating
reports from backend as per the
requirement from operation team.
Customers using Visual BasicA are (Berger
Becker, PNWritter and Vodafone)
Experienced in resolving deadlock and
blocking issues for concurrent users
Performance tuning of Ramco e apps ERP on
SQL Server 2000.
Used MS Visual Source Safe 6.0 as a
Version Control System.
Worked in system study and analysis of
software applications.
Developed and crystal reports, which will
use the stored procedure for generating
reports from database.
Company Description: The company provides solutions to multiple
verticals including banking, insurance, manufacturing, supply chain,
aviation, transportation and logistics, healthcare, governance, retail
and more. Ramco Systems is a public listed company and traded in BSE,
NSE and MSE. The company currently employs over 1,800 employees.
Project Description: Team work for 24/7 to support the product from
RAMCO ERP is also known as Ramco Marshall. Application provides
systematic maintenance of records for all the departments like
Accounts (Payable/Receivable), HR, Payroll, Sales, Inventory and
Shipping at client site. Any kind of technical issues and new
enhancements are developed and delivered by the team. Team implemented
the Ramco Marshal ERP 3x version having different modules for clients
by directly working at client environment for long term.
Cognizant
Technology Solutions Pvt. Ltd
PROJECT EXPERIENCE - Cognizant Technology Solutions Pvt. Ltd (Nov 2006 -
Mar 2008)
#7 Project Title:
Client Mellon International Bank
Industry Banking
Solution Environment SQL Server 2008, 2005, 2000 Application
DBA, SSIS.
Work Location Chennai, India
Duration Nov 2006 to Mar 2008
Technology Used Visual Basic 6.0, SQL Server 2000, PLSQL
Team size 5
Role & Responsibilities Worked on Support project on Visual Basic
(Market Share) which will have 24
different group of projects tagged into
one single visual basic group project.
This Visual Basic project maintained by me
without any issue on production for three
months.
Company Description: Mellon international banking is one of the
customers of CTS. Application called "EAGLE PACE STAR". Eagle
Investment Systems is a global provider of financial services
technology and a subsidiary of BNY Mellon
Project Description: Eagle provides portfolio management, data
management, investment accounting and performance measurement software
solutions to financial institutions globally. Eagle deploys its
solutions through a secure private cloud, Eagle ACCESS?, which hosts
and provides on-going support of the applications and systems
infrastructure, thereby helping to reduce complexity and risk.
Dowell Technologies Pvt. Ltd
(Vendor for Ramco Systems)
PROJECT EXPERIENCE - Dowell Technologies Pvt. Ltd (Dec 2005 - Sep 2006)
#8 Project Title:
Client Ramco Systems
Industry Retail
Solution Environment SQL Server 2008, 2005, 2000 DBA, SSIS.
Work Location Chennai, India
Duration Dec 2005 to Sep 2006
Technology Used Visual Basic 6.0, Visual Basic
Application, SQL Server 2000
Team size 5
Role & Responsibilities Created Visual Basic applications using
Excel Macros which will extract data from
backend with reference to the requirement
from end users.
Created Database and Database Objects like
Tables, Stored Procedures.
Created Crystal Reports using Seagate
Crystal Report version 11.0
Training Attended
Year Title Location Organised by
2013 SSIS - Advanced Chennai Tata Consultancy
Services
2012 .Net - E0 Chennai Tata Consultancy
Services
Personal Details
Date of Birth July 30th, 1981
Gender Male
Nationality Indian
Date of Joining April 6th, 2011
Designation Assistant Consultant
Location Chennai
Passport Details F5957135
Date of Issue: 4th January, 2006
Valid Till: 3rd January, 2016
Visa Details
Visa Type H1B Visa
Valid Till 02-Sep-2016
1
Contact this candidate