Resume

Sign in

Sql Server Data

Location:
Irving, Texas, United States
Posted:
May 15, 2019

Contact this candidate

Resume:

JYOTHI KATTA

Mail to: ac9dwv@r.postjobfree.com

Phone: 704-***-****

Professional Summary:

More than 6 years of IT experience in complete Software Development Life Cycle and Agile Methodologies including Requirement Analysis, Design, Development, testing, Implementation.

Strong Expertise in SQL Server 2005/2008/2012 components such as SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services)

Adept at interfacing with end users to gather requirements and produce functional requirements, Ample knowledge of Relational Database Management Systems (RDBMS) & Entity Relationship Diagram (ERD).

Experience in Migrating SQL 2005 databases to SQL 2008 and SQL 2012.

Expert in creating indexes, Views, complex Stored Procedures, user defined functions, cursors, common table expressions (CTEs) and Triggers to facilitate efficient data manipulation and data consistency.

Experienced on subscriptions, report snapshot and report cache.

Expert in Extracting and Transforming data using SSIS in SQL Server 2005/2008/2012, SQL Server Import Export Wizard, Bulk Insert Task and Bulk Copy Program (BCP).

Experience in Importing/Exporting Data from various data sources like Excel, Oracle, DB2 and Flat file.

Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS 2005/2008/2012) generated drill down reports, parameterized reports, linked reports, sub reports in SSRS 2005/2008/2012 using Tabular format.

Communicated with multiple business groups to design and develop reports using Microsoft Reporting Services

Experienced in automating the system by using Notification service and creating alerts, jobs and maintenance plans.

Experience in building Data Integration and Workflow Solutions and Extract, Transform, and Load (ETL) solutions for data warehousing using SQL Server Integration Services (SSIS).

Expert in customizing SSIS Script Task and Script component using c#.net

Will work "hands-on" when required but understands the value and importance of delegating work and responsibilities.

Proficient in High Level Design of ETL DTS Package for integrating data from heterogeneous sources.

Quick learner, excellent communication skills and good performer both in team and independent job environments.

Have extensive domain knowledge in Health Care insurance and Retail.

EDUCATIONAL PROFILE:

Master of Computer Applications from JNTU, Hyderabad

SKILL SETS:

MS SQL Server 2005/2008, SQL Server 2012, SQL Server 2014, SQL Server 2016, Visual Studio, SSMS, BI tools (SSRS, SSIS, SSAS), Bulk Copy program (BCP), SQL Server Data Tools, Windows NT/2000/2003/XP/VISTA/2008, Windows 7, HTML, XML, Internet Information Server (IIS), MS Office.

SUMMARY OF PROJECT EXPERIENCE:

Verizon, Tampa, USA . September 2017 to March 2019

MSBI Lead & developer

Project Description: Reverse IRB PCCIO

DataShare is an ongoing Corporate Finance transformational initiative that drives the One Verizon Customer View of accounts across the VZT, VES, and VZW platforms by employing methods of linkage based on proprietary relationships, key account attributes, and Equifax products. Since its introduction in 2007, DataShare has become the foundation for overarching credit assessment and recovery processes; streamlined functions for refund, bankruptcy, and fraud processing; and on-demand reporting for One Verizon Customer performance.

As part of this project, the Datashare application is integrating the data from all other applications and loading into the SQL server database like iCollect, iFinals and Rmicw for the converted accounts from NPD to VISION and process the balances and account activity to show on Datashare application.

Responsibilities:

Extensively involved in designing the integration part to flow the data form one system to another by interacting with the business users from multiple systems.

Extensively involved in design of AWS servers of test and UAT environment and designed the ETL data model based on the existing database table structures

Coding of SSIS Packages to migrate data from various sources and loading them into SQL Server Database.

Performed Unit testing of the SSIS extract packages and also building validation packages to check the accuracy of the data migrated.

Designed and developed the Power Bi solution for reporting and dashboard creation.

Performance tuning of stored procedure, SSIS Packages and reports and Wrote complex join queries using T-SQL.

Used various SSIS data flow transformations, such as Data Conversion, Conditional Split, Derived Column, and Lookup which were used for Data Scrubbing and Data Validation Checks during staging, before loading the data into Data Warehouse.

Created and modified Stored Procedures, Functions, and Indexes.

Created SQL Server Jobs and Schedules for automated and timely execution of Daily, Weekly and Monthly processes and scheduled.

Environment: SQL Server 2012, TFS, Microsoft Visual Studio 2012, T-SQL, SSIS, SSRS.

Macys, Atlanta, USA . Aug 2015 to September 2017

MSBI developer

Project Description: Big Ticket Merchandising Reporting

The automatic re-calculation tool will process the ROF adjustments based on the filters selected and ROF adjustments entered by the Inventory Planners. The main benefit of the automatic re-calculation tool is a reduction in manual processing, an immediate output/view of the adjustment impact and timelier and more accurate ROF projections.

The scope of the project is key ROF components of the C1 Report which the Inventory Planners analyse closely each week in order to provide timely and accurate dollar and unit projects to MLO in total as well as by DC Location.

Roles and Responsibilities:

Extensively involved in creating SSIS Packages to migrate data from various sources and loading them into SQL Server Database.

Played major role on production support (operations) running and scheduling jobs, backups and so on.

Involved in SSIS Package creation from package design documents to package build.

Involved in Unit testing of the SSIS extract packages and also building validation packages to check the accuracy of the data migrated.

Performance tuning of stored procedure, SSIS Packages and reports.

Wrote complex Join queries using T-SQL.

Used various SSIS data flow transformations, such as Data Conversion, Conditional Split, Derived Column, and Lookup which were used for Data Scrubbing and Data Validation Checks during staging, before loading the data into Data Warehouse.

Created Test packages to validate the SSIS packages build.

Created and modified Stored Procedures, Functions, and Indexes.

Experience in configuration of report server and report manager scheduling in SQL Server Reporting Services (SSRS).

Created SQL Server Jobs and Schedules for automated and timely execution of Daily, Weekly and Monthly processes.

Environment: SQL Server 2012, TFS, Microsoft Visual Studio 2012, T-SQL, SSIS, SSRS.

BELK, Charlotte, USA. Jan 2013 to Aug 2015

SQL Server/SSIS/SSRS Developer

Project Description:

This project will involve the data integration from transactional database to analytics database and prepare the reports out of that for the business to make decisions and daily processing.

Roles and Responsibilities:

Implemented triggers and stored procedures and enforced business rules via checks and constraints.

Created indexes on selective columns to speed up queries and analysis in SQL Server Management Studio.

Worked on querying data and creating on-demand reports in SSRS reports and send the reports via email.

Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.

Created Parameterized, Drill-down and Sub-Reports using RDL. Promoted RDLs to Reporting Service Server.

Worked on SQL Server Upgrade from 2008R2 to 2012.

Migrated SSRS reports from 2008 to SSRS 2012.

Defined the logging process for all the packages, populated it with entries like inserted record, updated record and error record.

Scheduled the SSIS packages and Jobs

Designed SSIS Packages to transfer data from various sources like Text Files, XML Files, Excel, Flat files to SQL Server 2008.

Extracted and reviewed data from heterogeneous sources from OLTP to OLAP using SQL Server Integration Services (SSIS).

Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.

Performed data transfers using BCP and BULK INSERT utilities.

Implemented the error threshold using precedence constraints and variables in SSIS packages using business rules as reference.

Created an automated ETL summary report which consists of the summary information for all the loading activities done each day and month.

Environment: SQL Server 2008 R2, SQL Server 2012, Microsoft Visual Studio 2008/ SQL Server Data Tools, T-SQL, SSIS, SSRS



Contact this candidate