Sathishkumar Jayaraj Email & Phone Number

Peterborough, England, United Kingdom

Jaguar Landrover, Gaydon, United Kingdom

• Technical Environment: Oracle DB, Java, SQL Developer, legacy applications in SQL server and Oracle, XML
• Performed analysis of existing consumer applications and identified the data objects in scope.
• Decoded the existing legacy design and created mappings without documentation.
• Documented the functional and technical requirement specifications and Data migration design.
• Conducted mapping workshops with diverse functional teams and Business Analysts and create Data Mappings.
• Created and managed Data Models, Database and application tables for the application.

Marks & Spencer, London, United Kingdom

• Technical Environment: IBM Datastage, IBM DB2, MS Azure, Mainframe, Linux, Shell Scripting, JSON, XML, Control MIntegration Architect in a large digital transformation program integrating data from Microsoft Azure.
• Analysed existing consumer applications and identified the data objects in scope.
• Created complex integration wiring diagrams involving all impacted applications.
• Decoded the existing design without documentation and prepared Attribute mapping document and Data mapping documents in Confluence portal.
• Conducted design workshops with development team for build and support testing and implementation of Datastage flows.
• Analysed and redesigned old Datastage server jobs and parsed and created JSON messages for MS Azure services.

Marks & Spencer, London, United Kingdom, Chennai India

• Senior Solution designer for several data integration projects in Marks and Spencer in the areas of Supply Chain and logistics, Multi-Channel Ordering, BI and Reporting.Technical Environment: IBM Datastage, IBM DB2.
• Involved in requirements gathering, technical design and preparation of Interface Functional Specification for approval by architecture board.
• Lead a Datastage team of 8 members at onsite/ offshore.
• Coordinated with developers / testing team and business team in build and testing phases.
• Reviewed Datastage ETL jobs for QA and performance tuning.
• Coordinated with Data team for go Live rehearsal and cutover planning.

Qantas Airways, Chennai Area, India

• Datastage Upgrade Lead for a project to migrate from Ascential Datastage 7.5 to IBM Datastage 11.3
• Migrated complex applications in short span of time.
• Redesigned existing jobs from windows environment to UNIX environment.
• Created Test design and approach for migration testing (Sandpit and Production)
• Converted Windows batch scripts to Unix scripts and server jobs to Parallel jobs for performance improvements.

Marks And Spencer, Chennai Area, India

• Senior ETL developer leading a team of 6 members for Datawarehouse, Data Migration projects in Marks and Spencer.Technical Environment: IBM Datastage, IBM DB2, IBM WCS,IBM WMB, MQ, MQFTE, Control M, XML
• Designed and developed Datastage ETL jobs, Database Objects for Enterprise Data warehouse and Data Mart
• Coordinated with developers to develop ETL jobs and onsite team for requirements.
• Prepared UNIX scripts and Control M flow.
• Reviewed ETL jobs, QA and performance tuning.
• Prepared High-level Blueprint for Amazon to IBM Sterling OMS Data migration strategy.

Office Depot Inc. Chennai Area, India

• Datastage Developer in Office Depot Inc.
• Solving issues in DataStage jobs and sequences and modifying Datastage jobs for enhancements.
• Performance and Query tuning in Teradata V12. BTEQ Scripts.
• Execution of Teradata BTEQs from Mainframe through JCL.
• Test Case design, documentation and Unit testing of all enhancements.

Target Corporation, Chennai Area, India

• Datastage Developer in Target Corporation. USA.
• Design and Developed Datastage jobs for fact and dimension tables of EDW
• Unit testing of Datastage jobs and flow.
• Test data preparation and test data load, fixing of system testing defects in EDW and Data Marts.
• Reviewed Master test plan and Business Rules.
• Designed and developed SQL database for Vendor Management Module.

Master Of Engineering - Me, Software Engineering, First Class Distinction

Bachelor Of Engineering - Be, Computer Science And Engineering, First Class Distinction