Kiran Kumar

Experience

• 

  Wipro

  Jan 2003 - Jan 2006

  Project engineer
• 

  Vensoft LLc

  Jan 2006 - Jan 2009

  Programmer Analyst
• 

  Timberland

  Jan 2006 - Jan 2007

  Cognos Developer

  • Interacting with Business Users for Gathering Business Requirements to develop Reports.• Designed, Developed and Implemented an Enterprise Wide Reporting system using Cognos BI.• Migrated Impromptu Catalogs and Reports to Cognos 8.• Imported metadata from different sources such as Relational Databases, XML Sources and Impromptu Catalogs into the Framework Manager.• Used Framework Manager to build Relational & DMR models, packages and published to web.• Developed Multidimensional Models in Power Play Transformer and generated Power Cubes for OLAP comprising of dimensions, hierarchies, levels, categories, and measures.• Created Alternate Drill-Down Path, Special Categories & Currency Conversion set up to better suit different user groups. • Enhanced existing reports and created new reports as per the business requirements.• Trained users on creating reports based on the developed catalogs. Show less

• 

  Gulfstream Aerospace

  Jan 2007 - Jan 2007

  Sr Cognos Consultant

  • Participated in Enterprise reporting Project Design, Estimation and development. • Installed, Configured and Deployed Report Net & Cognos 8 on NT and Unix (AIX) environments. • Imported metadata from different sources such as Relational Databases, XML Sources and Impromptu Catalogs into the Framework Manager.• Designed and Developed Projects, Packages, Reports using Framework Manager and Report Studio. • Created Dashboards and Scorecards using Metric Studio. • Setting up of the Audit logs for monitoring the usage of reports.• Created and Manipulated Impromptu Catalogs and Created reports for Corridor Application.• Designed and developed multi dimensional cubes and implemented security in cubes. • Published Power play cubes to PPES. • Enhanced existing power cubes to add dimensions, measures as per the user requirements. • Maintained Security at Query Subject as well as Query Item level for labor cost views.• Worked with Cognos Customer Support to address problems and resolve problems. Show less

• 

  Gap Inc.

  Oct 2007 - Oct 2010

  Sr Cognos Consultant

  • Interacted with Business Users to gather Business Process Requirements.• Effectively involved in Enterprise reporting design, estimation and development.• Designed and Implemented data cubes using Cognos Power Play Transformer for end user reporting.• Designed Framework Manager Projects, Model (DMR, Relational) & Packages, Importing the metadata from the Data Source tables, Views, Data Marts and Macros.• Created different kind of reports like: Executive Dashboard, Store Dashboard, Ranking reports, and Daily/Weekly Flash sales report using List, crosstab and chart report.• Designed and created reports using Attributes, Facts, Metrics, Filters, Consolidations, Custom groups and Prompts (MicroStrategy).• Worked on Advanced reporting objects creation [Advanced metrics, Advanced filters].• Create transformations to-do time series analysis and to compare the values at different times such as sales at this year versus last year, or month-to-date (MicroStrategy).• Worked closely with the MicroStrategy Admin teams during the project migrations and fixing the metadata issues and also in configuring the governing settings at the project level and on Intelligence server• Involved in moving the objects between two projects and two different environments by using Object Manager and merging the projects by using Project Merge Wizard.• Tested all the reports with Cognos Generated SQL and manual SQL using SQL Assistant.• Tracking of defects and Quality Center and reassigning back to Quality Analyst.• Provided extensive training to end users, how to use the Dashboard reports in Cognos 8. Show less

• 

  Ariat International

  Oct 2010 - Jun 2011

  Sr Cognos Consultant

  • Interacted with Business Users to prepare and update the Business Process Requirements and Software System Requirements.• Effectively involved in Enterprise reporting design, estimation and development.• Imported the metadata from different data sources like SAP BW and Oracle into Cognos Framework Manager and then created packages and published them to Cognos Portal.• Created different kind of reports like: OTC Metrics & Turn Time Summary Dashboard, Company Force Ranking reports, and Daily/Weekly Flash sales report using List, crosstab and chart report.• Involved in Cognos Upgrade from Cognos 8.3 to Cognos 10.1.• Partner with SAP BW developers to ensure Info Sources align and are appropriately designed to interface with Cognos reporting tool.• Perform the day to day support for all the BI (Cognos) Production Issues.• Tested all the reports with Cognos Generated SQL and manual SQ.• Provided extensive training to end users, how to use the Dashboard reports in Cognos 8/10. Show less

• 

  UTi Worldwide Inc.

  Jul 2011 - Jan 2012

  BI Lead

  • Closely interacted with Business Users to prepare the Freight Forwarding report requirements.• Prepared the Report specification documents based on the Business requirements.• Effectively involved in Daily Standup meetings to discuss status of each task (Data Modeling, ETL, Reporting etc.).• Effectively involved in Enterprise reporting design, estimation and development.• Involved in data modeling of Cargo Ops, Transaction charges and MDM (Master data Management).• Prepared ETL mapping documents for Flash and EDW reporting, worked closely with ETL team to load the data into Enterprise Data Warehouse.• Used best practices in creating the Cognos Framework Models (Relational).• Created Freight Forwarding Flash Reports, Audit Reports and Operational Reports.• Worked closely with offshore development team to transfer the knowledge of business requirements.• Provided day-to-day status update to Project Manager.• Had good experience with Noetix (third party tool for Oracle Financials) views and Reports.• Leverage Cognos Framework Manager in the modeling of enterprise data and in the creation of enterprise and analytical reporting needs.• Tested all the reports with Cognos Generated SQL and manual SQL.• Provided extensive training to end users. Show less

• 

  Gap Inc.

  Feb 2012 - May 2013

  Sr. BI Consultant

  • Day to day interaction with End users and gather the requirements based on their needs.• Translating the requirements into Detailed Architecture and Design documents.• Lead team of developers (onsite & offshore) in the delivery of technical systems and components.• Created all the Schema objects, Application objects and also defined the Attribute relationships. • Designed and created Adhoc and canned reports using Attributes, Facts, Metrics, Filters, Transformations, Consolidations, Custom groups, Prompts and Cascaded Prompts (MicroStrategy).• Involved in creation of Compound metric, Derived Metric, Filter Metric and Transformation metric to generate more complex MicroStrategy reports in an efficient way.• Involving the reporting analysis, design and development.• Involved in design & development of Dimensionally Modeled Relational & Relational models using Cognos Framework Manager and published the packages for Adhoc reporting.• Involved in creating multiple reports like: Executive Dashboard, Store Dashboard, Ranking reports, and Daily/Weekly Flash sales report using List, crosstab and chart report using Cognos & Microstrategy.• Extensively worked with Command Manager to execute user create/delete scripts.• Expertise in creating dimensional cubes using Power Play Transformer.• Maintained all Cognos reports in Serena Dimensions for version mechanism.• Effectively involved in migrating the objects to different environments.• Involved in Data Validation to ensure data quality. Show less

• 

  UTi Worldwide

  Jun 2013 - Jan 2015

  BI Lead/Data Analyst

  • Closely interacted with Business Users to prepare the Freight Forwarding report requirements.• Prepared the Report specification documents based on the Business requirements.• Effectively involved in Daily Stand-up meetings to discuss status of each task (Data Modeling, ETL, Reporting etc.).• Involved in the Data Analysis of the Freight Forwarding reports.• Effectively involved in Reporting Design, Estimation and Development.• Build Models (Semantic layers, Cardinality, Relationships, Query subjects), Packages and publish packages to Cognos connection and implemented security for the packages using Cognos Framework Manager.• Involved in creating Complex & Adhoc reports for Freight Forwarding and Finance.• Worked closely with Cognos Admin to deploy Reports and Packages to different environments like QC, UAT & PROD.• Tested and validated the reports against Database (SQL Server) to measure the performance and data accuracy.• Involved in Performance Tuning of the reports in Report Studio. Show less

• 

  WestEd

  Feb 2015 - Feb 2016

  Sr. Business Intelligence Consultant
• 

  WestEd

  Feb 2017 - now

  • Business Intelligence Technical Lead

    Apr 2022 - now

  • Sr. Business Intelligence Consultant

    Feb 2017 - now