Ravi Mishra

Summary (Project): FedEx FSI project is focusing on developing the Cloud based data engine that calculates Fedex Transportation Carbon emissions at Package and Account Level.so that it can help the business understand the emissions footprints at Package and Account Level through fedex.com Responsibilities: 1. Involved in Requirement gathering from Business User, developing technical documentation for the business and Team 2. Involved in the data modelling of the Segment and Package Data. 3. Imported Data from Delta Table using Databricks Cluster 4. Created Dax Queries to generate computed columns in Power bi. 5. Created Reports using Time Intelligence Calculations and Functions 6. Created reports using the functionality of bookmarks and using workaround to show the Latest date in the report by default 7. Worked on all types of transformation available in the Power BI Query Editor. 8. Involved in the usage of Deployment Pipelines At power BI services. 9. Created App in the power bi services to share with desired client. 10. Scheduled Automatic Refresh to get the incremental Data by developing incremental Policy in BI. 11. Involved in the unit testing and UAT. Performed in tuning the performance. Environment: Power BI services, Power Bi desktop, Azure Databricks, Azure Data Lake.

Task Performed: Gathered user requirements, analyzed and designed software solution based on the requirements. Consistently attended meetings with the client subject matter experts to acquire functional business requirements. Designed, Developed and Supported Extraction, Transformation and Load Process (ETL) for data migration with Informatica 7.1 Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression,, Sorter and Sequence Generator transformations. Performed Unit testing, Integration testing and System testing of Informatica mappings Developed Workflows using task developer, Worklet designer and Workflow Manager and monitored the results using workflow monitor. Used informatica scheduler to schedule jobs. Prepared Tableau data extract from various source. Prepared custom SQL query, made inner, left ,right, full outer joins among tables. Working with team of developers designed, developed and implement a BI solution for Sales, Product and Customer KPIs. Created action filters, context filter, parameters and calculated sets for preparing dashboards and worksheets in Tableau. Restricted data for particular users using Row level security and User filters. Developed Tableau visualizations and dashboards using Tableau Desktop as per KPI. Created Scatter Plots, Stacked Bars, Box and Whisker plots using reference, Bullet charts, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications. Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server. Provided 24/7-production support for Tableau users. Quickly and effectively diagnose and respond to service desk requests regarding data integrity and functional or interactive issues in existing and future dashboards. Thorough unit and integrating testing with the back end oracle database to verify calculation performed at tableau end before deployment to production user.

Client: Saudi Telecom Company (Riyadh) Description : STC is looking to create a platform where order transaction, business services and business KPI's. Every single business services will be ordered by various channel, Project deals with real time view of the order management system collected data from various source system, visualization need to be created on the Power BI which in turn share Iframe for embedding the dashboard on website created on Angular JS platform. Responsibilities: Involved in Requirement gathering from Business Users and Developed Technical Documentation for the Business and Team Involved in the data modeling of orders data and client data Imported data from SQL Server DB, Excel sheet to Power BI, Maria DB , Cassandra DB to generate reports Created Dax Queries to generated computed columns in Power BI. Generated computed tables and measures in Power BI by using DAX. Created reports using time intelligence calculations and functions. Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily. Languages English Hindi Skills Spotfire SAP BO Tableau SQL PowerBI Python Oracle Spark Machine Learning Algorithm Developed analysis reports and visualization using DAX functions like table function, aggregation function and iteration functions. Worked on all types of transformations that are available in Power bi query editor. Creating Row level security with power bi and integration with power bi service portal. Created bookmark with the help of button to show the same chart on various selection. Scheduled Automatic refresh and scheduling refresh in power bi reporting server. Created Adhoc Reports using Open source BI tool - Superset Tools and Technologies: Power BI desktop, Power BI,Superset reporting server, Maria DB, Cassandra DB.

Task Performed: Gathered user requirements, analyzed and designed software solution based on the requirements.. Converted business requirement into high level to low level design Involved in all phases of of SLDC from requirement gathering design, development, testing, production User training and support for production environment. Develop the mappings and Mapplets using needed Transformation in Informatica designer tool according to technical specifications. Performed data manipulations using various Informatica Transformations. Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database. Used debugger in identifying bugs in existing mapping by analyzing data flow evaluating transformations. Mappings, Sessions, Workflows from Development to Test and then to UAT environment. Prepared universe in SAP BO by retrieving tables, views, material view from oracle database Written custom query as per business requirement. Made inner, left , right and full outer joins , solved loops formed by alias and context. Extensively worked in Data Transformation. Restricted data for respective user for a same report using security profile at universe level or from CMC. Restricted data as per the business requirement using pre- defined filter, query filter , prompt filter, input control. Worked on Web Intelligence to develop and publish thin client reports. Created Canned Reports and Ad-hoc reports with various complex features, created charts and templates. Developed WeBI reports to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis. Scheduling and monitoring of reports on BO server. Maintained and Enhanced Universes based on updated database. Used conditional formatting, section, breaks. Trained End user on SAP business objects products. Performed unit testing and tuned for better performance. . Tool and Techniques: SQL, SAP BO 4.2, ALM12.5 (QC), Service Now, CMC, Informatica.