SUMMARY

• 7+ years of experience in Information Technology with extensive experience in RDBMS application data warehouse system analysis, ETL Tools with design and implementation of a database with production support activities.
• Expertise in Oracle 12c/11g/10g/9i, developer forms/reports and support experience in UNIX and Windows.
• Experience in working with UNIX environment, AUTOSYS for job scheduling.
• Worked on various stages in SDLC, used waterfall model in majority of projects and ability to work in agile methodology as needed.
• Proficiency in interacting with business analysts and developers to analyze and document the user requirements, functional and system specifications.
• Implemented DBA tasks such as creating roles, users and grants.
• Good hands on experience in creation of database Objects, Tables, Views, Constraints, Indexes, Synonyms and Sequences.
• Proficient in developing PL/SQL Procedures, Functions, Packages, Triggers and materialized views in PL/SQL and apply them to the business logic.
• Conducted Oracle database and SQL code tuning to improve performance of the application.
• Worked on In - line views, Sub-queries and co-related sub queries.
• Strong knowledge on advanced PL/SQL concepts such as records, tables, types, Exception Handling, Dynamic SQL, PL/SQL Collections and also experience in performance tuning using SQL Auto Trace and Explain Plan.
• Worked on Dimensional modeling, Star schema, Snowflake schema, fact, physical and logical Data modeling using Erwin.
• Good understanding of Data modeling concepts like ER Diagrams, UML, Use Cases, Normalization.
• Expertise in Data migration from Flat files/MS Access/SQL Server to Oracle using SQL loader.
• Good experience in using tools like SQL Developer, PL/SQL Developer, SQL Plus, SQL Navigator and TOAD.
• Extensive Knowledge in ETL tools like Informatica, Data stage & OBIEE.
• Knowledge on Data Stage PX for extracting the data from legacy systems to stage and process fetching them back to data marts and data warehouse.
• Used oracle Web logic server to combine the functionality of oracle application server and custom/legacy applications.
• Experience in analyzing Business Requirement Documentation (BRD), Requirement Traceability Matrix (RTM).
• Proficiency in using Clear Case and Clear Quest to handle the version control system and defect tracking
• Involved in Unit Testing and fixing the problem that occurred in UAT (User Acceptance Testing).
• Familiarity in working JAVA framework and front end technologies HTML5, CSS.
• Participated in SCRUM and code review meetings to keep in and know about on-going project.
• Strong Analytical, Inter-personnel, Problem-solving and have the ability to work under pressure.

TECHNICAL SKILLS

Databases: Oracle 12C,11g/10g/9i, MS Access, Microsoft SQL Server(T-SQL)

Operating Systems: Windows 2000/XP,Vista,7, UNIX SAS

Languages: SQL, PL/SQL, C, C++, Java, HTML5, XML, CSS

Scripting Languages: JavaScript, JQuery, HTML, UNIX shell scripting

Technologies: Oracle Forms and Reports 11g/10g, Crystal Reports Erwin, ODI, J2EE (Servlets, JSP, JDBC), AWR,ASH

Utilities: SQL Plus, SQL Loader, SQL Navigator, Toad, Sql Developer, UTL File, DB Visualizer, GIT, Microsoft TFS

ETL tools: Informatica, Ab initio

Packages: Micro Soft Office Suite- MS-Word, MS-Excel, MS-Power point, MS-Visio

PROFESSIONAL EXPERIENCE

Senior Oracle Developer

Confidential, Phoenix, AZ

Responsibilities:

• Created stored procedures and packages for embedding business logic.
• Created tables and database objects such as Views, Indexes, Sequences and Synonyms.
• Used SQL Loaders to load data from excel spreadsheets to database tables.
• Worked on data migration from access to oracle database.
• Created ODBC Connection for internal users to view the data in excel.
• Deployed and worked on SAP Crystal reports for generating the reports based on requests from product owners.
• Used PITTSCONN for identifying the dependent objects in the database and FILEZILLA to compile oracle forms and promote them to server.
• Experience working with job schedulers such as DBMS SCHEDULER.
• Extensively used cursors, ref cursors and collections.
• Worked on oracle forms and created various reports using Oracle Reports Builder.
• Extensively used Oracle forms promotion tool to compile the .fmb files to Server to find respective changes in server.
• Worked on creating additional functionality i.e. toolbars, standard method for displaying error messages, templates for check boxes, radio buttons in oracle forms.
• Extensively used JIRA for updating the story/defect progress.
• Extensive use of Serena PVCS, version managing tool for holding database objects.
• Dedicated to optimize the code written by various developers and worked on performance tuning with optimization techniques in PL/SQL.
• Good knowledge on ETL processing and exposure to reporting tools i.e. Microsoft Power BI and Oracle BI Publisher.
• Developed PL/SQL packages for generating various feeds from oracle database using UTL FILE utility in the client’s secure data transmission server.
• Involved in performance testing of the overall application and tune the SQL Queries and database where needed using Explain plan.
• Widely used PL/SQL tables and Bulk Collect for reducing the I/O and increased the efficiency of storing or retrieval of data.
• Good knowledge on Oracle EBS and Oracle Application Express.
• Design documentation and promotion document to list the database objects in the order of execution, created batch files for promoting to higher environments.
• Ability to replicate the production issues in lower environments and have the data fix or code fix as needed and created the unit test scenarios, design documentation as part of agency’s standard work.
• Regular business meetings with database development team to discuss and leverage the program units for re-usability.
• Ability to coordinate with other developers to discuss on the consolidated script for promoting the database objects to higher environments.
• Extensively used Serena PVCS for version control source code management.
• Discussed the work flow diagrams, use cases and mockups with Business Analysts and Product owners for solid understanding the business requirements.
• Experience working on agile/scrum based development team.

Environment: Oracle 12C, Forms 11G, Reports 10G, ERWIN, SQL Loader, SQL Developer, PL/SQL Developer, SQL Navigator, Serena PVCS, FILE ZILLA, PITTSCON, Windows 7, UNIX Shell Scripts, MS Excel, MS- Visio, VI Editor, HTML, CSS.

Oracle Developer

Confidential, Fort Lauderdale, FL

Responsibilities:

• Created numerous stored procedures and used procedural parameters to work with packages & exception handling.
• Designed and Developed Oracle database Tables, Views, Indexes, Sequences and Synonyms.
• Experience in working with scalar and composite data types.
• Extensively used PL/SQL Packages, Stored procedures, Triggers and tuned them for performance considerations.
• Widely used PL/SQL tables and Bulk Collect for processing the load on tables and retrieving into oracle.
• Developed PL/SQL packages for generating various feeds from oracle database using UTL FILE utility in the client’s secure data transmission server.
• Used SQL Loaders to load data from flat files into database tables.
• Extensively used cursors and ref cursors.
• Dedicated to optimize the code written by various developers and worked on performance tuning with optimization techniques in PL/SQL.
• Worked on creating Materialized Views to maintain database copy of the remote data at local node.
• Good knowledge in JAVA and experience in working with OOPS Concepts.
• Worked on various oracle supplied packages and extensively used UTL FILE, UTL HTTP.
• Experience working with job schedulers such as Cron tab, DBMS SCHEDULER
• Used oracle forms and created various reports using Oracle Reports Builder for day to day validations.
• Experience in working with Microsoft Team Foundation Server for source code maintenance.
• Regular business meetings with development team as well as Java Developers for tuning the SQL statements and embedded in the Java code.
• Involved in performance testing of the overall application and tune the SQL Queries and database where needed using Explain plan.
• Expertise in solving complex queries and improve the performance of application by performance tuning.
• Developed mappings using OWB for data loading. Created Process flow, scheduled & monitored session.
• Implemented ETL processes, Data flows and Data Marts based on business requirement.
• Involved in creating UNIX shell Scripting, Partitioning and Compressing to improve the performance.
• Participated in SCRUM and code review meetings to keep in and know about on-going project.

Environment: Oracle 11g, Forms 9i, Reports 9i, ERWIN, SQL Loader, SQL Developer, PL/SQL Developer, Subversion Windows 7, UNIX Shell Scripts, ETL, OWB, MS Excel, MS- Visio, VI Editor.

Oracle Developer

Confidential

Responsibilities:

• Created well defined stored procedures, functions, packages, collections, triggers & object types.
• Improved Data optimization and manipulation of staged data using PL/SQL packages.
• Proficient in SQL DDL, DML, DCL, TCL & SELECT statements.
• Used UTL FILE to export data and UTL MAIL to generate E-mails.
• Extensively worked with PL/SQL and used collections and Bulk collect to improve the performance of stored procedures.
• Involved in database migration and identified various scenarios during the upgrade for oracle 10g.
• Created various database objects such as tables, indexes, views, materialized views, triggers, sequences & synonyms.
• Extensively worked on complex SQL and PL/SQL queries. Implemented cursors, ref cursors, sub queries, correlated sub queries.
• Developed Test Cases in Unit Testing and System Integration Testing.
• Involved in the creation of index by tables, B-TREE, BITMAP, FUNCTION BASED.
• Created SQL code for generating PRIMARY KEY using Oracle SEQUENCE objects.
• Worked with Erwin for data modeling. Participated in code review meetings with the development team.
• Effectively used Oracle predefined functions such as Single row and multiple row.
• Experience in documenting and archive historical data for future auditing purposes. Responsible for production support and troubleshooting the production issues.

Environment: Oracle Database 9i, Windows XP, TOAD, SQL Loader, JavaScript, Perl scripting, XML, LINUX.

Junior Oracle Developer

Confidential

Responsibilities:

• Analyzed the business requirements of the project by studying the Business Requirement Specification Document.
• Creation of database objects like tables, views, procedures, packages using Oracle utilities like SQL Plus, SQL Loader and Exception handling.
• Timely monitoring of database and system backups, developed Oracle Stored procedures, functions, packages and triggers that pull data for reports.
• Designed the front end interface for the users using oracle Forms, Reports using 8i.
• Involved in database development by creating Oracle PL/SQL Functions, Procedures, Triggers, Packages, Records and Collections.
• Run batch jobs for loading database tables from Flat Files & CSV using SQL Loader, Data mapping.
• Participated in Performance Tuning for query optimization and program performance.
• Created Unix Shell Scripts for automating the execution process.
• Experience in working with other technologies such as COBOL & JAVA environment.
• Worked on Perl scripts to transfer files using FTP to all the UNIX servers at one time.
• Involved in Technical Documentation, Unit testing and integration testing and writing the Test plan.
• Ability to perform joins on various tables and display data from multiple tables.
• Involved in working on Oracle Pseudo columns like ROWID, ROWNUM and SYSDATE & SYSTEM TIMESTAMP.
• Automated Quality Check tasks by creating PL/SQL cursors, functions and dynamic SQL.

Environment: Oracle 9i, SQL Plus, Windows XP, UNIX, HTML, Oracle SQL Developer, Erwin, Oracle Forms 8i, Reports 8i, Informatica, JAVA, MS Access 2000/2002.