We provide IT Staff Augmentation Services!

Business Intelligence Resume

VA

PROFESSIONAL SUMMARY:

  • 20+ years of experience in - BI, CRM, ERP, Enterprise Reporting and ETL
  • Training/Project experience - OBIEE, Siebel, Dynamics CRM, SAP
  • Actively involved in Program and Project Management tasks in diverse environments
  • Worked on complete project life cycle from initiation to closure in different capacities
  • Interacted with clients for business processes and requirements, technical team for development approach, and testers for quality assurance
  • Exposed to various application integration scenarios across different environments
  • Documented and implemented Quality Management System in accordance with CMMI- L3/ISO 9001:2008 QMS standards.

TECHNICAL SKILLS:

Hardware: DEC-PDP 11/70, ND110, PC's

Operating Systems: UNIX, RSTS/E, DOS, SINTRAN-3, Windows, Languages Java, Javascript, PL/SQL, VB, ABAP/4, COBOL, Pro* C, C++ Database RDBMS-Oracle, Teradata, MS-SQL Server, UDB

Databases: Oracle, SQL Server, MySql, Access

Reporting: Oracle Reports, BOBJ, Actuate, Crystal Reports, Axiom, Discoverer, Cognos, Hyperion

ETL: Informatica, SSIS, ODl/OWB

ERP: SAP, Oracle EBS

CRM: Siebel, Microsoft Dynamics CRM, Salesforce

BI: OBIEE, OBIA, BI-Publisher, SAP-BO, Essbase, BIRT, Discoverer

OBIA: Sales/Service/Marketing/Financial/Call Center Telephony Analytics

Others: Oracle Application Express, MS-Project, SDLC-Agile/Waterfall, SOA, .NET framework, Aprimo, SharePoint, Toad, Tableau, MQ-Series, EDI (Mercator), 508 compliance tools, VMware - Virtualization, Rational, Lotus Notes, Visual SourceSafe, HP-Mercury tool, XML

WORK EXPERIENCE:

Confidential, VA

Business Intelligence

Responsibilities:

  • Work on defined tasks per the schedules in the project management plan
  • Analyze requirements and provide technical solutions to meet them
  • Configure the custom Automated Compliance Review System (ACRS) application
  • Set up MS Power Business Intelligence environment including setting up on-premise Power BI Report Server for enterprise reporting
  • Extract data from different sources for analytics reports
  • Assist users with entering the annual program review findings and corrective action plans
  • Generate management reports from the data sources for trend analysis by service centers and states
  • Design test scenarios for testing the enhancements in the application based on business functions
  • Involved in direct database management tasks as and when required also
  • Work with various business groups to resolve user concerns and application issues
  • Prepare training materials, organize and conduct user training
  • Responsible for quality assurance tasks
  • Conduct internal audits in different process areas and help make improvements based on metrics data

Confidential, DC

Business Intelligence

Responsibilities:

  • Assess the business model and its integration with existing technical infrastructure
  • Understand the structure and policies of various divisions to recommend a feasible reporting strategy
  • Work with report developers to improve the quality of different types of reports derived from different business units
  • Understand end user form requirements and validate data mapping
  • Develop BIP reports from various data sources including external XML data sets
  • Apply data level security measures in the new implementation
  • Help create test plans with proper validation checks
  • Share new report designs with users for feedback and improvements

Confidential, MD

Business Intelligence

Responsibilities:

  • Collaborate with business areas to implement BI enterprise reporting platform
  • Set up key milestones with tasks and prepare cost estimates with development hours
  • Provide inputs to development project plans
  • Plan and implement steps to build new metadata with business model and presentation layers in OBIEE
  • Configure OBIA to meet customer needs for dashboard analytical reporting
  • Design reports for healthcare providers and claims by regions/services for deployment on dashboards
  • Integrate BIP with existing legacy Hospital Reporting application
  • Translate requirements into development work units
  • Performing detailed data analysis and mapping in collaboration with business users and data architects
  • Analyze legacy reports in Cognos environment for upgrades and enhancements per requirements
  • Build a migration plan to convert existing reports from Cognos and PowerBuilder to BIP
  • Design BIP reports based on RTF, PDF, Excel templates and those derived from government forms
  • Customize look and feel ensuring 508 compliance
  • Document BI server administration tasks
  • Work with users on setting up training programs with required documentation and materials
  • Collaborate with QA team to build test plans for integration testing and resolving defects
  • Extract data from external sources and load into the reporting database using Informatica
  • Participate in SOA solution design phase for integrating legacy system and new technologies in heterogeneous environments

Confidential, VA

Business Intelligence

Responsibilities:

  • Establish project scope, design and resource plan
  • Interact with stakeholders on business priorities
  • Recommend technical solutions through changes in approach and business processes
  • Work with cross-functional teams and prepare status reports accordingly
  • Use ODI E-LT design approach to load and transform data using Loading Knowledge and Integration Knowledge Modules
  • Setup MS Dynamics CRM Server and Reporting Extensions
  • Install and configure MS CRM for Outlook to connect to organizations
  • Setup organization-owned and user-owned dashboards
  • Analyze ERP function modules required for back end accounting processes
  • Understand OBIEE business model changes for reporting from salesforce database
  • Demonstrate reports from Essbase cubes imported into the presentation layer of OBIEE repository
  • Utilize BOBJ to generate reports based on operational or management analysis requirements

Confidential, PA

Business Intelligence

Responsibilities:

  • Facilitate meetings with stakeholders to understand business analytical needs
  • Work with technical and business team to define critical phases of the project
  • Set up BI Publisher environment for creating user templates for emailing letters to customers based on business requirements
  • Design new BIP report templates for accounts based on underlying data fields consolidated from different data sources including Siebel CRM
  • Configure Service Request, Contact and Account Management modules for new customer management functions using Siebel Tools
  • Customize data warehouse and create ETL execution plans for data migration
  • Define Administration tasks for Siebel and OBIEE environments

Confidential, TX

Business Intelligence

Responsibilities:

  • Collaborate with data owners to successfully implement business analytics solution
  • Work with Program Management on approach and solutions
  • Build a custom RPD per business requirements
  • Configure Physical, Logical and Presentation layers inside the repository
  • Design data mart with star dimensional schema
  • Customize the Logical Layer with Formulas for accounting functions
  • Implement data security and define access privileges by user roles
  • Set up Dashboards for Finance Analytics reports such as General Ledger- Balance Sheet, Profitability Analysis -Products, Account Receivable - Payments Due, Account Payable - Invoice Details

Confidential, OH

Business Intelligence

Responsibilities:

  • Set up Siebel Email Marketing Server Architecture
  • Map Siebel out-of-box functionality to business requirements
  • Configure and test Siebel Marketing components
  • Define contact list management tasks
  • Integrate Siebel Marketing with OBIEE
  • Create OBIEE segments and generate lists for launching marketing campaigns
  • Use Siebel Workflow Policy programs and objects for campaign execution
  • Create new Catalogs and configure Segmentation Catalogs
  • Help Deploy configurations across different environments
  • Mentoring team members on Email campaign workflow and building offer templates

Confidential, MD

Business Intelligence

Responsibilities:

  • Install, configure and setup infrastructure in Windows and Linux environments for OBIEE/OBIA environments
  • Plan and implement business intelligence and a data warehousing solution
  • Install and configure Informatica PowerCenter components
  • Build ETL mappings for loading custom Siebel OLTP data into the data warehouse
  • Understand ERP-EBS functional modules and data load procedures into the warehouse
  • Analyze source tables for financial analytics reporting
  • Gather Siebel Call Center Telephony- Avaya data elements as a source for reporting
  • Analyze possible customer profiles and interactions for SmartScript deployment
  • Participate in discussions and mapping County's functional requirements to Siebel Public Sector - Case Management module
  • Design the Physical/Business/Presentation layers in BI repository based on customer information needs
  • Validate BIP templates after data mapping from transaction database
  • Work on developing dashboards and reports for managers using Answers/BI Publisher
  • Tuning reports and enhancing performance through Caching, Aggregation & Queries
  • Migrate reports/enhancements to Production after testing the new design with users
  • Integrate Oracle Map Viewer with BI application for plotting service requests
  • Integrate OBIEE reporting interface with MC311-CRM application
  • Set up Oracle BI training for managers

Confidential, NJ

Business Intelligence

Responsibilities:

  • Manage cross-functional program team for successful project outcome
  • Discuss user requirements and propose appropriate custom solutions to meet the business needs
  • Define strategy and design technical architecture for data warehouse
  • Document data model using Erwin tool
  • Implement data migration tasks from existing transaction system to data warehouse in SSIS for BI reports through ETL
  • Follow up with customer on a regular basis for deliverables and feedbacks

Confidential, PA

Business Intelligence

Responsibilities:

  • Gather user requirements and map to Siebel functionality
  • Responsible for change management tasks
  • Create eScripts to validate custom data elements
  • Effectively use Siebel Workflow/Assignment Manager for task assignments

Confidential, FL

Business Intelligence

Responsibilities:

  • Discuss customer requirement with business and technical team
  • Configure SCM - Inventory Management tasks for consumer products
  • Create new ETL mappings for custom table extensions and data migrations
  • Configuring DAC repository per Informatica workflow tasks
  • Work on developing dashboards and reports for managers
  • Set up Siebel Marketing Campaigns in coordination with Account team
  • Define Marketing segments based on zones
  • Generate contact list and prospects from Analytics Segments
  • Plan campaign load, launch and post launch process

Confidential, VA

Business Intelligence

Responsibilities:

  • Involved in the entire Siebel-CRM and OBIA project implementation life cycle
  • Define and schedule the project phases based on SDLC methodology
  • Understand the functional processes and plan the designs in accordance with Siebel industry standards and best practices
  • Act as a liaison between the technical team and the business users
  • Customize Business Objects, Components and Views within Siebel Tools
  • Use eScripts for filtering and validation of external data items
  • Implement eService module for external users to access FAQs, Solutions & Resolutions
  • Implement Inbound/Outbound Web Services for processing customer Surveys from external application
  • Implement Siebel Upgrade process
  • Develop/modify Siebel Actuate reports per requirements
  • Configure BI Application and analytics data warehouse per business needs
  • Convert Discoverer reports into BI Answers on user's Dashboard
  • Configured metadata repository to meet current user requirements
  • Use Siebel Answers and Dashboards for generating individual report requests and charts
  • Integrated Siebel Service Application with Analytics
  • Create ETL execution plans for data loads from OLTP to Data Warehouse using
  • Plan and upgrade complete Siebel 7.5 application to 8.0 per standards

Confidential, NY

Business Intelligence

Responsibilities:

  • Participate in Functional workshops
  • Review and validate all the functional and technical designs
  • Analyze business objects reports for enhancements and integrations with new application
  • Examine the Use Cases and provide feedback
  • Review the Middleware functional/technical design for key Interaction points between the Siebel Inbound Application and existing external Applications for real time transactions
  • Involved in transaction and data mapping phase
  • Design SCM - Customer Order Fulfillment workflow steps
  • Define strategy for Batch initial and Incremental transaction data loads from legacy system and other external application databases to Siebel DB and vice-versa
  • Define EIM steps to load transaction data through Staging tables
  • Participated in the application-building phase with key technical members

Confidential, VA

Business Intelligence

Responsibilities:

  • Participate in the entire Siebel Call Center life cycle including setting up Development/Test environment
  • Customize the SCM - Asset Management module
  • Identify help desk user requirement and perform gap analysis
  • Configure the requirements using Siebel Tools
  • Integrate Siebel with backend ERP application using EAI
  • Develop and integrate business reports in Actuate
  • Observe Siebel best practices when customizing the standard Siebel application
  • Configure Siebel Remote for synchronizing mobile user data
  • Design test plans for testing the new functionality
  • Responsible for designing a complete Upgrade/Migration plan from Siebel 6.3 to 7.5
  • Develop new Siebel Actuate reports such as mater detail and crosstab

Confidential , VA

Business Intelligence

Responsibilities:

  • Provided Training on Siebel functional modules
  • Prepared Case Study based on real life business scenario
  • Responsible for development of technical reference materials

Confidential

Business Intelligence

Responsibilities:

  • Worked as a Global Siebel Certified Trainer on behalf of Siebel Sydney
  • Imparted CRM training to business managers in South Korea and India

Confidential

Technical ERP-SAP Consultant

Responsibilities:

  • Provided consulting services to technical and functional consultants on SAP (business and technical modules)
  • Areas covered:
  • List reporting, Transaction Processing, ABAP/4 Query, SAP Scripts
  • Transaction data exporting/importing through EDI Mercator tool
  • Functional Modules associated with Logistics and Manufacturing - Materials & Service Management, Sales & Distribution and Production Planning

Hire Now