PRAKASH NANDURI

oo05xl@r.postjobfree.com

SUMMARY:

• Over Twelve years of experience in Business Requirements Analysis, Application Design, Dimensional Data Modeling, Designing, Coding, Development, Testing and Implementation with RDBMS, Data Warehouse/Data marts, ETL, OLAP, Pro C, Pro Cobol, J2EE applications on multiple platforms.

• Over Six years of experience on ETL Methodology for supporting Data Extraction, Transformations and Loading Processing in a corporate-wide-ETL Solution using INFORMATICA (Power Center 8.1/7.1/6.2/5.1

• Experience in Dimensional Data Modeling using ERWIN and participated in designing the logical and physical data model using Star Schema/Snowflake Schema, Fact and Dimensional tables.

• Over Three Years of experience in Business Intelligence tools like Cognos, Business Objects and used reporting tools like Crystal and Actuate reports for complex queries and views that are necessary for structured and ad-hoc reporting.

• Over 2 years of experience in supporting Java based applications on J2EE platform, used ANT tool in building the EAR files and deploying the EAR files on Weblogic.

• Significant Multi-dimensional and Relational data modeling experience with modeling tools like ERWIN with a strong emphasis on Data Warehouse/Data Mart analysis, design and implementation.

• Developed all custom conversion/transformation standards based on the business requirements.

• Experience in SQL and PL/SQL Programming (Stored Procedures, Functions and Triggers)

• Working Knowledge in Unix Shell scripting and automation of sessions using Control-M scheduler.

• Provided application requirements gathering, designing, development, technical documentation and debugging.

• Experience in leading a team and co-coordinating activities with Onsite-Offshore teams across multiple locations.

• Assisted team members in defining Cleansing, Aggregating and other Transformation rules.

• Worked on implementation of different 3rd party software products.

• Worked closely with the Presales team in building prototypes while working on Bank Master Product.

• Ability to Multi task, Excellent Communication, Interpersonal and Organizational skills.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 8.1/7.1/6.2/5.1

Operating Systems: Windows NT/95/98/ 2000, UNIX (HP, AIX, SUN Solaris)

Languages: SQL, PL/SQL, Pro *C, Pro *COBOL, Perl, Shell Scripting, J2EE, Java, XML

Application Servers: Web Logic 8.1

Messaging: MQ Series 5.3

Business Intelligence: Cognos 7.0 (Impromptu, Power Play enterprise server), Business Objects XI

Data Bases: Oracle 8i/9i, SQL Server, Sybase, Teradata

Reporting Tools: Crystal Reports Ver.11, Actuate 7.x

Tools: TOAD, Erwin 7.x, Serena (Version Control), Clearquest, Clearcase (Version Control),

Visio and MS-Office

Scheduler: Control-M, Tivoli, and Opcon

WORK EXPERIENCE

Client: CARNIVAL CRUISE LINES (Miami, FL)

Title: IT Consultant

Project: Revenue Management System

Duration: Dec 2007 – Till Date

The Revenue Management Data Warehouse caters to Carnival Business community to measure key business indicators regarding pricing, inventory management, booking trends, forecasting and revenue planning. Revenue Management Data warehouse was built for Operational reporting and Analytical reporting. Revenue management Revenue management data warehouse was integrated to other applications and data marts like Revenue Analytics, CRM, SHOREX and Siebel. Revenue management has thirty five subject areas with one fact and many dimensions.

Role and Responsibilities

• Business analysis and data model design for new tables.

• Worked with the data warehouse architect to perform source analysis, identification of key data issues via source analysis of the data profiling results and queries.

• Integration of data from Revenue management data warehouse into Revenue Analytics, CRM, SHOREX and Siebel.

• Participated in multiple projects in parallel.

• Creation and management of the solution proposal, work plan, and deployment plans.

• Assisting in the implementation of scheduling strategy.

• Participated in requirements gathering sessions with a broad spectrum of business and technical users and conducted requirements review and approval.

• Involved in Configuration management, code deployment process and version control process.

• Involved in Creating and trouble shooting the batch jobs used for loading data using informatica to verify mappings.

• Made substantial contributions in simplifying the development and maintenance of ETL by creating source and target shortcuts, mapplets and reusable transformations and establishing standard templates.

• Developed complex mappings, performance tuning, database design and queries.

• Resolved all issues with in the standard SLA time frame given.

ENVIRONMENT: Informatica Power Center 7.1/8.1, Oracle 9i/10g, SQL Server 2000/2008, Toad, Shell Scripts,

PL/SQL procedures, UNIX (Sun Solaris), Opcon, Erwin

Client: Alliance Data Systems (Dallas)

Title: IT Consultant

Project: Utility Services

Duration: Jan 2007 - Dec 2007

Alliance Data has proprietary suite/solution to support utility (Gas and Electric) clients end to end. I had worked in Customizing reporting solution to their clients First Choice Power and Green Mountain using Crystal Reports and complex SQL and PL/SQL procedures. These reports are generated from Query database which is populated using ETL process during the batch. These reports are again automated using scripts and are produced during the overnight batch cycle based on the reporting frequency.

Role and Responsibilities

• Involved in developing reporting data model (Star Schema), establishing process to maintain the report configuration tables and universe design.

• Owned database architecture and design of data warehouse subject areas.

• Identified and tracked the slowly changing dimensions, heterogeneous sources and determined hierarchies in dimension.

• Designed Coding standards and naming conventions to be followed in the project.

• Involved in requirement gathering, business analysis, impact analysis, data validation and high level design.

• Involved in Configuration management, code deployment process and version control process.

• Involved in Creating and trouble shooting the batch jobs used for loading data using informatica to verify mappings.

• Involved in Data Analysis, Post Load Validation and Business Rules.

• Worked on performance tuning of the application in various aspects like informatica, database design and queries.

• Packages, procedures, functions, triggers, etc were developed using PL/SQL.

• Mentored a team of four in development and testing of informatica mappings.

• Involved in creating the Change Requests or Problem management tickets, as part of the enhancement or for bug fixing.

• Resolved all issues with in the standard SLA time frame given.

ENVIRONMENT: Informatica Power Center 7.1/8.1, Oracle 9i/10g, Toad, Shell Scripts, PL/SQL procedures, UNIX (Sun Solaris, AIX), Control-M, Crystal reports XI, Business ObjectsXI, Erwin

Client: Franklin Templeton Technologies (St Petersburg, Florida)

Title: Senior IT Consultant

Project: Global Data warehouse (GDW)

Duration: Nov 2004 – Dec 2006

GDW (Global Data warehouse) is an ODS (Operational Data Store) for the FTT. The GDW project focuses on the Extract, Transformation, & Load (ETL) processes for the GID (Global Integrated Datastore) and ISR (International Sales Reporting) applications. GID holds marketing and performance data for the products (Funds, Fund holdings, Performances, Benchmark data etc). GDW takes data from different systems like used with in Franklin Templeton, transformations are applied and data will be loaded initially into staging area and this will be finally loaded into GID, which is an Oracle database.

Role and Responsibilities

• End to end projects, customization and building interfaces with other applications.

• Involved in the design of dimension tables and fact tables.

• Involved in Extraction, Transformation and Loading (ETL Process).

• Understand SWIFT ISO 15022 standard message formats for MT502, MT509, MT515 and MT599 coming from SWIFT network interfaced with MINT (Sunguard product).

• Created store procedures as part of extracts.

• Involved in enhancement and Bug fixing of the existing flows.

• Involved in conversion process of Treasury Account System from COBOL to Oracle.

• Scheduling jobs through Control M, scheduler.

• Generated system specific PL/SQL packages, procedures and stand-alone back-end processes.

• Packages, procedures, functions, triggers, etc were developed using PL/SQL.

• Worked on some enhancements using Sybase and java in their APECS system.(Abandoned Property Escheatment and Compliance System)

• Created and modified mappings according to the client's requirement.

• Developed new reports, performance tuning using Congnos.

• Involved in coding UNIX shell scripts as part of scheduling batch jobs.

• Involved in creating the Change Requests or Problem management tickets, as part of the enhancement or for the bug fixing.

• Resolved all issues with in the standard SLA time frame given.

ENVIRONMENT: Informatica Power Center 5.1/6.2/7.1/8.1, Cognos 7.1 (Impromptu, Power Play), Oracle 9i/10g, Sybase 11, Toad, Shell Scripts, PL/SQL procedures, UNIX Sun Solaris, Control-M, MQ Series

Client: Franklin Templeton Technologies (St Petersburg, Florida)

Title: IT Consultant

Project: Integration of Webseries with GPS (Global Payment System)

Duration: Oct 2002 – Oct 2004

Integration of Franklin’s new eROC architecture with Bottomline’s WebSeries J2EE platform, will allow for the Global straight through processing (GSTP) of trade orders and their associated confirmations, as well as offering a repair facility for incomplete and/or incorrect orders. The eROC architecture calls for the structuring of all transaction messages to and from counter parties and their agents, using the SWIFT ISO15022 standards for messages MT502 (Trade Orders), MT509 (Status Notifications), and MT515 (Confirmation of Settlement or Cancellation), as well as associated commentary via the MT599 (Text Narrative).

Role and Responsibilities:

• Implementing and integrating web series with eROC.

• Configuring the application on weblogic

• Brining up the managed servers and Troubleshooting.

• Involved in Extraction, Transformation and Loading (ETL Process).

• Supporting the Application on production, development and testing areas.

• Automating certain process using shell scripts.

• Developed Stored Procedures and shell scripts in customizing the application as per the internal needs.

• Converted the internal developed reports form Actuate to Crystal as per crystal is being used as standard reporting tool across Franklyn.

• Controlling and managing the application code in Serena (version control tool).

Environment: J2EE platform, Informatica Power Center 5.1/6.2/7.1, Web logic 7.1/8.1, Oracle 9.x, Sun Solaris, MQ series 5.3, Cognos 7.1.

Project: Misys International Financial Systems (A Division of Misys Plc, UK)

Title: Software Engineer / Analyst

Clients: Fundascion Social, Zurich Financials, Bank Aval, All States Bank, etc.

Duration: Aug 2000 – Sept 2002

Bank Master Retail System (BMRS): BMRS is a Retail Banking Solution of MISYS International Banking System (http://www.misysbanking.com). BMRS is live in production around the Globe and under implementation in some sites. Apart from its own Front End BMRS has another Front end called Branch Power that provides the Branching Solution. BMRS provides gateway interface to ATM/POS, Internet Banking, Browser Based Banking, and Mobile Banking.

• Worked on the following modules of BMRS

o Core Lending

o Accounts

o Check Processing

o Client

o Financial Transactions

o Standing Order

o Overnights

o Common Security Access

o SWIFT

Role and Responsibilities

• Implementing the BMRS software on AIX and HP platforms.

• Testing, Writing test cases and system test packs, execution of test packs.

• Design & Review, coding, Documentation

• Was associated with resolving and testing Issues and Projects to the Clients: Fundascion Social, Zurich Financials, Bank Aval, All States Bank, etc.

• Was involved in the set up of Demo versions.

Environment: Pro COBOL, Pro* C, ORACLE8i on HP-UNIX/AIX, Oracle Reports2.5, Visual Basic 3.0, TOPEND/TUXEDO.

Company: Canbank Computer Services

Project: Integrated Branch Banking Software (IBBS)

Title: Software Engineer

Client: Canara Bank

Duration: June 1997 – March 2000

Role and Responsibilities

Worked on Integrated branch banking software (IBBS), which is a product of Canbank computer services (A subsidiary of canara bank). IBBS is total branch automation software. I was associated with the support of product for all the available modules, doing code walk through and testing the product for the year 2000 compliance.

Product Environment: MF COBOL on Novell Netware.

Contact this candidate