Lohitha Man

About Lohitha Man

Overall, 8 years of experience in Information Technology, specializing in Data Modeling, Data Analysis, Database Design & Development in Data Warehouse environments-> Domain exposure across Insurance, Banking, Healthcare, giving strong cross-industry insight into data flows, regulatory & financial requirements-> Deep familiarity with the full SDLC (Software Development Life Cycle), engaged in all phases — requirements, design, development, testing, deployment — using Agile, Scrum, and Waterfall methodologies-> Experience in relational, dimensional, and multidimensional data modeling; adept at creating conceptual, logical, and physical data models-> Designed star schema and snowflake schema models for OLAP and OLTP systems, balancing normalization and de-normalization to optimize performance and storage-> Extensive work on Data Warehousing and Data Mart design, ensuring data integrity and consistency via parsing, prototyping, data validation and quality checks-> Hands-on with ETL/data integration tools such as Informatica, DataStage, Talend, SSIS; performed data transformations, mapping, data cleansing, and loading-> Experience with AWS cloud services (EC2, S3, Lambda, Glue) especially for data pipeline design, ingestion of JSON/XML, storage, and feeding BI/reporting tools (e.g. Tableau dashboards)-> Proficiency in SQL, PL/SQL, stored procedures, views, constraints, joins; sound in writing and optimizing complex queries-> Built BI/reporting visualizations using Power BI, Tableau, Excel (Power Query, Power Pivot), integrating data from multiple sources; created dashboards, KPIs, scorecards-> Experience in setting up/working with CI/CD pipelines, automation, and tooling for database deployments and data integration tasks.

Experience

1. Data Analyst Data Engineer

   Walgreens

   Dec 2023 — Present · Chicago, IL, US

Education

• KL University

  Bachelor's degree