Rekha Karthikeyan
ad5qcz@r.postjobfree.com
Current Location :
Scottsdale, Arizona
** **** ***** ** ** Experience spanning across designing and developing applications in data ware housing and big data ecosystem, specialized in building ETL pipelines using Pentaho and Informatica with various data formats.
Career Summary
4 Years of experience at Clients place across the geography, collaborating directly with the client building relationships.
4+ years of managing the large teams independently to run the show for a production support and Application maintenance projects.
16+ years of experience in the shipping and logistics domain across the IT landscape of shipping domain.
Valuable experience in Enterprise Software Development – PL/SQL, Informatica, Actuate, Unix
Hands-on knowledge on Pentaho Data Integration data warehousing tool.
Expertise in development in Pentaho suite including Pentaho Kettle, Pentaho Metadata Editor, Pentaho Report Designer, Schema Workbench and Pentaho BI configuration.
In depth understanding in change data capture and Slowly Changing Dimensions (SCD).
Development of ETL processes, ETL control tables, error logging, auditing, data quality.
Experience in administration and configuring / maintenance of multiple Pentaho, Informatica and other ETL pipelines
Well versed in engaging with clients and partnership development with focused and structured communication
Managed a large team towards achieving simultaneous goals and reaching the targets by mitigating the risks arising out of uncertainty and ambiguity throughout the phases of the project.
Deep understanding of emerging technologies with focus on delivering business solutions.
Extensively involved in estimations, costing, resource management and risk management
Worked extensively in data migration project.
Worked in IBM WTX Tool for EDI landscape in logistics domain.
Extensive experience in data integration between multiple systems and various technologies.
Extensively worked in applications involving UNIX shell scripting, batch processing and various ETL tools.
Strong Implementation understanding on Relational Database management and Optimization and Tuning Techniques.
Technical Skills
Programming Languages : PL/SQL, Informatica,WTX
J2EE Technology : Spring Boot, JPA and Hibernate, JMS, AJAX,XSLT
DevOps Tools : Jenkins,
Reporting Tools : Business Objects, Actuate
ETL Tools : Informatica, Pentaho, ER Studio
Education
Bachelor of Engineering (BE) in Electronics and Communication.
Anna University India.
Personal passion on Data warehousing and Data Analytics.
Work Experience
Technology Lead
Infosys
Project :Electronic Data Interchange -AMS Dec 2022 – July 2023
Client : APL Logistics Ltd
Description:
APL Logistics Americas offers a wide range of supply chain management services. Its brand was built alongside a culture of deep customer focus and attention, and the company are known for providing flexible solutions to complex problems. It also pioneered the use of visual data analysis and offer a robust Data Management and Analytics product. The company draws customers from automotive, industrial, consumer, and retail. APL Logistics' solutions include order management, distribution and fulfillment, transportation, and customs brokerage and global trade compliance.
Role: Production Support Lead
Responsibilities:
Worked as an onsite production support lead to provide support to business users based out of North America.
Worked in WTX, Unix shell script to provide solution to client EDI requirements.
Worked with offshore team to ensure seamless bug and enhancement delivery.
Worked with business team for requirement gathering.
Built the necessary ETL pipelines to transfer larger data from various sources into central warehouse using Pentaho which includes designing workflows using Pentaho Kettle and building schema structure with Metadata Editor and Schema workbench
Established integration with multiple environments using Pentaho BI configuration.
Environment: EDI WTX, Unix shell scripting, Jenkins, GIT, Axway Cyclone,Pentaho.
Technical Lead
Infosys
Project : Electronic Data Interchange -AMS Dec 2021 – Nov 2022
Client : CMA CGM
Description:
CMA CGM is a French shipping and logistics company. CMA CGM business activities include shipping, port operation, supply chain management and warehousing
Role: Technology Lead
Responsibilities:
Worked as technology lead for AMS project. The primary responsibility is to closely interact with client and gather requirements. Work with offshore team to deliver the enhancements and bug fixes.
Review offshore team deliverables.
Worked on WTX enhancements and bug fixes.
Worked with multiple vendors for production deployment.
Environment: EDI WTX, GIT, Jenkins.
Technology Lead
Infosys Limited
Project : SeeChange March 2020 –Nov 2021
Client : APL Logistics
Description:
SeeChange is an online website that helps to work effectively with multiple vendors, carriers and modes of transport. This fully hosted, Web-based portal opens up a panoramic view into the supply chain, from purchase orders (POs), all the way to shipment delivery. It will show the time-critical data so the client can quickly respond to shifting customer demand and make the right supply chain decisions at the right time.
Role: Onsite Production Support Team Lead
Responsibilities:
Worked on data migration project estimation and execution.
Responsible for team deliverables.
Worked on performance improvement for database reports.
Worked as onsite coordinator to work with US business team to gather requirements.
Environment: Java,Informatica,PL/SQL,Actuate,Unix
Technology Lead
Infosys Limited
Project : Employee Services
Sep 2019 – March 2020
Client : Kuehne + Nagel,US
Description:
Kühne + Nagel International AG engages in the provision of logistic services. It operates through the following segments: Sea Freight, Airfreight, Overland, and Contract Logistics. The Sea Freight segment offers services through partnerships with carriers, as well as visibility and monitoring of freight movements via KN Login. The Airfreight segment relates to the air logistics solutions and streamlined visibility and monitoring via KN Login information management system.
Role: Technology Lead
Responsibilities:
Worked on Rest API data integration with oracle database using Pentaho data integration tool.
Worked closely with business team to gather requirements for Data integration and implement the same.
Environment: Pentaho Data integration, Linux, Postgres,MS SQL Server,GIT,Jenkins.
Technology Lead
Infosys Limited, Chennai
Project : SeeChange April 2015 – Apr 2019
Client : APL Logistics.
Description:
SeeChange is an online website that helps to work effectively with multiple vendors, carriers and modes of transport. This fully hosted, Web-based portal opens up a panoramic view into the supply chain, from purchase orders (POs), all the way to shipment delivery. It will show the time-critical data so the client can quickly respond to shifting customer demand and make the right supply chain decisions at the right time.
Role: Offshore Technical Team Lead.
Responsibilities:
Worked as Application and Maintenance project lead for See Change module.
Worked with clients closely to plan the monthly deliverables.
Responsible for offshore enhancement and bug fix deliverable quality.
Worked on performance enhancement of informatica workflows.
Created specifications, data diagrams and technical design documents.
Establishing Data Quality and Quality measurement process to track the consistency of Master Data.
Maintained a close relationship with business team establishing a clear communication procedure involving timely formal reports and tracking status.
Managed the onsite resources with motivation during the highly critical situations and have driven the delivery successfully during the period of uncertainties.
Owned the Risk Management
Have taken care of end to end release management
Environment: Informatica,PL/SQL,Actuate, iLog,Data Modelling tool ER Studio,Unix
Technical Analyst
Infosys Limited, Chennai
Project : SeeChange Mar 2013 – Mar 2015
Client : APL Logistics
Description:
SeeChange is an online website that helps to work effectively with multiple vendors, carriers and modes of transport. This fully hosted, Web-based portal opens up a panoramic view into the supply chain, from purchase orders (POs), all the way to shipment delivery. It will show the time-critical data so the client can quickly respond to shifting customer demand and make the right supply chain decisions at the right time.
Role: Production Support Analyst US
Responsibilities:
Onsite POC for See Change module.
Responsible for coordinating with business to gather enhancement requirements.
Responsible for resolving Production issues in application and to provide root cause for all the issues.
Responsible for monthly ticket reduction for the application.
To work with multiple teams to ensure seamless application enhancement testing and feasibility of solution study.
To work with US based bend users to understand the challenges faced by them and to translate the issue fixes to enhancement requirements.
Environment: Informatica,PL/SQL,Actuate, iLog,ER Studio,Unix
Senior software Engineer
Infosys Limited, Chennai
Project : SeeChange Apr 2010 – Feb 2013
Client : APL Logistics .
Description:
SeeChange is an online website that helps to work effectively with multiple vendors, carriers and modes of transport. This fully hosted, Web-based portal opens up a panoramic view into the supply chain, from purchase orders (POs), all the way to shipment delivery. It will show the time-critical data so the client can quickly respond to shifting customer demand and make the right supply chain decisions at the right time.
Role: Senior Software Engineer.
Responsibilities:
Involved in training the new team members.
Responsible for mentees deliverables.
Worked on Informatica parallel data processing to improve the data availability turnaround time.
Worked on PL/SQL query tuning.
Worked as deployment Manager. Coordinated with different team across different geographical locations to ensure seamless deployment.
Environment: Informatica,PL/SQL,Actuate, iLog,ER Studio,Unix
Software Engineer
Infosys Limited, Chennai
Project : See Change Jun 2006 –Mar 2010
Client : APL Logistics.
Description:
See Change is an online website that helps to work effectively with multiple vendors, carriers and modes of transport. This fully hosted, Web-based portal opens up a panoramic view into the supply chain, from purchase orders (POs), all the way to shipment delivery. It will show the time-critical data so the client can quickly respond to shifting customer demand and make the right supply chain decisions at the right time.
Role: Software Engineer.
Responsibilities:
Involved in Requirements Analysis, Estimation, Design, Coding and Testing phases of the project.
Worked in automated report generation in informatica.
Environment: SAP BO, Oracle 9i/10i/11i PL/SQL, ASP.NET, Windows Communication Foundation, Informatica 9.3, Actuate 7,8,9, Unix Batch Scripting, Java 1.6, Eclipse, IBM WebSphere, Oracle 10g, IBM Rational ClearCase.