Shreyoo Gururaj Patel

• Gathering the business requirements and converting the business requirements into required Logic.
• Studying the source system and listing the constraints, requirements for the migration of the required reports
• Identifying semantic layer tables, Data mart views required for Reporting Layer.
• Creating insight driven reports for the Business users.
• Using advanced like Decomposition Tree, Animated Bar Charts to depict the required KPI in meaningful way.
• Create and document all the requirements for building the reports, changes that are implemented, new features and functionalities within the tool and best practices used as part of the project. (E.g. Report Mapping Document, Reporting Model document, Report-Functional document, Report-Technical.
• Setting up the auto refresh frequency of the reports based on the requirement.
• Creating parameterized Report using query parameters for different Environments (Dev/QA/UAT/Prod)
• Monitor post-implementation and resolve any potential issues to ensure smooth business operations.

Analyse, design and determine coding and integration activities based on architecture of the solution.
Understand the business requirements for developing reports using Quicksight.
Develop highly interactive visualizations with drill through, parameterize, and drill down features.
Use advanced visuals such as Sankey diagrams, KPI Visual, funnel charts, and Gauge Charts for insight-driven reporting.
Configure scheduled refresh for latest data availability.
Work within project planning constraints and communicate identified project risks and issues to the delivery/project manager.
Provide inputs to the change control process.
Support the operational teams during the UAT and rollout phases.
Monitor post-implementation and resolve potential issues to ensure smooth business operations.
Build and develop operational reports in Quicksight that source data from Athena.
Build analytical and pattern-based reports in Quicksight sourced from Redshift Warehouse.
Perform reverse engineering to discover object relationships before designing the reporting model.
Build the semantic layer to help consume data in Quicksight dashboards.
Build custom reports using Quicksight where data was loaded using Json manifest file.
Participate in the migration project for a pharmaceutical client involving Analysis Services sales information migration to Snowflake and repointing reports to Microsoft Power BI.
Coordinate with business and operational users to analyse requirements and consolidate redundant reports.
Prepare templates for documenting requirements and report layouts.

Involved in hypothetical study of different data sets used by the Internal Audit team.
Build a data quality layer with intuitive Spotfire visuals for evaluating data quality.
Build dashboards based on data from the Issue Management Platform for audit findings.
Develop intuitive dashboards supporting the ITSM team using data from the Open Audit tracking system.
Show open audit findings, duration of each incident being open, pending issues, and corrective actions.
Send email to responsible parties with the due date before the audit report is sent.
Revamp business reports in the analytic platform at client location for the Compliance team.
Provide Internal Audit Advisory assistance to one of the EY clients to complete its 2011/2012 Audit Plan.
Design and develop a highly scalable and extensible architecture of an EY proprietary tool for Risk Business.
Create a robust reporting prototype based on technical and functional specification.
Perform PoCs for the Operations Sector of EI Team.
Develop and design customized reports using advanced reporting techniques based on business user specification.
Identify different views to support the semantic layer of the model and code the business logic for each report.
Create report design documents and report mapping documents to map physical layer objects to requirements.
Analyse data, perform data cleansing, and conduct data quality checks.
Build a one-stop portal for the Enterprise Intelligence team focused on Compliance, Resource scheduling, Sales pipeline, EI Dashboard, Training, and Competency Matrix.
Understand business requirements and create Spotfire reports for the internal team.
Evaluate employee competencies by creating customized dashboards.
Participate in presales calls with prospects and clients conducting multiple solutioning workshops.
Train report developers on Tibco Spotfire and other BI reporting tools.

Lead the application support team for banking applications (Treasury).
Involved in the data cleansing team for pulling reports.
Perform data quality checks for the Treasury department at backend using SQL for reconciling closing balances and calculating outstanding invoices.
Define matching rules and associate them with each worksheet.
Reconcile Bank-to-Book, Bank-to-Forecast, and Bank Actual-to-Bank Estimate.

Perform exploratory data analysis and data cleansing using SQL and PLSQL.
Install reporting tool and build interactive reports.
Create standard and ad hoc reports using Spotfire Tool for advertising customer data.
Consolidate the survey dump and provide data drill down and modelling techniques to depict the information from the survey.
Design and implement end-to-end ETL flow for the advertising project data.
Design parameterized reports, including drill down approach to provide dynamic, robust and supportable solutions for retail customer data.
Conduct internal trainings on Tibco Spotfire and Power BI.
Lead design and development activities of ETL.
Provide requirements to hardware deployment team.
Incorporate business logics based on requirement.
Develop scenario tracker with all the business scenario.

Develop scripts for data quality checks for marketing team data.
Define rule engine for data cleansing for acquisition files.
Involved in data cleansing, data extraction, and data analysis.
Perform data mapping using Oracle APEX/HTML DB.
Synchronize various sales contact data sources with Oracle’s enterprise CRM system.
Perform title mapping for marketing team.