Highly qualified Business Intelligence developer focused on translating complex mandates into actionable plans and working systems. Specializing in Data Warehouse, Power BI Reporting Service, SQL Server and BI Developer with SQL query SSMS and data modeling. Ready to bring more than 6+ years of related experience to a challenging new role. And highly motivated and competent team leader and team player with strong vision to achieve successful outcomes for clients and colleagues
Data Analyst/power BI Developer
August 2020 - Present
Refinement and automation of existing metric calculations to ensure timeliness and error free product.
Learn, publish, analyze and improve management information dashboards, operational business metrics decks and key performance indicators.Support Fulfillment Center-wide system integration efforts to move into standard data platforms.Design, setup, execute and administer web-serving solutions.
Power BI Developer
March 2020 - Present
• Create tools to store data (OLAP Cubes).
• Build entire ETL system using SSIS (using various transformations like Data conversion, File system task, Row counts, OLE DB Command, Merge Join, Look up, Sort, Data flow task)
• Design, build and deploy BI Solutions (Using reporting tools such as SSRS and Power BI).
• Translate business needs into technical specification.
• Develop, and execute database queries and conduct analysis.
• Create visualizations and reports for requested projects.
• Develop concepts and practices of physical and Logical data model design (star and snowflakes) including multidimensional and relational reporting and analysis techniques.
• Share project documents using SharePoint.
• Identify key performance indicators (KPIs) with clear objectives and consistently monitor those.
• Created incremental loads while transferring data from OLTP to data warehouse using different data flow and control flow tasks in SSIS.
Data Engineer/ ETL Developer
September 2017 - August 2021
Develop, review technical design of and enhance data management solutions
Designing, implementing, and supporting scalable systems to support the rapidly growing and dynamic business demand for data
Defining best practice for development and system administration
Experience with BI tools, ETL, visualization Power BI
Experience with OLAP
Experience with SDLC (Software Development Life Cycle)