SUMMARY

• 10 years of experience as a Cognos Consulatant working on Analysis, Design, Development and Implementation of Relational Database (OLTP) and Data Warehousing Systems (OLAP) using Cognos reports based on Oracle/Netezza/MS SQL Server application databases for Healthcare, Telecom, Banking & Financial and Retail sectors.
• Extensive experience in Business Intelligence EnterpriseData warehousing environment using IBM Cognos Cognos 8.1/8.2/8.3/8.4/10.1/10.2
• Excellent experience in building relational/dimensional Model using FM, developing cubes using Transformer and creating reports through QS/RS/AS/ES/Workspace/Workspace Advanced.
• Excellent experience on designing Dynamic cubes with cube designer.
• Excellent Experience on creating Active/Interact/Mobile reports by using Report studio.
• Excellent experience in installation, configuration and administration of Cognos 8.1/8.2/8.3/8.4./10 BI Applications in both standalone and distributed environments and migrating/upgrading artifacts from Cognos lower version to higher.
• Excellent Experience on Impromptu Catalogs and Impromptu reports.
• Extensive work experience on migrating Impromptu Catalog/Reports to Cognos 8/10 versions.
• Excellent exposure in Software Development Life Cycle (SDLC).
• Experience in coordinating project development by serving as a bridge between business and development / test groups.
• Strong understanding of Data Warehouse concepts, OLAP, Star Schema, Data modeling using Normalization, Business Process Analysis, Dimensional Data modeling, Fact & Dimensions tables, Physical & Logical Data Modeling.
• Expertise knowledge on various types of projects handling systems like water fall, Agile methodology served as scrum master.
• Proficient in using Oracle 8i/9i/10G/11g SQL Server 2005/2008/2010 and Netezza.
• Extensive experience in Oracle development using SQL, PL/SQL, Stored Procedures, Triggers, Functions, Packages, Views and Indexes.
• Good knowledge of ETL tools like Datastage &SSIS.
• Expertise in Tableau, Qlik View, TM1 and OBIEE.
• Adept in Team Management skills like tasking, delegation, monitoring, feedback, skill upgrade, competence management, career planning, motivation & mentoring of the team.
• Cohesive Team Player with Fast Learning Curve along with strong analytical, problem solving, innovation, planning, organizational, communication & interpersonal skills.

TECHNICAL SKILLS

Knowledge/Strengths on Following technologies: Impromptu 7.4, Power Play Transformer 7.4/8.4, Cognos ReportNet1.1, Cognos 8.1/8.2/8.3/8.4/10.1/10.2 , Cognos8/10 Framework Manager, Cognos Mobile, Metric Studio, Metric Designer, Cognos Mobile, Cognos for Microsoft Office, Cognos Insight, Cognos TM1 and Cognos Microsoft Office, Tableau, Qlik View, OBIEE

DB: Oracle 10g/9i/8i, SQL Server 2008/2010, Netezza Toad 8, PL/SQL, SQL Developer

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

IBM Cognos Consultant

Environment: IBM Cognos 10.1/101.1/10.2 , Tableau,Oracle/SQL Server, Windows Server 2008 R2, CAFÉ, MS Go office, Access manager, LDAP and Remedy.

Responsibilities:

• Closely work with customer to gather requirement and analyze the source system for required tables/fields.
• Convert the requirement to specification documents and coordinate the work between team and customer.
• Managing scrum calls between team and customer to provide status on work deliverables.
• Design durable framework business model by keeping future business changes in mind to avoid respective report changes.
• Apply Cognos package/object/data level security in framework manger to make application more secure.
• Creating stand alone and embedded framework manager filter for easy reporting purpose.
• Implementing best practices during framework model and tuning Performance of framework model.
• Creating OLAP and Dynamic cubes (Virtual cubes) using power play transformer and dynamic cube designer.
• Creating alternate hierarchies in dimensions to bypass levels.
• Implementing security by creating cube views and associating those views with LDAP/Active directory security groups.
• Creating Cognos reports with Analysis studio/report studio/Query studio/event studio/metric studio based on business need.
• Dash board design by using Cognos workspace/work space advanced and active reports.
• Creating discontinues crosstabs in report studio with cell level drill through to detail report studio reports.
• Creating package level drillthroughs to navigate from Analysis studio reports to report studio reports.
• Implementing advanced Cognos report techniques like rendering, conditional blocks, book mark, page breaks and conditional styles.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Working with Tableau dashboards deployed on Web server
• Ability to support multi - environment Tableau infrastructure including server security troubleshooting and general system maintenance
• Install And Configure Cognos servers on distributed environment.
• Install and Configure CAFÉ and MS Go office on user machines.
• Defining Security matrix on cognos environment.
• Creating Cognos roles and security groups.
• Fixing Cognos environment performance issues and making environment is up and running.
• Creating IBM tickets for critical environment issues and tool bugs, fixing them by coordinating with IBM.
• Install and configure Access manager/LDAP
• Applying patch up gradation on cognos window servers.
• Applying fix packs and upgrading service packs.
• Weekly restart on cognos services and resolving issues if occurs.
• Routing Compatible and dynamic cube packages to respective servers.
• Assisting Application development teams on bottle neck issues.
• Fixing Cognos application development issues.
• Creating datasources across Cognos environments.

Confidential, Plano, TX

IBM Cognos Developer

Environment: IBM Cognos 10.1/101.1,TM1,Oracle/Netezza,Toad,Datastage, Windows Server 2008 R2,HP Quality tool, aginity work bench

Responsibilities:

• Collaborate with IT and business Teams to determine scope, goals and objectives.
• Conduct assessments of business processes and collect data to detail requirements.
• Translated business requirements into documented functional specifications associated with workflow, reports, interfaces, conversions, enhancements, forms and Dashboards.
• Documenting the detailed Technical business logic for each of the BI deliverables in SRS (Software/System Requirement Specification Document).
• Conducting Source system study to identify all the elements required to develop BI deliverables.
• Modeling of Relational and DMR FM models.
• Designing of OLAP Powerplay transformer cube models.
• Implemented Cube security based on facility.
• Fixing Performance Issues on Cube models.
• Creating Active/interact reports for mobiles.
• Creating dashboards by using Workspace/Work space advanced &Portlets
• Applying dynamic filter and dynamic sorting.
• Creating Package level drill-through to navigate from analysis studio to report studio.
• Creating cell level drill-through in report studio.
• Creating MDX reports based on DMR and Cube packages.
• Coding stored procedures and using them in report studio for DML operations
• Customizing report functionalities with html & Java scripts.
• Resolving QC tickets
• Providing support for all kind of cognos issues.
• Mentoring juniors regarding Project and Work.
• Coordinating team to make successful deliveries.
• Tuning report performance.
• Collaborate with the business on identifying the best way to present the data in Tableau reports & dashboards. Present Tableau solutions to the business and modify solutions based on user feedback
• Create high-impact, meaningful analytics (e.g. heat maps, KPI's, bullet graphs, motion charts etc.) in Tableau to help the business make informed decisions.
• Create actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.
• Developed Cognos TM1 Applications, Designed Dimensions, Cubes, Chores.
• Development of TM1 Turbo Integrator Processes to load and retrieve data from database tables and SAP BW feeds, for creating dimensions, hierarchies, and cubes. Well versed in using Prolog, metadata, data and epilog in the advanced tab coding.
• Scheduled Chores and Monitored Data Loads on timely manner.Monitored TM1 Operations Console for server health.
• Created TM1 rules to transfer data between cubes.
• Used TM1 rules editor to create and edit various calculations.
• Used Replication to copy the Cubes from one server to other server.
• Import the data from ODBC and Text files using TM1 Turbo integrator

Confidential, Plano, TX

IBM Cognos Developer

Environment: IBM Cognos 10.1/101.1,Oracle/Netezza,Toad, Windows Server 2008 R2,HP Quality tool, aginity work bench

Responsibilities:

• Interact with clients/Business users for requirement gathering to collect requirement and create requirement document.
• Leading the team and mentoring team members to make successful deliverables.
• Create DMR FM and Powerplay cube model design.
• Validation of FM and cube model design.
• Creating package level drillthroughs from analysis studio reports.
• Created tab reports by having multiple report pages in a single report.
• Dynamic sorting and dynamic filter
• Used java scripts to customize prompts.
• Applied advance reporting technics like rendering and conditional formatting.
• Created test cases and performing
• Testing the reports before to model deployment.
• Co-ordinated the team for deliveries.
• Bug fixes in production.
• Designed and developed Parallel jobs to extract data, clean, transform, and to load the target tables
• Using the Data Stage Designer.
• Designed developed job sequences to run multiple jobs in the predefined order to populate Data Ware house tables.
• Used Data Stage Designer for importing the source and target database schemas, importing and exporting jobs/projects, creating new job categories and table definitions.
• Designed and developed the Routines and Job Sequence for the ETL jobs.
• Involved in Unit testing and integration testing.
• Responsible for running jobs using Job Sequencers, Job Batches.
• Developed Parallel jobs using various stages like Join, Merge, Funnel, Lookup, Sort, Transformer, Copy, Remove Duplicate, Filter, Peek, Column Generator, Pivot and Aggregator stages for grouping and summarizing on key performance indicators used in decision support systems.

Confidential, Chicago, IL

Cognos Consultant

Environment: IBM Cognos 8.4, Oracle,Pl/SQl client and Windows Server 2005

Responsibilities:

• Worked on Relational FM model design.
• Applied package level, object level and data level security in framework model.
• Created multiple packages from a single model and published into cognos portal.
• Created multiple connection strings ( to point Test and Production schema) for a single datasource in development environment
• Customized Prompt pages using java scripts.
• Developed various reports like List, Cross tab, Combination chart and Drill-Through.
• Created Model Filters and Query Filters
• Implemented advance features like Page breaks, Report bursting and conditional formatting
• Created multiple report pages for PDF and Excel and rendered based on requirement.
• Created Multi-Dimensional cubes and Published into cognos Connection
• Created Test Queries and Performed Unit Testing.
• Created Ad hoc reports in Query studio.
• Responsible to interact with client and get the information needs for reporting.

Confidential, Dundee, MI

Cognos Developer

Responsibilities:

• Responsible for interacting with business partners to identify information needs and business requirements for reports
• Created a Relational FM model.
• Created Master- Detail Reports
• Created packages from the model and published it to the Cognos Portal
• Developed reports using Cognos Reportnet as per Business user requirements
• Implemented advance features like Report Bursting
• Created Model Filters, Query Filters & created conditional formatting in reports
• Created Prompts, Parameters and Calculations
• Developed various reports like List, Cross tab, Chart and Drill-Through.
• Created Test Queries and Performed Unit Testing

Confidential, Thousand Oaks, CA

ERP Cognos Admin

Environment: Impromptu/IBM Cognos Reportnet/Cognos 8.2/8.4,Oracle/SQL server, Toad, Windows Server 2005 R2 and IBM Quality toolDescription:

Responsibilities:

• Install and configure Cognos servers.
• Enabling Audit package in Cognos configuration
• Free up the Cognos installation drive when memory full
• Configure server to accept request from one package/application (Package routing).
• Resolving issue related to Migration/Upgrade, DataSource, Scheduling, Security/Capabilities, Framework Manger, Cognos server, Application Development
• Providing access permissions using Access Manger/LDAP for ReportNet/Cognos 8 Report.
• Migration of package from source to target environment.
• Extracting the model files from contentstore.
• Upgrading package/applications from lower version to higher version of cognos.
• Scheduling reports in Cognos production environment.
• Managing Impromptu catalog/reports like Deployment across environment.
• Administrating Impromptu reports.
• Migrating Impromptu Catalogs/Reports to Cognos 8/10 versions.
• Creating/Modifying datasource for Cognos Package.
• Report enhancements and bug fixing for existing reports.
• Restarting Cognos Servers for any issues.
• Created Technical/Process documents for the project to minimize the resolution time.
• Interacting with clients through phone and mails