Priya Pandey

add7d3@r.postjobfree.com

408-***-****

Certified Tableau Author

Certified Tableau Analyst

Certified AWS Solution Architect- Associate

IBM Certified Cognos10 BI Author

IBM Certified Cognos 10 BI Administrator

EXPERIENCE SUMMARY

●Having 9+ years of experience in Information Technology including Data warehousing & Business Intelligence and cloud computing.

●Experience in interacting with business users to analyze the business process and requirements and transforming requirements into data warehouse design, documenting and rolling out the deliverables.

●strong hands on Experience implementing BI Reports/Dashboard and analytics using tableau desktop and tableau server (Tableau 10.1,Tableau 2018.1,Tableau 2019.3).

●Good Experience in dashboard designing with large data volumes from various data sources (sql server,redshift,teradata,hive).

●Expertise in designing and creating various analytical reports and Dashboards to facilitate strategic planning in the organization using Tableau/Power BI/Cognos.

●Extensive experience on building Interactive dashboards using Tableau and Power BI.

●Experienced in analyzing the BI needs,Interpreting business user requirements and translating them in to reports

●Expertise in SSAS cube development using hive view, Performed multiple cube level calculation (DX and MDX).

●Expertise in designing different Schemas (Star and Snowflake) to fit reporting, query and business analysis requirements.

●Familiar with databases such as MS SQL Server, Postgres, SAP HANA, Hive, Redshift and Teradata.

●Experience in working with AWS platform and created multiple dashboards using Tableau like Spend efficiency, Developed various Cloud consumption dashboards for VP and engineering leader to provide deeper insights into their Cloud spend.

●Good understanding with AWS cloud computing (EC2 instance, Non EC2 instances, Storage, VPC, Load Balancer, cloud watch).

●Good Understanding of Lucid charts- Created flowcharts, ER diagrams for designing data warehouse tables..

●Good working knowledge of Agile Methodology and good understanding of Planning meeting, Execution of sprint tasks, Review meeting, Jira board and Retrospective meeting.

●Ability to handle multiple task concurrently and meet the deadline

EDUCATION

Master of Computer Application (2007-2010) - Dehradun Institute Of technology,Uttarakhand, India

Bachelor in Science - Mathematics,Physics,Chemistry(2005-2007)- Kumaun University Nainital,Uttarakhand, India

TECHNICAL EXPERTISE

Technology

Details

BI Tools (Reporting & Modeling)

Tableau 10.1,Tableau 2018.1,Tableau 2019.3,Microsoft Power BI, Qlik view, Cognos, Framework Manager, IBM Lifecycle Manager, Microsoft SSAS,

ETL Tools

Pentaho PDI 4.4.0 (Big Data ETLTool)

Cloud

AWS (EC2 Instances, Non EC2 Instances, Storage, VPC, Load Balancer)

Database

SQL Server 2008, Teradata, SAP HANA, Hive (Hadoop), Redshift,Postgres

Scheduling Tools

Hudson Scheduler, Cognos BI, Tidal, Metric Insight

Language & other

GitHub, Agile Methodology, Jira

WORK EXPERIENCE

Adobe

Spend Analytics (AWS/Azure Reporting)

Tableau & Power BI Developer April 2019–Till Now

Description:

Spend Analytics Project is driven to improve overall spend and to provide the high-level view at executive level by enabling executives with interactive dashboard which can help them easily identify- AWS Spend, Resource Utilization, Cloud Efficiency, Legacy Instances details, Azure Migration Plan and Search Platform Spend/Consumption (For Sensei, Shared Cloud, Lightroom, Helpx and Stock). This helps executives to take their decision to govern AWS instances/Azure Instances for next year and give the wide view of resource utilization.

Roles: Below are the list of my role and responsibilities in the project:

●Responsible for end to end development of the Dashboards using direct tables/view or custom query.

●Responsible for making dashboard as interactive as possible for Adobe senior management/Product Owners

●Responsible to educate end users about Tableau/Power BI which helps end user to execute dashboard efficiently

●Able to creatively stretch the capability of Tableau to customize and develop creatively stunning and dynamic visualizations

●Developed Tableau data visualization using crosstabs,,heat maps,line chart,bar chart,Pie chart.

●Worked extensively with advanced analysis Actions,Calculations,Parameters,Table calculations.

●Utilized Tableau server to publish and share the reports with the business users.

●Used context filter,extract to improve the performance of the dashboard.

●Involved in creating a dual axis bar chart with multiple measures.

●Responsible for creating calculated fields,combining fields,sets and hierarchies using tableau desktop.

●Performed data blending to use the different data sources to bring the data in the dashboard.

●Created Shared Cloud and Search consumption dashboards for increased business metrics visibility,Created Cloud Efficiency Dashboard which shows Executive summary for Cloud spend program (all initiatives across DME, DX & CTech)

●Responsible for creating VP Dashboard which shows Cloud consumption including AWS vs Azure spend by VP (by Env and AWS account etc.) using Tableau .

●Generated context filters and data source filters while handling huge volume of data.

●Azure Migration- Built a feature request & Azure support dashboard to track Microsoft’s performance on support tickets

●Helping QA team for Business scenarios testing and if any issues related to dashboard execution as well.

●Project was based on agile, had multiple sprint and was dedicated to get the work done with in the sprint

●Responsible for interacting with business users to analyze the business process & their requirements

●Responsible for developing business scenarios and making sure that it includes all the key data points checks to ensure in UAT we don’t come up with any defects

●Closely working with executives and interacting to make sure the development is on track per business requirement.

●Responsible for schedule meetings to explain progress on development which help to avoid gap/risk in future if any.

Environment: Power BI, Tableau 2018.1, Tableau 2019.3, Redshift, MYSQL

Adobe

Tableau Developer

Enterprise Parkour April 2015–Mar 2019

Description:

Project is driven to improve overall customer satisfaction by enabling end users with interactive dashboard which can help them easily identify 1) How customer satisfaction is 2) Is SLA’s being met or not etc. To make data available for dashboard, Data engineering tasks are being performed to bring entity and identity across Adobe’s, CAH (Customer Activity Hub), IMS and Entitlements, SAP and SFDC.

Roles: Below are the list of my role and responsibilities in the project:

●Responsible for interacting with business users to analyze the business process & their requirements

●Responsible for transforming requirements in the form of BRD

●Responsible for developing business scenarios and making sure that it includes all the key data points checks to ensure in UAT we don’t come up with any defects

●Closely working with Product Owner and interacting to make sure the development is on track per business requirement.

●Responsible for schedule meetings with product owners to explain progress on development which help to avoid gap/risk in future if any.

●Responsible for end to end development of the Dashboards

●Responsible for making dashboard as interactive as possible for Adobe senior management/Product Owners

●Responsible to educate end users about Power BI which helps end user to execute Power BI dashboard efficiently

●Responsible for designs (Cubes, Entity Relationship) using Lucid chart which gives everyone a clear view about business data flow.

●Responsible for Microsoft SSAS Cube development – Cubes are created to handle large data efficiently

●Helping QA team for Business scenarios testing and if any issues related to dashboard execution as well.

●Creating a view/table in hive and connecting with a cube for analysis.

●Actively involved in all phases of project such as documentation, analysis, Development and testing

●Responsible for finalizing end design such as – whether to go for star schema or snowflake schema etc.

●Responsible for coordinating with multiple teams including offshore team

●Deployed SSAS cube to GitHub Location for deployment from one environment to another environment (stage to Production)

Environment: Power BI, Tableau 2018.1, Microsoft SSAS cube and Hive (Hadoop Big Data)

DHL

Prague (CzechRepublic)/India -Forwin

Cognos/Tableau Developer May 2014 –Sep2015

Description:

FORWIN (Forwarding Intelligence) is the global data warehouse application supporting the reporting needs within DHL Global Forwarding. FORWIN incorporates data from several core operational systems, such as Logis Air, Logis Ocean, FMS, Alliance, Ax freight, OPAC and JBA (as used for operations in AMLA), as well as financial systems. FORWIN provides wide coverage of the DGF business including Through-Shipment Profitability (TSP). The solution is used by global, regional, country and station managers to support their business information needs. It includes Cognos reporting, Cube and basic description of the Framework manager design. Framework model reflects IBM Cognos methodology and is based on experiences from other projects delivered by Teradata in DHL environment and best practices recommended by IBM.This project was including the report creation and migration in Cognos and preparing dashboard using Tableau 8.2/Cognos.

Roles: Below are the list of my role and responsibilities in the project:

●Performed requirements gathering, analysis and source data analysis and identified business rules for the development.

●Prepared Lifecycle Manager (LCM) PPT and gave the presentation before Business Users and Client Manager.

●Installed Lifecycle manager tool and did the comparison of more than 2000 reports.

●Fully involved in the workshop PPT and prepared the slide with Model/Cube architecture.

●Published Package from Framework Manager and had done object level security.

●Rebuild the cubes on transformer 8.4

●In Cognos connection defined groups and roles

●Created data source for the packages and for static cubes on cognos connection.

●Involved in debugging and troubleshooting

●Fixed multiple issues during Migration of reports.

●Code export from production to development and vice versa.

●Involved in end to end development of the Dashboards and to make it as interactive as possible for DHL senior management.

●Created set, groups, Map and parameter, Action filters as per the project requirements for better visibility of the data.

●Assigned geographic roles to some fields which were not automatically recognized by tableau and done the editing for unrecognized locations also.

●Extensively used filter, highlight and URL actions to make more interactive dashboard.

●Involved in interaction with the business users directly as and when required.

●Responsible for UAT support in case business users face issues in the usage of the report.

Environment: Cognos 8.4, Cognos 10.2, Teradata, Transformer, Framework Manager, Lifecycle Manager 10.2, Tableau 8.2

CLOSE BROTHERS PREMIUM FINANCE

United Kingdom/India

ARDW & DCDW Enhancement, BI Developer Mar 2011- Mar 2014

Description:

This is a migration project from Cognos 8.4 to Cognos 10.1. The business offers finance to insurance clients through brokers. The DW contains two data marts. The data is being used by various reporting and consolidation. Some enhancements also required in the project based on BRD (Business requirement document) provided by BA (Business analyst) team.

Role: Below are the list of my role and responsibilities in the project:

●Actively involved in all the document creation related to project like package creation document, functional document, technical design document etc

●Involved in development of complex reports by using filter, prompt, drill through definition, master detail relationship etc

●Involved in performance tuning of reports

●Involved in debugging and troubleshooting

●Migrate all the models (. pyj. mdl) from c8.4 transformer server to c10.1 transformer server by restoring those models in c10.1

●Actively involved in creation of data source, package in C8.4 and c10.1

Environment: Cognos 8.4, Cognos 10.1, ETL Tool (Pentaho Data Integrator), SQL Server 2005

Contact this candidate