We provide IT Staff Augmentation Services!

Senior Oracle Database Developer Resume

Bloomington, IL

SUMMARY

  • Over all 15 years of IT experience in Energy, Finance, Insurance, Automotive and Life sciences projects
  • 5 years of experience in Data modeling on relational database with good understanding of data warehouse environment
  • Excellent knowledge about data modeling, architecture, ETL architecture and design, logical and physical data modeling
  • 12 years of experience in Studying, documenting, designing, developing, Testing, support and customization of enterprise software applications
  • 10 years of experience in design, development, implementation and support as database and ETL developer using Informatica, Oracle Data Integrator and Oracle Tools
  • Experience in developing ETL mappings to support data extraction, transformation and load using Informatica PowerCenter and Oracle Data Integrator
  • Experience in Oracle RDBMS, Oracle 8i/9i/10g, SQL, PL/SQL, XML, Java, HTML and Workflow
  • Proficient in Oracle Tools and Utilities for ETL such as TOAD, SQL*Loader and UTL FILE
  • Proficient in writing Procedures, Packages, Functions, Triggers and other database objects using SQL & PL/SQL
  • Experience in UNIX Shell Scripting and job scheduling using Cron, Autosys and DBMS JOBS
  • Experience in implementing data access security using Virtual Private Database (VPD)
  • Experience in writing and tuning of complex SQL statements, complex joins and sub - queries
  • Exposure in implementing Oracle Advanced Queuing for scheduling Oracle jobs
  • Developed ETL mappings to load flat file data into staging tables
  • Strong in test data preparation using SQL and PL/SQL to support User Acceptance Testing
  • Exposure to Master Data Management methodology and strategies
  • Extensive experience in designing and implementing reports in Crystal Reports
  • Excellent team player good communication skills
  • Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment
  • Highly motivated self-learner with ability to develop proficiency and adapt to new technologies and methods in a short period of time

TECHNICAL SKILLS

Databases: Oracle 11g/10g/9i/8i/7.3

System Development: Data Architecture, Data Modeling, ETL Architecture, ETL Design, and Application Design with full life cycle and using. Thorough understanding of SDLC

ETL Tools: Oracle Data Integrator (ODI), Informatica PowerCenter.

Reporting Tool: Crystal Report 8.5

Other Tools: ERwin, Putty, SQL*Plus, SQL*Loader, MS Visio, MS Project, ClearQuest, ClearCase, Autosys, TOAD, PL/SQL Developer, STG ICD, STG ICM

OS: Windows XP/2000/NT/98/95, UNIX (HP-UX, AIX), MS DOS.

Programming: Visual Basic, SQL, PL/SQL, UNIX Shell Scripting, Perl, HTML, XML, Java.

PROFESSIONAL EXPERIENCE

Confidential

Senior Oracle Database Developer

Responsibilities:

  • Lead data conversion design of STG Billing data conversion component
  • Build conversion programs and integration interfaces in Oracle PL/SQL.
  • Create and enforce database development standards
  • Support pre-sales team with customer’s data assessment including defining integration strategies.

Environment: Oracle 11g, SQL, PL/SQL, Virtual Private Database, TOAD, PL/SQL Developer

Confidential

Senior Oracle Database Consultant

Responsibilities:

  • Implement data access security using Oracle’s Virtual Private Database
  • Design database applications such as interfaces and data transfer mechanisms in Oracle PL/SQL
  • Design, develop and test software solutions in Oracle database
  • Provide technical documentation, including design and solution documents
  • Partner with Architecture, Analysis and QA teams during end to end project lifecycle
  • Design ETL process to support integration of broker data
  • Troubleshoot and investigate issues in support of third line production support
  • Data research and understanding of the underlying data that supports the products
  • Facilitate code reviews
  • Coordinate production installation of software

Environment: Oracle 11g, SQL, PL/SQL, Virtual Private Database, TOAD, PL/SQL Developer

Confidential, Bloomington, IL

Data Conversion Specialist

Responsibilities:

  • Lead the data architecture and design of underlying technical components of the project
  • Responsible for data archival, data security / encryption, data migration, data cleansing.
  • Create and enforce database development standards
  • Design database applications such as interfaces and data transfer mechanisms
  • Design databases to support business applications, ensuring system scalability, security, performance and reliability.

Environment: Oracle 11g, SQL, PL/SQL, STG Billing Product, Java 1.7, STG’s ICD and ICM toolkit.

Confidential, Richfield, OH

Sr. DataBase Consultant/Architect

Responsibilities:

  • Work with data architects for a proof of concept for string aggregation.
  • Involved in proof of concept for the new publishing process. These involve analyzing existing publishing process and create the reverse engineering documents.
  • Analyze load scripts built in Unix and PL/SQL.
  • Work with Architects to build the new Data Model using Erwin.
  • Build interfaces in Oracle Data Integrator (ODI) to load flat files into Oracle tables.
  • Use Snap On specific Knowledge Modules in the interfaces.
  • Integrate ODI interfaces and procedures in packages. Build run time scenarios.
  • Monitor ETL executions in the ODI operator.
  • Generate data load statistics for the leadership team.

Environment: Oracle 11g, SQL, PL/SQL, Oracle Data Integrator (ODI), Unix.

Confidential, Orlando, FL

Sr.System Analyst

Responsibilities:

  • Maintenance and support of Siemens Global database called PLM. This is an OLTP database with all the business logic built within the PL/SQL code.
  • Lead the data migration effort from the legacy system (AS400) to the PLM database (in Oracle). Work with the client on the conversion design blue prints.
  • Develop SQL*Loader scripts and PL/SQL packages for loading data into the warehouse.
  • Work with the project stakeholders for data mapping and data cleansing effort.
  • Worked with the Global Data Architect in the Master Data Management (MDM) effort in identifying and planning the maintenance of the master data. Assisted the Global Data Architect to draft master data strategies.
  • Build interfaces in PL/SQL to process data received from SAP XI.
  • Enhance and maintain the PL/SQL code that houses the business logic of the application.
  • Extensively used collections and Object types in the PL/SQL code.
  • Support an application built on Visual Basic 6.0 for minor bug fixes and enhancements.
  • Implemented Oracle Advanced Queuing for job scheduling and maintaining the denormalized tables used for reporting.
  • Built an error logging framework in PL/SQL using object types and autonomous transactions.
  • Directly work with business users for ad hoc data extracts.
  • Analyze long running queries and optimize the queries.
  • Performed Unit Testing and User Acceptance Testing.
  • Worked closely with the project and program management, provided detailed status reports on current status of the project. Provided overview on what was accomplished and what’s remaining in terms of deliverables for every week.

Environment: Oracle 10g, SQL, PL/SQL, Visual Basic, XML, PL/SQL Developer, ERwin 7.2.

Confidential, Minneapolis, MN

Senior System Analyst

Responsibilities:

  • Maintenance and support the clients Eligibility system built in VC++ and Oracle as backend.
  • Support the ETL interfaces built in PL/SQL, extensive usage of bulk data operation and dynamic SQL.
  • Coordinate with business analysts for enhancements to existing application.
  • Design and built ETL mappings, transformations and mapplets using Informatica designer to migrate data using Informatica designer into Optum’s Data Warehouse
  • Support the Data Warehouse team to map and extract data from source systems to target data stores, validate data loaded into the data stores, troubleshoot technical issues and support partners through the data cleansing process.
  • Optimizing the mapping to load the data in slowly changing dimension
  • Help the reporting teams to write complex SQL queries and build PL/SQL code for complex reporting requirements.
  • Analysis of the client Eligibility system and proposed new solution involving Oracle Database and a Java as front end. Provide technical leadership for the new solution.
  • Develop PL/SQL packages for the new Eligibility system
  • Lead design and code walk through sessions.
  • Partner with release management team to install code in test and production environment
  • Analyzed tables and indexes for performance tuning.
  • Optimized Query performance using Explain plan, SQL Trace and TKPROF utility.

Environment: Oracle 9i, SQL, PL/SQL, XML, TOAD, ERwin 6, Informatica PowerCenter 7.1.

Confidential

Data Architect

Responsibilities:

  • Application design to convert data from old application to the new application.
  • Work with the client on the conversion design blue prints.
  • Conversion procedures and mappings to list the data conversion requirements.
  • Designing the staging area of the legacy database using ERwin
  • Writing control scripts for SQL*Loader to load the legacy data.
  • Developed PL/SQL packages.
  • Extensively used XML in PL/SQL programs.
  • Interacting and supporting the onsite team.
  • Design the new customized data model in ERwin3.2.
  • Optimization of the SQL queries used in various application search functionality.
  • Worked with the DBA to build Perl scripts for data cleansing and scheduling migration scripts.
  • Maintain the drug dictionary in Oracle TMS. Sync the dictionary with the drug names used in the Custom data model. Maintain the mapping between the two systems.
  • Assist the DBA in creating database and prepare database deployment scripts.
  • Leading a team of PL/SQL developers, Business Objects developers and data modelers a total of 9 developers.
  • Manage Client expectations.
  • Project Planning, for the work stream I was responsible for.
  • Track, Update and Consolidate project plan.
  • Manage workload of the team.
  • Report status to Service manager
  • Track completion of project deliverables.

Environment: Oracle 9i, SQL, PL/SQL, XML, TOAD, Unix Shell Script, Perl

Confidential

Senior Programmer Analyst

Responsibilities:

  • Developed PL/SQL stored procedures
  • Extensively used XML in PL/SQL programs.
  • Writing views and PL/SQL procedures for reports.
  • Developed interface that integrates front office and back office operations in PL/SQL.
  • Involved in writing triggers for online compliance checks as per SEBI guidelines that uses dynamic SQL and bind variables stored in database tables.
  • Design and develop reports in Crystal Report.
  • Runtime reports development using Crystal Report designer component.
  • Preparation of Detailed Design documents which includes data flow diagrams in Visio2000.
  • Unit testing, preparation of test cases and peer reviews documents.
  • Integration of the reports in the application.
  • Implementation of the system at Client site.
  • Releasing of the modules and maintaining the release site of the application.
  • Maintenance and support of database & application server at client site.
  • Onsite support of the system at various client sites

Environment: Oracle 8i, SQL, PL/SQL, Crystal Report, Visual Basic.

Confidential

Senior Programmer Analyst

Responsibilities:

  • Writing views and pl/sql procedures for reports.
  • Writing PL/SQL stored procedures using XML.
  • Design and develop reports in Crystal Report.
  • Involved in designing a report scheduler in ASP, JavaScript and Crystal Reports
  • Designed reports that uses XML file.
  • Runtime reports development using Crystal Report designer component.
  • Involved in designing the row locking mechanism, which locks the transaction for a given session id and for specified time. The logic is built in back end.
  • Unit testing, preparation of test cases and peer reviews documents.
  • Integration of the reports in the application.
  • Online support to the on-site team.
  • Releasing of the modules and maintaining the release site of the application

Environment: Oracle 8i, SQL, PL/SQL, XML, ASP, JavaScript, Crystal Report.

Confidential

Programmer Analyst

Responsibilities:

  • Prepared detailed program specification for the sales module.
  • Worked extensively on Crystal reports.
  • Involved in writing PL/SQL programs.
  • Interacted with client for enhancements and changes.
  • Testing Unit Test Case.

Environment: Oracle 8i, SQL, PL/SQL, Crystal Report.

Hire Now