Summary
Overview
Work History
Education
Skills
Timeline
Generic

Sireesha Chavvakula

Atlanta,GA

Summary

  • 13+ years of experience in Database Administration for large databases in SQL Server 2005, SQL Server 2008,2008 R2,2012,2014, 2016 and 2019 and Businees Intelligence Administration.
  • Systematic and organized SQL DBA trained in database systems management using a variety of technology platforms.
  • Qualified SQL DBA committed to data integrity.
  • Experienced Database Administrator on Production Servers using SSCM,SSMS, performance tuning tools such as profiler,DTA.
  • Hands on experience on SQL Server Replication, High Availability,Backup/Restore, Disaster recovery and planning.
  • Having hands on experience in Log Shipping and Database Mirroring.
  • Troubleshoot performance problems, fine-tuning of databases and index Analysis.
  • Excellent communication skill, critical thinking and problem solving skills.
  • Experience in Batch processes, Import/Export, Database Monitoring tools and Application support.
  • 24/7 Production Database on Call Support.
  • Microsoft SQL DBA certified and SAP BI Admin Certified

Overview

12
12
years of professional experience

Work History

SAP BI and MS SQL Server Admin

West Corporation
Atlanta, GA
04.2014 - Current
  • Responsible for installation, configuration and complete administration of different versions of SQL Server (2008 to 2010)
  • Apply Service Pack (SP) and hot fixes on SQL server 2008R2,2012 ,2014,2016 and 2019
  • Configure log shipping for multiple databases as a part of Disaster Recovery.
  • Configure Replication and Database mirroring.
  • Application support for front end feeds and Resolved Application connectivity issues like connection timeouts, connection pooling issues and memory leaks.
  • Extensively work with SQL Profiler, Activity monitor, DMVs, DMFs and DTA to tune the databases, queries, performance related issues like memory CPU and I/O issues.
  • Analyze long running slow queries and tune the same to optimize application and system performance.
  • Configuring and maintaining Log-Shipping and troubleshooting the issues.
  • Reorganize/Rebuilding the indexes at regular intervals for better performance.
  • Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
  • Involved in troubleshooting and fine-tuning of databases for its performance.
  • Improve the performance of SQL Queries and stored procedures using SQL Profiler.
  • Implemented company policies, technical procedures and standards for preserving the integrity and security of data, reports and access.
  • Database Backup Procedures, Restoration Procedures, Disaster Recovery procedures and Contingency plans. Testing and implementing these procedures.
  • Provide 24/7 technical database support for SQL Database systems.

BI Technical Lead SQL Server DBA

National Weather Service
Silver Spring, MD
11.2011 - 04.2014
  • · Responsibilities include Lead a team of 3 developer and 1 Business Analyst in Universe Design, WEBI Reporting, Xcelsius dashboard design. Also include admin responsibilities like migration of WEBI Reports from BOXIR2 to BOXIR3, upgrade from Business Objects XIR2 to 3.1 with repository migration tool and Import Wizard of BO users, Groups, Folders, Universes and Reports to XI R2.
  • · Successfully upgraded BO 3.1to BO 4.0 and customized, expert in Java SDK.
  • · Successfully installed and configured Business Objects 3.1 on Staging Environment, Applied Service Pack and fix pack.
  • · Successfully installed and configured Business Objects 4.0 on Staging Environment, Applied Service Pack and fix pack.
  • · Clustered the servers successfully by distributing the Business Objects Services effectively between all the servers to make the Business Objects Environment Highly Available and got the “FAILOVER” to work efficiently.
  • · Used Import Wizard tool to migrate all the objects from BO XIR2 to BO 3.1.
  • · Tested all the reports that are migrated and analyzed the performance of the BO 3.1 using Load Runner by creating many virtual users.
  • · Worked Experience installation of Business Objects service packs SP3 and higher versions.
  • · Maintained the whole environment (TEST, DEV and PROD) along with 8 main servers.
  • · Experience in scheduling of repository backup and tuning the Business Objects servers for a better performance.
  • · Performed Server Management Tasks, using Central Configuration Manager (CCM) and Central Management Console (CMC).
  • · Configured File Repository Servers, Crystal Report Job, Cache and Page Servers, LOV Job server, Web Intelligence Job and Report Servers, Desktop Intelligence Job, Report and Cache Servers, Destination Job Server, Program Job Server, and Event Server.
  • · Applying patches, hot fixes, critical fixes, service packs and testing/applying security patch.
  • · Requirement Collection, Documentation & high-level design.
  • · Analyzed business model and created BI Architecture plan, created Business Functional Specifications, Functional Design Specifications, and Detailed Design Specifications
  • · Assisting the client, through analysis of their existing system, challenges, and business needs
  • · Documented the reporting requirements, dashboard design requirements by thorough interactive sessions with Business users by building prototypes for developing the interactive executive level dashboards.
  • · Involved in Working with Erwin tool in Data Modeling (both Physical and Logical Design)
  • · Designed, Developed and Maintained Universe in BOXIR3 Designer by defining joins and indicating cardinalities between tables in star schema (fact and dimension table) from data warehouse, creating Aliases to resolve the Loops, subdividing into Contexts to remove cyclic dependencies. Created the objects, which are grouped into classes for convenience in Business Objects Designer. Created custom List of Values. Used @Aggregate Aware, @Where, @Select, @Variable, @Prompt and @script functions when required
  • · Defined Access Restrictions in the universe for Confidential, Non Confidential and Highly confidential User groups and applied to the groups defining the priorities for different Access Restrictions. Applied security features of Business Objects like row level, report level & object level security in the universe so as to make the sensitive data secure
  • · Designed the Universe with the ability of adhoc reporting for users
  • · Worked with Business Analyst and the Business user to understand the user requirements, layout, and look and feel of the application to be developed.
  • · Two Dashboards were developed and served to track budget. Dashboards included customer detail drilldowns, threshold gauges and alerting mechanisms.
  • · Setting up New task, mounting on Access Point, troubleshooting already existing task setup and other issues.
  • · Created and Scheduled Weekly QlikView reports to distribute on email using Printing and publisher
  • · Participated in pre-sales activity working with prospective client, assisting with Technical contributions to win new business.
  • · Maintained Server for smooth QlikView development. Checked and updated environmental file, assigned task, path and triggers for QMC, QEMC.
  • · Presented the Dashboard to Business users and cross functional teams, define KPIs (Key Performance Indicators), and identify data sources.
  • · There were 4 million records with incremental loading of 20,000/week.
  • · Enhancement and translation of the already existing Dashboards in MSRS into QlikView. Extensively worked with Set Analysis.
  • · Helped end users to design test cases and worked through multiple UAT cycles.
  • · Handled query performance by created conditions in Universes and optimizing it at the Database level
  • · Created complex conditions (Dates), Prompts and free hand custom SQL to create Derived tables in universe. Defined logical classes and objects and hierarchies for analysis and drilling on hierarchies in the WEBI reports
  • · Created supporting WEBI reports for dashboards with multiple data providers and synchronized the data using merge dimension option in BO XIR3.1, and using combined queries to union hierarchical geo-dimensional data and using Chart, Sub-queries.
  • · Applying Drill Filters, sorts, breaks and multiple Tab reports with charts, crosstabs format, master/detail report.
  • · Developed View on Demand and Canned reports with Date functions, Drill Filters, Breaks, grouping data, custom sorts Displaying data in Free-standing cells
  • · The reports are built using Webi Rich Client and exported to CMS and scheduled instances of WEBI reports in Infoview
  • · Tested the results in Business Objects WEBI reports and running the queries (SQL’s) in the Database in Oracle.
  • · Developed web application interface with WebI SDK, ASP.
  • · Created Add-Ins and Macros based on the end users requirement using VBA (BO SDK).
  • · Designed and developed highly complex interactive Dashboards using Xcelsius 2008.
  • · Built Dashboards with high volume of data and cross-tab data upon latest instance of scheduled WEBI reports using LiveOffice connections.
  • · Built Dashboards with high variation of data using QAAWS and BI Web Services.
  • · Built Dashboards with various functionalities like passing parameters by selecting parameters from drop down list, also passing prompts from dashboard to WEBI reports.
  • · Extensive use of drill down capabilities, drill through capabilities, dynamic visibilities, dynamic filtering, scorecard components, containers, combo boxes, list views, complex excel logic, highly formatted excel model with defined naming conventions for design of these complex dashboards
  • · Designed Navigation page using XML connectivity containing the dashboards in highly interactive fish eye design with security enabled on the dashboards according to windows Active Directory Authentication.
  • · Customization of Business Objects using Enterprise SDK. Modified the look and feel of the WebI and integrated the reports with the intranet portal.
  • · Performance tuning on dashboards by optimizing number of LO connections and applying LA Fix by replacing jar files on the Tomcat Server.
  • · Well documented the design of Universe and detailed classes / objects information with macro enabled excel, all the changes made to the Universe, documented the design of WEBI Reports and dashboards and the changes made for future references.
  • Installation, configuration and upgrading of SQL Server 2008/2008R2,2012 with service packs and hot fixes.
  • Upgrading SQL Server 2008/2008R2 to SQL Server 2012 (Side by side upgrade).
  • Providing On-Call support during business hours.
  • Monitoring Daily backup jobs and automation of daily restores of development databases.
  • Monitoring the Disk Space of all the Servers.
  • Configuring and Monitoring log shipping and Database mirroring on Disaster recovery Servers.
  • Database snapshot creation for the synchronized databases for Reporting Purposes.
  • Capturing the events using sql profiler for poor performing queries, deadlocks and blocks and studying the execution plans and fine tuning the applications.
  • Automating Server Side Tracing in SQL Server and identifying SQL Server performance issues, by analyzing Profiler output.
  • Disaster Recovery setup and testing it in regular intervals.
  • Reporting and resolving serious SQL Server alerts.
  • Implement and Maintain database Security (Create and maintain users and roles, assign privileges)
  • Working with workflows for any changes on staging and development environment. Involved in the internal and external audits and participating in the business continuity plans of the company.
  • Implemented company policies, technical procedures and standards for preserving the integrity and security of data, reports and access.
  • Designed strategic plan for component development practices to support future projects.

Business Objects Admin & Developer

T Rowe Price
Owings Mills, MD
04.2011 - 11.2011


  • Responsibilities include Universe Design, WEBI Reporting, Xcelsius dashboard design. Also include admin responsibilities like migration of WEBI Reports from BOXIR2 to BOXIR3, upgrade from Business Objects XIR2 to 3.1 with repository migration tool and Import Wizard of BO users, Groups, Folders, Universes and Reports to XI R2.
  • Extensively involved in setting a new BO 3.1 Environment.
  • Successfully installed and configured Business Objects 3.1 on Staging Environment, Applied Service Pack and fix pack.
  • Clustered the servers successfully by distributing the Business Objects Services effectively between all the servers to make the Business Objects Environment Highly Available and got the “FAILOVER” to work efficiently.
  • Used Import Wizard tool to migrate all the objects from BO XIR2 to BO 3.1.
  • · Tested all the reports that are migrated and analyzed the performance of the BO 3.1 using Load Runner by creating many virtual users.
  • · Resolved the performance issues in BO 3.1
  • · Installed and Configured BO 3.1 on Production Environment of different regions.
  • · Managed over 400 users and 30 groups in the entire Business Objects suite
  • · Maintained the whole environment (TEST, DEV and PROD) along with 8 main servers.
  • · Experience in scheduling of repository backup and tuning the Business Objects servers for a better performance.
  • · Performed Server Management Tasks, using Central Configuration Manager (CCM) and Central Management Console (CMC).
  • · Configured File Repository Servers, Crystal Report Job, Cache and Page Servers, LOV Job server, Web Intelligence Job and Report Servers, Desktop Intelligence Job, Report and Cache Servers, Destination Job Server, Program Job Server, and Event Server.
  • · Applying patches, hot fixes, critical fixes, service packs and testing/applying security patch.
  • · Requirement Collection, Documentation & high-level design.
  • · Analyzed business model and created BI Architecture plan, created Business Functional Specifications, Functional Design Specifications, and Detailed Design Specifications
  • · Assisting the client, through analysis of their existing system, challenges, and business needs
  • · Documented the reporting requirements, dashboard design requirements by thorough interactive sessions with Business users by building prototypes for developing the interactive executive level dashboards.
  • · Involved in Working with Erwin tool in Data Modeling (both Physical and Logical Design)
  • · Designed a new Universe for GIS BI Pilot project which supports GIS CRM system
  • · Designed, Developed and Maintained Universe in BOXIR3 Designer by defining joins and indicating cardinalities between tables in star schema (fact and dimension table) from data warehouse, creating Aliases to resolve the Loops, subdividing into Contexts to remove cyclic dependencies. Created the objects, which are grouped into classes for convenience in Business Objects Designer. Created custom List Of Values. Used @Aggregate_Aware, @Where, @Select, @Variable, @Prompt and @script functions when required
  • · Defined Access Restrictions in the universe for Confidential, Non Confidential and Highly confidential User groups (SICAV and Non SICAV) and applied to the groups defining the priorities for different Access Restrictions. Applied security features of Business Objects like row level, report level & object level security in the universe so as to make the sensitive data secure
  • · Designed the Universe with the ability of adhoc reporting for users
  • · Handled query performance by created conditions in Universes and optimizing it at the Database level
  • · Created complex conditions (Dates), Prompts and free hand custom SQL to create Derived tables in universe. Defined logical classes and objects and hierarchies for analysis and drilling on hierarchies in the WEBI reports
  • · Created supporting WEBI reports for dashboards with multiple data providers and synchronized the data using merge dimension option in BO XIR3.1, and using combined queries to union hierarchical geo-dimensional data and using Chart, Sub-queries.
  • · Applying Drill Filters, sorts, breaks and multiple Tab reports with charts, crosstabs format, master/detail report.
  • · Developed View on Demand and Canned reports with Date functions, Drill Filters, Breaks, grouping data, custom sorts Displaying data in Free-standing cells
  • · The reports are built using Webi Rich Client and exported to CMS and scheduled instances of WEBI reports in Infoview
  • · Tested the results in Business Objects WEBI reports and running the queries (SQL’s) in the Database in DBVisualiser.
  • · Developed web application interface with WebI SDK, ASP.
  • · Created Add-Ins and Macros based on the end users requirement using VBA (BO SDK).
  • · Designed and developed highly complex interactive Dashboards using Xcelsius 2008.
  • · Built Dashboards with high volume of data and cross-tab data upon latest instance of scheduled WEBI reports using LiveOffice connections.
  • · Built Dashboards with high variation of data using QAAWS and BI Web Services.
  • · Built Dashboards with various functionalities like passing parameters by selecting parameters from drop down list, also passing prompts from dashboard to WEBI reports.
  • Extensive use of drill down capabilities, drill through capabilities, dynamic visibilities, dynamic filtering, scorecard components, containers, combo boxes, list views, complex excel logic, highly formatted excel model with defined naming conventions for design of these complex dashboards
  • Designed Navigation page using XML connectivity containing the dashboards in highly interactive fish eye design with security enabled on the dashboards according to windows Active Directory Authentication.
  • · Dashboards are certified by SAP through design review sessions
  • · Customization of Business Objects using Enterprise SDK. Modified the look and feel of the WebI and integrated the reports with the intranet portal.
  • Performance tuning on dashboards by optimizing number of LO connections and applying LA Fix by replacing jar files on the TomCat Server.
  • Unit Testing is performed on Dashboards, Reports and Universe using HP Quality Center and updated the results in HPQC.
  • Published Dashboards to Infoview and shared to the users in sharepoint through OpenDoc links.
  • Well documented the design of Universe and detailed classes / objects information with macro enabled excel, all the changes made to the Universe, documented the design of WEBI Reports and dashboards and the changes made for future references.

Education

Bachelor of Science - Computer Science

University of Houston Downtown
Houston, TX

Skills

  • Log-shipping
  • Replication
  • Mirroring
  • Database schema creation and management
  • Backup and recovery
  • Ensuring data integrity
  • Performance management and tuning
  • High Availability
  • Data security
  • General database management
  • Extensible data type administration


  • Excellent diagnostic skills
  • Enterprise technologies
  • Excellent communication skills
  • Data privacy applications
  • Excellent problem-solving abilities
  • Database design


Timeline

SAP BI and MS SQL Server Admin

West Corporation
04.2014 - Current

BI Technical Lead SQL Server DBA

National Weather Service
11.2011 - 04.2014

Business Objects Admin & Developer

T Rowe Price
04.2011 - 11.2011

Bachelor of Science - Computer Science

University of Houston Downtown

Similar Profiles

CREATE PROFILE
Sireesha Chavvakula