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!

Chat Now

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

Skills

Data & Analytics

Software Engineering

Data Modeling - 6 Years

Intermediate

Database

Others

Web Development

API Integration - 4 Years

Intermediate

Positions

Backend Developer

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

Tools

Jira software

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

Skills

Hadoop SQL Apache Sqoop Tableau Tools For Oracle Application Development - TOAD

Tools

Apache Hive Tableau

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

Tools

SQLite Visual Studio (Win)

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

Skills

Informatica SQL Teradata

Tools

Notepad++ (Win/Mac) Visual Studio (Win)

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

Skills

Informatica Oracle PostgreSQL SQL

Tools

Eclipse Visual Studio (Win)

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

Skills

Informatica Oracle PostgreSQL

Tools

Eclipse Visual Studio (Win)

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

Tools

Eclipse Micorsoft SQL server

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