Jan 2024 – Jun 2024 · 5 mos · Racine, Wisconsin, United States · Remote

• Developed and deployed interactive Power BI dashboards and reports for various departments, leveraging DAX and M Query to create actionable insights and visualizations from complex datasets.
• Integrated data from Teradata and Azure SQL Databases into Power BI, using advanced ETL processes to streamline data flow and maintain data integrity.
• Managed data storage and processing in Azure Data Lake, optimizing big data workflows and ensuring seamless integration with Power BI for comprehensive reporting.
• Developed and maintained ETL pipelines using Data Stage and SSIS, automating data extraction, transformation, and loading processes to support business operations.
• Implemented multidimensional analysis with SSAS, creating complex cube structures and MDX queries to enable detailed, multidimensional data analysis.
• Created and managed SSRS reports to deliver detailed and formatted reports, supporting strategic decision-making processes.
• Created and optimized Power BI Paginated Reports to deliver highly formatted, printable reports tailored to specific business needs.
• Utilized Tableau for advanced data visualization and reporting, providing additional insights and complementing Power BI analytics.
• Integrated and analyzed data from SAP BW, ensuring accurate reporting and data consistency across different business systems.
• Developed custom applications with Power Apps, automating business processes and enhancing user interaction with data.
• Developed and deployed automated workflows using Power Automate, streamlining repetitive tasks and improving efficiency across business processes.
• Applied Safe Agile Framework principles to manage BI projects, ensuring iterative development and continuous improvement in delivering business intelligence solutions.
• Developed complex queries using MDX for multidimensional data analysis, enabling advanced reporting and analytics in SSAS environments.

Apr 2021 – Dec 2023 · 2 yrs 8 mos · Austin, Texas, United States · Remote

• Gather requirements, analyze the source data and do data discovery to create reports for multiple teams.
• Created reports using different sources like corporate data models, Azure databases, Azure Data Lake, On-premise databases, Share Point Lists, Rest API, Excel etc., and creating dashboards pointing to different reports.
• Create reports in Power BI desktop and publish reports to respective workspaces, apps and automated the process to show the latest data.
• Configured Power BI Gateways to schedule the Datasets.
• Working on Teradata database, IBM Data Stage ETL packages to Validate, Extract, Transform and Load data to Data warehouse databases.
• Created complex SSAS cubes with multiple fact measure groups and multiple dimensions’ hierarchies in SQL server.
• Participating in Daily stand up Agile/Scrum meetings to discuss regarding the enhancements to be made for the existing requirements.
• Created Power Automate flows to schedule the Power BI reports without any daily refresh limitation.
• Conduct training sessions with business users on Power BI reports and Dashboards.
• Worked on Converting Spot fire reports to Power BI Reports.
• Created different chart types and drill down reports (SSRS).
• Using Integration Runtime (IR), the Azure Data Factory was upgraded from version one to version two.
• Worked on Power BI Paginated reports which provide users the capability to export in multiple formats like Microsoft Excel, Microsoft Word, Microsoft PowerPoint, PDF, CSV, XML and MHTML.
• Created Power BI Data flows to reuse the transformation logic by multiple teams.
• Worked closely with Business users to understand the Business Requirement Documents (BRD) and transform them to technical requirements.
• Scheduled Automatic refresh and scheduling refresh in power bi service
• Performs user acceptance testing to ensure system integrity before release to production
• Used various sources to pull data into Power BI such as SQL Server, SAP BW, Oracle, SQL Azure etc.

Jan 2019 – Mar 2021 · 2 yrs 2 mos · Columbus, Ohio, United States

• Works closely with business users to define requirements, prioritize issues, and address production support issues.
• Gathered functional, business and technical requirements using individual and group meetings.
• Participated in project planning sessions with project managers and team members to analyze business requirements and outline the proposed solution.
• Coordinates and facilitates work sessions with Operations users and IT development to define projects scope and requirements and manage project expectations.
• Involved in defining report layout in SSRS.
• Acts as liaison between the users, GIS team and IT development teams to determine and deliver the most effective solution for development and implementation including preparing detailed business requirements documents.
• Created data mappings to transform the data according to business rules.
• Developed Pig scripts for formatting and file manipulation in Azure Blob Storage.
• Proficient in performing data analysis, querying data bases, and utilizing SQL query tools
• Worked on development of metrics for performance tracking.
• Developed datasets/data models for various departments like Mobile Health Project, Weather department, Dental Department etc., to develop Power BI reports.
• Involved in designing the SSIS package Template using various control flow tasks such as Execute SQL Task, Data Flow Task, Sequence Container etc.
• Used Execute Package Task to run Child Packages from Parent Package and managed the Package flow using ETL Framework.
• Developed dashboards and deployed reports to development, UAT and Production workspaces.
• Developed interactive visualizations for BIDW live stories according to requirements.
• Created multiple mashup reports for management using Weather, Mobile Health Events, Dental data using Power BI desktop, DAX and Microsoft SQL server.
• Import-Export Data from various data sources including Excel, Oracle, Sybase and files (structured, unstructured, xml) using SSIS.

Nov 2016 – Dec 2018 · 2 yrs 1 mo · Atlanta, Georgia, United States

• Analyze the requirements and create packages/projects according to business requirement.
• Draft and maintain business requirements and align them with functional and technical requirements.
• Create Business Requirement Documents and Mapping documents to map data from source to destination.
• Create required staging and target tables in Azure Data warehouse and move the data from source to ADW.
• Convert Oracle logic to T-SQL Stored Procedures for data migration.
• Move the data from data lake to Azure blob storage and blob to ADW using poly base and Azure Data Factory.
• Prepare technical documents for models, packages, reports and upload into SharePoint.
• Build tabular models using Azure Analysis Services based on business requirement and deploy the models to server.
• Implemented the Extract, Transform and Load (ETL) strategy and creating a project wide Custom ETL Framework to support the Data migration.
• Standardize/validated Postal Address from US and Canada by embedding Third Party tool Melissa Data Contact Verify in SSIS Packages.
• Developed Tableau and Microsoft Power BI Dashboards to showcase the result of data analysis from database.
• Analyze the source data and do the data discovery to automate the process in ADW.
• Strong understanding of Data Modeling in data warehouse environment such as star schema and snow flake schema.
• Involved in defining report layout in SSRS. Created complex stored procedures for reporting services and Analyzed reports.
• Utilized tabular model in analysis services to pull and generate reports directly from in-memory from back-end relational data sources.
• Worked with Azure Data Lake Analytics for data analysis.
• Experience in developing applications using power Apps
• Developed Power Apps Model and canvas drive Apps

May 2015 – Oct 2016 · 1 yr 5 mos · BNepal

• Gathered requirements from Business Users for the Data migration project from ETL/Data Migration perspective.
• Participated in project planning sessions with project managers and team members to analyze business requirements and outline the proposed solution.
• Performed tuning of databases by normalizing database, establishing necessary joins, creating useful clustered index and non-clustered indexes.
• Built data warehouses on SQL Server and Azure Database.
• Designed and Maintained SSIS Packages for Importing and Exporting Data Migration and Conversion from Legacy Systems to Destination ERP (Dynamics AX).
• Involved in Data Migration Strategy to migrate data from Source (Legacy) to Staging (Data Scrubbing layer) to Destination ERP (Dynamics AX).
• Created ETL Control Database and Implemented referential integrity among the SQL Server Tables to handle the ETL Framework.
• Used various Control Flow elements like Precedence Constraints and Sequence Containers.
• Used Project Deployment Model to Deploy Packages to various environments.
• Migrated data from Data Scrubbing layer Dynamics AX using Data Import Export Framework (DIXF) using DMF Templates which are part of AX.
• Established connections with the AS400, mainframe/DB2, and Oracle databases to retrieve data from them.
• Worked on various AX modules from data migration standpoint such as Accounts, Finance, and HR etc.
• Performed Data Quality Analysis using SQL Skills, Count Validation, Statistical Analysis and Data Quality Validation in Data Migration.
• Created SSRS reports for sorting, different parameterized reports which consist of report criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Used Shared Datasets and Shared Data sources in various reports which point to the same objects and pulled data from OLTP System