SUMMARY

• 9+ years of working experience in Tableau Desktop and Tableau Server, Cognos BI tools using Cognos Framework Manager, Report studio, Query studio, Power Play Transformer, Data warehousing and Business Intelligence, XSLT and Java technologies, currently working as a tableau/cognos lead developer.
• I can effectively communicate with Business and Technology Professionals in requirements gathering, analysis, designing, data modeling and review process.
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Involved in Trouble Shooting, Performance tuning of reports and resolving issues withinTableau Server and Reports.
• Extensive experience on building dashboards and Stories using Tableau.
• Created visualization for logistics calculation and department spend analysis
• Created numerous dashboards in Tableau Desktop based on the data collected from Infor Supply Chain Execution by importing and blending data from MS Excel and CSV files along with Oracle SQL Server Databases.
• Developed Geo/Area Maps to show details on which facilities have more inventories using the App vs. the least facilities.
• Created Bar Charts which is complied with data sets and added trend lines and forecasting on future stocks of the SCE App.
• Strong experience in creating and publishing packages using Framework Manager
• Extensively used Framework Manager, Query Studio and Report Studio for model design, ad - hoc reporting and advanced report authoring.
• Worked on EJB reports using xml data sources.
• Strong experience in client interaction and understanding business application, business data flow and data relations from them.
• Worked with Different Databases like Oracle8i/9i/10g, SQL Server 2000, DB2, MS Access.
• Experienced in developing Dashboard Reports in Cognos 8 and 10.
• Interacted with Customers for requirement gathering, effective analysis and also to provide end-user training.
• End-to-End DW/BI cycle exposure with wide range of cross industry experience.
• Hands-on knowledge on ETL and BI/OLAP tools.
• Experience in Relational & Dimensional Data modeling for BI applications.
• Proven ability to understand Enterprise Scenarios and identifying opportunities to propose solutions for value addition and effective use of BI applications.
• Excellent metadata modeling skills using Framework Manager both with Relational and Dimensional approaches.
• Ability to design Dimensional modeling.
• Well-versed in developing reporting applications usingCognos Business Intelligence components like Report Studio, Framework Manager, Transformer and Cognos Connection.
• Developed various types of reports likeList Reports,Grouped Reports,Cross tab Reports,Chart Reports, Drill-Down, Drill-Through Reports, Master detail reports, Conditional Formatting, JavaScript and dashboards.
• Worked with relational model, DMR model in Framework Manager and developed reports for both models.
• Good working knowledge of industry best practices for Enterprise development including implementing and reassuring to design patterns.
• Experience in problem solving, analysis, implementation, installation, and configuration skills.
• Good interpersonal skills, commitment, result oriented, hard working with a quest and zeal to learn new technologies and undertake challenging tasks.
• Excellent team member with strong communication skills and capable of meeting set Deadlines.

TECHNICAL SKILLS

Reporting Tools: Tableau desktop,Tableau Server,Cognos10.x/8.x (Report Studio, Analysis, Studio, Framework Manager, Query Studio, Analysis Studio, Event Studio, Cognos SDK, Cognos Workspace, Cognos Workspace Advanced), Inter form NG and BIRT.

OLAP Tools: Cognos Transformer.

ETL Tools: Cognos Data Manager

Database: MSSQL Server 6.5/7.0/2000, Oracle 8i/9i/10g, MS Access, DB2

Development Tool’s: Eclipse

Programming Languages: Java and xslt.

Operating Systems: Windows 7, UNIX ( Linux)

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Tableau Developer

Responsibilities:

• Developed different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables using tableau desktop.
• Created visualization for logistics calculation and department spend analysis
• Developed Geo/Area Maps to show details on which facilities have more inventories using the App vs. the least facilities.
• Created Bar Charts which is complied with data sets and added trend lines and forecasting on future stocks of the SCE App.
• Worked with Agile methodology for project development.
• Involved in SCRUM meetings and developed and fixed the design changes or issues in tableau Reports.
• Involved in maintaining and developing the metadata model using Framework Manager
• Migrated reports from BIRT to Tableau.
• Developed reports, dashboards using Tableau desktop 9 for quick reviews to be presented to Business and IT users.
• Developed visualizations using sets, Parameters, Calculated Fields, Dynamic sorting, Filtering, Parameter driven analysis.
• Developed POCs by building reports and dashboards using Tableau 9 to demonstrate quick wins
• Prototyped data visualizations using Charts, drill-down, parameterized controls using Tableau to highlight the value of analytics in Executive decision support control.
• Developed visualizations using sets, Parameters, Calculated Fields, Dynamic sorting, Filtering, Parameter driven analysis.

Environment: Tableau Desktop9,Tableau Server9, Oracle 11g, SQL Server 2012, Java and J2ee and eclipse.

Confidential, Boston, MA

Tableau and Cognos BI Developer (Lead)

Responsibilities:

• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Responsible for interaction with business stake holders, gathering requirements and managing the delivery and acted as SME
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Generate KPI for customer management and risk management.
• Created visualization for logistics calculation and department spend analysis
• Developed Geo/Area Maps to show details on which facilities have more inventories using the App vs. the least facilities.
• Created Bar Charts which is complied with data sets and added trend lines and forecasting on future services.
• Involved in updating Cognos 8x reports to Cognos 10.x
• Updated metadata model using frame work manager from older version to newer version.
• Developed and implemented information management solutions as a part of Business Intelligence Organization.
• Manage deliverables and communicate the project level updates with stakeholders of the project.
• Worked with Agile methodology for project development.
• Involved in SCRUM meetings and developed and fixed the design changes or issues in tableau Reports.
• In Sprint review meetings, recognized well-formed Product Backlog Items, user story examples
• Developed Framework Manager Modelsand analyzed those models in analysis studio.
• Publishing the packages from Framework Manager & Importing/exporting the packages.
• Installing and configuring the Cognos server, Framework Manager and Webserver
• Define best practices for creating Tableau dashboards by matching requirements to the charts to be chosen, color patterns as per user's needs, standardizing dashboard's size, look and feel etc
• Developed visualizations using sets, Parameters, Calculated Fields, Dynamic sorting, Filtering, Parameter driven analysis.

Environment: Tableau Desktop 8, tableau server 8,Cognos 10.1, IBM Cognos Configuration, Oracle 10g, SQL, PLSQL,Eclipse IDE

Confidential, Dallas, TX

ETL and Cognos BI Developer

Responsibilities:

• Initial analysis and Data modeling.
• Refinement of ETL process by ensuring proper transformations.
• Modeling metadata using Framework Manager to meet the business requirements.
• Developing reports using Report Studio using DMR/Relational packages.
• R&D to meet client requirements.
• Manage deliverables and communicate the project level updates with stakeholders of the project.
• Lead the team and provide solution directions
• Preparing Transformer Models to generate Cubes for multi-dimensional analysis
• Involved in maintaining and developing the metadata model using Framework Manager.

Environment: Cognos 10(Framework Manager, Query studio, Report Studio, Transformer, Analysis Studio) Windows 7, Oracle Database.

Confidential

Cognos Developer

Responsibilities:

• Gathered and analyzed user requirements. Created variouscatalogsbased on different data sources.
• Created and modified catalogs, catalog prompts, filters, conditions and calculations.
• Modified existingImpromptu Catalogsfor efficiency and better usability.
• Developed different types of Reports usingCognosImpromptu 6.0 and Power Play 6.0.
• DevelopedImpromptu Web Reports (IWR)and published using Upfront.
• Created List, Sub-reports and Cross-Tab reports using Cognos Impromptu.
• Developed complex reports usingmultiple frames and sub reports. Scheduled reports & tasks using scheduler.
• Representing Off-shore team and Single point of contact for technical issues.
• Created Multi-Dimensional cubes usingImpromptu Query Definition (IQD)files in Power Play Transformer.
• Developed business mix reports, Trend over time reports, Ranking & variance reports usingCognos Power Play.
• Implemented drill-through from Power Play cubes to Impromptu report. Provided end user training and support.

Environment: Cognos Impromptu 6.0, Cognos Power play Transformer 7.3, Visualizer, Cognos Upfront, Oracle8i, Windows NT/2000, UNIX and Access.

Confidential

Cognos and Java Developer

Responsibilities:

• Involved in Gathering Requirementsand the reporting issues from the End users.
• Analyzed Businessrequirements from the analysts.
• Interacted with Development and Management Teams.
• Involved in Designing models usingFramework Managerand deployed packages to theReport Net Servers.
• Createddatabase layer and business layer, defining appropriate relationship between query subjects inFramework Manager.
• Modeled metadata fromSQL Server 2005data source for use in Report studio andQuery StudiousingFramework ManagerinReport Net.
• Createdcustom templatesandcustom toolboxesfor the use of reporting.
• Involved in creating QueryPrompts,calculations,Conditions&Filters.
• CustomizedCognos Connectionwith appropriate reports and security measures.
• Involved inQuery Optimization, and Developing Prompt pages and Conditional variables.
• Createdcustom prompted reports in Report Studio,Bursting reports to different user groups.
• As Cognos Impromptu administrator, I was taking care of catalog related issues such as: Creation & Modification of catalog.
• BuiltPower Play Reportsbased on the cubes and published toReport Net Server.
• Moved projects fromdevelopmentto QA and then Production servers.
• Involved in the Testing of the reports and updating the Bug Tracking Tool.
• Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports.
• Transferred technical knowledge specific to Cognos tools and the existing data model to other team members.

Environment: Cognos 8.0 BI Suite, Cognos Framework Manager, Cognos Impromptu 7.3, Cognos Report net 1.1, Cognos Power Play 7.3, Cognos Transformer 7.3,SQL Server 2005, Windows 2003 Server, Java and Jsp’s.