PROFESSIONAL SNAPSHOT:

• 7+ years of IT experience involving various aspects of Business Intelligence. Well versed with complete Life Cycle Development process including requirement analysis, documentation, development, testing, implementation, and maintenance.
• 4+ years of strong experience in designing and implementing complex reporting solutions using COGNOS Suite 10.1 / 8.4 / Cognos Reportnet 1.1 MR1.
• Expert level with developing metadata models in Framework Manager following best practices
• Mid level knowledge with developing OLAP models, using Powerplay Transformer.
• Strong skills developing DMR models in Framework Manager and dimensional reports in Report Studio
• Skilled at training users to use Query Studio and Analysis Studio.
• Ability to effectively communicate with various business groups to gather requirements and prepare functional and technical documents.
• Strong understanding of designing dimensional and relational models, star and snowflake schemas and different DW design paradigms.
• Strong proficiency in different SDLC methodologies including Agile and linear models.
• Experience in PL/SQL and query optimization techniques
• Solid experience in creating PL/SQL scripts and Stored Procedures to retrieve, load and manipulate data
• Mid - level knowledge of Oracle and DB2 databases.
• Mid-level knowledge of COGNOS administrative and security tasks
• Exceptional ability to quickly master new concepts and technologies
• Capable of working in groups as well as independently with excellent communication skills
• Good in trouble shooting with quick turnaround in fixing the issues.
• Strong functional and technical analysis skills.

CORE STRENGTHS:

Cognos BI & Data Warehousing

Cognos BI Reporting

Data Modeling Techniques & Methodology

Dimensional Modeling

Data Cube Building

Requirement Gathering & Analysis

Application Design & Development

Software Development Life Cycle (SDLC)

Software Testing Life Cycle (STLC)

Debugging Skills

IT FORTE:

Data Warehousing: Cognos 10.1/8.4/8.3/8.2 Suite, ReportNet 1.1.MR3, Informatica,Cognos ReportNet 1.1 MR1 (Framework Manager, Report Studio, Query Studio), Analysis Studio.

GUI: Oracle Forms 6i & Reports 6i

RDBMS: Oracle 8,9,10g, SqlServer,Teradata

Languages: SQL, PL/SQL

Utilities: VSS, SQL* Loader, TOAD 7.0, Mercury Test Director 7.0

Operating Systems: Windows 98, 2000, NT, XP, UNIX

EMPLOYMENT CHRONICLE:

Sr. Cognos Developer

Confidential, Davidson, NC

Tools: Cognos 10.1/8.4, Cognos Framework Manager, Query Studio, Report Studio, Analysis Studio, Cognos Transformer, (SQL, PL/SQL), Oracle Applications.

Responsibilities:

• Created new models and modified existing models in Framework Manager.
• Used Report Studio to build and validate complex multi-page, multi-query reports.
• Building dynamic prompts for single master report.With dynamic prompts you ensure that all cross-functional users have access to the same data in a customized layout that fits their specific needs.
• Developed, customized and burst reports using Report studio.
• Tested and validated report outputs against Oracle database using TOAD.
• Created and managed jobs and report schedules.
• Actively participated in meetings to get a better understanding of the project scope and requirements.
• Map business requirements to enterprise data and recommend analytical reporting strategies.
• Cognos Connection and Cognos Viewer customization
• Performance tuning of Cognos Reports, FM model
• Documented high level business user requirements.

Tools: Cognos 8.4, Cognos Framework Manager, Query Studio, Report Studio, Analysis Studio, Cognos Transformer, Cognos Report Studio 8.4 BI (Framework Manager, Report Studio and Query Studio), (SQL, PL/SQL).

Sr. Cognos Developer

Confidential, Atlanta, GA

Responsibilities:

• Built the Model using Framework Manager.
• Worked extensively on creating the Model and publishing the package for Reporting purposes.
• Created Filters within the Model.
• Developed various standard reports like list reports, cross tab reports and Drill through reports using report studio.
• Developed Prompt pages and Conditional Variables.
• Created Master Detailed report using Report Studio.
• Created Prompts like value, Text box, Date & time and cascading prompts.
• Created New calculations according to the report specifications.
• Involved in performance tuning of the Reports.

Tools: Cognos 8.4, Cognos Framework Manager, Query Studio, Report Studio, Analysis Studio, Cognos Transformer, Cognos Report Studio 8.4 BI (Framework Manager, Report Studio and Query Studio), (SQL, PL/SQL).

Oracle Developer

Confidential

Responsibilities:

• Studied business flow of Production Shop Floor and Manufacturing Services modules.
• Prepared functional decomposition, data flow diagrams and entity relation diagrams for the above modules.
• Participated in designing the proposed system and integrated with other modules .
• Developed 4 Forms using Oracle Forms 6i, 6 Reports using Oracle Reports Designer 6i and 5 PL/SQL Packages to perform back-end operations.
• Involved in technical code reviews, coding and unit testing; extensively used Test Director for defect tracking.
• Entrusted as QCO (Quality Co-ordinator) .

Environment: Oracle 8i, SQL, PL/SQL, Developer 6i on Solaris, TOAD 7.0.

Oracle Developer

Confidential

Responsibilities:

• Coordinates with all functional Head and participated in a case study of Materials Module including Purchase & Inventory Management.
• Prepared functional decomposition, data flow diagrams, entity relation diagrams for Materials Module.
• Identified gaps and prepared Gap Analysis to be incorporated in the proposed system.
• Prepared System Required Specification (SRS) documentation for Materials Module, which was signed-off by the end-user.
• Developed 3 Forms using Oracle Forms 6iTM, 8 Reports using Oracle Reports Designer 6iTM and 4 PL/SQL Packages to perform back-end operations.

Environment: Oracle 8i, SQL, PL/SQL, Developer 6i on Solaris, TOAD 7.0.