SUMMARY:

• Poised to leverage technical and analytical skills as Informatica, IDQ Developer and Siebel Technical Consultant towards launching a successful career with a growth - centric organization that seeks an articulate team player committed to supporting organizational objectives
• Around 5.7 years of total experience and 2 years in Designing, Analysis and Developing Informatica Applications
• Currently working as Informatica and OBIEE developer lead for Retail project for End to End implementation and implementing Cloud applications in loyalty functionalities.
• Have good knowledge in PLSQL, SQL.
• Have basic knowledge in Hadoop, MongoDB, Nodejs, Hive, Sqoop and PIG and other eco systems.
• Have Expertise in Informatica and IDQ implementations.
• Have good domain knowledge and in Loyalty functionality.
• Have expertise in Informatica Administration.
• Have good verbal and written communication skills.
• Have good knowledge in implementing Cloud applications.

TECHNICAL SKILLS:

Skill Set: Siebel Configuration, e-Scripting, Workflows, EIM

Informatica: IDQ, Powercenter, Admin Console

Industries: Telecom, Manufacturing & High-tech, Energy-Power, Insurance, Pharmaceuticals, Call Center, Life Sciemces

Languages: SQL, jQuery, C, HTML, PLSQL,VB Script, Java Script, MongoDB

Scripting Language: Java Script, Python

Database: Oracle, Microsoft Sql Server

Tools: Siebel, Informatica

MS Office: Word, Excel, Power Point.

PROFESSIONAL EXPERIENCE:

Confidential

Team Lead

Technologies: Informatica, Siebel, IDQ, Loyalty Cloud, OBIEE Anallytics 12C, 11g

Responsibilities:

• Involved in Data migration from source to Target systems using ETL tools (End to End)
• Working on ETL’s from OLTP to OLAP migration.
• Understanding the client requirements and discussions with client on business data model
• Involved in preparing proposal documents for new projects
• Involved in functional Automation testing using java code
• Help team in understanding the data model and guide them towards the development
• Working in OBIEE rpd deployment, development and Reports development.
• Able to do complete installation and setup of informatica applications.
• Able to Debug and solve admin related and development related issues
• Worked in Complete end to end migration project in informatica Data Quality.
• Used major transformations in complex scenarios.
• Have good hands-on experience in all transformations in IDQ and Powercenter.
• Developed complex requirements using IDQ mappings.
• Worked in repository migration and upgrading the versions.
• Good knowledge in IDQ transformations, Standardizers, Identity files
• Expertise in Admin console activities
• Worked with Consolidation, match, Address doctor, Router, Mapping variables, Expression Transformations, Update Strategy, Key generator transformations, Joiner transformations etc to achieve complex business use case
• Worked in batch load and real time integration with source and target applications to avoid duplicate data.

Confidential

Siebel Consultant

Technologies: Siebel

Responsibilities:

• Data quality fixes using IDQ and SQl queries.
• Worked on End to end data migration using IDQ and informatica
• Involved in repository migration
• Involved in Data load/Data Quality issue fixes based on the requests.
• Involved in mobile application and IPAD issues for mobile clients.
• Involved in application testing and fixing the issues for users.
• Involved in SQL data loader using control and batch file.
• Involved in EIM Load and ifb files execution.
• Involved in writing macros based on the request and automations using VB script.
• Involved in running reports using DTS packages.
• Involved in PPI process regularly.
• Involved in CSW issues and writing BS based on the requirements.
• Involved in small release tasks and working on workflows, WF policies.
• Working with Assignment manager and Quote Realignment and extension process.
• Involved in Non-SRF activities and contact/Account merge process.
• Involved in Trouble shooting scripts and Workflows and Business services.
• Involved small tasks related to BI reports.

Confidential

Siebel Consultant

Technologies: Siebel

Responsibilities:

• Supported Siebel Open UI application.
• Involved in creating a BC and BO filters at the time of release happens.
• Involved in Smoke testing activities and fixed small bugs during development phase.
• Involved in raising defects and development activities.
• Involved in Data load based on the requirements
• Involved in Server management tasks and database extract for mobile clients.
• Involved in application testing and fixing the issues for users.
• Involved in SQL data loader using control and batch file.
• Involved in EIM Load and ifb files execution and position audits.
• Worked on Change Requests, Service Requests, and Incidents.
• Involved in problem management and Oracle SR issues.
• Worked with EDW informatica team and monitoring ETL tool.

Confidential

Siebel Consultant

Technologies: Siebel 8.1.1.9, Oracle 11g, Windows XP

Responsibilities:

• I had joined the project at Fresher level. In the Project I had contributed in UI level configuration like changing the layout of applet, adding or removing applets in views, arranging the views, modifying the web templates.
• Learning the things like creating BC, BO, Applet, View, IO, Pick List (static and dynamic), and Link etc.
• Configuring Link/Join, Hierarchical Pick list, Toggle Applet, Drill Down (Static and Dynamic).
• Using the BC User and Applet User properties for various Requirements.