Summary
• 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.