Sql Server Data

Priya Yeruva

Mobile: 803-***-****

Mail: *****.******@*****.***

EXPERIENCE SUMMARY:

* ***** ** ********** ** Database Design, Development, System Analysis & Supporting MS SQL

Server’s 2005,2000/7.0/, in production/ development/UAT Environments.

Worked on Integrated Tax System.

Expert in designing relational database model and implementation as per business needs.

Knowledge and hands on development experience on the ETL process in Data Warehouse

environments with skills on major ETL tools.

Extensively worked in populating a Data Warehouse with Microsoft SQL Server 2000 Data

Transformation Services.

Designed DTS and SSIS Packages to periodically update the Data warehouse.

Converted DTS to SSIS.

Experience working with extremely huge databases in volumes of Terabytes.

Experience in Database Backup, Recovery and Disaster Recovery procedures.

Experience working with Production 24/7 and Development Environments and worked as Primary

On call.

Experience in Application domain knowledge in Banking, Financial, Manufacturing, Retail and

Supply Chain industries.

In-depth knowledge of Transact-SQL.

Expert in creating indexed Views, complex Stored Procedures, appropriate functions, and effective

Triggers to facilitate efficient data manipulation and data consistency.

Excellent Knowledge in SQL Server Integration Service (SSIS) and SQL Server Reporting Service

(SSRS) and SQL Server Analysis Service (SSAS).

Extensively used tools like SQL Profiler, Index Tuning Wizard, Windows Performance Monitor for

monitoring and tuning MS SQL Server performance

Expertise in Database driven web based application developer: using SQL Server 2000, MS Access,

Visual SourceSafe, Java/VB Script, HTML and IIS

Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule DTS Packages.

Expertise in generating reports using Reporting Services, Crystal Reports, Power Builder, XML and

Excel Spreadsheet.

Hands-on working experience with analyzing query plans, using extended Stored Procedures,

managing indexes and locks, Blocking and troubleshooting deadlocks.

Good Understanding of Windows DNS, DHCP, Active Directory, Windows Administration and

Group Policies.

Experienced in Manual Testing writing and executing.

Worked with the clients in UAT testing.

Flexible, enthusiastic and project oriented team player with excellent written, verbal communication

and leadership skills to develop creative solutions for challenging client needs.

TECHNICAL SKILLS:

RDBMS: MS SQL Server 7.0/2000/2005, Oracle 8i/9i, MS Access, Sybase.

Database Tools: Management Studio, SQL Server Enterprise Manager, Query Analyzer,

SQL Server Integration Service, Reporting Service and Analysis Service

(SSIS, SSRS and SSAS), SQL Profiler, SQL Transmitter, DBArtisan,

Upgrade Wizard, Visual Studio, Performance Monitor, COGNOS

6.5/7.0

ETL Tools: Data Transformation Services (DTS), SQL Server Integration Services

(SSIS)

Reporting Tools: Crystal Reports 9.0/10, Microsoft Reporting Services 2000/2005

SQL, TSQL, VB.NET, XML, C, C++, Java, VB 6.0

Programming Languages:

Scripts: JavaScript, VBScript, HTML, DHTML and XML.

Web Tools: MS-Front Page, Macromedia Suite, IIS, and Outlook Express.

Microsoft Office, Visio, and Visual SourceSafe.

Applications:

Windows 2003/2000/NT/XP, Advanced Server and UNIX.

Operating Systems:

EDUCATION & CERTIFICATIONS:

Bachelor Of Engineering

Microsoft Certified Technology Specialist (MCTS): Implementing and Maintaining Microsoft SQL

Server 2005 (70-431), Oracle 9i SQL, PL/SQL certified

PROFESSIONAL EXPERIENCE:

Oct 2007- May 2009

Department Of Revenue, Columbia, SC

Senior Developer (SSIS, SSAS, SSRS, Testing)

Working for SCITS (South Carolina Integrated Tax system). SCITS is a web-based application suite used

by SCDOR to set up and administer business and individual taxpayer records, generate tax billing,

process tax returns and payments, balance payments for deposit, and other tasks involved in the

collection and reconciliation of state tax revenue. SCITS has functionality to meet the objectives like

Provide integrated view of taxpayer such that DOR (department Of Revenue) users can have a summary

view of the taxpayer, Provide web self-service features such that external users can view their accounts

online and manage their relationship with DOR, Provide a real-time, integrated system that post

transactions real-time and provides an up to the minute view of the taxpayer’s account and financial

transactions as well as non-structured data such as images or e-mails, Provide a relational database to

store taxpayer data where operational taxpayer data is not duplicated.

Converting Mainframe database into SQL Server database, applying business functionality and rules.

Making the database available to SCITS (web-based application).

Responsibilities:

Working with Business Analyst and User Analyst to get the business rules and data mappings.

Leading conversion team and working with the database administrators for the necessary system

information. Training the team members on SSIS.

Understanding SALES, EWH, MISC, CORP, ABL, LOP, Property, Exemptions data, loading the

data to staging tables, applying the given business rules and loading to multiple destination

tables.

Working with DBA’s and making sure the data model is correct.

Maintaining the conversion, staging and testing database, database backup, restore and disaster

recovery.

Created complex SSIS packages to extract the data from flat files and load to sql

tables. Used Complex joins while loading the data.

Did data cleansing and data conversion to the desired data types.

Applying the business rules while transforming the data.

Used Unpivot data flow tasks. Used fuzzy lookups/lookups for cleaning data flow

transformations and to load the reference table values and grouping the data.

Used script tasks and conditional splits when loading the data and handled dirty data.

Used union all to get the data from multiple data sources and multicast to load the

data into multiple destinations.

Used multiple data flows in one package, Used cursors and Checkpoint

configurations.

Created User defined functions and triggers to cleanse the data and get the desired values and

implement business rules.

Used variables and row count task to get the input, insert and updated row counts for audit

purpose.

Worked on changing the dimensions, used Expression syntax and used Loops in the workflows.

Created event handlers like on post execute, on error etc. for error handling.

Created a master package to kick off the child packages.

Created xml configuration files so that packages can be executed on any server/database by

changing the configuration path in the XML files.

Scheduled the packages.

Captured and troubleshooted the long running SQL queries using SQL Server profiler &

performance monitor.

Analyzed and worked towards resolving Deadlock Issues.

Responsible for maintaining Development, Iteration testing, UAT testing and Training databases,

database back up and recovery, clustering, indexing.

Analyzed the data stored in the database and made recommendations relating performance and

efficiency of the data storage.

Created views, UDF’s and stored procedures and optimized them as required by application

developers for easier implementation of the Application.

Performed daily monitoring using Database Consistency Checks using DBCC Utilities to ensure

consistency and integrity of the databases.

Responsible for unit testing, bug fixing and helping the testing team to execute the test cases.

Communicating with BA team and making sure the reference table data is up to date.

Actively participated in the whole project cycle

Wrote insert, update and delete triggers.

Did Data Load in multiple environments like Conversion, system testing, UAT testing, Iteration

testing, training etc.

Analyzed and worked towards resolving Blocking and Deadlock Issues.

Helped testing team in identifying the correct data for the test execution.

Effectively Used SSRS for creating reports for the Application Teams on their specific needs

and at an executive level with drill-down capabilities.

Created OLAP cubes and used MDX queries. Defining effective aggregations, used

partitions, scaling, tuning memory/ processor usage and used query engine cache

effectively to optimize the query performance.

Responsible for Performance Tuning / Optimization.

Worked in Manual Testing, wrote test scenarios, performed execution and tested the business

rules.

Documented all the processes for future reference.

Environment: SQL Server 2005, SSIS, Visual Studio, SSRS, SSAS, T-SQL, VB script, Star Team, Share

point, Excel, Access, Windows 2000/XP.

May 2007-Oct 2007

CarMax, Richmond, VA

SQL Developer (SSRS/SSIS/DTS/SSAS)

Working in CarMax in the CAF (CarMax Auto Finance) team. This project is eTRACS (electronic Task

Routing And Communication System). This is capable of producing various reports and enabling a wide

variety of filtering and sorting functionality to the users when rendering these reports. These reports will

be rendered utilizing SQL Server 2005 & Reporting Services 2005.Using this platform for reporting it

allows scheduled report execution and caching, subscriptions for automatic emailing and the ability to

render the report in various formats, such as HTML, PDF, TIF and Excel.

Responsibilities:

Working with SQL Server 2000/2005, SSIS and Reporting Services 2000.

Created stored procedures to get the desired information to generate reports.

Wrote triggers to insert and update the captured data.

Automated the production of letters that are currently being manually created and audited in

another.

Responsible for Performance Tuning / Optimization.

Wrote complex T-SQL queries using various joins and sub queries.

Generated complex reports like drill down reports, drill through reports, matrix reports.

Used complex expressions to calculate, group, filter, parameterize, and format the contents of a

report.

Increased the productivity and accuracy of the reports and decreased the response time and lost

requests.

Rendered the reports in various formats.

Scheduled the reports for automatic emailing.

Stored the history of all the generated Reports and Letters sent are renderable.

Used SSIS for batch data transactions, exports and imports.

Created SSIS and DTS Packages to implement the Warehousing for the Sales Database.

Migrating DTS packages to SSIS by running Package Migration Wizard

Extracting data from multiple sources like oracle, MS Access, Excel.

Created SSIS Packages for data import and export from SQL Server Databases to Various other

data sources like Oracle and Sybase.

Generated SSIS packages so that the work requests are populated and updated by querying data

within eTRACS, CAMS and EDW databases.

Working with SSIS for scheduled report execution and caching.

Configured SQL mail agent for sending automatic emails when a SSIS/DTS process is failed or

succeed.

Created OLAP cubes for efficiency in the data retrieval and for efficient reporting.

Worked to establish connectivity between VB Applications and MS SQL Server by Using ODBC

Maintained version control of database releases and Object Changes.

Worked with monitoring and resolving locking and blocking issues.

Documentation for best practices, policies, procedures and standards.

Responsible for Unit / System Testing

Documented all the processes for future reference.

Environment: SQL Server 2005/2000, oracle, SSIS, SSAS, T-SQL, DTS, MS Reporting Services 2000/2005,

VSS, UNIX, Excel, Access, Windows 2000/XP

Nov 2006-May 2007

CarMax, Richmond, VA

SQL Developer

CarMax is one of the leading car dealers. This project is Slide Timings. The major goal of the project is to

capture Slide Timings and transaction metrics for monitoring and evaluation purposes for 80 stores.

Automating and capturing and centralizing of transactional data to the corporate repository. The system

utilizes Sybase, SQL Server 2000 and Power Builder

Responsibilities:

Actively participated in gathering the required information for the project.

Involved in different stages of Project Life Cycle.

Modified current database by adding tables, indexes and constraints.

Worked with SQL Transmitter and DBArtisan.

Created stored procedures for implementing the business logic.

Responsible for Performance Tuning / Optimization

Worked with complex T-SQL queries

Optimized the performance of queries with modification in TSQL queries, removed unnecessary

columns, eliminated redundant and inconsistent data, normalized tables, established joins and

created indexes wherever necessary.

Automated the execution of pulling and moving the transactional data to the Corporate

Repository.

Worked with SQL Server in moving the data to Corporate Repository by DTS packages.

Captured the data for every second, on hourly basis and for the entire day

Captured the parameter settings that are active when the transactional timings are gathered. This

will allow for researching why timings may vary through time

Wrote Triggers to insert, update and captured the data

Defined constraints, rules and defaults

Scheduled jobs by DTS, and created alerts for Error reporting.

Monitoring the database applications

Participated in different Testing and Debugging for the system.

Designed and implemented several Complex Reports using cross tabs and administration

modules.

Documented all processes involved in maintaining the database for future reference

Environment: Sybase, DBArtisan, SQL server 2000, T-SQL, Power Builder, UNIX, Excel, Access,

Windows 2000/XP

June 2005 – Sep 2006

AMI Insurance, Auckland, New Zealand

SQL Developer (DTS/SSAS/crystal report)

Project: Commercial Auto Insurance Online System (CAIOS)

AMI Insurance is a New Zealand owned company stretching back to 1926. It is the leading commercial

auto insurance provider, and is growing nationwide. CAIOS provides online facility to clients for their

auto insurance policy. The online system utilizes the recently developed CAIS system and allows

customer to apply for auto insurance, request modification to their policy, view their policy information,

and online support.

Responsibilities:

Actively participated in gathering User Requirement and Online System Specification.

Actively involved in different stages of Project Life Cycle.

Modified current database by adding tables and relationships to support online system.

Defined constraints, rules and defaults.

Created views as required by front-end developer for easier implementation on web pages, and

triggers on those views to provide efficient data manipulation.

Created complex stored procedures and functions to support efficient data storage and

manipulation.

Optimized the performance of queries with modification in index system for online system.

Wrote triggers (After and Instead Of) and stored procedures to capture updated and deleted data

from OLTP systems.

Monitored the growth of the database objects for capacity planning.

Data migration (import & export – BCP) from Text to SQL Server.

Scheduled the jobs using DTS

Created complex reports

Regularly monitored the system for bottlenecks (CPU, RAM, Disk IO and Networking).

Involved in Complete Backing up of Database and Restored the Database from Disaster

Recovery.

Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning

wizard.

Created OLAP Databases and generated reports using Crystal Reports Engine.

Created OLAP cubes for faster data retrieval.

Participated in different testing and debugging for the system.

Documented all processes involved in maintaining the database for future reference.

Environment: SQL Server 2000 Enterprise Edition, T-SQL, ASP. Net, ODBC, T-SQL, Excel, Access, Crystal

Reports, DTS Packages, SSAS, VB Script, Windows 2000/XP.

Dec 2003 – Mar 2005

Lumin Software Technologies, Hyderabad, India

SQL Developer

EPMS (Enterprise Project Management System)

Lumin designs and delivers the systems, services and software that drives next-generation

communications. Worked for the Project Management Office (PMO) center, developed and helped Lumin

implement EPMS, an enterprise-wide Project Management System. This implemented a disciplined way

to manage the execution of projects and ensured a reliable data collection mechanism for Senior

Management decision support.

Responsibilities:

Continuously interacted with users to gather the business requirements

Performed regular Administration activities from Managing system resources, users and

database to the fine-tuning level and implemented the project successfully

Designed and developed tables, stored procedures and cursors using T-SQL

Wrote complex T-SQL queries for reporting and data extraction

Identified, tested and resolved database performance issues (monitoring and tuning) to ensure

database optimization.

Used the MS SQL Server DTS Wizard to schedule migrations and transformations.

Wrote custom T-SQL stored procedures and triggers to improve performance, preserve

referential integrity, and provide additional application functionality.

Monitoring the growth of database objects for capacity planning.

Created replication servers and transmitted the data successfully.

Assisted other developers in fine-tuning their stored procedures and triggers.

Involved in testing, bug fixing and documentation for the project.

Environment: MS SQL Server 2000, T-SQL, VBScript, ADO, Windows 2000, IIS 4.0/5.0, and FrontPage

Contact this candidate