SUMMARY

• IBM Cognos Business Intelligence Solutions Developer with around 9 years of hands - on experience including enterprise BI architecture, BI strategies, solution roadmaps, system architecture, data modeling, application development, software testing, end-user training, business analysis/requirements gathering, impact analysis, gap analysis, functional specifications, change management, proposals, business cases, prototypes, statement-of-work, scope definition, project metrics, project charters, communication plans, strategic IT and resource planning.
• Experience in complete system development life cycle.
• Technical Lead for both on-shore and off-shore teams, delivered several projects through Confidential, Confidential Tele Services, Confidential Networks, Lion Re: Sources IT.
• Conducted BI Technical evaluations/reviews for Lion Re: Sources IT.
• Expertise in design and develop Cognos BI Metadata models (Framework & Transformer), building complex reports in adherence to best practices;efficient in designing planning, budgeting, and forecasting (PBF) systems. Design and deploy Scorecards & Dashboards which translates strategy into accountability and measure progress.
• Expertise in planning and performing migration of Cognos 7.x to Cognos 8.x and upgrade to Cognos 10.x.
• Installation, configuration, upgrade, administration, security setup, hardware sizing, load balancing, performance optimization, backup, disaster recovery, risk management of Cognos products - Cognos 10.x/8.x BI (Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio, Cognos Connection, Cognos Transformer, Powerplay Enterprise Server, Powerplay Studio), Cognos Series 7.x and LDAP and Active directory integration.
• Familiar with Cognos Series 7 Access Manager implementations - users, user classes and security.
• Experience in Oracle 10g, 11g, SQL Server 2008 databases.
• Experience on Windows, UNIX platform (Solaris).
• Learnt Dynamic Cubes and Dynamic Query Mode.
• Excellent Communication and interpersonal skills and Capable of learning new technologies very quickly.
• Ability to work under stringent deadlines with teams as well as independent.

TECHNICAL SKILLS

Business Intelligence Tools: Cognos BI 10.2/10.1.1/8.4/8.3/8. x (Framework Manager, Report StudioQuery Studio, Analysis Studio, Lifecycle Manager, Cognos ConnectionEvent Studio, Powerplay Enterprise, Cognos Transformer, Powerplay Studio), Cognos 10.2 Active Reports, Cognos Series 7.x, OBIP.

Databases: MS SQL Server 2008/2005, Oracle 11g/10g, Netezza.

Data Modeling/Project Tools: Microsoft Visio, PowerDesigner15.3, MS Office.

SQL Tools: PL/SQL Developer, TOAD.

Languages: SQL, PL/SQL, Batch, Shell, C, C++, JAVA.

LDAP/Web Technologies: Active Directory, SunOne, Apache Tomcat, HTML, Java, IIS.

Operating Systems: Windows 2008/2003/XP/2K, UNIX (Solaris).

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Sr. BI Report Developer

Responsibilities:

• Developed complex reports using Cognos 10.2 report studio.
• Interacted with internal and external business users to gather business requirements and to support through the entire report development cycle.
• Analyzed database schema, business logic, business and functional requirement for model and report generation.
• Used Java-scripts and other techniques in reports to achieve those dat are not out of Cognos box
• Used layout component reference feature to implement global prompts for all the Cognos reports.
• Delivered reports in excel or pdf using drill through functionality as per the users’ request.
• Scheduled reports and implemented bursting.
• Analysed the data in the DWH and created views in the DWH to be used in the Framework manager.
• Co-ordinated with the modelling team and the EDW team to produce quality results.
• Used customised SQL’s to build reports for which the data items were not available in the published package.
• Data Source creationin Cognos Connection, report migration across development, Quality Assurance and Production environments.
• Analysing the data in dat flows from the source systems to the DWH and talking to the source teams in case of discrepancies
• Built Cognos 10.2 cubes using the published packages/ reports.
• Learnt Dynamic Cubes and Dynamic Query Mode.
• Automated the cube refresh process through windows batch scripts.
• Used drill through functionality from the cubes to the reports from the Analysis studio.

Environment: Cognos 10.x (Report Studio, Query Studio, Analysis Studio, Cognos Connection), Powerplay 10.x, Powerplay Transformer, Oracle 11.2, TOAD for Oracle 11.6.

Confidential, Chicago, IL

BI Consultant

Responsibilities:

• Interacted with internal and external business users to gather business requirements and to support through the entire report development cycle.
• Analyzed database schema, business logic, business and functional requirement for model and report generation.
• Built complex reports and dashboards on Cognos 10.x/8.x/7.x.
• Used portal tabs, global prompts for dashboarding in Cognos 8.x.
• Delivered dashboards in excel or pdf using drill through functionality as per the users’ request.
• Analysed the data in the DWH and created views in the DWH to be used in the Framework manager.
• Created the Ad-hoc Reports in Query Studio.
• Metadata Modelling, migratingand publishing packages using Framework Manager
• Implemented object-level, Data level and package level security in Framework Manager Models for restricting access.
• Used session parameters, parameter maps to implement data level security.
• Managed Cognos Connection Portal and assigned users, roles and groups for authentication and authorization. Edited Governor settings in FM to reduce resource requirements and improve performance in SQL execution.
• Data Source creationin Cognos Connection, package migration across development, Quality Assurance and Production environments.
• Worked onHardware scoping, Load balancing, Migration Planning.
• Installed and Configured IBM Cognos 10.2, Cognos 8.4, Framework Manager, Transformer, Life Cycle Manager etc.
• Configured Content Stores and IIS web servers in Multi server environment.
• Migrated Impromptu 7.4 catalogs to Cognos 8.4, Powerplay 7.3 and Upfront to Cognos 8.4 and Powerplay Studio, automated cube building and deployment.
• Upgraged Cognos 8.4 to Cognos 10.2, used Life cycle manager to compare and test the performance of the reports simultaneously in both the environments.
• Error resolutions.
• Logged cases when needed with IBM Cognos for issues dat has been identified in the environment and worked with the support center resolve these issues.
• Analysing the data in dat flows from the source systems to the DWH and talking to the source teams in case of discrepancies.
• Onsite - Offshore coordination and management.

Environment: Cognos 10.x/8.x (Framework Manager, Report Studio, Query Studio, Cognos Connection, Cognos Configuration), Cognos 7.x, Powerplay 7.x, Upfront, Powerplay Transformer, Access Manager, Impromptu, SQL Server 2008/2005, SunOne Directory server, IIS

Confidential, San Diego, CA

BI Developer

Responsibilities:

• Performed System analysis, data analysis and suggested the scope of creation of BI reports and dashboards.
• Performed Gap Analysis and identified the gaps with the existing system
• Created reports using List, Cross tab, and Chart templates in Report Studio.
• Developed standard reports, Charts, Drill-through Reports and Master Detail Reports
• Created query prompts, calculations, conditions and Filters.
• Created Lists, Groups and Cross-tab reports with Drill-through functionality.
• Created Bursting Reports using Report Studio.
• Used Event studio to create agents and monitored the performance of key business factors
• Used Powerplay studio to drill down on cubes and perform business analysis
• Generated IQDs using Framework Manager and designed dimensional model in Transformer.
• Built Cubes in Transformer and Published them using the data sources and creating cube packages in Cognos 8.4.
• Involved in scheduling Report Studio and Query Studio reports and sending reports via email to several business users.
• Created filters within the Model for improving performance of the Model.
• Designed, Installed, configured IBM Cognos 10
• Load balanced the Cognos 10 BI Multi server environment for performance issues
• Responsible for all server maintenance, patching, upgrades, configuration, and performance tuning.
• Proactively managed multiple environments to ensure high availability, high performance, and minimization of risk.
• Installed, configured and Supported LDAP, Access Manager.
• Responsible in the setup of Cognos Security. Setup of user Groups, Roles etc.
• Migrated all the cubes and reports from old versions
• Followed Change Management Process and Procedures to perform production migrations from Test.
• Tested the reports with various testing methodologies like Functional testing, Regression testing and UAT.
• Migrated the reports from Cognos 8.4 to IBM Cognos 10
• Used Cognos Connection to administer and scheduling reports to run at various intervals.
• Set up for emailing the scheduled reports in any format.
• Set up Trigger based schedules for the reports as well as jobs.
• Created Chart palettes with company branding colors.
• Designed flexible, feature-rich reports from relational data sources such as MS-SQL Server, Netezza.
• Utilized Report Studio to create standard, nested cross-tabs and dash boards
• Planned and created professional Dashboard reports in Report Studio.
• Incorporated scripts into the report studio reports for various purposes.
• Set security for individual folders and reports in Cognos Connection.
• Involved in setting up Groups/Roles to secure the Models and packages
• Researched in house and vendor delivered technical references to halp locate solutions for a variety of reporting related bugs.
• Logged cases when needed with IBM Cognos for issues dat has been identified in the environment and worked with the support center resolve these issues.
• Provided on-call services and treated on-call duties with a sense of urgency. Escalated to management as needed.
• Responding to alerts or emergency issues during all times.
• Work with Vendor to rapidly resolve report issues or new incidents.

Environment: Cognos 10.x (Framework Manager, Report Studio, Query Studio, Event Studio, Cognos Connection, Cognos Configuration), MS-SQL Server, Netezza, Active Directory, IIS

Confidential, Portland, OR

BI Consultant

Responsibilities:

• Project Setup, Installation-Configuration and implementationof Cognos 10.1 BI environment on Windows 2008 R2 Platform. Implemented multi-server Architecture.
• User Security implementationby creating groups/ roles in Cognos Namespace and putting in the members or groups from the already integrated Active Directory in Cognos Configuration.
• Metadata Modelling, migratingand publishing packages using Framework Manager.
• Data Source creationin Cognos Connection, package migration across development, Quality Assurance and Production environments.
• Scheduling Report Studio reportsin Cognos Connection and bursting to the concerned recipients.
• User ID creation process and adding them to concerned groups in AD with the halp of UAM, AD teams and later assigning privileges to objects etc.
• Application Trigger implementation for automation of reporting cycle using batch scripts.
• Performance tuning of Windows Servers, Cognos Servers and Report studio reports.
• Prepared best practice documentsfor Backup strategy, Folder Structures, Performance and Tuning of servers and reports etc.
• Suggested certain templates for things to move in a certain process.
• Administered tasks such as Scheduling, Deployment, Dispatchers etc.
• Deployed Packages and Reports from one Environment to Another.
• Using CA EHealth tool to generate performance reports of the production servers (gateway/app).
• Customising (including SQL changes in the FM models) and bursting Audit reports to the concerned users.
• Customising the look and feel of the environment by making changes in the system.xml files at various locations.
• Generating/ Resolving Noetix reports/issues as per the requirement.
• Implemented/ installed hotfixes.
• Enabled SSL (Secured Sockets Layer) for security me.e. the URL starts with
• Prepared User documentation to train users and functionality of each report.
• Case resolution with the halp of Cognos Support team using Cognos Support secondary ID.
• Worked with the COE team internally and resolved certain critical issues in OBIP environment.
• Had a hands on how to design a DWH using Power designer 15.3.
• Onsite - Offshore coordination,

Environment: Cognos 10.x (Framework Manager, Report Studio, Query Studio, Event Studio, Cognos Connection, Cognos Configuration), Oracle 11g, Active Directory, IIS, OBIP, Noetix, EHealth tool

Confidential

BI Consultant

Responsibilities:

• Project Setup, installation-configuration and implementationof Cognos 8.2 BI environment on Unix platform.
• Migration from 7.4 Version of Cognos to 8.4.1 and Upgradation of 8.2 Version of Cognos to 8.4.1.
• User Security implementationusing Cognos Authentication Manager with Sunone Directory server.
• Installation and configuration of Sunone Directory server to Cognos Series 7.
• Metadata Modellingand publishing of packages using Framework Manager.
• Data Source creationin Cognos Connection, package migration across development and production environment.
• Scheduling Report Studio reportsin Cognos connection.
• Application maintenancetasks like reconfiguring content store, automating Powerplay cube refresh activities by shell scripts, User ID creation and maintenance, assigning privileges to objects etc.
• Application Trigger implementation for automation of reporting cycle.
• Performance tuning of Multidimensional cubes and Report studio reports.
• Best practice documentsfor data modelling on Report studio and Powerplay.
• Maintenance andtrouble shooting of Cognos OLAP environment.
• Configured LDAP Namespace to Cognos.
• Administered tasks such as Scheduling, Deployment, Dispatchers.
• Deployed Data from one Environment to another.
• Maintained the Product Licenses for Cognos Reportnet& Cognos Powerplay
• Designed the Security Architecture and Implemented it.
• Prepared User documentation to train users and functionality of each report
• Case resolution with the halp of Cognos Support team using Cognos Support secondary ID

Environment: UNIX, Cognos 8.x (Framework Manager, Report Studio, Query Studio, Event Studio, Cognos Connection, Cognos Configuration), Cognos 7.x, Powerplay 7.x, Upfront, Powerplay Transformer, Access Manager, Impromptu, Oracle 10g, SunOne Directory server, IIS

Confidential

BI Production Control Analyst

Responsibilities:

• Various production support tasks on tools like Maestro, Tivoli, Nagios, BMC ticketing tool etc.
• Involved in Installation of Cognos 8.4 (server components, Framework manager components and sample reports provided by Cognos)
• Involved in Configuring the same by providing the URIs for various file locations, configuring the content manager - content store and testing/ starting the service
• Configured IIS 5.0 to publish the content on to a web portal.
• Developed various business dashboards, Report Studio reports, templates, mailing reports, report level user wise security implementation.
• Modelled Report studio packages in Framework manager.
• Developed Powerplay Transformer modelsand built cubes using Transformer.
• User class wise and dimension categories wise'Security Implementation'in powerplay cubes.

Environment: Cognos 8.2 (Framework Manager, Report Studio, Query Studio, Cognos Connection), Powerplay 7.4, Active Directory, IIS 5.0