Tableau Architect, Power Bi Developer Resume
Plano, TX
TECHNICAL SKILLS
Reporting Tools: Tableau 7.0/8.0/9.0,10.0,2019.1,2019.1.3, Power BI and IBM Cognos, Alteryx.
Programming Languages: SQL, Java, ASP, CL400, RPGLE, SQLRPGLE, Free format RPGLE, COBOL, VB
Databases & Tools: DB2/400, SQL, MS - SQL, Connectivity: ODBC, JDBC, MS SQL Server 7.0 / 2000 / 2005 , Microsoft Azure, Oracle, MS Access, Teradata
Big Data: Hadoop, Sqoop, Pig, Hive and Mapreduce
RDBMS: MS SQL Server 7.0 / 2000 / 2005 , Oracle, MS Access
Scripting Languages: Java Script, VB Script, XML, Web services
PROFESSIONAL EXPERIENCE
Confidential, Plano, TX
Tableau Architect, Power Bi Developer
Responsibilities:
- Currently all the reports are generated in excel and creating PDFs and publishing to the users periodically. Role is to transform all the raw data to advanced business analytics visualizations in Tableau or PowerBI and based on groups.
- Work with Business Analysts and Business Users to understand the user’s requirements, layout, and look and feel of the dashboards to be developed.
- Utilized Tableau and PowerBi as a front-end BI tools and Teradata, oracle SQL and IRI extract data as back end database for creating reports.
- Performed data cleaning, data transformation and complex calculations using SQL, LOD’s and DAX.
- Created prompts, customized calculations, conditions, and filters (Local and Global) for various analytical reports and dashboards.
- Imported data from Teradata, Excel database to join or blend according to business requirements.
- Performance tuning of Tableau dashboards by applying best practices.
- Based on this report they should identify the area where they are lagging and concentrate on that area.
- Applied tableau security and published to Tableau Server based on Sector Level & Market Level.
- Involved in administration tasks such as Setting permissions, managing ownerships, providing access to the users, and adding them to the specific group.
- Preparing Dashboards using calculations, parameters in Tableau.
- Maintain the dashboards, restrict access based on user groups and support them in Agile Methodology.
Confidential, Plano, TX.
Tableau Developer/Architect
Responsibilities:
- Convert all the wireframes to highly visual and interactive dashboards using different features like Action Filters, Parameters, Sets, Groups, Calculations (like logical, String, Table, Aggregate, LOD functions) and organizing dashboards (Layout Containers, Annotations, Mark Labels etc.,)
- Performance tuning of Tableau dashboards by applying best practices like applying filters, using relevant worksheets in dashboards, Indexing & partitioning of relevant database tables etc.,
- Implemented context filters and data source filters while handling huge volume of data.
- Used SQL Scripts to test the data presented in the Dashboards are accurate by comparing against data in the database tables.
Confidential, Plano, TX.
Tableau Developer
Responsibilities:
- Currently all the reports are generated in excel and creating PDFs and publishing to the users periodically.
- Requirement is to transform all the excel data to Tableau and generate dashboards.
- Understanding the business requirements and discussing with customers and getting there inputs to build Tableau Dashboards and managing the delivery.
- Created dashboards to show summary view, drilldown for each brand wise, geography wise and channel wise.
- Based on this report they should identify the area where they are lagging and concentrate on that area.
- Applied tableau security and published to Tableau Server based on Sector Level & Market Level.
- Dashboards build based on user specific requirements.
- Preparing Dashboards using calculations, parameters in Tableau.
- Added Tableau Security based on Country wise groups.
Environment: Tableau Desktop 9.0, Tableau Server 9.0, Microsoft Excel with ETL, Teradata, SQL.
