SUMMARY:

• 17 years of experience in Business Intelligence, Business Analyst, Scrum Master, Data Warehousing and various relational database management systems and Tableau Qualified Associate, QlikSense, Qlikview, SDLC, Confluence, JIRA, Agile Methodology, Waterfall.
• Expert in business intelligence /Reporting toolsets, Metrics, SQL queries, Excel, SQL server, Oracle, Confidential InfoSphere/DataStage, SAP HANA, Business Objects, Microsoft Power BI Desktop, Crystal Reports, Tableau, OBIEE, Spotfire, MicroStrategy / reporting tools, data architect and develop data models, ETL tools/packages, OLAP cubes, and reports utilizing, Microsoft Power BI Desktop, Qlikview, QlikSense, Power Query, Informatica, Oracle Primavera, API Management & DB2, Oracle, Microsoft SQL Server, MySQL, Quantum, TriTech (CAD), Versadex RMS, Versadex MDT, Versadex and VisiCAD Mobile/CAD, DMAV, CAD System, Quantum, Inventory Management.
• Experience with widely successful Agile techniques: User Stories, ATDD, TDD, Continuous Integration, Continuous Testing, Pairing, Automated Testing, Agile Games - Applicable knowledge of the technologies used by the team. Configure, maintain, enhance and upgrade the JIRA, Service Desk, Confluence, JIRA workflows, schemes and related Add-In components.
• Arranged daily stand-up meetings, facilitate meetings, schedule meetings, demo and decision-making processes in order to ensure quick inspection and proper use of adaptation process. Agile practices and can coach individuals and interactions over processes tools and agile methodology, Jira Agile and frameworks like Scrum, Kanban, Lean, XP, RAD etc.
• Experience applying a wide variety of well documented patterns and techniques for filling in the intentional gaps left in the Scrum approach(example: numerous Burndown techniques, numerous Retrospective formats, handling bugs,etc) - 9 years experience as a team lead - Excellent communication and mentoring skills. Agile methodology in particular SAFe, DAD or Scrum, Kanban.
• Experience with JIRA, JIRA Agile, Confluence or other similar tools for Agile project management, documentation, Agile. methodology including authoring of Epics, User Stories, Acceptance Criteria, Waterfall methodologies. Construct custom dashboards using various filter types in JIRA and integrate JIRA projects with Confluence Pages and construct Confluence pages, Confidential InfoSphere/DataStage.

TECHNICAL SKILLS:

• Agile Project Manager Product Owner/Scrum Master
• Synergi
• Mobile/Tablet reporting design using SAP BOBJ Mobile
• Oracle
• 10g/11g/12g
• Hadoop
• QlikView
• QlikSense
• Spotfire
• Tableau
• Epic
• SAP Business Objects XI 3.1
• 4.0 & 4.1 architecture
• SAP BO 4.0 to 4.1 upgrades
• DBNetGrid
• SAP Lumira & Design Studio
• Jaspersoft
• SAP NetWeaver BW 7.0
• 7.3 & 7.4
• Flash CCS 6
• SAP HANA
• SAP Data Services
• Informatica
• Web Intelligence
• QAAWS
• Office365
• MS Project Server/SharePoint
• Infoview
• Data Stage
• Confidential Infosphere Data stage
• Oracle Hyperion Essbase Planning
• Camtasia Studio 8
• Oracle Data Integrator and other ETL tools. Office365
• Microsoft technology stacks (SQL Server Enterprise
• SSIS
• SSRS
• SSAS
• Power View
• Power Pivot and SharePoint). Primavera
• MS SQL DBA and SQL scripts
• Advanced Microsoft Office Tools
• Project Management and Quantum
• Control Administrator
• SAP Explorer
• Analysis Office/OLAP
• Lumira and Design Studio
• Cognos Power BI
• Tabular
• PowerPivot
• SharePoint
• Power View and Excel Services
• Administrator/Business Intelligence Architect
• Enterprise Resource Planning (ERP)| Agresso
• ADP
• Epic
• Confidential InfoSphere/DataStage
• Lean Six Sigma
• JIRA Agile
• Confluence
• AllScripts QuickBooks
• Microsoft Dynamics ERP
• Databases and data warehousing concepts (table joins
• Type-2/SCD/journaling foreign keys. Agile methodologies (Scrum
• Kanban
• Lean
• XP
• RAD etc.). Agile frameworks such as Scaled Agile Framework (SAFe)
• Large Scale Scrum (LeSS)
• Quantum
• TriTech (CAD). Disciplined Agile Delivery (DAD) with ability to guide the customer organization on the right path for Scaled Agile adoption and maturity.

PROFESSIONAL EXPERIENCE:

Scrum Master

Confidential, Austin, Texas

Responsibilities:

• Advanced scripting and ETL, data modeling and working with large data sets. Design, build, deployment and support of QlikView / QlikSense, Crystal Report, DBNetGrid applications; QlikView / QlikSense migration is a plus and use of complex Qlik functions and developing most optimal scripts, front-end design and Visualization best practices. Development of QlikView/Qliksense reports, dashboards, building semantic/data models for adhoc reports, QVD generation etc using Qlik View/Sense.
• Lead the team on how to use Agile/Scrum practices and values. Guide the team on how to get the most out of self organization. Guide the team on self organizing to fill in the intentional gaps left in the Agile/Scrum frameworks. Experience with software development methodologies and practices (SDLC, Agile, Scrum, Waterfall, etc.).
• Collaborate with the key stakeholders to develop the BI (Business Intelligence) processes, strategy and analytics roadmap for Cetera Organization. Outline specific project plans and milestones for BI & Analytics initiative. Work with technical and business teams to define appropriate technical solutions and build reporting and meta-data models to support strategic data initiatives.
• Proactively communicates and collaborates with project team members to analyze business needs and deliver the following artifacts as needed: (Business Requirements Document, Use Cases, Traceability Matrix). Strong analytical skills required, including a thorough understanding of how to interpret customer business needs and translate them into unambiguous business requirements.
• Responsible for sprint planning, product demos, retrospectives, and team metrics. Educate and support the team throughout the agile transformation process. Provide hands-on team guidance, support, and coaching in close cooperation and collaboration across all roles and functions, to facilitate increasing maturity at a sustainable pace. Support the Agile team in their development, playbook creation, and in establishing consistent best practices.
• Modify data flow processes and extract/transfer/load (ETL) processes Develop reports and dashboards using BW and Business Objects reporting/presentation/visualization tools (BEx Analyzer, Web Intelligence, Design Studio, Analysis for Office, Lumira), Qlikview, QlikSense, Microsoft Power BI Desktop, Tableau, DBNetGrid, CADs system, DMAV, SQL, Oracle, Microsoft Project, Visio, Office Tools, and SQL Management Studio, complex SQL queries, Stored Procedures, knowledge of Master Data Management and configuration, testing, documentation, training and implementation.
• Assess the Scrum Maturity of the team and coach the team to higher levels of maturity, at a pace that is sustainable and comfortable for the team. Remove impediments or guide the team to remove impediments by finding the right personnel to remove the impediment. Building a trusting team, with an emphasis on problem solving. Facilitate getting the work done without coercion, assigning, or dictating the work.
• Facilitate discussion, decision making, and conflict resolution. Assist with internal and external communication, improving transparency. Support the Product Owner, especially with respect to grooming and maintaining the product backlog. Provide all support to the team using a servant leadership style whenever possible, and leading by example. Coordinate with SME team to finalize requirements (define scope, solution, timelines & efforts) and submit proposaland finalize the requirements with business users by negotiating the feasible things.Convert requirements into software specifications.
• Translate business and data requirements into Logical data models in support of Enterprise Data Models, OLTP, Operational Data Structures, optimizing complex SQL queries and Analytical systems; Ensure data design follows the prescribed reference architecture and framework; Ensure design reflects appropriate business rules, and facilitates data integration, data conformity and data integrity; Ensure data structures are designed for flexibility to support future business needs and enhancements on Confidential applications like Versadex, DMAV, CAD reporting tools and also help with conversion of reports from DBNetGrid and Crystal reports to Qliksense reports and documentations.

Business Analyst / Tableau/BO/Qliksense & MS Power BI Desktop Developer

Confidential, Houston, Texas

Responsibilities:

• Quality Assurance & Business Process Improvement: Perform quality assurance and business process improvement activities in support of upstream business (Reservoir management, Facility Well an Completion, Equipment Master and Placement Data, Geology Manager, Field and Reservoir, Cost “Financial Reporting Line Item”, Material Sample, Surface Facility & Permits, Land & Lease and Document). Work with business partners to identify data reporting, systems or processing improvements. Provide project support by documenting business requirements. Identify business needs. Analyze workflows and existing processes/systems. Perform business analysis such as documenting business requirements, create use-cases and functional specifications and spearhead the effort required to develop those documents. Understand business requirements and reporting needs. Perform data analysis to ensure on-going data integrity and quality. Contribute to overall data warehouse/data mart design efforts.
• Effectively leads the elicitation and documentation of system requirements and solutions into work products. Proactively communicates and collaborates with external and internal customers to analyze information needs and requirements to deliver system artifacts as needed.i.e. Functional/system requirements, use cases, GUI specifications and Business Rules.
• Utilizing Power BI Desktop, power Query and help business users to generate custom reports with data pulled from the desktop and Data Warehouse. Support users to analyze data in their business processes and help them to prototype IT processes to improve the efficiency of their workflow.
• Analyze data to identify deliverables, gaps and inconsistencies, schema design and Dimensional data modeling, maintenance and scheduling of Tableau Data Extracts using Tableau Server and the Tableau Command Utility. Building web applications using Tableau Javascript API, sizeable web-based analytics project and Analytical and BI reporting with Tableau.
• Provides guidance on Test Scenarios and reviews Test Cases and ensures coverage of testable requirements. Collaborates with Test Leads and subject matter experts to establish the Testing Approach including usability and performance needs’
• Responsibilities include generating high level, detailed system requirements, developing epics / stories for Agile software development, and creating / grooming backlogs related to projects in collaboration with the product owner. Articulating and documenting user system requirements, proactively collaborating with product owners to ensure successful implementations align with business processes and conducting joint application design sessions. Developing and interpreting data flow diagrams and making recommendations concerning screen flows, process flow and reporting needs.
• Design, develop, test, and deploy dashboards, reports and ad hoc analytics utilizing a mix of BI tools, scripting as required, APIs for seamless end user experience. Work with the Technical Architects and PMO to articulate tasks, risks, dependencies and mitigation plans on all environments (Dev/QA/UAT/Perf/Prod). Support documentation and review of work product / deliverables for quality, progress and escalate project risks and issues to PMO and TPM.
• Use Tableau Server to publish reports online, clean and merge data in data files from all data sources — to be used in Tableau, Work directly with Quality Assurance associates to ensure all deliverables are accurate and of the highest quality and prepare data sets for various internal and external practices and products. SharePoint or a web service or a website with a Power BI dashboard integrated and manage testing and production database environments.
• Business Objects migration using Import Wizard, Report Conversion tool, Publishing Wizard, building Universe using Universe Designer, building reports and Business Objects (Web Intelligence), Central Management Server (CMS), Central Management Console (CMC), Central Configuration Manager (CCM), Auditing, Performance Management. Create prototype, ad-hoc and regular reports that can be shared internally and externally summarizing and benchmarking relevant data and to meet operational and performance reporting needs. Develop metrics, scorecards, dashboards and key performance indicators (KPIs).

Business Analyst & Reporting / Scrum Master

Confidential, Houston, Texas.

Responsibilities:

• Works with the business to elicit high-level requirements and capture business needs and determines operational objectives by studying business functions, gathering information, and evaluating output requirements and formats. Work directly with business owners to define requirements (epics and user stories). Manage, negotiate, and coordinate with technology, and business stakeholders on prioritization of tactical and strategic technology initiatives, as well as monitor the entire project process.
• Identifies solution interdependencies and data requirements in partnership with architects and developers and research data-related questions by querying data (SQL and SQL derivatives) in enterprise data warehouse and “data lake” to determine if data meets needs, answer business questions, validate data quality, and understand relationships. Converts business requirements and specifications into Tableau presentation and data layer application solutions through effective design, coding and testing to enable and support managing operating systems related to inventory, cycle time, quality, and productivity visualizations.
• Implementing new ETL Workflows, data source tables, integrating systems, enhancing current ETL Workflows, and Business Intelligence dash boards / reports. Work closely with business stake holders to further enhance the data warehouse / business intelligence environments to meet operational objectives and training.
• Define relevant metrics that help the program see how they are doing. Build trust with the business IT or other Divisions and throughout the organization & perform ongoing assessments of the teams' Scrum maturity to inform ongoing support decisions. Advise on dependency management techniques between internal teams and third parties, release managers, or between Agile teams. Quickly establish collaborative partnership with key stakeholders and build trust to ensure leadership buy-in across both Business and IT & foster speed, innovation and encourage continuous improvement.
• Quality Assurance to help and develop testing modules and overall User Acceptance Testing (UAT). Work with the business users to understand schedules and priority fixes. Create and Modify Pivot Tables, Data Manipulation, Creating Data Tables, Creating Charts, Filtering. Managing, configuring and supporting core financial and logistics systems functions (GL, AP, AR, budgeting, T&E, procurement, P2P, WMS, CPM) in enterprise systems such as Synergi, Infor, Agresso, Serenic, Epicor, Sage, Oracle, SAP.
• Interfacing with ERP SAP for source meta data to populate SharePoint/GLSoft lists for management of records as a case, e.g., contract case management with all relevant records associated with the contract. Working with the latest Tableau Server version, its Administration and the Maintenance. Worked with Extracts, Live datasets, managing access privileges and Tableau SDK architecture. Build and prototype dashboards to provide insights into the operations of a business function. Develop rich interactive visualizations integrating various reporting components from multiple data sources.
• Design and create visualization's using Tableau to make data actionable and facilitate decision making for the business users • Design and create dashboards using Tableau. Ensure the quality of each dashboard, data refresh and adhere to a regular refresh and dashboard publishing schedule along with the ability to manage the creation and delivery of additional dashboards/metrics to the users. Troubleshoot Business Objects Reporting issues. Work with internal support team to resolve difficult issues as needed.
• Support of SAP financial system modules including COPA, globally, in support of financial, legal, and business requirements. Works with regional and global Finance Directors and Controllers to improve global synergies. Review data models for appropriate key data sources. Recommend best practices around extracting data from sources as needed. Analyze requirements for creating semantic layer using SAP Universe, Jaspersoft Domain and Develop Reports, dashboards and embed/integrate with the destination application.
• Activating SharePoint eDiscovery for use as a central tool of the Public Disclosure Officers to search SharePoint, the legacy files remaining on the networked file storage and Microsoft Exchange e-mail for purposes of collecting responsive content and storing as a case in SharePoint to fulfill public disclosure requests. Support and System Administrator for the Agresso ERP, procurement / PO Module and assisting the AP team with invoicing queries and posting of invoices. Writing reports in Agresso including browser enquiries, accelerator reports and balance tables.
• Maintaining Corporate HES&S (Synergi) Matrix, assisting HES&S Coordinator in conducting & monitoring MaraLearn Adviser Surveys to improve team instruction, client support & technical assistance, compiling monthly training reports for supported organizations and drafting VTA documents for HES&S needs assessment process.
• SAP FI submodules (GL, AP, AR & AA).knowledge in CO sub modules like CEA, CC, IO & PCA and integration with FI. Knowledge and experience in migration of different FICO objects like GR/IR, Asset, AR & AP (master data and transactional data) including cutover. Working knowledge in integration of FI with other modules like MM, PP & SD.
• Ensure that Agile metrics are being tracked daily, monitor them for indications of current or potential problems, and help the team find solutions to those problems and teach the use of small user stories, emphasizing how this approach improves code quality. One time effort to map Schema / Application / Data model matrix - Consumer Center Admin, eCollection, eBill, ESS security, eSS ePay, CMS (Speedpay) and release manage (Data Model) on all environment (Dev/QA/UAT/Perf/Prod)
• Qlikview server structure, building QVD, QVW, QVFs, developing & deploying Qlikview reports & services for large organizations. Variety of data formatics to access, import, extract, transform, and transfer or load data. Oracle and/or SQL Server and advanced SQL querying. Proficient working knowledge of Excel, Access and Visio.

BI Technical Analyst III / Sr. Oracle Applications

Confidential, Houston, Texas

Responsibilities:

• Business Intelligence front end applications and directly querying database environments (Business Objects Design Studio, Tableau, SAP Dashboard, Excel Pivot, Sql). Develop reports (routine and Ad-Hoc) using QlikView, Mobius, OnBase, SQL and Excel that are distributed to Executive Sales Management, the Recruiting Sales team as well as to SCI Branch Managers.
• PL/SQL packages/procedures based PROGRAMMING for custom applications, data conversions, and interface development around Oracle EBS modules. Functional production support of Oracle financial systems concentrating in AP and AR.Customize existing Jaspersoft based reports/dashboards and implement new reports/dashboards based on customer requirements and converting Crystal Reports to JReport Reports.
• Transform business needs and requirements into design and implementation of intuitive information dashboards and visualizations. Create BI and data warehouse design patterns, designs, standards, and templates. Transform Crystal Report XML format to Jasper XML format and conversion of reports, converting a Report with Sub-report, converting Formulas with API, jrconverter installed and configuration and also converting report templates RPT/RDL to JRXML/Jasper Reports.
• Support end user of Agresso (Unit4) ideally in a finance or HR or payroll environment and supporting other ERP/Cloud ERP platforms such as Oracle ERP, SAP, Dynamics, and Salesforce. Design, specification, development and deployment of Jaspersoft and Business Objects solutions. Creation of Jaspersoft ad hoc queries, Jaspersoft Reports and Jaspersoft Dashboards.
• Develop SQL/Lync queries to extract complex datasets and metrics from multiple databases/data stores and utilize business Microsoft intelligence tools to build and support dashboards. Operate and maintain multiple Oracle database instances. DBA support of Oracle E-Business Suite 11i and R12. DBA support of 9i/10g/11g/12g databases. Performing month end Oracle AR and Oracle AP sub-ledger close steps including general ledger journal entries.
• Create queries using BEx query designer and work with Variables, Structures, Calculated or Restricted Key figures, Structures etc. Develops or “codes” BI Applications to enhance business decision making capabilities, primarily using Qlikview.Trains end-users on BI Applications and trains other BI Specialists on various BI Tools, including Qlikview.
• Work hand-on and in depth with Business Objects Dashboard, Crystal Report product in order to remediate reports from ground up as needed in support for Rose Hills project. BOBJ/ Design Studio SDK, primarily in Design Studio and Dashboard Design and integrating content with various portals like SharePoint, SAP Portal, BOBJ Content with Universes, BW Queries.
• Business Intelligence/Data Warehouse Data Store design (Data warehouse/Data mart/Operational Data Store) environment. Dashboard Design and Development using Xcelsius Designer and Business Objects Dashboards Design Extracting Tables, creating joins between tables all according to customer requirements on RH project, creating complex reports utilizing multiple sub reports, SQL commands, Tables and Views as the data sources as well as creating parameters, cascading dynamic prompts, formulas, and filters in Crystal Reports.
• Responsible for developing and maintaining high quality reports to support customer requirements. Crystal Reports 2011/2008/XI/10/9/8.5/8, SQL Server 2008/2005/2000, Report writing, build and unit testing, design review, interface build, client optimization/specification analysis, support, training.
• Creates reports containing information from single or multiple source systems using tools such as Crystal, Dashboards, Explorer and Web Intelligence, from low to high levels of complexity.
• Business Objects Universe Designer to create BO universes against BW as a data sources and developing Business Objects reports using Universe and BICS. Lead SAP BI/BOBJ projects from a Systems Integration and technical perspective.
• Design visually stimulating reports and dashboards using established SAP BOBJ reporting tools (Web Intelligence, Crystal Reporting, Tableau, SAP Dashboards, Analysis Olap/Office, Explorer). Analyze functional requirements and assist in the development of detailed BI/BOBJ data modeling and documentation.

Business Analyst / SAP BI/BO Lead

Confidential, Houston, Texas

Responsibilities:

• Analyze legacy USTIL reports to identify redundancies and recommend combined reports or enhancements to improve product performance. Lead the Design of the Reports, Universes (UDT & IDT), Dashboards of SAP BO 4.1 implementation and assist the migration effort from older version of SAP BO to SAP 4.1 implementation.
• Designs and creates data views in SQL and influences decisions regarding infrastructure and back-end data solutions in order to enable evolving analytical needs and creating advanced visualizations and dashboard/reports utilizing Tableau.
• Analyze complex ETL maps, isolate impacts of proposed changes, surgically implement the changes and code and unit test complex Informatica Power Center applications with minimal written specification. Develop applications using facets of QlikView (Set Analysis, VBScript or Jscript for Macros, Scripting for data loads, etc.) and assist maintaining current report & dashboard portfolio.
• Design, develop and deploy DWH and BI solutions using MSBI stack (SSIS, SSAS and SSRS), developing data visualizations using Power BI components like Power View, Power Map and Power Q&A.Develop SQL/Lync queries to extract complex datasets and metrics from multiple databases/data stores and utilize business intelligence tools to build and support dashboards and calculate and aggregate in Power Pivot.
• Function as Qlikview Senior Architect and provide Business Intelligence and analytics Subject Matter Expert (SME) and project technical lead. Monitoring and maintenance of QlikView Server and Publisher. Business objects Migration from BO XI R2 or B/ XI 3.x to BI 4.0 and 4.1 and conversion of universes, reports to newer versions and adopts new tools in 4.x.
• Lead the management of the Business Objects platform that includes: Web Intelligence, Information & Universe Design Tool, Desktop Intelligence, Crystal Reports, Xcelsius, Explorer, Dashboard Manager, and Analysis for Office, Analysis edition for OLAP, Design Studio, CMC and Import Wizard.
• Coordinate and developed Business Objects reports on top of multiple databases, SAP HANA/ECC, SAP BW and non-SAP sources, OLTP/OLAP data sources. Development, planning, coordinating matters related to Report development using Jasper Reports, Ad-Hoc Reports with Data Warehousing and BI solutions.
• Using Cognos reporting tool suite (Report Studio, Analysis Studio, Framework Manager, Event studio, Metrics Studio, Cognos cubes, Cognos SDK). Responsible for defining information requirements and convert them into functional specifications, delivering proper conceptual designs, development, implement and support SAP's Business Warehouse solutions, which include the complex extraction, transformation and loading operational setups, create and maintain DSO's, Infocube and other info providers, establish and monitor process chains.
• Installation & configuration of core BOBJ Enterprise product suite; data Services, information steward and Business Objects suite administration. SAP Business Objects reporting and dashboard, and extraction, transformation, loading (ETL) tools using the HANA in-memory database. Modeling InfoCubes, DSOs, MultiProviders, Master Data, Hierarchies, Navigation/Time-dependent attributes and Transformations with complex Start/End/Expert Routines, Process Chains, Delta/Change Log concepts, DTPs and ETL processes. Perform optimization at different levels like BEx Queries, BO Webi reports, efficient data modeling, BW/BO integration.

Business Analyst \ SAP BI\BO Lead

Confidential, Houston, Texas.

Responsibilities:

• Responsible for maximizing the value of the product and the work of the development team. Owns the business request queue and backlog, business testing, and deliverables quality. Works closely with multiple delivery teams consisting of the people who build the product; e.g. UX, user interface design, software, infrastructure, etc. Balance new features with reactive work such as maintenance, cost/timeline optimization and tackling technical debt. Contribute to the product vision, strategy, and roadmap and are more technology and team facing, working with the business stakeholders and IT development teams to write clear stories and acceptance criteria.
• Facilitating the Scrum process and meetings, maintaining Scrum artifacts, and assisting the Project Manager in project management support capacity. Support the maintenance of the project’s SharePoint repository and meet or exceed targeted billing hours (utilization).
• Creating data connections, creating data extracts and performing data preparation, query optimization, advanced charting techniques, performing standard and advanced calculations Dashboard development in Tableau topology (major components, processes, security features, etc.).
• Design and Develop Quantum (Inventory Management), voice user interface for IVR applications, Genesys Composer, Genesys Voice Portal (8.*, VXML Call Flow, SCXML workflow Diagrams, EServices) and perform post deployment application tuning. Review, analyze application requirements from both caller and client perspective.
• Configures and implementation of Quantum, SAP ECC system in FICO areas of Accounts Payable, Accounts Receivable, Asset Management, General Ledger and Special Purpose Ledger, Cash & Treasury Management, Controlling, Invoice Verification, Purchase Order Variance, Financial Analysis & COPA. Design and develop complex BI solutions using SAP Business Objects including Universes, Web Intelligence, Xcelsius and Crystal Reports. Schedule (where appropriate) the necessary BW objects (e.g. Info Objects, ODS, Info Cubes, Info Packages, Info Sources, Data sources, Extractors, Transfer Rules, Update Rules).
• Creating solutions (using SQL, Excel, Tableau, PowerBI Desktop, PowerView) to help manage the day-to-day responsibilities and enhance existing reports to provide better functionality and analytics for business units. Converts business requirements and specifications into Tableau presentation and data layer application solutions through effective design, coding and testing to enable and support managing operating systems related to inventory, cycle time, quality, and productivity visualizations.
• Develop detailed documentation for SQL infrastructure and reoccurring maintenance activities. Interface with database, entering and retrieving information, and writing queries to produce special reports and manage and maintain MS SQL infrastructure. Designing, mapping, and creating SAP BW Master Data Tables, InfoCubes, Data Store Objects, Data Sources, Multi providers, Info Objects, Virtual providers, Data source enhancements.
• Tableau Server Configuration a plus (creation of users, groups and projects with appropriate permissions) and design and development on BI reporting and analytics. Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Webi Reports.
• Maintains up to date understanding of SQL queries and Crystal Reports technology and recommends new reporting and strategies and procedure improvements to the development team. Design, develop, and maintain reports and analytical dashboards using Microsoft Reporting Services, Crystal Reports and Quantum Control.
• Created reports like Master/Detail reports, Cross Tab reports, chart reports, and drill down. Responsible for scheduling the reports on a daily, weekly & monthly basis. Create and maintain data objects for all BW/BI reporting structures including, but not limited to ODS objects, InfoObjects, InfoCubes, InfoProviders, Extractors, Process Chains, Open Hub, BEX Queries and Business Objects reports.
• Created both dynamic and static dashboards using Xcelsius from SAP and Non-SAP data using both QAAWS (Query as a Web Service) and Live Office. Setup and administer database structures, data elements, and module interaction. Administer technical support to system users to insure timely resolution of database related problems. Responsibility for configuration and maintenance of the SharePoint Server application and supporting database. Installation, configuration, maintenance, upgrades, and management of the SharePoint environment.

SAP BI/BO Consultant/ Data Conversion Analyst

Confidential, Houston, Texas.

Responsibilities:

• Install, configure, and maintain the Business Objects environment and review business requirements and design optimal reporting solutions. Implementing ECC6.0 EHP4, SRM 7.0, SAP installs/upgrades - R/3, ECC5, BW, SRM, Pi/Xi, Netweaver portal. Extraction of data from ECC using the standard content and development of BI Objects like Data source, DSO, Cube, Multi Provider, Open Hub and Process Chain. Developing scalable reports including drill down functionalities, filtering and changing data sets.
• Develop Cross tab reports, Drill up/Drill down reports, Drill through reports, Line charts, stacked charts and Bar graphs and Webi Reports using XIR2 or XI 3.1 that may utilize multiple data providers and universes. Determine and implement appropriate group security for new / changed reports. Support Testing team in developing test plans for reports and deploy BO and Crystal reports and/or universes following standard release schedules and procedures.
• Create and maintain Business Object Reports, perform data analysis to troubleshoot report or data issues, and create reports based on business needs and SQL coding (join, outer join, union, subselect) and PL-SQL. Developing and maintaining the configuration for mobile Apps on the SMP environment, performing all tasks throughout the full life cycle.
• Installing, configuring, testing, implementing, upgrading, supporting and maintaining a Business Objects environment as an administrator. Interact regularly with development organization for the creation and modification of mobile applications. Works with software designers, QA engineers, technical writers, configuration management and infrastructure, as needed, to ensure quality and the successful deployments.

Scrum Master / Business Analyst

Confidential, Sugar Land Texas .

Responsibilities:

• Participate in discovery backlog grooming to maintain a feature / technology backlog and participate in product / feature discovery activities where needed. Work with business stakeholders in creating and prioritizing the product backlog, get detail level of requirements from stakeholders or customers and clearly communicate the business requirements to the development team to connect them with the product and its customers.
• Organize and facilitate project planning, daily stand-up meetings, Sprint reviews, retrospectives, sprint and release planning and other Scrum-related meetings. Track and communicate sprint/release progress via information radiators. Ensure all information radiators are current and broadly available.
• Work with development team to break features into user stories, specifying acceptance criteria for each user story and act as a proxy for the user during development, and answer implementation questions from developers works with UX on design.
• Identify KPIs to measure product/feature success, and ensure that features include work to measure and report KPIs, produce KPI reports and dashboards to keep stakeholders informed and work tightly with development and IT partners and understand what is being build and tradeoff to technical decisions.