SUMMARY

• Acompetent and experienced business analyst with over 14 year’s experience in managing multi - disciplinary teams of varying sizes and complex programs of work in healthcare, banking and telecom domain.
• Can build strong relationships with all stakeholders and to turn proposals into reality.
• Especially successful in management roles that demand rigor, a high level of drive and dedication and a focus on delivering business outcomes using methodologies.
• Good experience in business analysis, system analysis, requirement gathering, change management and product development.
• Experience as a senior business analyst and project manager across agile & waterfall models within the financial services industry.
• Expertise in New Relic insightsto provide relevant insights for customer analytics.
• Experienced in Business Process Redesign, defining Vision Documents using Microsoft Visio, interacting with stakeholders, understanding user requirements, and articulating them into User Requirement Specifications (Use Cases), user stories and managing backlog.
• Excellent Business writing skills in preparing Business Requirement Documents, Use Case Specifications, Functional Specifications, System Design Specifications (SDS), System Requirements Specifications (SRS), User Stories and Workflow Diagrams.
• Expertise in master data management.
• Expertise in LDAP and single sign-on user authentication.
• Responsible for business liaison / stakeholder management, post implementation review
• Expertise in Salesforce to connect withcustomers across sales, customer service, marketing, communities.
• Single point of contact for all communications between the customer and company.
• Managing staff to ensure that all milestones are achieved within the agreed timeframes.
• Expertise in data transformation, data loading and data modelling.
• Ensuring effective quality control processes are in place to monitor deliverables produced.
• Portfolio Management, SOW experience
• Used Microsoft Project Pro for O365 for project related activities.
• Provide PMO support for the planning, execution, performance, and closure of enterprise data warehouse projects.
• Monitor the progression of projects through the project lifecycle, identify gaps/risks/issues, and prepare management reporting.
• Managed MS SharePoint for team.
• Expertise in coding with Sql, pig and hive.
• Extensive experience supporting Enterprise class HCM applications like Oracle PeopleSoft.
• Worked on Share Point Migration from Office 2010 to 2013.
• Experience on working on Office365.
• O365 experience especially on OneDrive and SharePoint Online.
• Experience with business collaboration tools.
• Good Data analysis skills.
• Expertise working in IT Infrastructure Data Centre & Security technologies.
• Create and maintain key management reporting & systems of record for the PMO.
• Good knowledge of Microsoft Outlook.
• Expertise working in Pricing, Asset Management.
• Good understanding of trade life cycle.
• Responsible for identifying, analysing, measuring and managing project risks & ensuring that projects conform to required standards.
• Conducting regular impact analysis to assess the consequences of the project deliverables on other sections of the business.
• Assisting the technical team in their design and development tasks & producing project definitions to include validated functional requirements, scope, roles, responsibilities, timescales and resources.
• Well-versed with all phases of Software Development Life Cycle (SDLC) using various methodologies like Waterfall, Spiral and Agile.
• Good know of predictive modelling techniques and linear programming.
• Experienced in managing Offshore/Onshore Models.
• Experience with ITIL & IT Service Management (ITSM) methodologies.
• Experienced in leading a virtual team and proficient in virtual project management tool for e.g. MS Project
• Experience on working on LMS(e-learning) to provide
• Experience working on revenue forecasting tool -RevPro.
• Expertise in call tracking metrics through ServiceNow.
• Expertise in Rally for Agile development process.
• Good understanding of swift.
• Knowledge of Credit card authorization and settlement system.
• Working knowledge of Lync 2013.
• FileNet experience.
• Expertise in graphic design, report creation, web design, and web based content management tools, methods and processes.
• Experience on working on order management and contract management system.
• Proficient in Technical and Business Writing, Business Modelling, Business Process Flow, Business Process Modelling, Business Analysis and testing.
• Good knowledge of Supply chain domain.
• Expertise in PeopleSoft applications like Oracle PeopleSoft HCM.
• Good knowledge of Compliance/Audit in Financial domain.
• Expertise in the functional and technical aspects of Oracle E-Business Suite Application 11i.
• Expertise in Oracle Procurement, Expense reporting, Oracle Payables and Payments.
• Expertise in Virtual classroom administration.
• Expertise working on order management, contracts and fixed assets module and order to cash cycle.
• Good understanding of ERP/Supply Chain management process.
• Expertise in XML and HTML languages.
• Proficient in conducting GAP analysis, User Acceptance Testing (UAT). SWOT analysis, Cost benefit analysis and ROI analysis.
• Experience working in Financial domain in investment bank for employee fraud, POS, consumer lending and credit card, brokerage, capital markets related use cases.
• Expertise in Investment banking/Wealth management data.
• Expertise in Legal, Sales, Compliance.
• Good knowledge of IOS/Android eco-system and .net.
• Good understanding of UX.
• Knowledge of Google Drive, One Drive.
• Expertise in Investment banking/Wealth management data.
• Expertise in creating and managing, leading POC’s.
• Experience testing implemented systems and system changes including liaising with QA teams to develop test cases, test plans, test scenarios, and generating test data; and conducting manual testing (regression, end-to-end, functional)
• Strong communication, problem solving, organizational, interpersonal, and presentation skills.

TECHNICAL SKILLS

Methodologies: SDLC, Agile, Waterfall, Scrum Methodology

RDBMS/ DBMS: Oracle 10g, Oracle 11g, MS-Access, SQL SERVER 2000, Confidential Vertica. Teradata

Operating Systems: MSDOS, UNIX, Windows NT, 95, 2000, XP,7,8 10

Tools: SQL *PLUS, SQL *LOADER, Toad 9.7.2

Languages: PL/SQL, SQL, Java, C, C++, Python, XML, HTML

Reporting Application: Informatica Power Centre 8.6, Informatica MDM, Business Objects XI, Brio and Crystal Reports

Test Management tools: Quality Center. Jira

Microsoft technologies: Excel, Power point, Microsoft Word, Outlook

Dashboard & Data visualization: Tableau

Data modelling tool: Erwin

Data Analytics, dashboard & visualizing tool: New Relic Insights

Customer and Data Analytics: Microsoft Dynamics 365

Project Management: MS-Project

MS Sharepoint: 2013

E-Business Suite: Oracle Ebs R12, 11i

Peoplesoft tool: Oracle HCM

PROFESSIONAL EXPERIENCE

Confidential

Business Analyst/Data Analyst

Responsibilities:

• Lead and conducted Joint Application Development (JAD) sessions
• Developed RTM to track requirements and traced test cases and functional specifications against the RTM
• Developed use cases, workflow, screen mock-ups, and conversion requirements
• Validated technical designs created by IT developers against functional specifications
• Identified Business needs and developed appropriate solutions or recommendations
• Developed System, Regression, and Interface test cases from business and system requirements to verify system functionality
• Developed SQL queries to extract test data to support and validate testing results
• Prioritized outstanding defects and system problems, ensuring accuracy and deadlines were met
• Finalized documentation and Final Approval packets
• Developed and lead all training efforts
• Involved in various phases of development lifecycle, from gathering requirements, designing and creating logical/physical data models based on business requirements, technical design specifications
• Involved in preparing functional and technical design documents
• Draft Interface Specification
• Draft Data Dictionary
• Prepare User Interface Worksheet
• Expertise in master data management.
• Manage Test Databases for testing and data analysis

Confidential

Business Analyst/Data Analyst

Responsibilities:

• Expertise in New Relic insights to provide relevant insights for customer analytics.
• Expertise in Adobe Analytics in visualization, analysis of complex sets of data.
• Expertise in Predictive Analytics and Churn Analytics.
• Instrumental in providing key performance indicators, dashboards for marketing team Confidential &T.
• Manage UAT efforts for the team including writing the UAT test plan and test cases, executing test cases, managing defects to resolution for GMOTT project
• Translated business requirements into specific test scripts and case scenarios.
• Designed and executed UAT for GMOTT project.
• Logged and classified test execution findings.
• Expertise in Master Data Management
• Tracked and performed proper disposition of issues according to the established priority criteria.
• Analyzed and presented results to the different involved departments in periodic meetings.
• Collaborated with different departments to ensure the requirements were properly reflected in the UAT process and to determine if the necessary reporting could be performed.
• Data Querying and data visualization of real time data using New Relic Insights(NRQL) required to build Marketing Dashboards
• Creating custom and interactive dashboards using real time data
• Data validation of real time data.
• Expertise in New Relic insights to provide relevant insights for customer analytics.

Confidential

Business Analyst/Data Analyst

Responsibilities:

• Handling a team of 15 members involved in Business requirements gathering phase & business process redesign, defined vision documents using Microsoft Visio in Vertica, Hadoop, Informatica and Java technologies.
• Interacted with stakeholders and business key users.
• Expertise in Adobe Analytics in organizing and visualizing data in quick-reference dashboards and detailed reports.
• Expertise in data warehouse design, development, optimization.
• Expertise in Python testing framework to write test scripts for various modules and make sure that the newly designed modules are rigorously tested.
• Written various scripts and programs used for processing daily listing data received from various clients in Python.
• Designed various modules for the company's data processing architecture that can be reused by various processes required to manage and process data in Python.
• Involved in understanding of user requirements, and articulating them into User Requirement Specifications (Use Cases), user stories and managing backlog.
• Excellent business writing skills in preparing Business Requirement Documents, Use Case Specifications, Functional Specifications, System Design Specifications (SDS), System Requirements Specifications (SRS), User Stories and Workflow Diagrams.
• Expertise in business flow diagrams.
• Expertise in Investment Asset Management for deploying, operating, maintaining, upgrading, and disposing of assets cost-effectively.
• Expertise in Risk Management.
• Expertise in Cash Management
• Expertise in online banking, payment hubs.
• Expertise in data loading and data transformation.
• Data Analysis of historical data.
• Expertise in user support and rebuilding workflows and forms after migration SharePoint Online.
• Design and configuration of modules to enhance application functionality and improve system efficiency.
• Developed a detailed project plan with emphasis on timelines and deliverables.
• Involved in getting sign offs/approvals on Business requirement document (BRD) after meetings with stakeholders.
• Good knowledge of compliance/audit process.
• Utilized Ms. Project, to request resources to resource manager, book project times, capacity planning etc.
• Facilitated project board meetings, project kick off, initiation and reported directly to project sponsor and other team members.
• Expertise in working in Hadoop and Vertica (big data technologies).
• Determined work activity, tasks, release timelines, impact assessment, resource/environment dependencies, issues, constraints etc.
• Expertise in Tableau Desktop, Tableau Server, Tableau Online, Tableau Reader and Tableau Public.
• Data Visualization, Gap Analysis and Dashboard using Tableau
• Experience with SOW preparation.
• Defined roles and responsibilities.
• Expertise in Informatica MDM for data management.
• Expertise in Investment Asset Management for deploying, operating, maintaining, upgrading, and disposing of assets cost-effectively.
• Good Understanding of Core banking system(Finacle)
• Expertise in collaborating with Sales teams.
• Experience in providing pre-quote deliverables and deliverable data for Sales Teams.
• Expertise in data set validation
• Implementation of data best practices.
• Expertise in AML transaction monitoring platforms.
• Expertise in CCAR regulator y reporting.
• Expertise in Investment banking/Wealth management data.
• Experience working in employee fraud, POS and credit card processing, capital market, consumer lending, loans, credit card authorization, risk, financial management, brokerage, fixed assets, settlement system related use cases.
• Worked with business, SME, mortgage agents and correspondent, along with PMO and technical team to scope and prioritize functional requirements and development releases.
• Defined requirements for all workflow activities including analysis, design, testing, and implementation for mortgage lending and loan origination systems.
• Expertise in MS SharePoint usage to store project documentation, maintain project flow for audit purpose.
• Expertise in Cloud based systems.
• Expertise in financial accounting and financial statements.
• Expertise in addressing issues, identifying areas of improvement, escalation.
• Expertise in Marketplace Business Operators and the Marketplace 3rd party sellers.
• Expertise in Confidential PPM tool for project plans with requirements management, quality and performance testing efforts and maintaining compliance and reducing costs.
• Completed call tracking metrics through ServiceNow.
• Service Now utilization to create Service Requests and Service Items.
• Microsoft Dynamics to connect data across various sources for business Intelligence decisions, data analysis and track communications.

Confidential

Business Data Analyst

Responsibilities:

• Involved in business requirements gathering phase, use case preparation.
• Responsible for the documentation of business needs/requirements and testing requirements, applying the required methods and standards.
• Expertise in business flow diagrams using Microsoft Visio, Functional documentation preparation.
• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle.
• Visualization using BI tools like Tableau (dashboard).
• Expertise in hive & Sql.
• Expertise in analyses and configuration of new features in OneDrive and SharePoint Online.
• Developed project plans, specify goals, strategies, schedule and allocation of available resources.
• Assigned tasks among development team monitored and tracked progress of project following agile methodology.
• Developed the Design Document.
• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle.
• Responsible for planning, directing and coordinating projects from initiation through implementation
• Developed project plans and ensures that the scope and approach are fully understood by all stakeholders
• Expertise in SharePoint Online to maintain all project related activities and maintain project flow and ensure documents are maintained as per project standards.
• Expertise in learning management systems (LMS) and learning content management systems (LCMS) to provide content and curriculum for project.
• Expertise in Tableau for pulling reports and dashboard purpose.
• Expertise in SOW for project.
• Expertise in Salesforce to connect withcustomers across sales, customer service, marketing, communities.
• Managed a team of developers, business Analysts and test engineers working on consumer website redesign changes for Confidential ’s ecommerce site (store. Confidential .com).
• Created functional design documentation, managed and documented the requirements gathering, technical system analysis, and testing portions of a project to develop, deploy, support.
• Expertise in Salesforce to connect withcustomers across sales, customer service, marketing, communities.
• Created insightful automated dashboards and data visualizations to track key business metrics using tableau
• Expertise in SQL Server Integration Services (SSIS, SSAS & SSRS)
• Adhoc analysis of data and dashboards using Adobe Analytics.
• Used SQL on TOAD to upload catalogue updates to the content management platform.
• Writing user stories for the ordering and product catalogue workflow models.
• Wrapped up the technical documentation for integration points such as customer data, store data and pricing.
• Cleaning of user story backlog and updating the project timelines and scope.
• Developed project plans, specify goals, strategies, schedule and allocation of available resources
• Assigned tasks among development team monitored and tracked progress of project following agile methodology.
• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle.
• Responsible for planning, directing and coordinating projects from initiation through implementation
• Responsible for the documentation of business needs/requirements and testing requirements, applying the required methods and standards, as appropriate for the portfolio.
• Expertise in Tableau to perform gap analysis.
• Administrative expertise in handling virtual classrooms.
• Experience in MS Sharepoint 2013 to maintain project related documents.
• Expertise in either eCommerce business operations.
• Expertise in issue management, escalation management.
• Used Microsoft Dynamics to obtain centralized customer information, automate marketing interactions, facilitate communications and track sales

Confidential

Business Analyst/Data Analyst

Responsibilities:

• Identified, analysed, and documented business processes and Use Case Scenarios.
• Translated business requirements into usable functional requirements.
• Preparation of the business flow diagram for the project.
• Project scoping, project tracking, resource planning
• Cost estimation, time estimation.
• Queries executed in Teradata environment
• Developed project plans, specify goals, strategies, schedule and allocation of available resources
• Assigned tasks among development team monitored and tracked progress of project following agile methodology.
• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle.
• Identified, analysed, and documented business processes and Use Case Scenarios.
• Translated business requirements into usable functional requirements.
• MS Sharepoint expertise in maintaining the project flow.
• SOW expertise.
• Experienced in designing the OLAP systems for data mart applications using SQL Server Analysis Services 2000 & 2005(SSAS)
• Used scripts and variables, email notifications for ETL process using Data Integrator.
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Microsoft dynamics for data analysis and business intelligence decisions.