Mgmt Sr. Analyst - Tools & Microautomation

Design and develop a variety of tools to automate the extraction of web information (writing web scrapers using VBA, calling third party APIs, creating SQL queries, etc.)

Good experience in web mining process, developing tools that pull large amount of information from website into Excel

Process Automation and Tool designing using Excel VBA, Macro and Microsoft office application

Create tools and processes to download data, parse it for relevant content, and store it in existing data management systems

Proficient in report design & analytics, table/query design and automation utilizing VBA modules and extracting data from CMS or different file formats like XML, text.

Merge multiple excel files or single excel file into many excel files for better data analysis

Understand and Analyze of current optimization problem

Schedule executable VBA files through Shell scripting

Qualifications:

Graduate with 4-8 years of experience with software development experience

Good knowledge of web technologies, Microsoft

SharePoint

 Server, MS Excel VBA/macro development, browser plugin development.

Familiarity with web crawler/spider construction, web etiquette, concurrency, and text-processing.

Proficient in Reporting and analysis. MS Excel and VB Script preferred

Capable of creating a report with data visualization (e.g. graphs and charts)

Previous e-Commerce experience preferred

Problem solver, like to work in an agile, collaborative environment, create tools and experiences that improve and solve repetitive tasks.

Technical Requirements:

Minimum 4 years of experience years of experience of programming and tool development

Must expertise in VBA programming

Proficient in HTML, CSS and JavaScript frameworks XML and SQL

Hands-on Dot Net, ASP.NET, C#, Microsoft Access, SQL server, stored procedures

Nice to Have Technical Skills:

MOSS

 (Microsoft Share Point), Any CMS Experience,

Previous web experience a plus; should be willing and able to pick up web programming

Certification in ITIL, Agile, Six Sigma would be an advantage