Sailaja Reddy Email & Phone Number

Pasadena, California, United States

Chicago, Illinois, United States

->Designed and executed batch ETL processes with precision, leveraging Azure Synapse Analytics.->Balanced workloads effectively by utilizing both SQL and Spark pools for diverse data processing needs.->Employed Spark Structured Streaming for real-time data pipelines, enhancing agility in data analytics.->Applied sophisticated physical data modeling constructs, optimizing schemas, tables, views, and indexes.->Implemented star schema and snowflake schema techniques, ensuring a robust foundation for effective data representation.->Developed intricate ETL jobs, specializing in incremental loads and managing change data capture scenarios.->Leveraged PowerShell scripting for end-to-end task automation, encompassing CI/CD pipelines and resource management.->Demonstrated proficiency in decision-making constructs, enhancing automation efficiency in complex workflows.->Implemented Docker for packaging and deploying applications, showcasing mastery in containerization concepts.->Utilized Kubernetes for seamless orchestration, demonstrating adeptness in pod, service, and config map management.->Submitted Hadoop jobs programmatically, showcasing knowledge in HDFS architecture, block storage, and HiveQL.->Implemented robust security measures, encompassing row-level and object-level access controls for data integrity.->Utilized Azure Synapse Studio for proactive monitoring, ensuring pipeline and trigger efficiency.->Integrated Azure Synapse Analytics seamlessly with Power BI, creating visually compelling reports and dynamic dashboards.->Applied visualization tools within Synapse for real-time monitoring, enhancing decision-making capabilities.->Collaborated seamlessly with cross-functional teams, integrating Azure Synapse Analytics into broader data ecosystems.->Implemented cost-effective strategies, optimizing resource utilization, and right-sizing workloads based on demand.

Mclean, Virginia, United States

• Involved in Requirement gathering, Business Analysis, Design and Development, testing, and implementation of business rules. • Experience in developing Spark applications using Spark-SQL in Databricks for data extraction, transformation, and aggregation from multiple file formats for Analyzing& transforming the data to uncover insights into the customer usage patterns. • Extract Transform and Load data from sources Systems to Azure Data Storage services using a combination of Azure Data factory, T-SQL, Spark SQL, and U-SQL Azure Data Lake Analytics. Data ingestion to one or more Azure services (Azure Data Lake, Azure Storage, Azure SQL, Azure DW) and processing the data in Azure Databricks• Understand business use cases, integration business, write business & technical requirements documents, logic diagrams, process flow charts, and other application-related documents. • Design and develop ETL integration patterns using Python on Spark.• Develop framework for converting existing PowerCenter mappings and to PySpark(Python and Spark) Jobs. Create Pyspark frame to bring data from DB2 to Amazon 53. • Translate business requirements into maintainable software components and understand impact (Technical and Business)• Used Pandas in Python for Data Cleansing and validating the source data. • Designed and developed ETL pipeline in Azure cloud which gets customer data from API and processes it to Azure SQL DB. • Orchestrated all Data pipelines using Azure Data Factory and built a custom alerts platform for monitoring. • Created custom alert queries in Log Analytics and used Webhook actions to automate custom alerts. • Created Databricks Job workflows which extract data from SQL server and upload the files to sftp using pyspark and python. • Used Azure Key vault as a central repository for maintaining secrets and referenced the secrets in Azure Data Factory and also in Databricks notebooks.

Jacksonville, Florida, United States

● Extensively involved in the Installation and configuration of Cloudera Hadoop Distribution.● Implemented advanced procedures like text analytics and processing using in-memory computing capabilities like Apache Spark written in Scala● Developed spark applications for performing large-scale transformations and denormalization of relational datasets.● Have real-time experience with Kafka-Storm on the HDP 2.2 platform for real-time analysis.● Loaded data into the cluster from dynamically generated files using Flume and from relational database management systems using Sqoop.● Created reports for the BI team using Sqoop to export data into HDFS and Hive.● Performed analysis on the unused user navigation data by loading it into HDFS and writing MapReduce jobs. The analysis provided inputs to the new APM front-end developers and the lucent team.● Loading the data from multiple data sources like (SQL, DB2, and Oracle) into HDFS using Sqoop and loading into Hive tables.

Hyderabad, Telangana, India

● Understand the data visualization requirements of the Business Users. ● Writing SQL queries to extract data from the Sales data marts as per the requirements. ● Developed Tableau data visualization using Scatter Plots, Geographic maps, Pie Charts, Bar Charts, and Density charts. ● Designed and deploy rich Graphic visualizations with Drill Down and Drop-down menu options and Parameterized using Tableau. ● Created action filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau. ● Explored traffic data from databases connecting them with transaction data, and presenting as well as writing reports for every campaign, providing suggestions for future promotions. ● Extracted data using SQL queries and transferred it to Microsoft Excel and Python for further analysis. ● Data Cleaning, merging, and exporting the dataset was done in Tableau Prep. ● Data processing and cleaning techniques carried out to reduce text noise, reduce dimensionality to improve the analysis.

Hyderabad, Telangana, India

● Processed data received from vendors and loaded them into the database. The process was carried out every week and reports were delivered on a bi-weekly basis. The extracted data had to be checked for integrity.● Documented requirements and obtained signoffs.● Coordinated between the Business users and development team in resolving issues.● Documented data cleansing and data profiling.● Wrote SQL scripts to meet business requirements.● Analyzed views and produced reports.● Tested cleansed data for integrity and uniqueness.● Automated the existing system to achieve faster and more accurate data loading.● Generated weekly, and bi-weekly reports to be sent to the client business team using business objects and documented them too.● Learned to create Business Process Models.● Ability to manage multiple projects simultaneously tracking them towards varying timelines effectively through a combination of business and technical skills.● Good Understanding of clinical practice management, medical and laboratory billing, and insurance claims with processing with process flow diagrams.● Assisted the QA team in creating test scenarios that cover a day in the life of the patient for Inpatient and Ambulatory workflows.