AISHWARYA N

CAREER SUMMARY:

• Technically sophisticated professional with 5 years of IT experience in Analysis of Business Intelligence solutions using Data Warehousing/ ETL.

• 5 Years of experience in Informatica PowerCenter 9.6, 10.2, Teradata and Oracle database.

• Hands on Experience using query tools Teradata SQL assistant and TOAD.

• Informatica Assisted in building the ETL source to Target specification documents by understanding the business requirements.

• Worked on multiple projects involving creation and enhancing the Mappings and Transformations in Informatica capability to integrate the data.

• Experienced in Agile Methodology.

• Having Proficient UNIX knowledge.

• Performed job scheduling and monitoring using ESP and Control M.

• Highly motivated team player, quick learner with analytical and problem solving skills. EDUCATION:

Degree /

Course

College / University

Year of

passing

Percentage

B.E-ECE GKM College of Engineering and Technology

2016 79%

XII Zion Matriculation Hr. Sec. School 2012 88%

X Zion Matriculation Hr. Sec. School 2010 84%

TECHNICAL SKILLS:

Technology Tools

ETL Tools Informatica PowerCenter 9.1,10.1, 10.2 and DataStage Reporting Tool Cognos

Database SQL, Oracle 10g/11g and Teradata

Programming Language C, C++, C#,SQL

Operating System Windows and Unix

Scheduling Tools ESP and Tidal

Other Tools Putty, WinSCP,CA Harvest Software(For SQL execution) WORK EXPERIENCE

Company Name Start Date End Date Designation

Cognizant technology Solution- Chennai Feb 2017 Dec 2018 Programmer analyst M1 Dynamics - Dubai March 2019 July 2021 Software engineer Organization : M1 Dynamics, Dubai.

Domain : Finance

Duration : March 2019 – July 2021

Responsibilities:

Maintaining Financial Data of M1 Group of company .Implementing SAPB1 for Finance Module. Worked on Data Extraction from multiple source system and on Data Migration. Hands on Experience on Data Integration with the Business User. Developed Workflows, reports for the organization.

PROJECT EXPERIENCE :

Project 2:

Organization : Cognizant Technology Solutions, Chennai. Domain : Financial Data Warehouse (FDW)

Client : Johnson & Johnson, USA

Duration : March 2018 – DEC 2018

Responsibilities:

• Managing Financial Datawarehouse and Concur Application in regions including North America, Asia Pacific, Latin America,Europe, the Middle East and Africa

(EMEA)

• Designed multiple custom workflows using Informatica tool to extract data, perform business defined transformations and load the processed data in to data warehouse which then flows to downstream applications.

• Data Analysis and generating monthly reports using Cognos.

• Monitoring the production jobs and updating the business user and team via Status mail communication and Status call.

• Incase of production job failure, analysis and find the root cause and involve respective team to resolve the issue

• Communication with Business user and other team member to resolve the issue. Project 1:

Organization : Cognizant Technology Solutions, Chennai. Domain : Facets Application

Client : Cigna Insurance, USA.

Duration : Feb 2017 – March 2018

Responsibilities:

• Extracting data from multiple sources like flat files and Oracle and transforming, cleansing, validating data and loading into final Destination

• Extensively worked in data Extraction, Transformation and Loading from source to target system using Integration Services.

• Creating production jobs and scheduling the jobs in job scheduler.

• Business will create ticket in case of issues in producion data. Analysis the ticket by referring Oracle,informatica mapping and unix script.

• Hands on experience in handling critical task related to business application and resolving it within SLA.

PERSONAL DETAILS:

Date of Birth : 6th September 1994

Sex : Female

Nationality : Indian

Mobile : +91-955*******

Email : adqw9e@r.postjobfree.com

I hereby declare that all the above said information is true to the best of my knowledge. Aishwarya

Contact this candidate