I have strong appetite of mathematics, statistical & analytical techniques and can work with ease on tools like Excel, Power BI, R & SQL Data Analysis.
I can provide data insights by developing analysis process (and automation) around the raw data sources to deduce meaningful results in form of decks, dynamic models and online reports.I am an excel expert with over 13 yrs of experience. I also have over 7 years experience programming SQL, R . I can help you in designing excel sheets from scratch or amending existing one all excel automation tasks using VBA , dashboard design data analysis in R programming language .
Application design and development using Microsoft Technologies, Database design and maintenance, SQL Programming including stored Procedure Writing, Trigger writing and complex query writing. Some of my Key Expertise Includes: • ERP Consulting and maintenance. • Developing Complex VBA Macros. • Data management in Excel. • Advance Excel Formulas. • Dynamic Excel Charts. • Statistical Data Analysis. • Dashboards/User Interface Forms. • Web scrapping in Excel using VBA • Creation of Excel Reports from Raw data in Excel or from other databases. • Conditional Formatting in Excel. • Developing Pivot Table. • Creation of Excel Addins to perform specific tasks in Excel. • Writing Complex Sql Queries, triggers and stored procedure. • Database management and administration for databases like SQL Server,My SQL and Oracle. • Web and Desktop application development using