Bhagavat Geetha

Mobile: 516-***-****

ad09o3@r.postjobfree.com

Summary:

•Over 6 Years of IT experience which includes System Analysis, Design, Development and Support for MS SQL Server 2008, 2016 and 2017 in Development, Testing and Production Environments in domains like Finance

•Expertise in creating SSIS packages for integrating data from various data providers to SQL server database using SSIS 2008 and SSIS 2005

•Expertise in ETL process (Data Extraction, Transformation and Load) with DTS/SSIS, Bulk Insert, BCP

•Expert at configuring the report server using reporting services configuration manager and creating various types of complex reports using SSRS 2008/2012

•Expertise knowledge and experience in deploying SSIS packages and SSRS reports to DEV, TEST and PROD Server

•Highly experienced in SQL Server and T-SQL in constructing Tables, Views, User Defined Functions, Triggers, Stored Procedures, Cursors and Indexes

•Highly proficient in high level design of ETL SSIS packages for integrating data from heterogeneous sources such as MS Excel, Oracle, XML, Flat file, Text Format Data to MS SQL Server

•Experienced in database upgrade from SQL server 2005 to SQL server 2008 and SQL server 2008 to SQL server 20017

•Experienced in Microsoft Visual C# in script component of SSIS

•For Loop container, For Each Loop container, Execute SQL task and Data Flow tasks were used extensively as part of ETL packages.

•Experienced in working with different phases of SDLC such as Analysis, Design, Coding, Testing, Implementation and Maintenance

•Excellent knowledge about various stages of MIS (Management Information System) and Business Accounting

•Experienced in creating Clustered and Non-clustered Indexes on tables to improve performance of database

•Proficient in using Profiler for both performance and auditing purposes

•Excellent interpersonal skill, result oriented, hard working with quest and zeal to learn new technologies

•Experienced in working with AWS Redshift by converting the SQL Server scripts to Redshift.

Education Qualifications:

Bachelor of Technology in Computer Science

Skill Set:

MS SQL Server 2008/2016/2017, SQL Server Management Studio, SSIS, SSRS, T-SQL, MS Visual Studio 2003/2005/2008, XML, HTML, Windows 2008/2010 Server, UNIX, MS Office, AWS Redshift, C#

Certifications:

AWS Certified Developer Associate Oct 7th 2020 – Oct 7th 2023

Programming in C# Jan 19th 2021

Project Summary:

Broadridge Financial Solutions, Brentwood, NY

04/2018-Present

BI Developer

Broadridge Financial Solutions, Inc. is a US servicing company for the financial industry as a spin-off from Automatic Data Processing. The project had different team tracks which include developing, testing, and deploying advanced SSIS packages, advanced stored procedures, and complex T-SQL queries and scripts. It also includes designing schemas, tables, and views.

Responsibilities:

•Involved in planning, defining, designing, and developing data, based on business requirements with Business Analyst, Team Leader, and Project Manager

•Involved in scheduling the Requirement Review Meetings with Business Analysts after studying the BRD

•Involved in preparing a Technical Specification document showing all the necessary steps to be taken for the project and scheduling Technical Design meetings with the team leader and manager

•Involved in installing and configuring MS SQL Server 2017

•Developed very complex and advanced SSIS packages to serve the purpose defined in the Technical Specification document

•Modified existing SSIS packages to meet the changes requested by the business

•Implemented proper Logging, Configuration, Error Handling, and Event Handling in every SSIS package

•Developed SSIS packages for integrating data using OLEDB connection from heterogeneous sources (Excel, CSV, flat file, text format data) and SQL databases by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Merge and Union All, Lookup, Derived Columns, Row Count, For Loop container, For Each Loop container, Sequence Container

•Designed new schema, tables, views, field definitions and mappings, indexes/constraints, stored procedures, and SSIS configuration scripts

•Developed complex stored procedures with logging and error handling and also modified existing stored procedures to eliminate cross server joins

• Involved in cleaning up and archive the redundant data from production server

•Maintained the performance of tables by applying Clustered and Non-clustered Indexes and Normalization

•Worked as a Developer in the team for designing and developing the applications using Microsoft advanced technologies MSFT Visual Studio .Net, C# and ASP.NET3.0

•Developed the packages using Microsoft Visual C# in script component

•Developed the classes using C#, which incorporate N-tier architecture and database connectivity

•Used ADO.NET to access data from database in a web application

•Performed T-SQL tuning and optimization of queries that take longer execution time

•Scheduled jobs for executing the stored SSIS packages which were developed to update the database on daily basis

•Developed Amazon Redshift functions. Knowledge in converting SQL Server scripts to Redshift scripts using PostgreSQL

•Created the external tables in Amazon Redshift which defines the table columns, the format of the data files and the location of the data in Amazon S3

Environment: MS SQL Server 2008/2017, SSIS 2014, C#, Amazon Redshift, Amazon S3

T-Mobile, Bensalem, PA 03/2017-04/2018

BI/SQL Developer

The project was about developing and implementing database and providing support thereby increasing the performance of the database.

Responsibilities:

•Wrote complex T-SQL queries, Stored Procedures and Triggers to build specific logic according to business requirements. Implemented check constraints, referential integrity and provided additional application functionalities

•Optimized the performance of queries with modification in T-SQL queries, eliminated redundant and inconsistent data, established joins and created Indexes wherever necessary

•Wrote and updated T-SQL stored procedures according to business requirements and automated them with SQL Jobs

•Wrote complex statements with extensive use of joins, subqueries and correlated subqueries

•Used SSIS to create ETL packages to validate, extract, transform and load data to data mart and data warehouse

•Created packages using Integration Services (SSIS) for extracting data from Flat Files, MS Excel files, OLEDB, MS Access etc. to SQL Server

•Implemented Event Handling and Error Handling in SSIS packages and notified process results to various user communities

•Migrated DTS packages to SSIS 2012 and modified the existing packages accordingly by using features such as Script Component, Script Task, Lookup, Derived Columns, Condition Split, Union All, Copy Column, Aggregate and Audit Transformation

•The Email feature was implemented for sending notifications for SSIS jobs to concerned people to notify about the execution and status of packages

•Wrote complex T-SQL Stored Procedures, Functions and Triggers to carry out various tasks

•Used SQL Profiler for tracing and debugging the T-SQL scripts.

•Analyzed database performance with SQL Query Manager and optimized Indexes to significantly improve queries.

Environment: MS SQL Server Management Studio 2014, SQL Profiler, Index Tuning Wizard, MS SQL Server Integration Services (SSIS) 2012/2014

Arrow – The policy processor, Hyderabad, India 09/2013-01/2015

MS SQL Server Developer

This project has been initiated to reduce the turnaround time to market, by providing client one of the most powerful features of the product, which is configurability. Using this feature client can configure and customize new products, rules, etc. without depending on the vendor. This project handled most complex product setup design that includes complex product rules by adhering to configurability. These products are spread over different lines of businesses like LIFE, Critical Illness (CI), Disability Illness (DI) and Long-Term Care (LTC).

Responsibilities:

Created Functions, Stored Procedures, Triggers, Cursors, Indexes and Views using T-SQL in different environments with SQL Server 2008

Validated change requests and made appropriate recommendations. Standardized the implementation of data

Involved in developing DTS Packages to transfer the data between SQL Server and other databases

Wrote and optimized Triggers, Stored Procedures and Queries in T-SQL

Involved in resolving Deadlock issues with the database using various Deadlock Resolution Techniques

Involved in designing, developing and modifying various reports based on business requirements

Built and performed user acceptance testing on modified reports

Performed requirement gathering from the users according to the business requirements

Analyzed business requirements and built logical data models that can describe all the data and relationship among the data

Documented the data using Entity Relationship Diagram, file definition, description and attributes

Involved in designing and developing various service management reports, utilizing Dynamic and Cascading Prompts, Sub-reports, Charts, Parameterized reports, Conditional and Dynamic reports

Designed, developed, and tested complex queries including joins, sub queries in SQL Server 2008

Environment: MS SQL Server 2008, Oracle 9i, MS Access, MS Excel, MS Visio 2010, CA Erwin Model Manager

Contact this candidate