Madhu Singh

10+ years of experience in BI tools like IBM Cognos (10.x, 11.x, 12) including Framework Manager, Report Studio, Query Studio, Analysis Studio and Power BI/Qlik Sense. Expertise in Cognos cube development and Report development. Over 7+ years of experience in designing and implementing Power BI solutions to drive actionable insights.

Over 5+ years of experience in Informatica with demonstrated results in delivering custom application migration and ETL development. Strong expertise in Power BI DAX, Power Query, and data storytelling. Strong problem solving and technical skills coupled with decision making for enabling effective solutions.

BI Lead/ Sr. Developer at Genpact Pvt Ltd (2025-07 – Present)

BI Lead/ Sr. Developer at IBM India Pvt Ltd (2014-10 – 2025-07)

CTS Pvt Ltd (2009-10 – 2014-09)

L & T Pvt Ltd (2005-05 – 2009-10)

Individual Contributor at Genpact Pvt Ltd (2025-07 – Present)

ING is a Dutch-based global financial institution, headquartered in Amsterdam, offering retail, wholesale, and digital banking services to over 100 countries. By utilizing Loan IQ, ING achieves data consolidation, which enhances reporting and allows for faster, more accurate management of syndicated loans.

• Worked as an SME in the project.
• Worked on user change or enhancement request.
• Designed complex report containing multiple prompts, calculation and layout using Power BI.
• Worked on Migration of report from Cognos 11 to 12
• Worked on improving the performance of report which was causing timeout issue.

Individual Contributor at IBM India Pvt Ltd (2024-01 – 2025-07)

Saudi Telecommunication Company provides ICT services of Saudi Arabia, across the Middle East and Europe. The group offers landline and fixed infrastructure, mobile and data services, and broadband & cloud computing services. Dashboards and reports were designed to monitor different Alarms/ Incident tickets occurred for different devices. Designed and developed complex reports like Cross Domain, Incident Management, Netcool/Watson Comparison, Unified Historic report, etc.

• Worked as an individual contributor on the Project.
• Analyzed the requirement and designed and developed report as requested by client.
• Designed complex report containing multiple prompts, calculation and layout.
• Designed and developed PLSQL code to read JSON column data from table.
• Designed and developed FM model by using PLSQL procedure as a query subject.
• Developed different Reports and Dashboards using JSON data source.
• Involved in Cognos Admin such as Installation & Configuration, Security Management
• Developed Power BI reports/Dashboard from Oracle source.
• Used DAX formula for different KPI used on the report.
• Implemented row level security for different domain user – Mobile Core, Mobile Access, IP Core, IPMPLS, Fixed Access etc

Senior Application Developer and Architect at IBM India Pvt Ltd (2022-09 – 2024-01)

AIA Group Limited, often known as AIA, is a Hong Kong-based multinational insurance and finance corporation. It is the largest publicly listed life insurance group in Asia-Pacific. Worked for different AIA Cognos / Power BI reporting projects - Case Track, Lifecode 2, BT Mercer, Vanguard, and Hesta Projects.

• Worked in different AIA projects as a Sr. developer.
• Analyzed the requirement and designed and developed report as per the changes requested by client.
• Developed Reports using SSRS.
• Migrated 56 Cognos report from On-prem environment to Power BI Azure environment.
• Involved in different Cognos server-side activities like – deployment, fixing server issues, data source creation, adding security filters, allowing access, Monitor server health and Cognos services. Start, stop, and restart Cognos services. Perform backup and recovery of Cognos content store.
• Helped in resolving different production Cognos report issue.
• Developed Power BI reports - Connecting Power BI to various data sources.
• Created interactive dashboards and reports. Using Power BI visuals (charts, tables, KPIs) effectively.
• Wrote DAX formulas for complex calculations. Identifying trends, patterns, and business insights.
• Implementing row-level security (RLS). Managing permissions and access levels.
• Publishing reports to Power BI Service. Sharing dashboards with teams. Automating data refresh schedules.

Senior Application Developer and Architect at IBM India Pvt Ltd (2021-02 – 2022-07)

Vodafone Idea or Vi is an Indian mobile network operator. It is an all-India integrated GSM operator offering 2G, 3G, 4G, LTE Advanced, VoLTE, and VoWiFi service. Different reports were designed to display 35 KPIs at State, Circle, District, tehsil, town and till cell site level using Map studio.

If User mouse hovers on circle, they can see the data, same value is shown in the list. User can check data for a single date or for a particular date range. They can also check for different types of calculations.

On Map reports, good value for a particular KPI is highlighted in green and lower values are highlighted in red.

• Analyzing the specifications provided by the clients and Developed Mockup report as per client requirements.
• Interacting with the End users on a regular basis to resolve issues pertaining to the reports.
• Created model and packages based upon client requirement.
• Created Dashboards and reports.
• Developed Map, List, cross tab, drill through and complex reports.
• Developed Reports using Conditional Formatting, Created Filters, Used Custom control, Cascading Prompts without page refresh and Calculations.
• Modifying the existing reports based upon the change request by the user.

Senior Application Developer at IBM India Pvt Ltd (2018-03 – 2019-03)

Idea cellular Ltd is operating in a highly competitive marketplace with multiple challenges affecting the telecom environment. Management Information Customer Service (MICS) takes data feeds from various source systems, which cater to different sub-functions of the Customer Service function of Idea.

• Built FM Models using Query Subjects, query items and name spaces from the imported metadata.
• Imported Views to the Framework manager model and set the cardinality between them as per the business requirements.
• Creating the Packages in FM Model as per business and publishing it to Cognos connection specified path.
• Developing the Power cubes in IBM Cognos Transformer using FM Package as a data source
• Providing Cube Level Security using User Groups
• Developing the Cognos Standard Reports using power cubes
• Developing reports on report studio using different objects like List, Cross tab, Chart, Value prompts, Cascading prompts.
• Preparing UAT Test Docket for UAT
• Involved in UAT's discussions with users and giving KT sessions to the users.
• Performed Deployment of Cubes and reports.
• Worked on BMC Remedy tool for handling user requests and for requesting RFC as the part of deployment.

Senior Application Developer and Architect at IBM India Pvt Ltd (2019-01 – 2020-01)

CXO Dashboards provides Senior Management with visibility on Business performance on Daily Business Operational KPIs for both Vodafone & Idea. The dashboards were made available on Tabs, mobile devices, on internet and intranet (web version). Business SPOC extracts the data for KPIs from the HPM system in required aggregate form and uploads them in RR Portal. ETL team picks the data and processes them for the dashboard presentation.

B.E. Computer Science