Data Architect
2020 - PRESENTA Data Warehouse as a Service Company- Enhanced and fixed bugs on the existing data model. Bug fixes included a complete review and fix of the omnichannel sales reporting module.
- Improved the data model to accommodate additional business areas to support retail analytics. Some of the areas included marketing, customer analytics, and payroll.
- Assisted with the implementation of three new customers. I completed various integration with structured, semi-structured, and API-based data.
- Managed four developers who delivered a demo dataset, anonymizing real-world data from one of our clients (with their consent). Its purpose is ETL orchestration and demo dashboards for showcasing the data model's capability to potential customers.
- Managed a team of three people for deprecating unwanted modules adding five modules to the data model, setting up the data model on a modeling tool, and centralized the repository where the core model and clients' versions could all be appropriately managed.
Technologies: Data Marts, Data Lake Design, Data Lakes, Data Modeling, Reporting, Data Analytics, Data Visualization, Tableau Server, Tableau, ETL, Microsoft Excel, SQL, Data Engineering, Python 3, Snowflake, Azure Data Factory, Data Warehouse Design, Data Warehousing, Dashboards, CSV File Processing, Databases, Database Development, Reports, Dashboard Development, LookerSolutions Architect
2018 - PRESENTA Leading Software Services Company- Completed pre-sales technical consulting for two large retailers in Australia. Managed a team of six people offshore to deliver sample ETL and dashboards on their data as part of POC.
- Conducted design sessions and authored technical designs for integrations to the Oracle MOM suite with various sources.
- Headed R&D for an accelerated delivery mechanism for Snowflake projects. This included a team of seven developers where I architected and managed the delivery framework. The outcome of this effort was a 2-week accelerated implementation module.
Technologies: ETL, Data Engineering, SQL, Oracle Data Integrator (ODI), Oracle Business Intelligence Enterprise Edition 11g (OBIEE), Exadata, Oracle, Python, Snowflake, Dashboards, Dashboard Design, Dashboard DevelopmentProject Manager
2016 - 2018A Leading Software Services Company- Guided the re-planning delivery for a retailer in Indonesia and oversaw the delivery. Managed a team of three onsite and seven offshore members.
- Conducted CRP and developed a project plan for a new retailer in India.
- Assisted as a technical project manager in the UK, including delivering 100+ reports and 10+ customizations on Oracle Retail Insights. Also, I managed a team of two onsite and nine offshore developers during this project.
Technologies: Data Engineering, Python, SQL, KornShell, Oracle Data Integrator (ODI), Oracle Business Intelligence Enterprise Edition 11g (OBIEE), Oracle, Exadata, Data Architecture, Microsoft Power BI, Data Virtualization, DAXProject Leader
2015 - 2016A Leading Software Services Company- Led and managed delivery of 500+ reports and dashboards and 25+ custom integrations for a retailer's BI project in Thailand. Managed a team of five onsite and four offshore developers, with eight onsite and 13 offshore members at peak time.
- Led the development of supplier profitability tools based on various data aspects that helped buyers negotiate new contracts and deals.
- Supported the development of a central replenishment module.
- Led and managed a team of four developers to migrate 50+ reports on a B2B portal from JSP-based to Oracle BI Publisher, including new reports creation, integration of BI publisher to B2B securely, and additional integration as required by reports.
Technologies: Excel Macros, Excel VBA, Microsoft Excel, Data Engineering, Python, KornShell, Oracle Data Integrator (ODI), Oracle Business Intelligence Enterprise Edition 11g (OBIEE), SQL, Exadata, Oracle