Agam Sinha

• Technical Competencies: Responsible to manage all the Power Platform requirements and projects.
• Starting from Requirement gathering, Stakeholder management, Data analysis, Dashboarding, Doing QC, Ensuring timely delivery.
• At TSC we serve global clients coming from different Industry background, hence have been exposed to different domains data.
• As per the client's environment I have also worked with Python and R integrated with Power BI, which we have used majorly for data manipulation and analysis.
• Managerial Competencies: Onboarded new employees with training and new hire documentation.
• Accomplished multiple tasks within established timeframes.
• Maximized performance by monitoring daily activities and mentoring team members.
• Resolved staff member conflicts, actively listening to concerns and finding appropriate middle ground.
• Developed and maintained relationships with customers and suppliers through account development.
• Communicated clearly with employees, suppliers and stakeholders to keep everyone on same page and working toward established business goals.
• Planned and budgeted accurately to provide business with resources needed to operate smoothly.
• Developed and implemented business strategies to achieve business goals and stay competitive.

Project: Landing Page (Nokia Internal Project)

May 20 – June 20

Description: This was an internal requirement. Of a same client we have several reports, which was access by different people at client side. So, this was internal requirement generated, so we thought of having different report App links accessible to different people at client side.

Data here was fetched from a excel, kept in a SharePoint site. Which has to be manually updated with the number of increasing projects.

Responsibilities:

● Initial requirement documentation.

● Implementing RLS.

● Testing RLS functionality with dummy data.

● Used bookmarks as per the requirements.

● Performing UAT with management people for best experience.

● UI enhancement as demanded at different stage of development.

● Given live demo of the report.

● Final deliverables as per the given ETA.

● On demand maintaining the report and data.

Environment: Excel, Dashboard, RLS, Bookmarks, UAT, Power Bi desktop and service.

2. Project: Power App Project

Description: As per the use of the Power App, client wanted to automate the data feed manual process in the excel files on SharePoint.

We converted the same excel file into a SPOL and used as a source for Power App.

User needed a form for feeding the data and also, he wanted to look at the live data being generated on the second screen.

Responsibilities:

● Initial requirement documentation.

● Created initial draft to demo.

● Testing functionality with dummy data.

● Created different design of forms to demo.

● Performing UAT with different people at client side.

● UI enhancement as demanded at different stage of development.

● Given live demo of the App.

● Final deliverables as per the given ETA.

● Similarly automated several other SharePoint files for data feed.

Environment: Excel, Dashboard, RLS, Bookmarks, UAT, Power Bi desktop and service.

Project: On ITSM data

Description: This client wanted to get the insights from there ITSM data. They wanted to see the number of tickets totally generated on monthly wise and yearly wise.

Similarly, they wanted to visualize top 10 issue generated region wise and different priorities of tickets generated.

Where P1 is the most critical one which should show up red and has to be sorted in a shorter ETA.

Data source: SQL server. Data coming from multiple servers.

Responsibilities:

● Using of Excel for initial data analysis.

● Since data was huge, used data parameter for loading less data for development.

● Having multiple initial sessions for requirement understanding and data understanding.

● Created a similar dummy data for initial draft of the report.

● Everyday progress development review.

● Using DAX for creating Measures and Calculated columns.

● Communicating with the different team for different issues at different level of development.

● Setting up On Premises gateway.

● Publishing report and scheduling refresh.

● Setting up incremental refresh.

● Even troubleshooting refresh issues.

Environment: MS SQL Server, Excel, Large Dataset, DAX, Power Bi Desktop and Service.

Project: ML Product based data.

Description: Client have a ML product for sales, of which they wanted to get the insights of the data they had in different dimensions. They wanted to look at the data region wise, revenue wise, customer wise etc.

Data Source: PostgreSQL. And the data was huge. Challenge faced was while understanding the data and data transformation.

Responsibilities:

● Understand the data and client requirement completely.

● Make sure to reports are delivered as per the ETA.

● Involved in end to end delivery of the project

● Data transformation and overall dashboard development.

● Using DAX for creating Measures and Calculated columns.

● Created the same report using PostgreSQL dataset and dataflow as well for different use of the customer.

● Doing UI testing and enhancement.

● Doing a sanity check before final delivery.

● Cross functional team communication for data warehouse changes.

● Getting engaged with client and updating to progress daily.

● Publishing the report in service and set up the Schedule Refresh.

● Final delivery of the project.

● Maintaining and updating the report as requested after final delivery.

Environment: PostgreSQL, Dashboard, Dataflow, UI testing, Schedule Refresh, DAX, Power BI.

• Did Reporting and data analysis on Excel for multiple teams.
• Use to brainstorm with Leads to discover and manager the current team's KPIs.