SUMMARY

• More than 10+ years of development with around 9+ years of experience in developing applications using Oracle, SQL, PL/SQL, New Relic, MuleSoft - 4 (Data Weave Scripting), AWS and Cassandra.
• Followed Agile methodology and CICD development and bamboo deployment.
• Created WSDL's for SOA services that can be used across enterprise.
• Created SOA and rest Web services.
• Excellent experience in Oracle Developer 2000, Oracle E Business Suite R12, Designer 2000/10g and Oracle 10g, Oracle SOA suite.
• Familiarized with reporting tools such as Alteryx, Tableau, Hygiea and Alert tools as New relic
• Done dimensional database with Entity-Relationship (ER) modeling and the structuring of data into normalized table
• Familiarity with Extraction, Transformation and Loading (ETL tools) to facilitate loading large amounts of data for different data sources XML, EDI, JSON formats from third party
• Experienced in dealing with end users to gather requirements, product demonstrations and providing product support giving detailed technical specifications for developers; design, validate and execute software test plans.
• Proficient in Data Modeling (Logical and Physical Design of Databases) using Oracle Designer 11g writing server-side stored procedures/ triggers.
• Ability to work on multiple tasks and deliver the results within estimated budget and time
• Proficient in using Oracle specific features Oracle Data Partitioning techniques to manage, support and performance tune very large databases (VLDB's) and used to Optimize/ tune Stored Procedures, embedded SQL.
• Designed modules included in Oracle Business Intelligence Suite Enterprise Edition Plus, Customer information that can be leveraged across all functional departments and Analytical Systems.
• Worked with Agile Methodology to deliver story within Sprint.
• Familiar with JIRA, Mozart, Source Tree, TFS, WinCVS, FileZilla and Git Bash, Bamboo, JAVA, Eclipse Neon3.
• Excellent communication and analytical skills.
• Good team player with experience working in individual and team environments

TECHNICAL SKILLS

Languages: SQL, PL/SQL, C, C++, JavaScript, Unix Shell Scripting

Databases: Oracle 19c/12c/11g/10g, Cassandra, MS SQL server 7/2000/2003, MySQL.

Application Tools: JAVA and Eclipse Neon3, x, MULESOFT 4 (ANYPOINT EDI), Oracle Forms10g, Reports 6i, Oracle E-Business Suite R12, Oracle Data Integrator 11gR1

Oracle Utilities: TOAD 12.x, PLSQL Developer 10.x, SQL Dev 4.x, MYSQL

Reporting/Alerting Tools: NEW RELIC, ALTERYX, TABLEAU, HYGEIA, INFORMATICA Power center 8.0

Version controls: WINCVS, BAMBOO, STASH, GIT BASH

CLOUD Protocols: AWS CLOUD System, BOX, AI implementation

Operating Systems: Windows NT/98/XP/2000/2003, UNIX

PROFESSIONAL EXPERIENCE

Confidential, New York

Sr. Oracle Developer III / Programmer Analyst

Responsibilities:

• New Relic Certified in Fundamentals and MuleSoft Certified Developer-Level 1
• More than 3+ years of Team Lead experience with team in India, Costa Rica and Miami developing applications using Oracle, SQL, PL/SQL, New Relic, MuleSoft, AWS and Cassandra. Oracle database development, troubleshooting, and performance tuning of PL/SQL
• Relational Database Management Systems (RDBMS) Tables Supporting the integrations partially post go-live and transferred knowledge to the offshore production support team.
• Ability to document concise design, development, and testing processes for assigned projects
• Ability to help create and map business needs/application requirements to technical solutions
• Good understanding of data modeling, processing and warehousing techniques
• Exceptional analytical and debugging skills
• Coordinate with DBAs for tasks such as creating/rebuilding indexes, adding partitions, and analyzing tables
• Commanding knowledge and experience writing advanced SQL queries, PL/SQL Stored procedures, Functions & Packages Ability to document concise design, development, and testing processes for assigned projects.
• Ability to help create and map business needs/application requirements to technical solutions Participate in Configuration and Change management activities for the integration that myself and the team developed Coordinate with DBAs for tasks such as creating/rebuilding indexes, adding partitions, and analyzing tables
• Reading complex XML EDI structures from BOX cloud locations and developing API specifications (OAS/RAML). Strong Integration background with legacy web services (SOAP) and Data Weave Scripting
• Experience in securing APIs with modern protocols (OAuth, JSON Web Token (JWT))
• Developed Dashboards/Applications and REST APIs to read EDI using JAVA and eclipse Neon deployed on AWS cloud system.
• Followed Agile methodology and CICD development and bamboo deployment using GIT bash to deliver story within Sprint. Gone through AGILE expertise training.
• Practiced Automation testing using Selenium, Eclipse for both Database packages and JAVA based dashboards (UI). Achieved 80% code coverage for Automated test cases.
• Experienced in dealing with end users to gather requirements, product demonstrations and providing product support giving detailed technical specifications for developers; design, validate and execute software test plans.
• Involve in Code Review, Testing, and Effort estimation for the enhancement requests and finish them with the capacity of the iteration.
• Worked with offshore team to find any issues for deliverables and guide them to fix it using Agile based methodology
• Excellent communication and documentation skills.

Environment: Oracle 19c/12c (Database), OWB (ETL tool), PL/SQL, SQL Plus, TOAD 12.5, WINCVS, Import/Export EDI, WEBUTIL, FileZilla, JIRA and Mozart, GIT Bash, AWS, Bamboo, JAVA and IntelliJ 11

Confidential, Miami Florida

Sr. Oracle Developer III / Programmer Analyst

Responsibilities:

• New Relic Certified in Fundamentals and MuleSoft Certified Developer-Level 1
• More than 3+ years of Team Lead experience with team in India, Costa Rica and Miami developing applications using Oracle, SQL, PL/SQL, New Relic, MuleSoft, AWS and Cassandra.
• Reading complex XML EDI structures from BOX cloud locations and developing API specifications (OAS/RAML). Strong Integration background with legacy web services (SOAP) and Data Weave Scripting
• Experience in securing APIs with modern protocols (OAuth, JSON Web Token (JWT))
• Learned JAVA/JavaScript/AWS and developed applications/REST API to download EDI
• Developed Dashboards/Applications and REST APIs to read EDI using JAVA and eclipse Neon deployed on AWS cloud system.
• Created WSDL's for SOA services that can be used across enterprise.
• Created SOA and rest Web services.
• Followed Agile methodology and CICD development and bamboo deployment using GIT bash to deliver story within Sprint. Gone through AGILE expertise training.
• Developed Recon reports largely used by Business for Analysis purpose with reporting Aletryx/Tableau and Alert dashboards using New relic.
• Developed SOA integration between Client FTP web services and ON premise web services
• Developed cloud-based Applications using ANYPOINT MULESOFFT-4 consuming files for BOX cloud storage system. Familiar with JIRA, Win CVS, Git Bash, Bamboo, JAVA, Eclipse Neon3.
• Practiced Automation testing using Selenium, Eclipse for both Database packages and JAVA based dashboards (UI). Achieved 80% code coverage for Automated test cases.
• Developed custom dashboard using HYGIEA and NEW RELIC and developed Custom proactive alerts from NEW RELIC at the TRIBE level
• Involved in making the team self-sufficient in server side maintenance for a 3rd party application and key upgradation. Done dimensional database with Entity-Relationship (ER) modeling and the structuring of data into normalized table
• Experienced in dealing with end users to gather requirements, product demonstrations and providing product support giving detailed technical specifications for developers; design, validate and execute software test plans.
• Responsible for database object maintenance by creating objects such as Tables, Indexes, Views, Database Triggers, PL/SQL procedures, Packages, Dynamic SQL, ref Cursors Materialized Views, Object Types, Bulk Transactions, SQL*Loader
• Analyze enhancement request of Invoicing (AR and AP) and Matching Application from business and provide technical solution.
• Involve in Code Review, Testing, and Effort estimation for the enhancement requests and finish them with the capacity of the iteration.
• Tune database queries and Monitor application related jobs and data replication activities.
• Perform application tuning and performance monitoring, perform general technical troubleshooting and give consultation to development teams. Created Detail Technical Documents and participated in the meetings with business helping the BSC to write the Functional Specification Document and SOA documentation.
• Worked with offshore team to find any issues for deliverables and guide them to fix it using Agile based methodology

Environment: Oracle 11g/10g (Database), OWB (ETL tool), PL/SQL, SQL Plus, TOAD 12.5, WINCVS, Import/Export EDI, WEBUTIL, FileZilla, JIRA and Mozart, GIT Bash, AWS, Bamboo, JAVA and Eclipse Neon3

Confidential, Tampa Florida

Sr. Oracle Developer/Programmer Analyst

Responsibilities:

• Responsible for database object maintenance by creating objects such as Tables, Indexes, Views, Database Triggers, PL/SQL procedures, Packages, Dynamic SQL, ref Cursors Materialized Views, Object Types, Bulk Transactions, SQL*Loader
• Took initiative for improving the data mapping documents and data flow diagrams.
• Worked on analyzing, fixing and testing the EDC (Electronic Data Capture) conflicts issues in production. Worked on creating test cases and data validation scripts.
• Knowledge in application packaging and application virtualization in tools like TRACKWISE PR IMPORTS
• Analyze Stage ETL and Oracle performance issues, design and recommend solutions, and code, test, and implement improved ETL programs according to established IT standards
• Developed adhoc and custom Crystal Reports, Cognos Reports and BI report from the Replica data form Golden Gate
• Performed IQ, OQ and PQ in HP ALM for the deployment go live.
• Created WSDL's for SOA services that can be used across enterprise.
• Created SOA and rest Web services.
• Created SQL loader scripts to load the data from files to temporary tables.
• Tune database queries and Monitor application related jobs and data replication activities.
• Replicated the real time production database for Golden Gate and Cognos using Materialized Views.
• Perform application tuning and performance monitoring, perform general technical troubleshooting and give consultation to development teams.
• Created Detail Technical Documents and participated in the meetings with business helping the BSC to write the Functional Specification Document.
• Documented the HLD of the process using VISIO, so that it would be very useful for the ones who come new on board.

Environment: Oracle 11g/10g (Database), OWB (ETL tool), PL/SQL, SQL Plus, TOAD 9.1, VBScript, Crystal Reports 2011, Track Wise, HP ALM, Golden Gate, Cognos Report Net (CRN), CMCS, JIRA, BEELINE, Microsoft VSS, WEBUTIL, Windows 2000/NT/XP

Confidential, San Diego

Sr. Oracle Developer/Programmer Analyst

Responsibilities:

• Created the database objects such as Tables, Indexes, Views, Database Triggers, PL /SQL procedures, Packages, Dynamic SQL, ref Cursors Materialized Views, Object Types, Bulk Transactions, SQL*Loader.
• Handled Off-shore team of developers and QA for Onsite project, taking requirements from Business Analysts and Business managers.
• Involved in the hardware setup of the database server and application server for Unix based system like HP- UX.
• Developed SOA integration between Client FTP web services and ON premise web services
• Transformation, Extracting and loading (ETL) of the data through Oracle Data Integrator (ODI) 11g for XML, EDI sources from third party
• Research, analyze and design computer-based solutions for defined business, scientific or engineering problems and provides analysis of business, management and system requirements in terms of decision support using: Oracle 10g/11g SQL, PLSQL, Toad 9.7
• Troubleshoot bugs, enhance and support existing ETL packages for the data warehouse
• Participated in requirements gathering and design of ETL/data integration solutions
• Optimize and convert existing ETL/ELTs
• Generated SQL and PL/SQL scripts to install create and drop Trading Exchange Connection database objects including: tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Troubleshoot performance issues and bugs within packages, reports using explain plan and TKPROF.
• Interface with QA, Production DBAs and Production Support team to test, deploy and support ETL packages
• Created/modified oracle loan procedures, packages and functions to move the change data across multiple environments using DB links.
• Oracle performance issues, design and recommend solutions, and code, test, and implement improved programs according to established IT standards
• Lead the support and troubleshooting of production systems as required, optimizing performance, resolving production problems, and providing timely follow-up on problem reports
• Used UNIX commands and basic Shell scripting.
• FTP tools for transferring the files like Toad 9.7, Cute Ftp, data designing/ Modeling software’s like ERWIN, Visio 2008. Web based application development through JBoss Server, Java, and MS SQL server 2012.
• Version controlling is done through Microsoft Visual Studio (TFS)
• Loading outside source files through SQL* Loader and UTL file
• Used TOAD, PL/SQL developer tools for faster application design and developments
• Participated in the full software life cycle.

Environment: E Business Suite 11i Oracle 10g(forms and reports), Oracle 10g/ 11g, Jasper, JBoss, Forms API MAter V2.0, VB.NET, PL/SQL, SQL Plus, TOAD 9.1,RDBMS, Import/Export EDI, SQL Loader, OWB ETL, Oracle Discoverer 10g, PVCS, VB 6.0, Crystal Reports11, WinSCP, Putty, WinCVS Agent Ransack, Citrix, Windows 2000/NT/XP/2003, Unix

Sr. Oracle Developer/Programmer Analyst

Responsibilities:

• Technical and functional knowledge of the Oracle APPS Modules (HRMS, OE, INV, PUR, RETAIL CHAIN MANAGEMENT AND CASH MANAGEMENT)
• Expertise in creating matrix reports, generating designated formats (*.pdf, *.xls, *.txt)
• Created the test cases and project deliverable templates and standards, step wise detail process and deployed the activities.
• Monitored the interdependency's for cloning the different versions for different clients.
• Developing the modules by getting the requirements, validating business requirements, planning and defining key activities and building the application.
• Customizing and implementing different modules like Cash Management, Merchandise Modiles, File Maintenance.
• Created the database objects such as Tables, Indexes, Views, Database Triggers, PL /SQL procedures, Packages, Dynamic SQL, ref Cursors Materialized Views, Object Types, Bulk Transactions, SQL*Loader.
• Troubleshoot bugs, enhance and support existing ETL packages for the data warehouse
• Participated in requirements gathering and design of ETL/data integration solutions
• Involved in the hardware setup of the database server and application server for Unix based system like HP- UX.
• Transformation, Extracting and loading (ETL) of the data through Oracle Data Integrator (ODI) 11g R1 and Informatica Powercenter 8.0
• Create and maintain documentation for developed ETL processes
• Developed procedures using Dynamic SQL, UTL FILE.
• Converting application modules from forms 6i into oracle 10g.
• Done the documentation and provided on-site production support.
• Also developed few applications in Visual Basics.

Environment: E Business Suite 11i Oracle 10g (forms and reports), Oracle 10g/ 11g, Jasper, JBoss, Forms API MAter V2.0, VB.NET, PL/SQL, SQL Plus, TOAD 9.1, RDBMS, Import/Export, SQL Loader, OWB ETL, Oracle Discoverer 10g, PVCS, VB 6.0, Crystal Reports11, WinSCP, Putty, WinCVS Agent Ransack, Citrix, Windows 2000/NT/XP/2003, Unix

Confidential

Senior Systems Analyst

Responsibilities:

• Research, analyze and design computer based solutions for defined business, scientific or engineering problems and provides analysis of business, management and system requirements in terms of decision support using: Oracle E business solutions 11i, Oracle 10g/11g SQL, PLSQL, Oracle Developer 2000 (Forms 6i/ Reports 6i), Oracle Designer 2000, Oracle forms 9i, Reports 9i, Visual Basics 6.0, Toad 9.7
• Involved in the hardware setup of the database server and application server for UNIX based system like HP- UX.
• Transformation, Extracting and loading of the data through Informatica Powercenter8
• FTP tools for transferring the files like Humming bird, Toad 9.7, Cute Ftp.
• Data designing/ Modeling software’s like ERWIN, Visio 2003. Web based application development through Oracle Data Access Developer (DAD), Dreamweaver CS5 JavaScript, HTML, and MS SQL Server 2008.
• Version controlling is done through PVCS tool and Microsoft Visual Studio (TFS)
• Loading outside source files through SQL* Loader, UTL file and WEBUTIL Files.
• Technical and Functional resource for the Oracle Application modules (FINANCE, RETAILING, PURCHASING, SUPPLY CHAIN MANAGEMENT (SCM), Customer Relations Management (CRM). Designing and developing reports in Discoverer Desktop 10g and JASPER Reports
• Expertise in creating matrix reports, generating designated formats (*.pdf, *.xls, *.txt)
• Created the test cases and project deliverable templates and standards, step wise detail process and deployed the activities.
• Monitored the interdependency's for cloning the different versions for different clients.
• Developing the modules by getting the requirements, validating business requirements, planning and defining key activities and building the application.
• Customizing and implementing different modules like Cash Management, Merchandise Modules, File Maintenance, Retail Chain management, Healthcare, Oracle APPS Modules (Finance, INV, PUR)
• Created the database objects such as Tables, Indexes, Views, Database Triggers, PL /SQL procedures, Packages, Dynamic SQL, ref Cursors Materialized Views, Object Types, Bulk Transactions, SQL*Loader.
• Troubleshoot bugs, enhance and support existing ETL packages for the data warehouse
• Participated in requirements gathering and design of ETL/data integration solutions
• Involved in the hardware setup of the database server and application server for Unix based system like HP- UX.
• Transformation, Extracting and loading (ETL) of the data through Oracle Data Integrator (ODI) 11g R1 and Informatica Power center 8.0
• Create and maintain documentation for developed ETL processes
• Developed procedures using Dynamic SQL, UTL FILE.
• Converting application modules from forms 6i into oracle 10g.
• Done the documentation and provided on-site production support.