Amit Luthra Email & Phone Number

Wokingham, Gb

London, United Kingdom

Delivered highly scalable and efficient data analysis solutions to produce all aspects of reporting, data analysis, and data visualisations for all departments including Finance, Product, Risk, Sales, Client Services and CareImplemented Data virtualisation (Denodo) schemas and unified views to combine Legacy (MS SQL server) and cloud (AWS Redshift) data sources to generate reports, dashboards, and analysis. Administered the Denodo caching schedules for all virtual data ports, database creation, users, roles, and managed access privileges. Provided training and support on Denodo to the business users.Successfully led projects of data migration from SQL server to AWS, working with multiple teams and in different timezones.Improved accuracy, completeness, and timeliness of existing processes through automation and redesign.Implemented new systems and trained users to increase adaptability.Skillset – SSIS, SSMS, SSRS, Oracle, SQL, Postgres, Git, Power BI, Spotfire, AWS, Denodo, Hive, Jira, Kimball, Agile, Scrum

London, United Kingdom

Created Operations Dashboard tracking all the call metrics and SLA reporting. Provided insights on the agent performance and improved resource management by reducing the cost by 15 %.Created a complete BI solution to acquire and report on the customer Survey Data. Providing a centralised view of NPS score across different clients and regions.Migrated various MS Excel reports to SSRS for error-free and subscription-driven delivery of reports.Created and maintained data dictionary and enhanced metadata layers, reports, report definitions and dashboards.Produced guidelines and standards for ETL usage, manageability, and maintainability within the organization.Skillset – SQL Server, SSIS, SSMS, SSRS, Excel, SQL, Spotfire, MS Excel

Developed centralised KPI reporting for the billing function using MS Excel & SSRS. This removed the ambiguity of billing measures across the organisation and provided a single source of truth. Prioritised and tracked billing incidents, providing impact assessments, internal communications and advice/guidance on customer communications in accordance with BACS or FSA policy.Identified all internal and external stakeholders and disseminate appropriate communications, chair conference calls to alert them of impacts and risks.

London, United Kingdom

Responsible for managing the migration of resource management system across the Global Infrastructure services. Liaising with stakeholders at various levels within the organisation and across EMEA, AMERICAS & APAC regions.• Making sure that the data from different sources is synced correctly into the system.• Highlighting the issue and providing the solutions across all the departments globally.• Liaising with stakeholders at various levels in the organisation, across countries and across departments• MI Reporting• Track progress against delivery plans, identify and report any (variance) to plans.• Make predictions and identify recommendations as necessary to remediate delivery shortfalls.• Provide regular reporting to central program office, regional management and other stakeholders as required.• Provide ad-hoc support to various initiatives as required.

• Creating and executing project work plans and revise as appropriate to meet changing needs and requirements.• Identify resources needed and assign individual responsibilities.• Managing day-to-day operational aspects of a project and scope.• Review deliverables prepared by team.• Ensure project documents are complete, current, and stored appropriately.• Extracting participant’s data from various sources.• Cleansing the data & making it ready to be utilized in different processes.• Produce Return on Investment Analysis at the end of each program me.• Prepare Pre & Post Evaluation analysis of all the trainings for client.• Tracking course progress by generating reports on weekly and monthly basis.• Business and financial strategy and planning, monitoring, management and reporting, including management and development of policies, systems, processes and personnel involved. • Reporting and accounting as per regulatory and legal requirements including taxation, dividends, annual report and accounts. • Contributing to strategic planning and development as a member of the team, and directly reporting to the CEO.• Managing and controlling departmental expenditure within agreed budgets. Budgeting and financial forecasting. • Setting and planning how to achieve supplier accreditation and service level management. • Manage and report on all invoicing activities using agreed systems and processes.

Responsible for producing and maintaining all aspects of regular reporting using Excel tools like Lookups, macros and pivots, including providing insight and commentary on the performance of the business.Job responsibilities:Producing reconciliation reports on weekly, monthly, quarterly basis for identifying collection & sales KPIs which can used into tailored MIS (management Information System).Providing insight through analyzing various data sources and supporting findings through creating graphs and charts.Streamlining reporting through automation and the removal of redundant processes.Cleaning data by removing test and duplicate cases.Managing all ad-hoc requests regarding analysis or reporting.Preparing documentation for different procedures set in place or changes made to it.Propose changes and new schemes to management for approval and implementation based on the findings from extracted data sets.Preparation & presentation of Business models giving brief on financial, sales and marketing processes involved and long term profit analysis.Developing tools and Marcos using VBA to extract data from SQL to produce data for reporting.Management & preparation of 2 payrolls for 500 sales and collections employees by collation, manipulation and interpretation of data from various sources, using SQL queries to grab the data from the database.Representing data in Pivot tables, Pivot Charts, Graphs with strong statistical methods and analysis.Responsible to carry out invoicing to various publication customers including Financial Times, Wall Street Journal, Timeout, The Week, USA Today etc.Responsible for Bank reconciliation of all the off shore GBP and USD accounts and updating the cash flow & liquidity report for the CEO on daily basis.

Responsible for managing a team of 25 technical support engineers and 2 soft skills trainers. Making sure that the support is provided within the agreed SLA while maintaining the highest level of customer satisfaction.Job responsibilities:Coordinating team activities, report generation using Excel tools like Look-Ups Pivot Tables & Charts.Motivating and developing members in a dynamically changing environment.Achieving and exceeding performance deliverables & KPI's. Ensuring Service Level Agreement is met to the highest degree.Creating a conducive and stimulating the environment for the members to accomplish goals. Providing guidance on technical problem solving.To ensure deliverables are prepared to satisfy project requirements, cost and schedule.

Bachelor'S Degree, Economics

Honours Diploma, Network Centered Computing

Gcse

Physics, Chemistry, Mathematics