Web automation

Excel automation

Outlook automation

Data analysis

Robotic Process Automation - Automate the process as according to the needs of client. Responsibilities:- -Data Gathering and Process understanding and analysis - Automate Data validation mass data upload to web portals -Transform large volume of data with the help of Python (data science) Libraries. -Develop automated desktop application with interactive user interface using Python that end user can use it easily. -Develop automated application so end users only need to click and repetitive work is automated. -Perform Automation which include Reports Automation, Web Automation, Outlook automation using Python and VBA. -Maintenance and debug already built modules or applications. -Communicate with clients throughout the transition & migration phase. -Integration of VBA and Python already built code (enhance productivity) -Use Version control system (github) to keep tracks of releases system. - Deliver the data and automated process to client as per requirement. -Develop SOPs of reports as per their automation and analysis

Web automation and excel automation

Automate Websites and Data ETL Operations Tools Used VBA, SQL-Server 2012, Macros, Python, MS-Access Overview: -Develop automation application to extract the data from web and other sources. -Create and analyze large volume of data in tab delimited format. Load the Data in the SQL Server Database. -Deliver the data to client as per their requirement. -Executing automation and provide data to customers, regular, one-time, weekly or monthly depending artifacts. -We promise accuracy, that you can rely upon to make smart decisions. -We are providing large volume of data records daily to our customers. -Analyze and clean large amount data Responsibilities o Involved in requirement analysis, business analysis, Quality Assurance, and implementation of System. o Writing scripts to automate manual task with the help of VBA and Python o Writing Macros, Modules and Class Modules. o Hands on experience on SQL Procedures and triggers. o Data Analysis, Data Validation, Data Cleansing, Data Verification, and identifying data mismatch. o Troubleshooting, resolving and escalating data related issues and validating data to improve data quality. o Extensively tested the Business Objects report by running the SQL queries on the database by reviewing the report requirement documentation. o Validating the data files from source to make sure correct data has been captured to be loaded to target tables. o Identifying duplicate records in the staging area before data gets processed. o Optimizing several complex SQL queries for better performance and efficiency. o Created and executed SQL queries to perform source to target testing o Performed the following tests: DATA COMPLETENESS, VALIDITY, UNIQUENESS, DATA INTEGRITY, DATA QUALITY o Create the test data for generating sample test reports before releasing to production. o Wrote complex SQL scripts using joins, sub queries and correlated sub queries, triggers and procedures. o Interacting with senior peers or subject matter experts to learn more about the data.

Web automation

develop kapow Robots and Databases to extract data from websites Responsibilities: o Development of robots using kofax kapow. o Extract data from different types of property, building, transaction & tax related websites o Gather requirement specification from – ALM(Application lifecycle management) tool –(Tool to handle and manage projects) o Extract binary data (pdfs and images) from websites using robots o Debug and Maintenance of already built robots and update and improve if needed o Transformation of robotic applications from different platform to Kapow framework. o Analyze websites and develop database to store those data. o Tests developed robots and verify whether extracting correct data or not (i.e perform data cleansing).