Manisudha M.

Data Engineer

Hyderabad , India

Experience: 12 Years

Manisudha

Hyderabad , India

Data Engineer

USD / Year

Start Date / Notice Period end date:

12 Years

Now you can Instantly Chat with Manisudha!

Chat Now

About Me

A bright, talented, ambitious and self-motivated software engineer with a strong technical background who possesses self-discipline and the ability to work with minimum of supervision. Having a proven ability to communicate the results to work collea...

Skills

Positions

Data Analysts

Data Scientist

Data Engineer

Portfolio Projects

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

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

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

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

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

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

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

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