SUMMARY:

• 5 years of experience with Microsoft SQL Server 2012/2014/2016, SSIS, SSRS, SSAS in Analysis, Design, Development, Integration, Reporting, Maintenance of Database and Client Server applications, Tableau Desktop and Tableau Server.
• MS SQL Server Development experience in Insurance, Online Banking, Finance Facilities Management, domains with expertise in MS SQL Server 2012/2014/2016 .
• Highly proficient in the use of T - SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Defined Functions, Relational Database models and Data integrity, and SQL joins.
• Expert in TSQL-DDL/DML/DCL, perform most of the SQL Server Management Studio functionality using T-SQL Scripts.
• Strong Knowledge on Normalization /De-normalization database design methodology.
• ETL Experience using SSIS (SQL Server Integration Services) in both Development and Production environments.
• Extensive experience in Extraction, Transformation, loading data from DB2, Teradata, SQL Server, Access, Excel, Flat Files and XML using SSIS.
• Proficient in designing Enterprise reports using SQL Server 2012/2014/2016 Reporting Services (SSRS) to generate Drill down, Drill through, Parameterized, Linked, Matrix and Chart Reports.
• Good understanding in Database and Data Warehousing concepts (OLTP & OLAP).
• Experience in data warehousing such as dimensional modeling, ER modeling, star and snowflake schemas, data marts, fact and dimension tables identification, and Operational Data Store (ODS).
• Creating Named Queries and Named calculations. Creating Dimensions, Hierarchies and levels, Star and Snowflake schemas using SSAS.
• Involved in developing and deploying OLAP Cubes and browsing cube data using SSAS.
• Hands on Experience in development of Reports and Dashboards in Tableau.
• Hands on Experience with Tableau 8.2/9.0/10.0/10.1/2018.1 and the Tableau reader.
• Experience in creating aggregates, hierarchies, charts, filters, quick filters, table calculations, trend lines and calculated measures.
• Ability to analyze and dissect user requirements and build Front-End BI applications according to specifications.
• 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.
• Conversant with all phase of Software Development Life Cycle (SDLC).
• Excellent problem solving, analytical, technical, interpersonal and communication skills and an extremely diligent strong team player with an ability to take new roles.
• Developed effective working relationships with client team to understand support requirements, develop tactical and strategic plans to implement technology solutions, and effectively manage client expectations.

TECHNICAL SKILLS:

Programming Languages: SQL, Transact SQL, PL/SQL, C, C++ and Java.

Databases: MS SQL Server 2012/2014/2016, MS Access 2007/ 2010/2013/2016 and My SQL.

Database Management Tools: SQL Server Management Studio.

Database Design Tools: Workbench 5.2/6.0, ERWIN R3.0

Reporting Tools: Tableau Desktop 8.2/9.0/10.0/10.1/10.2/2018.1, Tableau Server and SQL Server Reporting Services (SSRS) 2012/2014/2016 .

ETL Tools: SQL Server Integration Service (SSIS) 2012/2014/2016 .

Data Modeling: Physical and Logical Data Modeling.

Data Warehousing & BI: Star Schema, Snowflake schema, Facts and Dimensions tables.

Operating System: Windows 2003/XP/Vista/7/8/10, UNIX, Linux and MS-DOS.

Other Tools: Microsoft Visual Studio 2013/2015/2017, MS Visio 2010/2013/2016, MS Office Suite, OLAP & OLTP, Adobe Photoshop.

PROFESSIONAL EXPERIENCE:

Confidential, New Jersey, NJ

DateTableau/ Reporting Analyst

Responsibilities:

• Created visualizations, calculated fields, Filters, Actions, LOD’s, Maps, Worksheets, Dashboards in Tableau Desktop.
• Involved in the administration of Tableau server like installations, upgrades, user, user groups creation and setting up security features.
• Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Involved in representing data using crosstab-scatter plots, geographical maps-pie charts and bar charts, motion charts-small multiples, heap maps-density charts.
• Implement trend analysis and forecasting on real-time data from multiple sources using Tableau and apply in business solutions.
• Worked on creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Extracted and analyzed data from a variety of sources like Teradata, SAS data sets, MS access, MS Excel, CSV, XML, flat files etc.
• Performed unit test/integrated testing scenarios which were used to obtain the UAT's.
• Platform Setup.
• Minor and Major Release Upgrades.
• Tableau Teradata Performance Tuning.
• PDF automations.
• Troubleshooting day to day issues.
• Reporting Bugs to Tableau.
• Segregation of Single environment to multiple sector environments.
• Performed entire lift and shift of Tableau cluster.
• Set up of Tableau environment in Physical Servers, VM’s, Amazon Cloud, Microsoft Azure for performance testing.
• Dashboard Development & Building Customized Admin views.
• Providing Trainings on Tableau server.
• Analyzing Deployment Reviews on Quarterly basis.

Environment: Tableau Desktop 8.2/9.0/10.0/10.1/10.2/2018.1 and Tableau Server.

Confidential, New Jersey, NJ

BI Developer

Responsibilities:

• Involves in Planning, Defining and Designing data based on business requirements and provide documentation
• Installation and configuration of SQL Server 2012/2014.
• Created the SSIS packages to read/extract the data from excel sheets, SQL Server, other data sources and merge into SQL Server and vice-versa, involved in scheduling and monitoring.
• Wrote User defined functions, views, trigger, and indexes for various purposes based on the requirements
• Created the Load packages for loading the CSV files from DB2 into SQL Server using SSIS.
• Developed Unit Test Plans for SSIS packages for checking the functionality of each component.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Scheduled Jobs for executing the stored SSIS packages, which were developed to update the database on Daily basis.
• Extracted data from SQL Server for report, backup, testing purpose by using SSIS.
• Perform Tableau Server admin duties; add users/groups from Active Directory; and schedule instances in Tableau Server including weekly data dump.
• Building, publishing customized interactive reports and dashboards, report scheduling on Tableau server.
• Implement action filters, parameters, calculated filed and set for preparing dashboards and worksheets in Tableau.
• Develop dashboards in Tableau Desktop and published them on to Tableau Server that allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information
• Worked with business analysts, interpreted business requirements that users looked to dashboards to answer and created server-based Tableau dashboards with automatic updates.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Created extensive joins and data blending from several different data sources.
• Developed metrics, attributes, filters, reports, dashboards, storyboards and created advanced chart types, visualizations and complex calculations to manipulate the data.
• Used multiple Measures like Individual Axis, Blended Axis and Dual Axis.
• Create complex formulas and calculations within Tableau Desktop to meet the needs of complex business logic.
• Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
• Created Bar Charts which is complied with data sets and added trend, reference lines and forecasting.
• Created data views from different data sources like Oracle, DB2, SQL Server.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.

Environment: Tableau Desktop, Tableau Server, MS SQL Server 2012/2014/16, MS SQL Server Integration Services, MS Excel, Query Analyzer.

Confidential

BI Developer

Responsibilities:

• Updated all the current systems (SQL Server 2008) into one version of SQL Server 2012. by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.Involved in extensive data validation
• Created & Implemented Database Components Databases, Tables, Joins, views, Constraints, Stored procedures, and Functions.
• Created SSIS Packages to load data from sources like Flat files, excel, OLEDB, XML, and Oracle to SQL Server.
• Extensively used SSIS to move data from text files to SQL Server.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases and data mart databases.
• Scheduled jobs and alerts using SQL server agent
• Involved in integrating different Database Applications using SSIS packages.
• Creating SSIS packages that involves migration from legacy systems to centralized Database.
• Designed and tested packages to extract, transform and load data (ETL) using SSIS, designed packages which are utilized for tasks and transformations such as Execute SQL Task, Mapping the right and required data from source to destination, Data Flow Task, Data Conversion, Foreach Loop Container.
• Expert in using the work flow canvas for multiple transformations of data and the use of different features like variables, package configurations, event handlers, error logging and check points to facilitate various complex ETL logics and specifications
• Validate data before performing ETL transformations and load into SQL server database.
• Intensively worked on transformations like Derived column, import column, Export column, Row count, Union all, Copy column, Lookup, Data Conversion with SSIS.
• Used task factory components and transformation like Insert destination, Update batch transformation, Null Handler Transformation, Surrogate Key Transformation, Advanced Email and SMS Task in SSIS packages
• Worked with Web Service task where some of the binary files will be converted into XML element to place in Message Broker queue.
• Worked on Deployment of packages into Production servers and managed scheduled SQL jobs.
• Created stored procedures, Cursors, Joins in T-SQL.
• Manually documented each process and the flow of the package.
• Created Drill down and Drill through reports, also scheduled and managed weekly/monthly inspection and violation reports based on the business requirements.
• Implemented Distributed Transaction Control for the SSIS packages and event handlers to keep track of error logs. Also, to trigger emails about the failure using Email task.
• Designed and created Report templates, bar graphs and pie charts based on the inspection data.

Environment: Microsoft SQL Server 2008/2012, Microsoft Excel, SSIS/SSRS 2014/2012/2008, Microsoft Office, MS VISO, Profiler, Visual Source Safe, BIDS, Visual Studio, MS BizTalk Server.

Confidential

SQL Server Developer

Responsibilities:

• Installing and Configuring of SQL Server 2012 0n windows XP/7.
• Managing of databases objects like Tables, views, indexes etc.
• Created & Implemented Database Components, Databases, Tables, Joins, views, Constraints, Stored procedures, and Functions.
• Used T-SQL to create various queries.
• Optimized query performance with modifications in T-SQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, and establishing necessary joins.
• Involved in designing and implementing the Stored Procedures and Triggers for automating tasks.
• Daily Database backups and integrity checking.
• Implementing Backups and restoring when necessary.
• Extensively used joins and sub queries to simplify complex queries involving multiple tables.
• Developed scripts for maintaining administration tasks.

Environment: MS-SQL Server Management Studio 2008/2012, T-SQL, Windows XP/Windows 7, MS Access 2007/2010.