Summary:

• 6 Years of experience in Software Development participating in planning, analysis, design, review and Reporting in various projects.
• 5 Years of experience in Analysis, design and development of Data Warehousing, Business Intelligence and Project Management applications using Cognos, Business Objects.
• Excellent knowledge and work experience in Cognos Suite (Impromptu, PowerPlay, IWR, PPES, Access Manager and Report Net).
• Generated List Reports, Cross Tab Reports, Charts and drill through reports in Cognos Impromptu, ReportNet and Cognos 8 BI.
• Expertise in Cognos 8 Query Studio, Report Studio, Analysis Studio, Metric Studio,

Cognos Connection and Framework Manager

• Experience on Report Net 1.02/1.1 with Framework Manager, Cognos Connection, Report Studio and Query Studio.
• IBM Cognos 10 workshop experience and knowledge
• Expert in the development of Cognos Impromptu, Cognos Transformer, Power Play Reports.
• Extensively worked on publishing of (IWR) Impromptu Web and Power Play Web Reports.
• Extensively worked on Transformer for Data Modeling of the corporate data for building up of Multidimensional Cubes.
• Expertise in Analysis and E-R modeling, developing Database Schemas like Star Schema & Snowflake Schema used in relational, dimensional and multidimensional modeling.
• Expertise in the area of software design and programming of Client/Server, Web applications using VB 5.0/6.0,Oracle 7.x/8.0/8i/9i/10g,SQLServer 2000/2005, MS Access, Java Script, VBScript, ASP, HTML, DHTML, and XML.
• Responsible for interacting with business partners to identify information needs and business requirements for reports.
• Considerable knowledge in the analysis and design of the business requirements and specifications.
• Excellent Analytical and problem solving skills. Team Player with the ability to communicate effectively at all levels of the development process.
• Oversaw planning for the technology lifecycle for all infrastructure components and developed methodologies, policies and procedures.
• Managed all phases on time and under budget.
• Financial services and Insurance Experience.

Operating System:

Windows 95/98/2000/NT, MS DOS and UNIX (Linux, AIX, HP-UX, Solaris)

Software/Tools:

Cognos 10,Cogns 8,Cognos EP Series 7, Report Net, Cognos Impromptu
Cognos Powerplay, CognosVisualizer, Access Manager
Impromptu Web reports (IWR), Cognos IWR administration, BusinessObjects5.1, Web intelligence, Erwin 3.5/3.5.2, DTS (Data Transformation Server), Informatica 5.1/4.6, Crystal reports XI/10/9.0/8.0/8.5/5.0)

Languages:

C, C++, SQL, SQL*Loader, PL/SQL, UNIX Shell Scripts,
Java2.0, Perl5, Visual Basic 6,HTML, DHTML, XML, XSLT

Web Technologies:

Visual InterDev, Visual Source Safe, ASP, COM, DCOM, COM+ and RMI, Cognos Enterprise Server, IIS 4.0, PWS, MTS, MSMQ

RDBMS:

MS Access, MS SQL Server6.5/7/2000, Oracle 7.x/8.x/8i/9i/10g,DB2, Sybase and Teradata v2 R4

Education/Certifications:

• Post Graduate Diploma in Computer Application
• M.B.A
• Bachelor of Commerce in Computer

Professional Experience:

Confidential,Cypress, CA
Cognos Consultant Sep’11 –Till Date

Description: PacifiCare Company is a HealthCare provider, which providers the HealthCare Products in United States. Through its wholly owned subsidiaries and unconsolidated strategic investments, the company offers HealthCare and Insurance products. PacifiCare is one of the largest private HealthCare Company in United States.

Responsibilities:

• Worked with the Business Analysts, Clients and Users to gather the requirements for the

Reports.

• Designed the Report specification and report documentation for the reports.
• Developed standard Templates.
• Used Report Studio to build multi-page, multi-query reports against multiple databases.
• Expertise in developing Standard Reports, List Reports, Cross-tab Reports, Charts, Multiple-

levels of Drill through Reports and Master Detail Reports Using Report Studio.

• Good in creating Query Prompts, Calculations, Conditions, Filters, Bursting Reports and

Multilingual Reports Using Report Studio.

• Query Optimization, Creating Query Prompts, Developing Prompt pages and Conditional

Variables.

• Scheduling and Distributing Reports through Schedule Management in Cognos

Connection.

• Developed best practice in Deployment of code from development to staging and to

Production.

• Testing and improving Report Performance upon report completion for validation of

Calculations & data.

• Trained users in creating ad hoc reports using Query Studio.
• Created a model using Framework Manager for sales data and packed the model with

Reports and published on to the ReportNet Server.

• Created dimensions, data sources, measures, multi dimensional cubes, cube groups and

Power Play reports using PowerPlay Transformer.

• IBM Cognos 10 workshop experience and knowledge

Environment: Cognos 8, Report Studio, Query Studio, Cognos Connection, Framework Manager, Transformer, Cognos 10, Oracle, SQL Server, MS-Excel and Windows 2000.

Confidential,TX. Jan’11 –Aug’11
Cognos Developer.

Responsibilities:

• Involved in Meetings and documented the Business requirements for reporting needs.
• Performed Metadata Modeling using the Cognos 8 Framework Manager and published the packages
• Re-engineered and created new packages using Framework Manager
• Used Framework Manager to create packages combining data from a multiple data sources
• Used Report Studio reports to create a model/cube for meeting some requirements where users wanted drill through/slicing and dicing, which can be done with a cube.
• Created Models and Cubes using Power Play Transformer.
• Monitored the daily cube builds and reports
• Developed complex dashboard reports.
• Developed lists, charts, crosstabs, 3D bars and gauge reports
• Created multi-page layouts using different data sources
• Fine-tuned SQL queries for performance
• Used TOAD to run SQL queries and validate the data in Data warehouse and Data Marts
• Created Bursting reports to several users
• Generated various reports List Reports, Grouped Reports, Cross-tab Reports, Chart Reports, and Drill -Through Reports.
• Worked with master-detail reports, drill-through, prompts, complex calculations, formatting, conditional formatting, Bursting reports, Crosstab, multi-query reports, charts
• Customized cube content with Dimension Views by using Suppress, Cloak, Exclude, and Summarize features. Created Custom Views to implement User class security on Cubes.
• Created Multiple Cubes and Cube groups based on Regions.
• Created Drill down / Drill Up reports and Combine Filter, User-Defined Filters, Custom Ranking using Analysis Studio.

Environment: Cognos 8 (Framework Manager, Report Studio, Query Studio, Analysis Studio, PowerPlay, PowerPlay Transformer), Oracle 10g

Confidential,, TX May’10-Nov’10
Cognos Developer

Responsibilities:

• Worked with users in Designing the Report and Dashboard Layouts.
• Scheduling single and multiple reports using Jobs and distributing reports through schedule management in Cognos Connection.
• Used Report Studio and created complex lists, cross tab, chart reports and generated different report outputs which include Excel, PDF, and HTML.
• Creating page breaks and Created complex reports using conditional formatting.
• Changed Filters, Exception Highlighting and Sorting.
• Generated adhoc reports using Query Studio according to the Business User requirements.
• Developed dashboards, drill up/down, drill through reports and master detail reports.
• Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of report.
• Closely worked with ETL team to design data marts by understanding user requirements.
• Developed SQL Scripts in Oracle to validate data quality.
• Generated reports from multi-dimensional cube using Analysis Studio.
• Created data models with query subjects from multiple data sources using Framework Manager in Cognos.
• Created star schema based data models using framework manager in Cognos and added security to the packages.
• Worked on Performance tuning for the existing reports in Report Studio and improved Report Performance and performed Query optimization.
• Involved in building the Cubes and optimizing the cube creation.
• Submitted issues in Quality Center and Regularly Checking the Status of the issue
• Tested all the reports with Generated SQL and Manual SQL data.
• Created the business requirement and technical specification documentation for Reports.

Environment: Cognos 8.3 (Framework Manager, Report Studio, Query Studio), Cognos Connection, MS SQL Server 2005, Windows 2000/XP, MS EXCEL