EXECUTIVE SUMMARY:

• 11 years of IT experience across multiple lines of business and IT Service teams with roles like Business Systems analyst, Tester, Developer and Technical Support. Extensive experience in Enterprise Application Integration and Business Intelligence areas with requirement gathering, analysis, development, testing, support for variety of web services, applications and reporting solutions.
• Successfully managed technical requirements in various projects on different platforms like Web services SOAP/REST API based enterprise integration and Data warehouse based BI reporting and dashboards
• Adept in preparing User Stories, Business Requirement Document, Application design document, Application Interface document, high Level designs, sequence Diagrams & use Cases diagrams.
• Proven Experience of working in SAFe, Agile environment (even acted as Scrum Master many times) with backlog and user stories creation, grooming and Confidential planning to achieve better business outcomes
• Hands on experience with entire project life cycle and multiple domains. Worked in on - site and offshore model with liaison between business stakeholders and IT Service teams.
• Well versed in API and Web service testing using Soap UI and Postman and worked with management tools like HP ALM, JIRA for defects and releases. Involved in Facilitation and Participation in UAT
• Well versed with SQL databases and knowledge of basics of programming languages
• Consistently using problem-solving skills with ability to perform root cause analysis to resolve issues in timely manner and using analytical thinking to have gap analysis for delivered product
• Flexible to work on and learn various technologies with new solutions with research on tools that may be beneficial to the project and organization. Quick learner, self-motivated, good team player. Experience of working both independently and as a bridge with other teams.
• Handling multiple projects at the same time

SKILL:

• Agile methodology and other SDLC methodologies
• Use case diagrams, Sequence diagrams
• Testing - Functional, Non-Functional. Defect logging and tracking with tools like JIRA, HP ALM, Kayako
• Reporting, Dashboards/Visualizations, ETL
• SQL, Business Objects Webi, Crystal Reports, Universe Design, Tableau
• BI and Data Warehouse Life cycle concepts and Dimensional Modeling
• Informatica, Pentaho ETL
• Enterprise Integration
• Analysis and design of XML, XSD, WSDL, JSON, Web services documents,
• Manual and Automation Testing for SOAP and REST APIs
• SOAPUI, POSTMAN,ML, WSDL
• Knowledge of PL/SQL, Python, SSRS, SAP BW, SAP HANA
• Worked with databases like Oracle, DB2, Netezza, MySQL with Windows/Unix Environment
• DB Tools - Toad, PL/SQL Developer, DB Visualizer, MySQL Query Browser, SQL Developer

PROFESSIONAL EXPERIENCE:

Business Systems Analyst

Confidential, Overland Park, KS

Responsibilities:

• Communicating with different stakeholders of client like Subject Matter Experts, Solution Architects, other interfacing frontend and backend teams as well as external vendors
• Understanding requirements thoroughly which helps in preparing design document for the operational development and enhancements for web services and applications based on SQL, XML and JSON
• Working on multiple projects at the same time
• Performing SOAP and REST API testing in SOAPUI and POSTMAN
• Defect reporting and tracking in HP ALM and JIRA tools
• Working with Scaled Agile Framework (SAFe) for creation of user stories, PI and Confidential plannings, grooming, review, estimations and retrospectives
• To create operation design with sequence diagrams, data mappings and processing flows that describes the information a developer needs to implement the interface, how and where to access a backend system and any special considerations
• Understand Data Models, coordinate and communicate the design and activities with offshore team while serving as an interface between onshore stakeholders and offshore team to ensure smooth delivery
• To create operation schema XSD and use XMLSpy tool for each interface that describes request and response elements. To create operation interface that provides information a frontend needs to consume the interface. Each element’s description, syntax, construction and any special considerations are contained in the interface document.
• To create web service definition that provides an abstract of the operations and list of all XML schema files for WSDL schema.

Environment: SOAP, REST, ALM, JIRA, Java, SQL, Visio, Oracle, Amdocs billing, Windows/Unix, CA Agile Central, POSTMAN, XMLSpy, SOAPUI

Confidential, Moline, IL

Responsibilities:

• Interaction with business users to identify dashboard strategies, report layouts, data transformations and analyze the requirements to generate documentation for systems Design Specifications, and reporting
• Documenting Business Requirements, Functional as well as technical Specifications, Systems flow designs and updating Application interface documents
• Communicate activities/progress to project managers and other teams along with facilitation of UAT with demonstrations to the client
• Worked in Agile environment (even acted as Scrum Master many times) and participated in grooming and Confidential planning, estimation. Ensured the deliveries of stories and provided proactive inputs to business for time oriented deliverables and user stories
• Functional and Non-Functional Testing with test case creations, reviews, and defect tracking
• Building and prototyping dashboards for PoC work showing capability of different tools providing insights into the business functions.
• Design Tableau reports and dashboards providing insights into the business functions. Built effective dashboards to help business visualize the data story
• Worked in multiple projects at same time focusing and planning the client needs and business outcomes
• Design, testing, enhancement and troubleshooting work for Universe, Web Intelligence reports, dashboards and metadata design of semantic layer
• Helped in Dimensional Modeling of the data warehouse using Star Schema and Snow Flake concepts
• Extraction and Loading of data from various sources to Data Warehouse with ETL Jobs & transformations
• Managed security domain with user groups and administration work to Implement row and column level security, Report distribution and bursting through Publications
• Technical support to my team member, other users and training to the business power-users

Environment: SAP Business Objects, Xcelsius, Informatica,Tableau, Java SDK, Web services, Oracle, DB2, SAP HANA, SAP BW, Windows/Unix, Tello, Rally

Confidential

Responsibilities:

• Communicate activities/progress to project managers, business development, and onsite team
• Interaction with GEO (onsite team) for feasibility study, requirements analysis and understanding with overcoming language barrier successfully
• Testing of the ETL jobs and reports with defect tracking with successful UAT
• Reverse Engineering for the existing Universes and reports in Confidential, DWH, DAC applications.
• Generated new reports and modified existing reports as per changing user requirements including on multiple universes/data providers.
• Designed Project Plan Based on Report complexities and criticality
• Analyzed and proposed migration plan from 5.1 to 6.5 and 6.5 to BO XI 3.1
• Technical support to the users and the other teams
• Active application development activities based on production releases every month
• Effectively managed to finish critical assignment of BO infra ID for modifying 178 universes in DWH application.
• Interviewed many candidates to hire into my Project and in Telefonica project for the new positions.

Environment: SAP BO, SAP BW, Datastage, CVS, Oracle, Netezza, SQL Developer, Windows and UNIX Environment

Confidential

Responsibilities:

• To schedule and monitor the reports belonging to different business users
• Providing support to the existing DSS application
• To understand new work on requirement of Enterprise Data warehousing application.
• Changes in the universe and reports as per the requirements for change and enhancements.

Environment: SAP Business Objects, Informatica, Xcelsius, Oracle, Windows Environment

Confidential

Responsibilities:

• Coordinated and worked with clients for requirements analysis
• Lead analysis sessions, gathered requirements and created technical and functional design documents
• Manual Testing with defect tracking and management with facilitation of UAT
• Helped in Dimensional Modeling of the Data warehouse using Star Schema Concept
• Extraction and Loading of data from different databases and sources to Data Warehouse
• Universe Planning and Designing
• Report Designing and Analysis on Web Intelligence and Demonstrations to the client
• Dashboards creation and Demonstrations to the client

Environment: Business Objects, Tableau, Oracle 9i, Windows Environment, SQL Developer

Confidential

Responsibilities:

• Client Interaction for requirements and data Analysis with SRS documentation
• Testing of the ETL jobs and reports with defect tracking and UAT
• Data fetch through SQL queries and data loading through PL/SQL
• Metadata Design as semantic layer for reports
• Report Analysis, Designing and Integration with data attributes

Environment: Business Objects, Pentaho ETL, PL/SQL Developer, Windows and Unix Environment

Confidential

Responsibilities:

• Training sessions for knowledge sharing on BI, Data warehouse and Reporting
• Requirements Understanding
• Technical Support to Team Members
• Problem Solving
• Interviewed many candidates to hire into the organization for the new positions

Environment: SAP BO, BODS, Pentaho, Informatica, and other BI Tools

Confidential, NY

Business Analyst

Responsibilities:

• Manual testing for JSF based web application to do stress testing and to find various defects.
• Different tools like Business Objects, Cognos, Tableau and Pentaho compared with Proof of Concept through sample set of data and reports development.
• Data Mapping through Universe Designing and Designing of Canned and Ad-hoc Reporting
• Creating Users and Roles
• Scheduling of Reports and Technical Support to other Team Members

Environment: BO, Tableau, Pentaho, SVN, DB2, DB Visualizer, Java JSF, Windows Environment