Shujauddin Saifi Email and Phone Number

Joined Genpact India Pvt Ltd in 2024 as a Manager, Supporting Consumer Product Goods team (OTCDeduction Management) for their analytical decision and responsible for Developing visual reports, dashboards & KPI scorecards, project-based dashboards using Power BI desktop & PBI Services.Supporting a Consumer Product Goods team (OTC-Deduction Management) for their all the analytical decision ➢ Provide guidance and support to all the team members for their respective PBI Reports… Show more Joined Genpact India Pvt Ltd in 2024 as a Manager, Supporting Consumer Product Goods team (OTCDeduction Management) for their analytical decision and responsible for Developing visual reports, dashboards & KPI scorecards, project-based dashboards using Power BI desktop & PBI Services.Supporting a Consumer Product Goods team (OTC-Deduction Management) for their all the analytical decision ➢ Provide guidance and support to all the team members for their respective PBI Reports development & maintenance work. ➢ Connecting to different data sources like Share Point, OData feed, SQL server, MS Excel etc. to create dashboards. ➢ Able to implement row level security on data and understand application security layer models in Power BI ➢ Proficient in making DAX queries in Power BI Desktop ➢ Responsible for developing, publishing & scheduling Power BI reports as per business requirements. ➢ Knowledge & Experience in prototyping, designing & requirement analysis. ➢ Responsible for Publishing the reports to app.powerbi.com and setting up the necessary connection Details and scheduling. ➢ Provided reporting, analysis and insights about collection/dispute drivers and key revenue performance metrics to support corporate analytics using Power BI like Write Offs, past due and some time for Wealth Management Data as well ➢ Collaborated with clients and company officials to identify data analysis needs, develop, and implement data collection procedures and create meaningful data visualizations illuminating key performance indicators. ➢ Developing & enhancing existing Power BI and Excel dashboards and Reports for both Internal and External Stockholders Show less

Joined Incedo Inc in 2019 as Team Lead with Platinum Reporting, later joined Operations Intelligence Team. Gained expertise in the fields of Data extractions and manipulations, Analytics, Reporting & Automation.➢ Responsible for Hourly, Daily, Weekly & Monthly Reporting for the Management for different prospective to understand the business health ➢ Collaborated with clients and company officials to identify data analysis needs, develop and implement data collection procedures… Show more Joined Incedo Inc in 2019 as Team Lead with Platinum Reporting, later joined Operations Intelligence Team. Gained expertise in the fields of Data extractions and manipulations, Analytics, Reporting & Automation.➢ Responsible for Hourly, Daily, Weekly & Monthly Reporting for the Management for different prospective to understand the business health ➢ Collaborated with clients and company officials to identify data analysis needs, develop and implement data collection procedures and create meaningful data visualizations illuminating key performance indicators. ➢ Developing & enhancing existing Power BI and Excel dashboards and Reports for both Wealth Managers and Internal Stockholders. ➢ Maintained existing SQL code base and develop new code, stored procedures etc. ➢ Created prompts, calculated fields, groups, bins, sets, hierarchies, conditions, filters (local, global) and parameters for various analytical reports and dashboards in Power BI Desktop. ➢ Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data. ➢ Developed Power BI Desktop data visualizations using Waterfall charts, Scatter Plots, Geographic Map, Pie Charts, Bar Charts, Control & Funnel Charts, forecasting & forecast precision. Show less

Joined NIIT Technology in 2016 as Team Lead with Employee Benefit Reporting Team, used to create Performance Reports of strategies along with Analysis.➢ Generate Daily/Monthly/Quarterly and Yearly reports by using Advance Excel functions for Portfolio Advisor under Performance Reporting. ➢ Maintaining team tracker for manager reporting and co-ordinate with associate and manager on daily basis. ➢ Prepare presentation in PowerPoint & Dashboard as per the requirement of management.… Show more Joined NIIT Technology in 2016 as Team Lead with Employee Benefit Reporting Team, used to create Performance Reports of strategies along with Analysis.➢ Generate Daily/Monthly/Quarterly and Yearly reports by using Advance Excel functions for Portfolio Advisor under Performance Reporting. ➢ Maintaining team tracker for manager reporting and co-ordinate with associate and manager on daily basis. ➢ Prepare presentation in PowerPoint & Dashboard as per the requirement of management. ➢ Maintain statistics and data for completed Projects for future use. ➢ Designed/developed customized applications and made automated reports to reduce manual work using Advanced Excel ➢ Automating data refresh processes for reports in Power Query to streamline the business. ➢ Gathered the business requirements, imported the data and created the worksheets and visualizations using Excel and Power Point Show less

Joined Bank of America as an Analyst in 2008, responsible for produced monthly reports using Advanced Excel, Creating Performance Reports of Strategy, Reconciliation for finance department with multiple responsibilities.➢ Produced monthly reports using advanced Excel spreadsheet functions related to Trade Operation Money Movement, Strategy Performance, Investment Reconciliation for Banking Clients. ➢ Coordinated data analysis, design and information sharing via Excel Responsible… Show more Joined Bank of America as an Analyst in 2008, responsible for produced monthly reports using Advanced Excel, Creating Performance Reports of Strategy, Reconciliation for finance department with multiple responsibilities.➢ Produced monthly reports using advanced Excel spreadsheet functions related to Trade Operation Money Movement, Strategy Performance, Investment Reconciliation for Banking Clients. ➢ Coordinated data analysis, design and information sharing via Excel Responsible for Data cleansing & Data manipulation ➢ Creating process automation on Excel to streamline the process ➢ Responsible for creating & updating PPT Decks for the Top higher management. ➢ Creating Bill Payment Reconciliation reports for Onshore client with the help of T3K. Show less