senior consultant

Anchoring Healthcare BI Long term project. Brought transparency and streamlined the work being done across shores.Timely communication with onshore partners/business for clarifications. Tracking defects and communicating with the development team till defects are closed. Scripting new data quality checks and improvising existing checks on production data to ensure quality is maintained.Revisiting data quality business rules time to time to add/update/delete as per the behaviour of data.Developed business reports using Tableau tool

ETL developer and TesterCost and Effort Estimation and Low Level Solution DesignerMigration TesterSingle Point of Contact for Module specific Business RequirementsTeam Mentor Key Driver and Point of Contact for all Business Requirement clarification with French Clients through telephone conferences, presentations and Functional to Technical Design JustificationInvolved in various Project activities like Requirement clarification, job mapping preparation, Job design, test data preparation, testing, deployment of job, data quality testing, interaction with customer

1.Client American Express Australia LimitedRole SAS ProgrammerProject SPS FP ProjectThis project is related to AMEX SPS-sales performance system. The SPS system tracks Opportunities, Sales, and Incentives and provides metrics and reports on how the portfolio is growing to the critical stakeholders. It also gets information from SalesForce.com. SPS contains data for Credit Cards and Charge Cards .SPS also provides insights on campaign effectiveness that then provides the inputs to make necessary changes in marketing strategy, if needed.This project mainly involves replacing the existing CHMDB (Card Member History Database) Source system to GDR (global data repository) Source system to load the Dimensions.Key Responsibilities:Understanding the project requirements by reading the documents provided by the client.Understanding the SAS jobs developed to extract data from the Source system called GDR (global data repository).Modifying few of the existing SAS jobs created to load the data from GDR according to the Changes mentioned by the customer during testing phase. Involved in end-to-end testing of SAS jobs.2.Client S I T A , PARIS, FRANCEModule Smartbill SiS Transformation Role ETL Developer and DesignerProject SmartBillThe International Air Transport Association (IATA) is an international industry trade group of airlines. IATA's mission is to represent, lead, and serve the airline industry. IATA represents some 240 airlines comprising 84% of scheduled international air traffic. All the Airline rules and regulations are defined by IATA. The main aim of IATA is to provide safe and secure transportation to its passengers.Key ResponsibilitiesValidation rules implementation compliant with SiS Standards for Invoice IntegrityXML Output of Invoices compliant with SiS which ensure 100% payment to SITAWeb portal testing in IATA Service Portal to ensure that there were no rejections.

Client S I T A , PARIS, FRANCEProject Smartbill SP7 Transformation Role ETL Developer and DesignerOne of the objectives of SITA was to upgrade Billing Output (Invoicing-Interface) to a more flexible and easy to manage solution using XML standards and DWH technologies. SITA would leverage on this technology upgrade and solution to produce fast, easy customized invoices (hard copies and e-invoices) to its customers. This subproject was called SP7Smart Bill SP7 is an invoice generation transformation project consisting of 7 packages which will replace the existing smart view consisting of complicated 70 procedures. This project involves the creation of Invoice repository which replaced the Smartview. Data extraction from the Kenan tables and load into invoice repository tables both Master and Transaction using the ETL tool Talend and generate PDF file for data verification after verification this will send to the customers. This involves the creation of Deferred outputs (Prebill, BRR, Monthly Xml, Smartview) and immediate output (IATA xml, IATA text jobs and it also covers the reporting part using BO, migration of the legacy dataKey ResponsibilitiesUnderstanding the Project requirement. Understanding the data model.Requirement gathering and requirement analysis. Preparing job mappings based on the requirement. Interaction with the customers. Preparation of Talend jobs to load invoice repository tables. Maintained good coding standards and naming standards as per the requirement. Preparation of UNIT and SIT test cases and testing the same.