SUMMARY

• 19+ years of professional experience in Information Technology industry. In - depth, hands-on knowledge of Project Management, Business Analysis, Data warehousing / Business Intelligence and software methodologies.
• Extensively experienced in gathering, documenting and managing Functional and Technical requirements and implementing solutions and best practices to projects in Banking & Capital Market domain.
• Knowledge of various asset classes like OTC Derivatives, Equity, and Fixed Income with middle and back office trade flows.
• Extensive experience in managing the Delivery with Onsite-offshore model to produce quality deliverables within aggressive deadlines.
• Very high client focus and have successfully managed client relationships in North America & Europe.
• Knowledge of SWIFT messaging system in FIN domain (MT54X, 537, 202/210, 103, 304).
• Knowledge of FpML and XML messaging system in Derivatives domain.
• Knowledge of OTC Derivatives products (Credit, Interest Rate, Equity and Commodity).
• Knowledge of Dodd-Frank, EMIR Regulatory Compliance (for OTC Derivatives) and EU CSDR.

TECHNICAL SKILLS

BI Reporting Tools: Business Objects, Informatica Power Analyzer, Cognos

ETL Tools: Informatica Power Center

Data Modeling Tool: ERwin

Databases: Confidential, Sybase

Languages: Java, SQL, Confidential, Basic Shell Scripting

Web servers: Tomcat Web Server

Other Tools: JBuilder, TOAD, SQL Navigator, VSS, Star Team, Mercury Test Director, Peregrine ServiceCenter, ClearQuest Web, Quality Center (ALM), MQ, JIRA, Confluence, PuTTY, Rational Team Concert

PROFESSIONAL EXPERIENCE

Confidential

Lead Business Systems Analyst

Responsibilities:

• Working with Business users to elicit the requirements.
• Drafting the Systems specifications and mapping artifacts for SWIFT and proprietary messages.
• Working on the Infomediary message routing and configuration specific to each client.
• Working on the implementation of CSDR (Central Securities Depositories Regulation) Penalties Framework using MT537 messages.
• Carrying out System and End-to-End Testing for client implementations.
• Triaging the issues detected during UAT and post-Production.
• Carrying out the Release Management tasks for client implementation projects.
• Working as Scrum Master for in-house product development.
• Working as Project Manager for multiple workstreams within Merva Replacement initiative.

Environment: XML, Confidential, Confidential, Unix, MQ, JIRA, Putty, Mercator, SQL Developer, Agile

Confidential

Lead Business Systems Analyst

Responsibilities:

• Prepared the project milestones and managed the concurrent onboarding of new/conversion clients to Derivatives Hub.
• Managed the team of Analysts in the OTC Derivatives application team.
• Worked with the Product Owners and acted as proxy Product Owners in grooming the Agile stories and managed the Backlog and prioritized the deliverables in each iteration.
• Mapped the Inbound trade from client’s format to HUDL (Hub Unified Data Language) for ingestion to Derivatives Hub and to the downstream system for data extracts and reports.
• Articulated requirements for MO, BO and Regulatory Reporting functions.
• Managed the Data within Derivatives Hub for ISDA Agreements, Index Benchmarks, Equity and Index tickers, Pricing, Markit RED codes, Sec Master, Business Centers, Holiday Calendar, CCPs, NDF currencies etc.
• Coordinated with the market data providers (like Bloomberg, Copp-Clark, Markit, ICE and Reuters).
• Carried out data validation and data quality checks using SQL.
• Worked on “Data-as-a-Service” platform for aggregation and distribution of data.
• Carried out Position and Account reconciliation of specific clients in MO.
• Triaged various issues raised by client and BAU users related to trade errors, configuration, Ref Data, downstream integration, IBOR/ABOR functionality.
• Trained the Business users to configure and set up various products and processing rules within the application.
• Partnered with internal client, technology and business groups across the bank.

Environment: FpML, XML, Confidential, Unix, MQ, RTC, JIRA, TOAD, Putty, ISDA, EMIR, Agile

Confidential, Boston, MA

Responsibilities:

• Managed multiple new client implementations from Post-sales to Go-live.
• Facilitated cross-functional discussions with Clinical, ETL and Data Management teams.
• Analyzed large clinical data sets, identified the trends and patterns within them and flagged the anomalies in the data.
• Performed gap analysis between the client data and the product specifications.
• Performed loading of the data extracted from client EMR, Billing and Payer systems into Confidential staging environment using SQL Loader.
• Managed the Project Plan and the deliverables throughout the implementation process from initial engagement to delivery of application.
• Managed the monthly release and data refresh activities and coordinated the data issues, if any, across teams.
• Mentored the junior Business Analysts.
• Presented analytic output to the clients to facilitate strategic and tactical decision-making.
• Received “Bravo-Amethyst” cash for Best Performer in Data Management team.

Environment: EMR/EHR (Centricity Logician/eCW/Epic/NextGen/MED3000), CMS, HL7, EDI 837, Confidential, SQL Loader, JIRA, Unix

Confidential, Boston, MA

Responsibilities:

• Drafted the mapping documents between client’s Front-office and TradeFlow for Incoming trades - Equities/Fixed Income/Repos/ETDs (MT541/543), FX Spot and Forwards (MT304), MM (MT320/330), Payments (MT202/210/292) and OTC products (FpML).
• Gathered requirements for the Dodd-Frank Act for CDS, IRS and Non-Deliverable FX Forwards.
• Drafted the functional specifications and test scenarios for Credit Default Swaps, Total Return Swaps and Interest Rate Swaps.
• Liaised with the Hedge Fund’s Front office regarding capturing the trades and the data enrichment requirements as well as planning Bi-Party and Integration Testing.
• Assisted the Architecture team to define the flows for various assets and the impact of Dodd-Frank Act (for CDS, IRS and NDF FX).
• Identified opportunities for improvement in the business architecture.
• Planned the testing cycles and environment readiness for the scheduled releases.
• Carried out the Static/ Data set up in TradeFlow for OTC Derivatives.
• Provided defect triage and resolution to various business and technical issues in the TradeFlow product, focusing on root cause analysis.
• Coordinated with multiple vendors regarding releases, defect fixes and implementation.
• Coordinated end-to-end testing with downstream application owners (Summit, STAR).
• Managed and mentored a team of Development/Support and QA members for the deliverables and day to day activities.
• “Go to” person in the Middle Office Technology team.

Environment: SWIFT, TradeFlow/Heliograph (Fiserv), Summit (Misys), Volante, MarkitSERV, EagleSTAR, PACE, Omgeo CTM, FpML, Quality Center (ALM 11), MQ, Confidential, Unix

Confidential, Portland, OR

Responsibilities:

• Gathered the requirements from the Business users across various groups -, Billing, Claims, Sales & Marketing and Underwriting.
• Drafted the Business Information Requirements documents (according to standard templates), and then collaborated with stakeholders/SMEs to validate those requirements and obtained a Sign-off on those documents.
• Performed Gap Analysis on the existing system with an idea of figuring out the necessary mapping steps towards the new "Target" system.
• Worked with the Data Modeler and drafted the Logical Data Requirement towards closing these gaps.
• Drafted the Physical Data Mapping document for the data flow from Facets to the data warehouse.
• Drafted the Functional and Technical Specifications (the high-level business and user requirements decomposed into functional attributes, external interfaces, constraints, system and technical requirements) for the Operational reports.
• Functioned as a Business liaison to the Design and Development teams during translation of requirements specifications into software solution.
• Worked in the Scrum team and participated in backlog review and sprint planning sessions while following the Agile methodology.
• Validated the data fixes and carried out the UAT with the Business users before releasing to Production environment.
• Assisted in Project Management activities like effort estimation, task allocation, issue resolution and held post-launch review meetings to revisit the project.

Environment: Facets(Trizetto) 4.31/4.61, Clinical CareAdvance(Trizetto), Business Objects XI R2, DataStage, ERwin, Mainframe, ClearQuest, Remedy, SQL Navigator, SQL Advantage, Toad, Confidential 10g, Sybase.

Confidential, Monterey Park, CA

Responsibilities:

• Analyzed and documented the Business Requirements, ensuring that the requirement statements are complete, traceable, and unambiguous and that they conform to standards.
• Getting a formal sign-off from the Business Users and Stakeholders.
• Conducted JAD sessions as a facilitator to discuss requirements among the group.
• Lead the project team’s planning efforts and established delivery milestones.
• Participated in requirements prioritization.
• Drafted the Technical Solutions related to Business Objects development.
• Established several processes in the Credit Management Group regarding Documentation, Development and QA, with the goal of improving the efficiency and effectiveness.
• Worked in partnership with other Business Analysts of the upstream systems to understand the impact of their changes and to ensure proper integration of new solutions.
• Carried out extensive data validation.
• Created a Change Management Plan for the releases.
• Worked as a Production Support Coordinator responsible for prioritizing, escalations (where required), channeling the defects to the appropriate team, and ensuring that the applications meet their service level targets.
• Co-ordinated with the offshore delivery team for the releases.

Environment: Business Objects XI R2, Informatica PowerCenter 7.1, Java, Confidential 9i, Peregrine ServiceCenter, Win XP, Unix.

Confidential, Glendale, CA

Responsibilities:

• Performed Gap Analysis for new functionality requirements; as well as prioritized them based on actual business needs so as to align them with the product release roadmap.
• Analyzed ETL and Report requirements and prepared BRDs.
• Involved in developing mapping document indicating the source tables, transformation required, business rules, and target table’s columns and data types.
• Documented Requirement Traceability Matrix in RequisitePro for traceability of requirements through test cases.
• Conducted interactive JAD sessions with project’s stakeholders such as Business Users, QA Analysts, and project team, identifying and resolving issues.
• Developed Test plans and test cases based on functional specifications.
• Analyzed the session and error logs for troubleshooting the Data Loading process.
• Defined the access control layer through Business Objects groups and users.
• Developed the reports and dashboards.
• Provided BO support for the business users.
• Point of Contact for Enhancement and Defect Change Requests.

Environment: Informatica PowerCenter 7.1, Business Objects XI R2, Rational RequisitePro, Confidential 9i, Win2k.

Confidential

Technical Lead

Responsibilities:

• Interacted with Business Users and stakeholders to gather the requirements.
• Gap analysis of all dimensions required to build the new Data Warehouse.
• Involved in developing mapping document indicating the source tables, transformation required, business rules, and target table’s columns and data types.
• Involved in documenting the business requirements and data specifications for Business Objects Universes and Reports.
• Managed all the requirements in RequisitePro, making them available to the whole project team.
• Developed the workflows using Workflow Manager to run the sessions and monitor them using Workflow monitor.
• Managed a team of developers and testers.
• Created Test Scenarios and developed strategies with QA team to track and resolve defects.
• Used SQL tools like TOAD to run SQL queries and validate the data in warehouse.
• Keep track of scheduled environment refreshes and coordinate/communicate with Dev, Ops, and Analysts.

Environment: Informatica PowerCenter 7.1, Business Objects 6.5, Rational RequisitePro, Confidential 9i, Win2K.

Confidential

Business Analyst

Responsibilities:

• Identified the source systems and mapped with the user requirement in the role of Business Analyst.
• Completed the Requirements Trace Matrix by linking all BRDs, Functional Specifications and Test Scenarios.
• Developed Mappings in Informatica PowerCenter to load data from various sources using different Transformations.
• Implemented Unix / FTP Scripts to perform archiving operations for data files acquired on daily basis.
• Developed reports in Informatica PowerAnalyzer.
• Created Users, User Groups and Profiles in PowerAnalyzer.
• Scheduled the reports according to the precedence diagram.
• Kept track of the Change Requests.
• Liaisoned with vendor (Informatica) for patches and issue resolution.
• Performed comprehensive system and data validation.
• Used SQL tools like TOAD to run SQL queries and validate the data in warehouse.
• Active participation in team discussions, design sessions, mentoring and knowledge transfer initiatives.
• Created Unit Test and Knowledge Transfer Documentation for successful handover.

Environment: Business Objects 6.5, Confidential 9i, PowerAnalyzer 4x/5.0.2, TOAD, Weblogic, Windows, Unix.

Confidential

Associate Consultant

Responsibilities:

• Setting up the offshore development and testing environment for Global PAYplus.
• Reviewed and analyzed the Functional and Interface Requirement Documents for Citibank - London, Frankfurt and North America implementations and drafted the FSD.
• Translated business requirements into test suites involving SWIFT documents.
• Designed and executed test scenarios and cases.
• Responsible for generating test data (including the SWIFT messages like MT103/202), documenting defects and reporting test status.
• Development of BO Universe and reports with the capability of drill down and slice & dice.
• Drafted Program Specifications for the PAYplus enhancement.
• Coordinated with various functions (Development, Testing, and SQA) to meet planned release dates.
• Performed System Integration Testing (SIT) and User Acceptance Testing (UAT).
• Tracked the issues and comments through Mercury’s Test Director.
• Served as a liaison between core business group and Information Technology.
• Performed Function Point Analysis for Static Data Release.

Environment: SWIFT, CHIPS, RTGS, Java, XML, VB, Java Script, Confidential 8i, Tomcat Web Server, MTS, Tuxedo, JIntegra, Business Objects 5.1.8, Mercury Test Director, MQ Series, Win NT/2000/Unix.