SUMMARY

• Around 7 Years of experience as an Oracle Database Developer wif expertise in Software Development Life Cycle (SDLC) of client implementations including Requirements Gathering, Business Analysis, System Configuration, Design, Development, Testing, Technical Documentation and Support.
• Well versed in developing various database objects including Packages, Stored Procedures, Functions, Triggers, Tables, Indexes, Constraints, Materialized Views and others in Oracle 19c/12c/11g/10g database.
• Proficient in loading data from flat files into database tables using SQL*Loader scripts.
• Worked wif Arrays, Records, Dynamic SQL and Exception Handling.
• Involved in Performance Tuning which included creating indexes, partitioning tables, providing Hints, modifying tables using Explain Plan, sql trace and TKPROF.
• Worked wif tools like PL/SQL Developer, SQL Developer, SQL*Loader, TOAD, SQL plus.
• Efficient in creating Test cases and performed data validation and process testing for application moving into production. Supported Systems Integration Testing, Performance Testing and UAT as needed.
• Worked on automating data loading, extraction, reports generation. Extensively worked on UNIX Shell and PERL scripting.
• Knowledge of standard data modeling patterns and practices, e.g. 3NF, dimensional models, and the ability to produce logical and physical models using MS Visio and ERWIN toolkit.
• Experience working in Agile Scrummodel and Waterfall model life cycles.
• Good experience fine tuning queries, procedures and data load processes for better performance
• Proficient on developing Reports using various tools like Oracle Reports Builder 10g/11g/12c, OBIEE 10g, BIP, SAS Reporting, MARS application.
• Excellent knowledge on developing forms from Scratch designing various components. Worked on Form migration and compilation. Has hands on experience upgrading Forms from 10g to 11g.
• Strong communication skills and experience working wif business analysis, development, testing, implementation and support teams.
• Strong knowledge of the principals of Data Warehousing, Fact Tables, Dimension Tables, and Star and Snowflake schema modeling
• Good experience in report creation using SQL Server Reporting Services (SSRS) and Crystal Reporting
• Well versed in utilizing JIRA as Ticketing Tool. GIT Hub, Source Tree for Promoting (Check - in) the code to higher environment and to maintain in the repository. Utilized Stash to raise Pull Requests and get the Co developer’s approvals and Confluence for meeting notes.
• Working Experience in Data Extraction, Transmission and Loading (ETL) utilizing Oracle utilities like SQL Loader, UTL FILE, Export Import, Bulk Processing, External Tables and others.
• Proficient on ETL processing using Informatica and ELT using ODI. Worked on building mapping, transformation, Integration and presentation layers.
• Good understanding of Data modeling concepts like ER Diagrams, UML, Use Cases, Normalization and De-normalization of Tables.
• Knowledge of Principals of Data Warehouse using Fact Tables, Dimension Tables and Star/Snowflake schema modeling.
• Excellent intrapersonal and communication skills and proficient in implementing project in Agile/SCRUM methodology
• Highly organized and efficient to prioritize and manage multiple tasks. An excellent quick learner and a person wif detail-oriented mentality and problem-solving skills.
• Proven ability to work efficiently in both independent and team-work environments. Ability to meet deadlines and handle pressure in coordinating multiple tasks in a project environment.

TECHNICAL SKILLS

Databases: Oracle Database 10g/11g/12c/19c, SQL Server 2005/2007

Languages: SQL, PL/SQL, Pro*C, JAVA, XML, UNIX Shell Scripting, Perl Scripting

UI/Reporting Tools: Forms 6i/10g/11g/12c, Reports 6i10g/11g/12c, OBIEE, SAS, BI Publisher

Oracle Utilities: SQL*LOADER, Export/Import, UTL FILE, DBMS Packages, DB Links, etc.Scheduler Tools CONTROL M, AUTOSYS, CRONTAB, EMACS, DBMS SCHEDULER

Development Tools: TOAD, SQL*DEVELOPER, SQL Navigator, PUTTY, SSH, WINSCP3, FILEZILLA, PLSQL Developer, SQL*Navigator

Web Technologies: HTML, Apache, Microsoft Internet Information Server (IIS), VBScript, Java Script, CSS, DHTML, XML

Development Methodology: AGILE, SCRUM, HYBRID, WATERFALL, Test Driven, SDLC, OAIM

Ticketing Systems: JIRA, HP Service Center, Service Desk, ITSM

Operating Systems: Windows Family, MS-DOS, Oracle LINUX 6, AIX, UNIX, SUN Solaris

PROFESSIONAL EXPERIENCE:

Confidential, NYC, NY

Senior Oracle Database Developer

Responsibilities:

• Worked in complete Software Development Life Cycle (SDLC), starting from requirement gathering, analysis, design, testing, debugging, implementation, post implementation support and maintenance.
• Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the requirements.
• Involved in Performance Tuning at various levels including Target, Source, Mapping, and Session for large data files.
• Worked on Logical and physical modeling as well as Maintaining SQL Script for creation of database Objects and generating scripts using Erwin tool.
• Involved in Unit testing of the Reports, Forms andPL/SQLStored procedures.
• Worked extensively in Informatica, Teradata, Oracle 12c, Unix Shell Scripting, SQL and PL/SQL wif strong implementation on performance management.
• Created various jobs in Control-M to run the Informatica workflows.
• Designed and developed intranet web applications using Javascript and CSS.
• Analyzed requirements, designed, developed, deployed and documented software components.
• Developed the shell script, SQL*Loader script, and most of PL/SQL stored procedures, triggers and views to handle the Online and Batch process.
• Well conversant wif documentation for specifications, developing test cases, technical design and writing manual for end users. Experience in documenting thereportsfor future .
• Bug fixing and enhancing existingreports. Making changes to thereportsdat are created in earlier versions to Crystalreports.
• Designed and Developed complex Reports to meet end user requirements and deployed using Oracle Report 12c.
• Designed and Developed complex Reports to meet end user requirements and deployed using Oracle Report 12c.
• Interacted wif Business Analysts to gather the user requirements and participated indatamodeling sessions.
• Created DDL scripts for implementingDataModeling changes. CreatedERWINcrystal reports in HTML, RTF format depending upon the requirement, PublishedDatamodel in model mart, created naming convention files, coordinated wif DBAs to apply thedatamodel changes.
• Wrote complex Stored Proceduresand triggers to capture updated and deleted data from OLTP systems.
• Involved in the creation and deployment of the Reportsusing SSRS and configuring the SQL Server Reporting Server.
• Oracle Backend Development involving creation and maintenance of PL/SQL Functions, Procedure, Triggers, Packages, PL/SQL Tables.
• Performed unit testing, system integration testing and assisted during user acceptance testing (UAT) onETL packages and reports.
• Extensively worked on performance tuning and optimization ofdataware housing, business intelligence and database jobs.
• DevelopedStoredProcedures, Triggers, Indexes, User defined Functions, Constraints etc on various database objects to obtain the required results.
• Involved in Unit testing of the Reports, Forms andPL/SQLStored procedures.

Environment: Oracle Database 12c/19c, Windows 7, UNIX, SQL Developer, XML, SQL, PLSQL, UNIX Scripting, Putty.

Confidential, Dayton, Ohio

PL/SQL Developer

Responsibilities:

• Interact wif different stakeholders to understand project requirements and convert functional specifications into technical designs.
• Based on the finalized scope, design functional requirements document and start conversations wif the technical team.
• Analyze the requirements and build conceptual, logical and physical Database models accordingly.
• Post analysis - prepare mapping documents, mockup outputs and pseudo code (based on requirement) at high level.
• Create/modify visual flow diagram dat demonstrates technical process flow.
• Develop Oracle Reports using Oracle Reports Builder and integrate wif PLSQL packages, procedures in back end.
• Loading of data fromflat files into the user interfaceforms using Data Loader.
• Developed various Forms for the application involving modules to segregate the data.
• Create database tables, views, triggers, PLSQL Stored Procedures, Functions and Cursors in adherence to Oracle AIM standards. Update Triggers, Dev DB scripts, Views and debug the PLSQL main procedures.
• Code XML blocks, XSL templates dat links the JavaScript functions dat serve as a connection between the Middle Tier and the Application Tier.
• Read and Write data from/to CSV file using standard UTL FILE and FND FILE PLSQL Packages.
• Create Customized reports and functional blocks such as format triggers, report triggers,paper parameter form, paper and web layout dat incorporates aggregate columns (PLSQL Formula columns, Summary Columns) and Place holder columns for tax reports, Hearing notice reports, Letter reports, Extract reports, CSV reports using dynamic SQL on Oracle Reports Builder and integrate RDF wif SQL programs using host commands.
• Perform unit testing and prepare unit test case document. Making sure all the edge cases are covered in the Test Case Document.
• Perform End to End testing for all the configurations and different counties to make sure county specific functionalities doesn’t effect baseline functionalities.
• Work closely wif QA team to make sure all the test scenarios are covered.
• Documenting the results, outputs and constantly updating the backlog using TFS on Visual Studio.

Environment: Oracle Database 12c/19c, SQL Server 2016, SQL, PL/SQL, PLSQL Developer, Visual Studio, SQL*Loader, UNIX Shell Scripting, MS Visio, Oracle Reports Builder 12c, Oracle Forms Builder 12c, Control M, UNIX, PERL, JAVA, JSON, XML

Confidential, Jersey City, NJ

PL/SQL Developer

Responsibilities:

• As a Senior Oracle Developer, worked on multiple production applications independently and as part of a team using Agile Methodologies.
• Designed and Developed complex Reports to meet end user requirements and deployed using Oracle Report 12c.
• Oracle Backend Development involving creation and maintenance of PL/SQL Functions, Procedure, Triggers, Packages, PL/SQL Tables.
• Extensive Experience in Relational and Dimensional Data Modeling for creating Logical and Physical Design of the Database and ER Diagrams using Data Modeling Tool like ERWIN.
• Working wif the ETL Architecture and Functional teams on technical and functional requirements.
• Involved in User Acceptance Testing to ensure accuracy and the quality of data. User acceptance testing involved ETL/Data warehouse Testing of Data Mart, Database testing of source applications.
• Written Stored Procedure to fetch and insert complex data to flat tables which is sent to downstream systems.
• Wrote Stored Procedures for TEMPeffective Insertion and Updating of the Data into the Tables. Sub-Queries and Joins were extensively used in Stored Procedures.
• Created View, Tables, Packages, Procedures and Functions.
• Wrote Stored Procedures/Functions/Packages in various schemas as per business requirements and was involved wif the Tuning, Performance, Optimization of Queries and Standardization of the Code.
• Developed complex SQL queries to perform the back end testing of the Oracle database using SQL and UNIX shell commands.
• Implemented Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Worked on queries dat take huge amounts of time to run and did performance tuning on it to reduce the cost and time to execute.
• Experience in Data warehousing, Data Architecture & Extraction, Transformation and loading (ETL) data from various sources into Data Warehouse and Data Marts using Informatica Power Center.

Environment: Oracle Database 11g/12c, SQL, PLSQL, SQL Developer, PL/SQL Developer, UNIX, SQL Loader, Oracle Forms 12c, Oracle Reports 12c, HTML, XML.

Confidential

Oracle Database Developer

Responsibilities:

• Used SQL*Loader to download the data into warehouse database from the flat files and other data files across different platforms.
• Developed SQL and Shell scripts to create temporary tables and developed SQL*Loader scripts to load data into the temporary staging tables.
• Designed and developed Forms using Oracle Forms 10g to allow the end users to manage the customer relation TEMPeffectively and efficiently.
• Worked on creating Materialized Views to maintain copy of the remote data at local node.
• Mostly involved in code reviewing and Performance Tuning wif optimization techniques in PL/SQL.
• Solving the complicated run time errors while running the process along wif DBA team members.
• Involved in the development of database objects in both OLTP and OLAP databases.
• Addressing day-to-day issues wif business users using tools like TOAD.
• Having good knowledge on Claims, Benefits, Provider and Contract affiliations.
• Created documentation for migration and performed extensive testing during the various phases of product implementation.
• Designed and developed the logic for handling Slowly Changing Dimension tables load by flagging the record using update strategy for populating the desired.
• Developed reusable mappletsand transformations for reusable business calculations.
• Used Exception Handling Logic in all mappings to handle the null values or rejected rows.
• Tuned the ETL components to gain the performance and to avoid business continuity.
• Worked wif Persistent Caches for Conformed Dimensions for the better performance and faster data load to the Data Warehouse.
• Involved in performance tuning and optimization of Informatica Mappings and Sessions using partitions and data/index cache to manage very large volume of data.
• Performed query overrides in Lookup Transformation as and when required to improve the performance of the Mappings.
• Used Clear case for version controlling and Clear Quest for ticketing system.

Environment: Oracle Database 10g, Oracle APEX 3.2, Windows XP, UNIX, SQL Loader, TOAD, Oracle Forms 10g, Oracle Reports 10g, XML, SQL, PLSQL, Informatica Power Center 8.1

Confidential

Software Developer - Database

Responsibilities:

• Created heavy stored procedures for financial transaction by using Procedural parameters &worked wif Packages, blocks &Exception Handling.
• Designed and Developed Oracle database Tables, Views, Indexes, and Synonyms wif proper privileges.
• Developed PL/SQL Packages for generating various feeds from oracle database using UTL FILE utility in the client’s secure data transmission server.
• Developed UNIX scripts for transmitting files from the secure server to the customer specified server, using various FTP batch processes.
• Used SQL*Loaders to download the data into database from the text files and spread sheets.
• Extracted data from the XML files transmitted to the bank and loaded them efficiently into oracle temp tables for day to day customer financial transaction reconciliation.
• Designed and implemented client-server application using Oracle Forms 10g.
• Involved in the generation of User Interface using Oracle Forms by extensively creating Forms as per the client requirements.
• Developed various new Reports from Scratch utilizing Oracle Reports 10g for day to day validations.
• Developed ETL mappings, transformations using Informatica Power Center 8.1.
• Created various adhoc reports as of when required for the production analysis and bug fixing.
• Converted reports to browser supportable XML format.
• Extensively utilized TOAD for Performance Tuning by generating explain Plans.

Environment: Oracle Database 10g, UNIX, Windows XP, SQL * Loader, TOAD, SQL Navigator, Oracle Reports 10g, Oracle Forms 10g, Discoverer 10g, PL/SQL, UNIX, Perl, XML.