Jorge Sanchez Email & Phone Number

New York City Metropolitan Area

• Ensure the on-time delivery of daily files to consumers from managed pipelines and automated workflows on production support utilizing PagerDuty and One ServiceNow incident management• Design and implement CI/CD data pipelines with Jenkins and Git to build and promote applications from QA to Production while meeting necessary testing requirements and staging environments• Build Databricks environments with cluster appropriation, computed resources and performances for East to West transitions to continue team notebook collaboration and scheduled workflows• Promote features and QA processes to live Production environments after testing, verification, development and scheduling in automated engines, including Automic and Redwood servers• Develop transformations using Python, Pyspark, SQL and Scala to build financial processes and modeling for analysis and performance enhancement using collaborative Databricks notebooks and Github repositories• Assist with the migration of older transformations from Java and Scala to current Pyspark environments using Docker and AWS containerization• Manage AWS infrastructure including S3 buckets, versioning, policies, lambdas, EMR and EC2 cluster rehydration for production performance using shell scripting with Unix and Linux in IAM roles.• Register and validate datasets to AWS S3 Data Lakes and Delta Lake environments from QA to live production following stringent data governance, privacy, and data cataloging guidelines using internal applications and platforms• Uphold security standards using vulnerability fixes with Maven, package library updates in Artifactory and ensuring code coverage with compliance standards and testing maturity• Load data from AWS S3 into Snowflake tables, maintain, build and structure tables to optimize data ingestion and improve query performance for financial analysis

New York, New York, United States

• Lead the development of in-depth analyses to support the business goals of internal and external clients with automated report creation using Python scripting and built in API’s for most up to date data availability.• Use PySpark to read, write and analyze large data Apache Parquet files for AWS deployment from large government medicare files to live table loads.• Build functions and execution engines using Python Object Oriented Programming for AWS S3 and EC2 virtual environments with SQL Alchemy, psycopg2 and PostgreSQL.• Implement SQL queries for reporting and reconciliation purposes with financial stakeholders.• Work with data engineering team in database design and table registration with PostgreSQL tables using joins, metric creation and exploration queries.• Ensure data quality by designing ad hoc initiatives for emergency fixing, reconciliation checks and solutions.• Investigate healthcare claims data for patient tracking, facility and healthcare systems ratings• Push to and pull from code repository using Git and contribute to production documentation in Confluence with other engineers and analysts.

New York, New York, United States

As a Data Analyst, I coordinate various databases which includes the research and clinical operations of projects. I help collect, input, analyze and report data.Responsibilities include:• Find data insights using statistical analysis with Python, R and Microsoft Excel• Coordinate and maintain SQL warehouse with primary, foreign keys and data dictionaries.• Create Tableau visualizations of project operations, success metrics and insights using Enterprise Server • Set up automated programming processes in data analysis across databases for report building• Report and present key findings and insights as recommendations of strategy to leadership and management• Provide data auditing and data support across the hospital system for research initiatives• Assisted in COVID-19 emergency efforts to build patient databases and provide clinical population insights• Trains staff on data capture and data entry.

Greater New York City Area

• Provided and presented data analysis and statistical findings for conferences and meetings using Excel and R • Managed large qualitative and quantitative health research databases along with NYS Department of Health data and reports • Lead a team of researchers, medical students and physicians in community settings to conduct research• Designed and coordinated the collection of New York City data for the international MetaSUB genomic project• Assisted in the preparation of materials, submissions and renewals to the Institutional Review Board (IRB)• Provided preparation of grant submissions, progress reports, routing forms, abstracts and manuscripts• Proficient in statistical and database management in RedCap and SPSS

Greater New York City Area

• Managed and entered collected data into study databases, conducts qualitative coding and analysis of research data• Coordinated the recruitment and enrollment of study participants, access patient eligibility for eligibility in clinical trials. Ensured consent protocols are followed for study participation • Assisted in the preparation of materials, submissions and renewals to the Institutional Review Board (IRB)• Assisted with departmental mailings, storage and disposal of patient medical records• Provided trainings to community members and undergraduate students at large, both in English and Spanish• Translated research documents and educational materials for communities from English to Spanish• Proficiency in statistical and database management in RedCap and SPSS

Greater New York City Area

• Provide free cardiovascular and ophthalmology health screenings to underserved NYC communities• Obtain comprehensive medical and health history from participants and provide personal health education• Completes community medical research using IRB approved survey through REDCap software• Attend executive campaign meetings to analyze statistical data and to make research implementations • Recruit, train, inform and direct undergraduate student volunteers on behalf of the program

Greater New York City Area

• Obtain metagenomic samples in teams in New York City subway system following research protocol and using mobile data storage applications

• Dining room waitperson that prepares and serve appetizers, main courses and desserts to Bristol residents• Provide care and supervision of Bristol residents to help meet dietary expectations

Greater New York City Area

• Attended executive meetings, receive lectures and training from Weill Cornell Medicine director of laboratories

New York City

• Enrolled over 180 patients into NIH funded EDCares Study with REDCap software through IRB protocol• Obtained consent and enrolled 61 Spanish speaking ED patients into EDCares study

Greater New York City Area

• Immerse in emergency medicine volunteering, physician shadowing and patient advocacy • Help obtain medical history of patients under direct supervision • Helped nurses accommodate and transport patients, helped sanitize and restock ED when directed

Houston, Texas Area

• Gained medical exposure with professors and health professionals in the UT Health system• Attended pre-medical lectures in medical school and dental school setting.

Data Analytics Certificate, Data Analytics, Data Science, Data Engineering, Graduated

Activities and Societies: The Columbia Engineering Data Analytics Boot Camp is a 24-week program that will empower students to gain.

Bachelor'S Degree, Biochemistry

Activities and Societies: Classes: Took two one year of general chemistry, year of organic chemistry, year of statistics and calculus..

Bachelor'S Degree, Psychology

Activities and Societies: Chemistry Minor, Hunter College Orchestra Chamber, Hunter College Prehealth