Ooha Ranjani Bomma
Data Eng, Mgmt and Governance Sr Analyst
Summary
Versatile professional with total 6.3 years of experience in Information Technology. 4.5 years of experience as a Data Analyst ,POWER-BI. Knowledge of writing SQL queries, joins & subqueries. Working on ETL Process, SDK requests, ETL checks. 2 years of Experience in using salesforce lightening platform and ServiceNow. Gathering and analyzing data from other sources(ODBC Driver) including servicenow and excel, Transformed the data and produced Interactive Dashboards,reports,charts,graphs using the Power BI platform, Excel. Worked on Power Query and Power Pivot in Excel.Hands On Experience on tools like Kibana & Elastic Search. Creating cloud Templates , views , data artifacts,SSAS Cubes, Cached models. Used DAX language in Power BI Desktop and SQL ,Server Analysis Services Tabular models.
Overview
6
6
years of professional experience
3
3
Certifications
3
3
Languages
Work History
Application Development Analyst
Intel Corporation
11.2020 - Current
- OnTrak dashboards is a frontend application to develop reports in the charts/tables format which helps business in rapid decision support solutions by using OnTrak backend Framework where as iBI Daas Tool from where data collection, validation, modelling, storing, integrating for supporting trouble tickets created by customers.
- Identifying the failures in Cached models and debugging the failure message.
- Health code check and debugging.
- Designed and developed reports and dashboards using the Power BI platform. Gathered data from sources like ODBC.
- Create Test scenarios and test cases for Dashboard Failures.
- Log defects and provide status reports to Manager and onsite team.
- Weekly metrics reporting to management and collection of staff’s status reports.
- Completing Stuck collection Tasks.
- Performing analysis to assess quality and meaning of data.
- Debugging on long running collections, high failure etls.
- Fixing Bugs by cmgr validation and checks.
- Working on SDK, creating external views, ETL’s that stuck in running, dispatched.
- Validation on HSD PT’s fix.
- Creating SDK – Topic business models.
- Writing Business rules, Client scripts, Workflows.
- Provide 24x7 Tier 1 support for all High Priority Incidents.
- Retesting and closing the defects.
- Involved in triage calls and daily meetings.
Application Development Analyst
Cisco Systems
10.2019 - 10.2020
- Data Analytics in Cisco is an initiative to predict the renewals for the sold cisco products and update the Business owners to follow with the customers and close the deal. We here generate the eligible renewals, identify, and share to the stakeholders all around the globe.
- Review, analyze and evaluate Territory/Account conflict resolutions and provide admirative and sales support to regional manager & Account managers.
- Validate and Analyze Data for future Renewals& Reorganizing data in a readable format.
- Work Hand in Hand with Clients and support them for all queries related to Renewal Data.
- Extract and share Data for multiple Fiscal period for Business Users.
- Good working experience in Salesforce, SAP HANA, Business Objects Reports and ServiceNow.
- Prepare weekly Deck for all APJC, EMEAR and US Region clients.
- Support Dev Team in Bug detection and Analysis after fix.
- Prepare process documents for the team.
- Work on Adhoc request and prioritize them on client need and higher renewal value.
Associate Software Engineer
CenturyLink (Lumen)
01.2019 - 09.2019
- Company Overview: CENTURY_LINK (Lumen), that offers communications, network services, cloud solutions, voice and managed services and capable of providing customers a wide range of high quality technology solutions over a secure and reliable fiber-rich network and infrastructure solutions.
- Prepare or assist in preparing the M&P and tickets aids for the team in accepted format of the client.
- Solving the tickets independently with average case resolution per day is more than 15 cases.
- Performing Initial Analysis and routing to tier-2 (Dev Team).
- Experience in Sales Chat, which connects client & IT and providing real time solutions.
- Experience in using Ask-CTL Platform.
- CENTURY_LINK (Lumen), that offers communications, network services, cloud solutions, voice and managed services and capable of providing customers a wide range of high quality technology solutions over a secure and reliable fiber-rich network and infrastructure solutions.
Education
BTech - CSE
MallaReddy College of Engineering & Technology
Intermediate - undefined
Sri C.V. Raman Junior college
SSC - undefined
Githajani vidyanikethan
Skills
Data Collection
undefinedCertification
Microsoft Certified in Azure Fundamentals (AZ-900)
Education Summary
- 74.9%, BTech (CSE), MallaReddy College of Engineering & Technology, Hyderabad
- 96%, Intermediate, Sri C.V. Raman Junior College, Khammam
- 9.7, SSC, Githajani Vidyanikethan
Technical Summary
- Hands-on experience on using the applications Kibana, Microsoft SQL Server Management Studio, ETL, SAP HANA, SAP BO, Ibi Query, OnTrak Replication tool, CCW-R, Armor, Brownfield, SDK requests, Visual Studio, SSMS.
- Hands-on experience in writing Database Queries.
- Working on ETL Process, Load Monitor installation, HTTP services installation on Virtual Machines.
- Working on Cloud Creation Templates, migration views from On-Prem to Cloud.
- Having experience on Designing SQL Queries based on transformation rules.
- Removing corrupted data and fixing errors.
- Creating Collections and running jobs.
- Providing trainings for new hires.
- Ability to analyze data sets and extract valuable insights.
- Own ability to meet deadlines and handle pressure in coordinating multiple tasks.
- Good in communication, inter-personal skills and maintaining healthy relationship with the client/Customer.
- Capable of Adapting to New Environments and Learning New Tools and Technologies.
Disclaimer
I hereby insist that the above provided information is accurate to the best of my knowledge and belief. I take full liability for the correctness of the information.
Personal Information
- Father's Name: Upender
- Date of Birth: 03/20/97
- Marital Status: Single
Timeline
Application Development Analyst
Intel Corporation
11.2020 - Current
Application Development Analyst
Cisco Systems
10.2019 - 10.2020
Associate Software Engineer
CenturyLink (Lumen)
01.2019 - 09.2019
Intermediate - undefined
Sri C.V. Raman Junior college
SSC - undefined
Githajani vidyanikethan
BTech - CSE
MallaReddy College of Engineering & Technology
Similar Profiles
Jabeen AbbasiJabeen Abbasi
Module Development Engineer, LTD Lithography at Intel CorporationModule Development Engineer, LTD Lithography at Intel Corporation
KARTHIK KALAIAZHAGANKARTHIK KALAIAZHAGAN
Failure Analysis Engineer at Intel CorporationFailure Analysis Engineer at Intel Corporation
Chiadikaobi NjokuChiadikaobi Njoku
Mfg Systems Software Development Engineer at Intel CorporationMfg Systems Software Development Engineer at Intel Corporation
Rama TalatamRama Talatam
Data Process Steward at Intel CorporationData Process Steward at Intel Corporation
Pranshu SoniPranshu Soni
Application Development Analyst at Accenture Solutions Pvt. Ltd.Application Development Analyst at Accenture Solutions Pvt. Ltd.