Jayadeva Kodenkila

Dynamic Data Migration Lead with proven success at Foot Locker, Inc., specializing in global PIM implementations and POS system support. Expert in leveraging SQL and SSIS tool to enhance data integrity and streamline operations. Excels in team coordination and problem-solving, significantly improving data processing efficiency.

Infosys Limited, 02/01/14 to present

Certified in DevOps

Z7224876, 01/10/24, 09/28/26, IOE8674587715

• Gender: Male
• Marital Status: Married

PIM Data Migration, Foot Locker, Inc., 01/01/24 to present, Syndigo PIM Implementation [Project] – The objective of this project is to implement a PIM solution globally that will offer a single source of truth, data stewardship and governance, faster time-to-market to Foot Locker. This ‘Enterprise PIM’ solution will provide Foot Locker with a tool for managing all product information, fed by buying information from Range Plan/Vendor feeds, enriched with additional buying and selling information in the tool and then fed out to downstream systems and analytics., Data analysis on the source files and requirement gathering from client SMEs and Business., Coordinate with offshore team and pass on the requirement., Attend the daily meetings with clients and cross functional teams to close the requirement gaps and defect fixes., Generate the detailed error reports and work with FL business on source data cleansing activities. POS Production support, One of the leading sports apparel manufacturers in USA, 06/01/16 to 05/31/21, MEASURE POS is an advanced analytics platform & reporting application used by the senior leadership, analysts, data scientists & planners across different geographies within the organization with the focus towards marketplace growth, inventory optimization and margin improvement. The platform offers a variety of tool sets required for analytics like Tableau, Cognos & Microsoft BI for analytics and reporting. This application helps the users look at the Point of Sales data (Sales and Inventory) for different products at different retailers and assess/plan the sales/inventory., Data analytics and proactively fixing issues by processing the data in batches., Monitoring the Weekly/Daily batch jobs in production Environment using Airflow monitoring tool., Debugging the failures occurred with the help of logs in Yarn resource manager., Tuning the resources to improve the batch performances like Increase/Decrease the warehouse sizes on AWS cloud as per the need., Use AWS S3 buckets to download and analyze the data files received from the vendors., Address various user tickets on transactional/master data by pulling Cognos reports., Debug the data issues using the SQL query that is generated from Cognos report. POS Global Onboarding, One of the leading sports apparel manufacturers in USA, 06/01/21 to 04/30/23, We worked with Account teams and GEO leads to onboard new retailers into Snowflake Database. We worked with data from more than 500 distributors., Leveraging our strategic vendors and data partners, we worked to onboard both new external retailers and internal client partners efficiently., We could setup a new data source/retailer within 3-6 weeks and handle all sized retailers. Data was loaded through the scheduled batches in Airflow. Quality testing was performed on the Master and Transactional objects loaded into Snowflake DB., We could load two years of historical data and setup the integrations for weekly or daily delivery and weekly or daily granularity., Once the retailer has been onboarded, the data was available in standard Cognos, Tableau dashboards, AWS s3 buckets and Snowflake Database. Apple Care, One of the Leading smart phone/apparel manufacturers in USA, 09/01/14 to 05/31/16, Development of Teradata procedures and DDLs: Creation of Teradata semantic load procedures, Tables and Views., Creating new logging mechanism for many ETLs in 4 major applications under health care unit., Maintenance of Autosys jobs and scheduling of Autosys jobs in production environment. Syndigo PIM, One of the leading sports apparel retailers in USA, 12/01/24 to present, Data extraction, Transformation and Load of Legacy data from different systems to SQL server using SSIS ETL tool., Co-ordinate with customer SMEs and internal teams in gathering the requirement, handle different meetings and work closely with offshore teams.

Retail POS, Snowflake, Teradata, AWS S3, Cognos, SSIS, SQL, Unix Shell scripting, Python, Windows, Macintosh (MAC OS X), Service Now, JIRA

Technology Lead US