Summary
Overview
Work History
Education
Skills
INTERNSHIPS
Timeline
Generic

SOWMYA PIRATLA

Overland Park,KS

Summary

Responsive expert experienced in monitoring database performance, troubleshooting issues and optimizing database environment. Possesses strong analytical skills, excellent problem-solving abilities, and deep understanding of database technologies and systems. Equally confident working independently and collaboratively as needed and utilizing excellent communication skills. Background includes data mining, warehousing and analytics. Proficient in machine and deep learning. Quality-driven and hardworking with excellent communication and project management skills. Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals. To seek and maintain full-time position that offers professional challenges utilizing interpersonal skills, excellent time management and problem-solving skills.

Overview

5
5
years of professional experience

Work History

Data Engineer

Insightary LLC
01.2023 - Current
  • Experience in building and architecting multiple Data pipelines, end-to-end ETL, and ELT processes for Data ingestion and transformation in GCP
  • Strong understanding of AWS components such as EC2 and S3
  • Implemented a Continuous Delivery pipeline with Docker and Git Hub
  • Worked with g-cloud function with Python to load Data into BigQuery for on-arrival CSV files in the GCS bucket
  • Designed compliance frameworks for multi-site data warehousing efforts to verify conformity with state and federal data security guidelines.
  • Generated detailed studies on potential third-party data handling solutions, verifying compliance with internal needs and stakeholder requirements.
  • Built databases and table structures for web applications.
  • Prepared documentation and analytic reports, delivering summarized results, analysis, and conclusions to stakeholders.
  • Designed and implemented effective database solutions and models to store and retrieve data.
  • Analyzed complex data and identified anomalies, trends, and risks to provide useful insights to improve internal controls.
  • Explained data results and discussed how best to use data to support project objectives.
  • Communicated new or updated data requirements to the global team.
  • Developed, implemented, and maintained data analytics protocols, standards, and documentation.
  • Contributed to internal activities for overall process improvements, efficiencies, and innovation.
  • Designed and developed analytical data structures.
  • Designed advanced analytics ranging from descriptive to predictive models to machine learning techniques.
  • Prepared written summaries to accompany results and maintain documentation.
  • Used GDP on validation protocols, and test cases, and changed control documents.
  • Process and load bound and unbound Data from Google pub/sub topic to BigQuery using cloud Dataflow with Python
  • Devised simple and complex SQL scripts to check and validate Dataflow in various applications
  • Performed Data Analysis, Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export through Python.
  • Developed and deployed data pipelines in the cloud such as AWS and GCP
  • Performed data engineering functions: data extraction, transformation, loading, and integration in support of enterprise data infrastructures - data warehouse, operational data stores, and master data management
  • Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability
  • Generated detailed studies on potential third-party data handling solutions, verifying compliance with internal needs and stakeholder requirements

Process Analyst

Genpact India Pvt.Ltd
03.2020 - 06.2021
  • Managed pay-per-click accounts on Google AdWords, Google AdWords Editor, Google Analytics, and other search platforms for a variety of websites
  • Utilized successful bidding strategies and effectively managed keywords to significantly increase revenue on pay-per-click search engines
  • Achieved target acquisitions and their volume goals utilizing CPA and CPL efficiency metrics
  • Reported the performance of any tests conducted on pay-per-click campaigns
  • Authorized to make decisions relative to eliminating underperforming ad copy/keywords and adding new content
  • Applied skills in SEO and SEM techniques and learn strategies to increase search engine visibility
  • Performed keyword search, database entry of new ads, its written content, determined appropriate landing pages
  • Worked closely and built personal relationships with Google and Bing Teams to optimize account performance
  • Monitored and maintained keyword and product bids, quality scores, budget caps, and other account metrics
  • Met and surpassed company goals while working in coordination with the team and other departments
  • Analyzed web traffic flow, and implemented adjustments to optimize web page performance
  • Trained and supervised new employees and interns
  • Developed standard operating procedures and document workflows to drive current and future processes
  • Assessed products or services to evaluate conformance with quality standards

Risk Product Specialist

Uber India Pvt. Ltd
02.2019 - 10.2019
  • Addressing, prioritizing, and escalating bug issue to the concerned team/individual
  • Detection of fraud MO methods while increasing automation and creating a better experience
  • Supported teams in tool requirements
  • Involved in analyzing legacy sources to figure out data quality issues
  • Proficient in conducting penetration tests to identify vulnerabilities in software applications, networks, and systems, employing industry-standard methodologies and tools
  • Report tool/data issues to stakeholders, follow up with Phab tickets, and get them fixed
  • Collaborated with the Engineering and Product team to enhance tools, system functionality
  • Meet daily, weekly, and monthly productivity and quality targets set for the role
  • Facilitating fraud risk workshop
  • Worked closely with Business Intelligence and Development Teams
  • Leading discussions with the senior client management to discuss the risk of fraud and evaluating the adequacy of controls to prevent and detect fraud
  • Support the in-tool requirement
  • Investigate compliance violations of Uber partners in different LOBs
  • Collaborating with the Engineering and Product team to enhance tools and system functionality.
  • Trained and provided coaching to junior team members
  • Researched and identified solutions to technical problems
  • Generated reports to track performance and analyze trends
  • Monitored system performance to identify potential issues
  • Diagnosed and troubleshot hardware, software, and network issues
  • Offered assistance in implementing and developing training programs
  • Collaborated with vendors to locate replacement components and resolve advanced problems
  • Developed and implemented preventive maintenance procedures
  • Assisted in the development of system security protocols
  • Broke down and evaluated user problems, using test scripts, personal expertise, and probing questions
  • Helped streamline repair processes and update procedures to support action consistency
  • Assisted in the development of system security protocols

Business Analyst

Accenture India Pvt. Ltd
03.2018 - 02.2019
  • Worked on ICT - Incentive Fraud Risk where I have to analyze fraudulent accounts behavior/Transactions to determine the root cause of the loses
  • Provided key support to day-to-day business operations in multiple capacities, including data mining, analysis, and validation
  • Experienced in performing in-depth vulnerability research, analyzing software and systems for potential weaknesses, and developing effective mitigation strategies
  • Perform analysis on the customer account to identify the potential fraudulent customers
  • Coordinating with the stakeholders on the workflow analysis
  • Acted as Subject Matter Expert and part of the training team for new hires
  • Part of the team testing new tools before they hit the production floor in sync with the Eng Team, to give feedback on the features of the tool
  • Worked on Reports, presentations on MS Office, and Google Spreadsheet/Presentation to keep track of the performance
  • Analyzing fraudulent patterns and improving the team to be cautious of fraudulent customers
  • Handling various activities of the project like information gathering, analyzing the information, documenting the requirements
  • Developed and distributed reports to inform management and stakeholders
  • Detected errors and initiated or arranged for corrective action, following through with cognizant parties to verify the resolution
  • Collected, organized, and provided data to maintain program status and customer commitments
  • Developed and updated tracking spreadsheets for process monitoring and reporting
  • Conducted regular reviews of operations and identify areas for improvement
  • Supported the creation of detailed, technical financial models to value potential acquisition targets
  • Devised and implemented processes and procedures to streamline operations
  • Developed effective improvement plans in alignment with goals and specifications
  • Reviewed budget and sales reports and utilized findings to execute budget forecasting
  • Detected errors and initiated or arranged for corrective action, following through with cognizant parties to verify the resolution

Education

Master of Science - Computer Science

University of Missouri - Kansas City
Kansas City, MO
05.2023

Bachelor of Technology - Computer Science

JNTUK
05.2016

Skills

  • Languages: C, C, Java, SQL, Python, R
  • Software Development Principles: Agile Methodology, Test - Driven Development, Continuous Integration, Unit Testing, Integration Testing
  • Scripting Languages: Ruby, PHP, PowerShell, Shell Scripting, HTML, CSS, Bootstrap
  • Cloud Platforms: Microsoft Azure, AWS, Google, Cloud Platform
  • Databases: Postgre SQL, Oracle, MySQL, SQL Server, MS Access
  • Operating Systems: Windows, Mac, UNIX and LINUX
  • Hadoop/Big Data Technologies: HDFS, Hive, Spark, SparkSQL, Kafka
  • Hadoop Distributions: Cloudera Hadoop
  • ETL Tools: IBM Infosphere Information Server V8,V85 &V91
  • Microsoft Technologies: MS Project, MS Word, MS Visio, MS Powerpoint, MS Excel, SharePoint, MS Access
  • Methodologies: Waterfall, Agile, Scrum, Structured SDLC Methodology
  • Defect Tracking Tools: JIRA, PHAB
  • Master Data: Data Extraction, Data Cleansing, Data Enrichment, Data Management, Data Quality, Data Governance, Data Modeling, Data Analysis, Data Testing
  • Project Management: Stakeholder Management, Product Development, Risk Management, Query Optimization
  • Data Visualization Tools: Tableau, Power BI

INTERNSHIPS

Software Developer Intern  -  Vizag Steel Plant                    June 2015 - September 2015

Conternt Creator Intern - Planet Den                                       April 2013 - August 2013

Timeline

Data Engineer

Insightary LLC
01.2023 - Current

Process Analyst

Genpact India Pvt.Ltd
03.2020 - 06.2021

Risk Product Specialist

Uber India Pvt. Ltd
02.2019 - 10.2019

Business Analyst

Accenture India Pvt. Ltd
03.2018 - 02.2019

Master of Science - Computer Science

University of Missouri - Kansas City

Bachelor of Technology - Computer Science

JNTUK

Similar Profiles

CREATE PROFILE
SOWMYA PIRATLA