Akshaya Mangal

**** ****** **, ************, **

Visa Status: Green Card

Phone:240-***-****

adm9r2@r.postjobfree.com

PROFESSIONAL SUMMARY

4+ Years of programming experience as an Oracle PLSQL developer in Analysis, Design and Implementation of Business Application 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 deadline and targets while delivering high quality work.

Working knowledge of Relational databases and methods for efficient data retrieval

Good understanding of Informatica Power Center (versions 9.5/8.6/ 7.1) including Power Center Designer, Workflow Manager, Workflow Monitor, Repository Manager

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

Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Materialized Views, Query Re-write.

Created Table, Views, Constraints, Index (B-tree, Bitmap and Function Based)

Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PLSQL.

Improved Performance of PLSQL codes using DBMS_PROFILER Package.

Developed Materialized Views for data replication in distributed environments.

Experience in Oracle supplied packages, Dynamic SQL, Records, PLSQL tables. Loaded data into Oracle Tables using SQL loader.

Database knowledge of Python interaction with databases

A strong understanding of python data package like Pandas

Experience creating materials for executive review.

Good understanding of Jupyter Notebooks to analyze and connect data from different sources.

Troubleshoots data integrity issues, analyzes data for completeness meet business goals.

Partitioned large Table 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.

Knowledge of GUI standards and object-oriented design methodologies

Expertise in Oracle SQL performance tuning using Cost-Based Optimization (CBO).

Integrated new data management technologies and software engineering tools into existing structures and processes.

Good knowledge of Data reporting and Data visualization using Tableau.

Proficiency in Basic Linux system processing with shell scripting.

Hands on experience with Batch processing.

PROFESSIONAL EXPERIENCE

Software Engineer, Infosys Limited Bangalore, India (May 2017-Jan 2020)

Worked with Telstra (Telecommunication Company, Australia) on an ETL/Data Warehouse project.

Involved in the analysis of the user requirements and identifying the sources.

Completed documentation in relation to Data Flow Diagram (DFD), mapping documents and high-level data models.

Worked closely with customers, internal staff, and other stakeholders to determine planning, implementation, and integration of system-oriented projects.

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 daily basis like renaming the file, extracting date from file, unzipping the file and remove the junk characters from the file before loading them into the base tables.

Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Materialized Views, Query rewrite.

Worked on Analytical functions such as RANK,DENSE_RANK,LEAD,LAG,SUM Exposed to advanced PL/SQL constructs like Nested tables, Varrays, Records, types.

Developed complex database objects like Stored Procedure, Functions, Packages, Triggers, using SQL Developer.

Wrote scripts in Python for Extracting Data from JSON and XML files

Created Materialized view for data replication in distributed environments.

Created the Source and Target Definitions in Informatica Power Center Designer

Experienced with Data Warehousing techniques (Star Schema, Snow flaking, Denormalization, Normalization, Aggregation).

Created Materialized Views and Indexes for better performance of summary tables.

Expertise in Dynamic SQL, Collections, Ref cursor and Exception handling.

Used Bulk collect and Bulk binding for better performance and easy retrieval of data by reducing context switching between SQL and PLSQL engines.

Used Oracle supplied packages like DBMS_OUTPUT, UTL_FILE to extend PLSQL programs.

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

Created and maintained Database Objects like Tables, Views, Sequence, Synonyms, indexes

Created numerous complex queries involving joins, merge, correlated subqueries, diverse business requirements.

Participate in all aspects of the Software Development Lifecycle in Agile Methodologies (SDLC)

Analyzed client requirements and complex business scenarios.

Partitioned large tables using suitable methodologies like Range partition, list partition, hash partition to improve the manageability, availability, and performance.

Understanding of software skills such as business analysis, development, maintenance, and software improvement

Documented all the details discussed in team meeting and circulated amongst the team members.

Knowledge of Git and GitHub or a deep understanding of version control tools and branching model.

Junior Software Engineer, Infosys Mysore India (January 2016 – May 2017)

Performed updates to the SQL system as assigned by management.

Actively participated in decision making and QA meetings and regularly interacting with the Business Analyst and development team to gain a better understanding of the business process, requirement, and design.

Created Jobs to read and write data into complex flat files, Sequential files.

Managed security of the application by granting and revoking various privileges/roles to users and applications.

Designed and developed Data stage job to extract data from heterogeneous sources applied to the transform logic.

Provided ideas while troubleshooting the systems and restoring it to its efficiency levels.

Performed complex SQL queries using Joins, Subquery, Complex data Merge and other methods.

Did advanced Data validation using MS Excel.

Advanced in MS Excel including PivotTables, VLOOKUP, INDEX/MATCH, and Data Tables

Created database objects like Table, Views, Indexes, Synonyms.

Assisted the lead developers in designing and developing Oracle database.

Gathering and analyzing project requirements and planning work processes

SKILLS

Skills: PL\SQL, SQL, PYTHON, MYSQL, Data Warehousing, HTML, CSS, JAVA, JavaScript, PHP, PostgreSQL, shell scripting, Microsoft Excel, JSON, XML, Visual Studio.

Tools: SQL DEVELOPER, SQL PLUS, Eclipse, NetBeans, pgAdmin, JIRA, GIT, GITHUB, Jupyter Notebook, ipython

Cloud Computing services: Azure, Office365.

EDUCATION

Bachelor of Engineering - Computer Science (Amrita School of Engineering, Kerala, India)

CERTIFICATION

(January 2020-Present)

POSTGRESQL Certification From UDEMY

SQL Certification From UDEMY

PLSQL Certification From UDEMY

Python Certification from UDEMY

Contact this candidate