Sql Server Data
Resume:
Srikala Kotela
****.*****@*****.***
Overview
Experienced developer with emphasis on Microsoft Business Intelligence stack including MS SQL Server
development, administration, data analysis, database design, Report writing (SSRS), ETL (SSIS), and coding of T-SQL
stored procedure, views, triggers, and user defined functions. I specialize in providing services to Upstream Oil and
Gas, HealthCare and Financial industries.
• Very good T-SQL Programming skills. Experience in query optimization & performance tuning. Used SQL
Profiler, Execution Plan, Performance Monitor and DBCC Commands
• Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers,
Rules, Defaults, user defined data types and functions.
• Designed Databases for enterprise applications on MS SQL Server (7.0, 2000 and 2005,2008,2012)
• Experience coupled with good understanding of the concepts of GUI development, Relational Database
Management systems (RDBMS), primarily MS SQL Server.
• Experience in developing SSIS Packages
• Experience in developing reports using SSRS.
• Involved in building Enterprise wide Data warehouse and Multi-dimensional cubes using SSAS
2005/2008/2012.
• Good experience in converting the Business Requirements into Technical Specifications, Design &
Development.
• Highly motivated with the ability to work effectively in teams as well as independently.
• Excellent communication skills coupled with experience in interacting with clients.
• Committed to highest levels of professional and personal excellence.
• Excellent analytical and problem-solving skills.
• Highly motivated and a fast-learner.
• Ability to work in challenging and versatile environments and strive for excellence.
Technical Skills:
RDBMS MS-SQL Server 7/2000/2005/2008/2012,2014, Oracle, MS-Access
SSRS, Crystal Reports, Cognos 8(Framework Manager, Query Studio, Report
Reporting Tools
Studio),Excel, PDF
Oracle Support
TOAD, and SQL Navigator
Utilities
Database Tools SSMS,BIDS,DTS,SSIS,SSAS,Microsoft SQL server replication services
Data Modeling Tools Erwin, MS Visio
Operating Systems Windows 7/XP/2000/NT/9x and 2003 server, UNIX
Programming
C, C#, C++, T-SQL,PL/SQL
Languages
Scripting Languages VB6 Script
Other MS Office, MS Project
PROFESSIONAL EXPERIENCE:
Enterprise Products, Houston TX June 2012-Tilldate
SQL/BI Developer
Technical Responsibilities:
• Created permanent tables, temporary tables, table variables, indexes, procedures, views and triggers
for automating tasks in TSQL using SQL Server 2008/2012/2014.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning
Wizard.
• Maintained the database objects including the stored procedures, user defined functions, tables
related to PODS (Pipeline Open Data Source) data model.
• Extensively involved in database support (creating stored procedures, functions etc.) for the user
interface called Asset Information Manager (AIM) from which users can access different pipeline
assets, reports etc.
• Worked closely with GIS analysts and involved in writing the SQL scripts using SQL Geo spatial
functions.
• Involved in creating the derived tables/processes using PODS tables as a source.
• Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL
Server 2008 using SSIS, BCP and Bulk Insert.
• Designed the Templates to develop the SSIS packages with fixed variables and for Auditing package
execution details.
• Created custom data flow items for different SSIS packages using the VB.Net script.
• Created the package configurations using XML configuration file and Parent Package Variables.
• Deployed SSIS Package into Production and used Package configuration to export various package
properties to make package environment independent.
• Created the automated processes for the activities such as database backup processes and SSIS
Packages run sequentially using SQL Server Agent job.
• Managed the production deployments and maintained different versions of the scripts through Team
foundation server source control.
• Designed and developed various SSIS packages to import data from Excel and Flat files to SQL
Server using SSIS 2008, 2012 and 2014.
• Created individual Data marts for NPMS, PHMSA, and RISK deliverables.
• Consolidated the data from all the data marts to build Enterprise Data warehouse.
• Strongly involved in technical design for implementing data warehouse.
• Involved in creating the cube, named queries, named calculations using SSAS and refresh/process
whenever needed.
• Used Microsoft power pivot and power view to analyze the data in more granular level.
• Created Tabular reports, Cross Tab Reports, Matrix and Sub Reports and Parameterized reports
using SSRS 2008 and 2012.
• Developed Dashboards, Charts in order to view the pipeline metrics using SSRS and Power view.
• Created traces using SQL server profiler to find long running queries and modify those queries as a
part of Performance Tuning operations.
• Analyzed reports and fixed bugs in stored procedures.
• Involved in writing scripts and transactions to manipulate data in the database.
• Involved the technical review of SQL code with peers and design review with end-user audience.
• Involved in documentation of Reports, SSIS Packages, Tables, Stored Procedures, and User Defined
Functions etc.
• Worked on various major projects such as Facility Management, UPMR, HCA, ILI, AGM Loader,
etc. in the Asset Integrity Management Department.
Environment: MS SQL Server 2008/2012/2014, SSIS 2008/2012/2014, SSRS, SSAS 2008/2012, TFS, MS Excel,
Windows 2008
Entrust Energy, Houston TX Nov 2011-June 2012
SQL/BI Developer
Technical Responsibilities:
• Designed and analyzed the SQL Server database and involved in gathering the user requirements
• Logical and Physical design of database for project on basis of user requirements.
• Created new tables, stored procedures for Application Developers and some user define functions.
• Created SQL scripts for tuning and scheduling.
• Performed data conversions from flat files into a normalized database structure.
• Created Triggers to enforce data and referential integrity.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Performed optimization of query, triggers and stored procedures, their testing focusing on stability and
execution plan which has resulted up to 45% increase in performance of numerous modules.
• Involved in pulling the data from ERCOT website and loading into the database
• Involved in Extraction, Transforming and Loading (ETL) data flows using SSIS; creating
mappings/workflows to extract data from SQL Server and Flat File sources and load into various Business
Entities.
• Created SSIS package to load data from Flat File to Flat File and Flat File to SQL Server 2008 using Lookup,
Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and
Slowly Changing Dimension.
• Used custom .NET assemblies for Script Task in SSIS.
• Designed and developed SSIS package for loading data from OLTP to ODS and finally to Data Warehouse.
• Used ETL to implement Slowly Changing Dimension to maintain historical data in Data Warehouse.
• Implemented replication in SQL Server for managing and scaling databases in an enterprise environment.
• Loading data in Dimension Tables in SQL Server using SSIS Packages.
• Used Bulk Copy Program and Bulk Insert to load data from different data sources to SQL Server.
• Deployed and Configured SSIS Packages using BI xpress.
• Involved in using BI xpress for error handling by adding auditing feature to SSIS Packages and monitoring
the same.
• Unit testing and Integration testing for various modules.
• Responsible in creating a SQL Agent job to automate the execution of SSIS Package and executing in
different environments.
• Involved in Data Cleansing, Data Scrubbing, Error and Event handling, setting up the precedence constraints,
Breakpoints, Checkpoints, and Logging.
Environment: MS SQL Server 2005/2008, SSIS, SSRS, MS Excel, Windows 2008 Server
Texas Department of State Health Services, Austin TX Jun 2011-Nov 2011
SQL/SSIS Developer Analyst
Technical Responsibilities:
• Collaborated with business experts and application development teams to understand output requirements and
ensure application data and master data support those requirements.
• Understand complex business models and the data that supports those models, including inter-relationships
between applications.
• Provided solution options, including phased delivery, in order to deliver value to the business.
• Translated business requirements documentation, as well as input from business users, into functional and
technical specifications.
• Prepared Diagrams using Microsoft Visio and Erwin for better understanding the Database Models.
• Importing/Exporting data from/to different databases using utilities like Import/Export, Bulk Insert.
• Participated in migration of data from Microsoft Visual FoxPro to SQL SERVER databases and
responsible in creating complex SSIS packages to transfer data between them.
• Involved in Authoring reports in SSRS according to the business requirements.
• Involved in Data Conversion from Microsoft Visual FoxPro to SQL Server Database.
• Designed and developed a fully functional database by creating the logical database design and implementing
the physical database design using SQL server 2005.
• Written complex t-sql Queries using joins, aggregate functions, sub queries.
• Participated in Performance tuning SQL statements to improve performance of the system.
• Created complex Stored Procedures, Functions, Triggers, Cursors, Tables, Views and SQL Joins and
other DDL and DML statements for various applications, maintained referential integrity and implemented
complex business logic using t-sql and pl sql.
• Wrote stored procedures using Dynamic SQL, Cursor to handle special case which can't be handled using
static T-SQL or set based operations.
• Created views to develop new user-friendly web pages and restrict data access to users.
• Performed full, transactional, and differential backup.
• Optimized the performance of queries with modification in TSQL queries, removed unnecessary columns,
eliminated redundant and inconsistent data, normalized tables, established joins and created clustered/non-
clustered indexes wherever necessary.
• Used tools like SQL Profiler, Performance Monitor to find out performance issues with queries or Application
(i.e. Opening/Closing Connections by application, Read/Write etc.)
• Involved in Error handling for different applications.
• Involved in documenting the scripts for better understanding.
Environment: MS SQL Server 2005/2008, SSIS, SSRS, MS Excel, Windows 2003 Server
Community Health Plan of Washington, WA Oct 2010-Dec 2010
BI Developer
Technical Responsibilities:
• Worked with business experts and application development teams to understand output requirements and
ensure application data and master data support those requirements.
• Understand complex business models and the data that supports those models, including inter-relationships
between applications.
• Provided solution options, including phased delivery, in order to deliver value to the business.
• Translated business requirements documentation, as well as input from business users, into functional and
technical specifications.
• Responsible for analyzing the data, ensuring the data quality and organizing the data.
• Generated reports from the cubes by connecting to Analysis server from SSRS.
• Created Dimensions with the cube wizard and also individually.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.
• Designed and created Report templates, bar graphs and pie charts based on the financial data
• Created reports with Analysis Services Cube as the data source using SQL Server 2005/2008 Reporting
Services.
• Created the automated processes for the activities such as database backup processes and SSIS Packages run
sequentially using SQL Server Agent job.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Assisted in production of OLAP cubes, wrote queries to produce reports using SQL Server 2005/2008
Analysis Services (SSAS) and Reporting service (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.
• Created Reports from Web Services and used MDX on Cubes in SSAS to create reports in SSRS.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of
SSIS.
• Experience in using tools like index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for
Monitoring and Tuning MS SQL Server Performance.
• Worked on Sub Reports, Graphing, Data Drill-Down, and Data sorting/grouping, Crystal Report Design.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Extensive working knowledge in Application testing, Data Modeling, Data migration, Data Warehousing, and
OLTP, OLAP Database projects
• Participated in tuning MDX to improve performance of the system.
• Created complex reports against Cube.
• Involved in converting Excel reports to SSRS Reports.
• Experience with excel reporting.
• Involved in creating Complex Parameterized reports.
• Used complex expressions to calculate, group, filter, parameterize, and format the contents of a report.
Environment: MS SQL Server 2005/2008, SSIS, SSAS, SSRS, MS Excel, Windows 2003 Server
Morris Griffin Corporation, MD Sep 2009 – Sep 2010
ETL/Report Developer
Technical Responsibilities:
• Actively participated in interacting with business users, gather and analyze requirements.
• Actively participated in defining defaults, constraints.
• Importing/Exporting data from/to different databases using utilities like Import/Export, Bulk Insert.
• Written complex t-sql Queries using joins, aggregate functions, sub queries.
• Participated in tuning SQL statements to improve performance of the system.
• Involved in designing, developing and converting the data from legacy source systems to SQL Server
database.
• Participated in migration of data from EXCEL to SQL SERVER databases and responsible in creating
packages to transfer data between ORACLE, MS ACCESS and FLAT FILES to SQL server using
DTS/SSIS.
• Designed and developed a fully functional database by creating the logical database design and implementing
the physical database design using SQL server 2000. Successfully tested and validated with end users the
database design.
• Wrote queries to generate reports for analysis of data using SQL Server Reporting Services (SSRS)
• Created Drill through reports by creating complex views.
• Developed reports using table control, matrix control for cross tab reports and designed and created Report
templates, bar graphs and pie charts
• Generated new ad-hoc reports, Static reports using SSRS with variety of Data sources and published using
Report Manager.
• Created complex Stored Procedures, Functions, Triggers, Cursors, Tables, Views and SQL Joins and other
DDL and DML statements for various applications, maintained referential integrity and implemented
complex business logic.
• Designed multi-dimensional SQL database structures for numerous projects using common dimensions within
a singular data warehouse environment.
• Developed analytical and reporting solutions using SSRS 2005/2008 (Reporting Services), SSAS 2005/2008
(Analysis Services).
• Worked with SQL delta tools for comparisons between databases.
Environment: MS SQL Server 2005, SSIS, SSAS, SSRS, VB6, SQL Delta tool, Microsoft IIS, Windows 2003 Server
Cornileus Pharmaceuticals, India May 2007-Jan 2008
SSIS Developer
Technical Responsibilities:
• Wrote complex Stored Procedure, Queries, Triggers, Functions, Indexes, User-defined functions and Cursors
for applications.
• Wrote Store Procedures using Transact SQL to populate the fact tables and dimension tables.
• The Stored Procedures support both daily and historical data loading to the fact tables.
• Created scripts to perform validations and run jobs on different instances (Development, Testing, and
Production Environments)
• Worked on Linked and Remote Servers to run distributed queries between SQL server and other data sources
like excel using ODBC, OLE DB drivers.
• Created PL/SQL stored procedures, Functions for moving the data from staging area to Data mart.
• Created PL/SQL scripts to extract the data from operational database into simple flat text files using
UTL_FILE package.
• Responsible for scheduling the jobs.
• Gathered Requirements from the end user and checked the structure of the schema and data.
• Involved in Performance tuning the SSIS Packages.
• Developed SSIS package from source to staging and/or staging to DW data mappings.
• Developed data warehouse and reporting systems using SSIS and SSRS including Report
Builder and Report Models.
• Created new SSIS packages for data Importing, Cleansing, and Parsing etc. Extracted,
cleaned and validated data that is extracted from ORACLE.
• Created SSIS packages to clean and load data to data warehouse.
• Created SQL server configurations for SSIS packages and XML & Windows event logs.
• Deploy SSIS packages.
• Maintain and Optimize SSIS package, and troubleshooting issues.
• Use SQL Profiler and Execution Plan for troubleshooting, monitoring SQL Server, T-
SQL statement, Index, configure jobs and SQL profiler trace.
• Created reports by extracting data from cube.
• Generated reports using SQL Server Reporting Services 2008 from OLTP and OLAP data
sources.
• Created report models and deployed on report server.
• Created standard report Subscriptions and Data Driven report Subscriptions
Worked extensively on enterprise report (dashboards, scorecards, sub report, matrix and
•
drill through) and ad-hoc reports.
Environment: MS SQL Server 2005, SSIS, SSRS, SSMS, ORACLE, Windows 2003 Server T-SQL.
Spansules Pharmaceuticals, India Jan 2003-Apr 2005
SQL Server Developer
Technical Responsibilities:
• Served as developer for the solutions designed by other team members.
• Checked the coding standards followed by peers of the team.
• Prepared test reports and bug logs for the testing done.
• Involved in data migration and data integration.
• Developed stored procedures, triggers and functions and added/changed tables for data Extraction,
Transformation and loading.
• Tested and configured automated routine maintenance tasks like performance tuning, indexes and stores
procedures, checked deadlocks and created scheduled jobs.
• Extraction, Transformation and Loading of the data using DTS packages.
• Created and managed schema objects such as tables, views, stored procedures, and triggers and maintained
Referential Integrity.
• Responsible for designing Schema and finalization of naming and coding standards throughout project life
cycle.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-
SQL and PL SQL in Development and Production environment for SQL Server.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins,
database links and formatted the results into reports and kept logs.
• Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables.
Environment: Windows Server 2000, SQL Server 2000, Oracle, HTML, T-SQL.
EDUCATION:
Master’s Degree, Electronics and Communications
Bachelor Degree, Electronics and Communications
Contact this candidate