SUMMARY

• Senior BI Data Architect with over 20 + years of BI experience as a BI Data Architect, BI Analyst, Technical Lead in the field of Data analysis, design & implementation of enterprise BI & Analytics, development to support of enterprise BI infrastructure. Demonstrated leadership abilities and team work skills. Possess good Functional knowledge in the areas of Finance / Sales and Distribution / Purchasing / HR and Manufacturing.
• Extensive software development experience with specific expertise in Business Intelligence using such tools as Noetix, Business Objects, Oracle Business Intelligence Enterprise Edition (OBIEE), Oracle Business Intelligence Analytics (OBIA), Oracle Reports, Oracle Discoverer, Tableau & Spotfire.
• Experience working as BI Analyst in identifying business intelligence, reporting and data analysis needs. Worked closely with clients and IT teams in turning data into critical information and knowledge that can be used to make sound business decisions.
• Rich experience working with Visualization tool in designing and creating rich graphic visualizations with drill down/drop down and parameterized dashboards. Extensive knowledge working on building, publishing customized interactive reports/dashboards, report scheduling, creating action filters, parameters, and calculated sets for preparing dashboards and worksheets, restricted data using row level security and user filters, and data blending using multiple data sources. Involved in creating database objects like tables, views, procedures, triggers, and functions using T - SQL to provide definition, structure and to maintain data efficiently.
• Extensive knowledge working on Virtualization tool by creating data model using techniques by connecting multiple data sources such as SQL server, Sharepoint, Oracle database, Excel, Flat files etc., Expertise surrounding creation of base views, derived views, joins, projection, selection, unions, flatten views and associations of data service layers. Scheduled jobs for data extraction and report reload using scheduler.
• Experienced in implementing Business Intelligence projects and reporting systems using data warehouses and complex data models from requirement definition through production deployment and support of various departments such as Finance, Human Resources, Sales, Accounting, Procurement and Manufacturing. Excellent management, communication, presentation, interpersonal, and facilitation skills.
• Performed extensive GAP analysis in the project as there were numerous 'As-Is' and 'To-Be' conditions.
• Experience in Data Warehousing (Dimensional Modelling and Database design) and Business Intelligence (Report, KPI, Scorecards, Dashboards)
• Data Architecture (Conceptual, Logical, Physical) experience & Star Schema {Dimension (Slowly Changing, Snowflake, Conformed Dimensions), Fact, Metrics, and KPI} using the tool
• Very strong SQL and PL/SQL development experience (Creation of packages, procedures, functions, database objects, etc.).
• Extensive knowledge in all phases of Software Development Life Cycle SDLC and various methodologies like Agile and scrum.
• Over 18 years of experience in Oracle E-Business Suite Applications releases 11.0.3/11i2-11i10/R12 as an Application Technical Project Manager and Senior Techno-Functional Consultant.
• Rich experience on the RICE components (Reports, Interfaces, Customization and Extensions of Oracle Applications 11i/R12 (11.5.3/5/7/8/9/10 ) on Financials, and Distribution modules
• Experience in Application Integration; developed interfaces between Oracle Apps and legacy systems.
• Extensively used API’s in Data conversions/migrations, followed map, validate, error trapping, loading processes.
• Used AOL (Applications Object Library) and Template.fmb for all custom GUI development and Customization of Custom.pll for specific business validations.
• Used Forms Personalization effectively to accomplish specific business validations
• Very good functional knowledge on Financials (GL, AP, AR, FA, CM), Distribution (OM & INV) and Purchasing Modules of Oracle Apps.

TECHNICAL SKILLS

ETL/BI Tools: Data Loader, SQL Loader, SQL Plus, PL/SQL, OBIEE 10g & 11g (Administrative Tool, Publisher, Answers and Dashboard) OBIA 7.9.6.2/7.9.6.3 (Financial, Supply Chain and Procurement), ODI, Informatica, DAC, Noetix, Crystal Reports, BI Publisher (XML Publisher), Business Objects 3.x & 4.x, and Tableau 10.x, Denodo 5.5/6/7

ERP Applications: Oracle E-Business Suite Applications 11.0.3, 11i, R12; Financials AR, GL, AP, FA, CM, SLA (R12); Supply Chain Purchasing; Distribution OM, Inventory; Manufacturing BOM, WIP, Quality; HRMS Core HR, Payroll, OTL, Benefits; CRM Service Contracts, Installed Base, TCA

RDBMS: Oracle 12x, 11x, 10x, 9x, 8.x, 7.x, 6.x, MS Access

Case Tools: TOAD (7.x, 8.x, 9.x, 10.x, 11.x, 12.x), Visio 2000

Developer Tools (OLTP): Oracle Developer Forms (2.5, 3.0, 4.5, 5.0, 6i, 9i, 10g), Reports, Graphs, Oracle Discoverer (6i, 9i, 10g), Oracle Alerts, Oracle Workflow builder, Financial Statement Generator (FSG), Application Desktop Integrator (ADI), and Web ADI

Operating Systems: UNIX (SCO, Solaris, HP-UX), Linux (Red Hat), Windows 95/98/NT/2000/XP/2003

Programming Tools: PL/SQL, Oracle Packages, Custom Packages, Triggers, Libraries (custom.pll)

Domains: Financial Institution, Oil exploration, General Trading, Utility Billing, Government, Transportation, Fertilizer and Life Sciences, Retail and Insurance

Implementation Method: Software Development Life Cycle processes (SDLC) with Oracle’s Application Implementation Methodology (AIM) under ISO 9000 and CMMi Level 5 compliances

Other Tools: Jira for Bug/Issue tracking and project management, Atlassian’s Confluence and Microsoft Sharepoint for team collaboration

PROFESSIONAL EXPERIENCE

Confidential, NJ

Senior Consultant and Business Analyst

Environment: Microsoft Azure Cloud / Power BI / Tableau / EDW Platform / Big Data (Hadoop)

Responsibilities:

• Understand and document the information supply chain from their point of view.
• Create a visual for an information supply chain to understand the flow of data in “a Day in the Life” of a Lead.
• Document data flows and integrations for the Lead, step by step, at a conceptual (business level). Show major data lifecycle activities (create/acquire, update/maintain, and delete/dispose/archive). Avoid the technical “how” data is managed.
• Document the key data elements at each point in the supply chain and align to standard business terms
• Collect/build System Data Dictionaries for the EDW Reporting environment and load into Consolidated Data Dictionary tool
• Extract and create business level glossary information from the EDW Reporting system data dictionary and load into the Business Glossary Compendium tool. Assign Data Owner and Data Steward(s). Curate glossary entries and promote.
• Link / map EDW Reporting System Dictionary entries to Business Glossary Terms.
• Gather data source inventory about data sources for the EDM environment
• Gather Integration inventory which tracks the flow of data between points within the environment regardless of the type of integration
• Gather data model inventory and how they are related within the context
• Gather application, dashboard and report inventory supported by EDM reporting platforms
• Part of internal meetings with the team in gathering information and documenting the same

Confidential, MA

Data Architect

Environment: Denodo 7, Tableau 10.5, Windows, Oracle Database, Hyperion, Sharepoint and SFTP

Responsibilities:

• Understanding the business requirements and documenting the same
• Development and Management of Sources, Base Views, Derived Views and Final views using Denodo
• Supporting the tableau development team in providing the requirements needs and guiding in development of reports
• Perform unit testing and data validation
• Help the SIT and UAT team in performing testing and providing the needed data for validation
• Helping the team in moving files between instances
• JIRA tool is used in the project
• Creating of technical documentation
• Providing hyper care support to the business team
• Provide KT to the concerned technical team
• Being part of technical conversation and providing the needed support

Confidential, NJ

BI Data Architect & Lead Business Solution Architect

Environment: Microsoft Azure Cloud / Power BI / Tableau / EDW Platform / Big Data (Hadoop)

Responsibilities:

• Understanding and documenting various carrier programs and business processes like Leads, Lead cost, Policy, Commission, and Application and so on.
• Understand and document business flows
• Mapping of data from source to target
• Attend meeting to discuss and clarify the processes and data mapping
• Create JIRA tickets for each every tasks and track the progress
• Being part of daily standup call
• Discuss with the EDW team on the solution and on how the data will be pulled in from the source to the EDW
• NextGen EDM Platform
• Deployment of Big Data Hadoop platform for the enterprise data warehouse
• Gathered business requirements, working closely with business users, project leaders and developers.
• Analyzed the business requirements and designed conceptual, logical and Physical data models.
• Enforced naming standards and data dictionary for data models and documenting the same.
• Schedule meeting with business users and EDW team
• Responsible for detail architectural design.
• Responsible on Source to target mapping and traceability matrix.
• Performed database administration like User Management and implement Security using Roles, Privileges, Grants, table space management and capacity planning etc.
• Monitoring and optimizing the performance of the database through Tuning Applications, Tuning Memory and Tuning Disk Usage etc.
• Tuning of SQL statements using tools like Explain plan, Auto trace, Gathering statistic, analyzing tables and indexes, Query rewrite, hints etc. in oracle
• Profile data and identify data quality rules. Data map and gap analysis
• Actively involved in data profiling to ensure data quality.
• Worked on Tableau, design the reports, dashboards etc.

Confidential, MA

Lead BI Consultant

Environment: Business Objects, Tableau 10x, OBIEE 11g (11.1.1.6.2 BP1), Exalytics

Responsibilities:

• BO Upgrade
• Converting BO from 3.x to 4.x
• Around 25+ universes upgraded
• Around 700+ reports upgraded
• Managing the offshore and onsite team
• Unit and Integration testing
• Documentation
• SCALE Project (Oracle EBS 11i to R12 upgrade)
• Mapping of 11i tables to R12 for all universes
• Amendments to reports based on changes in universes
• Managing the offshore and onsite team
• Unit and Integration testing
• Documentation
• BO Support Project
• Managing the requirements as well as issues
• Assignments of activities to the offshore team
• Discussion with users
• Managing the offshore and onsite team
• Unit testing
• Deployment to PROD
• OBIEE Support
• Gathering requirements
• Developing dashboards, analytics reports as per client requirement
• Participating in client meetings
• Troubleshooting issues for OBIEE
• RPD related activities
• Carried out OBIEE assessment
• Interacting with the offshore team
• Managing the deliverables
• Production Support
• Tableau Support
• User requirement gathering
• Issue fixes
• Development of reports/dashboards

Confidential, NC

Lead BI Consultant

Environment: : OBIEE 11g (11.1.1.6.2 BP1), Exadata, Oracle Data Integrator 11g

Responsibilities:

• Developing dashboards, analytics reports as per client requirement
• Creating Physical layer, BMM layer and Presentation layers
• Building hierarchies
• Creating row-level and user level security
• Building Publisher reports
• Participating in client meetings
• Troubleshooting issues
• Creating SR with Oracle and following up on issues
• Moving RPD and Catalog from one instance to another
• Uploading data from one instance to another
• RPD related activities
• Implemented security (Custom users, groups, roles and policies)
• Implemented Custom Style & Skin (Changing logo, Banner Name, Background color, icons, text and other related activities)
• Production Support
• Worked on interfaces and expertise in implementing business rules
• Developed and maintained ETL (Data Extraction, Transformation and Loading) mappings
• Implemented the Change Data Capture (CDC) to minimize the data load times
• Created mappings using different look-ups and reusable components.

Confidential, NH

Lead BI Consultant

Environment: OBIEE 11g (11.1.1.6.1 ), Essbase, Teradata, Oracle Data Integrator 11g

Responsibilities:

• Identified the granularity level of the data required to be available for analysis.
• Developed Metadata repository (.rpd), configured metadata the Business Model
• Layer & Physical Data Model and Web Catalog Objects as per the reporting requirements using OBIEE Admin and Web tool
• Worked on Oracle BI Answers to build Interactive Dashboards with drill-down capabilities.
• Developed different kinds of Reports (pivots, tabular) using global and local Filters.
• To track user activities, Usage Tracking was implemented
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository
• Managed security privileges for each subject area and dashboards according to user requirements
• OBIEE Security enforcement using LDAP Authentication
• Row-Level Security implemented
• Worked on interfaces and expertise in implementing business rules
• Developed and maintained ETL (Data Extraction, Transformation and Loading) mappings
• Implemented the Change Data Capture (CDC) to minimize the data load times
• Created mappings using different look-ups and reusable components.

Confidential, San Diego, CA

BI Business Analyst

Environment: OBIEE 11g (11.1.1.5) and OBIA 7.9.6.3 (Financial Analytics), Informatica and DAC

Responsibilities:

• Installed and Configured OBIEE 11g (11.1.1.5), OBIA 7.9.6.3, Informatica and DAC environment on Windows to demo the product capabilities to the client.
• Understanding existing system (Costpoint, EPM11)
• RPD Configuration (establishing connection pool, bringing in custom tables, creating physical and logical joins, creating logical table, creating columns, measures, hierarchies, creating custom subject area and presentation tables)
• Development of Reports (15 reports)
• Creation of Initialization Blocks, Repository and System variables.
• Security Configuration
• Worked on interfaces using Informatica and DAC
• Expertise in implementing business rules
• Developed and maintained ETL (Data Extraction, Transformation and Loading) mappings
• Implemented the Change Data Capture (CDC) to minimize the data load times
• Created mappings using different look-ups
• Created mappings using reusable components like worklets, mapplets using other reusable transformations.
• Deployment of RPD
• Testing of reports and bug-fixes
• Documentation (RPD, Security & Report)
• Knowledge Transfer
• Production Support
• Attended project review meetings