Sql Server Data

Bindu

Sr SQL Server Developer

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

Contact: 678-***-****

Summary:

7+years of strong IT industry experience as a MS SQL Server 2014/ 2012/ 2008R2/ 2008/ 2005, Data Warehouse Developer/BI Developer in various domains. Maintained positive communications and working relationship at all levels.

Experience in developing the applications using T-SQL Programming (DDL, DML, and DCL).

Conversant with various phases of Software Development life cycle (SDLC) including development, designing, analysis, coding, testing and implementation.

Proficient with SQL Analysis Services 2008/2012 such as, building multi-dimensional cubes, Dimensions, fact tables, Hierarchies, levels, roles, performed drill-up, drill-down, and drill-through and applying cube security.

Wrote Multidimensional Expression (MDX) queries to extract data from cubes.

Extensive experience in MS SQL Server 2012/2008R2/2008/2005/2000, BI tools like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS).

Highly Proficient in developing SSIS Packages to Extract, Transform and Load (ETL)/DTS data into the Data warehouse from Heterogeneous data sources such as Oracle, DB2, MS Excel, MS Access, CSV, Oracle, flat file.

Proficient in creating, configuring and fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).

Proficient in assortment of technologies including PowerShell, Windows OS, Mysql.

Proficient in full life cycle design and development of Business Objects reporting Applications.

Strong understanding of data warehousing concepts, OLTP, OLAP, Visual studio in CSharp, Normalization, Star and Snow Flake data models.

Worked on non relational database.

Environment Windows OS Professional, Visual Studio 2010, 2013 with bundled resources and tools, Team Foundation Server, scripting languages including python & PowerShell.

Developed OLAP cubes using SSAS (SQL Server Analysis Services) and calculate the metrics that were revealed in the functional analysis.

Expert in writing parameterized queries for generating tabular reports, formatting report layout, sub-reports using global variables, subtotals, expressions, functions, sorting the data, defining data sources for the reports using SSRS.

Experience in training developers and advising technical groups on reporting best practices.

Flexible and versatile to adapt to any new environment with a strong desire to keep pace with latest technologies.

Experience in Visual studio in Csharp db.

Excellent problem solving, communication, analytical, interpersonal skills and ability to perform independently or as part of a team.

Certification:

MS Certified on SQL server 2008.

Technical Skills:

Languages SQL, MS SQL, Transact SQL, PL/SQL, Embedded SQL, C,C++, Java, J2EE, VBScript, C#.Net, JavaScript, ASP, HTML 4.0, DHTML,XML, CSharp.

Databases SQL Server 2012/2008 R2/2008/2005/2000, Oracle 9i/8.x, DB2 MS Access

Reporting Tools SQL Server Reporting Service (SSRS), Crystal Reports XI/10/9, Non relational database.

ETL Tools SSIS (SQL Server Integration Services), DTS(Data Transformation Services), Import Export Data, Bulk Copy Program (BCP), Informatica 8.6.1, Business Objects XI R2/R3, Webi, BIDS.

Other Software MS Office- 2007/2003/2000, Adobe Professional, Windows OS.

Operating Systems Windows OS/98/2000/2003/XP/Vista, Agile

Database Tools SQL Query Analyzer, SQL Enterprise Manager, Management Studio, SQL Server 2008 Query Editor, SQL Server Analysis Services (SSAS), TOAD

Methodologies Logical and Physical Database Design, non-relational database, UML, Database Design and Normalization, Data Modeling

PROJECT SUMMARY:

Fannie Mae, Reston, VA Feb 2015 – Till

Sr. SQL ETL Developer

Responsibilities:

Developed the SSIS ETL packages which will take the data from various sources like Oracle 8i,,Flat files, Excel and XML files and will perform the appropriate transformations over the data and will load the data onto targeted SQL Server Data mart.

Worked with SCD, Data conversions, Merge Join tasks, and look up transformations, Execute SQL Task, OLEDB Command Task and Sequence containers and For Each Loop containers in the package development.

Worked with Configuring the SSIS packages using XML & SQL Server type configurations when the finalized ETL packages are need to be moved onto the Production box.

Worked with Deploying the SSIS packages using SQL Server package deployment wizard to deploy the packages on the production server.

Developed the SQL Agent Jobs in order to schedule the ETL packages on a scheduled basis.

Migrated SAP BO Crystal reports 10 to SQL Server Reporting Services 2008 R2

Developed the SSRS reports by pulling the data from the Data mart by the extensive use of stored procedures and cursors.

Worked with the parameterized reports and enabled the reports with the Drill-down features by using the matrix and table data viewers.

Developed the Ad-hoc reports using the Report manager and Report Builder tools.

Rendered the reports into various formats like PDF, CSV, Excel etc.

Worked with Configuring the SSRS Report Manager and Report Server and generating the Web URL for the Report Server and creating the Virtual directory for the Report Server where the deployed reports would be stored as a repository

Managed the Reports by providing the access permissions to various report users like Admin/Report users/Browser Etc.

Environment: SQL Server 2014/2012/2008 R2 Enterprise Edition, FACETS, DTS packages, Visual studio 2012/2010, SSAS, SSIS, T-SQL, SSRS, ERWIN, Oracle 9i/10g, Agile.

AT&T Richardson, Texas Sep 2013 – Jan 2015

Role: Sr SSIS/SSAS/SSRS Developer

Responsibilities:

Involved in creating SSRS reports from Different Databases like Oracle, Hyperion and SQL Server.

Involved in Database modeling, ETL and creation of analytical processes, responsible for translating the Business requirements into technical specifications in business intelligence development studio(BIDS).

Worked on configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.

Experience of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.

Experience in using XMLA protocol for SQL Server Analysis Services 2008 for interaction between client application and instance of Analysis Services.

Worked with SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models.

Designed & Developed multi-threaded SQL CLR SP's Services to execute Data Load Task and basket creation process.

Update SPs / CUs using PowerShell scripts and troubleshoot Exchange 2010 related issues in server 2012 R2 / 2008 R2 virtualized environment as well as granular level restores when required.

Designed and developed packages for data warehouse using Integration services (SSIS) in BIDS.

Planned and developed account migration process for a multi-domain e-mail migration from internal and external AD domains running Exchange 2003/2010 to Google Apps Mail. Migration scripts developed with PowerShell..

Involved in claim adjudication process of facets application.

Regular responsibilities for updating and staging the dimensional databases as well as rebuild the Dimensions and cubes in Analysis Services.

Worked on different Tools in MS e.g.Powershell.

Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.

Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent in BIDS.

Worked in Agile Scrum Methodology with daily stand up meetings and great knowledge in TFS (Team Foundation Server) 2010.

Created OLAP models based on Dimensions and Facts for efficient loads of data.

Enhanced the functionality in database and data warehousing concepts (OLAP, OLTP) Cube by creating KPI, Actions and Perspective using SQL Server Analysis Services 2008(SSAS).

Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.

Designed and developed web pages using C#,MVC 3.0 and VS.Net.

Used C# scripts in SSIS script task to run custom scripts in package flow.

Working experience with ASP .NET to display reports and experience using C# in SSIS scrip task.

Scheduled and monitored the regular jobs and ETL packages, Used ADO.net connection, .net and C# code in SSIS Script task

Environment: SQL Server 2014/2012/2008 R2 Enterprise Edition, FACETS, DTS packages, Visual studio 2012/2010, SSAS, SSIS, T-SQL, SSRS, ERWIN, Oracle 9i/10g, Agile.

AIG, Jersey City, NJ Mar 2012 – Aug 2013

Role: SSIS/SSAS/SSRS Developer

Responsibilities:

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

Writing queries to generate reports for analysis of data using SQL Server Reporting Services (SSRS), Report Builder.

Generated Reports using Global Variables, Expressions and Functions for the reports in SSRS.

Generated various Drill-through reports, parameterized reports, sub-reports and linked reports using SSRS and integrated into the web front end. Implemented PowerShell remote and script execution

-Configured PowerShell in DDMG, In-Three, DDMAIL and DDI domains for script execution and removing

-Deployed node locked software requiring graphic user session for license activation with PowerShell + Auto IT.

Created the Data source connections, Data Source Views, Relationships, Named Query for customized analysis in SSAS.

Project includes extracting, transforming, loading data from ERP database in OLAP cubes in BIDS.

Implementation of SQL Server Analysis Services (SSAS), design/change/deploy OLAP Cubes.

Installed MS SQL server 2005 and MS SQL server 2008 on windows 2003/2008 servers, appliedService packs and Security fixes. Implementing database standards and naming convention for the database objects.

CreatedSQL Scripts for data loads and upgrades for data migrations and data validations.

Developed and scheduled DTS packages for each system Interface using SQL code in combination with VB ActiveX scripts and built-in DTS transformations.

Worked on Data Driven Subscription Tables for Quarterly Reports, Monthly Reports as well as Daily Reports.

Worked on FACETS up-gradation project.

Created Policies, Conditions and used Facets with Policy Based Management to configure and manage the SQL Servers.

Developed reports by using SSRS and deployed them on web pages using ASP.NET using C#.

Responsible for Developi.ng GUI Screens using ASP.Net and C#

Wrote custom tasks using C# within SSIS to enhance processing of both Excel and flat-files into SQL Server in Business intelligence studio (BIDS).

Created very complex SSIS Packages with considering all the best practice like error handling, logging, configurations, deployments, and maintenance.

Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS and in adding calculations using MDX.

Created complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL

Involved extensively in designing of OLTP database

Created schemas, keys and indexes considering the granularity of the data

Designed Data flows, Workflows and jobs to load data from source to target in BO Data Integrator.

Deploy the packages in Production server ad schedule the packages according to the requirements in BIDS.

Iteration planning for new features and user stories in Agile Development methodology.

Deployed SSIS packages and Reports to Production Servers.

Environment: SQL Server 2012/2008 R2, SSIS, SSRS, SSAS, DTS packages, Visual studio 2010/2008, Tortoise SVN 1.7.10, ERWIN, Red Gate 10.0,Window 7 Professional, Agile.

CNSI Inc, Rockville, MD Aug 2011 – Feb 2012

Role: BI Developer / MS SQL Server

Responsibilities:

Participated in gathering Business Requirements and System Specification from system users.

Created and executed SQL Server Integration Service (SSIS) packages to populate data from the various data sources into the data warehouse

Created SSIS Packages using SSIS Designer for importing heterogeneous data from OLE DB Source, Excel Spreadsheet, text files into Enterprise Data Warehouse.

Various ETL Transformation tools were used for Control Flow and Data Flow tasks

Experienced in creating reports (SSRS) in Drill mode using tables, matrix and charts in SQL SERVER 2008

Designed and implemented Parameterized and cascading parameterized reports using SSRS

Created star schema in SSAS and developed SSRS reports based on the cube

Involved in implementing package configuration in SSIS packages that allowed transferring packages from one environment to other

Involved in scheduling SSIS packages to run on routine basis and monitor the error log for any errors.

Involved in C# coding developing SSIS Packages.

Involved in writing C# scripts using script task transformation to create multiple reports based on providence Insurance client's information.

Created SSIS Packages using Script Task and various Shell scripts, CSharp, C#, VB script in BIDS.

Implemented multidimensional cubes with MDX calculations to support analysis needs and fast data retrieval

Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.

Backing up, restoring system & other databases as per requirements, and also scheduled those backups.

Developing stored procedures, triggers, views, and adding/changing tables for data load and transformation, and data extraction.

Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.

Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.

Environment: MS SQL Server 2008 R2/2008, Visul studio Management Studio 2008, SSIS, SSRS, SSAS, T-SQL, MS Access, Windows Server 2008.

Client: HSBC, India Duration: Apr 2009 – Jul 2011

Role: SQL Developer

Responsibilities:

Involved in Analysis, Design, and Development and Testing phases.

Analyzed the business requirements from the given specifications.

Writing of Stored Procedures and Functions using SQL Server 2005 and T-SQL.

Maintenance of the various database objects – tables/views/stored procedures - in SQL Server 2005

Performed the Server optimization, Tuning of the indexes and the queries and Consolidation of SQL Server environment in windows OS.

Used the maintenance Plan for SQL Server databases to recreate indexes and statistics for the performance.

Design and implementation of Security Model, policies and procedures.

Query Optimization using Query Analyzer, Profiler, Show plan, Index Tuning and Stats Time Tool.

Created Snapshot Replication for the Development and Testing Databases across different Servers.

Regular responsibilities for updating staging and dimensional databases as well as rebuilding the dimensions and cubes on Analysis Services (SSAS).

Development of DTS Packages, stored procedures, views, triggers, index and SQL Scripts.

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

Performed Documentation for all kinds of reports and DTS and SSIS packages in BIDS.

Designed and developed complex SSRS reports.

Create ad hoc complex management reports as required.

Design and develop reports using SQL server reporting services.

Configuration of linked servers for user to be used for data exchange.

Created and scheduled jobs and alerts.

Involved in version management of source code using VSS.

Involved in designing of reports using SSRS.

Involved in Unit testing and System Testing for the application.

Environment: Microsoft SQL Server 2005/2008, Microsoft SQL Server Management Studio 2005/2008, T-SQL, Windows OS and Microsoft SQL Server Reporting Services.

Contact this candidate