IT Business Analyst · Data & Automation · Melbourne, AU
Building reliable data products, integrations, and automation across SQL Server, Power BI, Python, and Microsoft 365. I handle end‑to‑end IT delivery: discovery → design → build → test → document → train → run.

• 16+ years experience spanning analytics, integration, and IT operations.
• Master’s in Business Analytics — Deakin University.
• Certified Scrum Master; comfortable leading Agile delivery and stakeholder workshops.
• Currently running the IT portfolio at Focus Machinery (Bayswater, VIC).
• Exploring practical AI assistants (LangChain + Groq + Pinecone + Gradio) and applying LLMs to business workflows.
• Advocate for data ethics and analytical integrity; design processes that maintain data quality end‑to‑end.
• Experienced mentor and team lead, driving standards in documentation, testing, and delivery.

Open to interesting conversations and collaboration.

• Data & Analytics: SQL Server (T‑SQL, views, stored procedures), Power BI (DAX, Power Query, model design), data modeling.
• Automation & Apps: Power Automate (cloud & desktop), SharePoint/OneDrive, 3CX, Trackunit, Record360, Numerik, Twilio.
• Integrations: REST APIs, pagination & auth flows, JSON payload design, error handling, logging, idempotency.
• AI/LLM: LangChain, Groq API, Pinecone (v3), vector DB design, embeddings, RAG, Gradio UIs.
• Delivery: Agile/Scrum, documentation, change management, stakeholder training, governance & M365 security (Intune).

• ⭐ End‑to‑end integrations between internal systems and external SaaS (Syrinx ↔ Numerik, Syrinx ↔ Trackunit, SQL ↔ Record360).
• 📊 Power BI suites for Hire Contracts, Stock Hire, OffHire, Service Jobs, Working Days/YTD measures.
• ⚙️ Automations for contact sync, contract updates, asset arrival alerts, invoice processing, and daily/weekly operational jobs via Power Automate + SQL.
• 🧪 Shift‑left testing: design test cases, validate edge cases, and maintain high‑quality releases without a separate QA team.
• 📚 Clear docs & enablement: write how‑to guides, architecture notes, and runbooks; deliver training when rolling out new tools.

Scope: End‑to‑end ownership of the IT portfolio for a leading dry‑hire earthmoving business.

• Built and presented Power BI reports for leadership and departments; advanced DAX/Power Query modeling.
• Performed SQL querying for rapid analysis; wrote Python scripts to consume external APIs (GET/JSON).
• Implemented Power Automate (instant/scheduled) and Jupyter Scheduler workflows across apps.
• Managed M365 (Exchange, Intune), asset fleet (laptops, mobiles, tablets, printers, Raspberry Pis), and basic troubleshooting. Wins:
• Rolled out a new HR solution, consolidating tools and cutting costs.
• Co‑led website redesign and launched online e‑rental, integrated with ERP.
• Introduced a survey program capturing feedback across the journey; set KPIs to lift operational efficiency.

Scope: Embedded with Emaar’s IT Data & Analytics team to run Voice of the Customer (VoC) at scale.

• Designed survey architecture & data flows; executed touchpoint surveys and categorized responses for insights.
• Authored questions; built reporting & insights; defined journey‑wide survey strategy.
• Used Salesforce Cloud for CRM/reporting; worked across Qualtrics, QuestionPro, Weconnect. Wins:
• Seamlessly migrated surveys across platforms without data loss.
• Engineered automated data integration for the VoC program, reducing manual effort and boosting reliability.
• Drove CRM issue‑resolution using feedback loops, improving satisfaction within agreed SLAs.

Scope: Group‑wide Master Data Management (MDM) and CRM operations across properties, malls, hospitality, and entertainment.

• Built a unified global customer ID; leveraged MDM for BI/analytics and targeted email marketing.
• Ran campaign ops with segments from analytics; partnered with Marketing on execution.
• Designed CRM data architecture for loyalty, gift cards, and mobile apps; produced performance reports for BUs. Wins:
• MDM became the authoritative customer database, mapping end‑to‑end journeys.
• ML‑driven segments gave executives deeper insight for tailored strategies.
• Targeted campaigns improved click‑through and reduced spam rates; CRM stacks continue with light upkeep.

• Delivered complex ad‑hoc analytics; gathered requirements and designed pragmatic solutions.
• Employed data mining for supervised target prediction and unsupervised segmentation.
• Identified automation opportunities; maintained expertise across analytics & DB tools. Wins:
• Contributed analytics across Telecom, Broadcasting, Distribution domains.
• Led SAS → SPSS migration initiatives.

Early roles: SPSS South Asia — Senior Pre‑Sales Consultant (Sep 2009–Mar 2011) · iEmployee — Client Retention Specialist (Dec 2006–Aug 2007) · NCR — Technical Analyst (Oct 2005–Oct 2006)

Languages & Data: SQL (T‑SQL), Python (pandas, requests, pyodbc), DAX, M/Power Query
BI & Storage: Power BI, SQL Server, SharePoint/OneDrive
Automation & Apps: Power Automate (Cloud/Desktop), 3CX, Trackunit, Record360, Numerik, Twilio
AI/ML: LangChain, Groq, Pinecone (cosine, 384‑dim), Hugging Face, Gradio
Cloud & Security: Microsoft 365, Intune device management
Methods: Agile/Scrum, documentation‑first, CI/CD mindset
Also worked with: R, Tableau, SPSS Modeler, RapidMiner, Salesforce, Qualtrics, Eloqua, QuestionPro

• Focus AI Assistant — LangChain + Groq + Pinecone + Gradio on Hugging Face Space. RAG over Focus website docs; streaming chat, PDF upload, and repo‑structured deployment. Demo: [<link-to-space>](https://huggingface.co/spaces/vikassekhar/FocusTest)

• Hire Contracts Analytics — Power BI semantic model & dashboards. Working days logic (YTD, MTD), suspended days, contract KPIs; SQL views & stored procedures backing the model.

• Syrinx ↔ Numerik Contact/Opportunity Sync — Python + Power Automate + SQL. Handles pagination, merge logic (contact exists vs customer not found), and robust error handling.

• Theft Alert SMS Pipeline — Twilio + Trackunit + Power Automate. Configurable alerting, audit trails, and opt‑out management.

• Master of Business Analytics, Deakin University (2021–2023) Distinction‑level average; capstone project delivered measurable outcomes.
• Master of Technology — Information Systems & Management, Mysore University (2007–2009) Assistant Secretary, student association.
• Bachelor of Computer Science Engineering, Anna University (2001–2005) Student Secretary (final year); Assistant Student Secretary (pre‑final year).

• Certified Scrum Master (Scrum Alliance) — 2020–2022.
• Power BI Essential Training (LinkedIn Learning) — 2023.

• Australian Computer Society — Member (2022–Present)
• Beta Alpha Psi (Deakin Xi Kappa Chapter) — Associate Member (2022–2023)

• LinkedIn: https://www.linkedin.com/in/vikassekhar
• Email: vikassekhar@gmail.com

Languages: English (fluent), Malayalam (native), Hindi (intermediate), Tamil (basic) Interests: Cricket

Last updated: {{ today }}