Ajay Chidrawar

· Assessment of all (170+) applications across enterprise.

· Building inventory of applications, capabilities, interfaces, data Sets, and integration methodology for enterprise level application landscape.

· Analysis and recommendations on application portfolio rationalization, reducing cost of ownership, defining data strategy and governance.

· Analysis of Datawarehouse and BI Ecosystem and provide recommendations on consolidation and rationalization for single truth of data for effective decision Making through self-service reporting capabilities.

· Planning project activities viz. scoping, Design, estimation, Staffing, training, tracking, change management, delivery management & post implementation support.

· Managing projects with respect to cost, resource deployment, time over-runs and quality compliance to ensure satisfactory execution of projects.

· Managing relationship with project stakeholders, keeping stakeholders informed of progress and issues to manage expectations on all project requirements and deliverables.

· Lead initiative for migrating SSIS Data Pipelines to Informatica PowerCenter. Approx. 2000 ETL's where migrated working in offshore-onshore delivery model and Real Time HL7 messages (ADT, LAB, RAD, ABS) parsing using Informatica Product Suite by defining robust architecture framework which is simple and scalable.

· Automation of ETL Mapping development to expedite development life cycle to meet stringent timelines.

· Responsible for development and Support for EDW, which source data from EHR Meditech Data Repository for Southern California, North California and Texas region hospitals and other sources.

· Analysis of EPIC Clarity data extracts stories, grooming, prioritization, assignment and follow up till completion by working with internal and external customers using Agile Kanban methodology.

· Guiding and defining the Data Extract Architecture framework, which is simple, scalable, and reusable.

· Ensure user sign off before deployment to production after thorough review of design, coding, testing and UAT for zero defect delivery.

· Operation Support Transition(24x5) from Client team to NTT Team and vice versa.

· Ensure 24x7 operations support so that Incident/Requests Tasks tickets are acknowledged, reviewed, Triaged, and resolved in timely manner for better customer experience as per defined SLA's.

· Daily Stand-up call for status updates and resolving impediments.

· Presenting status report to stakeholders on weekly basis with Status, Issues, Risk and Mitigation plan. Identifying areas of improvement as part of continuous service improvement initiative to increase productivity and customer experience.

· Migration of data from On-premises (SQL Server) EDW databases to Azure Cloud (Snowflake) databases by building design framework using IICS with minimum impact on BI tools seating top of EDW.

· Data Profiling by applying data quality rules using Informatica Data Quality tool.

· Prepare Data Linage from source to Target for traceability using meta data management utility.

· Defining strategy for migrating Cognos reports/dashboards on MS SQL Server to Power BI on Snowflake as part of on-premises to Cloud migration initiative

· Effectively work with business and cross functional teams for smooth delivery of projects.

· Planning project activities viz. scoping, estimation, tracking, change management, delivery management & post implementation support.

· Drive continuous service improvement (CSI) initiative to improve customer experience.

· Managed Support, Development and Master Data Management initiatives in DWH and BI area with offshore and onshore delivery model.

· Ensure 24/7 Operations Support and compliance with Service Management SLA's using remedy tool.

· Root Cause Analysis of defects to resolve and improve customer experience.

· Defining Migration Strategy for Business Objects to MS PowerBI.

· Review of Technical Artifacts ex: Low Level Design, High Level Design, Code, Unit Test cases etc.

· Architectural Roadmap for EDW Application Migration for technology modernization and implementation.

· Project Management, Change Management, Risk Management, People Management and Monitoring Client interaction right from the requirement gathering till the closing of the project.

· Delivering project in scheduled time with high Quality deliverables Project Status update on regular basis to the client

· BI Practice Team Assessment to identify skills gaps to fill in with appropriate training to improve productivity and quality of delivery.

· Transition of development projects and operations support from client team to NTT Team.

· Assessment of DWH and BI Architecture to identify gaps and recommend architectural changes for optimal performance leading to better customer experience.

· Lead multiple Data warehousing and BI initiatives for various OTIS internal customers as per defined priorities.

· Project Management Review (PMR) dashboard and presenting the same to the higher management on monthly basis.

· Streamlining Business Objects Universes and Reports to eliminate redundancy, improve performance for effective decision making.

· Ensure data availability SLAs are met to avoid any business Impact.

· Optimized data operations by automation and continuous service improvement.

· Project sizing, resource planning, costing, creating SOW/contracts for different OTIS customers.

· Responsible for delivering multiple projects in scheduled time with high quality deliverables by identifying issue, risks proactively and mitigating them in timely manner without impacting deadlines.