SUMMARY:

• 14 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 Business and Functional requirements in Banking & Asset Management and Healthcare domain.
• Worked as a Techno-Functional resource with a strong knowledge of Banking domain, SWIFT messaging system and Healthcare domain.
• Strong knowledge of front-to-back office trade flows for various Asset Types in Investment Banking domain.
• Worked on Global PAYplus - a product for transferring the funds globally.
• Worked on TradeFlow/Heliograph - a Middle-office product for post-trade processing.
• Extensive experience in Dimensional Data Modeling using Star/Snowflake schema, Fact and Dimensions tables, and Physical & Logical data modeling.
• Acted as liaison between Management and Development/QA team.
• Extensive experience in managing the Delivery with Onsite-offshore model to produce quality deliverables within aggressive deadlines.

FUNCTIONAL SKILLS:

Knowledge of SWIFT messaging system in FIN domain (MT54X, MT2XX, MT1XX, MT3XX).

Knowledge of FpML messages used in OTC Derivatives (CDS/CDX/CCY/IRS/TRS/FXO).

Knowledge of Investment Banking (Middle-office and Back-office) sector.

Frank Regulatory Compliance (with respect to OTC Derivatives and Non- Deliverable Forwards).

Knowledge of Healthcare Payer and Population Health Management sector.

Knowledge of HIPAA EDI Standards.

TECHNICAL SKILLS:

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

ETL Tools: Informatica Power Center

Data Modeling Tool: ERwin

Databases: Oracle, Sybase

Requirements Mgmt Tool: Rational RequisitePro, MS Visio

Languages: Java, SQL, PL/SQL, Basic Shell Scripting

Client Side Programming: HTML, JavaScript

Web servers: Tomcat Web Server, JSWDK

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

OS: Win9x/NT/2K/XP/Vista/10, Mac OS X, Unix

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

Sr Business Analyst/Implementation Manager

Responsibilities:

• Manage multiple new client implementations from Post-sales to Go-live stage and few others in Post Production stages.
• Facilitate cross-functional discussions with Clinical, ETL and Data Management teams.
• Analyze large clinical data sets, identify the trends and patterns within them and flag the anomalies in the data.
• Load the data extracted from client EMR, Billing and Payer systems into Oracle staging environment.
• Perform gap analysis between the client data and the product specifications.
• Manage the Project Plan throughout the implementation process from initial engagement to delivery of application.
• Mentor the junior Business Analysts.
• Present analytic output to the clients to facilitate strategic and tactical decision-making.

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

Confidential, Boston, MA

Sr Business Analyst / Delivery Manager

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.
• Liaisoned 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).
• Identified opportunities for improvement in the business architecture.
• Planned the testing cycles and environment readiness for the scheduled releases.
• Did the Static/Reference Data set up in TradeFlow for OTC Derivatives.
• Worked with PACE team for Reference Data setup for Equities (sourced from Bloomberg and Reuters).
• 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 6 members (Development/Support and QA) 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, Markit, Omgeo CTM, FpML, Quality Center (ALM 11), MQ, Oracle, UnixPutnam Investments

Confidential, Boston, MA

Sr Business Analyst

Responsibilities:

• Interacted with the Business for gathering the requirements.
• Carried out extensive Data Analysis on the existing PRM data and the data from the various source systems.
• Carried out Gap Analysis with the objective of bringing-in new data feeds and integrating them with the existing Data Warehouse.
• Created the BRD and mapping documents between source (PACE, SFDC) and target (PRM).
• Coordinated with the Architect and DBA in finalizing the structural changes in the Warehouse.
• Coordinated with the downstream application owners about the impact caused by the changes in the Data Warehouse.
• Created the test scenarios to validate the data loaded into the Warehouse.
• Managed ETL developers and responsible for project planning and tracking the deliverables.

Environment: PACE (Eagle), SalesForce.com, Informatica, OracleADP Taxware

Confidential, Salem, NH

Business Analyst (Consultant)

Responsibilities:

• Interacted with the Business for gathering the functional and reporting requirements.
• Drafted the Business Requirements and Functional Specifications document and obtain the sign-offs from the appropriate parties.
• Created the report mock-ups for the Business walkthrough.
• Interacted with ADP’s clients for seeking their feedback on the product’s features.

Environment: Taxware, Java, Oracle, ClearQuestBlue Cross Blue Shield of Massachusetts

Confidential, Boston, MA

Sr Business Analyst/ Project Manager

Responsibilities:

• Interacted with the Business for gathering the functional, non-functional, mapping and reporting requirements.
• Drafted the Requirements Clarification and Traceability documents.
• Drafted the Technical Traceability Matrix and worked closely with the other vendors towards the system integration for the End-to-End flow.
• Worked closely with the Architect in building the Services based system (SOA).
• Drafted the End-to-End flow of the EDI transaction along with the Functional specifications and Use-cases.
• Drafted the necessary artifacts in line with the 5010, NEHEN and BCBSA standards.
• Participated in the Agile methodology with the SME, Development and QA in the implementation process.
• Drafted the Composite Specifications for the Development team.
• Conducted walkthroughs and joint sessions with Business Owners, SMEs and technical team.
• Reviewed the Test Cases prepared by the QA team.
• Performed Project Planning for the effort estimates and delivery timelines.
• Managed and mentored the Development and QA team during various phases.
• Worked closely with the Business Operations during User Acceptance testing.
• Managed the Offshore resources.
• Managed the Change Requirements and supported the project through all phases.

Environment: EDI (270/271, 278, 837, 835), Java, Websphere, Oracle 11g, Quality Center, Visio, Cognos, Toad, SpecBuilder/Transaction Management (Edifecs).

Confidential, Portland, OR

Business Systems Analyst (Consultant)

Responsibilities:

• Gathered the requirements from the Business users across various groups - Membership, 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.
• Functioned as the coordinator for the project involving the conversion/sellover of members from legacy system to Facets.
• Worked in the Scrum team and participated in backlog review and sprint planning sessions while following the Agile methodology.
• Assisted the Development team, in terms of the BOE Universes and reports.
• Analyzed and resolved the ongoing issues with the Data Warehouse and the upstream and downstream applications.
• 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, Oracle 10g, Sybase.

Confidential, Monterey Park, CA

Business Systems Analyst (Consultant)

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.
• Participated in requirements prioritization.
• Established delivery milestones.
• Managed the development and QA resources.
• 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 also to ensure proper integration of new solutions.
• Worked on the Adjustments and Reconciliation Calculations (ARC) application of the bank for trouble shooting and enhancement.
• Carried out extensive data validation.
• Created a Change Management Plan for the releases.
• Worked as a UAT Coordinator 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, Oracle 9i, Peregrine ServiceCenter, Win XP, Unix.

Confidential, Burbank, CA

Data Warehouse Business Analyst (Consultant)

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.
• Kept track of scheduled environment refreshes and coordinate/communicate with Dev, Ops, and Analysts.

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

Confidential

Technical Lead/Business Analyst

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.
• Provided BO support for the business users.
• 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.