PROFESSIONAL SUMMARY:

• 18 years of experience in Business Intelligence Data Architect, Data Analytics, Business Analyst, Scrum Master, Data Warehousing and various relational database management systems and Power BI Qualified Associate, Power BI, MS Power Apps, MS Flow, Spotfire, QlikSense, Qlikview, SDLC, Confluence, JIRA, Agile Methodology, Reservoir Management, OpenLink, ITIL, Waterfall, Drupal, BMC Remedy, BMC Remedy ITSM: Incident Management Process Flow, SQL, Microsoft Server, Oracle, Hadoop Big Data, Apache, Nginx, SSAS Cube Architecture and Design & Advanced SSIS Package Design Patterns and Configurations MySQL and Redis, WhereScape RED data warehouse automation.
• Knowledge of datalake and data platform technologies and vendors (i.e. Hadoop/HDFS/Spark/Impala/AWS/Azure etc.)
• Very strong knowledge of Agile best practices, concepts, and tools such as Team Foundation Server (TFS), Visual Studio Team Services (VSTS) and Kanban board. And also knowledge understanding differences between VSTS and TFS and migration.
• VSTS and Team Foundation Server (TFS) both provide an integrated, collaborative environment that supports Git, continuous integration, and Agile tools for planning and tracking work.
• Expert in business intelligence /Reporting toolsets, Metrics, SQL queries, JQuery, Excel, SQL server, Oracle, Cassandra, Confidential InfoSphere/DataStage, SAP HANA, Business Objects, Microsoft Power BI Desktop, Crystal Reports, Tableau, OBIEE, Spotfire, D3 visualization library, 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, HTML5, CSS3, API Management & DB2, Oracle, Microsoft SQL Server, MySQL, Quantum, TriTech (CAD), Versadex RMS, Versadex MDT, Versadex and VisiCAD Mobile/CAD, DMAV, CAD System, Quantum, IT Security Architects, Inventory Management, Ariba, ASP.NET.
• Comprehensive understanding and previous management of extended data supply chain for Directional Drilling, Completion Services, Wireline, Drilling Fluids or Completion Fluids and In - depth knowledge of Offshore Drilling and Completions through the development of Model Contracts (Wireline, Drilling Fluids, Completion Fluids, Completions Equipment and Stimulation).
• 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, Confidential 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, Inventory and Material management / Maintenance, Asset Management, Upstream Reservoir Management.
• Experience with JIRA, TFS, VSTS, 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.
• Azure Data Factory, Stream Analytics, Azure IoT Services, Azure Data Lake Storage, Azure Data Lake Analytics, HDInsight/ Hadoop, Azure Data Warehouse, Statistical methods, and Advanced Analytics. AWS Redshift, S3, SCF Scripting, EMR AWS Redshift database (performance tuning, clustering, data allocation, etc.). Redshift concepts like DISTKEY, SORTKEY, COMPRESSION, VACUUM etc.
• Work closely with Business Product Leads to solicit visualization requirements, recommend changes, create prototypes, demo prototypes, and provide thought leadership for Advance Tableau capabilities and frameworks. Demonstrated ability to produce Executive Level Tableau Dashboard visualization for Senior Management. Tableau SME with strong expertise in Tableau visualization / Reporting on complex projects.
• Experience with advanced analytics with products like Azure, Amazon WS, Confidential Watson or Google. Strong Experience in Dimensional Modeling (Star Schema, OLAP Cubes, Advanced Fact and Dimension Table Techniques, Slowly Changing Dimensions, Bus Matrix Mapping). Experience in AWS Redshift Data Warehouse.
• Experience with AWS services such as S3, data pipelines, SWF, Lambda, RDS, EMR, etc.
• Facilitating good communication with everyone. Tracking sprint metrics and analyzing prior track records to make small, iterative improvements.
• Developing and performance tuning large BW standard and custom extract processes, BW data modeling, creating Business Warehouse Remote Cubes, Multi-Cubes, ODS Objects, InfoCubes, Update Rules, Info Sources, Transfer Rules, Start Routines, and Info Set Queries.
• 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.

SKILLS:

Reservoir Management, Agile Project Manager Product Owner/Scrum Master, Synergi, Mobile/Tablet reporting design using SAP BOBJ Mobile, Oracle, 10g/11g/12g, Hadoop, MS Power BI, 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, PowerQuery, Power View, Power Pivot and SharePoint). Upstream Reservoir Management, 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, MS 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, TFS, VSTS, 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. Polybase, Data Lake, SQL Data Warehouse, Azure Cosmos DB, SQL Azure (SQL, T-SQL, Sprocs, Views, Row Based Security). Huge BI Reporting Tool Experience (PowerBI “Pivot tables, Power pivot etc.…”, MicroStrategy, Cognos, SSAS, Tableau, Qlikview & QlikSense SAP, Microsoft Spotfire, Jaspersoft etc..). ETL development experience using a major ETL tool (SAP, SSIS/BODS/SDI, Informatica, Excel (Pivot tables, Power pivot etc.…)Hadoop, Confidential, Oracle, Data Migrator (IBI), Cognos Data Manager, Jaspersoft ETL, Talend Open Source Data Integrator, etc..)

WORK HISTORY:

Senior BI/Data Analytics Lead

Confidential, Houston, Texas

Responsibilities:

• Works directly with the senior Confidential Delivery leaders, SMe & stakeholder, boundary partners, and other internal business customers to understand reporting requirements, obtain data, and execute production of regular and adhoc reports in a timely manner with a high degree of integrity and accuracy.
• Manage analytics projects, prepare and deliver presentations with complex analytical concepts. Comfortable presenting to the business and upper management and
• Ability to lead and maintain pipelines in Azure Data Factory - understand best practices of bringing on-prem data to the cloud. File loading, compression, parallelization of loads, Azure Data Lake Analytics, HDInsight, Azure Datawarehouse, Azure Data Factory, U-SQL, Stream Analytics, HIVE, Power Shell, Event Hubs, Python/ C# coding, Azure- Hadoop DistributionsAzure Data Factory, HDInsight (PaaS and IaaS services), MongoDB, Elastic search, Azure security on cloud, Kafka, Apache Spark and Scala, Programming Language -Scala, PowerBI, office 365, Azure PowerShell and Agile / DevOps principles, Visual Studio, VSTS/TFS and SQL Management Studio.
• Manages the planning and delivery of bid data platforms and solutions by leveraging Azure Big Data & Analytics PaaS Services including but not limited to - Azure Data Factory, Azure Data Lake Store, Azure Data Lake Analytics, Azure Storage, Azure Cosmos DB, Azure SQL, Azure DW, Azure Analytics Services, Power BI, SpotFire, Qlikview/QlikSense, SAP BO and Tableau. Advanced understanding of TFS 2015+/VSTS Build, Test, Release tasks and the CI/CD pipeline.
• Advanced Scripting capabilities in: PowerShell, SQL, TFS APIs, XML, JSON, REST OData.
• Create tables, views, stored procedures, indexes, SSIS packages, and SQL Agent Jobs in SQL Server and Azure SQL, AWS S3 DW to support ETL processing and end user reporting. Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations. Configure and maintain SQL database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
• Performs complex systems development and design work in Microsoft Azure that may include logic design, I/O design, model formulation, computer architecture analysis and design, and analog or digital systems engineering. Experience using Azure Migration tools such as Azure Site Recovery Manager, Platespin or AppZero. Expert level experience with Roles and Features of Microsoft Windows Server including Active Directory, Clustering, DHCP, Files Services and others.
• Design, build and deploy integrated BI solutions (Dashboards, Standard Reports, ADHOC Self Confidential, Scorecards) using industry BI Tools like Power BI, Spotfire, SAP BO/HANA, QlikSense, Tableau & HIVE, Openlink, AWS and Azure that have direct impact on enterprise strategy. Develops functional requirements, translates to technical requirements, develops and maintains technical designs, specifications, views, data structures, dashboards, reports, data mapping, data flows, SQL queries and other project.

Sr. Business Analyst/Solution Architect Lead

Confidential, Austin, Texas

Responsibilities:

• Data Protection, Security & Controls, advanced SQL scripting, PowerQuery and ETL, data modeling and working with large data sets.
• Design, build, deployment and support of Tableau, SpotFire, MS Power BI, QlikView / QlikSense, Crystal Report, DBNetGrid applications; MS Power BI, QlikView / QlikSense migration 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.
• Expert knowledge connecting Microsoft Azure-based Power BI to various data sources. Design, develop, and support dashboards, KPIs, and reports, sourced from a variety of data sources, using Power BI.Develop complex Enterprise and Divisional level dashboards utilizing the full array of features including DAX queries and strong understanding of cloud migration techniques (on premise to Cloud Platforms).
• 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, Power BI 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.
• Create and manage Tableau sites, projects and workbooks, groups, data views, data sources and data connections and maintenance and scheduling of Tableau Data Extracts using Tableau Server and the Tableau Command Utility. Collaborating with other BI Analysts and Engineers around data/table structures in order to optimize for Tableau Dashboards and other self- Confidential needs.
• 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.

Sr. Business Analyst / Tableau/BO/Qliksense & MS Power BI Lead

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 and 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 and also data lake and perform transformations on the data necessary utilising SQL tool set to feed Power BI reporting/dash boarding.
• 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.
• Analyze, design and develop the backend Extraction, Transformation and Load (ETL) processes using Informatica and custom PL/SQL scripts. Designs, develops, and tests IDQ and PowerCenter mappings, workflows, develops scripts to execute and test mappings and workflows, develops test scripts to ensure mapping and workflow quality. Implements ETL processes for operational Databases, Transactional Databases, Datamart, and Data Warehouses.
• Utilizing Tableau, 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 Confidential 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).

Sr. Business Analyst & Reporting Lead / 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.
• Microsoft BI stack knowledge (SSIS/SSAS, SSRS, PowerB & SpotFire, (SQL and SQL derivatives) in enterprise data warehouse and data lake to determine, 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 and writing advanced SQL queries using SSIS, SSAS, SSRS and PowerBI
• 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.

Sr. BI Technical Analyst Lead / 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.
• Responsible for maintenance and performance of Informatica sessions that load excessively large volumes of data from multiple data sources. Oracle/DB2/ODBC/Flatfile/SFTP/MQ/MySQL/SQL Loader/PLSQL on various schedules ranging from near real-time to weekly batches.
• 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.

Sr. 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 and ability to tell a succinct, meaningful, and actionable story with data using visualization (Tableau, Spotfire, PowerBi, or other visualization tools).
• 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. Develop Workflows, Sessions, Mappings in Informatica PowerCenter (Data Integrations). Develop Data Replication/ Synchronization Tasks in Informatica Cloud (Cloud Application Integrations). Develop Mappings in Informatica Developer (Data Integrations & Data Quality)
• 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.
• 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.

Sr. Business Analyst \ SAP BI\BO Leads

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.