PROFESSIONAL Summary

A Senior Consultant with years of experience in Information Technology involved in complete SDLC including architecture, analysis, design, development, testing, implementation & maintenance of database applications in the Client/Server and web-based environments. Also, specialized in Data Warehousing design, Data Modeling, Business Intelligence (BI), and Maintenance. Successfully contributed and implemented many large-scale Data Warehouse, Business Intelligence solutions.

PERSONAL Summary

A highly motivated and ambitious individual able to give timely and accurate advice, guidance, support and training to team members and individuals. Possessing excellent communication with leadership qualities and shows dedication, strong commitment, teamwork, planning, monitoring and problem-solving skills. Having the ability to work with the minimum of supervision while leading a team. Having a proven ability to lead by example, consistently hit targets, improves best practices and organizes time efficiently.

TECHNICAL Highlights

Experience with SQL & PL/SQL in constructing all Data Objects like tables, views, indexes, views, synonyms, triggers, materialized views, stored procedures, functions, packages and hands on experience in Exception Handling. Strong knowledge with PL/SQL best practices and adhere to the Pl/SQL coding standards. Modified legacy PL/SQL codes to use the latest features of oracle versions.

Clear understanding of Tuning methodology and experience with Performance Tuning, Normalization, High-Load query re-writes, partitioning of data, Indexing of Partitioned Tables, Bulk Collects, Parallel Hints etc. Experience in application fine-tuning and database fine-tuning using Explain Plan.

Participated in the requirements gathering sessions and interacted with the business users and designed different modules to cater to the requirements. Worked closely with Corporate Interfaces Group to maintain detailed knowledge of the company’s Corporate Data flows. Managing Production, Test and Development environments.

Strong experience with Data Migration and preparing the Source-to-Target mappings, GAP analysis and customize it for each client. Experienced with Oracle utilities like SQL*Loader. Good ability to quickly grasp and implement new concepts and technologies. Extensive experience in working with TOAD and SQL Developer.

Develop procedures to populate and update a separate de-normalized database for reporting purposes from the transaction database. Experienced in Tuning SQL Statements and Procedures using various Optimization techniques.

Strong analytical and problem-solving skills with ability to work within a team environment and independently when needed. Prepared Ad-hoc SQL statements to help the business users in the data analysis phase and to create reports using Business Objects/Crystal Reports. Coordinated and resolved data related issues with other team members such as business analyst, developers, DBAs, and project managers. Participate in code reviews, ensure unit testing and integration testing, and facilitate code delivery.

Experienced in designing and implementing data level security via Oracle’s VPD (Virtual Private Database), TDE (Transparent Data Encryption) by applying Data security Policies. Also, used DBMS_REDACT to mask the sensitive data elements in the application.

Experienced in designing Business Intelligence, Database applications (OLTP/OLAP) and enterprise application integration solutions including Data Modeling, Cross Walk (Data Mapping), and Sample Data Analysis for Data Conversion of data into Oracle database.

Have clear understanding of Business Intelligence and Data Warehousing Concepts with emphasis on ETL and Life Cycle Design & Development Experienced in Training & Supporting end-user reporting needs using OLAP tools. Extensively worked with OLAP tools such as Crystal Reports 2008, Business Objects XI R2/6i/5i (Supervisor, Designer, Business Objects), Web Intelligence 2.6.

Experienced in utilizing SDM tools such as BitBucket to manage source code and Git Hub techniques to upload the scripts for CI/CD process and maintain the code safely/securely.

Good functional knowledge of all business processes, improvement and process re-engineering, mapping to system process design methods, technical architecture solutions. Strong experience in preparing conversion plan and methodologies for Data Extraction, Data Purification, Data Consolidation and Duplication, Pre Data Conversion and Post Data Conversion implication on System. Database design with Erwin data modeling tool.

TECHNICAL Skills

Operating Systems : Unix, Red Hat Linux

RDBMS : Oracle 8i/9i/10g/11g/12c, Ms-Access, SQL Server

Programming Languages : PL/SQL, Shell Scripts, COBOL

ETL Tools : Oracle Warehouse Builder 9i

OLAP : Business Objects XI R2/6i/5i, Crystal Reports 2008, WebI

Markup Languages : HTML, XML

Web Server : Apache, IIS

Design tools : Erwin 7.3.

IDE : TOAD, SQL Developer, SQL Navigator

Other Tools : JIRA, GitHub, BitBucket, Autosys, MS TEAMS, Freshdesk, Tortoise SVN,

PVCS Versioning Management, Footprints bug tracker

EDUCATIONAL Qualification

Master of Business Administration

Master of Science in Technology Management

Bachelor of Science in Computer Science Engineering

CERTIFICATION:

The URL is specific to this credential verification and will expire 5 days after the email send date.

URL: https://catalog-education.oracle.com/pls/web_prod/ocp_interface.certification_authorization?arg_key=OwGCP117624EKMe2588ucPV&p_org_id=1001&p_lang=US

Authorization Code: xk117696XE18K

Contact this candidate