SUMMARY

• Having around 6 years of professional IT experience as SQL Developer, BI Developer and Application developer.
• Involved in publishing of various kinds of interactive data visualizations, dashboards, and workbooks from Tableau Desktop to Tableau Servers.
• Have been working with various data sources such as Oracle, SQL Server, Hadoop, SAP, SSIS, SSAS, ODBC and flat file sources.
• Experience in reports validating and modeling data with the purpose of understanding or making conclusions from the data for decision making.
• Experience in using Filters, sorts, groups and Sets, reference lines, Bands and Boxes in different kinds of charts by using Tableau and power BI.
• Experience on working with MSSQL, MS Access, and Oracle.
• Experience in developing systems built on SQL Server 2008, 2008 R2, 2010 and 2012 using tables, triggers, views, packages and stored procedures in SQL & PL/SQL.
• Experience in reporting services like SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS).
• Experience in developing complex Stored Procedures, Functions, Views, Joins and Sub queries with PLSQL.
• Experience in providing Logging, Error handling by using Event Handlers in SSIS Packages.
• Experience in programming .NET technologies for communication between application and database.
• Experience in working with different software development methodologies like Scrum and Agile development methodology.
• Experience in development and testing phase in SDLC.
• Knowledge on Hadoop and worked on database with Hive.
• Having good knowledge on Banking and Healthcare domains.
• Flexible, enthusiastic and project - oriented team player with excellent written, verbal communication and leadership skills to develop creative solutions for challenging client needs.

TECHNICAL SKILLS

BI Experience: Tableau versions 8,9,10, Power BI, SSIS 2008/2012, SSRS 2008/2012, SSAS 2008

Languages: C, C++, C#, PL/SQL and SQL.

Web Technologies: ASP, HTML, Java Script, CSS

Database: SQL Server 2012/2008/2005 , Oracle 10g/11g and 12C, My SQL

Development Tools: Tableau, MS Visual Studio 2005/2008/2010/2013/2015

Operating Systems: Windows 10/8/7

Version Control Tools: Tortoise SVN, TFS

PROFESSIONAL EXPERIENCE

Confidential, Tampa, FL

Software Engineer

Responsibilities:

• Involved in interacting with stakeholders, IT and identifying problem areas, gathering requirements and documenting.
• Worked with internal and external customers and IT partners to develop and analyze business intelligence needs.
• Developed ad-hoc reports to conduct data analysis and validation.
• Involved in interacting with stakeholders, IT and identifying problem areas, gathering requirements and documenting.
• Worked with internal and external customers and IT partners to develop and analyze business intelligence needs.
• Created visualizations in tableau understanding the business values of the report and delivering it.
• Involved completely on Agile project throughout the period along with the business.
• Designed and developedPowerBIgraphical and visualization solutions with business requirement documents (BRD) and plans for creating interactive dashboards.
• Setup the platform for integrate SSAS Built in data model and Power Pivot files.
• Trained Business users to access and share their data models and files on Power BI environment.
• UtilizedPowerBI(PowerPivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper level management.
• Document code consistently throughout the development process by listing a description of the program, special instructions, and any changes made in database tables on procedural, modular and database level.
• Developed and supported many scheduler jobs using Windows Batch Scripting, PLSQL and C#. Written Unit Test Cases to test C# methods using N-unit and sonarqube.
• Created various Queries, Stored Procedures, Packages, Functions and Triggers with Oracle 11g and 12C.
• Data grids, Datasets are used extensively to display various PL-SQL server elements allowing real-time updates.
• Responsible for analysis of current programs including performance, diagnosis and troubleshooting of problem programs, and designing solutions to problematic programming.
• Performed unit testing on every new version before sending it for User Acceptance Test (UAT).

Environment: Tableau Desktop 10,10.0.1,10.0.3, Tableau Server 10.3, Power BI, PL/SQL,Excel, SQL Server 2014, Tableau Data Extract (TDE), Microsoft Excel.

Confidential, Boise, ID

Tableau Consultant

Responsibilities:

• Involved in requirement gathering/analysis, Design, Development, Testing and Production rollover of Reporting and Analysis projects.
• Resolved various performance issues and analyzed the best process distribution for different projects.
• Involved with Admin team in upgrading the tableau server to higher versions according to the requirement.
• Developed the dashboards from the scratch by taking the requirements through end-users/Business.
• Worked with the TABLEAU ELITE SUPPORT on daily basis and with the TABLEAU SOLUTION ARCHITECTS.
• Published the dashboard reports to Tableau Server for navigating the developed dashboards in web.
• Building complex formulas in Tableau for various business calculations.
• Scheduled the published dashboards from Tableau Server on weekly basis.
• Provided Performance tuning of Reports and best practices.
• Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
• Created data connections, published on Tableau server for using with operations/monitoring Dashboards

Environment: Tableau Server 9.0,9.2, Tableau Desktop 9.0.x,9.2.x, Oracle 10g, Oracle 11g, Excel, UNIX, SQL Server 2008, MS Office, Visual Studio 2010.

Confidential, Madison, WI

Tableau Developer

Responsibilities:

• Involved in requirement gathering/analysis, Design, Development, Testing and Production rollover of Reporting and Analysis projects
• Published the dashboard reports to Tableau Server for navigating the developed dashboards in web.
• Scheduled the published dashboards from Tableau Server on weekly basis.
• Sending the dashboards to users by emails with the help of admin team with subscriptions.
• Performance tuning of Reports by creating Linked Universes, Joins, Contexts, Aliases for resolving loops and checked the integrity of the universes using Business Objects Designer module during development.
• Given training/demos to users on Tableau Desktop for development.
• Created Data Connections, published on Tableau Server for usage with Operational/Monitoring Dashboards.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Built complex formulas in Tableau for various business calculations.
• Resolved various performance issues and analyzed the best process distribution for different projects.

Environment: Tableau Server, Tableau Desktop 8, MYSQL Server, Oracle 10g, Excel, UNIX, SQL Server 2008, Oracle 11g, MS Office, Visual Studio 2010.

Confidential

Software Engineer

Responsibilities:

• Involved in designing of Conceptual Logical Model and Physical Model.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using SQL in Development and Production environment for SQL Server.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Programmed ADO.NET for communication between application and database, used extensively Data Grid, Data Set, Data Table, Data Adapter and Data Readers to render reports.
• Worked on CSS and Java Script to create visually appealing User Interfaces.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Wrote PLSQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.
• Worked on complex stored procedures to implement business logic.
• Worked extensively on Scripts Creation (Create, Drop, Insert, Update, Alter and Delete).
• Importing source/target tables from the respective data base by using execute package task using control flow tasks in SQL Server 2008 Integration Services.
• Created transformations and mappings using data flow tasks.
• Created event handlers per the package using event handler tab.
• Used transformations like Merge join, Conditional Split, Union all, Pivot, Lookup, Sort, Data Conversion and Script Task to load data into Data Mart.

Confidential

Responsibilities:

• Involved in requirement analysis as per the customer requirements.
• Used Visual Studio 2008 development tool for building Web Application.
• Used SSIS to create ETL packages to validate, extract, transform and load data to Data warehouse databases and data mart databases.
• Supported many scheduler jobs using Windows Batch Scripting and C#.
• Programmed ADO.NET for communication between application and database
• Developed various operational, Dashboard reports using SSRS.
• Created Tables, Stored procedures and defined functions.
• Designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task and Data conversion task in SSIS Designer.
• Developed, monitored and deployed SSIS packages.
• Created and modified tables, stored procedures, triggers, check constraints and functions.
• Created triggers to keep track of changes to the fields of tables when changes are made.
• Attended daily standup calls as part of “Agile” methodology.
• Developed reports using SQL Server Reporting Services and utilizing complex SQL queries and stored procedures.
• Configure and maintain Report Manager and Report Server for SSRS.

Confidential

Tableau/SQL developer (Intern)

Responsibilities:

• Involved in generating proper data in excel for Tableau Dashboard.
• Extensive use of Access Database to load Excel file as a table.
• Skillfully Used Link Tables utility to update Access table to reflect the Excel changes.
• Extensive use of SQL Join to fetch the appropriate data for Tableau Dashboard.
• Advocate the use of Tableau solution and help educate business users to facilitate early adoption of the tool.
• Created complex calculation fields using Table Calculation, Date, Aggregate functions in Tableau.
• Skillfully created different kinds of actions for navigation and drill down.
• Skillfully Created Bar graph inside Tooltip and complex graphs using multi Measures.
• Extensive use of Add Reference line at Cell, Pane, and Table level.
• Used Incremental Extract Refresh to improve the performance.
• Proficient at Unit level testing, Module level testing, and System testing.
• Responsible for all Tableau administration activity like Adding New User, granting permission to new user for a particular Dashboard, Monitoring User and server Activity, Scheduling Extract.

Environment: Tableau 8, Microsoft Access, Microsoft Excel, MS SQL Server 2008, Oracle.