PROFESSIONAL SUMMARY:

• Over 9 years of experience in Software Design, Development of DWH, business Intelligence and Data Platforms.
• Over 6 years of Exetnsive Experience in Developing Dashbaords using Tableau Destkop/Server 10.x/9.x/8.x/7.x.
• Extensive experience working with other tools like Business Objects, Qlikview, Power BI and Alteryx.
• Experince upgrading Tableau platforms and performed content upgrades.
• Strong Skills in Tableau Desktop for Data visualization, Reporting and Analysis.
• Expertise in resolving the reports, dashboards, performance issues and implementing best practices using Tableau/Power BI.
• Extensive experience in Tableau Administration for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platforms like SharePoint.
• Skilled in Understanding client Best - Practices & Report standards, ability to provide visualization alternatives, assist in developing reports.
• Experience in Tableau application security/release management methods.
• Experince with existing reports, understanding of data connections to Various data sources such as, Oracle, MS-SQL, SQL Server, Teradata and other Databases.
• Experience in Data blending from multiple sources and Familiarity with Tableau mobile access options.
• Proficient in creating complex Calculations and Formatting using Tableau Desktop.
• Proficient in performance analysis, monitoring and SQL query tuning in Tableau and Databases.
• Provided user interface design for Web-based projects, including dashboards, widgets, and products.
• Experience in Software Development Life Cycle (SDLC) that include duties like providing technical documentation on design, testing and upgrade/migration works from development to production.
• Created of Business Requirements Documents, Functional and Technical specifications for BI Applications.
• Extensive experience in Identitfying user needs and business requirements and communicated design deliverables, such as specifications, templates, storyboards, wireframes, and mock-ups.
• Maintained company’s Wiki for user-interface best practices, procedures, and style guide.
• Extensive work experience in designing datamarts using different multi-dimensional modeling techniques such as Star Schema and Snowflake Schema for fact and dimensional tables that includes Logical and Physical data modeling.
• Expertise in Financial/Banking, Sales/Marketing, Retail, Healthcare, Entertainment and Pharmaceutical domains.
• A good Team player with the ability to communicate effectively Confidential all levels, possessing excellent presentation, communication and interpersonal skills.

TECHNICAL SKILLS:

BI Tools: Tableau desktop/ Server 2018/ 10.x/9.x/8.x/7.x , Tableau Prep, Qlikview, Business Objects 4.1/4.0/3.1, Xcelsius, Dashborad Designer,

ETL Tools: Alteryx, Informatica Power Center, Data stage.

Databases/Data Sources: Oracle 12g/11g/10g/9i/8i, M S Access, Teradata, SQL Server 2008/2012/2016, MySQL, Sales Force, Maria DB, AWS, Web data connector.

Languages: PL/SQL, SQL, ANSI 89, ANSI 92, XML, Python, R Java, Unix Shell Scripting, Stored Procedure, Hive QL.

Operating Systems: Windows XP/7/8/10, MS-DOS, UNIX, Linux.

Data warehousing: Normal forms (OLTP), Star Schemas (OLAP), Snow Flake Schemas, and slowly changing dimensions, Data modeling.

Industries: Financial, Health Care, Pharmaceutical, Retail, Marketing, Entertainment and Manufacturing.

Other: JIRA, Version One, Sharepoint, ALM, Microsoft Office.

PROFESSIONAL EXPERIENCE:

Confidential, Greenwich, CT

Sr. Tableau Developer/ Analytical Consultant

Responsibilities:

• Worked with business analysts, interpreted business requirements that users looked to dashboards to answer, and created server-based Tableau dashboards with automatic updates..
• Administered and provided production support for Enterprise wide Tableau application consisting of multiple key functional business domains.
• Created, organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
• Acted as a Point of Contact/Administrator in Data Interoperability, Analytics and Business Intelligence and Production Support issue resolution ans also Built and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Introduced several Levels of Dashboard Drill Down and Links to interrelated performance metrics.
• Leveraged advanced features of tableau such as calculated fields, parameters, and sets to support data analysis and data mining.
• Used Web Data connector to bring data from multiple web sites in Tableau.
• Performed Statistcal Anaylsis in Tableau by calling Python fuctions in Tableau.
• Responsible for developing various data connections from data source to Tableau Server for report and dashboard development.
• Responsible for writing views based on user and/or reporting requirements, wrote Teradata Macros and used various Teradata analytic functions.
• Responsible for creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data.
• Responsible for combined visualizations into Interactive Dashboards and publish them to the web. Transformed Tableau into a managed service offering for consumption across Corporate Treasury and Corporate Investments.
• Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data. Created actions, parameters, Filter (Local, Global) and calculated sets for
• Preparing dashboards and worksheets using Tableau. Effectively used data blending, filters, actions and Hierarchies feature in Tableau.
• Performed Data Warehousing and ETL using Informatica Power Center 9.5.

Environment: Tableau desktop/Server, 2018/10.5, SQL Server, AWS, Python, Orcale, Teradata, Web data connector, JIRA, Ateryx.

Confidential, New York, NY

Sr. Tableau Developer

Responsibilities:

• Gathered business requirements, defined and designed of the data sourcing, worked in conjunction with the data warehouse architect on the development of logical data models.
• Worked with internal management and team members to understand and clarify reporting requirements / needs.
• Participated in technical walk-through meetings to develop the functional design for the implementation of dashboards
• Loaded data from different sources (text-based files, Excel spreadsheets, transaction records) in legacy system to SQL Server databases using SQL Server Integration Services (SSIS)
• Used advanced data visualization tools like tableau to provide an easy to understand interface for end users to quickly identify key themes within their data.
• Effectively used data blending, filters, quick filters, data source filters, global filters, context filters, actions, Hierarchies feature in tableau
• Closely watched the SQL Server error logs, System error log for regular maintenance of SQL Server
• Integrated various data sources like Excel, Oracle and Flat Files into the staging area, data warehouse and data marts
• Created designs and process flow on to how standardize Power BI Dashboards to meet the Requirements of the business
• Worked with Power Query to extract data from external sources and modify data to a certain format to build Power BI reports.
• Generated Dashboards with Quick Filters, Parameters and Sets to handle views more efficiently
• Created solution driven dashboards by developing different chart types including Heat Maps, Geo Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms using Tableau and Power BI
• Created dashboards like weekly, monthly, daily reports
• Optimized the performance of queries with modification in SQL queries, eliminated redundant and inconsistent data, normalized tables
• Involved in schema objects creation: index, stored procedures, user defined functions, views
• Published Tableau dashboards in Tableau server and Power BI dashboards in Power BI service

Environment: Tableau desktop/Server 10.x, SQL Server, Google Analytics, Alteryx, JIRA, Sales Force

Confidential, New York, NY

Sr. Tableau Developer /Visulization Expert

Responsibilities:

• Promoted and overlooked the upgrade from Tableau 9.0 to Tableau 10.3. Managed the server upgrade along with multiple users desktop upgrade. Migrated all Tableau 9.0 reports and dashboards to Tableau 10.3 through full SDLC.
• Responsible for developing various data connections to Oracle, Hadoop, Hawq and Pivot. Also have experience in connecting with denies.
• Responsible for creating views based on user and/or reporting requirements, wrote Teradata Macros and used various Teradata analytic functions.
• Used Python integration for forecasting analytics. Created multiple POC's for current rates and spreads.
• Developed HTML prototypes and UI deliverables, such as wireframes, flowcharts, screen mock-ups, and interface design specifications.
• Worked with production team to implement UI and create enhancements to optimize user experience.
• Created dashboards for different investment sectors such as Healthcare, Electronics, etc.
• Responsible for creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data.
• Responsible for combined visualizations into Interactive Dashboards and publish them to the Tableau server. Transformed Tableau into a managed service offering for consumption across Corporate Treasury and Corporate Investments.
• Act as a Point of Contact/Administrator in Data Interoperability, Analytics and Business Intelligence and Production Support issue resolution. Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Designed, developed and supported BI solutions, Involved in Debugging and monitoring, and troubleshooting issues.
• Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data. Created actions, parameters, Filter (Local, Global) and calculated sets for Preparing dashboards and worksheets using Tableau. Effectively used data blending, filters, actions and Hierarchies feature in Tableau.
• Work directly with management, vendors, and third parties to ensure that Web site's financial transactions and database management applications operate Confidential peak efficiency. Ensured projects were completed on time and within budget.
• Tableau server maintenance, Tableau server backup activity. Consolidate multiple data silos that exist on campus to one location. Scheduled data extracts on a daily basis. Sophisticated stored procedures and triggers to provide complete technical solutions. Participated in test planning and test script definition. Resolved end user reporting problems through collaboration with IT and Operations. Environment Support to User community, Service Request & Resolution. Expertise in failed over activities in production Environments.
• Data analysis and manipulation and Regularly perform data de-duping and cleanup procedures

  Generated advanced reports in grid, graph and SQL mode, consisting of data analysis by combining a template with filters, using Tableau Desktop.

Environment: Tableau desktop/Server, 10.x/9.x. Amazon Web Services, Hadoop, HAWQ, Hive, Power BI, Oracle 12g/11g, SQL server 2012, SharePoint, JIRA,MS office

Confidential, Jersey City, NJ

Sr. Tableau Developer /Visulization Expert

Responsibilities:

• Responsible for developing various data connections from data source to Tableau Server for report and dashboard development.
• Responsible for writing views based on user and/or reporting requirements, wrote Teradata Macros and used various Teradata analytic functions.
• Developed HTML prototypes and UI deliverables, such as wireframes, flowcharts, screen mock-ups, and interface design specifications.
• Worked with production team to implement UI and create enhancements to optimize user experience.
• Created dashboards for different investment sectors such as Healthcare, Manufacture, Pharmaceutical etc.
• Responsible for creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data.
• Responsible for combined visualizations into Interactive Dashboards and publish them to the web. Transformed Tableau into a managed service offering for consumption across Corporate Treasury and Corporate Investments.
• Act as a Point of Contact/Administrator in Data Interoperability, Analytics and Business Intelligence and Production Support issue resolution. Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Designed, developed and supported BI solutions, Involved in Debugging and monitoring, and troubleshooting issues.
• Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data. Created actions, parameters, Filter (Local, Global) and calculated sets for
• Preparing dashboards and worksheets using Tableau. Effectively used data blending, filters, actions and Hierarchies feature in Tableau.
• Work directly with management, vendors, and third parties to ensure that Web site's financial transactions and database management applications operate Confidential peak efficiency. Ensured projects were completed on time and within budget.
• Tableau server maintenance, Tableau server backup activity. Consolidate multiple data silos that exist on campus to one location. Scheduled data extracts on a daily basis. Sophisticated stored procedures and triggers to provide complete technical solutions. Participated in test planning and test script definition. Resolved end user reporting problems through collaboration with IT and Operations. Environment Support to User community, Service Request & Resolution. Expertise in failed over activities in production Environments.
• Data analysis and manipulation and Regularly perform data de-duping and cleanup procedures
• Generated advanced reports in grid, graph and SQL mode, consisting of data analysis by combining a template with filters, using Tableau Desktop.

Environment: Tableau desktop/Server, 10.x/9.x/8.x, Microstrategy, Alteryx, Oracle 12g/11g, SQL server 2012, SharePoint, Salesforce, MS office.

Confidential, New York, NY

Sr. Data Visualization Consultant

Responsibilities:

• Responsible for gathering business requirements from various users of different Departments and stake holders.
• Collaborated with marketing, product management, and product development during design stages.
• Responsible for understanding the source systems to implement EDW.
• Responsible for Data Modelling, Data Analysis, Data Integration and Data Visualization.
• Responsible for Building Sales, Marketing and Finance reports and dashboards.
• Experience working with Tableau server to publish data sources, creating users and Tableau installation.
• Responsible for creating Tableau models, architectures, frameworks and strategies based on business requirements.
• Worked on the development of Dashboard reports for the KPIs for the top management.
• Designed Summary and Detailed reports using Data Blending feature in Tableau and utilized the cascading feature on Dimensions to provide dependency on objects through filters.
• Responsible for technical solutions to support and streamline data reporting requests requiring integration of data from multiple systems.
• Responsible for Analyzing and trouble-shooting technical issues related to reporting.
• Responsible for converting all excel reports in to Tableau reports and dashboards.
• Present the analysis to internal and external teams and Explain data from a business perspective and relevance to Key Performance Indicators.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterization using Tableau.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.
• Created action filters, parameters and sets for preparing dashboards and worksheets in Tableau.
• Extensive experience in SQL understanding and used TOAD and MS SQL Management Studio.
• Created several base formulas (mathematical expressions) using existing facts in Tableau that can be re-used to build any number of metrics.
• Generated advanced reports in grid, graph and SQL mode, consisting of data analysis by combining a template with filters, using Tableau Desktop.
• Responsible for providing Tableau training to business users and helping them in self-service Analytics.

Environment: Tableau Software 7.x, SQL Server, MySQL, Maria DB, Microsoft office, Oracle 10g

Confidential, Philadelphia, PA

Data Vizualization Consultant

Responsibilities:

• Work with customers and business partners to identify capabilities needed and perform Requirements Gathering, Requirements Analysis, Design, Development, Testing, End User Acceptance and Presentations of BI Projects.
• Provide support to various technical departments and business in achieving their business plans.
• Create enhancements to existing reports and capabilities in alignment with business needs.
• Ensures the testing and verification of new reporting processes.
• Assist business partners in decision-making, by analyzing the reporting process from end to end.
• Develop Metrics, Derived metrics, Compound metrics and Filters for complex reports.
• Perform Administrative tasks like User Creation and Creating Privileges.
• Design Advance filter, Advance metrics and Advance Prompts to create complex reports.
• Create and implement Drilling path into reports such that user can drill across different system and user hierarchies.
• Tested all the reports by running queries against the warehouse. Compared those queries with the Microstrategy SQL engine generated queries.
• Performed troubleshooting of Metrics, Prompts, Filters, Templates, Consolidations, and Custom Groups objects in an Enterprise data warehouse team environment.
• Partner with the Database Architect and ETL Developers to address Data availability and data model related issues.
• Identify and address all gaps in data quality.
• Map solution needs to the existing and available reporting tool set; additionally develop prototype solutions for business partners to assess.
• Create new Reporting Specification document in alignment with the business needs by incorporating useful alterations to the existing document.

Environment: Microstrategy Desktop 8.x, Microstrategy Intelligence Server, Microstrategy Web, SQL Server2005/2008.

Confidential, Memphis, TN

Sr. Busniess Objects Consultant

Responsibilities:

• Developed software development life cycles (SDLC) of the Projects.
• Participated in the end user meetings to obtain the business requirements for creating reports.
• Performed Data-Modeling Analysis like Creation of Snowflake schema, report structure based on the user requirements.
• Used the Project Creation Wizard to create Facts and Attributes.
• Created Attributes, Facts for different SAP Business Objects projects.
• Created the requirements documentation for SAP BUusiness Objects projects and environment.
• Created Reports using complex Filters and Compound Metrics and Prompts.
• Used Advanced Prompts, Conditional, Transformation metrics and Level Metrics for creating complex reports.
• Designed an efficient BI Dashboard for the Company Executives, through efficient use of SAP Dashboard Design.
• Developed Universes and Web intelligence reports Schema objects and Application objects such as Facts, Attributes, Transformations and Hierarchies
• Created all possible Metrics, for enabling the end users to generate customized reports by creating their own Templates and Filters, Managing schema objects and application objects across the project.
• Developed Dashboards using Xcelsius for Stakeholders using QAAWS and Live office connnections.
• Demoed Xcelsius (2008) dashboards to summarize the best selling product and dashboards displaying sales by store and region

Environment: SAP Business Objects XI 3.1/4.0, Xcelsius, Dashboard designer, Teradata, Oracle 10g (PL/SQL), Windows 2000 Professional, UNIX.

Confidential, Portsmouth, OH

Busniess Intelligence Developer

Responsibilities:

• Analyze requirements and develop derived metrics, custom report objects as required.
• Involved in collecting the business requirements from users by understanding the Source System (OLTP) and interacting with the users.
• Created Complex Metrics forcing Dimensionality and Conditionality embedded with prompts.
• Developed logical and physical data model by defining strategy for Star Schema with Fact and Dimension tables with Detail, Summary, Look-up Tables, Indexes and Views.
• Extensively involved in data modeling to create attribute relationships.
• Developed new reports and converted existing reports for the business line to satisfy the specifications using Web Intelligence and CrystalReports.
• Responsible for testing of developed reports and report objects.
• Created transformations to-do time series analysis and to compare the values Confidential different times such as sales Confidential this year versus last year, or month-to-date.
• Created Dynamic Enterprise Dashboards and utilized the new features to convert the dashboards into Flash mode.
• Supported all phases of the project such as, Analysis, Design, Development, Testing and Implementation of the project.
• Maintain design, development, testing and deployment task documentation.
• Created Applications, Dashboards, Metrics, Menus, Rules, Alerts and Analytics using application Foundation 6.5.
• Deployed QAAWS from import wizard.
• Used query as web option to build visualizations based on the reports built in Business Objects.

Environment: SAP Business Objects XI 3.1, Xcelsius, Crystal Reports, Oracle 10g, SQL Server 2005.

Confidential, Plano, TX

SQL Server Developer

Responsibilities:

• Performed logical modeling and physical modeling of the database.
• Successfully implemented physical database on MS SQL Server 2000. Supported complex relationship using triggers.
• Tuned database by creating proper Indexes on different tables that improve the performance of T-SQL queries on the database.
• Facilitated simplified access of database for end users using de-normalized views and created triggers on them to maintain to database integrity.
• Created audit trails of activities on database using triggers on backend.
• Implemented the business logic and processing of the payment by developing stored procedures.
• Used SQL Server Profiler to trace the slow running queries and optimized query execution with the use of Index Tuning Wizard and Rebuild indexes if necessary.

Environment: SQL Server 7.0/2000, T-SQL, VB 6.0, Windows NT/2000 server.