Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Sireesha Marupuru

Bristow,VA

Summary

Qualified [Desired Position] with thorough background in data analysis and proven track record of delivering actionable insights. Developed and implemented data models leading to improved business decision-making processes. Demonstrated proficiency in SQL and Python, showcasing keen ability to collaborate with cross-functional teams.

Overview

21
21
years of professional experience
1
1
Certification

Work History

Sr. Data Analyst

Inovalon
10.2013 - Current
  • De-Identification - De-identifying key data fields and processing Healthcare client data to be consumed by downstream systems for analytics
  • Converged Data Ingestion (Cloud Migration) - Data migration of various data pipelines (legacy applications) from MS SQL Server (on-prem) to AWS Cloud
  • Indices - Processing data to extract from multiple sources, transform, and load into a data warehouse for report generation
  • HIXeCAAS – Data processing and submissions for Health Insurance Marketplace
  • Served as a key software development team member as a Data Analyst / SME on development projects in an Agile environment
  • Analyze source data to identify data quality issues
  • Created test data sets, and performed ETL validation by validating data integration processes and transformation to ensure data accuracy and integrity using SQL queries
  • Performed Big Data validation in the Hadoop ecosystem by ingesting large data sets in HDFS and validating loaded data in Hive tables using HQL
  • Performed Cloud Migration testing and validated distributed data in MongoDB, S3, Azure, Aurora, and Snowflake databases
  • Validated SNS notifications generated during ingestion and distribution process completion
  • Performed the De-Identification process using Python Spark scripts and validated the masked data
  • Used Yarn, Oozie, and Ambari to monitor all the services running on the Hadoop ecosystem
  • Validated Kafka logs loaded to Kibana dashboards for performance monitoring
  • Performed Rest API validation using Swagger and Postman
  • Validated report dashboards in Tableau
  • Performed 508 compliance verification testing and reviewed technical requirements of the software
  • Created and maintained test summary dashboards in Azure DevOps
  • Participated in Root Cause Analysis and worked closely with Business Analysts and Developers in identifying the cause of the failure
  • Responsible for validating Customer Hotfixes and Production Support
  • Participated in sprint ceremonies like grooming, planning, stand-ups, and retrospectives
  • Coordinate with onshore and offshore teams, worked closely with project managers and developers, and handled multiple priorities simultaneously
  • Communicated requirement gaps ahead that resulted in minimizing the defects during the release cycle
  • Handled multiple critical releases under tight deadlines and quickly adapting to new tools and technologies
  • Environment: Agile, Hadoop, Hive, Spark, Oozie, Mongo, Green Plum, Kibana, Kafka, MSSQL Server, Tableau, Azure, Aurora, Athena, Snowflake, S3, EC2, EMR, Redshift, Cloud Watch, Glue, Python, Java, GIT, Cucumber, TFS, VSTS, Swagger, Postman, SharePoint

Sr. QA Analyst / Test Lead

Netuitive
04.2007 - 10.2013
  • Develop Test cases, Test schedules, and Test strategies for the projects
  • Provided Gap Analysis on the requirements
  • Perform SQL data validations, Unit, Interface, Functional, Load, Performance, Load Balance Testing, Failover Cluster testing, Web services, Cross-Browser, and Security testing to check for vulnerabilities
  • Perform back-end database testing by writing and executing complex SQL queries
  • Execute Regression and Sanity testing on nightly builds using QTP automation
  • Generate Test Summary Reports and Defect Status reports
  • Lean Agile approach followed throughout SDLC
  • Project Management and defect tracking is done using JIRA
  • Employed a 'test-to-break' approach to testing initiatives and clarified ambiguous requirements to ensure the effectiveness of all test plans
  • Created and maintained QA documents on Confluence
  • Delivered thorough QA testing reports that determined product quality and release readiness
  • Trained and mentored new members of the team
  • Created and maintained wiki pages that contained the architecture details and updates for the project which helped team members to get onboarded easily
  • Environment: Agile, Test Link, JIRA, Confluence, QTP, Eclipse, ANT, Aqua Data Studio, Oracle, SQL Server, UNIX, XML, HTML, Java, Visio, SharePoint, Windows 2000 server, Web Logic, MS Excel, VMware

Functional Quality Engineer

Freddie Mac
06.2006 - 12.2006
  • Analyze business and system requirements for the assigned project
  • Prepare test data from sample files received from the dealer and create trades
  • Developed test execution plan and coordinated testing efforts between Freddie Mac and vendors (JPMC and BlackRock)
  • Created and executed Test scenarios and prepared manual test cases using the Quality Center
  • Perform Functional, System, Integration, and End-to-End testing of the application for all the releases
  • Execute Regression and Sanity testing on nightly builds using QTP automation
  • Developed UAT test scripts and scenarios for functional testing and assisted the UAT team in preparing the Test Data
  • Perform various data checks using SQL Scripts to validate the data loaded to TDS
  • Validate charter compliance fields and reports generated in CAS
  • Involved in sending trade instructions from Aladdin to JPMC using SWIFT Messaging
  • Create and maintain RTM, Test Plan, Test Strategy, and Test Summary Report for each release
  • Initiated and led the Daily Test Status meetings that gave quick insight to the Business and Stakeholders about the open issues and the test status
  • Environment: Java, Web Portal, SWIFT Network, JPMC's VIEWS portfolio Reporting, IBM WebSphere, Oracle JDBC thin driver, Apache’s Log4J, J2EE 1.3, Apache’s Ant v1.6.x for compilation, TOAD UNIX, DOORS, Quality Center, Rational Clear Case and Rational Clear Quest

QA Analyst

Verizon
08.2004 - 06.2006
  • Responsible for all aspects of the QA cycle for assigned projects using a Waterfall methodology
  • Review the test plan and create test cases in the Quality Center- to ensure they match and cover all the requirements in the BRD (Business Requirements Document)
  • Perform Functional and regression testing by submitting orders on Mainframe applications like CG and ESG
  • Responsible for Daily and Weekly Batch processing
  • Perform UAT testing by submitting orders through Unity
  • Develop automated scripts using WinRunner for regression testing
  • Track defects using Test Director, Lotus Notes tickets database
  • Environment: Waterfall methodology, UNIX, Oracle, Quality Center, WinRunner, Java, JSP, XML, Mainframe and Windows NT

Education

Bachelor of Engineering - CSE

KSRMCE
Kadapa
06.2000

Skills

  • Data Analysis: SQL, Excel, Tableau, Power BI, Python (Pandas, NumPy)
  • Data Management: ETL Processes, Data Cleansing, Data mapping, Data mining, Data Quality
  • Healthcare Informatics: HL7, FHIR, ICD-10, CPT, SNOMED, LOINC, HIPAA Compliance, Electronic Health Records (EHR) Systems, Claims Processing
  • Database Management: SQL Server, Oracle, Mainframe, Redshift, MongoDB (NoSQL), PostgreSQL, MySQL
  • Cloud Technologies: Amazon RedShift, Snowflake (EC2, EMR, S3, Cloud Watch, Athena, SNS, IAM, Secrets Manager,Azure
  • Big Data Technologies: Hadoop, Hive, Spark, Oozie, Ambari and Bedrock
  • Operating System: Unix, Windows
  • Programming Languages: Core Java, SQL, Python, Unix Shell Scripting, HTML, XML
  • Log Monitoring: Kibana, Datadog
  • Test & Defect Management Tools: Azure DevOps, JIRA, Bugzilla, HP Quality Center, Rational ClearQuest, Test Director
  • Build Management: Atlassian, Jenkins, TFS, GitLab, GIT Hub, Share point, Ant, Maven
  • Other: Kafka, Swagger, Postman, SOAP UI, Cucumber, Confluence, VSTS, VMWare

Certification

  • AWS Certified Cloud Practitioner
  • SAFe Certified Agilist

Timeline

Sr. Data Analyst

Inovalon
10.2013 - Current

Sr. QA Analyst / Test Lead

Netuitive
04.2007 - 10.2013

Functional Quality Engineer

Freddie Mac
06.2006 - 12.2006

QA Analyst

Verizon
08.2004 - 06.2006

Bachelor of Engineering - CSE

KSRMCE

Similar Profiles

CREATE PROFILE
Sireesha Marupuru