Business Analyst (Data)

• May 2023 - Present

Senior Data Management Analyst

• Feb 2022 - May 2023

Responsibilities as a Senior Data Management Analyst:• Engaged in customer, account and transactions data analysis using Azure Data Bricks as part of Open Banking / CDR (Consumer Data Right) program of work. • Creating decision trees to analyse series of decisions and mention action steps/ further checks on each outcome for different business rules and standardization processes for different requirements.• Collaborated with system owners to identify data gaps and facilitated delivery of data files and possible remediation of gaps with systems owners.• Data Profiling & Analysis of source data to identify Data Quality issues for all critical data elements and documentation of Data Quality issues in appropriate Data Quality Issues Register• Assisted Developers and Testers to understand technical rules and exception handling requirements• Documentation of Interface Specifications (Data Mapping) for data files in scope and Detailed tech specifications to support development. Show less

Business Intelligence (BI) Analyst | Data Analyst

• Aug 2021 - Jan 2022

Responsibilities as a BI Analyst / Data Analyst:• Engaged in customer, account and transactions data analysis using Microsoft T-SQL as part of KYC (Know your Customer), AML/CTF (Anti Money Laundering/Counter Terrorism in Financing), and Financial Crime Remediation and Enhancement program of work. • Collaborated with system owners to identify data gaps and facilitated delivery of data files and possible remediation of gaps with systems owners• Data Profiling & Analysis of source data to identify Data Quality issues for all critical data elements• Data Ingestion activities - Validation of Data Ingestion process by ETL Framework• Data Curation and related documentation (source to target mapping - with pseudo codes)• Identification and documentation of data gaps & default values (or proxies as confirmed with BA and system owners)• Assisted Developers and Testers to understand technical rules and exception handling requirements• Documentation of i. Interface Specifications (Data Mapping) for data files in scope ii. Data Quality issues in appropriate Data Quality Issues Register iii. Detailed tech specifications to support development Show less

Business Intelligence Analyst | Sr. Associate Projects

• Jun 2013 - Aug 2014

Clients: Barclays (UK) Responsibilities as a BI Analyst: • Conduct information-gathering interviews and obtain feedback from clients and customers • Collect data and extract data from warehouses for reporting, using querying techniques • Make data easy to understand through designing and building data models to drive meaningful business value. • Use a variety of analytics tools to analyse data and determine business performance. • Transform raw data into insights, reports, charts, visualisations and forecasts. • Work with stakeholders to develop metrics used in performance assessment and key performance indicators (KPIs). • Create procedures and policies used in the collection and analysis of data. • Develop new data analysis methods. • Gather and analyse data to determine priorities and set workflows. Show less

Data Analyst | Application Programmer

• Jan 2010 - May 2013

Clients: General Motors (US), Lloyds Bank (UK) Responsibilities • Produce a complete set of module specifications that can be used for coding • Develop detailed technical designs for complex modules • Review detailed designs developed by others and resolve design issues with other module • Develop Jobs, Sequences and complex stages such as Look-ups, Joiner, Aggregators and transformers • Ensure ETL components meets design specifications and project standards • Code modules following the design specifications and standards • Fully and effectively review code for defects and proposes revisions • Develop, update and maintain the application test plan in accordance with the client and project needs and methodology standards • Monitor testing to ensure that it is on time and within budget, and that all quality and design requirements are met • Analyzing the service requests and its impact on the related jobs. • Prepare all documents related to an SR - test cases, test scripts, test results, mapping change tracker, peer review log, process defect log, code review mails • Assist new members of the team as appropriate in terms of mentoring and guidance around technical/functional area Show less

Data Engineer | Software Engineer

• Dec 2006 - Jan 2010

Clients: Best Buy (US), Dean Foods (US), American Express (US) Responsibilities • Perform the detailed design of application and technical architecture components. • Develop common test data. • Configure, build, and test the application or technical architecture components. • Work with other developers, designers, and architects to make sure that the configuration and custom components meet application requirements and performance goals. • Participate in code reviews. • Inform the technical architect and project manager of any issues that may affect any other areas of the project. • Participate in transitions of the application or technical architecture components to the testers. • Fix any defects and performance problems discovered in testing. • Document the application to facilitate maintenance. • Use enterprise data management tools like DB2 to create accurate, consistent and transparent data content; emphasizing data precision, granularity and meaning with concern for how content is integrated into business applications as well as how it is passed from one business process to another. • Use Extract, Transform and Load (ETL) tools like Informatica to extract data from outside sources, transform it to fit an organization's business needs and load it into a target such as the organization's database/datamart. Show less