Bhavya N

Handling Incident Management Process - Operations for Customer M/S Onmobile Pvt

Ltd

Bangalore, Karnataka

aczo4t@r.postjobfree.com - 91-953*******

Seeking a challenging position in an industry that needs innovation, creativity, dedication and enable me to work in a challenging and fast paced environment, leveraging my current knowledge with many learning opportunities. To work for growth of the organization and to grow with the organization. Willing to relocate: Anywhere

WORK EXPERIENCE

ETL/Informatica Job(Fresher)

Developmental Tools - Bangalore, Karnataka - March 2014 to Present Projects Undertaken:

Project 1: Banking Management System

Developmental Tools:

• Front End: Microsoft Visual Basic

• Back End: Microsoft Sql Server

Project 2: Online Insurance Management System

Language Specification:

• Language: C#

• DataBase: MS SQL Server 2005

• Server Scripting: ASP.Net

• Browser: Internet Explore

I hereby declare that the above written particulars are to the best of my knowledge and belief. Installation and qualification Coordinator Executive Wipro Limited - March 2014 to June 2015

Job Responsibilities:

• Handling Implementation / Installation Calls AND Qualification of Incidents

Aligning engineers to Site On-time.

Maintaining the Real-time assigning/updation & Closure in SAP CRM.

Product Installation report sign off from Customer.

Co-ordinating with the HO Installation team and Update database.

Identifying gaps in the auto-disqualified cases in system logged by customer.

Verification of documents like Purchase Order/ Annual Maintenance Contract/ Warranty in SAP MM /SD module (Material Management Module & Service Delivery Module)

Interact with Internal /External stake holders to verify the authenticity of the serial number/ product Logged.

Quarterly report documented with the National service delivery Manager. SKILLS

Informatica, Sql,basic Unix

CERTIFICATIONS/LICENSES

Informatica

ADDITIONAL INFORMATION

Skills:

• Undergone the Informatica power center 8.6 tool training for 6 months.

• Informatica Mapping, Mapplets and creating session.

• Good knowledge on SQL queries, familiarity with business evaluation and development strategies

• Well knowledge on Informatica flat files, xml file, data marts, data warehouse concepts.

• Expert in analytical thinking and problem solving ability

• Strong command over written and spoken English and Spanish

• Ability to learn and use new techniques and applications

• Software languages like Informatica powercenter 8.6, SQL, Unix, C, C++, Core Java, HTML Technical Skills:

Successfully completed certified Oracle-Informatica course in Quest IT solutions For 4 Months

• Complete knowledge on Informatica Power centre 8.x and Oracle 10g Database. I had learnt different phases of Data Warehouse development lifecycle from designing, development, testing and implementation.

• Various Mapping Designing for extract data from relational tables and flat files. Good knowledge on Transformations of leading the data into Oracle database. E.g. Source Qualifier, Joiner transformation, Update Strategy, Lookup transformation, Rank transformations, Expressions, Aggregator and Sequence Generator transformations. Good knowledge on SQL creating the tables, primary key, null values. Project 1:

Title:Telecom Warehouse

Environment:Informatics 8.6, Oracle 10g, Flat Files Description:

Hybrid Subscription Warehouse is value-added service (VAS) company which offered content management, mobile advertising, ring tones, phone backup, voice portals and voice SMS.We receives log files for each Telecom Operator based on new subscribers list, new subscriptions for various VAS services on Daily Basis which needs to be reformatted as per business logic and later will be loaded to Dimension and fact tables. These data warehouse is mainly for purpose of data analysis, report generation based on various operators, various subscriptions during a span of time and helpful in decision making. Source will be flat files which are logs generated on daily basis based on calls routed to server. Roles and Responsibilities:

Using Informatica Designer to create complex mappings using different transformations to transfer the data to the Data Warehouse.

Extensively used unconnected Lookups, Filter, Router, Aggregator, Expression, Update strategy for mapping Development.

Implemented Scd2 for the Telecom Warehouse project