SUMMARY:

• Highly motivated SQL Server/BI Developer with 7+ Years of IT Experience in Database and Business Intelligence Technologies with expertise in SQL Server Development and Reporting using SQL Server 2014/2012/2008 , SSRS and SSIS.
• Expert in Extraction & Migration of Data from heterogeneous data sources like Excel, MS Access, Oracle, DB2 to MS SQL Server by using Import Export Wizard, DTS SSIS, BCP & Bulk Insert utilities.
• Expert in Data Modeling and Multi - Dimensional Modeling.
• Strong understanding of the principles of DW using Fact Tables, Dimension Tables, star schema modeling and data modeling for Data warehouse.
• Excellent knowledge on RDBMS principles.
• Proficient in MS SQL Server suite of products like TSQL, SSRS and SSIS of MS SQL Server.
• Proficient in creating SQL Server reports, handling sub reports and defining query for generating drill down reports using SSRS.
• Maintained existing reports, created new reports according to the business needs, and integrated them in performance point server.
• Experienced in using global variables, expressions and functions for the reports.
• Maintained securities, roles, subscriptions in report manager in SSRS.
• Expert in designing SSAS cubes with slowly changing dimension, partitions, Aggregation and KPIs.
• Excellent ability to develop complex Crystal reports using custom SQLs, use of unions, creating subquery sections etc.
• Extensive experience of writing complex T-SQL queries, Views, Triggers, Functions and Stored Procedure.
• Skilled in Tableau Desktop for data visualization, Reporting and Analysis; Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart.
• Experienced in migrating reports from Crystal Enterprise to SSRS.
• Experienced in Building Power BI dashboards and configuring gateways.
• Extensive experience in creating SQL Server analysis projects using SQL Server Data tools.
• Experienced in creating complex SSIS for ETL purposes.
• Implemented complicated transformations to be used in SSIS packages.
• Expert in using tools such as Bulk Copy (BCP) and Data Transformation Services (DTS).
• Well-versed with database installation, configuration, maintenance, monitoring, backups and recoveries, and developing stored procedures and triggers.
• Highly proficient in the use of SQL Server and T-SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity, SQL joins and query writing.
• Designed and Developed ASP.NET web applications, custom control for navigation.
• Developed interactive web-based reports and forms with VB.NET and ASP.NET and ADO.NET and html.
• Developed a thorough knowledge and maturity in all the phases of Software Development Life Cycle (SDLC).
• Knowledge of Reverse and forward Engineering, Logical and Physical models, Dimensional Modeling.
• Highly motivated and competent individual with good communication and analytical skills.
• Creative and passionate for technology.
• Good team player, extremely adaptable and a fast learner.

TECHNICAL SKILLS:

BI Tools: SQL Profiler, Query Analyzer, SQL Server 2008,SQL Server 2005 Management Studio, DTS, SSIS, SSRS, SSAS, Performance Point Server 2010, PowerBI, Tableau

Database: MS SQL Server 2014/2, MySQL, MS Access

Language: T-SQL, MS SQL, MDX, DAX, C, C++, VB, HTML, DHTML, HTTP, Java, Shell Scripting

Operating Systems: Windows XP/NT/2000, DOS, Windows Server 2003, Linux

Tools: Microsoft Visual Studio 2008/2005, SharePoint Server 2010/2007, Microsoft Office Suite (Access, Excel, Word, PPT, Visio).

Architecture: Relational DBMS, Client-Server Architecture, OLAP, OLTP

Other methodologies: HTML, CSS, JavaScript, Routing & Switching protocols, LAN/WAN

PROFESSIONAL EXPERIENCE:

Sr. MSBI Developer

Confidential, Pittsburgh, PA

Responsibilities:

• Expertise in analysis, design, and development of end to end business intelligence solutions using the MSBI suites such as SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) & SQL Server Reporting Services (SSRS).
• Implemented and enhanced existing reports like Drilldown, Drill Through, Sub-Reports, List, Tabular, Matrix, Navigation Reports, Standard Parameter, Cascading Parameter and Multi-Value Parameters in SSRS.
• Perform database development that includes Schema development, Stored Procedures that could be used by different Windows Services.
• Used SSIS variables, parameters, & expressions to implement dynamicity of Master ETL Package, connection managers, tasks, containers, Send Mail, Row Count, Script tasks, etc.
• Monitored and maintained existing ETL packages and Reports to fix issues and bugs and troubleshooting.
• Created dashboards for Sales, Marketing, Finance and Production using benchmarked data to provide an analytical snapshot of point in time data.
• Created various MSBI (SSIS) packages using data transformations like Merge, Aggregate, Sort, Multicasting, Lookup, Conditional Split, and SCD (Slowly Changing Dimension) and Derived column, transformation of XML based on XSD File Experience with designing the ETL process, including data read/write, data transformations, error handling, process design, logging, and Development.
• Creation of ETL packages to load data from files into database by performing different kinds of transformations using SSIS.
• Involved in writing T-SQL programming to implement Stored Procedures and Functions for different tasks and created Triggers to enforce data and referential integrity.
• T-SQL development included queries using joins, sub queries, Ranking functions, Derived tables, common table expressions (CTEs), stored procedures, views, constraints, and Database triggers.
• Used to connect different data sources like SQL DB (SQL Query), Tabular Model (DAX Query), Web Trends to Power BI and generate reports with different visualizations.
• Involved in development & Deployment of SSAS Cubes and Monitor Full and Incremental loads and support any issues.
• Creating SSIS packages and scheduled them as jobs to run automatically to Process the cube, load data etc.
• Experienced in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools like SSIS, Data Transformation Services (DTS), Bulk Insert, BCP, and XML.
• Extensive reporting skills using SQL Server Reporting (SSRS).
• Created Data Models for each module of the current OLTP system and participating in the brain storming session to nail possible design challenges.
• Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.
• Worked on TFS for performing tasks.

Environment: Windows Server 2012 Operating System, MS SQL Server 2016, SQL Server Data Tools for Visual Studio 2015 (SSIS), SSRS, TFS, FTP, SharePoint, MS Visio, Excel PowerPivot, MS Excel 2010/2013.

Sr. MSBI developer

Confidential, Denver, CO

Responsibilities:

• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Data Automation Using SSIS to automate data processes for input of information.
• Had exposure to work on web application components using Microsoft Visual Studio, VB.Net and MVC framework. Involved in migration of reports from Crystal reports to SSRS.
• Performing comprehensive unit testing, system integration and performance testing.
• Designed, developed and deployed reports in MS SQL Server environment using SSRS.
• Wrote T-SQL Scripts and performed most of the SQL Server Enterprise Manager and Management Studio functionality using T-SQL Scripts and Batches.
• Scheduled Jobs and Alerting using SQL Server Agent.
• Created web service calls to extract data and load in SQL Server.
• Performed data cleansing techniques using look-ups, conditional splits, ranks and partitions and did data profiling.
• Write clear and concise supporting technical documentation.
• Efficient in writing stored procedures and implemented complex business logic in SSIS.
• Sharing ideas as part of the project team that provides solutions to technical issues.
• Ensure storage, archiving, backup and recovery procedures are functioning correctly.
• Extracted data from XML files and inserted the data into database.
• Developed complex T-SQL code for the application.
• Performed Look up, Derived Column, and used merge statement for creation of views.

Environment: SSIS, SSAS, SSRS, MS Office, Performance point server, SQL Profiler, report builder, Web Service.

MS SQL Server / SSIS/ETL Developer

Confidential, Englewood Cliffs, NJ

Responsibilities:

• Installed and Upgraded from SQL Server 2008 to SQL server 2012 on Various Servers.
• Migrating Databases from SQL Server 2008 to SQL Server 2012.
• Planned, defined and designed data based on the business requirement. Creating dashboard, scorecards using performance point server according to client requirements.
• Designed high level ETL/SSIS architecture for overall data transfer from the OLTP to Data warehouse with SSIS and prepared ETL/SSIS mapping processes and maintained the mapping documents.
• Created SSIS packages for Dynamic ETL/SSIS flow to validate, extract, transform and load data into database using Lookup, Fuzzy Lookup, Derived Column, Conditional Split, Slowly Changing Dimension (SCD) to perform Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Performed Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.
• Designed logical/physical data models using Erwin tool 8.0. Uses of power pivot.
• Deployed and scheduled Report subscriptions using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Responsible for Full Report Cycle including Authoring, Managing, Security and generation of Reports.
• Reviewed and fine-tuned stored procedures and triggers before production migration.
• Experienced in creating jobs Alerts, Alerts, SQL Mail Agent, and Scheduling SSIS Packages using SQL Server Agent job.
• Implemented various tasks and transformations for data cleansing and performance tuning of packages by using SSIS.
• Created XML and SQL Server package configuration to make package dynamic using SSIS package Configuration Wizard and deploy packages to production Server.

Environment: MS SQL Server 2012/2008, Enterprise Edition, Bamboo, Performance point server, MS SSRS 2012, MS SSIS 2012, T-SQL, VB Script, Windows Server 2007 and Erwin 8.0

BI Developer

Confidential

Responsibilities:

• Extensively worked on T-SQL for creating stored procedures, indexes and functions.
• Implemented custom SSRS Reports to Internal operation team by reading data from the QNXT Database.
• Added new users and applied roles in the QNXT UI in the Development and UAT Environments.
• Created Reporting interface for Customer service team by reading the data from QNXT Claim, Claim Detail tables.
• Implemented ETL Application to load Claim Payment information to QNXT Financial tables and provided access to financial team by creating custom roles in the security management.
• Designed Enterprise reports using SQL Server Reporting Services (SSRS 2012) which make use of multiple value selection in parameters pick list, cascading prompts, drill thru reports, drill down reports, matrix reports and other features of reporting service.
• Worked on SSRS 2012 to generate about 30+ reports for various user groups and developer groups.
• Deployed all the reports to reporting server, Excel & PDF.
• Developed Charts, Pie-Charts, Bar-graphs, series on SSRS.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML file) and then loaded the data into destination tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Responsible for designing the SSIS packages to export data of flat file source to SQL Server Database.
• Involved in enhancement of existing SSIS packages.
• Good knowledge in deploying SSIS packages to various environments.
• Implemented in unit testing and created unit test document.
• Supported system testing and helped the testing team in execution of SSIS Jobs.
• Used various control flow tasks like FTP, Bulk insert task, Conditional Split, Multicast, Merge task and different data flow tasks.
• Provided many supporting documentations for the project.
• Participated in meetings with all the members of the project to discuss, plan and implement strategies that would ensure all the business requirements reflect in the project development.
• Created SSIS packages for extract layer, Staging/Integration layer and Export layer.
• Worked on different kinds of Transformations in SSIS as per the client’s Requirement.
• Created Extract, Transform and Load (ETL) processes.
• Created complex reports in Crystal Reports using procedures from SQL Server by passing in stored procedure parameters.
• Participated in meetings with all the members of the project to discuss, plan and implement strategies that would ensure all the business requirements reflect in the project development.
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses extraction, Transformation and the direction of data flow and Metadata using SSIS.
• Managed production support and defect/enhancement request tracking.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring and archived data files for different DBMS.
• Designed high level ETL (Extraction Transformation Loading) architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Designed high level ETL (Extraction Transformation Loading) architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Designed and developed SSIS packages to move data from production environment to different environments within the organization.
• Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing, deploying and dynamic configuring of SSIS packages.
• Wrote stored procedures and User Define Scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Developed tabular queries for efficient analysis of report using Pivot/Unpivot in T-SQL.

Environment: Microsoft SQL server 2012, SSIS, BIDS, Notepad++, MS Visual Studio 2012, T-SQL, SQL Profiler, MS office.

SQL - ETL Developer

Confidential

Responsibilities:

• Gathered functional requirements and Business requirements and wrote the technical specifications for building the Data model.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server 2005/2008.
• Created and executed several SSIS packages to perform ETL operations of the data from source server to destinations server and OLTP to OLAP.
• Experience in creating complex SSIS packages using proper control and data flow elements with Error Handling.
• Experience in providing Logging, Debugging and Error handling by using Event Handlers, and Custom Logging, break point, data viewers, check points for SSIS Packages.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Transfer Data from Database to Data Warehouse using SSIS ETL packages such as look up, union-all, multicast Transformations.
• Involved in monitoring and tuning report performance by analyzing the execution plan of the reports.
• Developing back-end PL/SQL packages, building UNIX shell scripts for data migration and batch processing.
• Built, Published and Scheduled SSRS Reports for both Dev and Test Environment.
• Database backups and troubleshooting production databases and cube sync processing issues and SSAS issues.
• Created Star Schema for OLAP cube generation and extensively worked dimension modeling for analysis service using SSAS.

Environment: MS SQL Server 2008/2005, SSIS, SSRS, T-SQL, Crystal Reports 7/8, Windows 2008 Advance Server, VB.NET, MS Excel, and MS Office.

SQL Server Developer

Confidential

Responsibilities:

• Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
• Involved in creating SSIS jobs to automate the reports generation, cube refresh packages.
• Designed dynamic SSIS Packages to transfer data across various data sources like excel, flat file, oracle and validate the data by running SQL scripts.
• Worked on Performance tuning of SQL queries using SQL Profiler and Index Tuning Wizard.
• Responsible for designing and developing stored procedures, user-defined functions, views, triggers, and indices.
• Involved in analysis of requirements and actively participated and interacted with Team Lead, Technical Manager and Lead Business Analyst to understand the Business requirements.
• Created Tablix Reports, Matrix Reports, Parameterized Reports, Sub reports using SQL Server Reporting Services.
• Created reports with different features like drill through capabilities, jump to another report, use of pie charts and bar charts.
• Involved in modifying report content and exporting reports in multiple formats based on the business requirements.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Created Drill-down, Drill-through and Sub-Report using RDL. Promoted RDLs to Reporting Server.
• Wrote expressions in SSRS wherever necessary.
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Played a major role in production support of SSAS (cube refresh), SSIS jobs.
• Constantly checked configuration and performance of the existing databases including data file allocation, index, fragmentation and impact on system performance. Analyzed potential problems (response delay, locking, server down time, etc.) to avoid and optimize by following Normalization standards to maintain data consistency and by performing data validation.
• Regular monitoring of a rapidly-changing 500 GB database.
• Reduced total ETL package running time from 8 hours to 2 hours.
• Documentation of the new assignments, technical specifications and requirement documents.
• Ensure best practices are applied and integrity of data is maintained through security, documentation, and change management.
• Performed unit testing, integration testing and system testing as part of application development.
• Helped Quality Assurance Team to generate Test Plans and Test Executions.
• Worked very closely with Business users, End users and resolved any business process related issues.
• Created derived columns on the final fact and dimension tables as per the business requirements.
• Understanding the OLAP processing for changing and maintaining multi-dimensional data warehousing, Optimizing Dimensions, Hierarchies and adding aggregations to the OLAP Cubes.

Environment: SQL Server 2008 R2 and 2014, T-SQL, SSIS, SSRS, Visual Studio, SQL Server Data Tools, SQL Server Management Studio, SQL Developer, C#