Leny Varghese

• ETL data for report requirements using SSMS
• Created custom reports to replicate D365 and EDI data
• Gained basic working knowledge of Azure Data Factory and Azure Data Warehouse
• Worked with Snowflake DB
• Create detailed visualizations as per business requirement and provided support on modifying existing reports to tailor user needs
• Worked with MS SQL database for design and modelling data sets
• Worked with multiple table scenarios thereby utilizing joins, unions and views to transform data is SQL
• Developed intelligence-sharing dashboards, providing company-wide access to collected data
• Consulted sales, finance and logistics teams to define business intelligence needs, structuring subsequent information and gathering efforts accordingly
• Utilized JIRA to chart out tasks and smoothen workflow

• ETL data for report requirements using Data Cubes
• Create detailed visualizations as per business requirement and provide support on modifying existing reports to tailor user needs
• Worked with Snowflake DB
• Utilized Microsoft Azure DevOps to chart out tasks and smoothen workflow
• Worked with SharePoint and flat files with million plus rows
• Worked with multiple table scenarios thereby using joins and unions
• Gained experience in creating indexes for tables for speeding up search process
• Optimized BI reporting capabilities for secure server environment
• Developed intelligence-sharing dashboards, providing company-wide access to collected data
• Queried sales and finance teams to define business intelligence needs, structuring subsequent information gathering efforts accordingly

Project - Assa Abbloy

• Create detailed visualizations for weekly, monthly and annual reports and scaled requirements based on BRD/FRD
• ETL data for report requirements using SSIS
• Strong hands-on experience in designing data models, implementing dashboards, visualizing data and analytics using Power BI Desktop and Server
• Created various reports using Power BI visuals like stacked bars, bar graphs, scattered plots, geographical maps and waterfall charts
• Utilizing Query editor to prepare, transform and model data as required
• Knowledge about sales and finance data, healthcare data and user behavior data
• Worked with multiple table scenarios thereby using joins, unions and views
• Experienced in writing sub-queries for specific data requirements
• Gained experience in creating indexes for tables to speed up search process
• Worked on database reporting needs and turned them into powerful SQL queries that extracts data and compiles it into meaningful reports
• Designed customized data collection models for specific visualization tasks

Projects - Microsoft and Danaher

• Create detailed visualizations for weekly, monthly and annual reports for Sales, finance and asset margins
• Driving data-oriented analysis, adoption of technology solutions and process improvement projects to achieve operational, business goals and SLA metrics
• Strong hands-on experience in designing data models, implementing dashboards, visualizing data and analytics using Power BI Desktop and Services
• Utilized performance analyzer to optimize BI reports
• Coordinated with Department Managers & Engineers to initiate & implement process optimization
• Used SQL server for direct query data importing and importing

Projects - Costco and Molecular devices

• Responsible as single resource and team member in server administration, application support and database administration for US Healthcare project
• Worked on back-end SQL server for application error resolution and querying
• Served as initial contact person for all SQL support queries
• Analyzed trends across operational events and created efficient workflow patterns

Project - Horizon Patient Folder