Resume
Login
Email

Informatica, Oracle, PL/SQL, UNIX, PERL

Location:
Irvine, California, United States
Posted:
July 25, 2011   all resumes
Email:
sl8x75@r.postjobfree.com
Contact Info:
*******.************@*****.***


Madhuri Prathikantam
Email : sl8x75@r.postjobfree.com
Phone : 408-***-****

SUMMARY:

Over Six years of IT experience in IT/Software Industry Possessing Strong Knowledge in Data warehousing technology with skill set of Informatica Power Center, Informatica Power Exchange, also including analysis,design and development of Object Oriented Programming, implementing of application software in JAVA, J2EE,JSF,JSP, Oracle 9i/10g/11i, SQL, PL/SQL and db2.
Worked on various projects through all phases of Data Warehouse Development Life Cycle and Software Development Life Cycle including, requirement gathering, analysis, design, development, testing, performance tuning, and production support.
Extensive experience in Data warehouses with strong understanding of Dimensional Modeling, Star and Snowflake Schemas.
Has worked on Data migration and back filling of data.
Extensively worked on creating Mappings, Transformations, Sessions and Workflows to extract data from various sources and load into targets.
Experience in performance tuning of mappings, sessions and workflows including partitioning.
Experience with data cleansing issues and data profiling.
Extensively used Java transformation to implement the desired logic with in the mappings
Involved in migrating the code from Dev. environment to higher test environments and handled the change management.
Experience in translating business requests into Informatica DQ solutions
Creating technical design documents for ETL jobs which include detailed specifications for developing mapplets, mappings and workflows.
Using Sql Loader for loading flat files directly into the database tables and performance enhancement.
Writing Unix Shell scripts for preprocessing the flat files, purging the files, table data and logging to database.
Writing Perl script to execute power mart command and also to load data from source xml’s to Staging tables, to purge data from tables, to purge files from respective paths.
Developing reusable code for Mapplets, mapping parameters and variables.
Performance Optimization using Pipeline Partitioning.
Scheduling ETL Jobs using Autosys
Writing File watcher jobs to schedule the jobs and call the dependency jobs.
Extensive knowledge of Relational Database Management Systems (RDBMS).
Has good knowledge in working on OOPs Concepts.
Has good working knowledge on RSA Web-logic Server, JUnit.
Excellent communication, self-motivated, ability to manage a team and ability to work independently or within an integrated team.
Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.

SKILL SET:
Tools : Informatica PowerCenter9.0/8.X/7X, Informatica Power Exchange 8.X ,Toad,
Rapid SQL, SQL Navigator,SQL Developer, SQL*Plus, SQL* Loader,Eclipse 3.0, Oracle Warehouse Builder, Beyond Compare.
Databases : Oracle 9i/10g/11i, DB2 and MS SQL Server 2005/2008
Operating Systems : MS Windows XP/Vista/07, Unix
Languages and Misc : C,C++,[.Net],[Java],PL/SQL, MS Office, Visio and Dimensional Data
Modeling
Version Control : VSS, MKS, Perforce
Markup Languages : HTML, XML
Education : Master of Science , Osmania University, Hyderabad
Bachelor of Computers and Science, Osmania University, Hyderabad

Awards:
Excellence award from Telstra – The biggest telecommunication firm (Australia) for the IPSS project

External Certifications Completed:
PowerCenter 8 Mapping Design (Exam S)
PowerCenter 8 Advance Mapping Design (Exam U)
PowerCenter 8 Architecture and Administrator (Exam R)

Book Of knowledge documents published on Infosys Portal-Kshop:
Eliminating duplicates records using Expression Transformation
Informatica Power Center 8.6 - Performance Tuning Best Practices
Generating HTML Reports with images using JasperReports
Uploading an Image to Weblogic Portal Administration Console’s Content Management
VSS: Ability to Check-in files in the Absence of User
Internal tutorial on Wombat-3GIS

PROFESSIONAL EXPERIENCE:

ETL-Lead Informatica Developer Jan 11 – Till Date
Client: Capital Group Of Companies

Description: Capital Group Of Companies is one of the world’s largest investment management organizations with assets of around trillion USD under management. It comprises a group of investment management companies, including Capital Research and management, American Funds, Capital Bank and Trust. On the institutional side, capital manages money for pensions, governments, and other entities world wide. It also manages money for wealthy individuals and engages in private equity investments. One of its subsidiaries, Capital international, was responsible for the construction of the MSCI stock market indices.

The purpose of this project – the CISR program is a critical ITG initiative that targets the re architecture of several core investments systems, including: PA, MARS, ASM, SDS. Under CISR, the Data Management Services – Data Solutions (DMS-DS) Team will design and build new data integration application, IDH, to support the new CISR application’s data integration needs. To identify and describe RDM’s high level data integration requirements to be satisfied by the IDH for RDM Fundamental and Asset Releases.

Responsibilities:

Interacted with Business Analyst to understand the business requirements
Consulting on Interface tools and methodology.
Worked on many POC’s to get the desired requirement.
Created Data Mapping sheets which are useful to understand the column matching information while creating the mapping.
Created Visio Diagram to provide the step by step information of the logic.
Extensively worked on XML sources and different approaches to pull in the exact data.
Developed reusable transformations.
Developed transformation logic and designed various Complex Mappings which would load data from xml sources to staging tables.
Implemented Performance tuning at mapping, session level.
Optimized the queries for better performance.
Created many common components of UNIX and PERL Scripts.
UNIX script which extracts the data from source and load the staging tables for different interfaces.
Optimized the SQL queries which are used with in the scripts.
Created stored procedures to load data from staging to integration tables.
UNIX script which logs all the output and error information to database and prints the same on to console.
Created File clean-up UNIX script to purge all the un-desired files after certain period of time.
Created Table data purge script in UNIX to delete the data after certain period of time.
Created Re-cycle monitoring script which would fetch all the rejected records from the tables.
Created many Environment tables on SQL and Sybase database as part of the requirement.
Created a PERL module common component to log all the details to database.
Developed the profile file to work for various environments in the project.
Developed reusable Mapplet which loads all the header information of the XML source
Exported all the workflows and migrated to PERFORCE which acts as a repository for base lined code.
Acting as a POC to provide the status updates to the client.
Handling all Team management tasks
Testing and Implementation.

Environment: Informatica Power Center 9.0, SQL Server-2005, Sybase-15.0, UNIX- SOLARIS, PERL-5.8.4, Rapid SQL, XML SPY, Ultra Edit,Windows XP.

ETL-COE Senior Informatica Developer Jul 10 – Jan 11
Client: Union Bank of California

Description: Union Bank, N.A is a full-service commercial bank, providing a broad mix of financial services to businesses and individuals. The bank’s markets are trade finance, small business, real estate; the bank also offers investment and financial management, private services, insurance services, and global custody services. Highmark Capital Management is the bank’s investment management subsidiary. The bank’s commercial clients include communications, media, entertainment, energy, public utilities, retailing.

The purpose of this project is, this is a multi-year project involving replacement of multiple UB’s legacy retail banking applications with retail banking solution “Finacle”. The business objective is to provide UB with a retail banking system which will help them in growth path by having the ability to create customized banking products, fast deployment of such products, scalability in terms of ability to handle data and transaction volumes, faster transaction speed and reduced maintenance cost through single system maintenance.

Responsibilities:

Interacted with Business Analyst to understand the business requirements
Consulting on Interface tools and methodology.
As per the requirements provided by Finacle - Core banking system (Functional team), prepared the Interface Maps which contains the columns and data types and Transformation logic information.
Created COBOL Copy Books based on the Interface Maps prepared.
Extensively prepared Data Maps using Informatica Power Exchange for the COBOL copybooks.
The Data Maps created are used as Legacy (MainFrames) Target Tables.
Created Decode Table on Oracle database as part of implementing the decode business rules (i.e, Decode the value given by Finacle and load the corresponding value expected by Legacy)
Implemented Dynamic File Creation, which would create the empty file on MainFrames if not present.
Developed transformation logic and designed various Complex Mappings which would load Header, Detail and Trailer of a target table and Mapplets using the Designer
Developed reusable transformations, User-defined functions, onetime mappings, workflows.
Developed and Executed UNIX Scripts to run the workflows.
Exported all the workflows and migrated to MKS from where client could access the code.
Offshore/Onsite Co-ordination
Responsible for uploading all the HLDs, LLDs, Interface Maps, UTPs on to IBP Live which is a Share Point site.
Extensively worked on fixing the TOL’s –Tech-Online Tickets (defects) raised on Tech Online Portal
Was involved in handling all the Team Management related tasks.
Testing and Implementation.

Environment: Informatica Power Center 8.6, Informatica Power Exchange, Oracle 10g, UNIX, Cobol-Copy books, Mainframes Server-SYSK, MS SQL Server-MPSC-SQL93, Database-TellerDifference/naldr, Windows XP,VSAM

ETL-COE Senior Informatica Developer Jan 09 – Jun 10
Client: Wachovia Securities (now Wells Fargo Advisors)

Description: Wachovia Securities was the trade name of Wachovia Corporation's retail brokerage and institutional capital markets and investment banking subsidiaries. Following Wachovia's acquisition by Wells Fargo on December 31, 2008, the retail brokerage became Wells Fargo Advisors on May 1, 2009 and the institutional capital markets and investment banking group became Wells Fargo Securities on July 6, 2009.

The primary objective of this project is to maintain the dataware house which is used to handle the payroll of the brokers under the brokerage houses affiliated with Wachovia Securities by capturing details of the brokers, their commissions, compensations, actual pay and their eligibility to facilitate the Wachovia’s HR group to handle the payroll.

As part of ETL COE my role was to handle various projects as Informatica Tech Lead and responsible for successful deployments of projects which includes development, functional and performance testing in various test environments.

Responsibilities:

Interacted with Business Analyst to understand the business requirements. .
Designed and developed mapping, transformation logic and processes in Informatica for implementing business rules and standardization of source data from multiple systems into the data warehouse
Extensively worked with Source Analyzer, Warehouse Designer, Transformation Designer, Mapping Designer and Mapplet Designer.
Developed transformation logic and designed various Complex Mappings and Mapplets using the Designer.
Responsible for integrating data from different source systems into data marts using Informatica Power Center.
Developed mappings in Informatica to load the data from various sources using transformations like Source Qualifier, Expression, Lookup (connected and unconnected), Aggregator, Joiner, Update Strategy, Filter, and Router etc.
Created Mapplets using Mapplet Designer for reusing common business logic in various mappings.
Extensively used SQL, PL/SQL, Stored Procedure, Packages, and UNIX scripts.
Extensively managed multiple data sources including internal, external, and 3rd party source system data.
Extensively managed all technical aspects of the ETL process.
Experienced in SQL performance tuning.
Used Parameters and Variables to facilitate the reusability of code.
Developed and executed UNIX scripts.
Scheduled ETL Jobs using Autosys
Involved in Production Support and resolved production issues
Used LOAD utility for loading flat files directly into the database tables and performance enhancement.
Published one Book Of Knowledge on Eliminating duplicates records using Expression Transformation

Environment: Informatica Power Center 8.6, Db2, Power Mart, Brokerage Data Warehouse (BDW) PL/SQL, Oracle 10g, UNIX, Windows XP

ETL-COE Informatica Developer Dec 07 – Jan 09
Client: WellPoint- NextRx

Description: WellPoint is the nation’s leading health benefits company serving the needs of more than 33 million medical members nationwide. WellPoint is a Blue Cross or Blue Shield licensee in 14 states. WellPoint works to simplify the connection between Health, Care and Value. In the majority of the service areas, WellPoint does business as Anthem Blue Cross, Anthem Blue shield or Empire Blue Cross Blue Shield. WellPoint also serves the customers throughout the country as UniCare.

The purpose of this project involves movement of data (including claims, provider, eligibility, benefits, rebates and other) from ESI into the WellPoint Edward Environment in the form of data feeds. This merged data will be synchronized with various databases at WellPoint and with authorized third party vendors (Mutual Fund companies, Portfolio Managers, etc.).

Responsibilities:

Requirements Analysis
Prepared Design Documents
Developed multiple reusable transformations.
Develop onetime mappings, workflows, shell scripts and onetime executable as part of conversion project.
Analysis.
Scheduling the ETL jobs using Autosys.
Testing and Implementation.

Environment: Informatica Power Center 8.6, Db2, Oracle 10g, UNIX, Windows XP.

Senior Developer Jun 07 - Dec 07
Client: Telstra

Description: Telstra is an Australian telecommunications and media company. Telstra is the largest provider of local and long distance telephone services, mobile services, dialup, wireless, DSL and cable internet access in Australia. Telstra has faced competition since the early 1990s from Optus and a host of other smaller providers. It retains ownership of the fixed-line telephone network, as well as one of two competing pay-tv and data cable networks. Telstra outsources a significant portion of network installation and maintenance to private contractors and joint ventures such as ABB communications and STCJV. Telstra Mobile is Australia’s largest mobile telephone service providers, in terms of both subscriptions and coverage. Telstra also owns and maintains the majority of Australia’s Public telephones.

The project is a re-engineering Web application where in the framework is changed from Struts to JSF. This project has many UIs and requires analyzing the existing code and retaining only few modules code and coding for almost 12 UIs and 30 modules. My role is majorly involved in the developing IPSS portlet and Activation UIs and also coding various modules like IPSS Configuration module, IPSS Customer module.

Responsibilities:

Requirements Analysis
Existing Code Analysis
Coding the new UIs
Anchor for the PQM Report Generation
Generating the PQM Report for all the modules in the application
Performed the Unit Testing using JUNIT
Understanding the terminology and calculations to be represented on report
Giving Knowledge sharing sessions on the new areas in the project
Working with various other tracks to integrate the code
Published 3 Book of knowledge documents, “Generating HTML Reports with images using JasperReports”, “Uploading an Image to Weblogic Portal Administration Console’s Content Management”, “VSS: Ability to Check-in files in the Absence of User”.

Environment: Oracle Bea Weblogic 10.2, RSA, Java1.5, JSF, VSS, Windows XP, JUNIT, Jasper Reports

Developer Feb 07 - Jun 07
Client: Telstra

Description: Telstra is an Australian telecommunications and media company. Telstra is the largest provider of local and long distance telephone services, mobile services, dialup, wireless, DSL and cable internet access in Australia. Telstra has faced competition since the early 1990s from Optus and a host of other smaller providers. It retains ownership of the fixed-line telephone network, as well as one of two competing pay-tv and data cable networks. Telstra outsources a significant portion of network installation and maintenance to private contractors and joint ventures such as ABB communications and STCJV. Telstra Mobile is Australia’s largest mobile telephone service providers, in terms of both subscriptions and coverage. Telstra also owns and maintains the majority of Australia’s Public telephones.

The project WOMBAT-3GIS is a Network Monitoring Application developed to integrate the Wombat 3G applications with the XML solution developed. The Source has been changed from Sybase to oracle. Due to change in source from Sybase to Oracle the collector was redesigned to collect data from Oracle database. The code redesigning was made for collector, parser in such a way that the code will work for both 3G850 and 3GIS network. Testing (UTP, STP) were done for data sanity and the application was successfully deployed into production.

Responsibilities:

Requirement Analysis.
Create the DDL for the tables
Creating MViews and Views
Developing Procedure and Packagaes
Mocking the data for testing.
Testing the existing scripts
Back filling of the Data.
Anchor for the PQM Report Generation
Working with various other tracks to integrate the code.
Published one internal tutorial on Wombat-3GIS

Environment: Oracle 9i,QA4j-3.99a,TOAD, Solaris, Windows XP ,UNIX,MS-Office (Word & Excel)

Developer Jan 05 - Feb 07
Client: Raising Media

Description:
Raising media is an online social media company with a portfolio of websites in vertical search and social media space. Raising media is focused on online jobs/ recruitment, Online News, Business Consulting, Entertainment Space, E-Learning. Online Search space – With the State-of-art of vertical search technology, raising media has launched jobmixi.com, a specialized global job search engine. For the online Entertainment, at the raising media with the expertise in the social media space and the existing potential in the movie market prompted to develop an entertainment portal 16reels.com, covering the cinema, page3, lifestyle aspects. Business Consulting and Social Media Marketing are the two important and potential areas that has witnessed fast growth in the recent past. To foray and establish the presence in these areas, Raising Media has started Trizeon.com. English has always been a problem for people of non-English speaking nations in Asia, Latin America and the Middle East. Taking IELTS as a base, Raising Media has launched a portal ieltsmaster.com.

The project is on jobmixi.com and it aims at collecting and displaying all the top listed jobs from all the top websites by hitting the database when given a search with particular key word in one go. This process works on an algorithm and works with JAVA code and also works with many databases.

Responsibilities:

Design Analysis
Creating Stored Procedures
Creating DDL for the tables
Creating Views
SQL Statement to fire on the Database
Developed few mappings on Informatica Power Center 7.1
Mocking the test data
Environment: Oracle 9i, PL/SQL, MS SQL, TOAD for Oracle, Toad for DB2, JAVA, Informatica Power Center 7.1.