Software Engineer Developer

Vibha Taneja

E-mail: *****.********@*****.***

Contact # 708-***-****, Location # Houston, TX

SKILL SUMMARY

* ***** ** **/*** development, testing methodologies and process.

Experience working in all phases of SDLC from analysis, design, coding, unit testing, system testing and user acceptance testing.

Strong in writing Stored Procs, Functions, Packages and anonymous blocks using PL/SQL, Strong in writing SQL queries.

Modified database structures including table spaces, tables, views, triggers, stored procedures, Packages.

Ability to learn new technologies and challenging concepts quickly and implement them.

Excellent analytical, Problem solving, decision-making and presentation skills with ability to co-ordinate activities in a fast paced team environment.

Ability to work productively and effectively in a team as well as individually. Strong communication and interpersonal skills

Knowledge of CDISC Mapping, SAS/BASE, SAS/ACCESS, SAS/ODS.

Knowledge of creating SDTM datasets from raw datasets.

Knowledge of using SAS/STAT procedures such as PROC FREQ, PROC MEANS, PROC UNIVARIATE, and PROC SUMMARY.

Knowledge of producing Excel, RTF, HTML and PDF formatted files using SAS/ODS to produce reports for presentation and further analysis.

TECHNICAL SKILLS:

SAS Skills

SAS 9.1 (BASE)

SAS Procs

SQL, Report, Means, Univariate, Transpose, Freq, Sort, Summary, Contents, Format

operating Systems

Red Hat Linux and Windows 95/98/ME/NT/2000/XP.

RDBMS

Oracle8i/ 9i/ 10g/11g, SQL Server 2000, Access

Languages

SQL, PL/SQL, C, UNIX Shell

Tools

SQL*Loader, MS Office,Excel,Power Point

Tuning Tools

EXPLAIN PLAN, SQL HINT, Index

Database Modeling

TOAD, ER-Diagram

PROFESSIONAL EXPERIENCE

Barclays Capital, Jersey City, NJ August 2012 – April 2013

Duration: 9 months

Role

Sr. Oracle PL/SQL Developer

Responsibilities:

Worked on the Barclays Axiom Project as Sr Oracle PL/SQL Developer

Axiom is the intelligent system designed for developing Financial Control/Regulatory Reporting.

Experience on the enhancement and modifications of the financial control and regulatory reports.

Worked on the creation/modifications of Freeform reports

Worked on Sql queries required to create data sources as per the customer's requirement.

Worked on the portfolios, aggregation and workflows.

Experienced on implementing dynamic SQL.

FEDEX WTC, Memphis, TN Feb 2012 – April 2012

Duration: 2.5 months

Role

Sr. Oracle PL/SQL Developer

Responsibilities

Worked on the Pricing Request System of FEDEX as Sr Oracle PL/SQL Developer

Pricing Request System is the intelligent, workflow management system that defines & facilitates the end to end pricing process.

Worked on modification/enhancement of the packages for the new services added.

Implemented the new functionalities by creating new and enhancing the existing cursors based on the customer requirement.

Added the new services by creating new and enhancing the existing procedures and functions based on the requirement.

ACCENTURE, Bangalore Sep 2009 to Mar 2011

Duration 1.5 Year

Role

Software Engineer / PL/SQL Developer

Responsibilities

Worked in Oracle Retail Sales Audit (ReSA) implementation team.

Experience in ReSA after go-live stabilization phase wherein we worked to make the system stabilize after go-live.

Worked on the ReSA post go-live production issues.

Experience in setting up of audit rules and totals for ReSA.

Worked on PL/SQL based development of functions/procedures for data setup and clean-up.

Performance tuning of application by identifying the SQL, which are not written well; providing inputs to the application programmer; correcting and implementing the right components.

Created Views using a bunch of Joins, Union and minus operators on the reference tables which hold the data’s with new symbolic specifications.

Providing 24/7 production support on priority.

Created triggers and packages for some change requests.

Fixed existing bugs and automated various manual support activities

INFOGAIN PVT. LTD, Noida Jan 2008 to Aug 2009

Duration 1 Yr 7 months

PROJECT SUMMARY

1.

Project Name

National Vision Inc. (NVI) Data Migration

Description The Interactive Retail Information System (IRIS2) is NVI’s Point of Sale.

This project involved migration of database from Interbase to MySQL.

Role

Software Engineer

Responsibilities

Job creation in Talend Open Studio to automate data migration.

System Testing and validation of Talend Jobs.

Defect management and closure.

2.

Project Name

Description

Oracle Retail Implementation (version 13)

Oracle Retail implementation for India based retailer

Role

Software Engineer

Responsibilities

Functional understanding of Oracle retail merchandising (ORMS)

PL/SQL based development of interfaces (Supplier interface from Oracle E-business to ORMS)

Retrofitting of oracle patches as per India local environment.

Prepared high level and technical design.

Did unit testing and defect fixes.

Education

MCA (Master of Computer Application)- Punjabi University Patiala, India

B.Sc. (Bachelor of Science(Chemistry, Physics and mathematics)-Modi College Patiala, India

Trained in Base SAS(US bases SAS training)- EastBiostat Durham, NC

Reference- Puneet Singh 919-***-****) (My Training Instructor)

Appearing in Base SAS certification exam

Contact this candidate