SUMMARY

• 8+ years of IT experience in areas of Business Analysis, Development and Deployment of web - based and client-server applications.
• Expertise in functions like E-commerce Merchandising, Telecom operations, Warehouse Management, POS and Content management.
• Proficient in using database tools (MS Sql Server 2014, Informatica, XML SPY) to perform queries to analyze and capture data to support requirements.
• Knowledge in the ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence (BI) tools like Tera data.
• Experience in software development methodologies like - Agile, Scrum and Waterfall.
• Experience in Supply chain management systems and actively involved in JAD approach in supply chain management of retail business.
• Experienced in defining system integration requirement and designing data flow/sequence diagrams to represent multitier architecture.
• Responsible for creating requirements for RMS, TRMS and WMS as part of Supply Chain management application.
• Proficient in preparing BP Documents, Business Requirement Document (BRD), Software Requirement Specification (SRS), Functional Specifications, Use Cases, and User Manuals.
• Solid understanding of computing environment, systems engineering concepts, architectural framework diagrams, QA testing, building test plans, test cases, scripts, UAT, systems integration with multiple sources including outside vendors.
• Comprehensive knowledge and experience in all aspects of the Software Development Life Cycle (SDLC) which includes Gathering Requirements, Analysis, Design, Development, Testing and Implementation. Proficient in Object Oriented Analysis, Design and Development.
• Experience in the Business Consulting involving Business Process Improvement and identifying Strategic Options for clients using various methods such as As-Is and To-Be Process Maps, Functional Maps and Gap Analysis.
• Involved in creation metadata repository and data mapping according to the business requirements.

TECHNICAL SKILLS

Tools: SAP R/3 (FI-CO (GL), SD, A/P, and A/R), Requisite Pro, MS Word, MS Visio, MS Power Point, MS Project, andVMware. Expert in MS EXCEL (Pivot, If Statements, Sub-totals, Macros, Vlookup, Ulookup, Hlookup, Conditions etc.)

Databases: NeoView, MS Access, Oracle 10g, SQL Server 2008/2014

Operating Systems: Windows 98/2000/ME/NT/XP/Vista/7/8/8.1/Android/IOS.

Methodologies: Scrum, JAD Session, Agile, Business and Data Modeling, BPIM (Business Process Improvement Methodologies), MIS (management Information system).

Languages: C#, Java, SQL, PL/SQL development, .Net.

Quality Assurance: HPQC, Application Life cycle Management (ALM)

PROFESSIONAL EXPERIENCE

Confidential, Austin, TX

Sr. Business Analyst

Responsibilities:

• Elicited Non Functional Requirements to define POS and Payment system’s Security, Performance, Network, Maintainability requirements.
• Lead system integration analysis, data analysis with key business and technical stakeholders including architects, developers and analysts.
• Documented and designed Retail and Control Tlog solution according to Sales Audit requirements.
• Worked with third party vendors to create functional and non- functional requirements to design transaction process system.
• Created architecture design to define integration between POS client, TPS and Database.
• Analyzed several builds of TPS and proposed solutions to enhance performance across the TPS components.
• Identified tasks to implement a digital marketing process at the firm. Analyzed our websites' current traffic statistics and applied concepts of Search Engine Optimization (SEO) to optimize the website
• Created High Level and Low Level design documents to elaborate system integration solution for cash office, product, pricing and DW house systems.
• Worked with the development team to make sure that they understood the user requirements and that the system developed met those requirements. This was accomplished by elaborating requirements and by creating user stories.
• Closely worked with system architects and SMEs to build multi-tier system design and wireframes.
• Launched high-impact BI Sales Reporting for executives to perform trended multi-dimensional analysis.
• Participated in Data Analysis and Design and data mining with the Data analyst in defining data sources and required data content for the data warehouse component
• Create Data Mapping Document detailing out the source, transformation rules, and target to generate internal/external extracts using data.
• Extensively used XML Spy tool to examine XML files for validating data field’s path.
• Executed SQL queries to capture data fields as well as to analyze Retail and CDM data to ensure appropriate configuration of multiple testing environments.
• Lead testing teams to verify implementation of new features and enhancements across the code drops.
• Configured QA environments for testing team by injecting valid RTIs.
• Performed Defect Triaging and validating defects against valid requirements.
• Defined and promulgated test cases based on the requirements outlined in the test plan as part of the development cycle.
• Involved in Assembly testing with testing team to verify the requirement and acceptance criteria.

Environment: Windows Vista/7, SQL, MS-Visio, Agile, HP Quality Control, Visual Studio, XML Spy, Share point

Confidential, Irving, TX

Business Systems Analyst

Responsibilities:

• Identified and implemented processes for developing and documenting detailed business requirements.
• Elicited business requirements through interviews, document analysis, design workshops, surveys, use cases, and workflow analysis.
• Analyzed Business Requirements (BRD) and Functional Requirement Documents (FRD) and attended walkthrough meetings with Business Analysts.
• Performed Requirements Gathering and Analysis, interacted with the SME (Subject Matter Experts), and ensured that contributors and all key stakeholders were motivated to complete assigned tasks.
• Wrote Use Cases with relevant UML diagrams such as Use Case diagrams, Activity diagrams and Sequence diagrams using MS Visio.
• Designed innovative web-based tool for automatic update of traffic tracking reports and producing statistics on web site usage
• Analyzed business requirements and created wire frames to accommodate online platform layout.
• Preparing Business Workflow models that covered business processes. Prepared Workflow diagrams to analyze “AS IS” and “TO BE” scenarios, and designed new process flows.
• Assisted the project manager to estimate best/worst case scenarios, track progress with weekly estimates of remaining work to do, conducting informal meetings ad hoc and as needed.
• Participated in Data Analysis and Design and data mining with the Data analyst in defining data sources and required data content for the data warehouse component.
• Modeled and capture specification requirement for the data warehouse and the underlying transactional database.
• Developed the staging and warehouse schemas for the Dataware house.
• Worked extensively on Data-Integration, Data Mapping, and Data Warehouse access using SQL and Crystal Reports, ETL process, use cases modeling (UML) using MS Office (Word, Excel, Access, Visio) and dashboards
• Worked on Database queries for Insertion, Deletion and updating to make sure Data is accurate and the Data flow is right
• Wrote SQL Statements to extract Data from Database to verify the output Data of the reports
• Actively Responsible for documenting Test Plan and developed scenarios for writing Test Cases and Test Scripts.
• Wrote Test cases for all functions of the application in Test Plan module of Quality Center.

Environment: MS Windows, MS-Visio, Agile, SharePoint

Confidential, TX

Business Systems Analyst

Responsibilities:

• Analyzed available Ad Sales tools, and suggested a suitable option based on business needs.
• Created Requirements documents and implemented requirement gathering process to capture requirements for advertisement management solution.
• Provided optimization design to target traffic across multiple media, including broadcast television and radio, media networks, digital and mobile.
• Created Use Cases and ensured they were consistent and covered all aspects of the Requirements documents.
• Identified the areas of dissatisfaction with the existing products and services, thereby provided suggestions for improvement.
• Involved with business users and management team to determine content category, responsible figures for content management
• Used requirement elicitation techniques such as JAD Sessions and Document Analysis to gather information regarding the application.
• Used Google Analytics to analyze website usage, page views, traffic and exit to find out popular products and the reason why potential customers abandon shopping carts
• Provided backup to co-author and review the documents created by my team.
• Maintained open and clear communication with the business team on change requests timelines.
• Involved in bi-weekly status meetings and walkthroughs for updates.
• Participated in conference calls to figure out the scope and the needs of the business requirements.
• Logged in issues in Share Point and assigned them to the requisite individuals.
• Created UI Documents as supporting documents for the Business Requirements Documents.
• Attended and co-hosted Joint Application Development (JAD) Sessions with the business Users to document the business needs.
• Involved in Data Flow/Business Process Diagrams to illustrate the flow, input and output of data.
• Used MS Visio to carry out the business modeling, data modeling, and object modeling efforts to develop the business architecture for rapid and controlled application development.
• Developed SQL queries, functions, stored procedures and triggers to perform the backend testing of the data
• Extensively used SQL statements to query the Oracle Database for Data Validation and Data Integrity
• Assisted QA environment during the system testing of the application and performed UAT testing of the application.
• Responsible for addressing, diagnosing, and resolving issues that arise on a day to day basis for the team.
• Responsible for Back-End Testing Using SQL Commands.

Environment: MS Project, Java, JSP, EJB, Web Sphere, HTML, Oracle 9i, Windows, Quality Center, XML, Java, AMDOCS CRM

Confidential, CA

Business Systems Analyst

Responsibilities:

• Identified and implemented processes for developing and documenting detailed business requirements. Data was collected from end-users and analysts.
• Obtained business requirements with the responsible Technology & Operations departments.
• Handled several business lines including Wire line (PSTN), Internet, DTH and IPTV.
• Cohesively worked with on-shore and offshore team on financial planning and estimation of several projects.
• Presented traffic data to generate support on funding capacity projects for special events
• Utilized CPMF Frame work, that delayed on cutting edge technologies and process so the ON-Site and Offshore partnership worked very well.
• Used Microsoft Dynamics CRM 4.0 for Customer relationship Management with existing ERP
• Performed Supply Chain practice to maintain, coordinate and manage change.
• Created Functional Specification Document (FSD) and Software Requirement Specifications (SRS) documents and maintained Process Work Flow with Functional Specifications and Supply Chain aspect.
• Presented traffic data to generate support on funding capacity projects for special events
• Created Process Work Flows, Functional Specifications, and responsible for preparing Software Requirement Specifications (SRS), Functional Specification Document (FSD).
• Work under JAD approach in supply chain management of retail business.
• Elicited business requirements through interviews, document analysis, design workshops, surveys, use cases, and workflow analysis.
• Created and reviewed functional and technical design documents such as BRD, FRD, Use cases, data models and data flow diagrams, Wireframes using Visio etc.
• Worked extensively on Data-Integration, Data Mapping, and Data Warehouse access using SQL and Crystal Reports, ETL process, use cases modeling (UML) using MS Office (Word, Excel, Access, Visio) and dashboards
• Worked on Database queries for Insertion, Deletion and updating to make sure Data is accurate and the Data flow is right
• Wrote SQL Statements to extract Data from Database to verify the output Data of the reports
• Performed Defect Tracking and Change Control Procedures using Rational Clear Quest and Configuration Management and Version Control using Rational Clear Case.
• Worked with testing team in understanding the Traceability Matrix and helped team come up with test cases and test conditions as per the requirements to complete the integration testing.
• Developed and monitored tools and dash board for maintaining the applications and supported many errors that come up after implementation.

Environment: Windows XP, SQL, MS-Visio, Rational Rose, Oracle, MS-Project, Test Manager, Requisite Pro.MQC, Informatica.