We are looking for a Senior SAP Crystal Reports Consultant to lead the technical discovery of a large legacy Crystal Reports estate for a leading US-based bank. The candidate will own the technical side of the assessment: automating the extraction of report metadata, reverse-engineering report logic and data sources, rating report complexity, and recommending how each report should be handled in the future-state ecosystem built on Snowflake, Power BI, Alteryx, and Power Automate. The role also includes guiding a junior SAP Crystal Developer and working closely with the Business Analyst and Project Manager.
Key Responsibilities
Lead the automated, metadata-level inventory of all scheduled and ad hoc reports, using repository queries, audit data, scheduler logs, and scripting rather than manual review. Full inventory cataloguing and complexity scoring of the legacy report portfolios. Extract and catalogue report attributes such as report name, folder, owner, schedule, format, destination, data sources, connections, last-run date, run frequency, and failure history. Analyze report definitions to document SQL commands, tables and views, stored procedures, parameters, formulas, subreports, grouping, and business logic. Reverse-engineer undocumented or complex report logic and explain it in plain language to the Business Analyst and business stakeholders. Define and apply a complexity rating model (data sources, subreports, formulas, parameters, volume, distribution) for the prioritized report set. Identify duplicate, near-duplicate, unused, and failing reports,
and reports that share the same underlying queries or data sources. Provide technical input to future-state classification: Retire, Automate, Dashboard, Data Product, or AI Interrogation. Map legacy data sources to the future-state Snowflake data platform and highlight data gaps, dependencies, and source-system risks. Recommend the target tool and pattern for each prioritized report (Power BI dashboard, paginated report, Alteryx workflow, Power Automate flow, or governed data product). Provide effort estimates, dependencies, and sequencing inputs for the migration plan, RACI, governance framework authoring. Edit, fix, or create Crystal Reports where required to support the assessment or keep critical reports running. Guide and review the work of the Junior SAP Crystal Developer, and set standards for metadata capture and documentation. Maintain technical documentation, data lineage notes, and assessment artefacts on the client’s shared repository. Required Qualifications 10+ years of hands-on experience SAP Crystal Reports design, development, administration and consulting (2013, 2016, 2020 or later). Strong experience with SAP BusinessObjects BI Platform / Crystal Server, including CMC, scheduling, publications, instances, and distribution.
Experience extracting report metadata at scale using CMS Query Builder, the Auditing database, BI Platform SDK or RESTful web services, or similar techniques. Advanced SQL skills across one or more of SQL Server, Oracle, DB2, or Teradata, including complex joins, stored procedures, and performance analysis. Ability to read and reverse-engineer complex Crystal formulas, subreports, parameters, and command objects. Scripting experience in Python or PowerShell to automate metadata extraction and analysis. Experience with report rationalization, migration, or upgrade projects. Robust analytical, documentation, and communication skills, with the ability to explain technical findings to business users. Preferred Qualifications Experience migrating Crystal Reports to Power BI (including paginated reports), SSRS, or other modern BI tools. Hands-on exposure to Snowflake, Alteryx, or Power Automate. Understanding of data warehousing, dimensional modeling, and data product concepts. Experience in banking, financial services, or other regulated business environments. Familiarity with Azure DevOps, Jira, Confluence, and Agile delivery. SAP BusinessObjects, Power BI (PL-300), or SnowPro certifications are an advantage. Anaptyss is an Equal Opportunity Employer. All qualified applicants will receive consideration without regard to any legally protected characteristic, including disability and protected veteran status. For recruitment accommodations, contact your recruiter or
[email protected].
📌 Senior SAP Crystal Report Consultant (Noida)
🏢 Anaptyss
📍 Noida