SUMMARY:

• Senior Lead Developer with 15+ years of experience in business software development with extensive hands on experience in full software development life cycle, design and analysis, database programming, tuning for performance, Integration, Data Modeling, RDBMS, System and Business Analysis and implementation.
• A highly motivated, self directed, good team player and experienced Developer with good communication and interpersonal skills.
• Extensive experience in Sybase and using Informatica tool for implementation of ETL methodology in Data Extraction, Transformation and Loading.
• Excellent knowledge on Database Design, SQL, Performance Tuning using the (Sybase, Oracle, MS SQL Server).
• Experience in full job scheduling like Autosys and Control - M.
• Proficient in UNIX/Linux Shell Scripting.
• Data knowledge and experience working with large data files. Has experience working on the full life cycle of complex development projects. Detail oriented and able to work on multiple projects at a time.

TECHNICAL SKILLS:

Databases: Sybase 15, Sybase 12.5, MS SQL Server 2008, Oracle 11g

ETL: Informatica 9.1, Informatica 8.6.2

Operating Systems: Solaris, SunOS, Linux

Schedulers: AutoSys, Control-M

PROFESSIONAL EXPERIENCE:

Confidential, NY

Database Developer

Responsibilities:

• I retrieve data based on the Marketing user requirements for contacting Confidential members.
• The campaigns contact members via email or direct mail to inform about the services that are available to them. I use MySQL, Linux for the purpose.

Confidential, Jersey City

Database/ETL Developer

Responsibilities:

• Involved in the data migration for JPMC’s new application 4Site.
• Used MS SQL Server 2014, Oracle 11g and UNIX Server scripts for the purpose.
• Migrated the data from legacy system into the new application.
• Developed stored procedures to process the data.
• Loaded the data into Oracle server using Unix/Linux scripts and Informatica. Data is then copied into the reporting database.

Confidential, New York

Database Developer

Responsibilities:

• As a Lead Developer, Involved in database development for the mobile application.
• Created and maintained new database for the Mobile application.
• Created stored procedures to provide data to the mobile application.
• Involved in defining the replication rules to share data across all four regions.
• Maintained multiple versions of the mobile database code and formulated a process to maintain it.
• Defined the replication rules to share the data between regional servers.
• Design & development for data transfer from Spider to new desktop application that uses Sugar CRM.
• Development and enhancement of the regulatory processes in Spider.
• Supported the legacy system by performance tuning, enhancing existing process and support user requests.

Confidential, New York

Database/ETL Developer

Responsibilities:

• Development and enhancement of the custody reports.
• Used Sybase 15 and Informatica 9.1 for the purpose.
• Integrated with upstream trading system to load the position/balance/activity files in Sybase 15 databases.
• Implemented the Asia EOD processing stream. I have used Sybase 15 stored procedures for the purpose.
• Involved in the migration of the contract, activity and pending returns reports from legacy Sybase platform into SQL Server reporting database.
• Performance and Tuning of the Sybase 15 stored procedures.
• Responsibilities included daily analysis of the reporting issues and production support.
• Supported Cost Basis Reporting using Informatica 9.1. Responsibilities included production support, processing the files, making ongoing enhancements and performance improvements.

Confidential, New York

Database/ETL Developer

Responsibilities:

• Migrated all Informatica 6.1 version processes to version Informatica 8.6.2.
• Developed new Informatica processes to load the files into the Sybase 12.5 and Sybase 15 databases.
• Supported the Domestic Contracts System and Global Stock Loan system data loads for Products/Prices, positions, activities and balances.
• Performance and Tuning of the Sybase 12.5 stored procedures.
• Used Informatica 6.1, Informatica 8.6.2 and Sybase 12.5 for the purpose

Confidential, New York

Database Developer

Responsibilities:

• Developed reports for Compliance and Regulatory Control Groups to monitor the activity of the traders in the North American region. I have used Sybase 12.5 and Perl 5.6 for the purpose.
• Enhancements and Performance Tuning of the existing reporting procedures in Sybase 12.5 database.
• Received data from all the trading systems within Confidential North American region. Loaded the data into Sybase 12.5 database.
• Developed/enhanced reports using Perl 5.6 accessing the server to retrieve the data for the Compliance and Regulatory needs.

Confidential, New York

Database Developer

Responsibilities:

• Performed daily support of Domestic Contract System.
• Responsibilities included support, analysis and enhancements of the Domestic Stock Loan Trading Application, Short Sales, Cross Regional System and MIS based on the user requests. Used Sybase 11.9.2 (Transact SQL, Stored Procedures), Bash Shell and Perl 5.6 for the purpose.
• Documented the Cross Regional System, Short Sales and MIS using Microsoft Word.

Confidential

Database Developer

Responsibilities:

• Responsibilities include the daily support, analysis and development for new clients and pricing sources, enhancements to the existing clients and sourcing new data into the data warehouse. Used Bash Shell, Perl 5.6, Sybase 11.9.2 (Transact SQL, Stored Procedures) for the purpose.
• Implemented a process to obtain prices from Bloomberg through the Per Security Feed.
• Wrote a process to choose best price among multiple prices from different vendors based on the business rules.
• Retrieved data from the production server in flat files using Informatica.