Pankaj Rawat



Career Focus and Experience Summary:

Result driven Tech Lead/Solutions Architect with extensive experience in leading the management, design, development, and implementation of IT solutions. Recognized leader, applying high impact technical solutions to major business objectives with capabilities that exceeds IT boundaries. Adept at working with management to prioritize activities and achieve defined project objectives; able to effectively translate business requirements into technical solutions. Committed to helping organizations achieve maximum benefit from their IT investment, through meticulous testing, QA, research, development, and implementation of technologies.

Wide-ranging experience in solution architecture and design, technical leadership, system analysis, design, development, Testing and deployment of various Information Technology projects in industries including but not limited to Government, Consumer Packaged Goods (CPG), FMCG, Building and Construction Materials, Banking, IT Consulting etc.

Strong working knowledge in developing Internet/Intranet, Client/Server Based Applications

Extensive experience in data access, data processes, data strategy, data management and integration, data manipulation, data conversion and migration, data visualization and data transformation using SQL Server, SSIS, Excel and Oracle.

Actively involved in Database Design and Database application development using MS-SQL Server, Oracle, Crystal Reports & .NET Development Tools.


Career Snapshot:

Accenture Australia

Business & Integration Architect Associate Manager

March 2011 to Current

CAS Systems Australia

Technical Consultant

Aug 2007 to Feb 2011

Boral Limited, Sydney

Analyst Programmer

April 2001 to July 2007

SDI Technologies, Sydney

Software Engineer

Oct 1999 to April 2001


Summary of Skills:

·   Solutions/Application/Data Architecture

·   Creating solution prototype and controlling solution development

·   Analyzing the technology environment

·   Translating business requirements into technical design

·   Business/Requirement Gathering and Analysis

·   Expert in writing programming code, SQL queries, views, stored procedures

·   Data/Database Management, ETL and ELT, Data Transformation, Migration and Integration

·   System Implementation

·   Client Relations and Stakeholder Management

·   Conflict management and resolution

·   AWS, Azure and Salesforce Certified


Education and Technical Knowledge:


- Bachelor’s Degree in Science
- Master’s Degree in Economics
- Post Graduate Diploma in Computer Applications
- Post Graduate Diploma in Project Planning and Infrastructure Management


- AWS Certified Cloud Practitioner – Aug 2020

- AWS Certified Solutions Architect Associate – Dec 2020

- Microsoft Certified Azure Fundamentals AZ-900 – Sept 2020

- Microsoft Certified Azure Data Fundamentals DP-900 – Jan 2021

- Salesforce Certified Administrator – Oct 2020



- Visual Basic 4, 5, 6 and VBA

- SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)


Databases/Back End:

- MS SQL Server, MS Access, MySQL, Oracle

Web Development:


- Java Script and VB Script

- Visual Studio (.NET)

Also have knowledge/exposure to:

- Microsoft Power BI and Power Apps Platform

- Python, Node JS

- Amazon Cloud (AWS) Services such as EC2, ELB, ASG, ECS, CloudFormation, RDS, DynamoDB, SNS, VPC, S3, CloudFront, WAF

- Azure Cloud Services such as Virtual Machines, Databricks, Data Lake Storage, Azure Data Explorer, Synapse Analytics, Data Factory, Azure Functions, SQL Server on Virtual Machines, Azure Cosmos DB, Azure Database for MySQL, Azure SQL and Azure SQL Database


Professional Experience


Accenture Australia - March 2011 to January 2021


Lead Consultant / Integration Architect/Technical Lead / Solutions Architect / TPM Expert

Accenture’s purpose is to deliver on the promise of technology and human ingenuity.  They embrace the power of change to create 360° value for their clients, people, and communities.


Assigned to work on many multi-million-dollar projects in Australia and around the world and helped project team in successful delivery of the projects in time and budget while working on-site or off-site in client time zones.

Campbells Soups - North America and Canada - Lead Consultant and developer for the project

·         Managed the Calculation Engine and building Metrices as a specialist. Built custom reporting services reports as well as a ASP.NET application to generate reports based on ad-hoc SQL queries. Assisted project team in various CRs around application customizing etc.

Johnson & Johnson - Philippines and Spain - Integration Architect/Technical Lead

·         Utilized Scrum Agile Methodology. Designed and developed various interfaces interfacing data to and from Amazon S3, CDL and MBOX system. It included data extracting, transformation, and loading (ETL) and Migration of Master Data from Oracle database to SQL server Database. Managed a team of 8 offshore developers.

Minute Maid (Coca-Cola) - North America - Integration Architect/Technical Lead

·         Designed and developed the interfaces to legacy oracle system and liaison with another team (oracle, MuleSoft and BI). Managed the data loading process which included complete ETL process. Including data migration from SAP and Oracle systems to SQL server databases. Lead certain technical aspects of the project, building custom reports using Reporting services and helping the offshore team as CAS expert. Project was delivered using Agile Methodology.

Trade Promotion Management (TPM) on SaaS for Emerging Markets (& Brazil) - Solutions Architect, Technical Lead

·         On first CAS SaaS product customized for Emerging markets. Managed the transformation of the business requirements into technical design and implement them and train and lead the offshore team in Malaysia to bring to speed.

MJN (Mead Johnson) China - CAS Expert/Lead

·         Assisted CAS China team to their day-to-day issues and build some custom functionality required by business.

Coca-Cola – (North America) - Technical Consultant for TPM

·         Managed the customizations for customer-specific business requirements and bug fixing. Enhancements to the existing system by adding new functionality.

Guinness Anchor Bhd (GAB) - Malaysia - Integration Architect/Lead and Technical Consultant for SFA project

·         Participated with the project for the entire project life cycle from beginning to implementation and post implementation support and enhancements. Managed designing and developing interfaces (CAS Integration Objects) between CAS 9 and SAP.   Also involved in technical customization of online and mobile application, identifying, and resolving issues as well as building the infrastructure environments including QA environment and customizing clients for developers.

AB InBev, Henkel & PMI - IDC, Bangalore and From Sydney - CAS Expert

·         Supported IDC team to resolve critical issues. Coaching and Mentoring the Team. Identifying and resolving the Issues. Fixing the issues with the Reports.

Lion Nathan & Pernod Ricard Pacific – Sydney - Technical Consultant for TPM

·         Managed customizations for customer-specific business requirements and bug fixing. Enhancements to the existing system by adding new functionality. New Reports Building and Enhancements to the existing reports.

Campbell Arnott’s – Sydney - Technical Consultant for Arnott’s TPM

·         Managed customizations for customer-specific business requirements and bug fixing. Managed migration project of TPM solution from V4 to v9 which included migrating database from Oracle to SQL Server database. Onsite client support for almost a year. Coached and supported the client’s technical staff to be self-sufficient.

Blackmores – Sydney - Technical Consultant for SFA implementation

·         Involved with the project for the entire project life cycle from beginning to the implementation and post implementation support. Actively supporting client for enhancements, change requests & Bug fixing.


CAS Systems Australia - August 2007 to February 2011


Technical Consultant (CAS CRM Product)

·         Key member of the Professional Services Team of CAS Asia Pacific to ensure the successful delivery and support of the CPWerx CRM system.

·         Customization of company’s flagship Trade Promotion Management (TPM) product CPWerx for various clients such as Fosters, Blackmore’s, Pernod Ricardo Pacific (PRP), Lion Nathan (LNA) and Arnott’s.

·         Managed customizing the product as per customers’ requirements, configuring it and supporting the clients.

·         Worked on Retail Execution, Master Data Management, Promotion Planning and Management, Field Sales Management, Sales Force Automation and Mobile/Handheld Customization.

·         Taking a leading role in configuring the CAS software to reflect the client specific business processes, identifying technical issues as enhancing the product as per client requirements/need.

·         CPWerx system integrates with existing financial systems such as SAP/JDE and I have gained knowledge interfacing/transforming data to fit the CAS application and back to various Financial systems.

·         Defined requirements and business objectives for multiple projects.

·         Wrote Technical Design Document outlining the business objective, logic and coding instructions.

·         Provided input to Solution Architectural issues.

·         Programming, writing, and executing test plans and t test cases, testing customizations in support of customer-specific business requirements.

·         Given customers advice around technical best practices and application customizations.

·         Worked collaboratively with the project team to perform various other project consulting tasks including task estimation, testing and quality assurance activities.

·         Business/ Requirement Analysis and Stake Holder Management.

·         Provide leadership and guidance to customers.

·         Provided leadership and direction to team members (teams from 4 to 6 consultants)


Boral Limited - April 2001 to July 2007


Analyst Programmer

Boral Australia is the country’s largest construction materials and building products supplier with operations in all states and territories.  Boral supplies concreter, quarry products, asphalt, cement, roof tiles, timber and masonry to build infrastructure, residential construction and commercial buildings.

·         Performed estimation, design, analysis and programming tasks for various apps.

·         Designed and developed several windows and web-based applications.

·         Provided input to solution architectural issues.

·         Designed, developed and maintained application solutions for various business units.

·         Enhanced and supported several business-critical applications built by other team members, contractors and external companies.

·         Writing and executing test plans and test cases and performing all types of testing (functional, installation, acceptance_

·         Collaborated with business unit representatives and Team Leader through the system development lifecycle from project initiation through to production support.

·         Lead the resolution of significant production application problems.


SDI Technologies - October 1999 to April 2001


Software Engineer

·         Performed estimation, design, analysis, and programming tasks with multiple apps.

·         Provided input to solution architectural issues.

·         Designed, Developed, and maintained application solutions for various businesses.

·         Writing and executing test plans and test cases and performing all types of testing (functional, installation, acceptance, browser compatibility, stress, load, performance, volume)

·         Provided support for existing applications.

·         Reviewed over application designs and code created by team members.

·         Consulted with clients, business unit representatives and Team Leader through the system development lifecycle from project initiation through to production support.

·         Provided technical support for another team members.

·         Lead the resolution of significant production application problems.

·         Collaborated with clients on client sites