Page 	1 of 	5 	
 	
 	 	
        	 	
Anuj Jain	                                                     	              	                	Mob:	    +9	1- 9987198538	 	
                                                                      	                             	Emai	l:  eng.anujjain@gmail.com	 	 	
Professional Summary	 	
  
* 	Total 1	4 years 	of 	experience 	in Data Warehouse Projects with 	Telecom, 	Insurance	, Supply 	
chain	 domain 	working 	with 	Organizations 	Infosys, MindT	ree	, Cognizant	, Mobily	. 	
* 	Experience in	 Design, 	Data Modelling, Data Architecture	, Data Engineering.	 	
* 	Involved in Requirement Gathering, Requirement Analysis, Customer Interaction, 	and Impact	 	
Analysis for new proposals and requirements from client	. 	
* 	Experience in 	Data Modeling	 with 	Erwin	 Tool.	 	
* 	Experience 	in working in 	Telecom domain 	in data warehouse environment	 	
* 	Experience in managing 	business requirement till deployment as 	Scrum master. 	 	
* 	Experience in working at client site, face client 	interaction	. 	
* 	Ability to prioritize and perform broad range of respons	ibilities.	 	
* 	Having Experience	 in ETL Testing, 	Database Testing	, automation	. 	
* 	Good knowledge in the entire 	Software Development Life Cycle (SDLC)	 and Software 	
Testing Life Cycle (STLC).	 	
* 	Experie	nce in 	Azure Data Factory (ADF)	 development	.  	
 	
WORK EXPERIENCE	    	
* 	Worked as Data 	Modeler 	Manager in 	Mobily Infotech	 from 	Nov,	 2020 to Apr	, 202	3. 	
* 	Work	ed	 as 	an	 Associate Consultant in 	Cognizant (CTS)	 from 	April, 2014 to 	Oct	, 2020	.  	
* 	Worked 	with 	Mindt	ree	 from 	June, 	2013 to March. 2014.	  	
* 	Worked with 	Infosys	 from 	Jan, 2010 to May, 2013	.  	
Educational Summary	    	
* 	B. Tech. Computer Science	, Greater Noida Institute of Technology, Gr. Noida, U.P (June 200	9).  	
* 	12	th, from 	(UP State Board), K. K. Inter College, M	eerut, U.P (June 2003	)  	
* 	10	th, from 	(UP State Board), K. K. Inter College, Meerut, U.P (June 200	1).  	
Skill Set Summary  	 	
Technology	 	Skills	 	
Databases	 	Teradata	 ,Oracle 10g	 , SQL Developer, Greenplum	, Snowflake	 	
Operating Systems	 	WIN XP/2000/2003, UNIX	 	
Model	ing Tool	 	Erwin Data Modeling	 	
ETL Tools	 	Abnitio	, Datastage, Informatica, 	ADF	, SSIS	 	
Languages	 	SQL, C, VB Script, Excel Macro(VBA)	 	
Framework	 	Automation Framework(QTP) Data Warehouse	 Sys	tem	 	
 
 
PROJECTS SUMMARY	    	
PROJECT	 	CLIENT	 	DURATION	 	
Infosys Training	 	- 	Jan 2010 	&ndash; June 2010	 	
Retail Distribution of Investment	 	
Products, Infosys	 	
Citigroup	 	June 2010 	&ndash; May 2013	 	
AIG 	-Operational Data Source	 	AIG	 	June 2013 	&ndash; March 2014

Page 	2 of 	5 	
 	
 	 	
        	 	
(ODS),  MindTree	 	 	
Reliance Jio Analytics, Cognizant	 	Reliance	 	April 2014 	&ndash; Oct 2015	 	
Sanofi Sa	les Analytics, Cognizant	 	Sanofi	 	Nov 2015 	&ndash; Feb 2016	 	
STC EDW Dev and Testing, Cognizant	 	STC	 	Feb 2016	- Oct	, 2020	 	
TWC POM OEb	 &amp;Mobily Saudi	 	Mobily &amp; TWC	 	Dec	, 2020	- Apr	-202	3 	
 	 	 	
   DETAILS OF THE PROJECTS WORKED ON	 	
01 	Project Name	  	:     	JNJ Sales Forecast	 	
 	Client	 	
Duration	 	
:     	JNJ	 	
:     	 	
 	Role    	                    	:     	  Data Engineer and Data Modeler	 	
Responsibilities:	 	
 
Design and Data Modelling	 	
 	Creating the mapping and design for the data w	arehouse environment and maintain	ing the data 	
architecture of warehouse.	 	
 	Managing the source communications for the data profiling, source structure understanding.	 	
 	Generating data definition language (DDL) used to create the database schema.	 	
 	Creating a mod	el to correspond to each environment.	 	
 	Develop the logic in 	ADF	 and support Reporting Team for 	Developing Dashboard as per 	
requirement.	 	
 	Lead and Guide team end to end from development 	for the 	ETL	 package.	 	
 	Discussion with 	stake holder	 understand the requirem	ent and suggest the solution to achieve the 	
goal.	 	
 	Understand the logic from 	business	 and document it with proper formula for technical 	
documentation.	 	
 	Managing the work to ensure the quality and timely delivery of product in agile environment.	 	
 	Test Enginee	r 	
 	Software/Tools	 	: 	ADF, ADBK, SQL Server	 	
    02 	Project Name	  	:     	TWC POM OEE	 	
 	Client	 	
Duration	 	
:     	TWC	 	
:     	Dec	 2020	 to 	Apr	 202	3 	
                           	Role    	                    	:     	 Data Modeler and	 ADF Data Engineer	. 	
Responsibilities:	 	
 
Data Modelling	 &amp; Data Engineer	 	
 	Creating the mapping and design for the 	TWC POM	 data warehouse environment and maintain	ing the data architecture of warehouse.	 	
 	Managing the source communications for the data profiling, source structure understanding.	 	
 	Underst	and the requirement from end user/ client and prepare the data model accordingly.	 	
 	Generating data definition language (DDL) used to create the database schema.	 	
 	Creating a model to correspond to each environment.

Page 	3 of 	5 	
 	
 	 	
        	 	
 	Developing ADF Pipeline for	 POM Machine and 	for forecast	. 	
 	
Software/Tools	 	: 	ADF , Snowflake	, SQL Server	 	
 03 	Project Name	  	:     	STC EDW Dev and	 DQ	 	
 	Client	 	
Duration	 	
:     	Saudi Telecom Company	 	
:     	Feb	 2016	 to 	Sep	, 2020	 	
 	Role    	              	      	:     	  Designer/Data Modeler, Scrum Master	 	
Res	ponsibilities:	 	
 
Design and Data Modelling	 	
 	Creating the mapping and design for the Teradata CLDM data 	warehouse	 environment and 	
maintain	ing the data architecture of warehouse.	 	
 	Managing the source communications for the data profiling, source structure under	standing.	 	
 	Design mapping to fulfill the requirement and feasible technically.	 	
 	Maintaining a model repository in Erwin environment	 	
 	Generating data definition language (DDL) used to create the database 	schema.	 	
 	Creating a model to correspond to each 	environme	nt.	 	
 	Synchronizing models to ensure that database structures match models and Testing all DDL before 
deployment	 	
 
Scrum Master	 	
 	Lead and Guide team end to end from development to production deployment.	 	
 	Managing the work to ensure the quality and timely delive	ry of product in agile environment.	 	
 	Good understanding of Abinitio Graph.	 	
 	Interact with client for the progress of the activity in Team bucket.	 	
 	
 	Test Engineer	 	
 	Software/Tools	 	: 	Erwin, JIRA, 	Abinitio	, Data Stage	, Teradata	, JIRA, UNIX	, ADF	 	
 	
 03 	Project Na	me 	 	:     	Sanofi Sales Analytics	 	
 	Client	 	
Duration	 	
:     	Sanofi	 India	 	
:     	Nov2015 	to 	Feb 2016	 	
 	Role    	              	      	:      	Developer	- Tester	 	
Responsibilities:	 	
 	Experience to work at client location	. 	
 	Prepare the Test Strategy, Test Plan and RTM for	 DW/ETL testing and QlikView Report Testing	. 	
 	Involved and helping out for ETL Architecture with Architect	. 	
 	Develop the test script for ETL Testing and Report testing	. 	
 	Update the client with testing Status and handle defect call	. 	
 	Coordinate with the client,	 business analyst and development team during analysis and execution 	
phase	. 	
 	Update the client with the current status and suitable approach for future changing conditions	. 	
 	Logging and tracking of the defects till closure and discuss with development team a	nd client in 	
defect call	. 	
 	Test Engineer

Page 	4 of 	5 	
 	
 	 	
        	 	
 	Software/Tools	 	: 	Quality Centre, Oracle SQL Developer, Informatica, 	QlikView	, Unix	 	
 	
 04 	Project Name 	 	:     	Reliance Jio Analytics	 	
 	Client	 	
Duration	 	
:     	Reliance	 	
:     	April	 2014	 to 	Nov 2015	 	
 	Role 	            	     	      :      Associate 	&ndash; Project	 (Developer &amp; 	Sr Test Engineer)	 	
Responsibilities:	 	
 	Experience to work at client location	. 	
 	Prepare the Test Plan and RTM for DW testing and BO Report Testing	. 	
 	Prepare the test data for SIT phase	. 	
 	Review and develop the te	st cases for testing	. 	
 	Develop the test script for ETL Testing	 and BO Testing.	 	
 	Update the client with testing Status and handle defect call	 	
 	Coordinate with the client, business analyst and development team during analysis and execution 
phase	 	
 	Update the clie	nt with the current status and suitable approach for future changing conditions	. 	
 	Logging and tracking of the defects till closure and discuss with development team and client in 
defect call	. 	
 Involved in following environments of testing:	 	
o 	SIT 	- (Engineered 	Data)	 	
o 	UAT 	&ndash; (Business Data)	 	
 	Validate SAP	-BO Report, Spotfire Report	.  	
 	Test Engineer	 	
 	Software/Tools	 	: 	Quality Centre, Oracle SQL Developer, GreenPlum, Informatica, BO Report, 
Unix, Spotfire	, Hive	 	
 05 	Project Name	 	:    	AIG	-TCOE	 	
 	Client	 	
Duration	 	
:    AIG	 	
:    June 2013 to March 2014	 	
 	Description of the project 	 	
 	           	This project has details of insurance clients of AIG. There are different data 	
Warehouse according to region specific. The current system is to merge them into a 
single warehouse syst	em to facilitate the system as a centralize system and to 	
facilitate the regulatory body.	 	
Role 	                       	:      	Senior Test Engineer	 	
Responsibilities:	 	
 	Involved in streamlining the Automation testing process. 	 	
 	Involved in Test Planning and Test	 Case preparation activity.	 	
 	Involved in finding out the appropriate approach for the testing keeping the future requirements in 
mind.	 	
 	Identifying the approach for Automation Testing. 	 	
 	Developed the automation QTP script for testing.	 	
 	Developed Macro	-tool fo	r the status dashboard.	 	
 	Developed Macro	-Test Data Generation Tool to generate data for the ETL testing. 	 	
 	Involved in training activities related to Automation and ETL.	 	
 	Involved in managing project artifacts.

Page 	5 of 	5 	
 	
 	 	
        	 	
 	Software/Tools	 	: 	HP Quality C	entre, Oracle SQL	 Developer	, QTP 	, Data Stage	 	
 
06 	Project Name	  	:     	Retail Distribution of Investment Products	 	
 	Client	 	
Duration	 	
:     	Citigroup Inc	 	
:     June 2010 to 	June	 201	3 	
 	Description of the project	 	
 	         	RDIP is a board	-mandated, global initiative to revie	w and address the risks in the distribution of 	
investment products to retail investors across Citi. 	 	
Product Rating System	. One of the high	-impact changes associated with RDIP is consistent product 	
rating. The same product will carry the same rating across	 regions. All Standard and Non Standard products 	
will be assigned a rating on a scale of 1	-6. 	
Data Acquisition	. To mitigate the risk associated with the distribution of retail investment products, IPR 	
defined need for DA to provide consistent global survei	llance of suitability mismatches and inconsistent 	
product ratings. Acquired data across the globe and pearl system will be loaded into IPR DW with the data 
populated by &ldquo;Rules Engine&rdquo; will provide consistent global surveillance of suitability and inconsist	ent 	
product ratings. 	 	
Role 	                       	:  Test Engineer	 	
Responsibilities:	 	
 	Expert in automation in the project and was responsible to manage the responsibilities under 
automation for RDIP	 	
 	Involved in scope of automation and identifying the test c	ases for automation	 	
 	Prepare the framework of Automation for 2 modules in the project	 	
 	Involved in developing and debugging the script for automation	  	
 	Worked on Data Warehouse testing and Automation module	. 	
 	Involved in following types of testing:	 	
o 	Data Wareho	use (ETL) Testing	 	
o 	Regression Testing	 	
o 	Automation Testing (QTP)	 	
o 	Functional Testing.	 	
 Expertise in Data Warehouse testing 	&ndash;verifying all the tables in the stage and target environments.	 	
 Experience in verifying and loading the data.	 	
 Input files (text, excel and	 *.dat files) preparation for DWH.	 	
 	Performed test case preparation and execution	. 	
Personal Details 	 	
NAME	 	
DOB	 	
: 
: 	
Anuj Jain	 	
21	-02	-1987	 	
EMAIL ID	 	: 	eng.anujjain@gmail.com	 	
MARITAL STATUS	 	: 	Married	 	
NATIONALITY	 	
LANGUAGES KNOWN       	 	
: 
: 	
Indian	 	
English, Hindi	 	
 
Declaration	  	
Hereby  I  declare  that  the  information  furnished  above  is  true  to  the  best  of  my  knowledge  and 
belief.	 	
 	 	 	 	 	 	 	  	                                	Anuj Jain  	 	
Date: