Kartikay Panchal

Kartikay.panchal17@gmail.com 8317324710/9541555598

Professional Experience:
 IT professional with around 6.5 years of experience working in SQL, PL/SQL development.
 Very comfortable in writing stored procedures in SQL and PL/SQL.
 Experience in analyzing the data models, data visualizations, analyzing the business logic &rules
and incorporating the same.
 Quick learner, very good in people management and flexible to any work environment and
technology with good interpersonal and communication skills.

Strong experience in SQL:

 Sound experience on RDBMS and Data Warehouse concepts.
 Good exposure to database objects.
 Good command over DML, DDL and DCL.
 Strong in writing Sub-queries, Correlated sub queries, Joins& set Operators & other query types.
 Good exposure in using SQL date functions, number functions, analytical function.

Experience in PL/SQL:
 Worked on PL/SQL programming.
 Experience at different database objects in PL/SQL.
 Good at understanding the business rules and application of logic in the sub programs.
 Experience in creating stored procedures, user defined functions and cursors.
 Good at handling exception.
 Worked in creating and handling of materialized views and views.
 Good knowledge in Table partitioning.

Experience in Data Warehousing concepts:

 Have a good knowledge on data warehouse concepts.
 Good at data warehouse architecture.
 Good at identifying dimensions and facts.
 Good experience in creating schemas.
 Good knowledge on Meta data.
 Good at OLAP types and its operations.
 Have knowledge in SCD1,SCD2 and SCD3.

Experience in MySQL:
 Good knowledge in MySQL queries and functions.
 Good knowledge in data loading and debugging.
 Expertise in DDL and DML commands.
 Experienced in using different functions and concepts on basis of requirement.
Experience in Informatica:
 Worked in creating Mappings and workflow for different tables.
 Good knowledge in using lookups in mappings.
 Expertise in changing mappings and workflow on basis of requirement.
 Good knowledge in worklets and using them.
 Have a good knowledge in integration service.
Experience in Unix:
 Good exposure in finding out the error.
 Good knowledge in restarting the server.
 Good exposure in using different directories.

Experience in Amazon Redshift:

 Good knowledge working on Amazon Redshift.
 Working experience on AWS.
 Good exposure to amazon Etl tool Datanet.

Work Experience:
Working in Virtusa Polaris consultant and solutions as assistant software consultant from April
2019 to till date.
Worked in IMR Softech, Bangalore as a Software Engineer from Jan 2016 to April 2019.

Education:
B.TECH (CSE) from RPIIT from Karnal (Haryana) with 67.5%.

Technical Skills:
Database : Oracle 11g, MSSQL
Languages : SQL, PL/SQL, MSSQL, UNIX
Operating System : Windows
Tools : Informatica, Tableau
Other skills : SVN, Swagger, Mongo DB,

Projects Summary:

Project #5
Project Title : LQT (British Telecom) Client: British Telecom
Environment : Oracle database.
Description : In this project, we are working on the different requests received from the
customer on basis of there requirement for the services like LAN connection, routers, switches,
cables, licenses etc.
The customer generating new requests from the UI which is connected to our DB.
We have applied the pricing logic, license logic and other logics. We have created different journeys
on basis of product and services that we have developed for the customers. Also , we have new UI
and old UI both are managed by our team. We are getting data from the other team which is coming
in our DB through jobs. The requests data is stored in tables and XML is generated for each request.
The XML is to see the configurations properly. The data is transferred to other team Expedio, which
is used to generate the reports of different products, different requests, different journeys.
Responsibilities: Role: Assistant Software consultant
 Involved in gathering information for new requirement.
 Developing the code in basis of new requirement.
 Debugging and finding the issue or bug in the code.
 Modifying the code for any bug or issue resolving.
 Creating functions and procedures for new requirement.
 Helped the team to find correct pricing logic for new journeys and product.
 Doing the Unit testing after the code development or code modification.
 Checking the job if the DB is giving duplicate records.
 Solving the Live issue and giving the proper solution in timely requirement.
 To be the part of deployment on Sprint basis.

Project #4
Project Title : APE (British Telecom) Client: British Telecom
Environment : Oracle database, Swagger and Flat Files.
Description : In this project we are managing data receiving from the different customers on
basis of there requirements. The customers are applying different uploading and downloading
speeds with different countries and speeds. So managing that data and giving the proper prices
with right configurations.
Here if the customers if getting any response for the required configurations than we are checking
where the error is generating. We were developing the new code basis on the requirement of the
client. As well as we supporting the process also. If any quote in not getting process than checking
the code and providing the right solutions to the customers. We were also working on different Live
issues and test cases scenarios.

Responsibilities: Role: Assistant Software consultant

 Involved in gathering information and client requirements.
 Creating the data tables and views on basis of requirement.
 Using some DML on the tables and views for the developments.
 Debugging the different procedures and packages to find the issue.
 Modifying the procedures and packages on the client requirement and story.
 Creating new procedures and functions for the new requirement.
 Generating quotes in test environment and matching the result with the desired result set.
 Applying new logic while working on any issue and testing it.
 Checking logs for any request and finding the error and resolving the issue.
 Running some monthly, quarterly and yearly reports on basis of client requirement and
providing the right information to client.

Project #3
Project Title : MAS (ICICI MAS) Client: Fintellix Solutions
Environment : MSSQL database, Informatica, Unix and Flat Files.
Description : In this project we are building a product to load the data into the data warehouse
and then generating different reports for the bank.
The data have the details of different customers and parties with different types of accounts and
different services from bank. The bank need reports on daily, monthly, quarterly, half yearly and
yearly basis. The reports are different on basis of Loans, Deposit, Cards, Treasury and Security.
With the help of these reports bank can analyze his business. He can analyze his assets and
liabilities, and hence can examine different products of the bank.
With these reports, bank have the facility to analyze the business outside the country and in
different currencies.

Responsibilities: Role: Product Engineer

 Involved in understanding the requirement and gathering information.
 Creating the data tables, views and different reports format.
 Creating different mappings and workflow to load the data into tables.
 Creating data integration file to load the data from flat files to tables.
 Loading the data into dimension table and fact tables.
 Setting up the Drive Dimension conditions given by the bank as their product names.
 Loading the data from fact tables to Reporting Layer fact tables through workflows.
 Creating rules for every report and linking each line item with given condition.
 Running the utility and updating value in each report.
 Matching the value of each line item with the golden result.

Project #2
Project Title : Logistics system Client: NDVOR
Environment : Oracle database and Flat Files.
Description: In this project we are managing the data obtained from the front-end application of
logistics business. It has data about consignor, consignee, consignment, warehouses, types of
services, source and destination addresses of consignment, weight and dimensions of the
consignment, payment details, staff, departments, jobs, vehicle, pick-up and delivered dates of the
consignment and undelivered consignments. In this project we are dealing with the data in which
consignments are shipped through surface and air. Also, we maintain all the data pertaining to
wholesale consignments and its payment details.
This project is also helpful in analyzing the key performance indicators (KPI’s) like transportation
charges, inventory accuracy, on-time shipping and delivery, average days late, Rate of returns due
to shipment damage or shipment error, profitability and order picking accuracy.

Responsibilities: Role: Software Engineer

 Involved in understanding the project requirements and the entities available in the project.
 Wrote SQL queries to retrieve the data from the database.
 Created the database objects like Stored Procedures, Functions and Views.
 Used the concept of Correlated, Joins, and Derived tables while working with the complex
queries.
 Involved in exception handling.
 Participated in discussions involving the application creation and understanding the
requirements.
 Understanding and analysis of user’s requirement for minor enhancements.
 Identification of bug and the provision of immediate workaround.
 Response to end user’s functional queries.

Project 1:
 Title: AbbVie-1connect Client: NDVOR
Environment: Oracle Database, Oracle 11g
Description: AbbVie is pharmaceutical client where it handles different franchise tablets for all
its health care clients. For every franchise of tablets has n number of representatives to supply that
to health care clients specially doctors & medical stores for different regions in the world. There are
managers & representatives who have their different clients to call & sell tablets of different
franchise. For that they need call processing sheet to which they call & have incentives for every
sale of tablets (Incentives compensate). We have to generate report for IC & CP reports. On weekly
basis & monthly basis in excel format (for both manager & agents) on regular basis.

Responsibilities: Role: Software Engineer

 Involved in requirement gathering and analysis.
 Designed/developed tables, views, various SQL queries, stored procedures, function, complex
PL/SQL packages.
 Wrote SQL Loader for Import/Export data files.
 Development, System and production environment database script maintenance.
 Using Sql loader to move data into temporary table and then processing it through Oracle
procedures and functions.
 Data validations by checking the logs.
 Analyzing tables and indexes for performance tuning.