Customer Service Data

Archana Muniyappa

ETL Informatica Developer

Email: ***********@*****.***

Phone: 414-***-****

Summary:

. 7+ years of extensive experience in developing system, analysis,

design development, implementation, testing and maintenance of systems

in Informatica, Oracle Server, Microsoft SQL Server, Sybase and SAP

Crystal Reports XI in Retail and Insurance domains.

. Excellent knowledge in RDBMS concepts and constructs along with

Database Objects creation such as Tables, Indexes, Stored Procedures,

Views, User Defined Functions, Cursors and Triggers. Strong RDBMS

experience in writing, updating queries in PL/SQL, Oracle Server,

TOAD, SQL Server, RapidSQL and MySQL.

. Developed mappings in Informatica to load the data from various

sources into the Data warehouse using different transformations like

Source Qualifier, Aggregate, Lookup, Expression, Normalizer, Filter,

Router, Rank, Sequence Generator, Update Strategy and Joiner.

. Extensive experience in designing and developing complex Mappings,

Mapplets, Transformations, Workflows, Worklets, scheduling the

Workflows and sessions.

. Strong experience in using Informatica Power Centre 9.x/8.x (Debugger,

Session log file etc.) for error handling.

. Good knowledge and experience in UNIX and Windows NT/98/XP operating

systems.

. Experienced creating scripts using Shell, Perl, VB scripting

languages.

. Ample experience of Indexes, Stored Procedures, Views, User Defined

Functions, Cursors and Triggers and DML statements in Oracle and SQL

servers.

. Extensive knowledge of Kimball design principles, start and snowflake

schema in warehouse design.

. Database tuning and performance monitoring.

. Have Good understanding of ETL/Informatica standards and best

practices, Slowly Changing Dimensions (SCD1, SCD2, and SCD3).

. Deep understanding of the Data Warehousing SDLC and architecture of

ETL tools.

. Worked extensively in various kinds of queries such as Sub-Queries,

Correlated Sub-Queries, and Union Queries for Query tuning.

. Extensive experience in troubleshooting and error fixing skills in

Oracle and SQL Servers.

. Experienced in Load testing, Regression Testing, Manual Testing using

Quality Center.

. Extensive experience in implementation of the version control software

VSS, TFS.

. Experience with Data Cleansing, Data Profiling and Data analysis.

. Having remarkable experience in handling the team.

. Strong ability to interact with business users and development team.

. Experience in implementing User Accessibility Compliance for the

application.

. Demonstrated success many times under aggressive project schedules and

deadlines.

. Hardworking, enthusiastic and highly committed to the growth and

success of the organization.

Technical Skills:

Primary Skills: Informatica 9.1, Informatica 8.1, MS SQL,

Oracle PL/SQL.

Databases: Oracle 10g, Oracle 9i, SQL Server 2008, SQL

Server 2000, Sybase.

ETL Tools: Informatica 9.1, Informatica 8.1

Development Tools: Visual Studio 2005 and 2008, Toad,

Quality Centre.

Applications: RMS9, RMS13.

Programming/Scripting Languages: VB 6.0, VBScript, Shell Scripts, and

Perl Scripts.

Reporting Service: Brio Queries, SAP Crystal Report XI.

Operating Systems: UNIX, Windows NT/98/XP

Source Control Tool: Visual Source Safe, Team Foundation

Server

Scheduling tool: ControlM, Cron Tab

Environment: UNIX, Windows 2003 Server

Education:

Visvesvaraya Technological University

2007

Bachelors in Electrical and Electronics Engineering

Professional Summary

Axiom Technology Group, Inc.

October 2012 - January 2015

Sr. Consultant, Informatica Developer

Client: TMG Health Jessup, PA April

2014 - January 2015

Informatica Developer

Project Description: The purpose of Information Protection System for is to

monitor the personal information of all policy owners in Symantec server so

that the customer personal information is protected from leakage. The

Symantec DLP server uses the finger print files to monitor information

leakage. Two finger print files have to be sent to Symantec on a daily

basis, one that has PI data for clients that have any association with long

term care and the other for all other clients.

. Worked closely with business analysts in identifying the requirements

during the requirements gathering phase.

. Coordinated with both Security Master and Symantec server teams

regularly to understand the existing file system and the requirements.

. Translated business requirements into Data warehouse design which

comprised of a primary staging area and the ETL Design.

. Analyzed client data present in Sql Server and flat files in order to

come up with the Design for the staging data.

. Created the environment for Staging area which comprised of files from

Security Master.

. Created shell scripts to FTP the required files from the security

master server to IPS staging area.

. Worked extensively in Informatica Designer, Workflow Manager, and

Workflow Monitor.

. Implemented appropriate ETL mappings to extract and transform more

than 20 million client's data from various source files to meet

requirements.

. Created a series of validations on SSN, last name and DOB validation

to get the correct fingerprint file.

. The finger print files being the main feed for the DPL Symantec server

are used to check for any security breach. Created the fingerprint

files with PI information and placed it in files for the Symantec

server.

. Used ETL transformations like Source Qualifier, Expression, Filter,

Aggregator, Joiner, Union and Lookup procedure transformation to

create and load the fingerprint file.

. Wrote UNIX Shell Scripts for Informatica Pre-Session, Post-Session and

scripts for scheduling the jobs (work flows).

. Wrote batch/shell scripts for file transfer, file renaming and file

deletion for UNIX and Windows environment. Since the files from both

the IPS staging area and Symantec staging had highly confidential

client data.

. Scheduled the jobs for a nightly run using Control-M through UNIX

scripts.

. Used debugger to test the mapping and fixed the bugs.

. Extensively used Informatica Scheduler used during unit testing.

. Responsible for migrating the workflows across different environment

(Dev, Test, PROD) using Used Team Foundation Server.

. Providing support during production movement and during warranty

phase.

. Modifying the workflows and the mappings for the enhancement or bug

fix of component.

. Prepared Documents like Functional Specifications Doc, High level

Design Doc and Detailed Design Doc.

. Created and documented effective ETL Test Plans, Test Cases, Test

Scripts, Expected Results, Assumptions and Validations.

. Carried out Unit and Integration Testing to ensure the successful

execution of fingerprint file loading process.

. Analyzed Session Log files in case the session failed to resolve

errors in mapping or session configurations.

. Documented Mappings, Transformations and Informatica sessions.

Environment: Informatica 9.1, UNIX, SQL Server 2008, Team Foundation

Server.

Client: Nordstrom Inc., Seattle, WA

October 2012 - March 2014

Senior ETL Developer

Project Description: Nordstrom uses Oracle RMS (Retail Merchandising

System) for its merchandise management and supply chain logistics. This

project was the up-gradation of the RMS9 to RMS13. The project was carried

out in various stages, the first sprint included setting up the RMS batch

jobs and the item interface and the movement of all items from RMS9 to

RMS13.

. Involved in the Analysis of the two RMS versions 9 and 13 and areas

where they differed. Performed Data Migration where the relational

data is extracted from RMS9, transformed and loaded into the target

RMS 13 Oracle database without any data loss.

. Item interface migration from RMS9 to RMS13 was done using ETL

Informatica

. Created the detail design document and technical design document for

Item Interface.

. As a part of Item interface movement, all items from RMS9 were

extracted into the source staging area. Transformations to get the

RMS13 compliant Item ID and reclassification of items were included.

. SQL Override, Source Qualifier, Expression, Joiner and Sequence

Generator were the transformations used.

. Dimensional modeling of SCD2 was realized to implement items

reclassification.

. Performed data quality functions through data validation, de-

duplication, and completeness by querying backend oracle RMS9

database.

. Defined and communicated Test Plan objectives, Unit and Integration

Testing, test cases status, timelines and deliverables to all

stakeholders ensuring successful execution of project.

. Coordinated with the DBA all along during migration from RMS 9 to RMS

13.

. As a part of Batch Schedule, created a Visio which included the flow

of the entire RMS13 jobs i.e. daily, weekly, and monthly and adhoc

jobs.

. Created generic UNIX shell scripts to run the RMS13 batch jobs in

UNIX.

. Developed a tool in text pad to generate jobdocs when the input for

the fields are present in an Excel.

. Created the jobdocs in order to schedule the RMS batch in ControlM.

. As a part of understanding the functionalities of RMS13, have ample

hands-on in the creation of items, order, allocation, shipments and

receiving screens and tables of RMS13.

. Realized the Item creation in RMS13, which included the non-pack and

pack items and SKUs.

. With the items, created Purchase Orders, Order Transfers, did

Allocation, Shipped and received the item both at a warehouse and at a

store.

. Worked extensively with the following RMS13 screens, in order to be

through with their business functions, ITEMS, ORDERS, ALLOCATIONS,

SHIPMENT, and SIM etc.

. In order to move data from RMS9 to RMS13, did an in depth analysis on

the following RMS tables: ITEMS, ITEM MASTER, ORDER, ORDHEAD,

ORD_DETAIL, ALLOCATION, ALLOC_HEAD, ALLOC_DETAIL, SHIPMENTS etc.

. Gave a Knowledge Transfer to the team on the life cycle of the items

in RMS13.

.

Environment: Informatica9.1, RMS13, UNIX, Oracle 10g, TOAD, Visual Source

Safe, Visio

Infosys Technologies, India November 2007 -

September 2012

Associate Consultant, ETL Developer

Client: Nordstrom Inc., India.

November 2010 - September 2012

Informatica ETL Developer

Project Description: The cash balancing system is used to balance the cash

by end of the business Date and it will generate the various types of Daily

and monthly report for balanced cash data and unbalanced cash data and it

will feed the report data to various interface like general ledger, Loss

prevention. Cash balancing system has two inputs interface which will give

the data to the system balancing the cash. One is via. Glory file and

another one is from Day to Day customer transaction. The customer

transaction will processed through scheduled ETL jobs from staging table to

Data warehouse.

. Involved in the Analysis of Physical Data Model for ETL mapping and

the process flow diagrams.

. Created and maintained ETL documentation that supported business rules

and detailed source to target data mappings.

. Involved in creation and review of Functional requirement

specifications, High level design and Detailed design documents.

. Extracted data from various heterogeneous sources like SQL Server

2008/2012, .CSV, Excel and Text file from Client servers and through

FTP.

. Created Informatica workflows as part of the automating the process

for the Referral Process.

. Used Power Center Designer to create mappings which included a variety

of transformations, Source Qualifier, SQL Override, Expression,

Filter, Aggregator, Joiner, both Connected and Unconnected Lookup,

Rank, Normalizer and reusable maplets.

. Used Informatica Workflow Manager for creating Sessions task, Email

task and pre and post session Command tasks.

. Responsible for creating shell scripts in UNIX to run the workflow.

. Performed Unit and Integration Testing to ensure the successful

execution of ETL flow.

. Analyzed Session Log files in case the session failed to resolve

errors in mapping or session configurations.

. Extensively used Informatica Scheduler used during unit testing.

. Migrated the mappings and workflows from Development to Test and to

Production Servers using VSS.

. Implemented the ETL process by scheduling the jobs in Control-M

Scheduler.

. Handled Performance Tuning and Optimization on ETL jobs, with strong

analytical and troubleshooting skills for quick issue resolution in

large-scale production environments located globally.

. Reviewed and tested the workflows for fixing bugs if any.

. Providing support during production movement and during warranty

phase.

. Modifying the workflows and the mappings for the enhancement or bug

fix of component.

. Increased query performance by 20%, which is necessary for statistical

reporting after monitoring, tuning, and Optimizing Indexes by using

Performance Monitor and SQL Profiler. Reduced and obliterated

unnecessary joins and indexes.

Environment: Informatica9.1, SQL Server 2008\2012, Team Foundation Server

Client: Sainsbury's Supermarkets Ltd UK

November 2007 - October 2010

Informatica ETL Developer

Project Title: Sainsbury's Business Rewards

June 2008 - October 2010

Project Description: This project enables the creation of a system that

tracks customer purchases (by importing the data gathered at POS), provides

on-line access to data for Sainsbury's Customer Service Representatives,

and calculates "dividends" amounts along with other data required for

quarterly statement mailings. In addition, the system is used for marketing

trend analysis and support of other targeted customer communications. It's

a marketing system used by the Customer service representatives at

Sainsbury.

. Analyzed the requirements to identify the necessary Oracle tables that

need to be used in order to create the required VB screens.

. Created the Design documents which included a Visio showing the logic

involved in coding the screens.

. Created the unit and integration test cases and documented the same.

. Responsible for writing Oracle procedures to fetch customer profile,

coupon details, item SKU details etc. from the backend.

. Used the oracle procedures in the VB scripts in order to populated

data as per business requirements in front end screens.

. Created the VB front end screens Member Profile Change, Courtesy

Coupons, Coupon Redemption, Coupon Letters, Member Exceptions, ReIssue

Statements, Customer Business Development Program, Maintain Rewards,

Maintain SKUs and Subclasses.

. Involved in unit and integration testing and recorded the results.

. Developed the above Marketing screens using PL/SQL stored procedures

and VB scripting.

. Developed the VB based interface to print coupon letters for rewards

customers.

. Responsible for the deployment of the code in production environment.

. Responsible in maintaining all the client deliverables as per version

using VSS.

Environment: Windows 2003 Server, VB 6.0, VBScript, Toad, Oracle 9i, Visual

Source Safe.

Project Title: Sainsbury's Rewards Reporting- Development and Support

November 2007 - April 2008

Project Description: Sainsbury's business team use manual process of

gathering raw data from software systems like Rewards, Online Rewards

Center and Central Marketing Information System and generating business

critical reports. The project enables automation of business reports by

creating an interface between the above enterprise systems and supplying

the data for report generation, thus reducing the manual effort. The

reports that are developed as part of the project are: Associate Rewards

Enrollment Report, Online Rewards Center, Enrollment Report, Copy Print

Center Report, Ink Recycling Report, Sainsbury's Store Match Report, Sales

vs. Enrollment Report and Rewards High Frequency Transaction Report

. Responsible for complete life cycle implementation that encompassed

Business Requirement gathering, analyzing their source systems in

order to provide functionality for their reporting purposes.

. Created a Visio involving the flow of logic after going through the

requirements. Interacted with SME to accumulate knowledge about

business processes and documented those for future purposes.

. Completed the development of Copy Print Center Report, Ink Recycling

Report, Store Match Report using Oracle SQL scripting and Brio

reporting tool.

. Developed and modified the existing reports from basic Chart and

tabular to parameterized reports including Single/Multi/Boolean valued

parameters and linked reports based on new business logic.

. Successfully performed unit test and was actively involved in the code

integration testing

. Was involved in the deployment of the code.

. Responsible for performing warranty support activities.

Environment: UNIX Shell Script, Hyperion Brio, Toad, Oracle9i, Visual

Source Safe.

Contact this candidate