Bi Analytics Consultant Resume
Chesterbrook, PA
SUMMARY:
- Successful leadership experience as a highly innovative analyst, technical project manager and cross - functional team player.
- Critical skills in data warehousing, business analytics, road mapping, tool design and overall project execution in multiple industry niches.
- Diverse abilities in requirements identification, market research, competitive intelligence, business planning, ROI analysis and enterprise solutions.
- High-caliber leadership experience in designing and executing multiple initiatives, along with guiding strategic planning and deploying leading-edge solutions, for world-class market leaders.
- Consistent development and delivery of unique applications, detailed reports and comprehensive business plans with a visionary approach; rapid roll-out and support of growth-focused strategies, better customer engagement and more effective customer acquisition & retention levels.
- Confident expertise in writing, organizing, presenting and updating detailed reports, market analyses and business reviews for top executives, professional peers, industry leaders and key decision-makers.
- Key participant in hiring, training, orienting, mentoring, supervising and developing top-notch technical and support staff.
- Self-motivated to achieve maximum productivity, improve IT processes, meet aggressive business objectives and significantly expand corporate influence.
TECHNICAL BACKGROUND:
Processes/Technologies: Agile Scrum, Rational Unified Process (RUP), Rapid Application Development (RAD), UML and SDLC (Waterfall, Spiral).
Software: MS Office Suite, MS Project, MS Visio, Requisite Pro, Rational Rose, Rational Robot, Clear Quest, Caliber RM, EMC Documentum, Oracle Enterprise Suite 11, Crystal Reports, Quick Test Professional, Win Runner and Load Runner.
Languages: C, C++, Java, SQL, VB and COBOL.
Databases: MS Access, SQL Server, Oracle and DB2.
Operating Systems: UNIX, Linux and Win 3.x thru XP.
Reporting Tool: Siebel Analytics 7.x, OBIEE, Crystal Reports, Cognos 6.x, 8, Oracle Discoverer, Oracle Discoverer, Oracle Balanced Scorecard, SAP Business Objects, Pentaho, Hyperion/Oracle Essbase 9.x, 11.x.
ETL Tool: Informatica 7.x, 6.x, 5.x (Power Center and Power Mart).
CORE COMPETENCIES:
- Business Intelligence (BI)
- Tableau
- SQL
- SDLC
- IT Strategy
- Web Technologies
- Systems Analysis
- Data Mining
- Programming
- Data Delivery Lifecycle
- Work Scope Definition
- Stakeholder Relations
- Data Analysis
- Requirements Identification
- Systems Integration
- Project Scope Definition
- Multi-Project Accountability
- Technology Evaluation
- Technical Writing
- Job Costing
- SOAP UI
- Test Scripts
- Enterprise Solutions
- Rational Rose
- Oracle
- SAP Business Objects
- UML
- RUP
- OBIEE
- Siebel Analytics
- Agile Scrum Methodologies
PROFESSIONAL EXPERIENCE:
Confidential, Chesterbrook, PA
BI Analytics Consultant
Responsibilities:
- Responsible for Financial Performance Management (FPM) reporting at this top Healthcare Distributor
- Managing a team of 5 Business Objects (BOBJ) developers responsible for Financial Reporting.
- Created Functional Specification Documents for SAP BOBJ reporting.
- Managed defect triaging and resolution using Maximo.
- Worked closely with Key Business Stakeholders and SMEs to gather Business Requirements.
- Performed data validation for file feed loads in SAP BW.
- Created and maintained QlikView dashboards for various Project Management metrics.
- Worked Closely with Data Governance (DG) group to clarify reporting requirements.
Environment: SAP Business Objects, BW, QlikView, Agile, IBM Maximo, SQL Server, MS Access, XML, HP Quality Center, MS Office, Sharepoint.
Confidential, Philadelphia, PA
BPM Analytics Manager
Responsibilities:
- Responsible for End-to-End reporting on Order Flow through, Affiliate Sales Commissioning and Salesforce data.
- Creating and maintained Performance KPI dashboards for Senior Executives using Tableau and SalesForce.
- Conducted requirement meetings and JAD sessions to gather requirements.
- Managed development efforts for distributed teams across 3 continents (Asia,N. & S. America)
- Responsible for Rally Sprint planning (Agile Methodology)
- Documented User Stories and Managed Defect Triaging.
Environment: Tableau 8.x, OBIEE, Agile, Oracle, Salesforce.com, SOAP, RESTful services, XML, Rally, SQL,HP Quality Center, MS Office, Visio, Sharepoint.
Confidential, Philadelphia, PA
Senior Business Analyst
Responsibilities:
- Responsible for Claims Reconciliation Reporting project that included documenting Functional Specifications creating mockups and performing system and regression tests as part of the Government Programs group.
- Documented Requirements and Specs for the reconciliation reporting as part of Claims records migration project in accordance with Agile Methodology.
- Translated the finished Specs into Mockups for review by executive stakeholders.
- Supported development and test activities for Claims Error Correction Application by documenting User Stories and tracking defects and enhancement requests via HP Quality Center.
- Analyzed CMS MAO and 277 error business rules to ensure that Claims were submitted with minimum rejections.
Environment: Agile, SQL Server 2008, Tableau 8.x, SQL,HP Quality Center, SOAP,XML,MS Office, Visio, Sharepoint, Photoshop CS4.
Confidential, Philadelphia, PA
Senior Business Analyst
Responsibilities:
- Ensure that product releases met quality standards and customer needs by generating SQL queries against data sets.
- Piloted the rollout of the first production data federation platform within CBIG, consolidating and organizing customer data from different sources for over 30 million Confidential users.
- Instituted a unified business logic tracking users across various platforms, regions and time zones, correlating email usage with customer retention for the first time.
- Key participant in improving customer self-service and reducing repair & maintenance calls and service requests by over $3 million annually with a better reporting solution that analyzed click stream data.
- Interacted with Customers and Cross-functional team members to develop iterative solutions in an Agile environment.
Environment: Agile, OBIEE 11g, Oracle 11i, SQL, Tableau 7.x,TOAD, Razor SQL, Composite, MS Office, MS Access, MS SharePoint, Omniture SiteCatalyst, Photoshop CS4 and Linux.
Confidential, Herndon, VA
BI Applications Business Analyst
Responsibilities:
- Closely liaised with different stakeholders within the Enterprise Reporting Applications group at this world-class consulting firm to identify and review a wide range of data sources and reports.
- Initiated group JAD sessions to help developers and SMEs in focusing on technical solutions.
- Coordinated the design and delivery of Hyperion Essbase reports for HR and Finance units.
- Worked in a strict development sprints under the Agile methodology.
Environment: Agile, OBIEE 11g, Hyperion/Oracle Essbase, Cognos 8.3, TOAD, SQL, MS Office, MS Sharepoint, Oracle 9i/10g, HP PPM and HP Quality Center.
Confidential, Atlanta, GA
Senior Business Analyst/Project Manager
Responsibilities:
- Handled vendor selection for a BI/reporting solution.
- Acquired full buy-in from stakeholders companywide for the purchase of Oracle BI software after extensively evaluating different best-of-breed products.
- Efficiently reduced HR reporting times from 3 days to only minutes.
Environment: OBIEE 10.1.3.3.x, TOAD, SQL, PL/SQL, MS Office, MS Sharepoint, Oracle 9i/10g, Crystal Reports XI, HP PPM and HP Quality Center.
Confidential, San Franscisco, CA
Business Intelligence Analyst
Responsibilities:
- Tasked with analyzing market conditions, identifying business needs and reviewing functionalities with different stakeholders at this world-class financial institution.
- Suggested and implemented process improvements and new technologies as required.
- Formulated technical specifications and recommended fraud alert detection metrics.
- Gathered requirements for the migration of a legacy system for credit card information.
Environment: Agile, Siebel Analytics 7.8.4, Informatica 6.2.2,Cognos BI 6. UML, RUP, SQL, Oracle, MS Visio, MS Office and MS Project.
Confidential, San Franscisco, CA
Siebel Analytics/Business Analyst
Responsibilities:
- Closely interacted on and documented different projects with various stakeholders in the E-Business Member Services, Marketing, Legal and IT areas for this leading US healthcare provider.
- Built and led a group of 3 developers and 1 quality assurance tester with a $1 million budget.
- Designed an end-to-end structure from source to presentation for OBIEE; also created new dashboards and reports.
- Thoroughly analyzed and reviewed source structures, leveraging existing hierarchies into the analytic reporting solution.
Environment: J2EE, UML, SQL, Oracle, IBM DB2, Informatica, Siebel Analytics, MS Visio, MS Office and MS Project.
