SUMMARY:

• Extensive experience providing analysis for various Information Technology projects.
• Expertise gathering, analyzing and preparing documentation to include Business Requirement Documents, Functional Specifications, User Stories, Use Cases, UML Diagramming, Cloud Computing, Requirement Traceability Matrix, Project Charters and more.
• Exposure includes Web, CRM, and Data projects for organizations in different industries.

TECHNICAL SKILLS:

Miscellaneous: Agile, Scrum, Waterfall, Web Development, GUI, Web Services, Visio, Business Rules, Actuate Reports, Product Testing/Certification, ETL, MS Project, SharePoint, Project Scheduler, MS Office (Word, Excel, PowerPoint, Access), XML, HTML, .NET, SAP, PeopleSoft, Dynamics, CRM QA/Automation QTP 9, Win Runner 7.5, Load Runner 9

Databases: Oracle, SQL Server, DB2, SQL, PL/SQL, TOA

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Sr Business Analyst / Project Manager

• Responsible for driving requirements around Microsoft CRM and other web - based, application development projects. Requirements to support web applications, responsive UI designs, user experience, websites, systems integration, data conversions, etc.
• End-to-end SDLC experience and a thorough understanding of CRM concepts and how to develop custom, data-driven .NET applications
• Engage stakeholders to identify cross-functional product features and impacts to current business processes, operations, and platforms
• Gathered and created business requirements, user requirements, design and technical/functional specification documents. Documents were prepared by conducting JAD sessions through one-on-one meetings or group interviews
• Documented functional requirements across all technical aspects of the solution (UI, business rules, BRD, FRS, Use-Cases, Current State vs. Future State process flows, technical integrations, etc.)
• Reviewed loan applications and analyzed data required to process loan documents and performed validation to ensure loan documents are transmitted to appropriate departments.
• Worked and responsible for the scope, architecture, and requirements gathering sessions for various cloud computing and integration solutions.
• Support concurrent development process with standard Branching and Merge of application source code.
• Created and maintained several build definitions and publish profiles to handle automated builds in an Agile / SCRUM environment.
• Coordinated software application and database deployments across several environments and provided feedback and training to other full-time release engineering staff for production releases during off hours.
• Planning, implementing, maintaining, and updating security measures for maintaining integrity of data
• Experience working with Adobe Experience Manager (AEM) or CQ5
• Experienced in Microsoft Exchange, Microsoft SQL and Microsoft Share Point implementations and migrations
• Documented Test Plans and Test Cases for Unit/Integration/UAT. Facilitated User Acceptance Testing for the various inventory interfaces with stakeholders and users; fixed and verified the errors discovered via regression testing
• Responsible for Fit/Gap Analysis, Impact Analysis, functional and configuration design spec preparation and integration testing for PeopleSoft, SAP, Workday and HRIS initiatives.
• Worked and have knowledge on a pharmacy benefit manager (PBM) which is a third-party administrator (TPA) of prescription drug programs for commercial health plans etc
• Documented Product Backlogs (PBI), Epics, User Stories and Burn-Down charts; Agile/SCRUM methodology
• Prepared Testing Strategy, Test Plans, Testing Methodology, Test cases and Test Scripts for Testing on Web, GUI, and SAP ERP, on both Functional and Database applications.
• Researching, identifying, and mitigating security threats to information systems
• Installing firewall, anti-virus software, and data encryption programs
• Ability to effectively document, track, and troubleshoot CMS and web applications
• Act as a Scrum master while delivering project releases in compliance with SDLC standards using Agile and Waterfall methodologies (daily scrum meetings, grooming, retrospective meetings, etc.)
• Became the Subject Matter Expert (SME) by reputation for our HR department after answering many inquiries regarding SAP data structures, data, transactions, and reporting.
• Tracked project deliveries using project management tools.
• Anticipated and reduced the possibilities of security breaches and system failures
• Analyzed and determined root cause of security breaches and changed security controls
• Involved in the design of Workday HCM solution to ensure that all work streams are cohesive and cross functional impacts are considered
• Worked on converting process flow diagrams into more detailed requirements
• Worked in recovery management system
• Used sessions, workforce for running and loading the data from source to target data warehouse.
• Performed data analysis for the existing data warehouse and changed the internal schema for performance
• Create and execute SQL test scripts, and assist in the solution of data issues
• Developed and implemented financial analytical techniques for loan department and trained colleagues for effective financial analysis.
• Resolved a complex infrastructure issue by creating and utilizing a professional network of Scrum Masters, Product Owners and Technical Leads within the company
• Created Test cases and Test scripts for System Integration Testing (SIT), User Acceptance Testing (UAT) and Unit Integration Testing.
• Worked extensively on IBM Business Process Management tool as PEGA
• Performed activities and managed business requirements in JIRA

Confidential, Bloomington, IL

Sr. Business Analyst / Project Manager

• Engaged Program Leaders/Business Stakeholders, Application Owners, Product Owners, and Technical Delivery teams to understand business needs and identify appropriate solutions. Owned Theme/Initiative/Feature/User Story updates in Rally
• Worked on detailed business requirements, functional and non-functional requirements documents using a variety of structured techniques (e.g., use cases, business rules, UML modeling)
• Designed and builded complex fully integrated data solutions around OFSAA, including moving data from source systems into OFSAA and moving data back out.
• Worked in detail with regards to auto and consumer loan
• Worked with respective Project Development Managers to create business requirements and functional specifications documentation to aid in the facilitation of communications between UX, Digital Analytics, Content Management, eCommerce Development and Operations. Support Agile PLM end users with day-to-day issues
• Worked and experience in Migration of data from their legacy systems to Oracle Agile PLM.
• Conducted Joint Application Development sessions to clarify business requirements with business users and stakeholders
• Coordinated and conducted User Acceptance Testing, guiding business users in validating and verifying business requirements
• Designed and developed Use Cases, Use Case diagrams and Activity Diagrams for the various system components using Rational Rose.
• Worked on SAP MM-WM with knowledge of cross-functional modules such as, Sales and Distribution (SD), Quality Management (QM) and Finance (FICO).
• Involved in the integration of the PLM system with their Oracle EBS system and also implemented their business processes into Agile PLM system like New Part introduction, part creation. It also includes data migration from their legacy systems to Oracle Agile PLM space.
• Experience and worked in implementing integration solutions into and out of OFSAA applications.
• Involved in PeopleSoft Testing, Upgrading, Requirement Gathering, PeopleSoft 8.8 and 9.1, CRM 8.1 and 9.1.
• Created implementation plans for Web Content Management Systems (WCMS) including Sitecore, Adobe AEM
• Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings
• Possess comprehensive experience of CRM business processes like Campaign Management, Lead Management, Account Management, Case Management, Quote, Forecasting, and Call Center.
• Extensive experience of Salesforce.com implementation cycle in Sales, Marketing, Service and support modules.
• Involved in Change management from time to time
• Understanding foundational AEM concepts, including templates, components, dialogs, widgets, workflows and DAM.
• Engaged as a Lead Implementation Manager on a large Guidewire system implementation at a provincial worker’s compensation insurance company, interacting with clients to assist in definition of business requirements, coordinating offshore quality assurance
• Full lifecycle implementation experience in Salesforce Marketing Cloud experience as well as Salesforce Service Cloud
• Used Bing Maps API to update address coordinates in the Microsoft Dynamics CRM.
• Created the technical design specifications which detail the design changes required using People Tools, People Code, SQR's, Crystal report and Application Engine.
• Worked in designing integration solutions around OFSAA including both Data and Metadata.
• Creating several reconciliation analysis reports for coordination between PeopleSoft HCM (9.1) development team, Mainframe team, PeopleSoft financials team and various point solutions.
• Involved in Customized plant parameters for material requirement planning (MRP), consumption based planning and MRP information of material master is dumped to the legacy system from SAP via Interfaces.
• Design complex interfaces between PeopleSoft and other point solutions (8.9), such as interface from the recruitment system to PeopleSoft using Component Interface to process data load of new hires, rehires and internal transfer's employees. Experience implementing, upgrading, and supporting PeopleSoft HCM (HR, Benefits, Payroll, Self Service)
• Worked on various salesforce.com standard objects like Accounts, Contacts, Leads, Opportunities, Reports and Dashboards.
• Worked closely with the BPC resources on the Excel side to make them understand the flow of the SAP process in order scope efficiently.
• Performed Cost/Benefit analysis for upgrade from PeopleSoft 8.0 and 8.4 instances to a unified PeopleSoft 9.0 instance on an application by application basis.
• Created project plans for upgrade for PeopleSoft GL 8.0 and GL 8.4 to GL 9.0 and AP 8.4 to AP 9.0
• Successfully completed two SAP full life cycle implementations using ASAP methodology involving requirement gathering and analysis, designing business blue-print, configuration, testing and production support.
• Strong knowledge and experience in SAP Integration experience with BODS specifically handling Standard/Custom extractors
• Experience in SAP finance modules
• Created Test Scripts, developed SAP User Procedures, Training Curriculum and conducted Training Sessions for all levels of end users
• Designed and published visually rich and intuitively interactive Tableau workbooks and dashboards for executive decision making
• Develop, test, and implement Workday HCM Core Business Processes and Compensation

Confidential, St Cloud, MN

Business Analyst

• For various CRM and migration projects, worked with business/project stakeholders to identify business needs and use that as input to effectively create application/system scope and requirements documentation
• Managed business requirements, user requirements, technical and functional specification documents. JAD sessions, user interviews, etc.
• Collaboratively worked with development leads and architects during scope, requirements, and design processes to fully document the appropriate requirements according to business needs
• Prepared detailed scope/requirements documentation along with priority designations that development teams will use to plan, develop, test and implement application/system functionality
• Prepared business requirement, functional requirement, project scoping documents, work flow diagrams and business process flow diagrams using MS Visio.
• Monitor ongoing projects status and maintain communication with business unit leadership and affected stakeholders
• Configuring FI sub-areas including GL, AP, AR, Cost Center, Internal Order and Profit Center in CO area
• Working on new configuration for new company for FICO, MM, SD and WM module
• Communicate with Analysts and users in order to create some FI-MM, FI-SD and FI-WM integrations
• Implemented comprehensive Security functionality by importing users and groups from OID, setting up LDAP (OID) authentication and associating catalog objects and web modules with the created users and groups
• Experience working on Global Implementation projects for converting data from legacy - target systems
• Responsible for data manipulation and data validation using SQL queries in a MS SQL Server 2008 environment
• Used Informatica ETL methodology for supporting data extraction, transformations and loading processing, in a complex EDW
• Data validation by writing several complex SQL queries, conducting back-end testing and solving data quality issues
• Involved in the development of Informatica mappings and mapplets and also tuned them for optimal performance and dependencies
• Experience and performed data analysis and developing source to target mapping document for migration
• Responsible for archiving all project documents, conducted Retrospective meetings, project roll out and post-implementation product results tracking on SharePoint

Confidential, CA

Technical Business Analyst

• Acted as a liaison between the technical, business and testing groups to provide them with required specifications/documentation. Worked predominantly with the Supply Chain line of businesses to elicit, analyze and document complex business requirements.
• Conducted stakeholder Joint Application Design (JAD) interviews and facilitated meetings with project teams
• Revised purchase ordering algorithm to minimize overstock and reviewed purchase orders compiled by a colleague, achieving savings of 10-20% per inventory purchase
• Worked with the User Experience team to design the GUI for the application
• Responsible for GAP analysis and working on Client-Server application development, data analysis and data mapping.
• Expertise in Business Process Modeling and Use Case Modeling using Unified Modeling Language (UML) and Rational Rose tool.
• Work with Development and QA teams to transition business requirements into QA test cases and assist in UAT.
• Assisted other personnel on assignments including mentoring or providing on-the-job training to more junior associates. Mentor team members in business analysis principles, patterns, processes and practices.

Confidential, Warren, NJ

Technical Business Analyst

• Strong understanding and experience in various products within capital markets: Equities, Fixed Income, Mortgage Backed Securities, Asset Backed Securities and its trade life cycle (Trade Capture - Client and Reference data, clearing and settlements and Corporate Action)
• Serve as liaison for loan officers, applicants, mortgage underwriters, and others, ensuring communications remain open and loan processing applications function efficiently.
• Worked with Functional consultants and SAP developers to design the function modules for data extracts from SAP R3 systems
• Created effective Use Cases and identified Basic/Alternative flows.
• ETL design document which consists of the database structure, change data capture, error handling, and restart/refresh strategies
• Developed source to target mapping document for Item Master and Item Branch tables
• Executed SQL queries for data analysis and testing
• Tracked and maintained Stakeholder requested enhancements and changes using Requirement Traceability Matrix
• Used the Rational Unified Process to develop different phases of Software Development Life Cycle
• Helped in conducting Gap Analysis, User Acceptance Testing, System Integration testing and SWOT analysis
• Troubleshot issues in Crystal Enterprise 10 and Business Objects Enterprise XI
• Provided detailed daily commentary to explain variances in P&L with respect to risk factors and market forces

Confidential

Sr Business Analyst

• Managed business requirements, user requirements, technical and functional specification documents. JAD sessions, user interviews, etc.
• Collaboratively worked with development leads and architects during scope, requirements, and design processes to fully document the appropriate requirements according to business needs
• Prepared detailed scope/requirements documentation along with priority designations that development teams will use to plan, develop, test and implement application/system functionality
• Prepared business requirement, functional requirement, project scoping documents, work flow diagrams and business process flow diagrams using MS Visio.
• Monitor ongoing projects status and maintain communication with business unit leadership and affected stakeholders
• Worked with Functional consultants and SAP developers to design the function modules for data extracts from SAP R3 systems
• Created effective Use Cases and identified Basic/Alternative flows.