SUMMARY

• Over 8 years of Experience in Designing, Administration, Analysis, Management in the Business Intelligence Data warehousing, Client Server Technologies, Web - based Applications and Databases and Experience in industries such as Retail, Financial, Accounting, Distribution, Logistics, Inventory, Manufacturing, Marketing, Services, Networking and Engineering, and Government Projects.
• Experience in all the Latest BI Tools Tableau, Qlikview Dashboard Design, Alteryx and, Power BI.
• Experience in complex BI Reports, Dashboards, Project Management, Change/Incident Management, Maintenance, upgrade, Fix pack/Service pack installations, and Root cause analysis, Resolution Methods Time/ Cost/Budget Management.
• 5 years’ Experience in Tableau and Qlikview Dashboards in latest Design and Presentation.
• Creation of metrics, attributes, filters, reports, and dashboards. Created advanced chart types, visualizations and complex calculations to manipulate the data. Act as a Point of Contact in Data Interoperability, Analytics and BI and Production Support issue resolution.
• Designed, developed and supported BI solutions, Involved in Debugging and monitoring, and troubleshooting issues/tickets. Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data.
• Transformed Tableau into a managed service offering for consumption across Corporate Treasury and Corporate Investments.
• Experience in Developing Performance Dashboards, Score cards, Metrics, What if analysis, Prompts, Drills, Search (using Add-ons), Reports/Dashboards for all the functional areas including Finance, Change Management, Order Management, Pricing, Purchasing, HR, Demand Planning, Discrete Manufacturing, Quality, Inventory Warehouse Management, Supply Chain, and Transportation, Sales / Marketing, Variable Objects with formulas.

TECHNICAL SKILLS

Web Technologies: HTML, Java Script, VB script, Alteryx and Power BI.

Data analysis/ETL Tools: Ewin, Base SAS and Informatica 8.6. Oracle, SAP, and P21.

Packages: Microsoft Excel, Microsoft Visio, Microsoft SharePoint and Microsoft Project.

Business Intelligence Tools: Qlikview.

PROFESSIONAL EXPERIENCE

Confidential, New Jersey

Lead Business Analyst/Tableau Developer

Responsibilities:

• Delivered high-quality Business Intelligence (BI) services and data visualization solutions for Confidential .
• Responsible for creating training and outreach programs that raise the level of skill in data analytics and reporting across campus.
• Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Responsible for interaction with business stake holders, gathering requirements and managing the delivery.
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Connected Tableau server with share-point portal and setup auto refresh feature.
• Created visualization for logistics calculation and department spend analysis.
• Generate KPI for customer satisfaction survey results.
• Maintained Test log and Wrote test Evaluation, Summary Reports
• Extensively involved in doing user acceptance testing (UAT).
• Generated Test Cases for each specification in Requirement Specification Document corresponding to each module.
• Generated the test plan specifying an overview of testing approach, testing strategy, roles, responsibilities and its scope.
• Created Test Scripts, Test hierarchy to represent the features and functionality that need to be test in the application.
• Analyzed user and business requirements attended periodic meetings for changes in the application requirements and documents.
• Performed Parallel Testing or Production Testing, which ensures that the new system will perform correctly in a production environment and interface correctly with other production systems.
• Participated in the User Acceptance Warranty Testing. Involved in doing security and negative testing of the application.

Confidential, New York

Lead Tableau Developer

Responsibilities:

• Creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data.
• Transformed TABLEAU into a managed service offering for consumption across Corporate Treasury and Corporate Investments.
• Act as a Point of Contact/Administrator in Data Interoperability, Analytics and Business Intelligence and Production Support issue resolution.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Designed, developed and supported BI solutions, Involved in Debugging and monitoring, and troubleshooting issues.
• Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data.
• Work directly with management, vendors, and third parties to ensure that Web-site’s financial transactions and database management applications operate at peak efficiency.
• Ensured projects were completed on time and within budget.
• Played key role in enhancing client’s Web reporting system, reducing time of delay financial tracking.
• Purchasing, setting up, and configuring a Tableau Server and MS-SQL 2008 R2 server for Datawarehouse purpose.
• Consolidate multiple data silos that exist on campus to one location.
• Sophisticated stored procedures and triggers to provide complete technical solutions.
• Worked with all levels of development from analysis through implementation and support. Participated in test planning and test script definition.
• Resolved end user reporting problems through collaboration with IT and Operations.

Confidential, New York

Business Analyst

Responsibilities:

• Identify and document in written reports the economic, market and other industry factors and trends that affect business success and value for approximately 125businesses per year, in a wide range of industries.
• Collect and review business and economic financial information from various sources and analyze using Excel modeling tools.
• Research information on companies as part of competition or market analysis, for use in comparable company analysis, and as potential buyers or targets in merger and acquisition engagements, as well as in support of sales and marketing efforts.
• Write, edit and format company materials for print, Web and email, including for client reports and company marketing materials.
• Set up and send email newsletters and other email distributions, review success and responses, and maintain contact information, using ACT, Constant Contact and other tools.
• Maintain and manage company databases (in Filmmaker, ACT, Access, and Excel), coding reports, user interface screens and applications as needed.
• Support company client-server computers, network and users. Maintain company website, using FrontPage and other tools.