Mar 2020 – Aug 2021 · 1 yr 5 mos · Chennai, Tamil Nadu, India

• o Lead the data engineering team for the global Books business. As a part of organisation restructuring, print books merged with e-books. I was responsible for driving a data integration initiative for merging print books and e-books to enable format-agnostic metrics for measuring the performance of overall books business.
• o Owned a charter to build analytics and data engineering products and services, thereby providing advanced self-serve capabilities, with an aim to reduce the cost to access data embracing best-of-breed data technologies.

Aug 2017 – Mar 2020 · 2 yrs 7 mos · Chennai, Tamil Nadu, India

• o Responsible for establishing a center of excellence for data management, reporting and analytics team
• o Technical ownership in design, architecture, data model and implementation of core ETL and BI functions.
• o Implementing mechanism for governance and project delivery
• o Manage a partnership with vendors partners, creating and managing SOWs and requisitions, invoicing and payment to external consultants, managing cost center budget and spends related to recruitment, travel, trainings

Mar 2016 – Aug 2017 · 1 yr 5 mos · Pune, India

• o Work collaboratively with the application, infrastructure and enterprise engineers to develop, document and maintain current and strategic data warehouse capability road maps, principles, standards models, patterns, and reference architectures
• o Ensure proposed solutions are aligned with broader enterprise architecture vision prior to them going to the architecture review board
• o Establish strategic alliances, and lead joint ventures with key IT suppliers and business partners that proactively drive business opportunities for the organization
• o Establish budgetary costs for achieving the technology road maps

May 2014 – Mar 2016 · 1 yr 10 mos · Bengaluru, Karnataka, India

• o Develop end-to-end solution processes including approximate time and cost estimation and implementation requirements
• o Investigate complex strategic business issues, researching and identifying innovative solutions
• o Effectively partner and lead teams with various staffing models of internal and external on-shore and off-shore resources to deliver successful solutions
• o Participate in the sales and business development by creating prototypes, request for proposals, evaluate databases and BI tools

Jul 2010 – May 2014 · 3 yrs 10 mos · Pune, Maharashtra, India

• o Business requirement gathering, and converting them to technical requirements ensuring that both the functional and non-functional requirements are met
• o Partner closely with business analysts, product capability managers, technical leads, other solution architects, enterprise architects, and vendors to ensure alignment with projects, programs and strategies, and standards

Jan 2008 – Jul 2010 · 2 yrs 6 mos · Noida, Uttar Pradesh, India

• o Understand business requirement and create macro design
• o Design solution for the integration of data from TELE2, a fixed line company acquired by Vodafone, in the existing data warehouse
• o Lead a team of 13-14 developers for application development
• o Transition of work from Spain local vendors to IBM GD, India using IBM’s migration methodology consisting of GP, AP and PP phases
• o Involve in ETL and report development, system testing, implementation and warranty support
• o Participate in root cause analysis for the defects identified post implementation
• o Participate in internal and external project audits
• o Mentor team members

Dec 2006 – Jan 2008 · 1 yr 1 mo · Bengaluru, Karnataka, India

• o Involve in analysis and design of data warehouse projects
• o Create technical specification document
• o Involve in performance tuning of complex queries on Teradata
• o Involve in development of new code, unit testing, system testing
• o Create MIS reports for UK and other group countries where Tesco operates
• o Create implementation plan and deploy the code to production environment

Jul 2006 – Dec 2006 · 5 mos · Pune, Maharashtra, India

• o Create system design document
• o Involve in major enhancements, minor enhancements and bug fixes
• o As a project lead, was responsible for mobilizing the offshore team
• o Design owner-beneficiary reports containing insurance data
• o Create unit test plan, participate in unit testing, integration testing, assembly testing

Jun 2005 – Jul 2006 · 1 yr 1 mo · Noida, Uttar Pradesh, India

• o Transition of work for the F&A module of British Telecom to offshore
• o Lead a team of developers during the transition process
• o Responsible for software releases, environment creation and refreshes, manage user licenses and user creation on Mercury ITG, manage Oracle/UNIX server outages, apply Oracle patches, evaluate request for changes, and manage the Mercury ITG server
• o Involve in client interactions, work allocation to team members and conduct team meetings

Apr 2004 – Jun 2005 · 1 yr 2 mos · New Delhi, Delhi, India

• o Work in the travel domain for British Airways and SABRE
• o Create/enhance code modules, create and execute unit test cases, provide support during SIT, UAT and create deployment plans
• o Create extracts for various airlines involving complex transformation logic in Teradata
• o Participate in peer review, unit testing, system testing

Oct 2003 – Mar 2004 · 5 mos · New Delhi, Delhi, India · On-site

• Create modules to automate various process of the warehouse like inventory control, revenue, bill generation, etc.
• Understand the business process and map the same in the software to automate the manual process
• Train end-users on the software modules

Oct 2001 – Sep 2003 · 1 yr 11 mos · Patna, Bihar, India · On-site

• Create modules for managing the revenue, generation of monthly power bills
• Create monthly ledgers through the software for reconciliation purposes
• Automation of the payment process at the counter
• Deployment of the software to various centres and training end-users