Sandeep Kolla

adygkn@r.postjobfree.com

Mobile: +1-925-***-****

SUMMARY:

Around 7+ years of experience as Oracle PL/SQL Developer in Oracle 19c, 18c, 12c, 11g, 10g, 9i & 8i versions and IT experience in Software Development/Maintenance & Production Support Projects.

Technical areas of experience related to PL/SQL, Informatica, UNIX & Shell Scripting.

Experienced in complete life cycle Implementation of PL/SQL Development.

Experienced in working in OLAP and OLTP Database environments.

Proficient in writing complex SQL Queries, Stored Procedures, Normalization, Database Design, creating Indexes, Functions, Triggers, Sub Queries, Collections, Performance Tuning and Query Optimization.

Performance tuning and optimization using Explain Plan, SQL*Trace, TKPROF and Oracle Optimizer hints.

Experienced in PL/SQL Performance Tuning using Bulk Collections and other optimization techniques,

Expertise in Dynamic SQL and Exception Handling.

Expertise in Data Integration of data from various data sources like SQL Server, Oracle, Flat Files, and XML files and Data Migration.

Developed and maintained WMS applications using Oracle RDM and Manhattan WMOS, ensuring smooth operations and meeting business requirements.

Led a team of developers, providing guidance and support in code reviews and error resolution.

Experienced in working with high availability and scalability databases.

Developed and maintained complex database solutions using Teradata, Snowflake, and SQL.

Experienced in importing data from Flat files from Legacy Applications to Oracle DB using SQL Loader.

Creating Users, Roles and Profiles, Privilege management with role-based security.

Expertise in handling 24/7 Production Support projects.

Good exposure to Development, Testing, Production Support, Debugging, Implementation and Documentation.

Experienced in Requirements Gathering and Preparing Use Cases.

Experience with Performance Tuning for Oracle RDBMS using Explain Plan and Hints.

Comprehensive and in-depth experience using the System Development Life Cycle (SDLC).

Expertise in working with Projects in Agile Methodology.

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

A self-motivated, responsible, and reliable team player with a set of strong technical skills.

Strong conceptual, business, analytical skills, and innovative problem-solving abilities.

Good communication, interpersonal and problem-solving skills.

Expertise in Client-Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.

Experience in Design, Development, and Enhancement and Maintaining applications in Oracle 9i/10g/11g/12c, 18c using SQL, PL/SQL.

Experience in both Agile and Waterfall Software Development methodologies.

Strong experience in Data warehouse concepts, ETL.

Good knowledge on logical and physical Data Modelling 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.

Providing a complete solution set to power information-driven value chains.

Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.

Developed and Automated batch load process using SQL*Loader, Shell scripts and Crontab. TECHNICAL SKILLS:

Databases Oracle 8i/9c/9i/10g/11g/12c/18c, MySQL 5, MS SQL SERVER 2005/2008, DB2/UDB, SAP Tables, MS Access, Teradata and Snowflake

Other Technologies HP Project and Portfolio Management (PPM), HP ALM/QC, Oracle E-Business Suite 12, Oracle Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), Oracle Applications Manager (OAM)

Programming

Languages

SQL, PL/SQL, Unix shell scripts, SAS, C/C++/C#, Perl, XML, HTML, VB.NET, python, spark, apex, JavaScript.

WMS Applications Oracle RDM, Manhattan WMOS

ETL Tools IBM Infosphere Data Stage, Informatica

Data Warehousing Star & Snow-Flake Schema Modeling, Erwin, Sybase Power Developer, SSIS, SSRS, OWB, ODI Dev. Tools Windows/Linux/Mac OS Environment, Eclipse, Git/Pvcs, XCode, Subversion (SVN), CVS, ClearCase.

Tools TOAD, SQL*PLUS, SQL Developer, SQL*Loader, Crystal Reports, Forms 6i/9i/10g, Reports 6i/9i/10g, Workflow Builder and XML Publisher.

PROFESSIONAL EXPERIENCE:

Sr Oracle SQL Developer. AT&T, Houston, TX. Oct 2022 – Present. Responsibilities:

Involved in Production Support and Operations teams to resolve production issues in a timely and efficient manner.

Troubleshoot the existing PL/SQL procedures, functions, triggers.

Stored Procedures and Triggers were developed for Business rules.

Collaborated with cross-functional teams to gather and analyze business needs, translating them into technical requirements and solutions.

Implemented object-oriented concepts, patterns, and practices on the Java platform, optimizing performance and scalability of WMS applications.

Involved in writing procedural scripts using PL/SQL.

Used PL/SQL Tables, Ref Cursors to process huge volumes of data and used bulk collect and bulk bind for mass update as performance improvement process.

Used Ref cursors and Collections for accessing complex data resulted from joining a large number of tables.

Involved in SQL Tuning by creation of indexes, rebuilding Indexes using Explain Plan, SQL Trace and TKPROF Tools.

Designed and implemented efficient data models using dimensional modeling techniques.

Created and optimized ETL processes to extract, transform, and load data into the data warehouse.

Improved query performance by query optimization - tracing the query execution plan (explain plan).

Created indexes for better performance.

Developed scenarios for Unit, Integration testing to ensure that all the components work correctly when integrated.

Involved in PL/SQL code review and modification for the development of new requirements.

Involved in data analyzing using machine learning and spark.

Extracted, loaded, and analyzed data to and from Oracle database with Python Used AJAX to reduce page reloads. Worked on analyzing Hadoop clusters using different big data analytic tools including Hive, Spark

Hands on experience on Oracle Database EXADATA express and cloud services.

Responsible for designing and implementing new features into Smart Flow’s case management solution using a combination of APEX, JavaScript, SQL, PL/SQL.

Responsible for the integration of third-party APEX Plugins and JavaScript libraries.

Suggesting application design enhancements and new product features.

Evaluate new technology options, recommending the adoption of new technologies into the solution. Environment: Oracle 10g / 11g/12c/18c, SQL, PL/SQL, SQL*PLUS, Informatica, SQL*Loader, CVS, TOAD, UNIX, Shell scripting. Python, Scala

Sr. Oracle Developer United Health Group. Atlanta, GA. Sep 2020 – Oct 2022 Responsibilities:

Responsible for maintaining the integrity of the SQL database and reporting any issues to the database architect.

Assisted in mining data from the SQL database that was used in several significant presentations.

Assisted in offering support to other personnel who were required to access and analyze the SQL database.

Gather requirements for change requests with the Business team and create design documents.

Provide User Access to Business End Users to the Front-end tools after getting the required approvals.

Create PL/SQL packages for implementing Change Requests for adding new functionality to the application.

Created database objects like Tables, Views, Sequences, Synonyms, Stored Procedures, Functions, Packages, Cursor, Ref Cursor and Triggers.

Utilized Oracle PL/SQL to design and optimize databases, improving data retrieval and storage efficiency.

Implemented and integrated K8, Cloud Services, and Docker Containers to enhance the application deployment process.

Wrote complex SQL Statements, Complex Joins, Correlated Subqueries, and SQL Statements with Analytical Functions.

Developed interactive reports and dashboards using SQL Server Reporting Services (SSRS).

Conducted performance tuning and query optimization to improve database efficiency and response times.

Handled errors using Exception Handling extensively for debugging and maintainability.

Automated Oracle and Informatica workflows using Unix Cron Utility in Unix Environment.

Responsible for writing Unix Shell scripts for loading data using SQL*Loader. The Control Files for the tables were created and automated through UNIX shell scripts to perform data load into Oracle Tables. Used SQL Loader and PL/SQL scripts to load data into the system application.

Performed Data Cleansing to weed out erroneous Orders from the DWH tables.

Extensively used Toad to develop Oracle PL/SQL Packages.

Create Procedures and Functions in SQL Server to migrate data from Legacy servers to Oracle Data warehouse tables.

Create Informatica workflows (7.0 for Flat Roll/9.0 for Tubular implementations) for implementing business logic.

Worked on Sessions & workflows for a variety of loads starting from Source to Target.

Created Parameter Files to override session properties for source directory, Bad file Directory, Source, Target

& created Mapplet parameters for Mapplets.

Created Mappings using Designer, Extracted the data from the flat files and other RDBMS databases into staging area and loaded onto Data Warehouse.

Developed the Informatica Mappings by using Aggregator, SQL Overrides by using Lookups, source filter by using Source Qualifiers and Data Flow Management into multiple targets using Router Transformation.

Developed reusable Workflows, Worklets, Mappings and Mapplets using transformations including Router, Aggregator, Lookup, Filter, Expression, Sequence Generator, Update Strategy, Joiner and Union.

Create Shell scripts for automating the business logic.

Create ABPP (Agile Business Process Platform) workflows which sequences the execution of Oracle Packages, Informatica workflows, Shell scripts as per the business logic.

Deploy the code across the environments to main code consistency and update the same in Clear Case for version control.

Create Test Cases for verification and validation of the Change Requests.

Integration of Oracle APEX with Oracle EBS.

Experience in APEX reports quires & report Layout.

Good knowledge in front-end development using APEX. Environment: Oracle 10g / 11g/12c, SQL, PL/SQL, SQL*PLUS, Informatica, SQL*Loader, Oracle Forms 9i/10g, Reports 9i/10g, CVS, SOAP, REST, TOAD, UNIX, Shell Scripting, Apex, CSS, JavaScript. PL/SQL Developer, Lancaster Technologies, Hyderabad, INDIA. July 2017 – Aug 2020 Responsibilities:

Gather the requirements from the data analysts and architects and perform technical analysis to reach a viable solution.

Responsible for Analysis, Design, Coding, Debugging and Deployment.

Followed Agile methodologies and participated in CI/CD development, ensuring timely delivery of high-quality software.

Facilitated effective communication between business and IT stakeholders, providing regular updates on project progress and addressing any concerns or issues.

Conducted thorough analysis, problem-solving, and debugging to resolve complex technical issues.

Worked with the team to design, develop, test & implement systems. Creation of database objects like tables, procedures using Oracle tools like PL/SQL, TOAD. Written Stored Procedures using PL/SQL.

Worked in preparing functional documents, user documents, process flow diagram and flow chart.

Developed PL/SQL Packages, Procedures and Functions according to Business Requirements.

Created PL SQL procedure, used the DBMS_SCHEDULER for automatic weakly sending emails to the users.

Rich experience in writing SQL queries, Views, Materialized views, cursors, collections, Ref cursor, cursor variables, System reference cursor, Dynamic SQL.

Collaborated with cross-functional teams to analyze business requirements and deliver data-driven solutions.

Provided troubleshooting and debugging support to identify and resolve database-related issues.

Written complex Oracle SQL queries with complexity using Inner/Outer joins, Indexes, Sequences, Union All, Intersect & Minus set operators.

Troubleshoot performance issues and bugs within anonymous blocks, Partitioning dbms_output and Explain plan.

Create various Data Mapping Repository documents as part of Metadata services (EMR).

Customized Reports and Forms to meet user requirements mainly in financial modules (AP, GL, and AR).

Developed Scripts for creation of database objects like tables, views, indexes etc.

Provided Production Support for the application and business users.

Handled Configuration Management Support for Release activities.

Involved in deployment and post-deployment support.

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.

Created extensive documentation on the design, development, implementation, daily loads, and process flow of the Informatica mappings.

Wrote PL/SQL Database triggers to implement the business rules in the application.

Analyze SQL statements, reorganize database objects and design indexes to improve response of queries.

Developed reports using complex queries as per client request as a part of production support.

Provided on call support, solved the user issues, and made necessary changes. Environment: Oracle 10g, PL/SQL, UNIX, TOAD, Oracle Forms 9i/10g, Reports 9i/10g, Erwin, IBM Web Sphere Data Stage, MKS Integrity, CVS, SUN Solaris, MS SQL Server

Software Engineer. Ignis Software Technology, Banglore, India Feb 2016 – Jun 2017 Responsibilities:

Developed various PL/SQL objects like procedures, functions, packages, Cursors, pipeline functions and triggers in accordance with the business needs.

Created database objects like tables, views, synonyms, indexes, views, materialized views, and sequences.

Involved in interacting with the end-user (client) to gather business requirements and modeling the business requirements.

Define and represent entities, functions, and flows between the entities.

Participated in analyzing the requirements for the logical and physical design of the database.

Knowledge of Normalization, Data Warehousing, and data transfer, documentation, preventive maintenance, code review, automation, store procedures and triggers etc.

Experience with merging data files coming from the customer into the existing data warehouse.

Performed exception handling for data that did not conform to the required format.

Implemented purging techniques on the data which is not required by the clients.

Extensive use of Unix Shell Scripts and Autosys to automate processes.

Used Autosys to schedule the batch jobs for Intraday and End of the business day cycles

Responsible for making the merged data in turn available to other clients.

Implemented PL/SQL scripts in accordance with the necessary Business rules and procedures.

Presented several technical presentations on Oracle database operation.

Scheduled html reports using UTL_SMTP, UTL_MAIL and DBMS_SCHEDULER.

Optimized SQL statements and PL/SQL blocks by using Oracle Hints, explain plans, profiling, collecting statistics and Trace sessions for Cost based Optimization.

Environment: Oracle 10g, PL/SQL, Oracle FMW, Xml, Visio, UNIX Shell scripts, SVN, Toad, SQL Developer, HP Quality Center, SQL *Loader, Import Export, Autosys.

Education: Bachelors in Computer Science

Contact this candidate