Data Test Cases
Resume:
Vishwanath Mallanagouda
ETL Informatica Developer
Email Id: **********@*****.***
Mobile No: +91-953*******
Profile:
Total 3.6 years of professional experience in Developing Data warehousing Components Using ETL Informatica, Unix Shell Scripting, SQL.
Having good Experience on Informatica 8.x,9.x. and Expertise in developing ETL mappings, Sessions and Workflows.
Hands-on experience in Unix Shell Scripting.
Hands on Experience in analyzing complex PL/SQL stored Procedures and writing Stored procedures
Strong knowledge on the Data warehousing concepts, ETL tools, SQL database skills and development knowledge
Having knowledge on informatica Data Quality, informatica B2B and IDR.
Knowledge on the Autosys and Scheduling the batch jobs using autosys tool.
Experience in all phases of Software development lifecycle. Followed Waterfall, Agile methodologies in software development.
Extensive hands on experience in development, maintenance and upgrade for clients process.
Proficient in analyzing and translating business requirements to technical requirements and architecture and Involved in Micro Design Preparation, Unit Test cases preparation.
Executed software projects for UK Government and Insurance industry,having good domain knowledge
Experience in Code Check in, validation and Deployment of ETL components to System testing and to production.
Having good communication and involved in the client calls for design discussion.
Professional Experience:
Feb 2012 – Till date Application Developer and Maintenance IBM India Pvt. Ltd.
Educational Summary
Degree
College
Authority
Year of Completion
%of Marks
B.E (CSE)
Sri Siddhartha Institute of Technology, Tumkur
VTU Belgaum
2011
8.38 (CGPA out of 10)
PUC
SVM College, Ilkal
PU board Karnataka
2007
72%
10 Std
JNV Kuknoor, Koppal
CBSE
2005
72%
Software Skills
Core Expertise
Informatica Power Center 8.X, 9.X. Unix shell Script.
RDBMS / Tools
Oracle SQL and DB2
Operating Systems
Windows, Vista, AIX, Solaris and Linux
Trained in
Informatica Data Replicater (IDR), Informatica Data Explorer(IDE), SAP BOXI R2.
Scheduling Tools
Autosys, Cron Jobs.
Project Details:
Project Name –Group Insurance Data Warehouse(GIDW)
April 2014 –Till date
Client –Prudential Financials
Role: Application Development
Team Size : 4
GIDW: Is responsible for extracting Data from the Different OLTP Source system in Prudential, analyzing and Loading them into Stage and then dimension tables. Where the data is feed to the other downstream system’s and also aggregation is applied for loading fact to make data available to Downstream system,business team for reporting and analysis/ decision making.
Environment: Informatica 9.5.1, AIX, DB2, IDQ, B2B.
Responsibilities :
Developed the Informatica mapping, sessions, workflows.
Developed unix shell scritps and Stored procedures.
Developed and Reused IDQ rule’s provided by Informatica corporation on the validation and standardization of source data.
Generalized the system and other code component’s and Made them reusable across other applications.
Providing Solutions and design for implementing the application
Creating the Unit test cases for the different Scenarios.
Suggesting the best informatica coding practice to team
Providing the defect fix for QA, UAT, and also Production.
Analyzing the system behavior in the Production and Providing the production defect fix’s during the warranty support.
Project Name –Banking Liasion Automation and Customer Contract (BLACC), Business Information System(BIS), Corporate Reference Data Service (CRDS)
March 2013 –March 2014
Client – Department of Work and Pension UK Government
Role: Application Development and Support
Team Size : 2
BLACC: Automates the processing of files sent between external BLS and DWP Systems.
CRDS: The CRDS informatica Batch is responsible for loading the excel files containing office details and benefit services offered at these location into a CRDS database.
BIS: BIS Applications system is a complete end to end DWBI system. This primarily deals with Labor Market data provide Management Information (MI). The set of application provide meaningful information (reporting data) to the Business users -pulling data from 4 different source system applications .
Environment: Informatica 8.6.1, solaris 10, Oracle 10g, XML Spy, SAP BOXI R2.
Responsibilities :
Supporting the Application by resolving the incidents within given SLA.
Providing the feasible solution for Incidents from both Informatica Power Center and SAP BOXI reporting End and Creating the Unit test cases for the Scenarios..
Enhancing the informatica workflows, sessions, mapping as per client requirement.
Involved in Requirement Analysis and Solution Design for the enhancement.
Creating build package for new informatica component/ Problem fix component and Deploying it.
Project Name –Universal Credit
Date - April 2012 – Feb 2013
Client – Department of Work and Pension UK Government
Role: Application Development
Team Size: 7
Universal Credit: Universal credit provides pension and benefits to UK citizens, Under this program payments Management System is one of the key component, where Informatica used to process the source files from Different sources and loaded into Database for further processing.
Universal Credit is an integrated working-age credit that will provide a basic allowance for the needs. These is to achieve through a single department- the Department for Work and Pension.
Environment: Informatica Power Center 8.X, Oracle 11g, Unix Scripting.
Responsibilities:
Involved in Requirement Analysis.i,e Gathering the Data and Analyzing the Application.
Prepared the technical design document for use cases, like ETL mapping Spec, Data mapping Sheets.
Developed the ETL informatica workflows, session and mappings for Use cases assigned to me.
Developed the core component build and design.
Involved in the coding part for the use cases, supporting unix shell scripting, deployment scripting.
Provided Defect Fixing and Code Migration.
Prepare the Unit test plans and Execute the test plan in RQM and Capturing the unit test results data.
Involved in reviewing the project related documentation & UTP's WPI forms.
Providing the support to the Testing team for execution of test cases.
Achievements:
Awarded as brick of the project since I have involved in many of the components. (May 2012 – May 2013)
One of the top Contributor for the first year as a Graduate Hire.
Received many appreciations from the Client for my analytical skills while handling the Incident.
Identified for eminence and Excellency award in IBM
Personal Information:
Name
:
Vishwanath.
Father’s Name
:
Mallanagouda.
Marital Status
:
Single
Nationality
:
Indian
Passport No
:
K3818065
Date of Birth
:
2nd July 1989
:
**********@*****.***
Contact number
:
Mailing Address
:
#82,Blockno-1,Hanchinal(K),tq-Sindhanoor,dt-Raichur,PIN-584128
Hobbies
:
Singing, Playing indoor & outdoor games, Surfing.
Declaration:
I hereby declare that the information furnished above is true to the best of my knowledge and belief.
Date: Vishwanath M
Place:
Contact this candidate