Informatica, Oracle, Senior software engineer, senior systems analyst,

Andal Priyadarshini Varadarajalu

Email: ******.*@*****.*** Cell: 206-***-**** Edison, New Jersey

PROFFESSIONAL SUMMARY

• 6.5 years of IT experience with broad IT experience in all phases of project life cycle with technical emphasis in design and implementation

• Proficient in data warehousing technologies (ETL/ELT) using Informatica 8.1/8.5 and Oracle 9i/10g

• Excellent knowledge in SQL, PL/SQL, and SQL loader

• Experience in Oracle Reports Developer 6i and Oracle Warehouse Builder

• Hands on experience working on UNIX shell scripting and Weblogic (deployments)

• Strong knowledge on Leasing and Telecommunications domain

• Experience using Visual Source Safe, Rational Clear Quest, Remedy & SharePoint.

• Strong analytical, problem solving, communication and interpersonal skills

• Able to work independently; strong team player.

EDUCATION

• Bachelor of Computer Science Engineering, University of Madras, Chennai, India. Overall 83% with distinction.

TECHNICAL EXPERTISE

• Database : Oracle 9i/10g, Teradata, MySQL

• Data Warehousing : Informatica 8.1/8.5, Oracle Warehouse Builder

• Tools/Technology : Oracle Reports Developer 6i, TOAD, Ms Visio, Ms Visual

SourceSafe, Rational ClearQuest

• Domain : Leasing, Telecommunications

SIGNIFICANT ACHEIVEMENTS

• Cleared Level 1 of Oracle Certified Associate

• Received “Feather In My Cap” (Wipro) Award for contribution in ATLASMART project

• Received “Ocean's 11” (Level3 Award) for contribution in ATLASMART Project

• Received ‘Performance Award’ (AT&T) for contribution in DLC Project

• Subject topper (Mathematics) in High School & multiple College semesters

PROFESSIONAL EXPERIENCE

Device Life Cycle and OrderTrack Apr ’09 – May ‘10

Employer: Wipro Technologies

Client: AT&T, Bothell, WA

DLC and Order Track are high visibility applications used by AT&T dealers and sales personnel. Device Life Cycle (DLC) tracks AT&T devices through their lifetime and is used in processing insurance claims placed by customers. OrderTrack is used to track orders placed by customers.

Responsibilities:

• On-call Tier 2 production support for DLC and OrderTrack applications

• Responsible for monitoring high volume daily ETL loads, track job success/failure, intensive data analysis, defect fixing and performance tuning.

• Responsible for ensuring data quality, meeting SLA’s, designing solutions, task allocation and prioritization, customer interaction.

• Involves creation of Informatica mappings/ UNIX scripts/ Weblogic server activity to resolve user issues.

• Responsible for ETL and J2EE code deployment

• Responsible for Weblogic and Informatica server maintenance

• Responsible for creating production support manual & understanding documents and maintaining the SharePoint site.

Technologies : Informatica Power Center 8.5, Teradata, Oracle, Weblogic 9.2

Informatica ‘Re platform’ from Sun Solaris to IBM AIX Aug ’08 – Dec ‘08

Employer: Wipro Technologies

Client: Washington Mutual, Seattle, WA

This is a ‘re platform’ project where the Informatica ETL and UNIX code had to be migrated from Sun Solaris environment to IBM AIX

Responsibilities:

• Involved in migrating ETL code across environments from Sun Solaris platform to IBM AIX platform

• Worked with project teams in setting up UNIX and Informatica environments and handle any issues arising as result of migration from Sun to AIX

• Involved in creating scripts using Informatica provided pmcmd commands

• Provide reports to project teams based out of Informatica repository as requested

• Responsible for creating understanding documents and maintaining the SharePoint site.

Technologies : Informatica v 7 & 8 and Oracle 9i

Atlas Mart Jun ’06 – Jun ’08

Employer: Wipro Technologies

Client: Level3 Communications Inc, Broomfield, Co

Level3’s major challenge is to maintain the DQ between various inventory, order and billing systems. Atlas Mart is an integrated Mart of various OLTP (source system) layers, from which analysis is done about the usage and performance of circuits and various reports are built.

Responsibilities:

• Responsible for creating Informatica mappings and use of Oracle Stored Procedures/anonymous blocks to build the DWH

• Develop technical design documents, Co-ordinate requirements between offshore team and onsite business analysts/SME

• Responsible for code migration to PRE-UAT/UAT/PROD environments.

• Responsible for monitoring high volume daily ETL loads, intensive data analysis, defect fixing and performance tuning.

• Responsible for Quality Assurance (QA) of code delivered to client

• Responsible for ensuring data quality, meeting SLA’s, designing solutions, task allocation and prioritization to offshore team, customer interaction.

• Ensuring data quality by creating audit scripts/ job alarms, provide reports to business users as requested

• Acting as onsite coordinator and supported a team of size 5 at offshore.

• Responsible for bi-weekly releases and coordination with business users.

Technologies : Informatica 8.1.1, Oracle 9i/10g, SQL Server 2000, PL/SQL, SQL *

LOADER, SQL*Plus, TOAD, Clear Case, MS Visio, Rational ClearQuest

Unified Contract System - Batch processing and Data Warehousing Aug ’03 – Apr ‘06

Employer: Hexaware Technologies

Client: Deutsche Leasing, Bad Homburg, Germany

UCS is a reverse engineering project which involved migration of HOST system to a modern system based on Oracle9i database. For reporting purposes, Oracle Reports 6i was used and Oracle 9i stored procedures were used for batch processes.

Responsibilities:

Create ETL Mappings for daily refresh of data marts.

Generated reports using Oracle reports 6i

Developed stored procedures for background processing of UCS data

Performance tuning of queries

Preparation of Mapping/Requirement documents, Coding Unit testing, Integration Testing and Post production Support.

Automated deployment process using OMB

Technologies : Oracle Warehouse Builder, Oracle Reports Developer, SQL, PL/SQL

Fleet Information Tool - Data Mart Aug ’03 – Apr ‘06

Employer: Hexaware Technologies

Client: Deutsche Leasing, Bad Homburg, Germany

Fleet Information Tool is a data mart which provides valuable information regarding the Fleet Objects that Deutsche Leasing offers its customers.

Responsibilities:

Requirements gathering for new data mart Fleet Information Tool

ETL Mappings for daily refresh of data mart

Ensuring data quality in the warehouse

Preparation of Mapping/Requirement documents, Coding Unit testing, Integration Testing and Post production Support.

Automated deployment process using OMB

Technologies : Oracle Warehouse Builder, Oracle Reports Developer, SQL, PL/SQL

Contact this candidate