Informatica developer

Tustin, CA *****

**********@*****.***

LAKSHMI SUBRAMANIAM

PROFILE

Over 5 years of professional experience in Analysis, Design, Development, Testing and Support of ETL projects using Business Intelligence tools – Informatica and Talend, in the Banking domain. To pursue a career where I can apply my knowledge, acquire new skills and work as a team to achieve growth for organization and self.

EXPERIENCE

Senior Software Engineer, Tiruven Inc.

Jan 2017 – Till date

Senior Software Engineer, Larsen & Toubro Infotech Ltd.

June 2014-Nov 2015

Senior Systems Engineer, Infosys Ltd.

July 2013 – Apr 2014

Systems Engineer, Infosys Ltd.

Oct 2010 – June 2013

PROJECTS

Project #1

Title : Enterprise Credit Risk Information System

Client : Bank of America

Role : Systems Engineer

Environment : Talend, Informatica, UNIX shell scripting, Teradata, Autosys

Roles & Responsibilities:

Worked independently on a module to design and establish the movement of data from a legacy system to a new proposed system.

Provided inputs to prepare estimates for my project module.

Analyzed Informatica mappings and coded equivalent mappings on Talend.

Created a data model for the proposed module which received many appreciations from the client and was included in the Project Design documents.

Individually prepared the ETL low level design documents and test cases for my project module.

Involved in Coding, Unit Testing and System Integration phases.

Actively participated in the production release process.

Communicated and worked alongside onsite leads, managers and client contractors on a regular basis and presented defects report and weekly status reports for my module.

Project #2

Title : Campaign Marketing Project Initiative

Client : Bank of America

Role : Systems Engineer

Environment : Informatica, UNIX shell scripting, Teradata, Autosys

Responsibilities:

Individually created the ETL low level design and test case documents for the project.

Developed mappings in Informatica to load the data from various sources using various transformations, into target (Teradata) database.

Actively involved in discussions to analyze and review source to target mapping documents.

Created Autosys jobs using shell scripts - to create, schedule, monitor and send the messages in case of process success/failures.

Created UNIX shell scripts for the scheduling of the Informatica jobs and file handling.

Performed unit testing and systems integration testing

Inducted and mentored new recruits for the team.

Reviewed peer code and documentation and ensured that all deliverables adhered to quality and standard regulations.

Performed the role of Configuration Controller for the team by maintaining the Local Access Network.

Maintained project related documents such as Requirement Traceability documents, Configuration Management (CM) Plan and other team related documents.

Performed audits to maintain the security specifications required by the bank and prepared Audit Reports.

Project #3

Title : Statements Integration and Optimization Project Reporting

Client : Bank of America

Role : Senior Systems Engineer

Environment : Informatica, Teradata, MSSQL, Autosys

Responsibilities:

Attended requirements and design meetings, review and analysis of requirements and design documentation.

Reviewed Business Requirements Documents and the Technical Specification documents.

Conducted discussions and meetings with technical architects to understand the application and the overall functionality of the system.

Actively participated in discussions for the project estimates.

Developed test conditions and test scenarios at which the application was thoroughly tested according to Business Requirements.

Created the ETL low level design documents for the project.

Developed mappings in Informatica to load the data from various sources – flat files, Teradata, into target Teradata database.

Created Autosys jobs using shell scripts - to create, schedule, monitor and send the messages in case of process success/failures.

Created UNIX shell scripts for the scheduling of the Informatica jobs and file handling.

Co-ordinated communication with the onsite team to track all tasks to closure.

Performed peer code review and ensured that all deliverables adhered to quality and standard regulations.

Involved in the co-ordination of production release process.

Prepared and presented the defects report.

Prepared and presented the Weekly Status Reports.

Project #4

Title : CITI Know Your Customer

Client : Citibank

Role : Senior Software Engineer

Environment : Informatica, Teradata, MSSQL, Autosys

Responsibilities:

Involved in coordinating with the development team to keep the application updated and running successfully.

Co-ordinated with the file sourcing team to manage files for the downstream teams to work on.

Involved in the fixes of production bugs and minor enhancements.

Involved in the co-ordination of production release process for CR and other fixes.

Prepared and presented Weekly Status Reports and Defect Reports.

TECHNICAL

SKILLS

Operating Systems: Windows, Unix

ETL tools: Informatica, Talend

Database: Microsoft SQL, Teradata

Scheduling tool: Autosys

Windows tools: MS Office - Microsoft Word, Excel, Visio, Powerpoint

EDUCATION

Bachelor of Engineering - Computer Science Engineering, Anna University Chennai, 2010

CERTIFICATION

National Stock Exchange of India - Certification in Financial Markets: A beginners’ module

Microsoft SQL Server 2008, Implementation and Maintenance

ACHIEVEMENTS

Received a performance excellence award (in Infosys).

Won the good practice paper award and received client appreciations for creating a working data model (to establish a relationship between control tables) in the first project (in Infosys).

Contact this candidate