Sharadchandra Shrirame

Sr Oracle Database Developer/ Programmer Analysts at UNICOM Technologies Inc
  • Claim this Profile
Contact Information
Location
Tampa, Florida, United States, US

Topline Score

Bio

Generated by
Topline AI

0

/5.0
/ Based on 0 ratings
  • (0)
  • (0)
  • (0)
  • (0)
  • (0)

Filter reviews by:

No reviews to display There are currently no reviews available.

0

/5.0
/ Based on 0 ratings
  • (0)
  • (0)
  • (0)
  • (0)
  • (0)

Filter reviews by:

No reviews to display There are currently no reviews available.
You need to have a working account to view this content. Click here to join now

Credentials

  • Oracle Database 9i
    Oracle
    Nov, 2007
    - Sep, 2024

Experience

    • United States
    • IT Services and IT Consulting
    • 1 - 100 Employee
    • Sr Oracle Database Developer/ Programmer Analysts
      • Jun 2020 - Present

      1. Verizon LLC, Tampa Florida (Apr 2022 - Till Date) 2. Deutsche Bank, New York ( Jun 2020 - Mar 2022) Sr. Oracle Developer/ Analyst 1. Using Oracle 21c/19c and toad, developed PL/SQL packages, SQL scripts, Daily batches in CA WAWscheduler using Solaris/ Unix and Oracle scripting. 2. Created ESP job for CA workload automation(11.3) a SAAS implementor to import files and assimilate them in Verizon database system. 3. Used SSR application for project management and resolved very… Show more 1. Verizon LLC, Tampa Florida (Apr 2022 - Till Date) 2. Deutsche Bank, New York ( Jun 2020 - Mar 2022) Sr. Oracle Developer/ Analyst 1. Using Oracle 21c/19c and toad, developed PL/SQL packages, SQL scripts, Daily batches in CA WAWscheduler using Solaris/ Unix and Oracle scripting. 2. Created ESP job for CA workload automation(11.3) a SAAS implementor to import files and assimilate them in Verizon database system. 3. Used SSR application for project management and resolved very critical production issues. 4. Optimized and did performance tuning for legacy codes and migration into Oracle 21c/19c. 5. Followed Agile methodology and CICD development and bamboo deployment using GIT bash to deliver stories within Sprint. Gone through AGILE expertise training. 6. Provided production support for critical applications and timely rectifying the batch job failures operated in Oracle 19c and solaris file processing system. 7. Responsible for database object maintenance by creating objects such as Tables, Indexes, Views, Database Triggers, PL/SQL tables to move bulk data with procedures, Packages, Dynamic SQL, ref Cursors Materialized Views, Object Types, Bulk Transactions, SQL*Loader to store complex data from the remote database (ETL) 9. Involved in business requirement gathering, code Review, Testing, and Effort estimation for the enhancement requests and finishing them with the capacity of the iteration. 10. Worked with DBA to Tune database queries and Monitor application related jobs and data replication activities for local reports and remote data queries. 11. Perform application tuning and performance monitoring, perform general technical troubleshooting and give consultation to development teams. 12. Worked with offshore team for deliverables and guide them to fix it using Agile based methodology. 13. Practiced Automation testing using Selenium, Eclipse for both Database packages and JAVA based dashboards (UI). Achieved 80% code coverage for Automated test cases. Show less 1. Verizon LLC, Tampa Florida (Apr 2022 - Till Date) 2. Deutsche Bank, New York ( Jun 2020 - Mar 2022) Sr. Oracle Developer/ Analyst 1. Using Oracle 21c/19c and toad, developed PL/SQL packages, SQL scripts, Daily batches in CA WAWscheduler using Solaris/ Unix and Oracle scripting. 2. Created ESP job for CA workload automation(11.3) a SAAS implementor to import files and assimilate them in Verizon database system. 3. Used SSR application for project management and resolved very… Show more 1. Verizon LLC, Tampa Florida (Apr 2022 - Till Date) 2. Deutsche Bank, New York ( Jun 2020 - Mar 2022) Sr. Oracle Developer/ Analyst 1. Using Oracle 21c/19c and toad, developed PL/SQL packages, SQL scripts, Daily batches in CA WAWscheduler using Solaris/ Unix and Oracle scripting. 2. Created ESP job for CA workload automation(11.3) a SAAS implementor to import files and assimilate them in Verizon database system. 3. Used SSR application for project management and resolved very critical production issues. 4. Optimized and did performance tuning for legacy codes and migration into Oracle 21c/19c. 5. Followed Agile methodology and CICD development and bamboo deployment using GIT bash to deliver stories within Sprint. Gone through AGILE expertise training. 6. Provided production support for critical applications and timely rectifying the batch job failures operated in Oracle 19c and solaris file processing system. 7. Responsible for database object maintenance by creating objects such as Tables, Indexes, Views, Database Triggers, PL/SQL tables to move bulk data with procedures, Packages, Dynamic SQL, ref Cursors Materialized Views, Object Types, Bulk Transactions, SQL*Loader to store complex data from the remote database (ETL) 9. Involved in business requirement gathering, code Review, Testing, and Effort estimation for the enhancement requests and finishing them with the capacity of the iteration. 10. Worked with DBA to Tune database queries and Monitor application related jobs and data replication activities for local reports and remote data queries. 11. Perform application tuning and performance monitoring, perform general technical troubleshooting and give consultation to development teams. 12. Worked with offshore team for deliverables and guide them to fix it using Agile based methodology. 13. Practiced Automation testing using Selenium, Eclipse for both Database packages and JAVA based dashboards (UI). Achieved 80% code coverage for Automated test cases. Show less

    • United States
    • Oil and Gas
    • 700 & Above Employee
    • Sr Oracle Developer/ Programmer Analysts
      • Jan 2017 - May 2020

      New Relic Certified in Fundamentals and MuleSoft Certified Developer-Level 1 More than 3+ years of development applications using Oracle, SQL, PL/SQL, New Relic, MuleSoft, AWS Cassandra 2.X. Reading complex XML 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… Show more New Relic Certified in Fundamentals and MuleSoft Certified Developer-Level 1 More than 3+ years of development applications using Oracle, SQL, PL/SQL, New Relic, MuleSoft, AWS Cassandra 2.X. Reading complex XML 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 Cassandra (CQL)and developed applications/REST API under Team Leaders guidance and support Developed Dashboards/Applications and REST APIs using JAVA and eclipse Neon deployed on AWS cloud system. Developed Recon reports largely used by Business for Analysis purpose with reporting Alteryx/Tableau and Alert dashboards using New relic. Developed cloud-based Applications using ANYPOINT MULESOFT-4 consuming files for BOX cloud storage system. Familiar with JIRA, WinCVS, Git Bash, Bamboo, JAVA, Eclipse Neon3. Performed the Salesforce workbench objects to check the data is transformed correctly according to various business Techniques and rules. Verify data sent from Mule API is stored in the correct Salesforce location. Performed the JSON/ XML Request and Response data validation via Postman/ SOAP UI web services API Tools. Write scripts in POSTMAN for field level data validation. 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 Provide support to clients to perform UAT. Involve in Code Review, Testing, and Effort estimation for the enhancement requests and finish them with the capacity of the iteration. Written PostgreSQL queries for data tables for various vendor data sources Tune database queries and Monitor application related jobs and data replication activities. Show less New Relic Certified in Fundamentals and MuleSoft Certified Developer-Level 1 More than 3+ years of development applications using Oracle, SQL, PL/SQL, New Relic, MuleSoft, AWS Cassandra 2.X. Reading complex XML 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… Show more New Relic Certified in Fundamentals and MuleSoft Certified Developer-Level 1 More than 3+ years of development applications using Oracle, SQL, PL/SQL, New Relic, MuleSoft, AWS Cassandra 2.X. Reading complex XML 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 Cassandra (CQL)and developed applications/REST API under Team Leaders guidance and support Developed Dashboards/Applications and REST APIs using JAVA and eclipse Neon deployed on AWS cloud system. Developed Recon reports largely used by Business for Analysis purpose with reporting Alteryx/Tableau and Alert dashboards using New relic. Developed cloud-based Applications using ANYPOINT MULESOFT-4 consuming files for BOX cloud storage system. Familiar with JIRA, WinCVS, Git Bash, Bamboo, JAVA, Eclipse Neon3. Performed the Salesforce workbench objects to check the data is transformed correctly according to various business Techniques and rules. Verify data sent from Mule API is stored in the correct Salesforce location. Performed the JSON/ XML Request and Response data validation via Postman/ SOAP UI web services API Tools. Write scripts in POSTMAN for field level data validation. 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 Provide support to clients to perform UAT. Involve in Code Review, Testing, and Effort estimation for the enhancement requests and finish them with the capacity of the iteration. Written PostgreSQL queries for data tables for various vendor data sources Tune database queries and Monitor application related jobs and data replication activities. Show less

    • United States
    • IT Services and IT Consulting
    • 700 & Above Employee
    • Sr Oracle Database Developer/ Programmer Analysts
      • Mar 2014 - Jan 2017

      1. Client - Wells Fargo Bank, Maryland 2. Client - Direct Tv - Los Angeles, CA 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 Involved in analyzing the data mapping documents and data flow diagrams. Created and assigned users, profiles, privileges, roles etc according to the hierarchy levels Technical and functional knowledge of… Show more 1. Client - Wells Fargo Bank, Maryland 2. Client - Direct Tv - Los Angeles, CA 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 Involved in analyzing the data mapping documents and data flow diagrams. Created and assigned users, profiles, privileges, roles etc according to the hierarchy levels Technical and functional knowledge of the Oracle SMS and CDC Created highly tuned scripts to create database objects needed such as, tables, views, indexes, procedure, functions and packages. Worked on setting up the change tables, change views and packages for oracle native CDC (change data capture). 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 Worked on analyzing, fixing and testing the CDC conflicts issues in production. Worked on creating test cases and data validation scripts. Worked on used cases, which enables users to check the pool level statistics of fixed and ARM pools through UI. Developed automated scripts to create audit triggers for the tables. Created SQL loader scripts to load the data from files to temporary tables. Worked on rotational on call production support. Worked extensively in designing and developing the process for the ARCHIVAL and UNARCHIVAL of pooled loans in to the POSTWARE database, on the basis of the LOAN status on the SMS (Secondary Marketing System). Worked on the design and development of CORE Loans Consumption Process, and the Reporting Package adhering to the Business Requirements. Show less 1. Client - Wells Fargo Bank, Maryland 2. Client - Direct Tv - Los Angeles, CA 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 Involved in analyzing the data mapping documents and data flow diagrams. Created and assigned users, profiles, privileges, roles etc according to the hierarchy levels Technical and functional knowledge of… Show more 1. Client - Wells Fargo Bank, Maryland 2. Client - Direct Tv - Los Angeles, CA 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 Involved in analyzing the data mapping documents and data flow diagrams. Created and assigned users, profiles, privileges, roles etc according to the hierarchy levels Technical and functional knowledge of the Oracle SMS and CDC Created highly tuned scripts to create database objects needed such as, tables, views, indexes, procedure, functions and packages. Worked on setting up the change tables, change views and packages for oracle native CDC (change data capture). 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 Worked on analyzing, fixing and testing the CDC conflicts issues in production. Worked on creating test cases and data validation scripts. Worked on used cases, which enables users to check the pool level statistics of fixed and ARM pools through UI. Developed automated scripts to create audit triggers for the tables. Created SQL loader scripts to load the data from files to temporary tables. Worked on rotational on call production support. Worked extensively in designing and developing the process for the ARCHIVAL and UNARCHIVAL of pooled loans in to the POSTWARE database, on the basis of the LOAN status on the SMS (Secondary Marketing System). Worked on the design and development of CORE Loans Consumption Process, and the Reporting Package adhering to the Business Requirements. Show less

    • United States
    • Software Development
    • 700 & Above Employee
    • S Oracle Developer
      • Apr 2013 - Mar 2014

      •Createing 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 •Imroving Performance issues, design and recommend solutions, and code, test, and implement improved programs according to established IT standards •Worked on rotational on call production support. •Worked extensively in designing and developing the process for the ARCHIVAL and UNARCHIVAL of… Show more •Createing 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 •Imroving Performance issues, design and recommend solutions, and code, test, and implement improved programs according to established IT standards •Worked on rotational on call production support. •Worked extensively in designing and developing the process for the ARCHIVAL and UNARCHIVAL of pooled loans in to the POSTWARE database, on the basis of the LOAN status on the SMS (Secondary Marketing System). •Worked on the design and development of CORE Loans Consumption Process, and the Reporting Package adhering to the Business Requirements •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. Show less •Createing 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 •Imroving Performance issues, design and recommend solutions, and code, test, and implement improved programs according to established IT standards •Worked on rotational on call production support. •Worked extensively in designing and developing the process for the ARCHIVAL and UNARCHIVAL of… Show more •Createing 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 •Imroving Performance issues, design and recommend solutions, and code, test, and implement improved programs according to established IT standards •Worked on rotational on call production support. •Worked extensively in designing and developing the process for the ARCHIVAL and UNARCHIVAL of pooled loans in to the POSTWARE database, on the basis of the LOAN status on the SMS (Secondary Marketing System). •Worked on the design and development of CORE Loans Consumption Process, and the Reporting Package adhering to the Business Requirements •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. Show less

    • Sr Programmer Analyst
      • Aug 2010 - Mar 2014

      1. LPL Financials - San Diego, CA 2. Tomax Retail - Salt Lake City, UT Performance tuning, SQL tuning of Stored procedures and functions. Responsible for Oracle Plsql coding, testing and UAT test notes. Involved in technical specification writing, design documentation and analysis. Technical and functional knowledge of the Oracle APPS Modules (OE, INV, PUR, RETAIL CHAIN MANAGEMENT AND CASH MANAGEMENT) Expertise in creating matrix reports, generating designated formats(… Show more 1. LPL Financials - San Diego, CA 2. Tomax Retail - Salt Lake City, UT Performance tuning, SQL tuning of Stored procedures and functions. Responsible for Oracle Plsql coding, testing and UAT test notes. Involved in technical specification writing, design documentation and analysis. Technical and functional knowledge of the Oracle APPS Modules (OE, INV, PUR, RETAIL CHAIN MANAGEMENT AND CASH MANAGEMENT) Expertise in creating matrix reports, generating designated formats( *.pdf, *.xls, *.txt) Extensively used PL/SQL (Stored procedure, functions, packages, triggers, Bulk operations, Ref Cursors and Collections) Created the test cases and project deliverable templates and standards, step wise detail proces 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 Inventory, Pricing Modules, Merchandise Modiles, File Maintenance. Written the Interface Stored Procedures for Data Transformation Developed procedures using Dynamic SQL, UTL_FILE. Done the documentation and provided on-site production support. Show less 1. LPL Financials - San Diego, CA 2. Tomax Retail - Salt Lake City, UT Performance tuning, SQL tuning of Stored procedures and functions. Responsible for Oracle Plsql coding, testing and UAT test notes. Involved in technical specification writing, design documentation and analysis. Technical and functional knowledge of the Oracle APPS Modules (OE, INV, PUR, RETAIL CHAIN MANAGEMENT AND CASH MANAGEMENT) Expertise in creating matrix reports, generating designated formats(… Show more 1. LPL Financials - San Diego, CA 2. Tomax Retail - Salt Lake City, UT Performance tuning, SQL tuning of Stored procedures and functions. Responsible for Oracle Plsql coding, testing and UAT test notes. Involved in technical specification writing, design documentation and analysis. Technical and functional knowledge of the Oracle APPS Modules (OE, INV, PUR, RETAIL CHAIN MANAGEMENT AND CASH MANAGEMENT) Expertise in creating matrix reports, generating designated formats( *.pdf, *.xls, *.txt) Extensively used PL/SQL (Stored procedure, functions, packages, triggers, Bulk operations, Ref Cursors and Collections) Created the test cases and project deliverable templates and standards, step wise detail proces 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 Inventory, Pricing Modules, Merchandise Modiles, File Maintenance. Written the Interface Stored Procedures for Data Transformation Developed procedures using Dynamic SQL, UTL_FILE. Done the documentation and provided on-site production support. Show less

    • India
    • Software Development
    • 1 - 100 Employee
    • Sr Oracle Developer
      • Aug 2009 - Jul 2010

      • 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 • Created and assigned users, profiles, privileges, roles etc according to the hierarchy levels • Designing Forms 10g and Reports 10g, implementing them and uploading them. • Using java Beans in the forms 10g designing and Created new java jar and java applications for forms 10g. • Expertise in… Show more • 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 • Created and assigned users, profiles, privileges, roles etc according to the hierarchy levels • Designing Forms 10g and Reports 10g, implementing them and uploading them. • Using java Beans in the forms 10g designing and Created new java jar and java applications for forms 10g. • Expertise in creating matrix reports, generating designated formats( *.pdf, *.xls, *.txt) • Used TOAD, PL/SQL developer tools for faster application design and developments • Participated in the full software life cycle. Environment: Oracle 10g (Database), Oracle 10g (forms 10g, Reports 10g ), PL/SQL, SQL Plus, TOAD 9.1, Microsoft VSS, Windows 2000/NT/XP Show less • 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 • Created and assigned users, profiles, privileges, roles etc according to the hierarchy levels • Designing Forms 10g and Reports 10g, implementing them and uploading them. • Using java Beans in the forms 10g designing and Created new java jar and java applications for forms 10g. • Expertise in… Show more • 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 • Created and assigned users, profiles, privileges, roles etc according to the hierarchy levels • Designing Forms 10g and Reports 10g, implementing them and uploading them. • Using java Beans in the forms 10g designing and Created new java jar and java applications for forms 10g. • Expertise in creating matrix reports, generating designated formats( *.pdf, *.xls, *.txt) • Used TOAD, PL/SQL developer tools for faster application design and developments • Participated in the full software life cycle. Environment: Oracle 10g (Database), Oracle 10g (forms 10g, Reports 10g ), PL/SQL, SQL Plus, TOAD 9.1, Microsoft VSS, Windows 2000/NT/XP Show less

    • IT Services and IT Consulting
    • 200 - 300 Employee
    • Sr Oracle Developer
      • 2006 - 2008

      Design and develop packages, Triggers, views, procedures, functions. Solve the performance issues. Solve the production Tickets in the given time. Worked on the design and development of CORE Loans Consumption Process, and the Reporting Package adhering to the Business Requirements Thoroughly analyzed the upstream process and came up with the design and the plan for the Error-handling mechanism, which serves as a Admin Maintenance package. Held Meetings and worked with the… Show more Design and develop packages, Triggers, views, procedures, functions. Solve the performance issues. Solve the production Tickets in the given time. Worked on the design and development of CORE Loans Consumption Process, and the Reporting Package adhering to the Business Requirements Thoroughly analyzed the upstream process and came up with the design and the plan for the Error-handling mechanism, which serves as a Admin Maintenance package. Held Meetings and worked with the off-shore Team closely and guided them to build the Maintenance packages Show less Design and develop packages, Triggers, views, procedures, functions. Solve the performance issues. Solve the production Tickets in the given time. Worked on the design and development of CORE Loans Consumption Process, and the Reporting Package adhering to the Business Requirements Thoroughly analyzed the upstream process and came up with the design and the plan for the Error-handling mechanism, which serves as a Admin Maintenance package. Held Meetings and worked with the… Show more Design and develop packages, Triggers, views, procedures, functions. Solve the performance issues. Solve the production Tickets in the given time. Worked on the design and development of CORE Loans Consumption Process, and the Reporting Package adhering to the Business Requirements Thoroughly analyzed the upstream process and came up with the design and the plan for the Error-handling mechanism, which serves as a Admin Maintenance package. Held Meetings and worked with the off-shore Team closely and guided them to build the Maintenance packages Show less

Education

  • UCSD
    PMP Certification, Information Technology Project Management
    2014 - 2014
  • Nagpur University
    Bachelor's degree, Computer Engineering Technology
    1999 - 2004

Community

You need to have a working account to view this content. Click here to join now