Manisudha M.

Manisudha M.

Data Engineer Bigdata

Hyderabad , India

Experience: 12 Years

Manisudha

Hyderabad , India

Data Engineer Bigdata

12 Years

Now you can Instantly Chat with Manisudha!

About Me

  • Involved in phases of the SDLC (Software Development Life Cycle) from analysis, designing, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
  • Expert in creating complex SQL Quer...
  • Expert in creating complex SQL Queries, PL/SQL packages, functions, stored procedures, triggers, and cursors to facilitate efficient data manipulation and data consistency.
  • Experience in implementing business logics/transformations in informatica for the data transfer between source and target
  • Experience in working with HIVE and IMPALA for data extraction and cleansing process
  • Design, Develop and maintain simple to Complex tableau visualizations
  • Developed materialized views for data replication in distributed environments
  • Experience in Oracle supplied packages, Dynamic SQL, Records, PL/SQL Tables and Exception Handling.
  • Loaded Data into Oracle Tables using SQL Loader.
  • Used Insert All, Insert First for multi table inserts.
  • Partitioned large Tables using range partition technique.
  • Extensive Knowledge and working experience in ETL tools
  • Good experience on Extraction, Transformation and Load (ETL) process using PL/SQL to populate the tables in OLTP and OLAP Data warehouse Environment.
  • Experience working in fast paced AGILE environment & attended daily scrum meeting.
  • Experience with Performance Tuning for Oracle RDBMS using Explain Plan, HINTS.
  • Interfacing with clients for requirements gathering, conducting system analysis and finalizing technical / functional specifications for the project.
  • Experience with Data flow diagrams, Entity relation modeling, Data dictionary and database modeling using Database normalization techniques.
  • Strong experience in Data warehouse concepts, ETL, Informatica.
  • Assisted QA Teams for bug testing, User Acceptance Testing (UAT) & System Integration Testing.
  • Good knowledge of key Oracle performance related features, such as Query Optimizer, Execution Plans
  • Strong perseverance and diligence towards attaining challenging goals and effective time management

Show More

Portfolio Projects

Claims

Company

Claims

Description

  • Involved in phases of the SDLC (Software Development Life Cycle) from analysis, designing, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
  • Expert in creating complex SQL Queries, PL/SQL packages, functions, stored procedures, triggers, and cursors to facilitate efficient data manipulation and data consistency.
  • Experience in implementing business logics/transformations in informatica for the data transfer between source and target
  • Experience in working with HIVE and IMPALA for data extraction and cleansing process
  • Design, Develop and maintain simple to Complex tableau visualizations
  • Developed materialized views for data replication in distributed environments
  • Experience in Oracle supplied packages, Dynamic SQL, Records, PL/SQL Tables and Exception Handling.
  • Loaded Data into Oracle Tables using SQL Loader.
  • Used Insert All, Insert First for multi table inserts.
  • Partitioned large Tables using range partition technique.
  • Extensive Knowledge and working experience in ETL tools
  • Good experience on Extraction, Transformation and Load (ETL) process using PL/SQL to populate the tables in OLTP and OLAP Data warehouse Environment.

Show More Show Less

Skills

Big Data

Prudential GI (Billing and Claims Team)

Company

Prudential GI (Billing and Claims Team)

Description

  • Developing and testing models using big data tools and technologies and deploying the same in the production environment.
  • Create charts, graphs, infographics, dashboards, etc using tableau
  • Design and Implementation of various Tableau Reports and Interactive Dashboards according to specifications.
  • Extract data in Hadoop using sqoop , HIVE
  • Build the reporting sematic layers to facilitate the Self-service reporting as per business requirements.
  • Gathering and refining requirements, interviewing business users to understand and document data requirements including elements, entities and relationships, in addition to visualization and report specification

Show More Show Less

Standard Insurance (SIC)

Company

Standard Insurance (SIC)

Description

  • Created data extraction process to extract data and performed required business transformation Using PL/SQL Packages, Store procedures and functions.
  • Worked on database triggers as well as Forms triggers to implement the system requirement on field, block and forms level and insure that business logics are working on particular event.
  • Used PL/SQL built – in package and PL/SQL Collection to improve the performance of the processes.
  • Performed Loading and unloading, back up, performance and tuning activities.
  • Wrote complex SQL queries including inline queries and sub queries for faster data retrieval from multiple tables.
  • Build Jobs using Datastage tool

Show More Show Less

Skills

PostgreSQL SQL

Data Management Council- Integration

Company

Data Management Council- Integration

Description

  • Experience with merging data files coming from the customer into the existing data warehouse
  • Designing ERD and Normalization of tables.
  • Backtrack the layers to find SOR for CDE(Critical data element)
  • Implemented materialized views for the new BASEL requirements
  •  Extract vendor files and load to the data into target database using Joiner transformations
  • Integration of data which includes data scrubbing
  • Validate the mappings in INFORMATICA for the data certification process

Show More Show Less

Clear Channel

Company

Clear Channel

Description

  • Interacting with client and supervised in preparation of the technical documentation.
  • Implementation of business requirements, gap analysis, and technical specifications
  • Experience with merging data files coming from the customer into the existing data warehouse
  • Designing ERD and Normalization of tables.
  • Enhanced & modified database objects like tables, views, stored procedures, functions and triggers.
  • Created indexes and Hints.
  • Created Cursors and Ref Cursors to retrieve the required data from the tables.
  • Developed improved performance of mappings using multiple pipelines, caches, dynamic and static lookups in proper sequence
  • Used Bulk Collect and FOR ALL to insert/delete multi-row from table.
  • Ensures data quality and lineage back to the single systems record or certification scope requested
  • Testing and debugging the existing procedures
  • Develop queries using analytical functions

Show More Show Less

Adjustments

Company

Adjustments

Description

  • Created data extraction process to extract data and performed required business transformation Using PL/SQL Packages, Store procedures and functions.
  • Worked on database triggers as well as Forms triggers to implement the system requirement on field, block and forms level and insure that business logics are working on particular event.
  • Used PL/SQL built – in package and PL/SQL Collection to improve the performance of the processes.
  • Performed Loading and unloading, back up, performance and tuning activities.
  • Wrote complex SQL queries including inline queries and sub queries for faster data retrieval from multiple tables.
  • Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables.
  • Implemented transformations using Sorter, expression, normalizer.
  • Created PL/SQL Procedures, Function Packages and SQL queries of mid to high complexity according to System needs.
  • Regression, UAT and Production support
  • Participating in the daily/weekly status calls conducted with the Client/offshore/Onsite Coordinators & developers.
  • Effective knowledge sharing sessions to the development team as part of the upgrade project.

Show More Show Less

NEMIS

Company

NEMIS

Description

  • Coordinated with clients, Requirements gathering and designing.
  • Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
  • Created Indexes and sequences for faster retrieval of the visitor information.
  • Worked with Bulk Collect & Bulk Bind to improve the retrieval of multi row.
  • Implemented Join conditions, group by functions, correlated sub queries, nested sub queries.
  • Created procedures and functions for validation of transaction records into interface tables.
  • Developed PL/SQL blocks for the test data set up
  • Maintaining the quality related activities (Like Tracking the Tasks, Tracking the Defects identified in each project, Collecting Metrics at the end of each Project etc.,)
  • Involved in all Peer reviews to ensure a defect free deliverable of the Enhancement & Co-ordination with Onsite counterparts
  • Preparation of weekly project status report, defect status report

Show More Show Less

Skills

Oracle SQL

UHG-Use QA

Company

UHG-Use QA

Description

  • Preparation of Test Cases and Test Scenarios. Involved in validation of Interfaces, Extension, Reports, Letters & ID cards.
  • Preparation of Requirements Traceability Matrix, Test Scripts based on the R&D and other sources of requirements from End Users/Customer.
  • Updating test results in Test Scripts and Communication of Defect Status report to Development Team
  • Status reporting to Manager and Onsite Coordinator. Involved in reporting monthly Efforts.
  • Involved in all Peer reviews to ensure a defect free deliverable of the Enhancement & Co-ordination with Onsite counterparts.
  • Regression, UAT and Production support from offshore
  • Creating UAT & Regression Test Cases for Customers, Defect Seepage Analysis, and Internal Audits of Projects.
  • Maintaining the quality related activities (Like Tracking the Tasks, Tracking the Defects identified in each project, Collecting Metrics at the end of each Project etc.,)
  • Uploading and execution of the test cases to Rational Test Manager & maintenance of Defect Tracking sheets

Show More Show Less