Mohammed Mir

Responsibilities:

• Created data models and performed analytics for various CPG clients such as Walmart, Costco and PepsiCo.
• Conducted one-on-one sessions with business users to gather business needs and requirements to translate into conceptual designs.
• Turned data into actionable insights, providing C-suite stakeholders with insightful recommendations to streamline business operations and improve customer experience.
• Analyzed database requirements in detail with the project stakeholders by conducting Joint Requirements Development sessions.
• Generated statistical reports and visualizations, providing key insights for more than 20 marketing campaigns and initiatives, including A/B testing, customer retention, brand awareness, and global expansion.
• Created dimensional model for the reporting system by identifying required dimensions and facts using Analytics tools.
• Worked with Database Administrators, Business Analysts and Content Developers to conduct design reviews and validate the developed models
• Identified, formulated and documented detailed business rules and Use Cases based on requirements analysis.
• Used Informatica Designer, Workflow Manager and Repository Manager to create source and target definition, design mappings, create repositories and establish users, groups and their privileges.
• Solved challenging data integration problems, utilizing optimal extraction transformation load patterns to reach resolutions.
• Built analytics tools utilizing data pipelines to provide actionable insights into customer acquisition, operational details and other key business performance metrics.
• Worked with relational database query authoring (SQL) and other ranging database types.
• Used business objects and intelligence to extract data from software-based solutions and information warehouses.

• The objective of this project is to develop a data warehouse to fulfill reporting needs and develop new marketing strategies
• The data comes from source systems such as life applications to feed the business intelligence system
• Apart from this there was data coming from flat files and other databases too
• Tracking insurance policies and investments in marketing tables to drive better decision making by integrating relevant data into the Data Warehouse is the requirement to be designed and implemented
• Responsibilities:
• Worked on multiple projects with different business units including Insurance actuaries
• Gather the various reporting requirement from the business analysts
• Gather all the Sales analysis report prototypes from the business analysts belonging to different Business units; Participated in JAD sessions involving the discussion of various reporting needs
• Reverse engineered the reports and identified the Data Elements (in the source systems), Dimensions, Facts and Measures required for new enhancements of reports
• Conduct Design discussions and meetings to come out with the appropriate Data Mart at the lowest level of grain for each of the Dimensions involved
• Designed a STAR schema for the detailed data marts and Plan data marts involving confirmed dimensions
• Created and maintained the Data Model repository as per company standards
• Conduct Design reviews with the business analysts and content developers to create a proof of concept for the reports

Responsibilities:

• Troubleshot and resolved problems with programs and systems.
• Executed testing strategies to improve systems, databases and processing techniques.
• Provided analysis support for defects and/or incoming incidents or user requests
• Responsible for evaluating and understanding Business Requirements
• Provided application support during the build and test phases of the SDLC for their product
• Responsible for reporting status regarding assignments to the System Analyst Lead for their product
• Provided Subject Matter Expertise to System Analyst Leads, Developers and Testers
• Provided feedback to the System Analyst Lead on potential future improvements for the product
• Participated in defect resolution and coordination
• Provided investigation and root cause analysis support for operational issues
• Served as one of the authors for Integration Test Specification
• Handled Code reviews of the component to reduce the bug density of the component
• Carried out the development of configuration utilities like HP (Hanging Protocol) editor