Oracle Sme Resume
Baltimore, MD
SUMMARY:
- Around 10 years of experience in analysis, design, development, testing and implementation as ORACLE PL/SQL DEVELOPER.
- Expert in multiple RDBMS including Oracle 11g/10g/9i/8i/8.x/7.x, Microsoft SQL Server 2000/7.0/6.5 and associated SQL Dialects such as Transact SQL (T - SQL), PL/SQL
- Excellent working and conceptual knowledge of Oracle, PL/SQL, Developing Forms and Reports, C/C++, UNIX Shell Scripting and HTML
- Good knowledge in Software Development Life Cycle (SDLC) that includes requirements gathering, functional and technical specifications, design, development, testing and production deployment.
- Well experienced in developing the DataMart in Star Schema and Snowflake Schema, Flat files and building the Data warehouse, Efficient in developing the Data model, ER Diagrams and organizing the data as per the Business requirements.
- Rich Experience in developing PLSQL Stored Procedures, Functions, Packages, Database Triggers using features like Cursors, Collections, Exception Handling and good in Oracle Forms and Reports.
- Implemented new and advanced Oracle features like Virtual Columns, Unusable Indexes, and Invisible Indexes etc.
- Experienced in encrypting secure data elements using DBMS CRYPTO package.
- Extensively used inbuilt Oracle PL/SQL packages in application development.
- Strong in using tools such as TOAD, SQL*Plus, SQL developer, PL/SQL developer.
- Tuned SQL queries using EXPLAIN PLAN, optimizer Hints and TKPROF utility, Indexes and performed refinement of the database design leading to significant improvement in system response time and efficiency.
- Used bulk binding techniques like BULK-COLLECT and FORALL
- Strong in writing Stored Procedures and SQL queries.
- Experienced in developing batch programs by using PL/SQL and shell scripts and in using Export, Import and SQL*Loader Utilities for loading data from flat files into Oracle tables.
- Experience in working with Forms and Reports for development and customizations as per client specifications.
- Experienced in the development and deployment of Reports for Retail, Healthcare, Financial, Manufacturing, and Software companies. Defined, designed & developed the use of Reports by blending the financial knowledge of the client with the available technical know-how.
- Expertise in creating reports using XML publisher, creating and managing workbooks using Discoverer
- Experience in using oracle long data types like BLOB, CLOB
- Extensive exposure in Pro*C programming with Oracle backend on various flavors of UNIX.
- Experience in writing UNIX shell scripts for automating the daily processes.
- Worked as a part of team in 24x7 production environment and provided on-call and day-to-day support.
- Actively coordinated with Quality Team and User Acceptance Testing.
- Knowledge of job scheduling and using version control tools like VSS, SVN, CVS
- Strong programming and debugging skills in PL/SQL, SQL, C and PRO*C
- Strong skills in objected oriented programming using C++, Java
- Strong Trouble-shooting, Problem solving, Analytical & Design Skills and ability to quickly master new software and adapt to changing needs
- Excellent communication skills and ability to work individually and as a member of a team.
TECHNICAL SKILLS:
Backend: Oracle 11g/10g/9i/8i Database Enterprise Edition, Oracle 10g/9i Application Server
Frontend: Oracle Developer Suite 10g/9i/2000, SQL * Loader, SQL * Plus, FORMS Builder 10g/9i/6i/5.0/4.0, REPORTS Builder 10g/9i/6i/3.0, XML Publisher, Discoverer
Programming: ORACLE PL/SQL 10g/9i/8.0, UNIX K-Shell Scripting, C/C++/PRO*C, JAVA, J2EE, Servlets, Java Script, Visual Basic, COBOL
RDBMS: Oracle 7x/8i/9i/10g/11g, MS Access 2000/2002, MS-SQL Server 2005/ 2000/7.0/6.5
Third Party Tools: PL/SQL Developer, TOAD 8.6/7.5/7.0, SQL Navigator, Putty, Workflows, Erwin, TOAD Data Modeler, Informatica Power Center
Operating System: Windows 98/2000/XP/NT, UNIX (SunOS 5.7, Solaris 8, HP-UX), Red hat Linux 3.0/4/0
Others: XML, HTML, SVN, Microsoft Visual Source Safe (VSS), IBM Rational Clear Case and Clear Quest, Caliber, CVS, Eclipse, Quality Center, Dimensions, Accurev
PROFESSIONAL EXPERIENCE:
Confidential, Baltimore, MD
Oracle SME
Responsibilities:
- Analyzed current technology stack, proposed improvements and suggested markets leading players in Database technologies.
- Developed guidelines for Database installation.
- Developed automated scripts for Database installation to keep all the instances consistent.
- Developed standard templates, response files for RAC, non-RAC, Container, pluggable database installations.
- Closely worked with administration team to automate database installation using Ansible.
- Presented new features of Oracle 12C database, security improvements.
- Developed a proof of concept to mask data while migrating PII data to several non-production databases.
- Developed ETL process to feed data to GreenPlum database for Enterprise Data Warehouse.
- Analyzed and provided different techniques to connect to cloud servers to post and get data.
- Implemented several checks and balances to ensure the data quality during ETL process to EDW environment.
- Streamlined ETL process from db2 redo logs to EDW database.
- Developed data models for in-house applications.
Environment: /Tools: Greenplum, PL/SQL, DB2, TOAD, Oracle Database 11g/12c, Java, SQL Server 2012, MKS, ERWIN datamodeller.
Confidential, Los Angeles, CA
Technical Oracle Lead
Responsibilities:
- Implemented CMC dual membership as pilot program in QNXT
- Built in-house complex rule based algorithms to identify and stratify members with Asthma, Diabetes, Cardiovascular diseases using PLSQL
- Integrated and automated Asthma disease management, Diabetes disease management, Cardiovascular data feed from in-house rule engines to Care Advance(CCA)
- Active member in core system conversion from legacy MHC to QNXT
- Part of installation, configured, and maintained development, test, and production database environments.
- Performed database modeling.
- Products enhancement, maintenance and new feature development of client server applications written in C#.
- Performed database modeling, functional requirements, technical design, system development, user, interviews, testing, and implementation.
- Architect database infrastructure for high availability and high performance.
- Developed database objects such stored procedures, types, etc.
- Performed tuning on application programs and database setting or configuration.
- Project planning and management.
- System integration.
- Data Migration using PL/SQL, TSQL, SSIS, etc.
- Architect a data load process to load about 1TB of data once a month.
- Mentored other DB engineers
Environment: /Tools: PL/SQL, TOAD, Oracle Developer 9i/10g/11g /12C , Oracle Application Express (HTML DB) Developer Suite 10g, Java.
Confidential, Bellevue, WA
PLSQL Lead Developer
Responsibilities:
- Review the business requirement, functional requirement document for various modules so as to have good understanding of the application and capture it into a Confidential (Source System Analysis) document.
- Work with Prepaid and Postpaid application team SMEs and Business team to gather business rules.
- Implement business rules in development cycle.
- Create functional design, technical design documents for downstream data needs and get reviewed, approved by the Business team and Project Manager.
- Implement business rules in development cycle.
- Developed ABC module(Audit Balance Control) - core module in logging and keeping track of job status's, error logging/reporting, record tracking, notifications etc
- Created database objects such as Tables to hold the data and for DML operations, created Views, Synonyms to make the objects accessible to other schema users/objects.
- Created Database links to connect to remote databases and to be able to pull data, perform joins to manipulate the data etc.
- Created Stored Procedures, Packages, and Functions to massage data, validate data and to implement complex business rules.
- Good experience in team management software and also with TFS
- Used advanced Oracle features like Virtual column, Unusable Index, Invisible Index, data encryption using DBMS CRYPTO, objects.
- Used analytical functions like Rank, Row Number, Dense Rank, Listagg, First, Last etc to compute an aggregate value based on a group of rows.
- As the project deals with huge amount of usage data, Partitioned tables to enhance the performance, manageability, availability and eliminate the down time on frequently used usage related tables.
- Validate the data by analyzing and comparing to legacy Microsoft SQL server system PRS (Pre-paid revenue system).
- Developed mappings in Informatica Power Center to load the data from various sources using different transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Joiner, Filter and Router.
- Used EXPLAIN PLAN, DBMS STATS, Analyze, SQL TRACE to tune complex SQL statements and PLSQL objects.
- Interact with QA team member. Developers, Business Analyst in project meetings throughout the course of the project and communicate report and update team about the daily defects and execution statuses.
- Provide required application and environmental knowledge to project team and participate in knowledge transfer during Go-Live activities.
- Plan, facilitate, and participate in working sessions with cross-functional resources.
- Assist in definition, design, and management of Enterprise Architecture components and low-level technical Architecture design documents.
- Identify, evaluate and define impacts of changes, provide alternatives both to the application changing and all upstream and downstream systems, or identify if a change is a manual process taking into account the entire picture as well as the details.
Environment: Oracle 11g , Microsoft SQL Server 2005, Management Studio, SQL, PL/SQL, Unix , Windows 2000 server, TOAD, SQL Navigator, Accurev, SQL LOADER, Informatica Power Center 9.1 , EXPORT, IMPORT.
Confidential, Washington, DC
Data Modeler/Oracle PL/SQL Developer
Responsibilities:
- Analyzed the source forex transaction system and created tables on the target system to capture the source data
- Migrated data from flat files to Oracle database using SQL*Loader
- Developed Oracle PL/SQL programs for backend processing and exception handling
- Developed PL/SQL code to implement business rules using cursors, ref cursors, procedures, functions, and packages
- Developed Master Detail reports in Reports 6i to meet the requirements of end users within the system.
- Developed data entry forms, complex and template forms in Forms 6i.
- Automated the source to target loads using UNIX Schell scripting and CRONTAB
- Involved in performance tuning of SQL queries to decrease the execution time, for that Modified cursors to use hints,
- Modified procedures, functions to use autonomous transactions, for all bulk collect and more exceptions as needed.
- Good experience in team management software and also with TFS
- Used Subversion (SVN) for maintaining current and historical versions of code and documentation
- Used cursor variables to pass query result sets between PL/SQL programs and client application
- Created PL/SQL program units to include DDL statements using Dynamic SQL
- Involved in data mapping and populating database tables using SQL * Loader
- Worked on the autonomous transactions in PL/SQL to log messages from subprograms to log tables.
- Developed reports according to the requirement using Oracle Reports 9i
- Created and managed data base objects such as Tables, Views, Indexes, Sequences, and Synonyms
- Responsible for writing the technical documents and maintaining the documentation
Environment: Oracle 9i, SQL and PL/SQL, Reports 6i, Forms 6i, HP-Unix, SQL * Loader, TOAD, SVN, SQL * Plus
Confidential, Peapack, NJ
Sr. Data Modeler/PLSQL Lead Developer
Responsibilities:
- Involved in Requirement Analysis, System Design, Preparing Functional Specifications, Preparing Design.
- Validating extracted data from Legacy system.
- Developed database objects including tables, clusters, Indexes, views, materialized views, sequences, packages, triggers and procedures to troubleshoot any database problems.
- Created SQL*Loader scripts to load data into the temporary staging tables.
- Created Custom Stored Procedures, Packages and SQL Scripts.
- Partitioned tables with large volumes of data to enhance the performance, manageability, availability and eliminate the down time on frequently used transactional tables.
- Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL procedures.
- Tuned complex Stored Procedures for faster execution and Developed database structures, according to the requirements.
- Worked on Informatica power center tool - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplets and Transformation Developer
- Developed various complex stored procedures, packages, interfaces and triggers in PL/SQL.
- Created various SQL and PL/SQL scripts for verification of the required functionalities.
- Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
- Developed complex SQL queries for data retrieval from various database objects including tables and views.
- Played an important role in performance team in fine-tuning most complex SQL queries using Hints, Indexes etc.
- Worked on various backend Procedures and Functions using PL/SQL.
- Wrote shell scripts to automate the loading, balancing and extraction process.
- Scheduled AUTOSYS for daily execution of interface scripts for data extraction and loading.
- Performance tuning using Explain plan, TkProf and statspack.
- Good experience in team management software and also with TFS
- Executing ftp, telnet for remote access between UNIX systems.
- Extensively involved in UNIX shell scripting for writing Wrapper scripts, SQL Execution scripts in ETL processes
- Managing Version Control Tool CVS for source code migrations.
Environment: Oracle 9i/10g, SQL, PL/SQL, Toad, SQL*Loader, Informatica, UNIX Solaris 5.10, CVS, SQL LOADER, EXPORT, IMPORT
Confidential, Arlington, VA
Sr. Oracle Analyst/ PL/SQL Lead Developer
Responsibilities:
- Involved in SDLC gathering requirements from end users.
- Developed views to facilitate easy interface implementation and enforce security on critical customer information.
- Developed stored procedures and triggers to facilitate consistent data entry into the database.
- Developed user-interface screens for data transactions using Forms 10g.
- Written Stored Procedures using PL/SQL and functions and procedure for common utilities.
- Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
- Created programming code using advanced concepts of Records, Collections, and Dynamic SQL.
- Tuned complex and expensive queries by applying optimizer Hints.
- Developed Database Triggers for audit and validation purpose.
- Used pipelined functions for faster data accessibility.
- Writing validation packages using PL/SQL package using Data Structures.
- Used PL/SQL to validate data and to populate billing tables.
- Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance.
- Developed Installation scripts for all the deliverables.
- Performed functional testing for the procedures and packages.
- Developed Grouping report and matrix reports using oracle Reports 10g report builder.
- Designed and implemented several Reports for invoice, purchase order and inventory accounting using Reports 10g.
- Good experience in team management software and also with TFS.
- Created and manipulated stored procedures, functions, packages and triggers using TOAD.
- Wrote heavy stored procedures using dynamic SQL to populate data into temp tables from fact and dimensional tables for reporting purpose.
- Involved in migrating database from oracle 9i to 10g database.
Environment: Oracle 9i/10g, SQL, PL/SQL, Reports 10g, Forms 10g, Toad, SQL*Loader, SQL Navigator, Caliber, Eclipse, Quality Center, Dimensions, Windows 2000 server.
Confidential, Charlotte, NC
Sr. Oracle PL/SQL Developer
Responsibilities:
- Analyzed data to check for Data Integrity and Referential Integrity when loaded to source-staging tables.
- Created tables to capture errors and data that failed Validation Checks.
- Re-validated corrected data from source and re-processed to get them loaded to the oracle target.
- Re-worked on the BAD Files that were generated by SQL Loader.
- Used SED and AWK in UNIX Shell scripting to correct the data issues in the SQL-Loader data file.
- Responsible to write scripts which identify the legacy data and the valid data.
- Created Database Objects such as Tables, Views, and Synonyms to provide data access to subscribing parties.
- Created/modified various Packages, Stored Procedure & Functions as part of the data validation and cleansing process.
- Pro-actively participated in SQL tuning, Used ANALYZE, DBMS STATS, EXPLAIN PLAN, SQL TRACE and TKPROF.
- Used SQL hints and Indexes as needed to improve SQL performance.
- Designed and Created Database objects and Written PL/SQL PROGRAMMING for data extraction and transformation.
- Wrote UNIX Shell scripts for performing development and DBA activities.
- Tested the ETL process in testing environment and created test cases.
Environment: Oracle 9i/10g, SQL, PL/SQL, Redhat Linux 2.1/3.0, Windows 2000 server, TOAD, SQL LOADER, ETL, EXPORT, IMPORT.