We provide IT Staff Augmentation Services!

Sr.cognos Developer Resume

Dallas, TX

SUMMARY:

  • Over 8 years of professional experience working with Cognos applications and with experience in analysis, design, development, testing and maintenance of Software applications.
  • 7 years of experience in development and implementation of Business Intelligence Applications using Cognos EP Tools such as Cognos Report net 1.0/1.1, Impromptu 7.3/7.4, Impromptu Web Reports, Power Play Transformer, DTS, Powerplay Enterprise server, Cognos Upfront, Cognos Planning, Access Manager, LDAP Directory Server, Informatica-Power Center/Power Mart.
  • Excellent working knowledge with Cognos 8.4/8.3/8.2/8.1, Cognos ReportNet Framework Manager, Report Studio, Analysis Studio, Metric Studio, Query Studio and Cognos Connection.
  • Experience in Data warehousing, Data Mart, OLAP/OLTP System Study, Analysis, Architectures, Relational Modeling, Dimensional Modeling and Data warehouse schemas Star Schema and Snowflake Schema.
  • Experience as a Business Systems Analyst.
  • Experience in both Manual and Automation testing of applications in different environments.
  • Strong in analyzing Business requirements and design specifications and development of Test Plans, Test Scripts, Test Cases and executing them.
  • Excellent understanding of the Software Development Life Cycle (SDLC).
  • Extensive work experience in System Testing, User Acceptance testing (UAT), Functionality Testing, Black Box Testing, Integration Testing and Regression Testing.
  • Ability to translate business requirements into technical design specifications and to effectively execute those specifications or manage the execution of those specifications.
  • Involved in Migrating reports from Impromptu to ReportNet and also from Cognos ReportNet to Cognos 8.
  • Installed, configured and maintained Cognos ReportNet/Cognos 8 applications.
  • Excellent working knowledge with Cognos Series 7.x (Cognos Impromptu, Cognos PowerPlay Transformer, Cognos PowerPlay), Cognos Scheduler, Cognos Access Manager, Upfront.
  • Experience with designing and building cubes using PowerPlay Transformer.
  • Good Knowledge of schema design, Indexing and data structures.
  • Experience using Microsoft Office Suite with strong Excel or MS Access skills.
  • Expertise in setting up security and creating groups & user classes using Access Manager.
  • Experience in web technology skills such as Apache, ASP.NET, Java Script, HTML and XML.
  • Good understanding and experience with SharePoint.
  • Experience in Higher Education for creating reports for Human Resource Department.
  • Experience in implementing Pharmaceuticals Sales and Marketing reporting applications.
  • Good knowledge of Sybase IQ, Hyperion Interactive and Oracle Sybase.
  • Extensive experience in Creating Complex Reports – Complex Drill-Through, Cross-Tabs, Bursting reports, Conditional formatting and Summary Reports.
  • Excellent Communication skills (Verbal/Written), technically competent and result-oriented with strong problem solving skills, and Self Motivated Team player.
  • Propensity in learning new technologies within short period while fulfilling my regular responsibilities.

Technical Skills

BI Tools: Cognos 8.1/8.2/8.3/8.4 Cognos Report Net 1.1 MR1/MR2/MR3:
Framework Manager, Report Studio, Query Studio, and Analysis Studio, Cognos Connection. Cognos Impromptu Web Reports 7.3/7.4, PowerPlay Transformer 7.3/7.1, Powerplay Enterprise Server, Access Manager 7.3/7.4, and Cognos Visualizer.

Data Modelling: Erwin 4.0 / 3.5, UML.

Interface Tool: TOAD, SQL*Loader

Operating Systems: Windows 98/2000/2003/XP/Vista, MS-DOS and UNIX

Languages: C, C++, Visual Basic, Java, ASP.NET, HTML, SQL, PL/SQL.

ETL Tools: Informatica, Cognos Decision Stream, Data stage

Testing Tools: Win Runner, Load Runner, Test Director, and QTP.

Databases: Oracle 10g/9.x/8.x/7.x, SQL Server 2000/2005, DB2, Sybase 12.5
DB2, Teradata.

Professional Experience:

Confidential, Dallas, TX
Duration: Sep 2010 – Till Date
Role : Sr.Cognos Developer

Roles and Responsibilities:

  • Analyze functional and business requirements.
  • Development of enterprise conceptual modeling solutions working collaboratively with Business and project teams serving on data integration, business intelligence providing productivity reports, Business analysis for various Line of Businesses (Bankruptcy, Foreclosure, REO, Loss Mitigation)
  • Fulfilled many on demand report requests for Collection agents, Bankruptcy, REO, Foreclosure and Loss Mitigation Analysts within requested time with proven ability in highly dynamic, collaborative and cross matrixed environment
  • Design, develop, configure, program and implement software applications, packages and components customized to meet specific needs and requirements.
  • Modeled Relational data creating relationships, organizing the model satisfying most of the operational reporting needs for Business at a fast paced environment using Cognos Framework Manager.
  • Involved in System Testing and created Test cases for different reports.
  • Created Pivot like reports in Cognos, Charts, Cross-tab, list, repeater table, Set Expression, Intersection (Tuple), with almost all insert able objects like Conditional Blocks, Blocks, HTML Item (JavaScript code), Drill through/ Drill Down Detail Reports, Master detail Reports, Page Breaking, Bursting for an approved optimized report design on-time satisfying business requirements.
  • Review and modify programs to ensure technical accuracy, security and reliability of programs
  • Designed multidimensional models by mapping business needs using Power Play Transformer and created multidimensional cubes, cube groups, Power Play reports
  • Provide staff and users with assistance solving computer related problems, such as malfunctions and program problems.
  • Perform test plan preparation and unit and system testing
  • Perform code review and bug fixing
  • Perform troubleshooting and code migration
  • Provide quality documentation, status updates and support.
  • Developed transactional, historical on-demand prompted reports, scheduled reports (daily, weekly and monthly).

Environment: Cognos 8.4, Access Manager, Framework Manager, Query Studio, Report Studio, Transformer, Reportnet (MR 2), Impromptu, BRIO, Business Objects, Informatica 8.1, Oracle, SQL Server Enterprise Edition, SQL Server, DB2, MSP, DRI. Toad, Putty, Erwin 4.5, Microsoft Visual Source Safe, UNIX, AIX Solaris.

Confidential,Dallas, TX
Duration: May 2010 – Aug 2010
Role : Cognos Developer

With over 150 years of market experience, ECOM Agro industrial Corp. is committed to being a highly respected leader within the soft commodities industry. Our global operations rely on our extensive knowledge and experience in supply chain improvement, risk management, and client-focused distribution to create a valuable and profitable environment for our suppliers, customers, shareholders, and employees

Roles and Responsibilities:

  • Work with Business Units to define Business strategy and create a centralized reporting capability for users to perform analytical, and ad-hoc reporting for business applications and provide accurate information available to Decision Makers.
  • Provided system consulting services including system analysis and design including requirements definition, user support, testing and documentation.
  • Developed models and Reports for various business units such as Shared Services/ Account Controllership/Treasury/ Income tax/HR and Administration
  • Modified and created documentation for existing reports.
  • Designed and implemented basic, intermediate and complex Reports from end users and created Business functional Documents using Business Rules.
  • Created different types of reports like Crosstab, list, chart and Drill through.
  • Tested and validated the data in the reports with the Controller manually.
  • Created different jobs for Green Book and scheduled the reports.
  • Took part in the meetings with manager and team and understood various process plans, business process, and functionality in detail.
  • Worked on creating and analyzing the complex reports, like cross tab, drill-through reports, prompts, filters, and calculations.
  • Gained expertise with creating page breaks, conditional formatting, drill-thru, and master/detail reports.
  • Created different types of reports for over head accounts based on monthly, quarterly and yearly data.
  • Created Templates for the reports and portals in cognos connection.
  • Scheduling and Distributing Reports through Schedule Management in Cognos Connection.
  • Provided technical assistance, training and mentoring to Users and Business Partners.

Environment:
Cognos 8.4 BI (Framework Manager, Report Studio, Analysis Studio, Query Studio, Event Studio and Metric Studio), Cognos Transformer, Controller, Naivision, .1,QTP, Quality center, Load Runner, Oracle 10g, SQL Server 2000, Netezza, Sybase 12.5/15.0.3,Windows NT/2000.

Confidential,Duration : Jan 08 – May 10
Role : Cognos Lead/Developer

XO Communications provides leading Voice over Internet protocol (VoIP), Data & Internet, Network transport, Managed, Hosting and Fixed Wireless Access services to business, enterprises, government, and carrier & wholesale customers nationwide.

Roles and Responsibilities:

  • Provided system consulting services including system analysis and design including requirements definition, user support, testing and documentation.
  • Work with Business Units to define Business strategy and create a centralized reporting capability for users to perform analytical, and ad-hoc reporting for business applications and provide accurate information available to Decision Makers.
  • Created Relational Data models and Dimension Data models using Framework Manager to represent the business information.
  • Migrated existing Brio Intelligence Reports to Cognos 8.3 report studio Environment.
  • Developed models and Reports for various business units such as Business Services/ Sales/ Billing/ Revenue/Credits and Adjustments.
  • Developed different types of Reports using Cognos Impromptu and PowerPlay
  • Created various catalogs based on different data sources
  • Involved in the design and development of filters, prompts, calculated columns and catalogs.
  • Deployed Cubes and Reports on PowerPlay Enterprise Server and also Published to Upfront.
  • Involved In setting up Cognos Environment in the company.
  • Created charts, lists and crosstabs for Cycle variance, ILI Back Billing, IP Flexing, Credit -Adjustments projects using Report Studio and ad hoc reports using Query Studio.
  • Developed Dashboards/Metrics for higher management and business users.
  • Created Complex reports which include combination of List, crosstab, master-detail reports, drill-through reports.
  • Created some Labor reports in report studio using Sybase database.
  • Created some templates for Excel and Power Point reports.
  • Created reports for Human Resources/Payroll and Finance using Cognos 8.
  • Wrote and implemented the test plan, test cases and test scripts.
  • Developed and Designed Cognos transformer models using Cognos Powerplay Transformer for Employee Monthly Billing Cycles
  • Validated data through native SQL queries in the oracle environment.
  • Experience with Cognos Series 7 applications like Power play, Impromptu, Enterprise Server to migrate to cognos 8.4
  • Setting Data and Object security, giving access permission to objects and Packages
  • Security Administration for setting up users, groups and roles and creating access permissions.
  • Provided technical assistance, training and mentoring to Users and Business Partners.

Environment: Cognos 8.3 , 8.4 BI (Framework Manager, Report Studio, Analysis Studio, Query Studio, Event Studio and Metric Studio), Cognos Transformer, Impromptu 7.0, Cognos Power Play 7.0, IWR, Cognos Go! Office, Brio Intelligence 5.0, Sharepoint, Maximo 7.1, QTP, Quality center, Load Runner, Oracle 10g, SQL Server 2000, Netezza, Sybase 12.5/15.0.3,Windows NT/2000, UNIX

Confidential,Atlanta
Duration : Mar ’07 – Dec ‘07
Role : Business Analyst/Cognos Developer

SunTrust Banks, Inc., with total assets of $175.9 billion on September 30, 2007, is one of the nation’s largest and strongest financial holding companies. Through its banking subsidiaries, the company provides deposit, credit, trust, and investment services to a broad range of retail, business, and institutional clients. Other subsidiaries provide mortgage banking, asset management, brokerage, and capital market services.

Roles and Responsibilities:

  • Involved in Installation and configuration of Cognos 8 environment.
  • Security Administration for setting up users, groups and roles and creating access permissions.
  • Involved in Cognos Security Single sign-on configuration.
  • Participated in Requirement Analysis, Business Analysis, Use-Case Analysis and Gap Analysis.
  • Developed Test Plans, Test Cases, Test Scripts, Test Scenarios, Test Data and Traceability Matrix
  • Wrote and implemented the test plan, test cases and test scripts.
  • Created some reports on Trading and Equity as per the requirement.
  • Created different types of reports like List,Crosstab, and Chart, drill through reports.
  • Created user classes, signons for different users and set security for reports and cubes using Access Manger.
  • Created different Burst reports, filters, and prompts as per the Business requirement.
  • Created some reports like displaying a message while running report in report studio using Java Scripting.
  • Set Row level security in Transformer Model using Apex in Show diagram view.
  • Translated business questions and requirements into reports, and BI query objects.
  • Created different Dashboard reports, Burst and scorecards.
  • Created different types of reports using prompts like Value, search and select Date, Time, and Text box prompt.
  • Created multi-prompt reports using drill through and developed charts, graphs in cognos.
  • Worked extensively on creating Models and publishing the packages to Cognos Connection for reporting purposes.
  • Created various IQD packages in Framework Manager and from this IQD I integrated to Powerplay transformer to create various models and cubes.
  • Designed and implemented basic, intermediate and complex Reports from end users and created Business functional Documents using Business Rules.

Environment: Cognos 8.2/8.3 :Framework Manager, Report Studio, Query Studio, Analysis Studio, Metric studio, Event Studio, Impromptu, Cognos Connection., Access Manger, Oracle 10g, SQL,
TestDirector8.0, Quick Test Professional 9.0 and Mercury Quality Center (9.0),
MS Access, MS SQL Server 2005,Teradata,Informatica, Cognos PowerPlay Transformer, Cognos Enterprise Planning, SDK, Toad, Data Stage, HTML, TM1,XML, Windows NT, UNIX ,Apache and JAVA.

Confidential,Brea, CA
Duration : Jan’06 to Feb’07
Role : Cognos Consultant

Aviana Global Technologies is a Business Intelligence consulting company with expertise in all the areas needed to implement a successful "BI" strategy for its clients. Aviana has significant experience in the analysis and design of data warehouses and data marts, the extraction, transformation & loading (ETL) of data across systems and the reporting and distribution of this information to the enterprise. Aviana has expertise with the industry\'s leading vendor\'s products -- such as Cognos, Business Objects, Microstrategy, Informatica and Ascential, which makes them uniquely qualified to bring best of breed solutions to its clients.

Roles and Responsibilities:

  • Involved in Installation and Configuration of Cognos ReportNet and Cognos 8
  • Performed GUI integration,System,regression and User acceptance testing
  • Developed SQL queries using SQL server to verify the test data.
  • Set Row level security in Transformer Model using Apex in Show diagram view.
  • Responsible in the weekly refresh of multiple multi-dimensional cubes.
  • Created security in the upfront news boxes for different user classes.
  • Created Cubes Using PowerPlay Transformer.
  • Added Users and User classes in Access Manager by running Batch Script in Access Manager Batch Maintenance Tool.
  • Wrote Automation Script in .NET and JAVA for adding Users and User classes, Setting Users and User class’s properties and for setting Row level Security in Power play Transformer Model using Root User Class from Access Manager.
  • Created Dimension IQD’s and Fact queries in Frame work Manager.
  • Created Project Models and Packages in Framework Manager. Created Database layer, Business view layer and giving Business Friendly names.
  • Created Metadata Models in Framework Manager.
  • Worked on Microsoft SQL Server for getting Data Exactly as per the Requirement.
  • Worked with ETL people for supporting Data for Reporting purpose.
  • Created Highly Customized Reports using Report Studio like Conditional Formatting Reports, Bubble Chart Reports and Cascade Prompt Reports.
  • Tested existing reports for accuracy and performance.

Environment: Cognos 8, Cognos Report Net, Framework Manager, Power Play Transformer, Power Play Enterprise Server, Impromptu, Impromptu Web Reports, Deployment Manager, Visual Basic, JAVA, Upfront, Query, MS SQLSERVER 2000, Quality Center, QTP 9.0,MS Access, ORACLE 9i, DB2, QTP,HTML.

Confidential,
Duration : Apr’05 - Dec’05
Role : Cognos Developer

Voyager has various modules for worldwide library management system. Worked with the Circulation module. The Circulation model has the patron, patron fee, fine/fees, renewals, charge, discharge, due dates and archive for patron information. The purpose of the Circulation module is to deal with the patron and circulation transactions. Built the Framework Manager models, packages, reports, deployment, and scheduled report.

Roles and Responsibilities:

  • Involved in the installation and configuration with Cognos ReportNet
  • Understood the database schema, data modeling, and data warehouse.
  • Involved in developing and writing test cases, test scripts, unit testing, integration testing, system test, load testing, performance testing, regression testing, logging bugs, bug tracking and reporting with manual testing.
  • Managed the test assets using Test Director.
  • Performed Manual Testing by Black Box Testing, White box testing and Ad-hoc testing.
  • Provided daily and weekly status to Test Manager
  • Created and maintained Framework Manager Models and Cognos ReportNet reports.
  • Involved in creating the content store, data sources, and configured with Apache server for Cognos ReportNet
  • Used ReportNet Report Studio to create list reports, cross-tab reports and chart reports with date, value and text box prompts.
  • Analyzed and defined joins to build the Frame Work Manager Models and packages with Query subjects and Query items.
  • Published packages from ReportNet Framework Manager to Cognos Connection server.
  • Created folders, filters, prompts, and complex business calculations in Framework Manager and Report Studio.
  • Worked on creating and analyzing the complex reports, like cross tab, drill-through reports, tabular model, tabular sql, prompts, filters, and calculations.
  • Gained expertise with creating page breaks, conditional formatting, drill-thru, and master/detail reports.
  • Gained expertise in writing SQL queries for report testing.
  • Involved in unit testing, and migration from the development server to production server.
  • Gained expertise in creating multi page reports, and graphical reports.

Environment: Cognos ReportNet 1.01/1.1 Framework Manager, Report Studio, Query Studio, Cognos configuration, and ReportNet, Oracle 9i, Oracle Financials11i, TOAD, Windows NT/2000, MS Access, Microsoft Visual Source Safe, and UNIX (AIX), TestDirector8.0, Quick Test Professional 9.0 and Mercury Quality Center (9.0),Win Runner v7.5.

Hire Now