Dileep 
Mopuri	 	
Hyderabad	 	 	
+91 8712140642	 	 	
dileepchkrpn@gmail.com	 	 	
https://www.linkedin.com/in/dmopuri	 	 	 	
Experienced and dedicated Data Analyst with 	6 years of working experience. my work consists of 	
identifying	 efficiencies and problem areas within data streams. I&rsquo;m adept at receiving and monitoring 	
data from multiple data streams. Can interact effectively with colleagues and clients both in country an	d 	
overseas. worked on software	 applications such as SQL, Informatica	 and in	-house applications known as 	
Unify (Master Database) and MARS (Data Stewardship). I&rsquo;m a presenter and confident communicator 
with the ability to circulate information in a way that 	is clear, efficient, and beneficial for end users.	 	
Experience	 	
12/2021 	TO 	07/2022	 	
Senior Data Analyst 	- Teamware Solutions (Client	-TCS)	. 	
Hyderabad.	 	
&bull; 	Scheduling Batch process as per the required time window which can consists of executing 
hundreds or thousands of jobs in pre	-established sequence. 	 	
&bull; 	Monitoring the job activity and look for successful completion or job failures and then log the 
job. 	 	
&bull; 	Raise	d requests that deal with incidents, changes, problems, and other services using ticketing 	
tools like ServiceNow. 	 	
&bull; 	Perform general supervision, implementing, maintaining and scheduling workloads and event	-	
based processes. 	 	
&bull; 	Performed analysis, design and im	plementation of batch processing workflows 	with	 Cisco Tidal 	
Enterprise Scheduler. 	 	
&bull; 	Using salesforce, I&rsquo;ve analyzed project objectives, created customer workflows, and 
troubleshoot errors. 	 	
&bull; 	Good knowledge on administration, creation and maintenance of calen	dars, review and 	
implementation of all IT job processing, optimization of job schedules, monitoring and reporting, 
as well as analysis of job failures. 	 	
&bull; 	Responsible for overseeing the restart and rerun of all production jobs, creating and maintaining 
accur	ate documentation, including all job dependencies, and the development and maintenance 	
of standard operation procedures. 	 	
&bull; 	Escalates problems as necessary and provides timely status until transferred or resolved. 	 	
&bull; 	Assist in developing or improving batch ope	rations best practices. Responsible for the 	
organization of workloads in the operational environment. 	 	
&bull; 	Understand impact of changes to job processing and adjust schedules modifying as necessary 
for scheduled maintenance, etc. 	 	
&bull; 	Monitor and respond to alarms	, assess impact, troubleshoot and resolve problems	, escalate to 	
subject matter experts when required	. 	
&bull; 	Responsible for changes to IT production environments, managing change control 
documentation as changes are made, manage the change control meetings and c	ommunicate 	
changes to IT services and business users who are impacted. Document all changes.

01/2019 TO 11/2021	 	
Senior Data Analyst 	- Phoenix American Sales Focus Solutions India Pvt. Ltd	. 	
Hyderabad.	 	
&bull; 	Worked as a team leader with my duties including Assigni	ng the work to the fellow team 	
members, discuss the work load with my manager and follow up with the team. 	 	
&bull; 	Oversaw day to day operations and Monitor team performance. Always provided necessary 
support to the team whenever it required my attention, complet	ed the tasks in a given time 	
frame and provided daily updates to manager at the end of day. 	 	
&bull; 	Coordinated with Overseas Clients regarding the work requirement and also provided my inputs 
to them in simplifying the work process. 	 	
&bull; 	Performed data analysis and data profiling using SQL queries. Performed DML Operations for 
Inserting, Updating, Merging and Deleting records and also worked on DDL Operations for 
Creating, Altering and Dropping records. 	 	
&bull; 	Worked on various SQL Functions &amp; S	tatements such as Select, Insert, Update, Delete, Joins, 	
Unions, Group by etc. 	 	
&bull; 	Worked on Database statements like Create Database, Drop Database, Alter Database etc.	 	
&bull; 	Worked on an ETL application called 	Informatica.	 Using the ETL tool, i have extracted dat	a from 	
source system, transformation of this source data into the required format for target system 
and finally writing the data or loading into the target system. 	 	
&bull; 	Well versed in Data Monitoring, Data warehousing and Data Management Concepts.	 	
06	/20	16	 TO 0	1/20	19	 	
Data Analyst 	- Phoenix American Sales Focus Solutions India Pvt. Ltd.	 	
Hyderabad.	 	
&bull; 	Worked on an in	-house application called Unify In which we maintain the data of individuals 	
who work as Financial Brokers and Investment Advisers  	 	
&bull; 	I Import the Data fr	om our BAs, upload it in unify, and then we analyze it for any discrepancies. 	
Their data consists of their names, office addresses, telephone numbers and the firms in which 
they were employed. I have used this application for deduping the data, merging of 	data, 	
removing the duplicate data. this data could be user name, addresses or firm names. 	 	
&bull; 	Unify is a master database of Representative information which serves as a proactive approach 
for maintaining up	-to-date registered Rep data. this application is int	ernally developed to keep 	
data current in all clients. 	 	
&bull; 	I have provided many inputs in developing the unify database to ease the data representation 
and extraction process. made recommendations towards the development of new patches for 
Unify release. 	 	
&bull; 	I h	ave served as the initial contact person for all Unify support queries. 	 	
&bull; 	I have used Jira to keep track of the assignments and issues that seldom occur in Unify or MARS. 
created dashboards for multiple projects in Jira. 	 	
&bull; 	Monitored the status of the work as	signments along with identifying the need for automation 	
process that can result in quick resolution. 	 	
&bull; 	Worked on MARS, which is a Sales and Marketing tool for the Asset Management Industry. it 
includes data visualization and analytics. 	 	
&bull; 	Performed data reco	nciliation, scrubbing, and deduping activities to ensure that our clients have 	
accurate sales and asset data. 	 	
&bull; 	My work also includes Removing corrupted data, performing final analysis to provide additional 
data screening. Post analyzing the data, sent back	 reports to clients at the end of the day.

Skills	 	
&bull; 	SQL Database	  	
&bull; 	Informatica	 	
&bull; 	Team player	 	
&bull; 	Excellent time management skills	 	
&bull; 	Conflict Management	 	
&bull; 	System administration	 &amp; Troubleshooting	 	
&bull; 	Communication and public speaking	 	
&bull; 	Data analytics	 	
&bull; 	Data 	warehousing	 	
&bull; 	Microsoft Excel	 	
Education	 	
2008	 	
High school	 - SSC	 (Sri Rama Krishna Public School)	 	
Kakinada	 	
2008	-2010	 	
Intermediate 	&ndash; MPC 	(Narayana Junior College)	 	
Kakinada	 	
2010	-2014	 	
Bachelor&rsquo;s 	&ndash; Electronics &amp; Communication 	(Pydah College of Engineering	) 	
Kakin	ada	 	
 
Activities	 	
&bull; Books	 &amp; Novels 	&bull; Yoga	 &bull; Travel	 &bull; Cricket	 &bull; Chess