Niraj Shakya Email & Phone Number

Columbia, Sc, Us

• Developed interactive and visually compelling Power BI reports to present key insights and performance metrics.• Leveraged Teradata for data extraction and manipulation, ensuring accuracy and efficiency in reporting processes. • Created SSIS packages development, Unit testing and deployment in Dev and QA Environment.• Primarily involved in Data Migration using SQL, SQL Azure, Azure storage, and Azure Data Factory, SSIS, PowerShell• Help develop evaluation findings results and assist development of recommended solution architecture• Used advanced features of T-SQL in order to design and tune T-SQL to interface in Azure cloud and other applications in most efficient manner• Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing.• Utilized SSIS for data integration tasks, ensuring seamless data flow from various sources into Power BI.• Designed and implemented multidimensional models using Analysis Services to support complex reporting requirements.• Collaborated with cross-functional teams to understand business needs and translate them into actionable reporting solutions.• Conducted performance tuning and optimization of Power BI reports to enhance user experience and query performance.• Provided training and support to end-users for effectively utilizing Power BI reports for decision-making purposes. • Developed a comprehensive sales dashboard in Power BI, integrating data from Teradata and SSIS, resulting in a 20% improvement in sales forecasting accuracy.• Implemented a real-time inventory tracking system using Power BI, enabling stakeholders to monitor inventory levels and trends effectively.• Designed a customer segmentation analysis tool using Analysis Services, providing actionable insights for targeted marketing campaigns.

Houston, Texas, United States

• Excellent knowledge of all the phases of Software Development Life Cycle (SDLC).• Build GSHS Reports in Power BI from scratch.• Experienced in Agile Methodologies like attending daily Scrums, maintaining User Stories and Burn down Charts, Backlog Grooming and Retrospective.• Created dashboard for school system financial information which includes revenue and expenditure by district.• Worked on dimensional modelling and maintained dimensions like Product, Customer, and Region as a part of Snowflake schema and loaded the data in the member fact tables.• Written some Java script plugin that makes the polygons work like hyperlinks.• Specialized in transforming data into user-friendly visualization to give business users a complete view of their business using Power BI.• Extracted data from Oracle, SQL Server, Flat Files, Excel and XML using SSIS and cleanse the data.• Published reports and visualizations to Power BI Services and thereby created dashboards.• Designed, developed, and tested the ETL strategy to populate data from multiple source systems• Used various sources to pull data into Power BI such as SQL Server, oracle.• Involved in installation of Power BI Report Server.• Developed reports to visually explore data and create an interactive report Excel and Power BI.• Using a query editor in Power BI performed certain operations like fetching data from different file.• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS 2008.• Worked on formatting SSRS reports using the Global variables and expressions.• Created Parameterized reports, Drill down and Drill through reports using SSRS.• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard.

Florida, United States

Nepal