We provide IT Staff Augmentation Services!

Sr. Business Analyst / Business Intelligence Analyst Resume

Owings Mills, MD

PROFESSIONAL SUMMARY:

  • 9+ years of IT experience in Business Analysis, Certified Scrum Master, Data Analysis, Design, Modeling , Development, Implementation and Testing of Data warehouse applications.
  • Have Public trust Clearance.
  • Extensive experience as Business/Data Analyst on data warehousing projects and expert in Data Cleansing/Data Conversion/Data Mapping/Data Migration concepts.
  • Involved in Full Life Cycle Development (Waterfall & Agile) of building a Data Warehouse for Financial, Mortgage, Mutual Funds, Banking Clients
  • Experience working in Capital Markets, CMBS and Bond Administration projects
  • Solid Understanding of MBS, CMBS, Debt, Derivate and Fixed Income concepts.
  • Extensively used and translated requirements into the Requirement Traceability Matrix.
  • Designed and Developed Data Marts by using Star Schema and Snowflake Schema Methodology.
  • Data warehouse, ETL - Extraction/Transformation/Loading, Data Analysis, Data mining, Data migration, Data preparation, Graphical Presentation, Statistical Analysis, Reporting, Validation and Documentation.
  • Solid experience in AGILE SDLC, writing user stories, creating backlogs and working on RALLY
  • Experience in designing, developing, testing, and deployment of various custom reports using reporting tools .
  • Exceptional data analysis and reporting skills using ( Business Objects , SSRS, Crystal Reports and MS Excel).
  • Expert in writing Adhoc SQL queries and writing stored procedures using SQL
  • Proficient in creating Business Requirements Document (BRD), Use Cases, Requirements Traceability Matrix (RTM), Work Flow Diagrams, and Business Process Flow Diagrams.
  • Experienced with business modeling tools such as Blueprint Requirement Center and MS Visio to generate data flow diagrams, process maps, flowcharts and UML diagrams.
  • Ability to work in close co-ordination with the Testing team to develop Test Plan and Test Cases.
  • Experience in assisting users to conduct User Acceptance Testing (UAT).
  • Highly organized with the ability to manage multiple projects and meet deadlines.

TECHNICAL SKILLS:

Requirements Management and Modeling Tools: Requisite Pro, Doors, Microsoft Visio. JIRA, HPQC

Change Management and Version Control: Clear Case, Remedy, Clear Quest, CVS

Data base: MS SQL server, MS Access, Oracle, Teradata, DB2, Sybase

Project Management: MS Project

Other Tools: MS Office (Word, Power Point, Excel), RUP, Test Manager, HP ALM, TOAD, Rapid, Erwin, Data Flux, Business Objects Reporting, Tableau, MEGA HopeX, SharePoint 2016

Reporting Tools: Business Objects, Business Objects Universe Developer, Advanced SAS, SSRS and Cognos Series 7.0

PROFESSIONAL EXPERIENCE:

Confidential, Owings Mills, MD

Sr. Business Analyst / Business Intelligence Analyst

Responsibilities:

  • Working in this Project involves, a Lean Agile team which has 2-week sprints, and is known as Team halogen, as part of Team halogen some of the Primary responsibilities are data transformation from Hi Net database to IDW (Investment data warehouse), from IDW to Fusion and from Fusion to Halogen.
  • Created and modified several database objects such as Tables, Views, Indexes, Constraints, Stored procedures, Packages, Functions and Triggers using SQL and PL/SQL.
  • Extensive use of SQL and DB Visualizer.
  • This project involves restructuring of a new In-house tool known as Halogen, which in due course will be replacing MicroStrategy, throughout the Organization.
  • Day to day job also involves Analysis of legacy data, such as, Hi Net data, SSRS Reports, HiQ, and Eagle Reports.
  • Analysis of data from Business Object reports with expert level analysis skill in both Online and Desktop intelligence versions of the Tool.
  • Performed data mapping on a regular basis, which involves checking existing Stored procedures, breaking them into IDW Data, followed by mapping them into Fusion database.
  • Analyzing large data sets and breaking them down to both direct and calculated fields.
  • Extensive Data mapping and entering the data into SharePoint and linking them to JIRA.
  • Segregating all types of legacy reports and Views.
  • Performed Release Management, smooth transition between environments.
  • Strictly Followed Agile methodology, with a 2-week Sprint.
  • Performed requirements analysis and using MS Visio created various UML diagrams to enable the development teams to conceptualize the software needs.
  • Conducted detailed and comprehensive Business Analysis by working with the Business Team, SME's, and other stakeholders to identify the system, operational requirements and process improvements.
  • Utilized Agile Methodology to configure and develop process, standards, and procedures to create a Business Requirement Document (BRD) and Functional Specs.
  • Involved in design and development of data warehouse environment, liaison to business users and technical teams gathering requirement specification documents and presenting and identifying data sources, targets and report generation
  • Provide daily communications, scrum notes, sprint reviews reports, project retrospectives, and regular snapshots of project velocity and budget burn rate.
  • Organized and facilitated sprint planning, daily stand-up meetings, reviews, retrospectives, release planning, demos and other Scrum-related meeting.

Environment: SQL, MS Projects, SCRUM development methodology, ETL, JIRA, Microsoft SQL, Tableau, MS Visio, HTML, XML, HP ALM.

Confidential, Washington, DC

Sr. Business Analyst / Project Co-Ordinator

Responsibilities:

  • The project involved working with Personally Identifiable Information. (PII) and its removal from all the Federal Networking Systems both Internal and External, with the help of Data Integration and Data Warehousing techniques.
  • Also, currently working on SDMS Financial systems, tracking all the previous Fed Transactions, Analyzing the past and present Data.
  • Extensively participated in translating business needs into Business Intelligence reporting solutions by ensuring the correct selection of toolset available across the Tableau BI suite.
  • Built analytics solutions using variety of technologies and analytics tools as required by the line of business, and created robust documentation of solutions and underlying design decisions and operating procedures.
  • Performed Data analysis and Data profiling using SQL on various sources systems including Oracle and Teradata and migrated critical reporting systems to Business Objects and Web Intelligence on a Teradata platform.
  • Implemented data refreshes on Tableau Server for and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.

Confidential, Washington, DC

Sr. Business Analyst / Project Co-Coordinator

Responsibilities:

  • Led project teams, internal and external to achieve defined milestones and deliverables
  • Organized and facilitated Scrum ceremonies including Summer Planning, Daily Standups, Sprint Review, and Retrospective.
  • Conducted stakeholder Joint application design (JAD) interviews and translated business user concepts and ideas into comprehensive business requirements.
  • Established milestones and adherence to project scope, requirements, design documents, and schedules.
  • Responsible for conducting business process evaluations; developing & documenting detailed business requirements; and responding to project related requests from stakeholders and clients in support of business case development
  • Extensive experience in writing Functional Design Documents, Use Cases, User stories, and System Specification
  • Designed and improved processes.
  • Defined requirements for software tools for developmental staff
  • Test against requirements, on a weekly basis.
  • Integrated systems and managing projects of selected development efforts.
  • Review designs as and when available from the design team.
  • Use software tools to gather requirements, analyze needs, identify risk, propose designs, write documentation and conduct financial analysis
  • Demonstrated skills in software-aided business process capture
  • Demonstrated skills in analyzing processes and identifying opportunities for enhancements
  • Demonstrated experience in a project leadership role
  • Demonstrated experience establishing strong relationships with operational, IT and financial management
  • Experience in data analysis
  • Used communication skills, both verbal and written to lay out SOP’s and to delegate work within the MIPN team.

Confidential, Boston, MA

Sr. Capital Markets BA

Responsibilities:

  • Formulated Retail Banking compliance and regulations to help craft the overall testing program related to Sales Practices.
  • Extensively worked on retail and consumer banking regulations. (OCC) Office of the Comptroller of the Currency)
  • Worked on Santander banking products, Mutual Funds and retail products such as checking, savings, credit cards, loans, lines of credit and/or small business banking with understanding or processes at branch networks and call centers.
  • Worked closely on banking compliance investigations, strong knowledge of audit practices for handling of evidence and findings, analysis of structured and unstructured data, evaluation of violations, determine level risks and/or of compliance, documentation of findings.
  • Used tools like SAS, SQL and SPSS on retrieving and investigating Data and managed requirements in JIRA.
  • Analyzed portfolio along various risk metrics, ensuring adherence to policy and committee directives
  • Monitored market activity and flow via Bloomberg and broker/dealer network of contacts for MBS / CMO bonds
  • Worked with Capital Market, Mutual Funds & Trading team to formulate Fixed Income, Debt and Derivative (Swaps) Pricing Strategies. Heavily involved in Credit Default Swaps and MBS Securities.
  • Developed and maintained individual bond files complete with analysis, narrative summary, and broker confirmations readied for auditor or examiner (OCC) review
  • Developed a uniform performance review of existing holdings (actual vs. projected) highlighting yield, total return, and cash flow
  • Prepared all bond accounting entries including transactions, monthly accruals and accretion / amortization
  • Worked with various Business and Product partners to analyze and define requirements to develop requirements for a repository that meets the strategic needs of the Business.
  • Fraud Detection and investigation, involved screening of employee side Investigation with the help of Bank Software’s such as Synergy, Servicing Portal, Data Scan (used for Auto loans), Care, One and CIP Content Manager.
  • Heading a team of 10 analysts on formulating remedial steps of detected Fraud and Sales Misconduct.
  • Was instrumental in filing a report on findings and outcomes based on the last 3 fiscal years which will be presented to the OCC.
  • Prepared Logical Data Models that contains set of Entity Relationship Diagrams and Data Flow Diagrams and supporting documents and descriptions of the Relationships between the data elements to analyze and document the Business Data Requirements.
  • Prepared system Test Plan and scenarios for Test Scripts, Data quality Testing and Requirement Traceability Matrix.

Confidential, Boston, MA

Sr. Business / Data Analyst

Responsibilities:

  • Interacted with the stakeholders to get a better understanding of client business processes and document project vision with business requirements.
  • Created BRDs and translated them to system tech specification
  • Worked on Banking services provided by Client such as Mutual Funds, Capital markets and Mortgages.
  • Attended daily scrum standups to review the RALLY Kanban board and review user stories
  • Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
  • Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
  • Execution of SQL on oracle table in order to view successful transaction of data.
  • Validated the test data in DB2 tables on Mainframes and on Tera data using SQL queries.
  • Documented the evaluation of various reporting tools like Cognos/Business Objects, made recommendations about the product depending on the reporting requirements.
  • Performed Data mapping, logical data modelling and used SQL queries to filter data
  • Performed Business Process Management, Business Process Engineering, Business Process Re-engineering, CMM etc. to enhance the business process.
  • Used MS Visio to create AS IS and TO BE Process flow diagrams
  • Created Source to target data mapping documents identifying key data elements and prepared Data Flow Diagrams
  • Experience in Designing, Creating and maintaining the Universes, Business object reports, WEBI reports and Domains (Security, Universe, Document) in Business Objects.
  • Created and mapped file specifications for both inbound and outbound XML messages
  • Used Visual Basic Editor (VBE) for developing and testing Macros in Excel
  • Utilized Informatica toolset (Informatica Data Explorer, and Informatica Data Quality) to analyze legacy data for data profiling.
  • Designed Specs for Data Transfer API Service calls with External Callable Services
  • Participated in UAT and worked with HP Quality Center for bug and defect tracking.
  • Prepared a handbook of standards and Documented standards for Informatica code development.
  • Designed conceptual and logical data models of Data Warehouse and tables.
  • Followed the UML based methods using Microsoft Visio to create: Use Cases Diagrams, Activity Diagrams, State Chart Diagrams, Sequence Diagrams and Collaboration Diagrams.
  • Prepared Logical Data Models that contains set of Entity Relationship Diagrams and Data Flow Diagrams and supporting documents and descriptions of the Relationships between the data elements to analyze and document the Business Data Requirements.
  • Prepared system Test Plan and scenarios for Test Scripts.
  • Defined the duplication of data and columns between tables using TOAD and SQL.

Confidential, Charlotte, NC

Sr. Business Analyst/ Data Analyst

Responsibilities:

  • Implemented the data governance standards, policies, and procedures for the control, protection, consistency and delivery of corporate data and information assets.
  • Actively involved in data warehouse architecture meetings.
  • Performed impact analysis for changes to operational application processes and data that may affect the informational environment.
  • Helped SME’s identify Data abnormalities through data profiling and identifying the root cause of issues through SQL queries.
  • Supporting production issues through in-depth triaging of ETL issues.
  • Acted as a liaison between the technical staff and the users (staff and management). Also was responsible for communications between Project Team and other related departments.
  • Worked with Business Intelligence (BI) team in preparing documentation to facilitate transfer of developed BOBJ reports to production environment.
  • Reviewed and guided the development of logical and physical data models that have informational impact.
  • Worked and maintained an inventory of data dictionaries that impact the informational infrastructure.
  • Worked on quality assurance projects in the operational infrastructures to ensure that data is properly cleansed and certified prior to being transferred to the informational infrastructure.
  • Debugging SAS code to during development of Business Objects reports
  • Designed and developed Ad-hoc reports as per business requirements.
  • Worked on Data Verifications and Validations to evaluate the data generated according to the requirements is appropriate and consistent.
  • Created daily and monthly reports using SQL and UNIX for Business Analysis
  • Installed, configured, maintained and supported off-the-shelf software for ad hoc Data Cleansing, Data mining and Data mapping.
  • Analyzed and designed Use Case diagrams, Class diagrams, sequence diagrams, and Visio to depict process flows and PowerPoint presentations.
  • Developed requirement reports for day-to-day trading management needs for opening new accounts, using Rational SoDA.
  • Assisted QA manager to develop test plan and test case.
  • Provided business support to conduct User Acceptance Test (UAT).

Confidential, Austin, TX

Business Analyst/ Data Analyst

Responsibilities:

  • Responsible for gathering requirements, from users (Traders & Risk Professionals), writing functional & technical specifications, for: (1) an in-house front office, trading application the main products are related to asset management of ABS (Asset Backed Securities), CDO (Collateralized debt obligations) and Whole Loan Mortgages; Mutual Funds and Risk Management System, which supplies risk analysts with intra-day and end-of-day speeds, status of modeled bonds, as well as market and credit risk information.
  • Extensive user interactions as part of discovery sessions to understand the user problem, current processes and the user needs.
  • Responsible for gathering business/data requirements, business rules identification and documenting them as requirement specifications (BRD).
  • Prepared process flows, data flow diagrams using MS Visio.
  • Worked with lead & project manager to prepare and maintain the project plans & project status reports. Analyzed data requirements from the users and assisted data analysts, data modelers and developers for interpreting the data definitions, fields & attributes.
  • Effectively liaised between business users & developers to resolve requirement issues.
  • Assisted QA testers to review the test scenarios, test cases & defect analysis and worked closely for functional, integration and regression testing.
  • Wrote basic SQL queries for validating the data and the business rules.
  • Frequently worked with SQL to create basic statements: select, updated, delete, insert, create.
  • Applied Database concepts, DDL, DML.

Confidential, New York, NY

Business Analyst/ Data Analyst

Responsibilities:

  • Understood existing enterprise data warehouse architecture and logical/physical data models to get improved vision of how data flows across the enterprise/across the applications and across the systems while gathering data requirements for the Single family / multifamily domain.
  • Analyzed existing data to identify critical data elements from their existing Capital Markets, Mutual Funds and Mortgages, understood derivation logic (data lineage), perform source to target data mapping, elicit data requirements, and converted them into BRD and SRS.
  • Enforced key enterprise data warehouse architecture standards, including table structures, naming conventions, key definition and generation, optimization etc
  • Elicited requirements using interviews, document analysis, requirements workshops, storyboards, site visits, business process descriptions, use cases, scenarios, event lists, business analysis, competitive product analysis, task and workflow analysis, and/or viewpoints.
  • Facilitated JAD Sessions, design review and architecture review sessions.
  • Designed data flow diagrams, process flows, data model and context diagrams to provide visual representation of data to the business users.
  • Represented requirements using alternative views, such as analysis models (diagrams), prototypes, or scenarios, where appropriate. Decomposed, refined and documented Requirements using a variety of graphical and textual techniques, to include Use Case Scenarios and Diagrams, Functional Requirements Specifications, Activity and Process Diagrams, and Data Dictionaries.
  • Validated ETL scripts/logic and provided assistance during SIT for successful execution of all the ETL processes necessary for Data Movement.
  • Responsible for recommending the upgrades required in application development, Data integration Model.
  • Debugging Stored Procedures, developing and documenting the existing process.
  • Intensive Data analysis on the log tables to ensure that the clean Data gets in the Integration Model.
  • Responsible to understand and apply Data quality rules and assess the impact in terms of business and technical risk.

Hire Now