Professional Summary

• A dedicated Business Process Systems Analyst with over eleven years of experience as a Sr. Business Systems Analyst, supporting Business and Systems Operations.
• Skilled Analyst who can evaluate operational data to understand root causes and recommend corrective actions and improvements.
• Able to successfully handle multiple projects simultaneously, deliver on-time results, under pressure, on budget and in response to shifting priorities.
• Designed and Delivered new training programs to integrate systems and enhance effectiveness.
• 6 years Project Management experience.
• 6 years of experience in all aspects of Business Analytics Applications including analysis, design, development, configuration, customization, validation and deployment.
• Experience developing complex OBIEE reports and dashboards, repository development. Proficient in the use of repository variables.
• Created, modified and administered dashboard reports.
• Utilized OBIEE Delivers Answers for sending real-time alerts via intelligence agents ibots to dashboard for subscribed end users.
• Modified existing dashboard reports, resolved issues relating to performance and data integrity during testing and production phases.
• Participated in design, analysis and requirements gathering sessions with business operations personnel to determine the details for customized dashboard reports and data model.
• Prepared on-the-fly reports to management.
• Experience with Oracle database programming background, OBIEE and Data-warehouse Administration, including data modeling skills and SQL design. Provide support in the implementation of OBIEE components.
• Assisted with the development, and deployment of data warehousing and business analytical solutions.
• Maintain and monitor the data documentation for all data warehouse and reporting formats
• Documented Requirement Analysis and reviewed functional requirements.
• Participate in design and creation of metadata and ETL solutions best practices to assist the reporting process across the enterprise.
• Worked with DBA teams on the ETL process using Informatica PowerCenter for various transactions and loading data from various legacy data sources.
• Assisted with the administering ETL and data warehousing applications and tools
• Knowledgeable in designing Schema using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• 6 years of experience in all aspects of Business Analytics Applications including analysis, design, development, configuration, customization, validation and deployment.
• Assist with the implementation of ETL process to load data into tables using Toad for Oracle ETL Tool .
• Participate in ETL procedures to optimize query performance.

Professional Experience

Confidential

Business Analyst Consultant

• Working with Application Security Administration team to centralize applications to satisfy Auditors and SOX regulations.
• The process involves obtaining current processes, procedures, and configurations from the Application Teams per Application in order to create the appropriate documentation and to enhance these procedures so that the ASA team can perform annual application reviews.
• Create Business Process Models to depict the Application Centralization Processes and Procedures using MS Visio

Confidential

Process Engineer/Business Analyst

• Role as a Process Engineer/Business Analyst, Elicit information from clients to create business requirements and functional requirements for a workflow process Designed, configured and tested the workflow of the SaaS application. Handed that off to Developers for coding and implementing into the development, testing and production environments. Although I was not performing hands on coding, the role also involved identifying and creating the logic behind the correct web service used in conjunction with the application, and working with Developers from a software design perspective. The role also involved troubleshooting data import issues from a Post Production standpoint by looking at the XML data and application configuration issue to identify the root cause for web service anomalies. In addition, worked with the database teams to find solutions for re-engineering tables within the Oracle Data Warehousing environment and determined analytical solutions to meet the business needs to achieve a solid Scorecard report.
• Identified gaps between business needs vs. application functionality provided detailed estimates for technical solutions.
• Owned designs and maintenance of configurations of the SaaS Application and its extensions.
• Performed Technical Configurations pertaining to the workflow processes and workout solutions to meet the application or client requirements business needs.
• Prepared and maintained business and functional requirements Documents including: Technical Configuration Specifications, Business Process Models, Software Design Models, Process Map Workflows.
• Created, maintained, and supported innovative and efficient business solution using workflow processes.
• Involved in consulting with the Business Development Internal and External teams to provide Proof of Concept solutions while designing information on current workflow and suggested scope of solutions for potential client projects and Corporate Strategic Initiatives.
• Participated in reviews of Business Requirements, Solutions Design and Technical Design Documents.
• Provided timely and clear communication to the business and client teams including external business and systems analysts and internal developers, QA testers, trainers, client delivery managers and project managers.
• Managed and enforced Analysis Design specific project deliverables in accordance with project deadlines/schedules.
• Worked on cross function teams with DBA's, Developers and Business SME's to enhance the repositories for the Oracle DB that affected the Scorecard Reports.
• Provided Level of Effort estimates in accordance to defined work breakdown structure and deliverables per project phase

Confidential

IT Business Analyst Consultant

• At Bank of Confidential, within the Lifecycle project that was taking place, acted as part of a team that facilitated the On-boarding of System Applications with a Global Network Team to migrate those applications into SailPoint IQ, which is a Role Based Access Control Compliance and Governance system designed to manage user access across BNY Mellon's enterprise network. These System Application teams comprised of the Application Delegate, Technical Lead, DBA and the Business Management SME user. Since the Business Requirement Phase was already conducted, the team's role was to initiate the Kick-Off of the Functional Requirement - Definition Phase to define the Project Timeline. From the Kick-Off meeting to the deployment of the application, I facilitated each meeting with the Application team, ensuring that the technical specifications were met, which included the establishment of obtaining the proper database credential as well as ensuring the accuracy of the type and format of the file feed for both the development and production environments. Worked with Off-shore IT developers to track and resolve issues to move the process forward. To monitor the progress of these meetings, documented the process, defined Action Item Deliverables and uploaded this information into SharePoint.
• Managed on-boarding of applications throughout the SDLC process into BNY Mellon's certification tool SailPoint, using Project Management skills.
• Collaborated with Developers, Tech Leads, Application Delegates and Business Subject Matter Experts across a Global Integration Network to adopt applications into Identity Access Management system to sell concepts to a broad audience.
• Collaborated with On-Shore and Off-Shore development teams within the development life cycle to resolve database connectivity issues JDBC or Oracle Connectors for both testing and production environments and resolve showstopper issues with the Application's team Database Administrator.
• Worked with application teams to resolve CSV, SQL, Oracle, LDAP and Active Directory file feed issues in preparation for development and production phases within the life cycle.
• Coordinated with team members to update the Development Lifecycle Project model where necessary to align with the phases in the process flow using MS Visio.
• Participated in the creation and modification of detailed functional use cases and UAT template.
• Ensured business requirements were effectively translated into detailed functional specifications, exceeding customer expectations during the elicitation of information for the project.
• Gathered, analyzed, documented and validated the requirements within each phase in the process.
• Served as the principle conduit for managing system requirements between business and software development teams throughout the duration of an on-boarding project.
• Ensured applications proceeded throughout the SDLC in an accurate and timely manner using Project Management best practices.

Confidential

Senior Analyst

• At Verizon, was part of the systems integration team that worked towards the migration of legacy data across three business units. The environment used to facilitate the Business Requirements Sessions, the Functional Designing and Technical Specification process, was used via a Joint Application Design type environment.
• Responsible for defining and performing UAT tests regarding the Work Ticket Creation, Work Ticket Dispatching, creating an In-House Call Center, Creating the specifications of the Mobile and Website Application as well as the Drafting of Report Requirements using the SSRS and Oracle BI Publisher that tied into the Work Ticket Management.
• Managed OBIEE Dashboard Reports and Business Objects Dashboard Reports . After defining and approving steps required for the program, moved forward with the migration of the data from these legacy systems using Toad for Oracle working with the DBA team for upload into the Oracle Platform.
• Oversaw a Data Issue Tracker Database System, holding meetings with the IT Development, Systems and Business Teams to resolve Root Cause System and Enhancement Issues. In order to manage the process of migration to development, testing and production environments, our team used Wireframe Diagrams and MS Visio to represent process flows that showed the Process Modeling structure. To manage Project Timelines, used a Master Spreadsheet taken from the JAD Communication Matrix portfolio , Roles and Responsibilities and a Traceability Matrix Spreadsheet to monitor the deliverable of each functional requirement. After deployment, worked with Cross Functional teams with the different Area teams as part of maintaining the integrity of the processes as well as to help define new business requirements and be a part of system integration updates. I developed clear and concise training materials, determined training process and coordinated training delivery to all intended End Users of the Corporate Real Estate Support System CRESS to ensure system functionality with End Users. Similarly, I created training materials for new system enhancements from the creation of Release Notes pertaining to system enhancements. Additionally, regarding the Operation Work Process Manual OWPM document, I managed the document updates relating to new procedures and process flow charts as the sole operational document across this enterprise.
• Created, modified and administered dashboard reports.
• Utilized OBIEE Delivers Answers for sending real-time alerts via intelligence agents ibots to dashboard for subscribed end users.
• Participated in design, analysis and requirements gathering sessions with business operations personnel to determine the details for customized dashboard reports and data model.
• Modified existing dashboard reports, resolved issues relating to performance and data integrity during testing and production phases.
• Prepared on-the-fly reports to management.
• Provided support in the implementation of OBIEE components.
• Developed, implemented and deployed data warehousing and business analytical solutions.
• Maintained and monitored the data documentation for all data warehouse and reporting formats
• Handled Requirement Analysis and reviewed functional requirements.
• Participated in ETL procedures to optimize query performance.
• Used SQL to extract specific on-the-fly reports for call center agent evaluation performance, which includes data from national database using Oracle Business Intelligence Enterprise Edition OBIEE , Access and Excel to assist in the analysis of achieving a 95 customer satisfaction rating.
• Worked with SAP Business Objects, SQL, Oracle Business Intelligence Suite Enterprise Edition OBIEE and Access objects to create concise, useful local reporting information for real estate field teams, which includes coordinating development of standard reports, summaries and other processes to effectively manage Work Request Tickets WRT .
• Involved in Corporate Real Estate's transition to the SAP environment.
• Participated in processes and procedures within specific outlined timeline to design enterprise solutions tailored to meet enterprise systems for the organization.

Confidential

Analyst - Operations

• At Verizon Wireless, played more of a Reporting Analyst role and used MS Access, MS Excel and SQL Server's SSAS, SSIS and SSRS to create reports Versions used: 2000, 2005, 2008 R2 .
• Used Tririga Facility Management Database in conjunction with a SQL Server, created ad-hoc reports in addition to modifying canned reports from Tririga, by pulling in tables from the SQL into MS Access to create a High Level Manager/Director Trend Analysis report output to Excel.
• Created complex queries within MS Access and also created some user functionality with Excel via form controls to manipulate the output via macros.
• Used SSIS to create FTP packages to connect to vendor site and retrieve data used in Card Access Database via SQL Server. Created a Security Card Access database with MS Access, pulling tables via ODBC from SQL Server. Created SSAS cubes for specific tables within SQL Server that were used to create report using MS Access.
• Participated in creation of an In-House Call-Center using SQL Server as the back end for Rockwell Call Center Management System. Created reports via MS Access on Call Center Agent Performance and Call Handling Metrics that were used in conjunction with a Scorecard Metrics report, which were matched against KPIs to evaluate performance.
• With intro of PowerPivot as an add-on for 2010 office environment, created trend reports to interface with MS Sharepoint.
• Liaison between end-users and IT technical support group ensuring system integration and functionality.
• Created and customized analytical and interactive trend reports to support area leads with budget decisions and vendor discussions.
• Manipulated and analyzed large complex data sets using Microsoft SQL, Excel, Access and Visual Basic, including responsibility for maintaining the integrity of several systems.
• Managed the New York Metro facility and security Card Access databases.
• Performed User Acceptance Testing UAT on new and existing system enhancements. This relates to working one-on-one with IT developers, testing the functionality of new processes identifying and resolving coding issues
• Created specific Customer Satisfaction Survey CSS metrics reports to assist director teams across the National Verizon Real Estate Footprint by pulling data from the master call/contact center database and compiling, filtering by manager/supervisor to identify trends.
• Created Average Handle Time AHT peer-to-peer recognition program award report using the Rockwell Call Management Solution system to identify agent performance.
• Supported the implementation of the Tririga Facility Center Enterprise program and implemented a financial/statistical tracking system, which provided analysis reports in relation to Work Request Tickets.

Technical Skills

• OBIEE Reports/Siebel Analytics
• Systems Integration, Data and Analysis
• Business Objects and Crystal Reports
• Software Development Life Cycle Methodologies
• Reporting Services SSRS
• Data Warehouse Methodologies
• ITIL Best Practice Methodologies
• Waterfall/SCRUM Methodologies
• Microsoft Access, Excel, Visio Office Suite
• Basic Knowledge - XML/XSLT
• Languages: T/SQL, PL/SQL
• RDBMS: Microsoft SQL Server, Oracle, Access
• Web Development: i-net Developer Level 1