Experience

Phoenix American Salesfocus Solutions

• India
• 1 - 100 Employee

• Technical Lead

  • Jan 2014 - Present

  Responsibilities • Responsible for coordinating between onsite and offshore teams• Design - gather high end requirements and come up with design documents for development team.• Database development.

• Senior Oracle Developer

  • May 2012 - Dec 2013

  SalesFocus has a product built called MARS which is used in United States by mutual fund companies. It is a Data driven application where major functionality is handled in oracle database and the UI is built in .NET. Responsibilities: • Responsible for writing and modification of PL/SQL stored procedure, functions, packages and Database triggers.• Developed, modified, and optimized complex queries for data retrieval and modification.• Optimized and Tuned SQL Queries by running Explain plans• Used advanced PLSQL concepts like Bulk collect, plsql tables and Dynamic SQL for DML operations for better performance• Created tables with complex constraints applicable to the business rules.• Extracted Transformed and Loaded(ETL) data source database to data warehouse system• Integrated oracle data to other sources like Salesforce ,Microstrategy, TotalClient Show less



JPMorgan Chase

• United States
• Investment Management

• Developer

  • Apr 2011 - Mar 2012

  Automation Team is an IT group which supports the Loan Transactions and manages the Document Services for Chase Bank. As a part of support activities the main roles include providing data extracts, developing reports for audit purpose, backend code development for various different functionality to be provided by the database for the various front end softwares depending on it. Responsibilities: • Developed reports for managers using oracle report builder for managers for auditing • Responsible for writing and modification of PL/SQL stored procedure, functions, packages and Database triggers. • Developed, modified, and optimized complex queries for data retrieval and modification. • Optimized and Tuned SQL Queries by running Explain plans and using SQL Hints • Used advanced PLSQL concepts like Bulk collect, plsql tables and Dynamic SQL for DML operations for better performance • Interacting with front end developers and involved with the development of stored procedures, triggers and with the privileges Show less



3L Media Inc

• Developer

  • Jun 2010 - Apr 2011

  Core is a product developed by the company which is used by clients to maintain and create the yellow and white pages either in print or online media. It is developed in Gupta team developer and uses a huge database. Main role in this position is to resolve the errors raised by customers and also includes some new development like adding new features to core. Also have been developing reports for customers. Responsibilities: • Interacted with Business Analysts and Users in requirement gathering • Responsible for writing and modification of PL/SQL stored procedure, functions, packages and Database triggers. • Used advanced PLSQL concepts like Bulk collect, plsql tables and Dynamic SQL for DML operations for better performance • Interacting with the users and troubleshooting the problems involved with the development of stored procedures, triggers and with the privileges • Involved in developing scenarios for Unit, Integration testing to ensure that all the components work correctly when integrated. • Involved in Production Support and troubleshooting data quality and integrity issues Show less