Renuka Yadav Email & Phone Number

Canada

Ontario, Canada

▪ Inter-team collaboration for product deployment during Proof of Concept (POC) and leading the Quality Assurance (QA) before customer demonstrations.• Working directly with Director of Product for multiple BI deliverables and in-house product• Proactive watcher on quality of deliverables• Working with Git for code integration, Bitbucket/SVN for version control and JIRA for task management• Working with MongoDB, learnt and implemented mongo queries, Vertica database for complex sql queries, query profiling, query optimization▪ Exposure handling multiple BI requests (customer and internal) in both onshore and offshore positions while managing the QA deliverables across customers.▪ Managing the QA deliverables that involve creation and maintenance of Requirement Traceability Matrix/Test Plan/ Test Summary Reports and reviewing the Test Cases▪ BI Report testing/ Database Testing, manual testing, functional testing, Regression Testing and Smoke Testing▪ Active participation in Scrum calls, fix-pack planning and Product feature discussions

Delhi Area, India

• Requirement gathering and sharing the feasibility study. • Creation of dashboards for CXOs and different teams• Working directly on client site(onsite), closing the requirement gaps and implementation in an incremental manner.• Debugging and resolving issues on regular basis in BI solution related to data and reports/dashboards in both onshore and offshore positions• Impact analysis of enhancements needed in existing reports and implementing them• Scheduling reports and alarms in case of KPIs crossing thresholds• Fixpack planning, deployment and roll out on production environment• Pre-UAT and UAT support, training end user on how to use/share/download reports• Knowledge sharing across the team members• Extracting data from multiple CDR tables/Aggregations by creating complex SQL queries that joins multiple tables• Data Cleaning, transformation, and modelling• Working with star and snowflake schema to fetch desired reports and sharing with customers• Root Cause Analysis of issues (following top to bottom approach), exploring each layer of the product

Gurgaon, India

▪ Creation of executive dashboards extensively in Report Studio and Active Reports.▪ Worked on Framework Manager for metadata modeling▪ Created report templates for Power Users in Cognos Workspace Advanced in Cognos V10.x and Self-Service BI in Cognos Analytics▪ Type of Reporting: List, Crosstab, Chart, Visualization, Dashboards & Active Report.▪ Creation of Drill Through reports to get detailed level records from a summary report.▪ Designing simple to complex SQL queries, preferably for data reconciliation.▪ Fundamentals of Cognos Admin Activities like applying security, scheduling the report, add/delete member, access & permissions, restarting query services, logging & tuning, stop/start/test dispatchers etc▪ Worked on Report Studio, Query Studio, Event Studio, Analysis Studio, Cognos Workspace Advanced▪ Hands on experience in creating DMR metadata and reports▪ Working with prompts such as date/time, cascaded prompts, tree prompts, select & search prompts etc▪ Creation/Designing Cubes in Transformer which can run either on Full Refresh or Incremental Refresh basis.▪ Training on Watson Analytics, IBM Block Chain Essentials, IBM Block Chain Consultant▪ Hands on experience on Tableau(Visualization Tool)• Reporting Tool : Cognos Analytics Versions (10.x, 11.x), Tableau Visualization Tool• Maintenance Tool : Clear Quest - which is a defect tracking tool. BMC Remedy Version 7.6.4 - used for ticketing and CR Management. Co-Desk- Ticket Maintenance Tool• Database : dashDB (Cloud Database), Oracle, ms sql server, mysql▪ Solved severity 1 issue for one of the telecom customers where OLAP Cubes failed for one of the important provinces.▪ Pre-UAT and UAT SPOC for end-to-end data reconciliation▪ Preparing the draft layout of dashboard which is to be agreed during FS signoff Development/testing/deployment/go-live/maintenance & production support▪ Setting up Self-Service BI for customer and training them on how to make use of it