Professional Summary:

• Professional and dedicated individual with around 7 years of IT experience in datawarehousing primarily in reporting and data modeling
• Experienced in designing highly complex datawarehouse and desiging and developing complex reports as a OLAP Designer and Data Modeler.
• Experienced in business requirements finalization, report design,reports development as a Team Lead.
• Exceptional analytical and problem solving skills,self starter and leading a team of 20.
• Experienced in writing PL/SQL procedures and functions.
• Expertize in Cognos SDK.
• Experienced in Cognos 8.x business intelligence suite.
• Experienced in Cognos Framework Mananger Modeling
• Experienced in Cognos 7.x business intelligence suite.
• Proficient in relational databases like Oracle,Teradata,SQL Server and DB2.
• Exposure to ETL tools like Oracle warehouse builder and Ab Initio.
• Experienced as a Hypersion Essbase DBA.
• Proficient in Oracle Express.
• Proficient in Unix Shell Scripting.
• Proficient in other OLAP tools like Crystal Reports,Actuate etc.
• Experienced in scheduling tools like Maestro,Control-M,Autosys,Crontab.
• Comprehensive knowledge on the software development methodologies like waterfall,RUP,SCRUM,Iterative etc.
• Experineced in change management tools like Clearcase etc.
• Numerous accolades from Citigroup for providing the best reporting solution.
• IBM certified Cognos BI Author,Cognos certified in Cognos Advanced Report Authoring, Cognos Powerplay Modeling, Framework Manager Modeling.
• Possess excellent verbal and written communication skill.

Technical Skills:

Windows NT/2000, UNIX

C,C++,Java,JSP,Java Script,VB.NET,VB,PHP

Oracle 9i/10g,Teradata,DB2,SQL Server 2000,Access

Cognos 8,Cognos SDK,Hyperion Essbase,Ab Initio

Other

TOOLS & LANGUAGES:

Cognos Impromptu, Cognos Power play, Cognos Transformer, Cognos SDK, Cognos Script, Cognos ReportNet, Erwin, Hyperion Essbase, Crystal Reports, Ab-Initio, Oracle Warehouse Builder, Maestro, Auto Visn, Oracle Application Express,Toad,Actuate,Crystal ReportsDomain Knowledge:

Certifications:

IBM certified Cognos 8 BI Author.
COGNOS certification in Cognos Advanced Report Authoring.
COGNOS certification in Cognos Powerplay Modeling.
COGNOS certification in Framework Manager Modeling.
COGNOS Certified training in COGNOS ReportNet at SQL Star International, Hyderabad.
ORACLE Certified training in Fundamentals and Design Concepts of Data Warehousing and Implementation with Oracle based ETL Tool, Oracle Warehouse Builder, at SQL Star International, Hyderabad.
Under gone training in Visual Basic 6.0 at SSI Technologies, Coimbatore.
Under gone training in Oracle 8.0 at SSI Technologies, Coimbatore.
Under gone domain specific training in Banking, Finance & Mortgage concepts.
Banking and US Financial certification-Internal

Experience Summary:

Citigroup - Confidential,(Oracle Financial Services)
Jul 2005 to Apr 2006

Pearson Publications -Confidential,
May 2003 to Jun 2005

Bachelor of Engineering in Computer Science (B.E)

Star Performer Award – 3 Consecutive Years (Tata Consultancy Services)
Numerous Client Accolades

Key Engagements

Project Name: Troubled Asset Relief Program(TARP)
Client: Confidential,Texas,USA
Duration: Nov 2008-Till Date
Role: Cognos Architect/Developer
Environment: Cognos 8.2, Transformer, Oracle ,Teradata,Maestro, Cognos SDK, Oracle Express

Project Description

The Troubled Asset Relief Program (TARP) is a program of the United States Government (USG) to purchase assets and equity from financial institutions in order to strengthen the financial sector. It is the largest component of the government\'s measures in 2008 to address the sub-prime mortgage crisis. TARP allows the United States Department of the Treasury to purchase or insure “troubled" assets from various financial banks and institutions.

As part of the Troubled Assets Relief Program signed into law in Oct 2008 in which relief funds were allocated to financial institutions to alleviate strain, there are monthly and quarterly reports due to multiple government entities on the financial disposition of those ring-fenced assets.

As a Cognos Architect/Developer responsibilities include

• Extensively worked on understanding the business requirements and designing applications to meet the end user requirements.
• Responsible for creating a reporting solution that provides summarized and detail view of important metrics from various data sources.
• Responsible for gathering reporting requirements and creating functional specifications.
• Responsible for designing reporting layer out of base data model.
• Developed framework manager model and packages for overall reporting solution.
• Developed detail reports to plot the losses occurred on short-sold and foreclosed loans.
• Developed summary level roll-forward cubes to show the asset balances and losses on ring fenced loans.
• Responsible for analyzing the requirements and identifying the requirements by interacting with business users.
• Document the requirements and create functional specification for development
• Prepared functional and technical documentation of the reports created for future references.

Project Name: Master Servicing
Client: Confidential,Texas,USA
Duration: Sep 2007-Oct 2008
Role: Cognos Architect/Developer
Environment: Cognos 8,Crystal Reports, Teradata,Maestro

Project Description

The Master Servicing Division (MSD) tracks and audits for compliance loans that are owned by an investor but are serviced by another party. Historically, Crystal Reports has been the standard reporting tool in the Master Servicing Division. For several years, the Master Servicing Division was part of First Nationwide Mortgage prior to Citi’s acquisition. Crystal Reports was the reporting solution for Master Servicing employees. MSD relies on reports created using an older version of Crystal reports.

The need to change the reporting solution has not become an issue until recently when 1) world and corporate events have increased attention to the protection of customer and corporate data, and 2) Citi made a decision to adopt Cognos Business Intelligence tools as the Citi standard

As a Cognos Architect/Developer responsibilities include

• Was working closely with Business Analyst to understand the business requirements and report specifications.
• Involved in designing the FSLDM model and the Reporting Layer design as per the Reporting Requirements.
• Responsible for building models, publishing packages in Framework Manager and creating the reports as per report specifications.
• Extensively used Report Studio for creating various complex reports.
• Created various query calculations, filters, logical statements to get the desired data into the report.
• Migrated various reports from Crystal reports to Cognos.
• Involved in deciding report scheduling, maintenance/security of reporting folders in the production environment.
• Responsible for managing the User Acceptance Testing Phase.
• Prepared functional and technical documentation of the reports created for future references.

Project Name: REL Productivity 5X
Client: Confidential,Texas,USA
Duration:Dec 2006-Aug 2007
Role: Cognos Architect/Developer
Environment: Cognos 8.2,Transformer,Maestro

Project Description

The REL Productivity Project utilizes the Mortgage Analytics Platform (MAP) environment and is used by REL Originations Operations Group which is a centralized operations group that is responsible for supporting all Real Estate originations operations, including dedicated channel such as Retail, Wholesale, CTB/PFS and Correspondent for unique customer or product needs (e.g. customer facing staff or underwriting) and is the business center that provides cross-channel support for common functions. This group, with help from CMI and CHE Finance team, is responsible for creating Dashboards for key decision makers. As they want to minimize the manual intervention and also to have a secured, improved reporting they moved to Cognos.

As a Cognos Architect/Developer responsibilities include

• Responsible for working with the Business Analysts and Business Users to gather and document requirements.
• Created projects, designed models for reporting and created & published packages in Framework Manager from various data sources.
• Created all Kinds of Reports like List, Cross-tab, Nested Cross-tab and Dashboards.
• Created Multi-Dimensional reports using Power Play.
• Worked on various drill thrugh reports, conditional formatting and master detail relationships.
• Created complex reports using calculated data items, multiple lists in a single report.
• Extensively used Cognos along with Powerplay cubes for reporting with dimensional models.
• Prepared functional and technical documentation of the reports created for future references.
• Creating New Jobs using Cognos Connection.
• Creating jobs in Maestro and scheduling the Cognos Jobs.

Project Name: REO Conversion
Client: Confidential,Texas,USA
Duration:May 2006-Nov 2006
Role: Sr. Developer
Environment: Cognos Impromptu, Powerplay Transformer, and Oracle Application Express

Project Description

CREST Default and Collections support the non-performing serving needs of CMI, CTB, CFMC, NET and CHE Real Estate loans. As of April 2006, Wholesale Direct loans were originated on CFI and boarded to Citilink as CMI loans. Those loans, which exceed the ‘Citi Initiative’ rate threshold criteria, are serviced on Citilink using existing CFMC Default/Collections Servicing staff and policies.

At this time, the CFMC reporting infrastructure in place by various business reporting supports groups, which uses data from MortageServ via multiple paths. Most of those applications do not have a data path to them to obtain the Citi Initiative data that now resides in Citilink and DRI. This creates a critical gap in reporting as the mortgageserv platform was converted to Citilink as of July 4, 2008. The business needs this history data loaded into MAP.

As a Sr. Cognos Developer responsibilities include

• Responsible for converting the business requirements into project documentation.
• Created Catalog in Impromptu Administrator to create reports. Created various drill through reports from report to report.
• Developed Reports in Impromptu and PowerPlay.
• Deployed Power Cubes on Power Play Enterprise Server.
• Involved in all aspects of impromptu, from connecting to the corporate database to setting up effective catalogs, joins, folders, and filters, to ensure that adequate security procedures are in place.
• Involved in the design development and implementation of Cubes for various purposes.
• Created multidimensional power cubes in PowerPlay Transformer.
• Created dimension maps for transformer, established all dimension hierarchies, designed special categories, calculated measures and special time categories.
• Provided Oracle back end programming including PL/SQL, Oracle Stored Procedure.

Project Name: CPB Essbase Migration & Automation
Client: Confidential,New York,USA
Duration:July 2005-April 2006
Role: Essbase Admin/.Net Designer/Developer
Environment: Hyperions Essbase, VB.NET

Project Description

Citigroup Private Bank needed to migrate their existing Essbase Cubes in Version 5 to Version 7. The existing VBA application using the Essbase APIs also needed to be migrated and certified for Version 7. Automation of the monthly production process, with the back-up and COB requirements was also achieved in this project.

As a Essbase Admin/.Net Designer/Developer responsibilities include

• Analyzed the VBA code for Hyperion version 5 to version 7 Impact
• Modified the VBA code for Hyperion Essbase Version 7
• Participated in the Design of the Automation Program
• Developed the VB/VB .NET application for processing the data into Essbase as per the design, using the Essbase VB API
• Coordinated the Installation & Configuration activities with the Global Support Unit for the Test & Production environments
• Developed the Batch script for Cold backup of the Essbase database
• Enhancements to the Automation program due to requirement changes
• Provided Support during the Acceptance testing process.
• Responsible for Private Banking Hyperion System.

Project Name: Pearson Production Management System
Client:Confidential,New York,USA.
Duration:Jan 2004-Jun 2005
Role: Cognos Developer
Environment: Cognos Impromptu and Cognos Power Play,Oracle

Project Description

Pearson Education is the leading educational publisher and also the global leader in online learning with nearly 2,000 textbook companion Web sites, the Information Website for technology professionals, and the Family Education Network, the award winning online resource for parents, teachers, and children. Pearson Education is part of Pearson (NYSE: PSO), the international media company. In addition to Pearson Education, Pearson\'s primary operations include the Financial Times Group and the Penguin Group.
The existing system is customized to Pearson needs by redesigning the database creating new forms and creating reports. Various modules like Program, Summary, Cost Control, Product specification, Schedule, ISBN Creation, Forecast, Purchase order and Invoice are implemented.

As a Developer responsibilities include

• Extensively worked on understanding the business requirements and designing Cognos applications.
• Installed Cognos EP 7.1 Products.
• Created catalogs, with proper organization of folders as per the business requirement, setting up User classes, creating calculations, filters, conditions, prompts and security.
• Created List, Sub and Cross-Tab reports using Impromptu and distributed Catalog to users for Ad-Hoc reporting and analysis.
• Designed models by mapping business needs using Powerplay Transformer and created multi dimensional cubes, cube groups, powerplay reports.
• Created dimension maps and multidimensional cubes using impromptu’s Query Definition in PowerPlay Transformer.
• Applied Drill through Mechanism to Cubes using IMR reports.
• Created Cubes using User Class Views, Dimension Views and applied Cloak, Summery, Exclude, Suppress and Apex according to User Level.
• Decreased the cube build times drastically and increased runtime performance.
• Creation of different types of reports, drill through reports, sub reports, list reports. Creation of user and changing their profile.
• Creation of standard filters, calculations, prompts and conditions in catalog.
• Query optimization, weighing the tables in Cognos.
• Created the Special Categories in the Cube.
• Published reports to upfront using IWR.
• Published Cubes to Upfront using PPES.
• Testing the deliverables.

Project Name: In-House Automation Tool Development
Client: Confidential, Bangalore,India.
Role: VB Developer
Duration:May 2003-Dec 2003
Environment: Visual Basic

Project Description

Automating some of the manual process involved in the e-publishing project development cycle.

As a Developer responsibilities include

• Understanding the requirements.
• Creating automation tools.
• Testing the tools for its functionality.