Sr SQL Server DBA/Developer

Anusha kodali

Phone: 224-***-****

******.*@*****.***

Professional Summary:

Over 7+years of IT Experience in System Design, Development and Support of Microsoft SQL Server 2008 / 2005 / 2000 in Development, Test and Production Environments on various business domains

• Hands on experience in Installing, Configuring, Managing, Monitoring, Troubleshooting, Upgrading and Migrating SQL Server 2008/2005/2000.

• Expertise on Business Intelligence Tools (Analysis Services, Integration Services and Reporting Services).

• Good working experience in Management Studio, Enterprise Manager, T-SQL, and SQL Jobs and Query Analyzer.

• Experience in Data Modeling, Multi-Dimensional Modeling and involved in creation of Star Schema and Snowflake dimensional schema using Erwin Tool.

• Experienced in Data Warehouse Design and architecture, Data Analysis, Data Mining, Relational data modeling, Dimensional modeling, business modeling.

• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Log Shipping, DTS, Bulk Insert and BCP.

• Experienced in Data Warehouse Design, Data Analysis, Data Mining, Relational data modeling, Dimensional modeling, business modeling and UML methodologies.

• Extensive Experience in creating and maintaining security mechanisms for reports, creating repository domains using Business objects Supervisor.

• Expertise in working with Business Intelligence tools for developing various reports using Cognos 8.x Suite

• Extensive experience with building Universe, defining objects, classes, resolving loops.

• Extensive experience in developing Reporting solutions using OLAP techniques like Drill Down, Slice & Dice facilities, Master/Detail reports using Business objects Reporter 6.1.

• Involved in Data Migration from SQL Server 2005 to SQL Server 2008.

• Worked on ProClarity to create, deploy and analyze Reports based on MSAS Cubes.

• Experience in creating connectivity between already generated Cubes.

• Good experience in Designing, Building the Dimensions, Cubes with Star Schema and Snow Flake Schemas using SQL Server Analysis Services (SSAS) in SQL Server 2008.

• Experience in modifying MDX Cubes and Dimensions in SSAS.

• Good knowledge and usage of ANSI SQL Pre compilers.

• Working and designing reports on XI R2

• Creating Business view manager and Universe on R2

• Developed Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc Reports and distributed Reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).

• Used ProClarity for accessing and analyzing cubes and dimensions, and also worked on integration of SharePoint with SSRS.

• Building and writing MDX Queries, Calculated Members, and KPI’s using Microsoft sql Server 2005/2008 Analysis Services Business Intelligence (SSAS, SSRS)

• Excellent Report creation skills using Microsoft Reporting Services (SSRS) 2008.

• Good understanding in database and data warehousing concepts (OLTP & OLAP). Experience with logical and physical data modeling and database design using Erwin.

• Designed and developed database schemas and database objects based on design specifications, software requirements.

• Creating Dashboard pages that use Excel Access web parts and Reports.

• Experience in managing Alerts, Operators and Jobs through SQL Server Agent.

• Developed, Monitored and Deployed SSIS Packages from Development environment to Production environment.

• Experience in using Try Catch Block introduced in SQL Server 2005.

• Extensively used tools like SQL Profiler, Database Engine Tuning Advisor and Windows Performance Monitor for monitoring and tuning MS SQL Server Performance.

• Extensive experience in creating Tables, Views, Indexes, writing Stored Procedures, Triggers using T-SQL (DML and DDL) as well as analyzing and debugging existing complex stored procedures.

• Experience in writing complex T-SQL queries using Inner Joins, Outer Joins and Cross Joins.

• Expertise in using Microsoft .Net technologies and Microsoft SharePoint/Windows Administration and development with strong development background in Design, Development, Deployment and Administration of various applications including Web and Client/Server Application development using Microsoft .NET Framework, VB.NET, ASP.NET, ADO.Net, C#.NET .

• Experience in installation, un-attended deployments, configuration and administration of Windows NT, 2000 and 2003 servers in very large environments.

• Extensive experience to analyze and document business requirements and system functional specifications including use cases.

• Strong Technical background with excellent problem solving and communication skills. Good team player with reputation of integrity and an ability to work on multiple technologies.

Education:

• Bachelor of Sciences in Andhra University, India

Technical Skills:

Languages C, C++, T-SQL.

RDBMS MS SQL Server 2008, 2005, 2000, Oracle 9i/10g, SQL Server Management Studio(SSMS), SQL Server Analysis Services 2005,MS SQL Server Integration Services 2005, MS Access.

Front End MS Visual Basics 6.0.

Reporting Tools Crystal Reports, SQL Server Reporting services 2005

Web Server Technologies IIS 5.1/6.0.

Operating System Windows 2000 Advanced Server, Windows 2000 data center, Windows NT, Windows 95/98/2000 XP.

Professional Experience:

Client: PepsiCo, TX June’ 10 – Till now

SQL Server Data warehouse Consultant

Role and Responsibilities:

• Worked with Technical Architects and Database analysts for the Design of Summary tables required for efficient Report Design,

• Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development

• Extensively used T-SQL in constructing User Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.

• Created complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.

• Identify, develop and maintain Key Crystal Reports and Business Objects.

• Created Family of stars using dimensional modeling concepts of Degenerated dimension, Fact less fact table, Aggregate fact tables in multi dimensional model.

• Conducted Data Model design review meetings with Business Stake holders, Solutions Integrators, Development Leads, Architecture Team, Support Team and Database Administrators to get approval.

• Migrated & upgraded Business Objects from 6.5 and Crystal Reports 10 to XI r2.

• Designed Data Integrator jobs with Error Handling and email notifications.

• Used scripts and variables, email notifications for ETL process using Data Integrator.

• Designed Data flows, Workflows and jobs to load data from source to target in BO Data Integrator.

• Schedule Data Integrator jobs using Data Integrator Administrator.

• Worked on ProClarity for creating, analyzing and deploying Reports.

• Worked with development teams in the design of physical databases and in modification.

• Designed Cubes with Star Schema using SQL Server Analysis Services 2008 (SSAS).

• Development of mappings as per the technical specifications approved by the client implemented the Slowly Changing Dimension Type 2 methodology to keep track of historical data.

• Understanding OLAP process for changing and maintaining the Warehouse, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.

• Created Packages in SSIS with error handling.

• Developed ETL process using SSIS with Various Control Flow, Data Flow task and Store Procedures for Work Order Validation process.

• Created Family of stars using dimensional modeling concepts of Degenerated dimension, Fact less fact table, Aggregate fact tables in multi dimensional model.

• Designed logical / physical data models and defined primary key, foreign key using Erwin tool.

• Involved in creating Dimensions, KPI, Measures and calculations in SSAS 2008.

• Worked with different methods of Logging in SSIS.

• Configured SSRS 2008 with MOSS 2007 for directly deploying the report in SharePoint 2007.

• Generation of reports from the cubes by connecting to Analysis server from SSRS.

• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2005 to MS SQL 2008 as well as Created interface stored procedures used in SSIS to load/transform data to the database.

• Involved in migrating data from DB2, MS-Access, MS-EXCEL and other external data sources.

• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.

• Created complex SSIS packages using proper Control and Data flow elements.

• Have deployed packages on different servers by configuring it.

• Used Import wizard to import existing User accounts, Groups, Categories, Universes, Reports (FC and Web I), Connections and Universe restrictions to BO XI R2 environment.

• Used System Tables, System Stored Procedure, DBCC commands for Database maintenance.

• Migrated DTS packages from SQL Server 2000 to SQL Server 2005 as SSIS Packages.

• Involved in migration from SQL Server 2005 to SQL Server 2008.

• Written DDL / DML Triggers as per company policy.

• Actively involved in Normalization (3NF) & De-normalization of database.

Environment: MS SQL Server 2008 and 2005, T-SQL, ODBC, Excel, SSAS, SSIS Packages, SSRS, MDX, ProClarity, OLAP, OLTP, DB2, Access, Windows 2003 Server, IIS 6.0.

Client: Bookstore Manager, Inc. Abilene, TX Feb’ 09 – May’ 10

SQL Server Developer/SSIS/SSRS

Roles and Responsibilities:

• Used SSIS to unite data from existing system and performed transformations on MS SQL 2005

• Used various transformation components in the data flow task to implement business logic.

• Configured SSIS packages using Package Configuration wizard to allow package run on different environments.

• Conversion of DTS packages SQL Server 2000 into SSIS packages SQL Server 2005.

• Created complex variables, multiple breaks, sorts in the reports.

• Created Tabular and Matrix reports using SSRS.

• Developed multiple reports using reporting services.

• Creating functions and developing procedures for implementing application functionality at the database side for performance improvement.

• Creating and Modifying T-SQL stored procedures/triggers for validating the integrity of the data.

• Created packages and scheduled it to get from OLTP.

• Created various scheduled jobs to handle the data migration from SQL 2000 to 2005 periodically.

• Experience in building star schema and snowflake schema depending on the business data requirement.

• Monitor NT Event log for system, application errors, available disk space, Backup registry, keep emergency repair disk as current.

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

• Monitor SQL Error Logs/Schedule Tasks /database activity/eliminate Blocking and deadlocks/user accounts and connections /locks etc.

• Scheduling Jobs and Alerting using SQL Server Agent.

• Created datasets for reports using T-SQL and stored procedures.

• Created Cubes from which data can be retrieved rapidly by enterprise information consumers.

• Responsible for maintaining cubes using SSAS and populate the cubes with the data.

• Created different Data Layouts for the Business users depending on the requirement and providing them different Drill Down capabilities using ProClarity.

• Responsible for Query optimization and performance tuning

• Used NT Performance monitor to monitor CPU & Memory usage and SQL Server Profiler to monitor and record database activities of particular users, applications.

• Created logins, roles and groups to the Window NT and MS SQL Server and maintaining proper security procedures.

Environment: SQL Server 2000/2005 Enterprise Edition, SSIS 2005, SSRS 2005, XML, T-SQL, SQL Server 2000, SQL Server 2005, Windows 2000/2003 Advance Server, MS Excel, MS Access, Visual Studio 05.

Client: CITI Financial, NY Mar’ 08- Jan’ 09

SQL Server Developer

Roles and Responsibilities:

• Installed SQL server 2000 on windows 2000 server, applied service packs and security fixes.

• Designed databases for different projects and resolve database issues.

• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.

• Addressed the Replication Issues. Created new replications, DTS packages to maintain high availability of the data between the servers.

• Implemented the SQL login security for developers and users.

• Created DTS packages to pull data from Oracle and Flat Files.

• Created DDL for physical model using Erwin and handed over to the DBA team.

• Running DBCC consistency checks, and fixing data corruption in user databases.

• Involved in planning and monitoring Log Shipping.

• Used the descriptors for getting the input and output values in ANSI SQL.

• Planning, Implementing and troubleshooting Replication.

• Created logical and physical data modeling for development database using ERWIN tool.

• Creation of schema objects, rules and granting of roles to the users.

• Worked and coordinated with developers in writing and tuning new stored procedures.

• Worked on DTS packages to import the data from Oracle, Access and text files.

• Used CSS (Cascading Style Sheets) for branding purposes and user look and feel.

• Setting up backups for the newly created databases.

• Scheduling transfer of backups and log files to different servers.

• Provided a support for data issues and given appropriate solutions.

Environment: MS SQL Server 2000, MS Access, ANSI SQL, Oracle, Windows 2000, XML, SQL Profiler.

Client: Acadia Insurance Company, Rocky Hill, CT April’ 07 – Feb’ 08

Ms SQL server Developer/SSAS Developer

Roles and Responsibilities:

• Involved in documenting the code for understandability.

• Participated in creating reports that deliver data based on stored procedures.

• Experience in creating snapshots of static reports and configure subscription.

• Involved in creation of dimensions using Star and Snowflake schemas.

• Actively involved in creating SSIS packages to transform data from OLTP database to a data warehouse.

• Encapsulated frequently used SQL Statements into Stored Procedures thereby reducing the execution time.

• Involved in developing triggers to audit schema changes at the database level.

• Created Transactional Replication, Pull Subscription and defined publications to transfer data from branch to head office and vice versa.

• Created sub-reports to present more detailed information about the summary.

• Defined cubes, dimensions, user hierarchies, aggregations in an OLAP environment.

• Designed and implemented stored procedures and triggers for automating tasks

• Developed Server for sending automatic mails to the respective people when a SSIS process failure or success.

• Created dimensions using SQL Server Analysis (SSAS).

• Developed Multi dimensional Objects (Cubes, Dimensions) using MS Analysis.

• Consultancy for OLAP Data warehouse, Model, Design, Implementation.

• Loading data from various sources like flat files to SQL Server database using SSIS Package.

• Involved in creation of Dimensions using Star Schema.

• Used Lookup transformation to get the data from reference data sets.

• Scheduling the SSIS packages and jobs.

• Using SQL Server Reporting Services (SSRS) delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources.

• Making a report as per user requirement using MS Reporting Services 2000/2005.

• Created SSIS packages to migrate slowly changing dimensions.

• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS 2005.

• Worked on improving the performance of the system.

• Involved in the tuning of the existing Database Objects.

• Created permanent tables, Temporary tables and table variables.

• Used Query Analyzer to optimize SQL queries.

Environment: SQL Server 2000, MS Excel 2003, MS SQL Query Analyzer, SQL Profiler, MS SQL Server Reporting Services, MS SQL Server Analysis Services.

Client: EMC Insurance Company, Des Moines, IA May’ 06 – March’ 07

SQL Server Developer/SSIS/SSRS

Roles and Responsibilities:

• Used SSIS to unite data from existing system and performed transformations on MS SQL 2005

• Used various transformation components in the data flow task to implement business logic.

• Configured SSIS packages using Package Configuration wizard to allow package run on different environments.

• Conversion of DTS packages SQL Server 2000 into SSIS packages SQL Server 2005.

• Created complex variables, multiple breaks, sorts in the reports.

• Created Tabular and Matrix reports using SSRS.

• Developed multiple reports using reporting services.

• Creating functions and developing procedures for implementing application functionality at the database side for performance improvement.

• Creating and Modifying T-SQL stored procedures/triggers for validating the integrity of the data.

• Created packages and scheduled it to get from OLTP.

• Created various scheduled jobs to handle the data migration from SQL 2000 to 2005 periodically.

• Experience in building star schema and snowflake schema depending on the business data requirement.

• Monitor NT Event log for system, application errors, available disk space, Backup registry, keep emergency repair disk as current.

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

• Monitor SQL Error Logs/Schedule Tasks /database activity/eliminate Blocking and deadlocks/user accounts and connections /locks etc.

• Scheduling Jobs and Alerting using SQL Server Agent.

• Created datasets for reports using T-SQL and stored procedures.

• Created Cubes from which data can be retrieved rapidly by enterprise information consumers.

• Responsible for maintaining cubes using SSAS and populate the cubes with the data.

• Created different Data Layouts for the Business users depending on the requirement and providing them different Drill Down capabilities using ProClarity.

• Responsible for Query optimization and performance tuning

• Used NT Performance monitor to monitor CPU & Memory usage and SQL Server Profiler to monitor and record database activities of particular users, applications.

• Created logins, roles and groups to the Window NT and MS SQL Server and maintaining proper security procedures.

Environment: SQL Server 2000/2005 Enterprise Edition, SSIS 2005, SSRS 2005, XML, T-SQL, SQL Server 2000, SQL Server 2005, Windows 2000/2003 Advance Server, XML, MS Excel, MS Access.

Client : Crystal Info Solutions India Pvt.Ltd, India June’ 04 - April ‘ 06

MS SQL Server Developer

Roles and Responsibilities :

• Used T-SQL to create various queries.

• Involved in application design, development and testing.

• Database Design, Optimization of Queries and Database, Performance Tuning, SQL Profiler and Query Analyzer.

• Configured the SQL Server to increase the Server Performance, Creating Database Maintenance Plans, writing Stored Procedures and Triggers.

• Designing of Database and Tables.

• Developed SQL Scripts to insert, update and delete data in MS SQL database tables.

• Deployed different types of packages by using DTS and its tools and transferred them into different formats like MS Excel, TTF file, MS Access by using DTS.

• Scheduled jobs for backup and created alerts for error reporting.

• Monitored the growth of the database objects for capacity planning.

Environment : SQL Server 2000, VB Script, DTS, Enterprise Manager, Query Analyzer, XML, IIS 5.0, Windows 2000/NT/XP.

Contact this candidate