Kranthi A Email & Phone Number

United States

* Experienced Data Analyst with expertise in reviewing business requirements and analyzing data sources from Excel/IBM DB2 Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.* Proficient in extracting data from various database sources like Oracle, SQL Server using Informatica to load the data into a single data warehouse repository.* Skilled in administering Joint Application Development (JAD) sessions, interviewing end-users, and categorizing business requirements into user stories and epics.* Actively participated in daily stand-up meetings to assist the Scrum team in prioritizing work and resolving technical issues, utilizing Agile tools such as JIRA for backlog management and creating reports for Sprint meetings using Burndown charts and Task boards.* Constructed AWS data pipelines using VPC, EC2, S3, Auto Scaling Groups (ASG), EBS, Snowflake, IAM, CloudFormation, Route 53, CloudWatch, CloudFront, and CloudTrail.* Proficient in unit test/integrated testing scenarios and building reports in Tableau for tracking representative performance and current business situations, leveraging data visualization techniques including Cross tabs, Heat maps, Box and Whisker charts, Pie charts, Bar charts, and donut charts.* Responsible for creating calculated fields, geo coding, and hierarchies using Tableau Desktop, collaborating with program managers, business analysts, and developers to transform data into actionable intelligence through graphics and analytics.* Prepared SQL & PL/SQL Queries to validate data in both source and target databases and supported Tableau reports in production by performing daily health checks on multiple dashboards and extracts.* Experienced Tableau administrator proficient in creating report schedules on Tableau server, managing user groups, and onboarding new users, as well as installing Tableau in Multi-node and Enterprise Deployments.

* Proficient in performing comprehensive data analysis using SQL, Python, SAS, and other tools to extract, transform, and load data from various sources, ensuring accuracy and reliability in insights generation.* Skilled in creating interactive and visually appealing reports and dashboards using Tableau and Power BI, with a focus on translating business requirements into actionable visualizations, including drill-down options and parameterization for enhanced user experience.* Experienced in identifying and documenting limitations in data quality that may impact analytical outcomes, collaborating with stakeholders to address data quality issues and ensure data integrity throughout the analysis process.* Demonstrated expertise in database design and implementation, including star-schema, snowflake schema, and dimensional data warehousing using tools such as Erwin. Additionally, proficient in utilizing cloud-based technologies like Azure Data Factory and Blob storage for efficient data management and backup. * Experienced in leveraging Hadoop ecosystem tools like Spark API, Hive QL, and Apache Kafka for performing advanced analytics on large datasets, contributing to the development of scalable and efficient data pipelines for real-time and batch processing.

* Proficient in identifying and prioritizing business-critical measures through close collaboration with subject matter experts (SMEs), conducting JAD sessions, and documenting requirements in the form of user stories and epics, ensuring alignment with organizational objectives.* Skilled in testing the Extract, Transform, Load (ETL) process, including data validation before and after processing, as well as testing messages published by ETL tools and data loaded into various databases, ensuring accuracy and reliability in data transformation and migration.* Experienced in writing complex SQL syntax, including stored procedures and functions, for Teradata SQL Development, unit testing, and performance tuning, ensuring efficient data retrieval and manipulation.* Proficient in developing mappings and workflows using tools like Informatica and DataStage, integrating metadata, and migrating repository objects and scripts from development to production environments, ensuring seamless data integration and system performance.* Skilled in developing scripts using PySpark (Spark with Python) for data aggregation, unit testing code to ensure proper target loading, and evaluating and enhancing data models to reflect evolving business requirements, contributing to the efficient processing and analysis of large datasets.

* Led feasibility studies, scope analysis, and SWOT analysis for proposed systems, providing strategic recommendations to enhance business processes and improve investment portfolio evaluation methods.* Devised innovative processes enabling customers to generate investment portfolio performance reports and statements, enhancing portfolio evaluation capabilities and customer satisfaction.* Managed functional specification and use case documentation, ensuring clear communication of business requirements and alignment with stakeholder expectations, utilizing tools like MS SharePoint and MS Excel for efficient collaboration and traceability.* Facilitated Joint Requirement Planning (JRP) sessions with stakeholders, SMEs, and development teams, employing Rational Unified Process (RUP) methodologies and Rational Requisite Pro for comprehensive requirement documentation and communication.* Created UI documents including mockups, wireframes, and prototypes, collaborating with development teams to enhance user interface design and usability, facilitating seamless user interactions and system navigation.

* Actively participated in all stages of the Software Development Life Cycle (SDLC) using the Waterfall methodology, ensuring smooth progression of projects from initiation to deployment while adhering to project timelines and objectives.* Developed comprehensive visual representations of technical processes using UML diagrams, including Use Cases and Activity diagrams, utilizing tools like MS Visio to enhance understanding and communication among project stakeholders.* Utilized MS Project to determine project deadlines and tasks, facilitating efficient project planning and ensuring timely deployment of deliverables, while maintaining alignment with project goals and objectives.* Conducted walkthroughs and meetings involving leads from Business Analysis, Development, and Technical Support teams to maintain a clear understanding of project goals among stakeholders, fostering collaboration and alignment throughout the project lifecycle.* Collaborated closely with Quality Assurance (QA) teams during User Acceptance Testing (UAT) and Functional Testing, leveraging strong SQL knowledge to extract and validate test data, ensuring the quality and reliability of software products.