Business Intelligence Sql Developer

Name: Narender Bhukya

Role: PL/SQL Developer

Contact No: +1-614-***-**** +1-614-***-****

Email: ****************@*****.***

https://www.linkedin.com/in/narender-bhukya-840927238/

SUMMARY

** *ears of IT experience in Implementation, Design and Development of Oracle PL/SQL developer applications using Oracle on UNIX & Windows Platforms, total 9 years of IT industry.

Proficient in designing, developing, and maintaining robust software solutions.

Adept at leveraging Python's extensive libraries and frameworks to deliver efficient and scalable applications.

Demonstrated expertise in PL/SQL for database management and optimization.

Strong problem-solving abilities and a track record of delivering projects on time and within budget.

Excellent communication skills and a collaborative approach to working in cross-functional teams.

Experience in Python programming language, including knowledge of object-oriented programming (OOP) concepts.

Oracle Visual Builder is an intuitive development experience on top of a development and hosting platform that empowers you to create engaging responsive applications. Focusing on ease of use and a visual development approach, it provides an easy way for you to create applications that are hosted in Oracle’s secure and scalable cloud platform.

Daily development and testing environment baseline backup and restore, develop and maintain administration scripts by using Perl and corn shell

Experience writing AWS Terraform templates for any automation requirements in AWS services.

Excellent working experience on developing scripts in Perl and Shell.

Daily development and testing environment baseline backup and restore, develop and maintain administration scripts by using Perl and corn shell.

Created Perl scripts to pull the data from tables and load data into new tables.

Pulled data from flat files and loaded into the database tables using Perl scripts.

Developed Perl scripts for data validation of data Responsible for performance tuning of Oracle SQL*queries using the parallel query feature, indexes and processor hints.

Created Alert files using Perl and PL/SQL packages.

This results in frustration, lost productivity, and suboptimal decisions. Oracle Transactional Business Intelligence (OTBI) delivers a flexible and easy-to-use analysis tool that helps you to gain real-time insight into transactional data, understand data patterns and be alerted to key events and data anomalies.

With robust adhoc reporting, role-based dashboards, data visualization and self-service

Information delivery, Oracle Transactional Business Intelligence (OTBI) puts reporting in the hands of business users.

Oracle Transactional Business Intelligence (OTBI) is built on the power of Oracle’s industry-leading business intelligence tool Oracle Business Intelligence Enterprise Edition (OBIEE). This allows users to build powerful data visualization with real-time data that highlights data patterns and encourages data exploration instead of delivering static flat reports.

OTBI provides users a wide variety of data visualization options from standard graphs to advanced visuals such as trellis, tree maps, performance tiles, KPIs and others.

Developed Perl script to write session statistics during transactions.

Oracle BI Publisher is a reporting solution to author, manage, and deliver all your reports and documents easier and faster than traditional reporting tools.

With the separation of data, layout and translation BI Publisher enables customers to maintain fewer reports with greater flexibility and reduced maintenance effort while still generating all the documents and reports needed for your organization.

Write Shell and Perl scripts for unit/system/performing testing for those requirements.

Perl utilities to support job control Used DBI with Perl modules for Oracle connections.

Experience with web development frameworks such as Django and Flask.

Poetry makes it easier to create manage and maintain a simple, isolated, and efficient codebase.

Poetry is a tool for dependency management and packaging in Python. It allows you to declare the libraries your project depends on and it will manage (install/update) them for you.

Poetry offers a lock file to ensure repeatable installs, and can build your project for distribution.

Experience in application software analysis, design, development, implementation, maintenance, and documentation of commercial applications throughout various phases of project life cycle.

Proficiency in analysis, design, development, testing, implementation and maintenance of applications in Oracle Forms and Reports and client/server configurations.

Experience with Database development, ETL, OLTP and OLAP analysis and reporting processes.

The SQL Server Integration Services (SSIS) is the data-warehousing arm of the SQL Server 2008 R2 suite -- equipped with superior Extract, Transform and Load (ETL) capabilities.

The three components in the SSIS platform for starting the data integration process are the Import and Export Wizard, SSIS Designer and SSIS API Programming. The Import and Export Wizard simply transfers data from source to destination but does not include data transformation capabilities.

Provisioning AWS through Infrastructure as code. Push button deployment of new environments and version control of existing systems – Terraforming AWS.

Interacting with Business users, gathering and analyzing requirements.

Experienced in System Analysis, design and implementation. Logical and physical data modeling. Monitor database performance & Tuning.(HFM)

PeopleSoft is software that's part of the Oracle software product line. The PeopleSoft application was originally designed for finance and human resources support, but over time, it has gone on to include more tools and applications for general business operations.

Oracle's PeopleSoft is an industry leading, proven, functionally deep, full suite of integrated applications that can address your business needs for Human Capital Management (HCM) and Enterprise Resource Planning (ERP).

PeopleSoft applications are used by thousands of organizations around the globe across all industries, with a strong presence in service-based industries like health care, education and research, public sector, financial services, and professional services.(EPM)

Writing complex SQL queries and PL/SQL procedures to extract data from various source tables.

Experience in writing Stored Procedures, Functions, Database Triggers and Packages using PL/SQL. Enforcing data integrity using integrity constraints & database triggers.

Experience in generating customized Forms and Reports using Oracle Forms and Reports.

Substantial development experience in creating stored procedures, PL/SQL Packages, Triggers and Functions. Strong knowledge in Oracle cursor management and exception handling.

Enforcing security by creating roles, granting system and object privileges on the tables, stored procedures. Loading data from flat files into database tables using SQL*Loader.

Automating data loading, extraction, reports generation using UNIX Shell scripting (Bourne shells).

Using SSIS packages to run using Controm-M.

Knowledge of databases and Control-M. Strong SQL knowledge and ability to write and investigate complex queries and should have experience in Stored Procedures, Functions, Triggers

Wrote and modified Oracle PL/SQL, Sql statements procedures and functions that are called in the Java Scripts

Knowledge of database architecture for OLTP and OLAP applications, Data Analysis and ETL processes.(EPM)

The SSIS Developer will provide support on projects including designing, building, and maintaining metadata models and complex ETL packages and OLAP cubes.

Experience in developing applications using forms(11g/10g/9i/6i) and reports (11g/10g/9i/6i). Well experienced in backend programming (Triggers, Procedures, and Functions) using Oracle 11g/10g/9i/8i/8.x and web enabled application development and deployment using Oracle application server.

Hands on experience in designing, developing, implementing and deploying applications on cloud using AWS, Azure.

PeopleSoft applications are used by human resource departments in large corporations.

These applications include human resource management systems (HRMS), customer relationship management (CRM), financials and supply chain management (FSCM) and enterprise performance management (EPM).

Experienced in loading data using SQL *loader and using SQL *Plus.

Actively involved in capacity planning, creating views, materialized views, partitioning tables and creating indexes etc. for optimization process.

Expertise in Performance tuning and improved Report’s performance in Tableau using extracts and context filters and custom SQL.

Setting up Jenkins Credentials with AWS Secrets Manager for storing Application configuration data and all App Settings changes.

Having the Good knowledge about the SSIS and SSRS.

Experience with Performance Tuning for Oracle RDBMS using Explain Plan (HFM).

Hands on experience in Amazon Web services including EC2, S3, AWS Lambda, SQS.

Developed Data Mapping and Data Conversion scripts using SQL, PL/SQL.

Written complex SQL’s using joins, sub queries and correlated sub queries.

Wrote Test cases and performed data validation and process testing for application moving into production. Excellent in problem solving, logical and analytical abilities.

Team Player with Analytical skills, ability to quickly adapt to new environment and available as needed for training.

Ability to work independently and as part of a team, deliver under pressure and tight deadlines.

TECHNICAL SKILLS

RDBMS& software

Oracle 12c/11g/10g/9i/8i, Developer 11g/10g/9i/6i suite (Forms 11g/10g/9i/6i, Reports 11g/10g/9i/6i), Control-M, Oracle Designer 2000/6i, SQL*PLUS, Server Manager/SQL*DBA, Export/Import, SQL*Loader, JIRA, Tortoise SVN, Erwin, Toad, Oracle Enterprise Manager Informatica Power Center 9.5/9.1, Flat Files, Excel Files and reports.

Languages

SQL, PL/SQL, PERL, Unix shell scripting (Bourne shells)

Operating System

Windows-2000/NT/98/95, Red hat Linux, MS-DOS,

Languages and Web Technologies

SQL,PL/SQL,XML,HTML/XHTML,Python,ETL,Flask,Django,HTML5,CSS,JavaScripts.

WORK EXPERIENCE

OHIO DEPARTMENT OF MEDICAID, Columbus, Ohio. AUG 2021 to Still Present.

Oracle PL/SQL Developer

Roles & Responsibilities:

•Involve in the development of the application using ETL, HTML5, CSS3, AJAX, JSON and JQUERY.Developed the applications using DJANGO MTV framework which is based on model template view design pattern.

•Architect and implement Oracle CPQ solutions tailored to business requirements, ensuring alignment with organizational goals and scalability.

•Configure advanced pricing structures, complex workflows, approval hierarchies, and commerce processes within Oracle CPQ.

•Integrate Oracle CPQ with Oracle Sales Cloud and Oracle E-Business Suite (R12), ensuring seamless data flow and process synchronization.

•Collaborate with cross-functional teams and business stakeholders to gather requirements, translate them into technical solutions, and deliver CPQ best practices.

•Lead development teams, perform code reviews, and enforce coding standards to ensure high-quality, maintainable, and reliable deliverables.

•Maintain data integrity across integrated systems, troubleshoot issues, and optimize data exchange processes.

•Stay current with the latest Oracle CPQ updates and industry trends, recommending system enhancements to improve performance and user experience.

•Take an active, hands-on role in the design, configuration, and development efforts to deliver robust CPQ solutions.

•Proven experience with Oracle CPQ Cloud, including strong command of BML (BigMachines Language) for advanced configurations and logic development.

•Hands-on experience with REST and SOAP APIs for integrating Oracle CPQ with external systems and services.

•Proficient in leveraging middleware platforms (e.g., Oracle Integration Cloud, Dell Boomi, MuleSoft) to support seamless data and process integration.

•Strong problem-solving skills with the ability to analyze complex business requirements and communicate technical solutions effectively to both technical and non-technical stakeholders.

•Extensively used DJANGO technologies, which includes forms, templates and ORM for communication with database in different forms.

•ORMs provide a high-level abstraction upon a relational database that allows a developer to write Python code instead of SQL to create, read, update and delete data and schemas in their database.

•Oracle BI Publisher is a reporting solution to author, manage, and deliver all your reports and documents easier and faster than traditional reporting tools.

•With the separation of data, layout and translation BI Publisher enables customers to maintain fewer reports with greater flexibility and reduced maintenance effort while still generating all the documents and reports needed for your organization.

•Extensively used interceptors, validates, actions using DJANGO framework.

•Used perforce version control system and Python Tools for Visual Studio (PTVS) IDE.

•Create and write result reports in different formats like txt, csv, and JSON.

•Worked on CSV files while trying to get input from the MySQL database.

•Worked on design and development of Unix shell scripting as a part of the ETL process to automate the process of loading.

•Developed many Perl scripts for server side data processing.

•Created many scripts for data format/validation checking and wrote source code in SQL*Plus and Oracle PL/SQL to handle multiple tables.

•Poetry makes it easier to create, manage and maintain a simple, isolated, and efficient codebase.

•Application Composer is a Web-based application that administrators use to select which data elements are available to users of Oracle CRM On Demand

•Connected Mobile Sales. It is designed to work with any size of data set. It has features for searching, filtering, and tagging data elements.

•Most of these features are not applicable to the small data set in Oracle CRM On Demand.

•ETL uses a set of business rules to clean and organize raw data and prepare it for storage.

•Poetry is a tool for dependency management and packaging in Python. It allows you to declare the libraries your project depends on and it will manage (install/update) them for you.

•Poetry offers a lock file to ensure repeatable installs, and can build your project for distribution.

•The SQL Server Integration Services (SSIS) is the data-warehousing arm of the SQL Server 2008 R2 suite -- equipped with superior Extract, Transform and Load (ETL) capabilities.

•The three components in the SSIS platform for starting the data integration process are the Import and Export Wizard, SSIS Designer and SSIS API Programming. The Import and Export Wizard simply transfers data from source to destination but does not include data transformation capabilities.

•The SQL Server Reporting Services (SSRS) is a framework of reporting mechanisms such as the Report Builder, Report Designer, Report Manager and Report Server that work together through a Web interface to enable the development of concise interactive reporting solutions in print or Web format.

•Report Builder and Report Designer are two SSRS components for generating reports. Report Builder is a simple solution for the information worker or business user to create quick reports without the need to understand the core structure of the data. The Report Designer is a tool for developers because it adds complexity to custom reports development.

•Wrote Python and batch scripts to automate the ETL scripts run every hour.

•Wrote Python scripts to parse XML documents and load the data in database.

•Used Python and Django to interface with the jQuery and manage the storage and deletion of content.

•Rewrite existing Python/Django modules to deliver certain format of data.

Environment: Python, django, Flask, SQL, XML, UNIX, Linux, ETL, MySQL, SSRS, SSIS, HTML5,DBS, JSON, AJAX, JQUERY, CSS, JavaScript.

EQUIFAX, St, Louis, MO JUN 2020 - AUG 2021 Oracle PL/SQL Developer

Roles &Responsibilities:

Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.

Worked on SQL*Loader to load data from flat files obtained from various facilities every day.

Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.

Wrote UNIX Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.

Involved in the continuous enhancements and fixing of production problems.

Generated server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.

PeopleSoft applications are used MemSQL departments in large corporations.

These applications include human resource management systems (HRMS), customer relationship management (CRM), financials and supply chain management (FSCM) and enterprise performance management (EPM).

Developed PL/SQL triggers and master tables for automatic creation of primary keys.

Created PL/SQL stored procedures, functions, and packages for moving the data from staging area to data mart.

Created scripts to create new tables, views, queries for new enhancement in the application using TOAD. Created indexes on the tables for faster retrieval of the data to enhance database performance.

Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.

Performed SQL and PL/SQL tuning and application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.

Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.

Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.

Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL_FILE package.

The Oracle E-Business Suite (EBS) General Ledger (GL) module is a comprehensive financial management solution that provides highly automated financial processing, effective management control, and real-time visibility to financial results.

Trial Balance and Journal reporting with drill down to Accounts Payable (AP), Accounts Receivable (AR), Inventory (INV), and Fixed Asset (FA) subledgers.

Sample financial statements, including the Balance Sheet, Cash Flow, and Income Statement using the EBS Financial Statement Generator (FSG) hierarchy.

GL to SLA reconciliation for the AP, AP, INV, JSON, and FA subledgers.

Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.

Partitioned the fact tables and materialized views to enhance the performance.

Extensively used bulk collection in PL/SQL objects for improving the performing.

Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.

Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.

Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

Environment: Oracle 11g, SQL* plus, TOAD, XML, JSON, SQL*Loader, SQL Developer, Shell Scripts, UNIX, Windows XP.

MASTERCARD O’Fallon, MO Mar 2017 - June 2020

Oracle PL/SQL Developer

Roles &Responsibilities:

Analyzing the new Requirements and preparing the design documents.

Worked on migration of 4G LTE data from multiple legacy systems to EDW for better decision making.

Developed Oracle Extracts scripts to extract the data and created the staging tables to transform (to map) the data and load into target tables using Unix load scripts.

Analyzed data, designed, and developed Oracle forms 11g queries, layout, report triggers, parameter form, data models etc.

Developed new codes for data load and modified the existing load scripts to load data into Data Warehouse from different sources as per the requirement.

Developed Stored Procedures, Functions, Packages and SQL Scripts for database transactions using PL/SQL.

Oracle Golden Gate is a software product that allows you to replicate, filter, and transform data from one database to another database.

OGG is able to generate micro batch of real time data and feed them to our ETL tool (like ODI, or Informatics).

Development of database triggers, cursors, packages, procedure & functions using PL/SQL & SQL.

Worked on end-to-end flow in Data Warehouse.

Documenting the modifications and enhancements made to the application systems and databases as required by the project.

Created Triggers, Stored Procedures, Packages and SQL Scripts.

Developed PL /SQL code for updating payment terms.

Preparation and execution of test plans for unit & system testing.

Analyzing the test results and recommending modifications to the applications to meet project specifications.

The Oracle E-Business Suite (EBS) General Ledger (GL) module is a comprehensive financial management solution that provides highly automated financial processing, effective management control, and real-time visibility to financial results.

Trial Balance and Journal reporting with drill down to Accounts Payable (AP), Accounts Receivable (AR), Inventory (INV), and Fixed Asset (FA) subledgers.

Sample financial statements, including the Balance Sheet, Cash Flow, and Income Statement using the EBS Financial Statement Generator (FSG) hierarchy.

GL to SLA reconciliation for the AP, AP, INV, and FA subledgers.

Developing and implementing the test validations of the applications specifications

Wrote efficient stored procedures for the optimal performance of the system

Involved in formulating general methodologies, naming conventions and coding standards for various procedures and packages.

Having the Good knowledge about the SSIS and SSRS.

Substantial development experience in creating stored procedures, PL/SQL Packages, Triggers and Functions. Strong knowledge in Oracle cursor management and exception handling

Worked in debugging and tuning the PL/SQL code, explain plan and tuning queries for the Oracle database

Worked on SQL*Loader to load data from flat files obtained from various facilities every day.

Generated context filters and used performance actions while handling huge volume of data.

Used external tables to manipulate data obtained daily before loading them into the tables.

Experience in UNIX shell scripts in writing deployment code for migrations.

Developed PL/SQL Procedures at the database level that were used in the mappings through Stored Procedure Transformation.

Creation of interface screens and reports using oracle forms and oracle reports.

Loaded the data into database tables using SQL*loader from text and excel files.

Utilized SQL*Loader to load flat files database tables.

Handled various exceptions to troubleshoot PL/SQL code.

Formulated procedures, functions.

The SSIS Developer will provide support on projects including designing, building, and maintaining metadata models and complex ETL packages and OLAP cubes.

Created indexed views, and appropriate indexes to reduce the running time for complex queries

Monitoring the system performance and tuning the SQL codes by reading the explain plans.

Coordinating code builds between environments.

Used ETL to load the data from various sources into EDW.

Tested the various ETL processes that were developed to fetch data from various feeds coming from Admin System

Analyses the warehouse data provided reports for the same.

Involved in Code Review, Code Walk Through, and Unit Testing.

Environment: Oracle 11g, SQL, XML, Oracle Forms & reports 11g, Informatica Power Center, PL/SQL, Explain Plan, Microsoft Excel, UNIX, Toad, Oracle SQL developer, shell Scripts, SQL*Loader.

Chicago State University, Chicago, IL May 2015 – March 2017

PL/SQL Developer

Roles &Responsibilities:

Involved in all phases of software development including gathering requirements, creating specifications, development of database objects, developing code and validating programs.

Involved in the creation of database objects like tables, views, stored procedures, functions, packages, DB triggers, Indexes and Collections.

Developing highly complex applications using Oracle 10g database as backend with expertise in design and development of Oracle PL/SQL packages and procedures.

Involved in the design of Data-warehouse using Star-Schema methodology and converted data from various sources to oracle tables.

Extensively used PL/SQL Developer for creating database objects, running the command scripts for inserting the configuration data items.

Involved in moving the code to production using Change Management Procedures.

Documented all the packages, procedures and functions involved in ETL process.

Written many database triggers for automatic updating the tables and views.

Developed complex triggers in reports before/after for validation of user input on the application system.

Responsible for back end stored procedures development using PL/SQL predefined procedures.

Used Explain Plan and hints to tune the SQL.

Utilized SQL*Loader to load flat files into database tables.

Created PL/SQL based ETL process to transfer data from sources.

Used PL/SQL developing to load data from the source table to the target table based on the business logic.

Developed conversion programs to bring Legacy details into Oracle table using NoSQL SQL*Loader, PL/SQL Package and populated data into base tables.

Used EXPLAIN PLAN get the statistical data for the performance tuning of the SQL queries and stored procedures.

Used UNIX Shell scripts to deploy the Oracle forms and reports to production servers.

Involved in loading the data from flat files to Oracle tables using SQL*Loader and C.

Involved in creating user documentation and providing End user training.

Environment: Oracle 10g, SQL* Plus, Tableau 7 UNIX Shell Scripting, PL/SQL, SQL * Loader, Explain Plan, TOAD.

Contact this candidate