Apurv Patel

Automation Specialist

S&P Global Market Intelligence

Ahmedabad

11.2017 - Current

Web Scraping and crawling data using web watcher, Mozenda, Python script etc.
Building python scripts using for automate the manual processes and to extract accurate data with lean practice.
Creating javascript plugins to scrap the data with more eﬃcient and quick manner.
Maintained, debugged and optimized automation programs.
Prepared automation concept and control drawings according to client specifications.
Produced monthly reports using advanced Excel spreadsheet functions.
Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
Developed required policies and procedures that reflected actual goals, tasks and workflows, while meeting all regulatory compliance requirements.
Designed and developed data pipelines to acquire, clean and process data.
Updated and developed scripts and queries to extract and analyze data from multiple sources.
Provided technical support for troubleshooting analytics and reporting issues.
Analyzed data to identify root causes of problems and recommend corrective actions.
Assessed software bugs and compiled findings along with suggested resolutions for development team members.
Checked configuration files and logs to uncover root causes of problems.
Discussed requirements and processes with project managers and developers.
Worked closely with different departments to develop innovative solutions to functionality issues.
Providing a lean ideas for new data collection methods and product enhancements related to the covered content sets
Train other peers on existing tools.
Supported business needs dependent on location, working with staff at all levels to produce targeted solutions.