Data Analyst Business Intelligence

Shreya Harshitha Challala

901-***-**** *****************@*****.***

Professional Summary

Data Analyst with 4 years of experience working across all phases of the Software Development Life Cycle (SDLC) utilizing methodologies such as Agile Scrum, Waterfall, and Rapid Unified Process (RUP).

Proficient in system analysis, business analysis, data modeling, and process improvement. Skilled in gathering requirements, performing gap analysis, and preparing technical specifications and documentation.

Adept at using SQL, Tableau, Excel, and ETL tools for data transformation, data integrity testing, and business intelligence solutions. Highly experienced in data consolidation, modeling, and performance tuning.

Experienced in managing product backlogs and creating detailed user stories with clear acceptance criteria for Agile Scrum projects.

Proficient in developing Use Cases, Use Case Diagrams, Sequence Diagrams, Activity Diagrams, and Class Diagrams using Microsoft Visio and Word.

Extensive experience in business intelligence tools, including OLAP, data warehousing, reporting, querying, data mining, and spreadsheets.

Experienced in data consolidation and working closely with Data Modelers and Architects on data modeling and migration projects.

Expertise in data transformation, metadata management, data dictionary development, data loading, modeling, and performance tuning.

Knowledgeable in DBMS/RDBMS implementation using object-oriented concepts and database toolkits.

Skilled in software prototyping using UI mockups and wireframes to enhance requirement visualization and improve user experience.

Experienced in conducting GAP analysis and preparing detailed technical specifications.

In-depth experience in process/data modeling, quality assurance/testing for both client-side and server-side applications, as well as data warehousing solutions. Technical Skills

• Programming Languages: Java, C#, SQL, PL/SQL, HTML, CSS, XML, JSON, JavaScript, Python

• Databases: Oracle, SQL Server, MS Access, Teradata

• Data Modeling: MS Visio, ER Studio, ERWIN

• Methodologies & Frameworks: Agile/Scrum, ATDD, BDD, TDD, Waterfall Model

• Web Servers: TESTING, SOAP UI

• Operating Systems: UNIX, Linux, Windows, Mac, iOS, Android Professional Experience

Data Analyst

Aetna Remote April 2023 – May 2024

• Knowledge of large datasets and experience with performance tuning and troubleshooting.

• Provided application support by analyzing and resolving data correction issues in live databases through direct interaction with clients.

• Contributed to all phases of the Software Development Life Cycle, utilizing the Rapid Unified Process (RUP) methodology.

• Led efforts in gathering requirements, performing analysis, documenting findings, conducting follow-ups, reporting, and coordinating between business owners and technical teams.

• Collaborated closely with the project manager to define project scope, interpret business requirements, and develop detailed project plans.

• Facilitated Joint Application Development (JAD) sessions and conducted interviews with SMEs to gather both functional and non-functional system requirements.

• Performed Gap Analysis between legacy system ("As-Is") models and future-state ("To-Be") models to identify business needs and required changes.

• Developed business requirements documentation, including Project Scope Documents, Epics, Business Requirements Documents (BRDs), Functional Requirements Documents (FRDs), Entity-Relationship (ER) Diagrams, and Use Cases using MS Word and MS Visio.

• Created process flow diagrams to visualize and review system operations and requirements.

• Generated Requirement Traceability Matrices (RTM) to ensure seamless tracking of requirements throughout the development process.

• Performed report validation by writing SQL queries using TOAD with Oracle databases, ensuring data accuracy and integrity.

• Gained hands-on experience using Vision Plus (CDM, CMS module) to manage insurance card transactions.

• Developed and executed test cases as part of the User Acceptance Testing (UAT) team to validate system performance and functionality.

Environment: MS-Word, MS-Excel, MS- PowerPoint, MS-Visio, IBM Rational Requisite Pro, Windows, Quality Center, SQL, TOAD, Oracle.

Data Analyst

Sapotech Solutions Pvt Ltd May 2019 – July 2022

• Developed and executed SQL queries on staging and data warehouse tables to validate and ensure data accuracy.

• Delivered comprehensive solutions for Enterprise Data Governance, Data Quality, Metadata management, and ETL using Informatica.

• Maintained and managed Excel workbooks, utilizing pivot tables, exporting data from external SQL databases, generating reports, and updating spreadsheet data.

• Collaborated with the QA team to resolve data issues identified during regression testing.

• Liaised with business users to confirm business rules and communicated changes effectively to the ETL development team.

• Created Tableau dashboards with complex calculations and hierarchies, providing insights into large datasets.

• Performed Data Integrity testing using SQL queries on Teradata databases, validating data accuracy with TOAD.

• Partnered with data architects to implement necessary adjustments to data models.

• Contributed to the development of ETL mappings and processes using Informatica (Data Warehouse).

• Utilized Tableau Server for publishing and sharing reports with business stakeholders.

• Managed reports and performed advanced Excel operations such as Pivot Tables and V-Lookups to manipulate data structures.

• Tested and validated data post-load using logs generated after data was loaded into the Data Warehouse. Developed traceability matrices aligning requirements with test cases.

• Worked on Master Data Management (MDM) for maintaining customer data and applying ETL rules.

• Engaged with multiple layers of Business Intelligence infrastructure for data consolidation, harmonization, and analysis.

• Leveraged OLAP tools such as ETL and data warehousing and performed data extraction, transformation, and loading using Informatica and SSIS from SQL Server to Oracle databases.

• Collaborated with user groups to analyze requirements and proposed necessary design changes.

• Conducted Detailed Data Analysis (DDA), Data Quality Analysis (DQA), and Data Profiling on source data to ensure data accuracy and integrity.

Environment: MS-Office Suite (Word, Power Point, Excel), MS Visio, Rally, Windows 7, Java, Quality Center 10.0, SharePoint 2010, TOAD, Oracle.

Contact this candidate