SUMMARY

• Business Systems Analyst with 7 years of experience in business Process analysis/modeling, business requirements gathering, database design and development of Web Based, and Client/Server applications.
• Extensive experience in Retail, food processing and CPG industry.
• In - depth knowledge of creating use case, activity, logical, component and deployment views with rational tools to extract business process flows and workflows thereby helping development and quality assurance teams in understanding the requirements.
• Good knowledge of Workflows and Content Management Tools.
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, Primavera, MS Access, MS Visio, technical assessment tools, Data Warehousing concepts and web design and development.
• Experience in development methodologies like RUP, SDLC, AGILE, SCRUM and Waterfall
• Extensive knowledge in SDLC methodologies.
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, MS Excel, MS Access, MS Visio, technical assessment tools, MicroStrategyData Warehouse Data Modeling and Design.
• Strong understanding of information technology capabilities and dependencies, including platforms, content management, e-document strategies and process mapping.
• Results-oriented Joint Application Development (JAD) Facilitator and meetings coordinator with excellent interpersonal skills.
• Extensive experience in development of T-SQL, OLAP, PL/SQL, Stored Procedures, Triggers, Functions, Packages, performance tuning and optimization for business logic implementation.
• QA leader with a proven track record of strategic QA vision, quick delivery, and demonstrated ability to inspire/mentor quality assurance teams to implement latest QA programs for maintaining industrial quality standards.
• Experience in Agile Methodology, XP (Extreme Programming), Six Sigma.
• Extensive experience in configuring data mapping between different Databases.
• Proficient in creating Use Cases, Sequence Diagrams, and Collaboration diagrams, Activity Diagrams, Class Diagrams, creating RFP's, Business Intelligence Tools etc.
• Interviewed SMEs and Stakeholders to get a better understanding of client business processes and gather business requirements.
• High proficient withSQLagainstSQLServer, Sybase, Oracle and DB2 databases using tools like Toad,SQLProgrammer and RapidSQL
• Good experience with reading, writing, manipulation and transformation of data using XML, XSD, XSLT, using .NET. Development and web based applications using Microsoft technologies.
• Assisted the testing team in creating Test Plans and Test Strategy to ensure that the testing accurately reflects the functionality depicted by the Requirements.
• Extremely proficient in using Agile and XP methodologies performed roles of Scrum Master following sprint sessions and used Rally software extensively to write User Stories, assign tasks to individual team members.

TECHNICAL SKILLS

Programming Languages: C, C++, HTML, XML, SQL.

Data Base: MS Access, Oracle (SQL Series), DB2

Reporting Tools: Crystal Reports 8.0

Operating Systems: Windows(..), OS

Software: MS Office Suite(Word, Excel, Access, PowerPoint & Outlook), MS Visio, Rational Rose, Rational Requisite Pro, Adobe Acrobat, MS Office FrontPage, Lotus Notes

Reporting: MS SQL Server Reporting Services, Crystal Reports,BusinessObjects,MicroStrategy, Siebel Analytics

Processes/Technologies: Rational Unified Process (RUP), Waterfall, UML & Microsoft Office SharePoint 2013

Automation Tools: Requisite Pro, Win runner, QTP, Test Director, Quality Center

PROFESSIONAL EXPERIENCE

Confidential, SECAUCUS, NJ

SR BUSINESS SYSTEMS/QA ANALYST

Responsibilities:

• Completed a thorough customer analysis and prepared a Request for proposal (RFP) document and got the shortlisted vendor document signed off. Finally CRM was decided upon by the stakeholders among shortlisted as final implementation customer
• Create and maintain Use Cases, visual models, including activity diagrams, logical Business process models, and sequence diagrams using UML.
• Support the Product Information Management (PIM) System and item related data in the Arrowhead ERP System.
• Assist business units with data intensive projects and loading large datasets into PIM and ERP Systems according to the set standards.
• Analyzing and transforming Excel Spreadsheet of Product Data into standard formats for PIM tool importing.
• Created source table definitions in the DataStage Repository by studying the data sources.
• Prepared Use cases and Data flow diagrams and Work flow diagrams, considering the scope of the project with MS VISIO .
• Integrated Oracle WMS Module with Oracle Quality to enable inspection process after an item is manufactured as per the client's business needs.
• Plan and update Marketing promotional calendar to manage year's campaign themes and promotions
• Reviewed Stored Procedures for reports and wrote test queries against the source system (SQL Server) to match the results with the actual report against the Data mart (Oracle).
• Created and scheduled Sessions based on demand, run on time and run only once using Informatica Server Manager.
• Provided technical assistance in software functionality to the End users, QA team and the Development team.
• Evaluate and recommend new Information Security technologies and counter-measures against threats to information or privacy.
• Implemented and analyzed brand trending development initiatives, to identify product growth segments, while working in conjunction with marketing managers to creatively develop and achieve growth objectives.
• Developed and maintained corporate marketing budgets for continuing adult technical education campuses nationwide.
• Analyzed business requirements and created use cases to assist the development and QA/UAT team in design and testing.
• Responsible for A/P monthly spending reconciliation for corporate marketing budget, budget reductions & additional spend forecasting and supervised A/P staff.
• Managed external marketing partners such as advertising agencies, digital marketing firms and production companies to improve brand content.
• Performed details analyses using Google Analytics to improve clickability, inbound Marketing and SMO (Social Media Optimization).
• Responsible for QA deliveries to stake holders.
• Validated the data of reports by writing SQLqueries in PL/SQL Developer against ODS.
• Developed demonstrated prototypes including data models, business objects universes, reports and business dashboards and received their feedback to define the information access strategy for an integrated data warehousing and reporting solution.
• Worked on MS Excel Macros for creating automatic reports
• Worked with the QA team for designing Test Plan and Test Cases for the User Acceptance testing (UAT).
• Responsible for executing User Interface Testing, System Testing, Data Quality Testing on the configuration design and prototypes.
• Prepared Data Comparison tool by using VBA (Excel Macro).
• Assure that all Artifacts are in compliance with corporate SDLC Policies and guidelines.
• Functioned as the primary liaison between the Business line, operations, and the technical areas throughout the Project Cycle.
• Provided QA Strategic Roadmaps, employee evaluations, mentoring and training throughout the duration of each project
• Used SQL for Querying the database in UNIX environment
• Assist QA team in reviewing the test cases and with story validation.
• Defined the test criteria and project schedules, and baseline the Test Plan with the help of project meetings, walkthroughs.
• Participated regularly in daily status meetings and reported to the QA Manager Supervisor.
• Created QA Test plans, Test Cases for Functional, Integration Testing
• Conduct multiple benchmarking, JUDD, collaboration sessions with PM, BA, Dev, QA and external stakeholders
• Analyzeend-userbusinessrequirements into functional requirements and ensure that deliverables are completed byendof each sprint cycle
• Used master data management (MDM) to define reference data
• Developed Functional Specification Document and Supplementary Specification (non-functional) Document.
• Provide feedback and suggestions for improving the QA procedures to project and QA Lead.
• Participated in the Logical and Physical Design sessions and developed Design Documents.
• Developed schemas for extraction, transaction, and loading (ETL) using Solonde Warehouse Workbench to expedite data integration between systems.
• Involved in QA team meetings and gave updates to the QA lead/Project Manager on a weekly basis.
• Worked with Quality Control Teams to develop Test Plan and Test Cases.
• Develop User Manuals, and Training Manuals as per Project Specifications and timelines.

ENVIRONMENT: Microsoft Office Suite, MS Visio, Windows XP, DreamWeaver, CRM, SQL, PLSQL, XML, VB, ASP, Crystal Reports, Adobe Photoshop, Mercury TestDirector, WinRunner, LoadRunner

Confidential, DAKOTA DUNES, SD

BUSINESS/QA ANALYST

Responsibilities:

• Gather requirements by conducting meetings and brainstorming sessions with end users and SME and document them using Requisite Pro - the documentation tool offered by Rational.
• Followed Agile (XP) Methodology for the release.
• Analyst and QA Tester on cooperative project with third-part vendor to facilitate a high-volume data exchange for pre-payment analytics of claims.
• Worked closely with the QA team and Developers to clarify and understand functionality, resolve issues and provide feedback to identify defects.
• Assist in day-to-day management of marketing initiatives for general Acquisition initiatives
• Gathered requirements and modeled the data warehouse and the underlying transactional database
• Served as expert in the functional use of hybris, its various administrative cockpits and b2b and b2c accelerators.
• Generate ad-hoc SQL Queries to extract relevant data from PIM tools to standard formats (CSV, Excel, Text).
• Worked closely with the QA Team to review and enhance the Test Plan and Test Cases.
• Associated with the QA team to detect the defect and take necessary actions to resolve the issue. Attended review meetings and walkthroughs to discuss the status of the project.
• Provide IT Support for programmatically gathering product related data from external sources and effectively transforming product data into the PIM database.
• Conducted business analysis, QA test script creation, and UAT testing for bar code web applications, Active Directory database, and Outlook Express
• Plan and update Marketing promotional calendar to manage year's campaign themes and promotions
• Assist in the training of new staffs in the marketing department on how to use all marketing tools, Report, Manuals and updates.
• Coordinated with cross-functional teams including Marketing, Product, Retail operations
• Worked with the Business, Operations, and Engineering stakeholders to define the functional integration and end-2-end test cases for the CRM project.
• Reviewed and streamlined existing CRM processes, information, and data requirements to ensure accurate adoption metrics reporting
• Perform Gap Analysis of the processes to identify and validate requirements.
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Created QA Test plans, Test Cases for Functional, Integration Testing and participated in UAT.
• Involved in testing the conversion of the application into web application using XML web services.
• Research, analyze, maintain, modify, validate and prepare data, information and content regarding Accessibility strategies based on industry trends and government mandates in information technology, User Experience (UX), User interface (UI), and graphical layouts.
• Responsible for the collection of functional requirements, non functional requirements, data mapping, and light data modeling.
• Served as a liaison between various business units and information technology groups.
• Worked with various COTS and worked on projects to integrate them with already present applications.
• Conducted Architectural Discussions to prepare the Proposed Architecture and provided insight in the Business Case to the Architecture Review Board (ARB).
• Responsible for creating business work flows and processes and creating management reports based on the business rules and the business case analysis
• Support for an inventory management value assessment to improve financial performance and the customer experience by reducing working capitals and supply chain costs, and improving on shelf availability.
• Analyzed and Effectively implemented different QA methodologies/policies, strategies and plans in all stages of SDLC
• XML order header and order detail data transfer; inventory/supply chain management modules
• Used ERP business user information to create prototype business models and related business objects for Human Resources, Sales, Supply Chain and Finance which strongly supported ERP configuration using Business Process Modeling tool with UML and OOD
• Performed Business Process Mapping and performed AS IS and TO BE analysis
• Worked together with other team members in interviewing various business groups and identifying and prioritizing business and functional requirements.
• Proficient in querying a variety of databases like Oracle, SQL Server, MS Access using SQL, PL/SQL
• Involved in organizing Daily Status meeting with QA manager, Developers and Team Lead in resolving the issues.
• Develop, maintain, and support custom sourcing applications written utilizing JAVA, JavaScript, DB2, and HTML
• Gathered Web Content Management requirements from business units, translated those requirements into wireframe designs, and delivered HTML and CSS wireframe prototypes to client for implementation.
• Used Agile Software Development process viz. Scrum, as this was a time bound project
• Analyzed complex data structures of UI, Middleware, and backend systems to aid in the architecture of functional banking applications that were consumable by multiple clients
• Cultivate Agile Scrum methodology principles with a development team in transitioning from a Waterfall to an Agile SDLC environment.
• Developed processes to improve theWMSwarehouse management system (oracle) introducing product scanners. Inventory supply tracking, platform placement to shipping enhancements
• Extract Data from various applications - (SQLServer, Access, Beyond & Compare, third-party integration database).
• Communicated with developers and senior QA team members to assist in clarification of technical issues.
• Moderated Daily Defect Review meetings with Development Team to review the defects raised by QA team.
• Review the UX screens and the final prototypes to envision the Indicative UI screen.
• Assuring that the work requested and delivered were within all RFP specifications
• Apply UML notations and methodology in developing models that accurately represent the business process and workflows and clearly communicate them to the stakeholders.
• Facilitation of UAT andendusertraining
• Created Source to target data mapping documents identifying key data elements and prepared Data Flow Diagrams

Environment: Windows, MS Office(MS Word, Agile/Scrum, Waterfall, WMS, MS Excel, MS PowerPoint, MS Visio), .NET, Oracle, Crystal reports, Agile/Scrum, RUP, UML, Java, SQL, SQL Server, XML, HTML, CSS, GAP Analysis, Win Runner

Confidential - PLANO, TX

BUSINESS ANALYST

Responsibilities:

• Responsible to create the business requirements by defining routine, integrated processes.
• Responsible to gathers information to expand working knowledge of the business or product supported to include key processes and operational aspects.
• Monitored production for marketing materials, developed sale strategies, and implemented Pricing.
• Single point of contact for the business user and project tem in order to identify opportunities that meet organizational, operational and technological needs.
• Responsible to create the standard guide line for best practice in the project and documenting the key knowledge area in common project confluence site.
• Used different approach to explain the business concept to technical team and vise-versa.
• Performed extensive data analysis with other functional analysts on data received from various sources and in different formats.
• COTS testing and Vendor integration experience
• Developed basic to complex SQL queries to research, analyze, and troubleshoot data and to create business reports.
• Worked together with SMEs, architecture group and technical team leads to detail the interface, customized based on different user roles and functions.
• Mapped the current and proposed process and conducted thorough GAP analysis
• Generated Use Cases, Use Case Scenarios, Activity Diagrams and Data Flow Diagrams.
• Co-authored Functional Requirements and Specification Document.
• Worked with information architects and creative groups in detailing the wireframes and depicting GUI design.
• Worked in importing and cleansing of data from various sources like DB2, Oracle, flat files onto SQL Server with high volume data
• Assisted the database development team in data modeling, data structure and data table layouts required for consolidation of incongruent databases,
• Involved in writing test plan, test cases and test scripts for end-to-end testing.
• Reviewed test results and reported bugs/issues using Mercury Test Director.
• Assisted in UAT and end user training.
• Involved in various other enhancement initiatives to include new functionalities and redesign.
• Crated a process guideline or operating procedure to ensure proper communication methodology is being followed across the projects.
• Contributes to delivery of results for clients on complex issues.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent in SSAS
• Experience with onsite and offshore work model.
• Actively contributes to and readily applies knowledge for internal and/or external client solutions.
• Discuss with business user and technical team with based on data, which helps to come up with a decision quickly.
• Worked with Unix team to setting up cluster and common mount point for the applications.
• Drive best practice, quality and consistency within design and development phases.
• Analysed complex issues and lead a cross functional team to a solution
• Utilize and contribute to codebase to design projects.
• Identify production and non-production application issues.
• Identify opportunities to fine-tune and optimize applications of java developed projects.
• Responsible to do spot check after the developer deliver the code to ensure that all the required functional point has been deliver as committed.
• Requirement gathering for TIBCO infrastructure for the application
• Developed stored procedures in SQL Server to standardize DML transactions such as insert, update and delete from the database.
• Leverages available data and help and makes timely decisions.
• Experience with software tools used in requirements discipline and software testing discipline
• Experience in using Jira or similar tools for requirements, development and test tracking
• Experience with facilitation skills to lead requirements elicitation workshops planning and preparation, presentation, knowledge capture and follow-up.