Senior Developer Resume

SUMMARY

Over 10 years of programming experience as an Oracle PL/SQL Developer on a Datawarehouse platform.
Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation, project management and production support.
Expertise in application development using Oracle 11g/10g/9, PL/SQL, TOAD.
Strong Knowledge in Data warehouse concepts and ETL.
Excellent analytical skills and strong ability to perform individually or as part of a team.

TECHNICAL SKILLS

Programming: SQL, PL/SQL, Unix Shell Scripts

Reporting/ETL: Microstrategy, Informatica

Database: Oracle 11g/10g/9i, Sybase, SQL Server

Source Control: Tortoise SVN

Others: TOAD, Putty, winSCP, JIRA

PROFESSIONAL EXPERIENCE

Confidential

Senior Developer

Responsibilities:

Manage Development & Production support (SL3) team, provide delivery metrics to management on project milestones and deliveries.
Understand the functional requirements and analyze the technical feasibility and design.
Perform data analysis, data transformation, data reconciliation, data quality checks, preparation/execution of unit test cases and regression testing.
Responsible to develop, support and maintain theETL(Extract, Transform and Load) processes, using PL/SQL stored procedures, functions, packages and Triggers.
DDL Creation for database objects like tables, views, materialized views
Create and modify UNIX shell Scripts to process the source/feed files.
Handle errors using Error/Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
Create/Modify sql script to load data into database using SQL Loader.
Analyze application log files in Unix environment to identify application errors and bugs.
Participate in QA/UAT phases and liaising with stakeholders for business sign - off.
Responsible for deployment and post production support activites.
Provide guidance to L2 on resolving issues.
Guide Microstrategy Report developers on Query performance tuning and SQL Optimization.
Planned and coordinated Oracle database upgrade from 10g to 11g.
Planned and coordinated Database Migration from physical machine to DHS (Virtual) server.
Involve in the continuous enhancements and fixing of production issues.
Participated in Sybase to Oracle Migration Activities for DB Insight project (outside Sapphire project). Migrated the entire Sybase processes to Oracle database analyzing the Sybase objects.
Participated in Oracle Data modelling for GBA Module(outside Sapphire Project)

Environment: Oracle 11g, TOAD, UNIX, Microstrategy 9

Confidential, New York

Developer

Responsibilities:

Understand the business requirements and converting them to Design documents.
Worked extensively in the translation of business requirement into data warehouse design and developed ETL logic based on the requirement, using Informatica Power Center 7.
Developed mappings using Joiner, Sorter, Connected Lookup, Router, Filter, Update Strategy, Expression using Informatica.
Worked with all the client components of Informatica like Repository Manager, Designer, Workflow Manager, Work flow Monitor.
Created PL/SQL stored procedures with Ref Cursors for Actuate reports.
Created DDL scripts to create tables, queries for new enhancement in the application using TOAD.
Involved in the continuous enhancements and fixing of production issues.
Creating Actuate reports as per the requirement.
End to End validation of mappings/reports and standard checks.
Creating release objects and performing post sanity checks
Peer review of mappings and reports.

Environment: Oracle 9i, TOAD, Informatica 7, Actuate 8, Windows XP

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship