Subrahmanyam Maragani

***** ********** **, *****, **, 20105 737-***-**** adzx88@r.postjobfree.com www.linkedin.com/in/maragani-s-3b13b2286

Professional Summary

·2.4 Years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).

·Knowledgeable Oracle Developer skilled in data collection, analysis, and management. Works well under pressure and consistently meets deadlines and targets while delivering high quality work.

·Highly skilled software development professional bringing more than 2 years in API design, development. Advanced knowledge of Oracle SQL, PL/SQL.

·Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation, and maintenance with timely delivery against aggressive deadlines.

·Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques. Expertise in Client-Server application development using Oracle 12c/11g/10g PL/SQL, SQL *PLUS, and SQL*LOADER.

·Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.

·Strong experience in Data warehouse concepts, ETL.

·Good knowledge of logical and physical Data Modeling using normalizing Techniques. Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).

·Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.

·Developed materialized views for data replication in distributed environments.

·Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables. Loaded Data into Oracle Tables using SQL Loader.

·Partitioned large Tables using range partition technique. Experience with Oracle Supplied Packages such as DBMS_SQL, DBMS_JOB and UTL_FILE.

·Created Packages and Procedures to automatically drop table indexes and create indexes for the tables. Worked extensively on Ref Cursor, External Tables and Collections.

·Expertise in Dynamic SQL, Collections and Exception handling. Experience in SQL performance tuning using Cost-Based Optimization (CBO).

·Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans, and Indexes. Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.

·Experience in ETL techniques and Analysis and Reporting including hands on experience with the Reporting tools such as Cognos.

·Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.

·Excellent communication, interpersonal, analytical skills, and strong ability to perform as part of a team.

Experience

ORACLE TECHNICAL CONSULTANT EAPPSYS INFO SOLUTIONS LIMITED, IND SEP 2019 – DEC 2021

Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions, and packages to migrate data from SQL server database to Oracle database.

Build the script for projects module like projects, key members, classifications.

Migrated data from Oracle 11g to Oracle R12 for Balfour Beatty.

Successfully migrated data from Oracle to SAP. (Did not loaded into SAP)

Performed Database Administration of all database objects including tables, clusters, indexes, views, sequences packages and procedures. Implemented 11g and upgraded the existing database from Oracle 9i to Oracle 11g.

Involved in Logical & Physical Database Layout Design. Set-up and Design of Backup and Recovery Strategy for various databases.

Performance tuning of Oracle Databases and User applications.

Used SQL*Loader as an ETL tool to load data into the staging tables.

Provided user training and production support. Improved the performance of the application by rewriting the SQL queries.

Wrote packages to fetch complex data from different tables in remote databases using joins, sub queries and database links.

Involved in the full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.

Wrote sequences for automatic generation of unique keys to support primary and foreign key constraints in data conversions.

Created and modified SQL*Plus, PL/SQL and SQL*Loader scripts for data conversions.

Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.

Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling. Worked on XML along with PL/SQL to develop and modify web forms.

Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.

Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Rule based optimization.

Created some Custom reports and Forms for the end users to check the details and errors.

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.

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. 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.

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 performance.

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

Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.

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.

Collaborated with product management to design, build and test systems.

Collaborated with developers and performance engineers to enhance supportability and identify performance bottlenecks.

Developed code fixes and enhancements for inclusion in future code releases and patches.

Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQL Navigator.

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

Created management analysis reporting using Parallel Queries, Java stored procedure, HTPP Package.

Participated in change and code reviews to understand the testing needs of the change components. Worked on troubleshooting defects in a timely manner.

Involved in creating UNIX shell Scripting. De-fragmentation of tables, partitioning, compressing and indexes for improved performance and efficiency.

Involved in table redesigning with implementation of Partitions Table and Partition Indexes to make Database Faster and easier to maintain.

Experience in Database Application Development, Query Optimization, Performance Tuning and DBA solutions and implementation experience in complete System Development Life Cycle. Used SQL Server SSIS tool to build high performance data integration solutions including extraction, transformation, and load packages for data warehousing.

Extracted data from the XML file and loaded it into the database. Designed and developed Oracle forms & reports generating up to 60 reports.

Worked on SQL*Loader to load data from flat files obtained from various facilities every day. Used standard packages like UTL_FILE, DMBS_SQL, and PL/SQL Collections and used BULK Binding involved in writing database procedures, functions, and packages for Front End Module.

Used principles of Normalization to improve the performance. Involved in ETL code using PL/SQL to meet requirements for Extract, transformation, cleansing and loading of data from source to target data structures.

Involved in the continuous enhancements and fixing of production problems. Designed, implemented, and tuned interfaces and batch jobs using PL/SQL.

Skills

Oracle (SQL, PL/SQL)

Performance Tuning

Data Modelling

SQL PLUS

SQL loader

UNIX Shell scripting

Power BI

Oracle SQL Developer

Shell scripting

DMone Data Migration tool

Jira

Zoho

Excel

Peer Review

Documentation

Oracle O2C functional Work

Testing the OM

Inventory

Hands on Training

AWS, Python, Core Java, Git, GitHub, SQL Developer,, Eclipse, DBeaver, Jira, Zoho, Python Programming, Object-Oriented Programming (OOP) in Python, Libraries and Frameworks (e.g., NumPy, Pandas, Matplotlib), Web Development with Python (e.g., Flask, Django Database Interaction with Python, Data Analysis and Visualization, Debugging and Troubleshooting, Version Control with Git, Working with Virtual Environments, Knowledge of Python Packaging and Distribution.

Python Skills:

Python Programming, Object-Oriented Programming (OOP) in Python, Libraries and Frameworks (e.g., NumPy, Pandas, Matplotlib), Web Development with Python (e.g., Flask, Django Database Interaction with Python, Data Analysis and Visualization, Debugging and Troubleshooting, Version Control with Git, Working with Virtual Environments, Knowledge of Python Packaging and Distribution.

Mini Projects:

DECENTRALISED FREIGHT MONITORING SYSTEM USING BLOCK CHAIN

·Web application that uses blockchain technology to improve transparency to the user and increase security in the supply chain which uses solidity and web3.js for core development and deployed onto Ethereum through truffle framework.

WEB BASED PENETRATION TESTING TOOL USING PYTHON FLASK

·Analysis and graphical representation of vulnerabilities present in block chain, prevention and overcomes of different types of cyber-attacks.

Education:

MSCIS Erie, USA Jan 2022 – May 2023 GPA - 4

GANNON UNIVERSITY:

·Master of Information Assurance and Cybersecurity.

·Course Work: Cryptography, networking, information Security, Implementation of SHA-256 algorithm.

·Build an automated website vulnerability detection using Python and Flask. It conducts scans for various vulnerabilities like XSS, LFI, and SQLi, then visualizes the severity in graphs based on OWASP Top 10. The system generates a comprehensive report enabling quick identification and mitigation of security risks, enhancing web security for organizations.

Certifications

AWS Solution Architect Associate

Microsoft Excel Beginner to Advance

Email Etiquette Rules Everyone Should know.

Oracle PLSQL

Block Chain Essentials

Google Data Analytics Professional Certificate

Contact this candidate