[pic]

781-***-****

Ramesh Pannur

609-***-****

. Around 9+ years of professional consulting experience in building large

scale and high performance business intelligence, analytics and data

warehousing solutions for Banking, financial, healthcare, government,

utilities, and manufacturing industries.IBM Certified Solution Developer.

. Extensive experience in all phases of the Data Warehouse Lifecycle

involving Design, Development, Analysis and Testing of Data Warehouses

using ETL, Data Modeling, Data Migration, Data Integration and Reporting

tools on Unix and windows platforms.

. Strong knowledge of Dimensional Modeling, Star and Snowflake schema.

Designed Fact and Dimension Tables as per the reporting requirements and

ease of future enhancements. Expertise in Data Flow Diagrams, Process

Models, ER diagrams with modeling tools like ERWIN & VISIO.

. Proficiency in utilizing ETL tools of IBM Infosphere DataStage 8.5x and

MSBI (SSIS) and Informatica for developing the Data warehouse loads as

per client requirement.

. Expert in troubleshooting/debugging and improving performance at

different stages like database, workflows, mapping.

. Expertise in tuning the performance of job design in DataStage and

determining the performance bottlenecks in data warehousing, Data

Profiling and ETL architecture.

. Developed a number of Complex DS parallel and Server Jobs and Reusable

Transformations.

. Experience in integration of various data sources like SQL Server,

Oracle, Teradata, Flat files, DB2 Mainframes.

. Played significant role in various phases of project life cycle, such as

requirements analysis, functional & technical design, testing, Production

Support and implementation.

. Work Experience includes Requirement Analysis, Client interactions,

Design and Development, Testing, Quality Assurance and Implementation.

. Experience in UNIX shell scripting, CRON, FTP and file management in

various UNIX environments.

. Strong experience in complex PL/SQL packages, functions, cursors,

triggers, views, materialized views, T-SQL, DTS.

. Worked with clients/users, business analysts and technical staff to

design, develop and enhance data warehouse models, Business Intelligence

solutions, procedures and metadata for relational databases.

. Worked on Quality related tasks and faced the PQI audit ISO9001 Info

security audit

. Experience in Unit, Functional, Integration and Regression Testing.

. Enthusiastic and goal-oriented team player possessing excellent

communication, interpersonal skills and leadership capabilities with high

level of adaptability.

. Excellent skills in requirements and release management, team leadership,

project management, onsite/offsite/offshore coordination, and production

support.

Skill Sets:

ETL Tools IBM Infosphere DataStage 8.5 Data stage EE 7.5, Data

stage Parallel jobs and server 7.5/7.1Quality stage

7.5, Informatica Power centre 6.1,MSBI(SSIS)

OLAP / BI Tools Cognos, ESP IRD

OS Sun Solaris 2.x/7/8, HP-UX, IBM AIX, Unix, Linux,

Ms-DOS,

Windows ME/2000/2003/NT/XP, Exceed (Editor)

Databases Oracle (6.x/7.x/8.0/8i/9i/10g),SQL Server, Teradata,

Sybase, Informix, MS-Access, XML

Programming Skills C++, Shell Scripting (K-Shell, C-Shell), PL/SQL,

Db Tools SQL*PLUS, SQL*LOADER, SQL*NET, Quest TOAD, SQL

Navigator,

Oracle Enterprise Manager, Oracle WSGL/Web Tool kit.

Methodologies Agile/Scrum, Waterfall, BI Project management, Kimball,

Inmon, Dimensional Modeling

DM Tools Erwin, Visio

Educational Qualification:

. Master of Business Administration (MBA) Specialization in

MIS(Management Information Systems) from Kakatiya University

Warangal

Trainings Conducted

. Conducted Centre level training for 10 days in DataStage EE

7.5 at Syntel, Mumbai.

. Conducted Centre level training for 5 days in Oracle SQL & PL

SQL at Syntel, Chennai.

Trainings Attended

. Cognos 8 Training at Syntel Ltd, Mumbai.

. Global Financial Markets Training at Syntel Mumbai.

. Basics of Capital Markets Training at Syntel Mumbai.

Certifications

. IBM Certified Solution Developer - WebSphere IIS DataStage

Enterprise Edition V7.5.

. OCA Certification - Oracle 10g from Oracle University

. Global Financial Markets B&FS University Level II Domain

Certification.

Project Profile

Maxima Consulting Oct'12 to

Till Date

CLIENT: State Street

State Street Corporation is the world's leading provider of financial

services to institutional investors. It provides core investment custody,

fund or investment/securities accounting, fund administration, securities

finance and transfer agent services to institutional clients. Its broad and

integrated range of services spans the entire investment spectrum,

including research, investment management, trading services and investment

servicing. At State Street, we partner with institutional investors all

over the world to provide comprehensive financial services, including

investment management, investment research and trading, and investment

servicing.

Project : ESP-MSIM;ESP-ALLEGRO

Description : ESP provides a complete middle and back office solution to

State Street Clients. It gives asset owners and the managers a dynamic,

customizable, and scalable self-service platform for all their data needs.

ESP provides industry leaders with one platform that is dynamic enough to

meet customized needs yet complete enough to provide end to end information

in the form of Data Marts. Date Marts are prepared with different data

category join rules with different sources of data. Customized inbound data

can be generated by using this Data Marts. All the Meta Model creation and

changes can be handled for generating customized client specific reports.

Responsibilities:

. As a Senior Consultant, liaising directly with Business and

experienced in writing functional specifications, translating business

requirements to technical specifications, handling data base design

document with detailed description of logical entities and physical

tables.

. Involved with requirement gathering and analysis for the data marts

focusing on data analysis, data quality, data mapping between ODS,

staging tables and data warehouses/data marts.

. Leading and handling an offshore team responsible for understanding

the data model, complex data analysis, working with SQL,

normalizing and designing complete BI solution for the purpose of

client reporting.

. Using ESP while developing Reporting Datamarts, factoring in Dataware

houing principles to suit the reporting requirements..

. Designed and developed processes to support data quality issues and

detection and resolutions of error conditions.

. Working with the Business Analysts and the QA team for validation and

verification of the development.

. Participated in Designing of Dimension model (STAR Schema)

. Transform business requirements into mart design and develop marts in

Enterprise Service Platform (ESP) platform

. Extensively worked on SCD type 1 and type 2 dimensions jobs loading.

. Involved in creating the JILs and scheduling jobs by using Third Party

Tool, Autosys

. Involved in creating UTP, UTPE and BUAT test case doc creation for the

SCD Type 1 and type 2 dimensions.

. Created ETL DataStage Parallel Extender to track the run statistics

for each daily run.

. Involved in moving the code from DEV to BUAT and to support QA team

for each and every query's.

. Resolving the defects assigned by the QA and Business team.

. Involved in Deploying code to UAT and PROD in this project.

Environment : DataStage 8.5, Oracle 11i, UNIX, ESP Meta model tool, Autosys

Syntel India Ltd Feb'07 to Oct'12

Role: Project Lead

Project : TDW-FTP

Description : Funds Transfer Pricing (FTP) is an internal measurement and

allocation process that assigns a profit contribution to sources and uses

of funds. This project will also allow those measurements and allocations

to occur at a cost center and business unit level. The profit contribution

of deposits and overdrafts will also be assigned at a detailed account and

customer level.

Responsibilities:

. Analyzed the requirements/functional specs prepared the DataStage

design documents for the ETL process.

. Worked on DataStage Designer, Manager and Director extensively.

. Developed the various complex ETL jobs like source system specific

average balance calculation for money market, investment portfolio and

loan feeds and designing/developing the complex loan data load in the

star schema table.

. Introduced the JavaClientPXStage in State Street to read the excel

sheets data through DataStage.

. Implemented the complex NIR (Net Interest Revenue) calculations for

Actuals and Budget/Forecast data in ETL.

. Preparation of Technical Specification Design documents for the

development of DataStage Extraction, Transformation and Loading (ETL)

Jobs to load data into various Oracle databases defining ETL

standards.

. Written Unix Shell Scripts for automation of DataStage tasks.

. Created and tuned the Oracle database tables, triggers and audit

tables and also worked with DBA to do the table partitioning and

indexing.

. Design and Development of data validation, load processes, test cases

and review checklists.

. Design and Developed the JILs for automation scheduling of ETL jobs

using Autosys Scheduler.

. Resolved issues occurred during QA testing.

. Used ClearCase to control different Versions of the jobs.

Environment : DataStage 8.5, Oracle 11i, UNIX, Autosys

Project : Basel-DWH

Client : State Street Corporation (SSIT), US

Description : The main objective of the BASEL II Data Warehouse is to

integrate risk data from various risk streams and consolidate them in a

centralized enterprise Data Warehouse. This Data Warehouse will serve the

purpose of meeting current and future reporting, analysis and data quality

requirements. The Data Warehouse will capture data from the risk streams

like Credit Risk, Risk Analytics, Economic Capital, Regulatory Capital,

Market Risk, Operational Risk, and Interest Rate Risk.

Responsibilities:

. Involved in Design, Development and Testing of ETL Jobs

. Involved in requirement gathering.

. Analyzing and fixing the bugs with the program after extracting the

business needs.

. Involved in writing Unix Scripts for invoking the datastage jobs

. Open issues were tracked and resolved after confirming with business

clients

. Involved in performance tuning.

. Peer reviews for Design and Development.

. Leading the offshore development team and Coordinating with client

. Design and development of the datastage parallel jobs.

. Effort estimation for the project

. Preparing and executing unit test cases.

. Maintenance of proper quality standards in deliverables using EQIP

(SYNTEL's internal quality tool)

Environment : DataStage 8.5, Oracle 9i, UNIX, Autosys

Project : Basel-II

Title : CAS (Economic Capital Allocation System)

Responsibilities:

. Business Requirement Analysis.

. Prepared High Level design.

. Analyzing the business mapping rules and implementing the equivalent

low level design.

. Prepared Functional specifications.

. Developed Data stage parallel jobs using different types of stages.

. Peer reviews for Design and Development.

. Prepared Unit Test Plan for unit testing of DS jobs.

. Prepared System level test cases and did system testing.

. Support for User acceptance testing (UAT).

. Creating JILs (Job information language) for Scheduling and run the

jobs by using the AutoSys tool.

. Prepared unit test plans and done the unit testing.

. Involved in Performance Improvement and Tuning of the existing Data

stage jobs.

Environment : DataStage 7.5.2, Oracle 9i, UNIX, Autosys.

Project : PRIME (Anti Money Laundering)

Title : PRIME (SEIODR/ITA/OFAC)

Responsibilities:

. Understand the business function by reading the existing documents

available for the project

. Designed DataStage ETL jobs for extracting data from SQL Server

database to PRIME Server

. Involved in ETL Processes to load data from Flat file, SQL Server into

target Oracle, RD databases, Flat files by applying business logic on

transformation mapping for inserting and updating records when loaded.

. Developed Parallel jobs using stages like Join, Merge, Lookup, Funnel,

Copy, Remove Duplicate, Sort, Aggregator, Filter, Transformer,

Surrogate key, Change capture, Oracle Enterprise edition, Dataset,

sequential stages, etc.

. Creating validation and loading the rejected records into the relevant

tables and send to the users for re-submitting.

. Used DataStage Manager for importing metadata from repository, and new

job categories creating new data elements. Export and import of the

jobs between the production and the development servers is done.

. Used the Autosys, DataStage Director and its run-time engine to

schedule running the solution, testing and debugging its components,

and monitoring the resulting executable versions (on an ad hoc or

scheduled basis).

. Created ETL Design Documentation according to the Client requirements.

Environment : DataStage 7.5.2, SQL Server, UNIX, Autosys.

Project : Basel-II

Title : RDR

Description :

The Basel II Accord introduces a more complex set of standards for

ensuring capital adequacy. There are prescriptive requirements related to

quantitative and qualitative data collection and analysis. As a result, the

implementation of Basel II will impact enterprise-wide business processes

and technology infrastructure. The work being done for Basel II compliance

will improve risk management processes, and provide quality risk management

information that will ultimately support enhanced strategic decision

making.

Responsibilities:

. Responsible for Extracting, Transforming and Loading data from Flat

files and Oracle database and placing it into Target Database.

. Working on Data stage Designer tool- for creating Server jobs,

debugging the jobs and compile the jobs.

. Used OCI, TRANSFORMER, SEQUENTIAL FILE, AGGREGATOR and HASH FILE

stages for designing the Jobs in Data stage Designer.

. Importing & Exporting jobs backups and DEV to BUAT using DataStage

Manager.

. Involved in Design Documents for the jobs, which I have developed.

. Checked and tuned the performance of Server Jobs.

. Creating JILs (Job information language) for Scheduling and run the

jobs by using the AutoSys tool.

. Prepared unit test plans and done the unit testing.

Environment : DataStage 7.5.2, Oracle 9i, UNIX, Autosys.

Valtech India Pvt. Ltd., Bangalore May'04

to Jan'07

Role : ETL Developer

Project

Title : DuPont

Client : DuPont, US

Responsibilities:

. Developing various DataStage Parallel jobs using DataStage Designer as

per (FS/TS) business scenarios like validations, tedious reject

processing and jobs that had to be aborted based on source empty.

. Checked and tuned the performance of parallel jobs.

. Developing various mappings which would take source database like SAP

R/3.

. Developing DataStage Parallel Jobs by using various stages like DS

Dataset, Oracle, ABAP Extract stage for SAP R/3, IDOC Extract stage

for SAP R/3, SAP BW Open Hub Extract Stage, Join, Transformer, Remove

Duplicates, Pivot, lookup etc..

Environment : DataStage 7.5.1 Px, Oracle 9i, SAP R/3

Project

Title : INSIGHT

Client : Limited Brands, US

Responsibilities:

. Responsible for Extracting, Transforming and Loading data from Flat

files and Oracle database and placing it into Target Database.

. Working on DataStage Designer tool- for creating Server jobs,

debugging the jobs, shared containers and compile the jobs.

. Used ODBC, TRANSFORMER, SEQUENTIAL FILE, AGGREGATOR and HASH FILE

stages for designing the Jobs in Data stage Designer.

. Involving in Performance Tuning Jobs process identifying and resolve

performance by Using Link Partioner, Link Collector and IPC Stage.

. Prepare test cases, test data, executing the jobs for Unit testing

. Used the Data Stage Director for running and monitoring the jobs.

Environment : DataStage 7.5. Oracle 9i

Project

Title : Enterprise Data Warehouse for Insurance

Client : Partner Reinsurance

Responsibilities:

. Created Mappings in informatica for the Dimensions, Facts and Targets.

. Involved in preparation of Specs for the mappings.

. Created informatica mappings to build business rules to load data.

Most of the transformations like Source Qualifier, Aggregator,

expression, connected & unconnected Lookups, Rank, Filters, sequence

Generator.

. Used reusable transformations.

. Created sessions and workflows using workflow manager.

. Used Shell scripts to automate the Data extraction process and loading

of the data to the staging area and the Data Warehouse.

Environment : Informatica 6.1, Oracle 8i.

Contact this candidate