SUMMARY:

• 5+ Years in IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2000/2005/2008 R2/2012/2016 in Development, Test and Production Environments with insurance, sales and Banking domains.
• Experience with T - SQL, Integration Services (SSIS), Reporting Services (SSRS) and working knowledge of Analysis Services (SSAS).
• Hands on experience on Tableau 8.2/9.0 and Tableau Reader
• Expertise in design and deploy rich Graphic Visualizations Parameters using Tableau
• Experience in developing interactive dashboard using techniques like guided analytics and visual best practices provided by Tableau
• Worked on Tableau administration tasks such as publishing workbooks, setting permissions, managing ownerships, working with Sites, providing access to the users and adding them to the specific groups and Projects, Scheduling Refreshes and Subscriptions in Tableau Server
• Very good experience in Installation, configuration and maintenance of SQL Server.
• Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints
• Experience in Integrated Tableau dashboards into internal web portal using Java Script API
• Expertise in Performance Tuning, Index Tuning, Maintenance, Troubleshooting, Query Optimization, Client/Server connectivity and Database Consistency Checks using DBCC Utilities, DMVs and DMFs.
• Expert in using Native tools like SQL Server Profiler, Database T uning Advisor and Perfmon .
• Experience in Migrating SSRS Reports to Tableau Reports
• Expertise in Tableau advance analysis features like Actions, Calculations, forecasting, Parameters and Trend lines
• Experience in planning and implementing Database Security by creating Logins, Users, Roles and assigning permissions according to the requirement.
• Experience in creating and developing different types of reports using SQL Server Reporting Services and Crystal reports and migration of Data from Excel, DB2, Sybase, Flat file, Oracle to MS SQL Server by using BCP and SSIS utility.
• Designed reports with complex sub reports, Drill down, Cross Tabs, formulas, functions, parameters, schedule reports, alerts, multiple grouping, running totals, Charts, graphs, mapping, multiple sections, mailing label.
• Migration of SSRS reports from SQL 2008R2 to SQL 2012.
• Extensive experience with data modelling techniques, logical and physical database design.
• Experience in creating indexed views, complex stored procedures, effective triggers and useful functions to facilitate efficient data manipulation and consistent data storage.
• Experience in working/migration of data with SSIS (SQL Server Integration Services) as an ETL tool for Data integration services and business applications. Creating SSIS packages using various Data transformations like conditional splitting, Derived column, Fuzzy Look Up, for each Loop, Multi Cast, column conversion, Fuzzy Grouping.
• Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files.
• Created Reports with complex formulas and to query the database for business Intelligence.
• Good understanding in Oracle 9i/10g Database.
• Experience in creating Jobs, Alerts, SQL Mail Agent, scheduling DTS/SSIS Packages and Backup/Restore of a database
• Worked Extensively on ETL process using SSIS package.
• Experience in using variables, expressions and functions and 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.

TECHNICAL SKILLS:

RDBMS: MS SQL Server 2005/2008 R2/2012/2016, MS-Access

Web Technologies: HTML, ASP.Net, XML, Java Script and VB Script

Languages: C#, T-SQL, VB.NET, XML, C, C++, Java

Operating Systems: Windows server 2008R2/2012

Version Control Tools: Visual Source Safe and SVN

Reporting Tools: Microsoft Reporting services SSRS, Report Builder 3.0, Tableau 8.x/9.x

ETL Tools: SSIS 2008R2/2012, Informatica Power Center 7.x/6.x and PowerMart 8.x/7.x

Packages: Microsoft Office and Microsoft Business Intelligence

Modeling Tool: Microsoft Visio

PROFESSIONAL EXPERIENCE:

SQl Server BI Developer

Confidential

• Participated in the logical and physical database designs of the ecommerce applications
• Designed SSIS package templates for a set of data feeds instead of re-developing the same packages
• Usage of Team Foundation Server for SQL and SSIS code management, SQL objects comparison between different environments
• Developed different SSIS project models for different set of projects by completely data driven scenarios
• Implemented SQL Service broker for asynchronous message processing for some transactional databases
• Logging and configuration tables are modelled with XML data for supporting varying number of columns for each set of data feed
• Configured SSIS project models on SSIS DB on the integration services catalogue and set Environmental variables
• Developed SSIS packages to download and upload flat files, Excel files from/to SFTP for the avail of users
• Migrated SSIS 2008 R2 packages to SSIS 2012 using project deployment model
• Identifying the slow and more resources consuming queries, and tune them with the help Query plan analysis like effective analysis each operator in the query plan
• External SSIS tool components “Task Factory” are used in the simplification of package development
• Extensive use of excel (Pivoting, transpose) for data analysis.
• Implemented matching of input business names with external product matching provided by Match IT using CLR routines
• Developed complicated CLR procedures to do communication with Java end points of the Web application
• Writing data fixes for some critical transactional database applications
• Configured Email alerts in the database server for SSIS package failures to the DBAs/Developers
• Developed SSIS packages by effectively utilizing project parameters in a such way, everything can be driven data settings
• Maintaining the production jobs supporting the data and reporting needs.
• Creating Macros and Micros with Microsoft Excel for data analysis and data mapping .
• Implementation of production deployment and issue tracking through JIRA

Confidential - Morristown, NJ

BI/Tableau Developer (Tableau/SSRS/SSIS)

Responsibilities:

• Worked extensively in writing and debugging complex stored procedures, views, triggers and user-defined functions
• Installed SQL Server 2014/2012/2008 R2/2008/05 on Windows Clustered and standalone environments with latest service packs.
• Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
• Mastered the ability to design and deploy rich Graphic visualizations using Tableau.
• Developed Tableau data visualization using Pareto's, Combo charts, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Cross tabs, Histograms etc.
• Developed donut charts for analysing sales planning data and different KPI's using Table calculations and calculated key figures Manipulating strings, arithmetic calculations, aggregation options and Logical functions
• Worked extensively with Advance analytics like Reference Lines and Bands, Trend Line, data building Groups, Hierarchies and sets
• Expertise in different Formatting techniques, using Annotations and Mark labels.
• Developed effective and interactive Dashboards using Parameters and Actions
• Designed the Data warehouse and done the mappings from Source to the Target tables.

  Worked extensively on SSIS packages to implement the data load strategy

• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS
• Deployed SSIS packages into various Environments (Development, Test and PROD) using Deployment Utility.
• Reorg/Rebuilding the indexes at regular intervals for better performance
• Created SQL Server jobs and scheduled them to load data periodically using SQL server Agent.
• Responsible for Import and export data from various data sources like SQL Server Databases, Flat Files,
• MS Access, MS Excel and other OLE DB providers achieved through Importing and Export Wizard in SSIS.
• Developed complex T SQL code for Customer Imports and other interfaces for the PAT and Portal.
• Created and Maintained various database in MS Access to track activities and progress.
• Involved in Dimensional Data Modelling and Cube partitioning in SSAS.
• Generated multi parameterized reports in MS SSRS 2012 allowing users the ability to make selections before executing reports; thus, making them user friendly.
• Created views and Stored Procedures for generating report. Responsible for creating the reports based on the requirements using SSRS.
• Created and Maintained various database in MS Access to track activities and progress.

  Worked on several complex drilldown, parameterized reports and on reports that call sub reports using SSRS.

• 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
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories based on business needs.
• Optimized the queries by creating various clustered, non-clustered indexes and indexed views
• Performance Tuning of Stored Procedures and SQL queries using SQL Profiler and Index Tuning Wizard in SSIS.

Skills Used: MS SQL Server 2012/2008/R2, DTS, SQL Server Management Studio, SSIS, SSRS, SQL Server Business Intelligence Development Studio (BIDS), T-SQL, MS-Access, SQL Server Query Analyzer, ETL, Erwin, Red Gate SQL Source Control.

Confidential

SQL/MSBI Developer (SSRS/SSIS/SSAS)

Responsibilities:

• Development of SSIS ETL packages in optimal way using package execution trees
• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources.
• Using Multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• Worked on Bar charts, line Charts, combo charts, heat maps and incorporated them into dashboards.
• Experience with Sorting, Building Groups and using in visualizations.
• Worked on Global, local and Context filters.
• Used parameters to make dashboards dynamic.
• Worked extensively with Date, String and Logical Functions.
• Created Inventory trends, sales integration and forecast accuracy related dashboards
• Making a Report as per user requirement using MS Reporting Services 2008 (SSRS).
• Created SSIS Packages to migrate slowly changing dimensions.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.
• Worked on improving the performance of the system.
• Involved in the tuning of the existing Database Objects.
• Development of SQL procedures, SQL function implementing business logic
• Development of OLAP cubes for users reporting
• Performance tuning of the application SQL Queries
• All Database Administration activities include Index maintenance, Database consistency check, Updating Database Statistics, Backup strategy of databases and DR strategy
• Improving Stored Procedures performance by using SQL profiler and Database tuning advisor
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Rebuilding the indexes at regular intervals for better performance
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
• Perform SQL Server service pack and Windows Service pack upgrades.
• Improving the OLAP Cube performance by implementing Measure Group Monthly partitions for faster reports generation and faster cube processing
• Came up with different test scenarios for automating Unit test cases, Build verification test cases and Environment test cases
• Developing deployment and build document for the application
• Taking Care of Database File groups and Files growth
• BI Application migration from SQL Server 2008 R2 to a SQL Server 2012
• Grant/Revoke permissions for login accounts as per request
• Handling new change requests and defects for the existing phases in the production environment

Skills Used: MS SQL Server 2012/2008/R2, DTS, SQL Server Management Studio, SSIS, SSRS, SQL Server Business Intelligence Development Studio (BIDS), T-SQL, MS-Access, SQL Server Query Analyzer, TFS, Tableau 8

Confidential

SQL Server Developer Intern

Responsibilities:

• Installed SQL Server 2008 on development and production servers setting up databases, users, roles and permissions.
• Upgraded all SQL Server 2000 to SQL Server 2008 without any service interruption.
• Involved in the all the stages of Software Development Life Cycle (SDLC).
• Involved in the normalization and de - normalization of the databases.
• Created and Modified tables, views, triggers, Indexes, User Defined Functions, Stored Procedures, cursors in SQL Server 2008.
• Wrote the complex queries using joints, Sub-queries, common table expressions (CTE) in T-SQL-2008.
• Improved the performance of the T-SQL queries and Stored procedures by using SQL profiler, Execution plan, SQL performance monitor and Index tuning advisor.
• Created SSIS packages to transfer data from different data sources load it to data warehouse.
• Used SSIS features like event handlers, property expressions, and package configurations, transaction option, checkpoints and protection levels in the packages.
• Migrated DTS packages to SSIS packages using package migration wizard.
• Used containers, Execute SQL task, Execute package task, Script task etc. for transformation of data in the SQL Server Integration Services packages from OLTP to OLAP.
• Created business critical key performance indicators (KPIs) using SQL Server Analysis Services. Wrote MDX queries according to the business requirements.
• Designed and crated distributed reports in multiple formats such as Excel, PDF, XML, HTML and CVS using SQL Server 2008 Reporting Services (SSRS).
• Designed and Implemented Comprehensive Backup plans and disaster recovery strategies and scheduled jobs using SQL Server Agent. Monitored Log shipping/ Transactional Replication and troubleshooting errors.
• Extensively worked on Profiler, Perfmon, DMVs, DMFs and DTA to tune the databases, servers and query tuning.
• Managed Security using SQL Logins, Roles and Security Modes for various users.
• Configured and deployed SSIS Packages from Test to Production Environments.
• Deployed code into the production environment. Provided 24/7 production support for the production database.

Skills Used: MS SQL Server2005/2008, MS BI Stack(SSIS/SSRS)