Krupa H S

Role: BI Developer-Lead - Data Engineering and Analytics

Project Domains: Finance, Corporate Services, Intranet Web Page Analysis, Tesseract Data Hubs

• Gathered requirements from business users for report or dashboard development.
• Guided team members to support development and maintenance activities.
• Maintained existing ETL and designed and delivered new ETLs using SAP BODS and Informatica.
• Developed and managed dashboards using SAP Business Objects and Tableau- Developed polished visualizations to share results of data analyses.
• Designed customized data collection models for specific visualization tasks.
• Responded to specific BI requests from business personnel, creating data engineering workflows and reporting with requested information in easily understandable formats.
• Monitored and optimized SQLs and Dashboard performance.
• Data Engineering activity- ETL- from Source systems to HIVE using in house framework.
• Reporting using Python Scripting- hit Database, run query, post results in .csv format to server mount.
• Compiled, cleaned and manipulated data for proper handling.
• Developed, implemented, supported and maintained data analytics protocols, standards and documentation.
• Handled multiple calls per day to address user inquiries and concerns.

Role: BI Lead- ETL, Product Implementation, Reporting & Analysis

Client: Manitoba Liquor & Lotteries, Canada

Projects: MBLL RA Implementation, Sales Forecasting, Budget & Target Management

• Authored detailed work plans to meet business priorities and deadlines.
• Created detailed roadmaps of action items and project deliverables and generated reports to inform internal members and Delivery head.
• Managed and guided around 4 peers.
• Dimension Modelling - Data modelling using star and snowflake schema concepts, maintaining SCDs across dimension tables
• Developing end-to-end BI solution - ETL Development and Reporting- Design and develop data workflow.
• Development of SQL codes and workflows to transform and load data into AWS Redshift Data Warehouse using in house tool ETL Data Sync.
• Data selection- extract base or historical data required for forecast.
• Creating Key Performance Indicators (KPI’s) for ad-hoc analysis across Sales, Inventory, Operations, Buying & Pricing Modules
• Developed Tableau dashboards/ workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis
• Query optimization and performance tuning.
• Updated stakeholders on key milestones for projects.
• Documenting procedures followed and preparing training document to guide users.

Role: Report Developer and Analyst - Individual Contributor

Projects: Investment Efficiency Scorecard, Network Inventory Consolidation Reporting

• Worked as IT member for business users.
• Gathered and defined business user requirements to develop clear specifications for report design.
• Development of report using technologies as SQL and Microsoft Report Builder Tool 3.0, and Tableau
• Data validation and addressing data issues in reports.
• Discussed project progress with customers, collected feedback on different stages and directly addressed concerns.

Role: Database Programmer- ETL Developer

Clients: British Telecommunications PLC, 2-Degree Mobile Limited

Projects: UKB Data Migration, 2D Data Migration

• Worked as ETL Developer for Data Migration projects leveraging SQL, Oracle PL/SQL, and basic Shell Scripting skillsets
• Worked with development and testing team members to design and develop robust ETL solutions to meet requirements for domain functionality, data validations and and code performance.
• Partnered with development team involved in Data mapping, Data cleansing, Test data selection and data Reconciliation
• Coordinated with other engineers to evaluate and improve code and coding standards
• Consulted regularly with leads and client team members on ETL development project status, data issues, new requirements, and other functionality issues or technical issues.
• Communicated technical development stages and provided and seek design support to and from functional SMEs, encouraging participation for on-time execution.