Sql Server Data

Bhargavi

Email: **********@*****.*** Ph no: 313-***-****

Around 6+ years experience as Business Intelligence Developer using Microsoft BI framework (SQL server, SSIS, SSRS, SSAS) in various business domains including Finance, Medical, and Information Technology.

Experienced in working with SQL Query Analyzer, SQL Server Management Studio and Business Intelligence Development Studio, scheduling jobs with SQL Server Agent, SQL Server Storage Structures, Index and Security Architecture and SQL Profiler

Proficient in Database Programming and Development using SQL Server Management Studio and good experience in creating T-SQL (DDL,DML), Triggers, Views, Stored Procedures, User Defined Functions

Experienced in gathering Requirements, Design, Development and End User Training

Expertise in Performance tuning, Optimization, Data integrity and Statistics using SQL Profiler

Experienced in SDLC life cycle for Design, Development and Staging phases of the projects with support of Data-Flow, Process Models, E-R Diagrams

Experience in data warehousing including business intelligence tools- DTS, SSIS and SSRS, SSAS

Expertise in Data warehousing methodologies and concepts, including Star Schema/ Snowflake Schema, dimensional modeling

Experience in data normalization and de-normalization

Experienced in performing Incremental loads and data cleaning in SSIS. Expert in handling errors, logging through Event Handlers using SSIS

Expertise in developing Crystal reports and SQL Server Reporting Services

Expert in creating different types of reports such as drill down reports, drill through reports, parameterized reports, linked reports, sub reports using SQL Server Reporting Services

Design and Deploy Reports based on End-User requests using Web Interface & SSRS

Excellent problem solving, Interpersonal and communication skills

Technical Skills:

Databases:

SQL SERVER 2008 R2/2008/2012/2014, Oracle 11g, MS-Access and MY SQL

Programming:

C#, T-SQL, SQL, PL/SQL, ADO.NET, ASP.NET, HTML, XML

BI Tools:

SSIS, SSRS, SSAS, OBIEE

Operating System:

Windows 2008/2012 R2 Advanced Server, NT & Windows 9x, Unix

Tools:

Backup Utility, SQL LiteSpeed, Excel Power View

Network Topologies:

TCP/IP, DNS, WINS, DHCP, FTP, SFTP, SMTP

Professional Experience:

Client: Fiserv Inc. Columbus, OH Aug’15 - Till Date

Sr.BI Developer

Fiserv has been a trusted name in financial services technology for more than 30 years. Leading the digital transformation of financial services, helping financial institutions, billers and consumers move and manage money – securely, reliably and with ease – through our innovative solutions and deep expertise.

Responsibilities:

Involved in Requirements Gathering, Design, Development and Analysis

Created reports using SQL Reporting Service (SSRS) for Customized and Ad-hoc Queries

Created SSIS Packages to pull data from SQL Server to Excel Spreadsheets and vice versa including Event handling

Loading data from various sources like OLEDB, Flat files to SQL Server database using SSIS packages and created data mapping to load the data from source to destination

Successfully migrated data between different heterogeneous sources such as flat files, Excel and SQL Server 2008 R2 using SSIS, BCP and Bulk insert

Extensively used SSIS Import/Export Wizard for performing the ETL operations

Enhancing and deploying the SSIS Packages from development server to production server

Extensively used SSIS transformations such as Lookup, Derived Column, Data Conversion, Aggregate, Conditional Split, SQL task, Script task and Send Mail task

Designed, Developed and Deployed Reports in MS SQL environment using SSRS

Responsible for deploying reports to Report Server. Created and managed folder structure and folder level and report level security on Report Manager

Involved in creating multiple parameterized stored procedures which were used by the reports to get the data

Developed different types of reports such as Sub Reports, Crosstab, Charts, Matrix and Linked Reports

Developed Reports for End users using Report Builder

Environment: MS SQL Server2008 R2/2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), MS Visual Studio, Windows 2008 Server, BIDS, MS Excel, EDW, NETEZZA

Client: Sherwin Williams, Cleveland, OH

Oracle PL/SQL Developer Mar ‘14 – Aug’15

Sherwin Williams is an industry leader in Paints and Coatings. Oracle ERP is being rolled out in their Latin America region using their Global Foot Print. Supported in implementing Countries of Ecuador and Brazil.

Responsibilities:

Designed, Documented and Developed Custom EBS Objects, SQL*Loader Scripts, PL/SQL API for RICE objects. Documented Technical Specs-MD070.

Developed a PL/SQL API to Convert the Standard Open Purchase Orders into Oracle Application.

Developed a PL/SQL API to read the Matched Invoices for Custom tables and to Push to AP using Payables Open Interface.

Involved in End to End testing activities

Developed Generic Packages using PL/SQL UTL_FILE to build flat files to manage transmissions across Legacy and Oracle Systems

Involved in customization of XML/BI publisher reports like AP Open Invoices Report, AP Trial Balance Report, Open POs Report etc

Experienced in Procure To Pay (PTP) and Order to Cash (OTC) business cycles

Supported on existing PO Correction form 10g as per change requests and maintained it

Sysadmin job in registration for all Concurrent programs, Creation of Value Sets and Request Sets in test instances

Developed UPK Scripts for Account Payables, Integrated Receiving, Cash Management and Stores

Review and test completeness of sample data for UPK script development

Record and Publish UPK content for End user training

Environment: SCM, Financials, Oracle EBS R12, Oracle database 11g, TOAD, BI Publisher, UNIX, SQL, PLSQL, Clarity

Client: Integrated Medical Systems, Birmingham, AL Oct’12 –Mar’14

BI Developer

IMS is a leading surgical instrument management and clinical consulting company with facilities in Alabama, Florida, and Maryland. IMS has more than 1,200 employees nationwide in repair, clinical, technical, engineering, sales, and support roles.

Responsibilities:

Involved in Framework development for ETL Implementation and support for the Analytics and Reporting needs

Worked closely with end-users to gather requirements, understand their reporting needs and provided necessary solution

Troubleshooting DB performance issues and implementing necessary DB changes

Used tools like Execution Plan, SQL Server Profiler Database Tuning Adviser to tune the stored procedures and SQL Queries

Developed various report types such as Table Reports, Matrix Reports, Chart Reports and Dashboard Reports using Reporting Services (SSRS)

Implemented different functionalities like drill down, drill through, cross-tab, sub reports, parameterized reports in SSRS

Designed reports using SQL server reporting services (SSRS) and Excel pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports

Responsible for deploying reports to Report Server

Created SSIS packages to extract data from OLTP to Data warehouse systems and scheduled Jobs to call the packages and Stored Procedures

Developed packages using various transformations like Multicast, Conditional split, OLEDB Command, Script Component and Lookup while loading the data into Destination

Designed and implemented Dimensions and Measures per business requirements and loading data into Dimension Tables in SQL Server using SSIS Packages

Environment: SCM, Financials, OBIEE, Oracle EBS R12, Oracle database 11g, TOAD, BI Publisher, UNIX, SQL, PLSQL

Client: St Joseph Health, IBM India May’09 – Jun’12

Application Developer

St. Joseph Health (SJH) is an integrated health care delivery system sponsored by the St. Joseph Health Ministry. It is organized into three regions- Northern California, Southern California, West Texas/Eastern New Mexico. St. Joseph Health System provides a full range of care from facilities including 14 acute care hospitals, home health agencies, hospice care, outpatient services, skilled nursing facilities, community clinics, and physician organizations. I worked on the project for building the Amalga Data Warehouse which involved data load for several modules like MRI, Radiology, Pharmacy, Nursing. Meditech Data Repository(DR) is a database which stores Meditech data

Responsibilities:

Participated in Requirement Gathering and prepared the technical design document for the given BRD

Created the Stored Procedures to fetch the data from MEDITECH Servers (OLD and NEW)

Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2005

Actively participated in gathering of Requirement and System Specification

Extracting and Loading data into SQL Server Database using SSIS

Extensively used Execute SQL Task, Data flow Task, Lookup, Script logic component, Union All etc in SSIS packages

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

Worked on complex T-SQL statements, and implemented various codes and functions

Installed, authored, and managed reports using SQL Server Reporting Services 2005

Developed and optimized database structures, stored procedures, DDL triggers and user-Defined functions

Created Stored Procedures to transform the data and worked extensively in T-SQL for various needs of the transformations while loading the data

Designed, Developed and Deployed Reports in MS SQL environment using SSRS-2005

Created Parameterized Reports and Linked Reports with thorough knowledge of report server architecture (Table, Chart and Matrix Report)

Environment: SQL Server 2005/2008(Management Studio), SQL Server 2008 (Query Analyzer, Enterprise Manager, SQL Profiler, Index Tuning Wizard), IIS6.0, Data Analysis, Windows Server 2008, Windows XP, MS Access, MS Word.

Education: Bachelors in Engineering, Hyderabad, India

Contact this candidate