PROFESSIONAL SUMMARY:

• Over 10 years of extensive experience in all Software Development Life Cycle phases of business Intelligence solutions using Oracle Business Intelligence, BI Publisher, Jasper Reports and Tableau.
• Expertise in various domains especially Healthcare, Telecom and Finance.
• Administered Tableau and OBIEE environments.
• Strong experience in different database systems such as Oracle 11g/10g/9i/8i and SQL Server.
• Good hands - on working knowledge with utilizing a wide range of Oracle SQL Constraints (Primary Keys, Foreign Keys, Defaults, Checks, and Unique), and Dynamic-inquiries.
• Experience in writing complex stored procedures, functions, Indexed views and triggers for data consistency and manipulation using TOAD, Query Manager, PL/SQL developer and SQL developer for system testing of reports.
• In-depth knowledge of data warehouse design, maintenance, data loading, Real time and OLAP reporting concepts.
• Expert in translating business requirements into technical solutions and keen about quality, usability, security and scalability .
• Worked on SQL Performance Tuning and Query Optimization.
• Experienced in developing Jasper Reports/iReports using Jasper soft studio and ireport designer.
• Experience in designing the data conversion strategy, development of data mappings and the design of Extraction, Transformation and Load (ETL) routines for migrating data from non-relational or source relational to target relational.
• Good knowledge of Data Marts, OLAP, Dimensional Data Modelling, Star Schema Modelling, Snow-Flake Modelling for FACT and Dimensions Tables.
• Team player and self-starter with good communication skills and ability to work independently and as part of a team.
• Extensive experience in 508 standards testing of reports.

TECHNICAL SKILLS:

Business Intelligence Tools: OBIEE 11g, OBIEE 10.x, Siebel Analytics 7.x, Dashboards, Answers, BI Publisher, Jasper Reports/IReport, Tableau Desktop 8.2, SSRS.

ETL Tools: Informatica Power Center 8.x, 7.x, 6.x, SSIS.

Methodologies: Data Modeling Logical/Physical, Star Schema Modeling, Snow Flake, Schema modeling, Fact Tables and Dimension Tables

Databases: Oracle 11g/10g/9i/8i, SQL Server 2014/2008R2, PostgreSQL 9.0/9.1 and Teradata

Database Tools: SQL Developer, TOAD, SSMS (SQL Server Management Studio)

Languages/ Technologies: Java 1.6/1.5/1.4, SQL, PL/SQL, and T-SQL

Web Technologies: XML 1.0, HTML, DHTML, CSS, JavaScript, JQuery, JSP and ColdFusion.

Operating Systems: UNIX, Linux, Windows XP/2000/Vista

Software Applications: MS Word, MS Excel, and MS Power point

Big Data: MapReduce, HDFS, Hive, Sqoop, Pig.

IDE Tools: Eclipse, MyEclipse, and NetBeans.

PROFESSIONAL EXPERIENCE:

Confidential, Bethesda, MD

Sr. BI Developer

Environment: PostgreSQL 9.6.4, SQL Developer, Jasper Reports Server, Jasper Soft reports 6.3.1, Tableau 8.2, XML, pgadmin, Microsoft Office, Windows XP.

Responsibilities:

• Participated in business requirement discussion to come up with the standard mock reporting template having structured section defining its own behaviors.
• Design, develop and build report layout using IReport Designer and Jaspersoft Studio.
• Worked in collaboration with application developer to examine the appropriate data-source for rendering the data in the report.
• Developed complex adhoc & dynamic reports, sub report, crosstabs, charts etc. and embedded complex queries in JRXML template.
• Involved in managing report repository and deploying on the jasper report server.
• Writing complex SQL Queries using Joins Unions Nested Tables and Analytic Functions.
• Developed various data connections (like Restful web services, json, xml and postgresql) for report and dashboard development.
• Developed and deployed bar charts, pie chart, highlight actions and meter charts using Jasper soft studio and published them to jasper server.
• Perform data analysis to determine best BI solution (reports, dashboards, etc) using Tableau
• Developed various Dashboards using objects such as Chart Box (Drill Down, Drill up & Cyclic Grouping), List, crosstab etc. using Tableau.
• Created complex formulas and calculations within Tableau to meet the needs of complex business logic
• Created Technical Documentation (Report Specification Document and User manuals) for reports and maintenance/enhancements of existing Reports
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Combined Tableau visualizations into Interactive Dashboards using filter actions, highlight actions etc., and published them to the web.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Effectively used data blending feature in tableau.
• Defined best practices for Tableau report development.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Developed various data connections (like Restful web services, and postgresql) for report and dashboard development.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Scheduled reports debugged issues and provided solutions for Tableau.

Confidential, Columbia, MD

Sr. BI Developer

Environment: OBIEE 11.x, OBBI Publisher, Tableau 8.2, Erwin, Oracle 11g, TOAD, Microsoft Office, Windows XP, XML, Unix Shell Script, HTML, DHTML, CSS, JQuery, and MyEclipse.

Responsibilities:

• Well experienced on Oracle concepts like DDL, DML, Relationship Keys, Normalization, Data Types, Variables, Constraints, Joins, Sub Queries, Views, Indexes, UDFs, Stored Procedures, Triggers, Transactions, and Cursors etc.
• Collaborating with QA team to test the SQL scripts before they moved to QA, V&V & Production servers.
• Written complex stored procedures to meet the client business requirements.
• Rewrote and tuned long-running SQL queries to cut execution time, ease database load and improve scalability.
• Designed and populated reporting tables, views and stored procedures.
• The main goal of this project is to test for the quality of the application, and was a part of DECC.
• I have been working on a quality improvement organization team in development
• Create, enhance and optimize simple to complex reports.
• Strived for efficient code rather time consuming
• Perform data analysis on claims information.
• Used various analytic functions to do moving or rolling aggregations.
• Used complex joins instead of subqueries.
• Extensive experience in Oracle and use of CASE, CAST, SUBSTRING, TRIM, PL/SQL etc.
• Design and development of queries to process large data sets.
• Layer using connection pool, developing multiple Dimensions, Logical & Facts Measures objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer.
• Develop reports, Dashboards with different Views (Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using OBIEE Presentation server.
• Create Adhoc reports using Tableau to perform data validation.
• Analyzing physical queries executed against data base in case of data issues.
• Perform Unit testing and System Testing.
• Analyze and resolve issues during production support and provide root cause analysis document
• Document program development, logic, coding, testing, changes and corrections.
• Analyzed and developed reports using Tableau server as a prototype
• Designed the conceptual and business process models.
• Worked on integration of the new system with existing systems.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Developed Tableau workbooks from multiple data sources using Data Blending.

Confidential, Atlanta GA

BI Developer

Environment: Oracle Business Intelligence (OBIEE 10.1.3.4), OBIEE Answers 10.1.3.4, Oracle BI Presentation Server, Oracle BI SchedulerInformatica Power Center 8.1.1, Oracle 10g, TOAD, SQLToolsOracle10.g, Windows XP Professional.

Responsibilities:

• Worked closely with Business user in Understanding the OBIEE reporting needs from target user groups.
• Expertise in Developing the Subject Area with Physical Layer Objects (Database, Connection Pool, Catalog, Schema, Table), Business Layer Objects (Logical Table, Dimensions, Joins, Facts, Initialization Blocks, Repository Dynamic Variables), Presentation Layer Objects (Table, Columns)
• Created various logical columns based on existing logical/physical tables as sources
• Identified Facts, Dimensions, Levels / Hierarchies of Dimensional Modeling
• Strong experience in building Analytics dimensions and Level based hierarchies
• Developed many Reports / Dashboards with different Analytics (Pivot Table, Chart, Column Selector, and Tabular with Filters), Guided Navigation and Dynamic / Interactive Dashboards with drill-down capabilities with Dimensional Hierarchies.
• Developed BI dashboards including Subscriber daily activates, Subscriber daily deactivates, Monthly Revenue Report, Total usage reports, Territory Report and Sales Performance reports for summary level and detail level as per the user requirements etc.,
• Used Analytics Web Catalog to set up groups, access privileges and query privileges.
• Implemented security by creating roles & web groups, checks with External tables and LDAP, and Object Level Security.
• Experienced in Performing end to end testing, creating Test Plans including Data Validation, Unit Testing and User Acceptance
• Worked with Business Users and created Adhoc Reports
• Effectively communicated and coordinated with Business Requirements and testing team
• Excellent problem-solving skills with strong technical background and good inter-personal skills, Quick learner and excellent team player
• Deployment of defect free code while managing the timeline set for the project.

Confidential, Westbury, NY

BI Developer

Environment: OBIEE 10.1.3.4, Informatica 8.1.1, BI Publisher, Windows XP.

Confidential, Dallas, TX

BI Developer.

Environment: Informatica Power Centre 8 (ETL), Oracle Data WarehouseOracle Business Intelligence Enterprise Edition (OBIEE 10.1.3.4.1), OBIA, Windows, & Toad