SHRUTHIKA GR

Ph: 636-***-**** Email: acv36j@r.postjobfree.com

Professional Summary

Having 9 months of Experience with design, development and ETL (Informatica Power Center 8x 9x), RDBMS, OLTP, OLAP and data warehousing Concepts.

Have 5 years of Experience on MSI technology System Documentation, End-User support and Requirements gathering.

Having Expertise Experience in creating Mappings, Mapplets and transformations.

Possess good understanding of Data Warehouse Methodologies and RDBMS concepts.

Extensive experience in Extraction, Transformation, Loading (ETL) data from various Sources into Data Warehouses using Informatica Power Center, SQL & UNIX.

An effective and vivid communicator with excellent relationship & interpersonal skills.

Strong analytical, problem solving & organizational abilities. Possess a flexible & detail oriented attitude.

Trained on SCCM 2007 by certified professional.

Experience in Microsoft Application Virtualization (APP-V) 5.0

Technical Skills

Operating Systems

Windows XP, Windows 7, Unix, Windows Server 2008

Technologies

ETL Tool (Informatica Power Center 8x 9x)

Database

Oracle 10g 11g, SQL SERVER.

Packages and Tools

Informatica Power Center 8x 9x, Oracle 10g.

BIPM System Environment

Informatica Power Center 8.6 9.1 9.5 9.6, Oracle 10g 11g

Deployment tools

SCCM 2007, SCCM 2012

Sequencing tool

App – V 5.0

Virtualization Tools:

VMware 8.0 and Microsoft Virtual PC 2004

Education

Bachelors of Engineering

R.V.College of Engineering, Bangalore, India

Professional Experience

Client

MG TECHNO SOFT (Trainee)

Duration

06/2014 – 03/2015

Role

ETL Developer

Responsibilities:

Analyse the mapping specification to understand the business logic.

Mainly involved in ETL development and testing.

Analysed the Source and Target databases to understand the business.

Created the mappings using some transformations like Source qualifier, Expression, Filter, Aggregator, Joiner, Sequence Generator, Update strategy, lookup, Router Transformations to load the data into DWH according to business logic.

Involved in developing SQL overrides in source Qualifier according to business requirements.

The performance tuning for the developed mappings.

Created the test cases and test scenarios to test the mapping according to the business logic.

Created sessions and workflow for designed mappings.

Environment: Informatica PowerCenter 9.0, Oracle 10g.

Client

Dell (IronShore)

Duration

11/2013 – 03/2014

Role

Transitioning – Project Management

Responsibilities:

•Coordinate, facilitate and track task management activities associated with Transitioning for Desktop Engineering Services.

•Acts as key point of internal escalation for the different service area participants.

•Proactively disseminate project information such as project timeline, Datasets, access information, etc. to team members and clients.

•Convey and/or define clear, reasonable, and mutually agreed upon project expectations to team members and clients.

•Provides status on schedule and main issues on a regular basis.

•Logs the Outstanding Items and managed prompt resolution of issues from the Service Provider.

•Schedule and host internal and Client weekly meetings to discuss the current status, updates and Action items.

Environment: MS Office, MS Project, Excel, Lync

Client

Dell (Enterprise Holdings)

Duration

04/2013 – 10/2013

Role

Application Packager

Responsibilities:

•Sequencing the application both on 32 bit and 64 bit Platform using Microsoft APP-V 5.0 SP2.

•Publishing the sequenced application to test machines for application validation.

•Documentation of the Sequenced application to online web portal for reference by other departments.

•Assistance in the development and publication of processes and standards that support the Application Packaging function.

•Created Windows Installer setup packages (.MSIs) and modified the MSIs as per the standards, using Adminstudio 12/13.0

•Used SCCM 2012 for deploying the packages.

•Document the product specifications and package details as per company standards.

Environment: Install shield, Admin Studio 12.0/13, Windows 7, V Sphere client 5.0, Dotnet Installer 3.0, SCCM 2012, App -V 5.0

Client

Saint Louis University

Duration

01/2012 – 12/2012

Role

Application Packager

Responsibilities:

•Created online chrome Package request form to generate auto spreadsheet for all the requests created.

•Gather Information on every application that needs to be packaged and deployed, including source files, install procedures, configuration specifics, test scripts, and technical dependencies such as license keys and registration information.

•Generating SCCM reports for different departments to find prospective Application for packaging.

•Documenting the package request and package completion on a shared drive.

•Performs comprehensive testing to identify compatibility issues with your current application.

•Creating SCCM Packages, Programs, Advertisements, Collections and push them to the Test Workstations.

Environment: Install shield, Admin Studio 10.0/13, Windows 7, VB Script, VMware 8.0,

Chrome shared drive. SCCM 2007

Contact this candidate