OBJECTIVE:

• I aspire to be a member of an esteemed and reputed Organization, enhance my knowledge & contribute towards the progress of the organization with sincerity of purpose, devotion to duty and determination to succeed.

TECHNICAL SKILLS

Operating Systems: Windows 2003/XP/7,Unix

Language: C,C++,Core Java, Shell scripting

Database: SQL, Oracle 10g,Oracle 11g, Toad, Netezza

ETL: ETL - Informatica 8.6, Informatica 9.1,Informatica 9.6, Informatica Data Replicator

Reporting Tool: Oracle Business Intelligence 10g, OBI Publisher

Scheduler Tool: Autosys

Other: MS-Office, MS- Word, MS-Excel, HTML, MS-Outlook, MS- PowerPoint

PROFESSIONAL EXPERIENCE

Confidential

System Analyst

Responsibilities:

• Over 7 years of Total IT experience. Out of which 6.5 years in Datawarehousing - ETL and Informatica 9.1 and 6 months on Oracle Business Intelligence 10g
• Knowledge on BI Process and Data warehouse
• Hands on experience in ETL process using ETL-Informatica for various transactions and loading data from various data sources
• Extensive experience in understating the ETL like Informatica Designer, Workflow Manager and Repository Manager.
• Knowledge on SDLC Cycle. From requirement gathering to designing, developing the mappings, testing, de bugging/Validation, scheduling the jobs, conducting
• Self-motivated and able to set effective priorities to achieve immediate & long-term goals and meet project & operational deadlines
• Good functional & technical experience in Manufacturing and Marketing Domains
• Strongly initiative, creative and able to learn new technologies, organized and efficient with excellent Interpersonal Communication Skills, capability to work under pressure and a good team player

Confidential

Senior ETL Developer

Responsibilities:

• Designed the ETL processes using Informatica tool to load data from various source systems (flat files, xml and database) into the target Oracle 11g database
• Applying transformation rules with various transformations like Joiner, Aggregate, Expression, Filter, update Strategy and Lookup’s which are required for Data extraction, Cleansing, loading into OLAP database as per the business Requirements.
• Developed complex SQL queries and designed Informatica Mappings to load the data into warehouse
• Used Autosys to create, schedule and monitor the jobs and send the messages in case of process failures
• Testing - unit testing & integration testing & End-to-End testing.
• Responsible for communicating Client manager and server hosting/Operation support vendors in case of production load failures

Confidential

Senior ETL Developer

Responsibilities:

• Working on the business requirements and converting it into technical design.
• Designed the ETL processes using Informatica tool to load data from various source systems (flat files, xml and database) into the target Oracle 11g database
• Involved in ETL development
• Applying transformation rules with various transformations like Joiner, Aggregate, Expression, Filter, update Strategy and Lookup’s which are required for Data extraction, Cleansing, loading into OLAP database as per the business Requirements.
• Developed complex SQL queries and designed Informatica Mappings to load the data into warehouse
• Used Autosys to create, schedule and monitor the jobs and send the messages in case of process failures
• Preparing the Test cases for major Releases.
• Testing - unit testing & integration testing & End-to-End testing.
• Work on the resolution of incidents as a part of maintenance activity
• Resolution of Informatica loading errors in production
• Responsible for communicating Client manager and server hosting/Operation support vendors in case of production load failures

Confidential

ETL Developer

Responsibilities:

• Performed project estimations
• Working on the business requirements and converting it into technical design
• Designed the ETL processes using Informatica tool to load data from oracle Database/ Flat files/ XML files into the target Oracle 11 g database.
• Applying transformation rules with various transformations like Joiner, Aggregate, Expression, Filter, update Strategy and Lookup’s which are required for Data extraction, Cleansing, loading into OLAP database as per the business Requirements.
• Used Autosys to create, schedule and monitor the jobs and send the messages in case of process failures Using ETL - informatica tool developed mapping to convert business requirement into technical requirements
• Used Shell scripting to create bashes
• Responsible for executing test cases
• Testing - unit testing & integration testing & End-to-End testing.
• Resolution of Informatics loading errors in production
• Responsible for communicating Client manager and server hosting/Operation support vendors in case of production load failures
• OBIEE has been used for Reporting purpose
• Played a role of Lead ETL Developer
• Work on the resolution of incidents as a part of maintenance activity

Confidential

Business Technology Analyst

Responsibilities:

• Analyzing the Technical design document and creating the SQLs
• Designing of KPIs based on the metrics used in Cognos reports
• Thorough testing of KPIs and raising defects
• Testing of codes developed in Informatica
• Experience in performing different kinds of testing like Sanity Testing, Functional Testing, Integration Testing, Re-Testing and Regression Testing.
• Involved in executing the test cases and finding defects and verifying the fixed defects
• Assisted the team in understanding Informatica development code
• Involved in documentation of Informatica objects /Scheduled information of the jobs to help in quality testing

Confidential

Consultant

Responsibilities:

• Involved in analysis of different lines of business
• Analyzed the client requirement and Understood their business and their data workflow
• Developed complex sQl queries and designed Informatica Mappings to load the data into warehouse
• Developed the Staging tables using Source as Flat Files, RDBS Sources, SAP R3 source and loaded from source to staging and implemented incremental load logic
• Implemented Historical data maintenance logic(SCD 1 and 2 logic)
• Utilized several Transformations like Lookup, Union, Joiner, Bapi,
• Normalizer, Stored Procedure etc. for implementing the Transformation Logic in the Mappings
• Created sessions and scheduled Mappings using Power Center Workflow Monitor for the Daily Load
• Designed Error Table for easier validations
• Created Views, Partitions, Stored Procedures in Oracle 11g
• Created Batch Files, Parameter file and Parameter variables for implementing different logics
• Assisted BI Developers to fetch Reports using Cognos
• Provided modifications to existing functions initiated by Problem Report/Change Request (PRCR) and maintaining product compatibility
• Identified functional and non functional requirement
• Created unit test cases and performed the same on or before release
• Served as a single point of contact/responsibility for building and executing the technical implementation or changes in the Production Server
• Designed the Standards Document
• Assisted production support to the users
• Trained the new joinees on Informatica Tool

Confidential

OBIEE Developer

Responsibilities:

• Involved in analysis of different lines of business
• Translated Business requirements into technical requirements
• Developed OBIEE Repository (.rpd) at three layers (Physical Layer, Business Model and Presentation Layer)
• Created dimension and fact tables, logical columns, hierarchies,level based measures in Business model & mapping layer
• Configuring repository, creating/managing OBIEE Intelligent Dashboards, Answers, Delivers
• Implemented various Repository Variables and System Variables depending upon user requirements
• Utilized features like dashboard prompts, pivot tables, column selector, drill down, hierarchy