Varaprasad Ch

• Prepared report design documents from functional requirement specifications.
• Gathered and analyzed requirements while providing estimations for projects.
• Conducted data analysis to support management and client needs.
• Interacted with clients to understand requirements and develop tailored solutions.
• Analyzed source systems, created connection strings, and extracted data from various sources.
• Managed performance issues within dashboards to enhance user experience.
• Administered Tableau Server, publishing dashboards, creating users, and monitoring security.
• Developed ETL workflows in Informatica PowerCenter for efficient data loading across platforms.

• Handled data type differences, SQL syntax changes, and performance optimization issues.
• Developed analytics solutions tailored to specific client requirements.
• Recommended dashboards based on visualization features and delivered reports to business teams promptly.
• Designed and developed interactive dashboard reports using Tableau.
• Created custom SQL for reporting and worked with database views.
• Built end-to-end ETL pipelines in Informatica PowerCenter, integrating data from SQL Server, Oracle, and flat files into Snowflake via AWS S3 staging.
• Collaborated with business teams to deliver dashboards for sales, finance, and supply chain analytics, enhancing decision-making with real-time insights.
• Migrated on-prem ETL workflows to Informatica Cloud (IICS) for scalable transformations in Snowflake.

• Migrated 20 MicroStrategy reports from Teradata to Snowflake, resolving SQL syntax and data type issues.
• Designed and developed complex reports and dashboards in MicroStrategy to meet business needs.
• Built interactive dashboards using MicroStrategy Dossiers to enhance user engagement.
• Implemented dynamic reporting features such as drill downs, thresholds, filters, and prompts.
• Analyzed business data to extract actionable insights through MicroStrategy tools.
• Created and maintained MicroStrategy schema objects, including attributes, metrics, and hierarchies for efficient data organization.
• Developed ETL pipelines with Databricks for effective data ingestion, cleaning, and transformation.
• Conducted unit testing and debugging of reports to ensure accuracy and address data issues.

• Collaborated with stakeholders and Project Managers during mockup development phases.
• Developed dashboard automation, transitioning from PowerPoint slides to interactive dashboards.
• Interacted with DBA, Functional Analyst, Scrum Master, and Product Owner to clarify dashboard requirements.
• Managed QA/Call Center dashboard reports tracking customer experience and policy compliance.
• Troubleshot dashboard issues, implemented enhancements, and ensured timely data refreshes.
• Created complex calculations on dashboards using parameters, date functions, booleans, LODs, IF, and CASE statements.
• Utilized Agile tools like Jira to track tasks and adapt to changing business needs.
• Conducted knowledge transfer sessions for new team members regarding project methodologies.

• Executed requirement gathering and analysis for migration of reports from SAS to Cognos 11.1.0.
• Developed dashboard reports to consolidate multiple reports onto a single page.
• Created standard, list, and cross-tab reports using Report Studio and Query Studio.
• Conducted data analysis to support management and client requirements.
• Collaborated with clients to understand requirements and deliver tailored solutions.
• Analyzed datasets to derive accurate insights aligned with analysis objectives.
• Engaged extensively with end users for requirements gathering, analysis, and documentation.
• Managed AutoSys jobs for report generation within set deadlines.

Conducted requirement gathering and analysis to define project specifications.

• Prepared report design documents based on functional requirement documents.
• Facilitated knowledge transfer sessions from one vendor to another, preparing presentations for business approval.
• Collaborated with business analysts to develop comprehensive functional and technical requirements documentation.
• Utilized Framework Manager tool in Cognos to create models addressing business needs.
• Developed multi-page reports using master-detail relationships with integrated page breaks.
• Implemented cascading prompts and various prompt controls for enhanced report interactivity.
• Oversaw unit testing and scheduled weekly report distributions, ensuring quality deliverables.

Collaborated with business users to gather requirements and analyze existing systems and processes.

• Designed functional and technical requirement documentation based on gathered insights.
• Created and managed comprehensive project design documents for effective project execution.
• Developed reports and contributed to FM development activities.
• Validated report data across databases and prepared test documentation for quality assurance.
• Troubleshot errors during report development to ensure timely delivery.
• Conducted code reviews and fixed defects to maintain high standards.
• Facilitated daily meetings with clients to address technical issues and conduct reverse knowledge transfer.