Professional Summary

• Total 10 years of experience in implementing Business Intelligence solutions using Cognos BI and Informatica suite in different environments.
• Knowledge of complete BI Life Cycle Development process.
• Having strong knowledge on Data warehousing Concepts.
• Extensive experience in gathering and documenting user requirements.
• Good understanding of Multi Dimensional Modeling using Star and Snowflex Schema.
• Developed reports in Cognos 8/10 BI Suite using Report Studio, Query Studio, Analysis Studio, Cognos ReportNet Report studio, Query Studio and in Cognos Enterprise Series 7 using Impromptu and Power Play for windows.
• Extensive experience in installation and configuration of Cognos 8/10 Environments
• Expertise in Bursting and Scheduling of Reports.
• Proficient in designing complex reports using Conditional Prompts, Filters, Cross Tab, Graphs, Chart, Dynamic Reports, Dash boards, Multi Query reports and Drill-Through Reports.
• Worked on Security access to clients using Access Manager and worked with Data Security, Object Security, and Package Security.
• Extensively worked on Informatica tools such as Informatica Repository Manager, Designer Source Analyzer, Warehouse designer, Mapping designer, Transformations Mapplets .
• Expertise in Deployment using Cognos Connection Portal in Cognos 8/10.
• Extensive experience in Migrating to Cognos 10.2/10.1 from 8.2/8.3/8.4 versions.
• Extensive experience in Cognos BI Life Cycle Manager.
• Extensively working on Oracle 10g, 11g and DB2.
• Extensively working on Design, Installation, Configuration, Administration, Maintenance and Upgrade of Cognos8 BI servers on DEV, UAT and PROD Environments.
• Working on Operational support coverage to solve technical problems 7/24 365 days , Code deployments, User Administration, Non-Prod environment support, Development support, Automation Support, Net-backup support, all scheduled jobs to build reporting objects in the environment maintaining system and server performance, server administration including disk usage, memory usage, server monitoring.
• Performing monthly Disaster Recovery, upgrades and applying Cognos code fixes, Application server fix pack as applicable.
• Experience with the design and delivery of Extraction Transformation and Loading ETL tool and applications including decision support application development approaches, methodologies and technologies OLAP, MOLAP, ROLAP, OLTP, Informatica Power Mart 7.1/8.1 Power Center 7.1/8.1 Designer, STAR Schema, SNOW-FLAKE Schema design, ETL and UNIX .
• Extensively working on daily vaulting, weekly vaulting NetBackups on Veritas NetBackup 6.0 Enterprise Server.
• Extensive experience install configure and Maintain SQL Server Databases.
• Built Multidimensional cubes using PowerPlay Transformer.
• Good Knowledge on Informatica Data Stage tools as ETL Developer.
• Proficient and hands on experience with Informatica Cognos Data manager/ Decision Stream.
• Develop the Informatica mappings/workflows/worklets/session.
• Experience in testing the data consistency between Source System - DW and DW-Report.
• Excellent analytical and communication skills, ability to work independently and also a good team player.
• Good experience in training end users.
• Ability to rapidly learn new concepts together with excellent interpersonal skills.
• Exceptional communication, analytical, presentation and problem solving skills.
• Excellent skills in understanding business needs and converting them into technical solution.
• Experience in handling tickets for production support.
• Good experience in analysis, design, testing, development and implementation of client/server applications.
• Deploy the Cognos code Transformer models, Framework Models/Packages, reports and cube views from Dev to UAT and from UAT to Production environment.
• Installation of patches in Cognos or Microsoft or windows.
• Make sure to balance the load on the servers.
• Closely monitor the servers during month end.
• Managing the current activities.
• Reboot the servers on weekly basis on sequential order.
• Managing the Dispatchers and services.
• Guide the Cognos developers to follow the project standards at the time of designing.
• Set up the security to projects.
• Creating the Data source connection for an application
• Create Users, user groups in Cognos access manager and associate them into Cognos connection.
• Installation and configuration of cognos software in new developer system.
• Creating a profile and grant the access to new developers.
• Make sure to take the backup of code.
• Maintaining the source code in configuration management.
• Make sure to deliver the scheduled reports on daily/weekly/monthly.

Technical skills

OLAP Tools : Cognos 10.1/8/7 BI Framework Manager, Query Studio, Report Studio, Analysis Studio, Metric Studio and Event Studio, Cognos Connection, Power play Transformer, Workspace, Workspace Advanced, Business Insight, Cognos cube Designer, Access Manger, Cognos administration. ,Cognos EP 7 Impromptu ,Web Reports IWR , Upfront, BOXI3,Crystal reports 9.0. IBM Web Sphere Application Server ,OBIEE, SSRS ,SSIS,SSAS, Micro strategy, Access Manager, Hyperion Essbase, Hyperion DRM, , Hyperion Essbase, Hyperion DRM,SAP BPC .

ETL Tools : Informatica8/7, Data stage, Data Manager8.4, Abinitio, SSIS.

Databases : Oracle 11g/8i//9i/, MS SQL Server, DB2, SQL Server2008, Teradata.

Database Tools : Toad, WINSQL.

Languages : C, C , Java, .NET, COBOL, Pascal, FORTRAN, HTML, XML, Visual Basic 6.0,

PL/SQL

Operating Systems : Windows NT/98/2000//XP, Unix/Linux, AIX Sun-Solaris.

Web services : Java/ Web Server, IIS 4.0/5.0, Netscape Directory Server, Apache Web

Tomcat 4.01. IIS, Sun Salaries, Red Hot, Linux, UNIX.

Other Tools : Adobe Photo Shop, MS Office2003, MSAccess, MSExcel.

Professional Experience

Confidential

Role: BI Consultant

Key Responsibilities:

• Analyzed the business processes, data analysis requirements and Developed specification documents for reports as per client requirements.
• Deploy the Cognos code Transformer models, Framework Models/Packages, reports and cube views from Dev to UAT and from UAT to Production environment.
• Installation of patches in Cognos or Microsoft or windows.
• Make sure to balance the load on the servers.
• Closely monitor the servers during month end.
• Managing the current activities.
• Reboot the servers on weekly basis on sequential order.
• Managing the Dispatchers and services.
• Guide the Cognos developers to follow the project standards at the time of designing.
• Set up the security to projects.
• Creating the Data source connection for an application
• Create Users, User Groups in Cognos access manager and associate them into Cognos connection.
• Installation and configuration of cognos software in new developer system.
• Creating a profile and grant the access to new developers.
• Maintaining the source code in configuration management.
• Make sure to deliver the scheduled reports on daily/weekly/monthlyEnsure the timely and quality deliverables of Cognos and Informatica tasks assigned to me.
• Managing the Dispatchers and services.
• Set up the security to projects.
• Create Users, user groups in Cognos access manager and associate them into Cognos connection.
• Creating a profile and grant the access to new developers.
• Make sure to deliver the scheduled reports on daily/weekly/monthly.
• Extensive experience in Migrating to Cognos 10.2/10.1 from 8.2/8.3/8.4 versions.
• Extensive experience in planning and implementation of: Cognos server scaling, Cognos architecture, Cognos capacity planning, Cognos load testing,Cognos query/performance tuning, Cognos failover, Cognos load balance, Cognos advance routing, Cognos back-up and recovery
• Extensive experience for the health of the Cognos 10 BI environment DEV, QA and PROD.
• Extensively managed the security of the Cognos 10 BI environment.
• Extensive experience in monitoring all scheduled jobs including reports for business users, ETL jobs
• Extensive experience in setting up standard and architecture of the meta data layer
• Extensive experience in Staging Layer, Core Layer, Semantic Layer design and data modeling to meet the business requirements semantic and presentation layers.
• Extensive experience in providing performance monitoring and tune services on BI server platforms
• Extensive experience in ensuring stability given large, uneven requests of BI environment for reporting and adhoc analysis
• Extensive experience in setting up and manage multiple environments for application and report development, testing, training and production environment
• Strong experience in Setting up and manage domain groups/access rights Name spaces for BI platform users
• Strong experience in follow change management process and procedures to perform production migrations from test and other environments
• Extensive experience in documenting installation steps, environments custom configurations, production system changes and technical architecture platforms
• Extensive experience in assisting developers with test planning, test conditions and obtaining test data
• Extensive experience in supporting Cognos reports, cubes migrate to different environments
• Performing in-depth and comprehensive system, application and user-object troubleshooting coordinating with users, other department personnel, vendors and service technicians
• Extensive experience in consult with business community to gather requirements for specific BI scorecard, dashboard and reporting needs.
• Extensive experience in Cognos 10 Administration to work in a fast paced environment.
• Extensive experience in multiple server environments in distributed architecture, with plans to upgrade to 10.1.1/10.2.1.
• Extensive experience in work on problems of diverse scope with moderate to high complexity
• Extensive experience in root-cause-analysis, problem identification and resolution, optimization and performance tuning, security, backup and data recovery.
• Extensive experience work closely with the client to design, implements, and architects an enterprise environment that spans multiple divisions and groups, and integrates data and processes throughout the organization.
• Strong expertise in the following functional area such as Security Management, Patching and applying bug fixes, Performance Tuning, Backup and Recovery.
• Monitored System Performance identifying the no of items in the queue using Metrics available in Cognos Administration.
• Strong experience in installation of products and Cognos Modules, experiences working with Cognos support and ticket escalation
• Extensive experience in Participate in the design and development of enterprise-wide data repositories.
• Extensive experience in Design and validate Cognos Framework Models as assigned, working with BI analysts and DBAs to ensure appropriate database views and/or tables are available to support the Framework information needs and that accurate information is presented through the framework.
• Provided guidance on and adhere to best practices in Cognos Framework design and development as well as change management.
• Extensive experience in performance tuning/optimization of the Framework in coordination with database layer tuning performed by the DBA and application team.
• Make recommendation to improve the efficiency and functionality of the database and Cognos BI environment
• Designed and developed scorecards, dashboards and multi-dimension data cubes using Cognos
• Developed and executed a verification and security strategy to ensure the accuracy of the data distributed in the reports
• Design the different documents like Requirement Specification and Low Level Design Documents for Reports.
• Prepare the Test cases for Cognos reports and Informatica Mappings.
• Creation of reports based on simple, medium and complex using Cognos8 and 10.
• Do the Unit testing for accuracy of the reports.
• Fixing the issues of defects during the monitoring.
• Analysis of the ETL Mappings/Sessions/Workflows/Worklets in Informatica.
• Monitor the ETL mappings/jobs during the Production Support.
• Extensively worked on Informatica tools such as Informatica Repository Manager, Designer Source Analyzer, Warehouse designer, Mapping designer, Transformations Mapplets ,
• Responsible for Extracting, Transforming and Loading data from Oracle, Flat file and lacing it into Data warehouse.
• Design and Development of Mappings, Mapplets using Informatica Power Center.
• Failure analysis for Informatica loads using Error logs.
• Configuring Repository Manager, created folders and managed objects in repository manager of Informatica.
• Creating Informatica mappings to build business rules to load data. Most of the transformations were used like the Source qualifier, Aggregator, update strategy, Router, Expression, lookups, Filters Sequence Generator.
• Managing the current activities.
• Follow up with Users for any clarifications.
• Fixing all issues which are raised in Remedy Ticket tool by Users.
• Creating the Data source connection for an application
• Design the cognos reports as per the deadline.
• Validate the reports with Users.
• Preparation of the KT plan.
• Arrange KT sessions for new support applications with planned time table.
• Give estimations for new developing reports/TPA.
• Executed the Cognos migration project from Impromptu to Cognos8 for UK Apps.
• Maintain good relationship with Customer/Superiors/Team members.
• Configuration of Cognos content store.
• Identify risks and communicated to Supervisor.
• Guide the Cognos developers to follow the project standards at the time of designing.
• Developed the Best Practices method for Creating Report Template, Report Prompt Page, Governor Settings and Report Naming Convention in Cognos 8.4 10.
• Designed very informative and efficient relational models using functionalities like Shortcut Alias only available in Cognos 8.4 Framework Manager.
• Created Executive Dashboards to represent the financial data
• Deploy the Cognos code Transformer models, Framework Models/Packages, reports and cube views from Dev to UAT and from UAT to Production environment.
• Installation of patches in Cognos or Microsoft or windows.
• Monitored System Performance identifying the no of items in the queue using Metrics available in Cognos Administration.
• Scheduled and Distributed 8/10 BI reports using Schedule Management in Cognos Connection.
• Created new Groups and Roles in Cognos 8 and associating with the new packages.
• Setting up New Users in Access Manager and giving them the required permissions.
• Business User Training to get them familiarized to Cognos Connection environment and also helped them in the transition from Series 7 Upfront to Cognos Connection.
• Demonstrated the Cognos 8/10 environment, tools with their functionality.
• Reboot the servers on weekly basis on sequential order.

Environment: Cognos10.1 Cognos Connection, Framework Manager, Report Studio, Query Studio, Analysis Studio, Metric Studio and Event Studio, Configuration Manager, Power play Transformer, Cognos cube Designer, Access Manger, Workspace, Workspace Advanced, Business Insight, Cognos Administration ,Informatica,Teradata,Oracle11g,MSSQL Server.

Confidential

Role: Cognos Administrator/Modeler/Developer

Key Responsibilities:

• Requirement Analysis Estimation Interaction with business users/analysts to clarify doubts and provide technical inputs to them. Analyze the complexity of the requirement and communicate the effort estimate to client.
• Functional understanding of existing and new reports
• Functional understanding, documentation of tactical and strategic client mart.
• Business requirement analysis. Conversion of business requirements into technical understanding.
• Involved in gathering Onsite-Offshore connectivity requirements and setting up the connectivity at offshore.
• Proficient in implementing user level and data level securities within Cognos 8
• Strong experience in Cognos server build, Sizing, troubleshooting, tuning ,POC disaster recovery exercises.
• Extensive experience of data warehouse modeling, architectures, OLAP, OLTP data sets.
• Proactively monitoring threshold/s setup in Cognos 8 environment.
• Strong expertise with tuning Cognos BI OLAP components for faster access and performance i.. Transformer, PowerPlay Cube, PowerPlay Client and PowerPlay Studio
• Extensive experience install configure and Maintain SQL Server Databases
• Successfully completed Cognos v8.4 upgrade for the various reporting suites to the defined scope, project plan and implementation plan to specified timeline.
• Extensively working on the configuration of the Cognos environments such single server and multiserver components, failover, load balance mechanism including the underlying WebShere Application Server and database components such as Audit and Cognos Content Store.
• Daily, Weekdays, Weekend, off-hour Support to developers with the Cognos framework engineers, as needed, to assist in problem determination of complex issues including assistance in analyzing application performance problems.
• New Development, Enhancement, Maintenance and Migration of applications in the Development tower.
• Experience with migration of hot files, catalogs, reports, power play Transformer cubes from Cognos Series 7.1/7.4 to Cognos 8.2 using Migration Utilities.
• Customize the Cognos connection portal using existing portlets and customized tabs.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, multi-query reports, Burst Reports and Dashboard reports against database.
• Creating cross-tab reports and chart reports using multiple queries and drill down capabilities in a single report to meet the business needs.
• Created Cubes MOLAP/ROLAP using IQD's which were built in Framework manager and DMR Metadata Modeling.
• Supported Cognos Transformer models and cubes. Involved in implemented security at transformer level by creating custom views. Created Calculated Measures in Transformer.
• Working with Informatica Power Center client tools like Source Analyzer, Warehouse Designer, Mapping Designer and Transformation Developer.
• Developed the Mappings/Worklets/Workflows/Sessions in Informatica.
• Fixing the issues of defects during the SIT.
• Using Developed SQL scripts for business data loads.
• Imported data from various Sources transformed and loaded into Data Warehouse Targets using Informatica client Tools.
• Involved in Unit testing, System integration and UAT.

Environment: Cognos 8.2 Framework Manager, Report Studio, Query Studio, Analysis Studio, Cognos Connection,

Metric Studio and Event Studio, Configuration Manager Cognos Administration , CognosEP7 PowerPlay7.1/7.4, Impromptu7.1/7.4,PowerplayTransformer ,Informatica,Oracle,DB2,Windows 2000sever, Cognos Migration tools.

Confidential

Role: Cognos Developer

Responsibilities:

• Created metadata models, made appropriate Joins, organized Folders according to the Business view and published the packages using Framework Manager onto Cognos Connection.
• Designed various types of reports according to end user requirements.
• Applied advanced formatting features to the reports using Query Studio and Report Studio.
• Developed Rank reports and Section reports using Query Studio.
• Designed reports with conditional formatting.
• Designed reports using cross tab.
• Developed single select and multiple select cascading prompts.
• Scheduled reports using cognos connection Web portal.
• Created master detail relationship report.
• Extraction of data from source systems present at different physical locations both for historical load and ongoing processes.
• Worked with Blocks in simple list reports.
• Loading the transformed data into the data warehouse.
• Testing the Cubes data for accuracy and monitoring the BI Portals.
• Running the job streams manually when required.
• Monitoring the nightly jobs using Tivoli Scheduler and fixing the issues on daily basis.
• Created Views for Generating reports.
• Extraction of data from source systems present at different physical locations both for historical load and ongoing processes.
• Handling the enhancement work.
• Provided administrative support for production issues.
• Involved in Creating Content store, installation and configuration of the Cognos8
• Involved in design and development of joins, filters, calculations and conditional variables in DMR Packages within Framework Manager.
• Created complex reports using Report Studio and Ad-hoc web based reports using Query Studio.
• Published Impromptu Web Reports IWR and PowerPlay cubes reports onto the Upfront using Cognos IWR administration as well as PowerPlay Enterprise Server
• Performed Pivoting, Drill-down, Slice Dice and Filtering operations done for all OLAP applications.
• Extensive experience in Exceptional highlighting, sorting and ranking.
• Performance tuning power-Dynamic cubes IQD to reduce Query time and Partitioned Cubes.
• Involved in Scheduling reports using Cognos Scheduler.
• Trained end users on Query Studio for Ad-hoc reporting as well as involved in the Documentation.

Environment: Cognos 8 BI Report Studio, Query Studio, Cognos Connection, Framework Manager, Cognos Administration , Cognos EP ,Impromptu Web Reports 7.3, Power play Transformer 7.3, Cognos Data Manger, Decision Stream designer,DB2,MS SQL Server, Windows 2K.

Confidential

Role: Cognos/Informatica Developer

Responsibilities:

• Analysis of the specifications provided by the clients
• Responsible for gathering/refining requirements from the customer for developing reports.
• Loaded operational data from Oracle, Flat Files into transient Tables and cleaned the data using appropriate business rules.
• Worked on Informatica power center, Source Analyzer, Warehouse Designer, Mapping Designer and Workflow Manager.
• Implemented Expression, Aggregator, Sorter, Lookup, Update Strategy, Filter Transformations.
• Developed reports in report studio.
• Implemented filters, prompts, Formatting, Look and Feel and drill through capabilities
• Designed various types of reports according to end user requirements.
• Developed simple as well as complex reports using Report Studio.
• Developed standard templates which could be used as foundation of all reports.
• Designed reports with conditional formatting and drill through.
• Created multi page reports using conditional layouts.
• Involved in creation reports with value prompt, select and search prompt.
• Created the reports on daily, weekly and monthly basis.
• Prepared the unit test cases.

Environment: Informatica Power Center, Cognos, Windows XP and Oracle.