Uday Krishna Bende

Analytics Lead

E-mail: adbwzx@r.postjobfree.com

Mobile#: +1-804-***-****

Professional Summary

Having 13+ years of experience in working with Data Warehousing Technologies.

Having decent knowledge on Salesforce Einstein Analytics Tool (Wave Analytics, Data Manager)

Completed 28 badges, 4 Trails, 1 Super Badge at Trailhead with holding Mountaineer Rank.

Having sound knowledge on Cognos business intelligence tools like Cognos Analytics (Cognos BI 11.0.x/10.2.2/8.4/8.3/8.2/7.1), Cognos 10.x TM1 (Architect/Perspectives) Report Studio, Work Space, Active Reports, Query Studio, Event Studio, Impromptu and Framework Manager.

Experience in all phases of Software Engineering (SDLC), Project management (Waterfall & Agile/Scrum Methodology) including Requirement Gathering, analysis, Define project scope, Design, Coding, Manual Testing, TTD and Implementation.

Extensive Experience in Creation of Input Sheets, Report Sheets and Building/Scheduling/Monitoring the TM1 Chores and its processes

Experience in Developing and Published Packages in Framework Manager i.e., connecting and testing the data source, creating Database layer, Business layer and Presentation layer as per Business Requirements.

Experience in Installing, Configuring and maintaining COGNOS Analytics in Window/ Linux Environment.

Experience working with different databases like Oracle, DB2, Tera data, Netezza and MS SQL Server.

Certified in COGNOS 8.4 and 10.1 Report Author.

Certified in COGNOS Meta-Data Modeling.

Certified in Hadoop (Cloudera).

Trained, Tested and Certified in Quality “Green Belt Six-Sigma” and applied in a project showing a sayings of 1440 Man Hour Savings

Trained, Tested and Certified in Quality ‘LEAN’ showing the savings of 300 Man hours

Trained in Basic SAS, QilkView, Tableau Reporting Tools.

A Team Player with analytical and problem solving Skills, ability to communicate effectively at all levels of the development process.

Flexibility and adaptability in regards with new technologies and environments.

Research-oriented, motivated, proactive, self-starter with strong technical, analytical and interpersonal skills and zeal in learning new Technologies.

Skill Set

BI Tools : Salesforce Einstein Analytics (Wave Analytics, Data Manager),

IBM Cognos (Report Studio, Query Studio, Event

Studio, Frame Work Manager, Work Space, Work Space

Advanced, Impromptu, TM1 (Architect/ Perspectives), Power-

play, Transformers),SSRS, Business

Objects

ETL Tools : Informatica, Turbo Integrator (Internal Product of TM1)

Hadoop Eco System : Hadoop- HDFS, HIVE, PIG

Platform : Windows, Linux.

Database : MYSQL, Oracle, Netezza, TeraData, DB2

Design Methodologies : UML, Rational Rose.

Scripting Languages : Java Script, JSON

Verticals : Retail, Insurance, Banking, Auto Financial, Aero-

Space, Automobiles, Telecom, Emergency Services, Manufacturing

Documentation Tools : MS-Word, MS-Excel, MS-Power Point.

Professional Experience

Client: BCBSA Aug‘19 - Till Date

Project: FIRE Analytics 2.0

Role: Analytics Lead

Environment : Salesforce Einstein Analytics, Cognos Report Studio, Frame Work Manager, IBM DB2 BLU

Description:

Blue Cross Blue Shield Association (BCBSA), through its Licensees, has been growing the Blue Cross and Blue Shield (BCBS) portfolio of international health insurance products in order to meet the needs of increasingly mobile customers. It began with the BlueCard Worldwide® program to support coverage outside the U.S.; expanded in 2010 to include GeoBlue Expatriate, Traveler and Student products; and was then followed by the 2014 announcement of a strategic global partnership between BCBSA and Bupa Global for co-branded Expatriate products sold outside of the U.S. This partnership of two of the most trusted brands in healthcare delivers a comprehensive portfolio of international products to meet the needs of customers, no matter where they work, live or travel.

Responsibilities:

Involved in understanding reporting requirements for FIRE Analytics 2.0 Project from Business users.

Attend the Stand-up & Status meetings on daily basis with the team.

Understand the FRS, BRD documents and discuss in detail with the changes with Client and end users.

Create a delivery plan of Model for datasets and dashboards for each Executive as per their needs

Responsible for entire Wave Analytics Implementation and support.

Building Dashboards for Managing Directors and Executives to be able to measure performances of the teams

Create/modify JSON and build SAQL queries

Understand and uncover business challenges and issues and create Wave datasets, Dataset Recipes, dashboards and lenses to help isolate the critical areas

Proficiently working with salesforce object, layouts, workflows, recipes reports, dashboards, and logical formulas.

Write SFDC SOQL queries to search and display data from SFDC Org using tools such as Workbench

Designing, developing, and maintaining reports and multi-level dashboards in Wave

Worked extensively on complex bindings using various datasets created from different different sources and merging with the salesforce data

Creating and Maintaining Cognos Frame Work Manager Packages

Responsible to handle any issues that arises with in the other projects (CCP, HEDIS etc) that relates to COGNOS reports or FM model.

Completed some of the healthcare related exams like HIPAA (Health Insurance Portability and Accountability Act).

Client: Macys Systems & Technology Jan‘19 - Aug’19

Project: BOSS 3.0

Role: Analytics Lead

Environment : Cognos Report Studio/TM1 Architect/TI/Perspectives, Frame Work Manager, SSRS, TeraData

Description:

Macy’s Systems and Technology, Inc. engages in creating, gathering, and directing pieces of data to form management tools. The company provides integrated retail, e-commerce, and data warehouse systems. It also offers a range of services from advanced in-store register systems to sophisticated data management to the burgeoning online marketplace. Macy's Systems and Technology handles various issues, including hardware and software troubleshooting, point of sale terminal repairs, and support and maintenance of telecommunications systems through field representatives and technicians. The company was founded in 1994 and is based in Duluth, Georgia. Macy’s Systems and Technology, Inc. operates as a subsidiary of Macy's, Inc. it is recently renamed as Macy’s Technology

Macy’s has more than 10000+ employees and with 10 Billion Dollar Revenue per Year. Major IT Locations of Macys are San Francisco and Atlanta and a couple of Corporate Offices from New York, Cincinnati etc.

Responsibilities:

Involved in understanding reporting requirements for BOSS 3.0 Project from Business users.

Responsible for Collecting Requirements, Developing, Deploying and Documentation of each report

Use Jira Site to create the stories and keep track of each task and move them as per the time scheduled

Attend the Stand-up & Status meetings on daily basis with the team.

Modify the existing Standard Reports which are based out of VB Script on UI level with MDX code behind it along with base tables in Teradata on which these reports behave.

Responsible to modify 4 existing Models (Financial Model, Item Size, Item Daily and Item Weekly) and republish the new version of packages

Responsible for modifying the existing reports (12 reports) which needs the new elements that are populated in the new packages.

Responsible for deploying the modified Packages and reports to Production.

Documentation of all the changes done to the 12 reports and packages.

Created Cognos TM1 Mark-Up Price Cubes for Store and COM(Online Sales) seperately and upon that created Cognos TM1 Web Sheets

Created TM1 Cube Views for Vendor Financial and Dept Financial using the existing Excel outputs

Actively involved in creation of TI Processes & Chores

Created Basic Rules & Feeders for most of the cubes

Client: Hepaco LLC, Charlotte Aug‘18 - Jan’ 2019

Project: Financial/Corp HR/Accounting Reporting

Role: Cognos Lead Developer/TM1 Architect

Environment : Cognos Report Studio, Frame Work Manager, TM1 Architect/TI/Perspectives, Sql Server, SSRS

Description:

HEPACO is a high quality environmental service provider dedicated to exceeding the expectations of our clients. Established in 1984, HEPACO has evolved into one of the market leaders providing solutions to solve the environmental challenges of our clients. HEPACO is an emergency response, industrial services, environmental remediation, abatement services, maritime services and non-hazardous waste water treatment company. We work with many well-known organizations in the transportation, communication, petroleum, energy, chemical, and institutional industries.

This project is utilize the existing package which DELTEK provides and create some business reports and clean the environment.

Responsibilities:

Responsible for Collecting Requirements, Developing, Deploying and Documentation of each report

Understanding the existing Packages produced by DELTEK packages and modify them as per the Client need.

Clean up Cognos Environment as existing Environment has multiple versions of each report. Modify the TABS on Home page to look better with new versions of the reports

Involve into fixing the bugs with the existing reports.

Creating TM1 Cubes for Accounting/Employee Benefits/Payroll using the flat files which are generated out of ERP System.

Created some TM1 Perspectives (Active Forms, Slice & Snapshot ) for their Front-End purpose.

Involved in Deleting and Loading Fresh data for the existing Cubes.

Actively involved managing 20+ TI Process and respective Chores.

Created some of the challenging report in short span of time. Reports like ADP Payroll ADP Pay data, ADP Benefits etc

Tune the performance of existing reports for better performance and format them as per the need.

Client: Pioneer Financial Services, Kansas May’ 18 – Aug ‘18 Project: Financial Reporting

Role: Cognos Lead Developer

Environment : Cognos Version 11.0.2 Report Studio, Sql Server, Oracle (Old Legacy System), Business Objects

Description:

Pioneer Services has provided financial services and lending to the military community for over 30 years, helping 1.4 million military families along the way. As the military division of MidCountry Bank, a federal savings bank, Pioneer Services provides access to short-term personal loans, VA home loans, and online financial education information and tools. At Pioneer Services, we’ve seen firsthand how military families with low or limited credit scores are often underserved by many mainstream financial institutions. In 2007, Pioneer Services was acquired by MidCountry Financial Corp., a diversified financial services holding company, and became the military division of MidCountry Bank. That means our customers get the protection and security of a federally regulated financial institution, and the flexibility and speed you need.

Responsibilities:

Involved in understanding reporting requirements from Business users.

This project has a collection of reports (53 reports) from different departments.

Responsible for Collecting Requirements, Developing, Deploying and Documentation of each report

Understanding the Legacy system data (Oracle) for verification of data

Understanding the existing Business Objects reports and recreate the reports in COGNOS

Involve in Daily Stand up meetings to discuss the status of report development and peer reviews.

Responsible to manage the existing Cognos Packages i.e., adding new tables, security settings, publishing and documenting.

Involve into fixing the bugs with the existing reports

Create a Gap Analysis documents that defines all the required elements which are missing in the packages compare with legacy Standard reports system.

Tune the performance of existing reports for better performance.

Client: Macys Systems and Technology, Johns Creek, GA Oct’ 17 – Mar’ 18 Project: Financial Reporting

Role: Cognos Lead Developer/admin

Environment : Cognos Version 11.0.2 Report Studio, TeraData, Jira (Agile Methodology)

Description:

Macy’s Systems and Technology, Inc. engages in creating, gathering, and directing pieces of data to form management tools. The company provides integrated retail, e-commerce, and data warehouse systems. It also offers a range of services from advanced in-store register systems to sophisticated data management to the burgeoning online marketplace. Macy's Systems and Technology handles various issues, including hardware and software troubleshooting, point of sale terminal repairs, and support and maintenance of telecommunications systems through field representatives and technicians. The company was founded in 1994 and is based in Duluth, Georgia. Macy’s Systems and Technology, Inc. operates as a subsidiary of Macy's, Inc. it is recently renamed as Macy’s Technology

Macy’s has more than 10000+ employees and with 10 Billion Dollar Revenue per Year. Major IT Locations of Macys are San Francisco and Atlanta and a couple of Corporate Offices from New York, Cincinnati etc.

Responsibilities:

Involved in understanding reporting requirements from Business users.

Involve in Daily Stand up meetings and discuss the stories that are assigned to me, as each deliverable duration is 2 weeks (Agile Methodlogies).

Majorly involved with the report Development like Financial Vendor Chain, Financial Vendor Location, Financial Vendor Summary, Financial Department Summary and Private Brand Category.

Responsible to manage the existing Cognos Packages i.e., adding new tables, security settings, publishing and documenting.

Primarily back up of admin with involvement of upgrading COGNOS 10.2.2 to Cognos Analytics.

Involve into fixing the bugs with the existing reports

Lead the offshore team and responsible to assign the work for the team and ensure the work done on a daily basis.

Create a Gap Analysis documents that defines all the required elements which are missing in the packages compare with legacy Standard reports system.

Involved in minor updates at Teradata tables to get some new values reflected to report prompt pages.

Preparation of moving the reports from Cognos Report Studio to Cognos Analytics (11.0.7 Version)

Creating some Manual reports into Cognos to get rid of Manual Efforts. So Meeting each Stake holder to understand their reports and finding the possibility of creating their reports

Understanding the existing macros in the existing reports and document the specifics and changes as well.

Client: SunTrust Bank, Richmond, VA Jun’16 – April’ 17

Project: Consumer Lending

Role: Cognos Lead Developer

Environment : Cognos Version 11.0.2/10.2.2, Report Studio, Frame Work Manager, Cognos TM1 10.x, Toad, Oracle

Description:

SunTrust Banks. Inc with total assets of $191 billion as of December 31, 2015, is one of the nation’s largest and strongest financial services companies, as they offer a full suite of products and services designed to meet the needs of our consumer, business, corporate and institutional clients. The company operates approximately 1400 retail branches and 2160 ATMs in multiple states of United States of America. SunTrust Bank Private Wealth Management (PWM) team has come up to automate the existing reports which are currently created manually

Responsibilities:

Involved in gathering reporting requirements from Business users.

Analyzing the complexity of the requirements and reframing them to get the better clarity.

Understand the given SQL’s of each report and define what all reports can be merged into single reports.

Understanding each report macros and excel formulas and analyze the database related to each used table for each report.

Involving the processing of create the Data lake (Merge of different Data Sources).

Created the Master report with prompt options that will define the report output (Each report for each department)

Examination of the existing Frame work model to recommend the ideas to tune it and help to do new implementation i.e., changes to packages and developing new packages.

Involved in upgrading Cognos Environment to Cognos Analytics.

Loading/Deleting the Data in the TM1 Cubes.

Created Some Cube View for Wealth management Account by Regions.

Created Web Sheets for Regional Managers related for Wealth Management.

Using Cognos Analytics (Latest Version) created some dashboards.

Test the reports again writing a manual SQL hitting the database using the TOAD.

Develop cubes based on the requirement and modify the existing based on the need.

Lead a team of 8 people i.e., assigning and Monitoring their work.

Transferred technical knowledge specific to Cognos tools and the existing data model to other team members

Client: NOV, Houston, TX Mar’ 15- May’16

Project: Pressure Control Engineering

Role: Cognos Lead Developer

Environment : Cognos Report Studio, Oracle

Description:

National Oilwell Varco (NOV) has always been to provide the energy industry with the highest quality oilfield products and services available. NOV designs, manufactures and sells major mechanical components for land and offshore drilling rigs, complete land drilling and well servicing rigs, tubular inspection and internal tubular coatings, extensive lifting and handling equipment, and a broad offering of downhole drilling motors and tools. NOV also provides supply chain services through its network of distribution service centers located near major drilling and production theaters worldwide. With over 800 manufacturing, sales and service center locations in 61 countries, NOV supplies customer-focused solutions that best meet the quality, productivity, and environmental requirements of the global energy industry.

Responsibilities:

Involved in gathering reporting requirements from Business users.

Analyzing the complexity of the requirements and reframing them to get the better clarity.

Involved in Daily and Weekly Status Meetings to track down the report developments.

Created 8 different dashboards for each group (SBOP, Riser, Stack, Stack-Jackups, Riser, Ram, Upgrades, Rockwell)

Bursting of Cognos reports based on the Work Orders assigned to employees and Summary reports to their respective Managers.

Work Extensively on Active Reports and Workspace for each department

Installed Vizio, Cognos MapInfo Pro, Cognos Map Manager.

Designed & Developed Physical Work Station of each Department using MapInfo Pro and developed Maps using Map Manager to monitor Work orders and Work items to track their dependency.

Developed Dashboard and placed them on TV Screens of each department with auto refresh which help employees to check the live status.

Involve in testing the modified reports in different environments.

Played a key role while modifying existing reports to have a better view from the point of Business users.

Involve in the process of moving the reports to User Acceptance Environment through a specified process.

Created a complex reports which talks about the Sales order, Sales Line Item, Wok Order, Sub-Assembly items and related work orders.

Tuned the Performance of Environment and Documented the Techniques.

Provide user training on the various reports created as part of the Project.

Created Active Reports for each department which shows list of new work orders and relate parts to order new Work items to close those work orders on a monthly basis.

Created new reports using Visualization and studied on Visualization tool to modify & create new Visualization

Trained the Business users on how to create reports and understanding of existing reports.

Created Events and alerts over email regarding Work Orders for each department head.

Involved in Planning & Implementing to move to Cognos 10.2.2 to Cognos Analytics.

Client: UNUM, Portland-ME Aug’14- Feb’15

Project: In-sourcing Customer Reporting

Role: Sr. Cognos Developer

Environment : Cognos Report Studio, DB2 (TeraData SQL tool), Netezza

Description:

Unum US is the U.S. market leader in both group and individual disability insurance and group long-term care, as well as one of the largest providers of group life and voluntary benefits — products uniquely suited to meet the demands of today's diverse workforce. Unum has more than 5000 Clients in different Standard industries. Unum has come up with the list of Standard reports that would help their customers about the detailed information on the Claims and Leaves raised by their organization. Apart from the Standard reports Unum also wants to replicate an application which resides in the existing Legacy System (OCI) using Cognos Reporting functionality.

Responsibilities:

Involved in gathering reporting requirements from Business users.

Strategy & Planning, Results Accountability Complete ownership of end to end of single application related to Claims.

Analyzing the complexity of the requirements and reframing them to get the better clarity.

Involved in Daily and Weekly Status Meetings to track down the report developments.

Scaled up the infrastructure based on the increased user base and reports.

Created 1 Standard Report for all customers and 19 Application reports for the Specific group (Data Analyzer Group) of users for internal purpose.

Involve in testing the modified reports in different environments.

Played a key role while modifying existing reports to have a better view from the point of Business users.

Analyzing Teradata SQL and recreate the same views in DB2

Client: Ally Financials, Detroit-MI Feb’09– Jul’14

Project: Commercial Risk Management System

Role: Technical Lead/ Sr. Cognos Developer

Environment : Cognos Report Studio, Event studio, Query Studio, Frame Work Manager.

Description:

Ally Financials Inc. is one of the leading financial services company in North-America which provide financial services to more than 6000 “Automobile Dealers” and serving more than 4000 dealers across different countries (International Operations). Ally also provides financial services to the customers who buy vehicles from the Dealers and serve as BANK. Ally has come up to produce the Commercial Dashboard, Regional Commercial Dashboard, Commercial Dashboard with Dealer code and ALLY BANK Dashboard in Cognos environment which gives complete picture of the ALLY Business and as well planned to produce some critical reports for different divisions i.e., (Audits, Outstanding, Risk, Reviews, GMAC Performance, and Dealer Performance) and automate them in Cognos environment by scheduling on monthly, weekly and daily basis.

Responsibilities:

Involved in gathering reporting requirements from end users.

Involved in tracking effort and schedule of the project understanding and participating the planning activities Identifies risks and prepares mitigation plans.

Strategy & Planning, Results Accountability Complete ownership of end to end project.

Analyzing the complexity of the requirements and reframing them to get the better clarity.

Leading the team by assigning the work and accountability of results

Conduct Weekly Status Meetings and Report Weekly Status to Client/Management.

Created more than 250 reports for various sectors i.e., Audits, Outstanding, Dealer Performance, Risk, Review

Modified the Cognos models for adding the data elements using COGNOS Frame Work Manager.

Involve in testing the modified models in different environments.

Played a key role while modifying existing reports to have a better view from the point of end users.

Involve in the process of moving the reports to productions through a specified process.

Schedule the reports to limited audience on a monthly, weekly and daily basis.

Interact with the offshore team and assign the work based on the criticalities.

Client: General Motors, Detroit-MI Oct’08 – Feb’09

Project: GMPS Canada (General Motors PeopleSoft)

Role: Sr. Cognos Developer

Environment : Cognos Impromptu 7.1, Transformer

Description:

General Motors PeopleSoft Canada has come up to have an implementation on Salaried and Hourly Employee Data with a Data Conversion and loading into PeopleSoft Database. It also involves the reporting functionality to know the count of the salaried and hourly employees at each level. A few reports involves with the Survey of the Employee Equities for the salaried and hourly employees.

Responsibilities:

Involved in gathering reporting requirements from end users.

Created a Catalog in order to reach the Reporting Requirements by defining the Business Rules.

Resolved various joins that lead multi facts and cross-joins.

Performed optimization on the existing reports to decrease the run time to meet the real time requirements and made changes to the existing reports for good look and feel for the users.

Created Reports (*.iqd) using the Cognos Impromptu.

Impromptu Query Definitions are used as source for developing the cubes using Transformers

Improvising the Cubes performances by doing Cube Partitioning.

Managed the project very well to ensure the project delivered on Time.

Client: Boeing, Seattle Sep’07 –Sep’08

Project: Integrated Finance System (IFS)

Role: Cognos Developer

Environment: Cognos Framework Manager, Report Studio, Query Studio, Analysis Studio.

Description:

The 787 Integrated Finance Systems (IFS) is a part of Boeing 787 Airplane Program, provides a resource level view of airplane financials during the product development phase. This system gives the 787 Finance Group and Life Cycle Product Team leaders the ability to manage both financial detail and summary/Charge line data and thereby providing the financial reporting functionality. The reporting function comprises of a defined set of standardized reports deployed using the combination of legacy systems data and web-based reporting technologies.

Responsibilities:

Involved in various stages of project like Gathering Requirements, Designing, Developing and Testing.

Involved in status calls for creating the Design document based on the requirements.

Involved in developing the DMR models using the existing models

Used DMR models in the Analysis for creating some Analysis (Reports)

Created various prompts (Cascading Prompts), filters, conditional formatting, and conditional blocks according to the report specifications.

Generated various reports including List, Grouped List, Cross tab, Combinational Chart and Drill -Through Reports.

Tested (Unit, Regression and User Acceptance Testing- on behalf of end user) for most of the reports against its Database-Oracle.

Played a key Role in Developing & Documentation of the Reports.

Modifying the existing reports based upon the change request by the user.

Client: General Motors, INDIA Dec’06 –Sep’07

Project: Fright Audit Process (FAP)

Role: Project Engineer

Environment: Cognos Report Studio

Description:

General Motors is one of the World’s leading Automobile Companies.

The new logistics system FAP manages the outbound vehicle freight services done by logistics service providers. This new system will replace the current systems used in Europe for outbound traffic of vehicles, as Tuefas, FACS vehicles system as well as manual processes that exist at Vauxhall.

Responsibilities:

Developing Design Specification Documents for Reports as per client requirements.

Involved in status calls for updating the requirements in the Design document.

Involved in the discussion with different stakeholders across the world (USA, France, Germany, and U.K) to update the design Document.

Developed a proof of concept with sample Reports to show all stakeholders about the look and feel of the Reports.

Extensively presented them the features of the Cognos through which the reports can be developed.

Project: Distress Management, INDIA May’05–Nov’06

Role: Software Developer

Environment : Java, Oracle and SIP (Session Initiation Protocol)

Description:

SIP is signaling, transaction, application layer protocol. Assumption is that users hold SIP enabled devices and get the services. We created a server which responds on the Emergency grounds for the users by sending their medical information to the nearest hospitals and inform to the nearest police stations.

Responsibilities:

Developing Design Specification, Functional Requirement Document

Designed the database and Detailed Technical design document

Developed (Coded) Front End and at server side

Developed a POC using SIP that handles the distress.

Complete Documentation of Technical solution.

*Reference provided upon request.

Contact this candidate