Ashish Jain Email and Phone Number
•Tech Lead and Business Consultant with 10+ year of experience for a Canadian / US Based Life Insurance Company and Retail company.• Strong technical expertise in Business intelligence and analytics and Database applications• Expertise in requirement elicitation, analyzing and documenting business requirements and developing Business Requirement Specifications/Documents.• Oracle PL SQL Professional having 10+ Years of experience in Data Analysis, Tableau, Requirement Gathering, System Analysis & Design and Coding• Development and maintenance of high-performance data warehouse which processes high volume of real time data• Experience in Migration Projects (Data Center Migration, Azure migration, VDI, Citrix, LAN)• Knowledge of ETL concepts, Implementation, Design and best practices• Proficient in Retail and Banking domain• Worked on large data sets and extracted useful information out of it.• Good knowledge of analyzing the purchasing habits of customers and projecting various trends from that information• Expertise in analytics, transition and client interaction along with the understanding of business requirement concepts.• Rich experience in working with financial reporting feed's• Possess experience in creation of Data Extraction, TRANSFORMATION and LOADING rule• Work with Architect to create Data Models as well as ER Diagrams• Proficient in managing and leading cross-cultural and cross-functional teams to maximize productivity.• Leading and managing a team of onsite developers and offshore developers in an application maintenance of a Life Insurance Policy Administration application• Excellent analytical, logical and programming skills• Excellent in team coordination• Attention to detail and ability to learn new technologies and skills quickly• Experienced in delivering solutions using Agile methodology• Experienced in using Jira (Atlassian) and Rally Software (Broadcom)• IT Service Management experience with ServiceNow ITSM
Infosys
View- Website:
- infosys.com
- Employees:
- 217514
-
Technology LeadInfosys Oct 2021 - PresentJaipur, Rajasthan, IndiaInternal Policy Admin McCamish System for US Insurance FirmMcCamish is an internal Policy admin system used by internal US Insurance firm employees to issue any policy (both variable and retail).It also has various products under which a policy could be issued and various plans to be picked and various funds in which one can invest.My BSA responsibilities include performing data analysis, translating business requirements into system requirements, managing Kanban board on Atlassian Jira Software, coordinate triage calls with the dev team and business partners.Working directly with business stakeholders and technical experts from various teams.Maintenance and development of this system and launching various products as well as statements and migrating it from CGI to IBM data center and to Azure platform and ESP to CA workload.Translate the business requirements into functional requirements, data requirements and a modelling approach.Leading the team of developers and production support, work with peers, support and customers to meet client needs. Work as SME with peer group for the application that I support.Additionally handling BSA responsibilities for the application with the knowledge gained from working on the application.
-
Technology AnalystInfosys Jun 2016 - Sep 2021Toronto, Canada AreaInternal Policy Admin McCamish System for US Insurance FirmMcCamish is an internal Policy admin system used by internal US Insurance firm employees to issue any policy (both variable and retail).It also has various products under which a policy could be issued and various plans to be picked and various funds in which one can invest.My BSA responsibilities include performing data analysis, translating business requirements into system requirements, managing Kanban board on Atlassian Jira Software, coordinate triage calls with the dev team and business partners.Working directly with business stakeholders and technical experts from various teams.Maintenance and development of this system and launching various products as well as statements and migrating it from CGI to IBM data center and to Azure platform and ESP to CA workload.Translate the business requirements into functional requirements, data requirements and a modelling approach.Leading the team of developers and production support, work with peers, support and customers to meet client needs. Work as SME with peer group for the application that I support.Additionally handling BSA responsibilities for the application with the knowledge gained from working on the application.Development Centre of Excellence for Canadian banking and InsuranceThe project consisted of building and maintaining the whole database of Canadian bank and build new reports and applications/ services for Bank’s clients, internal use on various technologies to make the day-to-day work in bank easier for employees and clients and to establish a support and offshoring model for application development and maintenance.
-
Senior System EngineerInfosys Dec 2014 - Jun 2016Jaipur Area, IndiaProject - FATCA Tax Consolidation Reports, ICM, Fraud & Risk RatingManulife Bank is a Canadian Bank and in Canada there are various tax reforms changes which happened recently in last few years. So in order to facilitate the new changes and also helping the business in understanding the various scenarios involved, we were asked to generate reports and implement the tax calculations logic.ICM – Internal Compensation Module: Advisors bring business for the Manulife bank and in order to reward them so they remain motivated and bring more business this program was started.Fraud and Risk Rating: With the today's growing technology the fraud cases have increased drastically. So in order to have a control over that fraud and risk rating program was started in which each customer is assigned a risk category score which is checked every time before providing any service to that client.o Responsibilities: Estimation Business requirement elicitation (Functional/Non-Functional) High & low level Design Development of core tables and data flow design Generating reports out of the system based on various scenarios Review of various deliverables prepared by the teamo Tools & Technologies: SQL Developer, Open Edge, DB Visualizer, Tableau, JIRA, Confluence, Tortoise SVN, CA workloado Team Size: 4
-
System EngineerInfosys Apr 2014 - Nov 2014Thiruvananthapuram Area, IndiaProject : Customer Profile Attribution & Return Data Mart BuildingIn order to make Nordstrom websites more user friendly, Business came up with a new approach to show each user his top 10 brands per gender which he usually purchases. So requirement was to find out each customer’s purchase and browsing pattern and come up with a final table which can be directly used in the front end to reflect the requirement.Return Data Mart is a project where we link each transaction with its corresponding return ( if happened ) and the reason for return and also with the help of that we can view the returns done by each customer and the reason of return so that we could minimize the returns and increase our sales by giving them proper service.o Responsibilities: Involved in walkthrough of Requirements, Functional and Technical Specifications Analyzing the new changes and understanding the scenarios Actively participated in all phases of SDLC Business requirement elicitation (Functional/Non-Functional) High & low level Design Development of complete new tables and flow and make it work in parallel with existing flows, which involved the Customer, email, phone, address, transaction and other small flows Review of various deliverables prepared by the team Analyse the data and generated various reports to help the marketing BIO’so Tools & Technologies: Teradata 14, Wherescape RED, Toad, Tableau, Control-M,Unixo Team Size: 10
-
System EngineerInfosys Sep 2013 - Mar 2014Thiruvananthapuram Area, IndiaProject: Loyalty Rewards PointIn order to support on-going customer-centric initiatives, Nordstrom planned to add a new source to house Beauty Loyalty data. This would require identifying the loyal customers and give them loyalty points on the basis of their purchase. This data would be provided to MDM and to CKW. We have to make the changes in CKW to accept the Loyalty feed from MDM and propagate it downstream.o Responsibilities: Involved in walkthrough of Requirements, Functional and Technical Specifications Accept the Loyalty data from MDM and propagate the same in CKW Modify the purchase history interface to handle the Loyalty related changes Propagate the Loyalty data from MDM and SODS to CKW Customer Data Mart Code refactoring of existing code. Generation of various reports to analyse the effectiveness of Beauty Loyalty programo Tools & Technologies: Toad, Oralce PL SQL, Tableau, Control-Mo Team Size: 7
-
System EngineerInfosys Dec 2012 - Aug 2013Thiruvananthapuram Area, IndiaProject: Production Support for the Real Time Teradata Powered SystemThis includes support and maintenance of Database powered by Teradata which is fed real time by multiple sources maintaining Sales/Customer/Enterprise/Retail data .This also involved Coding, Code Reviews, Testing, Production abort fixes, Production Break Fixes for various modules.o Responsibilities: Review the production code and issues assigned & suggest solutions, fixes and workarounds and implement them keeping all the stakeholders informed. Manage the incident process to ensure issues are recorded, tracked, resolved, and follow ups are done in a timely manner. Coordination and reviews for Break fix activities and testing. Deployment and release management in production Interact and Co-ordinate with internal Development teams and various support teams in case of Production issues. Maintaining the production server load and code tuning.o Tools & Technologies: Teradata14, Wherescape RED, Control-M, Teradata Viewpointo Team Size: 15
-
System EngineerInfosys Jun 2012 - Dec 2012Thiruvananthapuram Area, IndiaProject: CKW Book OF WorkBook of work project involves complete development cycle for various Service requests which are raised for different scenarios of maintenance, automation and development of programs used to maintain and analyse data in Customer Data warehouse. The project was developed using ‘Agile’ methodology.o Responsibilities: Development of Underwriting rating module Extensive interaction with client for requirement clarification. Involved in walkthrough of Requirements, Functional and Technical Specifications Analysing the new changes and understanding the scenarios Actively participated in all phases of SDLC Business requirement elicitation (Functional/Non-Functional) High & low level Designo Tools & Technologies: Toad, Control-M, UNIXo Team Size: 12
-
Technical TrainingInfosys Dec 2011 - Jun 2012Mysuru Area, India• Underwent training in Infosys Technologies Limited, Mysore from December 2011 – June 2012. Stream training in ASP .NET.• Generic training in Java , C and basics of RDBMS and UNIX in Infosys Technologies Limited, Mysore.
Ashish Jain Skills
Ashish Jain Education Details
-
Government Engineering CollegeCse
Frequently Asked Questions about Ashish Jain
What company does Ashish Jain work for?
Ashish Jain works for Infosys
What is Ashish Jain's role at the current company?
Ashish Jain's current role is Technology Lead Infosys | BusinessConsultant Insurance & Retail Domain | Datawarehousing | DB Technologies.
What schools did Ashish Jain attend?
Ashish Jain attended Government Engineering College.
What skills is Ashish Jain known for?
Ashish Jain has skills like Oracle, Tableau, Data Warehousing, Data Analysis, Oracle Sql Developer, Pl/sql, Teradata, Retail Sales, Business Analysis, Requirements Analysis, Db Visualizer, Pl Sql Developer.
Who are Ashish Jain's colleagues?
Ashish Jain's colleagues are John F, Praveen Mahale, Najma Khanam Katlagal, Nagarjuna K Arjun, Harsha R., Atul Bisht, Anurag Pandey.
Not the Ashish Jain you were looking for?
-
1americanexpress.com -
Ashish Jain
Gurgaon -
Ashish Jain
Mumbai1yahoo.com -
Ashish Jain
Delhi, India
Free Chrome Extension
Find emails, phones & company data instantly
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial