SUMMARY:

• With 10 years' solid experience in analysis, design and development of trading applications.
• Expertise in Database Modeling, Designing, Implementation, basic Administration in Sybase ASE database, Oracle PL/SQL, scripting in languages like PERL, UNIX and Core JAVA on UNIX platform.
• Have solid experience in Performance tuning and Query Optimization for Sybase 12.5 and 15 ASE database.
• Possess basic knowledge of Informatica BI Tool as well.
• Hands on experience on bug and defect tracking system like JIRA.
• Strong expertise in version control tools like Clearcase and SVN.
• Worked on various automation tools like crontab, Autosys, Control M, etc.
• Strong experience in supporting database applications by troubleshooting any issues with deployment, database issues, development tools and general database requests.
• Certified in NCFM Capital Market Beginners Module and NCFM Equity Derivatives Beginners Module conducted by NSE India. They help me gain key capital Market skills with respect to the Credit Risk Area.
• Strong knowledge with respect to the Credit products and about most of the OTC Equity derivatives products. Basic understanding of Hedge funds business.
• Very Wide experience of process re-engineering, worked on all phases of SDLC Software Development Life Cycle . Converted Flat File Hierarchical Databases System in to SYBASE system.
• Proficient in Logical/Physical Data Modeling and Database Design: identifying entities, Normalization/De-Normalization, preparation of Logical Layout and Schema
• Strong analytical and problem solving skills. Ability to prioritize, delegate and motivate. Excellent written and verbal communication skills.

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE

Confidential

Role: Technical Lead

Responsibilities:

• Developing, enhancing and maintaining CSV feeds which creates various real time CSV files and are ultimately sent to the downstream team to meet the Reporting Requirements.
• Developing and enhancing ARRT feed which is an EOD feed to generate Regulatory data for various jurisdictions and sends to Automated Regulatory Reporting.
• Involved in development of stored procedures, Cursors, Triggers and various other database objects. Query optimization, imposing integrity constraints and rules, creating indexes, locking and concurrency control are also part of my responsibilities.
• Involved in handling production issues associated with multiple feeds and providing solution.
• Owner for tuning the performance of ARRT feed which process around 1 million records daily. Also tuning the CSV job as it runs every 15 minutes to report real time regulatory details.
• Created/maintained/modified the WIKI link which highlights all the details of the feeds and frequently occurring issues around them.
• Owner for performing the regression testing of all major releases for all Credit XIB feeds.

Environment: Sybase 12.5 15 ASE, Shell Scripting, Control M, Clearcase, SVN, JIRA System.

Confidential

Role: Technical Lead

Responsibilities:

• Acting as a Database Architect/Application designer and make sure solution meets quality standards and is in line with client vision.
• Involved in creating detailed design documentation based on assessed gaps in architecture, infrastructure and conceptual design. Review detailed designs with stakeholders and adjust based on feedback.
• Involved in the data mapping process of the custom POET tool entities with the Oracle RMS entities and producing a detailed design and creating custom fields for non-matching entities.
• Worked as a Technical Architect to design the day-to-day operations of the company and providing improved solutions regarding advanced tool implementation and using advanced hardware.
• Responsible for suggesting enhancements and how the solution would impact the normal day to day activity of the client. Involved in identifying any gaps in the application and would suggest solution for the same.
• Involved in coordinating the work between his peers to ascertain work assigned is completed on time with quality.

Environment: CA Erwin Data Modeler, MS Visio, Oracle PL/SQL, MS SQL Server 2012.

Confidential

Role: Technical Lead

Responsibilities:

• Developing a new feed which is a single strategic Credit CORE feed from Pyramid database to other downstream systems. This strategic feed will consolidate multiple feeds into one feed per instance. Also it will facilitate in saving more processing time.
• Involved in all phases of Software development life cycle including System Analysis, Design, Data Modeling, Implementation and Support of DAC DCPP application in OLTP environment.
• Developed logical and physical data model using Microsoft Visio.
• Created/maintained/modified database design document with detailed description of logical entities and physical tables along with data dictionary.
• Responsible for performance tuning of the feed to meet strict downstream team SLA's.
• Created multiple nested stored procedures to populate the staging tables for each record content type and storing this data in main tables for support. All the business logic pertaining to the Trade details/Cashflows/MTM values is incorporated in the stored procedures.
• Cursors are implemented for extracting spread details for each fee leg instruments and updating the leg details in temporary tables. Views were created on a single database for certain reference data tables which are fragmented across databases.
• Supporting the database application by troubleshooting any issues with the deployment process, database issues and general database requests.

Environment: Sybase 12.5 15 ASE, Shell Scripting, Perl Scripting, Control M, Clearcase, SVN, JIRA bug tracking System.

Confidential

Role: Associate Developer

Responsibilities:

• Creation of Stored procedures for static data maintenance. Triggers on insert, update or deletion of trade records after successful validation.
• Cursors for inserting high volume of financial instruments like Equities, Fixed Income, Futures and Foreign exchange.
• Views to provide limited access to the data for other users.
• Perl modules to read files from Minerva, parsing the fields from file and loading to main table.
• UNIX shell scripts to send various reconciliation/exception reports to external clients and accounting systems in a desired format.
• Multiple PERL modules are called dynamically depending upon the files and the formats in which the reports are to be sent via SFTP, email, etc.

Environment: Sybase 12.5 ASE, Oracle PL/SQL, Shell Scripting, Perl Scripting, Autosys, Clearcase, SVN.

Confidential

Role: Associate Developer

Responsibilities:

• Performed role of data analyst in interacting with business analysts and developers to analyze the user requirements, functional specifications and system specifications.
• Created conceptual, logical and physical models based on requirements gathered through interaction with upstream EAST team.
• Massaged the existing model to create new logical and physical models that formed the basis for the new Security Master application.
• Created stored procedure for loading high volume of data into the staging tables and later into the master table. Created procedures for Static data maintenance and performing updates on financial fields in the base tables.
• Stored procedures for inserting instrument and pricing data. Triggers are fired on insert/update/delete ensuring validation of data in base tables. Data inserted in the base tables is done using cursors. Views to provide limited access to the business users through web based application.
• Reading pipe delimited files from data feed, parsing the fields from file and loading to buffer database using PERL. Manipulation of data involving Financial Calculations using PERL subroutines. Shell scripting to streamline the job on a daily basis and send the status updates to the users.

Environment: Sybase 12.5 ASE, Oracle PL/SQL, Shell Scripting, Perl Scripting, Core Java, Crontab.

Confidential

Role: Associate Consultant

Responsibilities:

• Reading various types of files, parsing the fields from file and loading to database.
• Manipulation of data involving Financial Calculations.
• Various classes used to parse different file formats from different locations. Info about the files and modules to parse the files are stored in database. Modules are called dynamically.
• Java classes to retrieve and compare data from two database systems. Database connection objects using JDBC.
• Converting reports to EXCEL/CSV using XML/XSLT.
• Stored procedures for inserting or updating real time as well as retrieving static data. Triggers on insert.
• Status Report applications - Java and Perl programs to retrieve the info from database Sybase and sending the HTML report as an email. Also displaying status report on JSP.
• GoFtp module within GoRec developed to retrieve necessary information from ftp sites and storing the regular expressions of files in database.

Environment: Sybase 12.5 ASE, Oracle PL/SQL, Shell Scripting, Perl Scripting, Core Java, JSP, Autosys.