Senior Oracle Developer And Data Analyst Resume
Houston, TX
SUMMARY:
- Over 12 years of software development experience in data analysis, database administrator and database development in Oracle 12c, 11g and Oracle 10g - SQL and PL/SQL.
- Over 10 years of expertise in PL/SQL developing packages, stored procedures, functions and triggers, have extensively used collections, dynamic queries, subroutines and cursors.
- Proficient in tools like SQL*Plus, SQL*Loader, SQL Developer, PL/SQL Developer and TOAD.
- 3 years of development and administrator experience in ETL tools like Informatica Power Center, Data Quality and Address Doctor.
- Good understanding of data warehouse concepts, techniques and methodologies.
- 4 Years of experience in scrum/agile projects.
- 1 Year of development experience in Tableau
- 1 year of experience in MS-SQL Server 2000.
- Over 5 years of experience in UNIX Sun Solaris OS and Red Hat Linux.
- Experience in UNIX shell scripting.
- Familiar with ETL Tools like MS SSIS, FME and SAS.
- Development expertise primarily on high volume database refreshing and maintaining activity.
- Currently playing the role of Senior Oracle Developer Lead.
- Datastax certifications on Cassandra Architecture and CQL(No Sql).
- Extensive work experience in complete software development life cycle (SDLC) including business interaction, requirement analysis, software architecture, design, development, testing and documentation phases in finance and legal domain.
- Well versed with client server architecture, web application development on RDBMS.
- Proficient in creating / managing database objects like Tables, Views, Indexes, Synonyms, Procedures, Triggers, Functions, Materialized Views and Sequences.
- Worked extensively on Packages, Stored Procedures, User Defined Functions, Analytical Functions, Exception Handling, Cursor, Reference Cursor, Collections and Dynamic SQL.
- Good experience with oracle built in utilities like EXPLAIN PLAN, SQL trace and TKPROF, SQL*Plus Autotrace and Optimizer hints which are useful in performance tuning.
- Experienced in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to apply business logics and to move data from multiple sources into targets.
- Good knowledge of Unix, Linux, shell scripting and crontab job scheduling.
- Working with the XML files.
- Good Experience in Data Modeling of OLAP and OLTP database.
- Strong Communication, Interpersonal, problem solving, analytical reasoning skills and an Excellent Team Player.
- Expertise in working with distributed project teams across geographies.
TECHNICAL SKILLS:
Databases: Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i, MS-SQL Server 2000
Languages: PL-SQL, No Sql, C, Pro C, C++ and Java
ETL Tools: Informatica Power Center, Informatica DQS, Address Doctor
Platforms: Linux Red Hat, UNIX Sun Solaris, MS-DOS, Windows 98/NT/2000/XP/Vista/7/8
GUI: Visual Source Safe, QVT - Term, TFS, Rally, Jira
Familiar With: Unix shell scripts, HTML, JavaScript, XML
Tools: SQL*Loader, Toad, PL/SQL developer, SQL Developer, NetBeans 5.5, SQL Modular
PROFESSIONAL EXPERIENCE:
Confidential, Houston, TX
Senior Oracle Developer and Data Analyst
Responsibilities:
- Agile methodologies for this project involved in planning, backlog grooming, and daily stand-ups, retrospective and showcase sessions.
- Two weeks iteration (sprint) to complete design, development and testing.
- Closely work with product owner, business analyst and system architect.
- Involved in RDBMS design and developed ER-diagrams. Participated in code walkthroughs and review sessions with the development team.
- Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
- Analyze the communications, informational and programing requirements of clients; planning, developing and designing business programs.
- Interact with business analysts, subject matter experts, front end developer team, Reporting team, DBA team, testing team and developing database related objects for PT-DMS.
- Involve in Logical and physical data modeling and database design.
- Create database standard for the project and code review.
- Manage more than 10 server instances and involved in code and data migration process, Work in different environments like development, test and production.
- Create application’s data access layer with packages, store procedures, functions and triggers.
- Create new tables, integrity constraints (Primary Key/Foreign Key), Indexes, Sequences, Views MVs and Oracle Collections. Created Scheduled jobs with DBMS JOB.
- Carry out SQL code tuning, Query Optimization and database performance tuning, statistics gathering of tables and schema.
- Work with BO and Tableau developer for data analytics.
Environment: Oracle 12c, C#, .Net, UNIX, Rally, Toad, PL/SQL Developer, Informatica PC, SQL*PLUS, SQL Modular, Tableau 10.0, Scrum, XML
Confidential, Denver, CO
Senior Oracle Developer Lead
Responsibilities:
- Agile methodologies for this project, involved in planning, backlog grooming, daily stand-ups and showcase sessions.
- Three weeks iteration (sprint) to complete design, development and testing.
- Closely work with product owner, business analyst and system architect.
- Involved in RDBMS design and developed ER-diagrams. Participated in code walkthroughs and review sessions with the development team.
- Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
- Developed stored procedures, functions, packages triggers to facilitate consistent data entry into the database.
- Written Package and Stored Procedures for common utilities.
- Developed database Triggers for audit and validation purpose. Writing validation packages using PL/SQL package.
- Code Review of other team member and developed Installation scripts for all the deliverables.
- Involved in performance tuning on SQL and Pl/SQL using AUTO TRACE, EXPLAIN PLAN utilities.
- Have performed various testing activities like Unit Testing, Integration-System Testing, Regression Testing, and User Acceptance Testing and ensured that the code is ideal.
Environment: Oracle 11g, Java, UNIX, TFS, Toad, PL/SQL, Informatica PC, SQL*PLUS, SQL Modular, MS-SQL Server 2000, Autosys, Scrum, Jira, Harvest, XML
Confidential, New York City
PL/SQL Developer Lead
Responsibilities:
- Involved in SDLC gathering requirements from product owners. Developed views to facilitate easy interface implementation and enforce security on critical customer information.
- Involved in RDBMS design and developed ER-diagrams. Participated in code walkthroughs and review sessions with the development team.
- Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
- Developed stored procedures, functions, packages triggers to facilitate consistent data entry into the database.
- Written Package and Stored Procedures for common utilities.
- Developed database Triggers for audit and validation purpose. Writing validation packages using PL/SQL package.
- Code Review of other team member and developed Installation scripts for all the deliverables.
- Involved in performance tuning on SQL and Pl/SQL using AUTO TRACE, EXPLAIN PLAN utilities.
- Have performed various testing activities like Unit Testing, Integration-System Testing, Regression Testing, and User Acceptance Testing and ensured that the code is ideal.
Environment: Oracle 11g, Java, UNIX, TFS, Toad, PL/SQL, SQL*PLUS, SQL Modular, MS-SQL Server 2000, Informatica Power Center, Scrum, TFS
Confidential, Houston
PL/SQL Developer Lead
Responsibilities:
- Involved in SDLC gathering requirements from business users. Participated in the system architecture and design, which included creating tables, views, synonyms.
- Responsible to build the Informatica application environments on Linux Red Hat for development, Production Test and Production systems.
- Responsible for Informatica Power Center tool and DQS installation and configuration, Acted as system Administrator for managing services and users.
- Subject Matter Expert for all the 105 databases.
- Created Oracle coding standard and naming conversion document. Code Review of other team member
- Written Stored Procedures using PL/SQL and functions and procedure for common utilities.
- Involved in creating mapping and debugging Informatica Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, lookups, Stored Procedures and creating PL/SQL procedures, functions, Filters, Sequence, Router, Union and Update Strategy.
- Involved in database design and development of Business Object Universe and Standard Reports.
- Involved in production support activities.
- Have performed various testing activities like Unit Testing, Integration-System Testing, Regression Testing, and User Acceptance Testing and ensured that the code is ideal.
Environment: Oracle 11g, Informatica Power Center, Linux, SQL, PL/SQL, SQL*PLUS, SQL Developer, SQL Modular, Informatica Power Center 9.5.1, Informatica DQS, C and Pro C, TFS, Control M
Confidential, Houston
Lead PL/SQL Developer
Responsibilities:
- Involved in SDLC gathering requirements from business users. Participated in the system architecture and design, which included creating tables, views, synonyms.
- Responsible to build the Informatica application environments on Linux Red Hat for development, Production Test and Production systems.
- Responsible for Informatica Power Center tool and DQS installation and configuration, Acted as system Administrator for managing services and users.
- Subject Matter Expert for all the 105 databases.
- Created Oracle coding standard and naming conversion document. Code Review of other team member
- Written Stored Procedures using PL/SQL and functions and procedure for common utilities.
- Performance tuning of PL/SQL code.
- Involved in creating mapping and debugging Informatica Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, lookups, Stored Procedures and creating PL/SQL procedures, functions, Filters, Sequence, Router, Union and Update Strategy.
- Involved in design and development of Business Object Universe and Standard Reports.
- Involved in production support activities.
- Have performed various testing activities like Unit Testing, Integration-System Testing, Regression Testing, and User Acceptance Testing and ensured that the code is ideal.
Environment: Oracle 11g, Informatica Power Center, Linux, SQL, PL/SQL, SQL*PLUS, SQL Developer, Informatica Power Center 9.5.1, Informatica DQS, TFS, Control M
Confidential, Houston
Senior PL/SQL Developer
Responsibilities:
- Involved in SDLC gathering requirements from business users. Participated in the system architecture and design, which included creating tables, views, synonyms.
- Developed stored procedures, functions, packages triggers to facilitate consistent data entry into the database.
- PL/SQL code review and performance tuning.
- C and Java Program coding for reformatting (text and xml files) state data, C and Pro C Programs execution on Sun Solaris UNIX Environment.
- Writing SQL’s (insert, update, delete, create table and functions) pertaining to requirement.
- Writing SQL Loader scripts for loading raw data.
- UNIX Macro creation and execution.
- Verification and validation of uploaded data.
- Test case execution on Live, PT and as well as on Production Data also.
Environment: Sun Solaris, Oracle 10g, SQL*loader, PL/SQL Developer (5.1), Turbo C, VSS, MS DOS
Confidential
PL/SQL Developer
Responsibilities:
- Writing SQL’s (insert, update, delete, create table and functions) pertaining to requirement.
- Writing SQL Loader scripts for loading raw data.
- C Program coding for reformatting state data.
- C and Pro C Programs execution on UNIX Environment.
- Verification and validation of uploaded data.
- Test case execution on live and as well as on Production Data also.
Environment: Oracle 9i, SQL*loader, PL/SQL Developer(5.1), Turbo C, SVN, MS DOS