PROFESSIONAL SUMMARY

• 7+ years of extensive experience as a MS SQL Server ( 2014/2012/2008 R2/2005/2000) Business Intelligence Developer working with Fortune 500 companies in Insurance, Health Care, Finance and Retail Industries.
• Involved in the IT architecture, systems administration and 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.
• Extensive experience in systems administration and MS SQL Server 2014/2012/2008 R2/2005/2000 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, Drill-through and Drill-down reports.
• 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.
• Efficient in up gradation and migration from SQL Server 2005/2008R2 to SQL Server 2012/2014.
• Experienced in SDLC life cycle for Design, Development and Staging phases of the projects with support of Data-Flow and E-R Diagrams.
• Designed and Deployment of Reports for the End-User requests using Web Interface & SSRS.
• Experience in database administrator for MS SQL Server databases, and supported applications with efficient back-end processing.
• Quick learner and good performer both in team and independent job environments.

TECHNICAL SKILLS

Languages: T-SQL, PL/SQL, C#, HTML, XML, VB script.

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/2000, Oracle 11g/10g/9i/8i, TOAD 7.5

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

Confidential, Tampa, FL

Microsoft SSIS & SSRS Developer

Responsibilities:

• Involved in Technical discussions, Architecture and decisions for Business requirements, interaction with Business Analysts, Client team and Development team.
• Experienced in data analytics, 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.
• 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.
• 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.
• 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, SSMS, Visual Studio 2010, Import/Export tools, Power Designer tool, Power Designer Portal, T-SQL, Windows 2003 Server, MS TFS, JIRA.

Confidential,Summit, MO

Microsoft SSIS 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 GEHA.
• 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.
• 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.
• 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.

Confidential, Uniondale, NY

Microsoft SSIS/SSAS/SSRS Developer

Responsibilities:

• Actively participated in the team meetings to gather the business requirements and developing the specifications.
• Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL Server 2008R2 using SSIS, BCP and Bulk Insert.
• Developed, modified, and optimized complex queries and stored procedures to data retrieval and modification.
• Created SSIS packages to load data into Data Warehouse using Various SSIS tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, and xml task.
• Utilized multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Used XML and environmental variables in the package configuration for Deploying SSIS packages.
• Created SSIS Packages usingcontrol flow transformationto generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Installed and configured SQL Server Reporting Services.
• Created ETL metadata reports using SSRS, reports include like execution times for the SSIS packages, failure reports with error description.
• Developed reports using SSRS 2008R2 and used table control, matrix control for cross tab reports.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Created Drill Down, Drill through, linked and sub reports using SSRS 2008R2.
• Created complex queries to generate matrix reports using SSRS 2008R2.
• Created Cross-Tab and Sub-Report using RDL and promoted RDLs to Reporting Service Server.
• Created various OLAP cubes using SQL Server Analysis Services 2008R2.
• Involved in automating the partition management for the measure groups for the performance of the SSAS cube.
• Wrote MDX queries for Analysis Services.
• Published reports on to Share-Point and Report Server and set the data-driven subscriptions for these reports.

Environment: MS SQL Server 2008R2, SSIS 2008R2, SSRS 2008R2, SSAS 2008R2, MS Visual Studio 2008R2, Microsoft Visio, Windows Server 2003, Share-Point.

Confidential, Montvale, NJ

Sr. ETL Developer

Responsibilities:

• Participated in discussions with Team leader, Group Members and Technical Manager regarding any Technical and Business Requirement issues.
• Extracted large volumes of data from various data sources and loaded the data into target data sources by performing different kinds of transformations using SSIS.
• Reconciled data for transformation from SQL Server 2005 to SQL Server 2008 using SSIS.
• Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
• Created Ad-Hoc Reports, Sub Reports and Summary Reports using SSRS.
• Generated and formatted Reports using Global Variables, Expressions and Functions, designed and implemented stylish report layouts.
• Used complex expressions to Calculate, Group, Filter, Parameterize, and Format the contents of the report.
• Involved in Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics using SSRS.
• Developed various kinds of Tabular, Matrix, Drill-down and Drill-through reports using SSRS.
• Created reports of SQL Server Analysis Server cubes in SQL Server Reporting Services (SSRS).
• Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Played a major role in production support of SSIS jobs.
• Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Involved in writing MDX queries and performance optimization of the SSAS cubes.

Environment: MS SQL Server 2008, SQL Server Integration Services 2008, SQL Server Reporting Services 2008, Server Analysis Services 2008, MS Visual Studio 2008, Microsoft Visio, Windows Server 2003, Oracle.

Confidentia

ETL Developer

Responsibilities:

• Worked closely with applications development to ensure database design meets business requirements.
• As a part of 4-member team, was involved in design, development, testing and implementation of the Data Marts on the Customer data.
• Ensured databases are backed-up and recoverable.
• Anticipated in finding solutions for the problems related to database performance and execution.
• Ensured naming conventions & standards are enforced correctly.
• Worked with the higher officials in creating and maintaining corporate data model, monitored and maintained database utilities.
• Assisted application developers in database access techniques and resolving connectivity issues like monitoring, tuning, backup and recovering databases.
• Provided counter measures to problems related to database performance and execution.
• Assisted developers and users in database access techniques.
• Extensively involved in logical & physical design, development and testing of the system.
• Developed User defined functions.
• Assisted in loading data using DTS.
• Deployed DTS packages.
• Worked closely in building complex SQL queries.

Environment: DTS 2000, Oracle 8i, SQL Server 2000, PL/SQL, FTP, UNIX, Windows X