Project Manager And Business Analyst Resume
Charlotte, NC
SUMMARY:
- Business Analyst and PMP certified with proven track record liaising with cross - functional business and technology teams to develop business cases that demonstrate the purpose and value of technology projects within an AGILE environment.
- Strategic and technical thinking, strong understanding of systems, infrastructure and various types of applications, whether these applications are enterprise built or bought.
- Drafting project plans and WBD and obtaining necessary sign offs from stake holders.
- Ensuring scope creep does not occur.
- Drafting USER STORIES from requirements. I can provide samples from previous projects.
- Drafting user acceptance from user stories.
- JIRA expert for maintaining AGILE SCRUM, however, can also utilize EXCEL if project team does not use Atlassian products.
- Maintaining product and scrum backlog and developing sprints 4-6 weeks ahead of schedule.
- Requirements gathering from both business and technical (application engineer) teams.
- Business - Drafting Functional Specification for any application.
- Technical - Data Mapping, ERD, and reverse engineering database to develop model.
- Excellent at gathering requirements from both business and technical teams and translating into workable user stories.
- Building acceptance criteria from user stories and ensuring clarity with technical team who implements user stories into workable code or product enhancement.
- Triaging issues and appropriately documenting root cause.
- Every project is broken down into iterations with a definitive deliverable submitted to stakeholders.
- Under limited supervision, work with cross-functional teams translating business requirement into system interface specifications, logical and physical data modeling, create documentation for the request, and work with developers on prototypes.
- Drafting functional specification documents for new and existing applications.
- Work with the product owners to groom and define user stories, use cases, and acceptance criteria.
- Work as part of the Agile Scrum team with previous role as scrum master to deliver comprehensive changes to internal/external business.
- Analyze changes in the user stories to support the development process and communicate changes in established expectations to the project manager and stakeholders.
- Ability to communicate complex technology concepts to a non-technology audience.
- Analyze requirements gathered and determine gaps in technology, business processes, constructing workflow charts and diagrams; studying system capabilities and writing specifications.
- Background with contract negotiation with clients and sales team.
- Four years extensive work within JIRA as an Administrator and daily user.
- Protecting NPI within both financial services and healthcare via DATA MASKING through tools within INFORMATICA, ORACLE, and SQL SERVER.
- Proficient with both SQL MANAGEMENT STUDIO and SQL DEVELOPER and ERWIN and TOAD.
- Understanding of Star data schemas
- Skilled SQL Developer with experience in building complex scripts and queries, Experience with triggers, views, functions, and sequences.
EXPERIENCE:
Confidential, Charlotte, NC
Project Manager and Business AnalystResponsibilities:
- Agile Data Management of Delphix Implementation through Confidential Securities.
- Implementation of Delphix products and services for CALYPSO and Confidential proprietary applications.
- Budgeting and forecasting for remainder of 2016 and planning 2017.
- Drafting projects and Proof of Concepts (POC) for Delphix tools and services for additional WF applications.
- Application management for DELPHIX within Confidential .
- Issue management and triage.
- Stakeholder management.
- Documentation and hosted weekly calls with internal and vendor stakeholders.
BUSINESS SYSTEMS CONSULTANT
Confidential
Responsibilities:
- Data Masking and Obfuscation.
- Strong relationship management between Confidential departments and Confidential vendors.
- BUILD - Mapping Confidential Securities proprietary system application.
- This role needed both business analyst for requirements gathering and project manager for scheduling and drafting project plan and WBD. As a BA and PMP documentation is my best asset.
- Collecting business requirements as well as testing, validation of data.
- Drafting application ETL (extract-transform-load) workflow mapping leading to technical / system specifications specification and business requirements as applied to new data masking implementation.
- Solid understanding of staging tables and importance within ETL flow.
- Drafted PROJECT PLAN which also included WORK BUSINESS STRUCTURE and on
- Currently drafting FUNCTIONAL SPECIFICATION documents for each application that is in scope for masking.
- Map data flows and catalog existing data sources.
- Assembling and maintaining business and technical metadata.
- Business process engineering of data masking procedures.
- Drafting business glossary and data dictionary.
- Participates in the development of department technical procedures.
- Works with other experts and partners to test and debug applications and programs.
- Assures project and business area quality, security and compliance requirements are met.
- Identify gaps in current technology processes and recommend changes to stakeholders and application teams.
- Identify potential DODD-FRANK (CFTC) and Sarbanes - Oxley areas of risk that could pose a threat to Confidential Securities business.
- Document clearly all issues and the steps taken to resolve the issue.
- Documenting support procedures and operational workarounds.
- Incident management, escalation, and problem management.
- Obtaining signoffs and managing change requests.
- Maintaining a strong understanding of business processes, strategies, and data needs as well as IT capabilities and capacity, and participate in filtering and prioritizing requests accordingly.
- Utilizing SQL Management Studio to access database and filter tables and potential masking data.
Confidential, Dallas, TX
Salesforce Administrator / JIRA Administrator
Responsibilities:
- 1st Global is a broker dealer who engages in wealth management and retirement services.
- Utilizing regular expression to Test for patterns within a string.
- For example, I utilized an input string to see find telephone number patterns in the data.
- So, I therefore remove duplicates or a credit card number pattern occurs within the string. I would then subtract a substring from a string upon pattern match.
- Also utilizing regular expression to find specific text with a document or input field.
- Imported .csv data into JIRA.
- Extensive project to build complete database for every CPA firm in the United States.
- Project includes ETL process of CPA firm data from Internet sources into SQL SERVER then salesforce.com.
- Utilizing EXCEL macro and v-look up functionality.
Confidential, New York, NY
Project Manager and Business Analyst
Responsibilities:
- Requirements gathering as business analyst.
- Drafted USER STORIES from requirements and provided to technical team. I also led to build the tasks and scrum board with technical team.
- Communicated with Digital Risk to build user acceptance from user stories.
- Project Management - leading project sessions with the client DIGITAL RISK.
- Project Management - Led JAD sessions with Confidential - Next Angles technical team.
- Built data models by deconstructing regulation pertaining to solutions.
- Deconstructed DODD FRANK: VOLCKER RULE, eCFR TITLE 12 and TITLE 17 (banks and banking laws and securities laws) built object relational data models in conjunction the standard enterprise data management terms (EDM) and (FIBO).
- Created Best Practice Guide to team with deconstructing and created enumerations for the Dodd - Frank regulation.
- Created best business practices to deconstruct Dodd-Frank regulations and in corporate with Enterprise Data Management FIBO.
- Build data flows and develop semantic conceptual data models.
- Drafting use case to provide to UX and UI platform designer.
- Diagrammed object relational models into domain groups and rules groups.
- Built OBJECT RELATIONAL MODELS (ORMs) and UML. Plus, reviewed with chief scientist and knowledge architect / data modeler.
- Deconstructed Dodd Frank regulation into domains and rules and diagrammed into ORMs (entity relationship diagram using FIBO standards).
- Create semantic logical and physical data models using best practices to ensure high data quality and reduced redundancy.
- Diagrammed domain models and rules models with business and system requirements, FIBO, and enumerated Dodd-Frank regulation.
- Maintain semantic conceptual, logical and physical data models along with corresponding metadata.
- Maintained models by also working on project to built lexicon repository.
- Modeled with both built lexicon depository and FIBO.
- Develop best practices for standard naming conventions and coding practices to ensure consistency of data models.
- Developed best practice to:
- Enumerate / deconstruct Dodd - Frank Regulation for domain data models and rule data models.
- Developed best practice to diagram ORM with FIBO and Dodd - Frank enumeration and business requirements.
- Developed project management best practices for requirement elicitation and engineering.
- Evaluate data models and physical databases for variances and discrepancies.
- During this iterative stage worked with ontologist who used diagrammed models to build OWL.
- Provided solutions via Articulation Project which was my first initiative with the NextAngles Project
- Drafted Best Practices for articulation / enumerations
- This solution I proposed and led with the Chief Scientist and Knowledge Architect leads the ensuing targeted solutions in terms of deconstructing banking, securities, and financial risk regulation.
- Provide technical leadership and guidance to the technology staff.
- Validate business data objects for accuracy and completeness.
- Pursue continuous improvements based on lessons learned and industry best practices.
- Analyze data-related system integration challenges and propose appropriate solutions.
- Provided ORM data models to guide schematics of building the logical model for database.
DATABASE: CASSANDRA
PROGRAMMING LANGUAGES: CLOJURE and PYTHON, respectively.
MS: SHAREPOINT
Confidential, Dallas, TX
Senior Business Analyst
Responsibilities:
- Developed close relationship with UAT team to ensure requirements were met to guarantee sign off.
- Migrate from legacy system to Oracle.
- Data Mapping; and
- Business rules definitions.
- Utilized HP ALM software for requirements mappings
- Business Analysis skills:
- Analysis and documentation of current processes and functions and updated information within HP ALM.
- Requirements engineering to build internal applications to automate current procedures through ITIL
- Determination of business requirements and associated functional specifications for projects specific to the department.
- Development of business process models and associated changes to current processes for both BCBS IT team and the Project Diamond initiative.
- AXIOM QA manager: Perform functional, regression and verification testing on all web-based systems and related functionality. Participate in testing in regular sprint cycles and high-profile impact projects.
- Document and track core product defects during the testing process. Review and manage bugs reported in internal tracking system and facilitate the resolution of issues with the QA team, development, databases, product development, business sponsors, and systems engineering.
- Strong understanding of SDLC and experience working with different project methodologies.
Database: DB2 and Oracle 11g.
Confidential, Dallas, TX
Technical Project Manager / Business Analyst
Responsibilities:
- Scrum Master and JIRA Administrator.
- Built Functional Specification, Technical Specification and Business Requirement Document, along with Best Practices.
- Start up company in which requirements engineering and documenting was built via ITIL process.
- New UI / UX was immediately needed. Through iterative process I created wireframes for UI and created use cases and user stories to ensure appropriate UX.
- ITIL process to complete deliverable form inception to production.
- QA responsibility involved development and execution of test plans via use cases and SQL scripts, coordinating the resolution and escalation of bugs and issues that result from the testing process (entered in JIRA), and for facilitating software releases into the production environment.
- Draft reporting analytics and collections teams to support cash collection targets and Accounts Payable targets, to make appropriate decision on loss on accounts receivable.
- Forecasting and weekly SSRS reporting of AR collection status.
- Ensure smooth ETL of acquired clients into the collections and payables reporting process.
- Ensure active engagement with internal and external stakeholders for Project management to enhance collections and payables strategy by providing framework for cash/bad debt to internal and external stakeholders
- Service Delivery Managers, Billing teams, Sourcing Managers, Procurement Teams.
- Current project entails to optimize cash inflows and outflows, and minimize AR aging profile and bad-debt expense.
Confidential, Dallas, TX
Technical Project Manager
Responsibilities:
- Scrum Master and JIRA Administrator.
- Clearing backlog up to 4 - 6 weeks in advance.
- Building sprints to encompass 11 - 14 days.
- Built Functional Specification, Technical Specification and Business Requirement Document, along with Best Practices.
- Start - up who needed immediate deliverable to complete SOW and SLA for their client DIRECTV.
- Projects including utilizing DATA MASKING features for ETL iterations via INFORMATICA.
- Software architects and engineers built physical database and I engineered requirements via AGILE manner but through ITIL process.
- Documented and gathered project requirements to draft business documents throughout the project development lifecycle.
- Works as a liaison between end-users, product management, and development to gather and document user requirements, translating them into user stories (via AGILE methodology). Plan and conducts interviews with business owners and stakeholders. Conducts gap analyses (known unknown and unknown unknowns) to identify solutions that are cost effective and which meet business requirements.
- Worked iteratively with architects as technical writer to ensure application documentation reflects current system functionality and create functional specifications post calibration with development team.
- Supported project team and development team during design, development, and QA testing by clarifying requirement questions. Assist business team with UAT.
- QA responsibility involved development and execution of test plans via use cases and SQL scripts, coordinating the resolution and escalation of bugs and issues that result from the testing process (entered in JIRA), and for facilitating software releases into the production environment.
- Iterations included:
- Data Modeling Domain and Logic models and subsequent rule models. Plus, building data structure and data flows to present to internal and external stakeholders.
Confidential, Dallas, TX
Senior Business Systems Analyst
Responsibilities:
- Develop scalable solutions and reviewed business processes.
- Provide technical advisory services for multiple options and risks.
- Participate in process designing sessions and documented process flows.
- Evaluate and documented business processes and functional requirements.
- Implement information flow analysis for various business streams.
- Analyze and study request processes and future automated processes.
- Design and formulate application requirements and test conditions.
- Execute sprint planning and business estimation services with developers.
- Tracking/updating problem tickets and support requests.
- Working with support teams to triage/fix issues with the deployments.
- Creating/updating documentation to support the team functions.
- Generating metrics from available data.
- Regulatory Reporting - Swap Data Repository for asset classes: CREDIT, F/X COMMODITIES, EQUITIES, RATES, COLLATERAL.
- Develop business process documentation including Standard Operating Procedures (SOPs) and supporting documentation required for the organization ensuring consistency across all groups and departments. Ensures documentation complies with established quality control standards and writing style guidelines for external and internal publications.
- Project including drafting role specification documents for business analyst within Dodd Frank.
- Drafted technical specification documents for DTCC GTR within EMIR per Greenplum platform.
- SQL Developer with experience in building complex scripts and queries, Experience with triggers, views, functions, and sequences.
- Heavy usage with project management tool JIRA and SCRUM applications to service internal inquiries and manage large projects.
- Generate and produce ad - hoc reporting for industry governance committees and GTR (members) participants.
- Trained sales managers to understand how regulatory updates affect GTR products and how these changes and be implemented technically within GTR code within time constraints.
- Working knowledge of Bank Secrecy Act (BSA) and Anti-Money Laundering (AML) Regulations, US Patriot Act, Office of Foreign Assets Control (OFAC).
Database: Oracle 11g and OBIEE. DTCC is a strong client of Oracle ONDEMAND.
Confidential, Irving, TX
Business Research Analyst
Responsibilities:
- Executive level status ad hoc escalation originating from federal and state agencies, congressional offices, law firms, and offices of State Attorney Generals.
- Documented and gathered project requirements to draft business documents throughout the project development lifecycle.
- Loans serviced under Dodd - Frank guidelines.
- Report generation MS SQL SERVER 2008.
- Utilizing data masking to protect sensitive NPI.
Confidential, Irving, TX
Business Analyst - Contracts Specialist
Responsibilities:
- Requires excellent research capabilities to review pre-acquisition service level agreements and review for compliance within present ORACLE global approval matrix. Oracle licensing agreements under direct supervision of attorneys.
- Drafted contracts included technology products such as ORACLE new generation EXADATA, EXALYTICS, AND EXALOGIC, and project management services.
- Responsible for drafting direct ordering documents, partner ordering documents for resellers and distributors, amendments, procurement statement of work (SOW), and purchase order / pricing (PO) agreements. Draft both standard and non-standard contracts in accordance to customers’ needs.
- Assembled and draft contract documents, supporting assigned Oracle line of business, country, or sales organization, following Oracle’s global contract process and use appropriate tools and systems
- Reviewed transactional approvals/executive summaries to ensure appropriate business approvals are secured for any non-standard contract options per the relevant Oracle Global Approval Matrix
- Reviewed the Partner or Customer Master Agreement to ensure it is valid for the current transaction and meets define Oracle standards
- Engaged, per pre-defined guidelines, with Sales, Legal, Revenue Recognition, and other cross-functional teams on nonstandard contract terms
- Prepared contract documents and order packages for manager review
- Received and reviewed customer-executed documents, route for appropriate internal signature and submit for OrderProcessing or Project Funding
- Managed sales and customer expectation on time-to-completion for a given transaction request.
Confidential, Plano, TX
Business Analyst
Responsibilities:
- Ad hoc financial reporting via SSRS as requested by mangers and special escalation projects as requested from CFPB. Queried database as user and database to answer inquiries and draft functional specifications; Researched and resolved escalated mortgage loan issues.
- Audited all aspect of loan modification to ensure accuracy, investor and regulatory compliance.
- Acted as a primary point of contact and internal project manager for new client implementation, creation/execution of procedural modifications initiated internally or at the client's request. Utilized Sharepoint to communicate with the project manager regarding project procedural modifications and project deployment.
Confidential, Dallas, TX
Business Contracts Analyst
Responsibilities:
- SQL Server Analysis Services (SSAS) On-Line Analytical Processing (OLAP). SSAS project included working with development and coding requirements to build multidimensional structures structured cubes to pre-calculate and store complex aggregated algorithms, and also to build mining models to perform data analysis to identify valuable information like trends, patterns, relationships etc. within the data using Data Mining capabilities of SSAS, which otherwise could be really difficult to determine without Data Mining capabilities. Projects included post ETL aggregation of client data which was then analyzed to develop trends to service portfolio.
- SQL Server Reporting (SSRS) via SQL SERVER 2008 to product ad hoc managerial and regulatory stakeholder reports.
- Documented and gathered project requirements to draft business documents throughout the project development lifecycle.
- Utilizing DATA MASKING capabilities within SQL Server 2008 to protect sensitive NPI.
- Utilized SCRUM/AGILE development methods to service client portfolio and mange regulatory requirements. Additionally utilized AGILE testing and deployment to implement updates patient collection software platform.
- Creation, development, and maintaining reporting requirements Worked under compliance of HIPPA, FDCPA, and FCRA regulation.
- Acted as a primary point of contact and internal project manager for new client implementation, and lead project management on creation/execution of procedural modifications initiated internally or at the client's request.
- Projects for training in pursuant to regulatory compliance training and developing the Subject Matter Experts and sales / field representatives (Bright Now doctor recruiter and contracting team) with creating and maintaining document repository.