- Responsible for designing and development of MDM module workflows for creation, change, extend, deletion and undeletion of golden records.- Experience in designing and building Data Manager, Data Merger, Data Quality measures, Data Cleansing and Data Enrichment strategy modules.- Design and develop Data Cleansing, Duplicate finding, Commonality check modules for Data supersede/Merge.- Improved search capabilities within MDM by consolidating multiple system database as centralized reporting tool.- Serve as a subject-matter expert for critical data assets across multiple systems.- Develop data life-cycle and governance workflows to facilitate the management of metadata.- Managed and maintained metadata repositories - Data dictionary, Golden data records, Data structuring, Data catalog, Data classification, Business Analyst Responsibilities:- Eliciting, evaluating and defining detail business requirement gathering and effort estimation.- Effectively and accurately, convert business needs into technical specifications while working with stakeholders and project team to maintain alignment with business and technical implementation plan.- Lead and Coordinate with team members in development, prioritize and implement required business MDM functionalities and inform management and relevant stakeholders regularly of project report status.- Responsible for deployment, testing and support as a lead developer as well as an individual contributor.- Strong oral and written communication skills needed to interface with customers and internal management related to complex business process issues.- Master the capabilities of the Master Data Management/Governance application and advise business users on how to most effectively use the solution with all existing processes.- Strong skills in logical/conceptual data modeling, data profiling, data standardization, validation and cleansing, data lineage.- Drive any mock testing and POC as per business requirement.

Responsibilities:- Identify gaps, analyze, and resolve data quality issues related to integrity, accuracy, uniqueness, consistency, and completeness to support business intelligence reporting requirements.- Involved in Data Modeling and Data interfacing projects, Reference Data Management in MDM tool.- Consolidating all master Data, reference data and transactional data to build Data Analytics dashboard through MDM, Power BI and customized platforms.- Collaborate with stakeholders to identify opportunities to improve data quality accuracy and defining strategy for data enrichment to ensure that data owners are accountable for data quality.- Responsible to build centralized single platform reporting and dashboard tool within MDM platform and Power BI.- Experience in designing data models and database design to build Data Analytics dashboard on transforming business raw data into measurable value for fast decision-making.- Responsible to alert and publish reports related to collecting metadata, data statistics and data profiling.

Responsibilities: - Strong Technical expertise in relational database Oracle, SqlSever (SQL, PLSQL), SSIS, SSRS- Experience in writing ETL batch jobs through SQL, PL/SQL and Shell scripting for ongoing and historical data load.- Developed SOAP and RESTful Web Services for Create, Read, Update, Delete operations for real-time data processing.- Responsible for back-end development on database which includes Data Structures, Data Access Layers, Stored Procedures, Triggers, Packages, Reporting views, Analytical views, OLAP models, scheduling batch jobs, Automate Data Mapping, writing RPA algorithms.- Tracking invalid objects, compiling and validating the invalid objects.- Strong Experience working with technologies and platforms as Oracle Apex development, Oracle ords API, SOAP and RESTful Web Services, HTML, CSS, Bootstrap, XML and JavaScript.- Analyzing, designing and developing ETL strategies and processes, writing ETL specifications, administration and mentoring other team members.- Using ETL informatica power center transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, and SQL, Lookup (File and Database) to develop robust mappings in the Analytics Dashboard.- Developing as well as modifying existing mappings for enhancements of new business data analytics/data-warehouse requirements mappings to load data into staging tables and then to target tables.- Involved in Performance tuning at source, target, mappings, sessions and system levels. Exhaustive testing of developed components.- Perform on-going tuning for application and database instances.- Analyzing database tables and schema, Collecting System statistics, Reorganizing Tables and Rebuilding Indexes.- Responsible for End to End Testing and User Acceptance test (UAT) then fixing the bugs if any.- Created and maintained different database entities included table spaces, data files, redo log files, rollback segments and renaming/relocating of data files on servers.

- Responsible for providing L1, L2 technical support and managing enterprise applications, vendor applications and in-house applications.- Experience working with cross functional teams during implementation of applications and involved in rollout activities.- Managing application webservers and releasing application changes/enhancements in all landscapes (DEV, QA and PROD).- Responsible to maintain sync in all landscapes of applications to have the same functional and technical configuration of systems.- Experience communicating with stakeholders for any new enhancements/projects and documenting technical and functional requirements.- Responsible to close any open tickets related to Incidents, changes or Problems in timely manner to maintain SLA and KPI’s- Experience in development and configuration on small changes of applications like building new reports, new fields, etc.- Processing large batches of data extraction on daily and weekly basis using MS SQL and Oracle database- Responsible for monitoring and responding to open tickets submitted through an incident management system like ServiceNow and Remedy.- Managing Java, .Net and Frontend based applications and providing support to the platform.- Experience working on database objects tables, views, stored procedures, triggers, functions to manage and resolve any technical issues.- Writing SQL Queries in both MS SQL and Oracle for any new report or dashboard requirements of the clients.- Experience creating high-level BI dashboards on Microsoft Power BI along with data modelling, DAX and Power queries.- Working closely with the development team as well as the vendor to make sure and address the issue on time.- Responsible for maintaining application windows servers and security patching using SCCM console.- Responsible for End-to-End Testing and User Acceptance test (UAT) then fixing the bugs if any.

> Database administration, installation, configuration, upgrades, patches, performance tuning, backup and recovery, production support, cloning, space management, database security> Experience in Installation and configuration of Oracle 9i, 10g, 11g, 12c on a variety of operating systems including UNIX/LINUX and Windows environment> Hands on experience in-updating from Oracle 9i to 10g (10.2.0), 10g to 11g, 11g to 12c and applied oracle patches> Extensive experience in using Korn Shell scripts for Regular backup, instance startup and shutdown and for automation> Installed Oracle 10g RAC software with ASM & OCFS2 File systems > Oracle RAC Database Administration including Installation, configuration, Analysis, Design, Backup and Recovery (RMAN) > Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts. > Co-ordinated with UNIX administrators for space managements on various servers. > Hot/Cold Backup and Recovery and Cloning of databases using RMAN with VERITAS Net Backup> Proficiency in Disk management and problem resolving techniques with a good understanding of Capacity planning and efficient usage of the disk space> Experience in complete database designing and coding / programming with Creating schema environments, Masters and Operational Base Tables (400+), Views (200+), triggers (180+), procedures 250+), cursors, synonyms, DB links, Functions, Packages

> Run and Maintain business solutions database and application servers on production, development and quality environments> Support and resolve day to day techno-functional issues and Provided 24 x 7 support on Production environment received through BMC remedy ticketing system> Oracle Middleware Fusion WebLogic 12c, End-to-End Implementation along with Clustering, HA, Load Balancing, Performance Tuning, Monitoring and Machine Cloning> Responsible for all backend development on oracle and SQL server technology which includes Data Structures, Data Access Layers, Procedures, Triggers, Packages, Reporting views, scheduling jobs, Automate Data Mapping> Tracking invalid objects, compiling and validating the invalid objects> Perform on-going tuning for application and database instances> Install, upgrade and migrate data in new oracle database releases> Designing High Availability and DR’s for the Applications to support Global regions> Performed System administration activities like creating users, Assigning Responsibilities, Profiles> Applying application and database security patches and bug-fixes> Requirement Gathering for new enhancements, design and prepare technical-functional proposals> Work with team or individual to define, prioritize, and implement selected enhancements> Collaborate with client business users to optimize their Management processes using business solution> Master the capabilities of the business applications and advise business users on how to most effectively use the solution with all existing processes, procedures, work-flow, bulk/mass transaction work flows, governance, cockpit view, search engine, dashboard, BI KPI reporting, forms and content> Inform client management and relevant personnel of project status> Drive any mock testing as per client requirement during new plant/site/regions configuration roll outs> Develop and deliver customer training, both onsite and remote

> End-End Installation/deploy/Implementation of Oracle Apex (Versions 4.0,4.1,4.2,5.0)> Deploy on Oracle Database level, Stand alone mode and using apex listener2.xx> Enrolling and deploying Apex with Oracle WebLogic Server> Experience with Apex administrator (User Authentication, Application builder, Application rollouts, Export and Import)> Develop RESTFul JSON web services (ords)> Design and Develop Management level Dashboard applications for multiple clients> Worked more than 12 Apex Application projects as developer some of them includes following business applications - Flexi Time - E Learning - HR Management System - Time-sheet System - KPI reporting system - SRS Application – Ticketing tool - E-Leave application - Dash Board Reporting Application - Self Service online Application> Develop Forms,Reports, Interactive Reports, Dynamic actions, Processes and maintaining the look and feel of the applications> HTML, CSS> Trouble shooting of any application errors

Oracle Middleware Fusion WebLogic Administrator on Production, Quality and Development environments for Multiple Clients.> End-to-End Implementation along with Clustering, HA, Load Balancing, Performance Tuning, Monitoring and Machine Cloning> Applying security patches and bug-fixes> Performance tuning and health checkup and take necessary actions for better performance> Integration with Web server> SSL configuration (including CA certificate installation)> Creating new domain, Managed instance and Node manager> To interpret JVM logs, Trace logs, GC, native logs, java core, thread dumps> Clear understanding of GC (Generation of young, tenured and Perm), JDBC connection pooling, and thread pools, JVM Heap

Part of Research and development team and was responsible for application back-end database design along with complete UI.Worked on technologies : Oracle, SQL Server, Oracle Apex, Oracle EBS, JSP, HTML5, CSS, Bootstrap, Web Services, XML, JavaScript, JQuery, WebLogic, Apache, JBoss