Smita Kumari Email and Phone Number

•Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.•Performed data migration enforcement tasks.•Migrated database objects from Legacy oracle server to Oracle GOS server.•Coded data validation scripts to verify accuracy of the converted data.•Involved in the continuous enhancements and fixing of production problems.•Created Indexes on the tables for faster retrieval of the data to enhance database performance.•Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, TKPROF, and DBMS_PROFILER.•Created mappings using Designer and extracted data from various sources, transformed data according to the requirements.•Mappings, sessions, workflows from Development to Test and then to UAT environments.•Monitored workflows and Sessions using a workflow monitor.•Developed a generic upload process capable of handling complete Vendor data from diverse file formats like flat files, XLS, and CSV. This process seamlessly integrated with a PL/SQL-based database package and a generic job to automate the entire data processing cycle•Interaction with the End users for the Functional requirements and Design specifications on daily basis as part of Agile methodology.•Created various data extracts (ETL) based on specific user requests. Developed essential generic upload processes for tasks such as shelf-life maintenance, Purchase Order (PO) assignment, and trailer allocation, streamlining various operational workflows.•Scheduled and ordered jobs via Control-M and provided Tier I and Tier II support for all failed jobs.•Created and modified several UNIX Shell scripts according to the changing needs of the project and client requirements.•Created Tables, views, constraints, Index (B Tree, Bitmap and Function based).•Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.

•Participates in agile scrum calls for requirements grooming, design discussions, and daily stand-up meetings.•Technically leads product team engineers to mentor, review their development.•Individually willing to take complex development tasks to deliver with high quality.•Overall responsible for the code quality of product team.•Work on improving query performance for complex queries.•Good knowledge in optimization techniques of application and handling big amount of data.•Performed Data Migration between different environments using DB Links•Developed and modified Triggers, Packages, Functions and Stored Procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.•Implemented a data analytics solution that drew upon data from the data warehouse and various other valuable sources. •Fine-tuned procedures/SQL Queries for maximum efficiency in various databases using Oracle Hints, for Rule based optimization.•Spearheaded the design, development, and implementation of various automated ETL batch processes using PL/SQL and Informatica. •Wrote Unix Shell scripts to process the files on daily basis like renaming the file, extracting data from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.•Partitioned the fact table and materialized views to enhance the performance.•Created and modified SQL*Plus, PL/SQL, SQL*Loader scripts, and Data pump for data conversions.•Creating index on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables to eliminate the complexity of the large queries.•Worked on control-M Scheduler for successfully working of these validated scripts to run in daily and weekly basis.•Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.

•Engage with institute stakeholders (Directors, Physicians, Researchers and business partners) to understand the capability requirements, analyze these requirements, identify any gaps in the existing functionalities and provide appropriate suggestions for improvements in the requirements which will help in better decision making. •Involved in Technical Design and Development of Database activities related to MERCK Data warehouse and supporting business users in analytics.•Design the Workflow configuration structures for all physical objects and recommend changes on the applications through efficient statistical structures. •Involved in creating of Workflow set up for Oracle stored procedures, Packages, functions, triggers, views, collections, synonyms, and reports to support Data warehouse processing. •Developing back-end PL/SQL packages, building UNIX shell scriptsfor data migration and batch processing.•Performing troubleshooting of application workflows mal functions to do the root cause analysis (RCA) by providing the application data and providing the recommendations of the fixes. •Analyze and interpret data to understand business impact, correlations/discrepancies and alternate solutions. •Created Workflow to enable the stored procedures calls using Dynamic SQL and User Defined Functions as per the Requirement. •Proactively support product health by building solutions that are metrics driven, automated, scalable and sustainable, and relentlessly focusing on minimizing defects and technical debt. •Extensively worked in developing ETL programs for supporting Data Extraction, transformations and loading using Informatica Power Center.•Perform Proof of Concepts (POC) on existing systems and provide solutions which can demonstrate its feasibility and practical potential in our business. •Create new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.

•Participating in requirement gathering meetings, understanding BRD and ensure that all required information captured in the document for implementation.•Providing inputs for categorizing critical and non-critical requirements.•Providing inputs in designing end to end solution from a technical perspective.•Involving in the estimations for the project, perform analysis on the business requirements and prepare High Level Design and Low-Level Design.•Analysis, Designing, developing of modules using Oracle SQL/PLSQL, Forms and Reports following Cognizant Coding Standards (CCS).•Designing and Developing of UI Screens/ Prototypes using Oracle Forms. Developing complex Database Objects, Unix Shell Scripts.•Building ETL systems by creating Oracle packages, procedures, Functions, Table partitions, DataStage & Control-M jobs.•Created Data Flow Diagrams and data Modeling based on the Design Specifications.•Performed Data integrity, validation, and testing on the data migrated into the data warehouse.•Developed Informatica Mappings and Reusable Transformations to facilitate timely Loading of Data of a star schema.•Developed the Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.•Created Sessions and extracted data from various sources, transformed data according to the requirement and loading into data warehouse.•Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create robust mappings in the Informatica Power Center Designer.•Built complex SQL Queries for Business Reports. Tuning the SQL queries for performance improvement.•Providing inputs in Designing, review and approve system architecture design

•Involved in the entire life cycle of the project starting from requirements gathering to the end of system integration.•Designed and developed various PL/SQL scripts to meet the business requirements.•Designed physical and logical data models for star and snowflake schemas.•Wrote sequences for automatic generations of unique keys to support Primary and Foreign key constraints in data conversions.•Developed and modified Triggers, Packages, Procedures and Functions for data conversion and PL/SQL procedures to create database objects dynamically based on user inputs.•Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using Cursors and Exception handling.•Created and modified SQL*Plus, PL/SQL and SQL*Loader scripts for data conversions.•Identified the Entities, attributes and designed a relational database system.•Interacted with DBA to discuss database design and modeling, index creations and SQL tuning issues.•Used SQL*Loader and export/import mechanism for data migration for Bulk upload.•Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL*Loader.•Implemented PL/SQL to perform application security and Batch Job Scheduling.•Converted Data stored in flat files into Oracle tables.•Developed stored procedures using Oracle to automate the data loading process.•Involved in unit, regression, performance, and integration testing of Database jobs. •Involved in post-production process handling tickets for any production issues.