Aparna S

Developer - 6 Years of Experience - Near 07601




Hackensack, NJ

Education Level:


Will Relocate:



Professional Summary: * Over 6+ years of programming experience as an Oracle PL/SQL and ETL Developer in estimation, Analysis, Design and Implementation of Business Applications. * Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines. * Experience working in an Agile and Waterfall development environment for Finance and telecomm projects. * Worked on all phases of Data warehouse development lifecycle, from gathering requirements to testing, implementation, and support. * Expertise in Client-Server application development using PL/SQL, MYSQL, SQL *PLUS, TOAD and SQL*LOADER. * Created and used Functions, Indexes, cursor, Table Partitioning, Collections, FORALL, BULK COLLECT, REFCURSOR dynamic SQL, Views, materialized views, Stored Procedures, indexes, Packages, Exception handling, Dynamic SQL and Triggers using PL/SQL. * Worked on Hadoop file distributing system with Python, SQOOP, OOZIE, HBASE and Hive. * Extensive knowledge of ETL including TALEND and DATASTAGE. Created number of jobs as per requirement. * Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP. * Wrote Perl and Unix Shell Scripts for scheduling jobs and executing PL/SQL objects. * Experience in DBA activity, SQL performance tuning using explain plan, query Optimizer and Cost-Based Optimization (CBO). * Modified Java script using ECLIPSE and created new class file. * Extensive experience with Microsoft SQL Server 2008 and Oracle Forms & Reports Development. * Worked on Control-M and AUTOSYS scheduler to monitor and run the ETL jobs. * Worked for report creation in PDF and Excel reporting using XML reporting tool for Oracle Database data. * Acting as POC for Application Development projects. * Experience in database modeling, Entity Relationship diagram, Normalization using Visio. * Maintaining all the documentation related to developed objects which involve a code review checklist, technical specification, unit test document, FD (functional design) checklist. * Provided support in various phases of testing (Unit testing, System testing and Integration testing, UAT). * I conducted class room trainings sessions for new joiners to share my knowledge and bring them up. * Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.