Yeshwin Krishnamoorthy

Experience

• 

  UST

  May 2013 - Jul 2017

  • Developed process improvement projects involving the SDLC process; Used Teradata utilities and Informatica workflows and automated the processes, thereby being more productive with savings of approximately $100,000 to the customer (a Health Insurance company in the US)• Resolved a a significant production delay in providing timely solutions involving analysis of large-scale Teradata databases, loading the data using Informatica and submission of files to the state server in time which resulted in savings of about $70,000• Built 18 SAP Business Objects reports in 2 months and implemented them in real time which resulted in 90% more accuracy to the state provided data• Lead a team where I used my experience in driving them to take strong ownership of tasks and deadlines• Worked in different subject areas of healthcare insurance such as claims, provider, member and clinical Show less • Proficient writing SQL queries and programming including stored procedures and automation of existing processes.• Performed all stages of the SDLC process including Analysis, Coding, SIT testing, UAT testing and production support of multiple projects.• Implemented data warehousing concepts including OLTP, OLAP, Dimensions, Facts, and Data modeling to incorporate healthcare analysis of claims and provider data for both historical and incremental loads.• Created and automated shell scripting for generating automated weekly claims data for different lines of businesses.• Involved in Production migration script validation and execution of the queries in Production Teradata Server using Volatile tables to make sure no script failure or multiple rows update.• Created Bteq Scripts to load the Report storage tables (RDS) from LZ tables for new SSB business.• Extracted the claims to standard file format through Fast Export and FTP the files to State system through UNIX commands.• Direct interaction with Client to present technical documents and to rectify team clarifications.• Developed BTEQ scripts for migration of data from one environment to another and for all development activities• Coordinated with Elevance Health (formerly Anthem) for analysis of clinical, provider and claims data• Conducted online presentations explaining about the basic facets involved in every project• Attended Daily calls and organized Minutes of Meeting Show less

  • Senior ETL Developer

    Apr 2016 - Jul 2017

  • ETL Developer

    May 2013 - Mar 2016
• 

  Northeastern University

  Apr 2018 - Apr 2019

  Residential Safety Office Proctor

  • Provided access control to Northeastern University residence halls and helped out guests in guiding to their desired locations• Resolved for issues within the residence halls, being present in all scheduled time shifts and being aware of all deadlines in the office

• 

  Wayfair

  Jan 2019 - Jun 2019

  Data Analyst

  • As part of network planning team, I was in charge of finding new Delivery Agents (DA's) across the Wayfair Delivery Network (WDN)• Leveraged data and showcased metrics as part of decision making for conversion of more 3rd party DA's into asset-based for the purpose of faster and more efficiency in delivering purchase orders (PO's) to customers• Reduced dwell time and increased stops per route of major asset-based warehouses by 20% by analysis of large parcel data using ML models such as Regression, Clustering, Random Forest and XGBoost• Developed a framework for inbound and outbound data for LTL and TL across all DA’s using SQL server• Formulated reports for usage of all door utilization parameters for most constrained DA’s during Q1 2019 by means of R and Power BI• Optimized data with SQL server and MS Excel for conversion of 3rd party DA's into asset-based to send purchase orders to customers• Aligned and balanced cross functional objectives across sales, marketing and finance teams as part of strategic planning process; presented strategic plan of improving the returns, liquidations and aging freight carton space usage to steering committee with 10+ functional leads Show less

• 

  AI Skunkworks at Northeastern University

  Mar 2020 - May 2020

  Volunteer and Data Researcher

  • Created visualizations with regards to the COVID-19 crisis around the world and in the US• Sourced information about all possible epidemiologists and virologists in the US

• 

  TRUELight Energy

  May 2020 - Jul 2020

  Senior Data Analyst

  • Built macros for automation of Renewable Energy Certificates (REC's) process and generating REC daily forward curves for different ISO's and their states using MS VBA thereby saving 20-25 hours of manual work every month• Loaded csv data into database and performed DDL and DML operations for load profiles using MS Access• Performed other tasks like daily curve generation, monthly model update for all ISO's in the northeast region and generated monthly Price to Compare (PTC) models for the ISO's using MS Excel• Supported any existing issues or errors in the VBA code occurring in Excel sheets Show less

• 

  Vertex Pharmaceuticals

  Jul 2020 - Apr 2021

  Senior Analytics Engineer

  • Created QA Operational and Clinical document reports for current & legacy QMS data with Power BI• Managed and performed upgrades and configuration updates to regulatory, quality and clinical systems - Veeva vault eTMF, ARIM, EURS Validator, TRAIL (Insight) Viewer• Designed a centralized platform to serve as a master data repository – designed database by means of Veeva data analysis, generated Power BI reports and pulled data from Oracle database and SharePoint into data repository

• 

  Bass Pro Shops

  Jun 2021 - Oct 2023

  Senior Data Analyst

  1. Data Science: Built Machine Learning (ML) models to predict the customer purchase behavior for products of various categories like fishing, hunting, camping, marine, etc. I used Python libraries for machine learning, PostgreSQL for data loading and Excel for the dataset itself2. Web Analytics: Perform analyses and create and edit ad-hoc reports pertaining to different factors such as no. of customer clicks/visits on the website, avg. visit duration every session, items ordered per cart, etc. to the people from marketing team as per their requests. I use both Adobe Analytics and Google Analytics to do these3. HR analytics: Collaborate with the HR team to building a dashboard showcasing the type of trainings required for newly joined employees and recurrent trainings for the existing employees in the company. I use Excel to build the data and DOMO to create dataflows and generate dashboards Show less

• 

  Cognizant

  Dec 2023 - Feb 2025

  Manager Data Analyst

  • Spearheaded daily discussions with a 12-member team to drive direction and facilitate critical decision-making in ongoing projects• Leveraged Starburst and Collibra to integrate data into a marketplace by utilizing foundational components (Virtualization, Metadata Management, Data Access Layer) in building 4 Data Products and optimizing 30+ KPIs to enhance efficiency by 25%• Applied GenAI-driven insights by using LLMs and RAGs to expedite detailed analysis of business processes, creating mapping specifications and building materialized views in Starburst• Led the analysis and documentation of business requirements for projects within the medical devices’ domain• Collaborated with stakeholders to define and model business processes, workflows, and decision trees, ensuring consistency with organizational standards• Conducted comprehensive customer journey mapping to identify pain points and optimize the customer experience, resulting in a 30% improvement in conversion rates• Worked closely with stakeholders to create capability frameworks that supported long-term organizational growth and transformation goals• Oversaw the creation and maintenance of project documentation using Confluence and Jira• Teamed up closely with development teams to ensure accurate translation of business requirements into technical specifications and exhibited excellent analytical and problem-solving skills• Aided Data Architecture, Data Engineering and Data Governance teams in discussions about outlook and scope of projects• Expediated the detailed analysis of business processes to identify areas for improvement and guarantee that all project deliverables meet quality standards and business objectives Show less