Sql Server Data
Resume:
SRUTHI REDDY
********************@*****.***
Professional summary:
. Around 7 years of experience with design, development and implementation
of SQL Server based Application methodologies in the field of commercial
and business applications.
. Experience in installation, Upgrade and configuration of MS SQL Server
database.
. Hands on expertise in migrations from MS SQL Server 2000 to MS SQL Server
2005 to MS SQL Server 2008.
. Experience in Microsoft SQL Server Database Administration including
planning, implementing, backup, and recovery strategies.
. Strong Transact-SQL query writing skills (DDL, DML, and DCL).
. Good experience in creating objects such as Databases, Tables, Stored
Procedures, Triggers and Cursors, Constraints, Indexes, Views, Indexed
Views in Microsoft SQL Server 2000/2005/2008.
. Good understanding of Normalization/De-normalization, Database design,
Entity- model and application oriented design.
. Experience in optimizing the database by creating various Clustered, Non-
clustered Indexes.
. Efficient usage of DBCC commands to increase the performance of the
query.
. Have strong analytical, troubleshooting and problem-solving skills
dedicated to maintain the high quality standards. Good communication
skill, ability to work independently.
. Experience in design and implement processes for deploying, upgrading,
managing, archiving and extracting data for reporting using SQL Reporting
Services (SSRS).
. Experience in report writing using SQL Server Reporting Services (SSRS)
and creating various types of reports like table, matrix, and chart
report, web reporting by customizing URL Access.
. Knowledge of Dimensional Data Model concepts, Dimension and Fact tables,
Surrogate keys, Star and Snow Flake Schema, Physical and Logical Data
modeling.
. Transformed data from one server to other servers using tools like Bulk
Copy Program (BCP), Data Transformation Services (DTS) and SQL Server
Integration Services (SSIS).
. Experience in creating/deploying Data Transformation Services (DTS), MS
SQL Server Integration Services (SSIS) packages using various data
transformations such as Slowly Changing Dimension, Multicast, Merge Join,
Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and
Data Conversion Transformations.
. Experience in Designing and Building the Dimensions, Fact Tables with
star and snow flake schemas using SQL Server Analysis Services (SSAS).
. Comprehensive knowledge and exposure to different phases of Software
Development Life Cycle (SDLC). Experience in software Analysis, Design,
Development, Testing, Implementation and Production, support of
Client/Server and Web based applications.
Technical skills:
RDBMS: SQL Server 2000/2005/2008/2012, Oracle 10g/9i/8i/7.1, MS- Access
2000, MS-Access
2007, Teradata v2r4/ v2r5 and MS-Excel7.0
TOOLS: SQL Server Management Studio, Enterprise Manager, Query
Analyzer, SQL Profiler, Database Engine Tuning Advisor, SSIS, SSRS,
Business Intelligence Development Studio and Data Transformation Services
DATAWAREHOUSING: OLAP, OLTP, Star Schema Modeling, FACT and Dimension
Tables.
PROGRAMMING & XML: C, C#, VB Script, Visual Basic, SQL, Transact SQL,
PL/SQL, HTML.
SCRIPTING LANGUAGES
OPERATING SYSTEMS: Windows 9x/2000/2003, Windows NT/XP and UNIX.
EDUCATION:
. Bachelor of Technology in Computer Science Engineering - (JNTU), India
Professional experience:
GMAC National General, St Louis, Missouri
July '14- Till Date
SSIS/SQL Developer
GMAC Insurance designed an efficient and effective model for Managing and
Auto Insurance loans received from various Clients/Investors through
various branches and other sales teams. GMAC required integrating data into
a single data repository using Data Warehouse and ability to generate
Reports on top of that data. Prior developing this model, data existed in
various RDBMS like Oracle and Access and post development SQL Server
database is made as single stop data repository for various needs. Reports
Developed for business and users in MS Access, migrated to SSRS by creating
Report Models, Ad-Hoc Reports. SSIS and Data Junction Tools were used to
Load the data into the system from Flat Files.
Responsibilities:
. Worked closely with Business Team regarding scoping of requirements on
regular basis.
. Worked on Migration of reports from IBM Cognos to Sql server Reporting
services
. Synchronizing multiple reports, dynamically designing the Table headings,
groups and Field values and creating Reports with Interactive sorting.
. Good knowledge in creating Reports which can be used to modify the Data
from the Report.
. Creating Reports with Report parameters.
. Worked on Sql server integration services,Extracting data from sources
and transformed the data using different transformations like data
conversion, derived columns, look up, Conditional Split, Aggregate, Union
all, merge join and multi cast transformations..
. Created Configurations to change the package properties dynamically.
. Maintained log information in SQL table to tracking Errors and recording
package execution status.
. Creation of Package configurations, Logging, Deploying packages to target
server
. Scheduling SSIS packages using SQL Server Agent in SSMS.
. Ensures Quality and Timely delivery of assigned tasks
. Closely worked with Testing and Business Team in fixing test environment
issues.
Environment: SSIS 2008/2005, SSRS 2008/2008R2, IBM Cognos 8 BI,Server,MS
SQL Server 2008R2/2012, DTS, T-SQL, Oracle 10g, PL/SQL, TOAD, T-SQL,
Mainframes, C#. NET, VB.NET, Windows Sever 2000/2003/2008, SQL Server
Management Studio, SQL Profiler, Query Analyser, Erwin 7, TFS
Amerigroup Real solutions, Virginia Beach, VA
Nov '13 - Jan 14
SQL Developer/SSRS
Responsibilities:
. Gathering the requirements by interacting heavily with the business
users, multiple technical teams to design develop the work flows for the
new functional piece.
. Experience in SQL joins, sub queries, tracing and performance tuning for
better running of queries.
. Responsible for installation of SQL Server, database design, and create
schema objects like tables, views and indexes
. Extensively used joins and sub queries for complex queries involving
multiple tables from different databases.
. Performance tuning of stored procedures and functions to optimize the
query for better performance.
. Transformed complex business logic into database design and maintaining
it by using Sql objects, stored procedures, user defined functions,
views, T-SQL scripting and jobs.
. Successfully implemented indexes on tables for optimum performance.
. Developed complex stored procedures using T-SQL to generate Ad-hoc
reports within SQL Server Reporting services.
. Created Sub Reports, Parameterized and Drill down Reports based on the
requirements provided using SSRS.
. Created various SSRS reports such as Multi-valued reports, Parameterized,
Linked reports, Drill down reports, Tabular Matrix reports and Chart
diagrams.
. Scheduled SSRS reports for end users and managed the security of the
reports.
. Exported SSRS reports to various formats like PDF, Word and Excel and
scheduled to reports to send as an email body.
. Strong analytical and problem solving skills coupled with interpersonal
and leadership skills.
. Interaction with the clients to gather out the requirements and assist
them in immediate workarounds for the issues with the application.
. As SSRS developer, working closely with Business Analysts gathering and
clarifying data reporting requirements
Environment: MS SQL Server 2008R2/2012, SSIS 2008/2005, SSRS 2008/2008R2,
DTS, T-SQL, Oracle 10g, PL/SQL, TOAD,, Mainframes, C#. NET, VB.NET,
Windows Sever 2000/2003/2008, SQL Server Management Studio, SQL Profiler,
Query Analyzer, Erwin 7.0
CVS Caremark, Woonsocket, RI
July'12 - Oct'13
SR SQL Server/Business Intelligence Developer
Responsibilities:
. Experience in Upgrading of SQL Server 2000/2005 databases to SQL Server
2005/2008.
. Good hands-on working experience with using all kinds of SQL Server
Constraints (Primary Keys, Foreign Keys, Defaults, Checks, and Unique).
. Created databases, tables, stored procedures, views, functions, and
triggers using T- SQL.
. Created tabular, matrix, parametric and dashboards reports according to
business requirement.
. Studied the existing source tables and created new tables in production
database using TOAD
. Created Complex Stored procedures, triggers and used aggregations for
conversion of data from staging to production.
. Worked on Stored Procedures, Functions and Triggers in the development of
the application.
. Extensively worked on Database development and partly in administration.
. Complex querying skills, development of database objects such as T-SQL,
Stored Procedures, Functions with database administration skills
. Strong analytical and problem solving skills coupled with interpersonal
and leadership skills.
. Interaction with the clients to gather out the requirements and assist
them in immediate workarounds for the issues with the application.
. As SSRS developer, working closely with Business Analysts gathering and
clarifying data reporting requirements
. Creation of sub-reports, Drill down reports, Charts, Cube-Based Reports,
Report Models for Ad-Hoc
. Synchronizing multiple reports, dynamically designing the Table headings,
groups and Field values and creating Reports with Interactive sorting.
. Good knowledge in creating Reports which can be used to modify the Data
from the Report.
. Creating Reports with Report parameters.
. Extracted data from sources and transformed the data using different
transformations like data conversion, derived columns, look up,
Conditional Split, Aggregate, Union all, merge join and multi cast
transformations.
. Good knowledge in creating Event Handlers for Error Handling.
. Created Configurations to change the package properties dynamically.
. Maintained log information in SQL table to tracking Errors and recording
package execution status.
. Creation of Package configurations, Logging, Deploying packages to target
server
. Scheduling SSIS packages using SQL Server Agent in SSMS.
Environment: MS SQL Server 2008/2008R2, SSIS 2008/2005, SSAS 2008/2008R2,
SSRS 2008/2008R2, DTS, T-SQL, Oracle 10g, PL/SQL, TOAD, T-SQL, Mainframes,
C#. NET, VB.NET, Windows Sever 2000/2003/2008, SQL Server Management
Studio, SQL Profiler, Query Analyzer, Erwin 7.0
Chase Bank, Columbus, OH
Apr'11-June'12
SR SQL SSIS/SSRS developer
Responsibilities:
. Worked with Business Analysts and Users to understand the requirement.
. Worked on different levels of ETL Loads to extract Data from Source
System to Staging and then from Staging to load data into Production Data
Base Tables.
. Deploying the SSIS/DTS packages in file system and MSDB databases.
. Created tabular, matrix, parametric and dashboards and scorecards reports
according to business requirement.
. Scheduled reports, reports services documents and dashboards using
Schedule Manager.
. Created packages to migrate data from different data sources to data
warehouse.
. Created packages for database maintenance.
. Experience in applying various transforms, SCD (slowly changing
dimensions) to maintain the history of the data, aggregate, multicasting,
conditional split, Merge, Merge join, Pivot etc.
. Used SSIS control flow tasks Loop Containers, FTP, Bulk insert, Transfer
job task etc. and different data flow tasks such as Derived Column,
Fuzzy lookup, data conversion etc.
. Wrote scripts for Data Profiling, reported the risks, issues after
running those scripts on the source systems and used those results in
designing the ETL.
. As SSIS developer, worked on Designing and Implementing the ETL
processes.
. Creation of Packages using SSIS to load data from source to DWH.
. Applying Derived Column, Multicast, and Conditional Split transformations
while loading Data into DWH
. Designed packages Using Control Flow Tasks like For Loop Container, For
Each Loop Container, Sequential Container, Execute SQL Task and Data Flow
Task.
. Extracted data from sources and transformed the data using different
transformations like data conversion, derived columns, look up,
Conditional Split, Aggregate, Union all, merge join and multi cast
transformations.
. Good knowledge in creating Event Handlers for Error Handling.
. Created Configurations to change the package properties dynamically
. As SQL developer, worked in the application development side like
enhancements and letter (XML) changes as per the customer requirements.
. As a SQL database Developer, worked on Designing Tables, Designing Stored
Procedures, Designing Functions, Designing Triggers, Designing complex
scripts using T SQL, Designing complex scripts using BCP command.
. Experience working on 24X7 environment
. Involved in the overall systems analysis, design, development and
implementation
. Developed complex SQL Server database to responsively handle data
retrieval (T-SQL, DTS, Triggers, Stored Procedures) and SSIS Packages
. Involved in development of entire web applications and generate reports
in the desired format of HTML and PDF using SQL Reporting Services.
. Extensively interacted with clients and business teams to provide
technical support and measure the scalability, consistency and accuracy
of the applications.
Environment: MS SQL Server 2008 R2/2008, SSIS 2008, SSRS 2008, DTS, T-SQL,
Visual Studio 2005, Microsoft Visio, Windows 2007,SQL Server Business
Intelligence Development Studio (BIDS) MS Access 2007
TD Bank, Portland, ME
Mar'10-Mar' 11
Sr.SQL Server/Business Intelligence Developer
Description: TD bank is one of the leading banks in the United States for
commercial and investment banking, home and auto insurance in the United
States. Data warehouse was built to retrieve loan level information of a
customer who is a part of countywide home loan services. This includes the
Alternative Collateral Deals, which has data to determine whether a
customer is eligible for a deal by TD bank.
Responsibilities:
. Continuously interacted with end user to gather business requirements to
develop Business Requirement Document (BRDs) and ETL specifications.
. Upgraded from SQL Server 2008 to SQL Server 2008R2.
. Involved in database design to define E-R (Entity- Relationship) models
using Erwin 7.0 and implemented Ralph-Kimball methodology of dimensional
modelling.
. Used T-SQL to create databases and database objects like tables, views,
stored procedures, indexes and triggers.
. Worked with complex SQL statements using joins, sub queries and
correlated sub queries.
. Using Dynamic SQL statements constructed and executed dynamically during
run time, based on supplied users.
. Performance tuning in Database level, T-SQL level, Operating System level
& Hardware level.
. Periodic checking of all databases with DBCC commands for maintaining
data consistency and integrity and responsible for keeping system and
databases up-to-date by making necessary changes.
. Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to
optimize queries and enhance the performance of databases.
. Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived
Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task,
Data Flow Task, and Execute Package Task etc. to generate underlying data
for the reports and to export cleaned data from Excel Spreadsheets, Text
file, MS Access and CSV files to data ware house.
. Extracted data from XML to SQL server.
. 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.
. Responsible for Deploying, Scheduling, Alerting and Maintaining SSIS
packages.
. Created OLAP Cubes and deployed those using SQL Server Analysis Services
(SSAS).
. Created reports on the deployed cubes using SQL Server Reporting Services
(SSRS).
. Designed and deployed reports with Drill Down, Drill Through and Drop
down menu option and Parameterized and Linked reports using SSRS.
. Deploying and scheduling Reports using SSRS to generate all daily,
weekly, monthly and quarterly Reports including current status.
. Created report models, standard report Subscriptions and Data Driven
report Subscriptions using SSRS.
Environment: MS SQL Server 2008/2008R2, SSIS 2008/2005, SSAS 2008/2008R2,
SSRS 2008/2008R2, DTS, T-SQL, OLAP,, Oracle 10g, PL/SQL, TOAD, T-SQL,
Mainframes, C#. NET, VB.NET, Windows Sever 2000/2003/2008, SQL Server
Management Studio, SQL Profiler, Query Analyzer, Erwin 7.0
Residential Credit Solutions, Fort Worth, TX
Aug'09-Feb'10
SQL Server DBA/Developer
Description: RCS (Residential Credit Solutions) architected an efficient
and effective model for Managing and Servicing Mortgage loans and
Foreclosures received from various Clients/Investors through various
branches and other sales teams. RCS required integrating data into a single
data repository using Data Warehouse and Reporting on that. Prior
developing this model, data existed in various RDBMS like Oracle and Access
and post development SQL Server database is made as single stop data
repository for various needs. Reports Developed for business and users in
MS Access, migrated to SSRS by creating Report Models, Ad-Hoc and Canned
Reports. SSIS and Data Junction Tools were used to Load the data into the
system from Flat Files received through Fiserv. OLAP Cubes were created to
provide better and enhanced reporting for Business and Users.
Responsibilities:
. Worked Extensively on SQL Server 2005 and 2008/2008R2
. Involved in performing Extraction, Transformation and Loading using SSIS
. Developed all the required Stored Procedures, user defined Functions,
Triggers, Views using T-SQL as per business logic.
. Used SQL Server 2005/2008 Reporting Services (SSRS) for generating
reports, MDX queries utilized.
. Worked extensively with client gathering requirements to generate
customized SQL Reports (Subscriptions Created)
. Used "SQL Profiler TSQL Duration" template for tracking execution time of
TSQL Statements.
. Development and Implementation of Backup and Recovery strategies
. Database Backup Compression and Encryption using SQL 2008
. Implemented different types of Replication Models (Snapshot, Merge and
Transactional) and Log Shipping.
. Optimized the performance of queries.
. Created Dashboard for the business using SSAS OLAP Cube and integrating
it with Performance Point Server (PPS)
. Used SharePoint Enterprise Portal for hosting Scorecards and SSRS Reports
. Promoted database objects from DEV/TEST to Production. Coordinated and
Communicated production schedules within Development and Testing team.
. Worked extensively on all the Environments: Development, Testing and
Production
. Worked with front-end application developers to understand their
requirements and create Procedures and Reports.
. Automated Database Maintenance tasks by creating Jobs, Alerts and
Operators through SQL Server Agent.
Environment: SQL Server 2005/2008/2008R2 Enterprise, T-SQL, MS-Excel, MS-
Access, XML, SSIS, SSRS, SSAS, MDX, OLAP, PPS, SharePoint, Erwin, Microsoft
Visual Studio 2005/2008, Windows 2000/2003/NT/XP.
Cybage Technologies, Hyderabad, India
Aug'07-Jun'09
SQL Server Developer
Description: Cybage Technologies is a software products and services
company that focuses primarily on Business Process Management & Banking
solutions. It provides custom software development to the clients.
Responsibilities:
. Installation, Configuration and Maintenance of MS SQL Server 2000.
. Gathered functional requirements and wrote the technical specifications.
. Designed logical / physical data models and defined primary key, foreign
key using Erwin tool.
. Wrote T-SQL statements using DML and DDL for retrieval of the data.
. Responsible for Query optimization and Performance tuning.
. Used DBCC commands to check physical and logical consistency of the
databases and to rebuild indexes.
. Managed replication issues.
. Secured the SQL Server by creating user logins with appropriate roles,
dropping and locking the logins, creation of groups, granting the
privileges to users and Groups.
. Managing and scheduling daily jobs relating to data transfers, backup and
recovery, transaction log dumps.
. Performed Project planning and scheduling database module in conjunction
with project managers.
. Tested queries to optimize the procedures and triggers to be used in
production.
. Managed SQL user logins, database user accounts, server roles, database
roles and its permissions.
. Worked on DTS Packages, DTS Import/Export for transferring data between
SQL Server.
. Analysed and designed disaster recovery/replication strategies with
business managers to meet the business requirements.
. Developed processes, automation of maintenance jobs, tuning SQL Server,
locks and indexes configurations.
. Created DTS package to export and import data from SQL Server to Access,
text and EXCEL files.
. Used SQL Profiler for getting the trace activity for the Various Stored
procedures and used Index Tuning wizard for performance betterment.
. Checked Performance Tuning, Indexing, Query Optimization.
. Used database consistency checks using DBCC Utilities.
. Created DTS Packages to import data from Excel spread sheets.
. Used DTS to created jobs to populate some of the tables with data from
other servers.
. Good exposure in running jobs in Enterprise Manager using job-scheduling
tool.
Environment: MS SQL Server2000/2005, T-SQL, Excel, DTS, SSRS, SSIS, Data
Analyser, ASP.NET, VB.Net,C#.NET, ADO.NET, VSS 6.0, Windows 2003
[pic]
Contact this candidate