Sushma S

• Contributed to internal project aimed at enhancing company operations
• Primarily involved serving as ReactJS Developer, collaborated with team of four members
• Tackled various use cases provided by team and successfully developed user-friendly UI Dashboard tailored for internal company use
• Created reusable components and services which can be used in journeys and other parts of application
• Worked with different technical teams for business and technical understanding and handshake of Web/REST Services.

• Spearheaded migration and maintenance of legacy systems, concurrently leading three pivotal migrations: transitioning from DCM 12c to 19c DB, ETL migration from version 3x to 4x, and orchestrating move from AIX to Linux.

• Directing migration projects by conducting comprehensive data checks, meticulously comparing Control-M jobs between 12 and 19c, alongside adept scheduling, monitoring and management of intricate batch processing and workflows
• Executing data validations leveraging Prana framework, while proficiently crafting and managing PL/SQL Procedures, functions and packages vital for diverse business processes
• Developed MINUS database queries for meticulous data validations, ensuring data integrity and accuracy throughout migration processes
• Engaging in rigorous unit testing and debugging of PL/SQL code to uphold precision and dependability standards
• Contributing decisively to database schema design and data model development, steering seamless data migration processes using meticulously crafted PL/SQL scripts
• Improved database performance by optimizing PLSQL code and implementing best practices.
• Implemented advanced error handling techniques in PLSQL code, resulting in robust applications with minimal crashes.
• Worked closely with business analysts to translate requirements into functional specifications, ensuring alignment between technology solutions and business needs.
• Developed efficient stored procedures for seamless data retrieval and manipulation, increasing application response time.
• Reduced data redundancy by designing normalized database schema and enforcing referential integrity constraints.
• Increased application stability by troubleshooting and resolving complex PLSQL issues in timely manner.
• Maintained database documentation for accurate record-keeping and easy reference for colleagues.
• Contributed to successful project completion by adhering to strict deadlines and meeting client requirements.
• Provided technical support to end-users, ensuring smooth operations and minimal downtime.
• Mentored junior PLSQL developers, fostering environment of collaboration and continuous learning.
• Optimized existing PLSQL routines using performance tuning techniques such as indexing, query optimization, and partitioning strategies.
• Ensured compliance with industry standards by following best practices in code development, version control, and deployment methodologies.
• Participated in regular code reviews for consistent quality assurance across team's work output.
• Conducted regular database backups and recovery procedures, safeguarding valuable data against potential loss or corruption.
• Analyzed existing SQL queries to identify opportunities for improvements.
• Developed, implemented and optimized stored procedures and functions using SQL.
• Documented analysis results and provided performance improvement feedback.
• Developed reusable components for exploitation in coding and documentation.
• Managed workload independently but collaborated with colleagues to complete larger scale tasks in distributed team environment.
• Analyzed business reports for prompt communication, follow-up and ongoing support.
• Followed standard practices for migrating changes to test and production environments.

• Development tasks include generating artifact's for developing Mule flows in Anypoint Studio 7.6, adhering to naming standards for flows, and capturing necessary configuration details in config properties
• After receiving audits from clients, wrote queries in Spark SQL and run transformation queries in Athena to validate data population
• Then uploaded files to S3, make Dynamo DB entries for staging queries, transformations, and XML, and trigger APIs while monitoring jobs in AWS Glue
• Additionally, extracted data in XML format from S3 bucket, address code fixes and close assigned defect tickets while updating status in Jira
• Written Java test cases as per project requirement
• This project is Pure AWS Stack, for doing data transforms, used Glue ETL Workloads (Transforming)
• Worked in Agile environment, Participated in daily stand ups, status calls, Scrum calls and sprint planning
• Documented technical specifications and code changes for future reference and knowledge sharing
• Provided production support and troubleshooting for database-related issues
• Collaborated with cross-functional teams to gather requirements and implement solutions for database-driven applications.