More Related Content
What's hot (19)
Viewers also liked (18)
Similar to Sravya(1) (20)
Sravya(1)
- 1. Sravya 996-666-8399 Sravyarao11@gmail.com Summary: ? Around 3.4 years of experience in IT as an SQL Server Developer in Analysis, Design, Development and Customization of Business Application using SQL Server 2000/2005 and 2008. ? Experience with Software development life cycle (SDLC) process C performing detailed analysis, collecting requirements, documenting requirements, coding and unit testing, integration and system integrating. ? Hands on experience with SQL Server and T-SQL in constructing Stored Procedures, Index, Functions, DTS packages, triggers, cursors, tables, views, relational database models, and data integrity. ? Experienced in creating Queries using global variables, expressions and functions for the reports. ? Hands on Experience in Extracting and transforming Data by using DTS and SSIS. ? Extensive Experience in Migration of databases and database applications from MS SQL Server 2000 to MS SQL Server 2005. ? Experience in creating ETL functionality using SSIS. ? Experience in Designing, developing and deploying SQL Server Integration Services (SSIS) packages. ? Expert in handling sub reports in SSRS. ? Expert in writing parameterized queries and generating formatted Reports using Microsoft Reporting Services (SSRS). ? Experience working in Development, Production and QA environments. ? Very strong in problem solving & trouble shooting, proactively monitoring & tuning production environment. ? Very strong knowledge in the Data import and Data export methodologies. ? Strong troubleshooting and problem solving skills and strong ability to prioritize multiple tasks. ? Have strong analytical, administration and problem-solving skills dedicated to maintain the high quality standards. Good communication skill, ability to work independently. Experience Summary: ? Working as a Software Engineer with Choice Software Limited, Hyderabad from OCT 2008 to Till Date 1
- 2. Databases MS SQL Server 2008/2005/2000, MS Access ETL Tools SSIS 2008/2005, DTS, BCP Reporting Tools SQLServer Reporting Services 2008/2005/2000 OLAP Tools SQL Server Analysis Services 2000, SQL Server Analysis Services 2005 Performance Tuning Tools SQL Profiler, DTA (Data Tuning Advisor) Operating Systems Windows 9x/2000/NT/XP Languages T-SQL, C/C++ Ms Tools Visual Studio 2002/2003/2005, VSS Education: BE/BTECH in (ECE) from JNTU University, Hyderabad in 2008 Professional Experience: Choice Software Limited June 2011 C Till Date Client: Unicorn Financial, FL Senior Software Engineer Unicorn Financial provides financing for elective medical procedures. It needed to reduce the time and effort it took to close its books. Old processes were labor intensive, involving the manipulation and updating of large spreadsheets by hand. The company's new solution uses a Microsoft SQL Server database to store information. Data is dynamically run through Microsoft Office Excel 2003 to calculate values for income recognition. This led to more than 95 percent reduction in manual processing. Responsibilities: ? Analysis of the specifications provided by the client ? Experienced in SQL joins, Sub queries, tracing and performance tuning for better running of queries ? Back end Experience in MS SQL Server development, writing T-SQL stored procedures, views, triggers, cursors, UDFs ? Designed and Implemented SQL Server Integration Services 2005 packages to Ware House the data from distributed servers ? Experience in SSIS script task, look up transformations and data flow tasks using T- SQL ? Experienced in loading data from the legacy systems into MS SQL server 2008 using SSIS packages ? Created Stored Procedures and user defined functions for reports ? Designed, Managed and Published various reports using SQL Server Reporting Services 2008 ? Created different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports ? Created Cascading ( Collapsed ), Printable, interacted reports (drill-down and sorting functionality) ? Created and designed reports based on query parameters and Report parameters ? Experienced in nested Grouping, sorting columns and writing expressions according to the business requirements
- 3. ? Experience with sub reports and pass through parameters from main report to the sub reports ? Experience in setting report parameter properties. Determine whether parameters are single or multi valued, visible at runtime and set the default values in the run time ? Deployed reports in the solution explorer and opened through browser ? Unit Testing and Deployment Environment: .Net Framework2.0,Business Intelligence Development Studio, Microsoft Office Excel, XML, IIS 6.0, MS SQL Server 2008, SSIS 2008, SSRS 2008, Windows 2003 Choice Software Limited Jan 2010C May 2011 Client: Covidien,MA Software Engineer Covidien, formerly Tyco Healthcare, is one of the largest healthcare devices and supplies companies worldwide, and its corporate offices are located in MA. This project involved the development and implementation of customer billing data mart according to defined business rules for strategic business analysis. Responsibilities: ? Experienced in Database Migration from SQL Server 2000 to 2005 using Bridging Scripts, Column Mapping Tool and Source Control Explorer in Visual Source Safe (VSS) and finally passing all triggers, views under Unit Testing for validating data insert, update and delete. ? Developed Business and Data Access layers to write Validation objects and Business Logic. ? Used ADO.NET for SQL Server database interactions using Data Adapters, Data Reader and Dataset ? Developed classes using VB.Net ? Used Grid View, Data List and Data Repeaters to retrieve, display and manipulate data ? Created and Executed the Stored Procedures and Complex Queries for Reports ? Created and maintained databases, tables, views, users, logins, indexes, check constraints, and business rules using T-SQL ? Experience in Error Handling using TRY and CATCH blocks and performance tuning using counters in SSIS ? Managed the Metadata associated with the ETL processes used to populate the Data Warehouse using SSIS packages ? Published migrated data using SSIS(SQL Server Integration Services), DTS Wizard (Data Transformation Services) Tool through data flow tasks, look up transformations and script tasks ? Developed and tested all the backend programs, Error Handling Strategies and update processes ? Reports writing based on tickets submitted from front end people using SQL Server Reporting Services (SSRS) ? Created report parameter properties determine whether parameters are single or multi valued, visible at runtime and set the default values in the run time ? Experienced user defined functions to split the string for the multi valued
- 4. parameters and pass to the main query ? Created Cascading Parameters to a Report and adding a Report Parameter to Pass to a User-Defined Function Environment: .NET Framework 2.0,ADO.NET, MS SQL Server 2005, MS SQL server 2005, T-SQL, Excel, SSIS, SSRS,DTS, Data Analyzer. Choice Software Limited Oct 2008C Dec 2009 Client: Telstra, Melbourne, AUS Software Engineer Telstra Corporation Ltd., one of the biggest telecommunication companies in the Australia, provides not only wireless and wire communication but also broadband internet access service as well. The project that I worked is a National Sale Tracking (NST) system, which uses Microsoft SQL Server 2000 and Microsoft 2000 advanced data center Servers, including 4 sets of cluster servers. Responsibilities ? Analysis of the specifications provided by the client ? Designing the ware house system to maintain periodic data ? Created and maintained databases, tables, views, users, logins, indexes, check constraints, and business rules using T-SQL ? Back end Experience in MS SQL Server development, writing T-SQL stored procedures, views, triggers, cursors, UDFs ? Experience in SQL joins, sub queries, tracing and performance tuning for better running of queries ? Loaded the data from Heterogeneous data sources to Data ware house by using SSIS. ? Created collapsed and printable reports based on tabular, Matrix, List items ? Created parameters, Expressions and calculate the expressions according to the business requirements ? Report writing based on tickets submitted from front end people using SQL Server Reporting Services (SSRS) ? Unit Testing and Deployment Cubes and Reports Environment: .Net Framework2.0, MS SQL Server 2005, SSIS, SSRS, VS 2005, VSS, IIS 6.0, Windows xp, Visual Studio 2005