BI Developer with 15+ Years in Data Analytics and Visualization

Madhavi Email: ********@*****.*** Mobile: 540-***-****

Objective

Accomplished and passionate IT Professional with 15+ years of IT experience in all phases of Software Development Life Cycle such as Analysis, Programming, Testing, Implementation, Maintenance, Database Administration and Configuration Management. Includes 5 yrs in QlikSense, PowerBI and 3 yrs of experience ETL/BI Testing and 3yrs of experience of Informatica 7.x/6.x and 4 yrs of experience in Siebel Analytics 7.8.x, Oracle BIEE 10.1.3.x/10.1.4.x/11g & BI Publisher, Tableau 7.x, Business Intelligence Developer with expertise in transforming complex data into actionable insights through scalable dashboards, optimized data models, and automated reporting solutions. Proficient in SQL, data warehousing, ETL processes, and BI tools to support data-driven decision-making. Known for strong analytical thinking, performance tuning, and close collaboration with stakeholders to deliver accurate, meaningful, and impactful business intelligence solutions.; seeks assignments as Business Intelligence Developer, BI Analyst, Power BI Developer, BI Consultant, Data Visualization Specialist or similar assignments with organizations of high repute, preferably in Atlanta, New York, Boston, Alabama, South Carolina//North Carolina, Tennessee, or Remote.

Profile Summary

●Enterprising & Result-driven IT Professional with excellent relationship management skills and who has effectively contributed to achieving organizational goals, enhancing organizational processes through initiatives geared towards lowering risk, heightening productivity & improving internal controls, with analytical bent of mind and proven track record of stamping success in uncertainties & challenges across Business Intelligence (BI), Data Analytics / Data Analysis, Reporting & MIS (Management Information Systems), Data Visualization & Dashboard Development, SQL / Database Management, ETL / Data Integration. Analytics Engineering, Decision Support / Business Insights, Performance & Metrics Analysis.

●5+ Years in Qlik Sense/QlikView/PowerBI. Experience in Analyzing data in depth slicing and dicing through data brings out hidden valuable information using powerful BI tools including DAX, Power Query and data modeling. Designing Dashboards, Qlik Admin activities and Designing Nprinting Reports and distribution.

●4+ Years in Siebel Analytics/OBIEE. Experience on Siebel Analytics and OBIEE in designing Dashboards, Answers/Analysis, and Analytics Administration Tool and OLTP Tier Client-Server Environment and Business Intelligent Solutions using Data Warehouse and OLAP Techniques.

●Experience in Oracle BI Apps that include OBIEE/Siebel Analytics, ETL Tools and DAC in Financial Analytics, Procure and Spend Analytics, Project Analytics and Supply Chain Analytics, EAM analytics.

●Completed the Data Science with Python certification from simplilearn.

●Good knowledge and experience in Agile and Kimball methodologies to implement the BI/DW projects.

●Knowledge in optimizing Power BI solutions for performance, report rendering, query optimization, and data refresh strategies.

●Good knowledge in HCM, Oracle EBS, Maximo data source/table structure

●Experience in Informatica (Data warehousing ETL experience using Informatica Power Center 9.x/6.2/7.1, Source Analyzer, Mapping Designer, Mapplet Designer, Transformation Designer, Warehouse Designer, Repository Manager and Server Manager).

●Experience in Data Marts, Essbase Cubes, Triggers, Functions, Indexes OBIA modules like SCM, P2P and Financials.

●Data modeling experience using Dimensional Data modeling, Star Schema/Snow flake schema, Fact and Dimension tables, Physical and logical data modeling.

●Hands on experience in BI Publisher, Siebel Analytics, Oracle BIEE in designing Dashboards, Answers, Delivers and Analytics Administration Tool.

●Proficient in Installing and configuring OBIEE, Siebel Analytics and Informatica

●Experience in setting up IBots/ Alerts in OBIEE and Siebel Analytics.

●Expertise in designing and development of Repository (Siebel analytics and OBIEE).

●Created Siebel/OBIEE Intelligence Dashboards, configuration of guided navigation, iBots, Briefing Books, validation of reports and drilldowns.

●Customized privileges setting for the various groups and set privileges for the same

●Expertise in design and development of Data warehousing systems in client server environment and web-enabled environment.

●Good knowledge in creating ESSBASE cubes

●Excellent skills in troubleshooting and root cause analysis.

●Knowledge on Data Modeling, PL/SQL, SQL, Linux.

●Expertise in working with Oracle Stored Programs, Packages, Cursors, Triggers, Dynamic SQL and SQL*Loader in a distributed environment.

●Excellent Communication, Sales & Marketing skills and a team player.

●Documenting and analyzing software business requirements.

●Self-starter with strong work ethics, good time management skills, establish and maintain productive working relationships with management, Clients and team members.

●Clear written, Analytical and oral perception of ideas and concepts. Ability to articulate alternative solutions or workarounds. Ability to listen to superiors and absorb new technological advances.

●Excellent Analytical, Communication, and Team Working skills

●People’s Manager who leads by example; nurtures team members, fuels employee productivity & performance through impactful training, mentoring, and leveraging a motivational leadership style.

Areas Of Expertise

Functional

Business Requirements Analysis and Process mapping

BI/OLAP

Qlik Sense, Nprinting, PowerBI, OBIEE 11g, BI Apps 7.9.6.3/7.9.6.4, Siebel Analytics 7.8.4/7.8.2/7.7,OBIEE 11g/10.1.3.x/10.1.4.X, BI Publisher

DW/ETL Tools

Informatica PowerCenter 9.x, ODI, SSIS Packages, Power Exchange 5.1,DAC 10g

Data Modeling

Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, FACT, Dimensions), Entities, Attributes, Cardinality, ER Diagrams, ERwin 4.x/3.x, OLAP.

Database:

Oracle 11g/10g/8i/ 9i, MS SQL Server 7.0/2000, DB2 and MS Access

Languages

JAVA, J2EE, SQL*Plus, PL/SQL

Web Technologies

HTML, JavaScript, XML, HTML, Java script

Notable Accomplishments Across the Career

●Successfully designed and developed interactive dashboards and reports that improved business visibility and supported data-driven decision-making across multiple teams.

●Successfully completed Report Migration from OBIA to Qliksense then Qlik Sense to PowerBI.

●Optimized SQL queries and data models, significantly reducing report refresh time and improving overall system performance.

●Automated recurring reports and data pipelines, reducing manual effort and increasing reporting accuracy and consistency by using Nprinting /Paginated Reports

●Collaborated closely with stakeholders to gather requirements, translate business needs into BI solutions, and deliver actionable insights.

●Built and maintained data warehouse schemas, ensuring data integrity, scalability, and ease of analysis.

●Implemented data validation and quality checks to improve reliability and trust in reporting outputs.

●Enabled self-service BI by creating user-friendly dashboards and documentation, increasing adoption among non-technical users.

●Identified trends, patterns, and anomalies in large datasets to support strategic and operational initiatives.

●Supported leadership with ad-hoc analysis and executive-level reporting for timely decision-making.

●Consistently met deadlines in fast-paced environments while maintaining high standards of accuracy and data governance.

Work Experience (Total 15+ Years)

S&V Tek Systems, Atlanta, GA

Sr. Power BI Developer Sep 2024 to Feb 2026.

Flowers Foods is the second-largest producer and marketer of packaged bakery foods in the US.

Responsibilities:

●Designed and developed interactive Power BI dashboards using Power BI Desktop and Power BI Service, enabling executives to track KPIs, trends, and operational metrics.

Built data models using star and snowflake schemas, optimizing DAX measures for performance and accuracy.

●Partnered with business users to gather requirements, define KPIs, and create user-centric visualizations.

Automated recurring reports and dashboards, reducing manual reporting efforts by 40%.

Conducted data validation and reconciliation to ensure data accuracy and consistency across reports.

●Worked with data sourced from ERP, MES, and Quality Management systems within food manufacturing environments; transformed and modeled data for enterprise BI reporting using Power BI.

Environment: Power BI, DAX, Power Query, SQL, Oracle,ERP,Fabrics.

Interface Inc, Atlanta, GA

Global BI Developer April 2014 to July 2024.

Interface is a global manufacturer of commercial flooring with an integrated collection of carpet tiles and resilient flooring, including luxury vinyl tile and nora brand rubber flooring.

Responsibilities:

●Involved in designing and developing Power BI reports and dashboards that provided insightful and actionable business intelligence in supporting all areas of the business including Sales, Finance, PDM, Marketing etc.

●Involved in gathering requirements & translated business requirements into specifications that used to implement the required reporting tools, reports, or dashboards using PowerBI, Qlik, OBIA/OBIEE, ReportsNow.

●Involved in Creating user-friendly Power BI reports and dashboards with advanced visualizations and implement DAX expressions to perform complex calculations and data transformations in Power BI.

●Design, develop, and maintain Involved in configuring Qlik Sense applications using QMC and implemented security rules to manage applications access.

●Worked on Nprinting reports development and task creation, set up the users in nprinting and created groups for reports distribution.

●Involved in DEV to QA and QA to Prod QVD and QVF migrations.

●Involved in License Management activities.

●Involved in troubleshooting the nprinting issues or reporting distribution issues to recipients.

●Worked with end users on data exploration and training to access different applications.

●Involved in OBIEE to Qlik Sense Migration.

●Involved working on Qlik Sense to PowerBI migration.

●Involved in all activities of OBIA Administration.

Environment: PowerBI, Qlik Sense, Nprinting, OBIEE 11g, Db2, Oracle, Sales Force, JDE.

Pinellas County, Clearwater, FL

OBIEE Consultant Jan 2014 to April 2014.

Pinellas County is a county located in the U.S. state of Florida and County implemented OBIEE 11g

Implemented for Financials/HR/Procurement and Spend. Pinellas County has different sectors like

Schools, Court, Airport, Beaches, Online services, Business, Government, Residents, Visit, Departments.

Responsibilities:

●Involved in upgrading the RPD and web cat from 11.1.6.6 to 11.1.1.7 version of OBIEE.

●Involved in developing/modifying the Financial Reports for county.

●Involved in requirement gathering for HR module of OBIEE.

●Involved in Developing the report and dashboards for HR Module.

●Involved in Security implementation.

●Involved in all activities of OBIEE Administration.

Environment: OBIEE 11g/ODI, Hyperion, EBS, DAC, Maximo

TVA/Rolta Americas, Chattanooga

BI Apps Implementation (Financials/PNS/EAM) July 2013 – Jan 2014.

OBIA Consultant

The Tennessee Valley Authority is the nation's largest public power provider and a corporation of the U.S. government. TVA implemented the BI apps for Financials, PNS and EAM modules as part of Phase I.

Responsibilities:

●Experience in analysis and gathering of requirements of the various work streams by meeting with the business user and base lining the details that define business and functional specifications.

●Analyzed and tested RPD (Physical, BMM and Presentation Layer), configured metadata objects and web catalog objects as per the client and reporting requirements using OBIEE Admin Tool and Web tool.

●Involved in developing the custom reports in Financial, Procurement & Spend and EAM modules.

●Worked extensively on data validation for all modules with users.

●Used repository variables to dynamically modify conversion values for logical column formulas.

●Involved in code migrations from Dev to Test Environment

●Implemented security by creating roles & web groups, checks with external tables and LDAP, and Object Level Security.

●Implemented data level security depending on roles.

●Setup the visibility of dashboards to employees with respect to their responsibilities. Administered permissions and privileges for dashboard visibility and modifications to users based on their groups or responsibilities.

●Involved in investigate Data relationships by writing SQL statements on DW and Source Database.

●Developed new dashboards on the business needs, implemented dynamic column naming and dynamic logo which is driven through DB tables. Displaying a logo depends on user credentials.

●Created application roles for the Weblogic EM for the respective AD groups and used application roles for object level security.

●Worked as an Administrator in Weblogic EM and monitored various applications and services.

●Involved in resolving the HPQC Defects raised by users for PNS, EAM and Financials.

CMG, Atlanta

BI Apps Implementation (Financials) Sep 2012 – July 2013

OBIA/OBIEE Consultant

Cox Media Group is an integrated broadcasting, publishing, direct marketing and digital media company That includes the national advertising rep firms of Cox Reps and operations include 15 broadcast television Stations and one local cable channel, 85 radio stations, eight daily newspapers and more than a dozen non-daily publications, more than 100 digital services. Additionally cox media group own and operate Valpak, one of the leading direct marketing companies in North America. CMG was using the Great Plains for the Financials and moved from GP to OBIA 7.9.6.3

Responsibilities:

●Experience in analysis and gathering of requirements of the various work streams by meeting with the business user and base lining the details that define business and functional specifications.

●Developed and tested RPD (Physical, BMM and Presentation Layer), configured metadata objects and web catalog objects as per the client and reporting requirements using OBIEE Admin Tool and Web tool.

●Created hierarchies, variables in the repository.

●In detail analyzation of the requirements to provide the best possible solution on reports/dashboards using wide range of different analytic views (drill-down/dynamic, cascading style sheets, pivot table, chart, column selector, tabular with global and local filters and prompts) that are part of OBIEE Answers/Dashboard.

●Implemented Charting, Conditional Formatting, Filter, Sort, Hide, Formulas and Functions, Rich text formatting, multiple table and forms layout and Bar Coding for various reports in BI Publisher.

●Used repository variables to dynamically modify conversion values for logical column formulas.

●Implemented security by creating roles & web groups, checks with external tables and LDAP, and Object Level Security.

●Implemented data level security depending on roles.

●Setup the visibility of dashboards to employees with respect to their responsibilities. Administered permissions and privileges for dashboard visibility and modifications to users based on their groups or responsibilities.

●Involved in investigate Data relationships by writing SQL statements on DW and Source Database.

●Customized the look and feel (Skins & Styles) for OBIEE products (Answers Login Page, Banners, CSS files, etc.) as per company specific standards.

●Developed new dashboards on the business needs, implemented dynamic column naming and dynamic logo which is driven through DB tables. Displaying logo depends on user credentials.

●Designed and developed BI-Publisher Reports Layouts using BI-Publisher Desktop using sample xml data source & Answers request as data source and deployed on to the BIP Server.

●Configured security using Active Directory (AD) by setting AD in Weblogic Administration Console.

●Created application roles for the Weblogic EM for the respective AD groups and used application roles for object level security.

●Worked as an Administrator in Weblogic EM and monitored various applications and services.

●Prepared Migration document for all the environments and did production support

●Created Analysis, Dashboards and Agents in OBIEE 11G Version 11.1.1.5.0

●Implemented Cache seeding and Cache purging in production environment for daily refresh and configured AD Cache in Weblogic Admin Console.

●Worked on modules like Procure to Pay, Audience Share, Profitability, Pacings, Cox Reps Employee Expenses, Media Monitor Metrics, Revenue, Cash Flow, Vendor Spend Analysis reports

●Worked on Customized Dashboard & reports for Revenue, Cash flow, Vendor spend Analysis and Incentive comp

●Worked with Hyperion smart view/ In2 Hyp Essbase add-ins to retrieve the data from different cubes to validate against the reports data

Environment: OBIEE 11g, BI Apps 7.9.6.3, JAVA, DAC 10g, Informatica 9.0.1, BI Publisher, Essbase Hyperion 11.1.2.2, SQL Server, Hyperion EPM, Peoplesoft Financials, Oracle 11g,

Covidien, St. Louis, MO June 2012 – Aug 2012

BI Apps Implementation (Financials / SCM)

Sr. OBIA/OBIEE Consultant

Covidien/Mallinckrodt is a $12 billion global healthcare products leader dedicated to innovation and long-term growth. Covidien is passionate about making doctors, nurses, pharmacists and other medical professionals as effective as they can be. Our industry-leading brands – including Kendall, Mallinckrodt, Nellcor, Puritan-Bennett and Valley lab – are known and respected worldwide for uncompromising quality. Our success is made possible through the dedication of our 41,000 employees, nearly two-thirds of whom work in 53 manufacturing facilities located in 16 countries

Responsibilities:

●Involved in installation and configuration of BI apps 7.9.6.3 for JDE Enterprise one 9.1 – Financial Analytics, Procure and Spend Analytics, Project Analytics and Supply Chain Analytics, EAM analytics for out of box reports.

●Involved in installation and configuration of Informatica 9.x and DAC 10g for out of box reports.

●Involved in investigate Data relationships by writing SQL statements on DW and Source Database

●Effectively interacted with the end users for requirement gathering and defined requirement specifications document by access and retrieval of financial and personnel data from one single source.

●Involved in SQL Performance Tuning for BI Apps Reports.

●Involved in OBIEE upgrade from 10g to 11g and Informatica 8.x to 9.x

●Created Catalog Groups and set permissions for items in the presentation catalog and privileges and rights to users and groups.

●Designed and Tested reports in the Dashboards for the Oracle Financial Analytics modules like GL, AP, AR, HR etc and SCM modules like Inventory balance, back log etc, created the Ad-hoc reports according to the client needs.

●Involved in Reports Analysis and had given demos to high level management.

●Involved in training the users.

●Involved in creating documentation for END-to-END implementation and customizations document.

Environment: OBIEE 11g, BI Apps 7.9.6.3, JAVA, DAC 10g, Informatica 9.0.1, Peoplesoft FSCM, JDE Enterprise one 9.1, DB2, Oracle EBS, Maximo, SQL Server 2008.

Quintiles Pharmaceuticals, Morrisville, North Carolina May 2011 –June 2012

Project: Investigator Performance DataMart (IPD)

OBIEE Consultant

Quintiles Transnational Corp. is the world's largest pharmaceutical services company. Much of its business comes from its work as a contract research organization (CRO) which serves the pharmaceutical, biotechnology and healthcare industries. Quintiles also provide a full range of policy consulting and disease-and-health information management services to the international healthcare industry. The services offered by the company include centralized clinical trial laboratory management, data management and biostatistics, regulatory toxicology, pharmaceutical sales and marketing, health economics and healthcare policy consulting, and the development and packaging of clinical trial materials

Quintiles is implementing the Oracle Business Intelligence Enterprise Edition 10.1.3.4.1 (OBIEE) reporting environment with the intent to phase out reporting from Cognos.

Responsibilities:

●Involved in the whole life cycle of the project which includes requirement gathering, design, development, testing and release and production support.

●Created mockups for the reports using Adobe Dreamweaver CS5 for the Business to review.

●Integrated OBIEE dashboards with Siebel CRM and created links for the users to access the reports.

●Designed and Built Oracle BIEE Repository at 3 layers i.e., Physical Layer (connecting Data sources & import schema), Business Model / data mapping (create Logical tables & data source mapping) and Presentation Layer level (create presentation catalogs), create presentation folders, test and validate the model.

●Created the Mockups Using dream weaver which is an initial layout and shared it to the business in order to show the how the report looks like.

●Created connection pools, physical tables, defined joins in the physical layer of the repository.

●Worked on Answers to build Interactive Dashboards with drill-down capabilities.

●Developed different kinds of Reports (pivots, charts, tabular views) using global and local Filters.

●Created Business Facts & Dimensions and defined Logical relation between them in BMM layer.

●Involved in investigate Data relationships by writing SQL statements on DW and Source Database

●Extensively used Presentation variables and Guided navigation.

●Customized Dashboards, Administered permissions and privileges for Dashboard visibility and modifications to users.

●Extensively worked in Dashboard Prompts, Page Prompts, Narratives, presentation variables and Server Variables in the RPD and Dashboards.

●Developed and debugged many intelligence Dashboards using different Analytics Views (Pivot Table, Pie/Bar Chart, and View/Column Selector, Narrative View).

●Utilized variables and initialization blocks in the repository.

●Created Virtual Dimensions (Aliases) on the original tables, and used them to join to other fact tables.

●Used the expression builder in the BMM layer and created various calculation measures.

●Peer review of code, testing, monitoring NQSQuery and tuning reports.

●Documented the changes required in the Repository as part of the performance tuning and for the defects in the reports.

●Created opaque views in the physical layer of the rpd.

●Maintained the Deployments by raising an SR to different Environments.

●Updated the Instance Config file to meet the Requirements (Eg: Implemented Mouse over Functionality, Exceeding Max Rows of Repots,etc)

●Involved in creating the Security groups and Security document in order to implement the object level and the data level security.

●Build test cases and tested the Reports/Dashboards by comparing the SQL Output to the values in the Reports/Dashboards, documented the test results.

Environment: OBIEE 10.1.3.4.1/11g, Oracle 11g, Oracle EBS, Maximo, Windows Server 2003, SQL*Plus, TOAD, Peoplesoft Financials/HR/SCM, Siebel CRM 8.1.1, HP Quality center 9.2, Adobe Dreamweaver CS5.

Cox Communications, Altanta, GA Jan 2010 – Jan 2011

OBIEE Consultant (Developer/Testing)

As the third largest cable provider in the nation, Cox Communication Inc. is noted for its high capacity, reliable broadband delivery network as well as the company ability to provide superior customer service. For Cox, it’s not about being the biggest; it’s about being the best.

With more than 6 million customers, over 22,000 employees and a firm commitment to education. The Cox team is widely regarded as the best in the cable industry, having earned multiple distinctions in customer satisfaction and company strategy. In 2006, Cox received highest honor in J.D Power and Associates residential cable/satellite TV customer satisfaction study as well as in 2005 for customer satisfaction among high-speed Internet service providers.

Worked on the following projects

1. Wireless Reporting CRM

2. Wireless Reporting BRM

3. Kana IQ Reporting

4. Technician Efficiency

Responsibilities:

●Gathered Business requirements by interacting with the Business Analysts and the business users.

●Performed upgrade related activities from OBIEE 10.1.3.3 to OBI EE 10.1.4.1/OBIEE 11g

●Converted all Universes in Business Objects to OBIEE rpd.

●Designed Oracle BIEE Repository at 3 layers i.e., Physical Layer (connecting Data sources & import schema), Business Model / data mapping (create Logical tables & data source mapping) and Presentation Layer as per the Universes in Business Objects and followed best practices.

●Created dimension hierarchies, aggregates, and logical sources in the BMM layer as per the Universes in Business Objects.

●Extensively used repository variables, session variables and presentation variables.

●Used the security settings in OBIEE Admin tool to setup users, Groups and Access privileges.

●Created views and aggregated tables to improve performance in rpd.

●Worked with Cache Manager to improve performance.

●Created dynamic Dashboards with Dashboard prompts, Charts, Pivot Tables, Guided Navigation Links and Sections.

●Used Column Filter prompts and various views such as Pivots Table, Charts, Narrative Views and View Selector.

●Setup Usage tracking option to monitor frequently run reports in order to provide caching for the reports and perform database optimization by analyzing query performance.

●Modified the InstanceConfig.xml in order to configure the maximum number of rows,columns,sections,records required on the reports.

●Created user level security for Intelligence dashboards based on Business Requirement and Business Objects.

●Replicated the Reports, Dashboard, and Functionality in Business Objects to OBIEE (nearly 500 reports).

●Created Mock Up Reports for the new business requirements.

●Created iBots to send pre-processed reports using Delivers.

●Integrated BI Publisher with OBIEE.

●Created Templates, Reports, Prompts in BI Publisher.

●Schedule reports and bursting as per the requirement in BI Publisher and represented then in OBIEE dashboards.

●Performed Data Validation of data in the reports.

●Extensively used SQL Tuning and Indexes to improve performance.

●Used Toad to debug the SQL query to identify duplicate rows in the warehouse tables, and to debug SQL query issued during report execution.

●Provided Training to the business users on OBIEE Answers and Dashboards and educating technical super users and administrators on repository and web catalog migrations procedures with OBIEE Best Practices.

●Performed Unit Testing by comparing the data in OBIEE and Business Objects.

●Documented the conversion process from Business Objects to OBIEE for future reference.

●Involved and Migrated rpd and catalog to Development to UAT to Production environment.

Environment: Oracle BIEE 10.1.4.1,OBIEE 11g, Java, PL/SQL, SQL, BI Publisher, DAC, Business Objects XI Release 2, Business Objects 6.5, Oracle 10g/11g, TOAD

Certifications

●Oracle Certified Specialist

●PowerBI for beginners certificate

●Microsoft PowerBI Data Analyst

●Data Science with Python certification from simplilearn.

Academic Qualifications

●Master in Computer Applications Periyar University, Tamil Nadu, India.

Contact this candidate