SUMMARY:

• 8+ Years of professional experience as a Business system Analyst in financial services industry developing various web based applications with strong knowledge in Software Development Life Cycle methodologies Like Waterfall andAgile.
• Strong understanding of construction projects and operations.
• Extensive experience in analyzing and requirements gathering and writing system functional specifications including use cases.
• Created several templates, reports and queries in Business Warehouse as part of the simplification process.
• Excellent in Developing and evaluating business process Models.
• Evolved, implemented, and rolled out multiple SDLC processes for many customers Engagements lasted from a few weeks to a few years.
• Good knowledge of the claims process and how that process is related to the FACETS system.
• Designed and Developed an Informatica Mappings which generate an XPF Key Word File (Target Flat File) which will be loaded into the target tables using Facets XPF import batch job.
• Elicit, analyze, and manage requirements for software solutions, systems, and/or business processes translating business objectives into IT speak.
• Strong experience in RUP Business Modeling process.
• Connoisseur in documenting Business Requirements Document (BRDs), Functional Requirements Document (FRDs), Non - Functional Requirements Documents, Use Cases, Test Cases and User Interface Prototypes.
• Responsible for completing Phase Three scope - consolidation of local mail archives (PSTs)from 32 facilities into new Enterprise Vault archiving system.
• Vast experience conducting and documenting the As-Is/To-Be processes andBusinessProcess Re-engineering (BPR) exercises according to theAgileMethodology.
• Fluent in ecommerce platforms (OracleATGcommerce and Comergent), ERP systems (JD Edwards EnterpriseOne, SAP), CRM (Siebel), ETL tools (Informatica), Middleware (OFM), Content Management systems (Adobe CQ,OracleEM),OracleEndeca for Guided search and Navigation and Analytics/Reporting tools (Tableau).
• International experience asSAPMM/PP FunctionalAnalystincluding full lifecycle implementation using ASAP methodology in Discrete manufacturing environments.
• Worked in ECC, S/4 HANA versions ofSAP.
• Experience Financial, Statistical & Business Intelligence Reporting: Crystal Reports, SAP, Business Objects, Excel, & SSRS (horizontal markets- finance, billing, resources, metrics, B2B, B2C, process improvement, operations)
• Creating daily reports and tasks efficiently. Member of 2 projects which spans multiple departments - Coordinating with different stakeholders for handover4 and migration of processes, Excel, Microsoft Access, Crystal Reports, Raisers Edge, SQL Server 2012, Office 365, PL/SQL, Windows, Power BI.
• Create and facilitate efficient and cost effective solutions and analyze systems specification to meet business requirements.
• Organize and conduct multiple training sessions by department to show the functionality and benefits of each newly implemented system, software, and/or business process.
• Attend key meetings, both internal and external, and report findings from the meetings.
• Design and develop models for econometric and quantitative analysis around product.
• Analyze and assess data usage and product performance for maintenance prioritization and compliance with service level agreements.
• Utilized advanced MS Excel to manipulate data and support DSS - Decision Support Systems
• Experience in using Unified Modeling Language (UML) for creating Use Case Diagrams, Business Process Model, Class Diagrams, Activity Diagrams, Sequence Diagrams, and work flow diagrams
• Hands-on experience on Tableau Desktop, Tableau Reader and Tableau Server
• First-hand experience in Waterfall and Agile (Scrum) methodology of Software Development Life Cycle (SDLC)
• Driving multiple JAD sessions to capture the business needs vs wants
• Solid understanding of Business Process definition, Risk Analysis and SDLC methodologies.
• Promodel, MS Excel, MS Access, MS Visio, technical assessment tools, Micro Strategy Data Warehouse Data Modeling and Design.
• Marketing Analyst specializing in multi-channel campaign design, execution and analysis. Passion for supporting innovative and dynamic marketing strategies through data endorsed and customer focused direct communications.
• Experience Financial, Statistical & Business Intelligence Reporting: Crystal Reports, SAP, Business Objects, Excel, & SSRS (horizontal markets- finance, billing, resources, metrics, B2B, B2C, process improvement, operations)
• Collaborate on product launch plans and servicing requirements
• Developed business solutions for SAP Customer Master Data configuration to support new SAP Hybris Cloud 4 Customer Project.
• Developed business solutions by leveraging SAP SD HANA & Material Master Data configuration to support new e-commerce Hybris Project.
• Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, Master Data Management (MDM), ETL, OLAP, Business Intelligence, Client/Server applications.
• Utilized SLT to integrate SAP ECC master data to Hybris using SLT private cloud. Created the VPN with RFC connection from SLT to ECC/CRM and Hana and replicated the master data and Target groups using control tables dd02L, dd025 and dd08. Initiated the Initial load and Delta for the update
• Familiar with new SAP CRM package tool to extract data into SAP Hybris
• Exposure to Client/Server, Web Application developmental tools and Software development and design.
• Demonstrated ability to identify root causes of problems, consider both the long and short-term impact of proposed solutions and develop workable solutions. Ability to manage (Multiple) project tasks with changing priorities and tight deadlines. Ability to work well in a team. Open to Team related tasks, team meetings, team interaction and conference calls.
• Research and analysis of data, market needs, and customer issues
• Experience with ATG / Oracle Commerce and/or Endeca.
• Training the clients on Oracle Web Commerce ATG modules including B2C/ Commerce/ CSC/ BCC/ Endeca/ Repository/ Content Management/ Personalization/ and other.
• Develop client software to consume already published web SOAP services to interface with Hybris and Endeca.
• Business analysis
• QA
• Modeling
• Gap analysis
• Software
• Systems design
• Functional specification
• JAD
• MDM
• Business rules
• Process flow
• Data flow
• Business intelligence
• Acceptance testing
• SAP
• Reporting
• Impact analysis
• Retail
• Data modeling
• Hybris
• Legacy systems

TECHNICAL SKILLS:

Software/Hardware: RUP, Agile/ SCRUM framework, and Waterfall. SQL, HTML and XML. Database Oracle 10g/9i/8i, DB2, MS SQL Server Office Tools MS Office (Package), MS Visio, MS Project, MS FrontPage. Ecommerce Platforms SAP hybris, FACETS, Oracle ATG, IBM WCS commerce, Magento, Fry's, Blue Martin, SAP MM, HANA,SD, CR, CA. ORACLE, DATABASE, E-BUSINESS,ORDER MANAGEMENT,ORACLE FORMS.

Operating Systems: Windows Server

Databases: Progress, MS Access, Oracle, SQL Server

Methodologies: SDLC, QA Life Cycle, Waterfall Development, Agile Development, Data Extraction, Data Visualization, Complex Data Analysis

PROFESSIONAL EXPERIENCE:

Business/data Analyst

Confidential - San Jose, CA

Responsibilities:

• Developed business solutions by leveraging SAP SD HANA & Material Master Data configuration to support new e-commerce Hybris Project.
• Experience in Designing and implementing data integration modules for extracting, transforming, and loading (ETL) functions.
• Worked on Gap Analysis.
• Provide business analysis reports, Ad Hoc reports and business reviews to Executive team.
• Followed entire SDLC life cycle in this project from Requirement, Design, Coding, Testing and implementation.
• Defined and implemented SDLC Time Line for the Projects.
• Budgeting for freight, marketing, and vendor trade shows.
• Guided, coached, and developed team of three Finance para-professionals; aligned work with company goals and guaranteed team responsibilities were efficiently and effectively executed.
• Involved for defining the data conversion meetings and historical requirements and build systematic data conversion programs accordingly and provided Facets prospective in those processes.
• Intensively in involved in the Data Mapping meetings and process, used Crosswalk file prepared by Enrollment system (Medisys / Facets) and updated the Files (Design Documents) to send required field values to the downstream system for their payment to providers.
• Performed Facets Data Analysis and data mapping between Facets Data elements and downstream system's requirements.
• Worked on Bill Print information system for Taglines info related to billing area in Facets.
• Involved in the Data Migration meeting and process to provide feedback from Facets side based on its technical functionality.
• Gathered, analyzed, reviewed and documented design documents & business requirements, functional specifications/requirements and Use Case Document relating to business requirements to learn the scope and purpose of the application.
• Adhered to latest industry standards like Agile Business Rules Development (ABRD) & deliver high quality ABRD documents.
• Reviewed the developed product with Development before the release cycle and worked with development to fix issues.
• Retrieve all sales, purchasing, and inventory data regularly and present detailed analysis to upper management which suggests ways to drive sales while reducing costs.
• Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Business Intelligence, Client/Server applications.
• Actively participated in the weekly status report meetings between team lead, developers, SME and Project Manager.
• Extensive experience in developing Use Cases, creating Screen Mockups, conducting Gap Analysis and Impact, Analysis, SWOT analysis, Cost Benefit Analysis, Risk Analysis.
• Develop business solution for Customer Master Data configuration to support new e-commerce Hybris Project.
• Worked on a global team to support and implement SAP/SD and Master Data in other business units.
• DidSAPCRM Master Data, Lead management, Opportunity management and Pricing configuration, complex integrations with external systems, Incentive and Commission management, Claims process scenarios.
• Participated in the development of Guidewire Billing Center, Billing Center - Policy Center User Stories.
• Interacted with the Guidewire team to modify the Out of the Box logic based on Sentry's business need.
• Handled requirements gathering workshops of AS-IS and TO-BE process &BusinessBlueprinting workshops at the Client location and providing theSAPCRM solution as per the requirements
• Integrated Hybris with SAP ECC and CRM using Data Hub core extension, Used Hybris Data hub and processed the data using CRM customer, ECC product, order and utilized synchronous and asynchronous integration using IDOCS in the backend.
• Provide SQL Reports to marketing strategy managers for marketing opportunity to existing as well as prospect customers.
• Expertise in Installing, Configuring core InformaticaMDMHub components such as Informatica MDMHub Store, Hub Server, Cleanse Match Server, Cleanse Adapter (Address Doctor), IDD & Resource kit.
• Extensive experience in theomni natureenvironments with knowledge of Microsoft commerce ATG suite and websphere.
• Experience in several facets ofMDMimplementations including Data Profiling, metadata acquisition, data migration, validation.
• Successfully, setup the data and configured the components needed by Hierarchy Manager forMDMHUB implementation which included implementing hierarchies, relationships types, packages and profiles by using hierarchies' tool in model workbench.
• Dataanalysis of existingdatabase to understand thedataflow and business rule applied to differentdatabases by SQL.
• Modify and/or create SOPs for all existing and new business processes ensuring clean and accurate documentation
• Conducted meetings with the business and technical team to gather necessary analytical data requirements in JAD sessions.
• Used complex pre-defined and Ad-Hoc SQL queries for data validation, duplication, forward/reverse engineering for data mapping and ETL for data migration from the ERP/OLTP to the Data warehouse/OLAP system
• Responsible for data mapping and data mediation between the source data table and WMO data tables using MS Access and MS Excel.
• Experience in Conceptual, logical/physical database design & review sessions to determine and describe data flow. Excellence in delivering Quality Conceptual, Logical and Physical Data Models for Multiple projects involving various new and Existing Applications across Enterprise and Data Warehouse.
• Utilized Hybris configurable product (CPQ). This solution used existing configurable products setup for SAP Variant Configuration (VC), Integrates CPQ configuration user experience and process in Hybris to SAP backend.
• Utilized SLT to integrate SAP ECC master data to Hybris using SLT private cloud. Created the VPN with RFC connection from SLT to ECC/CRM and Hana and replicated the master data and Target groups using control tables dd02L, dd025 and dd08. Initiated the Initial load and Delta for the update .
• Worked with Data load team and used spreadsheet to load variant configuration data from Legacy system toSAPand involved in migration of master data from test landscape all the way to production environment.
• Familiar with new SAP CRM package tool to extract data into SAP Hybris involved in design of a SAP based solution for the Energy Company. The harmonized solution envisages the usage of SAP Hybris.
• Utilized SAP Hybris for search and merchandising, content management, Order management, product information management and digital asset management
• Hybris marketing is utilized to created the target group using Customer data management of Hybris.
• FosterAgileprinciples and methods for requirement gathering.
• Facilitate Agile rapid and meaningful releases
• Architected the commerce solutions such as B2B and B2C scenarios on the Hybris Platform and conducted the requirement and design sessions.
• Worked with Hybris Report Cockpit for the report dashboard
• Worked with Hybris Product cockpit for the product and catalog modeling
• Worked with Hybris CMS cockpit for the content management
• An in depth understanding of how to integrate Hybris with a corporate back office fulfillment product like SAP and CMS systems.
• Design the system architecture for the project, Design data models for Customer, Products etc. Design the approach for the data migration into the Hybris system from SAP systems. Provided the integration strategy documents, Designed the classification hierarchy.

Business/data Analyst

Confidential - Framingham, MA

Responsibilities:

• Part of SWAT Team for website enhancement/maintenance involving Problem/ Incident/ Defect management across applications used for web portal management.
• Upgrade of ENDECA to latest versions to support additional regional languages (ENDECA is Catalog hosting platform integrated with Oracle to leverage direct procurement from preferred suppliers).
• Serve as liaison with the systems and Finance teams to ensure data feeds to LDC Suite are complete.
• Used Agile Software Development process viz. Scrum, as this was a time bound project.
• Coordinated data source identification, requirements and design reviews with the customer and Endeca to ensure a successful BI and search solution deployment.
• Organize and conduct multiple training sessions by department to show the functionality and benefits of each newly implemented system, software, and/or business process.
• Develop client software to consume already published web SOAP services to interface with Hybris and Endeca.
• Assist the Director of Treasury with strategic plans related to process efficiencies, cost reduction, interest rate risks and budget maintenance.
• Troubleshoot and resolved any issues related to the treasury application environment.
• Backup for Treasury Analyst for daily cash management, including monitoring cash receipts and disbursements, processing wire transfers, managing cash among multiple entities and ensuring Treasury policies and procedures for short-term borrowings.
• Evolved, implemented, and rolled out multiple SDLC processes for many customers.
• Developed Project plans, User Acceptance Testing (UAT), test cases and test plans for knowledge transfer to end-user.
• Analyzed test results including UI, Data Presentation, Output Documents, and consistency
• Created wireframes to comply with the layout of the ecommerce website and tested the high standard UX expected from the company
• Developed test cases and test scripts with system integration testing and User Acceptance Testing (UAT) to assist with Quality Assurance activities
• Performed GAP ANALYSIS between the "AS-IS" model of the legacy system and "TO-BE" model to identify the project gaps.
• Created Functional Specifications for reports, enhancements, interfaces betweenSAPand MES system.
• Helped super users onsite with any questions/issues related to the newSAPenvironment and incorrect postings.
• Experience with EDI / idoc interface betweenSAPand shopfloor system.
• Developed functional specifications and test scripts for Finance programs, reports and interfaces within SAP FICO module.
• Implemented ATG commerce suites for multiple sites and ran testing, data cleansing and data validation.
• Primary analyst for multi-channel Rewards Program Direct Marketing campaign initiatives encompassing campaign design, test and learn strategies, reporting and analysis.
• Identified the gaps in business and system requirements in integrating/ customizing ATG commerce suite in comparison with the legacy of online application.
• Defined the Trust and Validation rules and setting up the match/merge rule sets to get the right master records. Configured match rule set property by enabling search by rules inMDMaccording toBusinessRules.
• Provide data workflow, including legacy system profiling, mapping of data, documentation of business rule validations, and reconciliation of historical claims data for an enterprise integration of Guidewire Claim Center.
• Utilized the guidelines and artifacts of the Rational Unified Process (RUP) to develop a detailed Implementation of Rational Unified Process effort for Guidewire ClaimCenter Integration in different iterations and phases of the Software Development Life Cycle (SDLC).
• Followed domestic and international marketing laws while maintaining knowledge of those laws, and ensured policies, procedures, and reporting were in compliance for all subsidiaries.
• Involved with Data Steward Team for designing, documenting and configuring Informatica Data Director for supporting management ofMDMdata.
• Performed match/merge and ran match rules to check the effectiveness ofMDMprocess on data.
• Worked on data cleansing and standardization using the cleanse functions in InformaticaMDM.
• Helped solve issues with Endeca Dimensions in QA and Production to enable new categories.
• Responsible for day-to-day project management and business analysis for the support of client's e Commerce website, which is built on an Oracle/Endeca platform.
• Analyzing and estimating based on the existing workload and prioritize to meet assigned deadlines within available timeframe by partnering with respective stakeholders.
• Utilize Endeca, Coremetrics, Agility and Tealeaf software daily to optimize search, keep track of analytics, observe user behavior and create business rules for production.
• Developed Mobile website using Mobile commerce features in WebSphere Commerce7 which contains all key features online Catalog, receiving personalized marketing and promotions, completing transactions, obtaining store location information, and providing an accurate view of orders and inventory availability.
• Defining use case scenarios with respect to Oracle Commerce platform- ATG & Endeca Experience Manager for Retail Commerce.
• Possessed working knowledge in the Oracle ATG eCommerce technology stack, database design, data flows, PL/SQL.
• Assist testing teams in preparation and reviews of functional test scenarios which were implemented from the recent upgrade.
• Requirement gathering and analyze the system, design process flow & solution architecture and write functional specifications, which helped developers to design application in live operation projects.
• Created process flow diagrams, ER Diagrams using Microsoft Visio to fulfill business needs that comply with quality standards and meets functional requirement.
• Created data models, charts, reports and visualizations, calculated fields and dashboards using Power BI and Tableau.
• Involved in Facets billing module mainly in Back - End system process for membership's enrollment info to downstream system and involved in Front - End system process for the information feed to Facets from Source system WGS - Medisys - Facets file transfer process.
• Managed complex dynamic Excel and Tableau reports and ensured detailed day to day reporting.
• Worked with Scrum Master, Product Manager,Agilecoach and development teams throughout planning, design, development, testing, and implementation of feature product releases.
• FollowedAgile/Scrum Software Development Life Cycle methodology for project execution.
• Serve as a point of contact for the client's stakeholders and provided customer support in addition to team building with on and off shoreagileteams.
• Ability in gathering/reverse engineering existing functionality of application platforms through interaction with users and technical teams and Rollout of Oracle Applications to additional countries.
• Worked on WebSphere Commerce Catalog subsystem, Member subsystem, Order management subsystem, Account subsystem and Payment Subsystem.
• Worked on customizing WebSphere commerce accelerator to support Catalog Management system. Developed customized Controller and Task commands and performs WSC Utilities.
• Worked on web services to integrate third party tools (Google checkout, PayPal) with current application.
• Major accomplishments include several complex projects from commercial and personal lines of insurance - Allstate Business Insurance (Re-plat forming of Commercial lines of data where several old systems were replaced by a single new system through Lexis Nexus) was a big success with many other projects as well.
• Managing various problem tickets surfaced in existing applications through respective problem management tracker and worked to prioritize for appropriate defect fixture and resolution.
• Analyzing the reported issues logged by business users with in-depth analysis related to existing system design and worked towards fixture through appropriate mode like Incident management, Problem and Defect Management.

Business/data Analyst

Confidential - Minneapolis, MN

Responsibilities:

• Acted as a liaison betweenbusinessexecutives and project stakeholders by assisting them in gathering, understanding and documenting theirbusinessneeds.
• Laison between the business units, technology teams and support teams.
• Worked with traditional Waterfall methodology for gathering requirements for developing web application.
• Primary point-of-contact for business technology and vendors as it relates to configuration for Facets related projects driven by the Facets Business Support Team. Provides guidance to the Facets Business Support Team on the necessary configuration changes for enhancements the team will be delivering.
• Participated in identifying, understanding and documenting thebusinessrequirements including the applications capability of supporting the given requirements.
• Act as liaison between banking institutions and corporate treasury
• Interfaced with Treasury and entity management system users worldwide to ensure project completion.
• Assist the Director of Benefits, Treasury Manager and Treasurer in preparing budgets for medical, dental, disability, 401k, employee stock purchase program and executive compensation plans that includes deferred compensation, SERP and Cash Surrender Value.
• Perform treasury operational functions such as cash management, cash forecasting, interest rate monitoring and forecasting, capital funding and financial derivative analysis.
• Assist in developing and performing treasury transactions, including refinancing of long-term debt, processing letters of credit for worker's compensation and inventory and opening new stores nation-wide.
• Translated thebusinessneeds into system requirements, communicated with thebusinesson a non-technical level and with the SystemAnalyston a more technical level, depending on the granularity.
• Prepare Quarterly Business Reviews upon request.
• Proactively communicates and collaborates with external and internal customers to analyze information needs and functional requirements and delivers the following artifacts as needed: (Functional requirements, DSD, Business Requirements Documents, Use Cases, GUI, Screen and Interface designs.
• Create story board of back log items in Agile and develop item according to business needs.
• Tracking implementation in the full-SDLC in project alignment. Using JIRA/Confluence, MS Visio, Adobe, and other tools.
• Performed user interviews, JAD sessions. Wrote Functional requirements specification (FRS) documents, SWOT analysis as per the Business requirements and process flow. Supported the assigned project manager with creating detailed project plans and assisting in developing, scheduling and tracking project timelines. Involved in User Acceptance Testing (UAT).
• Developed functional specifications and test scripts for Finance programs, reports and interfaces within SAP FICO module.
• Involved in leading and completing every phase of the application development lifecycle (SDLC) in an IT Operations.
• Involved with client service and customer relationship team (CRM) to get the end users feedback about the application.
• Lead the User Acceptance testing which included identifying and developing test scripts withbusiness users and facilitated testing to ensure all of the Council's requirements were met.
• Collaborated with development architect and thebusinessto develop both high-level and detailed application architecture to meet thebusinessneeds.
• Created dashboards for the management to view the sprint progress of all the scrum teams. Conducted team scrums, leadership scrums, sprint planning, sprint showcases and sprint retrospectives. Facilitated User Acceptance testing (UAT) for the application as a Business User.
• Assisted the Project Manager in setting realistic project expectations and in evaluating the impact of changes on the organization and plans accordingly.
• Analyzed requirements for various reports, dashboards, scorecards and created proof of concept/prototype the same using Tableau desktop.
• Collected and documentedbusinessprocesses andbusinessrules.
• Dealt with issues such as transaction monitoring and filtering of data.
• Involved in testing on all stages of System Development Life Cycle (SDLC).
• Participated in integration testing, build verification testing and integration testing manually.
• Maintained Burn Down Charts, Sprint Backlog and Product Backlog Sheets.
• Managed client relationship to ensure service delivery per milestone and overall performance.
• Created Data Flow Diagrams (DFD) to depict the source-to-target Mapping and Data Lineage Analysis.
• Critically evaluating information gathered from multiple sources, reconcile conflicts, decompose high-level information into details, abstract up from low-level information to a general understanding, and distinguish user requests from the underlying true needs.
• Developed strategies with Quality Assurance group to implement Test Cases in Mercury Test Director for stress testing and UAT (User Acceptance Testing). Designed and developed project templates based on SDLC Methodology.
• Assisted QA team by reviewing test cases and clarifying requirements to ensure complete coverage of requirements, worked in Agile environment and was able to bring projects to completion. Creating Test script for UAT and coordinating UAT with Business.
• Facilitate professional and constant communication with overall users on the status of production problems that might arise and inform them about ways of resolving issues.