Srivishnu

469-***-****

ac4yov@r.postjobfree.com

Summary Skills:

Over 10 years of IT experience with emphasis on Analysis, Design, Development, Validation and Reporting under different environments.

Worked on Cognos and Tableau requests simultaneously based on business need.

Expertise in Framework Manager Modeling and Report Authoring using Cognos.

Created, modeled and published packages in Framework Manager from multiple databases for use with Report Studio, Query Studio and Analysis Studios.

Expertise in creating dimensions, measures and building cubes using Transformer.

Expertise in developing standard Reports and Templates, Dashboards, Master Detail Reports using Report Studio.

Expertise in creating different kinds of visualizations using Tableau Desktop and variety of worksheets to build dashboards.

Expertise in using advance Tableau features like Dual axis, Calculated fields, Sets, Groups, Parameters, context filters, quick filter, Actions etc.

Strong knowledge on Data Warehousing concepts – Star schema, Snow-flake Schema and worked on both OLAP and OLTP.

Thorough understanding of System Development Life Cycle (SDLC) experience from requirement analysis through Design & Development.

Interacted with Business Analysts and core business group to design/develop/maintain database reporting and perform data analysis.

Involved in training end users and providing technical support and documentation.

Hands on experience in Cognos multi server installation and Cognos Administration.

Good experience on migration process.

Excellent communication, interpersonal skills with strong analytical and problem solving skills. Ability to learn quickly and take up new tasks and responsibilities

Technical skills

Languages

C, C++, Java, SQL

Databases

Oracle, SQL Server, Teradata, MS Access, Redshift

BI Tools

Cognos (11, 10, 8), Tableau, Transformer, TM1, Business Objects

Ms office

Microsoft Word, Excel, PowerPoint, Visio

Operating systems

Windows (10,8,7, XP)

Education:

Bachelor of Engineering, Electronics & Communications, Anna University – Chennai, India

Certifications:

IBM Certified Cognos Report Author.

Professional Experience:

Data Analyst BI, CapitalOne, Plano-TX Jun 2017 – Till Date

Developed dashboards for data analysis as per requirement.

Designed and executed various number of weekly and monthly business monitoring reports.

Worked on Cognos and Tableau requests simultaneously based on business need.

Handled ad hoc reporting requests to analyze and support new opportunities, strategies or product specific questions.

Implemented best practices like LCR and Custom classes for reusability and consistency.

Designed reports using Cognos functionalities like Drill through, Master/Detail.

Developed campaign waterfall reports per the business requirements to facilitate highly accurate decisions.

Performed testing of reports by writing SQl queries.

Worked on different types of Ad-hoc campaigns.

Built and Drove Email Campaign execution and analysis, create test cases and adjust strategies accordingly.

Implemented end to end cycle of Marketing campaigns, response tracking, analytics, reporting and revising strategies.

Marketing campaign deployment - Scheduling, audience segmentation, analyzing campaign KPI's within Salesforce Marketing Cloud (ExactTarget).

Assess the Post analysis Campaign performance.

Designed dashboards in Tableau Desktop by querying Teradata database.

Provided technical assistance by responding to inquiries from client regarding issues and questions about reports.

Environment: Cognos, Tableau, Cognos Connection, Teradata, Redshift, Visio.

Senior Consultant, Deloitte, India Nov 2015 – May 2017

Lead for offshore BI team.

Experienced in creating POC’s and presenting them to clients and higher management.

Gathered the requirements from clients and provided analysis for designing framework manager model and reports.

Understanding the requirements and provided gap analysis documents to the client for building efficient framework model and reports.

Designed framework manager models for ad-hoc analysis and reporting, also resolved loops utilizing shortcuts and Alias shortcuts in Cognos framework manager.

Resolved double counting of multi granular data between tables using determinants in Cognos framework.

Developed reports for customers/users at various levels for analysis of data and driving decisions.

Analyzed existing report capabilities and provided recommendations to the clients.

Analyzed existing source systems and designed data model for building data warehouse/data mart.

Evaluated Current Report Capabilities with other tools and provided recommendations of the analysis.

Performed testing of reports with an independent SQl.

Implemented security to the reports based on user requirements.

Created Prompts, Conditions and Filters to improve the report generation.

Environment: Cognos (Framework Manager, Report Studio, Transformer), Cognos Connection, Motio CI, Teradata, Tableau, Redshift, Visio.

Truven Health (Formerly Thomson Reuters Health Care) Dec 2012 – Nov 2015

Senior Specialist, India

Product owner for DWH initiative.

Involved in Full life cycle design and development of Cognos reporting Applications.

Interacted with Business Analysts and end users to develop ad-hoc reports and dashboards according to functional specifications. Also carried out analysis, documentation of detailed requirements.

Implemented multi-tier installation of servers in Cognos environment.

Developed dashboards for data analysis as per client’s requirement.

Designed reports that open in mobile for online and offline analysis of data by the users.

Designed and executed various number of business monitoring reports on monthly and quarterly basis.

Developed Complex dashboards that involved multiple objects, Master/Detail charts, cross tab, bar charts, pie charts, complex variables and calculation contexts.

Created reports using Cognos functionalities like Drill through, Drill up/down, Cross Tab, Master/Detail, Formulas and variables etc.

Migrated reports from Cognos 8.4 to Cognos 10.1, 10.2 and provided impact analysis to the business users.

Deployed packages, folders and content store from a development environment to test and then to production environments.

Designed user guide/customer handling documents and given training sessions to business users on how to use/run the reports in Cognos.

Provided continuity and accuracy in reporting by validating and testing data, identifying missing data, inconsistencies between data sources as well as validating accuracy and consistency with stated business rules.

Effectively handled modifications and enhancements to the dashboards as per the requirement changes from business.

Environment: Cognos (Framework Manager, Report Studio), Cognos Connection, Cognos Administration, Motio CI, Oracle.

L&T Infotech, India May 2011 – Dec 2012

Senior Software Engineer

Gathered Business requirements from the end users, business analysts and project managers.

Communicated with users to understand their requirements to create and modify framework manager and reports.

Successfully upgraded/migrated reports that are to be generated for 7500+ active users from cognos 7.4(Impromptu) to 8.4.

Developed framework manager according to the technical specifications and made sure they were free of loops and traps.

Tested the reports for data accuracy and made sure they met the look and feel requirements of the end Users.

Maintained admin activities like export, import packages across the different environments such as development, testing and production.

Used Cognos administration to schedule and distribute the reports automatically as per the business needs.

Responsible for creating test cases to make sure the data originating from source is making into target properly in the right format.

Environment: Cognos 8.4 (Framework Manager, Report Studio, Transformer), Cognos Connection, DB2.

Software Engineer, Infoapps India Nov 2007 – Apr 2011

Involved in Understanding the requirements of Business analysts and Corporate Managers.

Developed framework manager according to the technical specifications and made sure they were free of loops and traps.

Maintained team’s project lists and work with Users to determine priorities, and reports progress on projects(status reports) to the Users.

Involved in the development of the modules like Internal Message, Student Leave, Log Audit and Change Password in Java

Involved in developing UI screens using JSP and HTML.

Involved in developing DAOs using ORM Tools (Hibernate).

Involved in coding for controllers using Springs Framework between presentation layer to business layer.

Involved in Unit Testing of the user interfaces and provided testing results with the client.

Participated in Code reviews with the clients and made sure that the coding is as per standards.

Environment: Cognos 8.4 (Framework Manager, Report Studio), Cognos Connection, SQL Server, Java, Spring, Hibernate.

Contact this candidate