SUMMARY:

• 8+ Years of IT experience in the designing, developing and testing of Data Warehouse and Business Intelligence applications.
• Over 7 years of working experience with Cognos 10.2/10.1/8. x BI Suite (Framework Manager, Cognos connection, Report Studio, Metric Studio, Analysis Studio and Query Studio)
• Expertise in gathering business requirements and creating models &reports to meet the requirements.
• Handling complete range of BI capabilities: reporting, analysis, dashboards and business event management
• Hands on Experience with Framework Manager Modeling (Physical Layer, Business Layer, Packages) and Complex Report building with Report Studio
• Expertise in developing and testing Complex reports (List, Cross tab, Charts, Maps, Drill - through, Master-Detail, and Cascading) and Dashboards using Report studio
• Experience and expertise in understanding existing business processes, data analysis requirements, business systems analysis and design, converting requirements specifications into functional specifications
• Extensive experience in Multiple Relational Databases including SQL Server, Oracle & DB2
• Experience with writing SQL queries, Oracle PL/SQL Stored Procedures, Functions, Cursors and Triggers
• Provide best practices for day to day operations, performance analysis, tuning and capacity planning
• Have clear understanding of Business Intelligence and Data Warehousing concepts with emphasis on ETL and Life Cycle Development
• Involved in training end users and providing technical support and documentation
• Ability to adapt and learn new technologies and to get proficient very quickly with them

TECHNICAL SKILLS:

BI tools: Cognos10.2/10.1,8.x (Report Studio, Framework Manger, Analysis Studio, Query Studio, Business Insight), Transformer 8.3ETL Tools: Informatica 8.6, Data stage 7.5

Databases: Oracle 9i/10g/11g, SQLServer 2000, Teradata, DB2

Languages Scripting: C, C++, Java, Cobol, VB.net,VB Script, Java Script, HTML, CSS.

DB Tools: SQL *Plus, SQL *Loader, TOAD 8.3

Web Servers: IIS, Apache

PROFESSIONAL EXPERIENCE:

Confidential,Washington,DC

Sr. Cognos Developer

• Discussed with clients about their present reporting system and understand their current reporting issues to meet their needs
• Involved in Designing models with Relational Data using Framework Manager and published packages to the Cognos Reporting Servers.
• Implemented data level, object level and package level security in framework manager to achieve highly complex security standards.
• Created Database Layer, Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts in Report Studio.
• Developed Reports using Conditional Formatting, Cascading Prompts, optional prompts and Report Bursting.
• Upgraded Framework Manager Models, Transformer Cubes from Cognos Version 8.4 to 10.2.1
• Developed Dash board reports to display all the information related to environment using Summary reports.
• Created Master Detail reports, drill through and custom prompting reports, and Scheduled reports for efficient resource utilization.
• Created optional filters/prompts in report studio using Java Script and HTML.
• Worked on Analysis Studio to develop multi dimensional reporting.
• Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports
• Coordinated with functional users for User Acceptance Testing prior to releasing system changes in production
• Deploying models and reports from Development to Production and administering users/groups/roles.
• Assisted Quality Assurance Team in documenting and analyzing their current process and then make recommendations for improvements in their functional areas
• Created documentation for the complete project life cycle and mentored the End Users and Provided the Technical Support.

Environment: Cognos 10.2.1 (Framework Manager, Transformer, Report Studio, Query Studio), Oracle 11g, Cognos SDK, WAS,SQL Server 2008, TOAD, PL/SQL, Java Script, Data Stage, zLinux.

Confidential,Newport,NJ

Sr. Cognos Developer / Administrator

• Involved in all phases of the data warehouse project lifecycle, which includes assessment, business requirements gathering, data modeling and database design, ETL/BI architectures, Reporting Model and report Development, performance tuning, and data delivery mechanisms.
• Created metadata models using Framework Manager with relational data and deployed packages to the Cognos Reporting Servers
• Designed and Developed DMR models using regular & fact dimensions in Framework Manager
• Implemented data level, object level and package level security in framework manager to achieve highly complex security standards
• Implemented Database Layer, Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts in Report Studio
• Developed Reports using Conditional Formatting, Cascading Prompts, optional prompts and Report Bursting
• Developed dimensional models in Transformer, built cubes and published cubes to Cognos Portal
• Involved in Upgrading Cognos reporting application from Cognos Version 8.4 to 10
• Created, refreshed and supported Cognos Transformer OLAP models and Power Play cubes
• Developed Dashboard reports to display all the information related to environment using Summary reports
• Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports
• Coordinated with functional users for User Acceptance Testing prior to releasing system changes in production
• Deploying models and reports from Development to Production and administering users/groups/roles
• Assisted Quality Assurance Team in documenting and analyzing their current process and then make recommendations for improvements in their functional areas
• Created documentation for the complete project life cycle and mentored the End Users and Provided the Technical Support

Environment: Cognos 10.1.1/8.4, Framework Manager, Transformer, Report Studio, Query Studio, Oracle 11g, SQL Server 2008, TOAD, SQL Navigator, PL/SQL, Java Script, Informatica 9, AIX.

Confidential, Warren,NJ

Sr. Cognos Consultant

• Worked with business users, functional lead to understand and document the Business requirements.
• Installed and Configured Cognos 8.4 BI in single server Environment
• Designed Functional Requirement Specifications for report development, modified relationships between different database tables and building models using Framework Manager
• Developed functional and technical specs based on requirements.
• Worked jointly with the data management team members to understand data domains, values, cardinalities and other dimensions of data needed to support BI solutions.
• Created Metadata Modeling by using multiple databases in Cognos Framework Manager.
• Created and Published packages from Cognos Framework Manager.
• Created Complex Reports in Report Studio.
• Created Powerplay Reports by using Analysis Studio.
• Developed multiple page reports with page-breaks based on the first page of the report using Master-detail relationship.
• Developed List, cross tab, drill through and complex reports which involved multi-queries.
• Extensively used Power play Transformer to move relative data mart data into powercubes.
• Created Scheduled Jobs by scheduling multiple reports in a job.
• Scheduled the reports and bursted reports according to user requirements in Cognos.
• Deployed Packages and Reports from DEV Environment to UAT and PROD Environments.
• Imported metadata from various sources such as Relational Databases, Report Net models, Impromptu Catalogs into the Framework Manager.
• Did Unit Testing for all reports and packages.
• Creating report views with saved prompts and schedule according to the business requirement.
• Created Jobs to Schedule multiple reports in Cognos Connection.
• Personalized Cognos Connection, Specified display options, regional options and personal information.

Environment: Cognos 8.4, Transformer 8.4, Report Studio, Query Studio, Metric Studio, Oracle 10g, Sybase IQ 12, Erwin 4.0, TOAD, PL/SQL, SDK,Informatica 8, UNIX (Sun Solaris).

Confidential, Horsham, PA

Sr. Cognos Developer

• Developed and implemented information management solutions as a part of Business Intelligence Organization.
• Involved in all phases of the data warehouse project lifecycle, which includes assessment, business requirements gathering, data modeling and database design, ETL/BI architectures, Reporting Model and report Development, performance tuning, and data delivery mechanisms.
• Participated in the design, development, deployment and support of Reporting solutions in the areas of Sales & Marketing, Forecast & Planning and Supplier Performance.
• Collaborated with business to develop high-level designs including logical models and functional specification documents.
• Actively worked with the BI team and Business to transition the application into Production Environment by providing support and training through the release cycle.
• Prepared training materials, developing Business models and training users in Query Studio according to their specific needs and requirements.
• Assisted and worked with ETL developers and data modelers to make sure that model being developed is according to the business requirements
• Developed complex Reports using different features like slice & dice, Drill capabilities, queries, Master detail and cross tab tables with multiple breaks.
• Designed and developed Powerplay cubes for multidimensional analysis for Sales & Marketing and Forecast & Planning users
• Recommended and designed summary tables to be used in reports to optimize performance.
• Administered Cognos BI Server Environment
• Managed Package Migrations and Deployments from one Environment to another.
• Managed Data Sources, run activities, user accounts and permissions
• Used Cognos SDK to develop various java applications.

Environment: Cognos 8.2, Transformer 8.2, Report Studio, Query Studio, Metric Studio, Oracle 10g, DB2 7, Erwin 4.0, TOAD, PL/SQL, Data stage, UNIX, Cognos 8 SDK.

Confidential,Hopkinton,MA

Cognos Developer

• Interviewed business community to identify business, data, and delivery requirements.
• Designed models in Framework Manager.
• Worked with Complex reports in Report Studio using master-detail relationship, drill through, burst options, cascading options and Prompts depending on user requirements.
• Created reports using cascaded prompts, value prompts, sections, dynamic filtering, conditional layouts and multi lingual reports in Report Studio
• Created reports containing multiple data containers like List, Cross-tab and Repeater tables
• Created dashboards for a managerial overview with drill up and drill down capabilities.
• Created models in Transformer, built cubes and published cubes to Power Play server.
• Scheduled reports using Cognos scheduler and emailed to various recipients as required.
• Worked on TOAD for Oracle database systems for creation of adhoc queries and for improving various performance issues.
• Experience with oracle as the target for the data marts.
• Used Data Source Query Subjects, Model Query Subjects and Stored Procedure Query Subjects in Framework manager.
• Test/validate system tables/files in System Test environment, UAT environment and finally in Production environment.
• Trained End users to operate the reports.

Environment: Cognos 8, Transformer 8, Report Studio, Query Studio, Metric Studio, Oracle 10g, Erwin 4.0, TOAD, PL/SQL, Data stage, UNIX, Cognos 8 SDK.