Unnikrishnan Vallath K

Senior Software Engineer

Macy's Technology•  September 2021 - Present

Role Description: With the primary role as a Senior Software Engineer, I am responsible for the Analysis, design, development, and integration of customized Data conversion and integration modules for new implementations for Macy’s Technology (MTech). This is a new implementation of an Oracle ERP (MFCS) product. • Designing and building of Oracle and DB2 solutions - SQL scripts, procedures, and other DB components to Extract, Transform and Load large data volume for a high-volume transaction application. • Prepare data files for conversion in the required template as prescribed by the MFCS Oracle application. • Deployment and maintenance of builds across Oracle and DB2 services in the DEV, QA, SIT, and STG environment. • Data analysis and reporting. • Identify areas for automation and write scripts to ease manual processes. • Providing support to various application teams to resolve issues and help teams with the integration of applications during the builds across environments. • Planning, tracking, change control. • Translating customer requirements into formal requirements and design documents, establishing specific solutions including programming and testing. Environment: Oracle, DB2, MFCS

Senior Software Engineer

Verizon•  March 2019 - September 2021

Employer: Pyramid Consulting Inc. Client Verizon Wireless Role: Database Developer Role Description: With the primary role of a Senior Software Engineer (Database), I am responsible for the Analysis, design, development, and integration of customized database solutions for new implementations as well as the maintenance. The application is supported by Oracle databases hosted on AWS servers. Some of the other responsibilities include • Build SQL scripts, procedures, and other DB components to support large data volume applications ensuring top-notch performance and accuracy. • Responsible for generating data metrics and identifying new areas of monitoring that can aid in maintaining the system stability and proactively identify areas of concern. • Validation and verification of production data and services to ensure the smooth functioning of applications. • Fine-tune SQL queries for performance improvement. • Extensive data analysis and reporting. • Designing and building Oracle solutions and supporting batch routines. Deployment and maintenance of builds across Oracle services in the DEV and QA environments. • Designed DB structures based on Normalization and De-normalization concepts to reduce data redundancy and integrity without impacting the performance of the system. • Design, build, and maintenance of Unix scripts and ESP batches. Monitor and manage the ESP jobs in the CA Workload Automation tool. • Identify areas for automation and write scripts to ease manual processes. Developed frameworks to automate redundant tasks to minimize manual effort and workarounds. • Created Tableau dashboards and visualizations and worked with the team on queries and frameworks to support the dashboards and alerts. • Providing support to various application teams to resolve issues and help teams with the integration of applications during the builds across environments. • Planning, tracking, change control. • Establishing a Quality procedure for the team and continuously monitor and audit to ensure the team meets quality goals. • Environment: Oracle, Unix, CA Workload Automation, Tableau, Kibana, VB Macros (Reports), Python (Beginner)

Senior Software Engineer

Macy's Technology•  November 2017 - March 2019

Employer: Pyramid Consulting Client: Macy's Technology Role: Senior Software Engineer Role Description: With the primary role as a Senior Software Engineer, I am responsible for the Analysis, design, development, and integration of customized Database solutions for new implementations as well as upgrades for Macy’s Technology (MTech). I also supported Mainframe components as and when required by the team. • Designing and building of Oracle solutions - SQL scripts, procedures, and other DB components to support large data volume and high-volume transaction application • Deployment and maintenance of builds across Oracle and Mainframe services in the DEV and QA environment. • Design DB components to support dashboards and alerting to support real-time monitoring. • Data analysis and reporting. • Identify areas for automation and write scripts to ease manual processes. • Providing support to various application teams to resolve issues and help teams with the integration of applications during the builds across environments. • Planning, tracking, change control. • Translating customer requirements into formal requirements and design documents, establish specific solutions including programming and testing. • Establishing a Quality procedure for the team and continuously monitor and audit to ensure the team meets quality goals. • Supported Mainframe solutions for technical and functional issues. • Environment: Oracle, Mainframes, COBOL, DB2, JCL, CICS, WebSphere MQ, JBoss, Splunk, Kafka, Kariba, VB Macros (Reports), Unix

Business Analyst II (Oracle PL/SQL)

The Coca-Cola Company•  February 2017 - November 2017

Employer: Pyramid Consulting Inc. Client: The Coca-Cola Company Role: Business Analyst II (Oracle PL/SQL) Role Description: As a Business Analyst II, responsible for Analysis, design, development, testing, and implementation of customized Oracle conversion modules to work in conjunction with the Pentaho Data integration tool utilizing the functional and technical expertise in a large volume database application. • Working directly with customers, functional consultants, and integration consultants to establish conversion approach, complete migration of configuration, and to complete the data conversion/load of customer data into Workday. • Understanding the technical data conversion issues, expertly resolve issues, and communicate solutions. • Design Pentaho data integration mapping to work with the Database components to extract and transform data into the required template and load data into Workday. • Design and code DB components to translate the data into the required template. Ensure the design handles the high volume of data and it is performance-oriented to ensure the SLAs are met. • Provide functional expertise in one or more Workday functional areas (e.g., HCM, Absence, and Payroll) • Assisting customers with their data extract, explaining the conversion process, defining data requirements, and working with them to correct data in their legacy systems and prepare for the data conversion. • Environment: Peoplesoft, SAP, Oracle, Salesforce, Netsuite, Taleo, Workday, Pentaho Data Integration

Senior Software Engineer

Macy's Technology•  December 2009 - February 2017

Employer: IBM Client: Macy's Technology Role: Senior Software Engineer Role Description: With the primary role of Oracle Developer, I am responsible for the Analysis, design, development, and integration of customized database solutions for new implementations as well as upgrades for Macy’s Systems & Technology (MST). Having Mainframe as a secondary skill, I was also in charge of maintaining the Mainframe codebase of the application. I have handled multiple roles and responsibilities like Technical Designer, Technical Team Lead, Senior System Engineer, Developer, and Support as and when required across various projects. • Being a time-critical application, there is a conscious effort to create and maintain builds that are fine-tuned and are best in terms of response time. Was critical in maintaining the application across new components and newer builds • Responsible for designing the best tailored high-quality database solutions for the various new and complex business requirements • Responsible for leading and guiding a project team in delivering high-quality solutions to our customer in the Retail sector • Solely responsible for designing and building Oracle solutions as part of various business requests • Worked on supporting the application with SSIS processes with the queries to support the data migration to their system. Worked closely with the SSIS developers to ensure the data transformation is smooth and the execution time meets the SLA. • Was part of the SME team to support the application for any production environment issues • Took constant effort to identify areas with scope for automation and write scripts to ease out the process • Independently responsible for setting up and onboarding new teams to the account to the point where they can work independently with an on-shore coordinator • Part of the “firefighting” team who were expected to maintain good rapport with the client and identify any issues with the technical team beforehand and proactively work on resolutions to avoid escalations • Responsible for the deployment and maintenance of builds across Java, Oracle, and Mainframe services in the Dev and QA environment • Responsible for providing support to the various application teams to resolve issues and helping the teams with the integration of applications during the newer builds of the application across environments • Responsible for planning, tracking, change control, aspects of the project • Was also responsible for designing and building Mainframe solutions as part of various business requests. The changes include COBOL Batch modules, CICS routines, JCL, DB2 Queries, and also CICS programs that can be integrated with other programming languages via SOAP requests. • Took up assignments from performance and automation testing teams to support them during resource crunch situations. Developed various scripts with HP Unified Functional Testing and Parasoft SOAtest tool for various web services automated testing. Developed scripts for performance testing an Active Space Application and monitored and created reports as part of the test. • Responsible for effective communication between the project team, the onsite team, and the customer. Provide day to day direction to the project team and regular project status to the onsite team. • Translate customer requirements into formal requirements and design documents, establish specific solutions, and leading the efforts including programming and testing that culminate in client acceptance of the results • Utilize in-depth knowledge of functional and Technical experience in Mainframes and other supporting products and technology in conjunction with industry and business skills to deliver the best solutions to the customer • Establish Quality Procedure for the team and continuously monitor and audit to ensure the team meets quality goals • Was part of the team selected to engage with the client in building and proposing POC across new tools and services • Environment: Oracle, Mainframes, COBOL, DB2, JCL, CICS, WebSphere MQ, JBoss, uDeploy, Jenkins, VB Macros (Reports), Unix, Linux

Software Engineer

IBM India Pvt Ltd•  July 2006 - December 2009

Client: Telstra Employer: IBM India Pvt. Ltd. In Telstra, amongst other applications, MICA (Mobile Integrated Customer Accounts) is one of the most important applications as it is related to the core functions like Service Activations to Deactivation, Product Provisioning, Call Pricing, Billing, Commissions to Dealer, etc. for GSM services. This system is a mainframe application built using AllFusion: Gen (COOL: GEN) and COBOL with DB2 as the database. • Analysis, development, unit testing, and defect support of customized mainframe solutions for new implementations and upgrades throughout the MICA Application. • Provided technical and investigative support for system testers and other functional users on interfaces, defects, change requests, debugging issues, testing, and ad-hoc report requirements • Solely responsible for building and delivering the bill message requests from the client • Environment: Mainframes, COBOL, JCL, CICS, WebSphere MQ

University of Mysore

Computer Science, MS•  September 2006 - December 2010

Degree: MS (Tech) in Computer Science and Technology CGPA: 3.29 (out of 4.0)