SUMMARY

• Dedicated, driven professional with 7 years of experience in IT industry, in the field of Data Warehousing/Business intelligence using industry leading tools and technologies such as Tableau, MicroStrategy and Informatica.
• 3 +years of experience on Tableau 7.x/8.x/9.x product suite (Desktop, Server, Reader, Mobile).
• Solid experience in Designing Tableau reporting solutions for clients, Creating Dashboards, Performance optimization, Developing user Training Material and creating Best practices for reporting solutions.
• Proficient in using and creating parameters, dynamics groups and sets, data hierarchies, filters, calculated fields and other custom function like string functions, date functions and logical functions
• Proficient in creating visualization like Stack Bar, Bar Graphs, scattered plots, Bars, Lines and Pie charts, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables in Tableau.
• Experience with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to created summary level and detailed Reports.
• Experience in creating Tableau scorecards, dashboards using stack bars, bar graphs, Tree Maps, geographical maps.
• Experienced in troubleshooting and performance tuning of reports and resolving issues within Tableau Server.
• Experience in configuring and administrating Tableau Server sites, projects, publishing and refreshing tableau extracts.
• Successfully administered users, user groups, and scheduled instances for reports in Tableau.
• Experience in creating users, groups, projects, and Data connections as a tableau administrator.
• Responsible for Upgrading Tableau server from 8.3/8.1 to 9.0 in DEV and QA along with Migration of reports.
• Outstanding knowledge in writing complex SQL Queries, stored procedures, database tuning, query optimization and resolving key performance issues.
• Clear and thorough understanding of business processes and the designing part of the ETL Development.
• Strong understanding of Data warehouse concepts, ETL, Star Schema, Snowflake, data modeling experience using Normalization,Business ProcessAnalysis, Reengineering, Dimensional Data modeling, Fact and dimensions tables, physical and logical data modeling.
• Highly Proficient in Agile - Scrum, Test Driven, Iterative and Waterfall software development life cycle.
• Quick learner and mentor with the ability to adopt in demanding, fast-paced environments requiring highly adaptive, flexible and resourceful technical & management skills.
• Strong Analytical and Problem Solving Skills and communication skills with ability to work independently and in team environments, simultaneously on multiple projects with competing priorities.
• Extensive experience in creating visual dashboards, Worksheets using Tableau 9.0, 8.3 and 8.2.
• Experience in building, publishing customized interactive reports, dashboards, and report scheduling usingTableauserver.
• Worked extensively with advanced analysis Actions, relationships, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both tableau and excel.
• Extensively worked on creating calculated fields and Analysis depending on the user requirements.
• Extensively used advanced filtering capabilities for creating Dashboards.
• Extensive experience in creating dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices to convey the story inside the data.
• Experience on Tableau Admin for scheduling the Data refreshing frequency, manage automatic subscription, security and controlling access.

TECHNICAL SKILLS

BI Tools: Tableau 9.x/8.x/7.x product suite (Desktop, Server, Reader, Mobile). MicroStrategy9.x/8.x

ETL Tools: Informatica 8.5/7.1/6.2.

Operating Systems: Windows 2000/XP-Pro/Vista/7, UNIX/ LINUX

Languages: SQL, PL/SQL, Java, HTML 4.0, JavaScript

Modeling Tools: Erwin 7.x/6.x

RDBMS: Oracle 11g/10g/9i/8i/8.0, IBM DB2, SQL server 2005/2008.

PROFESSIONAL EXPERIENCE

Confidential, NY

Sr. Tableau Developer

Responsibilities:

• Involved in gathering and analyzing business requirements from the client.
• Involved in all Agile-Scrum meetings like standup meetings, Sprint planning and Sprint review and retrospective meetings.
• Responsible for creating different views in workbook to visually analyze data.
• Played critical role in establishing Best practices for tableau reporting by conduct meeting with the clients for gathering reporting requirements.
• Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
• Responsible for creating parameters and quick filters. Created sets to display top products based on their sale.
• Responsible for using Multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• Involved in Custom Geo-Coding; By creating a .CSV file and Assigning geographic roles to fields not recognized by tableau.
• Responsible for using different Mark types and Mark properties in views to provide better insights into large data sets.
• Responsible for creating filters to the improve performance.
• Responsible for creating Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
• Responsible for creating dimension on Page shelf for a detailed analysis of the view by members of the dimension.
• Responsible for creating extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
• 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.
• Worked on Tableau Admin for scheduling the Data refreshing frequency, manage automatic subscription, security and controlling access.
• Responsible for Upgrading Tableau server from 8.3/8.1 to 9.0 in DEV and QA along with Migration of reports.
• Responsible for creating and setting privileges on Users/User Groups.

Environment: Tableau 9.0, Desktop, Tableau Server, Oracle, SQL Server, Microsoft Office Suite (Word, Excel, Power Point)

Confidential, Redmond WA

Tableau Developer

Responsibilities:

• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
• Involve in Agile-Scrum methodology for this project.
• Building, publishing customized interactive reports and dashboards, report scheduling usingTableauserver.
• Extensively worked on creating calculated fields and Analysis depending on the user requirements.
• Responsible for creating Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
• Extensively used advanced filtering capabilities for creating Dashboards.
• Responsible to find ways to make graphs and tables visually exciting, and aesthetically pleasing, while at the same time maintaining the accuracy of the core information content that is being communicated.
• Involved in Data Warehouse Architecture and Design - Star Schema, Fact and Dimensional Tables, Physical/Logical Data Modeling and data flow diagrams.
• Involved in testing the database using complex SQL scripts and handled the performance issues effectively.
• Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.
• 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.
• Worked on Tableau Dashboards in Tableau 8.3. Demonstrated knowledge in dealing with various functionalities like context filters, global filters, guided navigation, customization, conditional formatting of reports to satisfy the end users.

Environment: Tableau 8.3/9.0, Oracle, SQL Server, Microsoft Office Suite (Word, Excel, Power Point)

Confidential, Chicago, IL

Tableau Developer

Responsibilities:

• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
• Worked on Tableau Dashboards in Tableau 8.1. Demonstrated knowledge in dealing with various functionalities like context filters, global filters, guided navigation, customization, conditional formatting of reports to satisfy the end users.
• Involved and played critical role in establishing Best practices for tableau reporting by conduct meeting with the clients for gathering reporting requirements.
• Responsible in developing Complex dashboards and used advance chart visualizations in Tableau like Pareto Chart, Dual Water Fall charts, Axis, Bullet Graphs, Bubble Charts, etc. to assist business users in solving complex problems.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to created summary level and detailed Reports.
• Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop.
• Worked closely with the ETL Team to automate the Data load process, create required aggregate tables, indexing and table portioning for performance optimization of Reports.
• Extracted data from various sources (SQL Server, Oracle, text files and excel documents)
• Responsible for writing Custom SQL scripts for creating aggregate tables and generating views.
• Responsible in designing and developing various Weekly and Monthly reports showing detailed information that could be used to send information to diverse group of users, clients, and managers.

Environment: Tableau 8.2/8.1/8.0, Tableau Server, SQL, PL/SQL, SQL Developer, DB2, Oracle, SQL Server, MS Project.

Confidential, Houston, TX

System Analyst - MicroStrategy

Responsibilities:

• Involved in gathering requirements for the dashboard from the business executives and prepared the prototype.
• Worked with data modelers and ETL developers to aid in the design of efficient and robust data structures for reporting and analysis.
• Interface directly with business customers to understand their process and information needs.
• Responsible for developing the Schema by creating attributes, facts and hierarchies.
• Responsible for creating a number of complex Metrics, Filters, Prompts, Custom Groups, Consolidations and Reports.
• Involved in designing and built pixel perfect report service documents and interactive Flash dashboards.
• Responsible for creating report builder interface for the Ad-hoc Analysis.
• Responsible for creating transformations using Transformations by tables for YTD (Year to date), and MTD (Month to date) for Time Series Analysis.
• Analyzed the legacy reports and recreated in MicroStrategy.
• Responsible for creating MicroStrategy schema and public objects for generating reports and used MicroStrategy desktop.
• Involved in troubleshooting MicroStrategy Web Reports, and optimizing the SQL using the VLDB properties.
• Resolved the defects during the QA and UAT testing process.
• Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.

Environment: MicroStrategy 8.0/9.0 (Desktop, Architect, Intelligent Server, Web), Object Manager,SQL Server, SQL Assistant, PL/SQL, Windows 2007, Eclipse.

Confidential, Tallahassee, Florida

MicroStrategy Developer

Responsibilities:

• Involved in design/development life cycle including gathering requirements, user interaction and report design and development.
• Supported team in standards, best practices, and methodology throughout the SDLC, supporting all types of MSTR BI applications; developed schema and public objects, created reports and dashboards.
• Worked extensively on creating MicroStrategy Objects like Metrics, Compound Metrics, Facts, Filters, Custom Group, Consolidation, Attributes, Hierarchies and Prompts for MicroStrategy reports using MicroStrategy Architect.
• Responsible for designing advanced filter, advanced metrics, Advanced Prompts to create complex reports.
• Responsible for creating drilling reports across different within the Hierarchy and other hierarchies.
• Extensively worked in both Ad-hoc and standard reporting Environments and Involved in creating reports scalable to large volumes of data.
• Responsible for creating a wide variety of fully interactive scorecards, dashboards, and enterprise reports.
• Responsible for creatingdynamic dashboard using Widget, Panels, Selectors, Map, Graphs and Grid.
• Designed and developed various Weekly and Monthly reports showing detailed information that could be used to send information to diverse group of users, clients, and managers.

Environment: MicroStrategy 7.5/8.0 (Web, Desktop), MicroStrategy Intelligence Server, Oracle, UNIX.