Sameer Mehta Email & Phone Number

Plano, TX, US

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.
• 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.

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.
• 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.

Dallas, Texas, United States

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.

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.

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.
• 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.

• 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.
• 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.

• 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.
• 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.

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.
• 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.