PROFESSIONAL SUMMARY:

• IT Professional with 8+ years’ experience in application, designing, development and implementation of Oracle Business Intelligence, BI Publisher, Tableau 7.x/8.x (Desktop, Server, Reader), creating various Reports and Dashboards using different functionalities in projects.
• Provided technical and analytical expertise in responding to complex, specialized report requests requiring higher - level data analysis and data management services.
• Conducted Gap Analysis, created Use Cases, work flows, screen shots and Power Point presentations for the Web Applications.
• Skilled in Tableau Desktop for data visualization, Reporting and Analysis; Cross tab, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart.
• Proficient in creating Calculations (Table Calculations, Hide Columns, Creating/Using Parameter, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Mar Card Changes, Rich Text Formatting, Shared Encoding) using Tableau Desktop.
• Expert in tableau server commands like synchronization, Tabcmd and Tableau server backup activity.
• Designing the report layout templates in the BI Publisher.
• Currently working on OBIEE Repository, which includes Physical Layer, Business Model layer and Presentation Layer using OBIEE.
• Designing repository based on business requirements, followed design best practices for the RPD and Dashboard designs.
• Extensive experience in dimensional modeling schemas like star schema and snow flake schema.
• Strong experience in designing and implementing complex reporting solutions using COGNOS Suite.
• Developed a Framework Manager model by importing Meta data, preparing business logic, setting up object level security and developing and publishing package.
• Review package; manage discussion topics and communications with worldwide finance leads.
• Organize and manage project work to drive predictable delivery.
• Participate in planning, management, development and implementation of concurrent enterprise wide solutions in a highly demanding and constantly changing business environment.
• Currently learning Tableau BI tool as a process of conversion from BI Publisher reports to Tableau reports in future releases.
• Support business managers and executives by providing the tools to make successful business decisions by translating corporate global financial and statistical data into useful information through analytical reporting and budgeting.
• Sustaining a high safety performance reputation, maintaining quality standards, and minimizing corporate costs and liability have been a consistent result of my professional commitment.
• I am an analytical, insightful, and highly-disciplined problem solver with a demonstrated ability to identify and secure project resources, and provide the quality leadership that invokes committed professional participation on the contractor and subcontractor levels.
• Maintaining meticulous attention to detail, inspiring team, and delivering quality, on-time project execution are areas in which I excel.
• Working on the accountability for the design, implementation, and execution of several projects.
• Enhancement & Development project and outline future upgrades and implementation to improve and streamline Business works.
• High energy, creative, multi-tasking, and get-the-job done attitude. Well-developed analytical, planning and organizational skills, with proven ability to manage multiple assignments/projects efficiently under tight delivery deadlines and changing objectives.
• Motivated and focused team player. Systematic and organized with exceptional interpersonal skills, comprehensive problem solving abilities, quick adaptability, troubleshooting and the analytical bent of mind. Strong persuasion and communication skills (verbal and written).

SKILL:

OLAP: Tableau 8.1/8.0, Tableau Server, Oracle BI Publisher (11.1.1.9.x), OBIEE (11.1.1.7), OBIEE Answers, OBIEE Dashboards, Cognos 10.2 BI Suite Report Studio, Frame work manager, Query StudioETL Tools Informatica Power Centre 9.x, Oracle Warehouse Builder

Methodologies: Data Modeling, Star Schema, Fact and Dimension Table

RDBMS: Oracle 11i/10g/9i/8i/7.x (SQL, PL/SQL, Stored Procedures, Triggers), SQL SERVER, MS Access 2000/2007, SQL TOAD

Programming: C, C++, SQL, PL/SQL, HTML 4, and XML, XSL.

Packages: MS Office (Word, Excel, Access, PowerPoint).

PROJECTS PROFILE:

Confidential, Columbia, MD

OBIEE/BI Publisher/Cognos/Tableau Developer

Responsibilities:

• Deep understanding of Information Technology Software Development Life Cycle (SDLC) methodology and project management principles.
• Involved in Requirements Gathering, Data Modeling and creation of detailed design Documents.
• Migrated the Tested Code from Dev to UAT and then to Production of Repository, Dashboard, Reports.
• Involved building the data models for reports that are being integrated to BI publisher.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Effectively used data blending feature in tableau.
• Defined best practices for Tableau report development.
• Proficient with BI Publisher reports and using various templates (rtf, excel, pdf, xsl, acrobat formats) to publish the reports as per user requirements.
• Experience in interacting with Business users to analyze the business process and requirements and documenting and rolling out the deliverable.
• Implemented performance monitoring and user auditing of BI publisher reports.
• Expertise in developing OBIEE repository from the scratch, build reports/dashboards from the repository using OBIEE Answers and troubleshoot various technical issues and bugs.
• Supported on Demand and Scheduled Reports to simplify and consolidate the infrastructure.
• Skilled at users to use Query Studio and Analysis Studio, Cognos Workspace.
• Conversion of Cognos , power builder reports to BI Publisher reports for HQR reports are under process currently.
• Performed unit testing and system testing of all components for reports in BI Publisher.
• Used PRIS(Portal Reporting Integration Service) to link up with BI Reports to display on the Quality Net Portal.
• Created users account setup for PRIS login and Report program setup in Quality Net Portal.
• Excellent problem solving skills with strong technical background having the ability to meet deadlines, work under pressure and quickly master new technologies and skills.
• Excellent interpersonal and communication skills for efficient client interaction.

Environment: Tableau 8.1/8.0, Tableau Server, OBIEE 11.1.1.6, BI Publisher 11.1.1.9, Cognos10.2, Informatica 9.0, TOAD, SQL, PL/SQL, SQL*Plus.

Confidential, Columbia, MD

OBIEE/BI Developer

Responsibilities:

• Deep understanding of Information Technology Software Development Life Cycle (SDLC) methodology and project management principles.
• Involved building the data models for reports that are being integrated to Bi publisher.
• Proficient with BI Publisher reports and using various templates (rtf, excel, pdf, xsl, acrobat formats) to publish the reports as per user requirements.
• Experience in interacting with Business users to analyze the business process and requirements and documenting and rolling out the deliverable.
• Expertise in developing OBIEE repository from the scratch, build reports/dashboards from the repository using OBIEE Answers and troubleshoot various technical issues and bugs.
• Executed OBIEE administrative tasks such as OBIEE server installation, migration and user maintenance.
• Integrated JFREE charts to create box and whisker plots. Also accomplished the Map Viewer progress in a multi alignment report.
• Supported On Demand and Scheduled Reports to simplify and consolidate the infrastructure.
• Performed multi language support reports using BI Publisher.
• Knowledge of Data warehouse Application Console (DAC) Architecture
• Excellent problem solving skills with strong technical background having the ability to meet deadlines, work under pressure and quickly master new technologies and skills.
• Excellent interpersonal and communication skills for efficient client interaction.

Environment: OBIEE 11.1.1.6, BI Publisher 11.1.1.5, Informatica 8.1, Cognos 10.1/10.0, TOAD, PL/SQL, SQL*Plus, Windows server 2003.

Confidential, VA

Cognos Developer

Responsibilities:

• Interacted with business analyst to gather business requirements and designed functional and technical requirements documentation.
• Worked extensively on creating the Model and publishing the package on Cognos Connection for Reporting purposes.
• Published different packages from Framework Manager to Cognos Connection
• Implemented all business logic in Framework Manager by creating prompts, folders, calculated columns, joins and naming convention
• Worked on creating and analyzing the complex reports like Cross tab, drill-thru reports.
• Created multiple page reports with page-break based on the first page of report using master-detail relationship.
• Created list reports, cross-tab reports and chart reports using underlying multiple query structure by using filters, calculations, complex expressions, and conditional formatting.
• Created Dashboard reports by translating data into visually rich presentations using different types of charts, and other graphical elements to show multiple results together.
• Applied different functionalities like filters, prompts for Cognos reports to retrieve relevant data
• Enhanced the performance of the reports by changing the properties of the Query such as Auto Group & Summarize, Processing, Execution Method and Use Parameter Info.
• Used Layout component in page header, page footer and prompt page for uniformity across the reports.
• Constructed Conditional Drill through, Drill through and Master-detail reports using parameterized filters in Report Studio
• Worked on Dashboards, scorecards, Reports, Active reports and Cognos Port lets.
• Developed Reports using Queries and set operations logics
• Created Prompts like value, Date, time and cascading prompts
• Developed various standard reports like list reports, cross tab reports.
• Written String, Boolean variable conditions as per the requirements in the reports.
• Involved in unit testing, smoke testing and performance testing of the reports
• Written SQL queries in database to test cognos reports before moving to QA testing.
• Worked on PLSQL Procedures and Views.
• Prepared migration template and raised work order for move the code to different environments.
• Involved in production support.

Environment: Cognos 8.4/10.0/10.1.1 Framework Manager, Report Studio, Query Studio, Analysis Studio, Metric Studio, Windows XP/7, Toad for Oracle, Oracle 10g/11g,SQL Server2008/2012