We provide IT Staff Augmentation Services!

Sr Business Analyst (edw/bi) Resume

Chicago, IL

SUMMARY

  • A Seasoned Business Analyst/Business Systems Analyst with over 10 years of diversified experience in Information Technology with an emphasis on Business Requirement gathering, Business Process Flow/Management, Business Re - Engineering, Business Modeling, and Quality Assurance of application software.
  • Possess exhibited credentials in translating business requirements into cost-effective and high-performance IT Solutions.
  • Well established analytical, critical and problem solving skills. Have exceptional oral and written communication skills with certified management and leadership qualities.
  • Experienced in RUP, Waterfall, Agile, Spiral, and Evolutionary Methodologies.
  • Project management skills which Involves high level implementation plans, data and process models, cost estimating, Risk assessments cost benefits analysis, and return on investments.
  • Facilitating Workshops, RAD, JAD and DRP Sessions.
  • In-depth knowledge of creating activity, logical, Sequence and Robustness to extract business process flows and workflows, thereby helping development and quality assurance in understanding the requirements.
  • Proficient at Rational Rose, creating detailed Use-Case Models, DFD, Use Cases, and Sequence Diagrams and Requirement Management tools such as Rational Requisite pro and Microsoft Visio.
  • Extensive Experience in EDW to BI integration (Data Mapping) and writing sql queries and stored procedures to fetch data.

TECHNICAL SKILLS

Test Management Tools: HP ALM, Test Manager, Jira.

Configuration Management tools: Clear case, SharePoint, Microsoft TFS.

ETL and BI tools: Abintio, Informatica, Erwin, Cognos, SAP-Bo, Obiee, Tableau, qlikview.

Databases: Sql Server, Oracle 11g, DB2.

CRM: Salesforce, Siebel .

Requirement Management Tools: Rational Requisite pro,MS project

PROFESSIONAL EXPERIENCE

Sr Business Analyst (EDW/BI)

Confidential, Chicago, IL

Responsibilities:

  • Involved in reviewing the, MD 70 to write the BR 100 Documents for OBIEE.
  • Facilitated in Data mapping for integrating HFM/OracleEbs/SalesforceCRM/OBIEE/BO.
  • Experienced in Requirement gathering from the Functional Teams of Agile PLM/SCM/Finance/HR/INV/OM teams for customized Reports to be built in OBIEE.
  • Involved in optimizing the performance Tuning of the OBIEE reports by identifying the bottle necks between Upstream and Downstream Components.
  • Interactwith user community to produce reporting requirements and liaise between technical and business teams to communicate solutions.
  • Facilitated the Workshops for Creating Wire Frames for Mcom, Ecom and Mobile.
  • Prototype solutions, preparetest scripts, and conducttestsfor data replication, extraction, loading, cleansing, and data modeling for data warehouses.
  • Extensively worked with Multiple BA of Oracle EBS (R12.2) for data mapping and Business Logic designing for Reporting (OBIEE) by decommissioning the Existing usage of SAP BO.
  • Used Requisite Pro for the Requirement Documents’ Preparation.
  • Proficient in the use of Rational Rose for Data Modeling.
  • Facilitated the Integration of Salesforce CRM to Reports used by Marketing Teams (Tableau)
  • Conducted JAD Sessions to develop an architectural solution that the application meets the business requirements, resolve open issues, and change requests.
  • Implemented and monitored Individual Development Plans focusing on total performance, including both quality and productivity.
  • Monitored client expectations through client involvement and communication throughout the lifecycle of the project; educate clients and stakeholders on the benefits and risks associated with the project.
  • Understanding the long-term business objectives and suggesting technical strategies to meet those objectives; introducing innovation to business processes through technology.
  • Assisting client in developing content or other materials; recommending enhancements and identifying new business requirements.

Sr Business Analyst/BI

Confidential, IL

Responsibilities:

  • Acted as a liaison between stakeholders: system users, clients and managers, who have a business problem and software development team to gather requirements for Mobile applications (IPhone/I pad/android) and ecommerce.
  • Collecting, understanding, and transmitting the business requirements for the project, and translating these into functional specifications and detailed test plans.
  • Conducting meetings/interviews and JAD sessions with stakeholders to collect business requirements.
  • Responsible for defining and documenting System Requirement Specifications in RequisitePro to promote communication and collaboration among team members and to reduce project risk.
  • Created mock-ups and wireframes for reports, dashboards, scorecards etc. based on the requirements
  • Created data modeling and analyzed business processes and requirements
  • Created functional specifications documents detailing the data metrics, dashboard designs and drivers of business needs
  • Worked with the data analyst to validated ETL mappings.
  • Extensively Involved in Siebel CRM as downstream data integrating to BI tools for Reporting used by Marketing and forecasting Teams.
  • Extensively Involved in BI reporting for Sales /Finance using Cognos Reporter.
  • Involved in Creating Source to target mapping, Data marts and Reporting for marketing Team using Tableau.
  • Extensively involved in IT Security requirements and identifying the risk assessments which consist of deployment/security/roles administration/ Network Security/ database systems.
  • Extensively involved in project management which Involves high level implementation plans, data and process models, cost estimating, cost benefits analysis, return on investments, risk assessments.
  • Extensively Involved in IT Audits for the Mobile/Ecom(iPhone/ipad/android/.com)
  • Creating Use Case Model and writing detailed use cases in conjunction with the project team, to define the features of the application, to be used by the development team.
  • Created Use Cases / Activity Diagrams / State Chart Diagrams, Sequence Diagrams, and Collaboration Diagrams thus defining the Data Process Model and Business Process Model using Visio.
  • Interacting with the stakeholders to review and baseline the design documents.
  • Overseeing and helping the QA team to devise the test plan for the application by explaining the vision document and the business case.

Business Analyst/BI/QA Lead

Confidential, IL

Responsibilities:

  • Develop conceptual design, scope of work, and functional specification documents.
  • Converted Business Requirements to the Functional Specification.
  • Interacting with the SMEs and stakeholders to get a better understanding of client business processes and gather business requirements.
  • Documenting workflows and results of business analysis and obtaining sign-off from client on specifications.
  • Used Requisite Pro for the Requirement Documents’ Preparation.
  • Proficient in the use of Rational Rose for Data Modeling.
  • Conducted JAD Sessions to develop an architectural solution that the application meets the business requirements, resolve open issues, and change requests.
  • Implemented and monitored Individual Development Plans focusing on total performance, including both quality and productivity.
  • Monitored client expectations through client involvement and communication throughout the lifecycle of the project; educate clients and stakeholders on the benefits and risks associated with the project.
  • Understanding the long-term business objectives and suggesting technical strategies to meet those objectives; introducing innovation to business processes through technology.
  • Assisting client in developing content or other materials; recommending enhancements and identifying new business requirements
  • Create Test cases with BPT’s and also maintained input data to run the test cases and BPT’ via QTP 9.2, following by migrating to QTP 9.5.
  • Experienced in querying the Oracle 11i database for validation for different environments such as staging and UAT.
  • Tested the mappings using Mapping Designer and worked with Aggregator, Lookup (connected and unconnected), Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.
  • Performed monitoring of the ETL jobs (Extraction, Transformation and Loading) by using Informatica power center Work Flow monitor 8.6.
  • Involved in Testing the Reports using Cognos Express Reporter v9.0 for the Various Extracted Data of multiple applications.
  • Involved in Excessive Production support and resolved Tickets for issues regarding data fix and functionality of the applications.
  • Experienced in running and debugging the UNIX scripts: HP UNIX for the daily cron jobs.
  • Created and maintained automated scripts and ran the scripts for regression testing in successive iterations.
  • Executed automated test cases in access with Keyword driven approach in different environments (UAT, Staging, Active Staging).

Business Analyst

Confidential, VA

Responsibilities:

  • Prepared Low level and High Level Design documents.
  • Supported discussions involving operations, business unit, and risk management resources
  • Implemented change control procedures
  • Written SQL overrides in Source Qualifier and Lookups according to business requirements
  • Implemented the business logic into coding and unit testing
  • Involved in Generating Reports using Cognos impromptu for cases used by Nurses.
  • Extensively Involved in Claims processing System.
  • Extensively used ETL to load data from XML source feed from vendor and Flat Files to Staging area using Informatica(8.1)
  • Participated in review meetings and helped resolve the system architecture
  • Assisted with product evaluation, product customization and system integration
  • Developed and documented complex solution requirements and provided consultation on the implementation of those solutions.
  • Performed extensive requirement analysis including data analysis.
  • Analyzed business needs and created or developed new functionality to meet them.
  • Participated in enhancement meetings to make the product more effective in real time.
  • Worked with developers and QA Analyst to clarify the SRS.
  • Used brainstorming, JAD, RAD and DRP sessions to generate ideas.

Business Analyst

Confidential, VA

Responsibilities:

  • Prepared interview questionnaires for the users and gathered requirements to write business specifications
  • Interfaced with business customers to determine and document business process flow.
  • Depicted As Is and To Be business process flow models and performed GAP Analysis.
  • Performed system analysis and developed Systems Use Case, Use case diagrams, Business flow diagrams, Activity diagrams and Sequence diagrams.
  • Developed UI Prototypes using VISIO.
  • Extensively Involved in Customer Portals for WMS.
  • Conducted JAD sessions with Business Users, SMEs, Business Analysts and Development team.
  • Conducted walk-through and design reviews with Business and Development teams.

Hire Now