I am a seasoned Data Scientist/Analyst with a rich experience spanning two years in the field. Over the past year, I have proudly contributed my skills and expertise to the dynamic teams of both Data Science (Personalisation - ML) and Data Engineering at McAfee. My journey has been marked by a relentless pursuit of excellence and a passion for transforming data into meaningful, concrete insights.

My proficiency in SQL, Python, Spark, my ability to figure out a way around blockers on the go, and my decisiveness with sound reasoning has been the cornerstone of my success, enabling me to extract, analyze, and interpret data with precision. My adeptness in these tools has empowered me to spearhead feature engineering projects, playing a pivotal role in enhancing the value of data and optimizing its use for strategic decision-making.

One of my significant accomplishments includes being a key contributor to the establishment of a feature store at McAfee. 
As we all know, from start to end, 70% of time in most Machine Learning projects is spent on finding out correct POCs within the company, communicating with them to acquiring the correct data and also understanding it, predicting probable metrics to be obtained from it, and then performing the pre-processing. 
Developing a feature store involved a lot of Feature Engineering, gaining close familiarity with the raw data, understanding the business and performing a lot of SQL intricacies, not to forget a lot of internal communication. The objective was to cut down on the preprocessing time and provide Data Scientists 
with data they could rapidly build prototypes upon without having to worry about the entire logistics of how it came to be. The nature of this 'pre-processed' data was that it could support a lot of Data Science efforts, since this data captured the essential behavior of our customers. 

This innovative solution has not only streamlined workflows but has also facilitated the acceleration of data-driven innovation within the organization.

Motivated by my unwavering commitment to continuous growth and a thirst for knowledge, I am eager to expand my horizons into the realms of Data Engineering and Data Science. Drawing upon my foundation in analytics and my proficiency in key technologies, I am excited to take on new challenges and leverage my skill set to drive transformative insights and solutions.

In essence, my journey reflects a fusion of experience, technical prowess, and an unrelenting desire to create value from data.

Sidharth Kriplani

DataLemur

⚙️ SQL Query Development & Schema Design
• Demonstrated expertise in SQL by writing over 100 SQL queries for coding exercises.
• Experienced in designing and structuring data schemas and datasets that align with the learning objectives of SQL coding challenges.
• Wrote comprehensive documentation, providing step-by-step explanations to enhance the users’ understanding of solving the SQL challenges.
• Conducted rigorous quality assurance testing to refine problem statements, SQL code, and documentation for improved clarity and precision.

📝 SQL Tutorial Author | https://datalemur.com/sql-tutorial
• Authored SQL tutorials and communicated technical knowledge effectively, enhancing readers' data analysis skills and showcasing strong analytical and communication skills.

🔑 Key Accomplishments
• Played an integral role in the development, launch, and ongoing growth of author Nick Singh's data science platform with a (growing!) user base of 100k users within a year.
• Proactively moderated user feedback, ensuring a seamless user experience with a 24-hour turnaround time for addressing queries, and boosting customer satisfaction and retention.

SQL Consultant | Technical Content Author

Food Market Hub

🛠️ Data Pipeline Development
• Designed a data pipeline from data extraction and processing in Python and BigQuery, to a sales development dashboard in Tableau and integration with Google Sheets for easy viewing.
• Streamlined workflows and improved efficiency through implementation of best practices for sustainable data collection and analysis.

👩🏻‍💻 Data Collection and Analysis
• Led weekly analytical reports for operational teams resulting in a 20% improvement in team performance and efficiency.

📈 Dashboard Creation and Reporting
• Created an interactive investor reporting dashboard for monthly business and operational metrics updates.
• Provided insightful performance results, including monthly active accounts, customer acquisition cost trends, and churn rates to senior management and investors.

Business Intelligence Analyst

Tricor Group

(Merged with Axcelasia in Jun 2020)
Research and Problem Solving
• Enhanced operations efficiency by redesigning accounting processes and automating work procedures by collaborating with other departments and empowering team members
• Improved efficiency of preparation of stock reports by 70% using automation
• Increased accuracy of management report by through dual rounds of managerial review
• Supported clients with Covid-19 initiatives on application to operate during MCO 1.0 lockdown and wage subsidies resulting in earlier business operations and 15% wage savings

Communication and Customer Orientation
• Built relationships with new clients, negotiated meetings, and responded to all questions or concerns within 24 hours
• Explained complex accounting issues in simple, layman terms verbally and in written communication
• Improved provision of information and served as liaison between audit, tax and secretarial departments

Leadership and Organization
• Managed a portfolio of 25+ clients and directed a team of 3 staff by effectively organising financial and accounting reporting and meeting deliverables deadlines ahead of schedule
• Coordinated internal restructuring for merger and led discussions with Payroll and IT on handover of knowledge and integration of systems

Manager, Accounts

• Supported clients with Covid-19 initiatives including application of MITI license to operate during MCO and wage subsidies (“Program Subsidi Upah)  
• Oversee and manage clients’ financial and accounting reporting activitiesincluding treasury, human resources, payroll and administrative
• Timely submission of yearly and monthly accounts, statutory contributions (EPF, SOCSO, EIS, PCB), service tax and withholding tax
• Experienced in full-set accounts using Sage UBS Accounting software
• Effectively plan year and monthly financial and accounting reporting for clients
• Directed a team of 3 staffs with efficient utilization of staff resources and allocation of clients
• Successfully cross-sell internal tax and secretarial services to clients

Managing Consultant

Senior Consultant

AmBank Group

• Responsible for accounting reconciliations, GST submissions, and review of staff claims and company expenditures

Senior Executive, Finance & Strategic Management

PwC Malaysia

• Performed external audits and statutory audits for public listed and SME clients in airline, property, semiconductor, and trading industry.

Audit Associate

Baker Tilly Malaysia

• Conducted external audits for SME clients in furniture, property, and trading industries.

Hello, I'm Katie from Penang! 🏝️

My career journey: Accountant --> Data / BI Analyst --> Data Engineer

🐒 As a SQL Consultant at DataLemur, an online platform specialising in SQL and Data Science Interview Questions, I wrote more than 100 SQL queries, designed data schemas, and authored technical tutorials on SQL functions. 

📊 Prior to this, I was a data analyst at a SaaS startup, where I designed and implemented ETL pipelines from data extraction and manipulation in Python and Google BigQuery, to the creation of dashboards in Tableau.

👩🏻‍💻 I'm also a chartered accountant with 7 years of extensive experience encompassing various domains such as auditing at PwC, banking, accounting, and HR and payroll services.

⚒️ Skills and Technologies
• Language: SQL
• Data Warehouse & Database: Google BigQuery, MySQL
• Spreadsheet: Excel, Google Sheets
• Business Intelligence: Tableau, Looker
• Technologies: dbt

Portfolio: https://github.com/katiehuangx/Portfolio-Guide/blob/main/README.md
How to Transition into Data Analytics: https://github.com/katiehuangx/Transition-into-Data-Analytics/blob/main/README.md
SQL Resources: https://www.linkedin.com/posts/katiehuangx_sql-for-data-analysis-udacity-free-courses-activity-6838753919229931520-u44C/

taplio

The Battle

Sidharth Kriplani

Katie Huang, FCCA

Followers

Posts

Engagements

Likes

Ready to grow your LinkedIn presence?