PROFESSIONAL SUMMARY:

• 8 plus years of experience in IT Industry with strong background in Analysis, Design, Development, Testing, Documentation and Implementation of applications.
• Completed projects from gathering requirements from business users till its completion by effective analysis, choosing the right tool, tuning, testing reports, to end - user training.
• Excellent proficiency in the usage of Cognos tools such as Cognos 10 & Analytics, Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio, Workspace, Workspace Advanced, Cognos Connection, and Transformer.
• Strong experience in creating Models and publishing packages in Framework Manager.
• Strong understanding of dimensional modeling of Star Schemas, Snow-Flake Schemas Methodologies for building enterprise data warehouses.
• Created and updated Multi-dimensional PowerPlay Models/Cubes using Transformer.
• Strong complex reporting skills - complex Drill-Through, Summary Reports.
• Administered Cognos Connection to implement Security among Cognos applications.
• Created Complex reports, Dashboards in Report Studio and created Ad-Hoc reports in Query Studio.
• Involved in the Full Project Life Cycle of the Data Warehouse Project.
• Proficient at analyzing business processes and providing Business Intelligence solutions.
• Highly motivated and adaptive with the ability to grasp things quickly and possess excellent interpersonal technical and communicational skills.
• Experience in writing and debugging stored procedures and triggers.
• Strong experience in client interaction and understanding business application, business data flow and data relations from them.

TECHNICAL SKILLS:

BI Tools: Cognos 8 & 10, Cognos Analytics, Framework Manager, Report Studio, Query Studio, Analysis Studio, Cognos Connection, Transformer

Databases: SQL Server 2000/2005/2008 R2,2012 Oracle 9i, Teradata 14/15

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

Web Servers: Apache Web Server, Microsoft Internet Information Server (IIS) 7.5/6/4.0/3.0, Websphere

Web Technologies: HTML, DHTML, XML

ETL Tools: Data Transformation Services (DTS), Informatica, Data stage

Microsoft Tools: MS Excel, MS Word, MS Visio, MS PowerPoint

Communication: Microsoft Outlook, IBM Lotus Notes

PROFESSIONAL EXPERIENCE:

Confidential, Houston TX

Cognos Developer

Roles and Responsibilities:

• Designed the Model according to the Business Requirements by creating a Presentation Layer .
• Interaction with the Management and Development teams for gathering information for creating the Framework Model .
• Implemented security in Cognos Framework Manager in each level according to business users.
• Created different types of reports like List, Cross-tab, Chart Drill-Thru, Master Details, cascading using different prompts Developed Standard Reports, Charts, Drill Through Reports, Master Detail Reports, Bursting Reports and Multilingual Reports Using Report Studio and Query Studio .
• Created Dashboards
• Customized data using prompts, Filters, Calculations, Summaries and Functions .
• Developed Prompt pages and Conditional Variables.
• Involved in migration from Cognos 10 to Cognos Analytics
• Created filters within the Model for improving the performance of the Model.
• Scheduling and Distributing Reports through Schedule Management in Cognos Connection.
• Optimized the cube performance and the report response time.
• Created Stored Procedures for Updating and Inserting data into the database.

Environment: Cognos 10.2 & Analytics (Cognos Connection, Framework Manager, Report Studio, Query Studio, Event Studio, Business Insight ) Oracle 9i, SQL, Windows.

QueBIT

Cognos Consultant

Roles and Responsibilities:

• Worked with business analysts and end users to understand business rules and interpret data.
• Developed Framework Manager Design documentation and report documentation.
• Created Packages which includes Query Subjects, Joins, Filters, Prompts in Framework Manager.
• Published the Packages to Cognos Connection.
• Used Cognos Connection for organizing, security, scheduling and distributing reports.
• Developed ad-hoc reports in Report Studio & Query Studio.
• Used Analysis Studio to build Multidimensional Reports.
• Developed List, Crosstab, Drill through, Master-Detail, and Charts which involved Multiple Prompts, Multiple Frames, Filters, Multi-page, Multi-query reports against different data sources in Report Studio.
• Created the Reports in different formats like PDF, XML, HTML, Excel and CSV.
• Involved in Bursting Report Studio reports and sending reports via Email to several business users.
• Involved in scheduling Report Studio and Query Studio reports in Cognos Connection.

Environment: Cognos 10 (Cognos Connection, Framework Manager, Query Studio, Report Studio, Event Studio, Metric Studio, Analysis Studio) Teradata, Oracle 9i, SQL, Windows XP.

Cognos Consultant

Confidential, Las Vegas, NV

Roles and Responsibilities:

• Understanding existing business model and customer requirements.
• Work with project managers, business analysts and end users to understand business requirements and translating them to technical specifications.
• Involved in analyzing, documenting functional and technical requirements for developing packages and reports.
• Developed Active reports and analytics to meet the needs of business analysts.
• Proven experience building ad-hoc and complex reports using prompts and parameters in Report Studio and Query Studio.
• Involved in designing and creating various projects in Framework Manager.
• Create Reports and attractive Dashboards in Business Insight
• Involved in designing Models using Framework Manager.
• Customized data by adding Filters Prompts, Calculations, Summaries and Functions.
• Created custom prompted reports in Report Studio, Bursting reports to different user groups.

Environment: Cognos 10.1/2 BI (Framework Manager, Report Studio, Cognos Connection, Business Insight, Transformer), Teradata (Teradata SQL Assistant) and Microsoft Excel.