Sr Business Analyst Resume
NJ
SUMMARY
- Over 10 years of experience in Business Analysis, System Engineering, System Analysis, System Integration, Business Analytics, Data Analysis, Design, Development, Testing, Implementing, Scheduling, Support Project Management, of web based Financial & CRM, .Net, Java based web and mobile Applications, Data warehouse Enterprise and Cloud based Sales force applications
- Excellent Functional & Technical Knowledge of CRM Application Modules
- Experience in Project Estimating, Project Management, Costing, Team Co - ordination and Team Management.
- Extensive experience in Design and Architecture of Siebel based CRM applications including building of batch and real-time interfaces.
- Responsibilities handled including Architecture, Requirement analysis, system design, systems support, system development, testing, documentation and design reviews.
- Responsible for Design and Development of Interface Programs., Experience in Developing Web Services, ER Analysis, and Process modeling methodologies.
- Model the as-Is system and perform GAP analysis for the existing system in order to map it to the To-Be system.
- Experienced in Database Testing using SQL queries on RDBMS databases like Oracle, SQL Server and MS Access.
- Experience as a Functional consultant and Business analyst in Implementing CRM modules of Siebel/Oracle applications for OLTP and OLAP
- Generating Time and Cost estimates for projects from concept phase thru development to Testing phases
- Experienced in data interpretation with ability to recommend and implement changes to increase process efficiencies
- Experience in working on Business Process Management process and tools
- Experience in Unit Testing, Functional Testing, System Testing and Regression Testing of Applications from End to End perspective
- Experience with the full SDLC methodologies like Waterfall, Agile, and Lean/Six Sigma Methodologies.
- Experience in supporting Buss users in UCT,UAT,ORT Test cycles
- Experience in co-coordinating with Design/Dev./ST teams to make them understand the requirements/design solutions to work on their deliverables and support Project Backup plans
- Experience in giving sing-offs of Technical Design, Code Walk Thru and Test Cases/Scenarios.
- Analyze and documents client’s business requirements, process and communicate these requirements by constructing conceptual data and process models, including data dictionaries and volume estimates from organization
- Involved in Setups, Implementation, Configuration and Customization of ERP and CRM Applications
- Extensive Experience in development of Concurrent Programs, Conversions, and Customizations
- Perform new product research, evaluations and recommendations with process improvements.
- Strong Analytical, Inter personnel and Communication skills.
TECHNICAL SKILLS
CRM: Oracle e-Commerce Gateway, Oracle EDI Gateway, Contracts, Services, Teleservices, EDI, AOL, Sys Admin,Siebel communications, Siebel Sales, Campaign, Marketing, Siebel Analytics, Salesforce, Cloud Services
Tools: Erwin, Visio, MS Project,iRise, ReqPro,Caliber,SQL* Loader, Crystal Reports, Oracle Query Builder, SQL Navigator, ETL,TOAD .Oracle Discoverer,Power Designer, Informatica,Datastage,SQL Developer,DB2,SQL, Silk Automation, Server,ActiveVOS 9.0, Clear Quest,HP Quality Center
Siebel Tools: Siebel Tools, EAI, EIM, workflow manager, Siebel Analytics, Siebel Actuate, EBC, VBC. XML Spy
Languages: Java, JSP,EJB,CORBA, .NET,SQL, PL/SQL, .NET, Shell Scripts, C, HTML, Java Script, J Query Grid,VSS, XML,VB Script,WML,XSL,XPATH,XSLT
Netware: TCP/IP, FTP, HTTP, WAP, SOAP, SMPT Client, Telnet, Gopher, Netscape, Internet and Web services, C Oracle Gateway
Operating Systems: UNIX, Sun Solaris, HP - UX SVR4, Windows 2000/NT/XP/2008
Databases: Oracle, SQL Server, MS Access,PostgreSQL
Reports: Crystal Reports, SSRS, Actuate
PROFESSIONAL EXPERIENCE
Confidential, NJ
Sr Business Analyst
Responsibilities:
- Reviewing Artifacts like wire frames, Copy deck, content map & proto types and Author the SRS documents
- Develop use cases for the different business scenarios to halp business and test team
- Develop SRS and Interface Agreement Documents with multiple systems and their interactions and transactions identified,
- Conducting JAD sessions, Triage calls and Business Artifacts Reviews with all the Stakeholders and updating with the meeting minutes and also supporting CR reviews.
- Develop Project backup/rollback straggles, Risk Mitigation plans for any Contingencies and any Patch upgrade support
- Proactive role based on the high level scope and prepare POCs and also Showcase of functionality to the Business Stakeholders, Clients and Vendors
- Support the BVT,UAT. UCT and PE testing cycles and Triage calls in resolving the defects from tech teams
- Support the Estimates, Units of work, SWAG Analysis and Provide 85%,100 PIR Inputs, work with services teams in getting the data to be presented on the Online UI application
- Supported the Page Utility Matrix, Account Navigation Matrix and Activity Dropdown list changes for all the pages of the Online Application
- SIMON tool support for updating and maintaining the Entitlements for the access to the various user groups
- Analyzing the existing application AS IS flow and halping the Team with TO BE flows with the Data Mapping and Interface impacts for the BBI Project
- Working with various vendors like Fiserv(Billpay),Yodlee(My Financial Picture),Morning Star(Portfolio X Ray),SiftSort(Documents from My Advisory and Recognia(Technical Analysis) modules
- Reviewing Test cases and test Scripts to make sure all the use cases covered for all the business requirements
Environment: .Net Technologies ASP.Net,C#,AJAX,Java Script,XML,HTML,CSS,MVC, Webservices Snag It, SharePoint.,PostgreSQL
Confidential, Middletown, NJ
Sr Business Analyst
Responsibilities:
- Developing Functional (FRS)and System requirement documents(SRS) by working with business stakeholders
- Understanding the business objectives during the Project JAR and Designing solution in the JAD sessions.
- Scheduling the calls with external interfacing applications for system to system impacts and GAP Analysis
- Presentations to the user community with the Proto types and Demos for the new project initiatives.
- Reviewing the System test cases and halp team with baseline process and make sure they are in line with the requirements
- Facilitate large group meetings for JAD sessions, Demos, End-End flow walk thru and to review my Deliverables
- Supporting the Infrastructure team in getting the Development and Test Environments available for the team
- Developing the End to End Flows and the Business Process flows based on the requirements
- Developed custom Reports in Salesforce CRM for BDMs
- Mentoring the Jr Business Analysts and assign the Tasks appropriately
- Accepting the request from SFDC to create a new opportunity in ROME with the product information
- Developed Application for State Farm customer for Managing and Maintaining their multiple Sites Information for US and Canada locations
- Created user stories, participate in daily scrum meetings for supporting Sprint cycles
- Constructed complex T-SQL queries to validate the data in between Source Tables vs. Data warehouse as per the Transformations defined in Data Specification documents.
- Inbound web service comes from SFDC and in the response ROME send the opportunity id
- Translated stakeholder requirements into various documentation deliverables such as functional specifications, use cases, user stories, workflow/process diagrams, data flow/data model diagrams using MS Visio
- Migrated the Leads and Opportunity Management from Oracle CRM to Cloud based Salesforce CRM
- Data Analysis and writing logic to retrieve the data from Centralized database for different types of Orders, Services & Inventory
- Developing use case diagrams, data flows, business Process flows and wireframes for screen mockups.
- Support the users during the business verification (BVT)and user acceptance testing(UAT) cycles and also with DB Query and Reading the Logs to prepare the Root Cause Analysis(RCA)
- Experience with Agile Methodology and with Domain driven design and data modeling
- Migrated Java based Deal manager Application SFDC to put end to end process flows for Design,Price,Propose and Contract Module
- Handling Project Management activities with estimations, scheduling, tracking of design, development and test cycles using MS Project
- Supporting end users with Trainings and developing M&Ps
- Used Siebel CRM Assignment Manager functionality to achieve Submission of Support Request, Work Requests to different Inbox of Sales user with and without Load Balancing
- Experience in Data Analysis, Business Intelligence(BI) and ETL Loads
- Working on Tools - Clear Quest for Defect Tracking, SharePoint for Centralized Repository of all the Project Deliverables, TOAD/SQL developer to Read/Edit DB Tables and to execute SQL Queries, Irise for screen designs and Rally Dev. tool for Agile ad Requisite Pro for Requirements Traceability
Environment: Java, J2EE,Web Dev,JDE, JQuery, J Grid, JSPs,Datastage, SQL Server 2005/2008, TOAD, HP-ALM, REQPRO, JIRA, ITUP, ETL, Sharepoint, Siebel CRM,SFDC, Salesforce, SFDC,ActiveVOS,XML,Webservices,XSLT,XPATH,EBC,VBC,Java,Web Dev,ARTIX,SQL Developer, ReqPro,XML Spy, iRise, wire frames, MS Project,Visio,ReqPro,Clear Quest
Confidential, Middletown, NJ
Business Analyst
Responsibilities:
- Involved in Architecture, Design, implementation of the Siebel based Power communications eCRM application in the capacity of Project Architect and Engineering Team lead for Confidential &T’s world-wide implementation of the eCRM funnel management tool.
- Involved in designing the Siebel based eCRM application with Business users interaction for Designing the Technical approach for documenting in the SRD’s,HLDs, IADs and to build multiple architectural Proof Of Concept models
- Designing Real Time Interfaces using web services technology with inbound and outbound methods with different partner systems as part of Automation
- Designing batch and real-time interfaces from the legacy applications to the Siebel eCRM/ROME application and documenting them in the Interface Agreement Documents (IAD).
- System Engineering, Interacting with End-Users and writing the Design Documents and uploading into the Visual Source Safe (VSS), Clear Case and Prism tools
- Responsible for building, configuring & setup of the Assignment Manager Rules, Divisions, Org, Employees, LOVs to meet the Buss requirements.
- Defined Use Cases to define the Buss Processes for modules within eCRM application for Support Request, Opportunity Activities explaining the whole life cycle from Creation to Completion
- During the Requirements Review with Buss team, suggesting for Product Automation and Improving the Cycle Time and avoiding Duplicate efforts and halps them to reduce the cost of Project.
- Scheduling the Internal and External Review for HLDs and IADs and preparing Review sheets, Uploading in CQ tool and Completing Mapping in RMT and ReqPro tools
- Helping the Admins and Dev. Team in prep. Work of various environments before it is ready for testing
- Handled Triage calls, War rooms in finding the root cause of Defects and closing them with Dev./Admin Teams
- Identifying the Scrubs, Data Migration during the Design Phase
- Involved in designing interfaces for data migration and integrating with the legacy Oracle eCRM application.
- Implemented Guided Selling, Global Sales Enablement, FMO, PMO Enhancements supporting Design and UI mockups
- Developed New Initiatives for services IP Flex/IP TF /BVoIP(CIF), OEW - CIF ( Ethernet), IPTF & IPAG from concept phase till deployment and supported various interfaces development to support sales funnel tool
- Implemented the Complex Project, which impacted all the Interfaces that eCRM TEMPhas for HRID to BUID Global conversion
- Responsible for Analyzing, configuring & building the Email Templates based on different work flow policies and groups
- Created remote users, responsibilities, positions and Generated Crystal Reports for Business Analytics team
- Supporting the QA team during the phases of System Test, BVT, UAT and UCT and coordinating with Dev. Team in resolving the issues.
Environment: Siebel eCommunications,Siebel 7.5/7.8/8.0,siebel sales, Siebel marketing, Siebel tools,EAI,EIM,workflow manager, Siebel Analytics, Salesforce, HP Quality Center, Crystal Reports,ActiveVOS,DB2,XML,Webservices,XSLT,XPATH,EBC,VBC,Java,Web Dev,ARTIX,ReqPro,XML Spy,CQ,CC Tools,iRise, wire frames, MS Project,Visio.,ReqPro,Clear Quest .
Confidential, Middletown, NJ
Oracle CRM Consultant
Responsibilities:
- Creating the Test Scripts for testing the Oracle Sales Online Application for various Business Scenarios
- Creating Oracle Stored procedures for implementing the Business requirements
- Loading the Data from the flat files
- Customizing the sales online screens using Java,JSP and Java Script
- Creating the Scrubs using oracle PL/SQL for cleaning the Data
- Generating Ad-hoc reports and customized the existing reports using Oracle Discoverer
- Writing interface agreement documents for different downstream systems using web services
Environment: Oracle e-Business Suite, CRM Sales Online, Marketing, Online, Partners Online, Installed Base, Order Management (OM), Workflow, TCA, Forms 6i, Reports 6i, Oracle 8i, SQL, PL/SQL, Discoverer, SQL*Loader and SQL Navigator,.NET UNIX, XML,Webservices,XSLT,XPATH,Java,JSP,Java Script,EJB,CORBA,Oracle Discoverer.