SUMMARY:
**+ years of experience in SDLC (design, development, testing and implementation) of Cognos Business Intelligence applications, Power BI & Tableau.
Experience in the development of Data Warehouse Applications using Cognos 11.0.7 latest version, Power BI, Cognos TM1, Cognos 10.2.1 Report Studio, Query Studio, Event Studio, Analysis Studio, Cognos Suite i.e. Cognos 8.4, Framework Manager, Dynamic Cubes, Transformer, Power Play and database MSSQL Server 2012 & Oracle 9i (SQL),
Strong in developing Cognos Framework manager models and publishing the packages into Cognos environment using various data sources like Denodo, Netezza, Teradata, Oracle and SQL Server etc.
Developed models for implementing multi-dimensional reporting (DMR).
Implemented security in Cognos Framework Manager by integrating with third party security namespaces like LDAP, Active directory to configure login mechanisms to apply package, object and data level securities.
Worked on Cognos Work Space, Cognos Work Space Advanced, Active Reports & Rave Visualizations for building the Dashboards.
Implemented column based partitioning, time based partitioning using Transformer for optimization.
Involved in Upgrading the Cognos 8.4 Reports to Cognos 10.2.1 and Cognos 10 to Cognos 11.
Implemented various functionalities in report studio like Macros, Drill up & down, Drill through, Master Detail Relationship, Conditional Blocks, Cascading Prompts, Table of Contents, Repeater Tables, Calculations, Filters, Bursting, Variables and Java script etc.
Implemented various functionalities in Framework manager such as Governors, Query set, Filters, Calculations, Joins, Scope, Hierarchies and Determinants.
Worked on Deployment Process when moving the Reports from DEV environment to SIT
Involved in finalizing the Report Specification and also preparing the Functional design documents, Mapping sheets & Unit test cases as per the Business Requirement.
Created dimensions, cubes and processes using TM1 architect for Finance department
Developed User Interfaces, Reports, Rules and Turbo Integrator processes using Cognos TM1 for Expenses, Revenues, Salary and Compensation, Headcount, Budget Variance and Summary
Worked with creating Business Rules that perform calculations, such as average price, currency conversions, and price/earnings ratios in TM1.
Validating data and Comparing in TM1 prospective excel and in TM1 web with Cognos Report Studio.
Adding Business Rules to Cubes by using the rules editor and Scheduling of TM1 process for data population.
Integrated TM1 cubes with Cognos 10.2 and used as a source to build BI reports in Report Studio.
Created Parameters & Maps for showing the results based on User id at run time and based on selection of the Prompts.
Creating Data Virtual layer in Denodo by integrating different Sources and creating Joins, Unions, Minus, intersect among the Views.
Cashing and Indexing the Base Views and make Index Type as 'Cluster / HASH' in Denodo
Modifying VQL based on the Reporting Requirement.
Developed dashboards with Power BI which display key KPIs for business analysis and decision making.
Created ad-hoc reports depending on the user requirements and created other excel reports also worked on pivot tables and power pivoting.
Created Tabular models and customized column aggregations by writing DAX using Power BI.
Used Power BI Power Pivot to develop data analysis prototype and used Power View and Power Map to visualize reports.
Creating SSIS Package to load the data from different Sources.
Education & Certifications
Masters of Computer Applications.
IBM Certified Designer - Cognos 10 BI Reports
IBM Certified Developer - Cognos 10 BI Metadata Models
IBM Certified Administrator - Cognos 10 BI
IBM Certified Developer - Cognos 10 BI OLAP Models
Technical Skills:
BI Tools
Cognos 11.0.7, 11.0.5,11.0.4,10.2/10.1/8.0/8.2/8.3/8.4 Report Studio, Data Modules, Data Sets, Dashboards, Cognos TM1 10.2.2, Turbo Integrator, TM1 Architect, TM1 Web, Query Studio, Analysis Studio, Work Space, Cognos BI Suite 8.4, Framework Manager, Cognos 8.4, Cognos Go Office, Tableau, Power BI
ETL Tools
SSIS, Data Stage
Databases
Denodo, Netezza, MS SQL server 2012/2008/2005/2000, Teradata, Oracle 11G/10g/ 9i/8i, DB2
Knowledge on
OBIEE, Boot Strap, Angular JS
Languages
C, C++, .Net
Scripting Languages
HTML 5, CSS, JavaScript, JQuery
Operating Systems
Linux, Windows XP, 7
PROFESSIONAL EXPERIENCE
Savantis
Client: VSP Global, CA Oct 2016 – Current
BI Lead
VSP is the nation's largest provider of managed vision care plans. Therefore, a very large collection of eye care related data was distributed throughout many legacy systems and there was no single tool that would allow the analysts to join such disparate data. By implementing the data warehouse, all this information was bought together in single repository. The primary purpose of implementing data warehouse and related data marts was to provide fast and easy access to standard set of group reports to sales, marketing, and group representatives.
Responsibilities:
Translate business needs for projects and broad scale initiatives into information solutions that improve business decisions.
Promote and adhere to Data Management processes and procedures and provide input to the creation of data definitions, business rules and data access methods.
Remain abreast of current and future Business Intelligence technology and BI analysis methods. Analyze and recommend new technology for use at VSP.
Creating FM Model Package for to develop the reports.
Develop Data Modules & Data Sets to create the Dashboard.
Creating Dashboards in Exploration
Identify the Bugs in Cognos 11 and raised PMR to IBM.
Involved in creation of Drill -Through and Master-Detail, Drill Up & Drill Down reports.
Working on Active Reports to improve the performance of the Reports.
Created Security for Managers, District Managers & Sales Reps.
Involved in Performance Tuning of the reports.
Involved creating Dashboards using Power BI by extracting data from Intranet sites, Different data Sources and from Excel / CSV files.
Creating DAX calculations in the Dashboard by comparing current year sales with last year sales, Cumulative Sales and other calculations.
Used different types of visualizations as per the business requirement.
Identify opportunities for innovation and improvement of cross line of business, line of business, and division processes.
Environment: Power BI, Cognos 11.0.7, Denodo, Netezza, JavaScript,
Collabera
Client: Bank of America, NC Sep 2015 – Sep 2016
Senior Cognos Developer
Bank of America today entered into a consent order with the Office of the Comptroller of the Currency (OCC) in which it agreed to continue to make improvements to its compliance practices, specifically enhancing its non-home loan collections litigation and Service Members’ Civil Relief Act (SCRA) processes as well as its enterprise compliance program. The order covers collections litigation from several years ago for a small percentage of credit card and deposit overdraft customers who defaulted on their account, and also covers SCRA account servicing. The issues were discovered by reviews that began in 2011; since that time, Bank of America enhanced its collections litigation and sworn documents processes and enhanced controls around SCRA across the company. In addition, Bank of America is building upon a number of initiatives already underway to better manage compliance risk going forward.
Responsibilities:
Worked on different streams like Key Measures, Monitoring & Testing and Enterprise Reference Data.
Experience working directly with the business users for gathering requirements, manage scope and schedule.
Involved in writing the Technical design documents and Unit testing documents
Design and implementing Physical/Logical/Dimensional Layers in DMR Modeling.
Implemented the Security (package, object and data level).
Passing parameters to Stored Procedure from Framework manger
Created the reports as per the business requirements
Created various types of reports like List Reports, Cross tab Reports Chart Report & Master Detailed Reports as per the client requirements.
Involved in creation of Drill -Through and Master-Detail, Drill Up & Drill Down reports.
Prepared various reports using cascading prompts and value prompts in Cognos Report Studio.
Developed reports based on conditional formatting.
Created reports Views and scheduled in Cognos connection.
Worked on Cognos Go Office to generate the reports in Power Point Version
Created dimensions, cubes and processes using TM1 architect for Finance department
Developed User Interfaces, Reports, Rules and Turbo Integrator processes using Cognos TM1 for Expenses, Revenues, Salary and Compensation, Headcount, Budget Variance and Summary
Worked with creating Business Rules that perform calculations, such as average price, currency conversions, and price/earnings ratios in TM1.
Validating data and Comparing in TM1 prospective excel and in TM1 web with Cognos Report Studio.
Creation of rules using the rules editor and adding Business Rules to Cubes. Scheduling of TM1 process for data population.
Loading and Maintain Data in Cube using Turbo Integrator.
Optimize the Rule Performance by adding SKIPCHECK and FEEDERS.
Integrated TM1 cubes with Cognos 10.2 and used as a source to build BI reports in Report Studio.
Environment: Cognos TM1 10.2.2, Turbo Integrator, TM1 Architect, TM1 Web, Cognos 10.2.1 Report Sudio, Cognos go Office, Javascript, SQL Server.
IBM
Client: TIAA-CREF, NC Dec 2014 – Aug 2015
Senior Cognos Developer
TIAA-CREF provides retirement plans at more than 15,000 colleges, universities, schools, research centers, medical organizations and other nonprofit institutions. TIAA-CREF Asset Management is a global asset manager dedicated to helping institutional and individual investors achieve their investment goals. TIAA-CREF has been dedicated to the needs of the participants and their families – those who serve the greater good through the work in the academic, medical, cultural and research fields. TIAA-CREF can help to achieve the financial goals through every stage of the life.
Responsibilities:
Experience working directly with the business users for gathering requirements, manage scope and schedule.
Involved in writing the Technical design documents and Unit testing documents
Design and implementing Physical/Logical/Dimensional Layers in DMR Modeling.
Implemented the Security (package, object and data level).
Passing parameters to Stored Procedure from Framework manger
Created the reports as per the business requirements for different university Plans
Created various types of reports like List Reports, Cross tab Reports Chart Report & Master Detailed Reports as per the client requirements.
Involved in creation of Drill -Through and Master-Detail, Drill up & Drill Down reports.
Prepared various reports using cascading prompts, Text box prompts and value prompts in Cognos Report Studio.
Developed reports based on conditional formatting.
Created reports Views and scheduled in Cognos connection.
Created cubes using the existing multi dimensional package to overcome performance issues.
Used Windows Scripts to update the Cube in a timely fashion, so that reports using the Cube will pick the latest data
Created Worksheet using Tableau Desktop
Created Dashboards using the worksheet developed in Tableau Desktop
Publishing the Desktop Reports to Web using Tableau Reports.
Created Visualizations as per the User Requirement
Worked with creating Business Rules that perform calculations in TM1.
Validating data and Comparing in TM1 prospective excel and in TM1 web
Creation of rules using the rules editor and adding Business Rules to Cubes.
Scheduling of TM1 process for data population.
Loading and Maintain Data in Cube using Turbo Integrator. Optimize the Rule Performance by adding SKIPCHECK and FEEDERS.
Integrated TM1 cubes with Cognos 10.2 and used as a source to build BI reports in Report Studio.
Environment: Cognos TM1 10.2.2, Turbo Integrator, TM1 Architect, TM1 Web, Cognos 10.2.1, Tableau, Teradata, Javascript, SQL Server, Data Stage.
IBM
Client: ANV, United Kingdom Nov 2012 – Dec 2014
Senior Cognos Developer
The ANV Group is a global insurance carrier with offices in London, New York, Barcelona and Hong Kong. The ANV Group is managed in three pillars: ANV Risk (currently ANV Holdings/old Flagstone UK), ANV MGU, and ANV Service Company. In the future, ANV Risk may be divided between Lloyd’s and Company markets. ANV Group consists of the finance and other support functions which collate performance information and govern the running of all subsidiaries. ANV UK has recently been formed by the acquisition of Flagstone UK – a Lloyds of London Managing Agent holding a number of syndicates writing insurance in the Marine, Aviation, Energy and D&O lines among others. ANV has en-gaged IBM to deliver the Data Warehouse and Reporting solution as they need to present information for key business decisions which is based on credible data of high quality and reduce the number of spreadsheets which make up business critical decision processes.
Responsibilities:
Prepared the reports specification documents to meet the user requirements
Involved in estimations of the reports for each Release
Worked on Requirement gathering & understanding the requirement and implementing them in Cognos.
Implemented the CxO Dashboard for Claims & Underwriting reporting users using Cognos Workspace Advanced.
The IBM Asset Solvency II QRT Reports deployed and changed as per the ANV requirements.
Design and implement Physical/Logical/Dimensional Layers in DMR Modeling.
Implemented Dynamic Cubes for all the Fact Tables to improve the performance.
Creating relationships between query subjects to better represent the logical structure of the business and the user requirements.
Creating the Dimensional Layer for implementing the DMR Concepts
Setting the scope between dimensions and Measures
Implemented the Security (package, object and data level).
Created the Database Views to meet the critical reporting requirements and imported into FM.
Created the reports as per the business requirements for different functional areas like (Compliance, Claims, Underwriting)
Created Database connection so the same Report will automatically point to ANV/APOLLO Database, So ANV user will see ANV Data in the reports and Apolli Users will see Apollo Data in the Report.
Implemented drill-through and drill down/up functionalities into the same report
Created complex Drill-through, Master-Detail, Conditional formatting and Cascading Prompts reports.
Created Dashboard in Cognos Work Space and as well using Portlets.
Implemented Security for different Groups.
Created Dynamic linking in between the Reports
Created Jobs and Report Views for Scheduling the Reports
Created Worksheet using Tableau Desktop
Created Dashboards using the worksheet developed in Tableau Desktop
Publishing the Desktop Reports to Web using Tableau Reports.
Created Visualizations as per the User Requirement
Environment: Report Studio, Work Space, Analysis Studio, Javascript, Framework Manager, Tableau, SQL Server
IBM
Client: Victorian order of Nurses, Canada Jun 2012 – Nov 2012
Senior Cognos Developer
Victorian order Of Nurses is a Not for Profit health care organization. Procura is the source system for Cognos and it is a Home Care Software that enables VON to conduct and manage its core business processes. Procura is first and foremost a scheduling and billing system where service requests are documented and processed from the moment the Intake team receives a request to service a client to the moment the service is scheduled, fulfilled, verified, billed and paid for. Clients are referred to VON by the Canadian Association for Community Care (CCAC) for service in three main areas: Home Support, Community Service and Nursing. The service request is received via email and it normally contains the type of service the Client is to receive, as well as the duration and frequency of the visits and there involves development modules.
Responsibilities:
Interacted with client, onsite team for gathering the requirements.
Analyzed the requirements with a technical insight and provided estimations for the work.
Independently prepared Report spec documents.
Responsible for developing / enhancing complicated Reports.
Integrating these reports in a Dashboard and passing communication between these Reports in the Dashboard.
Creating portlets for the user to Navigate to the Dashboard directly.
Developed the Summary Reports and Detail Reports for Internal Business Process.
Developed the reports using Crosstabs.
Prepared the reports using prompts, cascading prompts, filters and variables in report studio.
Used Drill Up and Drill down feature in the reports.
Used Rendering based on conditions.
Showing Trending Images in Crosstab measure based on Values shown in the Crosstab.
Performed Conditional Styling for the numbers shown in the Crosstab.
Designing drill through reports for analyzing the business performance.
Created Jobs and Report Views for Scheduling Purpose.
Moving the Reports from Test Environment to Production Environment.
Environment: Report Studio, Event Studio, Analysis Studio, Framework Manager, DB2
Tech Mahindra
Client: Barclays, United Kingdom Sep 2011 – May 2012
Senior Cognos Developer
In Barclays Africa, E2E Management of Operations Information - from Data collection to End-Report production – is a highly manual process requiring a large number of local / regional resources to support the increasing information need from Operations Functions and Senior Management and maintain a satisfactory level of quality on the data produced on daily/monthly basis. E2E Automation Initiative will provide a fully controlled and efficient Management of Operations Information preventing data quality issues, reducing significantly the level of manual intervention and providing effortless access to Operations information (Performance Indicators & Issue Log).
Responsibilities:
Understanding the business requirements for the development of reports and designing the reports
Involved in Creating / Updating Framework Manager Models
Created Triggering Events by using Event Studio for automatic mailing the reports
Developed list reports and cross tab and chart reports.
Prepared the reports using prompts, cascading prompts, filters and variables in report studio
Used Query studio for Ad-hoc Reporting and Report studio for Advanced Reporting
Developed and Executed Test Cases.
Used conditional formatting based on Threshold values.
Used Rendering based on conditions.
Designing drill through reports for analyzing the business performance
Used JQUERY core library functions for the logical implementation part at client side for all the application.
Environment: Report Studio, Event Studio, Analysis Studio, Framework Manager, Teradata
Kantar Operations
Client: Toyota, Japan Feb 2009 – Aug 2011
Senior Cognos Developer
Toyota is one of the biggest manufactures of Automobile parts, ranges from Heavy Vehicle to Small Vehicle, and a wide network throughout the globe. Being one of the oldest and strongest competitors in the automobile parts production more than 1000 categories of parts are supplied to the Vendors across the globe. The company set to Cognos enterprise BI solution that could provide the company as analysis and reporting to help the sales information particular area wise sales, product wise sales, Transportation and generate the reports monthly, quarterly and yearly sales, this reporting helpful to improve the company product sales and the information from the distributors.
Responsibilities:
Analyzing the changes requested for the reports from the specification and identifying the gaps.
Involved in Creating / Updating Framework Manager Models.
Create complex reports in Report studio.
Prepared various reports using cascading prompts, Text box prompts and value prompts in Cognos Report Studio.
By using Event Studio attaching multiple report outputs to a single email
Designing drill through reports for analyzing the business performance
Preparing the Test cases for the reports based on the spec.
Used conditional formatting based on Threshold values.
Used Rendering based on conditions
Created reports Views and scheduled in Cognos connection
Environment: Report Studio, Event Studio, Analysis Studio, Framework Manager, Oracle10g
Kantar Operations
Client: Baxter International, IL May 2007 – Feb 2009
Cognos Developer
Baxter International Inc. (NYSE:BAX), through its subsidiaries, develops, manufactures and markets products that save and sustain the lives of people with hemophilia, immune disorders, infectious diseases, kidney disease, trauma, and other chronic and acute medical conditions. As a global, diversified healthcare company, Baxter applies a unique combination of expertise in medical devices, pharmaceuticals and biotechnology to create products that advance patient care worldwide. Baxter had sales of $12.6 billion and has approximately 49,700 employees.
Responsibilities:
Used Report Studio to develop various types of reports like List Reports, Cross tab Reports Chart Report & Master Detailed Reports as per the client requirements.
Involved in creation of Drill -Through and Master-Detail reports.
Prepared various reports using cascading prompts, Text box prompts and value prompts in Cognos Report Studio.
Created Drill up & Drill down in Reports
Developed reports based on conditional formatting.
Created reports Views and scheduled in Cognos connection.
Preparing the Test cases for the reports based on the spec.
Created reports Views and scheduled in Cognos connection
Environment: Report Studio, Query Studio, Oracle10g