Phanindra Kumar Email & Phone Number

United States

• Demonstrated expertise in ETL processes utilizing Azure Data Factory, T-SQL, Spark SQL, U-SQL, and efficient data ingestion into Azure services.• Proficient in managing Hadoop metadata and optimizing Spark clusters on Azure Databricks; adept at troubleshooting Azure customer issues.• Skilled in data transfer from various sources to HDFS, leveraging Kafka, Zookeeper, and Apache Nifi for effective data movement.• Conducted data migrations to Azure Data Factory and Lake, employing Kafka and Spark Streaming for real-time data processing and ingestion.• Specialized in Snowflake Schema design, PySpark integrations, and OLAP cube development using Azure SQL Warehouse.• Developed robust web applications using the Django Framework, focusing on the model-view-controller architecture.• Created Clusters using Azure Data Explorer (ADE) storing and processing the Batch and streaming data using ADF and querying the data using KQL (Kusto queries).• Crafted user-friendly website interfaces, creating views and templates with Python and Django's view controller and templating language.• Developed consumer-centric features and applications using a blend of Python, Django, Pyramid, Flask, Web2py, HTML, and other web technologies.• Gained substantial experience working with Cloudera, Horton Works, and Azure HDInsight platforms.• Implemented Flask-based web applications adhering to MVC architecture principles.• Utilized CSS Bootstrap for front-end development, enhancing the user interface of web applications.• Proficient in using Python collections for intricate manipulation and iteration over user-defined objects.• Enhanced Hadoop performance using Spark and automated test scripts development in Python.• Skilled in Azure cloud services, including Azure Storage, Azure Active Directory.

United States

• Design and implement data pipelines to extract, transform, and load data from various sources into a data warehouse.• Develop and maintain data models and schemas to support business intelligence/Data warehousing (OLAP) and analytics applications.• Optimized data storage and retrieval systems for performance and scalability.• Collaborated with data scientists and analysts to develop and deploy machine learning models and algorithms.• Implemented data governance policies and procedures to ensure data quality, security, and compliance.• Managed and monitored data processing and storage infrastructure, including cloud-based platforms such as AWS or Azure• Hands-on experience on working with AWS services like Lambda function, Athena, DynamoDB, Step functions, SNS, SQS, S3, IAM etc.• Snowflake migration hosted on Azure from existing SQL server databases, SAP BW, and other flat files and JSON files, in order to make informed decisions in the space of marketing analysis.• Implemented migration into snowflake warehouse with automated pipelines.• Designed data migration architecture for both historical and incremental data load.• Developed and implemented various objects, views, external tables according to the requirement and the data file format in Snowflake.• Used Where Scape RED for Snowflake as an ETL tool to enable scheduled transition of data from on-premises databases to Snowflake.• Imported data from AWS S3 into Spark RDD, VPC Peering, AWS Private Virtual Interfaces, Performed transformations and actions on RDD’s, Transit Gateways.• Data modeling in Snowflake to arrive at the required data tags using SQL.

Boston, Massachusetts, United States

• Leveraged transactional and analytical data to drive business objectives, providing key insights through data analysis and reporting.• Expert in the full Software Development Life Cycle (SDLC), from requirements gathering to design and development, with a focus on data-intensive applications.• Specialized in RESTful web services development using Python, Flask, and PostgreSQL; proficient in building and maintaining scalable server-side applications.• Analyzed data using SQL, python, power BI and Tableau to identify relevant insights and improve decision-making.• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes (OLAP) SQL Server reporting services (SSRS). Created & formatted Crosstab, Conditional, Drill-down, Top N, Summary, Form, OLAP, Sub reports, ad-hoc reports• Developed a Command Line Interface (CLI) tool for Red Hat Linux, improving operational productivity.• Implemented XML parsing with Python for lightweight data management, bypassing traditional database dependencies.• Built and maintained Linux Services for RESTful web services deployment, utilizing advanced shell scripting techniques.• Designed and executed test cases for REST API and CLI tools, ensuring robustness and reliability through comprehensive test frameworks.• Utilized Jenkins for automated deployment and testing of web services, reinforcing continuous integration and delivery practices.• Played a key role in network infrastructure management, automating VLAN and router configurations to optimize network operations.• Contributed to version control and codebase management using SVN on Linux, maintaining code integrity and facilitating collaborative development.• Designed data models and executed analytical reports using SQL and Erwin, providing critical support for marketing and finance reporting.

Hyderabad, Telangana, India

• Elicited and detailed functional system requirements and non-functional system requirements• from cross-functional technical teams to identify needs of new analytical environment• Wrote complex SQL queries involving joins, sub queries and creating temporary/volatile tables, using Teradata SQL Assistant and SQL Developer.• Created Data mapping documents to capture the source to target data flow and any transformation and business logic involved.• Create tools or queries to obtain data from a central data repository for reporting, quantitative• and qualitative data analysis and present final analysis to customers.• Prepared Scripts in Python and Shell for Automation of administration tasks.• Worked on Tableau to build Interactive transaction migration Dashboards with drill-down• capabilities for reporting and monitoring, Developed SQL scripts for accessing data from the Teradata/SQL server tables, Worked in data quality, data organization, metadata, and data profiling• Performed Data Analysis to provide insight over data defects and future state issues that might arise over time during new data migration.• Created test cases, analyzed the results, tracked the defects by generating reports and map the• test cases to requirements to create trace ability metrics• Tested the iterative versions using RUP methodology.• Developed status update templates and provided timely status updates for the status review meetings.