Sql Server Data

Sindhura Kancherla

*********.**@*****.*** Ph: ***-312-

7746

Professional Summary:

• About 8 years of professional IT experience in analysis, object oriented design, development and

implementation of applications in SQL Database Environment.

• Expertise in Database Design and Development, extensively worked with SQL Server 2000/2005/2008

and SSRS, SSAS, SSIS.

• Incorporated database technologies such as ODBC, OLEDB to interface with Oracle, MS SQL Server

and MS Access for Internet/Intranet and business applications.

• Experience in Installation, Administration and Maintenance of SQL Server 2000/2005.

• Experience in Creating SSIS Packages and OLAP Reports using Business Intelligence tools.

• Experience in creating Jobs, Alerts and scheduling DTS Packages and SSIS Packages.

• Worked on Database Monitoring and Performance Tuning and Optimization.

• Proficient generating Sub Reports, Tabular Reports, Grouping and Drill down Reports, Matrix

Reports, OLAP Reports, Charts, Adhoc Reports.

• Experience in Working with OLAP databases and OLAP Reports.

• Working knowledge in designing, testing and improving scalability in database and web-based

applications.

• Experience using Performance Monitor/Profiler to solve Dead Locks/ long running queries, and

restoring database backups.

• Experience in Performance tuning of Sql Queries and Database Reports.

• Extensive experience in data modeling, logical and physical database design.

• Extensive experience with SQL scripts, Stored procedures, Triggers, Functions, Cursors, SQL

Performance tuning and transactions analysis, thorough understanding of indexes and statistics.

• Ensuring the best practices for performing code reviews and providing technical assistance as needed.

• Effective Team Working and Quality, Performance Improvement, High Profile Client Relations.

• Worked in various Types of Software Development Life Cycle like Water Fall, Scrum Methodology

• Excellent communication, coordination, interpersonal skills and documentation skills.

Technical Skills:

Database Environment SQL Server 2008/ 2005/2000, SQL server 7.0, MS Access,

Oracle 8i/9i

Programming Languages: Microsoft VB.Net, SQL, PL/SQL, C, C++, C#, ASP, VB.NET,

ASP.NET.

ELT Tools SSIS, DTS, BCP

Reporting Tools SSRS, Crystal Reports

Web Applications HTML, DHTML, XML, VB Script, Java Script

Web Sever IIS 4.0/ 5.0

Operating Systems Windows 2000,Win XP Prof/Standard, Win 98,Unix

Software/Tools Visual Studio.NET, FrontPage Editor, Microsoft Visio, Visual SourceSafe

Certifications:

Microsoft Certified Technology Specialist (MCTS)

Professional Experience:

Brown Greer PLC, Richmond, VA Feb 11 To To date

Programmer Analyst

BrownGreer PLC is a law firm devoted to mass claims resolution, litigation management, support and

claims administration. BrownGreer is an expert in implementing claims resolution plan and litigation

management and support which begin tracking information at the start of litigation or come in midstream to

gather the data and organize the process.

The Gulf Coast Claims Facility ("GCCF") is the web portal developed for Individuals and Businesses to file

claims for costs and damages incurred as a result of the oil discharges due to the Deepwater Horizon

Incident on April 20, 2010 ("the Spill"). This website provides information on how to check the current

status of a claim, and answers to questions about the process.

Responsibilities:

• Involved in Requirement gathering and Analysis.

• Developed DTS Packages to transfer the data between SQL server database and files.

• Involved in designing and developing the Back End functionality using Sql Server 2008.

• Developed Various SSRS reports for the easy analysis of Claimants information.

• Manage and respond to ad-hoc report requests including analyzing requests, writing SQL, reviewing

results, formatting reports, distributing and scheduling reports to end users.

• Designed and developed the required SQL stored procedures, triggers and database functions using Sql

Server 2008.

• Involved in performance testing and data validation skills.

• Develop and maintain on-demand and scheduled SSRS reports.

• Created SSIS packages mapping different data sources using various transformations to pull the Claims

from the Garden city Databases.

• Used Report Viewer control to embed reports into custom windows forms and Asp.net Web

applications.

• Involved in the Performance tuning at the Application and Database Layers.

• Designed SSIS Packages to transfer data between servers, load data into database using SQL Enterprise

Manager on SQL Server 2008 environment, and deploy the data; Scheduled the jobs to do these tasks

periodically.

• Involved in performance tuning, query optimization.

• Created stored procedures to pass the initial loads into a single database.

• Extensively used Joins and sub-queries for complex queries involving multiple tables from database.

• Extensively involved in discussions with the clients in collecting the requirements.

Environment:

SSRS, C#, ASP.Net, SSIS, SQL server 2008, SSIS Packages, Visual Studio .Net 2008, Windows XP

Well Point, Richmond, VA Sep 10 – Feb-11

SQL Server Developer/ DBA

Health Management Corporation (HMC) is a leading health benefits company that manages high-cost, high-

impact conditions, achieving definitive value for national health plans and employers. HMC is a part of

WellPoint Inc. The purpose of this project will implement (or display) the UM/CM data in HRS frontend,

for enabling the nurse to view UM/CM information of a member in HRS (instead of navigating between

different well Point applications).That is the reason the data is moved from IHUB database to TDL database

using ETL process.

Responsibilities:

• Involved in Project planning and implementation through the life cycle of the project.

• Worked directly with Business Analyst to assist in the analysis of requirements and the design of

solutions to meet the stake holder’s needs.

• Involved in gathering business principles and standardization for the Data Migration.

• Developed Various SSIS packages for Migrating the data from IHUB to TDL Database via Temporary,

Staging and ENT Databases.

• Created Stored Procedures to implement business logic in the back end using Triggers and Functions.

• Modified or Updated Data Models using Erwin.

• Involved in Developing the Data Architecture discussions.

• Created Data mapping documents for moving the data to various stages, which will be in turn used in

creating SSIS packages.

• Created various SSIS Packages for migrating the data from various Servers to temp tables and then to

staging servers using various transformations.

• Designed SSIS packages using various workflow, control flow tasks and data flow transformations for

heterogeneous data integrations & migrations.

• Rebuilding the indexes at regular intervals for better performance.

• Created tables according to the Data models on various Environments while adding the scripts to the

VSS and running the Script Index.

• Worked on automation of the SSIS Packages for nightly Jobs.

• Experience performing data analysis and developing data validation scripts to ensure the quality and

reliability of migrated data.

• Extensively used Joins and sub-queries for complex queries involving multiple tables for reporting

purposes.

• Extensively involved in Developing and Enhancing of custom Queries extracting data from Source

system and wrote required enhancements on Existing DTS Packages.

• Performed Database authentication modes, creation of users, configuring of permissions and assigning

roles to users.

• Expertise in designing databases and capacity planning.

• Involved in Testing, Bug Fixing and Documentation of the Project.

Environment: SQL Server 2008/2005, Windows XP, Sql Server 2005/2008, SSIS, VSS, Erwin

Verizon Communications, Dallas, TX Jul 08 – Aug

10

SQL SERVER Developer/DBA

Responsibilities:

• Involved in Requirement gathering and Analysis.

• Designed DTS/SSIS packages to transfer data between servers, load data into database

using SQL server Enterprise manger on Sql server 2000/2005 environment and deploy the data;

scheduled the jobs to do these tasks periodically.

• Review SQL and reports generated by an offshore reporting team for distribution to end

users.

• Developed DTS Packages to transfer data between Sql server database and files on daily

basis.

• Created SSIS Packages mapping different data sources using various transformations.

• Creating Fact Tables, Dimensions for various cubes.

• Migrating data from Staging to Production.

• Creating Development, test and Production environment servers.

• Developed stored procedures, views, functions using T-SQL.

• Deploying ETL (SSIS packages in Staging and Production environment.

• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security

Policies for various categories of users.

• Designed and created databases, tables, views, store procedures and triggers.

• Involved in migration of databases to 2008.

• Suggest index tuning and performance optimization techniques.

• Implemented replication for some of the databases of SQL 2000/2005/2008.

• Write T-SQL code while scheduling various jobs.

• Write T-SQL code using try/catch in SQL server 2005/2008 for error handling.

• Used DDL triggers in SQL server 2005/2008.

• Used DTS and SSIS to export and import data from SQL Server to Access and Excel files.

• Monitored the health of the database using SQL Profiler to tuned applications for optimal

performance.

• Rebuilding the indexes at regular intervals for better performance. Maintaining the database

consistency with DBCC at regular intervals

• Provide DBA support to Data Warehouse team in their development.

• Designed and implemented comprehensive Backup plan and disaster recovery strategies

Implemented.

• Designed and deployed reports using SSRS.

• Responsible for troubleshooting if any problem occurs.

Environment: Windows 2000/ MS-SQL Server 2000/2005/2008, DTS, SSIS, SSAS, SSRS, SQL-Profiler,

IIS, Microsoft Excel, ASP.Net, C#

Yash Technologies, Chicago, IL July 07 –

Jul 08

Reporting/analytics Developer

Responsibilities

• Design and Development of Reports using SQL Reporting Services.

• Involved in the design sessions for the business layer which included understanding the functional

requirements and suitably creating design documents describing the screen layouts and navigation paths

for the presentation screens using UML.

• Understand different metrics/Reports that will make up the Reporting Application .

• Design, Development and Implementation of Data Warehouse.

• Design and Develop ETL (Extraction Transformation and Loading) jobs for updating the staging

database from the source system.

• Design and Develop ETL (Extraction Transformation and Loading) jobs for updating the data

warehouse from the staging database.

• Developed reports using OLAP Cubes.

• Responsible for Generating 233 Reports.

• Created Links and Drill Through Reports.

• Designed Entity Relation Ship Diagrams.

• Developed OLAP Cubes.

• Designed Adhoc reports using Report Builder.

• Created Sub reports to be used in Main Reports.

• Involved in developing T-Sql Statements.

• Scheduled Reports for automatic delivery by the report sever via Email.

• Developed various Charts like Bar charts, Pie Charts by using Dundas Charts in SSRS.

• Design & Coding of Dashboard.

• Up-gradation of SQL databases from SQL Server 2000 to SQL Server 2005.

• Implementing Stored Procedures for Data Retrieval and Updating.

• Exported reports to various formats like PDF, Ms Excel, Web Archive, TIFF, CSV.

• Responsibilities include conducting meetings, gathering requirements and training users.

1 Environment: SQL Server 2005, VSS, SQL Reporting Services 2005 (SSRS), SQL Integration

Services (SSIS), SSAS, ETL, C#.Net, ASP.Net Visual Studio .Net 2005, Microsoft Visio, Windows XP

Genisys Software, Pune, India April 05 –

Jun 07

Reporting/analytics Developer

Responsibilities

• Architecture and designing of the entire project as per client’s specification.

• Designed Views/Stored Procedures in SQL to be used in the reports for better performance.

• Worked on reports that require sub-totals, sub-reports, Aggregate Functions and totals.

• Published Report output to PDF, XML files etc

• Used Report Viewer control to embed reports into custom windows forms and Asp.net Web

applications.

• Involved in the Performance tuning at the Application and Database Layers.

• Provided access to Database through MS Access Driver for storing data.

• Developed Stored Procedures using T-SQL

• Used Java Script and ASP.Net Server Validation Controls.

• Interaction with client to design screens and reports as per their requirement.

• Coding and unit testing with test data and live data.

• Involved in writing Complex SQL queries, stored procedures and Triggers.

Contact this candidate