senior developer

APARNA SHARMA I 469-***-****

***************@***.***

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 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.

Technical Skills:

Databases

Oracle 9i/10g/11g,MS SQL Server, UDB DB2,MS Access, Vertica DB

Scripting

SQL, PL/SQL, UNIX Shell Scripting, HIVE,Python,Perl

Operating System

Windows 2000/NT/XP/7/98/8, OS X and UNIX

Query Tools

TOAD,SQL Developer, SQL Navigator, SQL* Plus, PL/SQL Developer, Talend,Datastage,AION

Other Tools

SQL*Loader, MS Office(Word, PowerPoint, Excel, Visio), SVN,FEX 50, Control M, Autosys,GEM,CQ,SMS

Projects Summary:

Client: TEK-Sync Jan 2016-Mar 2017

Role: Oracle PL/SQL Developer

Location: New Jersey

Project & Assignment Description:

Project Deals with generating reports for customers having all the information about subscription and sales using XML tools which will extract data from Oracle Database.

Responsibilities:

Responsible for processing the data and generating reports for customers in PDF and XLS using XML reporting tool which will take the data from ORACLE database.

Includes in working for Application development and maintenance.

Developing the objects in PLSQL like packages, procedures, triggers, views, functions and indexes based on functional description to process the data.

Extensively used Joins and sub-queries for complex queries involving multiple tables.

Development of new shell scripts for data loading triggered by CONTROL M.

Loading of XML and CSV files using TALEND ETL tools and SQLLOADER.

Understanding the issue faced by client and reply with a satisfactory explanation within the first response SLA.

Wrote PL/SQL Packages using dynamic SQL to populate data into tables from fact and dimensional tables for XML reporting purpose.

Monitored performance and changed performance requirements through application of Database tuning and performance optimization techniques.

Worked under tight schedules for successful development and implementation

Client: Bank of America Apr 2014 – Nov 2015

Role: Senior programmer

Location: Bangalore, India

Project & Assignment Description:

This project deals with extracting credit risk elements from Bank’s database for credit cards and send feeds to a data warehouse. Performing data quality checks on the file feeds sent to the downstream systems

Responsibilities:

Involved in understanding of business processes and coordinated with business analysts to get specific user requirements.

Involved in creating specifications for ETL processes, Managed changes to the project scope, project schedule, and project costs using change management procedures.

Designed, Developed, Configured and deployed data stage jobs, scripts and AUTOSYS GIL.

Worked on Data Stage tools like Data Stage Designer, Data Stage Director and Data Stage Administrator.

Used Enterprise stages like Datasets, Change Data Capture, Row Generator and many other stages in accomplishing the ETL Coding.

Extensively used Data Stage for parallel processing, extracting, transforming and loading databases from sources including DB2 and Flat files.

Created and modified python Script to read Hadoop Data File and load that to HIVE tables.

Involved in creating Hive tables, loading with data and writing hive queries which will run internally in map reduce way.

Created indexes on the tables for faster retrieval of the data to enhance database performance.

Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

Client- SFR

Company: ACCENTURE Apr 2012 – Mar 2014

Role: Senior programmer

Location: Bangalore, India

Project & Assignment Description:

Project Deals with the Sales and Subscription and is divided in different domains. In this project, I worked with Backend application related to commissioning of distributors.

Responsibilities:

Created PL/SQL objects to implement business rules and load the data into Oracle DATABASE using ETL and SQL Loader.

Created Unix shell scripts which will be triggered by Control M to validate the files, data and execute all PL/SQL objects

I was involved in processing of XML files (around 1 GB size) where data is extracted from heterogeneous data sources, formatted and loaded in Oracle Database using ETL tool TALEND.

Execution and processing row data, using Java. Modified Exported job from Talend as Class code (in a jar File), and Source Code (in Java file), context property files.

Performing one-off pieces of logic using tJava

Setting the context and globalMap variables using tJava,Adding complex logic into a flow using tJavaRow,

Creating pseudo components using tJavaFlex.

Importing JAR files to allow use of external Java classes.

Experienced in creating job schedule for control M using FEX 50 tool.

Responsible for code configuration management using Tortoise SVN and Defect Tracking /Reports by Rational Clear Quest.

Client: Maples Esm technology

Jan 2011– Feb 2012

Location: Chennai, India

Role: Intern (Oracle Developer)

Responsibilities:

Extensively involved in coding of the Business Rules through PL/SQL using the Functions, Cursors, Triggers, Stored Procedures, and Packages in the server side.

Interacted with the user group on a regular basis to discuss requirements and updates.

Experience in writing Unix Shell Scripts.

Experience in using Export/Import, Data Pump Utilities to move the data between different databases and for backups.

Took active participation in developing and delivering things on Time with quality.

Prepared Test Cases and TACs for the reports.

Accomplishments:

Received Accenture Celebrates Excellence (ACE) award.

Received Stellar Award for Rising Star.

Received recognition for Focuses on delivering excellence.

Received recognition for Maximizes Team's Performance.

Scholastics:

B.E (Instrumentation engineering and control) from SRM University, Chennai with aggregate 81%.

Certification:

ATA Certified -- Application Developer Certification.

Contact this candidate