Santosh Reddy

Ph. 587-***-**** Email: acqxue@r.postjobfree.com

SUMMARY

•Around 5+ years of experience in Database development and administration of applications using SQL Server 2005/2008/2012.

• Experience in using Performance Monitor and SQL Profiler to solve performance issues and query optimization.

•Expertise in designing and optimizing the various T-SQL database objects like tables, views, stored procedures, user defined functions, cursors, indexes and triggers using Management Studio and SQL Profiler.

•Excellent experience in creating clustered and non clustered Indexes and complex queries.

•Experience in creating SSIS packages and administering ETL jobs for data manipulation and data consistency.

•Expertise in Microsoft Reporting Service (SSRS) with Report authoring, Report Management, Report formatting, Report distribution, Report delivery and Report security.

•Excellent understanding of all SDLC Models (Waterfall, Spiral and Hybrid).

•Responsible for Backups, Recovery along with assigning user and group access to database servers.

•Knowledge about Database products like Oracle 9i/10g, MySQL 5.5 and MS Access 2007.

•Excellent communication and organizational skills.

TECHNICAL SKILLS: -

Operating System:

Windows 95,98,NT, XP, Vista, 7,MS-DOS, Windows Server 2008/2012

Databases:

Microsoft SQL Server 2000, 2005, 2008 R2, 2012, Oracle 9i/10g, MS Access

Application Tools:

Microsoft SQL Server Management Studio, DTS Packages, Microsoft SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Visual Studio 2008/2010, Team Foundation Server 2008/2010, Visual Source Safe.

Languages

T-SQL, PL/SQL, .NET, C, VB Script.

Reporting Tools

SQL Server Reporting Services (SSRS), Excel 2010.

Other Tools

Windows MS-Office, Red Gate Backup and SQL compare tools.

PROFESSIONAL EXPERIENCE: -

RBC Bank Aug 14 – Present

Database Administrator

Responsibilities:

•Installed configured the patches and service packs for the SQL server 2012/2008/2005.

•Automated consistency check of the database (DBCC) for SQL Server. Performed successful migration from database SQL server 2008 to 2012.

•Responsible for creating backup jobs and restores on different environments. Drafted the disaster recovery plan.

•Designed, developed and implemented database security in SQL server 2012/2008 successfully.

•Monitored and scheduled existing/new jobs on production environment.

•Provided technical architecture and database engineering support to move databases from development to test and production for multiple applications.

•Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.

•Used DBCC commands to check physical and logical consistency of the databases and rebuild indexes.

•Extensively used Import/Export wizard to convert T- SQL Queries, Data and Reports from different forms like XML file, MS Excel file, TTF file, PDF file and other formats to SQL data type and Vice versa.

•Developed and maintained Enterprise database management Architecture for SQL server 2005.

•Monitored MS SQL Server performance using performance monitor and profiler.

•Created login accounts and database user accounts and managed database security using groups and roles.

•Created Logical and physical Data models for SQL server 2005.

•Rebuilding Indexes and Tables as part of performance tuning exercise and weekly maintenance plan.

•Used MS SQL Server reporting services (SSRS) to use daily report basis with client-server application.

•Extensively used joins and sub queries to simplify complex queries involving multiple tables.

Bank of America Feb 12 – Jan 14

SQL BI Developer

Responsibilities:

•Designed and created a database that matches the business requirements.

•Involved in creation of new database, planning the location of data, index and transaction log files on the disks.

•Created complex Stored Procedures, Triggers, Tables, Views and SQL Joins and other statements to maintained referential integrity and implemented complex business logic.

•Created SSIS packages for ETL from various source systems into SQL Server Database. Responsible for creating full and delta loads using ETL daily jobs.

•Provided technical support to move databases from development to test and production for multiple applications.

•Improved the performance of the SQL server queries using query plan, covering index, indexed views and by rebuilding and reorganizing the indexes.

•Worked with SQL server profiler to generate traces.

•Wrote queries to produce reports using SQL Server 2008 and Reporting service (SSRS).

•Deploying and scheduling Reports using SSRS to generate all daily Reports including current status.

•Worked on other packages of the SQL server 2005 Edition SQL Server Reporting Services (SSRS).

•Designed Tables, Constraints, Views, and Indexes etc. in coordination with the application development team.

•Writing the stored procedures, checking the code for efficiency, Routine backups and restoration.

•Wrote complex Expressions and Calculations for SSRS reports with Conditional Formatting.

•Responsible for Deployment of the reports using SSRS on to reporting web server, maintained 2 report servers prod and dev.

Jhonson&Jhonson Apr 10 - Jan 12

Sr. SQL Developer

Responsibilities:

•Linked Database Tables to get the reports, routinely, in the excel sheets, required by the managers for analysis

•Design tables using file streaming for image and different schema tables for better performance, backup and recovery.

•Designed and created Report templates, bar graphs and pie charts for analyzing data.

•Developed Drill down Tabular, Matrix and List Reports of the project given by Tech Lead/Manager using SSRS.

•Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.

•Converted various SQL statements into stored procedures thereby reducing the Number of database accesses (since Stored Procedures passes the whole block at one time).

•Analyzed and developed stored procedures, complex queries using complex joins, co-related, sub-queries for the application.

•Design and develop SSIS packages, store procedures, configuration files, tables, views

and functions to maintain optimal performance.

•Performed System Study and Requirements Analysis, prepared Data Flow Diagrams, Entity Relationship Diagrams, Data Diagrams, Table Structures, with a lot of interaction with the client.

Performance tuning on stored procedures.

Wells Fargo Oct 09- April 10

SQL Developer

Responsibilities:

•Created and modified various Stored Procedures used in the application using T-SQL.

•Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS.

•Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.

•Experience in end-user reporting definition, development and platform support using SQL Server Reporting Services (SSRS) and Performance Point.

•Used Reporting Services (SSRS) to generate Reports in PDF, Excel, and CSV format.

•Used MS SQL Server reporting services (SSRS) to use daily report basis with client-server application.

•Developed Sub Reports, Matrix Reports, Charts, and Drill down reports, using SQL Server Reporting Services (SSRS).

•Performed ad hoc queries, design and deployed reports using SSRS and resolved any issues related with it

•Created Logical and physical Data models for SQL server 2008.

•Improved the performance of the SQL server queries using query plan, covering index, indexed views and by rebuilding and reorganizing the indexes.

•Created complex Stored Procedures, Triggers, Cursors, Tables, Views and SQL Joins and other statements for various applications, maintained referential integrity and implemented complex business logic.

•Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.

EDUCATION: -

•Post-Graduate Diploma in International Business Management

St. Lawrence College, Toronto Jan 2014- Aug 2014

•Bachelor of Technology in Computer Science.

JNTU, Hyderabad, India. 2007-2011

Contact this candidate