Anita Patel
*** ********* *********** **, ****** Township, NJ 08831 Email: adh4na@r.postjobfree.com Cell: 732-***-****
Summary
Experienced and versatile developer, working with large systems and dispersed teams. Skilled in systems integration, data modeling concepts, business and data analysis, migration/Extraction/Transformation/Loading of data, query writing, integration testing, problem solving leadership, team training and end user support. Worked on data intensive time critical systems. Proactive, organized, creative thinker and out of the box problem solver.
Technical Proficiency
Oracle 12c/11g/10g/9i/8i, PL/SQL Developer, TOAD, SQL, SQL*Plus, .Net, Crystal Reports, Java, Python, Mongo DB, R, XML, VMS, PRO*C, Forms and Reports 6i/4.5, MS Excel, SQL Server, Ultra Edit, LINQ Pad4, HTML, TFS, PVCS, Citrix, Erwin, MS Visio, DOS, Windows, UNIX, Autosys, JIRA, SuperPuTTY, Sharepoint
Experience
Bank of America, Pennington, NJ November 2018 - Present
Lead Oracle Developer
Working in RDR Finance (Reference Data Repository team), an ETL platform that receives, transforms, and loads data from various upstream systems into the Oracle database and follows Agile methodologies.
Create design documents, technical specification, perform data analysis, migration, and extraction/transformation/loading of data into current databases.
Analyze new requirements to be implemented and create high level documents.
Enhance the existing procedures, create new procedures or applications or jobs to accommodate the requirements.
Lead the testing team of eight members for Oracle Cloud migration for 12c.
Reengineer existing applications for enhanced performance using external tables, partitions, oracle procedures, functions, packages, Unix and Autosys jobs.
Deep dive analysis of application/jobs performance and fine tuning for parallel processing.
Created automation of the process to transfer the Lease and Payment of accounting information to Delloite Lease Controller application.
As part of real estate services, created a process to source capital projects and its associated cost and metrics data.
Integrated a decommissioned system as part of non-permitted technology, by getting Involved in design, data modeling, development, integration testing and implementation.
Support production teams for data analysis, massaging, and recreation of issues for root cause and resolution.
Technologies Used: Oracle 12c, Toad, SQL, SQL*Plus, PVCS, JIRA, Windows, Unix, Autosys, SuperPutty, sharepoint, DMA tool
MOL-IT America Inc, Woodbridge, NJ May 2002 – Nov 2018
Mitsui O.S.K. Lines, now Ocean Network Express, is the largest Japanese Ocean carrier. They run over 700 ships carrying cargo from containers, automobiles, and natural resources.
Senior Oracle Developer Analyst May 2005 – Nov 2018
Worked in the EDI(Electronic Data Interchange) group related to developing EDI messages for one of the largest shipping conglomerates in the world.
Advocated for SDLC by engaging development teams in requirement gathering, data analysis, test data creation, creation of technical specification, copy the rest.
Created ad hoc reports and crystal reports as per business requirements.
Identified the location of a significant delay in the container tracking system through rigorous analysis and improved KPI almost immediately.
Pioneered a daily data purge routine and optimized performance using dynamic SQL, PL/SQL, DBMS_STATS, DBMS SQL, UTL_FILE, and UNIX
Elected to serve as IT lead for the design, data modeling development, and implementation of EDI Messages Booking Request, Cargo Tracking, Transport Purchase Order and Rail Billing.
Developed backend process using complex SQL queries, PL/SQL stored procedures, packages, functions, and database triggers.
Developed these batch processes with ability to run parallel copies and parallel audit logging.
Created these batch processes to deploy each process independently without stopping or impacting other processes.
To help in performance tuning, I used DBMS_APPLICATION_INFO in the processes to help identify the area of the process taking longer to execute.
Created a process to migrate data from one Oracle database to another using DBMS_XML and Unix.
Tuned backend process by Identifying and fixing transactional, threading and memory issues by using explain tables, TKPROF utility, index, optimizer hint and Oracle global temp tables.
Created comprehensive integration test strategies and plans to gather data related to database impacts, risk assessment, functional scenarios, and usability.
Worked on data intensive time critical systems like interfacing with U.S. Customs via EDI.
Gained hand-on experience in the scheduling and managing of batch processes using UNIX shell script.
Automation unix shell script with ability to multi thread on demand.
Advice team members of best practices and recommend solutions for redundant components and using new Oracle features.
Provided technical support and consultation related to the processes to the support team.
Technologies Used: Oracle 11g/10g/9i/8i, PL/SQL Developer, TOAD, SQL, SQL*Plus, .Net, Crystal Reports, XML, SQL Server, Ultra Edit, LINQ Pad4, HTML, TFS, PVCS, Citrix, Erwin, MS Visio, DOS, Windows, UNIX
Oracle Developer Analyst May 2002 – May 2005
Integrated EDI Messages such as Booking Request, Shipping Instruction, Cargo Tracking, Purchase Order, Rail Bill from Pro*C/VMS to Oracle/Unix.
Interacted with offshore development and business team members.
Created the flowchart of these messages using MS Visio, used to analyze the flow to make the new process be simpler, efficient and reusability of common components.
Created technical specification and developed backend processes using complex SQL queries, PL/SQL stored procedures, packages, functions, and database triggers.
Troubleshooting, Unit testing, bug fixing and query performance tuning.
Scheduled and managed these batch processes using UNIX shell scripts and crontab.
Created and reviewed unit, integration, UAT test plans and scripts, executed the tests and analyzed the results.
Migrated few frontend forms and reports from 4.5 to 6i
Technologies Used: Windows 95, UNIX, Oracle 8i, Pl/Sql8i, Forms and Reports 6i/4.5, SQL*Plus, PL/SQL Developer, Toad, SQL, SQL*Plus, PVCS, Windows, Unix, Pro*C, VMS
Education and Certifications
Bachelor of Science
Diploma in Computer Management
Certification in Oracle Financial 10.6sc
Scrum certification
Training Courses in .Net, C#, Mongo DB, and Python