Kamal K.

Kamal Kant

Sr. Architect

Concentrix Catalyst

(Formerly Prokarma Softech Pvt Ltd)

J P Nagar,

Bangalore, 560100

#5, Celebrity Serenity,

Bandenallasandra Village, Kyalasanahalli,

Jigani Link Road, Bangalore, 560105

+917406445006 [email protected]

 

Professional Profile

 

Results-driven Data professional with 13+ years of expertise in customising solutions according to specific business requirements. Dedicated technology professional with strong track record of architecting, developing, and implementing ETL pipelines. Adopts a logical and analytical approach to problem solving with the organisational skills required to ensure that deadlines are met. Enjoys working as part of a cross-functional development team and thrives in challenging and high-pressure environments.

 

Technical Skills

Languages:

Python, Spark, Spark Structure Streaming, SQL, PL/SQL, Core Java, HDFS, Yarn, Map Reduce, Pig, Hive, Web Services, Forms, Reports, and Oracle Apex.

OS:

Windows NT/XP/2000/Vista, Linux and UNIX.

Databases:

Oracle 9i/10g/11g/12c, Azure SQL Managed Instance, SQL Server, Postgresql, HBase, Cassandra, Cosmos, Delta Databricks, Snowflake and SQLite.

Tools:

 

 

Cloud Technologies:

Power BI, Tableau, Talend, SQL Developer, PL/SQL Developer, Toad, Putty, Bugzilla, GIT, Oracle Developer Suite, WEKA, Pentaho 4.2, SVN, Core Ftp, JIRA, and WIKI, Flume, Oracle Golden Gate.

Azure, Databricks, ADF 2, Azure Data Lake Gen1 & Gen2, Blob, Cosmos DB, HDInsight, USql, and Azure devops.

 

Education

 

MSc

 

 

B.E.

Distributed Data Management (2013), University of Hertfordshire, UK

Research Topic: Active Learning: a technique for reducing the amount of required training data based on the learning algorithm selecting the next item to classify.

Electronics & Telecommunication Engineering (2007), Amravati University, India.

Intermediate

Science (2003), R.P. College, India.

SSE

Secondary School Examination (2000), Loyola High School, India.

 

Professional Certifications

 

• Microsoft Certified Azure Solution Architect Expert (8-February-2020 to 8-February-2023). Verify Certificate.
• OCP – Oracle Forms Certified Professional (9i).
• OCP – Oracle Database Administrator Certified Professional (9i).
• OCA – Oracle PL/SQL Developer Certified Associate (9i).
• OCA – Oracle Database Administrator Certified Associate (9i).

 

Career Summary

 

07/2021-Till Date

Sr. Architect, Concentrix Catalyst (Formerly Prokarma Softech Pvt Ltd)

 

Responsibilities

• Full responsibility for product deliverables.
• Developing POCs.
• Working in close conjunction with Onsite team and Clients.
• Leading requirements gathering for new enhancements to the product.
• Designing, Developing and unit testing interfaces according to requirements.
• Mentoring team members for product development.
• Providing support in QA activities to fix bugs raised during QA testing.
• Providing support in production bug fixing.

 

Projects Done

Name:                              Life and Safety Segmentation.

Client:                        Intrado, United States

Used Technologies:       Microsoft Azure, Data bricks, PySpark, Spark Structure Streaming, ADLSG2, ADF2, SQL MI, Azure Devops, Flume, Oracle Golden Gate, Hive, HDFS and Impala.

Duration                          July 2021 to Till Date

Team Strength               16

Description                       This is migration project from on premises Big Data solutions to Azure cloud. This project involves multiple challenges such as batch processing, real time ingestion, real time replication and near real time consumption. Project involves 911 operation challenges.

 

10/2016-07/2021

Sr. Application Architect, DXC Technology Formerly (HP Globalsoft Pvt Ltd) Bangalore, India

 

Key Achievements

Recipient of the “Spot Delivery Excellence” award in 2020 for contributions made to multiple projects.

Recipient of the “Spot Delivery Excellence” award in 2018 for contributions made to Atlas.

 

Responsibilities

• Full responsibility for product deliverables.
• Working in close conjunction with Onsite team and Clients.
• Leading requirements gathering for new enhancements to the product.
• Designing, Developing and unit testing interfaces according to requirements.
• Mentoring team members for product development.
• Providing support in QA activities to fix bugs raised during QA testing.

 

Projects Done

Name:                              AQMS Analytics.

Client:                        CLP Power Hong Kong Ltd, Environment Protection Department Hong Kong

Used Technologies:       Microsoft Azure, Data bricks, PySpark, Spark Structure Streaming, ADLG2, ADF2, SQL MI, Azure Devops

Duration                          August 2018 to July 2021

Team Strength               11

Description                       AQMS is getting build to visualize the environment condition in Hong Kong. So that impact of power generation on environment can be monitored and appropriate action can be taken accordingly. AQMS XML data processed and brought in structured format in order to build analytics on top of it. Also, this project is to convert batch process to streaming process to avoid duplication of data ingested during re-run of job after failure and making system response to near real time leveraging streaming.

 

Projects Done

 

Name:                              Diamond Analytics.

Client:                        DXC Technology Formerly (HP Globalsoft Pvt Ltd)

Used Technologies:       Azure, Data Factory, VM, SQL Managed Instance and Power BI

Duration                          April 2018 to July 2018

Team Strength               4

Description                       This project is developed for Asia Pacific leadership to get insight of resource utilization.

 

Projects Done

 

Name:                                 Atlas

Client:                                 DXC Technology Formerly (HP Globalsoft Pvt Ltd)

Used Technologies:       SQL, PL/SQL, Oracle Apex, Java 1.8, HDFS, MR, HIVE, SQOOP

Duration:                           October 2016 to July 2021

Team strength:                30

Description:                      This is in-house project developed for FAM team to automate the billing process. Before this project, manual intervention was required for billing process. In order to minimize manual intervention, human errors and process automation Atlas has been developed. Technologies used in Atlas development is Java, Oracle (SQL, PL/SQL, Apex), HDFS, Map Reduce, HIVE, SQOOP.

 

09/2014-10/2016

Sr. Software Engg, Alshaya Outsourcing India Pvt Ltd., Bangalore, India

 

Key Achievements

• Recipient of the “Be Alshaya Award” in 2015 for contributions made to COMS module of Alshaya.

 

Responsibilities

• Complete accountability of COMS Module as module lead.
• Full responsibility for product deliverables.
• Working in close conjunction with Onsite team.
• Leading requirements gathering for new enhancements to the product.
• Designing, Developing and unit testing interfaces according to requirements.
• Mentoring team members for product development.
• Providing support in QA activities to fix bugs raised during QA testing.
• Providing support for raised production problem.
• Ensuring accuracy and attention to detail when documenting developed codes.
• Utilising D2k to develop screen as a GUI for data entry purposes.
• Integrating data from various systems using Pentaho 4.2.
• Developing various Oracle Procedures and Packages to achieve discussed functionality.

 

Projects Done

Name:                                 Ecommerce for Bodyshop Turkey, MENA and MAC Cosmetics (Middle East).

Client:                                 M.H. Alshaya Co., Kuwait

Used Technologies:       SQL, PL/SQL, FORMS, REPORTS, Aramex Web services, Pentaho 4.2

Duration:                           May, 2014 to October, 2016

Team strength:                4

Description:                      This is in-house project developed as integration between ecommerce site and Alshaya order management system called as COMS. Once order is created in ecommerce application it is shared with COMS to complete the order’s life cycle. DHL and Aramex are used as delivery partners for these created orders. COMS will communicate with ecommerce and delivery management partners to complete order’s life cycle and do the required things for order fulfilment.

 

Projects Done

 

Name:                                 Transfer Management

Client:                                 M.H. Alshaya Co., Kuwait

Used Technologies:       SQL, PL/SQL, FORMS, REPORTS, Pentaho 4.2

Duration:                           Sep, 2014 to May, 2014

Team strength:                4

Description:                      This is in-house project developed for supply chain management to track the various transfer during their transit. Two kinds of transfers are there Inter country transfers and local transfers. In Inter country, transfers are between different countries. Transfer can be from warehouse to warehouse, warehouse to store and store to store.

 

04/2014-08/2014

Software Engineer, Cherrytec Intelisolve Limited, Chennai, India

 

Responsibilities

• Working in close conjunction with client.
• Developing various Oracle Procedures and Packages for discussed functionality.
• Leading requirements gathering for new enhancements to the product.
• Performing unit testing for developed functionality.

 

Projects Done

 

Name:                                 Purchase order.

Client:                                 M.H. Alshaya Co., Kuwait

Used Technologies:       SQL, PL/SQL, FORMS, REPORTS, Pentaho 4.2

Duration:                           April 2014 to August 2014

Team strength:                5

Description:                      This project is developed to create non-retail purchase order. New functionality developed to create purchase order based on received quotation.

 

11/2010-08/2012

Staff Consultant, Oracle Financial Services Software Ltd, Bangalore, India

 

Key Achievements

• Recipient of the “We Applaud Award” in 2011 for contributions made to LM module changes in ASPAC region.
• Contributing to the timely delivery of code and implementation of MM eDealer changes resulting in a second ‘We Applaud Award” in 2012.

 

Responsibilities

• Playing a pivotal role in customising the Flex Cube banking solution in accordance with requirements.
• Utilising D2k to develop screen as a GUI for data entry purposes.
• Developing and unit testing interfaces according to requirements.
• Ensuring accuracy and attention to detail when documenting developed codes.
• Responsible for retrofit of existing functionality to new applications.

 

Projects Done

 

Name:                                 Release 5.9

Client:                                 CITI Bank, Canada

Used Technologies:       SQL, PL/SQL, FORMS, REPORTS

Duration:                           March 2012 to August 2012

Team strength:                8

Description:                      In this project loan processing functionality is retro fitted to MM eDealer from Citi Bank, Asia                         Pacific.

 

Name:                                 Release 4.21

Client:                                 CITI Bank, Asia Pacific

Used Technologies:       SQL, PL/SQL, FORMS, REPORTS

Duration:                           June 2011 to March 2012

Team strength:                15

Description:         In FLEX CUBE several new application and interfaces was developed and enhanced as a part of this release for different modules.

1. For LD Module new application of auto loan maintenance was developed for Citi bank Taiwan. In this project screen for the maintenance of loan amount and interface for the automatic maintenance of loan amount was part of development.
2. For china existing application of loan was modified to avail the overdraft facility in hierarchal manner if multiple accounts are maintained with Citi Bank.
3. For the trade of precious metal new swift message MT600 was generated instead of MT300. This enhancement was supported by almost all countries in ASPAC region. 

 

Name:                                 Release 5.7 & 5.8

Client:                                 CITI Bank, London

Used Technologies:       SQL, PL/SQL, FORMS, REPORTS

Duration:                           November 2010 to May 2011

Team strength:                5

Description:                      FLEX CUBE FXMM Module was used for back office support for citi bank London. All deals information comes to flex cube for processing and if processed successfully acknowledgement was sent back to the system from Flex Cube. If deals got failed then nack information got generated and was sent back to the corresponding system. For this purpose several interfaces were required which were the part of development.

 

04/2010-11/2010

Software Engineer, NIIT Technologies Ltd, Bangalore, India

 

Responsibilities

• Working in close conjunction with various Data Providers and Business Analyst.
• Developing various Oracle Procedures and Packages for the cleaning and migration of cleansed data.
• Leading requirements gathering for new enhancements to the product.
• Writing code to fix specific problems within the production department.

 

Projects Done

 

Client:                                 Toyota Kirloskar Motors, INDIA

Used Technologies:       SQL, PL/SQL, JAVA

Duration:                           April 2010 to November 2010

Team strength:                11

Description:                      The Data related to Toyota Kirloskar’s sales and operation of entire India was processed and collected into a centralized application to provide a single window view.

 

10/2007-03/2010

Software Engineer, Global iTechnologies, Bangalore, India

 

 

Responsibilities

• Playing a key role in developing various Oracle Procedures and Packages.
• Identifying and swiftly resolving issues with current database.
• Responsible for documentation and unit testing of developed codes.

 

Projects Done

 

Client:                                 ISRO

Used Technologies:       SQL, PL/SQL, .NET

Duration:                           June 2008 to March 2010

Team strength:                6

Description:                      Inventory management system was an application developed for ISRO to manage their resources. It automated the stock maintenance for ISRO. Availability of requirement is being checked using this system and accordingly dispatch process initiated.

 

Client:                                 Cosmos Super Market Bangalore

Used Technologies:       .Net, Oracle 9i

Duration:                           September 2007 to May 2008

Team strength:                4

Description:                      Supreme was a web application that was developed to manage their products. Supreme also have the powerful Admin management that is, Admin section, which had different user access levels.
This project was carried out to computerize the day to day activities of a supermarket.

 

Personal Details

 

Date of Birth:                    05-Jul-1984

Father’s Name:                Arbind Kumar Sinha

Passport:                           U2174547