SUMMARY:

Highly motivated IT Professional with over 9.5 years hands on experience in Architecture, Design and Development of multi - tier enterprise software application. Design and coding using Sybase, PL/SQL, Perl, Shell Scripting, Unix, Informatica and other related technologies. Strong experience in Architecture, Design, Development of Database & related Projects, Maintenance & Enhancement of Complex Application with strong analytical & development skills seeking assignments in Software Development & Leadership in the IT sector

• Experience in creating complex database models, designs & Stored Procs , Triggers, Indexes, Views,Tables, Schemas for large database systems.
• Programmed extensively in Perl scripting to handle ETL , Automation , Feed Loads, Purge mechanism, Data Consistency Fix, Extract & Load Data frameworks using DBI/DBD modules , batch transactions and Autosys.
• Extensive experience in sybase DB Tuning of high data volume applications. (Procedures, System Design, Triggers, Replication, Deadlock & Cache Tuning)
• Extensive experience in Sybase replicated database server environements.
• Experience in File::Slurp, HTTP::Request, Glob, Data::Dumper, Getops::Std, XML::Simple etc modules in PERL.
• Worked on Core Java based projects to make enhancements in Java Code.
• Experience in Control M, Cron Tab & Autosys.
• Experience in Analysis, design, development, and implementation of ETL process using Informatica Power Center for various sources - xml, flat files, relational.
• Extensive experience in all stages of Software Development Life Cycle and Software development Methodologies. Experience in Investment banking and Core banking.
• Experience in analyzing and translating business requirements to technical requirements, proof of concept, implementation, testing, maintenance and product support. Self-starter, well-organized, concise verbal & written communications, presentation & interpersonal skills.
• Good customer handling skills. Strong analytical skills and ability to quickly comprehend complex designs. Short learning curve and ability to quickly adapt to new technologies. Experienced and ability to lead mid-sized technology teams and software development projects. Self-motivated, pro-active, initiative to learn and show high levels of creativity and a team player.

TECHNICAL SKILLS:

Languages/Technologies: Sybase, PL/SQL, Perl, Shell Scripting, Unix, Informatica, PowerBuilder, C, XML

Enterprise/Web Server: Oracle Weblogic Server, Apache Tomcat, Web sphere 6.0, JRun

Middleware /Servers: IBM MQ

Tools: DBArtisan, SQL Advantage, E-Clips, Textpad, Editplus, Informatica

Mark-up/ Scripting Language: HTML, CSS, XML, and JavaScript

Operating Systems: Windows XP, Win server 2000, Win Server 2008,

Project management: Estimation, Planning, Project Management, Risk Management, Quality, RTC

Domain: Investment banking and Core banking

PROFESSIONAL EXPERIENCE:

Confidential, NYC

Technical Lead

• Active participation in daily scrum meetings for project and executing sprints . Participate in sprint hardening phases
• Implemented the change by creating various Sybase table schemas, indexes, and stored procedures .
• Designed & developed ETL extract framework for Annual Letter Mailing application. Implemented it using Perl/Sybase .
• Break analysis for various monthly transaction and fixing them
• Migrated other applications to new extract framework built for new application
• Performance Tuned multiple Sybase stored procedures and ETL processes
• Created Perl script , which will access DBA APIs for automatic dump and loads to UAT Env across multiple data servers.
• Implemented the change by creating various Sybase table schemas, constraints, indexes, keys, developed & modified stored procedure and triggers to working with Development team. Performed Code Review being senior member of team.
• Developed lookup table mechanisms to store field mappings on pool, tranche & deal level.
• Created workflows and scheduled them
• Scheduled jobs using crontab and used host utility.
• Wrote Perl program to import/export information from Sybase Database, send daily chat logs to clients
• Involved in data analysis & creation of Perl Script for Timely purging of data.
• Created DB objects deployment script using Perl scripting.
• Created adhoc jobs for update statistics and reorg rebuild using Perl scripts & various Perl modules like DBI/DBD .
• Validating the test results after repetitive feed load by writing automated Perl scripts & Subroutine.
• Design of trade application components based on Sybase12.5
• Coding in Sybase 12.5, FIX Protocol, UNIX, Shell scripting.
• Involved in Creation of Software Requirements Specification, Architecture and Design documents
• Task distribution among team members.
• Conducting code review meeting as on required basis.
• Conduct peer reviews and participate in technical code reviews
• Defect fixing and Deployment of application to various test environments.
• Using Weblogic for hosting, Ant to build and deploy, Start team for revision control, HP quality center for defect management.
• Analyzing/fixing issues by analyzing xml response.

Environment: Sybase 12.5, FIX Protocol, UNIX, Shell scripting, Autosys, XML, DTD, VI editor, VCS, Perforce, Aaraxis, ETSTest tool

Confidential, NYC

Technical Lead

Responsibilities:

• This is enhancement/maintenance project. It uses various technologies like perl+shell scripting for reporting and loading of small data. Informatica (ETL Tool) for loading and processing of data. Also used Autosys for job scheduler.
• Following are the roles and responsibilities: -
• Complete SDLC operations including Requirement Analysis, Architecture, Design, Coding, Testing and Deployment. Overall ownership of Project module and all activities related with technology assessment, estimation, development and implementation of the application.
• Creation of Software Requirements Specification, Architecture and Design documents.
• Requirement study and Impact analysis for the new requirement or change request on the existing programs initiated by client.
• Preparation of detailed design documents.
• Responsible for the Extraction, Transformation and Loading (ETL) of daily data into historical database.
• Development of shell script for controlling the ETL jobs and framework.
• Developing, scheduling Autosys jobs as per the requirements.
• Performing unit testing, System testing & UAT.
• Had worked in upgradation of Informatica from 7.1.3 to 8.6.1 version.
• Interaction with clients in the requirement and testing phase.
• Weekly Status call with the client.
• Troubleshooting of issues that are escalated by the Support Team.
• Development of frameworks and tools to support Surveillance Reporting.
• Ensuring overall quality of all the deliverables.

Environment: Sybase 12.5, Informatica, Unix, Perl, shell scripting, Autosys, Actimize, Perforce (for source code control), RCS (for Version Control)

Confidential

Responsibilities:

• Requirement Analysis and creation of System requirement specification document.
• Creation of High level and Low level Design documents.
• Set up the development Environment and package the build using the MSI package.
• Performed unit testing, QA and UAT for the developed Application.
• Carried out system, user acceptance, functional, performance testing of the application.
• Build and Release of the project.
• This is developments/enhancement/maintenance project. It uses various technologies like perl+shell scripting for reporting and loading of small data. Abinitio (ETL Tool) from loading and processing of data. Crystal Report for generation of various reports in specified format. This is very good project from learning point of view as this involves various technologies

Environment: Sybase 11.5/12.5, Unix, Perl, shell scripting, Autosys jobs, Abinitio, Crystal ReportClient

Confidential

Responsibilities:

• Requirement gathering, Estimation, Project planning, Design and Architecture.
• Responsible for System Analysis, Technology Assessment and coding of base components.
• Mainly focused on SYBMON activity for each Database and Database Design (Creations of Tables, Triggers, and Procedures etc.) & maintenance for DB Migration Project. For gathering SYBMON info, I have created some Shell script & Perl script and update this info in migration Database through scripts. At the end from the information, which is collected, I generated a report to categorize each database into the No Activity, Read Only Activity, DBA Activity, and Write Activity buckets accordingly.