Apr 2021 – Oct 2022 · 1 yr 6 mos · Mumbai, Maharashtra, India

• Established a clear vision, strong leadership, and strategic direction for analytics COE data and analytics platform services and capabilities. Assisted other sectors in gaining alignment on and driving strategy execution by acting as their partner voice. Ensure excellent goods and services, global optimizations, and organizational effectiveness/accountability in a culture of ongoing learning and development
• Drove automation and self-service technology by leading the data/analytics lifecycle journey in alignment with Agile, DevOps, and ITIL.
• Established analytics ecosystem on a multi-year journey toward becoming a world-class, hybrid on-premises/cloud-native data technology stack.
• Identified opportunities for data science / analytics which has driven enhanced insight into the risk profile and control environment; leaded engagement with stakeholders.
• Built a data architecture to drive innovation: By migrating on premise to cloud-based data platforms, by changing batch to real-time data processing, transforming pre-integrated commercial solutions to modular best-of-breed platforms, changing data access from point-to-point to decoupled data access, converting enterprise warehouse to domain-based architecture, re-architecting rigid data models toward flexible, extensible data schemas.
• Lead a analytics division that collaborates with business and application engineering teams to create co-creative concepts, analytical models, solutions, and alternatives to support the delivery and innovation of analytics applications
• Specified a cross-cloud strategy and choose technologies like big data, integration architecture, and container usage. promote the use of cutting-edge business intelligence, analytics, and machine learning frameworks.
• Implemented reusable cloud-friendly engineering frameworks for application security, monitoring, CICD, and configurability in collaboration with Developer services.

Jul 2017 – Apr 2021 · 3 yrs 9 mos

• Managerial Responsibilities: Leading a team of data analyst and data engineering teams, which together are providing analytics and reporting support for operational and improvement work across different customers.
• Supporting Requests for Analytics & Reporting: Key team member for designing and maintaining systems to support the analytics and reporting needs of the customers. This includes self-service analytics portals and systems for soliciting, vetting, and deploying analyst teams to support requests for analytics support from customers and service lines across different domains. Also help customers in combining a robust data warehouse design with strong data governance and a set of data visualization tools to empower managers with self-service analytics.
• Ensuring Strong Data Governance: This includes overseeing and refining processes for developing and communicating a single source of truth for data elements and metrics; and defining and enforcing policies related to the effective, safe, and secure management of information assets.
• Ownership of Analytics Tools and Data Infrastructure: accountable for the analytics technology stack from the tools and applications to the data warehouse.

May 2012 – Jun 2017 · 5 yrs 1 mo

• Responsible for the design, development, implementation and ongoing management of enterprise analytics and data management projects and initiatives along with leading Business Intelligence, Data Warehousing and Big Data delivery across multiple functional areas with direct management of internal and external teams with global footprint. Acted as a change agent and an ambassador for the Global Analytics team, promoting adoption of analytics-based business insights leading to better business decisions. In this capacity also acted as a strategic advisor to customer leadership on the long-term global analytics strategy and roadmap and integrate the team towards Big Data and Data Science capabilities.
• Worked extensively on end-to-end design and development with data warehousing, data modelling, data integration (ETL), data profiling, advance analytics and business intelligence
• Defined, configureded and optimized various processes and stages of analytics and advanced analytics delivery leveraging Big Data platform and advanced analytics.
• Key team member of enterprise architecture team of various customers to ensure that the data management principles and assumptions are aligned to IT strategy

Aug 2010 – Apr 2012 · 1 yr 8 mos · Mumbai

• Management of the Tricom Business Intelligence practice, including consulting management and development, sales support and proposal and both oversight of, and hands on delivery of BI solutions to multiple clients
• ADFS (Automated data flow system) – System includes designing of CDR(Central Data Repository) for bank to deliver 273 Adf Report(A) +256 Banks Identified Reports(B) +97 Additional Reports(C)=623 Reports along with 48 dashboards. System serving 500 concurrent users and 50 power users. ADFS was developed on oracle stack along with XML viewer as third party tool for XBRL reporting. My role includes:
•  Responsible for end-to-end project management including project plan , system requirement blue print development ,presentation and sign-off , Impact Assessment, Data gap analysis and correction strategy , Business Analysis ,Project delivery ,Functional Testing and User Documentation.
•  Estimation & management of project timelines, resources( 32 team members including solution architects , Business analysts, developers( Datawarehousing team , Report developers, Dashboard developers) testing team) for target implementation schedules.
•  Smooth execution for UAT and sign-off for the various milestones.
•  Responsible for all the documentation & updates needed for PMO and client , weekly updates on project progress to all project stake holders, presenting the progress in steering committee meeting.
• Design and Development of e governance solution CGIS( Corporate governance and intelligence system) for UBI bank and NRHM(National Rural and Health mission)

Nov 2007 – Nov 2009 · 2 yrs · Hyderabad Area, India

• As a senior level consultant, responsible for the overall technical implementation of various BI projects. Role includes full engagement experience through sales support, client vision development, tool selection, technical and Data Warehouse architecture and delivery. Mentoring consulting and client resources and hands-on technical development were included.
• Analysis and design of 200+ reports for OBIEE (Oracle Business Intelligence Enterprise Edition) / Siebel Analytics .Created Oracle BI Answers Requests, Oracle BI Interactive Dashboard Pages and Prompts, and Oracle Delivers iBots.Analyzed end-user query performance when implementing and tuning OBIEE
• Service Delivery: Successfully implemented new BO XI 3 Business Intelligence analytical web based store-level performance reporting to 15,000 users across 4000+ stores, meeting all performance SLA’s
• Acted as Essbase Subject Matter Expert / Mentor for Hyperion Planning application with 185 web forms, 220 business rules and 150 users; assisted client in knowledge transfer and transition from consulting firm
• Created Web Analysis / Essbase proof-of-concept dashboarding solution
• Cost Savings: Saved ~32% of the overall BI server upgrade project effort by utilizing offshore for testing of applications. Assisted portfolio management in improving work order process timeframe by 25%

Jan 2006 – Jun 2007 · 1 yr 5 mos

• Responsible for providing hands on support to BI delivery teams for Solution, Technical and Data Architectures including platform selection, data modeling and ETL design.
• Proposed, designed, and developed an enterprise level cellular network reporting system that tracked the operational performance of the companies cell sites. The web-based system used several OLAP cubes to deliver hundreds of metrics by time, location, and technology. The data mart portion of the application contained six databases ranging in size from 10GB to 300GB.
• Developed external and management financial reports, replacing the reporting that had been done in the ERP system. Reports included traffic lighting, flexible filtering, menu-driven customization, and stored user preferences. Reports that I developed included income statement, balance sheet, variance to budget, variance due to exchange, regional activity, as well as process reporting for exception handling and management of new metadata. Cut report generation time from 45 minutes to less than one minute.
• Data modeling for the Inventory and Sales reports in Business Objects

Apr 2003 – Dec 2005 · 2 yrs 8 mos · Ahmedabad Area, India

• Designed and developed several database applications to improve internal reporting processes and reduce inefficiencies in data gathering. Typical projects entailed defining user requirements; identifying relevant data; programming and debugging code; and writing technical documentation to support applications. I also converted a capital expenditure reporting process (that originally used 130+ Excel spreadsheets) into a single database application.
• Maintained a web-based network reporting system and developed an OLAP reporting system to track cell site capital expenditures, cellular network performance, and the status of cell site construction projects. Other tasks included creating a search engine that incorporated SQL Server 7 full text catalog functionality, developing a knowledge base to solve user problems as well as track application glitches, and serving as help desk contact to support and troubleshoot system performance and user-related problems.
• Created Presentation catalogs, and Folders in Presentation Layer, and Performed Global Consistency Check in Siebel Analytics Administration Tool.
• Involved in performing the Impact Analysis of Migration.
• Built Reports and Dashboards for Business Users, and Set up Usage Tracking database.
• Implemented Dynamic Dashboard Prompts to zoom into different segments of the customers and Brokers, to achieve performance optimization and easy navigation of reports.