POONAM KORADE

****, *********** *****, *** ****, California-95131 Mobile: +1-424-***-**** Email:acubk1@r.postjobfree.com SUMMARY

I have around 6 years of comprehensive experience in the IT industry. Expertise in all phases of the software development life cycle and Agile development methodologies.

5+ years of hands on experience at designing and configuring secured databases on Oracle and MySQL server.

I have strong expertise in Eagle STAR & PACE, which is an asset management tool.

Strong hold in the Investment Banking and Capital Markets domain.

Good knowledge of various asset classes Derivatives, Repos, Equities, Fixed Income.

Strong experience in database programming (MySQL & Oracle) and UNIX.

Experience in developing pricing interfaces of Pricing Center module.

Worked on Eagle PACE SRM (Security Reference Manager) and Eagle STAR Message Center modules.

Strong hands on experience in Eagle STAR report scheduler for generating periodic reports and send them to the various downstream applications.

Knowledge of OLAP reporting and data mart concepts used for Performance calculations.

Good understanding of ETL Processes and Data modeling concepts such as Design of the Dataflow, ER Diagrams, Normalization and De-normalization of Tables.

Experienced in creating database objects like Tables, Views, Synonyms, Sequences, Stored Procedures, Functions, Packages, Cursors, Collections and Indexes using Oracle PLSQL.

Proficient in using DDL (data definition) and DML (data manipulation) statements in Oracle SQL/PLSQL.

Effectively made use of Table Indexes, Table Partitioning, Collections, Analytical functions, Query Re- Write.

Partitioned large Tables using range partition technique.

Worked extensively on Ref Cursor, External Tables and Collections, Exception handling.

Experience in scripting using Shell and PERL scripting.

Hands on Java experience using spring framework and Oracle.

Experienced in defining and creating Technical and Functional design documents.

Working experience on Water Fall and Agile/Scrum SDLC models. EDUCATION: B.E in Information Technology from Mumbai University, India. CERTIFICATION: Oracle Certified Associate 10g (SQL and PLSQL) PROFESSIONAL EXPERIENCE

Sr. Software Developer at Avani Tech Solutions, San Jose, CA NOV 2015 - Present

Working on a workforce module of Human Resource Management application.

Implementation of core modules using Core Java backed by Oracle database.

Involved in development and testing using Junit.

Used design patterns like Factory and Singleton.

Usage of key concepts like Multithreading and Exception Handling.

Involved in design and development phase of the product’s life cycle.

Environment: Eclipse, Oracle PLSQL developer.

Sr. Software Developer at IGATE Global Solutions MAR 2014 – SEPT 2015 Client - DTCC - OMGEO, Boston, MA

Involved in design, development, testing and implementation of the database part of the application.

Developed database objects like Stored Procedures, Functions, Packages using SQL and PL/SQL in order to store and manage securities and trade level data.

Worked on Eagle STAR report scheduler for generating periodic reports and send them to the various downstream applications.

Good knowledge of various asset classes Derivatives, Repos, Equities.

Created Eagle PACE Uploaders and parameterized exporters in Eagle PACE.

Worked on PACE reports for generating monthly gross/net returns for calculating performance of security.

Worked closely with the Business Analysts to review requirements and implement solutions that add value to the business.

Comfortable working with various versioning tools like SVN etc. Environment & Tools: Oracle 9i/10g, SQL*PLUS, UNIX, SQL Developer, Toad, Accurev, Eagle Star Web panel Designer, Eagle PACE Uploaders & Exporters, SRM, Message center, STAR Report Scheduler, OMGEO CTM

Software Developer at Hexaware Technologies JUL 2013 – MAR 2014 1. Client - The Northern Trust, Chicago, IL

Involved in up-gradation activities from Eagle 9x to Eagle 12x version.

Automated several processes, which needed manual intervention and thereby could create data errors.

Worked on pricing center.

Implemented STAR web panels which facilitated the user with easy access and ease in managing the account, trades and securities data.

Created Technical specifications, Unit Test Plans etc.

Data Extraction Transformation and Loading (ETL) Using EAGLE PACE application.

Provided UAT Support using Control M which is job scheduling tool.

Working experience with File watcher jobs using Control M tool.

Worked on loading of data using Eagle STAR Message Center application.

Created Eagle PACE Up loaders and exporters.

Performed the Unit testing of the transactions in Oracle Environment .

Creation of database objects like tables, views, stored procedures, functions and packages using oracle tools like PL/SQL developer.

Used putty for logging into UNIX to perform bootstrap and checking server logs.

Worked on Perl scripts to transfer files using FTP to all the UNIX servers.

Strict adaptation of Test driven Development (TDD) approach using Agile Methodologies.

Code reviews for coding standards, performance tuning, refactoring and reusability.

Environment & Tools: Oracle 10g, SQL*Plus, TOAD, Tortoise SVN, Eagle 12.1.2, Eagle 9, Rapid SQL, Control M Job Scheduling Tool.

2. Client – Brown Brothers Harriman, Boston, MA JUL 2010 – JUL 2013

Developed pricing Exporters and Uploaders for loading the prices from various sources like Bloomberg, IDC, S&P and others.

Worked with Reporting group to facilitate reports using Front End Eagle Star web Panel.

Involved in development and enhancement of Eagle STAR Web panels, STAR reports and Report schedulers.

Migration of the web panel having old coding standards to new coding standards .

Document the whole process flow: PL/SQL packages, log files, locations, descriptions, log tables, possible error messages and process codes.

Developed packages in Oracle PLSQL to automate maintenance and back-up jobs for databases, update statistics, re-build indexes and create error log for events during data load in development and UAT environment.

Performed code review and Unit testing.

Environment: Oracle 9i/10g, SQL*PLUS, UNIX, Toad, Eagle 7.1, PLSQL Developer, Tortoise SVN, Web panel Designer, EAGLE PACE Up loaders & Exporters, SRM, Message center, STAR Report Scheduler

Contact this candidate