SUMMARY

• 13 years of IT experience as PL/SQL developer in application design, development, deployment, testing and implementation of software using Oracle, PL/SQL in the telecommunication industry.
• Extensive experience working in relational databases like 12c, 11g, 10g and 9i.
• Familiar with Python programming and big data processing languages like SPARK and R.
• Familiar with concepts of Core Java, OOPs, microservices, Spring, Spring boot, Rest services, CI/CD pipelines and Swagger documentation.
• Experience in design of ER, Logical and Physical models with data modeller.
• Extensive SQL and PL/SQL programming experience including packages, stored procedures, functions, triggers, indexes, exception handling and debugging.
• Experienced in creating, documenting and maintaining database objects such as tables, views, indexes, integrity constraints, Stored Procedures and Triggers.
• Used Oracle PL/SQL for implementing business rules and do Query optimization and performance tuning, data analysis and integration.
• Experience in coding, testing, documenting and debugging complex PL/SQL programs in production systems to meet business requirements.
• Coded PL - SQL packages and procedures to perform data loading, error handling and debugging.
• Experience in loading data from flat files into tables using SQL Loader.
• Worked extensively on Ref Cursor, External Tables and Collections.
• Experience in SQL optimization, Performance Tuning for Oracle RDBMS using Explain Plan, Bulk Collections, Table indexing and HINTS.
• Experience with UNIX and LINUX bash shell scripting in putty and scheduling jobs with crontab.
• Hands on experience in developing test plans, test cases, unit tests and procedures as well as execution of manual and automated tests.
• Highly experienced in data analysis and validation, data governance and identifying and resolving data anomalies in complex Data Integration systems.
• Used Team Foundation Server (TFS) for source control.
• Experience in all phases of Software Development Life Cycle (SDLC) deliverables and Service Oriented Architecture (SOA).
• Good knowledge in IDE tools like Toad, SQL Editor, SQL Developer, Visual Studio, Eclipse, Pycharm.
• Team builder with strong, analytical & interpersonal skills with good knowledge in Software Development Life Cycle (SDLC) and proficient in technical writing.
• Ability to work in a dynamic and fast paced environment. Able to multi-task working on numerous projects concurrently.
• Highly motivated, detail oriented, has ability to work independently and as a part of the team with excellent technical, analytical and communication skills, created various documentations for applications and shared a good rapport with the client/management and other team members.
• Good understanding of the development environment using AGILE methodologies with the SCRUM process. Participated in Daily Scrums, Sprint Planning, Sprint Retrospective meetings.

TECHNICAL SKILLS

Languages: PL/SQL, C, C++, Python, HTML, UNIX Shell Scripting, Spark, R

Databases: Oracle 9i, Oracle 10g, Oracle 12c, SQL Server 2016/ 2014/2012/2008/2008/2005 , MS Access, MySQL.

Tools: Control - M Scheduler, TFS, Visual Studio, Eclipse, TOAD, Service Now, SQL Loader, Crontab, Putty, Azure Data Factory, Jupyter notebooks, Pycharm

PROFESSIONAL EXPERIENCE

Confidential, Seattle, WA

Oracle PL/SQL Developer

Responsibilities:

• Coordinating with upstream and downstream systems to address data related issues in the enrollment system.
• Fixing any job related issues via incidents and make sure the issue is resolved, job is up and running in 24 hours TAT.
• Attending business meetings and understanding their data fix related issues and fixing the data in the enrollment system with proper sign off from the testing and business team.
• Coordinating with the DIS team for deploying newly developed code/components in order to go with hassle free On-cycle and Off-cycle release activities.
• Being working in an Agile environment, Need to attend daily stand up calls to provide the status on assigned used stories of the respective sprints.
• Achieving data fix deadlines set by business teams/customers.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
• Wrote Unix Shell Scripts to process the files on a daily basis like renaming the file, extracting data from the file, unzipping the file and removing the junk characters from the file before loading them into the base tables.
• Involved in the continuous enhancements and fixing of production problems.
• Created PL/SQL stored procedures, functions and packages for generating ad hoc reports..
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Involved in PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE.
• 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.
• Partitioned the fact tables and materialized views to enhance the performance.
• Used Team Foundation Server (TFS) for source control.
• Experience in using cron scheduler to automate jobs.

Environment: Oracle 12c/11g, PL/SQL, UNIX, SQL Developer, Toad, Control-M, IP Switch, Service Now.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Coded and tuned Oracle PL/SQL and SQL throughout the development.
• Wrote complex Oracle SQL queries using joins, sub queries and correlated sub queries.
• Developed, tested and optimized SQL queries and PL/SQL code for the migration of large datasets.
• Used advanced Oracle PL/SQL techniques like cursors for data retrieval.
• Developed Shell scripts and SQL control files to load data through SQL*Loader.
• Created many Unix shell scripts for data file extraction and loading.
• Involved in SQL tuning with indexes, partitioning tables, bulk collections and materialized views.
• Supported the production issue solutions to ensure system availability.
• Worked on functionalities like SQL Loader, data dump export/import, traditional export and import.
• 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.
• Used TFS to commit and check-in the codes(pull and push local/remote).
• As a part of AGILE, responsible for regular modification in coding and business logic.
• Used Jira ticketing tool for handling tasks and bugs.

Environment: Oracle 11g/9i, PL/SQL, UNIX, SQL Developer, Toad, TFS, Control-M, Jira.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Involved in the design and development of the CDR billing application for Confidential, state owned telecom company.
• Developed SQL, PL/SQL programs required to retrieve data using cursors and exception handling.
• Developed PL/SQL packages, Dynamic SQL, DML, DDL, Oracle tables, stored procedures, functions, Cursors, triggers and automated scripts for generating various weekly/monthly reports requested by the management.
• Generated PL/SQL scripts for data manipulation and validation and created scripts to create new tables, views and queries for new enhancement in the application.
• Handled errors using Exception handling techniques in Pl/SQL.
• Designed documents for all the developed SQL Queries, PLSQL Procedures.
• Used efficient Joins, Indexes, Correlated queries, Inline views for Query optimization.
• Participating in the test plan preparation.
• Executing Manual Test cases and reporting Bugs.
• Performed application admin activities such as creating/deleting users, assigning roles and associated with DBA team in setting security policies.
• Created ad hoc reports more often based on end user requirements.
• Worked on tuning the SQL Queries for better performance and troubleshooting development problems.
• Familiar in automating database deployments using Redgate.
• Developed stored procedures and triggers to facilitate consistent data entry into the database.
• Developed Control files, SQL*Loader scripts, Oracle import and export scripts for data loading, migration and backup of Oracle data.

Environment: Oracle 10g/9i, PL/SQL, UNIX, SQL Developer, Toad, HTML, HP Service Manager.