SUMMARY

• Over 5+ years of experience in Data Warehousing and Business Intelligence.
• Over 4 years of experience in Cognos BI and Cognos 10 BI, Cognos 8.4/8.3/8.2/10.1 (Framework Manager, Report Studio, Analysis Studio, Query Studio), Cognos Power Play and Transformer
• Having strong and working knowledge on Cognos Connection, Query Studio, Report Studio and Frame work manager
• Excellent ability to gather and understand business requirements and translate into IT solutions with the use of Cognos
• Having rich experience in creating various types of reports using Report Studio
• Experienced with complete application development life - cycle including requirements gathering, analysis and design, implementing, testing and deployment
• Having good knowledge on HTML and JavaScript and ability to implement those technologies in Cognos reports.
• Strong working knowledge in tools like TOAD, SQL Developer etc.,
• Excellent problem resolution and communication skills with ability to work under pressure in a highly visible role.
• Strong knowledge of Data Warehousing concepts and Dimensional modeling using Star schema and Snowflake schema.
• Good Knowledge in Data warehousing development using ETL tools such as Informatica Power center 8.x/7.x.
• Experience in using Data warehouse Administration Console (DAC) to schedule and run full and Incremental ETL loads, to schedule the Informative jobs, and to customize Execution Plans.
• Strong Experience in using different Informative Designer Components.
• Experience in writing SQL queries, creating different PL/SQL Objects and using SQL*Loader for loading data into Data warehouse / Data Mart.
• Experience in creating SSIS packages using pivot transformation aggregate, execute SQL task, data flow task and execute package task to export clean data from text files, MS Access and CSV files to data warehouse.
• Experience in Creating Report in Crystal.
• Profound knowledge of System Development Life Cycle (SDLC).
• Excellent problem solving skills with strong technical background and good interpersonal skills.
• Excellent team player and quick learner, with ability to meet deadlines and work under pressure.

TECHNICAL SKILLS

BI TOOLS/Analytics: Cognos, OBIEE11g, 10.x, Siebel Analytics 7.7, Crystal Reports

ETL TOOLS: Informatica 8.x/7.x

Database: Oracle 11g/10g/9i/8i/7.x, SQL server 2000/2005, Oracle EBS

Scheduling Tools: DAC (Data warehouse Administration Console)

Languages: C, UNIX, SQL, PL/SQL, HTML, XML

Oracle Tools/Utilities: SQL*Loader, Oracle Designer, SQL Developer, TOAD, SSIS, SSRS

Operating Systems: Windows vista, Win 95/98/2000/2003/2007/ XP, Linux, UNIX

PROFESSIONAL EXPERIENCE

Confidential

Cognos BI Consultant

Environment: Cognos 8.1/10.1, Oracle, SQL

Responsibilities:

• Created List reports, cross tab reports, charts, sectional reports, & Drill through reports by using Report studio.
• Involved with business and functional people to collect and gather requirements
• Implemented Mock report layouts before the actual report implementation.
• Using Framework Manager, developed reporting models for BI reporting - ad-hoc Queries, reports.
• Creating value prompts, Date & time prompts, Text box prompts, cascading prompts
• Hide and Show the objects by using conditional blocks
• Implemented Oracle SQL, PL/SQL script in reports.
• Involved and performed unit testing (manual testing) for the reports that have been developed.
• Developed multi format reports (PDF, Word, HTML & Excel).
• Raised tickets and interact with different teams for migration of code (Teradata views, packages and reports) to different environments.
• Creating & publishing the packages according to the business requirements
• Involved in the scheduling and deployment of the reports
• Involved in the Unit Testing of the reports and preparing the Test cases

Confidential, San Jose, CA

Cognos Report Developer

Environment: Oracle SQL/PLSQL, Crystal Report, Cognos BI

Responsibilities:

• Gathered Business requirements for creating the Models.
• Developing Standard Reports, Charts, Drill Through Reports, Master Detail Reports and Multilingual Reports Using Report Studio and Query Studio.
• Using Scheduler Schedule the reports Daily, Monthly, Yearly.
• Created Prompts to User Defined Filters.
• Good knowledge in Unit/integration Testing
• Extensively worked on TOAD tool, testing the queries.
• Good Knowledge and experience in Oracle Fusion.
• Creation of framework manager models and packages
• Configuration of Web server and cognos configuration
• Working with different projects in Framework manager
• Creation of packages in framework manager
• Working with cognos connection to run and schedule the reports
• Creation of Reports using Report studio

Confidential

Report Analyst / ETL Developer

Environment: Seibel analytics 7.7.1, Informatica 6.1, Oracle 8i/9i, Oracle 8i, SQL, PL/SQL, windows 2000, UNIX.

Responsibilities:

• Developed System Standards, System Architecture, Scenarios, detailed screen Specifications and documented Logical and physical Data Model.
• Created Navigation as well as Drill Down reports with Dimensional hierarchies.
• Modified existing reports and created new reports from Seibel Data as source and Siebel DW tables as per the business requirements.
• Created Action links in the analytics reports to switch between Analytics and Seibel Call Center application.
• Worked extensively on marketing which included Campaigns dashboards and Sales related dashboards.
• Created reports from different sources of data (Seibel, Avaya, and MCI).
• Set up object-level security (access permissions to web-objects) based on the user profiles and the user groups they belong to.
• Created drill down reports for various reports to get into details from base reports.
• Reviewed and updated Seibel Analytics data dictionary.
• Created Aggregate table Developed many delta / incremental complex Informatics ETL process and Oracle packages i.e.,
• Mappings & mapplets using various transformations.
• Designed and implemented the Pre Staging approach, for cleansing using informatica ETL.
• Extensively worked in data Extraction, transformation and Loading from Facets to target system using ETL.
• Responsible for ETL process, performance Tuning, Monitoring, Troubleshoot and fix Problems.
• Identified benefit of solution, Software product tested using Functional, performance and System test.