SUMMARY

• Over 7 years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2005/2008R 2/2012/2014/2016 in Development, Test and Production Environments on various business domains.
• Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2005/2008 R 2/2012 /2014/2016.
• Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).
• Developing reports in SSRS with SQL Server (2000/2005/2008/2010/2012/2014 ).
• Experience in using T - SQL in SQL Server 2000/2005 and 2008 platforms.
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports
• Building, publishing customized interactive reports and Dashboards, report scheduling using Tableau server.
• Created Action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Hands on experience in Creating Star Schema and Snow Flake Schemas, Involved in writing MDX Scripts, generating Static Reports using MDX queries and MDX Base Report Definition. Sound Experience in SSAS, OLAP cube and Architecture.
• Experience in creating packages to transfer data between ORACLE, MS ACCESS and FLAT FILES to SQL SERVER using DTS/SSIS.
• Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.
• Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule SSIS Packages.
• Great ability to create and manage various database objects like tables, views, indexes and sequences.
• Experience in Data Modeling, Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files.
• Involved in Query Optimization and Performance Tuning using SQL Profiler and Index Tuning Wizard.
• Experience in Created complex SSIS packages using proper control and data flow elements with error handling.
• Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T-SQL.
• Created and deployed SSIS packages using various transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.
• Well versed in Performance Point Server 2007. Designed Dashboards, Scorecards and reports using multiple KPI’s, OLAP charts and SSRS Reports with PPS.
• Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player.
• Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure.

TECHNICAL SKILLS

SQL Server tools: Enterprise Manager, SQL Profiler, Query Analyzer, Tableau Desktop, Tableau Server, Tableau online, DTS, SSIS, SSRS, SSAS, BI, Development studio, Analysis Manager, Visual Studio.

Database: MS SQL Server 2014/2012/2010 , 2008 R2, 2005, SQL CMD, Microsoft Office

Methodologies: SDLC, Agile, Waterfall

Language: C, C++, HTML, XML, TSQL, MYSQL, DHTML, VB.NET, ASP.NET, C#, JavaScript.

Operating System: Windows, IOS, UNIX.

RDBMS: Oracle, MY SQL, MS SQL Server

Tools: Erwin Data Modeler, MS Visio, SAS/Access, Crystal Reports 8.5,10, XI, R2, Microsoft office 2003/2007, Team Foundation Server (TFS), EXCEL, Geocoder, LINQ Pad, Toad.

ETL TOOLS: SQL server integration system (SSIS), Data transformation services (DTS), T - SQL stored procedures.

Transformations: Business Intelligence, Split And Join, Row, Row-Set, aggregate, conditional split, data conversion, lookup, merge, merge join, multicast, union all, bulk insert.

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia, PA

Tableau developer /SQL Server BI Developer

Environment: Tableau Desktop 9/8, Tableau Server 9/8, MS SQL Server 2016/2014/2012 , MS SQL Server Integration Services, TFS, MS SQL Server Reporting Services, MS Visual Studio 2012, Erwin, Informatica.

Responsibilities:

• Gathered Business Requirements, interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes
• Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports
• Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau
• Created sheet selector to accommodate multiple chart types in a single dashboard by using parameters
• Using Multiple Measures like Individual Axes, Blended Axes, and Dual Axe
• Extensively usedcalculatedfields for different logics for Trend, Extended price calculations for the different cost types
• Found efficientways to make tables and graphs which were visually easy to understand and at the same time maintaining the accuracy of the core information content
• Created visualizations for logistics calculations and departmental spendanalysis.
• Utilizedsample data to create dashboard while ETL team were cleaning data from source systems
• Validated the results inTableauby running SQL queries in MS SQL developer
• Conducted user acceptance testing and mentored business users how to slice and dice data using filters and parameters
• Created and maintained issue log where business users enter their feedback by working on dashboard in test environment.
• Implemented the feedback and incorporated the necessary changes.
• Developedtableaufunctional design document
• Performed performance tuning of the dashboard inTableaudesktop
• Published the developed dashboards into production and ensured the data was up to date by scheduling extract refreshes
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse
• Involved in the development of SSIS Packages for cleaning and scrubbing of data using Lookup and Fuzzy Lookup transformations to validate the data
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities

Confidential, Princeton, NJ

SQL Server BI Developer

Environment: MS SQL Server 2014, Visual Studio2012, SSIS, SSRS, Tableau server, Tableau desktop, Query Analyzer, Database Engine tuning wizard, MS Access, TFS, MS Excel, ERWIN, Windows Server 2012, Oracle 11g, Toad, MS-Visio, ETL Informatica

Responsibilities:

• Worked on Agile/SCRUM methodology for iterative and incremental development.
• Actively involved in gathering and analyzing stakeholder’s requirements.
• Installed and Configured SQL Server 2014 successfully.
• Worked on latest version of all software's like Visual Studio 2012 ultimate, Management Studio 2014.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Developed tabular queries for efficient analysis of report using Pivot/Un pivot in T-SQL.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
• Designed many technical documents individually to help the team understand the requirement for Building packages using SSIS.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse.
• Responsible for Deploying, Scheduling, Alerting and Maintaining SSIS packages.
• Created and deployed SSIS packages using various transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.
• Used SQL Queries at the custom SQL level to pull the data intableaudesktop
• Used Execution Plan to optimize and enhance the performance of SQL Queries.
• Created tabular and matrix reports in SSRS. Wrote stored procedures and functions to create SSRS reports.
• Created SSIS packages to import data from MS Access, Excel to SQL 2014.
• Developed complex stored procedures using T-SQL to generate Ad hoc reports within SQL Server Reporting Service (SSRS).
• Built different types of chart reports using SSRS for the business requirement like column chart, Pie Charts.
• Proficiently created Reports based on the requirements using SSRS.
• Defined parameters for parameterized Reports.
• Converted few reports from crystal reports to SSRS.
• Created SSIS package to automate maintenance, database back up, update statistics, re-build indexes as well as create error log for event during data load.
• Held responsibility for database maintenance plans.
• Explored Erwin for Data Mapping and Modeling.
• Created alerts, notifications, and e-mails for system errors.
• Performed unit testing for every package created.
• Deployed and scheduled tidal Job a job for SSIS Package for different environment.

Confidential, Parsippany, NJ

SQL Server BI Developer

Environment: MS SQL Server 2012, T-SQL, SSRS, SSAS, SSIS Packages, MDX, ETL, Erwin, ASP.Net, C#.Net, Excel, Business, SharePoint Server, ProClarity, OLAP, OLTP, Access, Windows 2003 Server, IIS 6.0.

Responsibilities:

• Actively collaborate with users, Team leads, and technical managers to fully understand the requirements of the system.
• Creating various reports on Daily, Weekly and Monthly basis.
• Involved in migration from SQL Server 2008 to SQL Server 2012.
• Server maintenance and support of SSAS, SQL Server and MYSQL Server
• Performing Replication, Backup compression for individual tables and indexes and reducing the disk usage.
• Created SQL server Reports using SSRS. Identified the data source and defined them to build the data source views
• Involved in the analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design (SSRS).
• Designed the OLAP systems for data mart applications using SQL Server Analysis Services (SSAS).
• Used scripts and variables, email notifications for ETL process using Data Integrator.
• Designed Data flows, Workflows and jobs to load data from source to target in BO Data Integrator.
• Enhancing and deploying the SSIS packages from development server to production server.
• Designed and built OLAP cubes to meet reporting needs.
• Performed Documentation for all kinds of reports and SSIS packages.
• Understanding OLAP process for changing and maintaining the Warehouse, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Created Packages in SSIS with Error Handling.
• Used various ETL tools like SSIS for data flow from source files like XML, Excel, Tables and views to other databases or files with proper mapping.
• Created reports in SSRS with different type of properties like chart controls, filters, Interactive Sorting, SQL parameters etc
• Wrote complex MDX queries for calculated members and measure groups.
• Created Time Dimensions on OLAP Cubes using SSAS.
• Extensively used T-SQL in constructing User Defined Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Created complex SSIS packages using proper Control and Data flow elements.
• Used System Tables, System Stored Procedure, DBCC commands for Database maintenance.

Confidential, Rochelle Park, NJ

SQL Server BI Developer

Environment: SQL Server 2008 R2, XML, T-SQL, SQL Server Integration Services, SQL Server Reporting Services, MDX, SQL Profiler, Visual Studio, .NET Frame Work, SharePoint.

Responsibilities:

• Created SSIS packages and used Analysis Services processing task to update the cube with current data.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and Billing Systems
• Extract Transform and Load (ETL) source data into respective target tables to build the required data marts.
• Created SSIS packages to load data from Oracle to SQL Server using various transformations in SSIS.
• Worked on the Reports module of the project as a developer on MS SQL Server 2005 (using SSRS, T-SQL, scripts, stored procedures and views).
• SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS
• Analyzed the existing tool and participated in meetings with the business users to gather
• Requirements and design goals of data warehouse.
• Identified the dimension, fact tables and designed the data warehouse using star schema.
• Developed Multi-dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
• Designed Dimensional Modeling using SSAS packages for End-User. Created Hierarchies in Dimensional Modeling.
• Used SQL CMD to write Stored Procedures in command line utility and it uses OLEDB to execute T-SQL batches.
• Developed Aggregations, partitions and calculated members for cube as per business requirements.
• Defined appropriate measure groups and KPIs & deployed cubes.
• Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by Using SSRS.
• Created report snapshots to improve the performance of SSRS.
• Responsible for managing daily activities of department including compliance initiatives, group practice agreements, managing health care claim strategies and other.
• Responsible for helping manage the daily operation of the company, meeting with clients and brokers for brokerage, holding employee meetings, resolving conflicts.
• Created T-SQL Functions, Cursors, views, indexes, stored procedures and triggers.

Confidential

BI Developer

Environment: SQL Server 2008, Windows Server, T-SQL, SQL Server Reporting Services

Responsibilities:

• Created ETL metadata reports using SSRS, reports include like execution times
• Responsible for Data migration from SQL Server 2005 to SQL Server 2008 Databases.
• Developed an automated report subscription process using SSRS.
• Applied conditional formatting in SSRS to highlight key areas in the report data
• Used Report Builder to do Ad-hoc Reporting.
• Created report links to refer other reports in a report.
• Resolved any deadlocks issues with the Databases/Servers on a timely basis.
• In-Depth working knowledge of ODBC.
• Imported and exported data into MS Access databases and Debugged VBA scripts linked to said databases.
• Configured the loading of data into slowly changing dimensions using Slowly Changing Dimension wizard.
• Created multiple hierarchical aggregates for faster performance.
• Installed SQL server 2008 on Windows 2003 server and involved in Physical and logical Database Design using Erwin tool.
• Created database objects like tables, users, roles, stored procedures, triggers.
• Worked on solving issues by doing data recovery in existing database.
• Used various formatting techniques like interactive sorting, grouping to created user friendly reports.

Confidential

SQL Server Developer

Environment: MS SQL Server 2008, MS Access, Query Analyzer, BCP, SQL Profiler, Import & Export Data, Windows Server, Crystal Reports, Excel.

Responsibilities:

• Gathered requirements to identify and create database objects such as tables, views, triggers and indexes, User defined functions, Cursors, Stored Procedure, Constraints and Roles.
• Involved in Normalization of the database and bringing it to 3NF.
• Involved in creating the constraints, rules, defaults and triggers to maintain the data and referential integrity.
• Performed data conversions from flat files into a normalized database structure.
• Created Views to enforce security and data customization.
• Created Non-Clustered indexes to improve query performance and query optimization for maximum efficiency
• Created Stored Procedures for commonly used complex queries involving join and union of multiple tables.
• Tested to optimize the Stored Procedures and Triggers to be used in production.
• Maintained the client relationship by communicating the daily status and weekly status of the project.
• Worked in Enterprise Manager for job scheduling and batch queries.
• Managed and monitored the use of disk space.
• Planned Backup strategy based on projects requirements. Maintained the consistency of the client’s Database using DBCC.