Shylesh Kumar Marubadi
Johannesburg
Summary
Power BI Developer/Data Analyst who has worked across multiple business leaders to identify data driven opportunity and growths by analyzing and visualizing data. Creative analytical skill, Critical thinking, and Self-Motivational Attitude.
Overview
26
26
years of professional experience
1
1
Certification
Work History
Sr Power BI Developer
Advaita Techologies
02.2018 - Current
- Designed customized data collection models for specific visualization tasks
- Developed intelligence-sharing dashboards, providing company-wide access to collected data
- Collected data from wide-ranging sources, including excel, Flat file, Azure Synapse, Azure SQL database and SSAS Cubes
- Monitored and optimized SQL server performance query and Data model
- Gather requirements from users across various departments and developer report according to their requirement
- Contributed ideas and suggestions in team meetings and delivered updates on deadlines, designs and enhancements
- Develop new reports based on user requirement and maintain existing report, fix bugs, ETL pipeline, DAX Functions and add new metrics or KPI into existing report
- Migrate Existing Excel and crystal report to Power BI to support user automation demand and trained user how to navigate
- Implement incremental refresh to support large dataset and performance
- Implement row- level Security among regional directors and manager in Power BI service
- Build Data model, transform, shape, cardinality, and cleanse to support user requirement in various developing process
- Work closely with DWH team to integrate business intelligence assets into future development lifecycles
- E.g., Calculated logics, Area Groupings and Product Groupings
- Create and configure workspace to share report, access to user and the entire organization by using Power BI App.
Power BI Developer/BI Analyst
Reliance Retail Ltd
02.2016 - 01.2018
- Migrate existing ad-hoc reports to power BI to support part of the automation process and to give user the flexibility of access those report from their phones
- Maintained Existing ad hoc report across users in excel and provide advice to move them to automated process in Power BI
- Experience in working with Power BI service configuration lJessica, workspace configuration, assign permission and deployments
- Schedule meet to gather requirements from user and deliver actionable dashboards, communicate with business users to validate their metrics and KPI through UAT process
- Validation dataset side by side against existing transactional system for accuracy
- Prepared, analyzed, and Ad hoc report to identify performance across various categories, Build executive report month-to-date Dashboard on BI system (Power BI)
- Implement role-Level Security to among directors and executives to support critical restriction and privacy
- Provides design support for development of business intelligence solutions
- Configured dataset and scheduled incremental refresh to support large dataset for performance improvement
- Develop critical data Model to support business needs from user, lJessica unpivot and pivoted rows to columns, calculated columns
- Extract data from multiple flat file source using Domo work bench into red shift transformation
- Schedule Domo Dataflow refreshing from multiple source transformation for reporting purpose
- Build and manage reports across various departments to ensure accuracy and data consistency
- Gathering data from multiple sources and develop ETL process using Domo or power BI
- Build marketing model to track Year-to-date (YTD) variance and performance
- Organize report, size, and share them with team member before deploying to production
- Building data models, lJessica Star schema, snowflake, one to many relationships and date table
- Extract data from multiple source transform, clean, shape and identify pattern using Power BI
- Collaborate with internal and external stakeholders to discuss requirements, lJessica Metric and KPI
- Discuss with various departments leaders to ensure On-Time delivery of their weekly report
- Experience working with Margin Minders, Actuals and analyzed various product categories and sales
- Collaborate with clients to discuss color pallets what kind of color they would like to see or use
- Work with the Data Engineering team to discuss data granularity, attribute, changes, and patterns
- Collaborate with Data warehouse team ensure data integrity and consistency across various departments
- Performed monthly incentive performance analysis to lead marketing incentive offer adjustment
- Intermediate experience using DAX, MDX and writing complex DAX functions across data models
- Prepared, analyzed, and distributed weekly monthly report
- Build variance reports across departments and relate findings and their causes of changes
- Build dataflow and transform data from multiple sources using Domo my SQL, Magic ETL and Red shift Engine
- Validate data side by side comparing during migration of existing legacy system to ensure accuracy
- Extract data from multiple flat file source using Domo work bench into red shift transformation
- Schedule Domo Dataflow refreshing from multiple source transformation for reporting purpose
- Develop and configure Role level security across multiple regional report and dashboard
- Implement incremental refresh on our large data set to enable faster refresh time
SQL Server DBA
Anderson Group
01.2011 - 03.2013
- Create projects, packages, and (ETL) with SQL Server Integration Service Debug failed SSIS package, using event handler, logging, breakeven and capture bad data using error out
- Performance Query Optimization, check execution plan, to determine long running query, wait stats, statistics
- Create connection manager strings, managed Control and Data Flow,
- Troubleshooting with dynamic management view to determine performance issues
- Use SQL Profiler, to capture and identify login run application and blocking in Database, resolve performance problem with DMV, Designed and created databases, tables, views, store procedures
- Regularly check Performance Monitor to determine in I/O
- Migrations of databases between SQL instances using, Backup and restore Database, check data integrity using Database Console command
- Reorganized index and views tables and improve performances, Maintain multiple SQL server database Engines
- Strong Technical background with excellent problem solving and communication skills
- Troubleshoot performance issues and optimizing Query performance
Process Analyst
Hyperion Holdings Pty Ltd
01.2010 - 12.2010
- Developed change management protocols to streamline required business process alterations through preemptive training and guidance.
- Pinpointed cost-effective process improvements through simulation of potential process alterations, discovering optimal enhancements without interrupting live production efforts.
- Processed management reports on monthly basis through effective collaboration with various departments.
- Analyzed and documented company processes for executive leadership and suggested areas for improvement.
- Liaised with staff managers to collaboratively design process change implementation plans.
- Designed process models to provide clear, understandable tools for presenting complex business processes to individuals with minimal knowledge on topic.
- Produced documentation outlining process improvement solutions.
- Maintained authoritative knowledge on change management techniques effective in improving processes without disrupting operations.
- Synthesized performance data from wide-ranging sources into cohesive overviews of process performance.
- Conducted training and applied change management to achieve desired outcomes.
- Developed standard operating procedures and document workflows to drive current and future processes.
- Analyzed process flows and identified areas of improvement to increase productivity and reduce costs.
- Implemented continuous improvement metrics to streamline workflows and reduce waste.
IT Infrastructure Manager
Nuance Group
04.2008 - 03.2009
- Developed and maintained relationships with customers and suppliers through account development.
- Accomplished multiple tasks within established timeframes.
- Resolved staff member conflicts, actively listening to concerns and finding appropriate middle ground.
- Cross-trained existing employees to maximize team agility and performance.
- Planned and budgeted accurately to provide business with resources needed to operate smoothly.
- Controlled costs to keep business operating within budget and increase profits.
- Built IT infrastructure to support key business strategies and evolving processes.
- Oversaw projects to help customers build, secure and optimize their IT infrastructure.
- Provided recommendations regarding new hardware and software to keep IT infrastructure up to date.
- Administered tracking and control of service assets in IT infrastructure and collaborated with configuration analysts to train asset configuration team.
- Estimated infrastructure component costs with vendors and internal technology resources for current and proposed projects.
IT Manager
Heritage Foods India Pvt Ltd
03.2007 - 03.2008
- Managed network and system performance, conducting troubleshooting, security patching, and maintenance.
- Oversaw IT department operations and training.
- Interacted and negotiated with vendors, outsourcers and contractors to secure products and services.
- Coordinated technical training and personal development classes for staff members.
- Communicated with executive team and CEO to maximize development efficiencies and resolve technology issues.
- Built, repaired and installed computer-related hardware based on deployment procedures.
- Developed and implemented measures and procedures to protect IT systems from cyber threats and data breaches.
- Demonstrated familiarity with latest hardware, software and networking technology.
- Led technology selection and rollout, focusing on organizational planning and supplier service-level agreements.
- Conferred with executives to advise and plan for short-term and long-term IT system upgrade needs.
- Coordinated IT operations activities to deliver smooth flow of daily business needs.
- Guided organizational technology strategy and roadmaps.
- Collaborated with other departments to help meet IT needs and properly integrate and secure systems.
- Wrote strategic business plans outlining need for departmental information technology resources.
- Managed life cycle replacement of hardware and software.
- Liaised with other departments to minimize network interruptions and possible downtimes.
- Coordinated secure system access of users to various department systems and platforms.
- Oversaw development and implementation of improvements to support network operations.
- Identified computer hardware and network system issues, performing troubleshooting techniques for remediation.
- Implemented and maintained technology and software budget.
- Analyzed network security and current infrastructure, assessing areas in need of improvement.
Assistant IT Manager
Pantaloons Retail India Pvt Ltd
01.1998 - 05.2006
- Liaised with other departments to minimize network interruptions and possible downtimes.
- Analyzed network security and current infrastructure, assessing areas in need of improvement.
- Identified computer hardware and network system issues, performing troubleshooting techniques for remediation.
- Coordinated secure system access of users to various department systems and platforms.
- Led technical upgrade projects for clients by working and coordinating with consultants and developers for integrations.
- Managed life cycle replacement of hardware and software.
- Identified issues, analyzed information and provided solutions to problems.
- Resolved problems, improved operations and provided exceptional service.
- Demonstrated leadership skills in managing projects from concept to completion.
- Developed and maintained courteous and effective working relationships.
- Gained strong leadership skills by managing projects from start to finish.
- Skilled at working independently and collaboratively in a team environment.
Education
Bachelor of Science - Maths, Physics, And Chemistry
Osmania University
India09.1991
B.Sc. - Masters in Computer Application
Princeton PG College
India09.1996
Skills
- T-SQL knowledge
- M Query
- Azure Synapse/ Azure SQL Database
- Performance Tuning
- Power Query
- Dax Studio & Tabular Editor
- SSRS (Build/Support)
- SSAS (Multi-dimensional/Tabular)
- SSIS(ETL)/ Azure ADF
- Microsoft Power BI
- Excel
- Domo
Certification
· MCPIT
· CCNA
· Linux Certified Professional
· ITIL v3
· CISP (Certified Information Security Professional)
· IBM Midrange Storage Specialist
· Certified Scrum Master
· Prince2 Foundation and Practitioner 2017 certified.
Timeline
Sr Power BI Developer
Advaita Techologies
02.2018 - Current
Power BI Developer/BI Analyst
Reliance Retail Ltd
02.2016 - 01.2018
SQL Server DBA
Anderson Group
01.2011 - 03.2013
Process Analyst
Hyperion Holdings Pty Ltd
01.2010 - 12.2010
IT Infrastructure Manager
Nuance Group
04.2008 - 03.2009
IT Manager
Heritage Foods India Pvt Ltd
03.2007 - 03.2008
Assistant IT Manager
Pantaloons Retail India Pvt Ltd
01.1998 - 05.2006
Bachelor of Science - Maths, Physics, And Chemistry
Osmania University
B.Sc. - Masters in Computer Application
Princeton PG College
Similar Profiles
Ian SooklalIan Sooklal
Progam Facilitator/Clinical Assistant IOP at Advaita Health Ventures LLCProgam Facilitator/Clinical Assistant IOP at Advaita Health Ventures LLC
Rohan PhatakRohan Phatak
High School Biology Teacher at Advaita GurukulHigh School Biology Teacher at Advaita Gurukul
ChandraShekar Reddy MarooriChandraShekar Reddy Maroori
Accounts Payable Analyst at Centific Global Techologies Pvt LtdAccounts Payable Analyst at Centific Global Techologies Pvt Ltd