Wilfred Xavier

RH-02, SAI POOJA CO-OP HSG. SOCI ETY, SECTOR -5, PLOT#40, KHARG HAR, NAVI M UMBAI -410 210, MAHARASHTRA, INDIA. PHONE: - Date of Birth: 21st April 1974 https://in.linkedin.com/in/wilfred-xavier Email:- WILFRED XAVIER SUMMARY  Over 10 years of experience in           Business Analysis Solution Architect Data Warehousing BI Architect Performance Management Continuous Improvement Strong background in Team Management, Product Management (Airlines and Credit Cards), Program Management (Airline Reservations, Customer Loyalty) Proven skills in Amazon Web Services, QlikView, Tableau, Redshift, Pentaho Data Integration, Mongo DB, MySQL, MS SQL, Postgres, Oracle. Proven skills in .NET (4.0, 4.5) and Java 1.8. I can develop REST, desktop, web and cloud applications. I have extensive experience in building enterprise grade applications using Windows Communication Foundation, Windows Workflow, Web API2, JavaScript and HTML B.Sc. in Chemistry from University of Mumbai in the year 1992 - 1995 TURN-KEY PROJECTS 1. Integrated Data Warehouse     Objective: Create a data warehouse which integrates structured and unstructured data, of varied volumes and arriving at varied velocity. IDW should be able to support data discovery via drag drop, support analytics, scale quickly and be low maintenance Stack:.Net ETL (multi node, multi-threaded, round robin task assignment), Redshift data store, Tableau data for visualization, S3 for short and long term data storage Method: Template based data import and ETL, each process spawns the next; tasks are allocated as per availability of nodes, new nodes auto signup and are available immediately. Data transformed into star schema and loaded into Redshift Deployments: AWS for Etihad, Accelya datacentre for Air India 2. Excess Baggage Audit Engine     Objective: Create a replicable and flexible rule based audit engine to audit Excess Baggage collections by airports for client airlines. Stack: Talend Java builds for ETL, Rules stored in JSON and parsed by JACKSON, Java console application as leader node and rule engine, PostgreSQL via JDBC, JAX-RS web API, jqPLot charts, Jquery and HTML UI. Method: Leader node identifies data source and hands off to Talend package for loading to PostgreSQL. The leader node distributes workload to all signed up nodes where Java rule engine parses JSON rule set and applies to incoming tuples. User can define report conditions dynamically using jQuery Querybuilder which are stored as JSON. Scheduled worker processes build and/or update reports, which are stored as JSON and delivered to user via JAX-RS, jqPLot and HTML UI Deployments: AWS for Virgin Australia, AWS for Etihad 3. Balanced Scorecard & Performance Management     Objective: Portal for entire business unit to review individual and departmental performance, its alignment and progress with respect to goals and KPI of business unit Stack: WCF web service, JQuery UI, PostgresSQL data store via Npgsql Method: Balanced scorecards created in conjunction with business head and department heads. Scorecards created for each employee and department. Scorecards had metrics, KPI, Critical Success Factors, Objectives and Perspectives. Portal contained historic data and reacted to real time data to indicate RGY to various stakeholders and individuals Deployments: Accelya datacentre for internal consumption 4. Ticket Audit Engine      Objective: Audit airline tickets as sold by travel agents etc. on behalf of airline for ticketing rule violations Stack: Business rules in .NET 4.0 WF, multi-threaded console application, Amadeus GDS interface Method: Accepts ticket good for passage and creates audit commands required for Amadeus, interfaces with GDS, passes audit commands till result is found, stores results in database (Oracle) and compares fares and rules as defined Features: Sales, Refunds (Part and Full), Exchanges (multi parent) Deployments: Accelya datacentre for Saudi Arabian Airlines and Kenya Airways 5. Continuous Improvement- Customer Satisfaction and Nett Promoter Score   Objective: Collaborate with client (United Airline) to continuously improve customer satisfaction scores and Nett promoter scores. Method: Identify areas of improvement using DMAIC. Implement improvement measures via employment training programs, reward and recognition programs, continuous evaluation of performance via data collection and alerts. Implement a strong outlier management program, identify employees with skill and/or motivational requirements and intervene proactively with counselling sessions. Conduct monthly town halls to update division on progress, celebrate achievements and reach consensus on mission objectives PROFESSIONAL EXPERIENCE Accelya Solutions as Group Manager – Solutions Architect, Decision Support Services Apr 2015 – Till Date.       Design, develop and implement a replicable integrated data warehouse of all in house products offered by Accelya Identify and procure appropriate software, hardware, vendors and resources required for productizing integrated data warehouse Lead data warehouse design and development, ETL design and development, reporting requirements through Tableau, Qlik and custom build self-service cubes Ensure solution is accessible and scalable horizontally and vertically, lead deployment to and maintenance on Amazon Web services Understand customer decision making processes, identify information needs and conceptualize product offerings for these needs Understand customer’s mid and long term strategy, operational challenges, market dynamics and help customer to operationalize strategy Accelya Kale Solutions (Kale Consultants) as Group Manager – Business Solutions Jun 2009 – Mar 2015          Identify Process Improvement and implement Workflow automation Identify System throughput opportunities and recommend product changes Create easily available knowledge base and multi skilling workforce Implementation of Risk Control Self-Assessment Integrated Project Review mechanisms Provide cost reduction solutions for multiple customer on the managed business process platform Product improvement through better management of issue resolution and interface with development teams Manage change as directed by IATA and/or customer and ensure managed processes and IT solution reflect these changes by understanding change, creating gap analysis for development team, tracking successful deployment to test environments, transition to production environment, UAT and sign off by customer Understand customer requirements through business focus groups, recommend additions and/or improvements to product, decision support tools and customer dashboard IBM Daksh Business Service Pvt Ltd As Deputy General Manager – Operations Apr 2008 – May 2009 As Senior Manager – Operations Dec 2005 – Apr 2008  Implemented e-learning across projects in the location and is being evaluated for organization wide deployment  Leading digitization and work flow optimization for the location  Leading a process of 400 (325 operations + 75 support, inbound airline reservation)  Operations, Quality, Training, Work Force Planning, P/L E-Serve International as Operations Manager and Sales Delivery Leader Sept 2004 – Nov 2005  Drive client revenue numbers through increased sales and lower cost per sale  Plan delivery of hiring number and oversee training Wipro Spectramind eServices Pvt Ltd As Operations Manager Apr 2003 – Aug 2004 As Group Leader Sept 2001 – Mar 2003  Transition product launches, new initiatives, six sigma projects initiated by the client at our site  Oversee ramp-ups, process conversions, on the job trainings, attrition  Conceptualized and implemented Outlier Management and Process Control E-Funds International as Team Leader Oct 2000 – Aug 2001  Manage a team of 25 customer service representatives  Helped setup MIS system to provide reports of productivity of various teams and team members Taj Group of Hotels as Assistant Manager – Taj Inner Circle Feb 1999 – Sep 2000  Managed 10 customer service executives, 4 data entry operators  Service centre was responsible for the management of the loyalty program across 52 properties Broadsystem Multimedia Pvt Ltd As Supervisor – Call Centre Jul 1998 – Jan 1999 As Team Leader Dec 1997 – Jun 1998 As Customer Service Executive Mar 1997 – Dec 1997  Managed 3 Team Leaders and 36 customer representatives  Responsible for the successful execution of various product campaigns Opaal Marketing as Sales Executive Jan 1996 – Feb 1997 Japan Hi-Tech as Sales Executive Jun 1995 – Dec 1995