Sameer Mehta

Sameer Mehta Email and Phone Number

Manager, Cloud Data Architecture @ Compliant Pharmacy Alliance Cooperative
Plano, TX, US
Sameer Mehta's Location
Plano, Texas, United States, United States
About Sameer Mehta

At the core of my professional journey lies a passion for transforming data into actionable insights that drive business growth and efficiency. My philosophy revolves around the power of data to reimagine the future, guiding organizations through strategic deployment of cloud technologies and innovative data solutions. I believe in the relentless pursuit of excellence, championing integrity, collaboration, and adaptability as the pillars of my approach.As a Cloud Data Architect and Data Engineer, my expertise encompasses data warehousing, ETL processes, and big data technologies. I excel in designing robust data structures and modeling to optimize business processes, and I bring a wealth of experience in developing reporting solutions using tools like SSIS, SSAS, SSRS, and Power BI. My proficiency extends to cloud technologies such as Snowflake, Azure Synapse, and Azure Data Factory, leveraging their power to derive data-driven insights. Additionally, I am well-versed in programming languages like R and Python, enabling advanced analytics and data science capabilities.My career is marked by distinctive achievements, including leading the development of a comprehensive 360-degree data view at BANK OZK, which enabled centralized access for business partners, enhancing decision-making. I played a pivotal role in migrating the on-premises reporting system to the Snowflake cloud, significantly enhancing scalability and performance. At Toluna, I delivered a multimillion-dollar reporting solution for CVS Pharmacy and successfully upgraded SQL servers, showcasing my ability to drive strategic change and innovative solutions. My dedication has been recognized with awards, including Employee of the Quarter at Bank OZK and the Most Dependable and Knowledgeable Employee Award at Toluna.I am on a mission to leverage my extensive experience and leadership skills to empower organizations in achieving their strategic objectives through cutting-edge data solutions. My goal is to create value by enhancing business efficiency and fostering growth through innovative IT implementations. Let’s connect and explore how we can collaborate to elevate your data strategy and drive transformative business outcomes.

Sameer Mehta's Current Company Details
Compliant Pharmacy Alliance Cooperative

Compliant Pharmacy Alliance Cooperative

View
Manager, Cloud Data Architecture
Plano, TX, US
Website:
compliantrx.com
Employees:
50
Sameer Mehta Work Experience Details
  • Compliant Pharmacy Alliance Cooperative
    Manager, Cloud Data Architecture
    Compliant Pharmacy Alliance Cooperative
    Plano, Tx, Us
  • Compliant Pharmacy Alliance Cooperative
    Cloud Data Architect
    Compliant Pharmacy Alliance Cooperative Oct 2024 - Present
    Dallas, Texas, United States
    In my role as a Data Architect at Compliant Pharmacy Alliance, I am responsible for driving the organization's data strategy, implementing Microsoft Fabric, and fostering a culture of responsible, self-service data consumption. My focus is on refining and harmonizing data through advanced tools like Power BI, Azure Synapse, and Microsoft Fabric while ensuring strong data governance and protection aligned with industry standards, including HIPAA.Key Responsibilities: • Lead data activation and standardization, optimizing data modeling strategies across Microsoft technologies. • Develop robust data solutions utilizing data warehouses, advanced analytics, and the Azure platform. • Implement and maintain data validation processes to ensure accuracy and reliability across systems. • Design scalable solutions that align with Medallion Architecture in Microsoft Fabric and Azure Synapse. • Provide technical leadership and mentorship, fostering innovation and continuous improvement. • Ensure governance and security compliance, including implementing Row Level Security (RLS) in Power BI reports. • Oversee the integration of data from various sources, including Dynamics and third-party vendors. • Leverage automation and orchestration tools to streamline data implementation processes. • Lead the creation of high-performance data warehouses, lakehouses, and semantic models for organizational use. • Collaborate with cross-functional teams to secure data using least-privilege-access methods and manage legacy data cleanup. • Stay current with emerging data technologies and drive continuous innovation within the organization.I am passionate about leveraging the latest Microsoft tools and best practices to enhance the organization’s data capabilities and create a data-driven culture.
  • Dataminds Labs
    Snowflake And Microsoft Fabric Data Consultant
    Dataminds Labs Jul 2024 - Sep 2024
    Dallas, Texas, United States
    As a Data Architect, I specialized in guiding organizations through their cloud data journey, whether leveraging Snowflake or Microsoft Fabric, to ensure seamless transitions to modern cloud infrastructure.My expertise spanned the following areas: • Planning and Requirements Gathering: Collaborated with stakeholders to understand business needs and develop effective data strategies. • Architectural Design: Created scalable and efficient data architectures for optimized performance and adaptability. • Data Ingestion: Designed robust pipelines to ingest data from various sources into cloud platforms. • Data Storage: Implemented secure and scalable storage solutions that met organizational needs. • Data Processing and Transformation: Streamlined data processing workflows to ensure accurate and timely insights. • Data Modeling and Integration: Developed models and integrated data for better decision-making and reporting. • Data Security and Compliance: Ensured data protection through security best practices and adherence to regulatory standards. • Data Governance and Quality: Established data governance frameworks to maintain data integrity and quality across platforms. • Data Visualization and Reporting: Created insightful visualizations and reports to support business objectives. • Deployment and Automation: Automated workflows and processes to increase efficiency and reduce errors. • Performance Optimization: Tuned systems for peak performance and scalability. • Monitoring and Maintenance: Provided ongoing monitoring and maintenance to ensure optimal system performance.• Documentation and Knowledge Transfer: Documented processes and delivered comprehensive knowledge transfer to ensure smooth transitions.
  • Bank Ozk
    Senior Vice President, Data Engineering
    Bank Ozk Jul 2022 - Jun 2024
    Dallas, Texas, United States
  • Bank Ozk
    Vice President, Data Engineering
    Bank Ozk Mar 2021 - Jun 2022
    Dallas, Texas, United States
    Managed and developed a team focused on developing data warehouse solutions. Part of a team to "Re-imagine the Future" to build innovative cloud solutions. Key Accomplishments:• Implemented an architect solution to move on-premises reporting solution to Snowflake cloud.• Integrated Moody’s Credit lens application into our DataMart; a critical integration needed for the bank underwriting and risk rating platform.• Built a new risk rating platform to automate and optimize the risk rating process. Enabled automated quarterly loan risk rating vs. manual annual risk rating leading to efficiency gains.
  • Bank Ozk
    Associate Vice President, Data Development
    Bank Ozk Aug 2019 - Feb 2021
    Dallas/Fort Worth Area
    Managed and developed a team focused on developing data warehouse solutions. Key Accomplishments:• Implemented critical Risk Rating DataMart used for all reporting needs for all loans.• Built an Indirect lending DataMart to enable more data insight. Built an ETL process to import XML files from third-party vendors using Alteryx.• Built a Power Apps solution for the Data Quality team. Drove a quarterly process to a weekly process resulting in efficiency and meeting the regulatory requirement.• Awarded Employee of the quarter in 4Q19.
  • Toluna
    Associate Vice President, Cem Database Services And Reporting
    Toluna Jan 2014 - Jul 2019
    Dallas/Fort Worth Area
    Trusted business partner and IT leader for digital market research and technology company specializing in research, data collection, reporting, and visualization. Develop and implement strategic reporting solutions for multimillion dollar accounts, such as CVS. Design cloud-based storage solutions and refine reporting processes for clients and stakeholders. Manage and forecast IT budget for development team. Key Accomplishments:• Drove strategic change in business direction by implementing task automation and direct reporting to project managers. • Delivered and maintained successful multimillion-dollar reporting solution for CVS Pharmacy.• Successfully upgraded the SQL server 2012 to 2016.• Deployed cloud-based data storage and reporting solutions, successfully utilizing Power BI and Microsoft Azure.• Enhanced accuracy of enterprise planning by developing a customer service score forecasting tool.• Selected to receive Most Dependable and Knowledgeable Employee Award of the Year in 2015.• Design and develop forecasting tool to predict customer service scores utilizing data mining and TSQL.• Built Azure Data warehouse, R solution, R studio, encrypted database for PII information, Cloud reporting solutions, dashboards, and Excel databases.
  • Toluna
    Director – Database Management And Programming
    Toluna Feb 2011 - Apr 2014
    Led full range of IT solutions and service including SSIS, SSAS, dashboards, data reporting/management, trouble shooting, reporting, and system migrations. Demonstrated strong ETL design skills, including source to target mappings, transformations, lookups, aggregations, and expressions. Created complex SSIS packages which loaded multiple files using a wide-variety of data transformations, including conditional splits, data conversions, derived column, and more. Key Accomplishments:• Extensively used SSIS and SSAS to create an online cube for the clients including Amtrak, Popeyes, Pfizer, and CVS.• Created a dashboard application for Project Managers to access tools, web-site, and reporting, reducing waiting time. • Upgraded SQL Server 2005 to 2012. • Built interactive reports for upper management with new functionalities such as multi-level and drill down reporting.
  • Toluna Usa
    Senior Programmer / Database Analyst
    Toluna Usa 2002 - Feb 2011
    Sr. Programmer/Database AnalystDelivered a wide range of IT and database solutions to enable more efficient client operations. Innovated new approaches to reporting, databases, projects, quality assurance, archiving, aggregating, and data security. Supported migrations to new software platforms. Mentor and role model for junior programmers and teammates. Trusted partner to business clients. Key Accomplishments:• Built reporting for Archon, a Goldman Sachs company, aggregating the results from 360 employee surveys.• Expanded stakeholder access to data reports by developing system with access to 1M+ records.• Developed vote collection project using SOAP and Web services, implemented during the 2002 gubernatorial elections.• Created an Access database application for quality assurance to automate the manual process for checking data.• Developed an analytical application for research analyst’s Turf calculation, generating more business from the client.• Launched well-received “SQL Saturday” program through collaboration with diverse project and event teams.
  • Common Knowledge
    Sr Programmer
    Common Knowledge 2000 - 2002
    Dallas/Fort Worth Area
    Audited and modified programming systems company-wide for better management of big data, and created centralized databases with improved accessibility and reporting functions. Reviewed, analyzed, and modified programming systems to enhance overall performance, from testing and debugging to installation and ongoing application support.KEY CONTRIBUTIONS:• Facilitated ease of access to reports by centralizing data with MS Access and SQL server databases.• Programmed successful ASP surveys for leading clients, including American Airlines, Burger King, Best Buy, and Nokia, utilizing data-intensive reporting using ASP and SQL servers. • Established maintenance plan for the backup of SQL servers to ensure business continuity. • Essential in the completion of a major project involving the porting of the existing system to IIS Web Server and the migration of SQL Server 7.0 database to SQL Server 2000.

Sameer Mehta Education Details

Frequently Asked Questions about Sameer Mehta

What company does Sameer Mehta work for?

Sameer Mehta works for Compliant Pharmacy Alliance Cooperative

What is Sameer Mehta's role at the current company?

Sameer Mehta's current role is Manager, Cloud Data Architecture.

What schools did Sameer Mehta attend?

Sameer Mehta attended Naveen Jindal School Of Management, Ut Dallas.

Who are Sameer Mehta's colleagues?

Sameer Mehta's colleagues are Emily Frankenfield, Kimberly Stoltenberg, Troy Scheffel, Thomas K., Edward Heckman, Blaire M., Peter Halecky.

Not the Sameer Mehta you were looking for?

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.