Amit Chand
Senior Software Engineer
Pune
Summary
To work towards the company’s motto and be in an organization where I can use my Experience, Knowledge, and Skills to add value to the business as well as nurture talent in a highly competitive work environment and grow.
Overview
14
14
years of professional experience
Work History
Senior Software Engineer
Trinus Corporation
02.2023 - Current
- Understand the business requirements, data sources, and data structures to effectively model and load data into Power BI
- Collaborate closely with stakeholders and end-users to gather and refine requirements for reports and dashboards
- Act as a bridge between technical and non-technical stakeholders
- Ensure efficient data retrieval and performance optimization
- Dashboard Development, design the layout, selecting appropriate visualizations, and incorporate user interactivity to allow end-users to explore the data
- Data Visualization development, choose appropriate charts, graphs, and maps to represent data accurately and effectively communicate insights to end-users
- Develop and maintain complex data models, including establishing relationships, hierarchies, and calculated columns
- Manage data integration tasks, including data source connections and data transformation processes
- Perform complex data analysis tasks using DAX (Data Analysis Expressions) functions to create calculated measures and solve intricate business problems
- Develop advanced DAX calculations for Transcatheter Heart Value performance across studies
- Data Governance, understanding data access controls, data retention policies, and implement proper data anonymization techniques when necessary
- Collaborate with business stakeholders and other team members to understand their requirements and translate them into actionable solutions
- Provide support and troubleshooting assistance to end-users, addressing their questions, issues, and enhancement requests related to Power BI & Tableau dashboards and data visualizations
- Power BI & Tableau features, enhancements, and best practices
- Tools handled: Power BI, Power Apps, Power Automate, Tableau, Excel, MS SQL, Amazon Athena
Senior Reporting Analyst
Evolent Health Care
08.2018 - 02.2023
- Establishing connections to Data Sources in Power BI and Tableau
- Performing Data Modeling in Power Desktop and Tableau Desktop
- Requesting access for Interactors and Viewers
- Preparing reports per client requirements and providing insight for contact centers and health care claims
- Creating Views and Stored procedures to analyze the data from SQL into Power BI
- Experience in writing simple to complex SQL queries
- Developed Up-selling and Cross-selling reports using DAX functions in Power BI and LOD functions in Tableau
- Creating Row level security with power bi and integration with the power bi service portal
- Developed contact center and health care claims report and dashboard by LOBs and customers
- Worked on all types of transformations that are available in the Power bi query editor
- Scheduled Automatic refresh and scheduling refresh in power bi service
- Developed analysis reports and visualization using DAX functions like table function, aggregation, and iteration functions
- Created reports using time intelligence calculations and functions
- Worked on all kinds of reports such as Yearly, Quarterly, Monthly, and Daily
- Executed dashboard setups and data manipulation using DAX
- Requirement gathering by coordinating with different teams and preparing reports & dashboards
- Analyzing user requirements and validating the available data to propose usable designs
- Interacting with multiple stakeholders to gather business needs & developed technical specs
- Conceptualizing and developing novel reports & Dashboards in Tableau, Power BI & Excel
- Publishing and sharing reports with business users online on Power BI platform
- Converting pre-existing Excel based reports to Power BI dashboards
- Accessing & transforming massive datasets through filtering, grouping, aggregation, & statistical calculation
- Connecting different data sources to extract uniform data & create views that deliver important insights
- Basic knowledge of Amazon Athena to create the reports
- Data Visualization & Business Intelligence
- Deploying rich graphical visualizations in dashboards to create effective views of data such as: Line Charts, Bar Charts, Pie Charts, Stacked Bar Chart, Table, Metrics etc
- In Tableau & Power BI Desktop
- Tools handled: Tableau, Power BI, Excel, MS SQL, MicroStrategy, Amazon Athena, Nice WFM tool
MIS Team Leader
Wipro
08.2016 - 08.2018
- Teamwork: Develop cross-site relationships to enhance leverage of ideas
- Willingness to work in shifts (attitude)
- Perform tasks of defined processes or procedures
- Proactively seek to identify and improve current core procedures
- Motivation (performance standards, achieving results and persistent)
- Seek to learn quickly and strive to continually improve service offered
- Escalate to the Seniors Management any potentially difficult situations which may impact the monthly reports
- Preparation of Client Servicing Reports for complex and sensitive clients
- Analyzing different datasets using BI tools like Tableau and Power BI
- Analyzing user requirements and validating the available data to create interactive reports in Tableau & Power BI
- Visualizing data using Tableau and Power BI
- Daily call with client to discuss the performance for previous day and setting up road map for future
- Grooming my team to manage the work and prioritize it as per the requirement
- Solving doubt of team members and guide them to grow in a right direction
- Tools: Tableau, Power BI, Excel, Genesis
Real Time Analyst
Infosys
05.2011 - 07.2016
- Manage the call volume, daily attendance and program break schedules
- Assist with creation if metrics and targets for services
- Work closely with the operations team to analyze and help improve their delivery processes
- Generate ideas for process and service improvement planning
- Produce daily, biweekly and monthly internal reports
- Use trends and reports to forecast requirements
- Assist with projects and other duties as requested or assigned
- Tools: CC Pulse, Excel
Education
EPGP - Business Analytics
LIBA University (Loyola Institute of Business Administration)
Bachelor of Commerce - Commerce
Indira College Of Commerce And Science
Pune 04.2001 -
Skills
- Fast Learner
- Adapt well to changes and pressures in workplace
- Good Communication Skills
- Work effectively with diverse groups of people
Timeline
Senior Software Engineer
Trinus Corporation
02.2023 - Current
Senior Reporting Analyst
Evolent Health Care
08.2018 - 02.2023
MIS Team Leader
Wipro
08.2016 - 08.2018
Real Time Analyst
Infosys
05.2011 - 07.2016
Bachelor of Commerce - Commerce
Indira College Of Commerce And Science
04.2001 -
EPGP - Business Analytics
LIBA University (Loyola Institute of Business Administration)
Similar Profiles
Celle RolonCelle Rolon
Email Security Engineer at Los Angeles County via Trinus CorporationEmail Security Engineer at Los Angeles County via Trinus Corporation
MAGIELYN M. DELA CRUZMAGIELYN M. DELA CRUZ
Stickering/Bundler at UNIVERSAL ROBINA CORPORATION /RED.DOT CORPORATION AGENCYStickering/Bundler at UNIVERSAL ROBINA CORPORATION /RED.DOT CORPORATION AGENCY
Lisa GallagherLisa Gallagher
Senior Director & Enterprise Transformation Exec at Oracle Corporation (acquired Cerner Corporation)Senior Director & Enterprise Transformation Exec at Oracle Corporation (acquired Cerner Corporation)