SUMMARY

• 5 years of extensive experience in SQL Server database development/administration, extensively worked in OLTP, OLAP environment & development databases as a Developer/DBA in different domains of Fortune 500 companies including Insurance, Utility and Retail Industries.
• Involved in the Business Analysis of the OLTP and OLAP data and in decision support.
• Hands on Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2014/2012/2008 R2/2005.
• Strong knowledge of Data Warehousing methodologies, concepts and implementation of star schemas, snowflakes schemas, facts & dimensions.
• Experienced in BI Development and Deployment of SSIS packages from MS - Access, Excel.
• Created and managed schema objects such as Tables, Views, Indexes and referential integrity depending on the requirements and converting them into technical specifications.
• Documented the technical architecture of the data warehouse, including the physical components, their functionality, source data and ability to integrate with existing system architecture.
• Extensive experience in MS SQL Server 2014/2012/2008 R2/2005 Business Intelligence in MS SQL Server Integration Services (SSIS) and MS SQL Server Reporting Services (SSRS).
• Proficient in Creating, Configuring and Fine-tuning ETL workflows designed in MS SQL Server Integration Services (SSIS).
• Experienced in providing Logging, Error handling by using Event Handlers, and Custom Logging for SSIS Packages.
• Proficient in designing and scheduling complex SSIS Packages for transferring data from multiple data sources to SQL server.
• Experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2014/2012/2008 R2/2005.
• Experienced in creating various Parameterized, Cascaded, Linked and Drill-through & Drill-down reports.
• Worked to enforce consistency in data warehouse for naming conventions and data types.
• Hands on experience in creating indexed views, complex stored procedures, effective functions, and appropriate triggers to assist efficient data manipulation and data consistency.
• Extensive experience in Installation, Configuration and Deployment of SSRS reports using Scale-Out.
• Experienced in programming Tasks-Stored Procedures, Triggers and Cursors using SQL Server 2014/2012/2008 R2 with T-SQL.
• Experienced in designing, creating, processing of cubes using SSAS.
• Efficient in up gradation and migration from SQL Server 2005/2008R2 to SQL Server 2012/2014.
• Worked extensively on system analysis, design, development, testing and implementation of projects (Complete SDLC) and capable of handling responsibilities independently as well as a proactive team member.
• Designed and Deployment of Reports for the End-User requests using Web Interface & SSRS.
• Experienced in database administration for MS SQL Server databases, and supported applications with efficient back-end processing.
• Experienced using Kimball Data Warehouse Methodology.
• Quick learner and good performer both in team and independent job environments.

TECHNICAL SKILLS

Languages: T-SQL, PL/SQL, C, Java

Operating Systems: MS-DOS, Windows Server 2012/2008/2003/ XP/NT 4.0/98/95, UNIX

RDBMS/ Databases / Database Tools: MS SQL Server 2014/2012/2008 R2/2005, Oracle 11g/10g/9i/8i, TOAD 7.5, MS Access, SQL Server Management Studio, SQL Server Data Tools, Business Intelligence Development Studio (BIDS), Visual Studio, SQL Profiler, Performance Monitor, DTS, Database

Data Warehouse Tools/Technologies: SSIS, SSRS, SSAS 2014/2012/2008 R2/2005

Data Modeling Tools: Power Designer, MS Visio, ERWIN

Reporting Tools: MS Reporting Server(SSRS), Excel Power View

Microsoft Technologies: SharePoint, VB.Net, ASP.NET

PROFESSIONAL EXPERIENCE

 MSBI (SSIS & SSRS) Developer

Responsibilities:

• Involved in Technical discussions and decisions for Business requirements, Interaction with Business Analysts, Client team and Development team.
• Experienced in database design process and data modeling process.
• Analyzed the Data quality, Data validating, Data Mapping to migrate data to SQL Server database.
• Designed SQL Server Database and Table Design with Schemas, Constraints and Views.
• Extracted data from various sources like DB2, VSAM, SQL Server 2014/2012/2008 R2, .CSV, Microsoft Excel and Text file from Client servers.
• Analyzed business requirements and implemented data mart solutions for data mining and reporting.
• Created SSIS packages which involved a variety of transformations such as Slowly Changing Dimension, look up, Aggregate, Derived Column, Conditional Split, Multicast, Union All, Merge, Merge Join, and Data Conversion before loading the data into Data Warehouse.
• Created a report model on SSAS cubes.
• Designed the data model based on star schema and created the tables and indexes and developed the scripts to load the data mart tables.
• Identified issue and developed a procedure for correcting the problem which resulted in the improved quality of critical tables by eliminating the possibility of entering duplicate data in a Data Warehouse.
• Developed, Code Reviewed, fixed bugs, tested and deployed SSIS packages using SQL Server 2014/2012/2008 R2 Business Intelligence Development Studio.
• Gathered Report Requirements and designed Reports, Matrix, Table Reports with Drilldowns, Map Reports, Dashboards, Gauge and Subscription reports.
• Strong knowledge of Data Warehousing methodologies, concepts and implementation of star schemas, snowflakes schemas, facts & dimensions.
• Developed reports with consistent drill-down functionality including Drilldown report and Summary report.
• Ensured constraints and writing triggers/linked server scripts to apply the business rules. Performance Tuning, Backing Up & Restoring User Databases.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Deployed and Tested (UAT) Reports in Multi User Environment. Created RSConfig Files and Ensure Report Security with Keys.
• Involved in Installation, Configuration and Deployment of Reports using SSRS with Scale-Out topology.
• Worked closely with QA team and helped them come up with test scenarios.
• Part of the Agile/Scrum team and participated in Standup, grooming, planning and retrospective meetings.

Environment: MS SQL Server 2014/2012/2008 R2, SSIS, SSRS, SSAS, SSMS, Visual Studio 2010, Import/Export tools, Power Designer tool, Power Designer Portal, T-SQL, Windows 2003 Server, MS TFS, JIRA.

 MS BI Developer

Responsibilities:

• Interacted with Business Analysts and stake holders to gather business requirements.
• Transferred data from various data sources/business systems including DB2, MS Excel, MS Access, Flat Files etc. to SQL Server using SSIS Packages and using various features like Excel source, Flat file source, transformation etc. Created derived columns from the present columns for the given requirements.
• Used SQL Server to load tables in support of de-coupled, pluggable architecture to manage data flows between service providers and LIPA.
• Created SSIS packages to get data from different sources, consolidated and merged into one single source.
• Created detailed design and requirements documents with logic to help team members understand the requirements and design.
• Designed and implemented relational databases, data marts and developed reports to allow users to easily access data.
• Developed reports with consistent drill-down functionality including Drilldown report and Summary report.
• Used SSRS to create, execute, and deliver tabular, matrix, and charts reports.
• Involved in usage of various SSIS components like Slowly Changing Dimension, Conditional Split, Merge, Merge Join, Multicast, Union All, Sort, Derived column, SQL execution task, Variables, and Error Handling before loading data into the Data warehouse.
• Designed custom Dimensions and Facts Tables to extend data warehouse.
• Worked on the project that involved development and implementation of a data warehouse.
• Created SSIS packages and involved in Package Configurations and deployments between Development and QA and Production servers so that various properties like variables, connection managers could be changed when moving the Package from one environment to another.
• Involved in Code Review, Unit testing, logging and Custom Logging in SSIS Packages, Query verification in SSIS and Stored Procedures.
• Conducted system tests, troubleshoot customer issues and correct database defects.
• Worked on Exception Handling with @@error and with Try/catch and resolving locking/deadlocks.
• Use customer requirements to improve functionality (speed, performance / usability).
• Created, tested and implemented SQL backup strategy based on the business needs, utilize the combination of full, differential and transactional log backup to ensure all necessary business data is properly backed up.
• Provided back-end support for functional testing and performance testing. Developed scripts to migrate data from multiple sources to desired destination using ETL tools.
• Modified SSIS ETL packages for changed business requirements to load data from different source files to SQL Server tables in data warehouse.
• Worked on knowledge transfer and documentation of various jobs developed and deployed into production.
• Coordinated/Involved in deployment/migration of change requests to testing (System Integration Testing) and production environment.
• Supported performance related issues in production database and optimized stored procedures/queries with the help of different Microsoft tools.

Environment: MS SQL Server 2012/2008R2, SSIS, SSRS, T-SQL, Software Development Life Cycle (SDLC), Team foundation server (TFS), SQL Server Management Studio, Visual Studio 2010, TortoiseSVNv1.7.11, Windows Server 2003.

Jr. Software Developer

Responsibilities:

• Developed ETL jobs like data transformation using Microsoft SQL Server Integration services.
• Created SSIS packages, staged data from different data sources into a SQL Server Database using SQL Server Integration Services.
• Designed and created SQL Databases, tables, indexes, and views, User Defined Functions, Stored Procedures, and Triggers to support business applications.
• Developed SQL Server reports on daily performance of databases using SQL Server Reporting Services.
• Administered minor databases of the facility using SQL Management Studio.
• Performance Tuning and Maintenance plan for consistency checks, backup/restore and Rebuild Indexes.
• Wrote stored procedures using T-SQL and implemented them.
• Conducted code review.
• Worked with various business groups while developing their applications, assisting in database design, phasing from development to QA and to Production environment.

Environment: Windows Server 2003, SQL Server 2005, Oracle 10g, UNIX.