Sohil Sanghadia Email & Phone Number

Melbourne, VIC, AU

Melbourne, Victoria, Australia

Melbourne, Australia

• Origin EnergyIndustry: Utilities
• Designed and delivered Data integration solutions using a cloud based Matillion ELT.
• Performed Data analysis and query optimisation of AWS Redshift based environment.
• Developed interactive Tableau reports for Operational as well as Executive level users.
• Worked across business groups ranging from Metering, Marketing, Credit collections, Solar Programs and Advanced Analytics teams.
• Mentored of Junior level consultants.

Melbourne, Australia

• National Australia BankIndustry: Finance
• Gathered reporting requirements from the stakeholders for new reports and also for existing reporting requirements;
• Partnered with marketing stakeholders across all marketing segments to ensure they have a clear understanding of how their activities impact performance metrics.
• Analysed Data of disparate data systems in Teradata Database.
• Performed ETL process development using Dataverse, a cloud based ETL Solution.
• Created and published new Tableau reports and dashboards.

Melbourne, Australia

• Phillip Morris International Industry: Retail
• Instrumental in completely revamping the Sales files delivery process from external vendors to PMI. The newly designed process drastically cut down the AU wide sales loading to EDW from 13 hours to 2 hours.
• Performed ETL process development using SSIS Packages.
• Created and Published new Tableau reports and dashboards
• Managed of Certified and Non Certified Tableau Datasources.
• Supported System Testing and UAT Activities.

Melbourne, Australia

• Ausnet Services, Melbourne VICIndustry: Utilities
• Acted as a primary liaison for various IT groups of Infrastructure, Procurement, Change Board, Helpdesk and Portfolio Services as well as Business groups.
• Created Integration Designs and DB Modelling.
• Conceived the Operating Model and Business Continuity Plans for the EDW.
• Performed Data pulls in order to ensure EDW data quality is as per expectations.
• Meeting with AusNet Stakeholders to understand requirements and suggest solutions.

Melbourne, Australia

Integrated Releases Testing Support as a part of Business Intelligence and Analytics Unit at nbn™ Australia

Melbourne, Australia

• Work with stakeholders from NAB, Macquarie Bank and ING Bank deliering Veda Products
• Prepare and maintain Requirements Tracebility Matrix.
• Preparation of Test cases and scenarios.
• Test case execution using SOAP UI and application front end
• Drive meetings and conduct UAT with Internal and External Stakeholders
• Defect Logging and tracking using Altassian JIRA

Pune Area, India

• Worked at Tata Consultancy Services for BEST BUY CO. INC.Data warehousing and Business Intelligence project
• Active participation in Effort estimation activity.
• Perform extensive data analysis to understand the complexity and criticality of the source data.
• Assess current capabilities, identifies high-level business requirements and conduct a gap analysis
• Decompose high-level requirements into user, functional and non-functional requirements specified in an appropriate level of detail
• Negotiate requirement's priorities and resolve conflicts among stakeholders

Minneapolis, Minnesota

Worked at Tata Consultancy Services for Best Buy Co. IncOracle Retail ORMS ERP Implementation Project- Working with the business to scope requirements and translate these requirements into Functional Specifications- Proactively analyse the business to identify inefficiencies in process, procedures or systems, and work with the business to find suitable.

Eden Prairie, Minnesota

• Worked at Tata Consultancy Services for SUPERVALU INC.Data warehousing and Business Intelligence project
• Eliciting Requirements and creation of Requirements Traceability Matrix
• Designed and support of end-to-end Data Warehouse and Business Intelligence solutions
• Contribute to definition and implementation of standards and best practices for DW & BI
• Identify trends and develop appropriate processes to ensure timely resolution and ongoing continuous improvement of key processes
• Ensure that production/support requirements are met prior to transition to production

Mumbai Area, India

Front end programming using Visual Basic 6 Comprehensive database design and programming using Oracle PL/SQLDevelop middleware components by doing shell scriptingDesign canned reports using Crystal Reports 3Manage Version control of the code changes MS-VSS (for source code control)Provide Client-site deployment and UAT supportRequirements GatheringAssist.