Project Developer

Kavitha Kumarasamy

Mob: 602-***-**** E-Mail:********.**********@*****.***

SUMMARY:

• Around 7 years of IT industry experience encompassing a wide range of skill set, roles and industry verticals.

• Posses a valid H1B visa and presently located at Phoneix,Arizona for American Express Client,for Cognizant Technology Solutions.

• Hands on experience in Development and Maintenance of Data warehousing Applications using oracle, Informatica and Unix shell scripting.

• Proficient in analyzing and translating business requirements to technical requirements and architecture. Posses strong database skills, Object Oriented Programming, and development knowledge.

• Mentored on board candidates and have given transitions which involved extensive training about understanding the project, tools used in the project, issue solving and delivering the reports to clients.

• Expertise in Data warehousing concepts, Release management, data management, and also involved in upgrades like oracle 10g and Informatica 8.1 upgrade for the applications in which I was involved.

• Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals. Excellent written and verbal communication skills including experience in proposal and presentation creation.

TECHNICAL SKILLS:

• ETL Tools : Informatica 9.1,8.6,8.1.1,7.1.1

• Languages : SQL, PL/SQL, JAVA

• Database : Oracle 10g/9i/8i, DB2

• Operating Systems : Windows 2000/NT/98 and UNIX

CERTIFICATIONS:

• Informatica Certification: S – Power Center 8 Mapping Design

• Informatica Certification: U – Power Center 8 Advanced Mapping Design Certification

• Informatica Certification: R – Power Center 8 Architecture and Administration Certification

AWARDS:

Has been awarded the VERIZON ABOVE and BEYOND AWARD, for being the best performer in the project.

EDUCATIONAL SUMMARY:

B.E. in Computer Science and Engineering, Anna University, Chennai,2001-2005

PROFESSIONAL EXPERIENCE:

• Currently working with Cognizant Technology Solutions from June 28th 2010 till date and posses a valid H1B visa.

• Worked as Software Engineer at Fidelity Business Services India Pvt Ltd, from Aug 28th 2008 till June 16th 2010 and involved in the project Fidelity pricing and Cash management Services (FPCMS).

• Worked as an Analyst in Verizon Data Services, India from Dec 28th 2005 till Aug 22nd 2008.

PROJECT NAME American Express-BIDW(Busimess Intelligence Data Warehousing)

INDUSTRY Banking and Financial Services

CLIENT American Express

DURATION 3 Months(May-2012 till Date)

ROLE Technical Lead

PROJECT SPECIFIC SKILLS Informatica 9.1, UNIX Shell,Oracle

LOCATION Phoenix,ARIZONA

CLIENT DETAILS

American Express Company is a global travel, financial and network services provider. The Company has three operating segments: Travel Related Services (TRS), American Express Financial Advisors (AEFA) and American Express Bank (AEB).

TRS includes the Company's card, travel, merchant and network businesses, as well as the Travelers Check and other prepaid products and services. Through its TRS businesses, the Company offers consumers and small businesses a variety of charge and credit cards, Travelers Check and other stored value products. The Company's Corporate Card services help companies and institutions manage their travel, entertainment and purchasing expenses. TRS' global network services business focuses on partnering with third-party financial institutions that issue American Express-branded cards accepted on the Company's merchant network.

As the world's largest travel agency, the Company offers travel and related consulting services to individuals and corporations around the world.

AEFA is one of the leading financial planning companies in the United States. AEFA has over 12,000 .financial advisors nationwide and offers a wide array of products and services, including financial planning, brokerage services, mutual funds, insurance and other investment products. AEB provides banking and other financial services to wealthy individuals, financial institutions and retail customers outside the United States.

American Express Company is a diversified worldwide travel and financial services company founded in 1850. It is a leader in charge and credit cards, Travelers Cheques, travel, investment products, insurance and international and online banking.

DESCRIPTION OF THE PROJECT

American Express's Business Intelligence and Data Warehousing team was formed to fill the gap of a shared data warehousing infrastructure to cater to the growing business need to consolidate data from across the enterprise and design analytical solutions to make more informed business decisions and report accurate numbers to Wall Street. The team is primarily working on building business specific solutions for Small Business (Open & Consumer Card Services Group), Rebates and Rewards and Accounts Receivable platforms and the purpose is to give business the proper analytical tools and underlying information to make informed marketing and finance decisions.

Responsibilities:

As a Technical Lead responsible for driving the project and the responsibilities included:

• ETL Requirement Gathering and Analysis.

• Consensus and Pilot approach documentation.

• Design and Development of Informatica Mappings.

• Extensively used various active and passive transformations like Filter Transformation, Router Transformation, Expression Transformation, Source Qualifier Transformation, Joiner Transformation, and Look up Transformation, Update Strategy Transformation, Sequence Generator Transformation and Aggregator Transformation.

• Responsible for best practices like naming conventions, Performance tuning, and ErrorHandling.

• Responsible for Performance Tuning at the Source level, Target level, Mapping Level and Session Level

• Solid Expertise in using both Connected and Un connected Lookup transformations.

• Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD

• Worked with Session Logs, and Workflow Logs for Error handling and Troubleshooting in all environment

• Design and Development of Informatica Workflows

• Preparation of unit test cases,regression testing and test execution

• Peer code review.

• Coordinate with offshore team and responsible for deliverables from onsite.

PROJECT NAME

Deluxe Staff Augmentation

INDUSTRY Communication Information Media and Entertainment

CLIENT Deluxe Corporation,USA

DURATION 24 Months(June 2010 till date)

ROLE Technical Lead

PROJECT SPECIFIC SKILLS Informatica, Oracle,Unix

CLIENT DETAILS

Deluxe Corporation is one of the two largest check printers in the United States, and provides various personalized products and services to small businesses, financial institutions, and consumers. Some of the services available from Deluxe Corp are design services, website services, print marketing, promotional products, and fraud protection services.

DESCRIPTION OF THE PROJECT

Deluxe Staff Augmentation project has been developed to get the product, customer, employee and order information from the different source system and load into the DWH tables. Source systems which have been used in this project are Oracle, DB2 and flat files. Mapping are developed to load data mart tables from DWH tables. Business Object has been used as a reporting tool. Informatica has been used as ETL tool to extract data from these source systems. There are Unix shell scripts which has been used to do the task like archiving the files, validation of source file,to create the parameter file dynamically and kick off the ETL.

Deluxe Provent:

Deluxe Provent is an Embedded service at the point of Order Capture. The consumer has visibility of the addition of the service but no option is available for the consumer to decline the service. The Deluxe provent project provides the ability to allow consumers to opt in/out of the Provent service at the point of Order Capture. This involves Changes to Order Capture systems to display the opt in/out, Changes to CI Application and Change to Price Display when Consumer Opts Out.The scope of the Deluxe DW/BI project is to integrate new applications to the EDW to address all the needs of their business users.

Marketing Program_BancVue:

Marketing Program_BancVue needs modification to the Client Database (CDB) application and database to enroll new program bancvue and enable the addition of BancVue contract dates and an automated update to Asset and Deposit Size from SNL data on a quarterly basis.Also enables an automated update of FDIC and NCUA and CAMELS SCORE values from SNL data on a quarterly basis,so that Client information is accurately tracked for the BancVue Program.

Data will need to be pushed from the CDB database to Sales Reporting System (SRS) files in order to reflect these new program changes.BancVue contract dates,SNL Data and score values will be maintained in SRS and updated to CDB. Functionality to extract and utilize the new data and to do initial loads of new data.

Deluxe Consumer Internet (DCI):

Deluxe Consumer Internet (DCI) has been maintained, but not improved since its launch in the late 1990’s. Consumers are more internet shopping savvy and expect basic standards when shopping online, like accurate pricing and being able to see any special offers available to them. Deluxe needs to be able to 1) serve Deluxe FI customers who want to reorder Deluxe checks, 2) market additional products and services to the site visitors to increase the average order amount, and 3) support FI (BC) specific requests to eliminate an all or nothing situation that we have with some FIs.The 2011 FS business strategy requires to continue to transform core check offering to deliver on the following:

Double the operating income for the program Deliver a bullet proof program.Shift from a primarily fixed to variable cost structure

At the end of this project, the current DCI application will be extinguished and the new DCI Rewrite application will be on the Hybris platform and treated as a separate Storefront for the Deluxe FI consumer.

Responsibilities:

As a Lead and developer been driving this project and the responsibilities included:

• ETL Requirement Gathering and Analysis

• Design and Development of Informatica Mappings.

• Extensively used various active and passive transformations like Filter Transformation, Router Transformation, Expression Transformation, Source Qualifier Transformation, Joiner Transformation, and Look up Transformation, Update Strategy Transformation, Sequence Generator Transformation and Aggregator Transformation.

• Responsible for best practices like naming conventions, Performance tuning, and ErrorHandling.

• Responsible for Performance Tuning at the Source level, Target level, Mapping Level and Session Level

• Solid Expertise in using both Connected and Un connected Lookup transformations.

• Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD

• Worked with Session Logs, and Workflow Logs for Error handling and Troubleshooting in all environment

• Design and Development of Informatica Workflows

• Preparation of unit test cases,regression testing and test execution

• Peer code review.

• Coordinate with onsite team and taking care of all the deliverables from offshore.

SAI 2010 AND STRATEGIC ADVISORS AND GEODE FILE ARCHIVAL (FPCMS)

INDUSTRY Financial Services

CLIENT Fidelity USA

DURATION 6 months

ROLE Lead/Developer.

PROJECT SPECIFIC SKILLS Informatica,Unix Shell Scripting

DESCRIPTION OF THE PROJECT

This project involves in adding a new process to the system of archiving the daily files of GEODE and SAI subsystems of communication engine and deliver to clients to view all trades that were received by FPCMS for that day.

This also involves in various testing efforts and validation for new sub advisors that are part of the source feed. The SAI2010 project required these new sub advisors to be recognized.

Responsibility:

• Analysis on the process and designed the code development for this new processing.

• Coded in Unix Shell scripting and used DB2 tables,

• Series of regression testing and UAT testing was done as part of this project. Performing Unit Testing, Functional and Regression Testing to ensure the quality of the deliverables.

• Coordinating with the manager in giving the low-level and high-level effort required for every Change.

COMMUNICATION ENGINE DEVELOPMENT AND ENHANCEMENTS.

INDUSTRY Financial Services.

CLIENT Fidelity USA

DURATION 8 months

ROLE Module Lead/Developer

PROJECT SPECIFIC SKILLS Informatica,Unix Shell Scripting

DESCRIPTION OF THE PROJECT

Fidelity Information Services, Inc. (NYSE:FIS) is a leading provider of core processing for financial institutions, card issuer and transaction processing services, mortgage loan processing and related information products . FIS has processing and technology relationships with 31 of the top 50 global banks, including nine of the top ten. Nearly 50 percent of all U.S. residential mortgages are processed using FIS software. Headquartered in Jacksonville, Florida, FIS maintains a strong global presence, serving over 7,800 financial institutions in more than 60 countries. FIS is part of the S&P 500. FIS has also been named the #1 banking technology provider and the #2 overall technology providers in the world by American Banker and Financial Insights (FinTech 100).

This project is driven by SWIFT Standard Release 2008. All standard changes needs to be made to be in compliance with SWIFT FIN messaging standards. These changes are mandatory in order to retain the ability to send SWIFT messages through the SWIFT Network. Further, conforming to the SWIFT standard ensures high Straight through Processing (STP) even for those SWIFT formatted messages that Fidelity sends in batches to the large sub custodians through dedicated NDM transmission connections. The SWIFT Message Standards changes will be effective as of Nov 17, 2008.

Responsibility:

A Series of projects were taken up in an effort to fix the current production bugs and also to handle few scenarios which were not handled earlier in the system as part of enhancements.

• Analysis for Decimal places in REPO INTEREST Production issue.

• End of Day Script Changes to handle late files.

• Involved in taking transitions for various applications in Custody applications for level 3 supports.

• Knowledge transition on communication engine application to Custody team and documenting about Custody and its various applications.

• Involved in giving various KT Sessions and taking domain knowledge sessions too.

REPO Interest Issue:

Involved in analysis of the issue and suggested the change required from communication engine perspective and designed the code development.

Coded in informatica to handle this issue and used unix shell scripting and ctrl m for scheduling the jobs.

Performed Unit Testing, Functional and Regression Testing to ensure the quality of the deliverable.

Also estimated the size and hours required and adhered to the same for the project as part of best quality practices which was constantly reviewed.

End of Day Script Changes:

As part of enhancements, took up the end of day late file processing which involved manual processing if files were late. Involved in identifying the enhancement and developing the same so that there is no manual intervention late file processing.

Responsibility:

• Analysis on the process and designed the code development for this new processing.

• Series of regression testing and UAT testing was done as part of this project. Performing Unit Testing, Functional and Regression Testing to ensure the quality of the deliverables.

• Code demo’s and process planning with onsite managers and been part of release process.

SWIFT RELEASES 2008, FPCMS

INDUSTRY Financial Services

CLIENT Fidelity USA

DURATION 5 months

ROLE Developer

PROJECT SPECIFIC SKILLS Informatica, UNIX (Korne Shell)

DESCRIPTION OF THE PROJECT

The primary objective of the project is to comply the SWIFT messages that comes in to the system and those that are being sent out to banks to be in SWIFT standards as they are defined every year and it is mandatory to comply standards as all banks will change to SWIFT standards for transmission of any data.

Responsibility:

• The code enhancements/modification of mappings was done and units were tested and issues were fixed.

• Test the modified newly compiled mappings and check for expected results.Data matching was done against prod data for the formats.

Contribution

• Analysis on the requirement of the changes to be done depending on the SWIFT standards and rules.

• Change and re compile the mappings and Performing Unit and functional testing.

• Series of regression testing with the data and data matching were part of the SWIFT releases to ensure the changes in formats does not affect deliverable to clients,Since this is an yearly activity in order to adhere to SWIFT standards.

• Coordinating with the business analysts and team in onsite to ensure the format changes and results are valid.

NETWORK METRIC PORTAL

INDUSTRY Telecommunication

CLIENT Verizon USA

DURATION 12 months

ROLE Developer

PROJECT SPECIFIC SKILLS Oracle 10g, Informatica (7.1, & 8.1.1), Microstrategy 7.1, HP UNIX, Perl

DESCRIPTION OF THE PROJECT

Telecom is a regulated business in USA and the genesis of the project lies in the Central telecommunication Regulation act of 1996. This act opened the local telephone market for competition giving rise to the competitive local exchange carriers (CLEC). The bandwidth providers were mandated to provide service to these smaller telecom service providers who would collect their customers by offering discounts and use the bandwidth and services provided by carriers. The FCC therefore asked the Incumbent local exchange carriers (ILECs) to produce metrics validating that the CLECs were being provided same level of service as any other customers of ILECs.

The Network Metrics Portal (NMP) is an initiative to bring this data on a central platform. This entails extracting data from several existing systems feeding this data to the data warehouse, building data marts to support the reporting requirements, doing the number crunching and producing the required reports.

The purpose of this project is to develop all the given Change Control Requests (CCRs) given. The primary objective of these CCRs is to ensure that the performance and penalty calculation for Verizon is done accurately. In case of any changes in the guidelines, ensure that these are reflected in our final reports produced.

Responsibility:

• Understanding the User requirements and performing the Analysis, Design and Implementation of the Change Control Requests for each month.

• Creating UNIX scripts for automation of the processes and make the current process simpler and reducing the total man hours.

• Created Informatica Mappings to build business rules to load data using transformations like Source Qualifier, Aggregator, Expression, Joiner, Connected and Unconnected lookups, Filters and Router.

• Performing Unit Testing, Functional and Regression Testing to ensure the quality of the deliverables.

• Coordinating with the manager in giving the low-level and high-level effort required for every Change Control.

Informatica Upgrade TO 8.1.1 from 7.1

INDUSTRY Telecommunication

CLIENT Verizon (USA)

DURATION 4 MONTHS

ROLE Module Lead/Developer

PROJECT SPECIFIC SKILLS Oracle 10g, Informatica 7.1/8.1.1, UNIX, Perl

DESCRIPTION OF THE PROJECT

The purpose of this project is to upgrade the version of informatica from 7.1 to 8.1.1.This involved all changes required by the new version support to all the maps and sessions as part of the upgrade.

Responsibility:

• Validation of all the Informatica mappings and sessions involved, parameters and variables used.

• Verification of all parameter files.

• Verification and compilation of every map and session in the project EPR.

• Performance of Unit Testing, Functional and Regression Testing of the code base in 8.1.1 and comparison of data with 7.1 which is taken from production.

• Resolving environmental and performance related issues in 8.1.1 which includes certain format changes and mapping styles in 8.1.1.

• Been part of data matching and validation for EPR (Provisioning), EBI (Billing) and EOR (Ordering) sub domains.

• Fix the Issues that come out of Unit Testing.

• Involved in reviewing the Test Cases written by his peers

DataBase Views :Network Metric Portal

INDUSTRY Telecommunication

CLIENT Verizon (USA)

DURATION 6 months

ROLE Module Lead/Developer

PROJECT SPECIFIC SKILLS Oracle 8i/10g, UNIX, Informatica

DESCRIPTION OF THE PROJECT

The purpose of this project is to mask the customer information to the off shore team and as part of that scripts and procedures were modified and developed so that customer information is masked as per the requirement.

Responsibility:

• Coordinating with the on shore team for the requirement of masking customer information.

• Developing database masking standard scripts and procedures.

• Performance of Unit Testing, Functional and Regression Testing of the code base so that new code does not change the functionality of populating the tables correctly.

• As part of masking the ETL123 and ETL4 scripts were identified for automation and hence reduced manual steps as well to enhance the support maintenance.

ORACLE 10G UPGRADE

INDUSTRY Telecommunication

CLIENT Verizon (USA)

DURATION 4 months

ROLE Developer.

PROJECT SPECIFIC SKILLS Oracle 8i/10g, Informatica 7.1, Microstrategy 7.1, UNIX Shell

DESCRIPTION OF THE PROJECT

The purpose of this project is to upgrade the version of oracle from 8i to 10g. As the support of 8i is withdrawn from Oracle, the upgrade was performed. This supported in utilising the new features of Oracle 10g and hence gets a resolution for the unresolved bugs present in Oracle 8i.

Responsibility:

• Coordinating with our primary Vendor Sapient for doing the upgrade.

• Validation of all the Informatica mappings, procedures, functions and packages.

• Checking of the plan for every sql in the code base and ensure that there is no performance impact.

• Performance of Unit Testing, Functional and Regression Testing of the code base in 10g environment and comparison with 8i.

• Resolving environmental and performance related issues in 10g like Order by and table space reuse storage issues.

Networks Metric Portal East Provisioning

INDUSTRY Telecommunication

CLIENT Verizon (USA)

DURATION 6 months

ROLE Production Support/Developer

PROJECT SPECIFIC SKILLS Oracle 8i/10g, Informatica 7.1, Microstrategy,UNIX

DESCRIPTION OF THE PROJECT

The purpose of this project is to produce metrics that are required by the Business Owners and help Verizon in improving the quality and reducing the penalties that Verizon is currently paying. The reports produced for both Ilecs and Clecs are delivered to FCC to rate the performance between the two. In case of any difference in the performance levels, the penalty is given to Verizon.

Responsibility:

• Performing the loading of the data through ETL process and producing final reports and metrics.

• Involved in Production support,development, operations and testing

• Defect tracking and version control of the system.

• Solving Production Issues and finding the root cause, fixing and running the jobs manually.

• Notifying the users regarding the job failures, load completions, delay in loads and the estimated time of data availability after recovery.

• Performing enhancements for continuous improvement of the processes

• Preparing process related documents and giving knowledge sharing sessions.

Contact this candidate