Abhilash Muralidharan

• Develop a data platform from scratch and took part in requirement gathering and analysis phase of the project in documenting the business requirements.
• Developed rest API's using python done the integration of various data sources including RDBMS, Shell Scripting, Spreadsheets, and Text files.
• Developed scripts to load data to postgress table.
• Loaded complex JSON files to table.
• Experience in working on AWS EC2 Machine and execute programs using AWS lambda.
• Experience in using AWS step functions for scheduling the process flow.
• Created transformation rules to get data from different tables and created a master table based on business requirement.
• Analyzed complex data and identified anomalies, trends and risks to provide useful insights to improve internal controls.
• Collaborated with onshore team on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
• Contributed to internal activities for overall process improvements, efficiencies and innovation.
• Compiled, cleaned and manipulated data for proper handling.

Python

• Built and analyzed datasets using SAS,Python

• Converted multiple projects to automation using Python and Shell for Automation

• Ingesting raw data and transforming to processed data by merging,cleansing the data using pandas and numpy.

• Worked on data that was un-structured and structured from multiple sources.

• Migrated multiple clients from SAS platform to PYTHON.

• Worked on excel automation using xlwings,openpyxl modules

Web Crawling-Python

• Used the BeautifulSoup & Selenium Python Library to extract desired data from a given URL an automated way

• Worked with different stakeholders to gather the requirement (Finance,SCM,Sales and operations),created wireframe and completed the project.

• Worked on different web scraping projects across Genpact

• The data pulled from different URL was transformed using python and created power BI dashboard

Microsoft SQL Server

• Involved in creating multiple parameterized stored procedures which were used by the reports to pull out results.

• Used SSIS transformations such as SQL task, Script task and Send Mail task etc.

• Responsible for conducting store data audits.

• Wrote Microsoft SQL T-SQL codes including stored procedures, functions, triggers and ad hoc queries.

• Pulling data from mainframe and creating required reports though SQL

• Creating the output Reports using the report manager/Unify.