Jul 2021 – Sep 2022 · 1 yr 2 mos · Bengaluru, Karnataka, India · Remote

• My role involved gathering requirements, identifying bottlenecks, and converting them into a Functional Design Document. Furthermore, I was also involved in the architecture and designing solutions around the requirements and identifying the pain points / functional requirements in various components of the application. Additionally, I was involved in developing data models, detailed level design, process flow diagrams, and performance tuning of Oracle queries, procedures, and packages. My role also involved altering and enhancing existing Oracle PL/SQL components to support the application and its data transformation capabilities, as well as designing the flow of data from the source system to the staging layer and DB tables, along with the design of the distribution logic. I used “wget” / “curl” to connect to a web service to download data into a flat file and load it into Oracle DB using SQL LOADER, and developed various UNIX shell scripts to ensure proper file validation was carried out before passing them to Oracle DB for processing. Additionally, I was involved in developing new UNIX shell scripts and Oracle packages to replace the current implementation of Informatica components and ensuring proper unit testing, integration testing, and UAT with Business.

Dec 2020 – Jun 2021 · 6 mos

• Worked as SAP Data Migration Consultant using Syniti ADM Tool and DSP platform.
• Have executed the rollout of the Global template to Countries in scope including Local Requirement Gathering, Design, Build, Test, Cutover, and Production Go live.
• Have worked on SAP Data cleansing & Data Governance, Profiling, Harmonization and Migration, SAP Cutover Planning, Data Analysis, Business Consulting, and Project Management roles, with a dual emphasis on business and project management and technology.
• Designed appropriate data migration solutions including, transformation routines, designing and Building the DSP staging area, Loading source files into the staging area, Design, Building, and testing transformations, Building data quality rules and scorecards Generating data in target templates for the load.
• Worked on SAP FICO, SAP ERP Landscape, data integration methods, SAP Load programs creation example LSMW, and loaded Master and transactional objects and their dependencies.
• Validated Pre-load and post-load validation of migration results, handle dropouts and advised on data cleansing requirements.
• Generated the reports using SQL & PL SQL Analytical skills.
• Performed migration dress rehearsals, migration cutover tasks, and post-go-live support.
• Provided advisory services to the business to understand their data management issues and advise on appropriate data management strategies and techniques.

Mar 2017 – Dec 2020 · 3 yrs 9 mos

• I worked as a senior PLSQL developer and was involved in the development of various backend client models and applications. My role involved the backend development of a customized model of one of the primary client applications called RMS. I also worked as an Oracle Fusion HCM Techno-functional, involved in the HR requirements analysis and development of customized reports and HCM extractions, along with report generation using BIP.
• I used various management tools and techniques for overall development activities, such as JIRA, BitBucket, Bamboo, and DevOps. I shared my functional knowledge of the various AWS cloud aspects, and also had exposure to Python fundamentals for the project. I also scheduled the batch jobs using Unix Shell Scripting and AUTOSYS. I was also selected to conduct SME connects for capabilities and ponder the technique of the latest Technical Aspects through Accenture’s internal Platform. Presented a whitepaper on "Email via Oracle PL/SQL Program" held by Accenture Oracle Retail Capability.

Aug 2016 – Mar 2017 · 7 mos · Bengaluru Area, India · On-site

• I had worked on various SQL and PLSQL-based technologies under Windows and Linux environments and my role as a part of the development team involved writing Stored Procedures, Functions, Exception Handling, Constraints, Triggers, Index, Views, and Inline views in oracle.
• Worked as a digital analyst responsible for the design and development of the various digital marketing aspects focusing on the marketing of products or services using internet-driven digital technologies.
• Worked on the various tools and technologies involved as Oracle SQL Developer for Database, job scheduling using UNIX Shell Scripting, iWork, and SmartFocus.

Apr 2015 – Aug 2016 · 1 yr 4 mos

Mar 2013 – Mar 2015 · 2 yrs

• I worked as a developer involved in the various developmental aspects of the three main Nike project Pillars: Nike Planning VR2, Nike Material Stabilization Release, and Nike PMD. For Nike Planning VR2, my role mainly involved querying various stored procedures for one of the backend applications of the client. I was also involved in the development and customization of PL/SQL Procedures, Functions, and packages. For Nike Material Stabilization Release, my role involved the development of PL/SQL executables, concurrent, and programs, as well as creating value sets and registering them into Oracle applications. For Nike PMD, my role focused on Demand and Supply Planning and Maintenance, using SAP APO/DP/BW, Oracle/PLSQL, and i2 SCP SCM consultant and solutions for handling Supply Planning and maintenance activities.