Sameer Pathan Email & Phone Number

Dallas, Texas, United States

•Developed and maintained database structures, writing advanced stored procedures, functions, and programs. Scheduled regular jobs for monthly snapshot tables to ensure data accuracy and efficiency.•Optimized data warehouse performance by refining views with complex joins and by converting views to indexed materialized views , significantly enhancing data retrieval speeds and system efficiency.•Implemented materialized views to replace long-running complex views and scheduling them periodically to eliminate the stale data, drastically improving the runtime and responsiveness of Power BI visualizations.•Expertly designed and deployed both simple and complex materialized views, utilizing fast and complete refresh techniques to optimize data presentation and accessibility.• Led comprehensive data migration projects, seamlessly transferring data from legacy systems to Microsoft SQL Server, ensuring accurate data mapping and integration.• Pioneered the migration of data from Microsoft SQL Server to Azure SQL Database, facilitating advanced data utilization in cognitive search applications and contributing to innovative chatbot development.

Houston, Texas, United States

Assisted my professor with technical support in building a machine learning model for his research work, which was used to improve the accuracy of the model by 10%. As an instructional assistant for the Data Science and Data vicourse, I provided support to students by answering their questions, grading their papers, and facilitating discussions in class.

Houston, Texas, United States

Worked under a director of Cullen College of Engineering to build, develop, and implement Munki software to support and manage the machines of faculty working under different departments, which saved faculty time and resources.Managed the installations on faculty machines built a dashboard to track the number of the machines and the installations, ensuring that all faculty machines were up-to-date with the latest software.

Chennai, Tamil Nadu, India

•Developed and supported applications for Voya Financial, a leading provider of retirement, investment, and insurance products with a large digital footprint.•Played an integral role on a 15-person AD and AM team with the responsibility of developing and maintaining hundreds of Voya Financial applications for four different lines of business (LOBs). Reported to the manager of Big Data and ETL operations. •Co-Architected the profiling and mappings between data sources required for AWS Glue ETL to process data efficiently. Additionally, designed AWS Glue Jobs for scheduling the job cycle.•Curated an application that gathered data from multiple relational sources like SQL Server, Oracle, and MySQL using AWS Glue data integration. Detected various dependencies with other upstream applications and notified the manager via SharePoint.•Written Unix scripts for an escalated application to automate the sending of job completion emails to end users. Also automated many non-prod testing tasks by writing efficient code, saving the team a lot of time and effort.•Worked on successful incident and change management responses for deployments and enhancements, automation, and implementing major production fixes that saved the company more than $2 million dollars in chargebacks.•Co-managed the company's migration project from an on-premise Oracle SQL database to a cloud-based AWS RDS database, which decreased maintenance costs and increased performance.•Managed the ETLOPS team platform to track team’s effort in competition league conducted by Voya and trained 6 programmer analyst trainees and migration team on data flow, transformation logic, workflows, Unix scripts.

Master'S Degree, Data Science, 3.701

Bachelor'S Degree, Computer Science, 3.6