NEELA MADHAB PANDA

• Working for client Sony Pictures Entertainment.
• Managing reporting solution (along with KPI+Forecast) in Tableau & SAP Business Objects.
• Creating Complex Tableau reports utilizing the features like Hierarchy, Blending, KPI Calculation, Actions - Drill Down functionality, Graphs.
• Performing multiple roles such as report design, report development, and report migration, analysis, and storytelling using an assortment of Tableau & SAP business objects products(including Web Intelligence (Webi) and Dashboard Designer).
• Worked on interactive Tableau dashboards, scorecards, and weekly/monthly reports on the status of key business measurements that are tailored to all audiences.
• Designed the logical semantic layer using the Universe designer tool by defining joins, cardinalities between tables and applying contexts and aliases to remove cyclic dependencies (Loops/traps).
• Handled Embedded BO Functions like @Prompt, @Select, @ Variable, @Where, @Aggregate awareness in the designer to handle user requests for report generators. Set up Aggregate tables to enhance the SQL performance
• Served as point of contact for clients regarding follow-up, meeting scheduling and responses to questions.

• Worked for client Morgan Stanley.
• Created Dashboards for Branch Managers, which enables them for tracking asset of each Field Agent.
• Implemented Context Switcher property ( MS custom feature ) on the dashboards.
• Worked on automating the extract of Tableau Dashboards based on an event.
• Worked on a dashboard which shows the distribution of assets for a departed FA.
• Embedded few custom extensions in the Tableau dashboards.

• Used formatting options such as crosstab representation, Section Breaks, Data Sort Options, Calculations, Fonts, Colors and conditional formatting in Webi reporting.
• Developed various charts, Graphs, Drill-Down reports, tables using Webi.
• Involved in creating conditions, Operators, Formulas, Filters, Ranking, Sorting, Combined Queries, Prompt, Section and Scope of Analysis
• Formulating and developing Webi Reports on top of Universe (both UDT and IDT), utilizing derived tables
• Scheduling Reports and Publications.
• Developing functions, views & stored procedures on the back-end SQL database.
• Utilizing Row level and column level security in IDT
• Responsible for effort estimations for Business Object universe and reports requirement.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server
• Created action filters, 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.
• Developed Tableau workbooks from multiple data sources using Data Blending.

• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently in Tableau.
• Generated context filters and data source filters while handling huge volume of data in Tableau.
• Worked on Webi reports, Prompts and Report Layout and re-formatting.
• Developed Complex Universes by linking different data sources.
• Create Aliases and Contexts for resolving Loops and check the Integrity of the Universe.
• Fine-tuned universes and reports by creating aggregate tables and filters.
• Created Webi reports using Universes, stored procedure and Free hand SQL as Data providers.
• Created Business Views for the LOVs in some of the reports.
• Created various Linked and Unlinked Sub Reports and managed the parameters accordingly.
• Devising complex calculation HANA Views
• Designing and implementing SAP HANA data modelling using Attribute View, Analytic View, and Calculation View; developing complex SQL scripts in Calculation Views and stored procedures.
• Performing data provisioning by managing tools such as Table Replication (LTRC), Monitoring, Table enhancement at SLT server using LTRS

• Created Webi reports based on universe as well as on top of BEx queries
• Worked as a BO Developer/Administrator; gained exposure of BI Launchpad, BO CMC, BO server splitting and server installation/upgrade
• Assisted in completing BO migration process
• Assisted in creating Analysis Application using Design Studio
• Administered and supervised the Business Objects (SAP BI) environment by monitoring/granting permissions and rights to users for viewing, creating, publishing reports; created Custom Level Access Controls and maintaining BW side Authorization

• Worked as Asst. Manager in Reliance Retail in SAP MM Module
• Devised Article Codes and maintained all the required details in SAP system for POS
• Performed Reconciliation Process and Listing Operations
• Analyzed sales price and tax updation of Article codes against Vendors and State
• Developed Planograms (POGs) as per the requirement from Functional Team using JDA software

· B.Tech. (Electronics & Comm. Engineering) from JITM, Paralakhemundi, BPUT in 2012 with 8.14 CGPA

12th from SKCG Autonomous College, Paralakhemundi, CHSE in 2008 with 78%

· 10th from SSVM, Paralakhemundi, BSE in 2006 with 83.46%