SUMMARY:

• More than 12 years of total IT experience as a Developer, Business System Analyst, BI Solution Architect, Delivery Lead in Cognos BI Installation, Architecture, Configuration, Administration, Maintenance, Design and Data Modeling, Development and Implementation of DW/BI, Reporting and Migration Projects.
• Experienced in Administration, Configuration, Installation, Maintenance, Development activities of IBM Cognos BI
• Extensive experience in Cognos Installation, Configuration in Distributed Multi Server/Location Installations, Load Balancing Implementations
• Extensive experience in Cognos BI Architecture, Environment Assessment, Capacity Planning, Sizing, Planning infrastructure components, Scalability and Availability
• Upgrades, Fix Packs, Migrations, Deployments, User Authentication, Access Permission and Security Setups.
• Proficient in integrating Cognos platforms with Corporate Intranets, for Single Sign - On and seamless integration, LDAP, AD, External Scheduling and Testing Tools.
• Involved in Performance Management, Cognos System Health Check, Strategy and Approach, Identification of Problem areas (Cognos Specific and Supporting Systems), Review and Implement Server Tuning settings and Evaluate Performance and use Cognos Support tools for Testing, Monitoring and Metrics collection.
• Worked with Multidisciplinary team with Cognos Architect, Modelers, Report Designer, DBA, ETL, Database team, Network/Firewall specialist, hardware specialist, OS Admin, PMO, Users and Tool users and Testing
• Involved in Point in time Load and Advanced tuning, Stress, Capacity and Stability, Scalability testing, Long term Load testing and Log Analysis for System Behavior, Performance issues and insights.
• Expertise in DMR and Relational Modeling using Framework Manager. Worked closely with EDW customers to capture and analyze business needs and Requirements and then architect a data solution.
• Expertise in Reports and Dashboards Development Activities using Report Studio/Analysis Studio/Query Studio
• Experienced in using UltiPro as source for HR reporting and dashboards
• Experienced in Data Analysis, Validation, Mapping, Verification, Conversion, Data profiling and Data cleansing and Data standardization. Experienced in ETL Architecture, Process flow, design and implementation from multiple data sources and file formats. Lead the ER / Dimensional Data Modeling and Report Database Design
• Handled Technical Presentations, Process model documents, Standards and Manuals, User requirements, Test strategy, Test plans, Prototypes and Proof of Concept Presentations, Reverse Engineering, Data Analysis, mapping and Data Dictionary, Design and Implement Process changes and Improvements
• Handled Resource Evaluation, Work Allocation and Monitoring, Client Relationship Management, Risk Assessment, Management and Mitigation, Facilitate SME, User and Developer Interaction, Project Road Map and Direction, Client Consulting for Solutions and Strategy, User and Transition, Timely and Consistent Delivery in Global Delivery Models - (Onsite, Offshore)

TECHNICAL SKILLS:

Business Intelligence Tools: Cognos 11.x/10.x/8.x Suite (Framework manager, Report Studio, Analysis Studio, Cognos Connection, Event Studio, Query Studio, Transformer 8), Impromptu, Tableau, Crystal Reports, Business Objects

ETL Tools: SSIS, Sagent, Data Stage, Informatica

Databases: Oracle 8.x/9.x/10g, SQL Server 2005/2008, Teradata, Netezza, IBM DB2

Programming Languages: HTM, JavaScript

Operating Systems: Windows, UNIX, Linux

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Cognos BI Architect

Responsibilities:

• Involved in the Requirements gathering for Reports
• Create Technical Specifications/Design documents for conversion of legacy reports to Cognos Reports
• Design and Development of Report Studio Reports and Conversion of legacy reports to Cognos Reports
• Design and Implementation of Relational and DMR model as per report requirements, Create Self Contained Data Mart for Reporting requirements by Business Area
• Cognos Framework Manager Model development using Stored procedures and Views and DMR
• Involved in Dimensional Modeling and Implemented Hybrid Approach to Reports and Dashboard Reporting using DMR, Relational Models, Stored Procedures and Embedded Sql
• Sales Force Management Dashboards and Analytics implementation
• IBM Cognos Analytics V11 installation, Configuration and Testing and Migration.
• Involved in migration Plan and analysis from Cognos 8.4, Cognos 10.2 to Cognos 11.0.6
• Cognos Impromptu to Cognos 11 conversion of reports
• Reports, Folders User Security Setup using groups
• Coordination with Business Users, Developers, Testers for Development, Testing for Reports Signoff
• Involved in Operational Readiness Testing plan and Implementation
• Create and Implement Event Studio Agents for Scheduling Reports and Managing Dependencies
• Production Go Live support and Post Deployment Support and Maintenance

Environment: Cognos 10.2, Cognos 11.0.6, Cognos 11.0.11, AIX 7.1, Windows 7, Oracle 12g,MS Apache 2.2.23, Oracle 12G Client, MS SQL Developer

Confidential, Chicago, IL

Cognos Lead

Responsibilities:

• Monitor production systems
• Analyze the tickets assigned
• Root cause analysis for ETL job failures in Informatica Power center and IDQ
• Apply minor changes for ETL jobs schedules
• Analyze the request for enhancements in reports and prepare the estimate for that.
• Co-ordinate with team for production support and development activities
• Interact with Business users to gather requirements & analyze problems in the reports
• Modify the models Cognos Framework Manager for minor enhancements
• Modify the reports in report studio
• Trouble shoot any reported data issues in Cognos reports

Environment: Cognos10.2 (Designer, Framework manager, Report Studio, Workspace Advanced, Query Studio ), Oracle Informatica Power center, IDQ

Confidential, Austin, TX

Cognos Architect

Responsibilities:

• Interacted with Business Unit Users to gather requirements & analyze problems as part of enterprise Software Development Process
• Built relations models and published packages in Cognos Framework Manager and created multidimensional models using Cognos dynamic cube
• Used MDX functions for developing reports
• Built standard and complex reports with embedded calculations, charts, and advanced reporting concepts using COGNOS Report studio
• Worked with multiple application data sources such as Netezza and SQL Server
• Developed Prompt pages and Conditional Variables, Render Variables, and Style Variables depending on user requirements
• Developed JavaScript to implement features not available in Cognos
• Co-ordinated with in-house BI team for developments and central communications between different users
• Worked as a data analyst
• Mentored offshore developers
• Used UltiPro data to build HR reports
• Cognos server installation and configuration
• Upgrade from Cognos 10.3 to Cognos 11
• Acted as Cognos Admin
• Implemented single sign on different environment
• Interacted with the End users on a regular basis for resolving issues pertaining to the reports
• Created views and aggregated tables
• Involved in moving the reports and packages from Deployment to UAT and Production

Environment: Cognos10 (Dynamic cube, Designer, Framework manager, Report Studio), UltiPro, JIRA, DataStage, SQL SERVER

Confidential, Beaverton, OR

Senior Cognos Developer

Responsibilities:

• Interacted with Business Unit Users to gather requirements & analyze problems as part of enterprise Software Development Process
• Built meta data models and published packages using COGNOS Framework Manager
• Built standard and complex reports with embedded calculations, charts, and advanced reporting concepts using COGNOS Report studio
• Worked with multiple application data sources such as Teradata, Oracle, and SQL Server
• Developed Prompt pages and Conditional Variables, Render Variables, and Style Variables depending on user requirements
• Developed JavaScript to implement dynamic features in report.
• Worked in Cognos SDK with Java team for customizing the burst process
• Setup report bursting and distributed the report
• Acted as point-of-contact for COGNOS consumers with in the business unit
• Co-ordinated with in-house BI team for developments and central communications between different users
• Mentored other developers for support of newly created reports
• Created technical specifications and documentation
• Used database tools to check the data in the database as compared to the requirement given and Performance tune them
• Created SQL queries to validate data on Teradata, Oracle and SQL server against COGNOS reports
• Interacted with the End users on a regular basis for resolving issues pertaining to the reports
• Created Stored procures to enable write back to data base through reports

Environment: Cognos10 (Framework manager, Report Studio), JIRA, MS WORD, MS EXCEL, SQL SERVER

Confidential, Plano, TX

Senior Cognos Developer

Responsibilities:

• Interacted with Business Unit Users to gather requirements & analyze problems
• Mediated clear communication between ETL team and the stakeholders to allow clarity and solutions to flow with synergy
• Involved in building relational and DMR data Models
• Created/modified published packages based on the reporting requirements and implemented star schema grouping
• Built meta data models and published packages using COGNOS Framework Manager
• Validated technical designs created by data modelers and ETL developers against functional specifications
• Created reports involving complex calculation such as trend line using multiple queries and queries
• Developed custom SQL to create reports
• Created executive dashboards and complex report in report studio
• Developed Prompt pages and Conditional Variables, Render Variables, and Style Variables depending on user requirements
• Identified and resolved the cause of performance issues such as unwanted stitch query and in full table scanning due to incorrect index
• Implemented report bursting to file system
• Created interactive reports for offline users using Active reports
• Created individual charts and integrated into dashboard using i-frame and linked i-frame to saved output in reports
• Co-ordinated with testing team to ensure flawless implementation
• Co-ordinated post implementation activities

Environment: Cognos10 (Framework manager, Report Studio), JIRA, MS WORD, MS EXCEL, ORACLE

Confidential

Lead Cognos Developer

Responsibilities:

• Determined user/business/functional requirements. Created data requirements document, source to target mapping, data model mapping, project charter, project status update documents
• Analyzed existing data ware-house, data models, and existing data enterprise systems
• Mediated clear communication between ETL team and the stakeholders to allow clarity and solutions to flow with synergy
• Validated technical designs created by data modelers and ETL developers against functional specifications
• Designed test plans and test cases for User Acceptance Testing (UAT)
• Performed requirement analysis by analyzing the XLS report mock-ups provided by the client
• Provided artifacts to the ETL team for data mart design based on the reporting requirements
• Involved in building relational and DMR Models
• Used MDX queries
• Created/modified published packages based on the reporting requirements and implemented star schema grouping
• Created reports involving complex calculation such as trend line using multiple queries and queries
• Developed custom SQL to create reports
• Developed complex reports that contain chart and list constructs with drill through capability to other reports and used filters, bookmarks, cascading prompts (value prompts, date prompts, search and select prompts) and conditional blocks to address reporting specifications
• Implemented complex formatting of reports using crosstab space and joining lists to match with XLS sample

Confidential

Senior Cognos Developer/Subject Matter Expert

Responsibilities:

• Conducted interviews with IT team and business users to understand the requirements and the existing reports
• Analyzed the existing Business Object and Cognos reporting environment to understand the current system and the requirements scope
• Created complex reports which involved multiple pages and conditional formatting based on report output
• Created complex list report(List with expand and collapse option) using javascript
• Developed multidimensional OLAP Cubes from Cognos Packages.
• Created event based triggering of reports using event studio
• Creating design specification template for reports
• Created relational models using FM and creates reports using report studio, analysis studio.
• Created reports using List Reports, singletons/tables, repeater tables
• Create cubes using Transformer for OLAP reporting using Analysis studio.
• Applied advanced reporting concepts like Dynamic Sorting and Dynamic grouping using backend Cognos SQL and Cognos prompt macro
• Developed Prompt pages and Conditional Variables, Render Variables, and Style Variables depending on user requirements
• Extensively worked on Report studios to develop simple to complex relational reports
• Worked with Drill- through Definitions to drill through from one report to another report back and forth on Report Studio
• Onsite offshore co-ordination for Cognos team, which involves daily status calls with Cognos team, resolving the specific issues in Cognos reports and providing technical details about Cognos cubes

Environment: Cognos10 (Framework manager, Report Studio, Transformer), ORACLE, SQL SERVER

Confidential

SR. COGNOS Developer

Responsibilities:

• Involved in Requirement gathering from Business Users
• Analyzing the specifications provided by the clients and Developing specification documents for reports as per client requirements
• Updated the Framework Manager models and Published packages to COGNOS connection
• Design & development of the reports using Cognos 8/10 Report Studio
• Extensively worked on Report studios to develop simple to complex relational reports
• Worked with Drill- through Definitions to drill through from one report to another report back and forth on Report Studio
• Created reports using List Reports, singletons/tables, repeater tables
• Created complex dashboards with area charts, pie charts, Lists and Multi prompts in Report Studio
• Applied advanced reporting concepts like Dynamic Sorting and Dynamic grouping using backend Cognos SQL and Cognos prompt macro
• Developed Prompt pages and Conditional Variables, Render Variables, and Style Variables depending on user requirements
• Tested reports using review checklists for Quality Assurance before delivering to the end users
• Updated reports based on QA feedback
• Used database tools to check the data in the database as compared to the requirement given and Performance tune them
• Ran SQL queries to validate data on DB2 and Cognos report server
• Involved in moving the reports and packages from Deployment to UAT and Production

Environment: Cognos10 (Framework Manager, Report Studio), Cognos 8.4 Suite (Framework Manger, Report Studio)

Confidential

Cognos/Sagent Developer

Responsibilities:

• Involved in Requirement gathering from Business Users
• Analyzing the specifications provided by the clients and Developing specification documents for reports as per client requirements
• Design and Developed the Framework Manager models and Published packages them to Cognos connection
• Created packages in Framework Manager to publish cubes and use them in Analysis Studio
• Design & development of the reports using Cognos 8 Report Studio, Analysis Studio reports
• Extensively worked on Analysis Studio to develop multi-dimensional reporting
• Worked with Global Drill- through Definitions to drill through from analysis studio reports to report studio reports
• Upgraded reports from Cognos 8.3 to 8.4 making sure the functionality is not affected
• Created complex dashboards with area charts, pie charts, Crosstab and Multi prompts in Report Studio
• Developing Prompt pages and Conditional Variables depending on user requirements
• Testing reports using review checklists for Quality Assurance before delivering to the end users
• Used database tools to check the data in the database as compared to the requirement given and Performance tune them
• Involved in moving the reports and packages from Deployment to UAT and Production
• Interacting with the End users on a regular basis for resolving issues pertaining to the reports
• Coordinating with Development Team tasks & Deliverables and working on high priority issues

Environment: Cognos 8.3/8.4 Suite (Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio, Cognos Office Connection), Oracle 9i, 10g, Windows 2003 Server

Confidential

Cognos Developer

Responsibilities:

• Analyzed Business requirements from the analysts and established scope, risks, assumptions and success criteria; Identified business sponsor; vendor selection
• Interviewed business community to identify business, data, and delivery requirements
• Customized COGNOS Connection with appropriate reports and security measures
• Worked on Analysis Studio to develop multi dimensional reporting
• Involved in Designing DMR models with Relational Data using Framework Manager and deployed packages to the Report Servers
• Created custom prompted reports in Report Studio, Bursting reports to different user groups
• Involved in Designing models using Framework Manager and deployed packages to the COGNOS Connection
• Implemented Framework manager security for Data access, Object level access and Package access
• Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager Model
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, multi-query, Cubes in Report Studio, Burst Reports against database
• Developed Stored Procedures and Database Triggers in PL/SQL
• Scheduled Reports using COGNOS Connection
• Developed Framework Manager Models with Physical layer and Presentation Layer to cater the various businesses needs (Folders, Filters, and Macros)
• Implemented Third Party Security with LDAP and use those in creating Data Level, Object Securities in Framework Manager Models
• Worked in Windows and to some extent in UNIX environments
• Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports in Query Studio and Report Studio
• Transferred technical knowledge specific to COGNOS tools and the existing data model to other team members
• Prepared User documentation to train users and explain functionality of each report

Environment: COGNOS 8.4 Suite (Framework Manger, Report Studio, Query Studio, Analysis Studio), Oracle 9i/10g, windows server 2003, UNIX

Confidential

Cognos Developer

Responsibilities:

• Requirement gathering and analyzing the reporting requirements.
• Created high level design documentation and detail design documentation.
• Developed the data mart using various ETL tasks to clean data and make it in a uniform format.
• Created reports in Cognos report studio based on requirements.
• Worked on performance tuning of the reports.
• Performed unit testing and integration testing of the reports.
• Participated in supporting the User Acceptance Testing.
• Led the design and implementation of a consolidated dashboard for the entire Contract and Compliance Services (CCS) team with a Graphical User interface
• Identified the various requirements and components of the various sub-departments within Contract and Compliance Services
• Programmed in Visual Basic to link the multiple levels of user interface to the Excel Spreadsheets
• Organized data into Excel Spreadsheets using VB programming
• Created macro programs to automate the report generation
• Success of the project led to the creation of a new team to maintain and develop and enhance the dashboard further

Confidential

Cognos/Hyperion Developer

Responsibilities:

• Analyzed the excel templates provided by the client.
• Created the mapping based on the requirement
• Created reports in report studio to match the reports in excel.
• Created the reports in Hyperion designer
• Unit Testing the reports