SUMMARY

• An accomplished Senior Business Intelligence Developer with more than 12 years of experience in Data Warehousing and Business Intelligence (DW/BI) projects with proven experience in multiple OBIEE, Tableau and Power BI implementations
• Worked in Greenfield BI projects with complete end to end participation in all phases of Software Development Life Cycle
• Well - rounded IT background with proven ability to manage and succeed in crisis management, navigating complex technical environments
• Expert in OLAP, design, analysis, development, testing, performance tuning, implementation, troubleshooting and error handling
• Proficient in requirement gathering/analyzing and translating business requirements to technical requirements and architecture
• Significant experience in OLAP systems and dimensional modeling, implementing Star and Snowflake schemas
• Used Tableau to design, develop, enhance and support visualizations including, but not limited to, highly interactive dashboards, advanced geographic maps, scorecards and reports
• Subject matter expert of Oracle Business Intelligence Enterprise Edition (OBIEE 12C/11g) with extensive experience in repository (RPD) and report catalog design, development, customizations in working with ETL tools like Informatica PowerCenter for creating data integration solutions.
• Diverse experience gained from working in projects following Waterfall, Scrum and Agile methodologies. Able to develop reusable processes and codes that can be leveraged and standardized for multiple instances

TECHNICAL SKILLS

Technologies: OBIEE, Power BI, Tableau, Informatica PowerCenter, SQL

Operating Systems: Linux, Unix, Windows 2003/NT/XP/10, Shell Scripting

Databases: Oracle 12C/11g/10g/9i, SQL Server 2008 R2EE

Tools: TOAD 13.1, SQL Developer, OBIEE 12C/11g/10g, Tableau Desktop, Tableau Server, Informatica PowerCenter 9.5.1, Power BI, JIRA

PROFESSIONAL EXPERIENCE

Senior Business Intelligence Developer

Confidential, Washington DC

Responsibilities:

• Utilized a full range of Power BI features to design, develop, enhance and support visualizations including, but not limited to, highly interactive dashboards, scorecards and reports
• Developed Power BI reports and visualizations using DAX functions like table function, aggregation function and iteration functions
• Created reports using transformations available in Power BI query editor
• Scheduled automatic refresh in Power BI service
• Created reports using time intelligence calculations and functions
• Created paginated report using Power BI Report Builder
• Analyzed requirements definition and scope documentation, recommended appropriate solutions based on business requirements
• Designed reporting and analytic solutions to meet business requirements
• Created pre-defined and ad-hoc reports, troubleshot BI report issues and tuned BI reports for better performance
• Designed and optimized the physical, logical and presentation layers within the OBIEE repository in multiuser development environment
• Analyzed issues and provided recommendations for OBIEE Repository and Middle Tier configurations
• Prepared detailed documentation for all objects developed and prepared transition documents
• Designed and developed metadata layer (RPD) and created reports using different visualizations like charts, pivot tables, heat maps, gauges etc. using OBIEE and published them

Environment: Power BI, OBIEE, Power BI Report Builder, Oracle 12C, JIRA

Senior BI Developer

Confidential, Fairfax VA

Responsibilities:

• Participated in and supported the full project life cycle (initiation, planning, requirement analysis, design, development, Quality Assurance, User Acceptance Testing, deployment and production support)
• Demonstrated excellent business and communication skills by working with business owners to understand their data and reporting requirements
• Managed, analyzed and resolved data initiative issues and managed revisions needed to best meet the business requirements while adhering to the best practices of business intelligence (OBIEE) to design the analytical solutions
• Provided training, resolved issues and gave direction to the end users on how to use OBIEE dashboards and shared knowledge with the less experienced staff regarding OLAP concepts, new techniques and methodologies
• Designed the dimensional data model and implemented it in OBIEE RPD and produced rich visualization, graphical display of data through OBIEE 12C reports and Tableau dashboards
• Utilized a full range of Tableau features to design, develop, enhance and support visualizations including, but not limited to, highly interactive dashboards, scorecards and reports
• Drove reporting optimization through continued improvement in performance and visualization
• Drove operational and process efficiencies through automation to minimize manual reporting
• Managed security model of the BI analytics reports by implementing both object level and data level security
• Collaborated with subject matter experts and data stewards to define and implement data strategy to ensure the enterprise data is accurate, complete, secure and reliable
• Created mappings/sessions/tasks/workflows to integrate and load target tables in Oracle from 92 different data servers (SQL Server) through Informatica PowerCenter
• Created source target mapping documents and functional data specification and technical design document
• Identified areas for data quality improvement and helped to resolve data issues through appropriate choice of error detection and correction
• Supported quality assurance and user acceptance testing of production defects and performed analysis to determine the root cause of those defects and provided resolution
• Migrated code across Development, Test and Production servers
• Facilitated the backup and recovery of the data and OBIEE repository and catalog

Environment: OBIEE 12C, Tableau, Informatica PowerCenter, Oracle 12C, SQL Server

Tableau Developer

Confidential, Vienna, VA

Responsibilities:

• Provided insightful ideas for developing effective and accurate codes - evaluated latest technologies and made recommendations to client to integrate new designs
• Collaborated with end users and other related departments to ensure that the application was meeting the client’s expectations and business requirements
• Created metrics, attributes, filters, reports, dashboards, advanced chart types, visualizations and complex calculations to manipulate the data
• Acted as a Point of Contact in data, analytics, business intelligence and production support issue resolution
• Implemented advanced geographic mapping techniques and used custom images and geo coding to build spatial visualizations of non-geographic data
• Created different action filters, parameters and calculated fields to meet complicated requirements
• Worked with Tableau administrator in managing Production, Test and Development environments
• Performed Tableau Server admin duties; added users/groups from Active Directory; and scheduled instances in Tableau Server including weekly data dump
• Created schedules and extracted the data into Tableau Data Engine
• Built and published customized interactive reports and dashboards, report scheduling on Tableau server
• Managed the Tableau solution architecture, administration, performance and usability
• Developed Tableau data visualization using Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails, and Density Chart
• Created dashboard designing with effective data visualization of large data volumes from various data sources (SQL Server, Oracle, spreadsheets)
• Prepared Dashboards using calculations, parameters in Tableau and created calculated fields, groups, sets and hierarchies etc.
• Provided customer support to Tableau users and Wrote Custom SQL to support business requirements
• Used Tableau calculations and applied complex, compound calculations to large, complex data sets

Environment: Tableau Desktop, Tableau Server, Oracle