Home

Kaustubh Shah Chetan - Power apps developer

[email protected]

Location: Absecon, New Jersey, USA

Relocation: YES

Visa: H1B

SUMMARY Cumulative 8 years work experience projects right from requirement gathering, Design, Develop and Deployment using Power Platform (Power App, Power Automation. 3 + years of experience in Power Platform (Power Apps, Power Automate) Skilled at Power Apps Platform to design and implement customized Canvas and Model driven apps and to provide integration with Power Automate workflows. Drove model enhancements and elevated product performance by leveraging team input for comprehensive model upgrades and optimizations. Created Canvas APP to perform CRUD operations to different sources like Dataverse, SQL, and SharePoint Lists. Write DAX functions in Power BI reports for Calculations or Develop measures. Created Power Automate flows to perform workflow related activities. Familiarity with end-to-end activities for developing and publishing Power Apps and Power BI reports. Knowledge on Data modeling (Snowflake and Start schema) Implemented Row Level and Column Level security in Power Apps. Good knowledge on using interactive notebooks like Jupyter Notebooks. Used variety of data sources in Power BI like, Excel, SharePoint List, SharePoint Folder, JIRA API, SQL Server, Azure Synapse and etc. Proficient in Agile methodologies and collaborative team player with experience working cross-functionally with logistics, operations, packaging design, and sales operations teams to develop and implement solutions to address business problems Skilled at using PySpark, Python, and SQL to process, analyze, and transform large volumes of data from multiple sources, and utilizing Microsoft Azure and Databricks as cloud platforms for data storage, processing, and workflow orchestration Experience using different libraries like Pandas and NumPy in Python to work on datasets. Ability to work with managers and executives to understand the business objectives and deliver as per the business needs and a firm believer in team work. EDUCATION June 2015 Master of Science in Electrical Engineering Rutgers, the State University of New Jersey, USA May 2013 Bachelor of Engineering in Electronics and Telecommunications University of Mumbai, India SKILLS Stack Tools Power BI Desktop, Power BI Service, Power BI Gateway, Power BI Report Server, SQL server reporting services (SSRS), SQL Server Integration Services (SSIS), MS Projects Power Platform Tools Power Apps, Power BI, SharePoint, Power Query, Power Automate Databases SQL Server 2008/2012 Scripting Python CERTIFICATIONS Certified Python Programmer Python Institute Microsoft Azure AZ900 Structured Query Language (SQL) Coursera Google Project Management Coursera Certified Scrum Master Scrum Alliance PROFESSIONAL EXPERIENCE Santander Bank, NJ July 2023 - Current Power Platform Developer Technical Environment: Power Apps, Power Automate, Power BI Service, Microsoft Azure, Azure DevOps Active Directory, Jira, Dataverse, OneDrive Responsibilities: Developed a comprehensive ticketing system using Microsoft Power Apps to streamline the process of logging and managing customer complaints. Designed a data intake tool using for the data engineering team to assign priorities for tasks assigned across the business unit. Integrated Power Automate for automated notifications and workflow management, improving response times and customer satisfaction. Collaborated closely with stakeholders to gather requirements and ensure the system met business needs effectively. Designed and built project management tracking application using Microsoft Power Apps to monitor project progress, allocate tasks, and visualize project data. Integrated with SharePoint for collaboration and document management within project teams. Conducted user training sessions and provided ongoing support to ensure successful adoption of the application across project teams. Designed the user interface and application architecture for Power Apps solutions, ensuring usability, scalability, and maintainability. Ashley Furniture Industries, Tampa FL Oct 2022 Jun 2023 Power Platform Developer Technical Environment: SharePoint 2013, SQL Server, Power BI, Power Apps, Power Automate, Power BI Service, Microsoft Azure, Azure Data Lake Storage, Active Directory, Jira, Dataverse Responsibilities: Developed intricate Power Automate Flows, leveraging a spectrum of actions and expressions, to seamlessly aggregate data from diverse sources including Excel spreadsheets and Azure Data Lake Storage. Utilized Jira for tracking project progress and to provide insights into the developmental work. Orchestrated the creation and refinement of Canvas Apps, engineered to provide write-back functionality to Power BI Reports, thereby enhancing user engagement and data interaction. Implemented robust Row Level Security (RLS) protocols within Power BI reports and Canvas Apps, ensuring stringent data governance and confidentiality standards. Seamlessly integrated Power Apps into Power BI Reports, providing a cohesive data ecosystem and streamlining data visualization and analysis workflows. Executed Power Automate Cloud flows from within Canvas Apps, facilitating seamless automation of business processes and enhancing user productivity. Engineered Cloud flows to automate the scheduled refresh of Power BI datasets, ensuring data currency and availability for critical decision-making processes. Streamlined business processes through Flows, resolving delegation issues and implementing advanced data export functionality and date range filtering to enhance data analysis capabilities. Implemented dynamic dashboards, scorecards, and ad-hoc reports utilizing PerformancePoint Server on SharePoint Server and Power BI, seamlessly connecting disparate data sources such as SQL databases using DAX queries. Expanded responsibilities to encompass service level activities, providing guidance and mentorship to cross-functional teams. Executed performance tuning initiatives across multiple projects, optimizing system efficiency and enhancing overall solution performance. Contributed to the COE by evaluating emerging features and technologies, providing recommendations to project teams, driving innovation and efficiency across the organization. Daiichi Sankyo, NJ, USA Nov 2020 Sep 2022 BI Developer Technical Environment: Power Apps, Power Pages (Portal), Power Automate, Power BI Service, Dataverse and Azure Synapse Responsibilities: Developed customized data power apps to support Business Intelligence (BI) dashboards for various departments within the IT procurement organization. Implemented daily CRUD operations within Canvas apps utilizing Power Apps and Azure Data Factory workflows to ensure seamless data transformation and integration from on-prem storage. Created custom triggers on Power Automate to execute work flows based on pre-defined conditions and to provide monitoring support. Defined primary keys for fact and dimension tables to ensure normalization of tables and ease of extracting data. Conducted consultations with cross-functional teams daily, ensuring BI solutions aligned with specific reporting needs for data-driven insights. Deployed incremental solutions to UAT environment and provided write-back functionality to Power BI reports. Integrated Power Automate flows within custom Power Apps Canvas Apps. Developed both Model-driven and Canvas applications using Power Apps and utilized Dataverse tables as a database to manage and store data, accommodating large datasets and delegation warnings. Facilitated communication between technical and non-technical teams, translating business requirements into effective BI solutions. Participated in user acceptance testing (UAT), refining apps for BI dashboards based on user feedback and ensuring alignment with reporting needs. Provided support for the existing Power Apps applications Implement security measures to ensure data privacy and compliance during data movement and storage. Citizens Bank, NJ, USA Jan 2019 Oct 2020 BI Developer Technical Environment: Visio, Power Apps, Power BI, SharePoint, Power Query, Power Automate Responsibilities: Involved in requirements gathering, analysis of requirements, design discussions, to document the Entity-Relationship (ER) models in Visio, enhancing the mapping document, connectors to implement the business requirements. Involved in PoC for Azure Data Factory and Power Automate to implement execution work flows. As part of sprint process, took responsibility for the development and execution of Canvas/ Model Driven Apps to update data for productivity. Co-ordinate with various business users, stakeholders and SME to get Functional expertise, design and business test scenarios review, UAT participation and validation of financial data. Deployed the customized Power Apps forms in higher environments like QA, UAT and Production. As a part of functionality collect data in JSON format and stored in SharePoint list column. Participated in migration of SharePoint 2013 on premises to SharePoint online. Tyco Electronics SubCom, Eatontown NJ Feb 2016 Nov 2018 System Designer Technical Environment: Python, PySpark, SQL, Pandas, GitHub, Crontab, MS SQL, Hadoop, MapReduce, SSIS Responsibilities: Led multiple Ultra Long Haul and Short Haul fiber optic network design, manufacture, and implementation projects worth $5M to $300M, ensuring adherence to technical specs and quality parameters. Configured Line Monitoring Equipment baselines to measure fiber network loss of signal and performed baseline checks using in-house simulation tools. Calculated fiber health using SQL queries and proprietary algorithms, measuring GOSNR, Optical Fiber Loss, and In-Service Attenuation to provide input for downstream teams. Optimized Optical Add Drop Multiplexing (OADM) design and defined network powering configurations in conjunction with SME s. Imported existing modules and performed data cleaning, transforming, validation, and quality checks using Python automation scripts in local Jupyter notebooks. Extracted data from on-prem RDBMS which include MS SQL Server as a central data repository using SSIS. Used Hadoop MapReduce to perform batch processing of incoming monitoring data on a daily basis. Designed and developed complex integrated product solutions for customer requirements, reviewed system design needs and testing requirements, identified new product development and costs. Produced high-quality technical documentation and maintained the compliance matrix for proposed project solutions and supported project management during critical implementation phase to ensure conformance to set technical specifications. Bloomberg LP, Dayton NJ Jun 2015 Feb 2016 Software Engineer Technical Environment: Python, SQL, JavaScript The Bloomberg Data Center is constantly upgraded to support new-generation server bays and stacks to support its increasing consumer demand and to support a continuous availability. Responsibilities Developed and executed Python and Java scripts for regular server maintenance and status reporting to the engineering team. Provided downstream data analytics and logs on server failures, network failures, and hardware failures and overall functioning of the system. Supported the R&D Data Center Team to ensure optimum functioning of server bays and timely maintenance of server hardware equipment. Commissioned new server bays and equipment within the data center to support the expanding capacity requirement of the Bloomberg platform. Performed validations for new server bays based on internal guidelines and OEM specifications. Keywords: quality analyst business intelligence active directory rlang information technology microsoft Colorado Florida New Jersey