PROFESSIONAL SUMMARY:

• 15 years of experience in Software Development that includes Data Analysis, Data Modeling, Business Intelligence & Packaged Solutions with exceptional understanding of business processes.
• Highly skilled in interpreting and analyzing data to provide results driven business solutions.
• Experience in Business Intelligence Applications using Power BI, SQL Server Reporting Services (SSRS), Oracle Business Intelligence (OBIEE) / Oracle Business Intelligence Apps (OBIA).
• Experience in data analysis & validations in databases like Snowflake, Oracle, SQL Server, and DB2.
• Experience in using Informatica to facilitate Extraction Transformation and data Load from OLTP systems to OLAP systems.
• Experience working with Siebel CRM in both Development and Support Roles.
• Experience with both Agile & SDLC.
• Experience in Global Delivery Model (Onsite/Offshore team structure) and Team Lead activities which include Estimations, Incident / Service Request / Change Management, Resource Utilization, and others.
• Experience in translating user requirements into functional & technical specifications, managing clients / vendors / partners relationships, ensuring service delivery and tracking requests for system enhancements, improvements from end - users / customers.
• Excellent Verbal & Written Communication and People skills. Have delivered quality products as a team player, team lead & independent consultant.

TECHNICAL SKILLS:

BI: Power BI, OBIEE 10g/11g, Siebel Analytics 7.8, BI Publisher, OBIA (7.9.6.3)

ETL: Informatica 9.x, DAC 7.x

CRM: Siebel 7.x & 8.0

Languages: SQL, PL/SQL, HTML, C, C++, JSON, Java Script, XML, DAX

Databases: Snowflake, Oracle 10g / 11g, Microsoft SQL SERVER, DB2

WORK EXPERIENCE:

Confidential, Santa Ana, CA

Sr. ERP Engineer

Responsibilities:

• Gathering Business Requirementsby interacting with the Business Users.
• Involve in Design Sessions with Data Architects and Business Analysts.
• Create executive & operational level reports (/dashboards) which assist leadership & management with meaningful insight on the data using tools like OBIEE, BI Publisher, Power BI Desktop, Power BI Report Builder & SSRS.
• Developed audit dashboards which gave up to date status on the ETL workflows.
• Defined templates for Notification Emails and used them in the Agents.
• Extensively worked on producing Power BI data models (for self-service BI through Power BI Service) leveraging DAX.
• Design & developed a security models in OBIEE & Power BI.
• Produced Themes JSON & Skeleton PBIXs.
• Written multiple views and functions in snowflake for Power BI report builder and SSRS to consume in RDL for paginated reports.
• Created Streams & Tasks in snowflake for CDC.
• Involved in OBIEE, RPD & Catalog Upgradation from version 11.1.1.7 to 11.1.1.9.
• Periodic Migrations of RPD and Catalog from lower environments to higher environments.
• Work with offshore and IT of other divisions as needed.
• Production support to keep the lights on & help other team members in the capacity of a SME.
• Maintained all the relevant documentations pertaining to projects.
• Perform code reviews and coach other resources on BI tool usage and best practice.

Confidential, Mountain View, CA

OBIEE Sr. Developer

Responsibilities:

• Involved in gatheringBusiness Requirementsby interacting with the Business Analysts, development and defect fixing.
• Understand business needs and warehouse architecture to design Data Model and produce Lineage Documentations for mappings.
• Customizing out of box RPD to address changes atPhysical Layer,Business Model & MappingandPresentation Layerlevels.
• Developing new RPD toaccommodate customized / business specific reporting needs and then merging the changes on to master RPD.
• Evaluate database design / architecture and estimatereal-time parallel connections to the warehouse systems to define Connection Pool settings.
• Work on Logical Sources, Level BasedDimension Hierarchies, Calculated fields, and Aggregates in the BMM layer.
• Set upMeta data Objects(Subject Area, Table, and Column)SecurityandData level Security.
• Leverage out of boxRepository Variables&Session Variables and defining new Presentation & Request Variables.
• Manage security settings in the Console and Enterprise Manager to manage Users / Groups / Access Privileges.
• Generate Reports using advance report features likePivot tables,Charts,View Selector and etc.
• Work on time series reporting usingAgo /To Date / period rollingfunctionsfor Rolling Time Periods Reporting.
• Unit testedthe modules by Data Validation of data in the reports.
• CreateDashboardswithDashboard Prompts,ChartsandPivot tables and scheduleexecutive reports through Agents to email them to Confidential Leadership team.
• Enable Usage Tracking on the application to trouble shoot long running reports and effectiveCaching Design / Management.
• Created Projects to enable MUDE for developers to Check-out / check-in.
• Manage daily Dev to QA & QA to UAT Migrations which involve rpd and Catalog Migrations.
• Participate in Daily Scrum meetings to update the project leadership on status / to-do activities.

Confidential, Dearborn, MI

Responsibilities:

• C-SAT initiative was to gather responses from various surveys, consolidate them and tag members as PROMOTER or NEUTRAL or RETRACTOR based on survey scores.
• As an independent consultant and individual contributed performed end to end operations of the project.
• Produced repository file that had Complex Joins, custom attributes in Presentation Layer, Dimension Hierarchies and Aggregates in the BMM, Data level Security enabled, Repository and Session Variables.
• Used the security settings in the Console and Enterprise Manager to setup Users, Groups and Access privileges.
• Produced dashboard which gave meaningful insight on the data.
• Performed Unit Testing by Data Validation of data in the reports.
• Scheduled executive reports through Agents to email them to Confidential Leadership team.

Confidential, Atlanta, GA

OBIEE Tech Lead

Responsibilities:

• Involved in the whole life cycle of the project from Requirements Gathering to Deployment.
• Created Prototypes of Dashboards & Reports to educate business owners with the capabilities of OBIEE reporting.
• Identified Source systems (Flat files) and Target tables (ODS & EDW - OLAP) for Data Mapping.
• Developed number of Informatica Mappings, Mapplets and Reusable Transformations using transformations like Lookup, Sequence Generator, Filter, Expression, Source Qualifier, Router Update Strategy etc for loading of data.
• Developed Workflows & Worklets using Informatica Workflow Manager. Leveraged Workflow Monitor Capabilities in Testing / Debugging workflow and monitor Session Logs.
• Defined Target Load Order Plan for loading data into Target Tables and Implemented performance tuning logic on Targets, Sources, mappings in Production environment, Sessions to provide maximum efficiency and performance.
• Employed DAC to schedule the workflows and periodically monitored the load.
• Developed metadata repository usingOBIEE Admin tool- Modeling Physical, Business Model and Mapping, and Presentation Layers.
• Created new Logical Columns, Dimensional Hierarchy, Calculated Measures, and Aggregate Table Mappings in the BMM layer as per the business requirements.
• Created variousSession & Repository Variablesto handle dynamic scenarios and the environment changes.
• Designed Subject Area, Dashboards (/Pages) & Reports and employed Security Mechanism (LDAP Authentication) as per the business needs. Added Users and configured security in Web Logic console.
• LeveragedAgo and ToDate functionsfor Rolling Time Periods Reporting on the Routing Trends Reports.
• Created schedules to seed and purge cache forCache Management.
• Worked on Styles & Skins (CSS) for providing customized look and feel for analysis and dashboards.
• Worked on KPIs and ProducedBI Publisherreports in word & pdf formats for publishing Routing Summery Report to external / 3rd party vendors.
• Scheduled executive reports through Agents to email them to Confidential Leadership team.
• Implemented Best Practices of OBIEE 11G to improve overall performance of the application.
• Produced High-Level and Low-Level Design Documents and conducted walk through sessions with the Client team for approvals on the same.
• Lead offshore team in delivering committed reports and dashboards on time and per agreed functionality requirements.

Confidential, Saint Joseph, MI

Lead Engineer

Responsibilities:

• Interacted with the end users in requirements gathering and defined Requirement Specifications Document.
• Moved data from Siebel system (ODS) to EDW and Reports & Dashboards were design and develop for Sales and Executive teams helping them in day to day Decision Making.
• Developed a new Data Warehouse for the company using Oracle's out of box solution packaged with OBIA (Informatica, DAC & OBIEE).
• Created reusable Transformations and Mapplets based on the business rules to ease the development process. Tweaked OBIA Informatica mappings in accordance to business logic when ever required.
• Employed Mappings and Mapplets to move data from sources like Oracle, DB2 & Flat files into the Data Warehouse, using different transformations like Joiner, Aggregator, Update Strategy, Rank, Router, Lookup, Sequence Generator, Filter, Sorter, Source Qualifier, Stored Procedure and etc.
• Used Informatica Workflow Manager, Workflow Monitor & DAC to Debug & Monitor session status.
• Worked extensively on all the 3 layers of RPD metadata
• Implementedsecuritybased onExternal Table Authentication. Created schedules to seed and purge cache forcache management.
• Upgrade the OBIEE application from 10g to 11g. Hands on RPD development with MDS XML as source system.
• Created Workflows for full load and incremental loads to be used by DAC and monitored them.
• Extensively worked with DBAs towardsperformance tuningin OBIEE and Data Warehouse environment usingCache Management,Aggregate tables, and Indexes.
• Lead a team involving OBIEE, Informatica, Siebel CRM & InQuira resources to drive team to resolve tickets as per defined SLAs and deliver enhancements in agreed time.

Confidential

OBIEE Sr. Developer

Responsibilities:

• Created Detailed Functional Specifications Documents, Key Project Assumptions, Report samples, Data Flows, and Data Models.
• Estimate and provide Project Timeline on the deliverables and co-ordinate the project.
• Developed Metadata repository (.rpd) that consists of Physical, BMM and Presentation layer, Security, test and validate the business model & repository level calculations using Oracle BI Administration tool.
• Created the User Accounts and granted the Access/Privileges.
• Improved Analytics Response-time by Performance management using optimization efforts such as implementing the Aggregate Tables, caching, and report changes.
• Defined and created Initialization Blocks for Repository and Session Variables for generating filters and defining Security.
• Created Hierarchies, Measures and implemented Business Logic by creating level-based measures in OBIEE business model & mapping layer.
• Customized/Created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
• Performed the Performance Tuning of Dashboards and Reports and made required changes to repository and database in consultation with DBA.
• Implemented security based on LDAP Authentication.
• Created Schedulers and developed iBots to deliver reports and dashboards to the subscribers as per the schedules and alerts.
• Followed Oracle Best Practices wherever applicable and involved in testing activities.
• Cross trained on Siebel Analytics (OBIEE) & Informatica
• Worked closely with the onsite Business Community in assessing Business Needs, defining Requirements and Implementing Solutions.
• Interacted with ODI team to understand Keys and relationships in the DB.
• Design Siebel Web Components including OBIEE Answers and Intelligence Dashboards.
• Build OBIEE repository file by importing the data, defining keys and joins, creating business model, defining complex joins, mapping columns and sources, creating measures, and developing subject areas.
• Created Dimension Hierarchies, Aggregation criteria and multiple logical sources in the BMM layer.
• Developed variousReports, Interactive Dashboardswith Drill-down Capabilities, with various charts and views, and tables using global and local Filters.
• Implemented Security by creating Roles and Groups and defined Object Level and Data Level Security.
• Created schedules to seed and purge cache forCache Management.
• Involved in Project Knowledge Acquisition Process and was part of Siebel Development & Bug Fix projects.
• Attended Workshops (Design phase) where in Clients Requirements were analyzed.
• Involved in preparation of Technical Design Documents.
• Did multiple POCs related to various aspects of Siebel CRM system.
• Worked on Applets, Views, Links, List of Values, Business Components, Business Services, E-Scripts & VB Scripts, Responsibilities, Workflows, Assignment Manager, Audit Trails, and others.
• While performing defect fixing activities, effectively documented the details on how the bug was fixed in MyQA for future reference.
• Documented require changes in RPM if the solution require any design change.