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 teh 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 wif multiple sources including outside vendors.
• Comprehensive noledge and experience in all aspects of teh 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 teh 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 teh 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

Senior 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 wif key business and technical stakeholders including architects, developers and analysts.
• Documented and designed Retail and Control Tlog solution according to Sales Audit requirements.
• Worked wif 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 teh TPS components.
• Identified tasks to implement a digital marketing process at teh firm. Analyzed our websites' current traffic statistics and applied concepts of Search Engine Optimization (SEO) to optimize teh website
• Created High Level and Low Level design documents to elaborate system integration solution for cash office, product, pricing and DW house systems.
• Worked wif teh development team to make sure that they understood teh user requirements and that teh system developed met those requirements. dis was accomplished by elaborating requirements and by creating user stories.
• Closely worked wif 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 wif teh Data analyst in defining data sources and required data content for teh data warehouse component
• Create Data Mapping Document detailing out teh 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 teh 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 teh requirements outlined in teh test plan as part of teh development cycle.
• Involved in Assembly testing wif testing team to verify teh 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 wif Business Analysts.
• Performed Requirements Gathering and Analysis, interacted wif teh SME (Subject Matter Experts), and ensured that contributors and all key stakeholders were motivated to complete assigned tasks.
• Wrote Use Cases wif 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 teh project manager to estimate best/worst case scenarios, track progress wif weekly estimates of remaining work to do, conducting informal meetings ad hoc and as needed.
• Participated in Data Analysis and Design and data mining wif teh Data analyst in defining data sources and required data content for teh data warehouse component.
• Modeled and capture specification requirement for teh data warehouse and teh underlying transactional database.
• Developed teh staging and warehouse schemas for teh 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 teh Data flow is right
• Wrote SQL Statements to extract Data from Database to verify teh output Data of teh reports
• Actively Responsible for documenting Test Plan and developed scenarios for writing Test Cases and Test Scripts.
• Wrote Test cases for all functions of teh 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 teh Requirements documents.
• Identified teh areas of dissatisfaction wif teh existing products and services, theirby provided suggestions for improvement.
• Involved wif 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 teh application.
• Used Google Analytics to analyze website usage, page views, traffic and exit to find out popular products and teh reason why potential customers abandon shopping carts
• Provided backup to co-author and review teh documents created by my team.
• Maintained open and clear communication wif teh business team on change requests timelines.
• Involved in bi-weekly status meetings and walkthroughs for updates.
• Participated in conference calls to figure out teh scope and teh needs of teh business requirements.
• Logged in issues in Share Point and assigned them to teh requisite individuals.
• Created UI Documents as supporting documents for teh Business Requirements Documents.
• Attended and co-hosted Joint Application Development (JAD) Sessions wif teh business Users to document teh business needs.
• Involved in Data Flow/Business Process Diagrams to illustrate teh flow, input and output of data.
• Used MS Visio to carry out teh business modeling, data modeling, and object modeling efforts to develop teh business architecture for rapid and controlled application development.
• Developed SQL queries, functions, stored procedures and triggers to perform teh backend testing of teh data
• Extensively used SQL statements to query teh Oracle Database for Data Validation and Data Integrity
• Assisted QA environment during teh system testing of teh application and performed UAT testing of teh application.
• Responsible for addressing, diagnosing, and resolving issues that arise on a day to day basis for teh 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 wif teh responsible Technology & Operations departments.
• Handled several business lines including Wire line (PSTN), Internet, DTH and IPTV.
• Cohesively worked wif 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 teh ON-Site and Offshore partnership worked very well.
• Used Microsoft Dynamics CRM 4.0 for Customer relationship Management wif 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 wif 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, datamodels 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 teh Data flow is right
• Wrote SQL Statements to extract Data from Database to verify teh output Data of teh reports
• Performed Defect Tracking and Change Control Procedures using Rational Clear Quest and Configuration Management and Version Control using Rational Clear Case.
• Worked wif testing team in understanding teh Traceability Matrix and helped team come up wif test cases and test conditions as per teh requirements to complete teh integration testing.
• Developed and monitored tools and dash board for maintaining teh 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.