SUMMARY:

• 18 years of IT experience in delivering high end technology solutions for enterprise level Business Intelligence & Data Warehousing, Data Analysis, Integration and MDM environments to support business goals. I have performed various roles such as, Technical Lead, BI Solution Architect, Senior BI Consultant and Support Admin for multiple software development and infrastructure projects. Provided solution based leadership bridging technical and business teams to enact effective and efficient solutions. Adept in implementing and managing SLA - driven services. Managed global teams and ability to adapt to any role necessary to ensure project success. Responsible for executing in all phases of requirements gathering, JAD, conducting interviews, Data Visualization, Business Analysis, Data Analysis, User experience (UX), design (Physical & Logical), customizations, implementation, conversions, development, KPI Metrics creation, scalability, performance tuning, Streamline and enhance existing programs, Quality Assurance, documentation, 24/7/365 Support and Monitoring. Strong customer orientation and skilled with managing and working with people at all levels.
• Excellent track record in solving complex business problems by defining the solution strategy, project planning, architecture, execution, monitoring, resource balancing and directing with ability to support and development/delivery of advanced technology solutions in bare-metal on premise and Private/Public cloud with multiple simultaneous projects in a matrix organizational structure.
• Excels at communicating with stakeholders to provide accurate reporting and information regarding the ongoing projects, risks and initiatives.
• Architect and Designed visually appealing information delivery in the form of Business Analytics for enterprises to improve the data driven approach for informed decision support.
• Experienced in coordinating, negotiating and motivating outside vendors and off-shore resources in support of timeline and IT project deliverables.
• A problem solver with strong dexterity in identifying the root cause and creating solutions with sharp analytical skills
• Outstanding interpersonal skills with emphasis in pro-active brainstorming and debating dialogues to mediate people with conflicting needs. Effective Training, motivating and mentoring onsite and offshore resources.
• Created & executed coding standards, Software Quality processes, checklists, UX good practices. Assisted in conducting research on software and hardware products to justify recommendations and to support purchasing efforts

CORE COMPETENCIES:

• Global Team Leadership
• IT Architecture & Planning
• Process Center of Excellence
• Project Management
• Change Management
• Risk Management Development
• Data/Information Management
• Service Level Agreements
• Sourcing IT Vendor Management
• FDA Reporting
• Healthcare IT BPO

TECHNICAL SKILLS:

BI Product Experience: Oracle BI, OBIA, BI Publisher, Essbase SAP - Business Objects, Crystal Reports Microsoft BI - SSIS, SSRS, SSAS

ERP/CRM Experience: PeopleSoft 9.1/9.0/8.9 EBS R12/R11, Siebel 8.2/8.0/7.8

Application/Web Servers: WebLogic, WebSphere, IIS

Midrange: IBM AS/400, Synon 2/E

PROFESSIONAL EXPERIENCE:

Confidential

BI Project Lead

Technologies: Oracle BI, eBusiness R12 (Finance, HCM), Informatica ETL, Oracle 11g

Responsibilities:

• Acted as BI Project Lead for E-Business Suite R12 roll out Finance and HCM, including regulatory compliance, quality system, document and change management. Worked closely with business leaders and Subject Matter Experts to set project priorities, budgets and strategy.
• Ensured identification, resolution and escalation of issues, risks and conflicts by mitigating potential risks proactively, which eliminated critical path roadblocks for successful deliveries.
• Performed key role in establishing Reporting Center of Excellence to foster collaboration globally and facilitate optimal utilization of reports and development resources.
• Structured Project Status Reporting to IT leadership and executives to monitor and control project.
• Install and configure and customize Financial Analytics for EBS-R12 Financials, HCM, analyze fit between Kaiser high priority requirements and Oracle BI Financial, HR, and Project Analytics out-of-the-box
• Review project framework, including objective, scope, approach, schedule, as well as review results of pre-meeting report prioritization exercise and validate priorities as a group
• Perform Fit Gap Analysis, created templates to prioritize the reports
• Customized prebuilt repository as per the requirements and created reports and dashboards
• Responsible for the day-to-day maintenance of the application systems in operation, including tasks related to identifying and troubleshooting application and data issues and issues resolution or escalation
• Administered OBIEE11g, Informatica environments with respect to change management request and incident controls.
• Migrated Informatica code across environments using code migration techniques.
• Performed deployments for OBIEE in Multi User development environment
• Provided proactive technical support for OBIEE, Informatica ETL end users, which includes performing detailed investigations to identify root causes/fixes for complex issues
• Analyzed ETL failures and interact with Development team for debugging and troubleshoot production issues. Respond to critical Informatica outages or issues
• Partnered with Delivery Management team to ensure a smooth transition from enhancement and project teams to ensure that service level agreements are met
• Trained new resource and team to absorb complexity of System for global support and administration.
• Communicated the status of all production problems and upcoming maintenance and release activities to business partners, stakeholders and upper management.

Confidential

Solution Architect

Technologies: Oracle BI, Informatica ETL, PeopleSoft 9.1, Oracle 11g

Responsibilities:

• Acted as Solution Architect for multiple divisional portfolio applications, including BI - OBIEE, Informatica ETL, Payroll for North America with GL & Time and Labor integration, Finance GL, integration processes between PeopleSoft HCM and Finance system, system configuration, data conversion, BI Publisher, custom interfaces with third-party benefit providers, document and change management. Worked closely with business leaders and Subject Matter Experts to set project priorities, budgets and strategy.
• Lead the functionality fit/gap analysis and solution design for implementation of Business Analytics using OBIEE/OBIA reports and dashboards for Attestation (Compliance), Grants, Research Finance, General Ledger Analysis, Income Statement, Supply chain Analysis and FTE subject areas to meet the requirements of the client.
• Provided and created user training using Oracle UPK to use OBIEE reports and dashboards

Confidential

Solution Architect

Technologies: OBIEE, OTBI, OBIA, Informatica ETL, Fusion Applications PPM, PeopleSoft HCM

Responsibilities:

• Managed and delivered Oracle HealthCare Analytics product solution by customizing the pre-built out of the box Data Warehouse and analytics to meet the business/functional requirements and promoted to QA/Production for the clients of oracle.
• Performed the fit gap analysis and collected the requirements, analyzed the requirements and customized prebuilt Informatica mappings and OBIEE repository for Fusion Applications PPM Pillar to add new functionality which is specific to this client like cost by task structure, report showing my estimate to complete and estimate at complete, want to see who has charged to my project for the first time, List of Invalid Transactions against my project and to compare authorized funding to the budget, actual cost actual cost plus commitments and forecast, etc.
• Layout the strategy, standards and architecture for the state of South Carolina Health and Human Services implementing Obama Care based on the toolsets purchased from oracle software (BI Publisher, OBIEE, Siebel 8.2.2, and PeopleSoft 9.1). Worked with Oracle ON Demand to get the installation and configuration done on oracle Linux 5.7.
• Performed ETL to load the data into Warehouse. Created OBIEE Repository and created analysis and Dashboards for enrollments, Disenrollment’s, call center, Plan Summaries.
• Created BI Publisher Reports/Documents for Child Care Assistance, Food Assistance and Cash Assistance.
• Liaison between oracle support and the client to manage and escalate the service requests related to product bugs and issues.

Confidential

Senior Consultant

Technologies: Oracle BI, Informatica, MDM, Siebel, PeopleSoft

Responsibilities:

• Responsible for Architect, designing, development, deploying, and maintaining Data Warehouse and BI Solution for Healthcare and Life Sciences engagements (Clients: WellPoint, Gilead, Agilent and South Carolina Health and Human Services )
• Analyzed and gathered business requirements for the data ETL process. Layout the strategy, standards and architecture developed, tested, and deployed the solutions utilizing Oracle BI
• Facilitated the development and management of key performance indicators (KPIs) dashboards to track, measure and improve performance

Confidential

Senior Consultant

Responsibilities:

• Create d a roadmap s for a HCM/CRM /Higher education system s and help the client standardize business capabilities across various departments and stakeholders
• Facilitated discussions and wrote business use cases, detailed business requirements.
• Analyzed requirements to determine the scope of the projects. During this process, individual requirements were analyzed and extracted the metrics and dimensions.
• Analyze Design and Create Conceptual Models, Logical and Physical Designs for effective Data Warehouse resulting in profitable Business Intelligence solutions
• Designed Logical and Physical Data Models for ODS, EDW by using best practices and Data Warehouse Methodologies and modelling techniques
• Defined and mapped ETL Processes using SQL Server SSIS to source data from disparate sources and load into target Warehouse
• Documented the design so as to make power users understand the data model to do ad hoc reporting
• Designed in-house training material on Data warehouse, Business Intelligence to train the client resources.

Confidential, Irwindale, CA

Sr. BIDW Analyst

Responsibilities:

• Worked closely with the BI manager, business leaders, functional teams and participate in end user meetings to understand facilitate, scope, translate business requirements and create project deliverables.
• Research business processes and data structures within source systems as a function of system design.
• Created project plan, BRD, Diagrams, flowchart, functional and technical specifications and responsible for designing, developing, testing and deploying reporting and data architecture for BI solution.
• Identified and Understood different types of enterprise data (Sales, Orders, Finance, and inventory) from the data lifecycle from a database to a report and did analysis based on the available data, and user/data steward meetings, which includes sources of data, forms of data and ways of manipulating data in Business Objects applications.
• Designed high level design document for 2 Business Objects Universes to “support Customer Support Business Unit”, Resource Management/Strategic Management Metrics.
• Provided business benefit by standardizing the common language for Report users, Designers and System Administrators to communicate with Data Managers

Confidential

Business/Data Analyst

Responsibilities:

• Performed business analysis and data analysis to identify BI solution requirements by interviewing business users, analyzing processes / operations, establishing solution objectives, prototyping solution, and preparing specifications.
• Functional (High Level) design for a new Warehouse called 1-800-medicare Data Warehouse (For CMS-Centers for Medicare and Medicaid services), and a Siebel data warehouse (Stand Alone) which is called NGD (Next Generation Data Warehouse). Data was provided by Centre Vu management system.
• Prepared Interface Specification to provide a detailed description and understanding of the source data interfaces and how they are related to other sources within the data warehouse.
• Defined standards and reusable approaches which benefit multiple cross-functional Projects.
• Created test plan and Unit Test Case Traceability Matrix and tested the validity of the data in warehouse.
• Followed CMM Level 3 best practices of designing and building data warehouse techniques from Architecture/High level design to detail design.

Confidential, Fremont, CA

Data Analyst

Responsibilities:

• Act as consultant and subject matter expert to external customers.
• Liaison between business units and IT, ensuring the user receives a system and/or enhancements that meet the business objectives.
• Interview business users for functional and business requirements for system.
• Analyzed the source and target systems, gap analysis met with various levels of users in various business units to define the requirements and worked with the project managers to give a high level design. Created data translation and migration plans. Interacted with the business community to explain the migration plans and get approval.
• Created system documentation for users.