Developer Data

SUJITHA DEVI M

e-mail : ac8p1t@r.postjobfree.com

Mobile : 816-***-****

Career Objective

Experienced Informatica Developer accomplished at Extranet Software solutions and Squires solutions performing development activities and supported complete project life cycle for Informatica. Looking for opportunity to reestablish myself in Data Analytics’ arena after pursuing graduation in Computer Science from University of Central Missouri where I can enhance my skills and in-turn prove myself as an asset for the organization.

Professional Summary

•Informatica Developer having overall 5+ year’s industry experience in the Implementation of Data warehousing using Informatica and 10months of experience in IBM BMC Remedy tool Management v8.

•Expertise in the development of ETL (Extract, Transform, Load) processes with a good understanding of source to target data mapping, ability to define, capture Meta data and Business rules.

•Proficient in the integration of various data sources such as SQL Server, Oracle, and Flat Files.

•Created Mappings, Mapplets, reusable transformations, sessions, work lets and workflows based on technical design specification documents with Quality and always adhered to the established standard practices.

•Implemented various Data Transformations using Slowly Changing Dimensions.

•Scheduled batch jobs for workflows using PM commands and cron techniques in Unix.

•Intensive Knowledge on Data Warehousing concepts like Star Schema modeling, Snowflake Schema modeling, Dimensions and Fact tables.

•Knowledge on efficient Sql queries and performance tuning in database.

•Experience of migrating Informatica objects from one environment to other.

Experience Summary

(Feb 2018 – Present)

Graduate Assistant Student worker at University of Central Missouri

(Jan 2015 – July 2017)

Application Developer

Squires Solution, Hyderabad, India

(Aug 2012 – Nov 2014)

Application Developer

Extranet Software Solutions, India

Technical Competencies/Skill Set

ETL Tool

: Informatica Power Center 8.x,9.x

RDBMS

: Oracle 10g/11g, SQL, PL/SQL

Operating System

: Windows environment, UNIX and Linux

IDE/Tool

: Toad, SQL Developer

Ticketing Tool

: Remedy v7.1, Remedy v8.1

Big Data

: Hadoop, Hive & Spark

Analytic Tools

: Python, R

Scholastic Profile

•Currently doing Masters in Computer science at University of Central Missouri from Jan 2018 to till date.

•Completed level II certification on Big data( Feb 2015-April2015)

•Graduate in Bachelor of Engineering (2007-2011) at JNTUKakinada University.

Project 3: Santander Bank

Company

: Squires Solutions

Project/Client

: Santander Bank, UK

Duration

: Jan 2015 – July 2017

Role

: Informatica developer

Role and Responsibilities

•Developed and supported the extraction, transformation and load process (ETL) for the Data Warehouse from heterogeneous source systems such as Oracle, flat files, etc. using Informatica Power center 9.1.

•Create and enhance Mappings based on Business requirement to load data from Source system into the target system.

•Extensively worked on developing and debugging mappings, Mapplets, sessions and workflows.

•Worked on creating Unit Test Cases for mapping and code reviews.

•Worked with PMCMD to interact with Informatica Server from command mode and execute the Shell scripts.

•Improving the performance of monthly reports.

•Participated in weekly status meetings, and conducting internal and external reviews as well as formal walkthroughs among various teams, and documenting the proceedings Production Support post go-live.

Project 2: Lloyds Banking Group-BI support

Company

: Extranet software solutions

Project/Client

: Lloyds Banking Group- BI Support

Role

: DEVELOPER

Duration

: June 2013 to Nov 2014

Roles and Responsibilities

•Understanding the business requirements and prepare the technical specification document using the function specification document provided by the Client team

•Extensively used Transformations like Router, Aggregator, Joiner, Expression and Lookup, Update strategy and Sequence generator and Filter.

•Created Informatica Mappings, Sessions including Command tasks like Event Wait, Event Raise, and Timer and assignment workflows on business requirements.

•Doing System Testing and coordinating UAT with other vendor.

•Bridge triaging with customer and other stake holders.

•Implemented complex transformations and mappings.

•Responsible for ETL design, development, testing and review of code along with support in documents like Unit test case and technical handover documents.

•Used SQL override to perform certain tasks essential for the business.

•Usage of Constraint-based loading to load Target tables.

•Worked on bug fixes on existing Informatica Mappings to produce correct output.

•Managing Files in UNIX and Used FTP to transfer the files between UNIX and Windows.

Project 1: Tier II Unilever support applications

Company

:

Extranet Software Solutions

Title

:

Application Production support Tier-II

Client

:

Unilever, USA

Role

:

Technical Analyst

Duration

:

Aug 2012 to May 2013.

Description

Tier-II is the name of the list of support applications for Unilever.

Roles & Responsibilities

•Provided Support for 18 applications in Production arena. Worked on BMC Remedy tool ticket management and delivered solutions to users on time.

•Production activities in Business objects, Kronos, Cass and other applications as major part of supported list of applications.

•Interacted with users directly to collect required information for analysis and provided on-time resolutions for low and medium priority issues.

•Created RFC's for code migration and change of code whenever required.

•Worked on Unilever Solar3 project for Data migration activities.

•Created knowledge transition and activities repository.

Environment: BMC REMEDY TOOLv8, Sql server2008, MS Access 2007.

Contact this candidate