SUMMARY

• Over 11+ years of experience in development, maintenance and implementation of Oracle and data warehousing projects.
• Working in a leading financial institution for their prime brokerage system (portfolio system) maintenance & up gradation.
• Hands on experience in software development methodology and practices including Agile Methodologies.
• Extensive experience in RDBMS concepts with Oracle9i/10g, PL/Sql, core java, jdbc, Aga (advent global area), RSLs, and UNIX shell scripting.
• Experience in ETI, Informatica, toad, plsql developer, Eclipse, Advent Geneva.
• Strong background on designing database schemas, handled large database and development of data transformations independently and extensive experience in performance tuning of oracle components.
• Experience in design and development of multi - tier applications using Java, J2EE,XML, HTML, JavaScript, Tag Libraries and JUnit
• Experience in web application design using MVC, springs and Struts Frameworks.
• Strong combination of business analysis, development and debugging experience in Oracle components, handing performance issues, exposure to oracle apps (o2c and p2p)
• Proficient in development and maintenance of applications in financial & capital markets and supply chain domains.
• Excellent verbal and written communication skills, excellent team player, lead & mentor team, involved in client interactions for scoping, effort estimates and status reporting.

TECHNICAL SKILLS

Programming Languages & Scripting: PL/SQL, core java, RSLs, UNIX shell scripting

Databases: Oracle, AGA (advent global area)

Domain: Capital Markets, Supply Chain

Platform: UNIX, Linux, Windows, Solaris

Tools: ETI, Informatica, eclipse, tortoise SVN, apache ant, cogons, Advent Geneva

Application Tools: Toad, PL/SQL Developer, MS Visual Studio

PROFESSIONAL EXPERIENCE

Confidential, Framingham MA

Oracle Consultant

Responsibilities:

• Analysis, design, and development as per client requirements.
• Discovery, Design and development of the database for FSA platform.
• Design and development of oracle database components (Packages procedures, functions).
• Integration of the database layer from source to target systems via Oracle Golden Gate.
• Design and development of FSA UI (web based application deployment in cloud)
• Cron jobs setup in Linux sever for data extract and loads to upstream and downstream applications.
• Design and development of the reports for the 360 view and event tracking by using dynamic sql.
• Design and development of file upload module. Implementation of Single Sign On, and service now integration for raising requests.

Environment: Oracle 12c, Pl/Sql, toad, Oracle Golden Gate, Jdk1.7, Ant build, tortoise svn, eclipse, apache tomcat, UNIX shell scripting, Jenkins GIT, JIRA.

Confidential, New York

Consultant/Analyst

Responsibilities:

• Analysis, design, and development as per client requirements.
• Development & maintenance of adapters for accounting & performance calculations.
• Handling the performance issues related to accounting & performance run times.
• Reconciliation of data between trading system, Geneva and pace applications. writing new RSLs for custom reports and changes to the existing RSLs and the ISL Specs
• Development and maintenance of the data transformations in Informatica.
• Maintenance of the adapters which loads the data into Geneva (using Geneva loader utility) and running the RSLs automatically and send the data to downstream systems (DB) for reporting purpose.
• As one of the custom requirement - developed a utility which will calculate the performance data (DTD, MTD, QTD, YTD) using the Daily Cumulative IRR Data.
• Developed Tools for Data comparison in Migration and up gradation. This includes running the RSLs on both the systems (Migration / Up gradation) and run the utility which will compare the RSL extracts from both the systems for data verification and validation across the systems.
• Developed tools which report the status of everyday accounting.
• Development of the custom reports in Geneva for PnL analysis, portfolio positions and lots, trades, non-trades, corporate actions, realized gain loss reports, change in net assets etc.
• Migration of the advent Geneva from version 7.6 version to version 14.2.

Environment: Oracle 11g, Pl/Sql, toad, Informatica, Java, Ant build, tortoise svn, eclipse, UNIX shell scripting, Geneva 6.0.6/7.6/14.2 , AGA (advent global area), RSLs, RDLs.

Confidential

Software Developer

Responsibilities:

• Planning, execution and estimation of the development effort.
• Design & coding new functionality for changing business requirements.
• Integration and performance testing i.e. Integration test plans & test execution.
• Production deployment as per Schedule.
• Concurrent programs creations as per client specifications.
• Sop’s (Service Operation Practices) creation for production support automation.
• Assigning and coordinating the development work according to project timeline.
• Suggest and implement improvements for data integrity.
• Application/Database - Performance tuning and monitoring

Environment: Oracle Apps 11, Oracle 9i, PL/SQL, Data Load, UNIX, QTP

Confidential

Software specialist

Responsibilities:

• Development using sdlc process to achieve the highest quality and to assign tasks and responsibilities.
• Integration of flat files and xml files using data mapping between the PUTs and GETs to integrate to oracle relational database components.
• Development of data transformations in ETL tool to extract/load the data from database.
• Designing database schemas.
• Development of data validation functions for client to validate the end user reports.
• Involved in integration and application testing.
• Development of reporting application for the status monitoring of the system logs and debugging.
• Design, development and implementation of the system in MVC architecture by using struts framework.
• Provided alternate solutions for business users for maintaining data transformation
• Design new functionality for changing business requirements.
• Unit tested the components using JUnit, integration.
• Bug Fixing.

Environment: Oracle 9i, Pl/sql, ETI, Unix Shell Scripting, ETL, Manugistics, pl/sql developer, toad, clarify case tool

Confidential

Software Specialist

Responsibilities:

• Gathered the business requirements.
• Implemented Software Development Life Cycle using agile methodologies.
• Weekly meetings with technical collaborators and active participation in code review sessions with senior and junior developers.
• Responsible to manage data coming from different sources.
• Analyze data and do required changes to PUTs/GETs components, for smooth run of Loads and Extracts.
• Wrote programs for integration of legacy systems using Java API.
• Participated in all phases of the development System Study, Analysis, Design, Development, Deployment, Testing.
• Tracked, worked assignation to team.
• Production Support and Maintenance activities includes observe the cycles proactively to avoid failures and fix them on emergency basis with minimum resolution time
• Creating DLDs for Enhancement requests from client.
• Design/Develop Stored procedures and triggers using PL/SQL
• Bug Fixing.

Environment: Oracle, Pl/sql. ETL Unix shell Scripting, Toad, and Pl/sql developer.

Confidential

Responsibilities:

• Provided Customer Support
• Analysis and estimation of new enhancements.
• Application Error - Bug fixing (mal function of application) raised by client
• Design and development of the reports using XML, JSPs, JDBC.
• Involved in performance tuning of the application and database design.
• Guided the team in providing the solutions in various modules.
• Participated in the implementation of efforts for coding, unit testing and code review.
• Monitor server and make recommendations for hardware for upgrades of space or add-ons (e.g. processors, disk space, memory) to accommodate current and planned server usage
• Participated actively in business discussions with the customer.
• Supported maintenance for the previous product releases.

Environment: UNIX, Windows XP, Java, J2EE, JSP, Struts, JDBC, WebLogic, Oracle 9i, UNIX Shell Scripting

Confidential

Responsibilities:

• Gathered requirements from the customer.
• Provided support for customers.
• Enhanced Installation framework.
• Implemented Software Development Life Cycle using agile methodologies.
• Involved in designing and database implementation of the project.
• Analysis and estimation of new enhancements.
• Involved in performance tuning of the application and database design.
• Participated in the implementation of efforts for coding, unit testing and code review.
• Experimental in implementing the Web Tool using Applets.
• Participated actively in business discussions with the customer.
• Supported maintenance for the previous product releases.

Environment: UNIX, Windows XP, Java, Jdk1.4.2, Jdk1.3, JSP 2.0, Oracle 8i, HTML, Apache 2.0.52, OAS 9.0.2

Confidential

Software Programmer

Responsibilities:

• Involved in Developing, Testing and Documentation of Reporting.
• Debugged the source code.
• Scheduling and Monitoring of Batch Jobs and immediate action in case of job failure
• Resolving Application Support Problems raised by business users users, user groups and security of the applications
• Provide assistance to users on the Application Functionality/Workflow

Environment: Windows, UNIX Oracle, Java, J2EE, JSP, Struts, EJB, HTML WebLogic, and Ant

Confidential

Software Programmer

Responsibilities:

• Requirements and Analysis: Understanding the requirements of the system and designing
• Interacting with the team leader and higher authority on various forums to discuss the scope of the project, clarify any queries regarding the functionality etc.
• Coding, Unit & Integration Testing
• Deployment & Quality related process

Environment: Red Hat Linux 9, Java, JSP, Servlets, Oracle 7, Tomcat4.0, PostgreSQL