SUMMARY

• Over 8 years of extensive Experience in the Business Requirements Analysis, Development, Implementation and maintenance of Business Intelligence, Data warehousing and Web applications.
• Proficient knowledge on Tableau Desktop, Tableau Reader, Tableau Server and Tableau Public.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Experience in design and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Created various visualizations in Tableau using Bar, Line, Area, Gantt charts, scatter plot, Histogram, Heat Maps making use of Calculated fields, Parameters, Sets, Groups, Filters.
• Expertise in using Trend Lines, Statistics, and Log Axes, Groups, Hierarchies to create detail level summary report and Dashboard using KPIs.
• Experienced in Tableau Data Visualization tool to analyze and obtain insights into large datasets, create visually compelling interactive reports and dashboards.
• Experience on calculations using different type of functions like logical, Number, String, Aggregate, date functions.
• Worked with different data sources like Flat Files, SQL Server and Oracle Database.
• Extensive experience in Tableau Administration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platforms like SharePoint.
• Experienced in writing SQL Queries using joins, derived tables, sub - queries, correlated subqueries for validating data on reports and for generating data extracts to support source data requirements in Tableau.
• Experienced in using SQL loader to load huge volume of data to Oracle DB.
• Worked in Agile, Test Driven, Iterative and Waterfall software Development life cycle models.
• Proficient in the use of JIRA, Target Process for Task / Issue tracking in project management.
• Carried out activities like Requirement Gathering, Analysis, Estimation, Planning, Designing, Requirement Traceability and Reporting.
• Outstanding data analysis skills including Data mapping from source to target database schemas, Data Cleansing and processing, writing data extract scripts/programming of data conversion and researching complex data problems and generating analytical reports/dashboards.
• Excellent Verbal, Written and Interpersonal and Communication skills, with high team spirit of collaboration with Testers, Developers and other team members in developing complex projects and in the overall enhancement of software product quality.
• Good work ethics, Interpersonal skills, hardworking nature and very good team player and ability to effectively communicate with all levels of organization such as technical, management.

TECHNICAL SKILLS

Analytical Tools: Tableau, MicroStrategy, SSRS, Unica,, Google Analytics

Data Integration Tools: Alteryx, Informatica, DataStage, SSIS

SQL Tools: Teradata SQL Assistant, Toad, SQL Developer, Rapid SQL

RDBMS: Teradata, Oracle, SQL Server,DB2, MySQL, AccessDocumenting anData

Modeling Tools: Power Designer, ERwin, ER Studio, MS Visio, MS Project, MSOffice(Word/ Excel/ Access/ Power Point), MS SharePoint,Documentum.

Scheduling Tools: AutoSys, Control-M

Defect Management/Testing Tools: JIRA, Confluence, HP Quality CenterChange/Service

Management Tool: HP Service Manager, CA Service Desk Manager, Lotus Notes

Scripting/Lang.: C, C++, HTML, JavaScript, Python, PERL, SQL, PL/SQL, andXML

Operating Systems: Windows XP/ Net/2000/ Vista/7, Unix, Linux

PROFESSIONAL EXPERIENCE:

Confidential, Maryland

Tableau Developer

Responsibilities:

• Created reports using Tableau functionality’s like Queries, Drill Down, Functions to meet the requirements using SQL Server.
• Used filters, quick filters, sets, parameters and calculated fields on Tableau reports.
• Experience in Marks, Publisher and Security.
• Experience with creating Worksheets and Dashboard.
• Working with Multiple data Connections.
• Experience in tableau created Rapid Analytics and Reporting.
• Using Multiple Measures like Individual Axes, Blended Axes and Dual Axes.
• Experience in BI interactive Dashboards and Tableau Publisher.

Environment: Tableau 9 Desktop, Tableau server, Oracle DB.

Confidential, West Chester, PA

Tableau Developer

Responsibilities:

• Worked with the Business users to understand the business and convert the business requirements into technical specification documents.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet inTableauDesktop.
• Used Data Densification features like turning on and turning off Domain Completion and Domain Padding.
• Increased extract performance by aggregating data and rolling up dates when creating extracts.
• Implemented responsive web design by using Vertical and Horizontal containers in dashboard.
• Worked with Tableau Administrator to implement content security for site, project, and object with windows active directory integration.
• Developed dashboards inTableauDesktop and published them on toTableauServer that allowed end users to understand the data on the fly with the usage of quick filters for on demand-needed information.
• DevelopedTableauvisualizations to support ad-hoc analysis.
• Designed and developed different visualizations like side by side bars, Scatter plots, Stacked Bars, Heat Maps, Geo Maps ( Summary and Detail), Pie, Line, Area, etc. depending on the best fit for a given business requirement.
• Created various complex SQL queries, calculated fields using Table Calculations functions (Effective and Relative Compute Using), Aggregate functions, Date functions, Logical functions, Windows functions, etc. for solving complex business issues and solved Optimize issues in Dashboards.
• Worked extensively with Advance functionalities like Actions, Background Images, Page Navigation, Filters (Quick, Global, and Context), Parameters, Groups, Hierarchies, Sets, Bins etc. to facilitate advance analytics to Business Users.
• Created organized, customized analysis and visualized projects and dashboards to present to executive leadership.
• Implemented user level and row-level security to define data access restrictions for users.
• Responsible for Deploying and Maintenance of dashboards onTableauServer.

Environment: Tableau 8.x, 9.x (Desktop/ Server), SQL Server 2008, MS Office Suite (Word, PowerPoint, Excel).

Confidential, Boston, MA

Tableau Consultant / Data Analyst

Responsibilities:

• Created and used Filters, Quick Filters, Table Calculations and Parameters on Tableau reports.
• Created various views in Tableau like Tree maps, Heat Maps, Scatter plots, Geographic maps, Line chart and Pie charts.
• Created Sets, Groups and Data Bins as per user requirements.
• Generated Interactive Dashboards with Quick filters, Parameters and Actions to handle views more efficiently.
• Created views using various axes like Individual Axes, Dual Axes and Blended Axes.
• Used Trend Lines, Lines and Annotations to describe the data.
• Created Data extracts for better performance and accessing data offline.
• Used parameters and input controls to give users control over certain values.
• Implemented Data blending with multiple data sources on a single worksheet for data analysis.
• Created and Published Tableau Dashboards into Tableau Server.
• Writing SQL queries for data validation by using join conditions.

Environment: Tableau Desktop 8, Tableau server, Sql Server, Oracle, Windows 8

Confidential

Data Analyst / Business Systems Analyst

Responsibilities:

• Involved in developing the optimization module for booking slots on loading places.
• Participated in technical review meetings and involved in creating technical, functional specification documents.
• Responsible for performance fine-tuning of queries.
• Extensively used error and exception handling techniques for validation purposes in code.
• Created and maintained triggers for maintaining history for auditing purposes.
• Involved in writing complex queries for generating different billing reports as per client needs.
• Created shell scripts for loading data using SQL Loader.
• Developed database triggers and stored procedures using Oracle PL/SQL cursors and tables.
• Used Toad extensively to debug, test SQL and PL/SQL scripts, procedures, functions, triggers.
• Create and develop highly complex applications using Oracle as back-end with expertise in design and development of Oracle PL/SQL Packages and Procedures.
• Involved in Oracle PL/SQL code review and modification for the development of new requirements.
• Coded and tuned Oracle PL/SQL and SQL throughout the development wherever needed.
• Created Job schedulers using DBMS job schedule for generating invoices at defined intervals.
• Conducted unit testing for the modules created.

Environment: SQL Server, Oracle DB, UNIX, Windows, ToadPROFESSIONAL SUMMARY:

• Over 8 years of extensive Experience in the Business Requirements Analysis, Development, Implementation and maintenance of Business Intelligence, Data warehousing and Web applications.
• Proficient knowledge on Tableau Desktop, Tableau Reader, Tableau Server and Tableau Public.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Experience in design and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Created various visualizations in Tableau using Bar, Line, Area, Gantt charts, scatter plot, Histogram, Heat Maps making use of Calculated fields, Parameters, Sets, Groups, Filters.
• Expertise in using Trend Lines, Statistics, and Log Axes, Groups, Hierarchies to create detail level summary report and Dashboard using KPIs.
• Experienced in Tableau Data Visualization tool to analyze and obtain insights into large datasets, create visually compelling interactive reports and dashboards.
• Experience on calculations using different type of functions like logical, Number, String, Aggregate, date functions.
• Worked with different data sources like Flat Files, SQL Server and Oracle Database.
• Extensive experience in Tableau Administration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platforms like SharePoint.
• Experienced in writing SQL Queries using joins, derived tables, sub - queries, correlated subqueries for validating data on reports and for generating data extracts to support source data requirements in Tableau.
• Experienced in using SQL loader to load huge volume of data to Oracle DB.
• Worked in Agile, Test Driven, Iterative and Waterfall software Development life cycle models.
• Proficient in the use of JIRA, Target Process for Task / Issue tracking in project management.
• Carried out activities like Requirement Gathering, Analysis, Estimation, Planning, Designing, Requirement Traceability and Reporting.
• Outstanding data analysis skills including Data mapping from source to target database schemas, Data Cleansing and processing, writing data extract scripts/programming of data conversion and researching complex data problems and generating analytical reports/dashboards.
• Excellent Verbal, Written and Interpersonal and Communication skills, with high team spirit of collaboration with Testers, Developers and other team members in developing complex projects and in the overall enhancement of software product quality.
• Good work ethics, Interpersonal skills, hardworking nature and very good team player and ability to effectively communicate with all levels of organization such as technical, management.

TECHNICAL SKILLS:

Analytical Tools: Tableau, MicroStrategy, SSRS, Unica,, Google Analytics

Data Integration Tools: Alteryx, Informatica, DataStage, SSIS

SQL Tools: Teradata SQL Assistant, Toad, SQL Developer, Rapid SQL

RDBMS: Teradata, Oracle, SQL Server,DB2, MySQL, AccessDocumenting anData

Modeling Tools: Power Designer, ERwin, ER Studio, MS Visio, MS Project, MSOffice(Word/ Excel/ Access/ Power Point), MS SharePoint,Documentum.

Scheduling Tools: AutoSys, Control-M

Defect Management/Testing Tools: JIRA, Confluence, HP Quality CenterChange/Service

Management Tool: HP Service Manager, CA Service Desk Manager, Lotus Notes

Scripting/Lang.: C, C++, HTML, JavaScript, Python, PERL, SQL, PL/SQL, andXML

Operating Systems: Windows XP/ Net/2000/ Vista/7, Unix, Linux

PROFESSIONAL EXPERIENCE:

Confidential, Sparks, Maryland

Tableau Developer

Responsibilities:

• Created reports using Tableau functionality’s like Queries, Drill Down, Functions to meet the requirements using SQL Server.
• Used filters, quick filters, sets, parameters and calculated fields on Tableau reports.
• Experience in Marks, Publisher and Security.
• Experience with creating Worksheets and Dashboard.
• Working with Multiple data Connections.
• Experience in tableau created Rapid Analytics and Reporting.
• Using Multiple Measures like Individual Axes, Blended Axes and Dual Axes.
• Experience in BI interactive Dashboards and Tableau Publisher.

Environment: Tableau 9 Desktop, Tableau server, Oracle DB.

Confidential, West Chester, PA

Tableau Developer

Responsibilities:

• Worked with the Business users to understand the business and convert the business requirements into technical specification documents.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet inTableauDesktop.
• Used Data Densification features like turning on and turning off Domain Completion and Domain Padding.
• Increased extract performance by aggregating data and rolling up dates when creating extracts.
• Implemented responsive web design by using Vertical and Horizontal containers in dashboard.
• Worked with Tableau Administrator to implement content security for site, project, and object with windows active directory integration.
• Developed dashboards inTableauDesktop and published them on toTableauServer that allowed end users to understand the data on the fly with the usage of quick filters for on demand-needed information.
• DevelopedTableauvisualizations to support ad-hoc analysis.
• Designed and developed different visualizations like side by side bars, Scatter plots, Stacked Bars, Heat Maps, Geo Maps ( Summary and Detail), Pie, Line, Area, etc. depending on the best fit for a given business requirement.
• Created various complex SQL queries, calculated fields using Table Calculations functions (Effective and Relative Compute Using), Aggregate functions, Date functions, Logical functions, Windows functions, etc. for solving complex business issues and solved Optimize issues in Dashboards.
• Worked extensively with Advance functionalities like Actions, Background Images, Page Navigation, Filters (Quick, Global, and Context), Parameters, Groups, Hierarchies, Sets, Bins etc. to facilitate advance analytics to Business Users.
• Created organized, customized analysis and visualized projects and dashboards to present to executive leadership.
• Implemented user level and row-level security to define data access restrictions for users.
• Responsible for Deploying and Maintenance of dashboards onTableauServer.

Environment: Tableau 8.x, 9.x (Desktop/ Server), SQL Server 2008, MS Office Suite (Word, PowerPoint, Excel).

Confidential, Boston, MA

Tableau Consultant / Data Analyst

Responsibilities:

• Created and used Filters, Quick Filters, Table Calculations and Parameters on Tableau reports.
• Created various views in Tableau like Tree maps, Heat Maps, Scatter plots, Geographic maps, Line chart and Pie charts.
• Created Sets, Groups and Data Bins as per user requirements.
• Generated Interactive Dashboards with Quick filters, Parameters and Actions to handle views more efficiently.
• Created views using various axes like Individual Axes, Dual Axes and Blended Axes.
• Used Trend Lines, Lines and Annotations to describe the data.
• Created Data extracts for better performance and accessing data offline.
• Used parameters and input controls to give users control over certain values.
• Implemented Data blending with multiple data sources on a single worksheet for data analysis.
• Created and Published Tableau Dashboards into Tableau Server.
• Writing SQL queries for data validation by using join conditions.

Environment: Tableau Desktop 8, Tableau server, Sql Server, Oracle, Windows 8

Confidential

Data Analyst / Business Systems Analyst

Responsibilities:

• Involved in developing the optimization module for booking slots on loading places.
• Participated in technical review meetings and involved in creating technical, functional specification documents.
• Responsible for performance fine-tuning of queries.
• Extensively used error and exception handling techniques for validation purposes in code.
• Created and maintained triggers for maintaining history for auditing purposes.
• Involved in writing complex queries for generating different billing reports as per client needs.
• Created shell scripts for loading data using SQL Loader.
• Developed database triggers and stored procedures using Oracle PL/SQL cursors and tables.
• Used Toad extensively to debug, test SQL and PL/SQL scripts, procedures, functions, triggers.
• Create and develop highly complex applications using Oracle as back-end with expertise in design and development of Oracle PL/SQL Packages and Procedures.
• Involved in Oracle PL/SQL code review and modification for the development of new requirements.
• Coded and tuned Oracle PL/SQL and SQL throughout the development wherever needed.
• Created Job schedulers using DBMS job schedule for generating invoices at defined intervals.
• Conducted unit testing for the modules created.

Environment: SQL Server, Oracle DB, UNIX, Windows, Toad