We provide IT Staff Augmentation Services!

Senior Software Developer Resume

0/5 (Submit Your Rating)

PennsylvaniA

SUMMARY

  • Software Engineer with 9+ years of IT experience primarily in Database development (Oracle),ETL(using PL/SQL) in Analysis, Design, Data Modeling (Logical and Physical) and MS.Net programming, in addition to working on cloud projects using Hadoop.
  • Over 5 Years of experience working in Agile Software Development model.
  • Expert in creating database objects such as Table, Views, PL/SQL Packages, Stored Procedures, Cursors, Functions and appropriate Triggers to facilitate efficient data manipulation and data consistency.
  • Experience in Extract Transformation and Load (ETL) using the Oracle dblink.
  • Expertise in Database Performance Tuning and Optimization of SQL statements using Oracle Hints, Explain plan, SQL*Trace and Table partitioning.
  • Extensive experience in developing UNIX Shell scripts and scheduled jobs on UNIX server using Control - M utility.
  • Self-starter, team player keenly interested in exploring new, challenging areas.
  • Responsible for mentoring junior engineers, designing, defining and prototyping work.

TECHNICAL SKILLS

Languages: PL/SQL, VB.Net, C#

Operating Systems: Linux, Windows NT/XP/7, Unix(HP-UX 11.31).

Databases: Oracle 12c/11g/10g, SQL Server 2008, DB2.

Web based Applications: ASP.net 2.0, ASP 3.0, JavaScript, VB Script,JSP and HTML

File Systems: NTFS,Hadoop Distributed File System (HDFS).

Tools: Toad, SQL Developer, Visual Studio 2010, JUnit, Jira, SVN, Oracle ReportsControl-M, SUPRTOOL.

PROFESSIONAL EXPERIENCE

Confidential -Pennsylvania

Senior Software Developer

Responsibilities:

  • Working as a Software developer at Confidential in an AGILE Dev model my tasks include writing Oracle Procedures PL/SQL and programs in C# and to facilitate the various financial transactions and write Unix scripts which are called from Control-M jobs to process Confidential ETF's. These Unix scripts in turn call .exes which have the core business logic.
  • Extracted Market Analysis Bloomberg data for specific BONDS from Bloomberg as a reference for Middle Office.
  • Improved efficiency of code using Explain plans and GATHER PLAN STATISTICS hint.
  • I was also extensively involved in Physical data modelling tasks like designing, creating tables, normalization(3NF), creating indexes etc.
  • Created External tables to import data from .csv files into the Core system.

Environment: Oracle 11g, Oracle 12c, Unix Shell scripting,VB.Net, C#.

Confidential, Minneapolis

Oracle Database Developer

Responsibilities:

  • As an Oracle Developer in the AHA Obama Care project I was involved in writing Managed Member Health modules.
  • Tasks included writing PLSQL (stored procedures, triggers) UNIX shell programs, Batch Jobs deployment and writing Oracle reports. I also performed ETL using PL/SQL techniques.
  • Used SQL Loader and External tables to import data into Internal systems.

Environment: Oracle 11g, UNIX -Shell scripting, AppWorx, SUPRTOOL, ETL (PL/SQL), Oracle Reports.

Confidential, San Francisco

Senior Associate (Tech Lead)

Responsibilities:

  • Wrote numerous Oracle Stored procedures that would process the customer claims for Confidential of California.
  • Daily tasks would include filtering and loading data from different formats of data sources into Database Tables and also writing numerous queries for extracting result sets.
  • Timely Query optimization was also required to be done using Joins and indexes in an effective manner.
  • Generated reports using Oracle Reports for CCMS application.

Environment: Oracle 11g, SQL Developer, Oracle Reports.

Confidential, San Francisco

Software Developer

Responsibilities:

  • The Paris Promotional Accounting Rebate Incentives System Engine (PE) is envisioned as a complex database application meant to produce rebate statistics.
  • Wrote numerous stored procedures that would calculate rebate sets, apply waivers, cull out sales transactions and finally determine the rebate amounts.

Environment: SQL Server 2008

Confidential, San Jose

Intern-Quality Analyst (Internship)

Responsibilities:

  • InfoSphere BigInsights is designed to help IT professionals quickly get started with big data analytics using Hadoop Distributed File System (HDFS).
  • My work was to determine the scope and verify the functionalities of various Infosphere BigInsights Components.
  • It focused on the DB2 Integration via JAQL in the LUW and Z OS and also the configuration.
  • As a QA Intern my job was to write Test Scripts in JAQL (JSON a Query Language) that would verify if all the DB2 supported functionalities are working fine after the Integration.
  • Worked on the setting up and configuration of Flume and wrote scripts to modify the existing nodes on Flume with number (add/remove) and roles (master/slave).
  • During my tenure I have logged in a few very critical defects which were later fixed by the development team for the Final release of the product.

Environment: JAQL,DB2, Hadoop Distributed File System (HDFS), Flume, Linux, Jira, RTC, RQM,DB2,Oracle 10g.

Confidential

Associate Consultant

Responsibilities:

  • I was actively involved in the database designing and development creating of database objects like Tables, Views, Stored Procedures, Functions, Packages, DB triggers, Indexes.
  • The tables were normalized up to 3 NF and also proper Referential Integrity rules were followed using data constraints and triggers.
  • Used HINTS, BULK COLLECT to achieve performance improvement. Also did query tuning and optimization by using Query Tracing and Explain Path.

Environment: Oracle 10g.

We'd love your feedback!