Anita Tornala Email & Phone Number

Canada

United States

System Analysis and Design (Order Management System, Warehouse Management System)Requirements Gathering (Business Requirement Document, Project Description Specifications) Proficient in all phases of the Software Development Life Cycle (SDLC) from planning and analysis to design, implementation, testing, deployment, and maintenance, ensuring the delivery of high-quality software solutionsProblem Solving and strong analytical skills to diagnose issues and implement… Show more System Analysis and Design (Order Management System, Warehouse Management System)Requirements Gathering (Business Requirement Document, Project Description Specifications) Proficient in all phases of the Software Development Life Cycle (SDLC) from planning and analysis to design, implementation, testing, deployment, and maintenance, ensuring the delivery of high-quality software solutionsProblem Solving and strong analytical skills to diagnose issues and implement solutionsProject Management (Agile, Waterfall)Documentation – skilled in creating detailed documentation for system requirements and processesUser Training and Support Troubleshooting and Problem ResolutionProficient in writing database stored procedures, SQL, PL/SQL, T-SQL, functions, packages, triggers, SQL Loader scripts, views, and SQL Server Agent jobs using Oracle and Microsoft SQL Server. Maintenance of application software using Oracle, SQL Server Management Studio (Version 15), Crystal Reports, Oracle Forms Designer (Version 11.1.2.1.0), and Oracle Reports Builder (Version 11.1.2.1.0)Skilled in using project management tools such as JIRA, Innotas, and PVCSExperience with Automate and UNIX shell scripting.Performed DBA activities, including user creation, privilege management, and database backupsExperienced in Data Migration projectsExcellent communication skills for liaising with cross-functional teams and stakeholdersCollaborated with offshore development teams to drive successful project development Show less

Worked as a Senior Oracle Developer and Application Support in various projects for Nationwide InsuranceContributed to the enhancement and application support of the Nationwide Insurance Pension Planning Keynote applications, ensuring improved functionality and user satisfactionDesigned and implemented enhancements for Nationwide's Oracle form applications, streamlining user interfaces and processesDeveloped and optimized ad hoc SQR reports, delivering valuable insights for internal… Show more Worked as a Senior Oracle Developer and Application Support in various projects for Nationwide InsuranceContributed to the enhancement and application support of the Nationwide Insurance Pension Planning Keynote applications, ensuring improved functionality and user satisfactionDesigned and implemented enhancements for Nationwide's Oracle form applications, streamlining user interfaces and processesDeveloped and optimized ad hoc SQR reports, delivering valuable insights for internal stakeholdersResolved defects through modifications to existing processes, improving system reliability, and performance, and fixed system bugsCollaborated with users to gather requirements and develop detailed system specifications, ensuring alignment with business needsProficient with using Quality Centre and Rational ClearQuest for quality assurance and issue trackingManaged source code maintenance in Harvest, ensuring version control and documentation integrity Show less

Worked as an Oracle Developer and Application Support in various projects for Detroit Diesel Corporation in Diesel Integrated Business Systems (DIBS)Provided application support for the DIBS application, ensuring user satisfactionDesigned and developed interfaces for engine work order tracking between MTU Detroit Diesel and DDCCreated data transfer interfaces for interplant parts requirements and developed vendor scheduling reports using discovererAutomated work order transfer… Show more Worked as an Oracle Developer and Application Support in various projects for Detroit Diesel Corporation in Diesel Integrated Business Systems (DIBS)Provided application support for the DIBS application, ensuring user satisfactionDesigned and developed interfaces for engine work order tracking between MTU Detroit Diesel and DDCCreated data transfer interfaces for interplant parts requirements and developed vendor scheduling reports using discovererAutomated work order transfer and component adjustment processes for the Bridge Engine ProgramDeveloped PL/SQL packages, procedures, and Oracle reports for SOX auditsConducted testing (unit, integration, UAT) and gathered user requirements and system specificationsMaintained source code in the Source Code Control System via Telnet and provided 24/7 on-call IT support Show less

Worked as an Oracle Developer on the Mortgage Underwriting and Processing Information Technology and Mortgage Online at Interfirst projects (MUPIT/MOAI).Developed PL/SQL procedures, functions, and packages in OracleModified screens using Developer 2000Coded extracts to enhance performance and reduced execution timeModified SQR reports and used code merge tools (Beyond Compare, Diff Doc)