SUMMARY:

• Over 10+ Years of IT experience in Business Analysis, Data Analysis and Reporting Analysis for Banking and Financial Industries for various projects from conceptualization to implementation.
• Proficient at understanding business and acting as a liaison between technical and business partners.
• Knowledge and experience of various SDLC methodologies such as Waterfall, Agile, RUP
• Experience in analyzing and writing Business Requirements Document (BRD), Functional Requirements Document(FRD) and Use Case scenarios.
• Experience in Agile methodology, Scrum meetings, Sprints and well versed in writing user stories.
• Well versed in Requirements/Change Management, Impact Analysis and Gap Analysis.
• Experienced in writing SQL queries and scripts for data verification, backend testing, and to generate customized daily, weekly and monthly user reports.
• Excellent Team player to work in conjunction with testers (QA), developers and other team members in validation and testing of complex project scenarios and tracked defects using JIRA.
• Hands on experience in analyzing the high level requirements, developing User Stories, Test Plans, writing Test cases, building test data using Excel & SQL queries.
• Strong Analytical and Problem Solving skills, Multi - Tasking abilities, with proven experience in utilizing people and process knowledge to assist enterprises in making critical decision.
• Working knowledge of Tableau, BI tool, in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc.
• Knowledge and understanding of Extraction, Transformation and Loading (ETL), basic concepts of data flow, data enrichment, data consolidation, change data capture and transformation.
• Experience on change, defect tracking tools like Remedy, Clear Quest and HP ALM Quality Center.
• 4 years of experience working on the Functional side of Banking and Accounting industries.
• Have a solid accounting experience working within a regulatory reporting role and have an audit background with experience of daily liquidity reporting and delivering quality information to strict deadlines.
• Expertise in Risk Analysis, Financing structures, Capital management and Portfolio Analysis.
• Experience in Accounting management and financial analysis: General Ledger, Accounts Payable, Accounts Receivable, Long Term and Short Term Liabilities, Accruals, End of Month & Year closing.
• Exceptional competence in preparing and analysis of financial statements and reporting functions.
• Excellent time-management, analytical, organizational and problem-solving skills.

WORK EXPERIENCE:

Confidential

Business/Data Analyst

Responsibilities:

• Working as a Business/Data Analyst on a project with a Financial Crime Technology team.
• Assisted in a project involved implementation and up-gradation of a COTS software used to monitor suspicious and fraudulent activities throughout company's worldwide locations.
• Analyze and verify the randomly selected sample data from Global Markets into company's database.
• Working with business to understand requirements and mock up screens with different LOB data.
• Working in a project with Risk Compliance involve Data Mining for Risk Analysis in particular to Global Capital Markets.
• Working with a Data Source Management team on a Data Quality to ensure correct and accurate data.
• Involved in detailed discussions on mapping data of Global Markets process to Oracle Business Process, Identifying the GAPS and recommending suitable workarounds.
• Created and maintained specifications and process documentation to produce the required data deliverables (data profiling, source to Client maps, flows)
• Evaluated data profiling, cleansing, integration and extraction tools (e.g. Informatica)
• Tracking and recording gap analysis, data mapping, writing and documenting functional specifications.
• Using Tableau dashboard as a BI tool to better visualize the products and systems performance
• Generated data extracts in Tableau by connecting to the view using Tableau MySQL or Excel connector.
• Pull the operational or transactional data and export on Excel for Analysis.

Business/Data Analyst

Responsibilities:

• Working as a full time Business/Data Analyst and had completed several successful projects including but not limited to Customer Care/customer Payment tools, Credit Card operations, payment gateways and payment processing, Data Migration from FISERV to FIS, conversion from regular clearing house to Branch Capture (Vision Content), Mobile Banking etc.
• Gathered requirements from business partners and users and translate same to Tech team effectively .
• Performed User story estimation, GAP analysis and priority analysis for the project which has "As-is" and 'To-Be" business process maps, data modeling, work flows, Dependencies on existing and interfacing systems.
• Actively participated in bi-weekly sprint sessions including sprint planning, grooming, elaboration activities, estimations, demos, retrospectives, and scrum planning activities.
• Participate in Joint Application Development (JAD) sessions, and conference calls to keep executive staff and the team members apprised of goals, project status, and resolving issues.
• Assists in Crafting End User Guides and Release Toolkit Configuration and Deployment documentation for client implementation training and project teams.
• Data analysis using Excel pivot tables, formulas (v-lookup and others), SumProduct, Index, Match, data validation, conditional formatting, Sorting and Filtering.
• Works closely with MIS Dept in the evaluation of strategies aimed at driving portfolio growth including capturing data critical to identifying portfolio segments that are underperforming.
• Developed and implemented BI solutions utilizing Tableau and SQL on live data.
• Executed Tableau dashboard setups and participated in data manipulation.
• Provided assistance using Tableau for data trends identification using Excel tools.
• Experience in using data steps in SAS and export SAS Results to different format, such as XML, Excel using SAS/Export, SAS/ODS for reporting and presentation.
• Worked on daily basis with lead Data Warehouse developers to evaluate impact on current implementation, redesign of all ETL logic such as Data migration, Data mapping, and reporting process.
• Used Informatica Workflow Manager to create workflows, database connections, sessions and batches to run the mappings.
• Experience in Data Modeling creating Logical and Physical Models using Power Design, ER-win.

Business Analyst

Responsibilities:

• Worked as a Business Analyst and had completed several successful projects including Trading platform, Trading account maintenance platform, Wealth planning, Online Banking, etc.
• Part of team as Lead business analyst involved in the design, analysis, testing and support of an asset management billing, trading account maintanence and a wealth planning tool.
• Produce liquidity reporting requirements that are in line with regulatory mandates, document business requirements and functional solutions.
• Providing liquidity reporting for Corporate & Institutional Banking (CIB) systems through the Liquidity Data Warehouse that provides finance validated data.
• Work closely with Treasury, Finance, Technology and Risk Departments - ensuring a constant and concrete understanding of regulatory obligations.
• Assist in the documentation of the Business Requirement Document (BRD) for use case scenarios Evaluated business requirements and prepared detailed functional and technical specifications that follow project guidelines.
• Analysis and breaking down of requirements into project specific use cases in clarity following the Waterfall methodology.
• Primary liaison between the project team and the Business owners in communicating the requirements and the expected output.
• Worked closely with Developers and Quality Assurance Analysts to ensure requirements and design are completely understood.
• Designed and implemented basic SQL queries for QA testing for report and validation.
• Plan, test, and implement various Web-based applications using JavaScript.
• Coordinated UAT sessions between Users, SMEs and Project teams in order to sign-off projects to subsequent phases

Business / Data Analyst

Responsibilities:

• Estimated time required to deliver project artifacts and reports progress toward delivery goals throughout the project.
• Interacted with project stakeholders to elicit, analyze and document project requirements.
• Analyzed and prepared the users ‘AS-IS’ workflow scenarios and the ‘TO-BE’ business processes.
• Used Microsoft Visio to model business processes using UML to create use case diagrams, activity diagrams, sequence diagrams and collaboration diagrams.
• Produced professional quality project artifacts including but not limited to business requirement documents, requirement plans, models (e.g. data, event, context and process), traceability matrices, use cases, issue logs and other documents as needed.
• Maintained the requirements traceability matrix to manage business requirements.
• Assisted the business in determining if and how new systems or system enhancements may improve process flow and business function.
• Provided an analysis of COTS products technical capabilities and costs
• Served as a critical resource and liaison between subject matter experts and technologists throughout the project lifecycle.

Business Analyst

Responsibilities:

• Participated in Business Modeling by understanding the needs of the business, and also documenting Business Use Cases as well as System Use Cases.
• Gathered Requirements and documented the proposed additional extension to the existing application.
• Facilitated Joint Application Development (JAD) sessions with the Management, Mainframe and HIPAA team to make sure everyone are in sync with the business requirement processes.
• Used MS Visio to create Use Cases and Sequence Diagrams.
• Accomplished experience through whole SDLC from requirement analysis till deployment, using highly efficient RUP process of Software development.
• Assisted development team to translate requirements into technical specifications.
• Analyzed mandatory and the situational fields and compared with the users manuals for EDI.
• Worked closely with the host (Main frames support person) and helped him understanding the process and in the creation of the match, input and the delete files.
• Created and Maintained the Requirement Traceability Matrix (RTM).
• Initiated Test Plans, developed and executed test cases and scenarios, worked with users to develop specific acceptance criteria and prepare test exhibits.
• Worked on modules such as pricing, payer, eligibility under claims processing system.
• Conducted User Acceptance Testing (UAT) sessions with business users and prepared document for enhancements and bug fixes.
• Used Test Director and Mercury Quality Center to report any bugs found and communicate to the developers and product support team.
• Analyzed and evaluated User Interface Designs, Technical Design Documents and Quality Assurance Test condition the performance of the application from various dimensions.
• Helped create the ‘Business Glossary’ to facilitate efficient understanding of the Business process amongst the other teams

Accounting Consultant

Responsibilities:

• Duties involved Accounting, Finance, Audit and Tax consultancy.
• Prepare, reconcile, analyze, interpret, store and finalize clients financial statements.
• Analyze the client’s business model and industry structure and anticipate future changes in accounting practices.
• Consultancy on client's Accounting System, Oracle R12 ERP Implementation etc.
• Coordinated accounting staff and project technical consultants in implementing Oracle Financials.
• Implemented Oracle Financial GL, AP, AR, and Fixed Assets modules.
• Assisted the technical consultants to understand the customer accounting requirements to customize the functions and reports and designed chart of accounts.
• Assist clients’ accounting team in preparing quarterly, biannual and annual financial statements.
• Provide consultancy for Book Keeping of small and medium enterprises, budgeting, performance evaluation, cost management, and fixed asset management.