Confidential has been in the Information Technology Industry for around 12 years. She is currently working as a Solution Architect in an Atlanta based Credit Card company.
Strong Datawarehousing experience on analysis, design, development; testing, performance tuning, implementation and production support using Informatica, Netezza and Oracle.
Data Modeling experience viz. Physical and Logical Data Modeling.
Sound Knowledge on SQL, DB2, Oracle, SQL Server, Sybase databases.
Informatica Certified. It includes Informatica Mapping Design, Advanced Mapping Design & Architecture & Admin.
She has worked with major clients like Compucredit, Telephia, First Data Merchant Services, Nielsen Media Research and ITC.
Confidentialhas a Masters Degree in Computer Science 
Has credit card domain knowledge - Well Versed in Credit Card Daily Loads like FDR & TSYS file Loads, Collections Business Processes & CreditCard Payment Processes.
Won several awards – ‘Above & Beyond’ Award,’Diamond’ Awards from the Clients for Outstanding Performance.

• Analysis, Design, Develop, and Implement
  Solutions
• ETL & DB Design and Development
• Dimensional/Relational Modeling
• Requirements Study and Source System Analysis
• Performance Tuning
• Production Support

TECHNICAL SKILLS 
Technical Skills : Data Warehouse Architecture, Design & Development
ETL Tools : Informatica PowerCenter (8.x,7.x,6.x)
OLAP : Microstratergy V7.2
Databases :Oracle 8i, SQL Server 2000, Sybase V11.x, DB2 UDB 7.2, Teradata, Netezza.
Languages : SQL, PL/SQL, Java, JDBC, Java Servlets, EJB, JSP, XML, HTML, ASP, VB Script, Java Script, C, Python & shell scripting
App/Web Servers : BEA Web Logic 5.1, Microsoft IIS
Others : PowerBuilder, VisualBasic

Professional Experience

Confidential, Atlanta Mar’05 – Till Date 
Solution Architect for
Infrastructure & Collections Business Units
Informatica Admin & Lead

ROLES AND RESPONSIBILITIES IN THE PROJECT:

• Work on the business requirements to come up with an End to End solution.
• Provide the Logical model & work with the DBAs in finalizing the Physical model.
• Lead the Design & Development effort in implementing the technical solutions to meet business requirements.
• Identify the right Technology to be used on the projects based on the functional requirements.
• Provide Solution for the Production Issues & work with various groups in fixing it.
• Responsible for Code Reviews. Work with the QA team in identifying the Test Cases & also review of the test results.
• Work with various groups in implementing the identified technical solution.
• Work with the Client’s program managers in estimating effort, preparation of project plan, scheduling tasks, conducting task reviews based on the requirements and reporting to the client on the status. Also, work closely with them in the entire SDLC process.
• Support Compucredit’s UK division in activities like TSYS Daily File Loads, their Collections Processes & Monthly Loads.

Projects & Responsibilities

• FDR Loads – Designed a generalized backend system that can hold cardholders information& cardholders Transaction Data coming from FDR.
• Designed to load various FDR reports to the Database for Settlements group.
• Payment Research – Designed a backend system that can hold differentkinds ofPayment information that are processed by Compucredit Payment Vendors. Designed the Front end part of it for the customer Service group that will enable them to reapply the payments to the right cardholder.
• Online Mall – Reused the system designed for Fortiva in implementinga new type of cardbookedat FDR.This is the first system in CCRT that will do the decisioning online.
• Dialer Upload to Netezza - Worked on moving the existing Oracle Processto Netezza for performance.
• Green Dot – Designed a system that will enable the Collectors to get the payment from the Customers through Green Dot
• Consumer DNS – Designed a system for storing the DO NOT SOLICITATE consumer information. The required information comes from various sources & it is captured in a centralized place so that these customers will not be marketed for any other products.
• Production Support - Work with thevarious groups in solving the issues that come up in the Critical Daily Load Process

Environment: Informatica. Oracle, Netezza, Python Scripting, Power Designer

CLIENT DESCRIPTION:

Confidential is an information and technology driven provider and direct marketer of branded credit cards and related fee-based products and services that are offered to prospective customers on an unsecured basis. CompuCredit has developed computer models that evaluate the credit and bankruptcy risks of consumers using credit bureau data and repayment history on consumer loans.

Project Title

FPA – Future Perfect Architecture

Duration

July 2003 – Feb 2005

Operating Systems

Windows, Unix

Programming Languages

Informatica 6.2,Teradata v2r5, Microstrategy 7.2

PROJECT DESCRIPTION:

Involved in consolidating/ migrating the existing Databases/ Data marts of seven identified products (viz. WAP, TABS, SMS, MMS etc.) into Teradata. The aim of the implementation is to support all the current reporting capabilities using Microstrategy, to provide an integrated operating environment and to automate many of the manual tasks which are currently used to produce, analyze and present the data. This project was nominated for Cognizant’s Technology \'Project of the Year 2004\'.

CLIENT DESCRIPTION: 
Confidential is the leading provider of essential market intelligence for the wireless industry, supporting the success of a wide range of businesses including carriers, service providers, device manufacturers and tower companies, content providers, advertising agencies and other organizations. The current Telephia architecture is supported by multiple back-end systems with data storage and reporting achieved through heterogeneous databases and reporting tools respectively. Telephia planned to implement a new, simplified architecture to support their business needs and automate all manual tasks.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

• Project Management, Design, Development
• Involved in design of the dimensional model
• Designed the ETL for loads.
• Responsible for all the deliverables. Technical Assistance to the team members.
• Developed Attributes, Facts, and Metrics & build reports in Microstratergy.
• Involved in Full Lifecycle of the project (i.e.,) both Reporting as well as ETL part of the project.
• Fully involved in the quality process of project.

TECHNOLOGIES USED IN THIS PROJECT:

Informatica V6.2, Microstrategy V7.2, Teradata V2r5

Project Title

IDS-DSS

Duration

Feb 2003 – July 2003

Operating Systems

Windows, Unix

Programming Languages

Informatica 6.1, UDB

PROJECT DESCRIPTION:

Provided FDMS with a scalable and flexible architecture to accommodate all data elements required for the reports. FDMS’s active OLTP system IDS-DSS served as source for the ETL process. ETL process moved data into intermediate staging area and in next stage of ETL, processed data were moved to IDS-DSS system. IDS-DSS system served as a base for generating reports. Cognos data mart served as another source for the IDS-DSS System. Informatica 6.1 was the tool used for ETL processing. Finally the canned reports were generated using Business Objects 5.1. Users were provided with an ad-hoc querying facility in Business Objects.

CLIENT DESCRIPTION:

Confidential is the worldwide leader in electronic payment solutions. Confidential offers a wide array of payment processing solutions including: Point-of-Sale terminal products; PC products; processing for credit, debit, stored-value and gas cards; Electronic Benefits Transfer (EBT) transactions; Business to Business (B2B), recurring payments, the TeleCheck Electronic Check Acceptance® (ECA®) service, and one-stop e-commerce solutions.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

• Source System Analysis
• Data Warehouse Design
• Setting up the Development/Testing Environment/Production Environment
• Developed mappings, mapplets using Informatica PowerCenter Designer
• ETL Design & Development for Data Migration from SQL Server to DB2
• System Testing
• Setting up the Production Environment
• Implementation
• Performance tuning of Informatica sessions and/or mappings
• Involved in fixing Production Problems and testing for its correctness.
• Fully involved in the quality process of project.

TECHNOLOGIES USED IN THIS PROJECT:

Informatica 6.1, UDB

Project Title

Galaxy Explorer

Duration

Aug 2001 - Jan 2003

Operating Systems

Windows, Unix

Programming Languages

Power Builder 6.5, Sybase 11.5 and Redbrick decision server 6.0.3

PROJECT DESCRIPTION:

Galaxy Explorer, shortly GE, is the flagship product of NMR that is used by its clients on a day-to-day basis. This is a reporting utility that can provide highly flexible reports that cater to every need of the clients. The clients makebusiness decisions out of the Reports produced by this Application based on various business criterions. This helps various advertising agencies to make decisions such as the time, duration and program for advertisements. They can get various Statistics for variety of highly complex requirements.

CLIENT DESCRIPTION:

Confidential is the world-famous TV Ratings company. Active in more than 40 countries, they offer television and radio audience measurement, print readership and custom media research services. In the United States, Nielsen Media Research provides television audience estimates for broadcast and cable networks, television stations, national syndicators, regional cable television systems, satellite providers, advertisers and advertising agencies. 
Nielsen Media Research also provides competitive advertising intelligence information through Nielsen Monitor-Plus in the U.S. and 30 other markets worldwide. Through a network of affiliates, NMR’s coverage is extended to more than 70 countries, representing 85% of the world’s advertising spending.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

• Project Management, Design, Development and client co-ordination
• Involved in fixing Production Problems, enhancements and testing.
• Responsible for all the deliverables. Technical Assistance to the team members.
• Involved in 3 of its very critical releases.
• Fully involved in the quality process of project.

TECHNOLOGIES USED IN THIS PROJECT:

Power Builder V6.5, Sybase V11.5 and Redbrick decision server V6.0.3

Project Title

Gemini

Duration

Nov 2000 - Sep 2001

Operating Systems

Windows, Unix

Programming Languages

Java, EJB and Weblogic Ver 6. Sybase 11.5

PROJECT DESCRIPTION:

This Project involves
Designing a new Web-based application and integrating the existing legacy M204 Cable and Metered Cable Psched files, as well as incorporating all Metered Template Tool (MTT) data with the exception of template maintenance. The legacy M204 Cable files includes: · System and Communities · Carriage · Tier, Pay & Multi-Subscribers · Shares and Protection times · Protection rule for cable · Advertising · Directories · Eliminate Psched and replace with a direct Sybase to DCDB interface, including CMS share channel processing. - Establish a software link to update templates based on carriage updates. · Replacing ATS as the scheduled call tracking mechanism. · Supplementing and/or replacing manual checks with software edits. · Redesigning current processes to eliminate redundancies and reduce workflow hand-offs. · Eliminating the dependency on paper cable sheets for tracking and history purposes. · Adding the capability of on-line call management to support a new workflow process. · Provide mass update capability. The project had two phases. Worked for the first phase. & was responsible for a very important module namely \'Subscribers\'. Also, took care of the database part (Sybase). Involved in the project from the Design stage. It was nominated for Cognizant’s \'Project of the Year 2001\'.

CLIENT DESCRIPTION:

Confidential is the world-famous TV Ratings company. Active in more than 40 countries, they offer television and radio audience measurement, print readership and custom media research services. In the United States, Nielsen Media Research provides television audience estimates for broadcast and cable networks, television stations, national syndicators, regional cable television systems, satellite providers, advertisers and advertising agencies. 
Nielsen Media Research also provides competitive advertising intelligence information through Nielsen Monitor-Plus in the U.S. and 30 other markets worldwide. Through a network of affiliates, NMR’s coverage is extended to more than 70 countries, representing 85% of the world’s advertising spending.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

• Java and EJB Developer.
• Development, testing of the Subscriber module.
• Developed testing scripts in JRun for unit testing.
• Developed Sybase Stored Procedures & was responsible for all the
• Database related changes.

TECHNOLOGIES USED IN THIS PROJECT:

Java, EJB and Weblogic V6. Sybase V11.5