Professional Summary:

• 6 years of experience in all major phases of SDLC i.e. requirements gathering, application design, development, integration, testing and production support of web application software and business software.
• Expertise in data analysis, development and performance optimization in ORACLE using SQL and PL/SQL.
• Experience in all aspects of Business Analytics Applications including analysis, design, development, configuration, Customization, validation and deployment.
• Excellent Programming skills and experience in ASP.NET, VBscript, Javascript and other object oriented environments.
• Solid hands on experience with Unix Shell scripting.
• In-depth knowledge of PL/SQL with the experience in constructing Procedures , Triggers, Tables, Collections, Functions, User Defined Datatype, etc
• Familiarity with RDBMS, OOPS and ORM.
• Hands-on experience in developing Test Strategies, preparing Test Plans and writing Test Cases.
• Complete problem solving abilities and outstandingcommunication skills.
• Leadership and Project Management qualities; demonstrated ability to coordinate and lead project teams from small to medium sizes during all phases of the project; ability to take ownership and responsibility for team.

Technical Skills:

• Platforms: Windows 9x/NT/2k/XP, Mac OS, LINUX, UNIX,OBIEE
• Database: MS SQL, Oracle 9i,10g, 11g SQL, Server 2000,
• Languages Dev Env.: VB .NET, ASP .NET, C#, Java, J2EE
• Automated Test Tools: Mercury QTP, Load Runner
• Testing Tool: JUnit
• Scripting Language: Unix/Linux script, Shell Script, VB Script,Perl, PL/SQL, Java Script, ASP, JSP
• Terminals: Reflection, Putty
• Application Servers: IIS, JBOSS, Ruby, Weblogic 8.1
• Web Technologies: HTML, DHTML, XML
• Environment: CMM Levels, Agile, VMWare
• Web Browsers: IE , Mozilla Firefox , Google Chrome,Safari
• Configuration Management Tool: Clear Case, VSS, SVN
• Release Management Tool: Build Forge
• Development Tool: Toad, Eclipse, SQL Developer,Visual Studio,Obiee

Work Experience:

Confidential, Seattle, WA Feb-2011 Till Date
Role: PLSQL/OBIEE Developer
Project: Tax Data Warehouse

• Developed PL/SQL blocks to generate reports for business.
• Developed the repository model for the different work streams with the necessary logic that involved creating the Physical, BMM and the Presentation layer. Also created hierarchies, variables, and event poll strategies in the repository.
• Administered Oracle database by setting up test environment.
• Modified some of the existing reports and dashboards, and fixing some of the issues related to performance, data quality etc., during production support.
• Designed and developed the OBIEE Analytics Metadata Repository (.rpd) using OBI Analytics Server Admin tool by importing the required objects (Dimensions, Facts & Aggregates) with Referential Integrity constraints.
• Developed business models conforming to functional mapping, defined logical and complex joins for the dimension tables.
• Develop batch processes for financial reporting applications and modules using shell scripts on Oracle database, with partitions and sub-partitions.
• Performance tuning of database objects using oracle hints and tuning techniques.

Environment: Oracle 11g, Linux (Red Hat), OBIEE 11g,SQL Developer, Informatica.

Confidential,Edinburgh UK Oct 2009 Apr 2010
Role: Database/Obiee Programmer
Project: ETL-ReArch.
Basel II logic was implemented in the RBS banking system as part of this project. New OBIEE reports
Were built and existing reports modified as part of enhancements.

Responsibilities:

• Developed PL/SQL scripts to test for data population and data validation in the database post migration of data in the Group Risk Data Warehouse (GRDW).
• Involved in Creating and Administering the Physical Layer, Business Model & Mapping Layer and Presentation Layer using Oracle Business Intelligence Admin tool.
• Responsible for implementing and deploying various enhancements and reporting in the Data warehouse systems.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Created Dimensional Hierarchy, Level based Measures and Aggregate navigation in BMM layer.
• Logged and tracked defects in PVCS tracker and Test Director.
• Performance tuning of database objects.
• Data Analysis
• Creating PL/SQL Scripts to automate the manual Monitoring process.
• Preparing monthly scorecards representing process performance and help in making presentations on RBS quarterly performance to various stakeholders and business owners for their review
• Conducted client meetings to clarify the business requirements and report daily status.

Environment:OBIEE 10.1.3.4, Oracle 11g, UNIX, Toad, Test Director, Defect Management Tool, PVCS Tracker, Informatica.

Confidential,Cupertino, CA Apr 2008 Sep 2009
Role: Database/Application Developer
Project: Point of Sale (POS)
POS application is used at billing counters at Apple stores world wide to enable sales associate to sell
Products to customers.

Responsibilities:

• Designed and developed desktop application using J2EE.
• Built and modified PL/SQL programs to support project implementation.
• Played a pivotal role in the partitioning and merge of archive database that involved creating partitioned tables to handle large-scale growth, tuning oracle stored procedures for performance and optimization and coding DB Units to validate changes to database objects.
• Worked closely with front end and middleware programmers to tune SQL.
• Generating Explain Plans for SQL queries and analyzing the Trace Files using tkprof.
• Optimized and modified the triggers, complex store functions, procedures, user base datatype etc.
• Design, develop and maintain web-based business process and database applications.
• Executed test cases and documented test results during various phases of testing unit testing, integration testing, system testing and regression testing. This helped in identifying and closing more than 70 defects in the application thereby ensuring the application gets maximum rating in customer satisfaction survey.
• Write SQL statement for ad-hoc report generation
• Worked on multiple projects simultaneously under aggressive timelines to ensure different client schedules are met and no SLAs (service level agreements) are missed.

Environment: Mac OS (Snow Leopard), JBOSS and Ruby servers, Unix, J2EE, Cocoa, Radar, Oracle11g, MySql, JIRA, Confluence, Process Validation Tool, ETL, Informatica,

Confidential,Colorado Springs,CO Mar 2006 Mar 2008
Role: Database/Application Developer
Project: EAR (Enterprise Architecture Repository)
EAR is based on John Zach man’s framework of Enterprise Architecture that provides a formal and highly structured way of viewing and defining an enterprise.
Responsibilities:

• Developed and maintained EAR application by utilizing ASP.NET.
• Responsible for the analysis, designing and coding of the database.
• Delivered custom and scheduled reports using Crystal. Built and performance tuned back end PL/SQL code.
• Front and back end support for Agilent IT GBS applications i.e., enterprise architecture repository (EAR).
• Wrote advanced queuing database package to send messages to clients based on events.
• Actively interacted with the stakeholders, users and project managers to identify ways of making the application more user-friendly, stable, secure and fast.
• Performed data element mapping, modified database schema objects and PL/SQL constructs, and conducted/reviewed test cases that contributed to the successful completion of an enterprise-wide data integration project.
• Created SQL scripts for data maintenance or bug fixes.
• Optimized and modified the triggers, complex store functions, procedures, user base datatype etc.

• Maintained version control and configuration management by tracking versions of different test related documents using Visual Source Safe (VSS).
• Prompt response and resolution of the support issues within defined service level agreements.

Environment: PL/SQL, ASP.NET, Shell Scripts, JavaScript, VBScript, HTML, Visual Studio Interdev, Oracle, Visual Source Safe 6.0, Process Validation Tool, PAL, Excel, Brio, Informatica

Confidential,London, UK Jun 2005 Feb 2006
Role: Database/Application Programmer
Project: Paragon
The project comprised of an Internet banking platform that provided comprehensive and integrated range of financial products and services

Responsibilities:

• Coding and unit testing enhancements for CRM module using Java.
• Writing SQL scripts to support back end requirements
• Programming shell scripts for space/processes/listener/oracle alerts monitoring.
• Responsible for application development and testing using Oracle and Unix.
• Reassigning, correcting and verifying the defects and involved in the defect prevention activities.
• Modeling of the various database objects that are required by the different modules of the project.
• Taken up the configuration management activity for effective version control and project management.
• Ensuring error free code migration across various instances.
• Prepared test case document to list all possible test cases related to the application release. The test cases were then categorized according to their priority and severity levels that ensured critical functionality is tested first.

Environment: Java, Swings, C++, C, JSP, PL/SQL, Oracle 9i, Shell Scripting, Web Logic, J2EE , JDK, OLTP, Master craft, Quartz, Toad, KAWA

Confidential,India Jun 2004 Jan 2005
Role: Software Engineer
Project: Dell
Provides a single portal for quick access to Dell product and service information.

Responsibilities:

• Coded, tested, debugged, documented, and maintained PL/SQL programs
• Designed and implemented error checking and correction protocols and programs.
• Gathered application requirements and provided design recommendations.

Environment: Oracle 9i,PL/SQL, UNIX, Windows NT/2003/XP

Education:
Bachelor of Engineering in Information Technology