We provide IT Staff Augmentation Services!

Lead Bi Consultant Resume

New York, NY

SUMMARY

  • 14+ years of IT experience in Business Analysis, Software Design, Development, Testing, production support, Data Warehouse and Business Intelligence areas using visualization/reporting tools such as Tableau and Cognos.
  • Business analysis experience in various domains such as Banking, Insurance, Healthcare, Retail.
  • Experience in creating requirement documents, technical specification documents, proposal documents, estimation documents and providing effective BI solutions to suit the client’s needs.
  • Cleared ITIL certification for IT service management which facilitates the better handling of production systems/applications.
  • Experience in working with Cognos ( 7.3, 8.2, 8.4, 10.1.1, 10.2.1, 10.2.2,11.0.5) suite of products (Report Studio, Framework Manager, Analysis Studio, Event Studio, transformer, Cognos Data Manager, Lifecycle Manager, SDK).
  • Created FM models and packages and implemented data level security, row level security and package level security in the published packages.
  • Experience in creating relational and DMR packages in Cognos.
  • Experience in creating multiple page complex reports, drill - through reports, prompts, master-detail, burst-reports, dashboards, charts, Framework Manager packages (including security issues).
  • Used parameter maps and language lookup tables to support multi-lingual reports.
  • Created Cognos transformer cubes using reports, packages as data sources and published them to Cognos connection.
  • Developed, deployed and supported power cubes using Cognos transformer. Used scripts to run the cubes.
  • Experience in testing the Cognos reports in various environments using Cognos Lifecycle Manager.
  • Migration experience of Cognos environment ver 7.3, 8.2, 8.4 and 10.1.
  • Migrated reports from Business Objects, Crystal reports, Actuate to Cognos during prior assignments.
  • Experience with Oracle and SQL Server databases. Used PL/SQL stored procedures, functions, cursors etc.
  • Experience in installation and setup of Cognos environments both single server and distributed server setup on Linux/WAS/IHS and Windows/IIS environments.
  • Experience in Cognos architecture design, capacity planning, cognos server scaling, load balancing and Disaster Recovery.
  • Extensive experience with Cognos security.
  • Expertise in building interactive reports/dashboards using Tableau Desktop/Server.
  • Used complex calculations using sets, filters, bins, parameters, table calculations, quick table calculations, quick filters, cascading filters, LOD expressions, hierarchies and groups in the views and workbooks in Tableau.
  • Used Pivot, merge, custom split functions, custom SQL, unions and joins in Tableau to prepare the data for visualization.
  • Used tabcmd, tabadmin commands to perform various admin tasks and automate the extract refresh tasks.
  • Worked with live data source connections and Tableau data extracts.
  • Basic Hadoop knowledge.

TECHNICAL SKILLS

Databases: Oracle 9i, PL/SQL, MS SQL Server 2008

Reporting Tools: Cognos 10.2.1, Cognos 10.1.1 on Linux (Reporting and Administration), Cognos Lifecycle Manager, Cognos 8.4.1 (Reporting and Administration) on Windows (Win), Cognos SDK, Cognos 8.2 (Win), Cognos Power play, Actuate, MS SSRS, Crystal Reports, Motio PI, Motio ADF, Tableau 9 Desktop and Server

Operating Systems: Windows server 2008/2003, Win 7/XP, Unix

Languages: SQL, PL/SQL (Cursors, Stored procedures, functions)

Specialization: Data Warehousing, Banking (Investment Banking), Insurance, Retail, Healthcare

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Lead BI Consultant

Responsibilities:

  • Develop reports in Cognos to capture the actuals, plan figures for the income statement and balance sheet using the two different accounting systems, namely - the USGAAP system (US) and the IFRS system ( Confidential Group).
  • Gather requirements for the reports and create functional and technical specifications.
  • Create Cognos Framework manager (FM) models and publish the FM packages to Cognos portal.
  • Used data level security to secure the packages.
  • Performance tuning of long running reports.
  • Create reports in Cognos report Studio and Cognos Workspace Advanced using the published packages.
  • Develop SQL queries, views and stored procedures in Oracle for capturing the data in the reports.
  • Create/update the database tables store the accounting system data and create the necessary indexes, constraints, partitions for improving the database performance.
  • Update the project status which includes creating, assigning and closing of the tickets using JIRA.
  • Created views in Tableau Desktop based on the business requirements.
  • Used custom SQL, pivot, merge, custom split functions, unions and joins in Tableau to prepare the data for visualization.
  • Created action and highlight filters in interactive Dashboards.
  • Developed dual axis charts to show current year and previous year values, donut charts, stacked bar charts, dynamic charts based on parameter selection.
  • Publish the developed dashboard containing charts, graphs and reports on the Tableau Server, manage user group permissions and access of the end users.

Confidential, Springfield, MA

Lead BI Consultant

Responsibilities:

  • Created design and analysis documents to capture the mapping of the columns and fields used in C7, 8.2, 10.1.1 reports.
  • Migration of reports from C7 using migration assistant tools to C10.0. Migrate Cognos 8.2 reports to Cognos 11.0.6.
  • Upgrade of reports from C10.1.1 to C11.0.6
  • Creating adhoc reports in Cognos from the technical specifications.
  • Updating the Framework Manager models and publishing packages to the portal.
  • Testing of the reports using Cognos Lifecycle manager.
  • Redesign of reports in Tableau 10.0.1.

Confidential, Jersey City, NJ

Lead BI Consultant

Responsibilities:

  • Analyzed the existing Actuate reports and created mapping documents.
  • Created FM models and packages for the Cognos reports.
  • Used data level security to secure the packages.
  • Used parameter maps to translate the different fields between English and German.
  • Created report templates to be used in the report. Used style references to have similar layout in all the reports.
  • Setting up of various system properties and tuning parameters in Cognos administration.
  • Used Motio ADF (Content modification tool) to add the reports, preferences, parameters for use from the Confidential UI portal.
  • Written SQL queries (used subqueries, joins, unions), and PL/SQL stored procedures for displaying the data on report.
  • Used PL/SQL cursor for loops in the stored procedures to perform complex row level calculations on the records.
  • Used Cognos Lifecycle manager for testing the reports between different environments.
  • Created views in Tableau Desktop based on the business requirements.
  • Created maps and charts in Tableau to capture various metrics (annual rent, occupancy per floor etc.) for the buildings leased by DB for each of the global locations.
  • Used Tableau desktop to blend data from database and spreadsheets and create different interactive views and dashboards.
  • Created Prompts, customized Calculations, Conditions and Filter (Local, Global), Parameters, Groups and sets for various analytical reports and dashboards.
  • Published views and dashboards to Tableau server.
  • Used tabcmd, tabadmin commands to perform admin tasks.
  • Administered users, groups, and scheduled instances for reports in Tableau server.
  • Scheduled data refresh on Tableau Server for weekly and monthly increments to ensure that the views and dashboards were displaying the changed data accurately.

Confidential, Minneapolis, MN

Cognos BI Lead

Responsibilities:

  • Analyzed the existing Cognos Transformer cubes and FM models.
  • Modified the FM models to add the Medtronic and Confidential dates to appropriate query subjects.
  • Changed the Transformer cubes to match the Medtronic Fiscal Calendar.
  • Ensure that the Medtronic dates added don’t break the existing Cognos reports using the Transformer cubes.
  • Created Audit reports using Cognos and Motio PI to arrive at the Cognos BI Licenses so that these can be effectively managed in future.
  • Created SQL queries for querying the content store tables.
  • Changed the Report studio reports to accommodate the Medtronic Fiscal calendar changes.

Confidential, Pittsburgh, PA

Lead BI Architect

Responsibilities:

  • Analyzed the existing system architecture of ERP/DW and new Kenandy architecture.
  • Coordinated with the data modeler to come up with the design of new DW structure.
  • Prepared the gap analysis document on basis of the existing Cube Data Lineage sheet.
  • Prepared the mapping document for the new DW tables and columns.
  • Suggested the Framework modeling (Cognos 10.2.1) approach instead of the designing separate cubes in Cognos Transformer. This paved way to self service BI where users could create their own adhoc reports.
  • Created a skeleton structure of the Framework Manager (FM) model with all the layers such asDatabase, Business, DMR and presentation layer to start the FM model development.
  • Reviewed Framework Manager model prepared the developers and suggested improvements to the dimensional modeling approach.
  • Created PL/SQL stored procedures using cursors and complex SQL queries.
  • Managed the migration of Cognos content from Cognos 10.1.1 to Cognos 10.2.1.
  • Used Cognos Lifecycle Manager to test the migrated reports and packages.
  • Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards using Tableau.
  • Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines, forecasting etc. in many tableau reports.
  • Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.
  • Scheduled frequency and time to refresh data for the when sources are publishes or extracted to server.
  • Worked on optimizing the queries to improve the performance of Tableau dashboards.

Confidential

Senior Developer

Responsibilities:

  • Analyzed reports that were developed in Crystal reports and prepared the report specifications for developing them in Cognos 10.1.1.
  • Analyzed the report requirements (including data, layout/design/format and functional process requirements).
  • Developed a matrix to map that Data Warehouse data to the Claims Application data extract to confirm data needed from Claims
  • Analyzed framework models/database objects and identified gaps/issues that need to be addressed to complete report requirements.
  • Created PL/SQL stored procedures for use in the Cognos Framework Manager.
  • Performed data analysis and profiling between the current Claims Application database and the previous Data Warehouse. Identified the gaps in the tables as well as the data present in the tables .
  • Designed and developed Cognos framework model and converted the previous dimensional model structure into a star schema structure to report against the Claims Application database
  • Created design documents and report specifications for the cognos reports.
  • Used Cognos Lifecycle Manager to compare the report outputs generated using the Claims Application source system vs data warehouse.

Confidential

Lead Consultant

Responsibilities:

  • Gathering requirements from the business and creating requirement specification documents for developing Cognos reports.
  • Managed internal and global teams in India, Brazil, UK and US.
  • Resource management, task allocation, incident management, management of crisis calls.
  • Developed Dashboard reports to organize data for specific user groups.
  • Connected to variety of data sources (Oracle, SQL Server, flat files) for creation of Tableau dashboards.
  • Worked with live data source connections and Tableau data extracts.
  • Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields.
  • Used user security filters. Applied filters to show data for the users logged in based on their territory/Geo. Also applied data level security based on job role and handle some of the exception cases.
  • Used groups and sets for computations. Also used the combination of sets to do deeper analysis on the data.
  • Worked on various kinds of data filtering as required in the dashboards/reports like quick filters, context filters, filtering measures, continuous and discrete filters. Also filter on top and bottom ‘n’ values.
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
  • Improved the performance of dashboards by optimizing the queries.
  • Created Drill - Through and Burst reports in Cognos to support the business requirements.
  • Created Framework manager models and published the packages to Cognos portal.
  • Implemented data level security, object level security and package level security using the Cognos Framework manager.
  • Used prompts, conditional variables and multiple pages in the Cognos reports.
  • Created adhoc Cognos reports and dashboards for the business users.
  • Created Cognos transformer cubes using reports, packages as data sources and published them to Cognos connection.
  • Development, deployment and support of power cubes using Cognos transformer. Used scripts to run the cubes.
  • Created custom SQL and stored procedures in Oracle to support Cognos reports.
  • Performance tuning of long running reports and cubes.
  • Used Cognos SDK to run the reports for specific set of users.
  • Involved in user administration, security setup, report scheduling, portal administration, data source creation, export/import of packages.
  • Migration of Cognos content from existing 7.3 to 8.2, from 8.2 to 8.4.1 and from 8.4.1(windows based) to Cognos 10.1.1 (Linux).
  • Used visualization tools such as Qlikview to provide more insight to the data.
  • Worked on Kerberos for Single Signon authentication in Cognos 10.1.1 Linux environment.
  • Catalog deployment and load monitoring using Cognos Data Manager.

Confidential

Programmer Analyst

Responsibilities:

  • Development of Actuate reports from the report specifications.
  • Involved in requirement gathering phase to create requirement specification documents.
  • Writing complex stored procedures, Pl/SQL queries for data retrieval in report.

Hire Now