Prinu Pappachan

Client:

MoneyGram International

• Analyzed scope and feasibility of business intelligence reporting needs.
• Defined vision and strategic roadmap for data products to enhance business intelligence.
• Collaborated with global functional owners to translate business requirements into data science solutions.
• Designed and trained models with data scientists to meet project specifications.
• Worked with solution architects to select platforms for solution deployment.
• Created and deployed reports using Looker, Power BI, Tableau, and Cognos Analytics.
• Executed quality analysis on reports and data for accuracy and reliability.
• Built interactive dashboards for Finance and Compliance teams, enhancing data accessibility.

Clients:

-University of California, Los Angeles

-University of California, San Diego

-Common wealth of Pennsylvania

• Participated in daily discussions for implementing PeopleSoft across campus.
• Established standard operating procedures for BI processes from requirements to final product delivery.
• Facilitated storyboarding sessions with end users to scope requirements and recommend modules.
• Conducted code reviews with associates, setting standards for legacy system delivery.
• Designed webpages using JavaScript, HTML, and CSS to align with legacy formatting.
• Developed OLTP reports for daily operations utilizing IBM Cognos.
• Collaborated with architects on data model development and design standards.
• Built Netezza as a reporting source to enhance performance.

Client:

-State Street, MA

• Developed FM models for report studio developers to enhance reporting capabilities.
• Created and published CPF (Project files) from FM models for streamlined project management.
• Designed query subjects, items, filters, and namespaces to support data retrieval needs.
• Utilized Rev Pro for accurate data forecasting and analysis.
• Constructed active reports to enable offline analytics functionality for users.
• Handled complex queries as separate query subjects to improve performance.
• Generated diverse reports including list, cross-tab, chart, and drill-down reports in Cognos 10.2.
• Configured and installed Cognos environment for optimal performance and usability.

Client:

-State Street, MA

• Migrated and verified reports from Cognos 8.4 to Cognos 10.1, ensuring accuracy in transition.
• Executed installation and configuration of Cognos 10.1 to enhance system capabilities.
• Developed financial dashboards using Tableau and trained end users on functionalities.
• Verified successful migration of Cognos 8.4 reports through Life-Cycle Manager.
• Designed Logical Cognos Framework Model to improve data organization.
• Created advanced dashboards for power users utilizing Business Insight in Cognos 10.1.
• Planned software configuration and version control strategies, establishing best practices.
• Collaborated in end-user sessions to optimize interaction with Cognos layer.

• Daily review for efficient inventory process.
• Data mining and data profiling to spot check trends for effective business decisions.
• Used Microsoft excels and other advanced tool to consume the data fetched from the OLTP database.
• Assisted business to frame marketing strategy by providing Analytical data sliced against various attributes.
• Identified Key performance indicator against different corridor of data.
• Used Visio to build conceptual data model.
• Worked on conceptual modeling of data base for effective flow of business.
• Identify, follow up implementation of Corrective and Preventive Action.
• Practiced various micro & macro level Strategies to boost up sales.
• Identified loopholes preventing sales and implemented corrective Actions.
• Analyzing store inventory data using Microsoft excel suite various tools to determine sale performance.
• Forecast sale based on analysis and create purchase order.
• Using Pivot table to create dash boards to determine Key performance indicators (KPI’s).
• Environment: MS excel (Advanced function – VLOOKUP up etc.), Visio