Nirosh Bonala

About Nirosh Bonala

Over 14 years of programming experience as a Sr Data Modeler/Business Analyst/Senior PLSQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS), AWS and GCP in Telecom domain.•Involved in all phases of the SDLC from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines. •Involved in various projects related to Data Modelling, System/Data Analysis, Design and Development for both OLTP and OLAP systems.•Facilitated Data requirement meetings with business and technical stakeholders and resolved conflicts to drive decisions.•Comprehensive knowledge and experience in process improvement, normalization-denormalization, data extraction, data cleansing and data manipulation.•Created, documented and maintained logical and physical database models in compliance with enterprise standards and maintained corporate metadata definitions for enterprise data stores within a metadata repository.•Established and maintained comprehensive data model documentation including detailed descriptions of business entities, attributes and data relationships.•Developed source to target mapping document for ETL teams having details about physical naming standards, data types, volumetric details, domain definitions and corporate meta data definitions. •Expertise in Erwin Data Modeler tool for ER, Dimensional Data Modelling.•Build and manage data warehouses, including star schema design, data cleansing and historical data management (SCD).•Deep understanding of SQL, PL/SQL, and scripting languages for data manipulation and automation.•Lead teams, manage project scope, and ensure successful delivery within deadlines.•Strong experience in Data Warehouse concepts, ETL.•Developed Complex database objects like Stored Procedures, Functions, Packages, Cursors and Triggers using SQL and PL/SQL and usage of Exception handling for handling exception scenarios. Effectively made use of Table Functions, Indexes, Table Partitioning, Analytical functions, Materialized Views, Constraints, Index (B Tree, Bitmap and Function Based).•Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans, Explain Plan, HINTS and Indexes.•Created Shell Scripts for invoking SQL scripts and schedule them using crontab.•Experience in ETL techniques and analysis and reporting including hands on experience with reporting tools such as OBIEE and Qlik.

Experience

1. Pl Sql Developer

   Verra Mobility

   Aug 2024 — Present · AZ, US

   Design and develop batch and real time applications for processing the traffic violation events.• Creation of packages and procedures which are called from the UI screen to process the violation data as per the business rules and display the output on the screen.• Creation of database objects like tables, views, materialized views, procedures and packages using SQL developer.• Creation of triggers to automatically update the data in the tables when a desired event occurs.• Used UTIL_FILE package to read the data from the files and write the data into the files.• Used cursors and collections for better performance and retrieval of data. • Collaborate with QA team to work on the test strategy of the newly built applications.• Maintaining Developed code in GIT as per the release.• Provide the data insights and database mapping for the new data to be shared with clients and help BA team with designing the new applications to be built.• Creation of Indexes on the tables and usage of hints for faster retrieval of data to enhance the performance. • Work on the performance tuning of the existing applications using Explain Plan and AWR reports.• Handled errors using Exception Handling extensively for the ease of debugging and displaying the errormessages in the application.• Enhanced the existing shell script to implement the new functionality.

Education

• Kalinga Institute of Industrial Technology, Bhubaneswar

  Bachelor of Technology - BTech

  2006 — 2010