SUMMARY

• Over 7+ Years of experience in requirements gathering and documentation with solid oral and written communication skills.
• Experience in working various phases of Software Development Life Cycle(SDLC) methodologies, Agile (Scrum), Waterfall and Rational Unified Process (RUP).
• Proficient with UML Diagrams such as creating Use Case diagrams, Sequence diagrams, Activity diagrams etc.
• Performed GAP analysis, to identify the GAP between AS - IS and TO-BE states of the application/processes.
• Have good knowledge in ETL (Extraction, Transformation, Loading) process .
• Working knowledge in analyzing and validating enterprise data using SQL and in creating data mapping documents.
• Experience in analyzing business processes, eliciting requirements, defining business needs and translating it to Business Requirement Document (BRD), Functional Requirement Document(FRD), Software Requirement Specification (SRS)/ Technical Requirement Documents, User Stories, Use-case Specification and Non-functional Requirements.
• Have good working knowledge in creating ad-hoc reports using Business objects, Tableau, Excel, Dashboards
• Have experience in Web Services.
• Good experience in Database management and Business Intelligence.Expertise in co-ordinating with cross functional teams, having developers, end users, testers etc., in assisting them with requirements and technical design documents, information on project timelines.
• Worked on all testing phases from developing test plans through test execution at all stages of project.
• Participated in User Acceptance testing and also supported the QA team.
• Expertise working with off-shore teams, to delegate tasks and to ensure the assigned tasks are completed within the project timeline.
• Possess strong communication and presentation skills.
• Have good experience in using Service Manager (HPSM) for raising and tracking Incident, Request, Change Management tickets.
• Experience in writing test plans.
• Expertise in maintaining and executing test cases in Quality Center.
• Involved in writing complex SQL queries and test scripts for data validation, backend testing and data analysis.
• Skilled at facilitating JAD (Joint Application Development) and JRP(Joint Requirement Planning) sessions with various user groups/stake holders by sending out meeting agenda, reference documents etc.
• Expert in broad range of technologies, including business process tools such as MS Excel, MS Access, MS PowerPoint, MS Visio (Microsoft Suite) and Testing tools.

TECHNICAL SKILLS

Modeling Languages: UML

Languages / Scripts: SQL, PL/SQL, C, HTML, CSS, ASP.net, Java

Databases: MS SQL Server (2000, 2005, 2010), Oracle 8i, 9i, 10g, MS Access

Operating Systems: Windows 95/98/2000/XP/Vista/2007/7/8, Linux

Microsoft Tools: MS Office, MS Outlook, MS Project, MS Visio, EXCEL

Project Management Tools: Clear Quest, Rational Requisite Pro, Rational Rose, MS Visio, SharepointQuality Center, DOORS, Clear Case

Reporting Tools: Business Explorer, Web Reporting, SAP BO Infoview, Tableau, SAS, Splunk

ERP Technologies: SAP ECC, BW / BI

Tracking-Tools(Business Traffic/: Google Analytics, JIRA, Bugzilla, Scrum wise, Version one

Project development/Bug):

Other Tools: MS Share Point, HP Quality Center, Snagit 8

PROFESSIONAL EXPERIENCE

Confidential, MI

Data Analyst

Environment: SAP BO 4.1, SAP BI 7.4, ECC 6.0, Business Explorer (BEx), Information Design Tool (IDT), Universe Designer, Enterprise Portal, Web Intelligence, Dashboards, QAAWS, MS Project/Office 2010

Responsibilities:

• Responsible for writing functional and business requirements for planned and ad-hoc enhancements
• Extensively created reports in WebI, implemented drill down features and created reports including horizontal table, vertical tables, forms and charts.
• Interacted with users and Business partners for customizing the existing reports and creating new reports. Designed and developed functional specifications, technical specifications for BOBJ reporting .
• Interacted with Project manager and end-users in architecting dashboards layout and solutions by understanding the requirements and specifications
• Created BEx reports using filters, calculated key figures, and restricted key figures for use in BOBJ Tools like Universe Designer.
• Designed Dashboards using SAP BI data/ BEx Queries. Valuable Knowledge on Dashboard Designer Components like Charts, Selectors (Filters, label Based menus), Tab Sets, Canvas Containers.
• Report, schedule and publish project status on SharePoint.
• Responsible for project coordination assist in development of project estimates etc.
• Used Variables, User defined objects, Scope of analysis, Drill mode, Slice and dice mode, Prompts, and Conditions to make reports accurate and easier for analysis.
• Created the reports using Business Objects functionalities like Combined Queries, Drill down, Cross tab, Master detail and Formulae.
• The project involved in the development of reports using Business Objects Web Intelligence to cater Ad-hoc reporting needs.
• As a part of Production support involved in monitoring load failures, Delta loads, documenting and monitoring the performance of the system.
• Involved in End User-Training documentation, conducted User Acceptance events.
• Worked on Operation support tickets. Solved high priority tickets without breaching the SLA’s

Confidential, MN

Business Analyst

Environment: MS Visio 2010, MS Project 2010, MS Word, MS Excel, MS PowerPoint, Sharepoint 2010, Autosys 11.3, UML, Clear Quest, Windows XP/2000, Oracle 10g, Tableau

Responsibilities:

• Involved in all phases of Software Development Life Cycle (SDLC) for this project, which used Modified Waterfall.
• Interacted with various stakeholders through interviews, meetings to gather requirements and have drafted and base-lined Business Requirement Document.
• Performed detailed analysis of the requirements and have validated it with the business users (reporting analysts) to ensure the requirements were correct and complete.
• Documented Business Requirement Specification and High Level project plan.
• Actively participated with the front end developers for gathering and analyzing needs of User Requirement.
• Experience with Data Extraction, query enhancement and managing data relationship with IT teams
• Documented Datawarehouse Requirement document.
• Used MS Visio for drawing Activity diagrams, Sequence diagrams, Collaboration diagrams and System Context Diagram.
• Involved in preparing the test plans and test cases.
• Coordinated unit testing and system testing to ensure the correct functionality.
• Involved in gathering requirements for developing mobile application for iphone and andriod users
• Involved in developing functional and business requirement documents for the mobile apps
• Used Agile and Scrum project methodologies to gather requirements and documentation
• Generated project reports using MS-Project.
• Analyzed Website performance and trends using results to implement changes to marketing
• Helped in Testing the IVR system to detect any issues, monitored real-time adherence and prepared and updated various ACD reports for management
• Worked on JIRA to create Bug report
• Managed requirements and requirement traceability matrix (RTM) to ensure the coverage of all the requirements.
• Participated and facilitated in UAT (User Acceptance Testing) to make sure that all the user requirements are met by the application and supervised the development of User Manuals for customers.
• Management of time constraints efficiently and meeting the project deadlines.

Confidential

Data Analyst

Environment: MS Visio 2010, MS Project/Office 2010, Cognos 8.4, UML, Doors, Quality Center, Sharepoint 2007, Windows 7, Oracle 9i, Tableau

Responsibilities:

• Act as business analyst across various streams for reporting needs.
• Involved in all phases of software development life cycle for this project, which used Agile(Scrum).
• Interacting with internal business units to collect functional specifications for generating the reports.
• Assessed client needs utilizing a structured requirements process (gathering, analyzing, documenting, and managing changes) to prioritize immediate business needs
• Responsible for writing functional and business requirements for planned and ad-hoc enhancements
• Conducted daily stand up meetings in the role of a scrum master.
• Communicate project details to various levels of management.
• Develop conceptual modeling and process workflows to illustrate current and future states.
• Documented user stories and helped the project manager in managing and prioritizing user stories in the product backlog.
• Performed GAP analysis and provided rationale for GAPS that could remain.Managed and prioritized release backlog.Ensured strict adherence to procedures and critical time frames.
• Reviews exception conditions& determine appropriate course of action.
• Coordinate system test activities & perform UAT
• Develop user test cases and validate test results during user acceptance testing (UAT).
• Execute SQL queries to analyze data sets for reporting.
• Created Custom reports using Excel.
• Developed various reports like List, Cross Tab, Master Detail and different charts including Line, Column, Area, and Pie Charts for analysis using Tableau
• Made decisions on the number of sprints and the story points that should be accomplished in each sprint.Created and maintained burn down chart.
• Actively participated in UAT testing, acting as UAT coordinator and monitored business testing and interfaced with the development team regarding defect status and fixes on daily basis.
• Performed Data Analysis and Data validation by writing SQL queries..Responsible for PLR maintenance.
• Report, schedule and publish project status on SharePoint.
• Responsible for project coordination assist in development of project estimates etc.

Confidential, GA

Business Technical Intern

Environment: SQL, Rational Rose, Rational Pro, Sharepoint, Oracle 9i, MS Word 2007, MS Excel 2007, SnagIt, HTML, MS Access.

Responsibilities:

• Involved in all phases of software development life cycle for this project, which used Waterfall.
• Interacted with various stakeholders through interviews, surveys and questionnaires to gather requirements and created a business requirement document.
• Worked with the team in analyzing the requirements.
• Provided a fine, clear and brief documentation on the requirement management plans, functional requirements.
• Used MS Visio for developing data flow diagrams and business process models and for depicting system context diagram using Microsoft Visio.
• Designed User Interface designs as a mock up screen for visual communication and data flow to the end users.
• Created Solution Specification Document.
• Interacting with development team to convert the requirements to technical specification.
• Developed a user interface design using SnagIt to show the UI design for the development team.
• Provided assessments, audits, and implementations for advanced web analytics using Google Analytics
• Mined online marketing and Web Analytics data for insights in to customer behavior
• Involved in requirements gathering for developing the ecommerce mobile app for IOS and Android users
• Created KPIs, goals and dashboards in Google Analytics for ecommerce site
• Performed the impact analysis on existing applications to determine the application prominence and ensure the elimination of the dominant applications on the portfolio like employment application.
• Created Data Flow Diagrams and Process flow diagrams by using MS-Visio.
• Involved in preparing the test plans and test cases.
• Coordinated unit testing and system testing to ensure the correct functionality.
• Participated and facilitated in UAT (User Acceptance Testing) to make sure that all the user requirements are met by the application.

Confidential

SAP Analyst

Environment: ECC 6.0

Responsibilities:

• Participated in data transfer from legacy systems to Global SAP systems (GSAP) .
• Involved in Data Extraction, Transformation, and Loading in to the SAP systems
• Check the data file prepared by the transformation team for format issues and approve or reject the file for load.
• Load the data into various systems using the LSMW tool
• Performed data load operations for 5 different countries from trail conversions to Go-Live.
• Involved in writing SQL scripts and programs to develop new LSMW objects to load data more efficiently
• Report and analyze the errors that occur during the data load and hence worked on performing in-depth analysis for the fixing of the issues.
• Perform the manual load going through the screens of the SAP transactions to exactly trouble shoot the issue in case the BDC session created by the LSMW ends in an error.
• Developed BDC program to upload the data from legacy system into SAP R/3 system for Customer Master Data Creation.
• Created Job Scheduling for daily and weekly sales reports, purchase orders and Release the Jobs.
• Involved in handling the onsite-offshore calls and meetings with client.
• Prepared test plans and test cases and involved in the UAT .
• Participated in the post-production support and On-call support during Go-Live.
• Responsible for providing documentation to team for troubleshooting and resolving issues reported by system users, facilitating resolutions.
• Documented, and managed all technical and functional requirements for the application and changes to requirements throughout the software development lifecycle using Solution Manager.