Professional Summary

• Cognos ReportNet Product Professional Certified with more than 8.5 years of experience in Analyzing, Designing, Developing and implementation of Business Intelligence solutions and in all phases of Software Development Life Cycle.
• Professional experience in OLAP tools providing basic to complex Business Intelligence solutions using Cognos 8/8.2/8.3/8.4, Cognos ReportNet MR1,Business Objects XI R2/6.5/5.1.X, WebIntelligence XI/6.0/2.X, Crystal Reports XI R1/R2, Spotfire 2.2/3.0.
• Highly skilled in Business intelligence system study, design, development and implementation of applications and Client/Server technologies.
• Extensive database experience using Oracle 9i/8i/7.x, MS SQL Server 2005/2000, DB2 UDB, MS Access, SQL, PL/SQL, SQL * Plus, Sybase ASE 15.0.
• Highly proficient in writing database queries, stored procedures, functions and triggers.
• Thorough knowledge of Ralph Kimball\'s Data Modeling concepts including Dimensional Modeling, Star and Snowflake schema, Slowly Changing Dimensions (Type1, Type2, and Type3) and Surrogate keys.
• Experienced in using modeling tools such as ERwin, and system specifications using UML.
• Proficient in Java and J2EE
• Excellent leadership and presentation skills, with excellent ability to coordinate and communicate with others; and
• Keen interest to learn quickly and implement emerging technologies that foster company growth.

Achievements

• Working as Team lead for a Business Object Reporting Tool Administration in the Confidential.
• Worked as a Senior Cognos Expert for Confidential.
• Worked as BI Architect for Confidential.
• Conducted the workshops on Cognos Report Studio, Spotfire for Confidential.
• Key member in selecting and evaluating the BI tools.
• Worked as BI Administartor in the Confidential
• Part of requirement analysis for Online Banking Reports and Two factor Authentication for Confidential
• Was instrumental in Implementation of Overdraft Approval System(ODAP) for Confidential
• Involved in Successful Implementation of WorkFlow Monitor (WFM) and Management Information System (MIS) in Confidential

Skill Sets

BI Reporting Tool

Cognos 8/8.2/8.3/8.4, Cognos ReportNet MR1, Spotfire 2.2/3.0,Business Objects XI R2/6.5/5.1.X, WebIntelligence XI/6.0/2.X, Crystal Reports 9, XI R1/R2, Actuate, Webtrends,

C, C++, Java, J2EE

ASP, JSP

Visual Basic 6.0

Oracle 9i/8i/7.x, MS SQL Server 2005/2000, DB2 UDB, MS Access, SQL, PL/SQL, SQL * Plus, Sybase ASE 15.0.

Windows 2000, Windows 2003, Windows XP and Unix

Struts, MotioADF

MotioCAP, PassMark

Apache XML Parser, Visual Source Safe, WinCVS, Microsoft Office SharePoint Server 2007, Windows SharePoint Services 3.0,Microsoft SharePoint Portal 2003, XML Spy, Microsoft Visio, IBM Web Sphere Studio Application Developer 5.0, IBM Web Sphere Application server, Tortoise SVN

Business Objects Reporting Tool Administration

Team Lead

Client

Confidential – USA

Duration

Mar 2010 – tilldate

Team Size

18

Platform : Unix Server, Windows 2003
Software : Business Objects XIR2, Crystal Report XIR2

Project Description:
Confidential is a leading provider of investment management, asset and fund administration, fiduciary and banking solutions for corporations, institutions and affluent individuals worldwide. Northern Trust, a multibank holding company based in Chicago.
The Distributed Framework is the division of WWT that is responsible for building, maintaining, and deploying applications on the architectures used to build Northern Trust\'s internal and external online applications.We were responsible for maintaining the health of the BI Tools.

Contributions: As a Team Lead, I am responsible for

• Server administration for the BI tools (Business Objects, Crystal Reports)
• Maintaining, supporting and upgrading BI reporting software’s used for both internal and external applications at the Northern Trust
• Focal point for reporting bugs or issues to the vendors
• Created different CMS clusters and also different server groups to gain performance.
• Onboarding new projects and create User / Group and maintaining security
• Develop project plan using MS project

ISR Survey Report

Role

Senior Cognos Expert

Client

Confidential– USA

Duration

Dec 2009 – Feb 2010

Team Size

8-10

Platform : Windows 2003
Database: Oracle 8i
Software : Cognos 8.4

Project Description:
Confidential is a leading global professional services company that helps organizations improve performance through effective people, risk and financial management.The objective is to analyse the requirements and provide/recommend the solutions for the Business Intelligence related projects. They offer solutions in the areas of employee benefits, talent management, rewards, and risk and capital management.

Confidential ISR(International Survey Research) works closely with their clients to create a survey that will collect employee opinions on important areas for client’s Human Capital development.

Contributions: As a Senior Cognos Expert, I am responsible for

• Working closely with the client to understand the requirement.
• Design data model based on the business requirement.
• Create a number of survey reports as required by client.
• Conducted daily status and weekly reporting meetings with the Client
• Follow the best practice and give recommendation.

Business Intelligence Applications

Business Intelligence Architect

Client

Confidential

Location

Oldsmar, FL

Duration

Sep 2007 – Oct 2009

Team Size

8-10

Platform : Windows 2003
Database: Sybase ASE 15.0, SQL Server 2005
Software : Cognos 8/8.2/8.3/8.4, MotioADF, MotioCAP,Sharepoint server 2007, Spotfire 2.2/3.0,Tortoise SVN

Project Description:
Confidential is the world\'s leading provider of marketing information, audience measurement, and business media products and services. By delivering an unmatched combination of insights, market intelligence, advanced analytical tools, and integrated marketing solutions, Nielsen provides clients with the most complete view of their consumers and their markets.

The objective is to analyse the requirements and provide/recommend the solutions for the Business Intelligence related projects

Contributions: As a BI Architect, I am responsible for

• On boarding new projects.
• Key person in evaluating the new business intelligence tools, components and platform architecture
• Creates overall functional Business Intelligence direction and implementation plan.
• Contributes to, reviews and approves the architecture for all Business Intelligence solution components.
• Contributes to the design of Business Intelligence application solutions including report design and analytics integration.
• Reviews and approves the translation of business requirements into functional application specifications and logical data model requirements
• Assists implementation staff with the resolution of complex, next tier issue support.
• Leads projects through the all stages of the development lifecycle
• Working with Business Units to define Business strategy and create a centralized reporting capability for users to perform analytical, and ad-hoc reporting for business applications.
• Gather requirements from various Data providers in different unit.
• Provide a project estimation , recommendation on BI solutions.
• Worked collaboratively with Infrastructure and support teams, consultants, project managers, and corporate development to develop consulting and project methodology, techniques, tools, and solutions.
• Led a group of eight to ten developers in architecting and building the EDW for the reporting and analytics solutions.
• Conducted daily status and weekly reporting meetings with the project teams and update the senior management on the progress on timely basis.
• Wrote Store Procedures using Transact SQL to populate the fact tables and dimension tables.
• The Stored Procedures support both daily and historical data loading to the fact tables.
• As a architect, designed the data models to meet the requirements of each report.
• Worked extensively on Framework Manager, Report studio, Analytical Studio, Query Studio,Event Studio, Metric Manager and Metric Studio
• Conducting the workshop on different technologies – Spotfire , Cognos Report Studio
• Participates in selection and hiring new BI team members

Business Intelligence Reporting Tool Administration

Business Intelligence Reporting Tool Administrator

Client

Confidential

Location

Chicago, IL

Duration

Oct 2006 – Aug 2007

Team Size

6

Platform : Unix Server, Windows 2003
Software : Business Objects 5.1.X/6.5/XIR2, Crystal Report 9/XI R1/R2, WebIntelligence XI/6.0/2.X ,Actuate, Webtrends

Project Description:
Confidential is a leading provider of investment management, asset and fund administration, fiduciary and banking solutions for corporations, institutions and affluent individuals worldwide. Confidential, a multibank holding company based in Chicago.
The Architecture Division is the division of WWT that is responsible for building, maintaining, and deploying applications on the architectures used to build Northern Trust\'s internal and external online applications.We were responsible for gathering the requirements to build the reports and maintaining the health of the BI Tools.

Contributions: As a BI Admin, I am responsible for

• Server administration for the BI tools (Business Objects, Crystal Reports, Webtrends and Actuate)
• Maintaining, supporting and upgrading BI reporting software’s used for both internal and external applications at the Northern Trust
• Focal point for reporting bugs or issues to the vendors
• User / Group creation, and maintaining security
• Migration of reports from Crystal enterprise 9 to new platform (BO XIR2)
• Set up single sign on functionality with LDAP.
• Created different CMS clusters and also different server groups to gain performance.
• Designed multiple universes to meet the report requirements.
• Created various detailed and summary WebI reports.
• Implemented various advanced features of WebI
  

Online Banking Reports and Two Factor Authentication (PassMark)

Client

Confidential

Location

Chicago, IL

Duration

Jun 2006 – Sep 2006

Platform : Unix Server
Software : PassMark, Business Objects

Project Description:
The current Online Banking product does not make use of a strong (two-factor) authentication mechanism to validate user access to the system. This leads to increasing potential for online fraud and customer concerns with identity theft and the security of their personal data. The PassMark System is a strong Two-factor Two-way Authentication mechanism that provides an additional layer of security to the Online Banking User. The PassMark System helps to ensure that only genuine online customers can access their accounts

With the implementation of PassMark, Online Banking needs the reports which gives the secured information like the number of user who are allowed/ Denied / challenged, the IP address the User coming from to enter the secure Online Banking application. These reports are very much useful for identifying the theft or fraud and to making decisions to secure the site. These Reports are Scheduled Reports which are generated everyday morning and sent to the Online Banking Officers.
Contributions: As a Requirement Analyst for Online Banking Reports and Two Factor Authentication (PassMark), I am responsible for

• Requirement Gathering for the Online Banking Reports and Two Factor Authentication for Online Banking
• Estimation for Requirement Phase.
• Preparation of Business Requirement Document and Software Requirement Specification.
• Walkthrough of SRS to Business User, Vendors and Technical Team

Over Draft Approval System (ODAP) Re-engineering

Duration

Jan 2006 – May 2006

Team Size

2

Platform : Windows 2003
Database : Oracle 8i
Tools : Business Objects 6.5 and MS-VSS

Project Description:
The Over Draft Approval System (ODAP) is an automated system utilized for processing overdraft transactions at Confidential which provides the necessary information to credit officers to reach a decision. Transaction Approval System (TAS) is being defined & developed as part ODAP.
TAS interfaces with the Business Objects to generate the reports. The two types of reports are

• System generated reports : Business object scheduler is configured to generate reports at a predefined time. The configuration of the reports handles the location where the report to be stored.
• User generated reports : This is an ad-hoc type of a report where in the user initiates the report generation.

The report gets generated in the selected format (either Excel or PDF) and saved in the selected location.
Contributions: As a Technical Leader for ODAP, I was responsible for

• Analysing the Business Requirements and Software Requirement specification
• Designing the Database with Oracle 8i
• Designing the Report framework with the help of BO 6.5
• Functional Analysis Document (FAD) preparation
• Concurently Working on developing the Reports in BO 6.5.

Highlights: 
This project development work completed in shorter time span of 3 months which includes training of Business Objects tool

• B.E [Electronics and Communication]
• Cognos ReportNet
• Oracle 8i,Informatica
• Java
• VB 6.0
• Spotfire
• Report Studio

Cognos ReportNet Product User

Cognos ReportNet Product Professional – Reporting Track

Cognos ReportNet Product Professional – Modeling Track

Cognos ReportNet Product Professional - Administration Track