Surendhar Reddy Gopireddy
Summary
- Over 10 years of experience as a Business/Data Analyst, specializing in business intelligence, data warehousing, and fraud analytics for banking, retail, healthcare, and pharmaceuticals.
- Expertise in administering Power BI Report Server, including setup, configuration, migrations, and security management for enterprise BI platforms.
- Proficient in Software Development Life Cycle (SDLC) and Agile methodologies, performing requirements analysis, process modeling, and system testing.
- Skilled in Python programming for developing automation scripts and integration solutions, supporting BI and fraud detection workflows.
- Experienced in eliciting and documenting business requirements, creating use cases, and ensuring alignment with stakeholder needs.
- Strong knowledge of Agile and Waterfall methodologies, managing end-to-end project delivery across SDLC and STLC phases.
- Adept at requirements gathering through interviews, JAD sessions, surveys, prototyping, and brainstorming to capture business needs.
- Proficient in creating process models, including wireframes, flowcharts, and BPMN diagrams, using MS Visio for system design.
- Extensive experience with AWS cloud services, including EC2, S3, RDS, IAM, CloudWatch, Lambda, and CloudFormation, for data storage and automation.
- Skilled in Azure cloud technologies, including Azure Data Factory and Synapse Analytics, for hybrid data integration and analytics.
- High expertise in developing and maintaining Requirement Traceability Matrix (RTM) to ensure requirements adherence throughout projects.
- Experienced in performing GAP analysis, data mapping, and data modeling to support business process improvements.
- Proficient in Microsoft Office tools, including Excel, Visio, and PowerPoint, for documentation and process visualization.
- Conducted SWOT analysis and cost-benefit analysis to evaluate project feasibility and business impact.
- Utilized AWS CLI and management console to manage cloud resources and APIs for enterprise applications.
- Created UML diagrams, including use case, activity, and sequence diagrams, to model system workflows and processes.
- Strong understanding of data warehousing concepts, including schemas, data marts, and ETL processes for analytics.
- Experienced in data modeling for data warehouses, ensuring efficient data storage and retrieval for BI reporting.
- Skilled in designing ETL workflows using SSIS and Informatica PowerCenter, integrating with AWS and Azure cloud platforms.
- Proficient in data visualization using Power BI and Tableau, creating dashboards for actionable business insights.
- Experienced in SQL query development, including joins and stored procedures, for data analysis and validation.
- Utilized Python and R for data mining and statistical analysis, supporting predictive modeling and forecasting.
- Conducted data cleaning, normalization, and transformation to prepare datasets for BI and fraud analytics.
- Adept at managing SQL Server, Oracle, and Teradata databases, optimizing performance and ensuring data integrity.
- Experienced in User Acceptance Testing (UAT) and manual testing, creating test plans and cases for quality assurance.
- Managed Power BI Report Server lifecycle, including report publishing, user access, and data refresh troubleshooting.
- Hands-on experience with Big Data technologies, including Hadoop (Hive, Pig, MapReduce), Spark, Sqoop, HBase, Flume, and Oozie, for large-scale data processing.
- Strong background in statistical analysis and forecasting using SAS and R, applying regression, clustering, and text mining techniques.
- Advanced expertise in SQL Server BI stack (SSIS, SSRS, SSAS) for ETL, reporting, and analytics, supporting enterprise reporting needs.
- Experience with Java programming for custom tools, automation scripts, and integration with AWS and AEM platforms.
- Collaborated with IT and security teams to address vulnerabilities and ensure compliance with KYC/AML and HIPAA standards.
- Proficient in low-code platforms like Power Apps and Power Automate for integrating BI solutions with web services.
Overview
11
11
years of professional experience
Work History
Senior Business Analyst
TJX
Framingham
10.2023 - Current
- Analyzed requirements and segregated them into high-level and low-level use cases and activity diagrams using MS Visio according to UML methodology, defining data process models for retail systems.
- Led Workday HCM and Payroll implementations covering Core HR, US Payroll, Benefits, and Absence Management, ensuring automation of hire-to-retire processes.
- Designed and configured Workday Business Processes for onboarding, terminations, compensation changes, and payroll approvals to align with HR policies.
- Developed Advanced, Composite, and Matrix Workday Reports for payroll compliance, HR analytics, and executive dashboards.
- Automated HR and payroll processes using Workday Report Writer and BIRT for operational efficiency.
- Administered and optimized Power BI Report Server, including user security roles, permissions, and access control, ensuring compliance with enterprise standards.
- Administered Power BI Report Server with patch management, upgrades, and security compliance, integrating with Azure Active Directory.
- Collaborated with IT security teams to mitigate vulnerabilities and ensure enterprise compliance, leveraging AWS IAM for access management.
- Planned and executed Power BI and SQL Server migrations to Azure Synapse Analytics, integrating with on-premises systems for hybrid cloud adoption.
- Monitored server performance, capacity, and availability using AWS CloudWatch, implementing tuning strategies for scalability.
- Automated ETL processes with SSIS and Python, integrating with AWS S3 and Azure Data Factory for data storage and processing.
- Conducted training sessions and knowledge transfer for IT and business teams on Power BI and Azure analytics tools.
- Utilized senior-level SQL query skills (Oracle and T-SQL) to analyze and validate SSIS ETL database data warehouse processes.
- Converted business requirements to functional specifications and conducted JAD sessions to develop architectural solutions, resolving open issues.
- Analyzed data warehouse project database requirements, defining dimensions and facts for user analysis.
- Designed ERDs, DFDs, and metadata documentation to support reporting architecture for retail analytics.
- Developed integration solutions between AEM, AWS (Lambda, S3, API Gateway, CloudFormation), and third-party platforms.
- Developed automation scripts using Python for AWS Lambda, enhancing data integration with AEM and retail applications.
- Created and maintained requirements, test cases, and defects in JIRA, ensuring traceability.
- Utilized Agile/Scrum methodologies to monitor and develop project objectives, integrating AWS and Azure services for hybrid deployments.
Senior Business Analyst
Citi Bank
NYC
03.2022 - 10.2023
- Analyzed User Requirement Document (URD), Business Requirement Document (BRD), Technical Requirement Specification, and Functional Requirement Specification (FRS) to develop a data warehouse for personal lines property and casualty insurance.
- Collaborated with HR, Payroll, and Finance stakeholders to integrate Workday Payroll with ADP, Kronos, and third-party benefits systems, ensuring seamless data flow.
- Managed UAT execution, defect tracking, and documentation for Workday payroll enhancements, ensuring accuracy before production release.
- Supported US Payroll operations, including payroll runs, taxation, deductions, garnishments, and year-end compliance reporting.
- Managed Power BI Report Server administration, troubleshooting data refresh failures and resolving report access issues.
- Executed SQL Server and BI platform migrations to Azure Synapse Analytics, coordinating with IT for hybrid cloud integration.
- Designed and optimized SSRS reports and SSAS cubes for banking operations reporting.
- Partnered with IT security teams to address audit and vulnerability findings, leveraging AWS IAM for compliance with banking regulations.
- Implemented role-based access controls for Power BI and SQL Server users, integrating with Azure Active Directory for enhanced governance.
- Provided end-user training and documentation on Power BI and Azure analytics tools to support self-service BI adoption.
- Conducted advanced data analysis using SQL and Power BI to identify and mitigate emerging fraud patterns across consumer banking products.
- Built and maintained fraud rulesets in collaboration with risk and operations teams, improving fraud detection precision.
- Developed SSRS reports and Power BI dashboards to monitor fraud trends, providing actionable insights to stakeholders.
- Investigated complex fraud schemes, performing root cause analysis and implementing remediations to prevent recurrence.
- Utilized SQL to analyze structured and unstructured datasets, identifying anomalous transaction clusters based on account activity and volume.
- Collaborated with product and compliance teams to align fraud strategies with banking regulations (e.g., ACH NACHA rules, KYC/AML).
- Created automated workflows using Python and SSIS, integrating with AWS Lambda and Azure Data Factory for fraud investigation processes.
- Conducted consumer interviews and open-source research to validate fraud claims, escalating high-risk cases for further review.
- Developed and executed data migration strategies for BI platforms, ensuring seamless transitions to cloud environments.
- Used Erwin for logical and dimensional data modeling, created ER diagrams and workflows for insurance data systems.
- Automated testing and ETL deployments using Jenkins CI/CD pipelines, streamlining development processes.
- Designed ACORD Forms (insurance industry standards) to support compliance reporting for banking operations.
Business Analyst
UHG
MN
04.2019 - 03.2022
- Worked with the BI team to gather report requirements and utilized Sqoop to export data into HDFS and Hive for healthcare analytics.
- Ensured data integrity and security by managing Workday roles, permissions, and audit compliance reports, supporting HIPAA compliance.
- Provided end-user training and created process documentation for HR and payroll teams to adopt Workday solutions.
- Worked in Agile environments using JIRA and Confluence for requirements tracking and sprint planning.
- Supported Power BI Report Server administration, including patching, upgrades, and vulnerability resolution, with partial migration to Azure Synapse Analytics.
- Built and maintained Power BI dashboards and reports, integrating with AWS S3 for data storage.
- Developed ETL workflows with SSIS, leveraging Azure Data Factory for hybrid data integration.
- Partnered with security/compliance teams to ensure HIPAA and enterprise security standards, using AWS IAM for access management.
- Delivered Power BI and Azure analytics training to healthcare teams, driving platform adoption.
- Analyzed data using R, Python, and Jupyter Notebook, performing data collection, treatment, and mining to identify customer segments.
- Implemented Hadoop ecosystem tools (Sqoop, Hive, Pig, MapReduce, Oozie, HBase, Flume) for large-scale healthcare data processing.
- Upgraded Hadoop cluster (CDH3u6 to CDH4.4.0) to improve performance and scalability of data processing systems.
- Applied text mining in R and Hive to detect fraudulent claims in healthcare datasets.
- Developed MapReduce programs and Spark workflows for data cleaning, staging, and warehouse integration, leveraging AWS EC2.
- Installed and managed Flume infrastructure for data ingestion into HDFS, monitored via AWS CloudWatch.
- Created Hive queries to extract insights, comparing data with EDW reference tables for trend analysis.
Business Data Analyst
Quotient
Mountain View
12.2017 - 04.2019
- Interacted with users and business analysts to gather requirements for data warehouse migrations.
- Defined source-to-target data requirements, overseeing data mapping specifications for the data warehouse.
- Performed data validations using SQL inner and outer joins to ensure consistency.
- Wrote SQL queries targeting performance and recommended indexing strategies for database optimization.
- Developed processes on Teradata and Oracle using shell scripting, with partial migration to AWS RDS.
- Performed in-depth data analysis and prepared reports using MS Excel, MS Access, SQL, and UNIX.
- Developed SAS programs to load data from flat files to Teradata tables, supporting ad-hoc reporting.
- Wrote SAS programs for ETL and validation of flat files into Teradata, ensuring data accuracy.
- Automated reporting using VBA macros in Excel for finance and marketing teams.
- Optimized Teradata queries with indexing, volatile and multiset tables for performance tuning.
- Implemented OLAP functions (sum, csum, aggregates) for analytical reporting in Teradata.
- Generated reports for Telemarketing, Mailing, and New Accounts departments using SQL, BTEQ, and UNIX, stored in AWS S3.
- Integrated Azure Data Factory for hybrid ETL processes, connecting on-premises Teradata with cloud storage.
Data Analyst
Cipla
India
11.2014 - 08.2017
- Designed and implemented data models in R to analyze customer call tariffs, providing insights to IT teams.
- Gathered data requirements for new and existing data sources, ensuring alignment with business needs.
- Visualized and reported data findings using Tableau, delivering insights to stakeholders.
- Participated in cross-functional project teams to identify reporting requirements.
- Acquired data from multiple sources and prepared it for analysis, ensuring data quality.
- Worked with business managers to review requirements and created process maps using MS Visio.
- Generated Tableau dashboards for sales with forecast and reference lines, stored in AWS S3.
- Built ETL pipelines using Tableau Workflow Manager to extract, transform, and load customer and finance data.
- Conducted unit, system, and UAT testing, ensuring data accuracy across reporting layers.
- Leveraged SPSS for statistical modeling and analysis of financial and marketing data.
- Documented and reported on mortgage and lending datasets, aligning with compliance and regulatory requirements.
- Performed ETL processes using Informatica PowerCenter, loading data into Oracle databases with Azure Data Factory integration.
Education
Bachelor of Commerce - Business & Finance
Osmania University
Hyderabad, India06-2014
Skills
- Power BI
- Tableau
- SSRS
- SSAS
- SSIS
- Informatica PowerCenter
- DataStage
- SQL Server
- T-SQL
- Stored Procedures
- Oracle
- Teradata
- DB2
- AWS
- EC2
- S3
- RDS
- IAM
- CloudWatch
- Lambda
- CloudFormation
- Azure
- Data Factory
- Synapse Analytics
- Hadoop
- Hive
- Pig
- MapReduce
- Spark
- Sqoop
- HBase
- Flume
- Oozie
- SQL
- Python
- R
- SAS
- UNIX Shell Scripting
- Bash
- Korn
- Data Modeling
- ER
- Dimensional
- Data Warehousing
- Metadata Management
- Tableau Desktop
- Pandas
- NumPy
- Datorama
- SPSS
- Spring Framework
- Hibernate
- Apache Tomcat
- WebLogic
- Agile
- Scrum
- Kanban
- Waterfall
- SDLC
- JIRA
- Confluence
- Microsoft Office
- Excel
- Visio
- PowerPoint
- Project
- VBA
- Selenium
- HP Quality Center
- Git
- Jenkins
- User access/role management
- Vulnerability mitigation
- Audit compliance
- KYC
- AML
- HIPAA
- Power Apps
- Power Automate
Timeline
Senior Business Analyst
TJX
10.2023 - Current
Senior Business Analyst
Citi Bank
03.2022 - 10.2023
Business Analyst
UHG
04.2019 - 03.2022
Business Data Analyst
Quotient
12.2017 - 04.2019
Data Analyst
Cipla
11.2014 - 08.2017
Bachelor of Commerce - Business & Finance
Osmania University