Subash Thoguluva

• Increased client satisfaction by developing and implementing customized solutions for their specific needs.
• Streamlined processes for improved efficiency, leading to better resource allocation and reduced project turnaround time.
• Enhanced collaboration with cross-functional teams, resulting in higher quality deliverables and increased customer satisfaction.
• Developed and maintained strong relationships with key stakeholders, fostering trust and ensuring successful solution implementation.

• Building end to end data ingestion pipelines in to AWS S3 and Snowflake.
• Building new data warehouses, data marts and data vault based in Snowflake cloud database.
• Technically converted raw JSON, CSV and other files to be ingested from Salesforce to the cloud platforms via AWS S3 and finally landed in to Snowflake.
• Built ELT modes via Python and DBT tool that ingests data in to Snowflake Database.
• Proposed & lead solution design discussions to build an efficient data architecture that categorizes data pipelines in to various stages like Raw, landing, staging & consumption etc.,
• Built end to end pipelines to feed data in to Power BI reports, Data Science activities, Campaign use cases etc.,
• Handled production release, version control via Git and Bitbucket platforms.

• Increased revenue by implementing effective marketing strategies and establishing strong customer relationships.
• Managed daily operations for a successful small business, ensuring efficient processes and quality services.
• Enhanced customer satisfaction by providing timely and accurate product information.
• Resolved customer complaints promptly, resulting in increased loyalty and repeat business.
• Maintained a clean and organized store environment for optimal shopping experience.
• Increased web traffic by implementing effective SEO strategies and keyword research.
• Enhanced user experience by optimizing website layouts and navigation features.

• Lead reporting analyst in cross functional customer and product reporting (Annual Product Reporting) application which identifies complex business problems with various aspects - which helps making proactive business outcomes and campaigns for customer acquisition and retention.

• Lead & built an innovative BI reporting solution via Qlik Sense for the Teradata based analytical asset of business Customers ( BCAA ) which opened up a whole new dimension for the tribe leads, chapter leads and product owners with an ease of use of live yet simplistic dashboards for the customer and product metrics .

• Primary data engineer of the foundational analytical asset for Business Customers (BCAA) which integrates data systems and functionalities engaging various departments/tribes like Business Owners / Data & Analytics /Pricing COE & Business Execution

• Engineered Data ecosystem contains Dimensional models, Data vault & Data warehouse integrated with Power BI & Qliksense reporting and product behaviour insights to enhance business products and encourage customer engagement using Teradata, Erwin Data Modeler, Oracle, Python and Big Data tools

• Data engineering, integration, automation and BI reporting of building analytical data assets which involves various product & customer based raw data source systems using dimensional modelling methods in Oracle and Teradata

• A strong contributor of the New Ways of Working (NWOW) and worked in Cross-Functional Tribes by following the best practices industry's core values such as integrity, collaboration, accountability, respect and excellence.

Toll Groups (Mar 2018 - Jun 2018): MDM Data Modeler/Solution designer

• MDM - Informatica ETL Data Modeler - To work closely with Business Stakeholders - Define conceptual and technical requirement for the MDM data engineers.
• Technical lead (MDM Developers) - for the data engineers offshore team who works solely in developing the technical data mapping requirements prepared by me.
• Informatica and oracle Pub/sub connection model - worked with experts to launch the solution in the MDM data project.

Telstra (May 2015 - Feb 2018): Data Engineer

• Propose Solution and Data architecture for business functionalities of the customer.
• Create reports to support remediation by using the big data tool ( Qlik Sense, Ambari )
• Analyze and Identify Data quality issues within the application, Implement tactical and strategic solution.
• Develop UNIX and Oracle scripts to ensure all the Data Quality issues are captured within the Error Framework.
• Peer review of ETL deliverables from Offshore and Onshore throughout the Software Development life cycle ( SDLC ).
• Providing Technical Support for issues pertaining to UNIX, IBM Datastage and PL/SQL.
• Identify opportunities to implement Continuous Service Improvement ( CSI ).
• Review and ensure system design and specifications are in compliance with Business defined rules.
• Develop enduring, trust based relationship with Client Stakeholders and external vendors.
• Identify and propose opportunities for Continuous Service Improvement that helps contribute to monetary benefit of the company and client.

• Developed DataStage package via complex ETL DataStage Jobs for an SFDC (Salesforce) source system and target EODS (Enterprise Operational Data Store)
• Written automated scripting via Unix Shell Scripting
• Written stored procedures via IBM DB2 Scripts
• Participated in peer reviewing process of the ETL jobs
• Coordinated the work with offshore and onshore team comprising of 4 members.
• Proactively managed communications with all stakeholders to meet the desired service levels.
• Provided guidance and support to the team in resolving technical and business issues.

• Worked in categorizing BING shopping data with the help of Microsoft Internal Categorization and label tool.
• Performed Data Quality Assurance for the whole team by being promoted as SME for peer reviewing data analysis .
• Consulting, analyzing and evaluating functional and technical requirements from clients.
• Produced monthly reports using advanced Excel spreadsheet functions.