* 9+ Years of experience as a Sr.Systems Engineer in complete software
development life cycle with active participation in database design, development,
unit testing, system testing, business intelligence reporting and mild DB
administrative tasks
 * Performed the role of a Quality Assurance Lead Sales/Channels Business
participating in creation of Test Strategy, Test Execution Plan, E2E Test
Execution Plan, Entry/Exit Criteria Metrics, Test Cases, Defect Management
 * Defect Management using tools Mercury Test Director, Quality Center,
Trix(Google Tool),QA Automation using JUnit
 * Participation and E2E support for UAT, Post Go-Live Support
 * Post Production Support using Ticket Management Tool Remedy
 * Version Control tools used as CVS Tracker, Perforce, Microsoft Version
Control
 * Good understanding of object oriented programming concepts
 * Efficient in programming in Oracle 9i/8.x using SQL, PL/SQL,TOAD, PL/SQL
Developer on Windows 2000/XP, HP-UNIX
 * Extensively worked on Backend Programming using PL/SQL, Stored Procedures,
Functions, Packages, Database triggers for Oracle 9i/8i and also SQL
queries/reports and scripts
 * Good Knowledge of Data integration and migration using SQL * Loader
 * Good Knowledge of data migration among different interface using Dynamic SQL
 * Extensive use of PL/SQL Tables, Collections and Records with the concepts of
Bulk Bind and Bulk Collect
 * Tune SQL queries and database performance for OLTP
 * Strong skills in writing technical and functional documents defined by the
business requirements
 * Outstanding in Production Support, Testing, Documentation, End-Users Training
and Knowledge Transfer
 * Six Sigma Green Belt Certified (DMAIC) from GE Corporate Information Systems
for Oracle HRMS Compensation Data Load project
 * Strong knowledge of Software Development Life Cycle, Methodologies and
Techniques and release management thru Clear Quest, Clear Case
 * Identified and analyzed user sensitive information to help and measure
business performance
 * Played as Business Analyst in Pharmacy Management Industry
 * Possess a thorough understanding of data collection methods. Develop and
automate reports and monitor the validity/performance of the data being reported
 * A solid base in gathering and documenting user and business requirements and
an expertise in business process analysis
 * Demonstrated strong analytical and presentation skills, onsite/offshore
coordination and resource utilization
 * Proficient with the SEI CMM Level 5 processes and the KPA s associated with
this Maturity models
 * Demonstrated strong analytical and presentation skills, onsite/offshore
coordination and resource utilization
 * Track record of providing Excellent Customer Support and Multi-Tasking
depending on priority of the deliverables

TECHNICAL SKILLS:

Hardware : HP workstation, IBM PC 486 Sun SPARC
Operating Systems : HP-UX, MS-DOS, Windows 95/98/NT/2000/XP
Databases : Oracle 8i/9i, DB2
Languages/Development Tools : PL/SQL, SQL*Plus, Pro*C, C, UNIX Shell Script
(Korn), PL/SQL
 Developer, Toad, SQL* Plus, SQL Loader, SQL Navigator, KEA,
 RUMBA, Telnet, Visual Basic 6.0
Configuration management tools : MS Visual Source Safe, Perforce
Reporting Tools : Business Objects 5.0, Crystal Reports, Siebel Analytics, Pivot
Tables
Document Management Tools : Microsoft Office
Project Management Tools : Microsoft Projects
CRM Tools/Case Management : Clarify Clearcase, Alliance, Kintana, 
Quality Control : Six Sigma Green Belt (DMAIC)

PROFESSIONAL EXPERIENCE:

Wells Fargo (San Francisco, California) Nov 09 - Till Date
Sr. Systems Engineer (Human Capital Reporting)
Employer: InfoSTEP Inc. (www.infostep.com)

Project Overview: HCR (Human Capital Reporting) is web based reporting
application for the Wells Fargo Bank to leverage their human resource capital in
accordance with their ethnic background.

Roles & Responsibilities:
 * Involved in as a Sr. Oracle Developer for Requirement Analysis, Development
and Unit/Integration Testing for development of new reports using Crystal Reports
and PL/SQL
 * Used Redscape Red as a Version Control and Release Management Tool for
scripting the ETL s using PL/SQL
 * Taken part in the Requirement Analysis phase for the new reports to be
delivered
 * Participated in Unit Testing, System QA and regression Testing for the new
ethnicity based reports for HCR application
 * Learnt the use of Business View Manager in BO Enterprise 11.5.7.608 XI R2
with creation of the Business Elements (to map the DW tables) and schematic layer
of Business Views for logically connected BEs
 * Contributed to the Technical Design Document creating the sections for new
Crystal Reports, Business Views and Business Elements and the ETL objects (PL/SQL
Procedures)
 * Created the new One Time Data Load procedure for Year End data merge between
Wachovia and Wells Fargo in the existing Wells Fargo database including the
Wachovia Business Unit
 * Created the Deployment Plan for deploying the newly created packages in
Redscape Red(Oracle Objects),Business Views and Business Elements to be deployed
into production
 * UAT Support to business users/key stakeholders through bug fixation
 * Cross vendor onsite/offshore coordination and resource utilization for the
development activities
 * Change control management using Redscape Red
 * Participation in weekly checkpoints
 * I have learnt the use of Business Views and Business Elements to create a
logical layer on top of the DW tables structure to source information for
reporting purpose

Environment: Oracle 10g, PL/SQL, BO Enterprise 11.5.7.608 XI R2, Redscape Red,
Windows XP

Cisco Systems, Inc. (San Jose, California) Jun 09 - Nov 09
Sr. Systems Engineer (DSSOT Q3FY10)
Employer: InfoSTEP Inc. (www.infostep.com)

Project Overview: DSSOT application is the discounting platform for the revenue
applications of Cisco Systems Inc. which determines the discount eligibility of
customers and Sales Channels of Cisco.

Roles & Responsibilities:
 * Involved in as a Sr. Oracle Developer for Requirement Analysis, Development
and Unit/Integration Testing for development of new functionalities for ICW 4.0
Release for Q3FY10
 * Taken part in the FSD Review/Sign-Off sessions during the requirement
analysis phase
 * PL/SQL coding of Back End Stored Procedures, Functions, Packages & Triggers &
Debugging using TOAD
 * Extensive use of PL/SQL Collections and Records for the Accuprice-CDS-DSSOT
Interface data transfers
 * Cross vendor offshore coordination and resource utilization for the
development activities
 * Change control management using the workflow tool Kintana for
package/deliverable deployment
 * Participation in weekly checkpoints for status calls
 * This project has helped me understand the discounting eligibility platform of
Fortune companies having Sales Channels departments

Environment: Oracle 10g, PL/SQL, TOAD, Windows XP, Kintana, CVS Tracker

Employer: Symantec Corporation, Cupertino, California (www.symantec.com)
Role: Sr. Programmer Analyst
Duration: Nov' 07 - May' 09

Roles & Responsibilities:
 * Involved as a Sr. Oracle Developer for Requirement Analysis, Design Document
preparation, Development and Unit/System QA Testing for developing new reports
 * Taken part in all the aspects of SDLC and practically played the role of a
Technical Business Analyst
 * Participated in system analysis and data modeling, which included creating
tables, views, indexes, synonyms, triggers, functions, procedures, cursors and
packages
 * PL/SQL Coding of Back End Stored Procedures, Functions, Packages & Triggers &
Debugging.
 * Used SQL*Loader to load that data in to staging tables before loading them to
the base tables
 * Used PL/SQL Tables, Ref Cursors, Inline Views to process huge volumes of data
and used Bulk Collect and Bulk Bind for mass update and using Explain Plan tool
from SQL Navigator/TOAD for performance improvement process
 * Extensive use of PL/SQL Collections and Records
 * Participated in the code review sessions before migrating code QA/UAT
environments
 * Created, debugged, and modified stored procedures, triggers, tables, views,
user-defined functions etc.
 * Performed unit testing, system integration testing
 * Involved in SQL Tuning by creation of indexes
 * Conducted Code Review and created baseline for coding standards and preparing
unit test cases
 * Optimized and enhanced the existing procedures and SQL statements for the
better performance
 * Customization of code as per the user requirements
 * Change Management governance using Project Request tool which is a Symantec
In-house product
 * Version control using Visual SourceSafe/Perforce
 * Change management for SOX/Non-SOX CRs using Symantec in house tool
 * Reporting Automation by developing Portfolio Management System to cut cost
related to manual reporting/editing efforts
 * Used Microsoft ODBC to connect Excel Spreadsheet to the Oracle Database to
extract Oracle DB Objects to source the Pivot Table reports
 * Error reporting automation for the reports failing generation using Shell
scripts uuencode, mailx commands etc.
 * System QA for the reports developed by the Spending/Revenue teams for metric
accuracy
 * Debugging of the Visual Basic code emulator for Excel Spreadsheet to
troubleshoot the problems related to new/existing reports, creating macros,
functions, formulae, using VLookups etc.
 * Deploy the newly created reports in the SymFinance page depending on the
report functionality
 * Created Pivot Table Reports and Chart Reports for AP Cashflow Analysis,
Procurement Details Reports, Expense Details, Unposted AP Details etc.
 * Performed functionality and data validation testing for the reports created
by other developers before moving with UAT
 * Catering to the queries from the iProcurement/Business Objects team regarding
activation of several organizations, procurement