Sourabh Lakhore

LTIMindtree (Payroll : E-labs Infotech Private Limited)

Client : Microsoft

• Managed Power BI report : created and optimized reports with a focus performance relevance.
• Technical assistance and issue resolution : provided technical support to client, trouble-shooting power bi issue related to Data Connectivity,report rendering and workspace settling.
• Data Transformation & Modeling : Utilized Power Query ad DAX to clean, shaped Model data ensuring high data quality and logical relationship.
• Scheduled Data refreshes : Configured automated schedules and ensured smooth refresh operations for both import and direct query data sets.
• Data source integration: Connected Power BI to multiple data source,including cloud, warehouse , API's, share Point and SQL data bases.
• Client collaboration and support : worked closely with clients to understand requirements, provided, Ongoing support and resolve Technical issues.
• Familiar with using Fabric for data integration and management in Power BI.
• Able to use Fabric for transforming and visualizing data in Power BI reports and dashboards.

• Created Financial Testing report analysis and dashboards to give meaningful insights about business.
• Collaborated with stakeholders to gather business requirements and translated them into actionable data visualizations and Implemented data refresh schedules.
• Creating training materials and delivering training sessions to users.
• Created reports to show company investment in each category.
• Connect to different types of Data Sources, import data and Transform (cleaning, organizing and processing) data for BI.
• Created reports to show company investment in each category.
• Worked on DAX expressions like Aggregate, Calculate and Mathematical Functions to Create New Calculated Columns and Measures.
• Created various visuals to show business insight like bar chart, Card, KPI, Matrix, Pie chart, Donut Chart.
  

• Experience in end-to-end reconciliation process pertaining to Position and recon.
• Knowledge in matching the breaks and routing it to the responsible teams.
• Hands on experience in reconciling the breaks like corporate actions, failed trades, Pay down–Pay up securities(MBS), Trade processing.
• Proactive in escalation of aged breaks and high value trades.
• Preparing share aging, full recon review, Hyper Care and Manual Factors for every cycles.
• Trade settlements : settling the trades which is in open stratus for USD currency.
• Responsible for review of the work which has completed by the colleague.