PROFESSIONAL SUMMARY:

• 8+ Years professional experience working on various technologies, complex projects across multiple regions & different lines of business.
• Scrum Alliance Certified Scrum Master (CSM).
• Expertise in various types of SDLC’s like Agile Scrum, Rational Unified process, Waterfall, V Model etc.
• Involved extensively in User’s needs analysis, Planning, Scheduling, Systems design, Testing, Quality assurance, Documentation, Project implementation, and End users support.
• Expertise in conducting requirements gathering using techniques like User Interviews, Workshops, JAD sessions, with different stakeholders.
• Strong analytical skills in analyzing data, documents, user input surveys and workflow to determine which course of action will correct the business problem.
• Proficiency in MS Word, Power point, Access, Visio, Share point, and Change control to produce Documents, Process flow Diagrams and good experience in developing and designing reports throughSSRSandExcel.
• Determining task dependencies, identifying milestones & monitoring critical paths using Burn - down Charts, Defect Heat Maps (Schedule & Allocation), and Requirements Traceability Matrix (RTM).
• Strong Experience in Business and Data Analysis, Data Profiling, Data Modeling, Data Migration and Integration. Experience with various ETL, Data warehousing tools like SSIS, SAS.
• Worked extensively in preparing Data Mapping documents, Use Cases, User Stories and various UML diagrams like process flows.
• Proficient in Designing Dataflow Diagrams, ER Diagrams, Use Case Diagrams, Activity Flow Diagrams, Sequence Diagrams.
• Demonstrated the capability of translating complex business needs into technical solutions.
• Exceptional ability to work with Subject Matter Experts (SME) in order to extract, document, and digitize their domain knowledge, business rules, requirements, decision process, and expertise.
• Practiced in clarifyingBusiness requirement, performingGap analysisbetween goals and existing procedures/skill sets, and designing process andsystem improvementsto increase productivity and reduce redundancy.
• Managed UAT process by performing Smoke testing, Test case Validation, and obtaining business approvals on UAT for scheduled deployments.
• Involved in automation testing using Selenium Web Driver and Selenium Grid.
• Capable of rapidly learning new technologies, has strong Analytical, Organizational, Communication and Interpersonal skills.
• Capable to prioritize workloads, time manage workday effectively, multi-task, work on a team, use analytical and problem-solving skills and work with a variety of personalities.

TECHNICAL SKILLS:

Operating Systems: Windows (10, 8, 7, Vista, XP, NT, 9x), UNIX and Linux.

Databases: Oracle, Microsoft SQL Server2008/12/13, MS Access.

SDLC: Agile (Scrum, Pair Programming, Extreme programming)Waterfall, RUP, V Model.

Programming Languages: SQL, PL/SQL, T-SQL, XML, HTML.

Scripting: UNIX Shell Scripting, JSON.

BI Tools: MS SharePoint, Oracle, and IBM Cognos.

Testing: HP Quality Centre, ALM, Jira, Rally, Selenium

Analytics: Google Analytics, Big Data Analytics.

ASP.Net:Good understanding of PMBOK, C, C++, JQuery, Java script

Reporting Tools: SSRS, Oracle Forms and Reports Builder, Report Studio, Tableau, Crystal Reports, MS Excel.

Microsoft: Excel, Word, PowerPoint, Visio, Share point, Access, Dynamics AX.

Other Tools: SQL * Plus, PL/SQL Developer, SQL Loader, SQL Developer, SQL Navigator, Microsoft Visual Studio, SSIS, Invision app (Visual Design), Confluence, Query Studio, Enterprise DB Migration Studio, Oracle Apex, TOAD, Pivotal Tracker, Change point, Remedy Force.

Web Based Applications: HTML, Bootstrap, Angular, React.js, Ember.js, Node.js, Backbone.js, Java, .Net, Sales Force.

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Scrum Master / Sr. Business Analyst:

Responsibilities:

• Conducted Requirement gathering sessions, feasibility studies and organizing the software requirements in a structured way.
• Interfaced between Business Owners and programmers to translate User Stories into respective Sprints basing on the Priority and Capacity.
• Organized and involved in Daily Scrums, Story Grooming, Sprint Retrospective, Look ahead meetings, Demos and Sprint planning activities.
• Actively participated in all phases of development, QA testing, UAT and production release activities.
• Ensured compliance with audit regulatory and legal requirements.
• Maintained strict company policies and Adherence.
• Acted as a Proxy Product Owner to the team for subject matter expertise questions and lead the team for Sprint activities.
• Worked closely with Product owner to create user stories required for new enhancements, features, backlog grooming activities.
• Created Environment setup plan, Migration document and checklist
• Modified Business Requirement Document, Identified process repetitions, bottlenecks and infrequent routes.
• Level 1 support for internal end users, answering general inquires on features/functions, analyzing root cause for reporting/data discrepancies, establishing and overseeing system usage standards.
• Collaborated with region heads and admin users in the risk assessment and strategy development practices for project risk management.
• Oversaw and mentored all interface, modification, reporting and security strategies.
• Was involved in defect fixing, change request and release maintenance of the application.
• Worked as lead of testing team during UAT - creating and executing test cases and supplying the whole team with daily reports.
• Generated various financial reports like risk assessment, BHUB data feed reports through SSRS.
• Used Rally to create, track and maintain Sprint activities.
• Extensively worked with Graphic Designer - User Experience (UX) and User Interface(UI) teams while driving the Functional requirements and Wireframes using Axure and Invision tools.
• Documented the as-is and to-be processes in Cross-functional flow charts.
• Provided post implementation application support for end users.
• Conducted JAD sessions to allow different stakeholders to communicate their perspectives with each other resolve any issues and come to an agreement quickly.
• Determining Task Dependencies, Identifying Milestones & Monitoring critical paths using Burn-down Charts, Defect Heat Maps, Resource Plans (Schedule & Allocations), Entity Relationship Diagrams and Requirements Traceability Matrix (RTM).
• Worked closely with Production support to analyze break fixes and other production issues.
• Used Webix Pivot tool to create data models to create various risk reports for Portfolio Managers.
• Lead onsite and off team as Subject Master Expert(SME).
• Resolved application incidents and problems that require app code modifications such as lower complexity software problem resolution.
• Worked closely with Risk Assessment department reporting team for deploying Tableau reports and publishing them on the Tableau and Share point server.

Confidential, Montvale, NJ

Sr. Business Analyst/ Sales Force BA

Responsibilities:

• Worked closely with Product Owner in gathering requirements, by interviewing and visiting dealerships, having better understanding of their concerns regarding present Legacy system and collected feedbacks.
• Simultaneously worked on 2 projects, focused on understanding the problems and being the domain expert was able to answer questions from Interaction Design team IXD, Visual Design team VD, Development team and Testing team swiftly and decisively.
• Conducted operational audit and analysis in a business environment that included the review of comprehensive corporate documentation and business compliance.
• Participated in Steering Committee meetings, documented project scope, Organizational structure and Operational guidelines.
• Worked in Kanban and Scrum methodologies.
• Incorporated Wire Frames, Page mockups and Prototypes for visualization of GUI design and business process to have better understanding of the project Outcome.
• Hands on Big data Analytics, Google Analytics to track portal usage by various dealers and their regions (North America).
• Extensive worked with User Experience (UX) and User Interface (UI) teams while driving the Functional requirements and Wireframes.
• Created Epics, wrote User Stories and facilitated Story Point discussions to analyze the level of effort on project specification.
• Maintained and updated Sprint backlogs and Product backlog, basing on change in scope of the project requirements during the sprints.
• Involved in Daily Scrums, Story Grooming, Sprint Retrospective, Look ahead meetings, Demos and Sprint planning activities.
• Updated and maintained JIRA and Pivotal Tracker on regular basis by displaying priority user stories, their estimates, Development teams Capacity on every Sprint, issues from multiple projects so the progress can be monitored.
• Created and maintained Business Rules for Sales, After Sales, Service, Parts in “MBUSA Dealers Application Document”.
• Planned and conducted requirements elicitation meetings with the business to collect functional and non-functional requirements relating to client's Sales force technology enhancement and initiatives.
• Conducted brainstorming sessions with the development team to actively involve them during the requirements stage level analysis.
• Worked towards preparation of requirements management plan, business and functional requirement documents.
• Created data flow diagrams and process flow diagrams to facilitate better system understanding.
• Monitor new Sales force released features and functionality to provide recommendations for process
• Conduct business analysis by working with end users to identify system, operational requirements.
• Involved with the testing team executing all Unit, Functional, Integration, User Acceptance and Regression testing using test cases and test scripts created in HP Quality Center to ensure that the Application data Analysis forms confirm to the specifications of business requirements.
• Created test data basing on the security roles using JSON for various combinations of Dealers, Companies, Franchises, etc.
• Created all possible scenarios for various dealer interface screens and executed User Acceptance Testing (UAT) and making sure all testing and integration requirements are met.

Confidential, Fairfield, Ohio

CRM / Salesforce Business Analyst

Responsibilities:

• Served as the principal conduit for managing system requirements between the business and the software development team throughout the duration of a project.
• This project software development life cycle was based on the Agile methodology and CRM System.
• Conducted and worked on the JAD sessions and created the prototype for the application using the JAD process.
• Analyzed Background Documents and Business Requirement Documents to get a better understanding of the system on both technical and business perspectives.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Deployed and processed SSAS Cubes weekly to update information by using SQL Server Agent.
• Worked with DBA’S to review Migration Strategy and Migration Schedule.
• Leverages multiple business requirements gathering methodologies to identify business, functional, and non-functional requirements.
• Conducts root-cause analysis on solution defects or shortcomings
• Worked with my project team, Business Areas, Development and Quality assurance team to create the UAT Strategy and Planning.
• Provide guidance for system/process workflow template development and data filtering criteria within CRM system.
• Provide oversight on mass data uploads into CRM system.
• Built a fantastic relationship with the Internal and External teams of the project and ensured that all the project tasks are accomplished under the dead-lines.
• Actively participated and resolved several Issues by performing a proper corporate navigation.

Confidential, MI

Business Analyst/ Systems Analyst

Responsibilities:

• Involved in Customer Business Meetings in order to get the appropriate requirements on both Green field Projects and existing applications on Tasks, Break Fixes, Enhancements, etc. at various stages.
• Develops and tracks project plans and progress from inception to delivery ensure requirements are delivered as scheduled. Issues status reports and keeps Stakeholders apprised of issues and risks in a timely manner.
• Assist in GUI mockup and prototype development.
• Involved in various stages ofSDLClike gathering User requirement and System Specification. System Analysis, Design, Development, Testing and Implementation.
• Gathered and analyze information on both current and desired future state business process and
• Documented the business requirements by conducting Joint Application Development (JAD) sessions, Workshops with Subject Matter Experts (SME's).
• Involved in Production Pushes and Emergency Deployments for various releases.
• Developed UML Use Cases for the application using Rational Rose and prepared the detailed work flow diagram based on the proposed enhancement for the system.
• Often worked on database design, data modeling and BI using Microsoft SQL Server.
• Define, Assign and also Update the projects in SharePoint, Change point based on the priority to track the work progress and to reduce redundancy.
• Execute adequate life cycle/release planning that demonstrates strong understanding of the scope of work, resources required to complete all tasks, sound assumptions, and clear understanding and recognition of risks involved.
• Developed and maintained Requirements Traceability Matrix (RTM) to track requirements and the test scripts.
• Aided QA analysts in testing the developed solution against desired requirements to ensure the business needs were met and suggest changes if necessary.
• Tracked, assigned, updated Remedy Force for various Help tickets and Break fixes.
• Proactively worked on relationships with employees both inside and outside the Organization, to determine business and functional requirements and identify solutions to resolve those needs.
• Conducted individualized Test cases and Test plans for each application affected by the migration.

Confidential, Boston, MA

Data Analyst

Responsibilities:

• Creating and running the shell scripts to run the Processes at time schedule according to business rules and also created roles, users and database objects.
• Lead project delivery by defining, maintaining and communicating Finance Systems requirements, solution approach & design, standards and standardized methodologies across the Enterprise.
• Provided consultative and technical support of the ERP system, interfaces, and integrations with other financial applications.
• Knowledge of Oracle Financials, Lawson Financials would be an advantage, as will familiarity with reporting tools and relational database concepts (such as SQL+ and MS Access).
• Worked with project team representatives to ensure that logical and physical data models were developed in line with corporate standards and guidelines.
• Involved in Requirements gathering, documenting, Use Case modeling, developing Business, Functional and Change request requirement documents.
• Determined which business subject areas provide the most needed information; prioritized and sequenced implementation modules accordingly.
• Used Clarity PPM to align project investments with corporate goals by developing plans and communicating.
• Worked extensively on MS Dynamics AX 2012 for various jobs like updating payment terms to the 3rd party vendors, creating business process documents, Exporting sales data from various tables into excel, creating Compliance Forms, Etc.
• Worked on daily basis with lead Data Warehouse developers to evaluate impact on current implementation, redesign of all ETL logic.
• Fine-tuningSQL Queries to improve performance that was achieved by changing table joins, sub queries and the way columns are declared wherever possible.
• Document all data mapping and transformation processes in the Functional Design documents based on the business requirements.
• Created Technical specifications documents based on the functional design document for the ETL coding to build the data mart.
• Involved in analysis and design documentation.
• Involved in all Phases of System development life cycle.
• Used DDL and DML for writing triggers, stored procedures.
• Involved in creation of databases tables queries and stored procedures to validate the data
• Proficient with SQL programming and various database concepts like performance tuning, sql profiler to validate and compare data.
• Involved in verifying test case scenario validations.
• Creating work flow documents and UML diagrams.