Power Bi Quality Control

SHAMEER SHAIK

+1-585-***-**** kansas, KS

***************@*****.*** linkedin.com/in/shameershaik7/ PROFESSIONAL SUMMARY

• A Professional with around 4 years of experience in data analysis, business intelligence, and data visualization.

• Expert in Python, SQL, Tableau, and Power BI for extracting insights and driving decisions.

• Proficient with Oracle, Snowflake, and MongoDB, and experienced with AWS and Azure cloud platforms.

• Skilled in supervising data reporting, collection, and quality control processes, ensuring high data quality across diverse data sets.

• Managed data governance processes, established data and reporting infrastructure, and collaborated with IT and external vendors to implement necessary systems.

• Developed data models and visualizations to meet business requirements, created interactive dashboards with Tableau and Power BI, and developed comprehensive reports for major advertising campaigns.

• Conducted forecasting and optimization on high-budget marketing plans, provided data-driven insights for bud- get planning, and identified additional data to enhance analytics and modeling efforts.

• Technically adept in ETL tools like Informatica Power Center and Talend, performed systems management and integration functions, and created Source to Target Mapping documents.

• Identified opportunities for process improvement, implemented technical business solutions, and ensured data integrity through governance processes.

• Conducted comprehensive market analysis and competitive benchmarking to provide strategic insights and support business decision-making processes.

• Enabled stakeholders to access and interpret data insights for better decision-making, facilitated business and technical teams towards solutions, and centralized data storage using internal databases like Palantir.

• Leveraged MBA expertise to align data strategies with business goals, enhancing cross-functional collaboration and driving strategic initiatives.

TECHNICAL SKILLS

Programming Languages: Python, SQL, R

Data Analysis & Visualization: Tableau, Power BI (with drill-down data exploration), QlikView, Advanced Excel Relational Databases: Oracle, SQL, Snowflake, MongoDB, Microsoft SQL Server, SSIS, SSAS Cloud Platforms: AWS (including S3, Redshift, EMR, RDS), Azure (including Azure Data Factory, Azure Data Lake, Azure Synapse Analytics, Azure Analysis Services) ETL Processes: Informatica Power Center, Talend

Development Tools: Git, Visual Studio Code, IntelliJ IDEA, PyCharm, Databricks, Excel VBA Business Analysis Tools: Palantir, Rational Rose, MS Visio, RequisitePro, MS Office, Balsamiq, JIRA, HP QC, ClearQuest

Business Analysis Methodologies: Agile, SCRUM

ERP Systems: SAP S4 HANA

PROFESSIONAL EXPERIENCE

Business Data Analyst Aug 2023 - Present

AT&T Inc. Middlesex, NJ

• Supervised data reporting, collection, and quality control processes for market mix modeling.

• Conducted detailed trend and gap analysis to identify opportunities and areas for improvement within marketing strategies and business operations.

• Ensured high data quality across media, advertising, pricing, handset, online, and competitive data sets.

• Identified and acquired additional data to enhance analytics and modeling efforts.

• Incorporated diverse data sources to improve the accuracy and relevance of market mix models.

• Developed and maintained automated reporting solutions to streamline data analysis and reporting processes.

• Managed the Marketing ROI & Insights data governance process to ensure data integrity and compliance.

• Established and maintained data and reporting infrastructure, coordinating with IT and external vendors.

• Developed comprehensive reports and key insights for major advertising campaigns.

• Translated complex data into actionable insights to inform marketing strategies and decision-making.

• Developed an internal database in Palantir to centralize data storage and streamline data access.

• Collaborated with IT and vendors to plan and administer necessary software, hardware, and systems.

• Created interactive Tableau dashboards to democratize data access and distribution across the organization.

• Enabled stakeholders to easily access and interpret data insights for better decision-making.

• Conducted forecasting and optimization on marketing plans with high annual budgets.

• Leveraged expertise in SAP S4 HANA to enhance data integration and business process optimization, contribut- ing to improved operational efficiency and strategic decision-making.

• Supported budget planning processes by providing data-driven insights and recommendations. Data Analyst Nov 2019 - Jun 2022

SPESHWAY SOLUTIONS PVT LTD India

• Analyzed diverse datasets and databases to extract meaningful insights and identify key trends.

• Translated complex data into informative cubes, reports, and visuals.

• Implemented data models and visualizations to meet specific business requirements.

• Developed KPI scorecards and interactive dashboards using Power BI Desktop.

• Performed systems management and integration functions, improved existing computer systems, and reviewed system capabilities and workflow.

• Facilitated business and technical teams towards solutions when necessary.

• Implemented technical business solutions in compliance with DFA Development, Governance, and Project Man- agement standards.

• Identified, analyzed, and profiled data sources to ensure data quality.

• Identified opportunities for process improvement and implemented enhancements.

• Created standard SQL queries, updates, inserts, deletes, and stored procedures.

• Utilized Power BI for data visualization and dashboard creation.

• Followed best practices and stayed updated on the latest features in Power BI.

• Gathered data requirements and translated business requirements into functional specifications.

• Created and edited logical and physical data models, XML, and file formats using tools like ER/Studio and XML Spy.

• Created Source to Target Mapping documents defining transformations and business rules using Erwin mapping manager or equivalent tools.

EDUCATION

University of Central Missouri, Lee’s Summit, MO Aug 2022 - Dec 2023 Candidate for Master of Science in Computer Science University of People, Pasadena, CA - Online Aug 2021 - Dec 2023 Candidate for Master of Business Administration

Contact this candidate