09/26/2024 updated

SP
100 % available

Team Lead, Senior Associate Consultant, Senior Associate Consultant

Hyderabad, India
Worldwide
Hyderabad, India
Worldwide

Profile attachments

Satish kumar.docx

Java (Programming Language)Agile MethodologyAmazon Web ServicesBusiness SoftwareCOBOL (Programming Language)DatabasesData TransmissionsData ConversionExtract Transform Load (ETL)Data ManagementData MappingData WarehousingIBM DB2DebuggingLinuxPython (Programming Language)Microsoft SQL ServersOracle Business Intelligence Enterprise EditionOracle Data Service IntegratorOracle DatabasesOracle ApplicationsOracle SQL DeveloperPerformance TuningPuTTYMicrosoft Power BISoftware EngineeringSoftware Requirements AnalysisPL-SQLSQL DatabasesSQL Server Integration ServicesSystem TestingData Import/ExportData ProcessingDatabase PerformanceOperational SystemsReporting ToolsVerticaOracle EbusinessOracledb
Agile, Agile methodologies, AWS, business applications, COBOL, Data Conversion, data import, Data Management, data mapping, Data Manipulation, Data Processing, data transfer, Data Warehousing, data warehouse, database performance, Databases, ETL, data loading, DB2, Java, Linux, MS-SQL, Ms SQL, Windows XP, Operating Systems, Oracle, OBIEE, Oracle Data Integrator, Oracle 11g, 12C, ORACLE EBS, Oracle PL/SQL, Oracle SQL, Oracle DB, PL/SQL, PLSQL, performance tuning, Power BI, Putty, Python, SQL, SSIS, Debugging, Software Development, Requirements Definition, System Test, Reporting tools, Vertica

Experience

Professional experience10+ years
Freelancer since2019

Languages

EnglishFluent

Project history

Team Lead

Project: Digital Reality | Skills: ODI, OIC, OAC, Ms SQL, SSIS, Oracle DB
* Investigated and resolved application incidents for Technovert's clients.
* Reviewed processes to optimize system performance.
* Logged service requests with Oracle for application issues and tracked them to resolution.
* Proposed, tested, and supported solutions for client issues.
* Assisted with user acceptance testing (UAT) of proposed solutions.
* Followed client-specific change management processes for production migration.

Senior Associate Consultant

Mass Mutual
Project: Mass Mutual | Role: Data Engineer | Skills: Vertica DB, Python, Power BI, MS SQL Jun 2020 -
Oct 2020
* Analysed business rules for data transfer and transformation.
* Converted data into the target system format and ensured data accuracy.
* Utilized Analytix Mapping Manager (AMM) to scan and import source and target databases.
* Designed source-to-target data mapping and created PL/SQL procedures for data loading into
different tables.

Senior Associate Consultant

Pepsico Limited
Skills: Oracle Data Integrator 12c, Oracle 12c, PL/SQL, OBIEE 12c, PLM
* Developed ODI mappings, procedures, scenarios, packages, and Load Plans using Oracle Data
Integrator (ODI 12c) as per mapping documents.
* Loaded data into the target system and validated data accuracy.
* Managed data import and export based on client requirements.
* Maintained extensive communication with both onsite coordinator and client.

Senior Software Engineer

Project: Rogers Communication | Skills: Oracle Data Integrator 12c, Oracle 11g, PL/SQL
* Created ODI mappings, procedures, scenarios, packages, and Load Plans using Oracle Data
Integrator (ODI) to align with mapping documents.
* Oversaw the loading of converted data into the target system, ensuring data accuracy.
* Managed the import and export of data according to client requirements.
* Engaged in extensive interactions with both onsite coordinators and clients.

Software Engineer

Project: Mississippi State Aged Blind Disabled (ABD) Data Conversion Project | Skills: Oracle Data
Integrator 12c, Oracle PL/SQL, Mapping Analytix
* Analysed business rules for data transfer and transformation, validating data accuracy upon
loading.
* Utilized Analytics Mapping Manager (AMM) to scan and import source and target databases, building
source-to-target data mapping designs.
* Created complex PL/SQL procedures to load data into various tables.
* Managed error handling through extensive exception handling for debugging and error message
display.
* Involved in performance tuning and optimisation to ensure timely delivery of objects.

Project: Montana State Medicaid Data Conversion Project | Skills: Informatica 9.1, Oracle SQL, PLSQL
* Converted existing COBOL generated data into Montana Pharmacy Benefit Manager (PBM) system by
Informatica jobs.
* Translated client-provided business requirement specifications into ETL design specifications,
creating mappings, sessions, and workflows.
* Analysed requirements and coded accordingly.
* Participated in analysing, developing, enhancing, and testing various Informatica mappings to
load data from various sources using different transformations.
* Managed error handling through extensive exception handling for debugging and error message
display.

Contact form

Log in to get in touch

You need to be logged in to use the contact form.

Sign upLog in