sachin lokhande


• 17+ years of IT experience in the software development life cycle. • Substantial experience in telecom, insurance, health care & finance industries. • Expertise in data governance, data quality, data modeling, data classification & BI Reporting. • Design & developed conceptual, logical & physical DWH-BI data model & data flow diagrams. • Developed star and snowflake schema diagrams as per the business and project goal. • Create source to target mapping to extract data from legacy systems & implement business logic. • Design & developed ETL solutions, BI reports, dashboard and perform data analysis. • Experience with data pipeline technical architectures, ETL/ELT, and reporting/analytic tools. • Performing data & system analysis, data profiling & querying large data sets to analysis business technical requirements. • Experience in developing BI solutions using Informatica ETL and Power BI technology. • Extract data from legacy systems, build data pipeline and upload to the Azure Data warehouse. • Experience in Microsoft Azure Data Factory, Data Lake, Azure SQL Database & HDInsight. • Maintaining data repository with data definitions, relationships, cardinality and sources. • Communication between business and technical team to prioritize business needs. • Data Analyst with strong experience in data validation, prepare UAT, developing test scenarios. • ETL Data Loading, SQL Performance tuning and DWH-BI implementation best practices. • Evaluate & improve existing BI systems data pipeline, developed Power BI data model Participate in design and code review to ensure quality and error free code. • Developing visual reports, dashboards and KPI scorecards using Power BI desktop. • Mentor ETL team & review developed code as well as suggested best ETL practices. • Experience of Agile Spring life cycle (user stories, planning, execution, release & retrospection). • Working experience in Agile & waterfall model, used JIRA for agile projects.