CAREER SUMMARY:

Sixteen years of diverse and progressive experience in Technology, and Finance Services Industry with a successful track record and expertise in hands on development, development management, gathering functional requirements, technical design and successful delivery of projects. Excellent interpersonal and communication skills with ability to deliver projects on time and within budget.

TECHNICAL SKILLS:

• Databases: Oracle 8i/9i/10g/11g, MS SQL Server, Sybase 11/10/4.9.1, MySQL, DB2, UDB, Teradata, MSAccess.
• Environments: Windows NT/XP/Vista/7, Solaris 5.7, UNIX, Linux Fedora, z/OS
• Tools Used: Informatica 7.1/8.6, JBuilder 7/9/X, Eclipse, IBM Websphere 6.1, BEA Weblogic, 7/8.1, Blaze Advisor, IPlanet 6.5, Cognos Impromptu/IWR 7.0, Crystal Reports, Peoplesoft 6.0/7.0/7.5 AP/Purchasing, MS Visual Studio .NET, Erwin 4.1.2, MS-Office 2000, Visio 2000, Rational Rose, BOXI Universe and WEBI , Hi Portfolio, Microgen Accounting Hub
• Languages Used: Python 2.6, Perl, VBA, J2EE, Core Java, JSP, Servlets, Tag Libraries, Struts, Spring, Javascript, C , HTML, ASP, PHP, XML, XSLT, XPATH, PL/SQL, TSQL, C , C, Visual Basic 6.0, Peoplecode, SQR/SQC, smalltalk, FORTRAN, Pascal, UML.

EXPERIENCE:

Confidential

Senior Risk Technology Consultant

• Reporting to Head of Risk Technologies. Responsible for architecting solutions using technologies such as Python, SAS, Sybase, and Java to enable business intelligence and warehousing of data related to counterparty/netting set, trade, and capital and credit exposure to facilitate timely reporting and business analysis for Credit Risk Management in investment banking division.
• Designed,developed, and deployed a home grown one stop shop risk reporting system which allowed integration across various risk systems. The objective was to remove redundancy of reporting systems and allows customizable solution to allow dynamic federation of data across multiple disparate data sources.
• Provided technical and business analysis support to traders, Credit Limit Managers, Portfolio monitoring managers, risk managers, credit product officers, and PnL analysts which includes explaining current exposure CE , Peak Potential exposures PE , PE at various tenors for both Credit and Capital streams.
• Created reports encompassing basel 2 B2 and basel 3 B3 Effective Expected positive exposures EEPE and Effective Maturity EM at counterparty and netting set level. This involved understanding and analysis of Probability of Default PD , Expected Amount at Default EAD and Loss Given Default LGD . OTC derivative exposures received IMM Internal Model Methodology treatment for Capital Reserve Calculation.
• Worked on establishing prod parallel server to enable gauging of exposure impact pre and post batch cycle. This environment was utilized to specifically measure and calibrate Multifactor model behavior prior to going LIVE
• Wrote technical requirements for enhancements to the Risk Reporting Engine and its reporting applications.
• Drove software development forward on the RE development teams in order to hit delivery dates.
• Ensured that the numbers produced by the RE are correct as the RE is enhanced and improved.
• Coordinated with offshore Quality Assurance team for the validation of RE valuation and various reports.
• Assisted middle office/business teams in system User Acceptance testing planning and execution.
• Hands on experience with Quartz SEC DB , SAS, Python, VBA, Sybase, SQL, Java.

Confidential

Senior Consultant

• Reported to the director of IT for Trading and Banking. Responsible for leading the maintainance, analysis, development and deployment of order management, post trade and banking systems.
• Worked on configuration and maintainance of Charles River order management system. This also involved developing ETL processes using SQL, JAVA, python, and informatica to maintain beginning of day and end of day Charles River data. The data was stored in a MS SQLServer.
• Worked on some informatica jobs related to data quality for Charles river which performed data quality checks and created auto notifications to inform IR's and traders of relevant data issues.
• Helped IR's and CSA's with order execution in Charles River to resolve pre-configured compliance alerts which had been established per broker/portfolio strategy.
• Maintained Perform/Credit Scope by Investor Tools , a third party tool, which is used to managed Fixed Income portfolio strategies for clients. This also involved building pricing and holdings feed from upstream systems based of which trade tickets were generated to meet the set threshold of a holding within each portfolio.
• Maintained feeds from multiple OMS Order Management Systems to enable registration of those trades in the company's accounting and settlement systems.
• Worked with portfolio managers and quants to meet their adhoc requests related pricing and PnL.
• Maintained feeds for Barclays banking systems which allowed clients to establish checking account s and debit cards with BONY Bank of New York . Built and maintained jobs to sync data with BONY and vice versa.
• Implemented and maintained a payment processing system from Bottomline C-Series Check Processing , which allowed the accounts payable department to issue checks to appropriate parties on a daily basis by reducing human intervention. This involved installing and configuring the software to ensure proper transmission of check data in the payment database.
• Performed releases and implemented deployment schedules for Charles River, Payment Processing, and Perform.
• Created Autosys JILS, which trigger the batch jobs created using Python, Unix, windows scripts, JAVA and Informatica.
• Worked with users and off shore teams to resolve production issues.
• Created runbooks for offshore production support teams.
• Experience with SQL Server, PL/SQL, JAVA, informatica, Python, Perl, Charles River, and Perform Investor Tools .

Confidential

Solutions Architect /Engineer

• Reported to the Executive Management of Asset Management. Responsible for the Development and Analysis of asset management systems such as Daily Performance PnL and PnL Attribution which is used in the management and tracking of asset portfolios worth 235 Billion.
• Analyzed and created the business specifications and technical architecture documentations for the Mandate PnL project.
• Actively worked with product controllers to analyzed and solve day to day PnL Performance related issues which were may have been caused due to either bad data, data format changes from external vendors or mistimed batches from the upstream systems within the firm.
• Designed and implemented strategic fixes if and when issues related to data or code aroused and prioritized this with product controllers to get them deployed in production.
• Leveraged Account and portfolio management systems such as HiPort, Microgen, Perform, and Peoplesoft to lookup info related to sub ledger and Journals to prove out numbers to management.
• Developed ETL processes using stored procs and functions in Oracle 11g via PL/SQL and informatica.
• Used VBA macro to perform Flash PnL calculations allowing users to verify results with the online system.
• Used JAVA, Business Objects XI, Oracle SQL and PL/SQL, VBA and SAS programs to create trade, position and PnL performance and attribution reports and online system.
• These reports were heavily used by product controllers to verify roll breaks, DTD/MTD/QTD/YTD performance per investment manager, and determine adjustments on price, security, portfolio and investment line levels.
• The reports were also used to feed into the the Asset Management's executive management presentations on a weekly basis to keep track on asset performance and attribution.
• Created three way monthly recon reports to verify Asset Management's PnL performance numbers with external portfolio manager systems and company's accounting system to maintain consistent reporting throughout the organization.
• Created UML artifacts to communicate technical specs to users as well as Developers and Architects.
• Created Autosys JILS, which trigger the batch jobs created using JAVA and Informatica.
• Worked with users and off shore teams to resolve production issues.
• Created runbooks for offshore production support teams.
• Created data migration document to architect solution for performing initial and incremental daily updates to the database.
• Created data dictionary for all columns in the database
• Hands on Experience with PL/SQL, Business Objects XI, Informatica, SAS, VBA and JAVA.

Confidential

Senior Consultant

• Reported to the Director of Technology for client delivery. As a consultant was responsible for leading design and architecture of Treasury Auction Analytical System in 3 months.
• Analyze the business requirements and prepare the technical requirements documentations.
• Created project plans to plan out implementation of data warehouse for ad-hoc querying.
• Created star schema model using ERWIN to meet requirements for creating AdHoc queries using Business Object Web Intelligence WEBI and Universe Designer.
• Created data migration document to architect solution for performing initial and incremental daily updates to the data warehouse.
• Created field mapping document for the data warehouse, which will supplement developers for mapping created via Informatica.
• Created data dictionary for all columns in the Universe and data warehouse
• Created document to architect rollup drill down's for the Universe.

Confidential

Senior Consultant

• Reported to the Senior Director of Legal/Compliance. Responsible for leading development and maintenance of an Asset Retention system and Master Account system.
• Analyze the Business requirements and prepare the technical requirements documentations.
• Created project plans to manage maintenance and enhancement releases.
• Held weekly meetings with user to go over issues log and prioritize tasks for maintenance releases.
• Lead a team to perform migration of Informatica jobs from 7.1 to 8.6 in conjunction with the oracle upgrade from 9i to 10g
• Worked with Testers to perform regressions testing after system enhancements.
• Worked on a DR test plan which, drastically reduced system down time.
• Worked on creating algorithm to create an automated process to reassign accounts of a departing FA to other FA s based on a qualification matrix. This was done in a J2EE environment WAS using Struts, JSP, and Servlets
• Created Reports using JAVA, IText, and Apache POI to create excel and PDF reports which, are used by field branches and Home office users to make business related decisions.
• Created Stored Procedures and Triggers which were used for persisting data and creating audit trails.
• Created UML artifacts to communicate technical specs to users as well as Developers and Architects.
• Worked on data mappings design and development using Informatica and JAVA.
• Created Autosys JILS, which trigger the batch jobs created using JAVA and Informatica.
• Worked with mainframe datasets, which were used by Informatica jobs via Power Exhange.
• Hands on experience with Informatica PowerCenter version 7.1/8.6, Oracle PL/SQL, and Data modeling using Erwin, JAVA, J2EE, Struts, Spring

Confidential

Senior Consultant

• Reported to the Senior Vice President of Securities Evaluations SPSE . Responsible for managing a group of Junior System Analysts, coordinating projects, creating technical/functional documents, use cases, test cases, Mappings/ Mapplets / workflows using Powercenter Designer and Workflow Manager, SAS, JAVA.
• Developed complex mappings using Informatica PowerCenter Designer to transform and load fixed income data from various source systems like Oracle, DB2, Sybase into the Oracle target database.
• Created Proprietary Pricing models using excel, SAS, JAVA, Intex API for Municipal, Government and Corporate issues for vanilla, floating rate, and Step coupon bonds by researching and working with experienced evaluators. These models were then relayed to IT via use cases, model spreadsheets, and pilot programs.
• Designed and developed yield curve for municipal bond system, using technologies such as UML, Oracle, MSAccess, and JAVA.
• Wrote complex SQL queries to meet users request for information.
• Liaised between IT and Business to create reliable pricing models and research data by writing use cases, UML Diagrams, and test cases.
• Created and coordinated Project Plans and Testing efforts in the user community.
• Mentored Junior Analysts to write good use cases and test cases.
• Hands on Experience with PL/SQL, Informatica, JAVA, SAS.

Senior Consultant

Reported to the Director of fund evaluations. Responsible for managing a group of developers, providing project estimates, creating technical and business designs for Unit Investment Trust system, and delivering projects on budget and time.

• Successfully lead the technical design and development of UIT Unit Investment Trust System . This system is one of the many evaluation systems that provide clients such as Merrill Lynch, Bear Stearns fixed income evaluations data on municipal and corporate bonds along with close ended funds. It was developed using J2EE technologies.
• Successfully lead the initiatives to DR certify Disaster Recovery the UIT system. This involved working with teams across the organization and making sure DR drills were performed successfully.
• Lead the conversion effort of Mercator based mappings to Informatica based mappings.
• Worked with Evaluators to understand and implement new enhancements and features in the UIT system.
• Worked on ratings delivery platform by performing enhancements to Ratings Direct portal using technologies such as Oracle XSQLRequest, JAVA, and XML.
• Hands on Informatica, Oracle PL/SQL, Core JAVA, EJB's, JSP, Servlets

Confidential

• Senior Systems Analyst Reported to the head of the Strategy group. Lead a group of off-shore based developers, Created project plans, technical designs using UML based structures, and use cases.
• Worked evaluating tools for data cleansing in GWM Global Wealth management such as Informatica Data Quality, and SAS. The objective was to decrease data maintenance cost, enforce data ownership and improve productivity.
• Worked on the rewrite of Trade Confirms and Master Security Database systems to improve performance and improve data quality. Created Technical and Functional Design Documents using UML artifacts. Created mapping documents along with business rules which would be implemented in JRules.
• Worked on the Pre-Year statement summary project, which involved analyzing and extracting data via Informatica from the books and records system to the statements Data mart.
• Evaluated tools BPM tools from IBM, and Adobe to solve the needs of expediting new account opening process.
• Created vendor matrix template for evaluation of third tools.
• Create common components using JAVA, and Eclipse. Built components such as exception handler, mailing agent, pdf reader writer. Used open source software such as Jasper, iText.
• Created canonical XML and built web services for books and records systems, which enabled various GWM product systems in leveraging common business processes to reduce coding, and data redundancy.
• Hands on Experience in Informatica, SAS, PL/SQL, UDB, Teradata, JAVA

Confidential

Technical Lead

• Reported to the Director of Information Technology. Responsible for providing workload estimates to project manager, creating technical and functional designs for compliance and legal systems, and delivering projects on budget and time.
• Successfully led the functional/technical design of EARC Equitable Agents Reinsurance system . The system administers policy and agent persistency information for quarterly and year-end processing. The system was developed using J2EE technologies such as EJB, JSP, Servlets, and Tag Libraries with heavy emphasis on design patterns. Reports were created using Cognos Impromptu/IWR with Oracle as the backend.
• Led the technical design, and development of Complaint Tracking system CTS . This system keeps track of complaints made against agents by the policyholders. Reports were developed in Cognos to track the net loss to business in a given year. This system was implemented using technologies such as Struts tag libraries, JSP, Java Threads, and Oracle.
• Designed and developed Outside Securities Transaction system OST . This system keeps a record of all outside accounts held by agents/employee and their respective family members. This system was implemented in using technologies such as Visual Basic, COM, JAVA, Cognos Impromptu/IWR, and Oracle.
• Involved in the implementation of the Advertising Management System AMS . The system is used to enter information filed by the agents to receive approval on a given advertisement that the agent wishes to submit. This system was implemented using J2EE technologies with Oracle as the backend.
• Evaluated third party tools for tracking replacements performed by agents without the policyholder's consent. This resulted in the design and development of RMS Replacement Management System , which uses a rules based engine Blaze Advisor to determine possible replacements thereby saving the company millions of dollars in NASD penalties. This system was implemented using J2EE technologies, RMI, JAVA Threads, and Oracle.
• Maintained and Enhanced features of AXA's Corporate Legal Management System, which is a third party vendor tool from CORPRASOFT. The system provides the paralegals and other legal department administrators with a web based front end to administer legal, and invoice information. This system was developed using XML, XPATH, ASP, Javascript, Visual Basic, Crystal Reports, and SQLServer.
• Designed and developed an ETL process using Informatica, which loads agent and policy data from the data warehouse and updates the compliance databases. These databases are used in conjunction with all the legal and compliance applications/reports.
• Implemented J2EE Design patterns standard for developing efficient and reusable API's, which reduced coding, and maintenance time for projects.
• Hands on Core JAVA, EJB's, JSP, Servlets, JavaScript Tag Libraries, Struts, Visual Basic, Blaze Rules Engine Fair Isaac , Informatica, Cognos, Erwin, Visio, XML, DTD, XML Schema, XPATH, MSXML, UML, Oracle PL/SQL, and SQL Server Transact SQL.

Confidential

Applications Programmer

• Successfully implemented a web based PC management system. This was an Intranet application written for the PC support group. This application enabled them to keep a track of all the PCs handed to employees of the company, issue trouble tickets to resolve technical issues.
• Implemented a Web open enrollment application which enabled employees to make modifications to their benefits, 401K, and HMO enrollments.
• Played a major role in upgrading PEOPLESOFT from Version 6.0 to Version 7.5, Involved in moving, testing, and debugging panels, records, and peoplecode in versions 7.0 and 7.5.
• Created Accounts Payables/Receivable and Purchasing reports for respective business users using cognos, SQR's and SQC.
• Customized the PEOPLESOFT user interface and business logic to conform with company's business rules for purchasing and creating vouchers.
• Hands on Peoplesoft, Peoplecode, SQR, SQC's, JAVA, Sybase.

Confidential

Tutor/Web Developer

• Designed, Developed and Implemented virtual world of NJIT using HTML, VRML, and JAVA.
• Tutored students in undergraduate Math and Physics courses.
• Graded class assignments and developed weekly student performance reports.

Confidential

Summer Intern

• Created end-user applications using MS Access.
• Responsible for software installation and troubleshooting for end-user desktops