Roshni Rao

Working on building accuracy controls for various Global and Wholesale products using ETL tool Pentaho and automating the same

• Input of control was configured as exceptions in case management tool- RAID (a tool from mobileum)
• Built dashboard in Qlik Sense for HOD and stakeholders with one stop shop view of controls for all products by normalising various reports/data tables
• Implemented section access and designed data model
• Currently part of core competence team, working closely with HODs
• Prepared various POCs, process improvements, documentation and presentation of existing methodologies and on brainstorming new solutions
• Automated control exception management KPI reporting for all reports. This included determining occurrence of exception and closure rate, backlog and new exceptions computation and trends of happy path.
• Led team of 4 in migrating 200 workflows from Informatica to Pentaho including all stages from development , unit testing, user acceptance testing, debugging, parallel execution, deployment and scheduling of jobs and transformations
• Facilitated in providing data/inputs for one of Global Services MFU for setting up Coverage
• Coverage is a tool that holds the P&L and provides provision of accessing risk and threats to be weighed in order to allocate the precedence for a product to be business assured
• Automated controls on Pentaho from SQL procedures and scripts
• Worked on products that were in C2M phase ensuring all data points are accurately captured in every stage/process
• Designed graphs and charts in Oracle Data Visualisation - ODV
• Used business objects, business intelligence and other reporting tools to extract data from data solutions and data warehouses.
• Analyzed large amounts of data to identify trends and find patterns, signals and hidden stories within data.
• Leveraged text, charts and graphs to communicate findings in understandable format.
• Created and automated data visualisation to present insights and tell compelling stories.
• Developed and implemented data collection systems and other strategies to optimise statistical efficiency and data quality.
• Performed root-cause analysis on data-related system problems to recommend or execute corrective action.
• Diminished process gaps and encouraged optimal productivity by closely supervising workflow of claims analysts and mail clerks.
• Reviewed files, records and other documents to obtain business information and key data informing responses to development requests.

• System discovery, flaw identification in process and system, data enhancement, business knowledge
• Reconciled data from L2C journey and generating exception reports like cancellation charges, discount Capture un-billed revenue
• Detect-Investigate-Prevent fraud
• Validation, billing completeness, order validation, time bound charges, billing, accurately settle charges and pricing accuracy with margin analysis, trend analysis etc.,
• Root cause analysis and predictive analysis
• Technologies used are SQL, PL/SQL, Excel, Free mind
• Understanding and hands on data warehousing, data cleanup, data mapping, data queries
• Knowledge on OSS and BSS, Process flow, Decision making capability, Analytical solution building, problem solving ability.
• Identified and documented detailed business rules and use cases based on requirements analysis.
• Researched and resolved issues regarding integrity of data flow into databases.
• Identified and documented project constraints, assumptions, business impacts, risks and scope exclusions.
• Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
• Trained employees on software to improve data management, monitored use and suggested improvements.
• Produced monthly reports using advanced Excel spreadsheet functions.
• Compiled, evaluated and reviewed engineered data for internal system.
• Documented business workflows for stakeholder review.
• Developed tables, views and materialized views using SQL.
• Built library of models and reusable knowledge-base assets to produce consistent and streamlined business intelligence results.

• Identified and documented detailed business rules and use cases based on requirements analysis.
• Researched and resolved issues regarding integrity of data flow into databases.
• Updated organizational systems and subsystems to improve and streamline data collection.
• Transformed project data requirements into project data models.
• Coordinated statistical data analysis, design and information flow.