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

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

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

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

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

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

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

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

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

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

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

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

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

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

Responsibilities:

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

Confidential

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