Programmer Analyst Resume

SUMMARY

11 years of Professional experience in Information Technology with extensive Knowledge in Data Warehouse ETL & Databases.
Exposure of complete Software Development Life Cycle.
Adept at effective implementation of full life cycle development of Data warehousing capabilities.
Strong in the Analysis, Design, Development, testing and Implementation of Data Warehouse Applications. Well versed with Star - Schema and Snowflake schemas for designing the Data Marts.
Extensively worked on the ETL Informatica Power Center and have good understanding of OLAP concepts. Hands on experience in writing, UNIX shell scripts, testing and implementation of stored procedures, Functions, triggers using PLSQL.
Excellent communication skills, good organizational skills, self-motivated, positive attitude, ability to work independently and co-operatively in a team.
Have done the Python Programming Certification from Edureka.
Having knowledge on Bigdata, Hadoop, Hive and Pig.
Interested and Ability to learn new tools and technologies quickly and effectively.

TECHNICAL SKILLS

Operating systems: Windows

Programming Languages: SQL, PL/SQL, UNIX, Python 2.7 and Mainframe SAS

Data Bases: DB2, Oracle and Netezza

Database utilities: TOAD, Squirrel and PL/SQL Developer

Document Processing: MS-office

ETL Tools: Informatica Power center 10x/9x

Job Control systems: UNIX shell scripting and Autosys

Data Analysis Tool: SAS Enterprise Guide

PROFESSIONAL EXPERIENCE

Programmer Analyst

Confidential

Responsibilities:

Close co-ordination with clients to gather all the business-related Information for Project and transforming the logical requirement to technical design flow and providing the estimates.
Work closely with business analysts and data modeler to understand the current system, business functionality, architecture and new requirements.
Attend the daily scrum meetings to provide the status updates on the activities with various teams like SDLC process team, Production control team and Shared systems/environment management team to coordinate and manage the ongoing Production jobs.
Performing data profiling to provide high quality of data to the business users.
Work with Database and Informatica Admins to create new objects or components and production deployment.
Conduct the Impact analysis on the existing objects for the new requirements.
Create the Technical documents and list the step by step solutions giving to the requirement or enhancements or issues in the existing legacy system.
Work with Informatica Power Center client tools Repository Manager, Designer, Workflow Manager, and Workflow Monitor to create new mappings, sessions and workflows for data extraction, mining, transformation, data sourcing, from mainframe COBOL files, flat files and tables etc.
Create Autosys jobs to schedule the ETL jobs and write UNIX shell scripts for Job scheduling, file processing and FTP scripts using UNIX.
Preparation and execution of Unit test cases and capturing the test results.
Tuning the mappings/session to boost up the performance of the jobs for large set of data.
Support for QA testing at various level and regions (Test, UAT, Performance and Production).

Technologies: Informatica 10.1, DB2, Unix

IT Analyst

Confidential

Responsibilities:

The CRM services applications show the profitability of each customer and there by assist the bank associates to manage client’s portfolios effectively.
Besides CRM services also hosts applications that talk about the performance of the associates with respect to their Lobs.
The objective of his initiative is to rewrite one of the performance Assessment Application to source data from the newly built data mart using Netezza and Informatica.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship