SUMMARY

• Over 12 years of experience in software development, maintenance, escalation support and testing using Perl/ Java/C/ C++/ SQL/ PLSQL.
• Extensive data analysis, data conversion, data migration, data integration, data mining and data base programming skills using Oracle, Sybase, JDBC/ODBC/Native - calls/SQL/PLSQL and PERL script.
• Experience moving hundreds of feed jobs, dozens of feeds servers as part of data-center migration.
• Experience handling large data sets. Experience in product development.
• Experience in Autosys and nagios monitoring tool
• Experience in a high-availability and mission-critical environment
• Experienced leading global team of developers, coding, testing and supporting high available mission critical application with focus on rapid development, cross functional deployment, release automation/co-ordination.
• Experienced in object oriented programming, creating and owning technical specifications and design documents.
• Domain knowledge of SDLC, QA process and SCRUM agile methodologies.
• Experience developing test strategies, test plan, creating and updating bugs as part of release process and agile methodology; release management and change control process.
• Experienced creating end user operations guide and end user training.
• Onshore/Off-shore team management experience.
• Extensive functional knowledge of Sun tools such as IBIS, Bugtraq, Apollo, Autosys and light house.

TECHNICAL SKILLS

Languages: Perl, Python,Java/J2ee, C++, C and Java core-java, JDBC, EJB, Junit and SWING

Operating Systems: UNIX (Solaris, AIX, HP-Unix), Linux centos 5.4, windows, OS/2, and DOS

Database: Oracle 10g, Sybase 11.x, informix, DB2, SQL server 7.0, Oracle 9.x, Sybase ver 11.9, DB2, and SQL Server 7.0 SQL, PL/SQL, stored procedure and triggers.

Webserver: SunOne, Tomcat and xampp stack.

Ancillary Skills: Autosys, IXP, Splunk DataStage 9.1 director, SQL loader, Verity search tool, lftp

Scripts: UNIX shells, perl, python/jython, SQL, Rexx

CRM: Siebel 7.2 (Call center Object Manager) and Actuate Reporting tool.

GUI: SWING/ JFC, Progress, Motif 1.2, Presentation Manager, VisualAgeC++.

ODBC: Sybase open client library, CLI/ DB2, DBLIB/SQL Server, CCL/Informix)

Source control: CVS, Team ware/SCCSTools Fulcrum search tool, Ultra seek search, Push2Test/Test Maker, Staroffice, Live Link, Autosys/Light House, PGP, public/private key encryption and Java Ant

PROFESSIONAL EXPERIENCE

Confidential

Systems Engineer/PL3 Lead

Responsibilities:

• Responsible for design develop and implement perl/python based ETL feeds for partner stores, L3 escalation support, data center migration and report generation.
• Provide on-call support to manage hundreds of perl ETL jobs; Inbound and outbound feeds/ETLs are running for price, item, image, order, order status, returns, store locator, content and marketing data feeds for hundreds of stores..
• As a Sr. Feeds consultant, was responsible for PL3 (product level 3) escalation resolution, code fix and implementing SMP project work.
• Investigate and fix feed failures, setting up jobs at autosys and monitor thousands of feeds jobs and supporting data center migration.

Environment: Perl 5.2, CPAN, Python 3.4.2, Unix/Linux shell scripts, SQL/PLSQL,Oracle, CPAN, Autosys, IXP, Jira and CVS

Confidential

Sr. Engineer/Lead

Responsibilities:

• Responsible for design, architect and implement test framework for automation of SOAP and REST services using SOAPUI tool and perl script.
• Lead over all QA effort of monthly SCRUM release cycle for JIGSAW GUI and web services.
• Manage small QA team for Jigsaw data fusion effort (JDF) for ORACLE CRM and Microsoft dynamics CRM data fusion.
• As Sr. SQA automation lead, was responsible for design, architect and implement Test framework to perform automatic regression test of Webservices API, using SOAPUI, Perl and Unix shell scripts

Environment: Java, Perl, UNIX shell scripts, SQL/PLSQL,Oracle CRM, MSD CRM, SOAPUI, Junit

Confidential, Santa Clara, CA

Sr. Systems Engineer/Team Lead

Responsibilities:

• HR Next gen project had been implemented to replace legacy staffing application with ADP sass based staffing system. As a key member I was responsible to implement operational data store (ods) for New hire integration between ADP and Sun HR database (Java/JDBC/PLSQL,Oracle 10g & stored procedure,perl).
• Was also responsible for conducting several meeting to gather requirements for data conversion, setting dev, beta and prod environments.
• Data conversion: Lead a conversion team, Designed and developed data conversion scripts to convert data from Sybase (11.9) database (legacy HR DW system) to Oracle (10g) operational data store (ODS).Performed initial data load.
• Design, develop test and deploy HRODS interim data-hub, ADP new-hire DB objects (stored procedure and table) .
• Initial data load, handled PGP encryption for initial data load.
• Single point of contact to set up dev, beta and prod environments, worked with different team such as ITOPS, DBA,HRIT and Business team.
• Created operations guide and handled ITOPS training.

Environment: Solaris 10, Java/J2EE,SQL/PLSQL,Perl and Unix Shell scripts, Autosys/Light house, PGP and Oracle 10G

Confidential, Santa Clara, CA

Sr. Systems Engineer / Architect

Responsibilities:

• As a key member of this project, was responsible for updating code base, build scripts to deploy different bugtraq components at HA environment.
• Test siebel and web service components, starting sequence and high availability.
• Also performed scalability testing for web services APIs.
• System architecture specification.
• Update build scripts and properties files.
• Re-configuration of C++ based BBM tool.
• Identify gaps in cluster group/resource in respect to each component.
• Coding test scripts, test script execution.
• Performed scalability testing of web service APIs.
• Test HA functionality, starting sequence and workflow.
• Worked with multiple team on finalizing HA system architecture specification.
• Created deployment document.
• Authored operations guide, handled ITOPS training.

Environment: Solaris 10, Java/Jdbc, SQL/PLSQL,UNIX shell scripts and Perl, Sun Cluster 3.2, Autosys/Light house, Siebel 7.5.2 and Oracle9i

Confidential, Santa Clara, CA

Senior Software Engineer/Team Lead

Responsibilities:

• Bugtraq have an existing interface with case management system, so it becomes a requirement to create new interface between Bugtraq and IBIS . As key member of this project, I have performed following tasks.
• System analysis, design and coding
• Created system architecture specification
• Performed API testing of INBOUND and OUTBOUND web service
• Performed JAVA coding of key portion (Consumer and producer) of this interface.
• Status meeting with Business users and IBIS team
• Worked with IBIS team on successful (multiple) BVAL testing.
• Release management, creating and updating Bugs, working with other developers on bug fix.

Environment: Solaris 9, Java/jdbc,SQL/PLSQL, Perl and UNIX shell scripts, Autosys/Light house, Siebel 7.5.2 and Oracle9i

Confidential

Staff Engineer/Team Lead

Responsibilities:

• Performed the following tasks simultaneously for the WMR release
• Bugster window manager release.
• Bugster WMR Theme implementation
• System analysis, design and coding
• Legacy look and feel, font, color was retained as Bugster Classic theme.
• Eight more themes are created as a fix to all theme related crs.
• Each Theme was designed and developed as an API
• Unit testing of theme APIs and bug fixing.
• Provided Theme demo to IT and business managers.
• Worked with QA on regression testing and related bug fixing Data validation (part of WMR release against p1 CR)
• Worked with ITOPS to refresh production data on DR environment
• Ensured DR environment has most current web services code/cli/jar
• Created data validation process on three non production servers
• Identified data inconsistencies for each error code and fix data in production
• Worked with Business team to notify users about bulk production data updates
• Worked with ITAS on issues related to production autosys alarm
• Updated Autosys JIL scripts
• Updated Lighthouse Resolution text
• Updated BT2 Operations Guide

Environment: Solaris 9, Java/JDBC, SQL/PLSQL, UNIX shell scripts and Perl, Autosys/Light house, Siebel 7.5.2 and Oracle9i

Confidential

Staff Engineer

Responsibilities:

• The requirement was to create an interface to Apollo tool to link each escalations with related bugs in bugtraq.
• Create new bugs from Apollo for new escalations.
• As key member of this project performed following tasks.
• System analysis, Test design and codng.
• Code/update web service APIs for Apollo interface.
• Worked with Apollo team on to test INBOUND and OUTBOUND data feed.
• Update siebel workflow for Inbound data feed.
• Release management.

Environment: Solaris 9, Java/J2ee, SQL/PLSQL, UNIX shell scripts and Perl, Autosys/Light house, Siebel 7.5.2 and Oracle9i

Confidential

Staff Engineer

Responsibilities:

• Data synch program synchronizes bug data between BT2 oracle database and legacy BT+ sybase database using JDBC and bugupdate CLI.
• As part of BT2 project's rollback strategy, this program back feeds delta changes from beta environment to legacy system on daily basis.
• It consists set of java program which back feeds data from
• Bt2 beta to BT+ (legacy) database.
• Handled entire IT system process including working with ITOPS to setup test environment, system analysis, design, coding and testing java jdbc program to update text fields from data extract.
• This program also taking care of complicated state mapping and other business logic before feeding daily delta changes.

Environment: Solaris 8, Java/JDBC, SQL/PLSQL, UNIX shell scripts, Sybase 11.9, Oracle 9.2, java/jdbc

Confidential

Staff Engineer

Responsibilities:

• It enable users to access and update bug information in oracle database (siebel schema) via e-mail.
• It uses RFC822 protocol standard to parse incoming mail message as header and body, and with in headers parses for different labels like From, Subject etc. as defined in RFC822 .
• BBM maintains logs for incoming and outgoing mails.
• It is using PGP public and private key encryption tool before sending CLI output to user and receiving mails for SUN business partners .
• Handled system analysis, design, prepared technical specification, coding and testing BBM for new Siebel environment.

Environment: Solaris 8, C, C++, SQL, UNIX shell scripts, Siebel 7.2, CVS/SCCS,PGP 6.5

Confidential

Staff Engineer

Responsibilities:

• BugTraq 2.0 dev infrastructure set up and testing.
• Total no of environments 6; proto, development, performance tuning (PT), uat disaster recovery(DR) and production.
• Web server Installation, Siebel app server and gateway server installation.
• Resonate (Load balancing Tool) installation.
• Actuate Reporting tool Installation.
• Autosys job creation.
• Light house alarm specification for job failure.

Environment: Siebel 6.5/7.x, Oracle 8/

Confidential

Staff Engineer

Responsibilities:

• Due to an Executive decision, Sun One web server bugs (Iplanet) were converted to Sun's bug tracking system from Netscape's bug database. Several thousands change requests (Crs/bugs) associated with I-Planet product had been moved from Netscape's (Bugsplat) database to Sun's bug tracking system.
• Data converted from Oracle 8.x to Sybase 11.x. As a responsible engineer has taken care of requirement gap analysis, system analysis design and conversion and testing of this conversion effort.
• System analysis design, Coding and testing
• Worked with ITOPS to set up database.
• State Mapping.
• Single point of contact to work with business users for time line and cost.

Environment: Solaris 8, Java/JDBC,Perl, SQL, UNIX shell scripts, Sybase 11.9, Oracle 8.x, Bug-update CLI

Confidential

Staff Engineer

Responsibilities:

• Escalation prediction - data mart project
• Cost of fixing an escalated bug is much more than fixing before escalation.
• Predicting escalation would save lot of time, energy and money.
• Sun selected InfoDynamics, a Israel based company to build the escaltion prediction system.
• Worked with Info dynamics
• Provided different subset of change t table records for different specified time frame.
• Provided different data points to management
• Validated Infodynamics results.

Environment: Solaris 8, C, C++, SQL, UNIX shell scripts, Sybase 11.9, ISQL, Unix shell

Confidential

Staff Engineer

Responsibilities:

• BT+ data cleansing. BugTraq+ managing half million product defects in Sybase database, during its re-implementation data will need to moved from Sybase to Oracle database.
• Considering data volume and huge user base cleaning the BT+ data helps a lot for perfect Conversion
• Wrote several sql scripts, embedded sql and ODBC programs to update and deleted data against various tables.
• Cooperated with several group's user.
• Tested scripts in DEV and QA before running against production database

Environment: Solaris 8, C, C++, SQL, UNIX shell scripts, Sybase 11.9,Sybase open client library, ISQL

Confidential

Programmer Analyst

Responsibilities:

• BUGTRAQ+ product Enhancement and Sybase 11 upgrade.
• Tested legacy application and fix upgrade related issues especially in class library.
• Worked with other groups on server move
• Fixed server move and y2k related bugs.

Environment: Solaris 8, C, C++, SQL, UNIX shell scripts, Sybase 11.9, Open client Library, DES

Confidential

Programmer

Responsibilities:

• Infimacs II is an ERP package from Confidential . It provides integrated
• Financial and Manufacturing Control system solutions to manufacturing companies.
• Infimacs II has over a thousand tables to manipulate data under various modules like
• Engineering, System control, Purchasing, Manufacturing, Material, Marketing/Sales and costing.
• Relevant decided Infimacs II back-end business process should be portable on major databases especially DB2 & SQL server due to proposed acquisition of informix by IBM..
• Use native calls and NOT to use ODBC for performance issue
• Port CCL Informix table object class to DB2 using CLI call
• Port CCL Informix table objects to SQL server using DB LIB
• As a responsible engineer ported middle tire class libraries using native calls from infomix to DB2 and SQL server.

Environment: UNIX - AIX 4.2, Windows 95, Window NT 4.0, C,C++,PL/SQL, Informix New Era 3.11, SQL Server 7.0, DB2 UDB, DBLIB/SQL Server, CCL/Informix, CLI/DB2