We provide IT Staff Augmentation Services!

Business Analyst - Etl Datawarehouse Resume

New York, NY

SUMMARY:

  • Business Analyst 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.
  • 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.
  • Three years extensive work within JIRA.
  • FDCPA, GLBA, UDAAP, FCRA
  • FACTA, Identity Theft,
  • Global Privacy, BSA AML OFAC, ECOA, KYC/AML
  • CCAR, DFAT, VOLCKER RULE
  • Technical Writer utilizing AGILE method
  • Utilizing data repositories to manage requirements and testing with development; I utilize SQL to analyze the data within these repositories.
  • As a result of past companies have requirements for BI, SQL and relational database knowledge is necessary to understand the flow of data from application into data warehouse
  • Retrieving data using the SQL SELECT statement
  • Restricting and sorting data
  • Retrieving data using sub queries
  • Hierarchical retrieval
  • Regular expression support
  • Controlling user access
  • Managing schema objectives
  • Manipulating large data sets
  • Creating AGILE user stories to build requirements
  • ORACLE 11g
  • DODD FRANK
  • CFBP
  • CFTC
  • TILA - RESPA
  • EMIR within EMEA
  • Reviewing data dictionaries and entity relationship diagrams.
  • Querying databases or database extracts as part of my analysis.
  • Querying the new system specifically through the UAT phase on behalf of business
  • Using single-row functions to customize output
  • Reporting aggregated data using the group functions
  • Displaying data from multiple tables
  • Using sub queries to solve queries
  • Using the set operators
  • Using DDL statements to create and manage tables
  • Creating other schema objects
  • Managing objects with data dictionary news
  • Generating SSRS reports by grouping related data
  • Managing data in different time zones

TECHNICAL SKILLS:

SQL DEVELOPER

T-SQL

TOAD

PL/SQL

SQL SERVER REPORTING SERVICES (SSRS)

CRYSTAL REPORTS

JIRA

HP ALM

MICROSOFT VSIO

ORACLE OLTP AND OLAP

SARBANES OXLEY

SHAREPOINT

EXCEL

ACCESS

LSAMS

TOAD

AGILE

USER STORIES to create requirements

Siebel

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

BUSINESS ANALYST - ETL DATAWAREHOUSE

Responsibilities:

  • Built data models by deconstructing regulation pertaining to solutions.
  • Created Best Practice Guide to team with deconstructing and created enumerations for the Confidential regulation.
  • 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 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.

Confidential, Dallas, TX

Senior Business Analyst

Responsibilities:

  • Information technology group within Blue Cross Blue Shield to automate current operational procedures.
  • 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.
  • Strong understanding of SDLC and experience working with different project methodologies.

Confidential, Dallas, TX

Technical Project Manager (Insurance) / Business Analyst

Responsibilities:

  • 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.
  • 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 / - Data Warehousing

Responsibilities:

  • Scrum Master for project conceiving, designing, and evolving the mobile application suite and platform technologies core to company mobile network offering.
  • 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.
  • 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 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.
  • 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
  • Implement corporate audit recommendations during weekly GTR data staging exercises. Provided recommendations and improvement plans via thorough research, tracking audit findings, and ensuring full remediation of audit issues.
  • 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)

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 SSRS 2008.
  • Large client acquisition projects via SSIS ETL projects with development. Developed 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 such as Data Conversion, Conditional Split, Bulk Insert, Merge, Lookup.
  • 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.
  • Utilized Sharepoint to communicate share drafted procedural document inter-departmental
  • Utilized SCRUM technology to communicate with developers and Business Analyst during planned projects.

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.
  • Fixed - price contracts.
  • Cost - reimbursable contracts.
  • Time and Material Contracts.
  • 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 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.
  • 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.

Confidential, Dallas, TX

Business Analyst

Responsibilities:

  • SSRS Developer MS SQL Server 2008/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.

Hire Now