Oracle PLSQL for sales tax calculation and reporting.Nielsen viewership Big Data processing and streaming with Apache Spark .Data processing with Python .Apache Airflow for scheduling workflows.MapR /HDFS Administration and Hadoop Development.Unix.Oracle AdministrationData Analysis using HiveAWS S3 Bucket Administration.CI/CD.Docker

Integrate SalesForce CRM with Oracle /Oracle Apex.PLSQLProduction Support

* Reversal Loader support for reversing bulk transactions and activities* Data Architect responsibilities.* Quality Assurance* Create stored procedures, Triggers , packages , functions to implement business features.* Interacted with business for gathering specifications and requirements.* Created logical data model using ER Studio.* Database design and implementation of Database objects.* Prepared the Impact Analysis document and High-level design for the requirements.* Performance tuning using AWR ,Explain Plan, SQL*Trace, TKPROF.* PL/SQL code reviews, Data load automations and job scheduling using control- M.* Supported migration activities, Export/import of data.* Resolved deadlocks & contention issues.* Rebuilt indexes when needed to avoid fragmentation and improve performance, monitored index usage and removed unused indexes.* Handled the Onsite coordination of enhancements to applications.

* Project entails working on Cerner’s Data Warehouse tables in an Oracle environment by using Cerner's proprietary Metadata Builder and created queries and interactive analysis reports through Cerner's DA2 (Discern Analytics 2) and Business Objects by also creating new Logical Views, Business Views and Business Domains for Coding Activity, Case Mix, Census, Patient A/R Summary, RVU Daily and Monthly Summary, and Adjustment Daily and Monthly Summary domains.* Use of HP Quality center for quality assurance testing and post-migration component validation.* Review and Approve Specification Design Input documentation and complete Technical Design Output documents.* Work collaboratively with offshore team in efficient delivery of projects in a timely fashion.* Present demos of completed projects to and discussed related issues with peers and leadership.* Complete web-based and instructor-led technical, industry, security and safety training modules and knowledge transfer sessions especially in conforming to HIPPA laws on handling information.* Agile/Scrum methodology processes is the software development life cycle model for delivering tasks and projects.

* Interacted with business for gathering specifications and requirements.* Created logical data model using ER Studio.* Database design and implementation of Database objects.* Prepared the Impact Analysis document and High-level design for the requirements.* Performance tuning using AWR ,Explain Plan, SQL*Trace, TKPROF.* PL/SQL code reviews, Data load automations and job scheduling using control- M.* Supported migration activities, Export/import of data.* Resolved deadlocks & contention issues.* Rebuilt indexes when needed to avoid fragmentation and improve performance, monitored index usage and removed unused indexes.* Handled the Onsite coordination of enhancements to applications.

* worked on stored Procedures and Triggers for building an efficient DataWarehouse* Worked on Composite (In-house tool) for data analysis.* Created Database objects using MS-SQL Developer.* worked on OLAP /OLTP/Star Schema and Snow Flakes tables in Informatica.* Created / Modified reports by modifying existing Business Objects Universe and regenerating adhoc reports for business use.* Created Mock-up designs for Dashboard team using Business Objects Xcelsius tool.

• Involved in the Migration from Oracle 9i to Oracle 10g & also involved in the Implementation and production Support of the system• Worked with analysts, users, and other IT technical professionals to understand requirements.• Supported technical teams involved with ORACLE issues and operations.• Responsible for unit testing and documenting the test results.