Raja Jagan ac7qpy@r.postjobfree.com

Sr. Business Analyst Mobile:+1-902-***-****

SUMMARY:

Over 6 years of Business Analysis experience in Information Technology and Insurance Sector.

Strong experience in project management tools like Microsoft Project, Word, Excel, Power Point, Outlook, and Visio for status reporting, project updates and project planning.

Experience in working with SDLC methodologies RUP (Rational Unified Process), Waterfall and Agile Scrum.

Sound knowledge of sales and marketing requirements of a global CRM system with excellent organizational, analytical, problem solving, planning and decision making skills

Organized and participated in Joint Application Development (JAD) and Joint Application Requirement gathering (JAR) Sessions

Strong experience with SharePoint, .Net, Business Java, PeopleSoft and SAP based applications.

Experience in developing Business Requirement Documents (BRDs), functional Design Documents, business process flows and flow charts.

Effective Project Scope Change Management and Configuration Change Management

Organized weekly Project Status and Task Review meetings

Well versed in working in a complex environment including onshore- offshore model.

Maintained constant communication with project team manager to report progress, identify issues, and allocate resources.

Expertise with UML tools, Swim lane diagrams applied for developing Use Case Diagrams, Activity and Sequence diagrams.

Excellent skills in writing Business Requirement Documents, Functional Requirement Documents, Systems Design Specification, Workflows and diagramming skills for drawing UML diagrams such as State diagrams and Class diagrams.

Proficient in developing efficient business relationships with various client teams in order to process and support requirements, develop tactical and strategic plans to implement technology solutions, and effectively manage client expectations.

Experience working with Reporting Packages, such as; Oracle Reports, Jasper Reports, Cognos, Business Objects

Extensive exposure to Software Development Life Cycle (SDLC) phases including Initiation, Planning and Design, Execution and Construction, monitoring and control and closing.

Expert in metrics development to measure performance

Well versed in creating project plan and task tracking, and resource utilization

Expert in analyzing existing operations and implementing effective systems, strategies and processes to improve organizational performance.

Excellent presentation skills and well experienced to present results to senior management

Ability to adapt in a rapidly changing, fast-paced work environment

Experienced in IT project budget analysis, outsourcing strategies and contract management with skills in writing proposals.

Expertise to prioritize projects and handle multiple tasks in meeting business objectives.

Excellent Interpersonal and Customer Relational Skills, proven communication, Organizational, Analytical, Presentation skills and Leadership Qualities.

TECHNICAL SKILLS:

Environment

C, Asp.Net 3.0, Java, HTML,

Framework/Methodologies

SDLC, Waterfall, Agile Modeling, Prototype Modeling, Scrum

Operating Systems

Windows 2000, NT, XP, Mac and UNIX

Databases

Oracle, SQL Server, MySQL

Data warehousing Tools

Business Objects, Informatica

Bug Tracking Tools

JIRA, TFS, MTM, Visual Studio, Rally

Utility Tools

MS Office Suite, MS Project, Adobe Photoshop

Reporting Tools

Crystal Reports, SQL Server Reports (SSRS)

Data Analytics

Text analytics, Tableau

PROFESSIONAL EXPERIENCE:

Barclays, Toronto, ON (Feb. 17 – Till Date) Sr. Business System Analyst

Roles and Responsibilities:

Conducted highly interactive JAD sessions with project stakeholders and the project management team to identify and resolve issues.

Involved in Rally workflows for bug tracking and project management.

Supported IT unit creating functional specification Utilized Agile methodology to configure and develop process, standards and procedures and created a Business Requirement Document (BRD).

Performed extensive GAP Analysis to understand the As-Is and To-Be conditions and determine the feasibility of the new project with the existing system.

Ensured compliance with established internal control procedures by examining records, reports, operating practices, and documentation

Educate and reinforce scrum methodology and agile framework to team members and key stakeholders

Derived functional specifications document based on the User Requirement Specification and used Rally for documenting requirements.

Verified and tested the functional aspect as per the business process and validated the interfaces with the other systems and data conversion from the legacy systems.

Documents for the design, development and implementation of strategic projects.

Created the design of physical and logical data warehouse models identifying data sources, data movement, interfaces, and analytics, while ensuring data quality.

Involved in defining the source to target data mappings, business rules and data definitions, System rules/validation, user interface requirement type and output requirement type.

Expertly respond to requests for data analysis and research. Identify and extract critical indicators from large and complex data sets and interpret in a business context.

Designed and deployed custom tabs, validation rules, workflow rules, custom dashboards, page layouts, portal documents and custom views to assist power users better utilize the Salesforce.com application.

Provide qualitative and quantitative analysis for detection of errors and abnormalities using data mining tool. Generate and present customized reports from the analyzed data to client.

Communicated Project Requirements, Business Issues, Solution and made recommendation.

Complete and thorough testing for the entire SDLC process.

Created Maintenance Transition Document for future users.

Conducted the Customer Acceptance Testing, System Acceptance and End-to-End testing.

Created customized reports using various types like text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts in excel and tableau.

Created proactive delivery reports using Tableau Desktop with both events-based and time-based subscriptions.

Remotely assist end users within Onsite Support.

Conducted Back End Testing on the database using SQL.

Writing SQL queries for data validation of the reports and dashboards as necessary.

Defined requirements through the Use Case and detailed supplementary specifications.

Develop, maintain and create functional test scripts within HP Quality Center.

Organized the information between the team members about the project with the help of MS SharePoint and for efficient collaboration across different user groups.

Coordinated deployment releases into various environments including TEST, UAT, DEMO, and Production.

Environment: MS Visio, MS Project, Rally, MS Office, Tableau, Microsoft Access, MS SQL Server, Adobe Creative Suite, HP Quality Center, Java, UML, MS Team Foundation Server (TFS), MS SharePoint.

Blue Cross Blue Shield Insurance, Toronto, ON (Oct. 15 - Jan. 17) Sr. Business Systems Analyst

Scope: The project was to analyze short-term and mid-term coverage needs of its customers to analyze the liability of the carrier and consequently contain business activities such as Risk Analysis, Risk Assessment & Management and Reinsurance policy. Created list and summary reports of customers by region, potential risk factors, household income, business income, property valuation and credibility of Insured Policyholders and their Properties and Projected Impact on Reinsured Investments.

Roles and Responsibilities:

Performed Carrier and Customer Analysis through Document Analysis by considering new Customer Enrollment Data, Product Data, Transactional Data, Demographic and Geographical preferences and created reports to identify Potential Risks and aide in Price Analysis and forecasted results for users.

Enhanced the Policy Administration system by adding elements taken from the Guide wire Policy center, Duck Creek ECM and Bridge Policy Administration system to Property and Casualty Insurance workflows to streamline the functional processes and aide in optimizing Automation in Underwriters functioning.

Technical aspects to create Deployment plans, Contingency Plans, resolving Blockers using Jenkins.

Continuously managed and improved build infrastructure for development teams, implementation of build scripts, continuous integration, infrastructure and deployment using Ansible and Trello for Project Management.

Worked with the Scrum Team and Product Owner to negotiate delivery of Minimum Viable Product. Assisted team in making achievable task commitments through user story selection and resizing, thereby reducing development time and facilitating the delivery of Potentially shippable product increment by the end of Sprint.

Tracked the team progress during sprint through Sprint burndown charts, task boards and defect matrix.

Defined the list codes and code conversions between the source systems and the Data Mart via staging layer using Reference Data Management (RDM) and modeled Data Flow into Metadata Repositories.

Developing Data Mapping, Data Governance, Transformation and Cleansing rules for the Master Data Management (MDM) Architecture involving OLTP, Operational Data Stores and OLAP.

Worked using a Decision Tree model to rank input variables based on the priorities set by Business owners.

Created workflow diagrams, SWOT and cost-benefit analysis report to help support Product initiatives.

Actively involved in reading data from varied file types like into Statistical Analysis System (SAS), created standard and Ad-hoc reports using Erwin. Generated delimited files and SQL script to load data into SQL tables.

Used Data Quality validation techniques to validate Critical Data Elements (CDE). Analyzed data contained by the databases using SQL and used Tableau for data accuracy and created reports to ensure Data Integrity.

Generated reports by employing complex data manipulation, creation and conversion of datasets from tables, flat files and analyzing the datasets and employed Informatica Power Center to perform Data Cleansing and create a Golden copy of Data matching with the single source of truth format prescribed in the Mater Data Management (MDM) architecture and structure of Metadata Repositories.

Monitored and tracked ongoing data quality levels regularly. Identified and established optimal approaches to resolve data quality issues. Supported Data Owners with resolution of data quality issues using Talend.

Managed source codes, software build, software versioning and defect tracking on software maintenance tasks/projects using GIT Version control system and documentation using Confluence.

Worked with Informatica Support for Master Data Management and Metadata Repository issues and upgrades.

Troubleshoot the automation of Installing and configuring applications in the test environments. Verified the results through automation testing using Selenium by scripting in Gherkins format. Logged defects using Jira.

Environment: MS Visio, SAS, Talend, RDM, Selenium, MS Project, Rally, MS Office, Tableau, Microsoft Access, MS SQL Server, Adobe Creative Suite, MS Team Foundation Server (TFS), MS SharePoint.

EBay Inc. Mississauga, ON (Sep 14 – Sep 15)

Business Analyst/Design Engineer

EBay Inc. is an American multinational corporation and e-commerce company, providing consumer-to-consumer & business to consumer sales services via Internet. It is headquartered in San Jose, California. Mid of 2015 eBay Suffered massive security breach, and advised all users must change their passwords, similar efforts were implemented to implement more security layers amongst all applications worked on in eBay network, providing the 2factor authentication (2FA) via bastion hosts and re-zoning for the current security network systems and applications.

Roles and Responsibilities:

Drives proposal reviews and assessments to ensure

The business drivers and high level requirements are captured for the impact assessment.

High-level estimates (effort, resources and budget) are developed for review by the requestor.

Partners with key project stakeholders (Technology, Business Partners) to refine the functional requirements in alignment with the scope of the project, the expected timeline and quality objectives.

Partners with Business Partners to ensure the BRD are/is accurate and complete.

Responsible for working closely with the core project team (Business Partners and Technical Lead) to deliver the Detailed Requirements Document (DRD).

Worked on securing customer facing web based applications and customer portals.

Partners with technical team (Technical Lead, Shared Services Team) to define the functional design specifications.

Partners with technical team to define system integration scripts and production hand-off document (PHD)

Reviews and approves project deliverables, such as the technical specifications and test plans

Coordinates with various teams (Vendor/TCOE/Business Partners) for functional and systems integration testing.

Supports issue investigation and resolution during the testing phase (system integration testing, regression testing, performance testing, user acceptance testing)

Provides support to Business Users to enable them to execute the UAT.

Designed and developed Use Cases, Activity Diagrams, and Swim lane diagrams, using Unified Modeling Language (UML), and with Rational Rose.

Maintains project documentation in project repository (Project SharePoint Site) to reflect current updates and promote documentation current state.

Proactively identifies, and escalates external functional dependencies to the Project Manager and works with project team to resolve.

Proactively identifies and escalates key risks and issues to the Project Manager and works with project team to resolve.

At the end of Design phase, provides effort estimate to Project Manager to establish the Level 1 estimate for effort and schedule.

Supports Project Manager to communicate the scope, dependencies and impact/risk to the production environment for the release coordination to the Release/Change Management Team.

Provides subject matter expertise to assess the impact of proposed scope changes (CRs) on the project deliverables (effort estimate).

Prepared weekly and monthly status reports and score cards to share with senior project managers.

Created monthly power point project status reports to show progress to senior leadership.

Partners with Project Manager to collaborate with Operations team throughout project lifecycle to ensure seamless transition through knowledge transfer and the production hand off document (PHD) process.

Environment: MS Outlook, MS Office, ADDM, CMDB, Firewall Tracker, Rational Rose, Rational Requisite Pro, Rational Clear Quest, SharePoint, HTML, MS Project, MS Office, Macromedia Flash, M.S.Visio, M.S. Project, Dreamweaver, J2EE, SQL.

Bank of America, NYC, NY (Sep 12 - Aug 14)

Business Analyst

Roles and Responsibilities:

Performed requirements gathering from the business users of the system while adhering to SDLC (Software Development Life Cycle) industry best practices.

Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams.

Coordinate with garnishment specialist in working with Accounts Payable and Treasury to balance garnishment deductions and vendor payments.

Analyzed information and requirements and documented them. Reviewed the Business Requirement document and detailed the Systems Requirement document.

Reviewed business requirements document for ACH (automatic clearing house) through interviews, surveys, prototyping and observing from senior managers and UI (User Interface).

Developed and customized batch and real-time client interfaces supporting Money Transfer, Automated Clearing House (ACH) and credit card processing.

Designed different document templates to gather Business Requirements, Change Requests and UAT.

Worked with QA testing team to design test methods to verify the applications functions of consumer loan, home equity, refinance and commercial loan activities

Worked with development and product management to determine resource needs, test requirements / strategy, and defect management process.

Prioritized outstanding defects and system problems. Identified and participated in resolution of business system issues.

Wrote User Acceptance Test Plan based on business user requirements and reviewed Test Plan templates.

Delivered and maintained extensive documentation for future extendibility of the system.

Environment: MS Visio, MS Project, Rally, MS Office, Tableau, Microsoft Access, MS SQL Server, Adobe Creative Suite, HP Quality Center, Java, UML, MS Team Foundation Server (TFS), MS SharePoint.

Education:

Masters in Computer Science from New Jersey Institute of Technology, New Jersey, USA.

Contact this candidate