SUMMARY:

• Having 11+ years of experience in IT industry
• Having extensive hands on experience in Business Intelligence, Information Management & Data Analytics projects
• Experience in complete SDLC of requirement gathering/analysis, Design, Development, Testing and Production rollover of Reporting and Analytics projects
• Experience working with Tableau Desktop and Tableau Server
• Experience in creating different visualizations using Bars, Lines, Pies, Maps, and Bubbles etc
• Experience in using different features of Tableau Desktop I.e. Filters, Parameters, Actions and Calculations etc.
• Experience publishing, scheduling, subscribing Tableau reports in Tableau Server
• Experience installing, upgrading and maintaining Tableau Server
• Experience working with Business Intelligence projects
• Experience working with ETL tools like SSIS (SQL Server Integration Services)
• Experience working with reporting tools like SSRS (SQL Server Reporting Services) and Cognos
• Working experience with various databases like SQL Server, Oracle and MS Access etc.
• Experience working with projects related to data modeling, system/ data analysis, design and development for OLTP, OLAP and Data warehousing environments
• Experience developing and maintaining web applications using .Net, ASP.Net, C#.Net, VB.Net, WCF
• Experienced in BFS (Banking & Financial Services), Healthcare, Travel and Manufacturing domains
• An experienced team player with excellent communication and interpersonal skills who has the ability to work independently under pressure can lead, motivate and influence others
• Experience working with Agile methodology
• Experience working as a Team member, Team Lead and also managed projects successfully

TECHNICAL SKILLS:

Visualization Tools: - Tableau Desktop, Tableau Server, Tableau Online, Tableau Public

Reporting Tools: - SSRS (MS SQL Server Reporting Services), Cognos

ETL Tools: - DTS, SSIS (MS SQL Server Integration Services)

Databases: - MS SQL Server, Oracle

DB Concepts: - RDBMS, OLTP, OLAP, Data Modeling, Dimensional, Entity Relational, ER Diagrams, Data Mining, Data warehousing, Data Marts etc

Languages: - SQL, PL/SQL, .Net(2.0, 2.5, 3.0, 3.5), Asp.Net, C#.Net, VB.Net, HTML, XML, Ajax

Products: - Microsoft Amalga, ProAccess, Nexus

Operating systems: - Windows

Development Tools: - Microsoft Visual Studio, BIDS (Business Intelligence Development Studio), SSDT (SQL Server Data Tools)

Testing Tools: - Microsoft Test Manager 2010

Version Control Tools: - TFS (Team Foundation Server), SVN

Web Services: - WCF (Windows Communication Foundation)

Scripting: - Ajax, JavaScript, PowerShell

PROFESSIONAL EXPERIENCE:

Confidential, Minneapolis, MN

Sr. Tableau Developer & Administrator

Environment: Tableau Desktop, Tableau Server, SQL Server, Oracle, SQL, PL/SQL, SSIS, SSRS

Responsibilities:

• Gathering requirements from business
• Involved in reviewing business requirements and analyzing data sources
• Developed compelling, Interactive Dashboards using different features like Filters, Parameters, Actions, Calculations (using logical, String, Table, Aggregate functions) and formatting the reports/dashboards (Layout Containers, Annotations, Mark Labels etc.,)
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once
• Created customized Calculations, Conditions and Filters (Local, Global) for various analytical reports and dashboards
• Developed different visualizations using Bars, Lines, Pies, Maps and Bubbles etc.
• Developed Cross Tab, Chart, Funnel charts, Donut charts, Heat Maps, Tree Maps and Drill Through Reports etc. in Tableau Desktop
• Developed story telling dashboards inTableauDesktop and published them on toTableauServer 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 onTableauServer for weeklyand monthlyincrementsbased on business change to ensure that the views and dashboards were displaying the changed data accurately
• Worked closely with business power users to create reports/dashboards using Tableau Desktop and publish them to Tableau Server
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data
• Involved in developing and testing the SQL Scripts for report development, Tableau reports, Dashboards and handled the performance issues effectively
• Consistently attended meetings with the business subject matter experts to acquire functional business requirements in order to build SQL queries that would be used in dashboards to satisfy the business’s needs
• Involved in publishing, scheduling and subscriptions with Tableau Server
• Creating and Maintaining SSRS reports
• Created different kind of reports like cascading prompts, Drilldown reports, Drill through Reports, Parameterized reports, Sub reports, Linked reports and charts in SSRS
• Migrating SSRS reports to Tableau reports
• Create ETL packages to move data from feed files (XML, CSV and TXT) to database.
• Create packages to migrate data from oracle to SQL Server.
• Developed Unit Test Plans for SSIS packages.
• Involved in Data modeling (dimensional & relational) concepts like star schema, snow flake, fact and dimensional tables
• Developed complex Stored Procedures, CTEs, Functions, Triggers, Cursors, Tables, Views, Indexes and other SQL joins and statements for applications.
• Involved in Installation, configuration of SQL Server

Confidential

Sr. Tableau Developer/Analyst

Environment: Tableau Desktop, Tableau Server, SQL Server, Oracle, SQL, PL/SQL, SSIS, SSRS

Responsibilities:

• Gathering requirements from business users
• Interacted with Subject Matter Experts and Business users for reporting requirements analysis and to define business and functional specifications
• Understanding functionality of legacy applications, data and reports
• Involved in reviewing business requirements and analyzing data sources
• Developed different visualizations using Bars, Lines, Pies, Maps and Bubbles etc.
• Developed Cross Tab, Chart, Funnel charts, Donut charts, Heat Maps, Tree Maps and Drill Through Reports etc. in Tableau Desktop
• Developed story telling dashboards inTableauDesktop and published them on toTableauServer which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Installed and Upgraded Tableau servers to the latest versions after rigorous testing
• Modifying the existing Tableau reports as per the business needs
• Ability to understand customer requirements, expertise in data blending, joins, designing visual constructs etc.
• Creating a design and development of tableau visualization solution
• Created complex formulas and calculations with in tableau
• Implemented navigation and drill down features in Tableau dashboards.
• Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers
• Scheduled data refresh onTableauServer for weeklyand monthlyincrementsbased on business change to ensure that the views and dashboards were displaying the changed data accurately
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data
• Involved in practical understanding of Data modeling (dimensional & relational) concepts like star schema, snow flake, fact and dimensional tables
• Creating and Maintaining SSRS reports
• Created reports in SSRS with different types of properties like chart controls, filter, interactive sorting, SQL parameters etc
• Designed, Developed and Deployed reports in MS SQL Server environment SSRS
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled Jobs to call the packages and Stored Procedures.
• Created and Modified SSIS packages to meet current business needs
• Experienced in using fuzzy lookup, derived column and slowly changing Dimensions (SCD) to clean data, improve SSIS package performance and error- trapping using logging and event handler.
• Developed complex Stored Procedures, User defined functions (UDF), Cursors, Tables, Views, Indexes and other SQL joins and statements for applications.
• Planned and scheduled backup strategy to ensure reliable backup..

Confidential

Tableau Consultant

Environment: Tableau Desktop, Tableau Server, SQL Server, SQL, PL/SQL, SSIS, SSRS

Responsibilities:

• Involved in understanding the reporting requirements and providing Tableau reporting solutions.
• Develop, maintain and document highly visualized comprehensive dashboards using Tableau Desktop and publish it to Tableau Server to meet business specific challenges.
• Created visually compelling and actionable interactive Tableau reports and dashboards.
• Installed and Upgraded Tableau servers to the latest versions
• Prepare dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau
• Developed multiple reports/dashboards using Dual Axis charts, Histograms, Filled map, Bubble chart, Bar chart, Line chart, Tree map, Box and Whisker Plot, Stacked Bar etc.
• Presented to the higher management the discovered trends and analysis, forecast data, recommendations and risks identified.
• Involved in creating and understanding of ER diagrams for Entity Relational data modeling
• Act as a liaison between stake holders, clients, reporting and software development teams and conduct sessions, one-on-one meetings to collect requirements.
• Perform Gap Analysis and feasibility study for implementing Extract/reporting enhancements.
• Help in data modelling efforts to decide on various entities and relationship between them.
• Created Logical and Physical data models
• Involved in creating and understanding of ER diagrams for Entity Relational data modeling
• Developed complex Stored Procedures, Functions, Triggers, Cursors, Tables, Views, Indexes and other SQL joins and statements for applications.
• Designed and implemented stored procedures and triggers for automating tasks.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled Jobs to call the packages and Stored Procedures.
• Document the process flow and logic to move data from staging to data warehouse.
• Create UAT test document to deploy SSIS packages on QA, UAT and production.
• Create packages using multithreading enabling the parallel processing property of SSIS.
• Creating and Maintaining SSRS reports
• Create parameterized reports to accommodate business required
• Created different kind of reports like cascading prompts, Drilldown reports, Drill through Reports, Parameterized reports, Sub reports, Linked reports and charts in SSRS

Confidential

Tableau Developer

Environment: Tableau Desktop, Tableau Server, SQL Server, SQL, PL/SQL, SSRS, SSIS, ProAccess, Nexus

Responsibilities:

• Formalized the reporting process by creating thetechnical specificationand requirementspecification document.
• Interacted with the business users and assist/trainthem to use Tableau reports.
• Created Dashboardsfor a better understanding of the business performance metrics.
• Developed and published reports and dashboards using Tableau Desktop/server.
• Redistributed tableau server processes based on tableau's recommended configuration in a distributed environment to improve server's performance.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Prepare dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Installation and configuration of Tableau server in various environments
• Configured Tableau server for subscriptions enabling business to receive dashboards periodically.
• Collected data on various process measurements and formatted into graphs using Tableau desktop
• Involved in dimensional and ER data modeling phases
• Worked throughout the SDLC, which included requirements, specifications, design, analysis, testing and production deployments
• Developed complex Stored Procedures, Functions, Triggers, Cursors, Tables, Views, Indexes and other SQL joins and statements for applications.
• Created trace in SQL Profiler for Performance tuning on stored procedures and Scripts.
• Create ETL packages to move data from feed files (XML, CSV and TXT) to database.
• Developed Unit Test Plans for SSIS packages.
• Enable error handling strategy i.e. transaction isolation to help rollback of transaction when package fails.
• Creating and Maintaining SSRS reports
• Created different kind of reports like cascading prompts, Drilldown reports, Drill through Reports, Parameterized reports, Sub reports, Linked reports and charts in SSRS
• Responsible for Monitoring and Tuning Report performance.
• Formalized the reporting process by creating thetechnical specificationand requirementspecification document.

Confidential

BI developer/ Analyst

Environment: Tableau Desktop, Tableau Server, SQL Server, Oracle, SQL, PL/SQL, SSIS, SSRS, Microsoft Amalga

Responsibilities:

• Gathering requirements towards identifying solutions with business partners or customers.
• Analyzed various data feeds that are inbound to the application and developed the design documents based on the analysis.
• Participated as a key team member/module lead in planning and coordinating the testing of the reports & packages where I had responsibility for specifically coordinating the test plans.
• Interacted with business users in gathering, analyzing and documenting the business requirements and translate them into technical specifications.
• Development of new dashboards from the existing cubes.
• Responsible for recreating reports and dashboards using Tableau software
• Create complex reports using multiple queries and sub queries.
• Configuring scheduled updates (Automatic and User notified) for optimal performance.
• Developed Ad-hoc report for business users when necessary.
• Developed complex Stored Procedures, Functions, Triggers, Cursors, Tables, Views, Indexes and other SQL joins and statements for applications.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled Jobs to call the packages and Stored Procedures
• Creating and Maintaining SSRS reports
• Create parameterized reports to accommodate business required

Confidential

BI developer/ Analyst

Environment: Tableau Desktop, Tableau Server, SQL Server, SQL, PL/SQL, SSIS, SSRS, Microsoft Amalga

Responsibilities:

• Gathering requirements towards identifying solutions with business partners or customers.
• Analyzed various data feeds that are inbound to the application and developed the design documents based on the analysis.
• Participated as a key team member/module lead in planning and coordinating the testing of the reports & packages where I had responsibility for specifically coordinating the test plans.
• Interacted with business users in gathering, analyzing and documenting the business requirements and translate them into technical specifications.
• Development of new Tableau dashboards from the existing cubes.
• Responsible for recreating reports and dashboards using Tableau software
• Create complex reports using multiple queries and sub queries.
• Developed Ad-hoc report for business users when necessary.
• Developed complex Stored Procedures, Functions, Triggers, Cursors, Tables, Views, Indexes and other SQL joins and statements for applications
• Create UAT test document to deploy SSIS packages on QA, UAT and production.
• Creating and Maintaining SSRS reports

Confidential

BI Developer/ Team Lead

Environment: SQL Server, Oracle, SQL, PL/SQL, SSIS, SSRS

Responsibilities:

• Lead a team of 10 people to ensure the delivery in time
• Gathering requirements towards identifying solutions with business partners or customers.
• Responsible for understanding the business & the technology of the client system.
• Performing functional / Technical code reviews.
• Working on the Database programming (T-SQL).
• Responsible for imparting application knowledge and technical learning to the new team members inducted into the Project.
• Handling onsite calls and daily status calls.
• Creating various types of SSRS reports

Confidential

.Net Developer/Team Lead

Environment: .Net, ASP.Net, C#.Net, SQL Server, SQL, PL/SQL, SSRS, Ajax, WCF, Cognos

Responsibilities:

• Lead a team of 5 people to ensure the delivery in time
• Gathering requirements towards identifying solutions with business partners or customers.
• Responsible for understanding the business & the technology of the client system.
• Performing functional / Technical code reviews.
• Working on the Database programming (T-SQL).
• Responsible for imparting application knowledge and technical learning to the new team members inducted into the Project.
• Handling onsite calls and daily status calls.
• Creating various types of SSRS reports

Confidential

.Net Developer

Environment: .Net, ASP.Net, C#.Net, SQL Server, SQL, PL/SQL, DTS, Cognos

Responsibilities:

• Gathering requirements, Analyzed, designed for various modules
• Design and Development of various modules.
• Integration and Unit testing.
• Testing and Bug fixing.
• Documentation.

Confidential

.Net Developer

Environment: .Net, ASP.Net, C#.Net, VB.Net, SQL Server, Oracle, SQL, PL/SQL, DTS, Crystal Reports, Analysis Services, Cognos

Responsibilities:

• 24X7 Production support
• Analyzing and fixing bugs
• Gathering requirements, Analyze, designed for various changes
• Design and Development of various new features.
• Integration and Unit testing.
• Documentation.