Life Insurance Project
Resume:
Akash Jain
E-mail:*************@*****.***
Mobile: +91-988*******
OBJECTIVE
To utilize my potential and capabilities to their optimum in my work, use them in widening my skills and knowledge and to establish myself as a well-managed and dynamic person.
Professional Experience
Working with CenturyLink Technologies as Software Engineer from July,2018 to till date.
Worked with Cognizant Technology Solution as programmer Analyst from May,2014 to March,2018.
6.9 years of experience in Informatica and Data warehouse.
Hands on experience on development, enhancement and Admin activities.
Hands on experience Informatica, SQL,UNIX shell script, batch script,excel macros,maestro tws tool.
Currently we are using Datalake as an source to Informatica.
Worked as a single member team for more than an year.
Excellent problem solving abilities, willingness to learn, enthusiastic and a responsible team member .
Centurylink Projects:
Project Details: project 1
CenturyLink, Inc. is an Americantelecommunications company, headquartered in Monroe, Louisiana, that provides communications and data services to residential, business, governmental, and wholesale customers in 37 states. A member of the S&P 500 index and the Fortune 500,[6] the company operates as a local exchange carrier and Internet access provider in U.S. markets and is the third-largest telecommunications company in the United States in terms of lines served, behind AT&T and Verizon.It also provides long distance service
Project
BCSS
Client
Level 3 Communication
Organization
CenturyLink Inc.
Duration
July 2018 – Till date
Team Size
11
Module:1
Environment
Tools & Technology Used
Informatica, Toad for Oracle, Putty, SQL developer, UNIX shell Scripting, MySQL, HUE and Dbeaver.
Roles and Responsibilities:
Developed mappings in Informatica as per the business requirements from scratch.
Automated Daily Environment Refresh activities and well recognized in the company.
Automated Daily status mail using Informatica, HTML, and batch script to send an email and oracle database.
Created table structures as per the required in the automation.
Did Enhancement and Analysis work as per the User Stories provided.
Well Co-ordinated with DBA team and actively participated in the Scrum call and internal team meetings.
Provided suggestions to avoid future failures and discuss those over the scrum call with on-site coordinators and team.
Cognizant Projects:
Project Details: project-1
The company was established in 1891 as the United States subsidiary of the German company Merck, which was founded in 1668 by the Merck family. Merck & Co. was nationalized by the US government during World War-I and subsequently established as an independent American company in 1917. While it operates as Merck & Co. in North America, the original Merck based in Darmstadt holds the rights to the Merck name everywhere else. Merck & Co. is the world's seventh largest pharmaceutical company by market capitalization and revenue. Its headquarters is located in New Jersey.
Merck & Co. publishes The Merck Manuals, a series of medical reference books for physicians, nurses, technicians, and veterinarians. These include the Merck Manual of Diagnosis and Therapy, the world's best-selling medical reference. The Merck Index, a compendium of chemical compounds, was formerly published by Merck & Co. before being acquired by the Royal Society of Chemistry in 2012.
Project-1
Client
Merck & Co.
Organization
Cognizant Solutions Technologies
Duration
Jan 2017 – Mar 2018
Team Size
7
Module:1
Environment
Tools & Technology Used
Informatica, Toad for Oracle, Putty, SQL Server management, UNIX shell Scripting.
Roles and Responsibilities:
Developed mappings in Informatica as per the business requirements.
Automated manual activities using Informatica tool and Unix shell scripting.
Automated Daily status mail using Informatica,HTML,batch script to send an email and oracle database.
Created table structures as per the required in the automation.
Made Changes in the mapping as per request change by client.
Provided suggestions to avoid the failure in future and discuss those over the phone with on-site coordinators and team.
Project Details:project-2
Project-2
Client
Massachusetts Mutual Life Insurance Co.
Organization
Cognizant Solutions Technologies
Duration
April 2015 – Jan 2017
Team Size
5
Module:1
Environment
Tools & Technology Used
Informatica, Toad for Oracle, Putty, SQL Server management studio, UNIX(WINSCP & PUTTY)
Roles and Responsibilities:
As an admin taken care of the code migration request from DEV to QA or QA to production environment.
Developed mappings in Informatica as per the business requirements.
Added new user and provide them relevant access
Developed and worked in Core java application to archive daily common issues.
Automated monthly schedule task using Informatica tool and batch scripting.
Automated Daily status mail using Informatica,HTML,batch script to send an email and oracle database.
Created table structures as per the required in the automation.
Single handled automation work.
Made Excel macros to do comparisons.
Enhanced mapping according to the requirements.
Provided suggestions to avoid the failure in future and discuss those in the call with on-site coordinators and team.
Project Details:project-3
Project-3
Client
The Hart Ford
Organization
Cognizant Solutions Technologies
Duration
May 2014 – April 2015
Team Size
2
Module:1
Environment
Tool:
SQL Server Integration Service, SQL Server 2008,SSIS
Project Abstract:
Multiple areas and initiatives within SI&T (Strategic Initiatives and technology) require information regarding servers and their relationships to other data. The CIIP (CTO Information Improvement Program) will create one aggregate source for server and other asset-related data.
In our support application, the SSIS (SQL Server Integration services) packages are executed and in turn it updates the data warehouse and also the end user SharePoint list.
The reports are generated from the warehouse and send to the users which consists of the below key data points.
ROLES AND RESPONSIBILITIES:
Performed ETL Process using SSIS Tool by creating the package.
Build up the connections for different sources.
Test the connections.
Extract the Data from different sources.
Applying the transformations in the data.
Check the data for validation in the SQL server studio.
Build the connection for destination.
Send the data to the destination.
Execute the package.
Certification
Completed core java: level 0 ccp.
Completed ITIL fundamentals.
Completed Oracle SQL Fundamental 11g
Completed classical hadoop training from katalyst global solutions.
Education Qualification
Examination
Institution / University
Class
Percentage
Year
CDAC
Sunbeam Institute of Information Technology
Distinction
75%
2013-14
B.E.
IP University, GPMCE, Delhi
Distinction
76%
2009-13
H.S.C.
Mother Teresa Public School, Delhi
First Class
64.5%
2007-08
S.S.C.
St. Joseph’s Academy, Delhi
Distinction
75%
2005-06
Personal Profile
Name
Akash Jain
Date of birth
13th Oct 1990
Sex
Male
Father’s Name
Sumat Kumar Jain
Nationality
Indian
Permanent Address
P-6, East Azad Nagar, Street No.-1, Krishna Nagar, New Delhi-110051
*************@*****.***
Contact Numbers
Hobbies
Listening Music, Playing Guitar, Cooking, solve 3 by 3 Rubik cube.
Declaration: The above information is correct to the best of my knowledge.
Akash Jain place: Delhi
Contact this candidate