Raman Chauhan

Developed and adjusted ETL job logic for new and legacy systems according to user specifications.

Developed data models that enabled effective business intelligence and reporting capabilities.

· Designing and developing framework models as per the requirements.

· Maintenance and optimization of legacy framework models and transformer Models.

· Conceptualizing, designing, developing and deploying reports as per user requirements.

· Developments of different types of reports which include: - LIST Reports, CROSS Tabs, Drill through Reports, Query Studio reports, Analysis studio reports, burst reports. etc.

· Fixed bugs and optimized COGNOS reports/dashboards to improve performance and user experience.

· Efficient enough to debug reports by writing SQL queries if any data point issues.

· Developed models with two different data sources in a single model.

· Modification and creation of the existing Event studio triggers for scheduling multiple reports to multiple users.

· Resolved after-upgrade issues of Cognos reported by clients during report execution.

· Automated scheduling of reports and cubes using batch scripts to enhance efficiency.

· Administering unit-testing before launching it to actual users.

· Resolving tickets without breaching the SLAs

· Collaborated with stakeholders to gather requirements and define project scope.

· Mentored junior analysts in data analysis techniques and best practices.

· Collaborated with IT teams on new tools and technologies.

· Maintained updated knowledge base on industry trends and best practices.

• Developed comprehensive reports using advanced data visualization tools.
• Implemented best practices for report development including security, scalability, maintainability and usability standards.
• Collaborated with cross-functional teams to gather reporting requirements.
• Trained junior developers on best practices of creating efficient SQL queries for generating reports.
• Conducted training sessions for team members on report generation processes.

• Designed automated test scripts using Selenium for continuous integration.
• Performed functional, regression, integration and system tests on web-based applications.
• Collaborated with developers to identify and resolve software defects.
• Worked closely with development teams to ensure timely delivery of quality products within deadlines.
• Utilized defect tracking tools such as JIRA and Bugzilla to manage defects effectively.

· Collaborated with stakeholders to gather requirements and define project scope.

Designed and developed framework models based on project specifications.

Developed data models that supported business intelligence and reporting requirements, enabling informed decision-making.

· Conceptualizing, designing, developing and deploying reports as per user requirements.

· Developments of different types of reports which include: - LIST Reports, CROSS Tabs, Drill through Reports, Query Studio reports, Analysis studio reports, burst reports. etc.

· Fixed bugs and improved performance of COGNOS reports and dashboards, ensuring accurate data presentation for users.

· Maintained and optimized legacy framework and transformer models, enhancing system performance and reliability.

· Administering unit-testing before launching it to actual users.

· Efficient enough to debug reports by writing SQL queries if any data point issues.

· Developed models with two different data sources in a single model.

Designed and developed framework models based on project specifications.

· Collaborated with stakeholders to gather requirements and define project scope.

· Developed data models to support business intelligence and reporting needs.

· Conceptualizing, designing, developing and deploying reports as per user requirements.

· Developments of different types of reports which include: - LIST Reports, CROSS Tabs, Drill through Reports, Query Studio reports, Analysis studio reports, burst reports. etc.

· Administered unit testing to ensure quality before deployment to users.

· Maintenance and optimization of legacy framework models and transformer Models.

· Fixed bugs and enhanced performance of COGNOS reports and dashboards.

· Efficient enough to debug reports by writing SQL queries if any data point issues.

· Developed models with two different data sources in a single model.