SUMMARY

• 10 years of significant experience as a Business Analyst in various phases of software development life cycle (SDLC) in finance, insurance, retail, pharmaceutical, and telecommunication domains.
• 8 years of experience in teh IT industry wif 7 years of experience as a Business Analyst in Salesforce.com Customer Relationship Management (CRM) process.
• Experience in Oracle E - Business Suite (Oracle 11i, R12 - Financials Module).
• Deep knowledge of Oracle E-Business Suite (EBS) and Oracle Supply Chain Applications, including GL, AP, AR, Cash, Order, Fixed Assets, CRM, Cost Management, Human Resources Management, Projects, Project Manufacturing and Manufacturing Applications.
• Extensive knowledge of Salesforce.com implementation cycle in Sales, Marketing, Service and support modules.
• Subject matter expert in SFDC Administrative tasks like creating Profiles, defining Roles, assigning Users, setting permissions, constructing Page Layouts, enabling Email Services, Approval processes, Workflow alerts and actions, generating Reports and Dashboards, Lead and Case assignment rules.
• Experience in Salesforce.com CRM integration, developing and deploying custom integration solutions. Excellent skills in creating/troubleshooting/modifying APEX code, S-Controls and Visualforce pages.
• Have vast experience in onsite/offshore working model wif various clients across USA and India.
• Domain expertise coupled wif technical expertise to perform requirements gathering, requirement analysis, project planning, use case designing and impact analysis of architectural change in “as-is” vs “to-be” product.
• Experienced in agile methodologies (scrum, extreme programming) as well as typical waterfall model.
• Highly proficient in preparing Business Requirement documents (BRD), Functional Requirement Documents (FRD), User Requirement Document (URD), essential in bridging teh gap between Business Management and teh Development Teams.
• Expert in identifying business and functional requirements; creating global metrics, trend charts and other decision-making tools, leading data-modeling and process-mapping initiatives and designing/re-engineering processes, workflows and technology solutions.
• Expertise in preparing workflows, business process models and mock-up screens which can be transposed to technical requirements.
• Extensive experience in data analysis, writing data mapping documents, data transformation rules and maintaining data dictionary for business intelligence and data warehouse applications.
• Extensive Salesforce knowledge and hands on experience wif solution design, workflow implementation, complex customizations, data loading, configuring and administering features available on Marketing Cloud, Sales Cloud and Service Cloud.
• Wrote complex SOQL, SOSL queries across multiple objects wifin teh SFDC database.
• Knowledge in data migration from Traditional applications to Salesforce, data warehousing concepts and ETL processes using Data loader, ETL tools such as Informatica and reporting tools like Business Objects.
• Worked wif Eclipse IDE wif Force.com Plug-in environment for writing Business logic in Apex Programming Language, Target App Exchange Product and Salesforce Mobile Experience.
• Installed Salesforce Apps, configured and maintained user security permissions in compliance wif organizational needs.
• Expert in migrating data from various systems into Salesforce CRM using ETL tools - Informatica on Demand, Cast Iron (CI) experience, to synchronize data between Sales.com and web service endpoints. Data Junction (Pervasive), Excel connector and DQC.
• Hands on experience in using Data loader for data management in force.com platform and good knowledge in cast Iron and Informatica.
• Worked wif Salesforce.com sandbox and production environments. Expertise in developing web based GUIs using Applets, Servlets, JSP, HTML, JavaScript, CSS, and Java Swing.
• Working experience on Web Services (XML, WSDL, SOAP,REST, SSI) & web integration wif SDFC.
• Experienced in working on Oracle 9i/10g, SQL Server 2000, and SQL databases. Hands on working experience wif Stored procedures, Triggers and Functions using PL/SQL and AJAX.
• Expertise in Requirements Engineering techniques like use case diagrams, activity diagrams, process flow diagrams and sequence diagrams.
• Proficient in Unified Modeling Language (UML), VISIO, Object Oriented Analysis and Design techniques (OOAD) and version controls to include teh addendums.
• Comprehensive Knowledge in reviewing Test Procedures, extensively worked wif teh QA Team in executing teh Test Plans for UAT, providing Test Data, creating Test Cases, analyzing bugs, interacting wif team members in fixing errors and also assisted in Post - Production support. Worked on Black box, White box Testing and also worked wif stakeholders to obtain deliverable sign-offs.
• Experience in integration testing, system testing, and GUI testing.

TECHNICAL SKILLS

CRM: Salesforce

Salesforce: APEX, Webservices, Visual force, Triggers, Work flow rules, Webservices API, Reporing, Inbound & Outbound job, Reporing, AJAX, Javascript, Dashboards, SOQL, SOSL, APP EXCHANGE

Languages: C, C++, C#, CSS, MySQL, SQL, VBA, Java, VB Script, ESQL and HTML, XML

Technologies: Snapshots, Case Management Automation, Custom Objects

Tools: SQL Server management Studio, SQL Profiler, Performance monitor, Microsoft visual studio2005/2008, Microsoft Office Suite, OBIEE

Database: Oracle 10g-11i-R12, SQL Server 2000/2005/2008, MS Access

Data Modeling: UML, MS Visio

Load Testing: LoadRunner, Test Director

Operating Systems: Windows 95/98/2000/XP/NT/Vista, MAC OSX, UNIX/Linux

Domain Knowledge: Utilities, Life Insurance, Group Insurance (Dental, Vision, EAP), E-commerce, Finance, Pharmaceuticals.

PROFESSIONAL EXPERIENCE

Confidential - Hicksville, NY

Sr. Business Analyst

Responsibilities:

• Programming and monitoring of teh Distribution Automation SCADA control system.
• Utilize SAS to analyze real data provided by Electrical Circuits via OMS(Outage management System).
• Collect and reviewed industry and competitor data and built customized databases.
• Perform regression analysis, basket analysis, segmentation analysis, and correlation analysis.
• Analyze feasibility of business requirements for ERP execution, performed cost-benefit analysis for building a consolidated data platform and defined scope, found out dependencies by interacting wif Management Business Analysts, other Subject Matter Experts, Product Owner, Project Manager and Technical Lead.
• Meet wif every department's stakeholders to elicit requirements using techniques such as Business Rule Analysis, Structured Interviews, Job Shadowing, Process modeling and Document Analysis.
• Create a Macro Document incorporating components of Business Requirement Document (BRD) and System Requirement Specification (SRS) incorporating business, functional, non-functional, data and GUI requirements which would in turn serve as teh centerpiece of teh project.
• Help teh Product Owner to Prioritize teh Product Backlog items for developing Sprint tasks by taking technical suggestions from teh cross-functional development team.
• Develop, maintain and track teh progress of teh team by teh means of Sprint Burn Down charts as well as calculated teh velocity of teh scrum team for improved Project Management.
• Facilitated DA in Creating Staging Area, Source, Target Databases for ETL and data mapping using Informatica.
• Help in designing Data models and conducted normalization and de-normalization of data to fit OLTP and OLAP frameworks, slicing and dicing of data marts for analytical decision making support.
• Logged and tracked teh defects using HP ALM and created an error repository and managed teh testing process wif teh QA team.
• Assist in teh creation of deployment flow chart in conjunction wif development, infrastructure, and network teams containing information for maintaining Application.
• Create training scripts, training module, training curriculum and operating manual.

Environment: Waterfall-Scrum Hybrid, SharePoint 2013, Tableau, Rally, MS Office 2007 (MS Word, MS Excel, MS PowerPoint), MySQL server 2012, UML, HP ALM 11.5, Informatica v9x, JAVA, MS Project, SOAP Web Services

Confidential - Rahway NJ

Sr. Business Analyst

Responsibilities:

• Assuming a leadership role in teh area of requirements definition and application best practices and assisting wif determining project scope wif project managers and sponsors.
• Gatheird and documented use cases, detailed business requirements and developed process flow. Also prepared Business Requirement documents (BRD), Functional Requirement Documents (FRD), User Requirement Document (URD), essential in bridging teh gap between Business Management and teh Development Teams. Conducted walkthroughs and delivered teh signed - off business requirements document (BRD) and system specification document (SSD) for teh financial transactions and reporting needs.
• Followed teh UML based methods using Rational Rose and Visio to to create Use Cases, Activity Diagrams/State Chart Diagrams, Sequesnce Diagrams, Collaborations Diagrams.
• Responsible for identifying, analyzing, measuring and managing project risks & ensuring that projects conformed to required standards.
• Assisting business analyst team wif analytical skills, to critically evaluate teh information gatheird from multiple sources, assess risk, reconcile conflicts, and decompose high-level information into details, abstract up from low-level information to a more general understanding.
• Provide daily/on-demand updates on all business analyst related project tasks/deliverables including requirements sign-offs to PMO and escalating issues to senior level management.
• Collaborating wif key business stakeholders, PMO, IT management (development, architect and QA), and various departments as it relates to business analyst contribution to project success.
• Build positive working relationships wif clients, business stakeholders, clients, and project team members. Serving as key communication liaison between business and IT resources.
• Participating in company strategic planning, budgeting and quality improvement activities.
• Well-verse wif all phases of Software Development Life Cycle (SDLC) using various methodologies like Waterfall and Agile.
• Owned and authored User Requirements Document; Create logical level data models.
• Automated teh Charge back process -- Business Case; Created Automated chargeback process for Pharma side where teh system was working wif manual chargeback process. Generating RD20 and process document.

Environment: PL/SQL, Shell Scripts, Adobe Acrobat 9, HP ALM, SharePoint, MS Project, MS Visio

Confidential, Great Neck, NJ

Sr. Business Analyst/Project Manager

Responsibilities:

• Responsible for teh project management throughout teh entire project lifecycle, including project initiation/proposals, project delivery, business liaison / stakeholder management, post implementation review and project close out / handover.
• Expertise in Project Management i.e. Project Scoping, Planning, Estimating, Scheduling, Organizing, Directing, Controlling, Budgeting and Drafting Remedy Procedures.
• Single point of contact for all communications between teh customer and company.
• Managing staff to ensure that all milestones are achieved wifin teh agreed timeframes.
• Ensuring TEMPeffective quality control processes are in place to monitor deliverables produced.
• Responsible for identifying, analysing, measuring and managing project risks & ensuring that projects conform to required standards.
• Conducting regular impact analysis in order to assess teh consequences of teh project deliverables on other sections of teh business.
• Assisting teh technical team in their design and development tasks & producing project definitions to include validated functional requirements, scope, roles, responsibilities, timescales and resources.
• Well-versed wif all phases of Software Development Life Cycle (SDLC) using various methodologies like Waterfall, Spiral and Agile.
• Identify, track, and maintain an inventory of business needs to be defined in detail for application systems;
• Analyze, document, and validate detailed business and user requirements; Identify gaps between system capabilities and business requirements and map capabilities to requirements to ensure that business needs are met;
• Develop business area process models, activity diagrams and use cases.
• Own and author User Requirements Document; Create logical level data models;
• Assist wif Business Requirements Document (BRD); Assess solution alternatives; Develop and manage data to assist in User acceptance testing (UAT); Work wif client to establish and maintain business priorities for system solutions; Understand Otsuka's project management and contribute to defining work plans and keeping track of progress.
• Use standardized SDLC model for end-to-end project management (from concept through delivery and support); Manage validated systems in life sciences; Deliver Business Process Management (BPM) solutions for automated workflow systems; Provide content management and digital asset management solution to Otsuka web environment.
• Work wif Oracle Hyperion to perform Business Intelligence ("BI") analysis for budgeting, forecasting, management reporting and analysis, including ad hoc requests from management. Primary reports are planning and forecasting, including administration, training and monthly/annual development of consolidated forecast.
• Multi-Org Workflows for Procure to pay in Oracle R12 - Business Case; Generating RD20 user requirement document; understanding teh process working wif Oracle team to implement teh solution as per teh URS. Generate Deployment plan along wif UAT test script. MD50 and MD70 functional and technical document.
• EDI files automation of process for Medical Device wif proper information.
• Automate teh Charge back process -- Business Case; Created Automated chargeback process for Pharma side where teh system was working wif manual chargeback process. Generating RD20 and process document.
• Creating Automated process for on boarding teh vendors.
• Remediation teh issue of Clearing account wifing oracle wif teh halp of Accounting to have proper COGS rules to be define in teh back end and documenting teh process; Creating proper accounting rules
• Process Improvement; Take ownership of issue logs, project status documents, mapping specifications, test plans and test cases. Ensure current and accurate documentation for teh system is maintained;
• Define teh business requirements for all Oracle Business Intelligence Enterprise Edition (OBIEE) reporting parameters including name, type, business description, owner, users, frequency of generation, currency of data, and teh priority. Act as a liaison between clients and teh development team understanding clients' needs and writing development requests for teh development team to evaluate specifications.

Environment: Oracle R12, SharePoint 2011, Tablau, Hyperion, OBIEE, Clear Quest, ClearCase, MS-Visio, RUP, MS-Office, Quality Center, JIRA, Windows, Eclipse.

Confidential, Great Neck, NY

Sr. Business Analyst/Admin

Responsibilities:

• Assuming a leadership role in teh area of requirements definition and application best practices and assisting wif determining project scope wif project managers and sponsors.
• Gatheird and documented use cases, detailed business requirements and developed process flow. Also prepared Business Requirement documents (BRD), Functional Requirement Documents (FRD), User Requirement Document (URD), essential in bridging teh gap between Business Management and teh Development Teams. Conducted walkthroughs and delivered teh signed - off business requirements document (BRD) and system specification document (SSD) for teh financial transactions and reporting needs.
• Conducted Joint Application Development (JAD) sessions wif stakeholders throughout SDLC.
• Moved data from SAP to SFDC using Informatica On-Demand Tool and completed data migration.
• Involved in integrating Salesforce CRM wif its ERP (Oracle EBS) system.
• Experience wif Sales cloud and service cloud.
• Customized teh dashboards to monitor lead activities based on sales geography.
• Generated different reports like standard, summary and matrix for quarterly and half yearly sales.
• Worked wif Apex Data loader for loading teh Leads, Opportunities and their related activities into salesforce.com.
• Developed various Visualforce Pages, Apex Triggers to include extra functionality and wrote Apex Classes and Controller to provide functionality to teh visual pages.
• Wrote Apex Trigger, Visualforce pages, JavaScript, Web services design & development and donor databases integration for websites.
• Implemented teh requirements on Salesforce.com platform and Force.com IDE Plug-in using Eclipse.
• Worked on various AppExchange products according to teh needs of teh organization.
• Worked on various Salesforce.com standard objects like Case Management, Accounts, Contacts, Content, Reports and Workspaces.
• Developed and supported Extraction, Transformation and Load process (ETL) using Informatica.
• Communicated regularly wif teh SFDC designated super users to support them in their role and provide information and training on new features and functionality.
• Performed analysis on inbound/outbound file layouts and analyze sample data to identify teh transformation rules wif respect to teh business logic.
• Analyzed teh existing reports and backtracked teh reports to teh feeds - to identify teh gaps in teh data elements needed to produce customized reports for teh new venture.
• Worked wif QA team to design test plan and test cases for System testing and User Acceptance Testing (UAT).
• Performed GAP analysis between teh source and target system and proposed changes to teh feed layouts to accommodate prudential data elements and teh processing rules.
• Liaised wif business SMEs, development team and QA teams.
• Updated System Change Request (SCR) forms for enhancements or change requests and implemented version controls across all impacted documents.
• Traced test cases and functional specifications to System Specification Requirements.
• Reported teh status, metrics, risks, issues and mitigation plan to various stake holders of teh project.

Environment: Saleforce.com platform, Apttus, Apex Language, Visualforce (Pages, Component & Controllers), Salesforce.com Data Loader, Workflow & Approvals, Reports, Service Cloud, Oracle 10g, Custom Objects, Custom Tabs, Email Services, HTML, Java Script, Java, Web Services, WSDL, Sandbox, Eclipse IDE Plug-in, Oracle, Windows.

Confidential

Responsibilities:

• Worked wif multiple departments to understand complex business processes, and configure applications and systems into efficient technical solutions.
• Captured input, business rules from business users through JAD/Requirement gathering sessions and defined scope of teh project.
• Created Functional Requirement Document and Software Requirement Specifications for teh design solutions based on teh requirement.
• Created Test case documents based on use cases for Integration testing and UAT.
• Actively involved in business process analysis for Case management, Opportunity Management, Product Management, Quote Management, and Ordering Process.
• Perform due diligence to understand teh existing framework of teh various applications.
• Perform analysis on teh coverage of existing regression test suite to minimize teh knowledge transition effort during teh startup phase.
• Gatheird teh functional requirements and created teh vision, scope, and other artifacts during teh inception phase of teh project.
• Designed, developed and deployed teh Custom objects, Page layouts, Custom tabs, Components.
• Coordinated wif vendors and legacy application team for integrating data flow wif Salesforce as centralized system.
• Created Formula Fields, Validation Rules, Workflow and approvals for teh flexibility and functionality of force platform application.
• Customize dashboard for various managerial view.
• Created multiple record types based on teh category of clients.
• Based on teh business requirements created multiple custom objects and fields (created lookup fields to maintain relationship between objects).
• Worked on maintaining teh functional areas of accounts, contacts, leads, campaigns, opportunities, quotes, activities, dashboards.
• Participated in business requirement definition workshops along wif client SMEs and analyzed teh GAP in teh new product.
• Defined teh business process models and milestone deliverables for teh various phases of teh project.
• Created workflows, screen mock-ups, use case diagrams, activity diagrams, and sequence diagrams.
• Assisted in architecture analysis and design using UML and Rational tools.
• Documented and delivered teh signed - off business requirements document (BRD) for teh commencement of coding.
• Conducted Joint Application Development (JAD) sessions wif stakeholders throughout SDLC to resolve open issues.
• Worked wif QA team to design test plan and test cases for System testing and User Acceptance Testing (UAT).
• Interfaced wif business users to prepare and update Business Process Requirements (BPR) and Software System Requirements (SSR).
• Performed GAP analysis of business rules, business and system process flows and requirements.
• Documented and maintained teh business rules catalogue.
• Created SQLs to analyze teh data pattern to accommodate teh various business scenarios.
• Liaised wif business SMEs, development team and QA teams.
• Created induction manuals for training new joinees.
• Traced test cases and functional specifications to System Specification Requirements.
• Reported teh status, metrics, risks, issues and mitigation plan to various stake holders of teh project.

Environment: VB, VBscript, SQL, HP Quality Center, Quicktest Pro,VBScripts, Saleforce.com platform, Apex, Visualforce, Data Loader, HTML, Java Script, Workflow & Approvals, Custom Objects, Custom Tabs, Email Services, Security Controls, Sandboxes(Developer sandbox, Configuration only, Full sandbox) Eclipse IDE Plug-inAdobe Acrobat 9,Crystal Reports, Windows XP, VISIO.

Confidential, NY

Business Analyst

Responsibilities:

• Lead design discussions wif users, technical and functional stakeholders to analyze Salesforce.com functional, technical, integration and data needs and clarify, refine and document requirements.
• Primarily involved in developing prototype of teh application as proof of concept (POC) for business team and as a guideline for development team.
• Critically evaluated information and data from multiple sources. Reconciled differences and troubleshoot issues.
• Decomposed high-level business needs into Salesforce.com requirements and explained detailed technical concepts at a high level.
• Collaborated wif developers, product managers, subject matter experts and users to communicate teh proposed solution vision and analyzed tradeoffs between usability and performance needs.
• Translated requirements into application and operational deliverables.
• Researched business requirements, documented user stories, test cases and collaborated wif SFDC developers to estimate level of effort
• Created various Custom objects, Tabs, Workflows, Reports, Apex triggers and validation rules for teh application.
• Created Email templates in Text, HTML and VisualForce necessary for teh application.
• Analyzed and Created Custom Profiles as required for teh business needs and implemented Object level, Field level and Record level security.
• Devised Salesforce.com solutions based on business problems. Teh designs included requirements documentation, graphical representations, and presentations that described teh desired solution and product features. Documentation included business process flows, security access matrix, data mapping tables, integration diagrams, RACIs, application prototypes, user stories and specific, testable functional requirements.
• Used Data loader for all data adding, updating, and deleting, exporting data.
• Used Eclipse IDE for building scripts and deployment.
• Documented Sales force fundamentals and reporting for easy understanding and navigation for business users.
• Acted as a liaison between teh application development team, technology teams and product managers.
• Exhibited solid understanding of project management practices, SDLC and Agile deliverables.
• Managed requirements delivery to: create and review backlog, plan sprint releases, manage releases builds and deployments, manage release expectation and communication wif product management and users.
• Manage change control process to halp prioritize and estimate enhancements requests. Lead user advisory board and review sprints
• Assist business Super Users wif creating Salesforce reports, dashboards, email templates.
• Proven ability to lead teams, create action plans & resolve obstacles to achieve deadlines.

Environment: MS Access, UML, MS Visio 2008, Microsoft Office 2008, MS Project, Visual Studio 2008 professional, MS Expression 2008, Visual Source Safe, Salesforce.com, Apex Classes, VisualForce Pages, Data Loader, Workflow Alerts, Approvals, Validation Rules, Sharing rules, Reports, Standard & Custom Objects, Tabs, Email Templates, Roles, Profiles, HTML, Force.com IDE.

Confidential, Hicksville, NY

Business Analyst

Responsibilities:

• Implemented and identified improvements to teh existing interfaces and processes.
• Reworked Inventory and BOM to ensure they are TEMPeffectively tracked in Oracle Install Base.
• Efficiently organized test plan and scenarios for functionality testing and conducted business end-to-end manual testing.
• Granted exceptional assistance to teh OM Team in conducting daily activities utilizing Service Contracts.
• Proactively facilitated teh IT team in renewal and consolidation of Service Contracts data on a monthly basis to generate renewal letters.
• Functioned TEMPeffectively in improving teh client’s order processing ability by 70% through implementing database tools, which successfully led to a Q4 revenue realization of over $22 million in Service Contracts.
• Accurately documented defects and communicated issues during daily Scrum meetings.
• TEMPEffectively resolved end-user issues and questions for Service Contracts, OM, and IB.
• Professionally conducted end-user training for Service Contracts, Order Management, and Install Base.
• Expertly granted production support across Sales Online, Oracle Order Management, Oracle Install Base, Oracle Discoverer and Custom Billing application.
• Conducted root cause analysis of issues and worked wif track lead and development to provide fixes.
• Accurately created test cases and conduct unit, integration and user acceptance testing.
• Efficiently used Quality Center for bug reporting and defect tracking.
• TEMPEffectively designed and deployed business reports using Oracle Discoverer.
• Actively participated in requirement gathering from business users to integrate Salesforce and Oracle EBS.
• TEMPEffectively conducted user acceptance, unit, integration, usability, and regression testing between teh Oracle application and Salesforce as well generate and grant support to SRs all teh way through issue resolution.
• Ensured identification of software problems, accurately wrote easy-to-follow bug reports and log them into bug tracking database; monitored teh development and verified fixes.

Environment: Oracle E-Business Suite R12, Oracle Install Base, Order Management, Shipping, Inventory, Oracle Sales Online, Oracle Discoverer, Sales Store, Oracle Incentive Compensation, Salesforce