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 wif 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 teh 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 wif teh 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 wif Informatica & Cognos Data manager/ Decision Stream.
• Develop teh Informatica mappings/workflows/worklets/session.
• Experience in testing teh 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 wif 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 teh 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 teh load on teh servers.
• Closely monitor teh servers during month end.
• Managing teh current activities.
• Reboot teh servers on weekly basis on sequential order.
• Managing teh Dispatchers and services.
• Guide teh Cognos developers to follow teh project standards Confidential teh time of designing.
• Set up teh security to projects.
• Creating teh 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 teh access to new developers.
• Make sure to take teh backup of code.
• Maintaining teh source code in configuration management.
• Make sure to deliver teh scheduled reports on daily/weekly/monthly.
• Certified in COGNOS BI.

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.0PL/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, Woodcliff Lake, NJ

BI Consultant

Responsibilities:

• Analyzed teh business processes, data analysis requirements and Developed specification documents for reports as per client requirements.
• Deploy teh 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 teh load on teh servers.
• Closely monitor teh servers during month end.
• Managing teh current activities.
• Reboot teh servers on weekly basis on sequential order.
• Managing teh Dispatchers and services.
• Guide teh Cognos developers to follow teh project standards Confidential teh time of designing.
• Set up teh security to projects.
• Creating teh 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 teh access to new developers.
• Maintaining teh source code in configuration management.
• Make sure to deliver teh scheduled reports on daily/weekly/monthlyEnsure teh timely and quality deliverables of Cognos and Informatica tasks assigned to me.
• Managing teh Dispatchers and services.
• Set up teh security to projects.
• Create Users, user groups in Cognos access manager and associate them into Cognos connection.
• Creating a profile and grant teh access to new developers.
• Make sure to deliver teh 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 teh health of teh Cognos 10 BI environment DEV, QA and PROD.
• Extensively managed teh security of teh 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 teh meta data layer
• Extensive experience in Staging Layer, Core Layer, Semantic Layer design and data modeling to meet teh 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 wif 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 wif users, other department personnel, vendors and service technicians
• Extensive experience in consult wif 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, wif plans to upgrade to 10.1.1/10.2.1.
• Extensive experience in work on problems of diverse scope wif 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 wif teh client to design, implements, and architects an enterprise environment that spans multiple divisions and groups, and integrates data and processes throughout teh organization.
• Strong expertise in teh following functional area such as Security Management, Patching and applying bug fixes, Performance Tuning, Backup and Recovery.
• Monitored System Performance (identifying teh no of items in teh queue) using Metrics available in Cognos Administration.
• Strong experience in installation of products and Cognos Modules, experiences working wif Cognos support and ticket escalation
• Extensive experience in Participate in teh design and development of enterprise-wide data repositories.
• Extensive experience in Design and validate Cognos Framework Models as assigned, working wif BI analysts and DBAs to ensure appropriate database views and/or tables are available to support teh Framework information needs and that accurate information is presented through teh 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 teh Framework in coordination wif database layer tuning performed by teh DBA and application team.
• Make recommendation to improve teh efficiency and functionality of teh 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 teh accuracy of teh data distributed in teh reports
• Design teh different documents like Requirement Specification and Low Level Design Documents for Reports.
• Prepare teh Test cases for Cognos reports and Informatica Mappings.
• Creation of reports based on simple, medium and complex using Cognos8 and 10.
• Do teh Unit testing for accuracy of teh reports.
• Fixing teh issues of defects during teh monitoring.
• Analysis of teh ETL Mappings/Sessions/Workflows/Worklets in Informatica.
• Monitor teh ETL mappings/jobs during teh 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 teh transformations were used like teh Source qualifier, Aggregator, update strategy, Router, Expression, lookups, Filters & Sequence Generator.
• Managing teh current activities.
• Follow up wif Users for any clarifications.
• Fixing all issues which are raised in Remedy Ticket tool by Users.
• Creating teh Data source connection for an application
• Design teh cognos reports as per teh deadline.
• Validate teh reports wif Users.
• Preparation of teh KT plan.
• Arrange KT sessions for new support applications wif planned time table.
• Give estimations for new developing reports/TPA.
• Executed teh Cognos migration project from Impromptu to Cognos8 for UK Apps.
• Maintain good relationship wif Customer/Superiors/Team members.
• Configuration of Cognos content store.
• Identify risks and communicated to Supervisor.
• Guide teh Cognos developers to follow teh project standards Confidential teh time of designing.
• Developed teh 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 teh financial data
• Deploy teh 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 teh no of items in teh 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 wif teh new packages.
• Setting up New Users in Access Manager and giving them teh required permissions.
• Business User Training to get them familiarized to Cognos Connection environment and also helped them in teh transition from Series 7 Upfront to Cognos Connection.
• Demonstrated teh Cognos 8/10 environment, tools wif their functionality.
• Reboot teh 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, Albany, NY

Cognos Administrator/Modeler/Developer

Responsibilities:

• Requirement Analysis & EstimationInteraction wif business users/analysts to clarify doubts and provide technical inputs to them."Analyze teh complexity of teh requirement and communicate teh 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 teh connectivity Confidential offshore.
• Proficient in implementing user level and data level securities wifin 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 wif tuning Cognos BI OLAP components for faster access and performance (me.. Transformer, PowerPlay Cube, PowerPlay Client and PowerPlay Studio)
• Extensive experience install configure and Maintain SQL Server Databases
• Successfully completed Cognos v8.4 upgrade for teh various reporting suites to teh defined scope, project plan and implementation plan to specified timeline.
• Extensively working on teh configuration of teh Cognos environments such single server and multiserver components, failover, load balance mechanism including teh underlying WebShere Application Server and database components such as Audit and Cognos Content Store.
• Daily, Weekdays, Weekend, off-hour Support to developers wif teh 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 teh Development tower.
• Experience wif 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 teh 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 teh 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 Confidential transformer level by creating custom views. Created Calculated Measures in Transformer.
• Working wif Informatica Power Center client tools like Source Analyzer, Warehouse Designer, Mapping Designer and Transformation Developer.
• Developed teh Mappings/Worklets/Workflows/Sessions in Informatica.
• Fixing teh issues of defects during teh 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 ConnectionMetric 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, NA

Cognos Developer

Responsibilities:

• Created metadata models, made appropriate Joins, organized Folders according to teh Business view and published teh packages using Framework Manager onto Cognos Connection.
• Designed various types of reports according to end user requirements.
• Applied advanced formatting features to teh reports using Query Studio and Report Studio.
• Developed Rank reports and Section reports using Query Studio.
• Designed reports wif 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 Confidential different physical locations both for historical load and ongoing processes.
• Worked wif Blocks in simple list reports.
• Loading teh transformed data into teh data warehouse.
• Testing teh Cubes data for accuracy and monitoring teh BI Portals.
• Running teh job streams manually when required.
• Monitoring teh nightly jobs using Tivoli Scheduler and fixing teh issues on daily basis.
• Created Views for Generating reports.
• Extraction of data from source systems present Confidential different physical locations both for historical load and ongoing processes.
• Handling teh enhancement work.
• Provided administrative support for production issues.
• Involved in Creating Content store, installation and configuration of teh Cognos8
• Involved in design and development of joins, filters, calculations and conditional variables in DMR Packages wifin 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 teh 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 teh 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

Cognos/Informatica Developer

Responsibilities:

• Analysis of teh specifications provided by teh clients
• Responsible for gathering/refining requirements from teh customer for developing reports.
• Loaded operational data from Oracle, Flat Files into transient Tables and cleaned teh 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 wif conditional formatting and drill through.
• Created multi page reports using conditional layouts.
• Involved in creation reports wif value prompt, select and search prompt.
• Created teh reports on daily, weekly and monthly basis.
• Prepared teh unit test cases.

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