PROFESSIONAL SUMMARY:

• Working as Senior BI Tableau/Cognos consultant with 10 + years of IT experience analysis, design, testing, development and implementation of client/server applications.
• Experienced in designing and implementing each phase involved in DWH and BI SDLC (Software Development Life Cycle).
• Worked on Tableau Desktop, Tableau Server, and Cognos Suite.
• Experience in Financial, HR, Marketing, Operations and Sales Reporting.
• Experience to Resolve Help desk ticket issues
• Warehousing and Business Intelligence applications using Tableau, COGNOS Suite.
• Worked with different data sources Sql server, Oracle, Excel, MS Access, Hadoop.
• Experience of Cognos 10.2.1 (Framework Manager, Cognos connection, Report Studio, Workspace, Workspace Advanced and Event Studio).
• Experience in creating Tableau Dashboard.
• Hands - on skills with use of actions, filters, advanced navigation techniques, calculations, Level-of-Detail (LOD) expressions.
• Trained on R Language, statistical analysis, good in writing machine language coding.
• Good knowledge on salesforce and wave analytics.
• Expertise in designing, modeling and architecting Data warehousing Concepts in OLTP/OLAP System. Analysis and developing Database Schemas like Star Schema and Snowflake Schema for Relational and Dimensional Modeling.
• Utilized Best Practices and Proven Methodology in data modeling, ETL and other BI development process
• Implemented Security in Cognos using Windows Active Directory.
• Expertise in Framework Manager Modeling (DMR and Relational Models) and Complex Report building with Report Studio
• Expertise in creating Dash board reports and using Java Script in Report studio
• Created Ad-Hoc reports using Query studio and Trained power users to use Query Studio for Ad-Hoc reporting.
• Very good experience in customizing the Cognos connection portal.
• Interacting with the End users on a regular basis for gathering the requirements and resolving issues pertaining to the reports.
• Deploying models and reports from Development to Production and administering users/groups/roles
• Ability to meet deadlines and handle multiple tasks, flexible in work schedules and possess good communication skills.
• Ability to write and maintain technical documentation to describe Reports development, logic, coding, testing, changes, and corrections.

TECHNICAL SKILLS:

Primary Skills: Data warehousing ( OLAP).

Operating Systems: Unix(AIX), Windows Xp

Languages: PL/SQL

ETL Tools: Informatica

Reporting Tools: Tableau Desktop, Tableau Server, Cognos Suite, FM, Report Studio, TransformerDatabases: Oracle 11g;MSSQLServer 2012, Teradata

Configuration Tools: Microsoft Visual SourceSafe.

Domain Knowledge: Communication and Manufacturing, Sales, Pharmaceuticals

PROFESSIONAL EXPERIENCE:

Confidential, Boston

Lead Tableau Consultant

Responsibilities:

• Involved in Gathering business requirements for various customers.
• Defined and guided the definition of technical architecture to meet business requirements in infrastructure and Applications products implementations.
• Providing infrastructure sizing, including hardware and software requirements.
• Developed and Documented technical architecture, system design, performance test results and other technical Aspects of the implementation.
• Prepared fit gap analysis documents, Identified gaps.
• Created Design documents such as Functional, Technical specs, and also package creation documents.
• Excellent knowledge of software development life cycle activities including analysis, design, development, unit testing, regression testing, production deployment and Maintenance
• Developing, Designing and supporting interactive Tableau Dashboard reports.
• Experience with the design and development of Tableau visualization solutions.
• Created Bar Charts, Columns Charts, water fall charts, Heat Maps, And Geographical Maps.
• Experience in Marks, Action, Filters, Parameters, Cards, Publisher and Security..
• Created Derived Columns to fulfill the User Requirements.
• Created Parameters to reports be more User friendly to End Users.
• Connecting multiple data source with Data Blending technique.
• Formatting the Data by using Legends, Marks, Colors, Sizes, and Shapes.
• Providing the Security while Publishing to the Tableau Server.
• Applied various types filters like Data source filters, Quick filters and Context Filters.
• Created table calculations, calculated fields and parameters.
• Created groups, sets, bins and performed conditional sorting and filtering as per the requirements.
• Coordinating with Business Analyst in validating report requirements.
• Validate the data for each report and review the reports.
• Involved in the entire process of developing the new reports and delivering them to the client.
• Unit testing and peer reviews are done after report development.
• Interacted with the clients on a regular basis, for resolving issues pertaining to the reports.

Environment: Tableau Desktop, Tableau Server, Netezza, Cognos 10.2.1 (Framework Manager, Query Studio, Report Studio), Informatica

Confidential, NC

BI Architect

Responsibilities:

• Involved in Gathering business requirements for various customers.
• Defined and guided the definition of technical architecture to meet business requirements in infrastructure and Applications products implementations.
• Providing infrastructure sizing, including hardware and software requirements.
• Developed and Documented technical architecture, system design, performance test results and other technical Aspects of the implementation.
• Prepared fit gap analysis documents, Identified gaps.
• Created Design documents such as Functional, Technical specs, and also package creation documents.
• Excellent knowledge of software development life cycle activities including analysis, design, development, unit testing, regression testing, production deployment and Maintenance
• Developing, Designing and supporting interactive Tableau Dashboard reports.
• Experience with the design and development of Tableau visualization solutions.
• Created Bar Charts, Columns Charts, water fall charts, Heat Maps, And Geographical Maps.
• Experience in Marks, Action, Filters, Parameters, Cards, Publisher and Security..
• Created Derived Columns to fulfill the User Requirements.
• Created Parameters to reports be more User friendly to End Users.
• Connecting multiple data source with Data Blending technique.
• Formatting the Data by using Legends, Marks, Colors, Sizes, and Shapes.
• Providing the Security while Publishing to the Tableau Server.
• Applied various types filters like Data source filters, Quick filters and Context Filters.
• Created table calculations, calculated fields and parameters.
• Created groups, sets, bins and performed conditional sorting and filtering as per the requirements.
• Coordinating with Business Analyst in validating report requirements.
• Validate the data for each report and review the reports.
• Involved in the entire process of developing the new reports and delivering them to the client.
• Unit testing and peer reviews are done after report development.
• Interacted with the clients on a regular basis, for resolving issues pertaining to the reports.

Environment: Tableau Desktop, Tableau Server, Sql Server (SQL, PL/SQL), Cognos 10.2.1 (Framework Manager, Query Studio, Report Studio), Informatica.

Confidential

Associate Technical Architect

Responsibilities:

• Involved in Gathering business requirements for various reports by analyzing focus code.
• Prepared fit gap analysis documents, Identified gaps.
• Created Design documents such as Functional, Technical specs, and also package creation documents.
• End to End experience in designing and deploying date visualization using tableau
• Responsible for Preparing the Report Design specifications based on the User’s requirement.
• Involved in Data modeling.
• Created List, Cross Tab Reports with Quick Filters, Summarized Filters.
• Developing, Designing and supporting interactive Tableau Dashboard reports.
• Experience with the design and development of Tableau visualization solutions.
• Created Bar Charts, Columns Charts, water fall charts, Heat Maps, And Geographical Maps.
• Experience in Marks, Action, Filters, Parameters, Cards, Publisher and Security..
• Created Derived Columns to fulfill the User Requirements.
• Created Parameters to reports be more User friendly to End Users.
• Connecting multiple data source with Data Blending technique.
• Formatting the Data by using Legends, Marks, Colors, Sizes, and Shapes.
• Providing the Security while Publishing to the Tableau Server.
• Applied various types filters like Data source filters, Quick filters and Context Filters.
• Created table calculations, calculated fields and parameters.
• Created groups, sets, bins and performed conditional sorting and filtering as per the requirements.
• Coordinating with Business Analyst in validating report requirements.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Executed and tested required queries and reports before publishing.
• Validate the data for each report and review the reports.
• Involved in the entire process of developing the new reports and delivering them to the client.
• Unit testing and peer reviews are done after report development.

Environment: Tableau Desktop, Tableau Server, Sql Server (SQL, PL/SQL), Flat files, SQL Developer, Informatica 9.x, Focus Code.

Confidential

Sr. Report Developer

Responsibilities:

• Involved in Gathering business requirements for various reports
• Prepared fit gap analysis documents, Identified gaps.
• Created Design documents such as MDD, TDD, and also package creation documents.
• Creation of reports using standard filters, calculations and conditions.
• Creation of reports with Prompts like Textbox prompt, Value prompt, cascading prompts.
• Developed different reports like drill through reports, conditional blocks, conditional formatting.
• Applied layout calculations, and written case statements for various conditions.
• Developing and testing of the different reports, Self review of the reports after completion of development of the report.
• Interacting with the onsite coordinator on a regular basis for resolving issues pertaining to the reports
• Involved in Gathering business requirements for various reports
• Analyzed ERP query and identified total tables and columns.
• Prepared fit gap analysis documents, Identified gaps.
• Prepared corresponding ERP to JAROS ODS tables and columns
• Validated data Erp to Jaros ods corresponding tables in dev, qual, production environment.
• Interacting with the onsite coordinator and also with clients on a regular basis for resolving issues pertaining to the reports
• Involved in Gathering business requirements for various reports
• Prepared fit gap analysis documents, Identified gaps.
• Created Design documents such as MDD, TDD, and also package creation documents.
• Creation of reports using standard filters, calculations and conditions.
• Creation of reports with Prompts like Textbox prompt, Value prompt, cascading prompts.
• Developed different reports like drill through reports, conditional blocks, conditional formatting.
• Applied layout calculations, and written case statements for various conditions.
• Developing and testing of the different reports, Self review of the reports after completion of development of the report.
• Interacting with the onsite coordinator on a regular basis for resolving issues pertaining to the reports

Environment: Cognos 8.4.1 (Framework Manager, Query Studio, Report Studio, Analysis Studio, Metric Studio and Event Studio), Cognos Transformer, oracle10g (SQL, PL/SQL), Flat files, Toad, SQL Developer, Oracle Power Builder.

Confidential, PA

Sr. Cognos Developer

Responsibilities:

• Designing Cognos Framework manager Model for the Data Marts.
• Implementation of Framework Manager Model in Cognos 8.1.
• Implementation of Data Level, Object Level and Package Level Security in Framework Manager Model.
• Creation of Packages and publishing the same.
• Educating business users on how to make use of the Cognos Package/Namespace in Cognos Query Studio.
• Creation of Complex Reports in Report Studio.
• Made use of Value Prompt, Text Box Prompt, Date Prompt, Select and select search Prompts. Almost made use of all its properties and feature.
• Created DMR in Framework Manager Model against relational Data Source.
• Creation of Packages and publishing the same.
• Analyzing the specifications provided by the clients and Developing specification documents for reports as per client requirements.
• Involved in complete Software Development project life cycle.
• Installation & Configuring the Cognos 8.4 on Windows Environment and Configured with LDAP.
• Responsible for creating User groups and roles to manage security in Cognos Connection and Access Rights of the Reports for the end users.
• Created Executive Dashboards, complex reports using Report Studio.
• Developed a prototype to demonstrate the benefits of Performance Indicator Reports that was developed in Metric Studio
• Modifying the existing report based upon the change request by the user.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.
• Worked with Analysis Studio to develop multi dimensional reporting.
• Coded and implemented PL/SQL packages.
• Deploying models and reports from Development to Production and administering users/groups/roles.
• Carried out Testing by developing test scenarios, test cases, test data to be used in testing based on business and user requirements, technical specifications and/or product knowledge.
• Assisted Quality Assurance Team in documenting and analyzing their current process and then make recommendations for improvements in their functional areas
• Created documentation for the complete project life cycle and Mentored the End Users and Provided the Technical Support.

Environment: Cognos 8.4/8.2,Oracle 10g, Informatica 8.1

Confidential, Minneapolis, MN

Sr. Cognos Developer

Responsibilities:

• Developed Framework Manager Models with Physical layer and Presentation Layer
• To cater the various businesses needs (Folders, Filters, and Macros)
• Implemented Third Party Security with LDAP and use those in creating Data Level security,
• Created Drill- through reports and Customized Reports with Prompts (List. Cross tab)
• Prepared User documentation to train users and functionality of each report
• Designed and implemented of Cognos IMB enterprise planning solutions
• Involved in Migrating reports from Impromptu/CRN to Cognos 8.
• Involved in building the Cubes and optimizing the cube creation.
• Importing the model from analyst to contributor, creating saved selections, access tables, e-list, user classes and user rights.
• Provide a prototype of the exact model which we actually build and get a sign off on the functionality.
• Creating a common library for the model which we are actually building.
• Published cubes and created Power play Reports for the web users.
• Played as a good mentor to the newly joining team by giving knowledge transition in both technical and functional areas.
• Worked on and resolved Unix related issues.
• Performed major upgrades of unix utilities tool kits for windows 98,NT
• Responsible for overseeing the Quality procedures and Software configuration management related to the project
• Production Support which involves solving user problems.

Environment: Cognos Reportnet 1.1 MR2 (Framework Manager, Query Studio, Report Studio), Power Play Enterprise Server 7.3, Transformer 7.3, Oracle 8i

Confidential

Cognos Developer

Responsibilities:

• Designed & developed reports from the Data warehouse using Cognos report studio, Query Studio Studio reports.
• Involved in migration of catalogs, reports from Cognos Series 7/CRN to Cognos 8 using Migration Utilities.
• Involved in defining Relationships and Cardinality between query subjects
• Built models containing query subjects, query items, and namespaces from scratch as well as from imported metadata in Frame work manager.
• Created Multi-Dimensional Models (DMR) and published the packages using Framework Manager and then generated reports based on these packages.
• Provides technical expertise in the development and maintenance of basic to moderately complex Accounting reporting applications, data marts, and reports. In some cases the reports will be used in day-to-day production and in other cases the reports will be used audit the accuracy of a large accounting system conversion.
• Responsible for technical maintenance and enhancements of multiple existing Accounting reporting applications, data marts, and reports in adherence with change management protocol.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos
• Involved in the entire project of migrating reports and cubes from Cognos 7 to Cognos 8.2 and creating project documentation for future use
• Developed stored procedures, triggers and complex packages using PL/SQL.
• Managed performance and tuning of SQL queries and fixed the slow running queries in production with utilities like Trace, Stored Outlines.
• Resolved issues resulting from User Acceptance Testing (UAT).
• Provided the Documentation and tutored the End Users how to Use Different types of studios.

Environment: Cognos Suite, Impromptu, Report Net (Cognos Connection, Framework Manger, Metric Studio, Report Studio, Query Studio, Analysis Studio, Powerplay Transformer), Reportnet, Sql Server 2005, PL/SQL, Oracle ERP, Cognos Access Manger.