Connie Ramirez Email & Phone Number

Pittsburgh, Pennsylvania, Us

Business Analyst (Contract)Experienced Business Analyst supporting the Site Reliability Center (SRC) at PNC Bank, focused on enhancing system reliability, efficiency, and operational performance. Skilled in data-driven insights, process optimization, and effective communication with cross-functional teams. Proficient in analyzing performance metrics, improving workflows, and documenting key findings to help ensure high availability and seamless operations for PNC's critical systems.Principal Responsibilities • Process Improvement: Work with stakeholders to assess and refine workflows, enhancing automation and streamlining processes using Site Reliability Engineering (SRE) principles.• Documentation and Reporting: Maintain clear, accurate documentation of processes, incidents, and improvements. Generate reports on KPIs, SLOs, and SLAs to monitor SRC effectiveness.• Incident Management Support: Assist in incident response and post-mortem analysis, documenting root causes, identifying preventive actions, and supporting reliability improvements.• Cross-functional Collaboration: Serve as a liaison between the SRC, technology partners, and business stakeholders to ensure alignment on reliability goals and prompt resolution of service-impacting issues.• Stakeholder Communication: Provide regular updates on project status, metrics, and SRC-related initiatives to management and relevant stakeholders.• Tool and Automation Development: Identify opportunities for tools and automation to improve SRC efficiency, reliability, and scalability.• Risk Assessment: Assess potential risks to system reliability and performance, supporting the development of mitigation strategies to ensure business continuity.

Phoenix, Arizona, Us

• Serves as the primary liaison and point of contact for Post Collection to the assigned functional business area for routine software development, enhancement projects and testing. • Facilitates the development of software solutions and is responsible for the knowledge transfer of software program requirements to the Post Collection team throughout the life cycle of a change request or development project.• Creates detailed documentation of functional, system (non-functional), user and reporting requirements such as Use Cases, Logical Models, Report Specifications, Data Mapping and Flow Diagrams and test scripts for Acumatica and TRUX.• Performs profiling and analysis of data from source systems to decommission PCScale.• RunBook: Supports quality assurance and control efforts through the use of data analysis as part of pre-and post-implementation reviews for software development projects and updated RunBook for Acumtica, Sage, and PCScale.• Testing Expertise for Acumatica and TRUX using testing methodologies such as function testing, regression testing and user acceptance testing (UAT).• Designed test scripts and scenarios to ensure comprehensive testing coverage by utilizing QTest, and Rally to streamline testing process and enhance efficiency. • Analyzed business requirements and translated them into testing scenarios and acceptance criteria. • Coordinated testing groups progress to ensure quality of software or systems by identifying defects and facilitating their resolution.• Coordinates status meetings and produces progress reports for stakeholders, developers, and quality assurance teams to facilitate smooth testing processes and effective communication of issues.• Derived a clear line of communication with tester to improve testing processes, methodologies, or documentation templates to enhance efficiency and effectiveness.• Provided training to end-users or support teams on new systems, processes, or functionalities.

Irvine, Ca, Us

• Serves as the primary liaison and point of contact between IT and the assigned functional business area for routine software development and enhancement projects.• Coordinates the process of obtaining current state functional requirements from business stakeholders and subject matter experts utilizing elicitation techniques such as SWOT use case, and process flows diagraming to design future state reports.• Performs research and analysis for proposed projects to determine feasibility, ROI and durability and presents findings to management.• Facilitates the development of software solutions and is responsible for the knowledge transfer of software program requirements to the IT Customer Support team throughout the life cycle of a change request or development project.• Creates detailed documentation of functional, system (non-functional), user and reporting requirements such as Use Cases, Logical Models, Process Flow Diagrams, Report Specifications and Data Mapping & Flow Diagrams.• Performs profiling and analysis of data from source systems.• • Supports quality assurance and control efforts through the use of data analysis as part of pre-and post-implementation reviews for software development projects.• Coordinates status meetings and produces progress reports.• Maintains and builds working relationships with software application vendors.

Phoenix, Arizona, Us

• Serves as the primary liaison and point of contact between IT and the assigned functional business area for routine software development and enhancement projects.• Coordinates the process of obtaining functional requirements from business stakeholders and subject matter experts utilizing elicitation techniques such as SWOT use case, and process flows diagraming.• Performs research and analysis for proposed projects to determine feasibility, ROI and durability and presents findings to management.• Facilitates the development of software solutions and is responsible for the knowledge transfer of software program requirements to the IT Customer Support team throughout the life cycle of a change request or development project.• Creates detailed documentation of functional, system (non-functional), user and reporting requirements such as Use Cases, Logical Models, Process Flow Diagrams, Report Specifications and Data Mapping & Flow Diagrams.• Performs profiling and analysis of data from source systems.• Maintains a system enhancement request database and coordinates the related application enhancement release schedule.• Works jointly with IT Managers to create detailed project work plans for software development and enhancement projects.• Provides support to functional and user acceptance testing groups as part of project implementation.• Supports quality assurance and control efforts through the use of data analysis as part of pre-and post-implementation reviews for software development projects.• Coordinates status meetings and produces progress reports.• Maintains and builds working relationships with software application vendors.

FinCrime (Financial Crime Global Fraud repository database, SharePoint and InfoPath forms), focused on moving users and content onto a new improved database and InfoPath forms. The old process was complex for End Users and did not map to our Global database. Also managed Change Request (Change Management) database used by End Users to make update or modification to existing FinCrime record.Selected Accomplishments:• Analyzed the business process and workflow and drafted process improvement recommendations.• Understanding of how business units Financial Crime remediation is accomplished and identified key process dependencies that may exist in Financial Crime record and tracking for Global environments.• Written and reviewed technical documents including risk assessments and security architecture artifacts by managing and updating FinCrime Operation Manual.• Identified, document, and communicate complex requirements across systems and business domains by mapping downstream system applications with understand the integration of processes across domains, scope, charter, plans in FinCrime database mapping from U.S. to Global database • Collected business requirements and prepare written requirements on system and Global FinCrime data housing SharePoint update• Prepared business process maps, high-level workflows, use cases, functional specifications, wireframes, process flow diagrams, and report mockups update to InfoPath form for SharePoint upgrade.• Supported development teams in obtaining clarification of business requirements to avoid delays in development cycle• Met with Business Units to develop user stories, assisted in identifying and documenting scope of work procedures. • Identify business processes for redesign to improve existing business process and identify modifications to automated processes while implementing update to InfoPath form for SharePoint upgrade.• Managed and defined Testing case and participated in QA process

San Francisco, California, Us

Customer Remediation business partners to gather and document business requirements related to affected customers. They will work with technical data teams throughout the process of pulling data and remediation execution. Gathered business requirements and translating into technical specification and requirements. Document requirements and experience with BRD/FSD documentation. Managed relationships as a liaison between business partners and technical teams. Basic use of SQL query’s

Tempe, Az, Us

Enterprise Content Management (ECM) Program, and will focus on moving users and content off Cimage onto an alternative platform (i.e. OpenText and ProjectWise) so that Cimage can be decommissioned. CIMAGE Decommissioning, migrating content to ProjectWise and/or Open Text Context Server: The Cimage Application is no longer supported by the vendor and is running on unsupported HP hardware, making it increasingly difficult to support and maintain. The application has been identified as critical to the business, and OpenText Content Server (OTCS) and Bentley’s ProjectWise platforms have been identified as viable replacements of Cimage.Selected Accomplishments:• Business Analyst: Participate in various requirements analysis sessions with Key Stakeholders of the project. Participated in providing inputs to Use Case to analyze CIMAGE functionalities and align with ProjectWise and Open Text. Participated in discussion on metadata and records management.• Quality Assurance Lead: Updated and edited published Test Strategy/Plan documents. Identify test schedule and types of testing to be conducted during the course of the project. Identify defect capture, handling and reporting. Lead the execution of testing.• Tester: Edited, Developed and executed test case, capture defects and criticalities.• Trainer: Provided inputs in creating the modules for training, Review Training contents and provided high level training.

Phoenix, Arizona, Us

Analyzed Pharmaceutical data by analyzing, validates, and documents the needs of the project stakeholders. Adhering to the established work methodology, the Application Requirements Analyst facilitates requirements analysis, management, and documentation to accomplish strategic, corporate, and operational needs while keeping user experience and usability as a priority. Seeing that the agreed-upon initiative tasks are performed timely per the documented project plan all by utilizing SQL, Hyperion and Power BI.Selected Accomplishments:• Working Knowledge of the over 3 dozen PBM (Pharmacy Benefit Management) industry and PBM data; understands key PBM metrics (such as PMPM, generic utilization). Extract, Transfer and Load (ETL) Plan Data Sheets into Database for all BIN, PCN and Group number in our network to gather AWP Discount and Dispensing fee for 30/90 Day and by drug Type (Single-Source Brands, Multi-Source Brands and Multi Source Generic).• ETL current claim data by BIN, PCN, and Group to get current AWP by Day Supply• Ad-Hoc report on full impact of PBM’s Managed Medicaid pricing to review impact to Pharmacy network• Review current pricing to bid pricing contracts by adjusting current AWP Discount, Dispending Fee, Cost Paid, and Acquisition to get Average Profit/Loss Per Script by a percentage rate change and/or Dollar amount for large sets of pharmacy, claims, medical, and/or financial data• Develop over a dozen macros for monthly reporting such as: to update monthly Margin Tracking report and format claims reports for analytics.

New York, Ny, Us

Responsible for managing, IT Project and software deployment. Overseeing change management activities and the software development lifecycle. Work closely with Product Owner/System Matter Experts to define deliverable. Prepare application scope and objective, facilitate, monitor, evaluate document Knowledge Articles (Knowledge Case). Facilitate technical learning and development needs and activities for IT Engineers (HelpDesk) communications of business transformation. Works closely with Customers, Client Relations and Product Development teams to ensure the maximum benefit from our tools and products. Leaning Management System Administrator (LMS) manages IT Transformation and Software Deployment training material and videos onto Navigator (Corporate LMS). Develop and maintain a thorough understanding of company hardware, software, and cloud solutions to provide training for new and existing customers and partners as well as internal training for employees. Works as part of the training team to create and deliver training solutions that translate complex business, process or technological concepts into easy-to-understand course materials and tutorials. Prepare and maintain current product information, training data and training materials, as required, to successfully conduct online and in-person training classes.Selected Accomplishments:• Establish business requirement from Product Owner to End Users specification and how it impact them and collaborate the information to Technology Support Engineers. • Manage multiple projects at one time, with Agile environment by using JIRA. • New Engagement: Created New Engagement requirements; crated and manage New Engagement • Learning System Management: Curriculum: Designed New Hire Curriculum, which contained 25 learning modules for over 300 Help Desk Support team

Scottsdale, Az, Us

Liaison between the finance and accounting business users and IT, and reports directly to the IT Finance Application Manager. Worked closely with the business end users to provide on-going training and support and as well to meet their business objectives for improvements and efficiency gains. All done by having the knowledge and experience of Finance systems, processes and best practices and documented the objectives of the Finance and accounting teams into requirements for design, development and execution. Leaded projects and other IT Finance Business Analysts.Responsible for managing: IT Project and SDL to Accounting infrastructure; change management activities and the software development lifecycle. Work closely with End Users and System Matter Experts to define deliverable. Prepare application scope and objective, facilitate, monitor, write document Knowledge Articles. Facilitate technical learning and development activities for accounting team, and communications of business transformation.Selected Accomplishments:• Rewrote 1099Pro, Fanatical Asset System (FAS), and over 20 Newstar (Constellation) training manual for end users. Also supported and train financial end user on all finance related systems• Created Infopath (out of the box) forms integrated with SharePoint functions for New Users Access and Sales Performance.• Troubleshoot system and process issues to resolution for Financial and Accounting issues Agile• Performed changed management activities as necessary with system changes• Test, validate and sign-off system upgrades prior to production release• Documented requirements, define scope and objectives and execute plan for system/process improvements• Collaborate with external vendors and internal developers to execute system enhancement and reporting requests• Lead larger or more technical projects to completion• Maintained financial applications for User access and master data maintenance• Maintained ERP financial reports

Bloomfield, Ct, Us

Responsible for a wide variety of business, systems, and project analysis tasks within CIGNA Onsite Health (COH) in support of onsite product delivery. Responsibilities included password authentication, support of users with COH business computer systems, software applications and business network and CIGNA connectivity, compile and analyze results of services for identification of improvement opportunities, possess a thorough knowledge of the interdependencies among business improvement teams, complete deliverables related to application upgrades/enhancements and strategic technology initiatives, assistance with the implementation and support of health care centers found within client sites as requested and supporting numerous other projects and production support as requested.Work closely with Product Owner/System Matter Experts to define deliverable. Prepare application scope and objective, facilitate, monitor, evaluate document Knowledge Articles (Knowledge Case). Facilitate technical learning and development needs and activities for IT Engineers (HelpDesk) communications of business transformation. Works closely with Customers, Client Relations and Product Development teams to ensure the maximum benefit from our tools and products. Selected Accomplishments:• Created an asset management system to track infrastructure IT build up.• Performed changed management activities as necessary with system changes• Test, validate and sign-off system upgrades prior to production release• Documented requirements, define scope and objectives and execute plan for system/process improvements• Collaborate with external vendors and internal developers to execute system enhancement and reporting requests• Facilitated On-Boarding COH: Passwords authentication via firewall and encryption, to Network and system applications.

Troy, Michigan, Us

•Agile Methodology user story and user acceptance criteria; Clarity for project Budget and Rally for managing the project.•Syntel Agile Certification 1 and 2•SME of American Express (Amex) Global Merchants Services (GMS) develop templates for project scope, requirements and process mapping documentation•Studying best practices and knowledge sharing of Amex GMS E2E process Facilitate business meetings to introduce the business analysis phase of project management SDLC•Document business requirements, test plans, and user training materials for quarterly release cycles•Edited a layout in Media Wiki page using HTML and wiki markup coding.

Charlotte, North Carolina, Us

documenting and redesigning process for improvements. Selected Accomplishments:• Support and Administration of SharePoint 2007/2013 user integration and troubleshooting • Design and customization of SharePoint Lists, Content Types, Workflows, Views, Sites and more with and without SharePoint Designer• Improved Nintex workflow process designed in 2013 while under migration of SharePoint 2007• Site Administrator for several SharePoint Site • Worked with SharePoint Support for Migration from SharePoint 2007 to 2013• SharePoint development with InfoPath 2007 by creating an interactive Voice of the Customer• SharePoint 2013 user profiles & My Site configuration within Central Administration including customizing User Profile Service & Properties.• Crated PowerPoint presentation SharePoint 2013 training end users on list, libraries, pages, publishing, web part, importing, exporting, navigation and many other features.• Created SAP macro scripting by gathering data from different SAP database and implementing the information into Excel Ad-Hoc reporting by using VB scripting for a dozen reports.

Us

Development and administers of JDE EnterpriseOne data and Oracle Essbase cubes and reporting platform Financial Report Writer (FRW). Work with business teams to gather business requirements, prepare, prioritize and deliver reports for all functional areas and business units across the organization.Selected Accomplishments:• Migrated SEC Financial Reporting Package (Income Statement, Balance Sheet, and Homebuilder Operations) from Timberline to JD Edwards new Chart of Accounts. • Designed SEC Financial Reporting Package of various Income Statement, Balance Sheet, and Homebuilder Operations by Consolidated, Business Units, Period, Quarter and Annual to JDE EnterpriseOne reporting platform (FRW)• Validated SEC Financial Reports to Legacy reports by using JDE EnterpriseOne OneView

New York, Ny, Us

WW Credit and Fraud Reserves COE, Financial Analyst, Delivery and maintenance of MIS support, processing, and reporting by developing and maintenance of Essbase Database (Design/Maintains/Load/Validation/Ad Hoc Reporting) for ICCS/Corp, Global Fraud Reporting and GNS, Lotus Notes (Access/Update)Selected Accomplishments:• Developed and maintenance of Essbase application database by managing, loading, validating and generating reporting from ICCS/Corp Model, Global Fraud Reporting Model and GNS Model. • Develop relevant reporting and databases to provide detailed information on activity cost across all functions and geographies. • Involved in the development of automation and validation tools by automating and streamlining BAU and financial reporting.• Maintenance of Lotus Notes Database• Apply proven analytical skills to identify key areas to improve efficiency and reduce waste.• Managed Dashboard, International Executive Leaders.Card Financial Capture and Settlement, Accountant 1, Carry out general Ledger function for US and Asian Markets, Including media settlements (Tranfered of international cash payments to Financial Institutions), account reclassification, true-ups, account analysis, and reconciliation (IRIS), journal entries, and SOX testing. Selected Accomplishments:• Consistently met deadlines while demonstrating strong analytical and problem-solving skills to achieve corporate objectives. • Strategically restructured desk procedures and processed in accordance with organization changes.Tech Finance AEDR, Financial Analyst Worked on project that maintenance Fee Allocator, by reconciling Charge backs, Credits and Profiling data toward CS3. International Cost Center reconciliation for on CPC and EPIC. Selected Accomplishments:• Reconciled Cost Center 255, YTD CPC, YTD EPIC and CS3 vs. Fee Allocator• Fee Allocator: Charge backs, Credits and Profiling• Manage @Work

Analysis and evaluate the uses of accounting information for managerial decision-making, budgeting, and control. By allowing one to make effective and efficient use of accounting information in managerial decision-making. Emphasizing in strategic cost management of pro-forma balance sheets of multi year forecast and planning. In relations to the process of manufacturing or product cost, inventory valuation methods, economic and cost based approaches to pricing. With the understanding of generally accepted accounting standards. Financial accounting and reportingSelected Accomplishments:• Financial Analyst: Identify and analysis key problems that are found in financial management and in business enterprises. By analyzing accounting information to evaluate a grants financial health, and a valuation of key determinate and relevant of stream of cash flow rather then accounting-based performance.• Managerial Finance Analyst: concentrates on key issues faced by government financial management. By use and developing a framework for evaluating the government grants and financing decisions that are typically made by a financial manager. • Monitored 91 million in Federal Grants, by budgeting, forecasting, reconciling grant allocations.

Us

• Managed 6 associates, 1,000 customers, Compliance Audits, Bank Reconciliation, and Guest RelationsMortgage Accountant,• Prepared Investment Acquisitions, Managed and reconciled General Ledger/Trust Accounts, Report development utilizing Crystal Report, Audit standard, techniques and procedures, Risks and appropriate controls

San Francisco, Ca, Us

Managed the Claims department team, analysed billing discrimpencys from insurance reinbursements.

Master Of Business Administration (M.B.A.)

Bachelor Of Science (Bs), Finance, General

Associate’S Degree, Computer And Information Sciences And Support Services