Sri Spandana Paleru

Email: ad1f3x@r.postjobfree.com Ph: 704-***-****

LinkedIn: https://www.linkedin.com/in/sri-spandana-paleru/ Objective:

Dedicated and results-oriented Data Analyst with 6+ years of experience in leveraging advanced data analysis techniques and programming skills to optimize risk strategies. Proven expertise in SQL, PL/SQL, Teradata, Snowflake, AWS, Python, statistical analysis, data visualization, risk analytics, and fraud prevention. Adept at collaborating with cross-functional teams and stakeholders to implement innovative automation strategies and generate actionable insights. Professional Summary:

• Around 6+ years of decent experience as a Business Intelligence Developer.

• Proficient in Business Analysis, Design, Development, and Implementation of enterprise-wide windows and data integration jobs using Microsoft tools & Teradata technology.

• Experience in SQL/Business Intelligence with good knowledge of both OLTP and Data Warehousing/OLAP Systems.

• Involved in Data Migrations, Transfers, and ETL Processes (Data Extraction, Transformation layer) using utilities like Data Transformation Services (DTS), and SSIS.

• Worked on Performance Tuning by means of Teradata SQL Assistant to improve the performance.

• Expert in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.

• Experience in Unit testing, Functional testing, Integration testing, Regression testing and UAT

• Proficient in analyzing sources and creating Source to Target Mappings (STM)

• Proficient at Debugging, Fixing bugs and Maintenance

• Experience in all phases of SDLC like Requirement Analysis, Implementation, and Maintenance, and extensive experience with Agile and SCRUM.

EXPERIENCE:

Technical Data Analyst - Tabner INC - TIAA Dec 2022 – Till Date

• Collect and organize key data points, analyzing U.S. and international financial markets and customer spending behavior to develop data-driven insights for risk strategy optimization.

• Propose and prioritize engineering requirements with technology teams to align portfolio financial goals and corporate objectives.

• Manage a portfolio of relationships, ensuring payment solutions meet financial and timeline objectives.

• Conduct deep dive analysis on business trends, translating insights into easily consumable presentations.

• Utilize modeling and analytics to understand the impact of risk decisions on top and bottom lines.

• Develop statistical models and business cases for new risk policies, risk vendor integrations, and risk infrastructure enhancements.

• Monitor portfolio performance and identify improvement opportunities using data mining and visualization tools.

• Collaborate with cross-functional teams to deploy optimal payment solutions, exchanging best practices. SQL/Business Intelligence Developer Tabner INC - Charter Communications - May 2018 - Dec 2022

• Conducted in-depth data analysis to identify trends, patterns, and insights, enabling data-driven decision-making processes.

• Developed and maintained interactive dashboards and reports using tools like Google Big Query, providing real-time business intelligence to stakeholders.

• Played a key role in the Agile development team, applying Lean principles to streamline workflows, resulting in a 20% increase in project delivery speed.

• Collaborated with business users to define KPIs and metrics, ensuring alignment between data analysis efforts and organizational goals. Worked on designing, developing, tesgng, and maintaining ETL jobs using DataStage and Teradata.

• Excellent problem-solving skills, ahengon to detail, and ability to work independently or in a team environment to meet project deadlines. Employed Snowflake for data warehousing and performed in-depth data analysis to uncover trends and paherns.

• Utilized MS Excel for data reporting and analysis, generating reports, and presenting findings to senior management.

• Collaborated with Charter Communications' teams to ensure data accuracy and consistency across multiple projects.

• Implemented data integration and ETL processes using DataStage, optimizing data workflows and efficiency.

• Fostered strong client relations by effectively communicating insights and addressing client needs working in a full development life cycle, Created Database objects as tables, views, user-defined functions, cursors, Store Procedures, Constraints, and roles. Involved in creating Store procedures and User-defined functions for SSIS packages.

• Created and maintained DDL, DML Scripts, and Databases. Created Store Procedures for automatic day-end processing through SQL Server Agent.

• Worked on performance tuning to increase the response times. Involved in creating Unit Testing Plan Documents and test strategies to test the ETL workflows and reports.

• Had exposure to work with Enterprise and residential Finance, Sales teams and

• Experience working on Metadata management (MDM), Data Governance Data, and in-sync audit teams to help create the required audits on the main ETL Processes.

• Involved in creating Prototypes, wireframes, and POC (Proof of Concept) for new Projects.

• Responsible for creating ad hoc reports as required by Business Users and stakeholders. Performed data validation, error checking, troubleshooting, and performance tuning. Production monitoring and overall support.

• Generated reports to support the general operations of the company and provide reporting solutions to diverse business teams using Micro Strategy.

• Developed metrics to measure ongoing business performance, campaign effectiveness, and customer experience.

• Maintain version of code by using version control tools like GitHub, Source Tree, and Tortoise SVN Tag the developed code scripts of a project using the repo browser, of which the link will be shared to downstream environments for validation and migration purposes.

Environment: Teradata SQL assistant, SSIS, SSMS, SSDT, Oracle SQL Developer, MS Excel, Teradata Studio, JIRA, GitHub, Source tree, agile methodology, MicroStrategy

Data Analyst ATOM SOLUTIONS- Vishakhapatnam, AP - Jan 2014 -Feb 2015

• Creating a web application to narrow job search for job seekers.

• Scheduled jobs to automate database-related activities such as backups, maintaining index, monitoring disk space, and backup verification.

• Using text mining techniques to infer information from unstructured data. Used unsupervised learning algorithms on job descriptions to classify them into different clusters.

• Applied Clustering Algorithms such as K-Means to categorize customers into certain groups.

• Data cleansing, transformation, and creating new variables using R

• Coded JSP pages, and Java Servlets in struts framework, prepared test cases for reviewing and understanding the flow of the application.

• Performed exploratory data analysis like calculation of descriptive statistics, detection of outliers, assumptions testing, factor analysis, etc., in R Analyze and Prepare data, identify the patterns on the dataset by applying historical models.

• Performed data transformation method for rescaling and normalizing variables.

• Exploratory data analysis and Feature engineering to best fit the regression model.

• Applied predictive models to car maintenance records to predict car sales based on its usage and fuel efficiency.

• Implemented forecasting models to predict car sales for to coming seasons so that we can meet the demand. Skills:

• Programming Languages: SQL, PL/SQL, Python

• Databases: Teradata, Snowflake, Oracle, AWS

• Tools: Jupiter, MS SQL, Data Visualization Tools (e.g., Tableau, Power BI)

• Analytical Skills: Statistical Analysis, Risk Analytics, Fraud Prevention, Anomaly Detection

• Soft Skills: Business Acumen, Collaboration, Change Management, Effective Communication

• Other: Risk Score Model Development, Loss Prevention, Data Assessment, Automation Strategies Education:

South Dakota State University Master’s in data science GITAM UNIVERSITY Bachelor of Technology in Computer Science and Engineering

Contact this candidate