Uploaded File
add photo
Girisha
isha.nakka@gmail.com
903-372-1328
touchton rd
Jacksonville, FL 32203
SQL Developer
17 years experience
0
Recommendations
Average rating
85
Profile views
Summary

Experience
SQL Developer
Information Technology
Mar 2014 - present
  • Created database objects like tables, complex Stored Procedures, Functions, Views, Triggers, Indexes and T-SQL queries (DDL and DML) to meet the business requirements using T-SQL.
  • Involved in gathering business requirements and development of data modeling to facilitate business and operational needs.
  • Worked on support, resolve any production data quality issues and also supported any research requests.
  • Created functions and developed procedures for implementing application functionality at the database side for performance improvement.
  • Created and Modified T-SQL stored procedures for validating the integrity of the data.
  • Hands on MS SQL Server configuration, performance tuning, client/server connectivity, query optimization, back-up/recovery, running Database Consistency Checks using DBCC using SQL Server Profiler, Execution Plan and Performance Monitors.
  • Deployed the created SSIS packages in Development and Testing environments.
  • Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse databases and data mart databases.
  • Generated packages using different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component.
  • Experience in providing Logging and Error handling by using Event Handler and Custom Logging for SSIS Packages.
  • Used VB.Net and other .NET languages for Script task. Script task is primarily to control the flow of SSIS package.
  • Hands on using tools like SCM, VSS and CVS.
  • Gathered report requirements and document technical specifications.
  • Pulling the data from T-SQL stored procedure to make the parameterized reports.
  • Formatting the existing reports as well as creating new reports with different sources.
  • Responsible for Full Report cycle including Authoring, Managing, Security and Generation of reports.
  • Worked on database security, Replication and Log shipping activities.
  • Managing the security of the servers, creating the new logins and users, changing the roles of the users.
  • Backing up, Restoring system & other databases as per requirements, and also scheduled those backups. Environment: MS SQL Server Management Studio
.NET SQL Data Marts Stored Procedure SQL Server ETL SSIS T-SQL Triggers SQL Developer Data Modeling Data Replication Data Warehousing Database Backups Performance Tuning
Remove Skill
Database Developer
Information Technology
Oct 2013 - Mar 2014
  • Interacted with end users to define, create, implement, and maintain their reporting requirements and documented the designs.
  • Created database triggers/stored procedures and fine tuned to implement complex business rules and automatic background processing.
  • Created indexed views, and appropriate indexes to cut the complex query time.
  • Generated SQL scripts to create tables, views, primary keys, indexes, constraints, packages.
  • Design and develop SSIS packages, T-SQL Stored Procedures, configuration files, tables, views, and functions, implement best practices (performance tuning) to maintain optimal performance.
  • Developed SSIS packages using proper control and data flow elements with error handling.
  • Experience in moving the data from heterogeneous data sources like oracle, xml etc to sql using SSIS.
  • Created Stored Procedure and Functions for various SSIS packages.
  • Created packages for migrating data from other data source like Oracle, excel and Access using ActiveX Scripts to upload Data from Text files having Data such as CSV, and Tab space etc., values.
  • Extensively used T-SQL in constructing Stored Procedures, Common Table Expressions (CTEs), User Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
  • Used several transformations in SSIS like Sort, Merge, Merge join, Aggregate, Conditional split, Data conversion, Derived column, fuzzy lookup, Lookup, Merge, Merge Join, Multicast, pivot, sort, union all etc.,
SQL XML Stored Procedure Oracle SSIS T-SQL Triggers Data Conversion Database Design Data Integrity
Remove Skill
SQL Developer
Information Technology
Nov 2012 - Feb 2013
  • Deployed the created SSIS packages in Development and Testing environments.
  • Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
  • Created SQL Server Reports using SSRS 2008.
  • Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
  • Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
  • Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
  • Created Drill-down, Drill-through, Parameterized, dash board, calendar and Sub-Reports using SSRS.
  • Designed Matrix, Table, Indicator reports.
  • Created tables and inserted data in to them (which are required for creating Reports). Environment: MS SQL Server Management Studio 2008/2005, SQL Profiler, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), C#.net.
SQL Data Marts SQL Server ETL SSIS SSRS SQL Developer Data Warehousing Statistical Analysis Database Design Microsoft Excel
Remove Skill
SQL Developer
Information Technology
Nov 2010 - Oct 2012
Berkeley Heights, NJ
* Designed the Functional Requirements and Mapping Technical Specifications on the basis of Functional Requirements.
• Creating Database objects - Tables, Views, and Functions and developing procedures for implementing application functionality at the database side for performance improvement.
• Design and implementation of Security Model, Policies and Procedures.
• Performing query plans and making sure each and every query is using appropriate useful Indexes
• Creating and Modifying T-SQL Stored Procedures/Triggers for validating the integrity
• Used Performance Monitor and SQL Profiler for Monitoring memory, processor, Disk I/O, SQL Queries, other etc.
• Rebuilding Indexes and Tables as part of performance tuning exercise.
• Deployed the created SSIS packages in Development and Testing environments.
• Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse databases, data mart databases
• Generated packages using different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component and etc
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• VB.Net / C# used for Script task.
• Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created Drill-down, Parameterized and Sub-Reports using SSRS. Environment: MS SQL Server Management Studio (SSMS) 2008/2005, SQL Profiler, Index Tuning Wizard, MS SQL Server Integration Services (SSIS), MSSQL Server Analysis Services (SSAS), MS SQL Server Reporting Services (SSRS), TFS, C#.net.
C# ETL MS TFS SQL SQL Developer SQL Server SSIS T-SQL Triggers Data Warehousing Statistical Analysis Database Design Performance Tuning Data Marts Microsoft Excel Stored Procedure
Remove Skill
SQL Profiler
Jan 2005 - Jan 2008
MS SQL Server Integration Services (SSIS), Share point, C#.net, MS-Access 97- 2007, Excel, Visual studio 2008 - 2010, Visual source safe.
SQL SQL Server Visual Studio Microsoft Excel MS SharePoint
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Electrical Engineering
not provided
Skills
SQL
2021
9
SQL Server
2021
8
Performance Tuning
2021
7
Microsoft Excel
2013
6
SSIS
2021
6
Data Marts
2021
5
Data Warehousing
2021
5
Database Backups
2021
5
ETL
2021
5
SQL Developer
2021
5
Stored Procedure
2021
5
T-SQL
2021
5
Triggers
2021
5
Database Design
2014
4
.NET
2021
3
Data Modeling
2021
3
Data Replication
2021
3
MS SharePoint
2008
3
Statistical Analysis
2013
3
Visual Studio
2008
3
C#
2012
2
MS TFS
2012
2
Data Integrity
2014
1
Data Conversion
2014
1
Oracle
2014
1
SSRS
2013
1
XML
2014
1