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.