Soumya Swain

Collaborate with cross-functional teams to drive product development from inception to deployment, ensuring seamless integration that aligns with strategic business objectives. Establish and maintain architectural standards and design and development practices and encourage a culture of continuous learning. Sole resource in team for ETL design and development. Key Achievements: Created multiple Informatica workflows to help business future date orders so they can test for upcoming new type of Order/Account data seamlessly. Created multiple Informatica workflows to load Route to Market orders and its related details from Teradata to Oracle. Oracle E-Business Suite Application Upgrade from 12.2.2 to 12.2.12. I collaborated with multiple interlock teams, DBAs and Oracle to ensure smooth transition to new version. Made multiple code changes to ensure all synonym references in codebase for tables/views schemas is Oracle compliant. Identified and resolved firewall issues for interlocks by working with server engineers. Successful upgrade to this version provides us with improved performance, security and stability. Designed and developed multiple pages/reports using Oracle Apex for automating creation of compensation plans which brought down plan setup time from 6 weeks to 2 weeks. Designed and developed the way ten levels of Product Hierarchy is managed in the system with integration from Finance structure data using Informatica workflows and Oracle APEX to create drill down for user to view easily, this eliminated tickets from salesreps wanting to check on detail products assigned to their sales quotas. Worked with admin team for version upgrade from Informatica 10.5.2 to 10.5.7 by assisting them with testing ensure smooth migration of service account privileges, NAS configuration etc from non-production to production. Created multiple Control-M jobs for automating Informatica workflows to be signal based. As a stretch project worked with members of various teams to make a POC of Coin flip algorithm using Quantum Computing using Qiskit, which used IBM Quantum Cloud for qubits.

Contributed to the design and development of critical software components, focusing on writing clean, efficient code in line with team standards and project requirements. Adhered to agile methodologies, managing tasks and priorities efficiently in a fast-paced environment. Sole resource in team for ETL design and development. Key Achievements: Oracle database Upgrade from 12C to 19C , worked with DBAs to ensure performance and functionality werent impacted. This upgrade provided the system with enhanced performance and security. Setup CICD for cloud and database projects using Gitlab along with security scans to help team deploy faster with ease as needed with automated CHG request creation integrated in. Worked with team to design a custom archival solution using db link and I created a dashboard using Angular which showed archive job status, archived record count along with an option to view Oracle program log. This saved the license cost of using paid archival solutions on market. Created an integration(microservice) using SpringBoot which allowed interlock team to easily create, update and assign compensation roles and groups to salesreps, this did away with manual assignment setup errors and reduced time Analysts spent to 20%. Created an integration(microservice) using SpringBoot with OAuth for security which is used to pull quota data of salesreps which is used for compensation calculation from interlock team into our system which is used for quota assignment along with mechanism to catch and handle errors on both sides, this replaced manual quota loads being done by Analysts by saving them 75% time. Improved speed by 70% of Commission calculation process by redesign dynamic queries into static one so performance is trackable using sqlids. Designed and developed Informatica workflow to load order metric JSON data from Teradata to Oracle, job processed ~100k records per day , it replaced manual loads being done by business saving them 5 hours of load each day. Created multiple signal-based scheduling jobs using Control-M for automating workflow runs removing manual interaction.

Participated in the development of software solutions, writing and testing code to meet established standards and requirements while maintaining a focus on creating reliable and maintainable code. Contributed to process improvements and adopted best practices within the team to enhance efficiency and software delivery. ETL design and development. Key Achievements: Developed Informatica workflows to load Account data of Orders from Teradata into Oracle , job processed ~100k records per day to be used in compensation calculation, it replaced manual loads being done by business saving them 3-4 hours of load each day. Created multiple OAF Pages for Uploads which provided business with the flexibility to do ad-hoc data loads for immediate fixes. Created an automated process to assist with reprocessing of Commission calculation for reps with issue with minimal system interaction from business, this replaced manual order adjustment being done by Analyst saving them 2 hours for each run. Using PLSQL Automated Credit/Debit Memo child order to have Order Based Adjustment if parent order has it for correct Commission calculation doing away with manual business fixes for such orders reducing their system interaction time of 10+ hours of manual fixes each week. Created a concurrent Program to Purge/Truncate tables passed to it based on date parameter which removed the need for manual purge/truncate activities and could be scheduled for ease. This automated process saved Business 30 days of SD development effort per year. Created a dashboard for submitting and monitoring scheduled Oracle concurrent requests week wise in Angular using TypeScript which helped business check program progress/status , this provided easy access to check multiple program statuses at once.