Data Sales

Kishore

SUMMARY OF EXPERIENCE:

. Around * years of strong data warehousing experience using Informatica

PowerCenter with extensive experience in designing the Tasks,

Workflows, Mappings, Mapplets and scheduling the Workflows/sessions

using Informatica PowerCenter 8.6/8.1/7.1/6.2/5.1, Power Mart

6.2/5.1/5.0 and Power exchange/Power connect.

. Design and Development experience in Data Quality and Data Analysis

using Informatica IDQ 8.x.

. Strong business understanding knowledge of Financial,

Telecommunications, Pharmaceutical and inventory management projects.

. 5 years of experience in Cognos, Business Objects 6.1a/5.1.2/4.1, Web

Intelligence v6/2.6/2.5, Broadcast Agent, Power Builder and Crystal

Reports.

. 5 Years experience in Unix Shell Scripting, PERL Scripting.

. 5 years experience on various SQL Editors such as TOAD, SQL Plus, BTEQ

and Query Analyzer and other utilities SQL*Plus, SQL*Loader.

. 6 years experience in OLTP/OLAP System Study, Analysis and E-R

modeling, developing Database Schemas like Star schema and Snowflake

schema (Fact Tables, Dimension Tables) used in relational, dimensional

and multidimensional modeling.

. Experience in loading data into Data marts using Informatica

PowerCenter ETL.

. Extensive experience in creation of ETL Mappings and Transformations

using Informatica PowerCenter to move data from multiple sources into

target area using complex transformations like Expressions, Routers,

Lookups, Source Qualifiers, Aggregators, Filters, Joiners.

. Experience in integration of data sources like Oracle, DB2,TeraData,

COBOL, MQ, SQL Server, Flat Files.

. Expertise in Data cleansing, Stored procedures, Triggers and necessary

test plans to ensure the successful execution of the data loading

processes

. Hands-on experience on Informatica PowerCenter PWX connectors for

Mainframe VSAM.

. Experience in MOLAP/ROLAP implementations.

. Experience with AutoSys and Control-M.

. Experience in working with Business Objects Universes & Query

development.

. Knowledge in E-commerce and Web related tools such as HTML,

JavaScript, Applets, Servlets, Java Server Pages, EJB and XML.

. Good team player with leadership abilities and excellent communication

skills

EDUCATION:

Bachelors in Science

TECHNICAL SKILLS:

Languages : C#, Java, COBOL, PERL.

Databases : Oracle 10g/9i/8i/8/7.x,Teradata,SQLServer,DB2,MS Access,

Sybase.

ETL : Informatica Power center 8.6/7.1/6.2/5.1,PowerExchange 8.0,

Informatica Data Quality (IDQ) 8.x,

Oracle Warehouse Builder & SQL*Loader,

Toad 7.6

Reporting Tools : BusinessObjects 6.5/5.1, Cognos

8/7/6.0/5.0,Webiv6/2.5/2.6, Crystal Reports,

OracleReports2.5, PowerBuilder

Design Tools : Erwin 4.0/3.5, Oracle Designer / 2000

GUI : Developer/2000, Visual Basic

Internet Tools : HTML, JavaScript, VBScript, JSP, XML, ASP

Scheduling Tools : Autosys, Control-M

Other Tools : Quality Center, VSS and Test Director

0S :

Windows(NT,2000,2003,XP,Vista,7),Linux(RedHat,Fedora),UNIX(SunSolaris,Linux)

PROFESSIONAL EXPERIENCE:

Societe Generale, NJ

Nov' 09 to Till Now

Informatica PowerCenter Developer

Societe Generale Corporate and Investment Banking is the 3rd largest

corporate and investment bank in the euro zone by net banking income. SGCIB

serves corporate, financial institutions and investors in over 45 countries

across Europe, the Americas and Asia. This project is designed to process

various feeds coming from back office system OLTP Data and load into TLDB

database and then to datamarts for reporting. This Project is designed to

improve financial and management reporting efficiency, standardize

processes, controls and policies for Finance and Technology and provide

Societe Generale with an Oracle Application consolidation of world-wide

results. Informatica PowerCenter is used to perform all ETL operations.

PowerBuilder application Control Panel is used to view the exceptions and

errors raised during load time.

Responsibilities:

. Developed mappings in Informatica PowerCenter to load the data from

various sources using transformations like Source Qualifier,

Expression, Lookup (connected and unconnected), Aggregator, Update

Strategy, Filter, Router etc.

. Created parameter files in Informatica PowerCenter and

passed them to Informatica PowerCenter Tasks.

. Tuned Informatica PowerCenter mappings for better Performance.

. Translated business requirements to Informatica PowerCenter

Mappings.

. Responsible for identifying reusable logic to build several Mapplets

which would be used in several mappings.

. Created mappings to extract and de-normalize(flatten) data from XML

files using multiple joiners with Informatica PowerCenter.

. Incorporated IDQ plans into Informatica using the integration plug in.

. Created IDQ Plans in Informatica data quality work bench.

. Developed strategies for Incremental data extractions as well data

migration to load into the Teradata.

. Worked with various stored procedures to populate data to summary

tables.

. Created the transformation routines to transform and load the data.

. Extensively used TOAD to create target tables and accessed data.

. Worked closely with the end users and Business Analysts to

understand the business and develop the transformation logic to be

used in Informatica PowerCenter.

. Used Teradata, Oracle and DB2 for Planning Sales data, did weekly

aggregations by store and sku; summing quantities, sales, returns,cancels and open sales. This work used Informatica Pushdown

optimisation and ELT with SQL overrides.

. Designed and documented validation rules, error handling routines and

testing strategies for the mappings.

. Modified bunch of Sybase stored procedures that perform income

calculations.

. Writing queries and stored procedures in PL/SQL to fetch data from the

OLTP system and executed at regular intervals of time.

. Extracted using Informatica *.x and then loaded into Teradata.

Sourced Oracle, Teradata and AS400/RPG and COBOL data.

. Development of an automated process for loading the data into the base

tables in EDW (for ETL) using FastLoad, MultiLoad, BTEQ utilities of

Teradata.

. Extensively used control-m scheduler to schedule informatica

workflows.

. Developed processes for automation of loading data using parameter

driven sessions for batch schedule processes, verification and re-

conciliation of data stored in several different source systems.

. Used data code interface to PERL using PERL & Informatica PowerCenter

APIs.

. Experience with Informatica Power Exchange in Creating Data Maps,

Extracting (Incremental) CDC data from Mainframe sources, Exporting

Data Maps to the Repository and Importing Mainframe source files to

shared folders.

. Created advanced external procedures to test PERL functionality.

. Worked with analysts and data source systems experts to map

requirements to ETL code.

. Responsible for preparing developed Test Plan, Test Procedures and

Test Cases.

. Written UNIX Korn shell scripts along with Control M for scheduling

the sessions and workflows.

. Monitoring the Data Quality, Generating weekly/monthly/yearly

statistics reports on production processes - success / failure rates

for causal analysis as maintenance part and Enhancing exiting

production ETL scripts.

. Developed Test Plans and written Test Cases to cover overall quality

assurance testing.

Environment: Informatica PowerCenter 8.6/8.1,Informatica IDQ

8.x,Informatica Power Exchange 8.0, TOAD for Oracle, Oracle10g/11g, SQL

Server2005/2008, Erwin 4.0, DB2, DataFlux, Teradata, Business Objects XI,

Power Builder, Sun Solaris 8.0, Shell Scripting.

Barclays NY

Oct' 08 to Nov' 09

Informatica PowerCenter Developer

Barclays Bank is a global financial services provider, engaged in retail

and commercial banking, credit cards, investment banking, wealth management

and investment management services all over the world. With a vast,

international reach, Barclays offers innovative products and services to

meet the needs of its diverse base of customers and clients.

Project: ADIR- Application Deployment and Information Renewal

As a branch application, Barclays was using an old Database. To update

their bank clients with the fast and easy to handle application, they came

up with Application Deployment and Information Renewal (ADIR) system built

in framework. The purpose of this project was to provide an application

which creates and maintains customers' (Personal, Premier and Business

Customers) account in Barclays and provide different products like Saving,

Money Management and loans.This application uses Oracle database.

Responsibilities:

. Master Test plan and certification plan preparation.

. Created Test Scripts by analyzing the Business requirements and

system Requirements of the Application.

. Coming up with RTM and Estimates based on the Functional

requirements.

. Writing the functional scenarios / test cases, setting up of test

environment and test execution.

. Allocating work to onsite team members, reviewing of the work done

by them and sending the status reports.

. Extensively used control-m scheduler to schedule informatica

workflows.

. Defect Tracking and reporting.

. Production validation of the webpages, domain and URL redirections

in production environment.

. Involved in data base validation using complex SQL and PL/SQL.

. Involved in Data Quality for source, target and metadata in DB2 and

oracle.

. Developed strategies for Incremental data extractions as well data

migration to load into the Teradata.

. Worked closely with Application Architects, Business Analysts, and

Project Managers to create used cases.

. Used to test the mainframe where we used to have typical data and

large amount of financial transaction processing during ETL

process.

. Development of an automated process for loading the data into the

base tables in EDW (for ETL) using FastLoad, MultiLoad, BTEQ

utilities of Teradata

. Worked on Informatica dubbing tool to verify the target load.

. Worked on performance testing of ETL process, data migration and

database performance after the target load.

. Tested application at mainframe level in UNIX environment.

. Used Teradata, Oracle and DB2 for Planning Sales data, did weekly

aggregations by store and sku; summing quantities, sales, returns,cancels and open sales. This work used Informatica Pushdown

optimisation and ELT with SQL overrides.

. Developed various test cases of the Reporting side verify the data

from business Object.

. Worked on Manual Performance testing of database after the load and

before the load.

. Worked in Agile environment and familiarized with the AGILE

terminology such as Iterations, Sprint Review, Backlog (User

Stories), Acceptance Criteria, Story Check-ins, Impediments.

. Functional testing the new developments/enhancements and Micro

Strategy Report's Testing.

. Wrote SQL queries to perform Database Testing in SQL server,Oracle

for the Common Processing System Account Management Module and

micro strategy test reports.

. Extracted using Informatica *.x and then loaded into Teradata.

Sourced Oracle, Teradata and AS400/RPG and COBOL data.

. Tested the different application portals that have been developed

for different groups of users.

. Used Test Director to generate Bug Reports and documented the same.

. Developed test scripts for Acceptance test, Maintenance test and

Regression tests and executed them.

. Regular interaction with developers to report and give input

various problems and issues to them as Sr. QA.

. Involved in System Integration, Business integration, performance

testing and production support.

. Participated in designs Sessions and Application Walk Through.

Environment: UNIX, Windows XP, Informatica PowerCenter 8.6/8.1,Informatica

IDQ 8.x,Informatica Power Exchange 8.0, Business Object,QC VB Script,Perl

scripting, Teradata, DB2,Oracle, SQL Server2005/2008, Work Station/2000,

QTP 9.2, Test director, Quality center,Load Runner.

Merrill Lynch, NJ

Oct'07 to Oct'08

Informatica Developer

The Merrill Lynch FGI ("Finance Globalization Initiative") Project centers

on consolidating the current Oracle Applications environments to single,

global instance of Oracle Applications. In the Old state, Merrill Lynch

maintains 9 instances of the Oracle Applications to support the day-to-day

operations of the firm. The FGI Project is designed to improve financial

and management reporting efficiency, standardize processes, controls and

policies for Finance and Technology and provide Merrill Lynch with an

Oracle Application consolidation of world-wide results. Informatica

PowerCenter is used to perform all ETL operations.

Responsibilities:

. Teamed together with client resources to design the to-be

processes, applying standards and facilitating the industry best

practices.

. Implementation of best practice integration methods based on

Informatica PowerCenter framework.

. Responsible for the Design, Analysis & implementation of the

Interface Gateway for a global gateway process to handle multiple

feeds from several different regions of Merrill Lynch Europe, Asia-

Pac rim, Australia & North America.

. Responsible for mapping and transforming existing feeds into the

new data structures and standards utilizing Router, Lookups

(Connected, Unconnected), Expression, Normalizer, Update strategy &

stored procedure transformation.

. Responsible for identifying reusable logic to build several

Mapplets, utilizing shared folders to incorporate them as

shortcuts, which would be used in several mappings.

. Responsible for developing several complex mappings for processing

the feeds, re-defined existing process to accommodate batch

schedule-using Worklets and developed E-Mail Tasks in the Workflow

Manager for sending successful or failure messages.

. Scheduled several jobs using Autosys tool, creation of Autosys

jils, changing job definition & handling scheduling issues.

. Developed processes for automation of loading data to multiple

instances using worklets, parameter driven sessions for batch

schedule of processes, verification and re-conciliation of data

stored in several different source systems.

. Involved in developing several UNIX Korn shell scripts for

performing validations.

. Designed relational data model for facilitating data loads to

custom table in RDR involving target load order and constraint

based loading, created several views for discoverer reports.

. Involved in writing several stored procedures & PL/SQL programs GL

interfaces built.

. Provided automation of the mentioned process for loading data into

several different instances.

. Created Test cases by taking input from Business Analysts and

Technical Manager.

. Tested the feeds regarding the functionality and Performance

manually.

. Validated the feed processing in different stages like File Watcher

conditions, PRE_ETL, ETL, POST_ETL and Oracle Apps Import/Post

processes.

. Created parameter files in Informatica PowerCenter and passed them

to Informatica PowerCenter Tasks.

. Executed Informatica PowerCenter Workflows individually and

validated the data.

. Execution of Test plan, Implementation Plans & identified areas for

process improvement of workflows, mappings in Informatica

PowerCenter.

Environment: Informatica Power Center 7.1, Sybase, Oracle 9i, TOAD,

Autosys, Business Objects

6.5., Korn Shell Scripting (KSH)

Reliance Communications, Hyderabad, India Mar'05 to Jul'07

ETL / Informatica Developer

Reliance Communications is a brand of telecommunication services in India.

This Project is basically developed for Reliance Communications for

building a datamart and OLAP reports for order management, strategic

testing and tactical call center/customer relationship Management. This

data mart stores historical information about Local, Long Distance, Voice

Mail, and Pager Services. This system extracts data from order management

system database (OLTP).

Responsibilities:

. Extracted Data from Different Sources by using Informatica.

. Extensively used Informatica client tools Source Analyzer, Warehouse

designer, Mapping designer and Mapplet Designer.

. Created set of reusable transformations and Mapplets.

. Extracted data from different sources of databases. Created staging

area to cleanse the data and validated the data.

. Designed and developed complex Aggregate, expression, filter, join,

Router, Lookup and Update transformation rules.

. Developed schedules to automate the update processes and Informatica

sessions and batches.

. Analyze, design, construct and implement the ETL jobs using

Informatica.

. Developed mappings/Transformations/mapplets by using mapping designer,

transformation developer and mapplet designer in Informatica Power

Center 6.1.

. Developed Shell scripts to setup runtime environment, and to run

stored procedures, packages to populate the data in staging tables.

. Used PMCMD commands to start, stop and ping server from UNIX and

created UNIX Shell scripts to automate the activities.

. Created Users, user groups, database connections and managed user

privileges using supervisor.

Environment: Informatica PowerCenter 5.1.1, Oracle 8i, MS SQL SERVER 2000,

SQL, PL/SQL, SQL*Loader, UNIX Shell Script, TOAD 7.6 for Oracle.

CITY BANK, Mumbai, India

May'03 to Feb '05

Database Programmer

CITY Bank offers a wide range of banking products and financial

services to corporate and retail customers through a variety of delivery

channels and affiliates in the areas of investment banking, life and non-

life insurance, venture capital and asset management. Designed and modified

various applications using Oracle and Developer 2000 (Forms, Reports).

Developed various forms and reports for departments such as; quality

control, warehouse and finance. This includes developing the user

requested forms for data entry for the end users and its respective reports

for managerial view using Developer 2000.

Responsibilities:

. Created database objects including tables, indexes, roles, clusters,

sequence and privileges.

. Involved in Unit testing, Integration testing and Load testing of

the interface.

. Involved in documenting the modifications and intended

functionalities of the interface.

. Calculated and monitored size and space for tables, clusters and

indexes.

. Created and maintained triggers, packages, functions and procedures.

. Helped in creating technical specifications by mapping the interface

tables with the base tables.

. Helped Project Lead to develop various reports as needed by

management.

Environment: Oracle 8i, SQL*Plus, PL / SQL, Windows 2000.

Contact this candidate