Data Analyst Sql Developer

Mamata Barik

Oracle SQL and PL/SQL Developer and Teradata Developer 980-***-**** ***************@*****.***

Professional Expertise:

Over 5+ 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).

3+ years of experience as a Data Analyst and Developer in Teradata database development and an excellent understanding of data warehousing, relational database structures concepts

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 11g/10g, 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 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 Shell Scripts for invoking SQL scripts and scheduled them using crontab.

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

Experience in Test data Management and provide test data.

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

Skills & Abilities:

Operating system

Windows, UNIX/Linux, MacIntosh

Tools

MS-Office Suite, T.O.A.D, Alteryx, Jira tools

Databases

Oracle-PL/SQL, Teradata

Configuration Management

GitHub,BitBucket,Sourcetree

Education:

Master in Computer Application

KIIT Bhubaneswar, India – 2007

Bachelor in Computer Science

Utkal University, India – 2004

Work Permit: H4 EAD valid till May 2024

Projects:

Database Developer and Analyst .

SEP 2022- Till Now

CHARTER COMMUNICATION

Responsibilities:

Design and maintain database systems. This includes creating, updating, reading, and deleting .

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

Supporting the data warehouse in identifying and revising reporting requirements.

Supporting initiatives for data integrity and normalization.

Generating reports from single or multiple systems.

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: Teradata and ALTERYX tool.

Test Data Analyst

JUL 2011-Jan 2014

SPRINT

.

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

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.

Oracle Developer

NCR

APRIL 2009 - JULY 2011

Responsibilities:

Works on different database management systems efficiently

Has a good command over data warehousing concepts to load the data effectively

Design, develop, and automate the data

Develops data flow models for ETL applications

Testing the storage system after transferring the data

Prepare documentation for the further reference

Ensure that the data is scalable and architecture

Work with clients to deliver scalable and maintainable data

Gather essentials and process them for business needs

.

Oracle Developer

AIR CANADA, CANADA

Sept 2008 - March 2009

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

Contact this candidate