We provide IT Staff Augmentation Services!

Bi Analyst Cognos Lead Resume

Roseland, NJ

SUMMARY

  • 9+ Years of IT experience in Business Intelligence technologies in reporting, Designing, Development, Testing and Documentation implementation of Cognos, Tableau Desktop, Power BI, Business Objects, Qlikview and MS SQL applications and maintenance of Data Warehouses, Data Bases, Data Marts and providing solutions for Manufacturing, Retail, Health care, Insurance, and Banking domains.
  • Business Intelligence and Data Analytics proficiency - COGNOS reporting logic, Framework Manager Modeling (Physical Layer, Business Layer, Packages), Security and Complex Report building with Report Studio, Pentaho Report Designer, experience in Tableau, Qlikview and basic understanding of ETL Informatica and Datastage.
  • Having good knowledge of Data Modeling Concepts (Normalization, Star Schema, and Snowflake Schema). Strong analytical and problem solving skills, including the ability to provide solutions to technical and non-technical problems. Thorough knowledge of Tableau Desktop/Qlikview will be an added advantage. Other BI tools experience involved MS Power BI, Business Objects.
  • Client Need Analysis and Customer Management - Experienced in analyzing and translating business requirements into technical requirements for development, and creating of high level technical architecture, design documents and technical specifications, great exposure to client interaction and user-requirement analysis.
  • Mentoring and Teamwork - Mentored the team for successful execution of projects, excellent interpersonal and communication skills and the ability to work in a team environment, can effectively coordinate project team with client representative to resolve any functional and technical issues.

TECHNICAL SKILLS

  • Cognos
  • Technical Skills
  • SQL and Query related Skills
  • Administrational Skills
  • Microsoft Skills
  • Data Modeling Skills
  • Agile Skills
  • Managerial Skills
  • Oracle Skills
  • Non-Technical Skills
  • Analysis Skills
  • Maintenance Skills
  • Configuration Skills
  • Development Skills
  • Different Domains related Skills

PROFESSIONAL EXPERIENCE

Confidential - Roseland, NJ

BI Analyst Cognos Lead

Tools: Used: Cognos Analytics 11.x.x

Responsibilities:

  • Participated in migration of 56 Cognos reports from Oracle DB to Postgres & AWS Athena.
  • Analyzed the existing BI contents and implemented best practices to support the smooth migration from one source system to other.
  • Analyzed the impact on the reports due to the changes in the source systems.
  • Participated in PI planning sessions and provided reporting impacts on reporting development.
  • Worked and troubleshooted in establishing the connections between Cognos BI and AWS Athena.
  • Worked on improvements in reports performance and proposed new ideas to business users.
  • Involved in the design discussions of the mappings for data loading using data pumper.
  • Modified the Framework Manger Models to incorporate the new data elements.
  • Tested end to end reports while migrating from Oracle to Postgres.
  • Involved in writing complex embedded SQL queries to improve the performance of the reports.
  • Implemented security into Cognos Framework Manager.
  • Created test cases to test the reports and promote the code up to production environment.
  • Responsible for code migration across environments by creating the change tickets against deployment team.
  • Analyzed SQL queries and added additional functions for performance improvement.
  • Designed the Physical, Logical & Presentation Cognos Framework Model layers.
  • Developed, maintained, and managed Cognos packages.
  • Worked closely with stakeholders in Agile methodology using Version One.
  • Experienced in using Bit bucket and PVCS for version control.
  • Good understanding in AWS Cloud based applications such as Athena, Redshift, Glue.
  • Worked on monitoring the ETL AutoSys jobs for daily runs.
  • Worked with DBA’s to analyze slow query performance by executing the query plan and advised on creating the indexes to improve reporting performance.
  • Worked on CI/CD pipelines for automated processes.

Confidential - Berkeley Heights, NJ

BI Consultant/L3 Support - Cognos

Tools: Used: Cognos 10/Analytics, Qlikview

Responsibilities:

  • Participated in the workshops for gathering requirements as part of project enhancements.
  • Provided production support (L3) to business users in case of any issues during daily, monthly, quarterly runs.
  • Analyzed the impact on the reports due to the changes in the Source systems.
  • Worked on improvements in reports performance and proposing new ideas to business users.
  • Involved in the design discussions of the mappings for data loading using datastage jobs.
  • Modified the Framework Manger Models to incorporate the new data elements into existing models/packages.
  • Designed and developed the reports as per the requirements in Cognos 10.2.2 and Cognos Analytics.
  • Tested end to end reports while migrating from Cognos 10 to Cognos 11/Analytics using MotioCI.
  • Involved in writing complex embedded SQL queries to improve the performance of the reports.
  • Implemented security into Cognos Framework Manager packages.
  • Published the Framework Packages into Cognos content store for developer community.
  • Modified existing reports to incorporate the changes in the Source systems.
  • Prepared the test cases for report unit testing and validations.
  • Actively involved in unit and integration testing.
  • Responsible for code migration across environments ( DEV, QA/UAT & PROD) and post validations.
  • Responsible for documenting the code changes as per the user change requests.
  • Conducted multiple sessions between offshore/onsite for code review as part of project enhancements.
  • Created Drill-Down Hierarchies and used slicing and dicing technologies to provide optimized Reports.
  • Analyzed SQL code for problem resolution and performance optimization.
  • Involved in creation of schema objects like tables, indexes, views, stored procedures, functions, triggers and synonyms.
  • Worked in agile fashion using (Rally).
  • Developed, maintained, and managed Cognos packages using Framework Manager.
  • Worked with internal and external business users and developers to assist with the development and implementation of new reports.

Confidential

Sr. Cognos Developer/Business Analyst

Tools: Used: Cognos 10/Analytics, Tableau

Responsibilities:

  • Created, enhanced and maintained relational/DMR/OLAP metadata Framework Manager Models to support business requirements.
  • Designed & Developed reports/dashboards using Report Studio, Analysis Studio, Query Studio, Cognos Workspace (+ Advanced)
  • Delivered advanced/complex reporting solutions such as Dashboards and Standardized Reporting (Including the bursting of reports globally) using Cognos. Created complex Dashboards with Area charts, Pie charts, Cross tabs and Multi prompts in Report Studio.
  • Defined and followed Cognos development best practices for Continual Service Improvement.
  • Authored technical specifications that describe program development, data modeling coding, testing, changes and corrections.
  • Interacted with business units, business analysts, and IT professionals throughout the product life cycle.
  • Advised management the best practice to build a full life cycle BIDW from data marts using SSIS to using BI suites to support Cognos artifacts, package, reports, and dashboards.
  • Ensured that developed reports meet specifications, run efficiently and are error free through Data Validation and Performance Testing.
  • Responsible for evaluating and analyzing requirements, for developing the User Interface and the Database Developed business architecture using requirements, analysis, questionnaires, scope, and risks to communicate the client’s needs to developers and various teams.
  • Conducted training on advanced report authoring to familiarize end users to the new reporting environment.
  • Led tech team to complete around 154 reports including dimensional cuts successfully before the deadlines.
  • Generated Complex reports in Cognos 10 Report Studio including Drill through reports.
  • Gathered and analyzed business requirements from users and business community.
  • Tested the created reports by executing the Test Scripts.
  • Created Cash Product Dashboard reports to present critical company data in a single report using Cognos metric studio.
  • Used conditional blocks and conditional variables for generation of reports.
  • Manually modified the SQL in Report Studio to tune and/or to write reports.
  • Created cubes using Power play Transformer and implemented security into the cube model.
  • Performed data validations, unit testing and prepared some Test cases.
  • Documents for report validation and testing after interacting with the end users.
  • Created filters, prompts, calculations and determinants for efficient data retrieval and analysis.
  • Tested the fixed reports in Cognos 10 environment as well as the performance of the reports.
  • Involved in transforming SDLC from Waterfall to Agile using JIRA.

Confidential, Nashville, TN

Sr. Cognos Consultant/Business Analyst

Tools: Used: Cognos 8

Responsibilities:

  • Developed Cognos based automated reporting.
  • Published 1000+ pages multi-sectioned PDF reports using a mixed source of dimensional and relational data, using features such as Table of Contents and bookmark returns.
  • Automated monthly PDF & Excel emailed reports.
  • Migrated existing relational systems onto a data warehouse structure; structuring cubes and hierarchies
  • Gathered and analyzed business requirements from users and business community.
  • Provided and implemented technical design reviews, standards, and best practices.
  • Responsible for production support issues, performance tuning, and future development.
  • Upgraded reports specifications as per requirements to fulfill business needs.
  • Used Agile methodology for software development to perform tasks by iterations.
  • Performed BI Content Administration tasks including scheduling and content management.
  • Created SQL extract reports and writing scripts for loading and scheduling on FTP site.
  • Imported metadata from multiple sources, created subject oriented business models, published to content store via Framework Manager.
  • Debugged, monitored, and troubleshooted our code and deployed solutions.
  • Authored Reports using Report Studio and trained end users in building Ad-hoc reports using Query Studio.
  • Worked with ETL teams on understanding the ETL processes and data flows coming into reporting.
  • Worked on complex reports using Tabular Objects, Static Prompt conditions.
  • Designed extensive sample business reports to cater the needs to meet their future demands on behavioral trend analysis.

Hire Now