We provide IT Staff Augmentation Services!

Bi Lead Resume

4.00/5 (Submit Your Rating)

Berkeley Heights, NJ


  • 8 years of IT industry experience in the areas of requirements gathering, analysis, design, development, testing, implementation, migration and application support
  • Over 6 years of experience in analysis, modeling & design, and development of data warehouse and reporting applications using business intelligence (BI, OLAP) technologies
  • Over 6 years of experience in various COGNOS Tools - Framework Manager, Report Studio, Analysis Studio, Query Studio, Transformer, Business Insight, Business Insight Advanced COGNOS Connection & COGNOS Administration
  • Created dimensional models using star schema and snowflake schema and using cubes
  • Interacted with business users. Gathered and translated the requirements into dimensional model
  • Worked in different roles as modeler, administrator, designer and developer
  • Experience in transformer models on corporate data to build multidimensional cubes
  • Experienced in SQL and in relational databases DB2, Oracle and SQL server
  • Identified and fixed performance issues. Research and suggest best practices on optimizing the COGNOS functionalities from the application perspective
  • Strong experience in client interaction and understanding business applications, business data flow and data relations for them
  • Prepare SDLC 3.1 industry standard artifacts, like High/Low Level Design, Architecture Profiling; distinguish service level SLA, data classification and integration
  • Rationalization of the solution and practical evaluation of the project whether it could be achieved or not
  • Involved in budgeting, resource utilization, planning project timelines and status reporting
  • Performed deep down analysis of the data for auditing and data quality
  • Managed large pool of resources over various technologies and skillset
  • Liaised with multiple teams from different horizontals in order to create streamline process maps that would show the interdependency of each department
  • Experienced in working with cross-functional teams for end-to-end project delivery
  • Conducted data analysis, gap analysis, including AS-IS and TO-BE models
  • Highly motivated, result oriented professional with a short learning curve and strong communication skills


COGNOS Tools: COGNOS 10.1/10.1.1 series - Framework Manager, Report Studio, Analysis Studio, COGNOS Connection, Query Studio, Business Insight. COGNOS 8.4/8.3/8.2 series

Languages: XML, HTML, SQL, PL/SQL

Databases: Oracle 10g/11g, DB2, SQL Server, MS Access

Special Software: QlikView, SQL Developer, SQL Plus, TOAD, MS Word, Visio & Excel, HP Quality Centre

System Analysis and Design: Business Analysis, Data Modeling, Impact Analysis, Effort Estimation, Design, Development, Test plans, Implementation plans, Implementation & Production support.

Computer Systems: WindowsServer2003, Linux, AIX, Solaris


Confidential, Berkeley Heights, NJ

BI Lead


  • Rationalization of the solution and practical evaluation of the project whether it could be achieved or not
  • Budgeting, Resource utilization, Planning project timelines, status reporting
  • Analyze and document data requirements from business
  • Prepare sample functional specs, mock up reports or similar functional requirement specifications based on information gathered
  • Prepare SDLC 3.1 industry standard artifacts, like High/Low Level Design, Architecture Profiling; distinguish service level SLA, data classification, integration
  • Construct and analyze BI Model Layer in Cognos from Industry standard IBM IIW anchorage data model
  • Identify servers, configurations, and Network topologies
  • Analyze application performance and suggest improvements where appropriate
  • Analyze changes to design specifications and determine the application impact, utilizing design patterns and existing code where applicable to incorporate and test new requirements
  • Involvement in Design, Validation, Deployment, Backup and Restore of the Data Models, Reports, Dashboards, Cubes, Multidimensional Data
  • Performed deep down analysis of the data for auditing and data quality
  • Implement Data Quality Monitoring system using Portals to display monthly reports on Quality of data
  • Responsible for code review, document review, packaging and mentoring fellow team members for development of application
  • Work on PVCS for code versioning and Cognos Framework Manager for data modeling, Cognos Transformer for Cube Building, Report Studio for Reporting and Dash boarding
  • Manage large pool of resources over various technologies and skillset
  • Created dashboards (Rate Change Monitoring) using QlikView

Environment: Cognos 10.2, DB2 z/os, Framework Manager, Transformer, Report Studio, Erwin r9, HPQC, MS-Visio, MS-SharePoint, Duck Creek

Confidential, Boston, MA

COGNOS Developer


  • Gathering business requirements from users, for the reports to be developed.
  • Created functional and technical specifications, which acts as a source for report development, and for QA testing from the business requirement documents.
  • Imported tables, views and stored procedures from SQL server database into Framework Manager and created relations and filters in the model.
  • Troubleshooting and tuning of FM Relational Models, DMRs and reports for better performance.
  • Created a Business User friendly Data Model for AD - Hoc Reporting and also trained Business Users on using AD-Hoc Reporting tools like Business Insight and Business Insight Advanced.
  • Worked on creating complex SQL queries
  • Provided development support during production release for the reports and fine tuning of complex live and batch reports, to improve report performance and to reduce the report runtime errors.
  • Performed unit testing and manual testing on each report after development or whenever there is change in report logic.
  • Implemented bursting logic on batch reports and report views to produce separate report outputs for each claim file submitter.
  • Migration of reports from Dev to QA and Production environments.
  • Upgraded the reports from COGNOS 8.4.1 to COGNOS 10.1.1
  • Providing technical assistance and mentoring to business users and perform UAT.

Environment: COGNOS 10.1.1 Components like Framework Manager, Query Studio, Report Studio, Analysis Studio, Business Insight and Business Insight Advanced, Windows XP/7, SQL Server 2008 R2, Oracle 10g

Confidential, Windsor, CT

COGNOS Developer


  • Created Framework Manager Metadata models in COGNOS 10.1 platform by taking data from MARS database and created three tier metadata models and publishing packages to COGNOS connection.
  • Worked on modeling the metadata extracted from multiple databases and established joins, cardinality and provided performance tuning to meet the business needs based on functional specification and requirement specification document.
  • Created effective and user friendly prompts which enabled flexibility to analyze the data in all possible ways and at the same time achieve tremendous performance time.
  • Created complex reports using variables, conditional styling and conditional blocks as per the client requirements.
  • Involved in upgrade of reports from COGNOS 10.1 to COGNOS 10.1.1 platform in production and UAT.
  • Worked with users throughout the testing phase to ensure data integrity.
  • Worked with Business Analysts to gather requirements from the clients and designing reports.

Environment: COGNOS 10.1/10.1.1 (Framework Manager, Query Studio, Report Studio, Analysis Studio), SQL Server 2008, DB2 and Windows XP/7

We'd love your feedback!