Sql Server Data

Prathibha Reddy Parne

Email: ac1d2v@r.postjobfree.com

Senior SQL/BI Developer Phone: 248-***-****

A Microsoft Certified Professional with around 9years of total IT experience in the Design, Modeling, Development, Implementation and Support of SQL Server 2016/2014/2012.

Expert in analyzing, designing, developing, installing, configuring and deploying MS SQL Server suite of products with Business Intelligence in SQL Server Reporting Services 2005/2008, SQL Server Analysis Services of 2005/2008 and SQL Server Integration Services.

Experience in maintaining one to many and many to one relationships while moving data between two databases.

Experience in using recursive CTEs, CTE, temp tables and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency as well as to support the existing applications.

Skilled in designing and implementing complete life cycle client servers and database applications with various development tools and languages.

In-depth understanding of security and backup procedures to ensure database integrity.

Expertise in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.

Skilled in error and event handling: precedence Constraints, Break Points, Check points and Logging.

Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.

Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.

Experience in importing/exporting data between different sources like Oracle/Access/Excel etc. using SSIS/DTS utility.

Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.

Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.

Implemented reporting (SSRS) roles (Browser, Content manager, System Administrator, Publisher and My Reports) for various business reports in Multi-user Environment.

Experience in ETL processes involving migrations and in sync processes between two databases.

Experience in Microsoft Visual C# in script component of SSIS.

Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), and SQL Server Integration Services (SSIS) (2005/2008).

Experience in creating configuration files to deploy the SSIS packages across all environments.

Expert in generating writing parameterized queries, drill through reports and formatted SQL server Reports in SSRS 2005/ 2008/2008 R2 using data from ETL Loads, SSAS Cubes and various heterogeneous data sources.

Defining data warehouse (star and snow flake schema), fact table, cubes, dimensions, measures using SQL Server Analysis Services.

Performance Oriented in Developing and Extending Cubes, Dimensions and Data Source Views, Data Mining Models, and Deploying and Processing SSAS Objects.

Worked with report manager for deploying the reports across all the environments.

Expertise in using global variables, expressions and functions for the reports with immense experience in handling sub reports in SSRS.

Strong Experience in creating Ad Hoc, parameterized reports, Linked reports, Snapshots, Drilldown and Drill through reports using SQL SSRS 2005/2008.

strong work experience as Business Objects Developer.

Ability to handle Multiple tasks, Initiative and Adaptable. Self-motivated, organized team player with strong problem solving and analytical skills and total commitment to the organization goals.

Good ability to quickly grasp and master new concepts and technologies.

Technical Summary

DBMS/RDBMS: MS-SQL Server 2014/2012/2008R2, Teradata V2R5/R6/R12/R13, Oracle 10g, PL/SQL, MS Access, DB2.

ETL: SQL Server Integration Services (SSIS), Data Transformation Services (DTS) and T-SQL Stored Procedures, PowerPivot, Power BI

Programming Languages: T-SQL, PL/SQL, C, C++, C#, Python, VB.Net, HTML, XML, Java, WCF

Tools: Microsoft SQL Server Business Intelligence Development Studio (BIDS), Microsoft SQL Server Management Studio Visual Studio, Rational Rose, NET Beans, Toad 4.0 and Eclipse, Red Gate SQL Compare, Cosmos, Microstrategy.

Data Modeling: Microsoft Visual Studio 2012/2008 and SSAS.

Operating Systems: Windows server 2008/2003/NT, Windows XP/Vista, Windows 7, Windows 8, UNIX and Linux.

Office Tools: MS word, MS Excel, Power Point, and Visio.

Design Methodology: Unified Modeling Language using Rational Rose

Domain Expertise: Health Care, Finance services, Insurance, Mortgage and Banking.

Source Control: Team foundation server 2010 (TFS), Visual Source Safe 2005 (VSS).

Bachelors in ComputerScience JNTUniversity,India.

Microsoft Certified Technology Specialist -Microsoft SQL Server 2008 Business Intelligence (SSIS, SSRS, SSAS) Development and Maintenance.

Global Lending Services LLC focuses on providing franchised dealers and their customers with the highest level of service and value. GLS leverages established national distribution channels and its deep understanding of consumers’ and dealers’ needs to deliver clear financing solutions quickly and efficiently. GLS takes an approach to subprime lending that serves the unique needs of customers who have experienced difficult times while respecting dealerships’ need for a lending process that enhances their ability to operate profitably

Responsibilities:

Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.

Maintained data integrity by performing validation checks.

Responsible for creating the reports basing on the requirements using SSRS.

Administered and enhanced SQL Server Integration Services (SSIS) data loads.

Imported data from various sources into a staging area, merges the data into the OLTP data model, and presents it to all levels of the over-600 users.

Deployed the generated reports on to the server.

Formatted the reports using the Global variables and expressions.

Optimized Queries, Tuned and Monitored server performance.

Create Parameterized SSRS Reports and ETL packages .

Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using CONTROL-M.

Utilized SSIS (SQL Server Integration Services) to produce a Data Mart for reporting.

Involved in Fine tuning of database objects and server to ensure efficient data retrieval.

Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies.

Developed SSIS solution for developing a full-fledged data warehouse solution

Developed, monitored and deployed SSIS packages.

Assisted in migrating denormalized report DB into a Star Schema design.

Environment:

MS SQL Server 2014, Microsoft Azure,MS SQL Server Reporting Services (SSRS/2016), MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS), T-SQL, PL/SQL, Visual Studio

2008/2010, BIDS, Windows 2008 Server,ASP.NET 4.0, C#, .Net Framework, IIS, ADO.NET,Visual Source Safe(VSS), XML, HTML, Java Script

The Fulton County School System is one of the most unique school systems in the nation. Though not Georgia's largest school system in terms of student enrollment, it is, however, one of the largest systems in geographic area. As the fourth largest school system in Georgia, Fulton has more than 12,000 full-time employees, including more than 6,800 teachers and other certified personnel, who work in 100schools and 14 administrative and support buildings.

Responsibilities:

Designed and developed SSIS Packages to extract data from various data sources SAP Database and flat files into SQL server 2012/2008 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge, Data stage and union all.

Excellent knowledge of using variables and expressions in packages of SSIS.

Worked on creating dynamic SSIS packages to load the data based on the file definition of a particular file.

Created batch jobs to automate the SSIS packages.

Worked on developing Tables, Indexes, Views, Creating complex stored procedures, Triggers, Functions.

Involved in gathering business requirements from clients about the credentials needed to access their servers, firewall settings and management about the table structures that are to be defined and the data structure that is to be collected from the clients.

Implemented the Master Child Package Model for easier maintenance and better performance of SSIS Packages.

Designed Enterprise reports using SQL Server Reporting Services (SSRS 2008/2012)

Involved in Migration of from SQL Server 2008 to SQL Server 2012

Created Report Snapshots to improve the performance of SSRS.

Analyzed the data to implement incremental load.

Implemented Slowly Changing Dimension (SCD) type 2 to maintain Historical Data

Used agile methods to promote a disciplined project management process that encourages frequent inspection and adaptation.

Attended functional testing and user acceptance sessions and worked on the feedback provided by them.

Environment:

MS SQL Server 2012,MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS), T-SQL, PL/SQL, Visual Studio

2008/2010, BIDS, Windows 2008 Server,ASP.NET 2.0, C#, .Net Framework, IIS, ADO.NET,Visual Source Safe(VSS), XML, HTML, Java Script.

The International Finance Corporation (IFC) is the largest global development institution focused exclusively on the private sector. We help developing countries achieve sustainable growth by financing investment, mobilizing capital in international financial markets, and providing advisory services to businesses and governments

Responsibilities:

Involved in Planning, Defining and Designing data based on business requirement and provided documentation.

Designed the ETL process based on the schemas (snow flake and star schema) for extraction and transformation of data from the source data base and loading on to the target data base.

Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data into SQL Server RDBMS (relational database).

Also designed and developed PL/SQL scripts for loading data into the Relational Oracle Database (RDBMS).

Worked on BIDS for improving the cube efficiency making it more programmable.

Maintained the table performance by following the tuning tips like Normalization and Creating Indexes.

Involved in creating report specification by Tele-conferencing with end users

Modified the existing SQL Server SSIS packages to meet the changes specified by the users.

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

Environment:

MS SQL Server 2012, MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS), T-SQL, PL/SQL, Visual Studio

2008/2010, BIDS, Windows 2008 Server,ASP.NET 2.0, C#, .Net Framework, IIS, ADO.NET,Visual Source Safe(VSS), XML, HTML, Java Script.

HP Enterprise Business (EB) incorporates HP Technology Services, Enterprise Services (an amalgamation of the former EDS, and what was known as HP Services), HP Enterprise Security Services oversees professional services such as network security, information security and information assurance/ compliancy, HP Software Division, and Enterprise Servers, Storage and Networking Group (ESSN).

Responsibilities:

Involved in Creation of tables, indexes, sequences, constraints and created stored procedures and triggers which were used to implement business rules.

Developed various SSIS Packages using Stored Procedures and Complex SQL Queries

Created ETL packages using Heterogeneous data sources (SQL Server, ORACLE, Flat Files, Excel source files, XML files etc) and then loaded the data into destination tables by performing different kinds of transformations using SSIS

Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table.

Used Event Handlers for Custom Logging using Complex Store Procedures for various events (On Warning, On Pre and Post Execution, On Task Failed etc)

Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks and re-indexing

Did lot of Performance Tuning by using unblocking Transformations and row transformations for better Performance of SSIS packages.

Experience in SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts

Worked on Huge Data Transfers from & to SQL Server Databases using SSIS, and used configuration files and Environment variables for production deployment

Deployed Packages on both file system and SQL Server MSDB across Development, Test, Production using bat files and Execution Utility

Extensively involved in SQL joins, sub queries, tracing and performance tuning for better running of queries

Worked on Dimensional DataModelling using Star and snowflake schemas for Fact and Dimension tables

Developed OLAP Cubes by using SQL Server Analysis Services (SSAS), worked on Performance tuning of SSAS Cubes

Extensively involved in the SSAS storage and partitions, and aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.

Created various reports with drilldowns, drillthroughs, calculated members, and dropdowns from the cubes by connecting to Analysis server and SQL Server from SSRS.

Developed the User Interface by using ASP.Net 2.0 by implement Grid View and Wizards.

Provided documentation about database/data warehouse structures and Updated functional specification and technical design documents.

Responsible for maintaining the integrity of the SQL database and reporting any issues to the database architect.

Assisted in mining data from the SQL database that was used in several significant presentations.

Assisted in offering support to other personnel who were required to access and analyze the SQL database.

Environment:

MS SQL Server 2005/2008/2012, MS SQL Server Reporting Services (SSRS), MS SQL ServerIntegration Services (SSIS), MS SQL Server Analysis Services (SSAS), T-SQL, PL/SQL, Visual Studio

2008/2010, BIDS, Windows 2003/2008 Server,ASP.NET 2.0, C#, .Net Framework 2.0, IIS, ADO.NET,Visual Source Safe(VSS), XML, HTML, Java Script

Courts of common pleas are PA Courts of general Trial. These courts handle both civil and criminal matters. But the phase of the CPCMS will only incorporate those processes that are related to criminal matters. This court has both original and appellate jurisdiction. In Original jurisdictions courts will hear and decide a matter before any other court can review the matter. In appellate jurisdiction court will review and revise a lower court's decision.

Responsibilities:

Write T-SQL statements for retrieval of data and Involved in performance tuning of TSQL queries and Stored Procedures.

Creating joins and sub-queries for complex queries involving multiple tables.

Optimized query performance by creating indexes.

Using DDL and DML for writing triggers, stored procedures, and data manipulation.

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

Requirement gathering and creating mapping specs.

Created various SSIS packages which would load raw physical data in to the tables of the databases.

Created Clustered Indexes and Non-Clustered Indexes to increase the performance of database.

Designed, implemented and maintained UNIX-based custom statistics collection package.

Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Merge and Send Mail task etc.

Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2005/2008.

Used spreadsheets for reporting server.

Used Erwin tool.

Developed and tested system maintenance tasks such as Database Backup and Recovery, Database mirroring and replication.

Extensively worked on data extraction, Transformation and loading data from various sources like Oracle, SQL Server and Flat files.

Created parameterized reports, Drill down and Drill through reports using SSRS.

Worked on formatting SSRS reports using the Global variables and expressions.

Using Team foundation server 2010.

Assign permission to user(s), role(s) and object. Administrate security for server’s logins

(Windows and SQL server account).

Environment: Windows 2007 enterprise,SQL Server 2008/2005,SQL Integration Services(SSIS), Business IntelligenceDevelopment Studio, Visual Studio 2008/2005,Team Foundation Server(TFS),Crystal Reports.

WellPoint is the nation’s leading health benefits company serving the needs of more than 33 million medical members nation-wide. WellPoint is also a Blue cross or blue shield licensee in 14 states

Project Description:

WellPoint EDW providing an efficient and consistent data intake process for RHI Rule and Message processing for all WellPoint programs that require RHI analytics

Integrate RHI analytics within the EDW to facilitate application of RHI analytics across the entire population covered by WellPoint inclusive of RHI rule results, message results and Physician Quality Profiling results. Once the results of RHI analytics are contained within Edward, all WellPoint business units will have access to the analytic results and messages for use in initiatives aimed at improving the quality and cost effectiveness of care.

Perform RHI analytics, on a more timely and efficient basis scaled to support the entire WellPoint enterprise book of business and the increasing volume of WellPoint programs.

Responsibilities

Involved in complete SDLC, which includes requirement gathering, analysis and design.

Involved in the Data modeling, Physical and Logical Design of Database

Involved in Developing Stored Procedures, functions and Triggers using T-SQL.

Implemented Horizontal Partitioning to improve the performance.

Responsible for outputs changes in data model.

Involved in developing packages for transferring the data.

Created stored procedures for Application Developers and some user defined functions.

Created SQL scripts for tuning and scheduling.

Performed data conversions from flat files into a normalized database structure.

Defined Check constraints, Business Rules, Indexes, and Views.

Worked on DTS Package, DTS Import/Export for transferring data from Heterogeneous

Data migration (import & export BCP) from Text to SQL Server.

Wrote BTEQ scripts to transform data.

Wrote Fast export scripts to export data.

Involved in migration projects to migrate data from data warehouse on Oracle/DB2 and migrated those to Teradata.

Regularly monitored the system for bottlenecks (CPU, RAM, Disk IO and Networking).

Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.

Performed development support, document reviews, test plan, integration of the system.

Creation/ Maintenance of Indexes for fast and efficient reporting process.

Managing historical data from various heterogeneous data sources.

Decomposing the crystal reports moving the reports from crystal reports 2008 to SSRS2 2008 R2

Environment: SQL Server 2005/2008/2012, T-SQL, SQL Server 2008 Reporting Service, VB.Net, VSS, Windows 2000 Server, Enterprise Manager, Query Analyzer, SQL Profiler, Oracle,. MLOAD, TRUMP, FAST LOAD, FAST EXPORT.

Project: Internet Shipping.

Anderson Merchandisers is largest distributors of movies, music, books and Magazines for

I was involved in the development of internet shipping. Internet Shipping Application is used to generate shipping labels for orders from internet retailers that will be shipped to end-consumer homes.

The purpose of this application:

●Verify that the correct units have been picked and allocated to the shipment

●Select the cheapest carrier for a the order’s service type (“rate shop”)

●Create a shipping label for the package and enter a record in the carrier’s manifest

●The application is currently using 3-rd party applications for rate shopping and shipping: Connect Ship is used to rate and ship all.

Responsibilities:

Involved in Planning, Defining and Designing data based on business requirement and provided documentation.

Designed the ETL process based on the schemas (snow flake and star schema) for extraction and transformation of data from the source data base and loading on to the target data base.

Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data into SQL Server RDBMS (relational database).

Also designed and developed PL/SQL scripts for loading data into the Relational Oracle Database (RDBMS).

Worked on BIDS for improving the cube efficiency making it more programmable.

Maintained the table performance by following the tuning tips like Normalization and Creating Indexes.

Involved in creating report specification by Tele-conferencing with end users

Implemented SSAS to build cubes which were made available to business users who can browse the data using a variety of tools, making ad hoc analysis an interactive and analytical process rather than a development effort.

Implemented Power Designer for analysis of the extracted data prior to loading of data into destination staging area.

Tracked the deployments and proceedings of their status through MS SharePoint.

Modified the existing SQL Server SSIS packages to meet the changes specified by the users.

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

Designed, Developed and Deployed reports in MS SQL Server 2008 environment using SSRS.

Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SQL Server SSRS.

Created reports to retrieve data using Stored Procedures that accept parameters.

Generated various reports using SSRS 2005.

Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard.

Fine tuned SQL Queries for maximum efficiency and performance.

Generated necessary documentation through MS Word and Flow charts with MS Visio.

Generated SQL for views from query subjects in Framework model.

Designed and implemented Stored Procedures for automating tasks.

Environment: MS SQL Server 2005/2008, SQL Reporting Services (SSRS), SQL Integration Services (SSIS), MS SQL Server 2008, Ms Access2007, Office2007, Windows Server 2003.

Contact this candidate