SUMMARY

• 14 years of work experience in large - scale Business Intelligence & data-warehousing projects.
• Worked in all phases of software development life-cycle (SDLC) including requirement gathering, analysis, design, development, testing, production implementation and support.
• Extensive hands on experience in BI reporting tools like OBIEE, BI Publisher, BRIO/Hyperion Interactive Reporting (IR) and Tableau.
• Strong knowledge of data modeling, design, development. Worked on Oracle SQL, PL/SQL, Teradata databases. Extensive data analysis experience using SQL and MS Excel.
• Worked in multiple Agile (Scrum) projects.
• Strong interpersonal skills and communication abilities.
• Worked in finance, treasury and HR projects in various organizations.

TECHNICAL SKILLS

BI Tools & Technology: OBIEE 10.x/11.x/12c, Tableau 8.x/10.x, BI Publisher 10.x/11.x, Informatica Power Center 8.x/9.x, TOAD, SQL Developer, BRIO, Hyperion Interactive Reporting 9.x/11.x, HP Quality Center, Rally, VersionOne, MS Visio, Rational ClearCase, SVN, VSS, JIRA.

Database: Oracle 10g/11g, PL/SQL, Teradata V2R5, SQL Server

Scripting Language: JavaScript

PROFESSIONAL EXPERIENCE

Confidential, Austin, TX

Sr. BI Consultant

Responsibilities:

• Work with finance line of business to design and create forecast dashboard.
• Create dashboard in OBIEE and Tableau.
• Work with database team to design aggregate & snapshot tables needed for RPD setup.
• Design and develop complex OBIEE dashboard using pivot table and dynamically calculating certain metrics with change of prompt value and passing variables.
• Use column selector for dynamically adding columns to the pivot.
• Set up row level security by product.

Tools: Used: OBIEE 11.1.1.7, Tableau 10.4, Oracle 11g

Confidential, Charlotte, NC

Sr. BI Consultant

Responsibilities:

• Closely work with Line of Business to understand BRD and create detailed technical design documents for reporting needs.
• Design and develop several simple to complex OBIEE Analysis reports/dashboard for enterprise level project initiatives like Regulatory Data Repository (RDR), eONE, First Data Resources (FDR).
• Work with database team to understand table structure and load cycles to setup OBIEE RPD.
• Develop reports with multiple drill-down capability from normalized instrument level data to detail level transaction data using action links and master-detail linking.
• Create GL reconciliation/data quality dashboard for data visualization using charts and pivots.
• Create highly formatted BI Publisher reports to generate Income & Expense report PDF-s.
• Work on ongoing irisWeb (in-house java-based reporting tool) to OBIEE report migration. The migration involves understanding the existing report SQLs and design them in OBIEE.
• Set up row level, column level and folder level security by system of records.
• Automated event-based agents to send report output to users on daily/month-end basis.
• Closely work with database team on performance tuning of long running report queries by gathering statistics, creating indexes, modifying joins recommended for better performance.
• Worked on OBIEE 11g to 12c upgrade project.
• Created Tableau reports prototype with visualization for senior management.
• Work on fast paced agile setup and attend scrum calls.
• Actively communicate with QA testers during functional testing (IFT) cycles, analyze the bug reported and provide root cause of report defects logged in HP Quality Center.
• Support production issues and provide help-desk with detailed analysis of reported data issues
• Conducted multiple training sessions for business users, help-desk staffs and power users to demonstrate tool navigation and features.

Tools: Used: OBIEE 11.1.1.7, OBIEE 12.2.1.3.0, Tableau 10.2, Oracle 11g, HP Quality Center, TOAD, Rally.

Confidential, Washington, DC

Sr. BI Consultant

Responsibilities:

• Worked as developer to support payroll, time & labor analytical reporting for HR department.
• Understood PeopleSoft back-end table data to effectively model tables in OBIEE RPD.
• Worked closely with payroll business lead to define the domain mappings needed to load the data from PeopleSoft database to data warehouse tables.
• Developed medium to complex custom OBIEE reports and dashboard.
• Identified missing elements in the Oracle delivered RPD and provided a gap analysis to users.
• Supported business during multiple cycles of UAT and promptly addressed their queries.

Tools: Used: OBIEE 11.1.1.7, Oracle 11g, TOAD

Confidential, Cambridge, MA

Sr. BI Consultant

Responsibilities:

• Lead developer in an agile (scrum) project to convert Grants Management (GMAS) team’s exiting financial reports from Hyperion IR to OBIEE.
• Worked closely with data architect to understand existing table structures, Informatica mappings, PL/SQL scripts, load processes and put together design elements needed to migrate reports to the new OBIEE platform.
• Actively participated in designing star data model for RPD to meet the reporting requests and identified the need of new table/view.
• Developed complex reports with parent-child hierarchy requirement. Created new hierarchy table needed to set up parent-child hierarchy.
• Worked with higher management to capture requirements around usage of newly migrated OBIEE reports and transformed the idea into a visually rich Usage Tracking dashboard.
• Used Writeback feature to create OBIEE access management dashboard.
• Worked with admins to setup Act As functionality for debugging user access and prod issues.
• Participated in performance tuning of reports along with DBAs and infrastructure teams.
• Attended project sponsored training in Tableau 9.
• Created mock-up reports using Tableau, created comparison matrix between OBIEE and Tableau for HR group to help them choose their next reporting solution.

Tools: Used: OBIEE 11.1.1.7, Oracle 11g, Tableau 8.0, TOAD, SVN, JIRA.

Confidential, Herndon, VA

Sr. BI Consultant

Responsibilities:

• Created interactive map-based Analysis reports.
• Developed complex reports using views like Pivot Table, Graph, Chart and Narratives.
• Configured Map Viewer, built and configured maps, created themes and layers using Map Builder. Worked on Oracle spatial data for geocoding.
• Used master-detail to set up navigation between graphical presentations and data.

Tools: Used: OBIEE 11.1.1.7, Oracle Map Builder 11.1.1.7, Oracle 11g, MS Excel

Confidential, McLean, VA

BI Technology Lead

Responsibilities:

• Technology lead of a team of four developers in on-site offshore model to support financial reporting needs for Treasury/Capital Market department.
• Extensively involved in designing OBIEE model to meet reporting needs for middle/back office and understanding data flow from Confidential vendor tables to target reporting tables.
• Worked on migrating several Hyperion IR reports created on top of Summit, Quantum, Reval vendor tables to OBIEE. Developed and supported OBIEE RPD data modeling and designed reporting solutions using OBIEE Analysis, BI Publisher.
• Built BI Publisher statements for generating trading transaction PDFs for external customers.
• Developed custom external triggering solution to send PDF-s generated by BI Publisher via emails to address a technical gap with the built-in scheduler and BI Publisher bursting option.
• Worked on migrating 100+ Treasury reports during OBIEE upgrade from version 10g to 11g.
• Participated in yearly disaster recovery exercise.

Tools: Used: Oracle 11g, PL/SQL, OBIEE 10.1.3.4/11.1.1.6, BI Publisher 10.1.3.4/11.1.1.6, Hyperion Interactive Reporting 11.x, ClearCase, HP Quality Center, VersionOne, Informatica 8.6.1

Confidential

Software Developer

Responsibilities:

• Worked as an ETL developer in HR department projects. Developed Teradata SQL, BTEQ scripts, and Informatica mappings to ETL transactional and historical data into data mart tables.
• Loaded and maintained large summary tables and views using Teradata macros
• Hands on experience on loading data into Hyperion Essbase cubes and creating data-forms, web-forms, writing business rules in a Hyperion Planning application.
• Created workflow using Flat File adapter, planning adapter, and variable adapter in HAL to do the dimension building in Hyperion Planning Applications.
• Worked on Hyperion Interactive Reports/BRIO, Siebel Analytics dashboards, charts, pivots, reporting queries, and data model. Created report UI navigation functionalities using JavaScript.

Tools: Used: Informatica Power Center 8.1.1, Teradata V2R5, Hyperion IR 9.3, BRIO, JavaScript