Systems Engineer Resume Profile

Synopsis

A dynamic professional with around 5 years of progressive experience as Database ETL developer in the Banking/Investment domain
Expertise in working with relational databases such as Oracle, SQL Server and MS Access.
Strong Data Warehousing ETL experience of using Informatica PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools Informatica Server, Repository Server manager
Designing as well as development of UI reports using Oracle Application Express.
Experience in using Automation Scheduling tools like Autosys and TWS.
Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.
Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting.

Possess knowledge of:

Big Data
Data Warehousing
Onsite-Offshore Model
Agile Methodology
Software Development Life Cycle
Worked with Business Managers, Analysts, Development, and end users to correlate Business Logic and Specifications for ETL Development
A strong motivator and team player with effective leadership, communication, decision making, problem solving and interpersonal skills, together with a bottom-line corporate focus and a results-driven attitude.
Presented with 'Excellence award' certificate for creditable performance at Infosys.

Employment Recital

Technical Skills Set

Languages : PL/SQL, T-SQL, UNIX, Perl, VB Script
Operating Systems : Windows, UNIX
Middleware/Databases : Oracle 10g/11g, MS SQL Server 2005/2008
Testing Framework : utPLSQL
ETL Tools : Informatica Power Center 9.1/9.0/8.6/8.5
Scheduling Tools : Autosys,TWS
Web Technologies : HTML, XML
Other Tools : APEX, IBM Rational Team Concert Rational ClearCase, Putty, Erwin, TOAD

Functional Skills Set

Rich exposure to the Banking/Investment Domain.
Excellent client management skills, innate ability to build strong and mutual beneficial relationships.
Result oriented, proactive professional with achievement driven experience and excellent analytical skills

Strong team builder with proven ability to motivate team members towards achieving organizational targets.

Projects Experience

Company

Confidential

Description

Project Overview:

Client acquired a major asset management company from a bank. As part of this Project, we envision to develop a NAV hub to distribute fund information NAV, AUVs and related attributes Yields Distribution to downstream system. This will help in reducing dependency on Mainframe thereby reducing its consumption. It also supports expected Global Asset Management business model.

Tools Technologies Used:

Informatica 9.1/9.0, Oracle 11g, PL/SQL,TWS scheduler, UNIX shell scripting, TOAD

Role Responsibilities:

In this project my Role was of an Individual Contributor, working as Informatica developer. The work involved the following:
Designing, development of ETL workflows using Informatica.
Created Informatica mappings with PL/SQL Procedures/Functions and triggers in T-SQL to build business rules to load data
Involved in Unit, Integration, System, and Performance testing along with bug fixing and tuning for optimal performance.
Created automated scripts to perform data cleansing and data loading.
Developing scheduling jobs on TWS scheduler.
Modified existing mappings for enhancements or any change request.
Created detailed Unit Test Document with all possible Test cases/Scripts.
Performing Code reviews and unit test log reviews for other developers.

Company

Confidential

Designation

Technology Analyst/ Senior Systems Engineer

Description

Project Overview:

Worked on two projects under different divisions:
Fixed Income Division: The Project was to enhance the portfolio management application which was being used by different Portfolio managers in making investments decision. It also managed various asset classes on which trading is done in the market, so as to provide various informative and transactional details, which was helpful in the research work.
High Income Division: The project dealt with fund groups under this division. The goal of this project was to decommission MS-Sql server and move High Income division data from it to Oracle11g and to create a common data environment so that common data can be accessed across different projects.

Tools Technologies Used:

Informatica 8.0/8.5/8.6 ,PL/SQL, T-Sql, Oracle 10g/11g, Autosys, Oracle Application Express, UNIX shell scripting, VB Perl Scripting, IBM RTC, IBM RCC

Role Responsibilities:

In this project, my role was of an Individual Contributor, which included End to End implementation of the solution. The work involved the following :
Participated in requirement analysis designing for any incoming change request.
Drafting the documents as per requirement includes creation of Technical Design Document, POC, Job Document, Operation Document and Unit Test Plans as per requirements
Development of DB objects SSP/APIs, Function/Procedure, Views, Triggers etc. , mappings/workflows using Informatica8.5/9.0 , UI reports using APEX .
Developing scheduling jobs on UNIX server using Autosys.
Engaged in writing macros using VB script.
Defect handling and Testing in DEV SIT environments utPLSQL Framework, Unit Testing, Blackbox Testing etc.
Performing peer reviews mentored new recruits for development activities.
Planned shared domain/technical knowledge within/across teams.
Organized and conducted various team building activities and events.

Company

Confidential

Designation

Systems Engineer

Description

Project Overview:

A taxation domain project dealing with automation of ITR Income Tax Returns It simplifies IT Returns through faster refunds issued and automatic intimations to the assesse

Tools Technologies Used:

Oracle 11g,Toad,PL/SQL, Erwin, Unix, Putty

Role Responsibilities:

In this project, my Role was of Database administrator. The work involved the following:
Monitoring daily database backup jobs and other recovery jobs.
Handling tablespace other storage-related/ Capacity issues.
Monitoring and handling Performance issues.
Involved in Data replication and Table maintenance etc.
Supporting the developers by providing grants, creating roles, users etc.
Assisted in Oracle 10i RAC installation

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship