Deepa Rao

Application Architecture BI

Dallas, TX

972-***-****

adzs4i@r.postjobfree.com

WORK EXPERIENCE

LivCor a Blackstone Portfolio Company – Data Integrity Architect Remote, TX Nov 2021 – Present

Manage Data Quality team. Play key role in the process to ensure that the data is accurate and consistent across different departments in the organization, work with inter- and intra-department to implement projects. Play key role in setting the priority and assigns tasks to other team members (as required). Work with required team members to mitigate project risks; helps with medium-large problems of team management, organization, and processes.

Develop and executes a Data Quality Strategy that aligns with organizations OKR. Implement the process of embedded data quality in the CI/CD Data Pipeline.

Work to bring confidence to the organization about the quality of the data by continuously engaging the business on validation tasks.

Create a formal Structure of Data Quality and Data Governance Framework with the launch of Data Council identifying champions and SME’s. Create a structure of Data Quality Rules and Standards for checking Data Integrity, Validity and Accuracy. Define and support data governance standard and maintain data documentation such as data dictionary.

Proactively identify opportunities to enhance the Data quality and to implement ethical data handling process based on QRM principles, by identification of the PII data, setting proper masking for Data Privacy.

Continuously improve data integrity knowledge base and understanding, identify training needs, and ensure availability of appropriate and functionally relevant training materials.

Create Strategy for the future state, bring new trends in technology for the data quality.

RealPage – Application Architect

Richardson, TX March 2019 – Sep2021

Cognos content upgrade from 11.1.2 version to 11.2

Lead development, maintenance, and enhancement of BI reporting solutions to meet the needs of the business users using Cognos Analytics.

Work on Problem management escalations. Debugging, roots cause analysis and fixing them in timely manner depending on the priority.

Performance tuning Cognos reports by analyzing and comparing the queries and their turnaround times between SQL and Cognos.

Work with the Data Science team bringing SQL in Databricks and converting to Data frames that can be used in machine Learning. Also used Databricks as a data source with Tableau.

Built Power BI POC using Power BI desktop, Power query editor utilizing DAX expressions for Database Dashboard Management. Build parameters and functions using M query.

Built Tableau POC for tool comparison. Built Benchmarking Dashboard utilizing GIS visualizations on property coordinates having ability to drill down to the unit level in Tableau utilizing calculated fields and parameters.

Built a POC using Looker writing dimensions and measures in LookML setting up Explores for the same and creating reports and visualizations that can be shared with users.

Worked and supported Sisense dashboards for Rentylitics team. PROFILE

LinkedIn: Deepa Rao

TECHNICAL SKILLS

Miscellaneous:

MS- Azure, Snowflake,

Databricks, Data Quality,

Data Governance, Data

Analysis, Data Warehouse,

Data pipeline, Jira, Zephyr

Scale, Alation, Unity

Catalog, Agile/Scrum

Methodology, Leadership,

Problem Management,

Manager, Organizational

Design, Yardi, Entrata,

Onesite, Multifamily data.

BI Tools: Cognos Analytics

11.1.2 (Framework

Manager, Reporting,

Dashboard), Cognos 10.2

and 10.1.1 (Report Studio,

Analytics Studio), Tableau,

Power BI, Sisense, Looker,

DOMO, QlikView, Google

Analytics,

CERTIFICATIONS

The Total Data Quality

Framework,

Measuring Total Data Quality,

IBM Certified Solution Expert

– Cognos BI,

IBM Cognos BI Report Author,

IBM Cognos BI Metadata

Modeler,

IBM Cognos 10 BI

Multidimensional Author,

IBM Cognos 10 BI OLAP

Developer,

IBM Cognos TM1 Developer

10.1

Facilitate Kanban team, and schedule all Scrum ceremonies (daily, Sprint Planning, Sprint Review, DEMO/Retrospective) and follow up on action items.

Monitor and manage teams’ backlog daily and ensure it accurately reflects the current state, including burn-down chart and status, at the release and sprint levels in Azure DevOps/TFS.

Facilitate/negotiate impediment resolution in a timely, cost-effective manner; stay attuned to team need and remove impediments before they form. RealPage – Sr. Cognos Developer

Richardson, TX June 2015 - February 2019

Designed, developed, and built business critical metrics and reports across all business levers and key performance indicators.

Performed detailed data analysis through multi-query, list/crosstab reports, drill- throughs, and master-detail multi-page reports in Cognos Report Studio to derive insights for Multifamily clients. Customized data by adding Prompts, Filters, Calculations, Summaries, Functions and Conditional formatting.

Collaborated with Business, DBA’s onsite and offsite team to build new widgets, reports, and dashboards.

Proactive in researching and learning new BI tools like Looker, DOMO, QlikView, Power BI, Sisense, Tableau and comparing them with existing Cognos functionality by creating POC’s on each tool and giving recommendation to Management on same.

Tata Consultancy Service — Sr. Cognos Developer for Bank of America Addison, TX November 2014 - May 2015

Designed models with appropriate relationships for reporting and created & published packages in Framework Manager from SQL, DB2, Composite and Oracle Data sources and applying proper securities and publishing packages.

Prepared technical and functional documents while transforming the requirements from various lines of business into complex Cognos reports with row-based drill through, master-detail relationships with Multiple Prompts and visualizations.

Creating tickets in Nexus for migrating models, cubes, and reports from DEV to UAT and UAT to PROD

Helped in conversion of reports from Cognos to tableau. Converted reports from crystal reports to Cognos.

Alliant Techsystems Inc — Cognos Developer for ATK Small Caliber Systems Independence, MO February 2014 – October 2014

Participated in requirement gathering meetings. Work closely with business analysts and end-users to understand, capture, document, and analyze requirements. Research and define data mappings for all data to be displayed.

Performed data analysis in Deltek Costpoint on various requirements from users. Identify the necessary back-end tables, necessary data elements, and table relationships.

Used SSMS for data analysis and validate the data sanity. Migrating existing reports in excel and crystal reports to Cognos 10.2.

Maintain a close working relationship with the data warehouse team to ensure the necessary data elements are available.

Model Query Subjects in framework manager. Deploy packages to Cognos DEV environment. Maintain technical views within Cognos, made sure the lineage is correct. Develop and maintain technical documentation.

Designed & developed multiple reports using ATK templates like list reports, crosstab reports and chart reports. Work in report studio to create complex LANGUAGES

English, Hindi

reports and dashboards for the given requirements. Developed Dashboards based on the user group requirements.

Validated that the functional requirements are met before putting into TEST environment. Used version control for Cognos tools like Motio. Provided Cognos training to end-user once report promoted to Production.

Briefly worked on Installing, configuring, and building TM1applications, cubes and dimensions, turbo integrator processes TM1 rules and Executive view reporting.

For the rest of the experience please see LinkedIn. EDUCATION

B.S Electronics Engineering

Contact this candidate