SUMMARY:

• A proficient and result oriented Sr Business Systems Analyst with 7+ years of experience and proven track record of performing enterprise level data warehouse projects. Driven by strong leadership, strong work ethics and high competence with ability to work under pressure to keep up with the deadlines. Worked in various domains like Banking, E - Commerce and Insurance. Ability to quickly grasp new concepts and processes while working vertically across the organization and end users to ensure accurate and timely completion of large & small-scale projects.
• Business Systems Analyst / Scrum Master with 7+ years of experience in Business Analysis, Requirement Gathering and implementation of complex IT projects with proven ability in leading with self-organization and cross - functional teams.
• Proficient in working on end-to-end IT solutions in Insurance, E Commerce, Banking & Investment sectors.
• Strong knowledge of Business Analysis methodologies and Software Development Life Cycle (SDLC) like Waterfall model, Agile (Scrum, Extreme Programming) Scrum-Waterfall Hybrid SDLC environments.
• Experience in eliciting and documenting business and functional requirements using techniques like Requirements Workshop, Joint Application Development (JAD), Job Shadowing, Interviews, Prototyping and Document Analysis.
• Proficiency in gathering SMART (Specific, Measurable, Attainable, Realistic, Timely) requirements and transforming them into functional specifications focusing on workflow analysis, user interface design, and process flow modeling.
• Skilled in drafting Business Requirement Document (BRD), authoring Functional Requirement Document (FRD), Use Case Specifications (UCS) and Software Requirement Specification (SRS), collaborating with Subject Matter Experts.
• Handled Requirements Churn by evaluating the Change Request. Have successfully performed Technical and Business Impact Analysis to study the effect of the change request and ensure minimal effect on Triple Constraints of the Project.
• Proficient in using UML for Business Process Modeling, Use Case Diagram, Activity Diagrams, E-R Diagrams, Sequence Diagrams, Data flow Diagrams and document them using Rational Rose and Microsoft Visio.
• Experience working in Web Services (SOAP, WSDL and REST), Client-Side Validation, and Server-Side Validation.
• Excellent knowledge in writing queries for extracting data using Joins, Functions, Group by and Order by in MySQL server.
• Good understanding on Data modelling which includes Dimensional Modelling and E-R modelling. Expert in creating Specifications and developing Conceptual data, Logical data and Physical data and ER Diagrams for RDBMS and data mart.
• Experience in Data Warehousing and Business Intelligence enterprise applications in implementing projects.
• Experience in writing advanced SQL queries, documenting data requirement document and developing strategies for (ETL) Extraction, Transformation Load data from various sources into Data Warehouse and Data Marts.
• Exposure to various modern business intelligence tools such as MicroStrategy, Tableau, IBM Cognos, Microsoft SSRS, Microsoft SSAS and SAS for analyzing the data and generating report and creating dynamic dashboard.
• Good knowledge on Hadoop Distributed File System architecture and Map Reduce Version 2.0 Framework and experience in monitoring large volume of streaming data using Apache Flume, Apache Sqoop and Apache Kafka.
• Understanding of various Hadoop big data concepts such as HDFS, MapR, HBASE, Spark, Hive, Pig, Flume, Sqoop.
• Possess strong knowledge on concepts of data warehousing like data profiling, data mining, data migration, data masking, data Cleansing, top down approach and bottom up approach, OLTP, OLAP, MOLAP, ROLAP, HOLAP.
• Designing Star Schema, Snow flake Schema for creating OLTP Databases and hands on experience on Data Mapping.
• Competent in performing OLAP operations such as Drill-up, Drill-down, slicing and dicing based on requirements.
• Proficient in preparing Excel models based on requirements a determining the input values and required fields.
• Strong experience in generating test cases, test scripts and resolving (UAT) issues by communicating with QA team.
• Performed defects tracking, prioritized outstanding defects in the reporting system. Coordinated between the development team and the management team to resolve any conflicts with regards to the defects.
• Experience in overseeing Functional Testing, Regression Testing, Integration Testing, Performance Testing and was actively involved in conducting the User Acceptance Testing, assisting the user and documenting defects that surfaced.
• Extensive experience in working for large cross functional and complex projects, working for multiple Data Migration projects using various ETL Tools, Documenting ETL process, handling multiple tasks and implementations.
• Extensive experience in coordinating with offshore development and Production support teams.
• In this 7+ years of business experience I have acquired team building, problem solving and analytical skills to look a complex problem at higher level and understand how business works to meet the requirements.

TECHNICAL SKILLS:

SDLC Methodologies: Waterfall, Agile, Scrum, Waterfall - Scrum Hybrid, Extreme programming (XP)

Front End Tools: TFS, JIRA, MS Share Point, MS Visio, MS Project, Rational Requisite Pro, Confluence

Database: My SQL, SQL Server 2008/2012, DB2, Oracle 9i,10g,11g, Aster, Microsoft Azure

Design Tools: MS Visio, Rational Rose, Star UML

Testing Tools: HPALM, HPQTP, HPQC, Cucumber, Load Runner

ETL Tools: IBM Cognos, Informatica, TOAD, SAP BO Data Services (BODS), SSIS

Reporting Tools: Tableau, Microstrategy, Spotfire, SAP Business Objects IX, QlikView, Power BI, SSRS

Graphical Tools: Mock-Up Screens, Balsamic, Sketch

MS Office Tools: MS Office (Word, Excel, PowerPoint, Access)

Languages: HTML, XML, SQL, PL/SQL, T-SQL, C, C++

Data Science: Big Data, Hadoop, Map R, Python, R Language, AWS, R Studio

Operating System: Windows XP, 7, 8, 10, Linux, Mac OS

PROFESSIONAL EXPERIENCE:

Confidential, Las Vegas, NV

Business Systems Analyst

Roles and responsibilities:

• Interacting with business stakeholders in gathering business requirements and analyzing the existing system.
• Interacted with SME’s who were involved in development of application to understand the process flow and purpose of the application in order to bridge the gap between the To - Be system.
• Conducted several one on one interview with vendors and business team gather system functionalities.
• Involved in working with prototype of event and venue management application and creating process flow diagram for event and venue management application.
• Documented a scope and a power point presentation of the project so that anyone who has access to this document can understand goal of the project.
• Involved in analyzing the application and functionalities required for the business with respect to Confidential .
• Converted all the business and functional requirement gathered into a form of user stories in Blueprint / Storyteller tool.
• Interacted with security analyst and documented risk assessment for the project to assess the risk for this project.
• Interacted with system architect and vendors to review business requirements and process flows diagrams of Application.

Confidential, Trenton, NJ

Business / Data Analyst

Roles and responsibilities:

• Performed Document analysis to understand the existing system and business process to document scope.
• Created data mapping documents, data flow diagrams for ETL (Extract, Transformation and Load) process that specified mapping of Logical Data Elements to Physical Data Elements and Source Data Elements to Destination Data Elements.
• Involved in prior documentation and business process to understand the scope and development. Reviewed and Analyzed Business Requirement Documents (BRD), Functional Requirement Document (FRD) enable development team to better understand the requirements.
• Conducted one on one meeting with the clients to discuss the business needs and gathering business requirements and had meetings with SME and Database Admin to understand the application and determine the ETL workflow.
• Conducted regression testing, Data validation and data testing on the data mart end and also on the business universe end to see the all the view and tables available for reporting according to the requirements.
• Collaborate with business and IT teams to determine data and reporting requirements for the new functionalities and creating dashboards in the SAP Business Objects business intelligence tool.
• Closely worked with the data warehouse team in implementing history for the tables and available for them in discussing business requirement document if they need any assistance in verifying the requirements back and forth.
• Created prototypes for demo to show how they wanted to see the reports and Documented universe requirement gathering document and universe development join relationship cardinality verification document for business universe team to create business universe.
• Closely working with data architect in creating the logical design and physical design for data marts.
• Performed SQL quarries on the Oracle database to analyze and retrieve the data and gathering the data requirements for the ad-hoc reports and documented into data requirement document and universe creation requirement document.
• Experience in creating excel sheet reports for office of education system in order to know the statistics of Education data and input tables and finalized input and output Values.
• Conducted SAP Business Objects BI Tool training documentation for the employees to access the SAP Business Objects business intelligence Tool and create ad- hoc Reports based on their requirements.
• Performed systems testing, functionality testing and data validations for the new data mart and documented the reports.
• Used SAP Business Objects BI Tool to give live demo of the project by visualizing and analyzing all the data, created centralized dashboards to consolidate views and to keep tracking of various reports of project.

Environment: Oracle Discoverer, Oracle SQL Developer 4.1, SAP Business Objects Business Intelligence Tool, Oracle Warehouse Builder, Oracle TOAD, SAP BO Data Services (BODS), Office 365, MS Excel, MS Word, MS Outlook, ETL Workflow.

Confidential, Columbus, OH

Business System Analyst

Roles and Responsibilities:

• Acted as a liaison between the Hadoop administrator, Hadoop developers, Data engineers and Business owners.
• Conducted Gap Analysis for current state and to-be state of the system which involved in in the identification of business rules, business and system process flows, requirements and assumptions.
• Organized a Focus group session between the Hadoop team, Core-metrics data team and SAS analytics team for the pre-analysis of the project to understand the requirements and assisted the Project manager in Cost Benefit Analysis.
• Interacted with the Security Team to know about the sensitive information and Database Team to understand the 61VSD tables attributes in Aster Teradata to give an easy understanding to the MapR developers and testers.
• Constantly involved with ETL teams to conduct ETL job and create data mapping document with ETL workflow.
• Constructed (Requirements traceability matrix) RTM to determine the source of the requirement, ensure all requirements are met and locate affected system components when there is a requirement change.
• Involved in prior documentation and business process to understand the scope and development. Reviewed and Analyzed Business Requirement Documents (BRD), Functional Requirement Specification (FRS) and System Requirement Specification (SRS) enable development team to better understand the requirements.
• Designed Conceptual and Logical Models to capture the entities existing in the system and the relationship between them using E-R Diagrams, keeping in mind the business requirements.
• Performed Advanced SQL queries on various data bases and Documented data requirements as per the requirements.
• Conducted data validations to make sure data has be moved successfully and having accurate data.
• Closely work with the ETL engineers in understanding the structure and unstructured data of the organization and develop the system for analyze the data in making effective decisions for the business development.
• Responsible for performing Data Profiling and Data Mapping using the tool Informatica Data Quality (IDQ).
• Effectively involved in transformation of data based on requirements, data cleansing and improving the quality of data.
• Experience in handling data in excels sheet and analyzing the data using various data analysis functionalities in excel.
• Analyzed existing data sources in OLTPs by working with SQL Queries and came up with to-be states of new Map R environment coordinating with the SME’s as how to achieves those states.
• Used HIVE as an interface in querying Hadoop data and Involve in create Hive tables, loading with data and writing Hive queries to understand the data in a high level regarding the sales and inventory databases.
• Assisted QA team in testing complex queries and reviewed the queries to test the difference between Aster vs MapR.
• Conducted User Acceptance Testing (UAT) and developed test plan, test conditions and test cases and manually executed these to verify actual result against the expected results and arranging triage calls with development and QA team.
• Used Tableau to give live demo of the project by visualizing and analyzing all the data, create dashboards to consolidate views and to keep tracking of various tasks of project.

Environment: Waterfall, JIRA 6.4, Confluence, MapR, ODBC, Hadoop, Aster, Manta, Teradata, Tableau BI Tool, IBM core-metrics, Apache Drill, SAS, Pig, Hive, Python, R language, Rational Requisite Pro, MS (Power Point, Excel, Word, Project), Oracle 11g, MySQL Developer, Apache Tomcat Server, Java/J2EE, XML, JSON.

Confidential, Naperville, IL

Business Analyst / Scrum Master

Roles and Responsibilities:

• Actively involved in prior documentation and business process for understanding the Scope of system.
• Conducted Gap Analysis for current state and to-be state of the system which involved in in the identification of business rules, business and system process flows, requirements and assumptions.
• Interacted with the internal and external Stakeholders, project leads for gathering requirements for the system design & understanding the business process model and worked closely with the SME’s to understand the requirements.
• Worked with Power BI to create reports from the structured data for analysis done by Security Analyst.
• Wrote SQL queries to document and integrate data from various sources to gather requirements for creating database.
• Analyzed and reviewed the gathered requirement and documented them effectively in Business Requirement Document (BRD) and Functional Specification Document (FSD).
• Created Mock-up Screens and Wireframes using UI Components such as Radio Buttons, Drop-down list, Checkboxes for different screens for demonstration to business users, stakeholders and to give insights of the ‘TO-BE’ system.
• Along with the architects developed star schema, thereby identifying fact tables and establishing relationships using dimension modeling, which served as a basis for designing data warehouse and mapping the data with the source data.
• As a Scrum Master facilitated all Scrum Ceremonies like daily scrum meetings, biweekly sprint planning, review, retrospective, backlog grooming meetings, and planning poker sessions with the scrum team.
• Helped the Product Owner to prioritize the Product backlog items (PBI’s) for developing Sprint tasks by taking suggestions from the cross-functional development team.
• Actively involved in testing API’s and web application using cucumber and also assisting QA lead in testing.
• Tracked and communicated team’s velocity and sprint/release progress by maintaining burn up and burn down charts.
• Meet with product owners and operational business managers for selected modules to introduce scrum.
• Wrote test cases, test plans depicted in documented requirements and traceability matrixes for User Acceptance testing
• Compile, analyze, and present statistics about time estimation accuracy, team velocity, and burndown rate to development team and management each sprint.
• Used JIRA to keep track of the issues that are logged and in-progress along with the person responsible. It helps to generate reports to see the status of an issue and improving the productivity of the development team.

Environment: Waterfall - Scrum Hybrid, Wireframes, JIRA 6.4, Confluence, Cucumber, Mendix, MS Office (MS Word, MS Excel, and MS PowerPoint), HDFS, HIVE, Power BI, IBM Cognos Data Manager v10.2, Oracle SQL 2008, Web Services, SOA, SOAP, XML, HTML5, CSS, Ajax.

Confidential - Richfield, MN.

Business System Analyst

Roles and Responsibilities:

• Performed JAD sessions, interviewing and surveys with SME's, multiple teams for requirement gathering and refinement.
• Analyzed the gathered requirement and reviewed Business Requirement Document (BRD) and Functional Specification Document (FSD) for developing better understanding of system requirement to assist development team’s operations.
• Performed data retrieval using the SQL queries from database.
• Interacted with the ETL engineers for better understanding of functional requirements in proper implementation of data warehouse and data marts.
• Analyzed and documented business requirements through Business Domain Models, Business Process Maps, Use Cases, Mockups, Prototypes, and Data elements.
• Effectively involved in ETL process from extracting data from various source data, transforming the data with respect to data rules for the data warehouse and loading the transformed data into data warehouse using OWB.
• Prepared project deliverables through business workflow analysis, process analysis, user requirement documents (Use Cases & Use case diagrams) and managed the requirements.
• Gathered the requirements for the source data, target data and also functional requirements for the data warehouse.
• Designed and developed Use Case diagrams and involved with design team in creation of Activity Diagrams and Sequence Diagrams to depict process flows.
• Experience in creating Ad-hoc reports and visual dashboards in QlikView based on the requirements to intelligently summarize information need to product development.
• Effectively involved in writing SQL queries to understand the data from the databases and understand Meta data.
• Assisted and guided data architects and developers during the design and development phase of data warehouse.
• Creating data mapping documents, data requirement document and data modeling with the SME’s and data architects.
• Prepare use cases, scenarios, event lists, work flow analysis, business process descriptions and documents.
• Worked with the QA team for designing Test Plan and Test Cases for the User Acceptance Testing and Regression Testing.
• Used Tableau for data visualization to communicate information clearly and efficiently via the statistical graphics, plots, information graphics, tables, and charts selected.

Environment: Waterfall, MS Visio, MS Office (Power Point, Excel, Word, Project), TFS, SQL, Oracle SQL developer, Oracle warehouse builder, SAP Business Objects, MS Access, QlikView Business Intelligence Tool, Informatica power Center.

Confidential

Business System Analyst

Roles and Responsibilities:

• Interacted with business users to identify business needs and initiate process changes. Adopted Water fall methodology.
• Analyzing the prior documents such as project plan, business requirements, scope of the project and system specification to understand the as-is of the system.
• Gathered business requirements by participating in JAD sessions, interviewing business users and stakeholders, conducting one on one sessions and consulting existing systems documents
• Performed SWOT and GAP Analysis to discover new functionalities and prioritized them based on actual business needs.
• Created UML diagrams such as Business Flow Diagrams, Use Case, BPM and Activity Flow in coordination with technical team using MS-Visio.
• Created Mapping Documents, Report Mockups and modified existing report mockups and finalized for development
• Prepared different documents including User Requirement Document (URD), Business Requirement Document (BRD), Wire Frames to illustrate the functionalities, and SRS.
• Participated in the business requirements analysis meetings and prepared Use Case Diagrams, Sequence Diagrams, Class Diagrams and Activity Diagrams using Rational Rose.
• Interacted with the large data sets, automated data extraction from the various external data sources and monitoring dashboard with the Business Intelligence tools like ETL and visualization.
• Business presentations with graphical representation using MS Visio to help both Business and operations understand project purpose.
• Carrying out the impact analysis of change requests on budget and schedule, updating the BRD to document the suggested changes and getting them incorporated in prototype.
• We used SSRS and IBM-Cognos as a reporting tool to report data that is loaded in the Data Warehouse
• Analyzed existing data sources in OLTPs by working with SQL Queries and came up with to-be states of new OLAP System coordinating with the SME’s as how to achieves those states.
• Assisted in writing SQL queries like Select, Update, and Joins to retrieve desired information.
• Documented ETL Processing for Migration of data from one system to another system with respect to requirements.
• Performed a large-scale data analysis and data modeling to understand the scope for development of the system.
• Assisted in design review meetings to make sure all the requirements are covered in the development project scope. Involved in writing Test Plans, Test Cases and Test Scripts using HP Quality Center.
• Played a key role in the planning, User Acceptance Testing and implementation of system enhancements and conversions.

Environment: Waterfall, Wireframes, MS Office Suite, MS Visio, MS Project Professional, SSIS, SSRS, HP Load Runner, IBM Cognos, Mockup screens, UML, HP ALM, GAP Analysis, Tableau, Informatica Power Center.

Confidential

Business Analyst

Roles and Responsibilities:

• Interacted with clients and SME’s in gathering business requirements and ensure that end deliverables meet client needs.
• Conducted Joint Application Development (JAD) sessions with key business users to make them understand the project scope and deliverables and to check the feasibility of the project.
• Involved in analyzing Business Requirements and developing System Specifications.
• Created mockup screens for the user interface for the better understanding of the requirement, and to resolve the issues.
• Actively interacted with different business groups to perform Gap analysis to identify the deficiencies in the system by comparing the actual objectives with the system objectives desired
• Interacted with various cross-functional teams on building Use Cases and understanding expenses and revenue stream.
• Writing SQL queries for analyzing data form the database and gather data requirements for reporting purpose the project.
• Created documents like BRD, FRD, SRS based on the requirements gathered from the business.
• Created Use case diagrams, activity diagrams and class diagrams using MS Visio for designing and developing.
• Participated in the development and preparation of the Test Plan with the testing team as well as ensuring testability, reliability, usability, maintainability and performance of the application.

Environment: Water fall, HTML, XML, CSS, MS Visio, MS Office, MS Project, MS Share Point, and Rational rose, GitHub, Java, JSON, JavaScript, SQL Server.

Confidential

Java Developer (intern)

Roles and Responsibilities:

• Participated in JAD sessions to allow different stakeholders to communicate their viewpoints with each other, resolved any concerns and came to an agreement quickly.
• Identified the business-critical areas from the user perspective by Risk Analysis and GAP Analysis.
• Developed a high-level Business Requirements Document (BRD) and Functional Requirements Document (FRD) document and had them base-lined from the Business owner.
• Developed the GUI of the system using HTML, JSP and client-side validations was done using JavaScript. Built and accessed the database using JDBC for ORACLE 10g.
• Involved in designing the user interface using HTML, user interactions using JSPs on Eclipse and developed custom tags using Java Server Pages Standard Tag Library (JSTL) to support custom UIs.
• Java Servlets and JSP pages were deployed on the Web Logic Application Server for retrieving user information.
• Created JUnit test cases, and Development of JUnit classes.
• Developed the application and implemented DAO using Spring Framework that influences classical MVC architecture.
• Used CVS for version control across common source code used by developers.
• Involved in Unit Testing, defect analysis and fixing.
• Coordinated with the back-end team for integration issues and participated in Code Review preparing Test Cases.

Environment: Java, J2EE, JSP, Servlets, JDBC 3.0, HTML, UML, XML, JSON, JavaScript, Eclipse, CVS, Junit, WebLogic Application Server, Oracle 10g, IBM Rational Rose, MS Project, MS Office Suite.