Mamata Barik

Oracle SQL and PL/SQL Developer 980-***-**** adzx1p@r.postjobfree.com

Professional Summary:

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

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.

Strong RDBMS concepts and well experience in creating database objects like Tables, Views, Sequences, triggers, Collections, etc taking the Performance and Reusability into consideration.

Expertise in Client-Server application development using Oracle 12C/11g, PL/SQL, SQL *PLUS, TOAD, PLSQL Developer and SQL*LOADER.

Experienced and skilled Agile Developer with a strong record of excellent teamwork and successful coding project management. Specializes in problem identification and proposal of alternative solutions. Adept at working on multiple projects simultaneously.

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

Experienced and skilled Agile Developer with a strong record of excellent teamwork and successful coding project management. Specializes in problem identification and proposal of alternative solutions.

Worked at conceptual/logical/physical data model level using Erwin according to requirements.

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

Good knowledge on 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.

Worked extensively on Ref Cursor, External Tables, Collections and Exception handling.

Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.

Experience with design and implementation of ETL/ELT framework for complex warehouses/marts. Knowledge of large data sets and experience with performance tuning and troubleshooting.

Experienced in ETL tools of ALTERYX and Informatica Power Center.

2+ years of IT Experience in the Analysis, Design, Development,Testing and implementation of business application for Telecom sectors.

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

Skills & Abilities:

Databases

Oracle 12c/11g/10g, Microsoft SQL 2008/2012, MS Access, DB2

Languages

SQL, PL/SQL,T-SQL, XML, UNIX Shell Scripting, Perl Scripting, C, C++, Perl programming

Oracle Tools/GUI

Forms 9i/10g, Reports 9i/10g, Discoverer 11g, OTM Modules.

Tools

PL/SQL Developer, TOAD, SQL Developer, SQL*Loader, Oracle SQL*Plus, SQL Navigator, PUTTY (Unix/Linux Utilities), Solaris, FileZilla, Teradata, Informatica, Alteryx

Web Technologies

HTML, Apache, Microsoft Internet Information Server (IIS), VBScript, JavaScript, CSS, DHTML, XML,

Operating Systems

Windows Family, MS-DOS

Work Experience:

Client: CHARTER COMMUNICATION

Role: Oracle Developer

Duration: SEP 2022- Till Now

Responsibilities:

Design, develop, validate, and troubleshoot the ETL workflows and datasets in Alteryx

Hands-on skills and work experience in Alteryx Designer, Alteryx Server, and the tools with Alteryx such as Parsing, Transforms, and Predictive

Write complex SQL queries with multiple joins to automate/manipulate these extracts in Alteryx

Document and Publish Alteryx workbooks and data extracts/ Alteryx workflows/macros

Managing and designing the reporting environment, including data sources, security, and metadata.

Extensively worked on Oracle Packages, procedures and functions using PL/SQL, SQL, SQL Navigator, and PL/SQL Developer.

Supporting the data warehouse in identifying and revising reporting requirements.

Supporting initiatives for data integrity and normalization.

Generating reports from single or multiple systems.

Developed terraform scripts and plans to automate whole AWS cloud infrastructure on secure VPCs.Troubleshooting the reporting database environment and reports.

Providing technical expertise in data storage structures, data mining, and data cleansing.

Work in multiple source data extraction and data transition from existing production system to test environment.

Performing root cause analysis and providing recommendations for resolution

Providing data to Marketing,, sales and Business Analyst.

Environment: Oracle19C, Teradata, TOAD, Jira, GitHub, ALTERYX.

Client: SPRINT

Role: Oracle Developer

Duration: Jul 2019-Aug 2022

Responsibilities:

Developing and executing a long-term strategy for enterprise test data management

Estimating testing-related tasks, analyzing testing requirements, designing and developing supporting tools, testing, and implementing TDM processes and solutions

Identifying the Type of Data required for Software Testing

Developed PL/SQL Package, procedure, functions, triggers, indexes and collections to implement business logic.

Created indexes on the table for faster retrieval for enhance database performance.

Creating consistent and repeatable processes to support multiple functions, such as identifying and masking test data for different applications and refreshing/updating test data as needed

Ensuring compliance with IT security guidelines and data compliance regulations

Provisioning data for QA testing, user acceptance testing, and performance testing.

Developed UNIX shell scripts that help as a scheduler for data load.

Created data mapping files for the data coming from different web services.

Worked on customer service call data from different web services

Proven track record in troubleshooting of Data Stage jobs and addressing production issues like performance tuning and enhancement.

Used the DataStage Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into staging tables.

Environment: Oracle12C, TOAD, Unix,, Jira, GitHub, INFORMATICA.

Client: NCR

Role: Oracle Developer

Duration: Apr 2018 - Jun 2019

Responsibilities:

Custom tables and new custom objects were designed as per business requirements.

Involved in all phases of SDLC as active participant.

Designing, Developing, Enhancing and Maintaining Data warehouse Oracle ETL Processes, PL/SQL scripts, DB Procedures, DB functions, creating tables and indexes.

Design, develop and maintain oracle database schemas, tables, standard views, materialized views, synonyms, unique indexes, non-unique indexes, constraints, triggers, sequences, implicit cursors, explicit cursors, cursor for loops, reference cursors and other database objects.

Used various Indexing and partition techniques to improve the query performance.

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

Improved the performance of the application by rewriting the SQL queries.

Created Materialized Views, tables, complex SQL queries, correlated sub queries, Nested Queries, Views and Function Based Indexes for effective Business Application Development.

Designed and developed Oracle PL/SQL Procedures, Functions and Database Triggers and involved in creating and updating Packages to meet business requirements.

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

Used various forms of control structures including CASE, DECODE, IF-THEN-ELSE, FOR loops, WHILE loops while developing procedures.

Used Dynamic SQL to implement DDL statements in PL/SQL programs.

Created scripts to create new tables, views, and queries for new enhancement in the application using TOAD.

Performed Database Administration of all database objects including tables, clusters, indexes, views, sequences packages and procedures.

Environment: ORACLE 11g, SQL Developer, TOAD, UNIX, FileZilla & WinSCP, WebLogic, Vector wise.

.

Client: HIGHMARK Health Solutions PA

Role: Oracle Developer

Duration: Sep 2016 to Mar 2018

Responsibilities:

• Performed design and development of Oracle applications according to project requirements.

• Design, code, and maintain the Oracle systems based on established standards.

• Understand project requirements and develop design specifications.

• Perform initial design reviews and recommend improvements.

• Write clear codes and prepare coding documentations.

• Provide technical assistance to other Developers as needed.

• Analyze and troubleshoot system issues in a timely manner.

• Developed Oracle reports, database procedures and UNIX shell scripts.

• Modify existing codes to optimize Oracle applications.

• Assist in system integration and acceptance testing and perform bug fixes

Environment: Oracle Database 10g, Windows XP, TOAD, SQL Loader, JavaScript, LINUX.

Contact this candidate