PROFESSIONAL SUMMARY

• Over 10+ years of experience in Information technology as BI developer tools including Tableau, Cognos, Informatica.
• Having Experience in Tableau Visualization Tool, Cognos BI, Informatica Power Center, SQL, PL - SQL, Hadoop Hive.
• Hands on Experience in Design, develop, and support interactive visual dashboards and reports using Bars, Lines and Pies, Maps, Scatter plots, gnats, Bubbles, Histograms, Bullets, Heat maps and highlight tables.
• Good understanding on the Tableau Administration.
• Good Understanding and experience ETL Informatica Power Center to load the data in the DWH.
• Good Experience in Debugging, monitoring, troubleshooting issues, during the test phases.
• Hands on Experience in Performance Tuning of the database Queries, Reports and writing the complex queries as per the business requirement.
• Worked in Developing Metadata Models in Tableau and Cognos FM.
• Good Understanding and experience on the Teradata Database concepts and worked on developing views, Materialized views and Procedures.
• Having good understanding of Tableau architecture, Tableau Desktop, Tableau Server various reporting objects like Facts, Attributes, hierarchies, transformations, filters, calculated fields, sets, groups, parameters in Tableau.
• Excellent understanding Data Warehouse concepts like Star schema, Snowflake schema, Transaction Facts, Fact less Facts, Role playing Dimensions.
• 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 and Implementation.
• Worked in Implementation of security in Tableau and Cognos
• TEMPEffectively created reports with Exception Highlights, drilldown, drill through reports, cascading prompts, Chart reports, Crosstab reports, List reports and calculations.
• Knowledge and worked in using Cognos Connection in Public Folders, My Folders, and to email and schedule reports.
• Involved actively in Full life cycle which includes Technical Design, Development, and Testing & Implementation of various projects.
• Experienced in preparing the various documents like Requirement document, high level and low level design documents Business Mapping documents, Change request documents and Implementation documents.
• Good experience in creation of ETL mappings and transformations using Informatica Power Center to move data from multiple sources into target area.
• Troubleshooting production issues and gave post production support for couple of projects.
• Performed Team Lead activities in managing a team of 5.
• Clear understanding of the business procedures and ability to work as an individual and as a part of the team.

TECHNICAL SKILLS

Operating Systems: Unix, Windows

Database: ORACLE10g, TERADATA client 13

RDBMS: Teradata SQL assistant, ORACLE AQT

BI Tools: IBM Cognos 11 Analytics, IBM Cognos10, 8 (Cognos Report studio, Framework Manager, Query Studio, Cognos Workspace Advance, Business Insights)

Visualization Tool: Tableau Desktop, Tableau Server

ETL Tool: Informatica (PowerCenter Designer, Workflow Manager, Workflow Monitor, Repository)

.NET Technologies: VC++, Visual Studio .NET

Languages: PL/SQL,SQL,T-SQL

PROFESSIONAL EXPERIENCE

Confidential, Morgan Stanley, NYC, NY

BI Lead

Roles & Responsibilities:

• Worked with Business Users to understand user requirements.
• Developed the Dashboards using the Data source SAP HANA on GL Accounts.
• Developed the Data model to develop the reports.
• Worked on the MTD, QTD, YTD calculations.
• Developed Dashboards for the General Ledger Reporting.
• Developed POC to migrate the PPT dashboards dat were developed using Morgan Stanley internal tool to Tableau and Atomization of scheduling these reports.
• Worked with cross functional teams for the DWH implementation.
• Worked on the Teradata database environment for implementing the views.
• Worked on the Table Calculations to implement the KPI need for the Dashboard Reporting.
• Implemented Action filters, user filters and LOD expressions in developing the reports.
• Worked on the Tableau Extracts, Tableau live data sets and managing privileges to the users.
• Involved in Tableau Java scripts in building the web applications.

Confidential

BI Lead

Roles & Responsibilities:

• Worked with Business Analysts and users to understand user requirements, layout and look and feel of the application to be developed.
• Worked on agile methodology in implementing the project.
• Developed Framework model to develop the reports.
• Worked on analyzing the conversion of the complex dashboard dat was developed with OLTP system to OLAP system.
• Migrating Tableau Dashboard from the OLTP system to OLAP system.
• Created Tableau Model using the Tableau Desktop.
• Developed the Tableau Dashboard and Story and published the dashboards to the Tableau Server.
• Interacted with the Business Users and halped in Querying the data as per the requirement.
• Written the Complex Queries at the database level as a view to avoid multiple joins at the Tableau Level.
• Involved in the Data modeling to solve issue for Dimension to Dimension joins.
• Implemented Partitions and Indexes for the performance Tuning.
• Handled self service requests in developing reports.
• Implemented the Package level, Object level security on the FM package.
• Developed the Dashboards with Cognos Report studio.
• Developed the complex reports with the given business Queries.
• Implemented the complex queries at the view level to meet the business requirement.
• worked on performance improvement of the Model and reports.
• Tested the data integrity of the model with respect to the Business.
• Migrated the reports from the Cognos 10.1 to cognos 11 environment and tested them.
• Developed the reports using the Cognos Analytics.
• Developed dashboard using Cognos Analytics and Tableau to the Hadoop Hive

Confidential

Technology Lead

Roles & Responsibilities:

• Worked with Business Analysts and users to understand user requirements, layout and look and feel of the application to be developed.
• Worked on Agile methodology in implementing the project.
• Data blending implemented on the TFS databases and generated interactive dashboard.
• Developed Data model for the imported data in the organized way to created user friendly reports.
• Generated dashboards with quick filters, parameters and sets to handle views more efficiently
• Published workbooks by creating user filters so dat appropriate teams can view it.
• Generated context filters and used performance actions while handling huge volume of data.
• Created custom SQL queries to get the data from database to generate the dashboard reports.
• Developed POC on TFS database.
• Created Dashboards by extracting data from different data sources using data blending.
• Involved in creating interactive dashboards and applied actions.
• Developed complex calculated fields for the business logic, field actions, sets and parameters to include various filtering capabilities for the dashboard.
• Created different types of visualizations like Bar charts, Pie charts, box plots, Dual axis bar charts, drill through reports and drill down reports in the Dashboard.
• Given Training for the End users.
• Involved in administration activities like installing the tableau server, giving permissions to the user, managing data connections, schedules for background tasks and incremental refresh for the weekly and monthly dashboards reports on the tableau server.
• Worked on T-SQL to load the huge in a sequential order.

Technology Lead

Confidential, Denver, CO

Roles & Responsibilities:

• Understand Requirement, Analyzing Systems and Source Databases.
• Designed and developed Dashboard using Tableau and published to the server.
• Developed Teradata data structures based on the reporting requirements.
• Created Dynamic filters and Parameters to implement the user required prompts.
• Created story to display dashboards in different tabs and published to the server.
• Implemented Data blending to join the tables from different data sources.
• Created calculated fields and implemented calculations to display the required data in the report.
• Dynamically displaying images the report.
• Formatted the report to make the report feel good.
• Implemented the project in Agile methodology.

Technology Analyst

Confidential, Illinoise, Chicago

Roles & Responsibilities:

• Gatheird Functional Requirements from end users.
• Involved in the complete Life cycle of the project from Dev to Prod.
• Involved in the requirements gathering for Ad-hoc Model/Metadata Model and Reports.
• Designed and developed Ad-hoc model for reporting in Cognos Framework Manager.
• Modified the existing reports based upon the change request by the user.
• Analyzed and created customized Cognos BI reports linking databases, to meet the user requirements.
• Created metrics using fields available in the package for Ad-hoc reporting.
• Developed dashboards, Reports and implemented Role level security on the reports.
• Developed Standard Reports, Charts, Drill through Reports, Master Detail Reports, Dashboard using Report Studio and Query Studio.
• Implemented package level, column level, and Role level security/data level security with groups.
• Implemented built in prompts in the package.
• Created views and stored procedures for implementing the data level security.
• Implemented user defined functions on the package.
• Developed reports with concept of cascading and Value Prompts as per Business Requirements.
• Created & published the packages using Framework manager.
• Worked on BIA (Business Insight Advanced) to create Adhoc Reports.
• Involved in the Cognos Admin task like giving the access on the Cognos Applications, adding users to the security groups.
• Moving Reports and package from Development to QA.
• Given training on Cognos Workspace Advance for end users.
• Performed unit testing and writes appropriate unit test plans to ensure requirements are satisfied.
• Involved in ETL design process to handle data related to security implementation.
• Created and Configured Workflows, Sessions to transport the data to target using Informatica Workflow Manager.
• Involved in writing UNIX shell scripts in KSH to Transfer the files between multiple systems and to load data from files to database.

Confidential, KY

Technology Analyst

Roles & Responsibilities:

• Communicated with the business users to comprehend the requirements.
• Involved in the entire life cycle of the project from the user requirement gathering to deployment stage.
• Involved in unit testing the migrated reports in different environments.
• Ensure all the functions of the report to work in sync with their intended functionality.
• Updated HTML java scripts in the prompt page for enabling dynamic functionality.
• Involved in gathering reporting requirements from end users for the new reports.
• Imported new tables from DB and created new Query Subjects in the relational layer according to the unique business need and published package.
• Created multiple Dashboard reports for multiple packages.
• Created list/crosstab/graph reports as per the business requirements dis would generate data pertaining to the Franchise Code or Customer type or Interruption Cause Type.
• Implemented Conditional Blocks, conditional formatting, page breaks to display data in the report as per the user requirements in the Report Studio
• Created Prompts, Calculations, Conditions & Filters, Prompt Pages, Variables in Report Studio in Cognos.
• Created reports with Exception Highlights, drill down, drill through reports, cascading prompts.
• Developed Prompt Pages, Cascaded input Prompts to display only the selected entries in the report and also worked on the customization of prompt parameters.
• Involved in extensive use of conditional formatting while developing reports in Report Studio.
• Written HTML/Java Script in Cognos report studio reports as per the requirements.
• Served ad-hoc change requests pertaining to existing Cognos Reports.
• Performed unit testing and writes appropriate unit test plans to ensure requirements are satisfied.
• Deployment of packages/reports across environments.

Confidential

BI Developer

Roles & Responsibilities:

• Involved in gathering reporting requirements from end users.
• Create Frame work model, package & publishing the packages using Frame work manager.
• Created Drill- through reports, Master detail reports.
• Developed Dash Board Reports on Cognos 8 report Studio.
• Extensively used Conditional Blocks to hide/display the report contents (list, crosstab, charts) based on user selection in the prompt.
• Extensively used conditional format features of Report Studio to generate efficient and user-friendly reports.
• Moving Reports from Development to QA.
• Performed unit testing and writes appropriate unit test plans to ensure requirements are satisfied.
• Interacting with the users and providing solution to ad hoc requests to query the database and provide the dataset.
• Modifying the existing reports based upon the change request by the user.

Confidential

BI Developer

Roles & Responsibilities:

• Understanding Specification Documents for Reports as per client requirements.
• Converted reports from Pega to Cognos.
• Used Query Explorer to create the reports without Framework model and package.
• Created List, Crosstab, Repeater reports using Report Studio.
• Created report views with saved prompts and schedule according to the business requirement.
• Created Prompts, Calculations, Conditions & Filters, Prompt Pages, Variables in Report Studio in Cognos.
• Created reports with Exception Highlights, drill down, drill through reports, cascading prompts.
• Implemented Conditional Blocks, conditional formatting, page breaks to display data in the report as per the user requirements in the Report Studio
• End to End execution provided with UAT Test Plans on all the user reports

Confidential

BI Developer

Roles & Responsibilities:

• Analyzing the existing system
• Interacting with Business Analyst and gathering business requirements.
• Involved in creating Projects, Namespaces, Models and Packages using Cognos Framework Manager and deployed packages on Cognos Connection.
• Worked with the QA team in documenting & capturing test cases.
• Created List, Crosstab, Chart, Repeater reports using Report Studio & Ad-hoc reports using Query Studio.
• Created new reports using Cognos and upgraded and replaced existing EXCEL reports.
• Trained power users to use Query Studio for Ad-Hoc reporting.
• Involved in review sessions and demos with business users and draft design/solution

Confidential

JTAG on EPOS

Roles and Responsibilities:

• Created Flow diagrams for the project.
• Analyzed and documented PCB functionality.
• Created win forms using VC++.
• Used dlls to Connect between PC and JTAG on E-pos PCB
• Analyzed the architecture of the ARM Processor and memory devices.
• Tested the software and compared the results with manual results.