Business Intelligence Developer

• Sep 2022 - Present

Assistant Consultant

• Aug 2021 - Present

- Working closely with stakeholders to understand business requirements.- Proposing solution design for gathered requirements- Creating data mappings from Data warehouse to Mart in IBM Fasttrack- Writing medium to complex SQL queries to analyse the data to provide answers to business and development team- Analysing data issues highlighted by business, by analysing ETL Datastage jobs and oracle- Working in Agile Methodology and utilising Jira to track business requirements in form of user stories- Acting as bridge between offshore team and business- Building understanding of various source systems- Providing technical guidance with team related to Power BI Show less

Business Intelligence Consultant

• Jul 2020 - Jul 2021

- Provide planning and reporting solutions to ensure business reporting needs are aligned to their business requirements. - Analysis of data model, identification of data set and creation of plan for consolidation of various business reports and migrating to Power BI- Define and Manage BI deliverables- Participated in project planning sessions with project managers, business analysts and team members to analyse business requirements and outline the proposed solution.- Developed reports on Claims and Accounting Data- Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.- Handling of various critical issues raised by business- Conduct business meetings to analyze and gather requirements for the reports- Provide effort estimation for development work- Provide technical guidance to the team members when needed- Developed knowledge on insurance dataTechnology Used: SAP BO, Power BI, Oracle Show less

Technical Lead

• Oct 2019 - Jun 2020

- Understanding existing airline MRO system- Creation of Data Model for data migration- Creation of migration flow process diagrams- Creation of Technical Design document and process flow diagrams- Involved in the study of sources & targets mapping. Extracted data from sources such as Oracle, Flat Files, XML files Transformed as per mapping specification documents and loaded into Oracle- Gathering business requirement and providing feasible solutions- Effort estimation of the development work- Completion of data migration POC using Azure Data services- Creation of Power BI dashboards.- Used various sources to pull data into Power BI such as Sql Server, Oracle, SQL Azure, JSON,XMLTechnology Used: SAP BODS, Azure Data services, Oracle, Engineering MRO system, Power BI, DevOps,Visio Show less

Data Engineer

• Dec 2017 - Sep 2019

Ticket Feed Project- Develop real time jobs to consume the XMLS messages from MQ and load into Staging database- Creating the BODI job to extract the data from staging layer to transactional database.- Experience of transformations like Query, Key Generation, Pivot, Map operation, Table Comparison in Data Integrator.- Creation of ETL Processes for the added new Subject areas, Develop Data Extraction, Transformation and Loading Program using Data Services.- Involved in Creation of jobs that specify data mappings and transformations by using Data Services Designer.- Used Data Integrator to load data from different sources (SQL, Text files) to the target database- Created Jobs, Workflows, Transformations and Data Flows according to requirement to integrate source data in to Target data ware house.- Experience in Business Requirements Analysis and Documentation.RTDP Denied sales project - Processing of raw RTDP log files using SAP BODS ETL tool and capturing meaningful data in Oracle Database - Creation of Business object universe for business reporting. - Creation of Business Object reports for denied sales reporting BlueSkies project - Creation of ETL process that identifies elite members of VAA, Delta, AF/KLM airlines - Creation of ETL process to share Flight BidPrice information between partner airline i.e VAA, DL, AF/KLM - Creation of ETL process to fetch VAA accruals data and share it with partner airlines Show less

Data Analyst

• Dec 2016 - Nov 2017

Client: Virgin Atlantic Airways- Analysing real time ticketing data- Documenting, understanding business requirement and making sure requirements map to the business need and approved by all stakeholders- Underlying data issues that need to be addressed and discover any information related to the business- Development of new ETL job to generate Ticket extracts from real time- Monitoring of all the interfaces between VAA and third party- Handling Adhoc business queriesTechnology Used: SAP BODS 3.2, SAP BO XI R3.1, SAP BODS 4.2, Oracle 10g, 11g Show less

Management Information System Analyst

• Feb 2014 - Nov 2016

Client: Virgin Atlantic Airways- To connect with users from various business areas about their queries and provide appropriate resolutions.- Meeting with users to understand requirements and provide feasible solutions.- Working on problems tickets to permanent resolution of issues- Handled the tickets of priority 1, 2 and 3 by following (SOP) Standard Operating Procedures and never missed the (SLA) Service Level Agreement.- Supported the client by providing long-term solutions to the tickets by doing Root cause Analysis.- Used BODS Data Integrator Transforms PIVOT row level transformation according to reporting requirement.- Used the LOOKUP_EXT and LOOKUP_SEQ functions to derive the columns in BODS ETL- Actively involved in Load Monitoring of Daily, weekly, and Monthly, Data Loads using Process Chains.- Rectifying the Load Failures for Master Data and Transaction Data Loads and analysing the reasons for frequent failures of loadsTechnology Used: SAP BODS, SAP BO, Crystal Reports, TM1, Oracle, Remedy Show less

Business Intelligence Developer

• Sep 2012 - Jan 2014

Client : Lloyds Banking Group- Analysing the requirements and communicating the discrepancies- Creation of universe, canned and ad hoc report to support client requirements- Realization of proof of concepts, sample reports, etc.- Responsible for deliverables such as MLPD ( mid level platform design), DPAD, etc.- Preparation of testing scripts, unit testingTechnologies Used: SAP Business Objects, Oracle