We provide IT Staff Augmentation Services!

Sr. Bi Analyst Resume

4.00/5 (Submit Your Rating)

Orlando, FL

SUMMARY

  • IBM Certified Cognos professional wif over 11 years of experience in Analysis, Design, Development, Testing and Implementation of reports.
  • Expertise in Business Intelligence reporting application development using COGNOS Suite 7.3 / 8.4.1 / 10.1.1/10.2.0/10.2.2 and Cognos Analytics 11.0.9.
  • 6 Months experience in Cognos Analytics 11.0.9.
  • 4 + Years’ experience in Cognos 10.x BI Suite (Framework Manager, Cognos connection, Report Studio, Analysis Studio, Query Studio, PowerPlay Transformer and Event Studio).
  • 3 + Years’ experience and expertise in Cognos 8.x BI Suite (Framework Manager, Cognos connection, Report Studio, Analysis Studio, Query Studio and PowerPlay).
  • 3 Years’ of experience and expertise in Cognos suite (ReportNet 1.1.1, Cognos Impromptu 7.3, and Analysis Tools such as Cognos Transformer & PowerPlay 7.3, Access Manager).
  • Expertise in Framework Manager Modeling (Physical Layer, Business Layer, Presentation Layer) and Complex Report building wif Report Studio.
  • Expertise in Relational and Dimensional (DMR) Modeling.
  • Expertise in Report building using Report Studio, Analysis Studio and Query Studio.
  • Expertise in creating Dash board reports and using Java Script in Report studio.
  • Experienced in Transformer model design and PowerPlay cube building.
  • Experience in Migrating reports from Cognos EP Series 7/CRN to Cognos 8 Environment and also from Cognos 8 to Cognos 10 Environment.
  • Experience in databases such as Oracle, SQL SERVER and IBM DB2.
  • Experience in writing SQL, PL/SQL Packages, Stored procedures, Functions, Triggers, Cursors as per teh business needs.
  • Worked wif Access Manager and Server Installation & Maintenance.
  • Experience in conducting requirements walk through, test plan reviews, and comprehensive involvement in user acceptance testing.
  • Proficient in documenting test scenarios, test plans, and test cases.
  • Experienced in developing advanced spreadsheets Pivot Tables and V - Look Ups.
  • Successfully handled offshore-onsite model as a Team lead.
  • Experience in interacting wif end users at different geographical locations to gather requirements.
  • Proficient in Microsoft Office suite including Word, Excel, PowerPoint, Visio, Outlook.
  • Excellent interpersonal and communication skills, professionally competent and result-oriented wif strong problem-solving skills.

TECHNICAL SKILLS

Operating Systems: Windows 8, Windows 7, Windows XP, Windows 2000

Programming Languages: PL/SQL, CORE JAVA

BI Reporting Tools: Cognos Analytics 11.0.9, Cognos 10.x Suite (Framework manager, Report Studio, Analysis Studio, Cognos Connection, Event Studio, Query Studio, PowerPlay, Transformer), Cognos 8.4.1 Suite (Framework manager, Report Studio, Analysis Studio, Cognos Connection, Event Studio, Query Studio, PowerPlay, Transformer), Cognos Impromptu 7.3, PowerPlay 7.3 and SQL Plus (Ver. 7.0)

Databases: Oracle 9i/10g/11i, PL/SQL, SQL Server 2008, IBM DB2 9.1/10.1

Management Tools: Microsoft Office Suite (Visio, Word, Excel, PowerPoint and Outlook), HPQC, e-Room, PVCS, Action Request System (ARS), Service Now

PROFESSIONAL EXPERIENCE

Confidential, Orlando, FL

Sr. BI Analyst

Environment: Cognos Analytics 11.0.9, Cognos 10.2.2 (Report Studio, Query Studio), Microsoft SQL Server 2014, Oracle 11g, vFire, PeopleSoft 8.9, Windows 7

Responsibilities:

  • Requirements elicitation by meeting wif report owners and PeopleSoft nVision SME’s and other stakeholders.
  • Analysis of PeopleSoft nVision reports to understand teh BODA mapping rules that are being used in various reports and prepare teh Caption mappings to be created in MEGA database.
  • Analysis of teh data in FACT and DIMENSION Tables and report issues to FAST database team.
  • Engage in discussion wif FAST team for a better understanding of teh data.
  • Define mapping rules to eliminate calculations that are currently being used in PeopleSoft in order to improve teh report performance.
  • Develop reports in Cognos 10.2.2(Report Studio) and in Cognos Analytics 11.0.9 upon migration from Cognos 10.2.2 to Cognos 11.0.9.
  • Used Custom grouping, Conditional Formatting, Conditional Block and Cascading Prompts, Complex calculations for grouped subtotals, Singletons etc. for teh various reports being developed.
  • Used Page set to combine Summary and detailed pages into a single report based on a prompt value.
  • Helped teh FAST database team in creating Captions and identifying teh mapping rules for various Drill BIT reports.
  • Combined multiple nVision report layouts into a single Cognos report by using Prompts and Render variables.
  • Ensure that teh SOX requirements are met for all teh SOX reports that were being developed.
  • Update and track teh report development status through vFire tickets.
  • Test teh reports in Cognos 11.0.9 that were earlier developed in Cognos 10.2.2 after teh migration.
  • Analyzed teh performance of reports and request FAST team for additional indexes for performance improvement.
  • Perform Cognos report reconciliation against nVision reports and Drill BIT application.
  • UAT support to users.
  • Analyze issues reported during UAT and tracking them to closure.
  • Cognos Report walkthrough to users for helping them understand teh new reports.
  • Fix issues or GAPS that are identified during requirement analysis in teh nVison reports, in teh new Cognos Reports that are being developed and notify them to PeopleSoft report development team to get them fixed in PeopleSoft.
  • Provide weekly status updates to teh respective stakeholders.
  • Coordinate wif report owners for User Acceptance Testing and signoff.

Confidential, Dover, NH

Sr. Cognos Developer

Environment: Cognos 10.2.0 (Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio and Event Studio), Cognos Access Manager, IBM DB2 10.1, Windows 7

Responsibilities:

  • Maintenance and enhancement of Workers Compensation Reporting.
  • Gather and analyze teh change requirements for regulatory reports and document them.
  • Discuss wif interfacing technical support team to understand teh regulatory reporting requirements and to keep teh reports in sync wif teh legacy system reports.
  • Incorporate teh regulatory report changes in a timely manner.
  • Apply teh new data filters and conditions for teh regulatory report changes to teh existing regulatory reports.
  • Perform data analysis to understand teh source for new internal reports requested.
  • Create ad-hoc Reports using Query Studio.
  • Develop teh requested new reports in Report studio using functionalities like Render Variables, Conditional Blocking, Cascading Prompts, and Conditional Formatting.
  • Implement teh changes in validations/edits in teh existing reports.
  • Data comparison of Cognos reports and legacy application reports.
  • Scheduled new reports developed using Event Studio as per requirement.
  • Customize Cognos Connection wif appropriate reports and security measures.
  • Perform Change Management activities for implementations.
  • Generate Cognos Reports and perform data comparisons for specific users upon request.
  • Provide teh workers compensation policy information on ad hoc request to internal business users.
  • Analyze Workers Comp Policy information for bureau criticisms raised in legacy system.
  • Evaluate report validations/edits and analyze failed reports upon occurrence.
  • Perform report reconciliations.
  • Prepare and execute test scripts and test cases.
  • Coordinate wif internal business users for User Acceptance Testing and signoff.
  • Prepare User Manual for new reports developed and trained teh business users to effectively use teh reports and also develop own reports in Query Studio.

Confidential, Berkeley Heights, NJ

Sr. Cognos Developer

Environment: Cognos 10.1.1 (Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio, PowerPlay Transformer), Cognos Access Manager, Oracle 11i, Windows 7

Responsibilities:

  • Collaborated wif Stakeholder at different levels to capture business objectives and reporting needs.
  • Gatheird, analyzed and documented business requirements and technical specifications.
  • Prepared BRD and conducted walkthrough sessions for user signoff.
  • Identified teh tables and prepared teh mapping for teh new reports.
  • Installed & configured teh Cognos 10.1.1 BI Environment, Administering teh Servers, Troubleshooting, and Performance Tuning.
  • Developed and Published Packages in Framework Manager - Connecting and testing teh data source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects.
  • Created transformer models and created power cubes using teh model as teh source.
  • Used Dimensional modeling (DMR) and Snow flake Schema modeling technique to develop models.
  • Customized Cognos Connection Portal based on user specifications.
  • Designed Reports using most of teh Report studio features (Conditional Formatting, Conditional Page layout, Sections, page Breaks, Master-detail, Drill Through, Drill Down, Drill Up).
  • Used HTML/Java Script in Cognos report studio reports as per teh requirements.
  • Developed Dashboard reports using Cognos Report Studio.
  • Worked wif Stored Procedure Query Subjects in FM and Reports.
  • Created Drill- through reports and Customized Reports wif Prompts (List, Cross tab).
  • Developed Dash Board reports in Report Studio using MDX Functions.
  • Created Oracle PL/SQL Stored Procedures, Functions and Cursors for use by Framework Manager Packages and Report Studio reports.
  • Worked wif Analysis Studio to develop multi-dimensional reporting.
  • Implementation of security at data level, Object level.
  • Java Script for complex validation, navigation, communication and format customization.
  • Performance tuning by analyzing and comparing teh turnaround times between SQL and Cognos.
  • Resolved issues resulting from User Acceptance Testing (UAT).
  • Performed Data validations, Unit testing and preparation of Unit test cases.
  • Actively involved wif end users for UAT and Signoff.
  • Involved in implementation and post production support.

Confidential, Berkeley Heights, NJ

Sr. Cognos Developer

Environment: Cognos8.4.1 (Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio, PowerPlay Transformer), Cognos 10.1.1 (Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio, PowerPlay Transformer), Cognos Access Manager, Oracle 11i, Windows 7

Responsibilities:

  • Analyzing teh specifications provided by teh clients and Developing specification documents for reports as per client requirements.
  • Installed & configured teh Cognos 10.1.1 BI Environment, Administering teh Servers, Troubleshooting, and Performance Tuning.
  • Used Framework Manager to import metadata from multiple datasources, to Design and Develop teh Framework Manager models.
  • Created database layer and business layer, defining appropriate relationship between query subjects in Framework Manager.
  • Created Packages and published to teh Cognos Connection.
  • Developed cubes in Transformer for analyzing teh performance of brokers, councils and BDM’s.
  • Migrated reports from Cognos 8.4.1 to Cognos 10.1 Environment.
  • Migrated PowerPlay Cubes from Cognos 8.4.1 to Cognos 10.1.1 Environment.
  • Used HTML/Java Script in Cognos report studio reports as per teh requirements.
  • Created Drill- through reports and Customized Reports wif Prompts (List. Cross tab).
  • Created multi-dimensional reports in analysis studio.
  • Implementation of security at data level, Object level.
  • Report reconciliations between Cognos 8 and Cognos 10.
  • Report performance comparisons between Cognos 8 and Cognos 10
  • Performed Data validations, Unit testing and preparation of Unit test cases.
  • Extensively involved in UAT and signoff, travelled to various user locations to assist in UAT.
  • Performed report comparisons in Excel using Pivot Tables and v-look ups.

Confidential, Berkeley Heights, NJ

Cognos Developer

Environment: Cognos 8.4.1 (Transformer, Framework Manager, PowerPlay, Query Studio, Analysis Studio, Report Studio, Event Studio), Cognos Access Manager, Oracle 10g, SQLServer 2008, IBM DB2 9.1, Windows XP

Responsibilities:

  • Developed Framework Manager Models wif Physical layer and Presentation Layer to cater teh various business needs (Folders, Filters, and Macros).
  • Implemented Third Party Security wif LDAP and used those in creating Data Level and Object Securities in Framework Manager Models.
  • Developed Complex Report Studio Reports using Bursting, Tabular Objects.
  • Created Drill- through reports and Customized Reports wif Prompts (List, Cross tab).
  • Prepared User documentation to train users and functionality of each report.
  • Production Support which involves solving user problems.
  • Created IQD files from Framework Manager and designed PowerPlay models in Transformer.
  • Involved in building teh Cubes and optimizing teh cube creation.
  • Provided security for Cubes of various User classes.
  • Published cubes and created PowerPlay Reports for teh web users.
  • Played as a good mentor to teh new joiners in team by giving noledge transition in both technical and functional areas.
  • Developed Stored Procedures and Database Triggers in PL/SQL.
  • Designed extensive sample business Reports to cater teh needs, which can meet their future demands on behavioral, trend analysis.
  • Calculated fields, created manual dimensions and used special categories for creating cubes and reports using Transformer models.
  • Created Drill-Down Hierarchies and used slicing and dicing technologies to provide optimized Reports.
  • Installed and Configured Cognos 8.4.1 in single server Environment.
  • Responsible for overseeing teh Quality procedures and Software configuration management related to teh project.
  • Production Support, which involves solving user problems.

Confidential, Jersey City, NJ

Cognos Developer

Environment: Oracle 9i, PL/SQL, Cognos Transformer 7.3, Impromptu 7.3, PowerPlay 7.3, Cognos 8.4.1 (Transformer, Framework Manager, PowerPlay, Query Studio, Analysis Studio, Report Studio), Microsoft Access, Windows XP

Responsibilities:

  • Gatheird & analyzed teh end-user business requirements.
  • Provided estimation of efforts required.
  • Used Framework Manager to import metadata from multiple datasources, to design and develop teh Framework Manager models.
  • Worked wif relationships (cardinality) between query subjects to better represent teh logical structure of teh business and teh user requirements.
  • Created list reports, cross-tab reports and chart- reports using multiple queries in a single report.
  • Created various Report Studio reports using calculations, filters, prompts and conditional formatting, drill through.
  • Rebuild Cognos 7 Catalogs and Reports in Cognos 8.4.1 Environment.
  • Created PowerPlay cubes using Transformer (PowerPlay).
  • Data retrieval, Multidimensional analysis, PowerPlay structure.
  • Created Multi-Dimensional reports using PowerPlay.
  • Created Cognos Impromptu Reports.
  • Migrated Impromptu reports to Cognos 8 Environment.
  • Migrated PowerPlay Cubes in Cognos 7 to Cognos 8 Environment.
  • Validated report results wif teh source data and authorized teh reports to production environment.
  • Scheduled Reports and Jobs to run periodically.
  • Worked on securing Cognos Connection and setup security by assigning users to teh groups and roles defined in Cognos Namespace.
  • Created several drill through to several reports for providing better functionality.
  • Provided technical assistance, training and mentoring to Users and Business Partners.

Confidential

Cognos Developer

Environment: Oracle 8i, PL/SQL, Cognos Transformer 7.3, Impromptu 7.3, PowerPlay 7.3, Cognos ReportNet 1.1.1, Windows XP

Responsibilities:

  • Gatheird teh requirements, analysis and preparation of design documents.
  • Understand teh reporting needs.
  • Prepared Functional Specification Document.
  • Study existing system and review.
  • Document teh process involved.
  • Maintain Requirement Traceability Matrix.
  • Imported metadata from multiple data sources to build a HR model and published packages in Framework Manager to teh ReportNet server.
  • Created catalogs wif teh help of Impromptu utilizing relational databases.
  • Developed impromptu reports wif various functionalities (Drill -- through, Cascading prompts).
  • Created templates utilizing Impromptu.
  • Created ad hoc reports utilizing Cognos Query.
  • Created user prompts, conditions and filters to improve report generation.
  • Created PowerPlay cubes using PowerPlay Transformer to permit multi-dimensional cross sectioning and drill down analysis.
  • Worked on securing Cognos Connection and setup ReportNet security by assigning users to teh groups and roles defined in Cognos Namespace.
  • Enabled users to access teh distributed HTML reports through local network folders, intranet and via e-mail.
  • Refresh teh PowerPlay Cubes and perform reconciliation of data.
  • Prepared System Test Plan and Unit Test Plan.
  • Performed System Testing, Unit Testing, Integration Testing and Regression Testing.
  • Prepared test scenarios for User Acceptance Testing.
  • Provided Weekly Status reports.

We'd love your feedback!