SUMMARY

• Over 7 years of programming experience as anOracle PL/SQLDeveloper in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Extensively involved in developing Web Applications using Java, Java Applets, EJB, JSP, Servlets, MQ, Java Beans, HTML, Struts, SGML, XML, multithreading, JDBC and Java Scripts.
• Experience in implementing SOA solutions for Health Insurance Exchanges and Medicaid Integrated Eligibility systems which includes integration with OPA, Siebel, Federal Data Services HUB and Carriers.
• Oracle MDM implementation experience in Oracle Product Hub (PDH), Customer Hub (CDH), Supplier Hub (SDH) and Site Hub involving Data Governance, ETL and Data Quality processes.
• Experience in data quality tools (Oracle EDQ and EDQP) integrating with Oracle MDM applications.
• Involved in all phases of theSDLC (Software Development Life Cycle)from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines. Expertise in creating databases, users, tables, triggers, macros, views, stored procedures, functions, Packages, joins and hash indexes in Teradata database.
• Proficient in working with various technologies like ATG Dynamo, Commerce, CSC, Core Java, Java Beans, JSF, J2EE (JSP, Servlets, EJB3), Struts2, Spring, Hibernate, Ajax, JMS, JDBC, XML, Web Services and Design Patterns.
• Experience in working with various CDC tools likeOracle Golden Gate, StreamSetsandStriim.
• Worked on agile and test driven environment, participated on daily scrum meetings, discussions and finalize road blocks.
• Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
• Experience with executing conversion in mock environments for practice runs.
• Working as Principle Consultant mentoring junior dba's, took initiatives on new projects writing scripts, APEX and reviewing changes, Cloud Infrastructure, Cloud PaaS and SaaS Support.
• Experienced in Procure to Pay, Order to Cash, operations and Operations and Record to Report - GL, AP, AR, CM, iExpense, SLA, PO, OM, INV, SLA, OPM etc.
• Hands on experience using query tools like TOAD, SQL Developer, PLSQL developer, Teradata SQL Assistant and Query man. And on experience using query tools like TOAD, SQL Developer, PLSQL developer, Teradata SQL Assistant and Query man.
• Developed test-driven developmentTDDstrategy guiding use of the Nunit unit testing framework.
• Had experience of working on MDM (Master Data management) TCA, Customer Data Hub, Customer Data Integration (CDI) using Trillium and Dun & Bradstreet.
• Developing Technical documents & Unit test Documents.
• Extensive experience with T-SQL in constructing Triggers, Tables, implementing stored Procedures, Functions, Views, User Profiles, Data Dictionaries and Data Integrity.
• Experience withData flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modelinganddesign techniques.
• Analyze Korn Unix shell scripts on platforms.
• Expertise in Client-Server application development using Oracle12c/11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOADandSQL*LOADER.
• Expertise in implementing MDM-CDH, PIM/PLM integrating with financial systems and global order management systems.
• Extensive experience in performance tuning, stabilizing and handling distressed clients dealing with SLA issues, platform instability issues and scalability issues.
• Understanding ofTest Driven Development(TDD).
• Worked on designing and developing the Real - Time Time Tax Computation Engine usingOracle, StreamSets, Kafka, Spark Structured StreamingandMemSql.
• Identify, present and deliver innovative and creative Product solutions. Possess excellent organizational skills, pay attention to details, and understand the needs of the customer and the Products. Vast knowledge of Healthcare domain including different EHR systems, LIS, Pharmacy, Claims, Eligibility, EDI X12, HL7 and Integration. Worked on different Healthcare programs in both institutional and community setup and on different service authorization and eligibility systems. Implemented EDI Healthcare transaction Interface with Managed Care Organizations MCO's
• Actively participated in HL7 working group activities and implemented the MITA Medicaid Eligibility Architecture based on HL7 v3. Played an instrumental role in successful.
• Involved in support during various testing phases of the project as Unit Testing, Functionality Testing, System Integration Testing and regression testing. Supporting in Go-Live activities in various releases of the PPG engagement.
• Oracle Meter Data Management: Extensive hands-on experience on MDM OOB modules as well as Lodestar modules like Rate Schedule, LTMH Adapters, and Web Services etc.
• Effectively made use ofTable Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-WriteandTransportable table spaces.
• Worked as an SME/Data Analyst for MDM/Oracle Apps Customer Master 11i/R12 to EDW (Enterprise Data Warehouse) data extraction & ETL.
• Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions.
• Strong experience inData warehouse concepts, ETL.
• Good knowledge on logical and physicalData Modelingusingnormalizing Techniques.
• CreatedTables, Views, Constraints, Index(B Tree, Bitmap and Function Based).
• Developed Complex database objects likeStored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Involved in ingestion, transformation, manipulation and computation of data usingStreamSets, Kafka, Memsql, Spark.
• Wrote Unix Shell Scripts for Data loading and DDL Scripts.
• Developedmaterialized viewsfor data replication in distributed environments.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling forOLTPand dimension modeling forOLAP.
• Experience in software development using agile and test driven methodologies.
• Tested Service and data access tier usingJUnitinTDDmethodology.
• Experience inOracle supplied packages, Dynamic SQL, RecordsandPL/SQL Tables.
• Loaded Data into Oracle Tables usingSQL Loader.
• Partitioned large Tables usingrange partition technique.
• Experience with Oracle Supplied Packages such asDBMS SQL, DBMS JOBandUTL FILE.
• CreatedPackagesandProceduresto automatically drop table indexes and create indexes for the tables.
• Worked extensively onRef Cursor, External TablesandCollections.
• Developing Technical documents (MD 70) & Unit test results (UTR) Documents.
• Expertise inDynamic SQL, CollectionsandException handling.
• Handled performance teams and performance efforts to achieve mission critical SLA's successfully.
• Experience in SQLperformance tuningusing Cost-Based Optimization (CBO).
• Good knowledge of key Oracle performance related features such asQuery Optimizer, Execution PlansandIndexes.
• Experience withPerformance Tuningfor Oracle RDBMS usingExplain PlanandHINTS.
• Experience inETLtechniques and Analysis and Reporting including hands on experience with the Reporting tools such asCognos.
• CreatedShell Scriptsfor invoking SQL scripts and scheduled them using crontab.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

TECHNICAL SKILLS

Databases: Oracle 7.x/8i/9i/10g/11g/12c (SQL, PL/SQL, Stored Procedures, Triggers), MS SQL SERVER 2000/2005/2008 , DB2/UDB, Teradata, SAP Tables and MS Access.

ETL Tools: Informatica (PowerCenter 5.1/6.2/7.1/8.6.1/9.1.0 , PowerMart 5.1, Power Connect/Power Exchange for SAP R/3, MainFrame and Oracle Change Data Capture (CDC), AB Initio 1.8 and SQL*Loader.

Reporting Tools: Business ObjectsDeveloper Suite 5.1/BO XIR2, Cognos Suite, Cognos Report Net 1.1MR2, Crystal Reports, Oracle Reports 2.5

Data Modeling: AutoSys, Control-M, PVCS, WIN CVS, Informatica Data Quality, B2B Data Transformation, Informatica Power Exchange Informatica 9.1.0 Developer/Analyst, TPump, Fast Load, BTEQ

Languages/Utilities: SQL, PL/SQL, UNIX shell scripts,Java, XML,Python/Jython C and COBOL.

Webbased Applications: JDK, J2EE, Servlets, JSP, JDBC, EJB, Java Beans, Java Script, Struts, HTML, XML, JHTML, Java, HTML5, CSS3, AJAX, JavaScript

SCRIPTING LANGUAGES: Shell, Perl, JavaScript

PROFESSIONAL EXPERIENCE

Confidential, CO

Oracle PL/SQL Developer

Responsibilities:

• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Responsible for designing and implementing the integration solution for Hawaii Integrated Eligibility System using Oracle SOA stack.
• Worked onSQL*Loaderto load data from flat files obtained from various facilities every day.
• Working as Principle Consultant mentoring junior dba's, took initiatives on new projects writing scripts, APEX and reviewing changes, Cloud Infrastructure, Cloud PaaS and SaaS Support.
• Serve as subject matter expert (SME) of MDM business process cycles and system integration.
• Implemented Monitoring Templates and Incident Rule notifications using OEM cloud control 12C/13c for database alerting.
• Followed techniques and principles provided by test driven design TDD paradigm for developing quality code.
• Responsible for technical design reviews and assist process team members in unit testing and integration testing activities.
• Optimized batch programs and processes in PRO*C, PL/SQL and custom programs and tuned them to meet the SLA's.
• Performed a POC to check the time taking for Change Data Capture (CDC) of oracle data acrossStriim, StreamSetsandDBVisit.
• UsedJUNITAPI for testing in a Test-Driven Environment (TDD).
• Worked on the Reports module of the project as a developer on MS SQL Server 2005 (using SSRS, T-SQL, scripts, stored procedures and views).
• Proficient in developing concurrent programs usingSQL, PL/SQLandUNIX Shell Scripting.
• Created and modified severalUNIX shellScriptsaccording to the changing needs of the project and client requirements.
• Designed integration architecture for Oracle MDM and Oracle Billing and Revenue Management (BRM).
• Having complete domain and development Life Cycle knowledge of Data Warehousing & Client Server Concepts and knowledge of basic data modeling.
• Involved in migration projects to migrate data from data warehouses on Oracle/DB2 and migrated those to Teradata.
• Extensively working with cloud based database environments preferably AWS cloud.
• Created Ref cursors, Bulk processing, collections, nested tables.
• Used External tables to manipulate data obtained daily before loading them into the tables.
• Involved in multi-tier Java and J2EE based applications support, responsible for writing business logic using core Java, SQL queries for the backend RDBMS.
• Performing Unit Testing on the developed components.
• Designed and developed SOA based enterprise system using Oracle SOA Suite 11g and WebLogic 10g
• Migrated Medicaid Eligibility System from JCAPS/Glassfish to Oracle Fusion middleware.
• Used Oracle Fusion Middleware and JDeveloper 11g to implement Enterprise Healthcare IT Eligibility System for 5010 and MESAV.
• Developed performance frameworks for meeting SLA's that also included using oracle options like partitioning, hashing, indexing, REF cursors, external tables, global temporary tables and materialized views for repetitive aggregations.
• Attended every day Scrum meetings to provide current project status demonstrations in every two weeks, thus implementingwith Test Driven Development.
• Integrated EDI message flow with Corepoint HL7 Analyzer as part of B2B integration and message processing.
• Mapped and implemented EDI transaction for Medicaid Eligibility Benefit request and response X12 270/271 and converted 4010 X12 Transactions to 5010 X12 Transactions.
• Experience working on Vagrant boxes to setup a local Kafka and StreamSets pipelines.
• Worked onTDDTest Driven Development environment.
• Analyzed and consolidated client’s legacy product data and mapped service, customer and account data elements in BRM to Oracle MDM products.
• Experience with monitoring tools such as Cloud Watch.
• Developed PL/SQL triggers and master tables for automatic creation of primary ke
• Proficient in performance analysis, monitoring and SQL query tuning using EXPLAIN PLAN, Collect Statistics, Hints and SQL Trace both in Teradata as well as Oracle.
• Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
• Involved in the continuous enhancements and fixing of production problems.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Involved in Unix Shell scriptsto automate the loading, balancing and extraction process
• Used various Core Java concepts such as Multi-Threading, Exception Handling, Collection APIs. Extensively used While, For-each, Flow, Pick, FLOW N, IF activity’s in Jdeveloper 11g.
• API’s implemented utilizing the following technologies: Spring framework, XML, XSD, JIBX/JAXB to bind XML to Java objects.
• DevelopedPL/SQL triggersandmaster tablesfor automatic creation of primary keys.
• Created PL/SQLstored procedures, functionsandpackagesfor moving the data from staging area to data mart.
• Configured an AWS Virtual Private Cloud (VPC) and Data Base subnet group for isolation of resources within AWS RDS.
• Involved in technical design, unit test documentation preparation.
• Practitioner of Agile Methodologies such as Scrum, Extreme Programming (XP)/Pair Programming and Test Driven Development (TDD).
• Worked on Cloud Migration project, worked on servers and databases running on VMware
• Used DTS/SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML
• Created scripts to createnew tables, views, queriesfor new enhancement in the application using TOAD.
• Exadata/Exalogic Elastic cloud. UNIX Admin (Solaris, Linux), Database/ Weblogic.
• Supporting different Oracle different databases and als using Oracle Enterprise Manager Cloud Control 12c running on top of WLS.
• Created a StreamSet pipeline to parse the file in XML format and convert to a format that is fed to Solr
• ImplementedAgile MethodologyScrumthat includes daily scrum with team and followed Test Driven Environment followingOOD.
• Designed and developed frameworks for fault tolerant architectures, performance frameworks to meet SLA's.
• Exalogic Elastic cloud (Physical and Virtual).
• DevelopedUNIX shell scriptsthat help as a scheduler for data load.
• Wrote Applications which sits on oracle cloud using APEX involving, PLSQL, and TRIGGERS etc.
• Resolve issues related to Control M, Unix shell scripting, Oracle PL/SQL and Informatica on Production environment.
• Involved in multi-tier Java and J2EE based applications support, responsible for writing business logic using core Java, SQL queries for the backend RDBMS
• Performed backend programming for Java applications using JDBC connections.
• Developed JavaBeans, Java Server Pages (JSP), PL/SQL Procedures and Functions to perform business transaction
• Createdindexes on the tables for faster retrieval of the data to enhance databaseperformance.
• Involved in data loading usingPL/SQLandSQL*Loadercalling UNIX scripts to download and manipulate files.
• Used Agile & TDD Methodology for Java development. Repetitive machine driven efforts using Scrum.
• End to End application development right from ingesting the data feeds from upstream, Extraction, transformation and loading, Data enrichment using PL/SQL and python.
• CreateUnitTestScript and define Test Data.
• PerformedSQL and PL/SQL tuningand Application tuning using various tools likeEXPLAIN PLAN, SQL*TRACE, TKPROFandAUTOTRACE.
• Extensively involved in usinghints to direct the optimizerto choose an optimumquery execution plan.
• Used various Core Java concepts such as Exception Handling, Collection APIs to implement various features and enhancements.
• Meeting of all the SLA's set for the system to meet business standards.
• UsedBulk Collectionsforbetter performanceand easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• CreatedPL/SQL scriptsto extract the data from the operational database into simple flat text files usingUTL FILEpackage.
• Implemented Hibernate ORM to Map relational data directly to java objects
• Creation of database objects liketables, views, materialized views, procedures and packagesusing oracle tools likeToad, PL/SQL DeveloperandSQL* plus.
• Worked with JSON file format for StreamSets.
• Created various UNIX Shell Scripts for scheduling and loading process.
• Partitionedthe fact tables andmaterialized viewsto enhance the performance.
• Extensively usedbulk collectionin PL/SQL objects for improving the performing.
• PerformUnit testingand document Unit Test Results.
• Createdrecords, tables, collections(nested tables and arrays) for improving Query performance by reducingcontext switching.
• UsedPragma Autonomous Transactionto avoid mutating problem in database trigger.
• Extensively used the advanced features of PL/SQL likeRecords, Tables, Object typesandDynamic SQL.
• Used core java, java threading (to dynamically create processes)
• Used Jprofiler for java code profiling.
• Handled errors usingException Handlingextensively for the ease of debugging and displaying the error messages in the application.

Environment: Oracle 11g/12c, SQL * Plus, TOAD, SQL*Loader, Java, TDD, Python/Jython, SQL,Streamset, SLA, Test Driven, TDD,Unit Test, Unix Shell Scripts, Windows XP

Confidential, Milwaukee, WI

Oracle PL/SQL Developer

Responsibilities:

• Developed AdvancePL/SQLpackages, procedures, triggers, functions, IndexesandCollectionsto implement business logic usingSQLNavigator. Generated server sidePL/SQLscriptsfordata manipulationand validation and materialized views for remote instances.
• Excellent understanding of Software Development Life Cycle (SDLC), Waterfall and Agile/Scrum Methodologies. Extensively involved in Test Driven Development (TDD).
• Working as Senior Consultant at Oracle responsible for day to day Oracle Cloud operations SaaS
• Supporting Fusion Applications Domains HCM, CRM, BI, ERP, SCM, PROCUREMNET, IC SaaS with Fusion Middleware 11g and Database 11g on Exalogic and Exadata platform for Oracle Cloud on Rel 12 and 13.
• Used advanced features of T-SQL in order to design and tune T-SQL to interface with the Database and other applications in the most efficient manner and created stored Procedures for the business logic using T-SQL.
• Maintained the batch processes using Unix Shell Scripts.
• Created management analysis reporting usingParallelQueries, Javastoredprocedure, HTPPackageandWEB.SHOW DOCUMENT. Participated in change and code reviews to understand the testing needs of the change components. Worked on troubleshooting defects in timely manner.
• Handling core performance issues with business process, with the database, overall infrastructure and optimizing the application design as required to meet the SLA's.
• Used AJAX in suggestive search and to display dialog boxes with JSF, JavaScript, HTML and CSS for some front end. Created database objects like tables, views, procedures, packages.
• Involved in migration projects to migrate data from data warehouses on Oracle/DB2 and migrated those to Teradata.
• Documentation of Technical Design document (TDD) which includes all the components developed as part of the requirement - packages, procedures, table creation scripts etc.
• Used Teradata utilities fastload, multiload, tpump to load data
• Involved in creatingUNIXshellScripting. Defragmentation of tables, partitioning, compressing and indexes for improved performance and efficiency. Involved in table redesigning with implementation of Partitions Table and Partition Indexes to makeDatabaseFaster and easier to maintain.
• Designed and implemented web UI for testing/simulation of APL trade orders using Python and PL/SQL
• Experience inDatabaseApplicationDevelopment, Query Optimization, Performance TuningandDBAsolutions and implementation experience incomplete SystemDevelopmentLifeCycle.
• Performance tuning of batch programs (PL/SQL, PRO*C), Oracle forms in ORMS,ORPM to meet the SLA's
• UsedSQL Server SSIStoolto build high performance data integration solutions includingextraction, transformationandload packagesfordatawarehousing.Extracted data from theXMLfile and loaded it into thedatabase.
• Used combination of Java and SQL statements embedding them in Java programs for various issues.
• Developed database triggers and stored procedures using T-SQL cursors and tables.
• Designed and developedOracle forms & reportsgenerating up to 60 reports.
• Performed modifications on existingformas per change request and maintained it.
• UsedCrystal Reportsto track logins, mouse overs, click-through, session durations and demographical comparisons with SQL database of customer information.
• Experience withTest Driven Development (TDD)andNunittesting framework.
• Used DMX-3000 SAN storage solution for hosting Oracle databases and BCV technology for hot backups to meet SLA's.
• Used principles of Normalization to improve the performance. Involved inETLcode usingPL/SQLin order to meet requirements for Extract, transformation, cleansing and loading of data from source to targetdatastructures.
• Involved in the continuous enhancements and fixing of production problems.Designed, implementedandtunedinterfaces and batch jobs usingPL/SQL. Involved in data replication and high availability design scenarios withOracle Streams. DevelopedUNIXShellscriptsto automate repetitivedatabaseprocesses.

Environment: VB 6, JAVA, Oracle 10g/11g, PL/SQL, SQL*LOADER,Python, Oracle Streams 10g (Replication), SQL PLUS, HTML, SQL Server SSIS, TOAD, XML, HP-UNIX shell scripting.

Confidential, NY

Oracle Developer

Responsibilities:

• Involved in customizing and testing of AIA/PIP interfaces between Siebel and MDM
• Involved in providing solutions in identifying issues form UCM and resolving those issues
• Performed DQ by adding matching fields and logic as per business requirement
• Involved in Architecture discussions with other teams like CRM Siebel,
• AIA Middleware Team
• Involved in providing customization of Data Quality Services Person Match for MDM performed set up of multiple MDM environments for the state and Data Quality Design And Definition
• Led the effort of Designing and solution Integration between Legacy mainframe applications and MDM
• Supervised and Designed and recommended best practices for Initial Data Load to facilitate minimum downtime of production environment
• Setup Oracle Advance Benefits by establishing Elements for various Benefit Plans, Programs, Program Enrollments, Life events, Eligibility Profiles to restrict eligibility. Simplified the Customizations in OAB and modified the Configurations at various levels to follow Oracle rules and hierarchy of Eligibility and Electability rules.
• Provided Solution and Developed Data Quality frame work for person data coming from external systems
• Performed AIA/PIP installation and configuration for Customer Master between Siebel and MDM
• Provided Integration solution for EDM Interface with MDM to facilitate Open Enrollment
• MDM Architect, UCM 8.1.1.4 installation, DQ Design Implementation, Integration with PIM and Oracle EBS
• As the application architect / Technical Lead, responsible for installing UCM 8.1.1.4, Oracle Data Quality IIR 2.7 in Sun Solaris and Linux environment
• Involved in the design on data quality, data load, interfaces, data management
• Involved in the testing of AIA/PIP interfaces between Siebel, Oracle EBS and UCM
• Provided Solution of the unique identifier across all systems
• Involved in identifying issues form UCM and resolving those issues
• Involved in Architecture discussions with other teams like PIM Product Master,
• Oracle Supplier Hub OSB Teams
• Involved in defining the ICC Discussion and providing a Design for Integration with Order Management System
• Involved providing Solution Workshop to the business owners and end users

Environment: Oracle 8i, UNIX, SQL, PL/SQL, SQL Developer and TOAD, SQL*Loader, Data pump, Crystal Reports, Erwin, VSS, Outlook, Putty.

Confidential

Oracle Developer/Analyst

Responsibilities:

• Involved in full development cycle ofPlanning, Analysis, Design, Development, TestingandImplementation.
• Designed logical and physical data models for star and snowflake schemas usingErwin.
• Wrote sequences for automatic generation of unique keys to supportprimary and foreign keyconstraints in data conversions.
• Created and modifiedSQL*Plus, PL/SQLandSQL*Loader scriptsfor data conversions.
• UpgradedOracle 9i to 10gsoftware in different environments for latest features and also tested databases.
• Developed and modifiedtriggers, packages, functionsandstored proceduresfor data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• WroteSQL, PL/SQL, SQL*Plusprograms required to retrieve data using cursors and exception handling.
• Worked onXMLalong with PL/SQL to develop and modify web forms.
• Designed Data Modeling, Design Specifications and to analyzeDependencies.
• Creatingindexeson tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
• Fine-tuned procedures/SQL queries for maximum efficiency in various databases usingOracle Hints, for Rule based optimization.
• UsedDiscoverer 2000to provide end users easy access to data and help in data analysis.
• Created some Custom reports and Forms for the end users to check the details and errors.

Environment: Oracle 9i, 10g, SQL*Plus, PL/SQL, Erwin 4.1, Oracle Designer 2000,Windows 2000, Toad.