Data Ssis

Savitri Bhattiprolu

Phone: 615-***-****

Email: ******************@*****.***

SUMMARY:

• 8+ years of experience implementing Business Intelligence solutions using MS SQL server 20017/2014/2008 databases and Tableau 10.x/9.x

• Designed Physical and Logical DB models for Data warehouse using Erwin Modeler

• Expertise in creating SSIS Packages for Data Migration from several sources like SQL Server, UDB DB2 and Flat file

• Strong Data warehousing concepts include Slowly changing Dimension, Star & Snowflake schema

• Experience in Code Optimization and Improving Efficiency in databases including Re-indexing, Updating Statistics, Recompiling Stored Procedures and performing other maintenance tasks

• Experience in writing and debugging Cursors, stored procedures, Functions and Triggers

• Experience in creating Jobs, Alerts, SQL Mail Agent and schedules

• Used VSS (Visual Source Safe) & TFS (Team Foundation Server) for versioning

• Strong background in software development life cycle (SDLC) process and has excellent analytical, programming and problem-solving skills

• Good with people management, especially in onsite-offshore model

• Excellent Communication and interpersonal Skills when working with developers, project managers and application end-users

TECHNICAL SKILLS

RDBMS: SQL Server 2014/2008/2005

Data Modeling: ERWIN Modeler

BI Tools: Tableau 10.x/9.x, SQL server SSIS, SSRS SQL Utilities: SQL Server Management Studio, BI Development Studio/SS Data Tools, Query Analyzer, SQL Server Profiler, Index Tuning wizard, Visio Backup Tools: Redgate & SQL Lite Speed

Languages: T-SQL, Shell Scripting

Operating System: Windows & UNIX AIX

Web Technologies : HTML, DHTML, Java Script

1. Multiple Applications

Project Title DAPR

Employer HCL Global solutions, MI

Client Follett, Westchester IL

Duration Jan-2020 to till date

Role BI Consultant

Tools SSIS, SSRS

Database SQL server 2017

Project Description:

Follett specializes in campus bookstore chain offering new, used & digital textbooks, plus school- branded merchandise

Responsibilities:

• Create Stored procs and SSIS packages for loading data to Data warehouse.

• Deploying SSIS packages, config files to QA and Prod

• Helped QA set up environment for testing our packages

• Build complex SSRS reports for Finance reporting.

• Responsible for testing & migration of packages from QA to Prod

• Responsible for deployment and migration of self-service Tableau Reports 2. AWR

Project Title AWR

Employer HCL Global solutions, MI

Client RR Donnelly, Warrenville, IL

Duration Jan-2017 to Sept-2019

Role BI Consultant

Tools SSIS, Tableau 9.x/10.x, SSRS

Database SQL server 2014/2008 R2

Project Description:

AWR (American Water Resource) is one of the leading companies which supplies different products mainly Water to the people in their area throughout US. RRD helps AWR in maintaining the details related to their transactions and helps them in maintaining and printing the mails that they need to send to the AWR customers. They also maintain data related to the new prospects and mail them when AWR wants them to be based on different campaigns.

Responsibilities:

• Support other Development teams in performance turning and setting up partitioning, Create Stored procs and SSIS packages for loading data from ODS to Data warehouse.

• Deploying SSIS packages and config files to QA and Prod

• Good with unit testing of SSIS packages and helped setting up test cases.

• Identified Index defrags, re-indexing and identifying key columns for adding indexes

• Developed/Enhanced many Stored Procedures, Triggers, CTE, Cursors, SSIS packages

• Created and managed DB objects such as tables, views, stored procedures, and triggers.

• Performance tuning and applying security plays a very important role in my day to day activities.

• Used various sources like SQL Server, Flat file, Xlxs, etc while loading the data into different databases through SSIS

• Responsible for testing & migration of packages from QA to Prod 3. Unica Application

Project Title Unica

Employer HCL Global solutions, MI

Client CDW, Vernon Hills IL

Duration Oct-2013 to Jan-2017

Role Business Intelligence Developer

Tools SSIS

Database SQL server 2008R2

Project Description:

Some of the CDW Purchase and shipment data is saved to IBM systems called Unica. Project is to get this data from IBM and integrate it with the existing Enterprise Data Warehouse. Project included creating new Purchase and shipment subject areas in the warehouse and creating report from EDW. Responsibilities:

• Responsible for requirement gathering from business to create package specs

• Create SSIS packages to load data from Flat files, spreadsheets to SQL Server

• Developing/Enhancing SSIS packages, stored procedures, triggers, and functions to maintain application integrity

• Migrated SSIS Packages and scripts to QA and provided business and test plans

• Created Data Marts for individual subject areas

• Performance tuning and applying security is part of job responsibility

• Created and managed DB objects such as tables, views, stored procedures, and triggers.

• TFS is used as version control tool

4. KRONOS Application

Project Title KRONOS Application

Client IntelliGroup Aisa Pvt Ltd, Hyderabad

Duration Jan 2008 to Aug 2010

Tools DTS, SSIS

Role Software Engineer

Database SQL server 2005/2000 & UDB DB2

Responsibilities:

• Created several SSIS Packages to pull data from SQL server and Flat files into UDB DB2 and to archive the data as per the business logic.

• Identify unused data that can be archived and set-up an auto archiving process that will reduce the size of the database using Data Transformation Services

• Identify a number of inefficient system queries that affect performance

• Managed various issues like the Orphan user and transfer of logins etc., during the process of migration of SQL server 2000 to SQL server 2005.

• Created and managed DB objects such as tables, views, stored procedures, and triggers.

• Tested the application on various builds of SQL Server and identified the correct build without compromising on the performance.

• Created a Disaster Recovery Strategy and deployed database backup process that will send notification if process fails

• Implemented package security using various techniques including configuration files and SQL tables. Implemented the SQL login Security for developers and users. EDUCATION

Masters in Computer Applications -India (2004-2007)

Contact this candidate