Alekhya
Herndon,VA
Summary
Over 6+ years of experience in Business/Data Analysis, Software Design, Development, Integration,Implementation and Maintenance of Business Intelligence and Database Platforms. Over 5+ years of experience in Software Testing. Tableau Experience in Enterprise Environment, in Tableau 7.0, 8.0, 8.1 as a Analyst Experience working with banking applications and Healthcare. Expertise in administration, design, development, testing, deployment and support of BI Reporting tools and delivering accuracy, efficiency, and responsiveness. Experience in working on various SDLC models including Waterfall, RUP and Agile methodologies Conducted GAP Analysis, created use cases, workflows and PowerPoint Presentations Expertise in SQL Server Integration Services(SSIS) and SQL Server Reporting Services (SSRS)with good knowledge on SQL Server Analysis Services(SSAS) Transformed data from one server to other servers usingSQL Server Integration Services(SSIS) Vast experience in developing Business requirement documents (BRD), Functional Requirement. Specification (FRS), Software Requirement Specification (SRS), Use Case Specifications and Technical Requirements. Experience in product life cycle activities including discovery and requirements definition. Skilled in eliciting user demands and converting them into visualizing models, as well as ensuring that the business goal is met throughout the product lifecycle. Very good knowledge on Python learned out of interest. Proficient knowledge of the product lifecycle. Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau. Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie - Charts, Heat Maps, Bubble Charts, Tree Maps, Box Plots,Bullet Graphs, Geographic Visualization and other making use of actions, other local and global filters according to the end user requirement. Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
Overview
12
12
years of professional experience
Work History
Business Analyst
Optum
11.2020 - Current
- Employed customized agile software development process through iterations
- Worked on account tool and balance bar tool
- Developing and maintaining high-level overview of the project and design ows using MS Visio
- Gathered Business Requirements, Interacted with the Users and SMEs to get a better understanding
- Worked with multiple development teams since I worked on two tools
- Proposed creative features for trading applications
- Performed test cases at the end of three iterations performing UAT
- Management of time constraints e ciently and meeting the project deadlines
- Efficiently recorded incomplete features for later releases
- Gathered information regarding business problems by leading research Created ad-hoc queries to retrieve data from the database using SQL
- Writes requirements,epics, and userstories to suppoet product development
- Providing information by analyzing and translating information to IT teams and management
- Designed Use-Case, Active and Sequence diagrams using Unified Modeling Language (UML) methodologies
- Worked with the development teams to assure business requirements are met Tracking and managing changes in business requirements and scope of project
- Effective communication with business customers, upper management, technology specialists and vendors
- Designed business intelligence dashboard using Tableau Desktop and publishing the same on Tableau server, allowing Management to view current and past Delinquencies and HAMP, forecast Repayment Plan, and to track loan current state
- Created Tableau Extracts of historical data to quickly retrieve information for reports
- Designed Business Use cases and Functional Requirement Specification
- Experience with Data Extraction, Transformation and Loading (ETL), query enhancement and managing data relationship with IT teams Managed Traceability matrix for business, functional and use case requirements
- Created test plans and User Acceptance Test (UAT) procedures
- Determine opportunities for modifying business process and problem resolution and proposed for its changes
- Environment: Requirements Analysis, UML, Use Case Analysis, MS Visio, Rational Rose, Requisite pro, Oracle DB, SQL, ETL
Business Analyst
Citibank
01.2018 - 10.2020
- Involved in all phases of software development life cycle for this project, Agile Methodology Conducted daily stand up meetings in the role of a scrum master
- Assisted the manager on product backlog by documenting the user stories
- Managed and prioritized release backlog
- Conducted meetings and interviews with business associates to gather requirements
- Assisted in providing with cross-functional knowledge to developers and business users
- Tracking and managing requirements changes using Spreadsheets
- Acted as User Acceptance Testing coordinator and monitored business testing and interfaced with the development team regarding defect status and fixes on daily basis
- Also actively participated in UAT testing for the application
- Formulated Excel spreadsheets and charts for analyzing the reports
- Specification (FRS), Software Requirement Specification (SRS), Use Case Specifications and Technical Requirements
- Developed end user training modules for training the user about the new system
- Environment: Oracle 8.0, PL/SQL, MS Office Suite, UNIX, HTML
Core Software Quality Engineer
Hexagon PPM
10.2012 - 11.2017
- Experience in system design and development, with a focus on process improvement and business and technical requirements gathering.
- Coordinating with developers in identifying the complex scenarios in the product during development
- Acquire the skills necessary to work as a key member of a development team consisting of project managers, software engineers, and software quality engineers
- Create and perform validation tests as part of a quality engineering team for testing software features used in the design.
- Reviewed contracts between clients and contractors to ensure compliance with regulations and laws.
- Assisted in the preparation of construction budgets and estimates for projects.
- Ensured that safety protocols were followed at all times during the course of a project's development.
- Developed schedules for all phases of construction projects and tracked progress against timelines.
- Expertise in SQL Server Management Studio and MySQL
- Experienced in working on multiple teams if required
- Expertise in Agile Methodology – SCRUM (Sprint planning, Grooming, Retrospective meeting)
- Experience in testing (Manual) Mobile Applications on different devices (Android, IOS)
- Experience in working with other teams in achieving deliverables
- Ensuring all development tasks meet quality criteria through test planning, test execution, and quality assurance
- Involved in different phases of testing like Test case authoring, Test data preparation, Test case execution, and defect tracking
- Experience documenting workflow processes
Education
Bachelor of Science -
JNTUK
Skills
- Business/Data Analysis
- Software Design
- Development
- Integration
- Implementation
- Maintenance of Business Intelligence and Database Platforms
- Software Testing
- Tableau Experience in Enterprise Environment
- Tableau 70, 80, 81
- Banking applications
- Healthcare
- Administration
- Design
- Testing
- Deployment
- Support of BI Reporting tools
- SQL Server Integration Services (SSIS)
- SQL Server Reporting Services (SSRS)
- SQL Server Analysis Services (SSAS)
- Python
- Product lifecycle activities
- Eliciting user demands
- Visualizing models
- Design and deployment of rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau
- Design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie - Charts, Heat Maps, Bubble Charts, Tree Maps, Box Plots, Bullet Graphs, Geographic Visualization and other making use of actions, other local and global filters according to the end user requirement
- Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, Calculated fields, Sets, Groups, Parameters etc, in Tableau
- SQL
- PLSQL
- Java
- Windows Vista
- XP
- 7
- 8
- Unix
- MS SQL Server (2005, 2010, 2012)
- Oracle 9i
- DB2
- MS Access
- MS Office
- MS Outlook
- MS Project
- MS Visio
- Clear Quest
- Rational Requisite Pro
- SharePoint
- Quality Center
- DOORS
- Clear Case
- Clear View
- Tableau 90
- 81
- 80
- 70
- Informatica
Timeline
Business Analyst
Optum
11.2020 - Current
Business Analyst
Citibank
01.2018 - 10.2020
Core Software Quality Engineer
Hexagon PPM
10.2012 - 11.2017
Bachelor of Science -
JNTUK