Mohammed Mir

8+ years in Information Technology with Expertise in Data Analytics building data-intensive applications, overcoming complex architectural and scalability issues and Data modeling for Data Warehouse/Data Mart development, Data Analysis for Online Transaction Processing (OLTP) and Data Warehousing (OLAP)/Business Intelligence (BI) applications. Proficient in predictive modeling, data processing and Data mining algorithms. Exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation, production support and Extensive experience in Project Management methodologies.

Facilitated data requirement meetings with business and technical stakeholders and resolved conflicts to drive decisions. Familiarity and experience in the work environment consisting of Business analysts, Production Support teams, Subject Matter Experts. Created, documented and maintained logical and physical database models in compliance with enterprise standards and maintained corporate metadata definitions for enterprise data stores within a metadata repository.

Exceptional communication and presentation skills and established track record of client interactions.

SENIOR OPERATIONS DATA ENGINEERING LEAD - Circana - Chicago, IL

(2017-11)

• 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(SQL) 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.

DATA MODELER - MasTec - Littlerock, AR

(2016-06 - 2017-09)

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.

• 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

SYSTEM ANALYST - University Of Arkansas At Little Rock - Career Services - Little Rock, AR

(2015-06 - 2016-05)

• 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

Master of Science - Data Science - University of Arkansas At Little Rock (2016-05)