TECHNICAL SKILLS

Analysis Methodologies: Agile, Waterfall, Risk Analysis, Gap Analysis.

Databases and Tools: MS SQL server, TOAD, VBA Macro, SAP HANA

Data Quality: Informatica 10g (IDQ)

Metadata: IBM Information Governance Catalogue (IGC)

Business Modeling and Release Management: Microsoft Visio, Microsoft TFS, MS visual Studio, HP QC

Reporting: Excel (Pivot, formula and Vlookup), SharePoint, SQL server, Tableau

PROFESSIONAL EXPERIENCE

Confidential

Business Analyst

Responsibilities:

• Performed GAP analysis to identify the gap between current state and desired future state
• Organized kickoff meetings to introduce the project to the stakeholders, business groups and timelines
• Document high level requirements to address capability gaps in Current vs Post state
• Interviewed compliance group to defined and documented business requirements in the form of BRD using the GAP analysis findings
• Refined and decomposed high - level information into details and business logic to clearly define requirements; present and lead discussions with business users in white board sessions, interviews and JAD sessions
• Key deliverables include documentation of business process/system flows, BRDs, FRDs, impact summary, capability gaps requirements and identifying implementation ownership within cross functional IT Teams
• Created Data flow diagrams using MS -Visio to assist in migration to the new application
• Performed Data analysis using excel functions such as Vlookup and created reports using Pivot and excel formulas
• Performed data analysis using SQL to understand the different type of data and tables which will be impacted
• Built new and revised business process maps ("As-Is/To be") flows, use cases and data flow diagrams to assist IT team in the solution
• Analyzed and reconciled Upstream source data for several asset classes including bonds, equities, exchange traded and OTC derivatives to create a Data Mapping
• Participate in the walk-through Sessions with Technology to discuss Solution Requirement document
• Provided administrative and operational support for the PMO regarding making sure project data is easily accessible, project tracking metrics and distributing project information as needed
• Built a test plan to test the solution along with the test cases and test scenarios in MS excel
• Executed Test Cases using SQL to ensure the agreed changes appeared in the client’s profile
• Coordinated Testing and managed test defects in HPQC
• Assisted in UAT and PAT setup and signoff

Environment: MS Office, SQL, MS Visio, HP QC

Confidential

Business Analyst

Responsibilities:

• Facilitate JAD session with the Product management team, portfolio management team and IT to elicit and capture functional requirements and data requirements
• Created requirement documents to captured logic to build the report and identifying source of input data in to BRD, DRD to assist IT in solution
• Captured logic to calculate asset mix, investment mix, yield to maturity and fund performance in the BRD
• Created Data Requirement Document (DRD) by analysing input data files from various sources and systems, in order to identify the list of Data element required along with their transformation logic
• Facilitate JAD session to revised BRD and DRD and captured feedback
• Performed Data analysis using excel functions such as Vlookup and created reports using Pivot and excel formulas
• Analyzed source system data in SQL tables to understand what data elements comes from various in scope sources and what data element is sourced from the golden source for ETL calculations
• Documented Functional and non function requirement in business requirement document
• Revised BRD, DRD, wireframes, SLA to help development team to build estimates
• Worked with BSA to create System requirement document
• Built a Data dictionary and Business glossary of the required data element for the report
• Created Test strategy, Test plan, test cases and maintained defect log
• Groomed project backlog, translated high-level requirements into user stories, prioritized and sequenced user stories using JIRA
• Coordinated and assisted in UAT and PAT testing
• Provided Postproduction support to the client

Environment: SQL, JIRA, SharePoint, Visual Studio

Confidential

Junior Business Analyst

Responsibilities:

• BRD reviews with business stakeholder to provide clarification on the business requirement and prepared Use cases for technical stakeholders
• Business Glossary/ Metadata gathering Strategies for all enterprise systems and Data Warehouses
• Attested and validate the data lineage from source to report and produced linage report for audit trials.
• Captured and build an enterprise business glossary for all CDEs as a part of enterprise initiative (EDW/CDS) and produced data mapping documents to create source to target mapping
• Created data flows diagrams to understand business processes and how data flow through the system to capture Metadata, data linage and preformed Data Quality.
• Loading the Business glossary in the metadata tool and assisted with the validation package to test data lineage from source system to report in IBM Info sphere Governance Catalogue (IGC)
• Performed Data analysis on various sources using excel functions such as Vlookup and created Data Quality reports using Pivot and excel formulas
• Analyzed Source system data, ETL logics, Data in SQL, Oracle tables to create Data linage and Data Quality reports
• Worked closely with Data Architecture, Data modeler and DBA s to gather a list of all critical data elements (CDE) for entire enterprise and performed Data Mapping, collecting Metadata and Data Catalogue across collateral management, Credit, Market & Liquidity Risk
• Identification and documentation of Data Source, ETL logics and tables and Data Destination in the form of Data Lineage
• Identify upstream and downstream reference data requirements in terms of creation of views, tables and modification of existing views, tables e.g. creating customized views, adding new columns, changing data types etc.
• Implement Data Governance framework using Agile Methodology
• Carried out impact assessment and data quality checks, ran queries using SQL and created data analysis reports for senior business leaders
• Documented data reconciliation processes for capital market, credit risk, collateral and other risk group to fulfill regulators ask
• Conduct Credit Risk, Counterparty (including Collateral management) Retail data analysis to performed Accuracy, completeness, consistency and timeliness for data quality reports

Environment: MS Office, Enterprise JIRA, Informatica Data quality (IDQ), IBM IGC, SQL