SUMMARY:

• Certified in Tableau Desktop Associate and Tableau Desktop specialist
• Business Intelligence Professional with over 4 years of experience in the field of IT, Business/Data Analysis along with vast experience in interpreting, analyzing and reconciliation of data obtained from a variety of sources.
• Extensive experience in Business Intelligence analytics, Reporting and ETL technologies.
• Involved in end - to-end, large and diverse Analytics, Business Intelligence projects.
• Expertise in end to end (SDLC) development of business dashboards and reports.
• Extensive professional experience in design, development, implementation and support of critical Business Intelligence (BI) applications.

TECHNICAL SKILLS:

Business Intelligence: Tableau, Qlikview, SAP Business Objects 4.0

ETL: Alteryx, SAP BO Data Services

SAP: SAP BEx Query designer, BEx Analyzer, Crystal, Xcelcius, Business Object

OS: Windows 10

Project Management Tools: MS Project, MS Visio

Database: MS Access, MS SQL Server 2008, Oracle, Salesforce, SAP HANA

WORK EXPERIENCE:

Metric and Reliability Analyst

Confidential

Responsibilities:

• Responsible for defining, gathering, analyzing data from different source systems to provide key trend analysis and provide insight to support strategic business decisions.
• Involved in Development and enhancement of existing Tableau Dashboards.
• Developed POCs and designed Tableau Workbooks and Reports
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on the new changes to ensure that the views and dashboards were displaying the changed data accurately
• Reconciled the report data with the source systems and reviewed it to find any data anomalies.
• Migrated Excel reports to Interactive Tableau Dashboards.
• Combined multiple dashboards into a single story to enhance the visual appeal of the report.
• Designed, developed, tested, and maintained Tableau functional reports based on user requirements
• Represented business team in scrum meetings as business owner for various analytics projects
• Tableau development skillset including visualization development, use of parameters, and report optimization.
• Develop canned / Ad-Hoc reports and complex dashboards in Tableau as needed for Executives.
• Ability to use custom SQL for complex data pulls.
• Proficient with Cross tab, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails, Density Chart, etc.
• Experienced in creating Calculations (Table Calculations, Hide Columns, Creating/Using Parameter, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Mar Card Changes, Rich Text Formatting) using Tableau Desktop.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like bar graphs, scatter plots, pie-charts, geographic visualization and other making use of actions, other local and global filters according to the end user requirement.
• Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Develop and generate standard and ad hoc reporting capabilities from new and existing data sources
• Experienced in developing rich Interactive report, dashboards and other user interface elements integrating various reporting components from multiple sources.
• Posses’ strong knowledge of database management in writing complex SQL queries.
• Extracting data from different sources connecting them and used the same to create dashboards.

Data Visualization & BI Analyst

Confidential, Irving, TX

Responsibilities:

• Responsible for interaction with business stake holders, gathering requirements, understand the data from different source systems and managing the delivery.
• Investigated root cause analysis for favorable and unfavorable trends and provided timely resolutions.
• Extracted, interpreted and analyzed data to identify key metrics and transform raw data into meaningful, actionable information.
• Analyzed requirements for various reports, dashboards, scorecards and created proof of concept / prototype the same using Tableau desktop.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Developed Tableau workbooks to perform YTD, QTD and MTD type of analysis.
• Generated context filters and data source filters while handling huge volume of data.
• Built dashboards for measures with forecast, trend line and lines.
• Created Business requirement documents and plans for creating dashboards.
• Generated tableau dashboards for sales with forecast and lines.
• Generated tableau dashboards with combination charts for clear understanding
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gnatt charts using show me functionality.
• Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Pie Charts, Doughnut Charts, Tree maps, Bubble Charts, etc., to assist business users in solving complex problems.
• Created worksheets using parameters, calculated fields, groups, sets and hierarchies in Tableau.

Business Research Analyst

Confidential

Responsibilities:

• Transitioned the team from an intuition based to a fact-driven decision making culture.
• Involved in designing analytics environment for operational data by creating POCs using Qlik Sense.
• Implemented filters, scorecards, charts on dashboard reports on Performance point for analytical and aesthetic purposes.
• Investigated root cause analysis for favorable and unfavorable trends and provided timely resolutions.
• Developer various Ad hoc reports based on the business user requirements.
• Created mock-ups showing the intended functionality, visual aspects of the dashboards to be developed.
• Helped end users to design test cases and worked through multiple UAT cycles.
• Scripted queries and joins used SQL Server Constraint Primary Key, Foreign Key.
• Gathered customer requirements from Business Analyst and understand the data from different source systems.
• Constructed various graphs such as Straight table, Bar graphs, Pie charts, Line charts Gauge charts.
• Involved in full project life cycle implementation (requirement gathering to production) QlikSense dashboards.
• Responsible for Self-Business analysis tool Qlik Sense initial setup and end to end development of Qlik Sense applications..
• Connected to different ODBC, OLE DB data sources (SQL Server, Oracle) and flat files to create and schedule different complex reports as per given business requirement by leveraging the basic components of QlikSense.
• Performed testing of dashboards for functionality, data, performance, look and feel.

Junior Research Fellow

Confidential

Responsibilities:

• Developed and conducted programs for analytics user groups and administrators.
• Worked as a technical consultant for reporting tools and was a part of the implementation life cycle.
• Worked as business intelligence analyst on various research projects.
• Shared confidential records and research materials in a secure way for grant providers during reviews.
• Trained junior research students on data Tableau for data analytics.
• Created workflows using Alteryx on research data for pre-processing and creating feed files for tableau.
• Drafted equipment, lab and inventory maintenance protocols for fellow research associates and interns
• Collaborated with principal investigators in selecting and scheduling lab experiments
• Organized lab tours for school students and mentored interns
• Crunched numbers from lab results and prepared charts for further analysis
• Prepared research proposal drafts with senior research scientists in order to secure grant
• Documented lab results into system to keep track of historical lab results along with images
• Maintained good laboratory practices and performed other related duties as necessary

Business Intelligence Analyst

Confidential

Responsibilities:

• Implemented reporting solutions for analyzing and monitoring business performance with emphasis on interactive dashboards
• Introduced a new Business Analytics software which improved existing teams’ productivity across the data pipeline by 90%
• Coordinated with the project management team in establishing business analytics systems that ensured timely and orderly completion of reports
• Performed time over time analysis of sales and performance related data
• Performance tuning of dashboards was carried out to limit the response time to well under 10 seconds
• Collaborated with power users and IT management teams to streamline business reports and identify all end users
• Gathered customer requirements from Business Analyst and understand the data from different source systems.
• Optimized data collection procedures and generated reports on weekly, monthly and quarterly basis using Tableau
• Used advanced Microsoft Excel to create pivot table, used VLOOKUP, and other Excel functions
• Developed Tableau visualizations and dashboards using Tableau Desktop
• Developed Tableau workbooks from multiple data sources using Data Blending
• Developed Business Objects Reports on SAP Data Warehouse using BEx queries
• Designed, developed, deployed and maintained Universes for BO Reports using IDT.