Senior Software Developer Resume
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.
