Ajay Chidrawar

Systems Integration Associate Director

adubj2@r.postjobfree.com

Mobile # +1-657-***-****

Irvine, California

Professional with over 24+ years of comprehensive experience in leading Data warehousing, Data Migration and Business Intelligence projects in Manufacturing, Healthcare, Retail, Insurance, Supply chain and Finance domain. Strong background in technical project/program /Delivery Management with an outstanding history of managing projects from initial conception, through development, to implementation using Waterfall, Agile methodology. Unexcelled record of bringing mission-critical projects in on schedule and within budget. Outstanding ability to build and lead data engineering teams. Extensive experience in global delivery. SKILLS

Management

Technical/Project/Program Management, Stakeholder Management, Risk Management, Communication Management, People

Management, Knowledge Management, Quality Management, Delivery Management. Design

Requirement Gathering & Analysis, Solution Architecture and Framework, Database Design, Building Data Pipelines

Technology

Data Management, Data Stewardship, Data Visualization, Data Warehousing, Business Intelligence,

Enterprise Dashboards, ETL/ELT, Testing, Data Integration, Data Management, Data Quality, Data Profiling, Data Mapping.

Delivery Agile Scrum, Feature Analysis, User Stories, Waterfall methodology, Hybrid methodology Methodologies

Domain HealthCare (Provider (EHR- Meditech and EPIC)), Supply Chain, Mortgage, Life Science, Retail Gathering requirements from business stakeholders to understand their processes and pain points to plan and deliver data focused solutions.

Develop data strategies, programs, and solutions based on business priorities, consumer insights, and industry trends that support data reporting strategy.

Project activities viz. Scoping, Estimations, Costing, Staffing, change management, Delivery management, Contract Management, Tracking and Monitoring, Transition Management, Knowledge Management, Quality Management, Sales Support, Communication, and Client Management. Liaison among the executive committee members, stakeholders, data engineering, Data Operations, Data Analytics and Data Extract Teams.

Responsible for full lifecycle application development of Data engineering and Data Analytics Projects (e.g. requirements gathering, use case development, system analysis and design, integration, testing, deployment) Ensure that activities are carried out in accordance with established specifications, schedules, and budgets with highest quality and timely delivery.

Managed EDW Data Operations (24x7 Production Support), Maintenance and Development Projects in various tools and technologies in global delivery model across customer engagements and deliver with customer defined metrics.

Hands on Technology leader with full stack development experience in Informatica Powercenter, Informatica Data Quality, Informatica MDM, Business Objects, Cognos, Snowflake, Azure Data Factory, Tableau, Power BI, Data Modeling, SQL, Unix Scripting and the end-to-end software development life cycle. Delivery transformation and Operations optimizations by continuous service improvement adapting lean methodology.

Application Assessment and Recommendation for performance improvement and defining technology roadmap.

Managed peak team size of over 30 team members and portfolio between 5-10M$’s. Responsible for Resourcing, Goal Setting, 1x1, Performance Appraisals, Trainings and Career progression for direct reports.

Single point of Contact for Customer to address escalation and conflict management. Experienced Managing Master Data Management, Data Management, Data warehousing, Data Integration, Analytics and Data extraction Projects.

Translating business requirement into detail technical specification, architecture, and Solution design. Define reporting approaches and explores solutions to complex problem to meet business needs. Defining and developing Architecture and framework for Data Pipelines using various tools and Technologies to source data from heterogenous sources i.e., relational, text files, HL7 & semi structured to build enterprise Datawarehouse for single truth of data.

Datawarehouse modernization, data migration, Reports migration on latest tools and technologies by applying creative approach to avoid rebuilding from scratch. Extensive experience in managing team of Data Engineers, Architects, Data Analysts, Business Analysts, ETL Architects, BI Developer, Tech Leads, DBA’s, Technical Project Managers. Assess, propose, and develop ongoing and existing staff training needs as per market and business needs. Ensure staff capacity is effectively utilized and balanced across projects and reprioritize working with stakeholders if required.

Experience with Agile and Waterfall software delivery management tools and techniques preferred (Scrum, JIRA, confluence, MS Project, Azure DevOps)

NTT Data Services (Former Dell Services), USA (Oct 2016- Till Date) Client: Providence St. Joseph Health, USA

Tools & Technologies: Informatica Powercenter10x, SQL Server, Informatica Data Quality, Informatica DX & DIH and Informatica Data Transformation, Cognos, Tableau, IICS, Snowflake, Oracle, Control M, Azure ADO, ServiceNow.

Roles and Responsibilities:

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. Executed Project 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 scalable with reusable objects.

Automation of ETL Mapping development to expedite development life cycle to meet stringent timelines. Responsible for development and Support of EDW sourcing data from EHR Meditech Data Repository for Southern California, North California and Texas region hospitals and other sources as part of Batch Data processing using data pipelines built in Informatica. Analysis of EPIC Clarity data extracts requirements, prioritization, assignment and follow up till completion by working with internal and external customers and Vendors. 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.

Ensure that all 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 the 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 and data quality rules using Informatica Data Quality tool. 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

Single point of Contact for Client and NTT Stakeholders with respect to Enterprise Data Warehouse, Data Analytics, Data Extracts and Data Operations.

Effectively work with business and cross functional teams for smooth delivery of projects. NTT Data Services (Former Dell Services), Bangalore (Oct 2010- Sept 2016) Client: Owens & Minor, USA (Aug 2012- Sept 2016)

Tools & Technologies: Informatica 9x, Oracle, Unix, OBIEE/OBIA, Informatica MDM, BOXI R3, MS Project Roles and Responsibilities:

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

Developing project baselines while monitoring and controlling projects with respect to cost, resource deployment, time over-runs and quality compliance to ensure satisfactory execution of projects Carrying out project management activities (collect requirement, define scope, develop design/architecture, project related Activities, conducting weekly meetings with business) Monitors and communicates project/Program progress to sponsors and project team including use of project status reports.

CSI Champion for account to drive continuous service improvement hence providing value additions to customer.

Managed Support and development projects with offshore and onshore delivery model. Identifying risk and issues in project and preparing the mitigation plan Coordinate the work of Data Engineers and Data Operations team supporting Enterprise Datawarehouse Manage a team of Data Engineers, Business Analysts, Testers, Data Architects and Operations Engineer. Client: PHH, USA (Feb 2012 to Aug 2012)

Tools & Technologies: Informatica 9x, Oracle, Unix, MS Project Roles and Responsibilities

Architectural Roadmap for EDW Application Migration 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 Project Management Review (PMR) dashboard and presenting the same to the higher management on monthly basis

Holds the distinction of completing each phase of SDLC as per agreement by following all the quality processes

Identifying risk and issues in project and preparing the mitigation plan Client: OTIS – A United Technologies Company, ISRC, Pune (Jul 2010- Jan 2012) Tools & Technologies: MSBI (SSIS, SSRS & SSAS), BOXI R2/R4, BO Data Integrator, BO Data Services 3.1, MS SQL Server, Oracle, MS Project

Roles & Responsibilities:

Team Assessment to identify skills gaps to fill in with appropriate trainings to improve productivity and quality of delivery.

Application Assessment to identify areas of improvement by recommending architectural changes for optimal performance and better customer experience.

Managing multiple projects for various OTIS internal customers. Project Management Review (PMR) dashboard and presenting the same to the higher management on monthly basis

Responsible for maintaining project related artifacts. 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. Responsible for Support Training and post-delivery Support. Previous work Experience:

Organization Tenure Title/Role Technology

Hp Globalsoft Ltd.,

Bangalore

Feb 2003 to Jun 2010 TPM/Tech Lead Informatica Powercenter, Business Objects, Oracle, Unix Scripting, HP Quality Center, Erwin,

MS Project Plan, MS SQL Server

Patni Computer

Systems, Mumbai

Jan2001 to Feb 2003 Sr. Software Engineer Informatica Power Mart, Unix Scripting, Business Objects, Cognos, Oracle, SQL, Oracle ERP

Skynet Software

Solutions(I) Pvt. Ltd.

Mumbai

Apr 2000 to Dec 2000 Software Engineer Visual Basic, HTML, MS SQL Server, ASP, MS Access.MS Excel

Formica India Division Aug 1997- Mar 2000 Consultant CA Open Ingres, SQL TECHNICAL BACKGROUND

BI Tools: IBM Cognos, Tableau, PowerBI, Business Objects, SSRS Tools and Technologies: Informatica PowerCenter, IICS, MS SSIS, Erwin Designer, Informatica Data Quality, Business Object Data Integrator, DataStage, Service Now, HP Quality Center. Databases: Snowflake, MySQL, Oracle, SQL Server, Ingres/CA Open Ingres Languages: SQL, PL/SQL, UNIX Shell Scripting, HTML, ASP, Visual Basic Cloud Platforms: MS Azure

Project Management: MS Project, JIRA, Confluence, Azure ADO, PowerPoint, MS Excel. EDUCATIONAL PROFILE

Master of Computer Applications (MCA) from Dr. B.A.M. University, Aurangabad, India. - 1997 Bachelor of Science (Micro-biology) from Dr. B.A.M. University, Aurangabad, India- 1994 Diploma in Pharmacy –Bombay Technical Board- 1991

Contact this candidate