Download PDF

Venkateswaran Narayanan

BI Developer

Summary

Accomplished leader with a record of achievements in BI combined with success in Analytics and visualization. Experience encompasses collaborating with clients to understand the requirements, design, develop and deliver quality reports and dashboards. Strong analytical and problem solving skills.  

Qualifications

  • 11 years of experience in Requirement Gathering, Software Design & Development, Project Implementation, Report Authoring, Testing, and Technical Support
  • Prepare technical design document, high level system flows, project estimates, project plan, code reviews, unit test plan and weekly status reports for project management.
  • Expertise in authoring reports using Cognos Analytics, Cognos 10.2 (ReportStudio, QueryStudio, AnalysisStudio), Cognos 8 Series, Cognos Series 7 and performance-tuning of reports.
  • Expertise in publishing packages in Framework manager using clear conventions, a multi-layered structure, and package, data, and object level security.
  • Expertise in Tableau.
  • Expertise in developing Powerplay model and cubes.
  • Involved in installation, configuration and upgrade of COGNOS BI suites (10 & 11).

Education

June 2004May 2007

Bachelor of Science in Electronics

PSG College of Arts and Science

GPA - 3.53

Work History

March 2012Present

Application Programmer

IBM

Client - Horizon Blue Cross Blue Shield of New jersey.

Brief: Horizon Blue Cross Blue Shield of New Jersey (Horizon BCBSNJ) is the state's largest health insurance company, serving over 3.6 million members. Horizon BCBSNJ is a not-for-profit, tax paying health insurer, headquartered in Newark, New Jersey.

IBM has been engaged to develop and maintain BI reporting solution for Horizon BCBS NJ. IBM team is responsible for maintaining and rewriting the existing impromptu reports using Cognos BI suite. IBM is also responsible for support of entire cognos BI (series 7 application and Cognos 10). IBM EDW team extracts and maintains the data from various source systems and the reporting team handles the analytical and tactical reporting solution for all levels of Management.

Tools:  Cognos 11 Analytics, Tableau, Cognos 10 BI Suite (Cognos Report Studio, Cognos Framework manager, Cognos Transformer), Cognos series 7 (Impromptu, Access manager, Upfront)

Database: DB2, Oracle, SQL Server, Teradata, Hive

  • Report development in Cognos 11, Cognos 10, Cognos 7.
  • Development of data models for report authoring.
  • Development of Powerplay Transformer models and cubes.
  • Translating business requirements to technical/high level requirements, and design.
  • Involved in estimating the project and preparing the project plan.
  • Troubleshooting issues related to database and report performance.
  • Recommending and implementing improvements and efficiencies.
  • Developing deployment best practices for the Business Intelligence solution.
  • Leading customers through discussions around success criteria and data analysis.
  • Allocating and tracking work assignments to the off-shore team members. Leading the offshore team and providing the team members necessary training and guidance as and when required.
  • Handling production support activities.
  • Handling admin related activities.

Awards & Recognitions

  • Best of IBM 2015 honoree
  • Orion Award, 2014
  • Orion Award, 2013
  • Excellence and Eminence Award, 2012

Jan 2011Feb 2012

Associate Consultant

Oracle Financial System Software Ltd

Client - Deutsche Bank

Brief: Deutsche bank offers financial products and services for corporate and institutional clients along with private and business clients. Deutsche Bank's core business is investment banking. Deutsche Bank is the 16th largest bank in the world by total assets.

OFSS had been engaged with development and maintenance of the cognos reports and cubes.

Tools:  Cognos 8 Report studio, Framework manager, Cognos 8 Planning

Database: Oracle

Involved in 

  • Development of Cognos 8 reports as per the customer requirement.
  • Performance tuning of cognos reports.
  • L2 and L1 support
  • Maintenance and enhancement of the Cognos Planning environment.
  • The work also involved modifying the existing analyst model based on the customer requirements, taking care of the synchronization and GTP processes and Contributor administration.

Sept 2007Dec 2010

Application Developer

IBM

Client - Horizon Blue Cross Blue Shield of New jersey.

Brief: Horizon Blue Cross Blue Shield of New Jersey (Horizon BCBSNJ) is the state's largest health insurance company, serving over 3.6 million members. Horizon BCBSNJ is a not-for-profit, tax paying health insurer, headquartered in Newark, New Jersey.

IBM has been engaged to develop and maintain BI reporting solution for Horizon BCBS NJ. IBM team is responsible for maintaining and rewriting the existing impromptu reports using Cognos BI suite. IBM is also responsible for support of entire cognos BI (series 7 application and Cognos 10). IBM EDW team extracts and maintains the data from various source systems and the reporting team handles the analytical and tactical reporting solution for all levels of Management.

Tools:  Cognos series 7 (Impromptu, Access manager, Upfront)

Database: DB2, SQL Server

  • Involved in the development of Catalogs, impromptu reports and publishing them to upfront IWR.
  • Migrating the reports between environments.
  • Development of Powerplay Transformer models and cubes and publishing the cubes to IWR.
  • Managing user access to the environment through Access Manager.
  • Developing DTS and SSIS packages for data transformation.
  • Troubleshooting issues reported by business.
  • Handling production support activities.

Awards & Recognitions

  • Bravo Award, 2008
  • Eminence and Excellence Award, 2010

Skills

Cognos 11 Analytics
Tableau
Cognos10 BI
Cognos Powerplay
Cognos8 BI
Cognos 7
Cognos Planning
DB2
SQL Server SSIS
R Programming
Mongo db

Certifications

Dec 2013Present

IBM Certified Cognos 10 BI Author

IBM
Dec 2013Present

IBM Certified Cognos 10 BI Multidimensional Author

IBM
March 2014Present

IBM Certified OLAP Modeler

IBM
March 2014Present

IBM Certified Cognos 10 Metadata Modeler

IBM
March 2014Present

IBM Certified Cognos 10 BI Admin

IBM