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 teh 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 noledge on developing forms from Scratch designing various components. Worked on Form migration and compilation. Have 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 noledge of teh 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) teh code to higher environment and to maintain in teh repository. Utilized Stash to raise Pull Requests and get teh 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 teh data in teh tables and to update teh tables as per teh 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 teh 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 teh Informatica workflows.
• Designed and developed intranet web applications using Javascript and CSS.
• Analyzed requirements, designed, developed, deployed and documented software components.
• Developed teh shell script, SQL*Loader script, and most of PL/SQL stored procedures, triggers and views to handle teh Online and Batch process.
• Well conversant wif documentation for specifications, developing test cases, technical design and writing manual for end users. Experience in documenting theirportsfor future .
• Bug fixing and enhancing existingreports. Making changes to theirportsdat 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 teh user requirements and participated indatamodeling sessions.
• Created DDL scripts for implementingDataModeling changes. CreatedERWINcrystal reports in HTML, RTF format depending upon teh 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 teh creation and deployment of teh Reportsusing SSRS and configuring teh 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 teh required results.
• Involved in Unit testing of teh 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 teh finalized scope, design functional requirements document and start conversations wif teh technical team.
• Analyze teh 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 teh user interfaceforms using Data Loader.
• Developed various Forms for teh application involving modules to segregate teh 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 teh PLSQL main procedures.
• Code XML blocks, XSL templates dat links teh JavaScript functions dat serve as a connection between teh Middle Tier and teh 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 teh edge cases are covered in teh Test Case Document.
• Perform End to End testing for all teh configurations and different counties to make sure county specific functionalities doesn’t affect baseline functionalities.
• Work closely wif QA team to make sure all teh test scenarios are covered.
• Documenting teh results, outputs and constantly updating teh 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 teh Database and ER Diagrams using Data Modeling Tool like ERWIN.
• Working wif teh ETL Architecture and Functional teams on technical and functional requirements.
• Involved in User Acceptance Testing to ensure accuracy and teh 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 teh Data into teh 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 teh Tuning, Performance, Optimization of Queries and Standardization of teh Code.
• Developed complex SQL queries to perform teh back end testing of teh Oracle database using SQL and UNIX shell commands.
• Implemented Exception Handling extensively for teh ease of debugging and displaying teh error messages in teh application.
• Worked on queries dat take huge amounts of time to run and did performance tuning on it to reduce teh 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 teh data into warehouse database from teh 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 teh temporary staging tables.
• Designed and developed Forms using Oracle Forms 10g to allow teh end users to manage teh customer relation TEMPeffectively and efficiently.
• Worked on creating Materialized Views to maintain copy of teh remote data at local node.
• Mostly involved in code reviewing and Performance Tuning wif optimization techniques in PL/SQL.
• Solving teh complicated run time errors while running teh process along wif DBA team members.
• Involved in teh development of database objects in both OLTP and OLAP databases.
• Addressing day-to-day issues wif business users using tools like TOAD.
• Having good noledge on Claims, Benefits, Provider and Contract affiliations.
• Created documentation for migration and performed extensive testing during teh various phases of product implementation.
• Designed and developed teh logic for handling Slowly Changing Dimension tables load by flagging teh record using update strategy for populating teh desired.
• Developed reusable mappletsand transformations for reusable business calculations.
• Used Exception Handling Logic in all mappings to handle teh null values or rejected rows.
• Tuned teh ETL components to gain teh performance and to avoid business continuity.
• Worked wif Persistent Caches for Conformed Dimensions for teh better performance and faster data load to teh 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 teh performance of teh 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 teh client’s secure data transmission server.
• Developed UNIX scripts for transmitting files from teh secure server to teh customer specified server, using various FTP batch processes.
• Used SQL*Loaders to download teh data into database from teh text files and spread sheets.
• Extracted data from teh XML files transmitted to teh 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 teh generation of User Interface using Oracle Forms by extensively creating Forms as per teh 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 teh 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.