SUMMARY:

• Senior Business Analyst with over 14 years of professional IT experience that includes Full Life Cycle Implementations, Requirements Gathering & Management, Analysis of Business Processes, Process Improvement, Quality Assurance, Project Management, Budgeting, Resource Allocation, Reporting, Documentation, Technical Analysis, Content management and GAP analysis
• Multi Industry/Domain experience: Finance & Banking, Retail & E - commerce, Aviation, Education, Healthcare, Insurance, IT services management and Hospitality
• Ability to collect and analyze complex BI data and translate into meaningful interpretation formats, Business analytics, summaries, reports and dashboards
• Excellent Expertise in implementation of Data Warehouse Concepts, Master Data Management (MDM), HR, Financial, CRM and ERP systems and applications
• Excellent knowledge in development methodologies and frameworks such as Agile, Waterfall, RAD, UML and ITIL v3
• Expertise and Specialization in designing and developing Digital Content Management Blue prints, UI/UX artifacts layouts, wireframes & mock ups, prototypes and Demo content
• Extensive experience with CMS applications and tools like Sitecore, Wordpress and Net Forum
• Proactive team player equally effective in independent and collaborative settings as well as experienced in coordinating with on-site and off-shore teams
• Capable of translating technical concepts, Designs, Business Rules and Logics, System Structure and Architecture, Data Concepts and Naming Conventions to non-technical stakeholders, Vendor teams, Users and Implementation partners
• Excellent Proficiency with Database concepts, Scripting languages (Java Script, PHP, Ruby, HTML, CSS) SQL queries, Manual and Automated test scripts, Data migrations, Mapping of data, ETL process, Business Intelligence concepts & management, Digital Communications, Web services/API testing Office 365 products

TECHNICAL SKILLS:

Databases: MS Access, My SQL, Oracle, People Soft, SAP Hana

Testing Tools: Visual Studio 2010 (TFS), ALM HP Quality Center, Quick Test Professional, Jira

Testing Methods: Manual & Automated, Black, White & Grey box Testing, System Testing, UAT, Data & Regression etc.

Operating Systems: IOS, UNIX, Microsoft Windows NT/ 98, 2000/XP/10, Android

Languages:: SQL, C++, VB Script, HTML, PHP, Java Script

Tools: MS Word, Excel, Access, PowerPoint, Visio, Projects HP Service Manager, Adobe Campaign

Networking Technologies: LAN/WAN/WLAN, Routers, Bridges, Switch and Wireless Devices

Troubleshooting: Windows, LAN, WAN, ROUTERS & HARDWARE (PC)

Applications Used: Oracle, SAP Business Objects, People soft, Primavera

Other: .NET, HP Service Manager, Cognos, Crystal Reports, JAVA, SharePoint, Basecamp, Trello, Lotus Notes

PROFESSIONAL EXPERIENCE:

Confidential, Estero, FL

Sr. Business Lead Analyst/Technical Consultant

• Gathered, documented, tracked and coordinated detailed data requirements for company’s MDM systems and processes
• Created context diagrams, flowcharts, process mapping documents illustrating data flow from upstream source systems to the target systems and downstream consuming systems
• Created Scope document, Test plan and Traceability documents and coordinated testing activities with the Offshore QA teams
• Contributed to the data dictionary approach and was responsible for timely updates
• Responsible for coordinating business rules, data flow and data quality requirements with the ETL (Informatica) teams and negotiating and scheduling deployment timeframes
• Responsible for coordinating Web Services requirements between MDM team and various 3rd party upstream sources and negotiating and maintaining SOWs, contracts and business rules
• Responsible for understand the downstream systems data requirements and proposing the best approach for data delivery leveraging ETL tools and files formats (JSON, .CSV etc)
• Responsible to querying the data using SQL queries in the RDBMS and on the EBX interface
• Responsible to update process documents and perform version control in Team Works
• Responsible to create, update and track Jira tickets and track overall project progress

Applications and Technologies: Office 365, Oracle, Tableau, ASP.net, JAVA, MY SQL, MS DYNAMICS, Informatica

Tools: Teamworks, Visual Studio TFS, JIRA, MS Projects, Google Docs, Google Drive, MS Visio, SOAP UI, PostmanShare Point, J-meter

Confidential, Chicago, IL

Sr. Lead Business Analyst

• Served as a primary liaison between the internal development team and business team to understand, elicit and capture detailed requirements for various Digital communication campaigns and channels (Email, SMS, In-App & Print/Letter)
• Gathered Functional, Data and UI requirements and translated into use cases/user stories
• Prioritized the requirements based on the delivery schedule and MVP agreement
• Performed and facilitated end to end testing, including data, batch, Web services/API testing
• Maintained project documents in a centralized data repository (basecamp and SharePoint) and updated the files from time to time and performed version control
• Created comprehensive test strategy and planning documents comprising of test scripts, test data, scenarios and detailed test cases
• Coordinated with backend team and requested test data files and converted into interpretable formats. Modified the test data to meet the testing requirements
• Performed end to end data validations verified source to target mapping requirements
• Coordinated and carried out functional testing, tracked testing progress, compiled and documented test results
• Logged bugs, issues and tasks in Jira and ALM and tracked and communicated the progress
• Facilitated and coordinated UAT with the stakeholders and requested sign-off
• Worked with the release management team to negotiate go-live and product deployment

Applications and Technologies: Tableau, Office 365, IBM ECM, Adobe campaign

Tools: Visual Studio TFS, JIRA, Basecamp, MS Projects, MS VisioSOAP UI, Postman, Share Point

Confidential, Glenview IL

Sr. Lead Business Analyst

• Developed, negotiated, sized and prioritized requirements for company’s E-Commerce based web and mobile applications, CRM application, CMS and LMS applications Sitecore platform
• Gathered requirements understanding the significance, criticalness, business value and impact and tracked progress and delivery of each requirement
• Served as the liaison between the business module owners, vendor teams and technical teams throughout the project life cycle
• Facilitated project teams with identifying project scope, roadmap, budget, resource planning and management in an Agile Scrum frame work
• Facilitated daily standups, Sprint planning, Product backlog refinement, retrospective and requirements review meetings
• Created User Interface (UI/UX) design documents, Blue prints, Mock Ups, custom themes, Layouts, Wireframes, Mapping specifications, Functional and integration requirements to support the development of Mobile/tablet Apps (IOS & Android)
• Negotiated time lines and established SOWs, Addendums, contractual documents with vendors and 3 rd party affiliates
• Supported the planning and development of MDM (Master Data Management) system that served as a centralized data resource point of reference
• Extracted data from the date warehouse and performed comprehensive analysis and disseminated data to the BI Analytics team, leadership and marketing teams to make informed business decisions that impacted revenue and enhanced customer experience
• Managed agile framework artifacts such as: Product Backlog, Sprint Backlog, User Stories, Acceptance Criteria, Wireframes and UML Diagrams
• Coordinated data requirements and facilitated testing of Web Services and web APIs
• Responsible for planning strategic implementations, performing requirements analysis, metrics evaluation, maintaining compliance and data integrity
• Coordinated and performed various forms of extensive testing (End to end data, functionality, systems, UI and integration testing) of both Web and Mobile applications on various operating systems including Mac OX, Windows, IOS and android
• Carried out research and tracking of billing activities for publications products (Medical Books, E- books, Journals and Confidential magazine) using Oracle Utilities Customer Care and Billing Solutions and CRM (Net Forum & Sales Force) activities and Identified opportunities to improve existing workflows and processes
• Coordinated and tracked development efforts with external hosting providers supporting Confidential platforms such as, but not limited to, Content Management System (CMS), Learning Management System (LMS) and Association Management System (AMS), Ecommerce platforms, APIs, Responsive Sites, Digital Content and Mobile Apps.

Applications and Technologies: Sitecore, Tableau, Net Forum, ASP.net, JAVA, MY SQL, MS DYNAMICS, Office 365

Tools: Visual Studio TFS, JIRA, Smartsheets, MS Projects, Google Docs, Google Drive, MS Visio, Axosoft, Fogbugz, SOAP UI, Postman, Share Point

Confidential, Rosemont, IL

Sr. Lead Business Analyst / Scrum Master/ BI Consultant

• Supported and carried out full life cycle implementations on multiple projects that comprised of ERP applications (SAP, Oracle & PeopleSoft) design and development, System Integrations and testing, application merger, system re-design, software/hardware upgrades, Digital marketing and media upgrades and enhancements, Mobile app development, Web services and API development and testing
• Elicited requirements from stake holders and product owners to support the development of new and existing Web, E-commerce and CMS applications based on Sitecore and Wordpress platform, Data warehouse integration between internal & external ERP applications (Oracle, Hyperion, Peoplesoft and SAP), Mobile Apps, Shopping cart & Checkout process
• Translated business requirements into comprehensive BRD, Functional and technical specifications
• Carried out process improvement and optimization initiatives for the existing ordering and customer fulfillment process
• Coordinated between business users, stakeholders, project teams, CAB, Vendor and application support teams on issues, process gaps, enhancements and project milestone and progress
• Lead, managed and supported the enhancements and merger of company’s primary and secondary in-house web based customer rebates application
• Proposed solutions and ideas to the project teams for better outcome of deliverables through out the different phases development lifecycle
• Facilitated projects comprising ETL process between applications, Data Migration from data warehouses, creation of MDM system and performed Data mining, Data extraction and cleanup for Analytics, BI reporting and facilitated decommissioning of old applications
• Lead projects as a short-term PM/Scrum master and created Project charter, Feasibility Report, Design & Flow documentation, Requirements documents and performed resource and budget management
• Facilitated requirements review sessions and daily stand-ups to identify impediments & project status
• Facilitated, coordinated and scheduled UAT and End to End testing before each deployment of all the web & client server applications, Mobile Apps and Web APIs
• Identified and coordinated defects with the development and QA team and ensured timely resolutions
• Facilitated and coordinated open issues/tickets with the application support team
• Facilitated and coordinated change and release management
• Coordinated ETL efforts in a major data migration project using the Managed File Transfer, FTP, SFTP process to support application shift from Power builder to SAP
• Created design specifications, wireframes, UI layout and mock-ups (for both Web and Mobile Apps), graphical representations for the proposed application development which contributed to enhanced & improved user experience
• Created standard operating procedures, user manuals, training material, conceptual & functional data models, process workflows using MS Visio for user development and training

Applications and Technologies: People soft, Oracle, Java, Sales Force, Hyperion, Tibco, IBM, UNIX, Linux, Putty, SAB Business Objects, Sitecore, Wordpress, OFFICE 365

Tools: HP QC, QTP, JIRA, MS Projects, Share Point, Visio, Lotus Notes, MFT, Crystal Reports, OBIEE, Informatica, MS Office Professional, Snag it, Etc.

Confidential - Bloomington, IL

Sr.Business Analyst

• Performed the role of a technical BA in a vendor hosted ITIL based services management framework
• Coordinated on high level, low level & complex business requirements that were primarily meant for enhancing and improving digital content and e-com initiatives
• Tracked requirements and ensured timely delivery after business owner, stake holder review and approval
• Served as a liaison between the application support team, Business Partners and Vendor
• Performed Incident Management and facilitated Change & Problem Management
• Managed/coordinated escalations (Incidents, Requests & problem tickets) for the 3rd level technical support team
• Facilitated the vendor and the 3rd level support with performance, UAT testing, debugging, reproducing and fixing the defects, scheduling fixes and patches on test and production environments
• Lead projects related to Data Migration, Version Upgrades and Process Improvement
• Coordinated with the vendor on tickets opened by the support team and ensured timely resolution
• Organized, facilitated and documented meetings with the business partners, project teams, stakeholders, vendors and senior leadership
• Negotiated and established maintenance windows with the business partners supporting business areas (Bank, Claims & Auto quote department)
• Managed and updated process related documents and metrics on team’s SharePoint site on daily basis
• Obtained data via IBM Cognos reporting tool for monthly reports pertaining to the team’s performance and volume metrics and presented to the leadership
• Coached the support team, provided feedback on documentation, service expectation and effective communication
• Published, updated and retired knowledge articles on company’s website, wiki sites and knowledge database

Applications and Technologies: Peoplesoft, Java, Sales Force, Hyperion, Share point

Tools: HP QC, QTP, JIRA, MS Projects, Visio, Lotus Notes, MFT, Crystal Reports, OBIEE Etc, Visual Studio TFS, Silverlight

Confidential- Cincinnati, OH

Business Analyst

• Elicited and documented requirements for customization of company’s Web based HR payroll application (COTS Product) and ensured quality and compliance was incorporated
• Authored comprehensive BRD documents that included design documents, use cases, user stories and followed through with the requirements until the final deliverables
• Participated in walkthrough meetings to provide project status, discuss impediments, make amendments to the BRD, review requirements and discuss deadlines
• Provided ongoing project support and assistance in project planning by estimating resource time, cost and budget and identifying overall project scope
• Facilitated end to end testing and regression testing of the application before each deployment and release cycle
• Coordinated UAT testing with the end users in the final phase of the application before deployment
• Supervised and reviewed test cases and scripts written by the offshore team and provided feedback
• Proposed solutions and ideas for better outcome within existing developmental strategies
• Coordinated and negotiated release schedule with the business and change/release management teams
• Identified defects and bugs while performing various forms of testing and created bug reports to follow up, review and re-test

Tools: Visual Studio TFS, JIRA, MS Projects, Visio, Lotus Notes, MFT, Crystal Reports, OBIEE Etc

Confidential, Rosemont, IL

Business / Billing Analyst

• Participated in numerous business optimization projects with the Supply Chain realm that improved process efficiency, reduced defects, reduced expenses and labor costs by automating outdated manual processes
• Facilitated requirements gathering, process modeling and design sessions, reviewed design documentation with users and developers in an Agile environment to support the development of SAP applications
• Converted functional requirements into user stories and have written and executed test cases
• Ensured all aspects of compliance and business rules were met while documenting functionality requirements
• Helped resolve critical control and operational weaknesses; identified problems, recommended improvements, and worked in collaboration with cross-functional teams to implement issue resolutions.
• Performed extensive research and analysis on customer accounts to identify loss of revenue
• Responsible for recognizing new processes, finding out breaks or gaps in current processes, organizing training sections for new process developments and completion
• Performed reconciliation on invoicing and billable data pertaining to customer accounts
• Performed research and data analysis to validate billing activities using Oracle Utilities Customer Care and Billing suite, Oracle CRM, SAP business objects and Performed testing activities using HP Quality Center, QTP
• Wrote SQL queries to retrieve validate and verify data from the database.

Applications and Technologies: SAP, Oracle, People Soft financials, Java, Java Script, PHP, Sales Force, Share Point

Tools: Visual Studio TFS, JIRA, MS Projects, Visio, Lotus Notes, MFT, Crystal Reports, OBIEE Etc

Confidential, Jacksonville, FL

Business Process Analyst

• Performed comprehensive research and analysis to determine challenges in establishing the process functionality, procedures and compliance
• Gathered functional requirements for People Soft based application in an Agile (Scrum) based process
• Documented and followed through the requirements until the final deliverables
• Performed financial analysis on transactions to identify source of the funds in question, misapplied funds and missing funds
• Initiated electronic wire transfers for moving funds between accounts using Mainframe Systems
• Maintained balances and transferred excess funds to the Treasury or borrowed funds in case accounts went overdraft
• Identified as the SME and was responsible to organize training sessions for juniors and new recruits
• Responsible for short-term resource planning and implementation based on the forecast provided to ensure service level goals were met
• Created standard operating procedures and training manuals for process improvement, Team development and training
• Communicated, tracked and documented post production issues to the development team