Archana Surapaneni

Phone: (***)-(***) -(****) Email: ad2j5f@r.postjobfree.com

Professional Summary:

. Over 8+yrs of work experience in Data Analysis, Data Minning, Database Marketing, Customer Profiling, Decision Making, Market Research.

. Proven success in Project Management, Communication and Collaboration, Business Acumen, Contribution and leadership, Sprit Planning.

. Expert in handling large datasets, querying relational databases, create? Automate adhoc analysis/reports using SQL, Oracle, Teradata, Cloud.

. Strong skills in visualization tools like Power BI & Tableau.

. Expertise in various phases of project life cycles (Design, Analysis, Implementation, and testing).

. Proficient in all aspects of Data Extraction, Data Cleaning, Data Transformation, Data Loading, Data Visualization using SQL, SAS, Excel, Tableau

. Strong SQL development skills including writing Stored Procedures, Triggers, Views, and User Defined functions.

. Excellent communication, team membership and relationship management skills.

. Establish and maintain database indexing and partitioning strategies using SQL, optimizing performance, and ensuring swift retrieval of product details, order histories, and customer data, especially during peak shopping times.

Academic Qualifications:

Masters of Business Administration in HR and Finance in 2011. Masters in Computer and Information Systems in 2023. Technical/Interpersonal Skills:

Programming Languages SQL

Databases PL/SQL, SQL..

Other Tools Tableau Desktop, Tableau Server, Power BI. Computer Proficiency MS-Office, MS-Excel, MS-Word, PowerPoint, Windows XP, Windows 10 Soft Skills Team Leadership, Problem Solving/Critical Thinking, Going Above and Beyond, Decision Making, Multi-tasker

Work Experience:

Rivier University, Nashua- New Hampshire

Sr. Data Analyst / Tableau Developer July2023 -Dec2023

• Identify, analyze, and interpret trends or patterns in complex data sets to provide business insights, identify opportunities, help answer questions, solve problems, and make better decisions using Data Extraction and Data Visualizations tools.

• Define data collection needed across the functions and systems in the or

• ganization to support reporting and analysis using SQL, Tableau

• Examine, evaluate, and compare data sets for quality and precision.

• Design, develop, conducts unit testing, and maintains complex Tableau reports for scalability, manageability, extensibility, performance, and re-use.

• Mastered the ability to design and deploy rich graphic visualizations with drill down and drop-down menu option and parameters using Tableau.

• Using Sqoop tool to extract from a relational database into Hadoop.

• Use SBT to build the Scala project.

• Responsible for installing, configuring, and managing Hadoop cluster spanning multiple racks.

• Developed Spark programs in Scala to perform data transformation, creating Data Frames and running Spark SQL and spark streaming application in Scala.

• Performing different tasks such as data mining, data cleaning, data interpretation along with data visualization.

• Utilize data-driven insights, ranging from customer performance to internal operations, to identify areas of improvement and develop actionable recommendations.

• Involved in scheduling Teradata and UNIX object to running the jobs on daily/weekly basis depending on business requirement.

• Created stored procedures and functions to support data storage and manipulation.

• Created the Object Relational Database Tables with all the necessary Constraints.

• Work through iterative review cycles to deliver results that meet or exceed user expectations.

• Develop, execute, and monitor complex insights and analytical solutions to marketing problems analytical approaches and methodologies.

• Result driven Tableau consultant with background in business intelligence and analytics.

• Developed and maintained applications for various projects, adhering to best practices and design patterns.

• Involved in Agile development methodology active member in scrum meetings.

• Streamlined data visualization process resulting in increased efficiency and user satisfaction.

• Analyzed database performance with SQL query manager and optimized indexes to significantly improve queries.

• Implemented database schema changes and performed data migration for a critical client project, minimizing downtime and data loss.

• Implemented error handling and retry mechanisms in Step Functions to ensure fault tolerance and robustness.

• Collaborated with cross-functional teams, including software developers and data analysts, to gather requirements and design effective SQL solutions.

• Experience in design and developing applications leveraging MongoDB.

• Involved in developing a Map Reduce framework that filters bad and unnecessary records. Hyper Interact Service Pvt Ltd, Hyderabad

Sr. Data Analyst / Tableau Developer July 2022 – Sep 2022

• Use SQL to build complex queries/dashboards that will help drive business decisions across the product, customer success, and sales teams.

• Forecast marketing scenarios based on potential KPIs (revenue, spend) and support in evaluation of overall marketing campaign effectiveness.

• Created and maintained data connections, data sources and data visualizations in Tableau.

• Configured read replicas for read-heavy applications, distributing read traffic across multiple replicas, and improving read performance while offloading the primary database.

• Performed data migration between multiple environments using mongo dump and mongo restore commands.

• Skilled in project management and stake holder engagement with the ability to deliver high quality solutions on time and within budget.

• Use spark to process the data before ingesting the data into HBase. Both batch and real-time spark jobs were created using Scala.

• Build datasets and tables in Big Query and load data from cloud storage.

• Converted and modified Hive queries to use in Big Query and performed data cleaning on unstructured information using various tools.

• Work with different sources like HDFS, Teradata for Spark to process the data.

• Develop programs in Spark to use on application for faster data processing than standard MapReduce programs.

• Owned the design, development, and maintenance of ongoing and ad-hoc metrics, reports and analyses that drive the key business decisions.

• Processed data on store items, provided solutions for inventory order system.

• Worked with data investigation, discovery, and mapping tools to scan every single data record from many sources.

• Track, report and analyze the performance of marketing campaigns and streamline the automation of regular reporting and data processes using Tableau.

• Involved in converting Hive queries into Spark transformations using Spark RDD and scala/python.

• Boosted the performance of regression models by applying polynomial transformation and feature selection and used those methods to select stocks.

Hyper Interact Service Pvt Ltd, Hyderabad

Jr. Data Analyst April 2015 – Jun 2022

• Responsible for working on big data/analytics that gather & integrate large volumes of data, perform analysis, and develop actionable insights.

• Partnered with the business/operations teams to consult, develop KPI’s, automated reporting/process solutions to meet key business needs.

• Execute and maintain reports for external clients and internal support.

• Enable effective decision making by retrieving & aggregating data from multiple sources and compiling it into digestible and actionable format.

• Document the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.

• Built dashboards and data visualization reports in Business Intelligence platforms to intuitively demonstrate the business performance KPI’s.

• Worked with key internal and external partners to refine the models and optimize for increased response rate, conversion, risk and other KPI’s.

• Analyzed and report on campaigns to help drive performance improvements, growth opportunities by lowering costs, and improved responses.

• Assisted with campaign execution by providing data support across platforms, including processing the data and selecting the target audience.

• Experience articulating product questions, pulling data from datasets (SQL, Oracle, Teradata) & using summary statistics to arrive at solutions.

• Translated analysis results in business recommendations, and excellent written and verbal communication skills.

• Imported/Exported large amounts of data from Excel file to various data sources like Teradata, Oracle, SQL Server and ensured Data Accuracy

• Identified areas of improvement for internal channels data to reduce outdated or superfluous information, which reduced IT work tickets.

• Remain knowledgeable in all areas of business operations to identify systems needs and requirements.

• Ensure assigned projects are completed within budgets and schedules while meeting the business objectives.

Contact this candidate