OBJECTIVE:

• Intend to build a career with leading corporate by applying my knowledge, skills and experience there by seeking challenging and satisfying career.

SUMMARY:

• Over 7 years of working experience in Healthcare, Insurance, Mortgage and Banking Domains.
• Experience in Full Lifecycle Implementations including Requirement Gathering, Business Process Analysis, GAP Analysis, Creating Functional Specifications, Defining Solutions, Recommending Best Business Practices, Conducting User Acceptance Testing (UAT) and Completing System Set - up & Production Support.
• Exceptional documentation skills in creating project artifacts like Business Requirements Document (BRD), Functional Requirement Document (FRD), Requirements Traceability Matrix (RTM), System Requirements Specification (SRS), Data Mapping Document, User Acceptance Test Plan, Use Case Specifications and Test Scripts.
• Sound experience in Data Conversions, Data Migration, Inbound/Outbound Interfaces Design, Reports Development, Workflow Customizations, Database Triggers, Procedures, Functions and Packages using SAS, SQL & PL/SQL.
• Extensive experience in diversified industry sectors including Credit Services, Mortgage, Credit Cards, Risk Analysis, Brokerage/Securities, Commercial, Retail and Investment Banking.
• Good Knowledge of SDLC Methodologies, Change Management Process and hands on experience in Waterfall and Agile/Scrum Methodologies.
• Excellent understanding of financial market instruments such as stocks, bonds, futures, swaps, forwards, options and credit derivatives products.
• Hands on experience in Data Modelling, Data Visualization, Data Management, Data Quality Assurance and Control, Data Governance, Master Data Management, Continuity Planning and Operations.
• Exceptional communicator - can effectively present ideas and concepts to upper management in a clear and concise manner.
• Profound experience in MS Word, Power Point, Advanced knowledge of Excel (Macros, Pivots, Lookups etc.) and Visio.
• Knowledge of common AML Typologies, Banking-Related Products and Services and Transactional Flows.
• Working knowledge of the laws applicable to money laundering, including the Bank Secrecy Act (BSA), The USA PATRIOT ACT, OFAC, FinCEN requirements.
• Strong Subject Matter expertise in Credit Card Industry, Retail/Investment Banking, Risk Analysis, Mortgage Loan Origination and Loan Servicing.
• Adept in Team Management, Problem Resolution, Conflict Management, People Management and Interpersonal Skills.
• Extensive working experience in JIRA, Data, Share Point and HP ALM (Quality Control) Tools.
• Proficient ingeneration and automation of reports (operational and ad-hoc) based on internal/ external needs by using SAS and SQL/PLSQL.
• Exceptional problem-solver with keen ability to resolve technology issues.
• Experience working in conjunction with various onshore/ offshore teams.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, SAS, C/C++, C#, Java, HTML and XML

ETL Tools: SQL*Loader, SQL*Plus, Toad, SSIS, SSRS, TABLEAU and OBIEE

Other Tools: HPQC, JIRA, REMEDY, Data Loader, MS Office and Share Point

Operating Systems: Windows XP, HP UNIX, Sun Solaris UNIX, Linux

Data Base: MS Access 2000, Oracle 10g & 11g, MS SQL Server 2005/2008/2012

Methodologies: Waterfall and Agile (Scrum)

PROFESSIONAL EXPERIENCE:

Confidential, Philadelphia, PA

Sr. Business Analyst/ Data Integration Analyst

Environment: UML, HP ALM, Microsoft Word, Excel, PowerPoint, Data Loader, JIRA, SQL developer, MS Visio, SQL/PLSQL, OBIEE & SharePoint

Responsibilities:

• Documented functional requirements and non-functional requirements based upon the approved business requirements by following UML processes and standard procedures for developing use cases, use case diagrams, and other supporting documentation.
• Performed weekly interaction with stakeholders to understand the requirements, explain them the process of the project and for sign-offs.
• Reviewed Business requirements with Project Manager, Team Lead, technical architects and developers.
• Prepared business and functional requirements based on PCI (Payment Card Industry) compliance.
• Created UML diagrams with MS Visio, crucial to the development phase of the project and provided qualified analysis of capacity requirements and projections.
• Developed Requirement Traceability Matrix (RTM) to monitor development process and used SharePoint as repository for all documentation.
• Traced requirements thorough out the development process and verified adherence using the Requirement Traceability Matrix (RTM).
• Performed business process analysis of current business processes and provided recommendation for improvements.
• Used Data Loader for insert, update and bulk import or export of data. Used it to read, extract and load data from comma separated values (CSV) files.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.
• Played a major role in Change Management during the software development lifecycle.
• Created mapping documents to define the transformation rules to translate requirements into technical design.
• Lead the Data Warehousing/Business Objects team to develop and generate the daily BO report on identifying the special charges PO and Purchase Order Variance PO lines.
• Responsible for Identifying and tracking defects to resolution and producing a summary defect report to determine testable defects (defects that have been promoted, fixed or reopened).
• Performed Back End Testing using SQL queries, generating reports to ensure data integrity and to validate the inserted and updated data.
• Led the impact analysis exercise and facilitated session with other IT and business teams across WTW.
• Coordinated in transferring the data files to vendor through SFTP and FTP process.
• Performed data analysis and data quality check by designing SQL scripts in Oracle environment and generated reports in MS Excel for clients in Europe Offices.
• Actively participated in QA life cycle execution from Test Plan, Test Scripts, and Defect Resolution to User Acceptance Testing (UAT), System Integration Testing (SIT) and End-to-End testing.
• Managed test case, defects and reports in HP Quality Center (ALM).

Confidential, Dayton, OH

Sr. Business Analyst/Scrum Master

Environment: XML, Web Services SOAPUI tool, HP ALM, JIRA, Microsoft Word, Excel, PowerPoint, SQL developer, MS Visio, CRM MS Dynamics, C & Unix, .Net, SharePoint, Power Builder Tool, IVR System, SAS and SQL/PLSQL

Responsibilities:

• Developed Project artifacts such as Business Requirement Document (BRD), Functional Requirement Documents (FRD), System Requirement Specifications (SRS), Use Case Document, User Stories, Product backlog, Sprint backlog, Traceability Matrices.
• Organized and facilitated Scrum Daily Standup, Review and Product Backlog, Retrospectives, Sprint and Release planning, Demos and other Scrum related meetings.
• Participated in steering committee and weekly project committee calls for effective tracking and exercise scope control of overall program, risk identification and mitigation.
• Lead multiple concurrent projects providing planning and administration, issue resolution, monitoring project progress to plan, facilitated JAD/JRP and distributing project status.
• Involved in defining and constructing the customer to customer relationships based on association to an account and customer.
• Analyzed research on operational procedures and methods and recommend changes for improvement - with an emphasis on automation and efficiency.
• Generated a streamline process to understand various steps in the loan lifecycle and desired functionality of the new system by interacting with Users, Management, SME, lenders and underwriters.
• Researched and analyzed complex healthcare data from variety of sources to evaluate, define, design, develop, test and implement technical solutions to produce accurate data extracts/reports in the required file layout based on the Federal requirements.
• Performed healthcare data mapping utilizing data and information from data warehouse, Confidential claims processing system (claims, eligibility, provider, trading partner etc.) and other division data sources using various SAS Business Intelligence tools.
• Created and reviewed source to target data mapping documents from crosswalk analysis to Confidential healthcare systems.
• Interacted with Claims team for analysis and documentation.
• Followed the standards of PMO which included getting approvals for SOX (Sarbanes-Oxley) compliance at various gates.
• Maintained contracts with Centers for Confidential Services to provide quick and easy affordable access to the health care service of their choice of like of health insurance system like PPO, HMO, POS and CHIP.
• Reviewed examined, calculated and authorizes insurance claims investigated by insurance adjusters.
• Ensures that all the claims are valid and settlements are made according to company practices and procedures.
• Gathered all the requirements from the user and had brainstorming sessions with the developers.
• Ensured development team worked efficiently towards sprint goals and worked with the development team during the design, build and test phase of system projects to clarify business requirements as required.
• Database support that includes activities required to correct, delete or summarize medical history of members as well as provider information.
• Created SQL scripts to evaluate features for existing or proposed systems.
• Provided a weekly project report that includes Test Metrics and status reports to stake holders.
• Developed Test Strategy Document and performed Functional System Testing and Regression Testing.
• Participate in requirement and design reviews to ensure test plans are traceable to requirements.
• Responsible for importing the test cases from MS-Excel to Quality Center.
• Conducted sessions to familiarize users with system and Assisted in development of materials for new technology and process improvements.
• Resolved the user support tickets and Involved in monthly production release.

Confidential, North Whales, PA

Sr. Business Analyst/Scrum Master

Environment: XML, HP ALM, Microsoft Word, Excel, PowerPoint, SQL developer, MS Visio, Power builder tool, .Net, SAS and SharePoint

Responsibilities:

• Scrum Master Activities - Facilitating daily Scrum Meetings, Sprint Planning, Sprint Demo, Product Backlog, Story Board, Story Writing, Sprint Backlog and Release Plan.
• Developed and followed Agile project management plan (Agile ceremonies). Facilitated build requirements log (product backlog) with cost estimates and priority.
• Tracked and reported Scrum team velocity and manage Sprint capacity.
• Guarded team from outside distractions, removing any obstacles that could impede the team progress.
• Coordinated dependencies between teams with other Scrum Masters and Project Managers.
• Facilitated Joint Application Development (JAD) sessions in order to ensure that both the technical and non-technical teams understand exactly what the project is about.
• Managed budget and tracked actuals, invoices, Vendor information as needed using MS SharePoint dash board.
• Interacted with client and the technical team for requirements gathering and translation of business requirements to technical specifications.
• Responsible for streamlining business processes through analysis, design, and documentation of new processes and applications including risk assessments and mitigations, and creation of process flows (VISIO flow design) and change enabling quality controls.
• Implemented Change Management techniques for successfully monitoring and fine-tuning the project changes to obtain the desired production results and to meet Client deadlines.
• Assisted both the QA and UAT teams in the building of Test Case, Use Cases.
• Assisted in development of materials for new technology and process improvements.
• Served as a resource for analytical services utilizing SQL Server, TOAD/Oracle, and SQL Developer.
• Developed SQL Statement and stored procedures in SQL for extracting as well as writing data.
• Worked extensively in creating business and functional requirements to create Electronic Health Records (EHR) and performed EHR data validation.
• Worked specifically with EHR to design clinical applications enhancements to meet user and business needs.
• Designed executive summary reports based on data analytics to present the insights to high level management by using SAS.
• Created Test scripts, developed SAS user procedures, curriculum and conducted sessions for all levels of end users.
• Designed reports using SAS to provide more comprehensive dimensional information.
• Responsible for creating the Test Plan and Test Cases based on the requirement documents and tracing test specifications back to the business requirements.

Confidential

Data Analyst - SAS/SQL

Environment: Teradata 13.1, Informatica 6.2.1, Business Objects, Oracle 9i, PL/SQL, Microsoft Office Suite (Excel, Vlookup, Pivot, Access, Power Point), Visio, VBA, Micro Strategy, Tableau, UNIX Shell Scripting

Responsibilities:

• Acted as a liaison between IT, Application Developers and Business teams.
• Documented the Traceability Matrix for tracing requirements, test cases and maintained in JIRA.
• Coordinated with system architects and developers to convert business requirements into system requirements by analyzing equalities, credit risk, assets and liabilities.
• Performed reporting and analytical tasks using SAS and SQL Queries.
• Actively participated in daily scrum calls for status updates and defect reporting. Also raised some excellent scenarios during spring planning meetings.
• Interacted with the Scrum master and the project manager and highlighted any risks that would arise during the sprint.
• Responsible for Program construction, monitoring and auditing, emphasizing the management of internal risk assessments and/or investigations.
• Ensured adherence to all aspects of First Principles, code of Business Conduct and Ethics, including individual accountability as it relates to potential conflicts of interest, safeguarding of customer information.
• Extracted complex data from multiple sources and prepared data sets from external sources using SAS.
• Assisted in creation and maintenance of custom SAS stored processes and SAS Macro libraries.
• Performed complex data aggregation, cleaning and quality checking using SAS Programs.
• Created SQL queries to collect, manipulate, analyze and report data to meet ad hoc customer needs.
• Contributed to problem and event management efforts as required, worked with team members to ensure resolution is completed as quickly and efficiently as possible.
• Prepared supplementary documentation on file/queries as and when required (e.g. reports for Compliance, Memos, and File Notes).
• Flexible and worked on tight deadlines when required (for example, with urgent requests from the Business Line) on the take-on of new clients.
• Lead clients and technical staff to investigate, analyze, and resolve complex application problems related to system functions.
• Performed SAS programming to provide data review complex reports and extracts to support data management.
• Performed data validation testing writing SQL queries and SAS.
• Extracted and analyzed large amounts of data using SQL queries from a data ware house environment.
• Provided data extracts and reports using SQL queries for internal stake holders.
• Conducted performance tuning and troubleshooting on data analytic packages such as SAS stored processes.
• Performedimpact analysisfordata issuesandupstream data changes.
• Performed load, stress, performance and volume tests to ensure the application can handle production environment.
• Responsible to Develop, Review and Approve detailed test plan outlining the testing approach.
• Performed manual testing by entering positive and negative values and worked on verifying transaction as they pass through multiple functional areas and/or external interfaces.
• Communicated with QA team about any of the impacted functionality that needs to be included in their test planning.

Confidential

Business Analyst/KYC Analyst

Environment: UML, HP ALM, Microsoft Word, Excel, PowerPoint, MS Visio, OFAC Screening, World-Check, LexisNexis, Bloomberg, OneSource, Global Client Onboarding System, FATCA.

Responsibilities:

• Conducted risk rating of clients by in-depth understanding of regulatory risk and compliance, sanctions, screening, PEP, adverse media research/analysis and investigation.
• Analyzed the financial crime risk indicators and taken an independent decision regarding completion of the request.
• Created product roadmap for the various stages and releases throughout the project lifecycle.
• Reviewed KYC files to ensure the attachments support the information in file and updated the applicable sections in KYC files for the subject’s business unit.
• Assisted in identification and mitigation of Anti Money Laundering (AML) related risk associated with clients.
• Responsible to assign appropriate Money Laundering Risk Assessment (MLRA) to customers.
• Provided advice to the Global Banking Business unit on all financial crime risks, AML and Sanctions and provided approval for the on boarding of the bank’s high risk customers.
• Responsible for the monitoring team activities and quality management of the team.
• Managed queries from the front office and stakeholders on AML, ABC and Sanctions.
• Reviewed test scenarios and coordinated with business users and QA team for execution of test plans.
• Provided direction and support to junior staff for process procedure and shared the process knowledge with other team members.
• Responsible for review and sign-off of the bank’s high-risk customers (Special Category Clients) including Politically Exposed Persons (PEP).
• Participated in Testing and Migration planning related tasks, ensuring upstream and AML system test plans are aligned.
• Worked on High, Medium and Low risk clients and familiar with their on-boarding procedures.
• Participated in Onboarding the Financial institution groups, Banks, NBFI, Corporate clients and government entities for HSBC Bank Plc.
• Applied the KYC procedures and norms for Regulated, Listed, Private and Funds adoption in validating the documentation.
• Responsible for performing the KYC /AML policies and procedures on new and existing clients.
• Responsible for performing the Customer due diligence (CDD) / Enhanced due diligence (EDD) based on the client Risk levels.
• Responsible for investigating the client’s nature of business and performing the CDD checks.
• Performed world checks to investigate in preventive crime research on the PEPs and high-risk clients.
• Responsible for monitoring the Regulators, Exchanges and Private Firm’s data for the adoption process.
• Proficient in obtaining and navigating the client documents in the public domains.
• Supported the Relationship Managers to accommodate business requirements in quick turn over time.
• Participated in application interface design, modelling, and implementation with SAS programming including PROC SQL interactions with Oracle and SQL Server.
• One of the team members in SAS AML administration and SAS application support for AML and case management workflows supporting BSA/AML Operations for SAR.
• Prepared process/data flow diagrams mapping documents to map client upstream product to AML system.
• Assisted in Data analysis, modelling, technical design, code development and validation for data supporting BSA/AML applications and solutions.
• Prepared SAR Reports as per the client specifications and to meet the regulatory specifications.
• Reviewed and approved Know-Your-Customer files for complex banking products.
• Strong working experience in regulatory compliance, AML transaction/risk monitoring tools.
• Assisted the team in solving AML related issues.

Confidential

Data Analyst

Environment: Agile, JIRA, Windows 7, Microsoft Office SharePoint 2010, MS Office, MS Dynamics, SQL Server and UML.

Responsibilities:

• Conducted Joint Application Development (JAD) sessions, Project Meetings, Reviews, Walkthroughs and Customer Interviews
• Attended daily stand up meetings and Scrum meetings.
• Responsible for generating weekly ad-hoc and new reports based on requirements.
• Provided analytical support in the design, development and implementation of Project.
• Designed and implemented basic SQL queries for QA testing and data validation.
• Worked as a liaison between the users and the different teams involved in the application development for better understanding of the business and IT processes.
• Designed STTM documents (Source to Target Mappings) based on mappings rules provided by business to process new state and extended vendor layout files to data warehouse and provision in the views for Customer Service Applications to access.
• Created Data Modelling Change Requests (DMCR) to create new tables and columns in existing tables to process the new files as per new architecture.
• Created Excel Charts and pivot tables for the Ad-hoc data pull.
• Translated business requirement into SAS functional requirements and created functional design specifications.
• Conducted extensive data analysis to evaluate data sources, determined best sources for business information and recommended data quality improvements.
• Reviewed business requirements, business data flow and documented rules for transforming source data to meet target data requirements.
• Created reports using Crystal Reports to perform data analysis.
• Documented detailed test plans and test cases based on business and functional specifications for each story & Maintained test matrix for test results.
• Integrated data from External Systems, Excel Spreadsheet, and CSV by using SAS Data migration procedures.
• Served as a liaison between the internal and external business community (Claims, Billing,, Capitation, Customer service, management, provider management, advanced Healthcare, provider agreement management) and project team.
• Created advanced reports using SQL Server Reporting Services (SSRS) and Tableau.
• Responsible for retrieving the data by writing simple/ complex SQL queries using SQL Management Studio.
• Designed different data analytics and reports to provide the data insides to support the front end teams in promoting new features to the website.
• Performed UAT and developed different testing strategies like Black Box Testing and Load Testing.
• Worked closely with development team and QA team to deliver requirements for implementation and changes are deployed.
• Accountable to follow approved, documented processes and procedures to collect and analyze customer information in-order to ensure in-depth knowledge of the customer and its relationship
• Performed detailed risk analysis to identify possible issues and bugs.

Confidential

Business Analyst/Quality Analyst

Environment: Agile methodologies, Oracle11g, MS Access 2000, MS Project, UML, MS Visio, MS Office suite, Tableau, Pencil, Jira, Test director, Share Point

Responsibilities:

• Responsible for documentation of Test Plans, Test Cases, Test Scripts, Test Procedures based on the design document and performed Unit Testing, System Integration Testing (SIT), User Acceptance Testing (UAT), Regression and Smoke Testing.
• Assisted the product owner in user story creation/ prioritization and product backlog refinement via emergent requirement elicitation while supporting overall organizational goals.
• Communicated the progress to senior management through ‘Burndown Charts’, monitored the quality through metrics and mentored team through the project management processes.
• Understood overall products/system requirements and synthesized multilevel test requirements.
• Involved in Smoke, Functional, Integration, Regression, System and User Acceptance Testing of the applications.
• Involved in designing and implementing of manual QA test strategy and working with automation using HP interactive test suite.
• Documented test results, revise test cases, and scripts as needed and rerun test scripts to verify results.
• Performed Manual Testing for the functionality and GUI of the application using Quality Center those cannot be automated.
• Developed test scenarios and implemented test plan, providing key input in working with users in defining project and system requirements.
• Ensured the actual results match expected results using Quality Center.
• Used Quality Center for tracking requirements and communicated them to the team during the test process and translated the information to test procedures.
• Involved in Back-End testing using SQL queries and reporting defects in Quality Center.
• Participated in Bug-Review meetings with software developers, managers, suggested enhancements to the existed application from business perspectives, and provided solutions to existing bugs.
• Worked closely with QA team for developing and maintaining quality procedures and ensuring that appropriate documentation is in place.
• Performed regression testing throughout for defect fixes and small subset of cases toward the end of the test level.