SUMMARY:

• Over 17 years of IT experience in Software Systems Analysis, Design, Development, Testing, Implementation and Support in various business sectors. Accomplished developer in Perl, UNIX, Sybase, SQL Server and Oracle

TECHNICAL SKILLS:

Languages: SQL, Transact SQL, PL/SQL, Perl, Shell, C, C++, Java, XML, HTML, COBOL

RDBMS: Sybase ASE, Sybase IQ, Oracle, SQL Server, DB2, MySQL

DBMS Tools: Sybase central, DBArtisan, Rapid SQL, ISQL, BCP, SQL Advantage, TOAD, SQL Navigator, JConnect, SQLloader, SQLPlus, EyeWatch, Aqua Data

Business Intelligence tools: OBIEE

Methodologies: ITIL - ITSM practices, Waterfall and Agile/Scrum models

CASE Tools: Power Designer 15, Erwin, Designer2000

GUI tools: PowerBuilder, PFC, Visual Basic, Crystal Reports, Excel, PowerPoint, Oracle Designer, Oracle Forms, SSRS

Version Control/Build Management: SCCS, CVS, TortoiseSVN, ClearCase

Bug/Issue tracking tools: JIRA,ClearQuest

Job Scheduling tools: Unix Cron, AutoSys, Windows batch, Hudson, Control-M

Dynamic application service management tools: DataSynapse GridServer

Testing tools: Test Director, Win Runner

Project Management tools: Confluence, Visio

Operating Systems:, DOS, Unix (Sun Solaris), RedHat Linux, Next, Windows 95/98/2000, NT, XP, Win 7

UNIX Emulators: Putty, Reflection, X-windows, Exceed

PROFESSIONAL EXPERIENCE:

Confidential

Adhoc Automation Lead

Responsibilities:

• Interaction with Business users for Adhoc requirements and Analysis
• Design, develop and tuning of the SQL and T-SQL code.
• Automate the frequently repeated report requests using Perl, shell and T-sql code
• Manage Adhoc requests queue to meet the Service Layer Agreement.
• Manage user testing and signoff process

Environment: Sybase15, SQL Server, SSRS, Power Designer, RapidSQL, Perl, Ksh, Cron, SCCS, Visio, SharePoint

Confidential, Stamford, CT

Senior Developer and Support Lead

Responsibilities:

• Analysis, Design and development of Intercompany Perl modules
• Design and develop database objects - tables, views, stored procs and triggers
• Performance tuning and query optimization of sql queries, sp’s and triggers
• Fixing Perl batch jobs performance issues
• UNICRON enhancements for Hyperion code Migration in Perl and database.
• FINREP requirement enhancements to existing reports in Perl and databases
• Prepare dashboards and customized reports for the users via OBIEE answers
• Version control and release management.
• Automate the Perl batch jobs via Autosys for the daily, weekly and month end jobs
• Production support, bug fixes and patch releases of Perl and database code.

Environment: Sybase 12.5/15, Oracle 10g, SQL Server, SSRS, OBIEE, Aqua Data, Perl5.10, Ksh, Autosys, JIRA, Deltatrack (in house tool for code releases), Exceed, Unix Cron, SCCS, Apache, Tomcat, Solaris10, Linux

Confidential, Mason, OH

Lead Developer and Data Architect

Responsibilities:

• Participate in all project/ SSCR (Small system change request) related discussions
• Analysis of the FDD and Use cases.
• Manage offshore team
• Prepare Technical Design documents and Data manipulation matrix
• Design database objects required for the interfaces.
• Identify, fix and fine tune slow running processes
• Automate and implement the Trizetto patches for Facets system upgrades via Perl, shell and SQL

Environment: Sybase15, Power Designer, Perl, Ksh, Cron, Clear Case, Visio, SharePoint, Solaris10

Confidential, Wall St, New York

Senior Developer - level 2 support

Responsibilities:

• Analysis and Development of various Equities and Derivative related Risk report requests
• Interactions with portfolio managers of various desks
• Imagine trading application version upgrade
• Automation of current manual process of generating adhoc reports in Perl.
• Adhoc SQL query and report generation upon request by trading desk or application users.
• Peer code review, Bug fix and enhancements to the existing risk reporting jobs developed in Ksh and Perl.
• Bug fix and performance tuning of Sybase stored procs and triggers that are executed via nightly batch jobs
• Release management. Process to ensure fully tested code is released on time as a team.
• Support the production management team with real time issues and ensure their SLA’s are met.
• Support Prod server migrations, Implementations, DR testing for related servers/applications.

Environment: Sybase12.5/15, Perl 5.10, Ksh, Java, XML, Cron, Control-M, CVS version control, Apache, Tomcat, JIRA, Linux, Solaris10

Confidential, Stamford, CT

Risk Environment Dev Support Lead

Responsibilities:

• Administration of Risk application environments for locations like London, Stamford, Sydney and Hongkong
• Automation of environments and its dependant application batch processes using Perl, Java, Shell and T-SQL.
• Implementing business necessity changes with stored procs, Triggers, performance tuning and other changes/enhancements related to Risk applications data.
• Manage Development Hardware (Linux servers) required for the environments with respect to monitoring the CPU utilization, memory, local disk and the assigned Q-tree/NFS mount usage, assignment of right machines to different environments depending on the usage load.
• Install and maintain different versions of Dynamic application service management tool (DataSynapse).
• Engage in a proactive relationship with application users to ensure service is tailored appropriately to their needs.

Environment: Sybase12.5/15, Perl, Ksh, Java, XML, JIRA, Cron, AutoSys, DataSynapse, Tibco Messaging, CVS, Apache, Tomcat, Hudson, Solaris10, Linux

Confidential, Chicago

Risk Environment Developer

Responsibilities:

• Create Development environments for the Risk applications as per the new code release and deploy it to different Confidential locations like London, Stamford, Sydney and Singapore.
• Bug fix to nightly batch jobs using shell, Perl, Sybase SQL and Transact-SQL, Autosys and Cron.
• Develop stored procs, Triggers, BCP and other changes/enhancements related to Risk applications data.
• Worked on onsite-offshore model for some of the Risk application enhancements
• Address systems difficulties related to environment access and application behavior.

Environment: Sybase12.5, Oracle 10g, Perl, Java, Shell (Csh, Ksh), Java, XML, ClearCase, Cron, AutoSys, TestDirector, Linux

Confidential

Senior Developer and Project Lead

Responsibilities:

• Worked in on-site / offshore model for new change requests and enhancements, make time and effort estimations
• Analysis of change requests, enhancements, prepares technical specifications and impact analysis.
• Database design and delegate the project work to the team members
• Bug fixing and development of changes and enhancements as required by the client

Environment: Sybase11.5, Oracle 9i, Perl, Shell, C, C++, Power Designer, Clear Quest, Solaris5.8, Linux

Confidential

Systems Analyst

Responsibilities:

• Was at client location (Basel, Switzerland) for requirements and analysis of existing Event Management system
• Interactions with application users for requirements details, Technical design & documentation of the requirements.
• Design of the event management system database using power designer
• Involved in handling Change requests of BIS Client/Server applications. Supported BIS in-house applications.

Environment: Power Builder6.5, Sybase11, Oracle 8, Power Designer, Shell, PVCS, Sun Solaris 5.6, NT, Novell Client

Confidential, NJ

Developer and Project Lead

Responsibilities:

• Interactions with client on requirements and producing a detailed design and approach documents.
• Was mainly responsible for database analysis, design & project estimations.
• Responsible for team management

Environment: Power Builder6.5, C++, Crystal Reports, Sybase11, Shell, Oracle 8, Erwin3.5, TOAD, PVCS, ClearQuest, IBM PC, Sun Solaris 5.6, Windows NT, Novell Client

Confidential, NJ

Developer and Support Team Lead

Responsibilities:

• Mainly involved in handling the Change requests and production support activities.
• The support role involves scheduling, monitoring and managing of nightly job runs
• Automation of production run statistics in C++, shell

Environment: Power Builder6.5, C++, Crystal Reports, Sybase11, Oracle 8, C Shell, DBArtisan, Erwin3.5, TOAD, PVCS, ClearQuest, IBM PC, Sun Solaris 5.6, Windows NT

Confidential

Developer

Responsibilities:

• Requirement analysis
• Design of DFD’s, E-R diagrams, normalization of tables, table structures, integrity constraints.
• Design and development of dB Triggers, Stored Procedures and oracle Packages.
• Reports design and development in Perl and Oracle.
• Responsible for system Integration and Implementation.

Environment: PowerBuilder6.5, Oracle 8.0.3, Shell, Perl, Power Designer, HP UNIX, Windows 95, NetWare 5.0.

Confidential

Developer

Responsibilities:

• As a member of the database design team, responsibility includes preparation of flow charts, ER diagrams, normalization of objects, designing table structures, defining integrity constraints and Indexes.
• Was responsible for the design and development of database Triggers and Stored Procedures.
• Developed various masters and transaction user Interface screens and critical MIS reports.
• Developed Trail balance and Balance sheets. Involved in preparation of Unit and system test cases for the module.

Environment: PowerBuilder5.0, C++, Oracle 7.3, Designer2000, HP UNIX, Windows 95, Windows NT