M Lokeswara Reddy

Responsibilities:
• Developed Cost performance Enablers dashboard using PowerBI to compare the projects UTC journey and benchmark shell internal projects with external projects.
• CPET dashboard includes visualizations like Bar chart, Pie chart, Tree Map, Box Plot, Parallel Co-ordinate plot, Scatter plot & Map Chart etc.
• Developed complex data models and DAX expressions, Aggregations and bookmarks in the PowerBI dashboard.
• To achieve data anonymization , developed Azure app which will anonymize the data in the power dashboard. Performance analyzer and vertipaq analyzer are configured to track the dashboard performance.
• Row level security is implemented in the dashboard. Created dashboards for Transposed Accounts, Transposed volumes which will show the data for different UOM’s.
• Developed Business one reports include the visualizations that will show the different KPI measures data for the different line of business. Developed Spotfire Created XMR charts in the global Logistics project for Aviation, Marine and land.
• Created Competency reporting dashboard for Prelude FLNG which will provide the shift details and Role details and certificate details of the persons assigned to the facility.
• Created Spotfire reports using the data sources like HANA, SQL and Azure SQL. Created dashboards for operations time to check the status of the BODS and HANA and Sql jobs.
• Used detailed visualization and cross table reports for each business unit. Worked on various visualizations like Bar chart, Pie chart, Tree Map, Box Plot, Parallel Co-ordinate plot, Scatter plot & Map Chart etc.
• Created Complex query information link to connect to various data sources. Developed standard reports using SPOTFIRE for different Departments.
• Created complex dashboards using property controls, prompts, Filters, calculated columns for different functionalities. Used detailed visualization and cross table reports for each business unit. Worked on various visualizations like Bar chart, Pie chart, Tree Map, Box Plot, Parallel Co-ordinate plot, Scatter plot & Map Chart etc.
• Created Bookmarks, tags on visualizations and published them to end user. Performed.
• Customization using Iron python script.

• Company Overview: Dean Foundation is dedicated to serving others through public service, health education and advancements in clinical research
• It is one of the largest integrated healthcare delivery systems in the country
• Utilized complex Spotfire features to build complex corporate dashboards and visualizations with multiple graphs and charts that analyzed the revenues of hospital
• Worked on Spotfire Professional to create dashboards, and published them for end users Deliver advanced/ complex reporting solutions such as Dashboards and Standardized Reporting
• Set up Guided Analysis DXP files-included Cover Page, Navigation Links and Filtering Schemes etc
• Used Transformations-Pivot and un pivoting
• Created DXP files from multiple data sources
• Used Load on Demand Data tables for Performance Improvements
• Enhanced Visualizations using Trellis, Reference Lines, Custom Expressions and Details Tables
• Analyzed functional areas and formulated data requirements needs related to building visualizations
• It is one of the largest integrated healthcare delivery systems in the country
• Environment: Spotfire professionals 6.0, Spotfire web player, Spotfire enterprise player, SQL Server, UNIX, Spotfire server, TIBCO BW

• Company Overview: Agilent Technologies is the leading independent provider of global factory-to-dealer transport logistics and also manufactures the laboratory needed equipment’s
• Gathering the requirements from business team and transmuting them into technical architecture and design documents
• Involved in estimation, analysis and solution documents
• Strong experience in creating sophisticated visualizations, calculated columns and custom expressions
• Developed Map Chart, Cross table, Bar chart, Tree map and complex reports which involves Property Controls, Custom Expressions
• Created Complex Information Links to pull the data from Oracle 10g/11g
• Expert in Writing SQL Queries on Oracle and DB2
• Created the Materialized views on the aggregate functions and used that in the reports
• Created various Reports using SPOTFIRE and involved in Performance tuning
• Created reports using complex calculations and variables
• Implemented User level security to the Reports
• Extensively worked with formatting the reports according to the user requirements
• Developed Dashboard reports for Project portfolios which help in better analysis for decision making using SPOTFIRE
• Used Iron Python to create power actions in test areas
• Involved in migrating the dashboards from Development to Production environments
• Used SQL to join the data in the database
• Perform day to day administration of SPOTFIRE, including group/library management, upgrades, monitoring log files, performance tuning, troubleshooting and reporting
• Environment: TIBCO Spotfire 5.0, 5.5,6.0
• TIBCO web player
• Automation services, Application data services, Windows 2008 R2 servers