Aswani Selvan

Email: ac5o70@r.postjobfree.com Phone: 551-***-****

Experience Summary

A Self-motivated and organized professional with 11+ years of experience as a business and data analyst, providing support in the areas of project coordination, data analysis, and metrics reporting. Able to translate business needs into complex analysis designs and recommendations. Able to perform complex multiple tasks while insuring seamless support of the overall project timeline. Strong communication and customer service skills. Strong end-user computing skills.

Professional Summary

Handle many data visualization projects using Tableau.

Expert in Reports, Dashboards and Metrics automation using Excel VBA, MS Access and Tableau.

Coordinated migration of reports from SQL server to SAP HANA.

Handled complex SQL scripts in SQL Server, Oracle, SAP Hana and Teradata.

Handled different Ad hoc change requests and analysis.

Have good experience in translating business needs into functional requirements specification document.

Ability to work in dynamic, fast pace environment and can keep up with the rapidly changing business needs.

Expert in excel modeling, Data modeling using MS Access and SQL Server.

Possess strong experience in Stakeholder engagement and also in collaborating with business, IT and other cross-functional teams.

Self-motivated individual with strong work ethic and team spirit.

Ability to work independent and gather customer requirements

Software Skills

Languages

VB 6.0, VBA

Reporting Tools

SAP Business Objects Enterprise XI 3.1 (Webi), Tableau Desktop and Server, SharePoint

OS

WINDOWS 7

Database

MS Access, SQL Server, Essbase Hyperion, Oracle-Toad, SAP-Hana and Teradata.

GUI

Visual Basic 6.0 / C#.NET, VBA with Excel and Access Macros, MS-Word Macros, Excel XLA, HVE.

Work Profile

The details of the various assignments that I have handled are listed below

BI Reporting Analyst – Tableau/SAP Hana

Cisco – BTOF – Pricing and Strategy – San Jose, CA

June 2015 – Now

Interacted with different Business units, Business analyst and other stakeholders to analyse business needs and developed technical specifications.

Involved in creating Dashboards, reports as needed using Tableau Desktop and Tableau Server.

Restricted data for particular users using Row level security and User filters.

Creating users, groups, projects, Data connections, settings as a Tableau administrator.

Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.

Developed Tableau workbooks from multiple data sources using Data Blending.

Worked with large amount of data and streamlined the process using various automations.

Performed data extraction and mining of large data sets from disparate business intelligence tools.

Developed databases and automated report generation process.

Acted as a Subject Matter Expert in the team.

Coordinated between Cisco IT and Business to migrate the data to Enterprise system.

Provide tableau training to business and non-technical users.

Reporting Analyst – VBA/SQL Server

Cisco – BTOF – Pricing and Strategy – San Jose, CA

Mar 2013 – 2015

Prepared weekly / monthly packages and executive management reporting packages.

Performed Ad-hoc financial analysis.

Handled large data sets in Excel and did Analysis as per the requirement.

Imported and exported data from text files, saved queries, or databases; used automatic outlining, inserted subtotals, created advanced filters, and used database functions.

Created pivot tables and charts using worksheet data and external resources, modified pivot tables, sorted items and group data, and refreshed and formatted pivot tables.

Worked with large amount of data and streamlined the process using various automations.

Prepared and documented the end to end data flow for the existing system.

Plan, design, and implement application database code objects, such as stored procedures and views.

Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.

Involved in requirements gathering, preparing business requirement documents (BRD) and designing front-end mock-ups, participated in BAT/UAT testing.

Reporting Analyst – VBA/Essbase Hyperion

UNILEVER CRT Team – Englewood Cliffs-New Jersey

Jan 2010 – Feb 2013

Unilever Sales and Financial is part of Unilever, the multinational corporation that owns many of the world's consumer product brands in foods, beverages, cleaning agents and personal care products.

The Unilever Sales team is responsible for the various reporting activates in all the regions of USA and Canada. IT team of the Sales group helps in automating the various reporting activities using Excel VBA connecting Essbase-Hyperion.

Acted as the lead technical Excel-VBA developer for Unilever North America sales team.

Automated a variety range of Sales Reports by retrieving the data from the Essbase external source in Excel sheet using Hyperion.

Essbase Hyperion is used to connect to the Merlin datacubes.

Designed queries using Essbase Query Designer

Have good knowledge in Hyperion Smart View.

Designed and developed various tools to automate the various reporting activity.

Incorporated Add In features into the excel sheets with XLA technology

Performed operational support for business reporting tools developed by Business Systems.

Have in-depth experience in Nitro-Nielsen tools

Handled different Ad hoc change request in Excel VBA.

Extensively used Excel and Access Macros and VBA with Excel Forms and Excel Charts.

Had exhaustive knowledge in Essbase APIs.

Coordinated with end users while they performed UAT (User Acceptance Test) to answer questions.

Automated the process of distributing the reports to users using Outlook and Excel VBA.

Created a repository of Excel reports paths with XLA technology.

Excel/Access VBA Programmer

CITI CARDS – Chicago

AUG 2006 – OCT-2009

Responsible for all project lifecycle phases, from specifications and coding through deployment, testing, debugging, documentation, and maintenance.

Created VBA programs to automatically update Excel workbooks, encompassing class and program modules and external data queries.

Created Front end screen for Updating and Validating the Non Monitory data in the FDR system by sending XML request and getting response using VBA.

Developed RAD using Excel VBA.

Develop Business Intelligence Applications using VBA.

Importing and exporting files between different systems.

Developed the CR Reporter Tool using Access VBA which stores all the CR information in the Access database and generates the weekly report in Word document.

Migrated and upgraded the existing application to perform better.

Design and develop various tools to automate the various reporting activity.

Prepare and send various reports/metrics using Excel-VBA to clients directly.

Generated Ad hoc query reports accounts related information to MS- excels reports and combined with OLE control.

Automated various processes using VBA with Excel.

Loaded Card Statement details from FDR Report in the form of text file to Excel spreadsheet.

Downloaded various FDR-reports from Mainframe environment and processed into Excel sheets.

Education Qualifications

Degree and Date

Institute

Major and Specialization

Bachelor of Technology

Pondicherry Engineering College,

Pondicherry, India.

Information Technology

Personal Details

US Visa Status

Green Card

Present Address

2180 Panorama Court,Dublin, CA-94588

Mobile Number

551-***-****

Contact this candidate