Manager Developer

VINOD KUMAR JAYABALAN Scottsdale,AZ

BI/ETL/Database Developer 732-***-****

*******@*****.***

SUMMARY

●14+ years of experience in Information Technology with emphasis on Business Intelligence and Data warehousing

●Worked as a Senior Developer for many clients providing end-end Dev/Support

●Worked on Agile Methodology Process for more than 9 years with Cross Functional Business teams

●2+ years of Healthcare Experience including Facets TriZetto, RxClaim, Valencia, Medforce, CMS and AAH

●Provide process improvements and solutions to Development & Administration

●13+ years of strong experience in developing Complex reporting solutions using Cognos BI 10.2/8.4/8.3/7.3 and other BI tools including Tableau, Business objects and Crystal Reports

●Worked as Cognos Architect role for Clients. Strong Experience on all Cognos BI Products including Workspace, Workspace Advanced, Report Studio, Query Studio, Framework Manager, Metrics Studio, Transformer. Business Insight and Business Insight Advanced

●Installed and Configured all Cognos BI products in Production and all other environments

●Experience on installing and Configuring TM1,have integrated Cognos BI security with TM1

●Experience in data warehousing concepts, data modeling and OLAP.Strong knowledge on Ralph Kimball and Bill Inmon Datawarehouse Strategey.

●Strong Data Modeling Experience to meet the complex reporting requirements.

●Experience in Business Objects Desktop Products (Supervisor, Designer, Business Objects Reporter) and Enterprise Products (Web Intelligence and Application Foundation).

●Basic Knowledge of ETL Mappings and Workflows –OWB, informatica, Microsoft DTS and Humming Bird-Genio and Oracle DBA

●Production support (Level1, Level 2 and Level 3) and Training to end users

●Strong SQL experience in MS SQL Server, Oracle, SSIS, Teradata and follow Database Naming Standards

●Experience in Requirement Analysis, Design, Development, Testing and Implementation of Software

●Quick Learner of Business Processes and Technologies

●Excellent interpersonal communication skills, team player with commitment to excellence

●Experience in working with clients to gather requirements

EDUCATION:

●Harvard Business School- Digital Strategy and Innovation 2020

●M.S- Computer Science, University of Alabama in Huntsville, United States, May 2008.

●B.E- Computer Science, Bharathiar University, India, Apr 2003.

Certifications

●IBM Certified Designer Cognos 10 BI Reports and Cognos 10 BI Administrator

Skills and Knowledge

Databases

Oracle10.x/8.1/8i, MS SQL Server 2000, DB2, MS Access,Teradata

ETL

Humming Bird. Oracle Warehouse Builder (OWB), Informatica,

Microsoft DTS, Microsoft SSIS Packages

BI Reporting

Cognos Analytics 11,10.2, Cognos Insight, Workspace, Workspace Advanced, Cognos8.3(Report Studio, Query Studio, Framework Manager, Transformer Analysis Advanced, Cognos8.3(Report Studio, Query Studio, Framework Manager, Transformer Analysis Studio, Event Studio, Metrics Manager),Cognos ReportNet 1.1 MR2,Cognos Transformer 7.3,Cognos Power Play 7.3, Cognos Metrics Manager 2.1, Cognos Visualizer 7.3,Business Objects 6.1b, Web Intelligence, Crystal Reports Tools, Tableau

Languages

C, C++, VC++, SQL, PL / SQL, Java, PHP,UNIX Basics

GUI

Visual Basic, FACETS,Salesforce

Other Tools

Toad, Chameleon, Google Earth (Kml)

Functional

Finance, Healthcare, Hospitality, Telecom, Retail and Banking

PROFESSIONAL EXPERIENCE:

Genuent-NOV client,Houston,TX July 2020 to Till Date

●Remote Cognos Developer

●Created Reports and Models using Cognos 11 and Framework Manager

●Worked on T-SQL,SQL

●Worked on their internal systems,databases and Datawarehouses including Oracle

and SQL Server database on Azure

CRST Inc Feb 2020 to July 2020

●Currently undergoing Informatica Training

●Cognos TM1 self-Training

Riskonnect Inc,Scottsdale,AZ(Remote and Onsite)

Cognos Administrator Nov 2019 to Jan 2020

●Cognos 10.1 to 11 migration

●Salesforce support and Cognos Production support

●Fix FM packages,reports including Dashboards

RTI International Durham, NC Mar 2019 to Nov 2019

Cognos Lead /Database Developer

Tools: Cognos 10,11+, SQL Server,SSIS,PowerBI,BSP,Cognos TM1,Accounting Hub

●Worked for Workforce, Revenue and Projects Data

●Worked on to understand the reports requirements and other systems including Acct Hub Revenue

●Installed and administered Cognos 11.x version

●Created Stored procedures,views,packages,Dashboards,reports

●Worked on Mapping documents, Analysis and UAT

●Worked on analyzing the SSIS packages for data issues and understanding

●Work on TSQL procedures

●Have experience in Database naming coveti

●Have done TM1 security implementation on IBM Cognos Servers

●Installed and Configured IBM Cognos Analytics

●Provide full support on Cognos Maintenance with other teams

Germania Insurance Brenham,TX May 2018 to Feb 2019

Sr.Cognos Developer/Database Developer

Tools: Cognos 10 & 11 Oracle and SQL Server

●Worked for Insurance Reporting and other internal systems including Guidewire and other applications

●Worked on data including Auto, Property and Liability

●Worked on to understand the reports requirements and other systems

●Created Reports,Dashboards,using Cognos Report Studio

●Followed Scrum Methodology

●Worked on Mapping documents, Analysis and UAT

Johnson & Johnson, Bridgewater, NJ Nov 2017 to Feb 2018

Sr.Cognos Developer

Tools: Cognos 10.2.2 & 11, Tableau,Corporater, Oracle and SQL Server

●Worked for SCM/ Financial Reporting Project

●Worked on to understand the reports requirements and other systems

●Created Reports using Tableau and Cognos

●Followed Scrum Methodology

●Worked on Mapping documents, Analysis and UAT

HCSC, Chicago, IL Sept 2017 to Nov 2017

Senior Cognos Modeler/ Developer

Tools: Cognos 10.2.1 & 11, Oracle, Teradata, Aptitude Accounting HUB database, BIG DATA

●Worked for Financial Services Division Reporting Project

●Worked on to understand the reports requirements and other systems

●POC on development/security/reports solutions using Tableau/Cognos suite of products

●Followed Scrum Methodology

●Worked on Mapping documents, security templates and Framework documentation

Erp Global Inc, Troy, MI Apr 2017 to Sep 2017

Sr Cognos Developer/Database Developer

Financial Reporting Project

Tools: Cognos 10, Cognos TM1,SSIS,SSRS, Oracle 11g

●Cognos BI 10.2 & Cognos TM1 Administration and Production support.

●Have installed configured Cognos BI, Cognos TM1, Cognos Planning

●Provide Level1, Level2 and Level3 Support, provide solutions to Administration and Development

●Design, Develop, Build and Test Cognos Reports

●Developed Report Studio reports queries, filters, conditional formatting, aggregations,

CVS Health Nov 2014 to Mar 2017

Senior BI/Developer/Database Developer

Tools: Cognos 10, SSIS. FACETS, SSRS, Oracle 11g, MS-SQL Server, Medforce, RxClaim, Valencia, Teradata

●Interact with Business users to gather requirements

●Write BRD, Approach, Design and Unit Test Case documents for Medicare Part D Projects

●Developed AENO, Out of Area, Routed Calls, Discrepancy, Undeliverable Mail & healthcare reports

●Process Improvements within the team

●Design, Develop, Build and Test Reports. Provide Solutions to Development

●Develop reports using SQL technology including Oracle and SQL server and other BI tools

●Production Operations Support using HPSM tickets and regular reports

●Work on Healthcare systems including Facets-Trizet to and other internal systems and perform reporting based on it

●Worked on Facets which includes Medicare Part D Data, Member Enrollment data, Eligibility Data, RxClaims, Configuration Data, Plans and Groups, Part D Events.

●Understanding of Facets Data model (Subscriber Eligibility, Customer Service, Groups, Plan)

●Cognos Reports, Report Studio, Query Studio, Workspace, Workspace Advanced, Analysis Studio and Transformer Cubes

●HPSM Incident and Problem Management

●Create, Build and Test Microsoft Sql Server Integration Packages for reporting.

●Work on Automation of Queries using Microsoft SSIS packages.

●Develop, Design Packages using SSIS for various projects.

●Perform analysis on various source systems including Medforce, AS400, Datawarehouse, MS-Access and other systems and develop reports.

●Worked on Medforce Databases and other Rxclaims systems, created reports for Paper Claims Processing.

Wayne State University, Detroit, MI Sept 2014 to Nov 2014

Senior Report Writer/Cognos Architect/BA/Database Developer

Tools: Cognos 10.2, Oracle 11g

●Gather reporting requirements with SME’s

●Design, Develop, Build and Test Cognos Reports

●Developed Reports for Development and Alumni Affairs Department

●Created Reports on Family Gifts, Donors

●Performed Analysis using reports and Oracle Queries

●Work on Databases-Oracle

Cognizant Technology Solutions US Corp –Mar 2008 to Sept 2014

Comerica Bank, Detroit, MI May 2013 to Sep 2014

Lead Cognos /BIDW/Senior Developer/Administrator/Architect

●Cognos BI 10.2 & Cognos TM1 Administration and Production support.

●Have installed configured Cognos BI, Cognos TM1, Cognos Planning

●Provide Level1, Level2 and Level3 Support, provide solutions to Administration and Development

●Design, Develop, Build and Test Cognos Reports

●Developed Report Studio reports queries, filters, conditional formatting, aggregations,

●Calculations, block variables, Drill down, drill through, Page Set, etc

●Created Reports for Loan Applications, Credit Cards,Refferals and for Sales

●Have worked on Framework Modeling Changes

●Managing 21 applications which are developed using Cognos suites of Products

●Have developed dimensions,cubes using Cognos TM1 using input files as source

●Have added users to Cognos TM1,Cognos BI & Planning

●Incident, Problem and Requests Management through Service Desk

●Co-ordinate with Offshore team and Business users

●Educate users on using Cognos Workspace Advanced and other Cognos Products

●Analysis of Incidents and fixing/providing solutions

●Work on Databases including Oracle, DB2 and SQL Server

●Worked on Lifecycle Manager and BSP MetaManage

Crawford Insurance-Chicago, IL Sep 2011 to May 2013

Lead Report Developer/Database Developer

●Analysis of Reports sources from Business Objects and other Oracle reports

●Interact with Client to get requirements

●Perform Gap Analysis

●Mapping between Source and Target systems for Reporting needs

●Creation of Reports using Cognos tools including Report Studio, Query Studio and FM

●Developed Complex reports using Report Studio

●Unit Testing

●Assign work to team members

●Provide technical support to Cognos Developers

●Co-ordinate with Offshore team

Arthur J Gallagher, Chicago, IL May 2011 to Sep 2011

Sr Cognos Developer/Database Developer

●Analysis of Reports sources from Hyperion, SQL and access reports

●Creation of Reports using Cognos Report Studio and Query Studio

●Framework Model changes using Facts and Dimensions

●Unit testing of Cognos Reports

AAA Insurance, Phoenix, AZ - Oct 2009 to May 2011

Cognos Developer & Administrator/Architect

●Cognos 8.4.1 Administration and Production support

●Building, Scheduling and Monitoring Cubes using Batch scripts

●Deployment of Reports, Cubes and portal pages between Dev and Production environments

●Implementing Security and Enabled Single Sign On

●Analysis of Reports issues in Production Worked on Transformer Power Cubes Changes

●Upgraded the Cognos Environment from Cognos 8.3 to 8.4 and 8.4 to 8.4.1

●Installed Cognos 8.4 on a multi-server environment and configured with IBM WebSphere

●Installed and Configured Cognos Go Dashboard

●Installed and Configured Metrics Server, Designer and created metric store

●Install of Fix packs and hotfixes for Cognos BI products.

●Moved the metric files from SQL server database metric store to Oracle metric store through Cognos

●Use of Maximo for managing Change in Production

●Supporting startup and shutdown of Cognos Services during Security patching.

●Cognos 8.1 Planning Administration-Adding users and running Admin links, GTP

●Developed few reports on Audit and few reports for ETL Job Status using Informatica Tables

CUNA Mutual Group, Madison, WI Aug 2009 to Oct 2009

DW/BI Test Lead

●Interacted with clients on getting the testing requirements.

●Analyzing their source systems,ETL approach and Business Objects Reports

●Defined the scope of testing

●Designed the flow of testing which includes the testing approach on ETL and Business Objects Reports.

●Involved in system testing on the ETL source systems which involves testing from different stages, i.e. testing from source to staging and from staging to EDW and from EDW to Data marts.

●Involved in analysis on some of their ETL mappings.

●Tested the Business Objects reports by writing SQL queries on the backend.

●Involved in Defect Triage Meeting with the Development teams to work on the defects found during testing.

●Worked on HP Quality Center 9.2 for test case execution, creating and logging the defects.

John Hancock Insurance, Boston, MA Aug 2008 to July 2009

Cognos Architect/Developer/Lead/Administrator/Database Developer

●Interacted with SME’s on getting the requirements.

●Analyzing of clients Crystal Reports, source tables

●Creating Oracle Stored Procedures using PL/SQL Programming language.

●Creating Cognos Framework Models and Reports using Framework manager and Report Studio.

●Creation of Filters, prompts, calculations in Report studio

●Development of Cognos Reports, Test and Deliver.

●Installed and Configured Cognos 8.3 suite of products including Cognos Go Office!

●Portal Administration and Worked on Security –Users, Groups and Roles

●Configured Audit Reporting.

●Scheduled Reports using inbuilt Trigger functionality and using Events

●Exported and Deployed Packages, Report Specifications from Development to Test and Production Environments.

●Written technical and end user documentation on Cognos.

●Trained the Clients on Framework Manager.

●Installed the patch update for Cognos 8.3

●Code reviews and UAT

Travelers Insurance, St Paul, MN Mar 2008 to Jul 2008

Architect/Developer/Lead

●Analysis of Requirements.

●Developed Framework models based on their Data Models.

●Developed Cognos Reports according to customer’s requirements. Extensive amount of portal customization and integration with their web application was done as part of the requirements

Information Technology Systems Center, Huntsville, AL Aug 2006 to Dec 2007

Graduate Research Assistant (Part Time)

●Designed and develop web pages using JSP, JavaScript and PHP to render data

●Worked on web services using Apache Axis and Java. Involved in creating wsdl files and generating server and client stubs and writing client interface using JSP.

●Worked on Oracle and My SQL 5.0 databases

●Worked on Open source mapping Tools such as Chameleon and Map Server.

●Involved in Creating Maps for Map Server using Shape files.

●Worked on Google Earth using Kml files.

●Designed the user interfaces using JSP(Java Server Pages) and HTML

Academic Project, University of Alabama in Huntsville May 2007 to Aug 2007

I-Quest (An Intelligent Query Structuring Based on User Browsing Feedback for Semantic Retrieval of Video Data)

●Created User interface using Asp.net and Vb.net.

●Embedded video player on web.

Wipro Limted, Dubai Jan 2006 to Jul 2006

Data Warehouse/ Senior Cognos Developer /Database Developer

●Performed system analysis, design, development, coding, generation of reports, testing and documentation.

●Collected requirements from clients, prepared requirements document, followed up and developed new report templates as per the client request

●Involved in Logical and Physical Data model and created Business models using Framework Manager

●Used Cognos Connection for organizing, security, scheduling and distributing reports.

●Building models and publishing packages in Framework Manager to the Report Net server.

●Created cubes from multiple iqds using Cognos Transformer

●Created drill thru reports from Cognos Power Play to Cognos Report net

●Created Scorecards, (KPI’s) and Dashboards using Cognos Metrics Manager and Cognos Visualizer

●Implemented security for Cognos Transformer, Report net, Metrics Manager

●Trained the Clients in Cognos

●Supported UAT

Data Warehouse Developer (Cognos/Business Object/ETL)

Wipro Limited, Bangalore, India-Mar 2004 to Dec 2005

Hospital Client, Wipro Limited, India -Apr 2005 to Dec 2005

Telecom Client, Wipro Limited, India, (Jul 2004 to Apr 2005)

Retail Client, Wipro Limited -(Mar 2004 to Jul 2004)

●Analysis of the specifications provided by the clients

●Installation of Cognos suite of Products.

●Cognos Administration- security, scheduling and distributing reports.

●Creation of Framework models using Framework Manager

●Building models and publishing packages in Framework Manager to the ReportNet server.

●Development of filters, calculations, prompts, conditions, and created various reports, using Cognos Report Studio.

●Created cubes using Cognos Transformer

●Perform Oracle DBA activities, importing, exporting and backup

●Created both summary and detail reports using Cognos Powerplay and Reportnet

●Implemented security for Cognos Transformer, Reportnet, Metrics Manager

●Created drill thru reports from Cognos Power Play to Cognos Reportnet

●Involved in Logical and Physical Design of the database

●Replicated the Logical Data models using Cognos Framework Manager.

●Replicated the Reports using Cognos suite of Products.

●Experience in designing and building Universes, Classes and objects using Business Objects

●Created Cardinalities, Joins and Aliases for resolving Loops and checked the Integrity of the Universes.

●Perform Oracle DBA activities, importing, exporting and backup

●Exported the universes to the Repository for making resources available to the users. Created reports for various Portfolios using the Universes as the main Data Providers.

●Used Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae’s etc.

●Experience in BO Reporter, Designer and Supervisor modules, Query Panel and Data Provider.

●Created universes including universe parameters, objects and classes in BO Designer.

●Used Designer Module to Create prompts and queries, applied Aliases to remove cyclic loops

●Backups and Recovery in Test Environment using Oracle (DBA activities).

●Unit and module testing

●Maintaining VSS (Visual Source Safe)

Contact this candidate