SUMMARY:

• Business Analyst with proven track record liasing with cross - functional business and technology teams to develop business cases that demonstrate the purpose and value of technology projects.
• Proficient with both SQL SERVER and SQL DEVELOPER and ERWIN and TOAD.
• Skilled SQL Developer with experience in building complex scripts and queries, Experience with triggers, views, functions, and sequences.
• 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.

EXPERIENCE:

Confidential, Dallas,TX

Project Manager - Salesforce Administrator / JIRA Administrator

Responsibilities:

• Utilizing regular expression to Test for patterns within a string.
• For example, I utilized a 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.
• Extract, transform, and load CPA firm data from Internet sources into salesforce.com.
• Utilizing EXCEL macro and v-look up functionality.
• Responsible for change management by developing change request log and tracking change requests within JIRA.
• Developed contingency plans to mitigate risks to project completion.
• Provided documentation advising status and ensure delivery of project status to management and stakeholders on a daily basis.

Confidential, New York, NY

PROJECT DOMAIN MANAGER- - ETL DATAWAREHOUSE

Responsibilities:

• 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.
• Client and Vendor Management:
• Effectively assisted in directing both internal and external resources to achieve business solutions within project guidelines.
• Responds to operational issues and RFI s within defined areas of responsibility while progressing on project work.
• Collaborates and communicates with other project managers and leaders to coordinate cross-project initiatives and activities. Identify and eliminate obstacles to solution plans, business goals or implementation.
• Work with the team to implement data strategies:
• 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:
• 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.
• 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.
• Effectively assisted in directing both internal and external resources to achieve business solutions within project guidelines.
• Responds to operational issues and RFI s within defined areas of responsibility while progressing on project work.
• Collaborates and communicates with other project managers and leaders to coordinate cross-project initiatives and activities. Identify and eliminate obstacles to solution plans, business goals or implementation.
• 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.
• Effectively assisted in directing both internal and external resources to achieve business solutions within project guidelines.
• Responds to operational issues and RFI s within defined areas of responsibility while progressing on project work.
• Collaborates and communicates with other project managers and leaders to coordinate cross-project initiatives and activities. Identify and eliminate obstacles to solution plans, business goals or implementation.
• 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.
• 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 Doman 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:

• 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.
• Relationship management with swap dealers and major swap participants, regulators, and other third parties.
• SQL Developer with experience in building complex scripts and queries, Experience with triggers, views, functions, 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 Greenplum

Confidential, Irving, TX

Project Manager / Business Research Analyst - Consumer Lending Mortgage

Responsibilities:

• Drafted Oracle hardware (legacy Sun Microsystem hardware).
• 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.

Confidential, Plano, TX

Business Analyst

Responsibilities:

• Ad hoc financial reporting via SSRS as requested by mangers and special escalation projects as requested from Confidential .
• 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.

Confidential, Dallas, TX

Business Contracts Analyst

Responsibilities:

• 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.
• 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 in Sharepoint.

Confidential, Dallas, TX

Business Analyst

Responsibilities:

• SSRS Developer MS SQL Server 2005/2000/ in Healthcare environment.
• Utilized relational database) to service debtors and maintain client list.
• Project iteration included working with development to build the post migration from legacy proprietary software to the MS BI stack: Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS).
• Implemented ETL packages using SSIS 2008/2005 for integrating data using OLE DB connection from sources (Excel, CSV, Oracle, flat file, Text file, Teradata) by using multiple transformations available in SSIS toolbox.
• 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.

Confidential, Dallas, TX

Business Product Technical Support

Responsibilities:

• BA technical support for Intuit Confidential product.
• Facilitated requirements gathering from the business units and translating them into client use cases/stories so the software development team can execute on them. Primary responsibilities include creation and management with technology architects and quality assurance and development.
• Utilized product knowledge and technical knowledge to assist clients and build user stories.
• Inputed / cataloged client inquiries to project manager within database and communicated user cases/stories to project manager.
• BA due diligence includes directly with customers via telephone and email to troubleshoot inquiries. Client database managed via MS ACCESS