PROFESSIONAL SUMMARY

• Certified Business Analyst Professional CBAP with 7.5 years of experience in Business and Data Analysis, Data modeling, design, testing, gathering and eliciting requirements based on functionality, workflow and business rules in Finance and Healthcare Insurance domain.
• Master of Science in Management Information Systems.
• Knowledge of Financial instruments, Capital Market and experience with Security and Pricing Reference data application and Platforms.
• Hand on experience in Data Modeling for Relational Databases as well as Dimensional data modelling for Datawarehouse applications. Expertise in creating Star Snow-Flake Schemas, FACT and Dimensions Tables, Physical and Logical Data Modeling using Erwin.
• Expertise in writing Complex SQL Queries using Oracle, SQL Server and Teradata and implementing MDM, Data Warehouse/ETL applications.
• Well versed with Agile methodology using Scrum and hands on experience on Agile tools like Rally for sprint planning, writing user stories and Acceptance criteria.
• Experienced in development of ETL mapping and scripts for ETL Projects.
• Experienced with HIPAA X12 EDI transactions like 834, 820 and implementing Affordable Care Act.
• Proficient in Requirements elicitation techniques like JAD sessions, interviews and hands on experience in creating BRDs, User stories and FRDs.
• Extensive experience in test planning and test case designing
• Comfortable working individually as well as in a team environment

EXPERIENCE

Confidential

Business Analyst Lead

• Techno functional BA Lead/Product Owner acting as a Liaison between Business stakeholders and Technical team for SEI's wealth management platform that supports US Banks and US advisor markets in a Scaled agile environment.
• Analysis of asset and other financial Data and other financial data using SQL to perform coverage analysis and to do root cuse analysis for BAU issues.
• Responsible for defining the scope of the project, gathering business requirements, performing gap analysis identifying risks and dependencies and documenting them.
• Leading efforts to elicit and prioritize requirements for Asset data services team responsible for maintaining reference data and assets maintenance on wealth management platform.
• Vendor Management - Bloomberg Data License, Thomson Reuters Data Scope Equities and Data Scope Onsite, Investnet.
• Responsible for writing User stories and defining Acceptance Criteria for the team.
• Working collaboratively with Project Managers, Technical Architects, Quality Assurance team and others to ensure effective cross-project communication and issue management.
• As a Product owner, Responsible for facilitating backlog grooming and Sprint planning.
• Assists QA in test planning, test scripts and validating the test results.

Confidential

MDM Business Analyst Lead

• Consults with and collaborates with various business stakeholders to assess and determine business specified requirements, perform analysis and recommend best solution to address the user needs related to Master data management and Data warehouse to support implementation of Healthcare Exchange.
• Responsible for creating data flow diagrams, data analysis using SQL queries and reports generation for business users using Crystal Reports.
• Conducted JAD sessions, user interviews to facilitate cross functional requirements definition and analysis and determining scope of analysis to support implementation of modules involving ETL using Informatica.
• Creates test plans and participates in system testing of projects and in the evaluations and follow up of systems previously implemented.
• Responsible for product testing, product trouble shooting, product upgrades, and report development.
• Source to Target Data mapping and data modelling to support implementation of New York Healthcare Exchange.
• Involved in preparation of Traceability Matrix based on High/Detail requirements and Test Cases
• Impact analysis to determine the affected systems while implementing new functionality into business architecture and training the users on new information system changes.
• Assist with efforts to demonstrate that Information systems are compliant with NY State guidelines, government regulations HIPPA/HITECH and contractual requirements.

Confidential

Business /Data Analyst

• Monitor Securities and Asset data platforms to identify data exceptions containing inaccurate data and to engineer processes to ensure data quality.
• Involved in preparation of Traceability Matrix based on High/Detail requirements and Test Cases.
• Documents specific data attributes from data sources and develops data mapping to support implementation of ETL requirements using Ab initio.
• Modify existing datasets in the database using SQL and other database management tools.
• Remediate exceptions by modifying datasets in the database via SQL or other tools
• Created Test Plans, Test Cases, and Test Scripts for all testing events such as System Integration Testing SIT , User Acceptance Testing UAT and Unit Integration Testing.
• Engineer advanced operational and financial processes to maintain data quality, and perform further analysis to compare datasets from Strategic and Legacy securities and pricing platforms requiring enhancement.
• Create and monitor business-as-usual BAU processes to satisfy data requirements and perform test script execution for new financial systems implementation and present testing results to management.
• Work on the legacy integration and decommissioning projects by coordinating with global clients to gather requirements, translate them to the tech team and deliver the products back to the clients.
• Train and manage team of 3 business analysts
• Independently query data from multiple relational databases for analysis
• Conformed with issue tracking JIRA and escalation process
• Familiar with Corporate actions and have thorough knowledge about financial products

Confidential

IT Business Analyst

• Gathered requirements from business users from Phoenix Wealth Management Company and translated them to the technical team using UML diagrams and Functional design documents to support implementation of ETL based project in Informatica Power Center.
• Created and delivered full sign-off project documentation starting from Development and ending at post-Production deliverables by working with Key Stakeholders to elicit information and gain agreement
• Managed and mentored a team of 8 quality assurance associates to deliver 24/7 support to 21 run and change applications supporting 70 of the vertical clusters of Bank of America
• Accurately estimated the efforts required for incoming work-orders and scoped projects to bill client
• Top scorer in a two month training program on core technologies at CSC including .Net technologies C , SQL server, ADO.Net and test automation
• Identified and replicated intricate and inconsistent issues, analyzed them, prepared root cause analysis RCA reports, found the root cause and fixed them after proposing the solution to client
• Developed a fully functional travel portal, using .Net, as part of the training plan

TECHNICAL SKILLS