Pushpender Sharma	 	
 
Current Company 	&ndash; TCS, Pune	 	
Phone 	- +91	-74476	-50079	 	
Email 	- Pushp_Sharma10@yahoo.com	  	
 
An  aspiring 	Data 	Vault  data	 Modeler  and 	Cognos  BI	 developer	 offering 	11 	years  of  rich  and  comprehensive  experience	 with  a 	
demonstrated	 track record of delivering results 	in a highly	 competitive environment. 	 	
 
QUALIFICATIONS/CREDENTIALS 	 	
 
❖ 	B. TECH	 in Electronics and 	
Communication	 from PTU 	 	
 	
❖ 	10th from 	Shri Guru 	
Harkrishan Public School	, 	
Pathankot	 	
 	
❖ 	12th from 	MDK Arya Senior 	
Secondary School, 
Pathankot	 	
 
 
 	
 
 	
CAREER HIGHLIGHTS 	 	
 	
❖ Well  Versed  with  various  OLAP  Tools  such 	as Cognos 	analytics 	and  Cognos	 	
Administration,	 Cognos Report Studio, Framework manager	. 	
❖ Proficient in creating 	Physical, logical	 and conceptual data model depending on the 	
business requirements.	 	
❖ Strong  knowledge  on 	setting  up  Single  server  and  distributed  server  Cognos 	
environments at Legacy and Cloud Environments.	 	
❖ Defined  and  governed  data  modeling  and  design  standards,  tools,  bes	t  practices, 	
and related development for enterprise data models	. 	
❖  Extensive  experience  in  converting  CQM  to DQM  packages,  identifying  and  fixing 
bugs during migration from one data source to another.	 	
❖ Good  knowledge  about  Database  Designing  Administration,  Advanced  Data 
Modeling for Star Schema design	 	
❖ Implementation  expe	rience  with  web  servers  and  working  knowledge  of 	
authentication 	providers like Open ID, AD, 	Okta, Pingone	 	
❖ Experience in migration on	-Prem Cognos to Google cloud environment.	 	
❖  Extensive  experience  with  Cognos  administration,  LDAP  configuration  and  Single 
sign on experience	 	
❖ Good Knowledge in 	Managing Cognos user security groups and roles	 	
❖ Installation, Upgrade, maintenance and support of all Cognos Analytics components	 	
❖ Experience  in  Data  vault  2.0  data  modeling  for  loading  all  the  enterprise  data  in 
single Ent	erprise data warehouse through ETL loads.	 	
❖ Involved  in  various  projects  related  to	 Data  Modeling,  System/Data  Analysis, 	
Design and Development for both OLTP and Data warehousing environments.	 	
❖  Good exposure on working with cloud database like Google Big 	query .	 	
❖ Worked extensively 	end to end on migrating Cognos environments from on premise 	
environments to cloud environments	. 	
❖  Overall  exposure  on  data  server  connections, maintainence,  fix  packs 	, setting  up 	
security groups on Cognos environments.	 	
 	
 
 	
Data Modeling tools	 	Erwin, Oracle SQL developer	 	
Databases	 	Oracle 10g, SQL, SQL developer	, Big Query, Teradata	 	
Analytic Tools	 	Erwin, C	ognos Analytics, Cognos 10	 	
ETL Tools	 	Informatica	 12x Power center	 	
 	
Operating Systems	 	Windows server 2008,2012, Linux	 	
 	 	 
 
 
 
 
 
Work Experience 	 	
 
Tata Consultancy Services	                                         	                	May 2020 	&ndash; Present

Designation: Consultant	 	
Team Size: 9	 	
Role:  Data Modeler and Cognos Admin	 	
 
 
Community Health Services (HealthCare)	 	
 
Community Health Systems, Inc. is one of 	United States	&rsquo; leading operators of general acute care hospitals. The organization&rsquo;s 	
affiliates own, operate or lease 89 hospitals in 16 states with approximately 15,000 licensed beds. Affiliated hospitals prov	ide 	
quality healthcare for 	residents	 and contribute to the e	conomic development of their communities. Based on the unique needs 	
of each community served, these hospitals offer a wide range of diagnostic, medical and surgical services in inpatient and 
outpatient settings.	 	
 
Responsibilit	ies 	 	
 	
❖ Migration and maintenanc	e of Cognos Analytics from On Prem to Google cloud Planform 	 	
❖ Installation and configuration with AD authentication 	with GCP for better performance 	 	
❖ Enabling Single Sign on and creating user security groups and providing necessary privileges to the 	users.	 	
❖ Data Analysis and creating OLTP and OLAP data models based on the client requirements	 	
❖ Involved in various projects related 	to Data Modeling, System/Data Analysis, Design and Development for both 	
OLTP and Data warehousing environments	 	
❖ Preparing Physical and Logical Models 	and 	enabling team mates to 	understand 	Data modeling	 (Dimensional &amp; 	
Relational)	 concepts like Star	-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.	 	
❖ Created, documented and maintained logical and ph	ysical database models in compliance with enterprise 	
standards and maintained corporate metadata definitions for enterprise 	data	stores within a metadata repository.	 	
❖ Analyzed database requirements in detail with the project stakeholders by conducting Joint 	Requirements 	
Development sessions	 	
❖ Developed a	 Conceptual model	 using Erwin based on requirements analysis	 	
❖ Developed normalized	 Logical	 and	 Physical	 database models to design OLTP system for insurance applications	 	
❖ Created dimensional model for the 	reporting system by identifying required dimensions and facts using	 Erwin 	 	
❖ Used forward engineering to create a Physical Data Model with	 DDL	 that best suits the requirements from the 	
Logical Data Model	 	
❖ Worked with Database Administrators, Business Analysts	 and Content Developers to conduct design reviews and 	
validate the developed models	 	
❖ Identified, formulated and documented detailed business rules and Use Cases based on requirements analysis	 	
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Infosys Ltd.	  	    	 	 	                                        	From Jan 2015 	&ndash; Apr 2020	 	
 
Designation: Technology Analyst	 	
Team Size: 3	 	
Role: 	 Data Modeler and Designer

Hillenbrand Batesville Inc.	 	
 
Hillenbrand is a global diversified industrial company with multiple leading brands that serve a wide variety of industries 	 	
around the world. Hillenbrand&rsquo;s portfolio consists of two business segments:  Process Equipment Group and Batesville	.      	
Batesvil	le is a recognized leader in the death care industry in North America through the manufacturing and sale of funeral 	
services products, including burial caskets, cremation products, selection room display fixturing and technology solutions fo	r 	
funeral homes	 	
 
Responsibilities 	 	
 	
❖ Understanding the business requirement in CAB meeting with clients and Extracting data from ERP systems to 
create data definition that modifies the metadata into meaningful data.	 	
❖ Loading analyzed and Extracted data into the 	Staging area and creating Hash Keys to be used in Hub, link and 	
Satellite tables	 	
❖ Installation, Upgrade, maintenance and support of all Cognos Analytics components	 	
❖ Respond to and resolve tickets on technical issues related to Cognos Analytics within defined	 SLAs	 	
❖ Co-ordinate with IBM Support for any issues related to Cognos Analytics tools	 	
❖ Responsible for monitoring, reporting, and controlling server usage	 	
❖ Creation and maintenance of system documentation related to the Cognos Analytics environment	 	
❖ Deep level 	troubleshooting including RCA	 	
❖ Communicate status of production issues to stakeholders in a timely manner	 	
❖ Identify problems in advance and look for continuous service improvements	 	
❖ Participate in problem management and come up with trend analysis on recurrin	g incidents	 	
❖ Partner with the DBA, Systems, Networking, and Product teams to facilitate issue resolution	 	
❖ Identifying Hub, Links and Satellites from the data definition created from JD Edwards and Other customized 
systems according to data vault 2.0 methodol	ogy.	 	
❖ Loading analyzed and Extracted data into the Staging area and creating Hash Keys to be used in Hub, link and 
Satellite tables	 	
❖ Creating mappings for JDE to Stage, Stage to Data Vault (Hub, Link and Satellite loaders) and Data Vault to EDW 
and set up bu	siness logic.	 	
❖ Creating and validating test scripts to validate the data of JDE with staging, Data Vault and EDW to make all the 
data is loaded correctly with no loopholes.	 	
 
 	
 	
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 	 	
Atos 	Syntel Ltd.	 	 	    	 	 	                                            	From Nov 2011 	&ndash; Dec 2014	 	
 
Designation: Software Developer	 	
Team Size: 5	 	
Role: Reports Developer

BARCLAYS BANK	 	
 	
Barclays	 is a British	 multin	ational	 banking and	 financial services	 company headquartered in London. It is a	 bank with 	
operations in retail, wholesa	le and investment banking, as well as wealth management, mortgage lending and credit cards. 	
It has operations in over 50 countries and territories and has around 48	 million customers. Barclays is organized into four 	
core business: Personal &amp; Corporate (Per	sonal Banking, Corporate Banking, and Wealth &amp; Investment Management), 	
Barclaycard, Investment Banking and Africa.	 	
 
Responsibilities	 	
 	
 	
❖ Strong skills developing DMR models in Framework Manager and dimensional reports in Report Studio 	 	
❖ Strong understanding of designing dimensional and relational models, star and snowflake schemas and different 
DW design paradigms.	 	
❖ Good knowledge in building	 Active reports, static reports using conditional grouping and drill through	 	
❖ Identifying facts and dimensions from the source system and business requirements to be used for the data 
warehouse.	 	
❖ Developing reports in BIRT using dimensional and relational mo	dels.    	 	
❖  Using SQL server and Oracle database for data analysis and query optimization	 	
 
 	
 	
 
 
PERSONAL PROFILE	 	
 	
▪ 	Date of Birth 	 	 	 	: 	13th September	 1988	 	
▪ 	Nationality                    	 	 	: 	Indian	 	
▪ 	Marital Status	 	 	 	:         	 	Married	 	
▪ 	Languages known          	 	 	: 	English, Hindi, Punjabi, Japanese	 	
▪ 	Passport                                                   	  :                 	J7780550	 	
 
I hereby declare that all the above 	are	 true and correct to the best of my knowledge and belief.	 	
 	 	 	 	 	 	 	 	 	(Pushpender Sharma)