SUMMARY

• Highly organized and result - oriented professional with experience in Tableau Development and Data Analytics
• Proficient in QAQC, Business Intelligence, Data Validation, Database and Data warehouse
• Advanced level of SQL Server databases, Microsoft SQL Server
• Proven experience in Tableau server, Tableau prep builder, Tableau desktop
• Strong Knowledge of Power Bi, Thought-Spot, and Adobe analytics
• Proficient in all Microsoft applications, Word, PowerPoint, ADVANCED EXCEL skills (Pivot Tables, VLOOKUP, Macros), MS Office suite, MS Access, Google Suite
• Knowledge of Workbench, Teradata, Data3sixty, Sales Force and Query Fabric
• Experience assisting Business Analysts in gathering requirements for development purposes
• Proven understanding of translating cell formulas in Excel into VBA code and using Excel-based VBA to design, analyze, and deploy programs.
• Proven experience in the use of DAX (Data Analysis Expressions) language
• Experience in Data Analysis and manipulation of complex data set for business need
• Understanding of SQL to generate queries in Database for exporting purpose
• Strong project management skills with good working knowledge and understanding of business and operational processes
• Ability to interact and work with internal & external stakeholders/vendors/clients at all levels.
• Self-aware, reflective and able to learn from mistakes, with an ability to learn quickly while on the job

TECHNICAL SKILLS

Languages: VBA, SQL, DAX(Excel), Tableau

Databases: MS-Access 2.0/97/2000/XP/ 2002/2003/2007

Operating Systems: WINDOWS NT 4.0, WINDOWS 98/95, WINDOWS XP, MS DOS

Tools: MS (Access, Excel, Word PowerPoint)

Other skills: VLOOKUP, Pivot table, VBA

PROFESSIONAL EXPERIENCE

Confidential

Tableau Developer Data Analyst

Responsibilities:

• Extract data from databases and data warehouses for reporting and to facilitate sharing between multiple data systems.
• Work with business teams in various areas of field sales to develop reports or address data needs to provide reporting solutions
• Maintain and manage advanced reporting, analytics, dashboards and other BI solutions using both Tableau and Power BI but not limited to it, which includes other reporting tools like ThoughtSpot
• Perform and document data analysis, data validation, data mapping/design, by accessing multiple sources, specifically data residing in data warehouses
• Synthesize and translate Business data needs into creative visualizations in Tableau
• Extract, Upload and Manipulate data on Enterprise Business Intelligence Software
• Write SQL query and perform table joins and complex data merges
• Manipulate Tables on Excel and Import to SQL using Enterprise Business Intelligence
• Created Excel based Analysis and reports using VLOOKUP, Pivot tables and complex excel formulas per business needs
• Identify and translate business needs and requirements into customized design and implementation of intuitive information dashboards, reports, and visualizations that are optimized for performance and use best practices
• Manipulate data on Salesforce for Visualization purpose.
• Create complex reports on Adobe Analytics
• Develop and implement databases, data collection systems, data analytics and other strategies that optimize statistical efficiency and quality
• Interpret data, analyze results using statistical techniques and provide ongoing reports

Confidential

Tableau Developer/ Data Analyst

Responsibilities:

• Created Excel based Analysis and reports using VLOOKUP, Pivot tables and complex excel formulas per business needs
• Data migration and Data validation/Testing through MS Access and MS Excel
• Wrote VBA codes for automated transferring of data between spreadsheets and work books
• Wrote VBA codes for exporting queries from Access Database to Excel
• Importing of data to Access and SQL Server from flat files and Excel spread sheets
• Manual review and correction of numerous errors and gaps for dataset using Data Analysis Expressions
• Maintained Access database for the purpose of extracting reports
• Developed interactive Tableau dashboards for presentations purpose
• Worked with the Business users to understand what reports were critical, non-critical and not needed.

Confidential

Data Analyst

Responsibilities:

• Created an MS Access database to collect data systems in order to provide lists, status reports and management overview reports
• Created BI reports in Tableau, Power BI, pivot charts, graph and other visualization format to Analyze trends
• Created Dynamic Charts/Graphs in MS Excel and MS Access using VBA
• Imported data from pre-existing text files and excel spreadsheets
• Generated the necessary BI reports and information to litigate tax appeals for properties
• Assisted Business Analysts in gathering requirements for Development purpose
• Documented weekly meetings with internal and external Stakeholders
• Created Dynamic Charts/Graphs in MS Excel and Access for biweekly/Monthly reporting purpose
• Manual review and correction of numerous errors and gaps for dataset using Data Analysis Expressions
• Communicated with external business vendors/clients and other general administrative tasks as assigned

Confidential

Data Analyst

Responsibilities:

• Created Excel based Analysis and reports using VLOOKUP, Pivot tables and complex excel formulas per business needs
• Data migration and Data validation/Testing through MS Access and MS Excel
• Wrote VBA codes for automated transferring of data between spreadsheets and work books
• Wrote VBA codes for exporting queries from Access Database to Excel
• Importing of data to Access and SQL Server from flat files and Excel spread sheets
• Manual review and correction of numerous errors and gaps for dataset using Data Analysis Expressions
• Maintained Access database for the purpose of extracting reports
• Developed interactive Microsoft Excel dashboards for presentations purpose
• Worked with the Business users to understand what reports were critical, non-critical and not needed.