Sql Server Data

Mahasree

Certified SQL BI Developer

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

Contact: 908-***-****

Professional Summary:

8+ years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2014/2012/2008R2/2008/2005/2000 in Development, Test and Production Environments with various business domains.

Migration of SSRS reports from SQL 2012 to SQL 2014.

Extensive experience with data modeling techniques, logical and physical database design.

Expert Knowledge of Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS).

Experience in Database Development, modeling, Data Warehousing, Design and Technical Management.

Hands on experience in Installation, Configuration and Migration of SQL Server2014/2012/2008 R2/2008/2005/2000, apply periodic service packs and hot fixes (cumulative updates) and complimentary third party tools.

Extensive experience and proficiency on the design, construction and implementation of Business Intelligence tools (Star Schema, Data-Warehouses, OLAP cubes, Partitioning and Aggregations), ETL Process (Data Extraction, Transformation layer) with DTS/SSIS, Data Cleansing, MSSQL Databases, Analysis Services (SSAS), Reporting Services (SSRS), Notification Services (SSNS) and MDX ad-hoc Reporting.

Experience in creating indexed views, complex stored procedures, effective triggers and useful functions to facilitate efficient data manipulation and consistent data storage.

Used MDX to interact with the back end OLAP Services.

Experience in Dimensional Modeling, Designing of STAR, SNOW FLAKE Schemas.

Created Reports with complex formulas and to query the database for business Intelligence.

Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.

Experience in enhancing and deploying the SSIS Packages from development server to production server.

Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).

Expert ETL design.

Expertise in migrating data from MS-Access, MS-EXCEL and other external data sources.

Experience in Creation and deployment of cubes on SSAS.

Good understanding in Oracle 9i/10g Database.

Very Good Understanding and Experience in SQL Server Integration Services(SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services(SSRS)

Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.

Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.

Experience in Analyzing Execution Plan and managing indexes and troubleshooting deadlocks.

Experience in Tuning SQL queries and T-SQL queries, MDX & improving the performance of the queries.

Worked Extensively on ETL process using SSIS package.

Experience in using variables, expressions and functions and also defining Query for generating drill down reports in SSRS.

Experience in writing complex SQL queries involving multiple table’s inner and outer joins, stored procedures.

Excellent analytical, problem solving skills and a motivated team player with excellent inter-personal skills and familiar with offshore and multi site development.

Integration Services (DTS/SSIS)

Extensive knowledge in ETL Process & Progressive knowledge in using DTS/SSIS utilities.

Experience in Extraction & Migration of Data from heterogeneous data sources like Excel, MS Access, Oracle, and DB2 to MS SQL Server by using Import Export Wizard, DTSSSIS, and BCP & Bulk Insert utilities.

Expertise in designing SQL Server SSIS packages to import and transform data between databases and external data sources.

Involvedin migrationofDTS Packages (2000) to SSIS(2005/2008R2/2012/2014) and troubleshoot migration issues.

Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.

Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.

Certification:

Microsoft Certified Professional.

Microsoft SQL Server 2008 Business Intelligence – Implementation and Maintenance.

Technical Skills:

Databases Tools

SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, SQL Server Analysis Service (SSAS)

ETL Tools

Data Transformation Services (DTS) – Export/Import, SQL Server Integration Service (SSIS)

Reporting Tools

SQL Server Reporting Services (2000/2005/2008 R2,2012,2014), MS Access, MS Excel

Database

MS SQL Server 2014/2012/2008/2005/2000, MS Access, Oracle 9i/8i

Programming

T-SQL, PL-SQL, C

Web Technologies

HTML, DHTML, XML, XSL, Java Script (Validation), CSS, PERL

Operating Systems

Windows (95/98/2000), Windows 2003/2008 Server, Windows XP, Windows Vista

Other Tools

MS Office Suite (Microsoft Word, Power Point, MS Visio), OLAP & OLTP, ERWIN, Adobe Photoshop, Abode Flash.

Professional Experience:

Client: Verizon Wireless, Alpharetta, GA 2015 Nov-Present

Sr.MS SQL Server Developer (SSAS/SSIS/SSRS)

Client Description: Verizon Wireless is a broadband telecommunications company and largest wireless communications service provider headquartered in Basking ridge, New Jersey. It is completely accompanied by Verizon. It has a huge amount of data, which are maintained in SSAS cubes and updated through SQL server SSIS packages. This project is involved with maintaining the data related to various entities in Verizon such as customer, revenue, plans, markets etc.

Responsibilities:

Involved in building cubes from scratch using Microsoft SQL Server Analysis Services (SSAS) 2008R2/2008/2012/2014

Create dimensions and members based on the business requirements and modify them accordingly whenever change control documents are updated.

Developed SSIS packages to run daily jobs in the control system and ran extracts using BCP process.

Created various ETL processes to modify the configuration files and ran batch files to run the extract files and load data into cubes.

Designed Pivot table, drill through and many other complex reports using SSRS 2008R2, 2012, 2014 for client to check the final data for reporting.

Involved in writing scripts in Teradata to export the source data into SQL database.

Created many calculated measures using MDX scripting in SSAS.

Involved in writing complex stored procedures, creating views, triggers, Joins, Constraints, DDL, DML and functions based on the requirement.

Involved in upgrading of SQL server 2008R2 to 2012 and Visual Studio 2008 to 2014.

Created usage based and normal aggregations for the cube to improve the performance.

Used SQL Profiler to monitor the performance of queries, which are causing deadlocks and made performance tuning to the databases by removing historic query list.

Designed pivot charts and provided links from spreadsheet to the database through excel for client to connect to the database to view the reports and select required data.

Modified data flow tasks in SSIS Packages to configure them with new bill cycles or any new change requests and add them to the loop containers.

Worked on automating daily jobs, monthly jobs and scheduling them in Control system.

Configured error messages of daily loads through SSIS packages and sent them manually sometimes when the notification or processing is done through BCP.

Involved in moving the fast export extract from Teradata as a source to SQL server database destination tables and views.

Created hierarchies, partitions and base measures in cube as per client requirements.

Majorly responsible for development and management of SSAS and SSIS projects

Worked very closely with Business Customers, End Users and resolved any business process related issues.

Environment: Windows server 2008, MS SQL Server-2014/2012/2010/2008 Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, OLAP, OLTP, Performance Point Sever, Office-2010, MS Excel, C#.NET, Teradata SQL Assistant 14.10, JEdit 5.0, Putty 0.60.0.0, Business Intelligence Development Studio 2014/2012/2008

Client: Garretson Group, Cincinnati, OH Feb 2014 – Sep 2015

Sr. MS SQL Server (SSIS/SSRS/SSAS) Developer

Client Description: Garretson Resolution Group (GRG) is a neutral provider of services to parties who are settling personal injury claims. Each year we resolve over 100,000 healthcare obligations for thousands of firms and companies across the country. Our Resolution & Compliance Program includes Healthcare Lien Resolution; Medicare Set-Aside (MSA); Medicare Secondary Payer (MSP) Consulting & Mandatory Insurer Reporting; and Complex Settlement Administration.

Responsibilities:

Excellent report creation skills using Microsoft SQL Server 2014 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.

Created SQL Server Reports based on the requirements using SSRS 2012,2014

Involved in analysis of Report design requirements and actively participated and interacted with Team Lead, Technical Manager and Lead Business Analyst to understand the Business requirements.

SQL Server 2014 installations, patches and upgrades, including both standalone and clustered environments of production, test and development.

Migrated DTS packages from SQL Server 2008R2 to SQL Server 2012 as SSIS packages.

Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2008R2/2008 (SSAS)

Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).

Troubleshooting performance issues and fine-tuning queries and stored procedures

Worked on OLAP Data warehouse, Model, Design, and Implementation.

Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.

Created complex reports which involve more number of groupings and multi-value parameters

Developed reports like Claim Statements, Fee Bills Transactions and some end request user reports on periodic basis.

Sound Experience and understanding of SSAS, OLAP and OLTP cube, Data mining and Architecture.

Created multiple reports with drop down menu option having complex groupings within the report.

Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).

Experience in creating complex SSIS packages using proper control and data flow elements.

Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.

Rendering the reports to PDF formats as per the requirement and printing all the reports in a batch process for Monthly Statements.

Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers

Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.

Scheduling the SSIS packages and Jobs.

Environment: Windows server 2003, IIS 6.0, MS SQL Server-2014/2012/2010/2008/2005 Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, Erwin VB.NET, OLAP, OLTP, Erwin, Performance Point Sever, Office-2007, MS Excel, C#.NET, ProClarity Analysis.

Client: Monsanto, St. Louis, MO Nov 2012– Jan 2014

SQL Server BI Developer (SSIS/SSRS)

Client Description: Monsanto Company is a publicly traded American multinational agrochemical and agricultural biotechnology corporation headquartered in Creve Coeur, Greater St. Louis, Missouri. It is a leading producer of genetically engineered (GE) seed and of the herbicide glyphosate, which it markets under the Roundup brand.

Responsibilities:

Extracting and Loading data into SQL Server Database using SSIS.

Extensively involved in designing the SSIS packages to export data from flat file source to SQL Server database.

Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2012/2008/2005(SSAS)

Created SSIS Packages to migrate slowly changing dimensions

Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).

Experience in creating complex SSIS packages using proper control and data flow elements.

Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.

Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).

Pulling data on a daily basis from OLTP database to OLAP or staging database using the SSIS packages.

Rendering the reports to PDF formats as per the requirement and printing all the reports in a batch process for Monthly Statements.

Performed the task of data transfer from files in remote server to folders in another server using FTP.

Created database maintenance plans and deleting of history data using SSIS packages.

Scheduling the SSIS packages and Jobs.

Designed SSRS 2008 reports with Cascaded Parameters, Gauges and Interactive Charts, etc.

Excellent report creation skills using Microsoft SQL Server 2012/2008/2005 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.

Created SQL Server Reports based on the requirements using SSRS 2008.

Highly responsible for development and management of PPS, SSAS, SSRS and SSIS projects.

Building KPI reports for the cubes and optimizing the reports.

Involved in partitioning of cubes in order to increase the performance of cubes (SSAS).

Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.

Created complex reports which involve more number of groupings and multi-value parameters

Using Sql server reporting services (SSRS) delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.

Design and create report models based on users’ requirements, explain and train users to use report builder to generate their own personalized reports.

Worked very closely with Business Customers, End Users and resolved any business process related issues.

Environment: Windows server 2003, IIS 6.0, MS SQL Server-2012/2008 R2/2005 Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, Erwin VB.NET, OLAP, OLTP, Erwin, Performance Point Sever, Office-2007, MS Excel, C#.NET, ProClarity Analysis.

Client: ERT, Bridgewater, NJ Jan 2011 – Nov 2012

Sr. MS SQL Server

Client Description: ERT (eResearch Technology, Inc.) is a global technology-driven provider of clinical services and customizable medical devices to biopharmaceutical and healthcare organizations. The project involved in transfer data from OLTP (Online Transaction Processing) to Global Data warehouse.

Responsibilities:

Understanding the Reporting design requirements from the Architects and Business Analyst.

Interact with SME’s and End Users for requirement gathering, process improvement, problem identification, project analysis & review meetings and progress reporting.

Designed SSIS package for automatic data migration to transform Data from SQL Server 2000 to SQL server 2008.

Understanding the OLAP processing for changing and maintaining the warehousing, optimizing Dimensions, Hierarchies and adding the Aggregations to the cube.

Responsible for Process CUBE Partitions and Dimensions.

Involved in writing MDX queries for various calculated members.

Experience in Developing and Extending SSAS Cubes, Dimensions and data source view SSAS-Data Mining Models and Deploying and Processing SSAS objects.

Used SQL Profiler for troubleshooting, Monitoring, Optimizing SQL Server and T-SQL statements from developers and testers.

Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).

Created several Dashboards and Scorecards with Key Performance Indicators (KPI) in SQL Server Analysis Services (SSAS)-2008/2005.

Well versed in defining/creating and handling Data Sources, Data Source views and parameterized Reports in SSRS 2008.

Designing OLAP cubes, Data Modeling, Dashboard Reports, and scorecards according to the business requirement.

Served as technical expert guiding choices to implement analytical and reporting solutions for complex financial scenarios.

Created/Updated Stored Procedures, Triggers, Functions, Views, and Indexes with extensive use of T-SQL.

Design and develop SSIS (ETL) packages for loading data from Oracle and Flat files (3GB) to SQL Server Database.

Created packages in SSIS with error handling as well as complex SSIS packages using various Data transformations like Lookup, Script Task, and Conditional Split, Derived Column, Fuzzy Lookup, and Partition task, For-Each loop container in SSIS; scheduled the same SSIS packages by creating the job tasks.

SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.

Participated in creating Jobs for various packages that run at specific schedule every day based on some dependencies.

Created clustered and non-clustered indexes on tables for new database to faster retrieval of data for the Reports.

Managing the Report Server contents with Admin privileges and Report Manager for Subscriptions, Snapshots and Security Content on the reports

Helped Quality Assurance Team to generate Test Plans and Test Executions.

Environment: Windows 2003 Server, SQL 2008/2005 Enterprise Edition, Import-Export (DTS), SSRS, SSAS, SSIS, OLAP, OLTP, MDX, T-SQL, ASP.NET2.0, C#.NET, ADO.NET, Microsoft Visual Studio.Net 2005, .NET Framework 2.0, EXCEL2007.

Client: Sanofi-Aventis, Bridgewater, NJ Oct 2009 – Dec 2010

SQL BI Developer

Client Description: Sanofi-aventis, a diversified global healthcare leader, discovers, develops, and distributes therapeutic solutions to improve the lives of everyone. We work to prevent and treat the diseases that we know of today, as well as those we may face tomorrow. The scope of the project was creating a database schema to perform analysis on the company performance for the past 2 years using SSAS. The project requires creating, designing and modifying reports.

Responsibilities:

Analyzed all the Database Structure and prepared a reference guide to understand the existing system better.

Created complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications.

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

Created SSIS packages to Oracle and other SQL Server instances and used configuration files and variables for production deployment.

Involved in making mappings and transformations using DTS Transform Data Task, Data Driven Query Task.

Scheduled SSIS Packages for loading Facts and Dimensions.

Created packages in SSIS with error handling.

Worked with different methods of logging in SSIS.

Experience in creating complex SSIS packages using proper control and data flow elements

Involved in updating slowly changing dimensions’ strategies.

Designed cubes with star schema using SQL Server Analysis Services (SSAS).

Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.

Designed and built OLAP cubes to meet reporting needs.

Responsible for identifying and defining Data Source and Data Source views.

Created cubes and defined the dimensions.

Responsible for defining calculated members.

Developed Multi dimensional Objects (Cubes, Dimensions) using MS Analysis Services (SSAS)

Build MDX queries and Data Mining Expression (DMX) queries for Analysis Services SSAS and Reporting services SSRS.

Defined attribute properties in a Parent Child Dimensions.

Used Joins to write queries that retrieve data from more than one table.

Responsible for hiding and disabling attributes and attribute hierarchies.

Developed reports that deliver data from cubes.

Created and managed subscriptions for the reports.

Responsible for ongoing maintenance and change management to existing reports and optimize report performance.

Created stored procedures to calculate pension and annuity information, when called will give the details for an employee on the website.

Defined specific read/process permissions for the users in SSAS instance.

Environment: Windows 2003/XP, SQL Server 2005 BI Suite, SSAS, SSIS, SSRS, ETL, OLAP, OLTP, ASP.NET, PROCLARITY, MDX, T-SQL, MS Visual Studio 2005.

Polaris, India. Aug 2008 – Sep 2009

SQL Developer

Polaris Software is the world's most sophisticated banking and insurance software company. Polaris is the chosen outsourcing partner for 10 of the top 15 global banks and 6 of the 10 top global insurance companies. Polaris offers state-of-the-art, comprehensive solutions for core banking, corporate banking, wealth and asset management and insurance.

Responsibilities:

Created Indexes to get the high-level performance.

Created various database objects (tables, indexes, views, stored procedures and triggers) and implemented referential integrity constraints for enforcing data integrity and business rules

Responsible for tuning T-SQL procedures, triggers and other database objects

Fine tuned and checked the performance of existing objects in SQL Server and implemented transactional logic for them

Installation of SQL Server on Development and Production Servers, setting up databases, users, roles and permissions.

Extensively used SQL native tools like Index tuning wizard, Database tuning advisor (DTA), SQL profiler, Performance monitor, Activity monitor, Event viewer, dynamic management views and dynamic management functions for monitoring, performance tuning/analysis and troubleshooting.

Responsible for all technical SQL Server database operations, Administration, ongoing development for various in-house databases.

Designed and Developed Database Objects like Tables, Stored Procedures, Triggers, Rules, Defaults, user defined data types and functions for this project.

Designed and developed DTS packages for transferring data from flat files and Access files

Created linked servers between different SQL Servers and created linked server with different access files used across various departments

Performing the ETL operations to support the data loads and transformations using SSIS.

Involved in migration from Oracle to SQL Server 2005 using SSIS.

Generation of reports from the cubes by connecting to Analysis server from SSRS.

Used SQL Profiler for troubleshooting, Monitoring, Optimizing SQL Server and T-SQL statements from developers and testers.

Maintained databases, performed software installations and upgrades, monitored Database Performance.

Implemented automated backup and database maintenance / cleanup jobs.

Managing Logins, Users, Roles and User permissions.

Running Trace from the Profiler to trouble shoot database and running DBCC consistency checks for other database maintenance aspects.

Designed numerous ad-hoc and custom reports using SQL Reporting Services.

Created various Tabular and Matrix Reports using SSRS.

Created and scheduled jobs for various tasks and was responsible for maintaining jobs.

Environment: SQL Server 2000/2005, Query Analyzer, SSIS 2005, T-SQL, Excel, Microsoft SQL Reporting Services 2005 (SSRS), Windows 2000/XP, Oracle 7.0.

Contact this candidate