TECHNICAL SKILLS:

Databases: MS SQL Server, Netezza, Oracle, MS Access, MySQL, SAS, Hyperion (Oracle).

Data Warehousing: Oracle 10g/9i, Netezza

DB Utilities: Aginity Netezza, PATS, CATS, Workbench, TOAD, MyPHP Admin, SSMS

Operating Systems: UNIX. Programming Languages SQL, PL/SQL, HTML

Technologies: Tableau, BMC Remedy, Subversion, Active Directory, Excel, SharePoint, Clarity, MS Project

Environment: Windows, UNIX, LINUX, Mainframe, Subversion

WORK EXPERIENCE:

Tableau Developer/ Project Manager III

Confidential

• Responsible for the development, production, and ongoing support of the Global Distribution & Omni - Channel Strategy team’s reporting needs.
• Reporting and analyzing global and regional omni-channel performance, SkyMiles & product penetration, Delta Gift Card sales, and other ad-hoc reporting.
• Convert large amounts of data into compelling data visualization dashboards and to automate this process on ongoing basis using Tableau, SAS and Hyperion (Oracle).
• Provide analytical support and data that will help identify opportunities for increasing revenue, reduce costs, shift channel share and improve business processes
• Identify opportunities to improve processes and focus on providing solutions and delivering results
• Analyze and troubleshoot reports, ensure data accuracy and timeliness, and provide interpretation and analysis of data for business management at regular intervals to guide strategic and tactical business decisions
• Apply a good understanding of underlying data, data structure, KPIs and the business uses of the data when producing ad hoc reports
• Produce weekly, monthly, and quarterly recurring Tableau dashboards which fulfil basic information requests, also help monitor trends and measure KPIs.
• Develop analytical models to estimate the impact of different scenarios, assisting in the business decision making process for Online Travel Agency and Global Distribution Systems negotiations.
• Support annual budget process through reporting and analytical support, along with seasonal forecasting.
• Develop new and ad-hoc reports by working with stakeholders to define report requirements, track requests, and complete reports adhering to reporting requirements and deadlines.
• Creatively visualize data in a variety of formats to provide relevant and persuasive insights.

Tableau Developer

Confidential

• Creating dashboards using calculations, groups, sets, parameters, calculated fields and hierarchies.
• Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
• Experience in creating filters, quick filters, data source filters, local & global filters, context filters and user filters.
• Responsible for maintaining User and Group permissions across servers and dashboards.
• Expertise in working with different databases like MS SQL Server 2008 R2, Oracle 10g/9i/8i and tools like Aginity, Toad, SQL Navigator
• Interact professionally with diverse group of professionals in the organization including managers and executives.
• Report issues through BMC Remedy
• Worked with multi applications under BMC Remedy. Example; Change Management, Service Request Management and Incident Management.
• Write SQL statements to view database tables
• Pulling reports using PL / SQL Developer
• Creating ad hoc queries and reports in support of the business process using SQL and excel formulas.
• Via SQL provide data analysis and execute data validation from external vendors prior to import into Confidential internal systems
• Provide data research for internal and external business partners using SQL
• Publishing the developed reports to production Tableau server environment
• Other responsibilities include: Microsoft Access and database management (SQL)

Tableau Developer

Confidential

• Created dashboards by extracting data from different sources using parameters, sets, groups and calculations. Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Ability to translate complex data requirements into simple, understandable formats understood by both technical and non-technical users. • Preparing Dashboards using calculations, parameters in Tableau. • Creating calculated fields, groups, sets and hierarchies etc. • Creating data blending in case of merging two different datasets
• Built complex formulas in Tableau for various business calculations.
• Interact professionally with diverse group of professionals in the organization including managers and executives.
• Involved in creating dashboards and reports in Tableau and Maintaining server activities, user activity, and customized views on Server Analysis
• Involved in creating dashboards by extracting data from different sources.
• Involved in creating calculated fields, mapping and hierarchies.
• Administered user, user groups
• Expertise in working with different databases like Netezza, Teradata, MS SQL Server 2008 R2, Oracle 10g/9i/8i and tools like Aginity, Toad, SQL Navigator, Teradata SQL Assistant
• Report issues through BMC Remedy
• Worked with multi applications under BMC Remedy. Example; Change Management, Service Request Management and Incident Management.
• Write SQL statements to view database tables
• Pulling reports using PL / SQL Developer
• Creating ad hoc queries and reports in support of the business process using SQL and excel formulas.
• Provide data research for internal and external business partners using SQL
• Publishing the developed reports to production Tableau server environment
• Other responsibilities include: database management (SQL)

Tableau Admin/Project Coordinator

Confidential

• Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
• Created Dashboards with interactive views, trends and drill downs.
• Published Workbooks and Dashboards to the Tableau server.
• Combined visualizations into Interactive Dashboards and publish them to the web.
• Created groups and users in Tableau server
• Used commands in Tab cmd. and Tab admin utility tool and migrated Workbooks and Dashboards
• Facilitate the definition of project scope, goals and deliverables
• Communicate project deadlines and deliverables to internal resources and coordinate necessary actions to ensure project success
• Create and maintain project plan and WBS; ensure milestones are met; track and resolve issues
• Develop agendas and manage preparations for client meetings including status reports and resource availability; set.
• Used MS Project to monitor and control progress, confirming that project resources were used effectively, and resource loaded schedules were followed. Inspected services, deliverables, and content for quality assurance.
• Worked with key subject matter experts to estimate industry resources needed to achieve project goals.

Business Support III

Confidential

• Responsible for performing quarterly fee structure audits.
• Convert Confidential Legal Department Core Team Member list to Excel file and calculate member averages by Partner, Counsel, Associates and Paralegals.
• Responsible for managing AFA Inbox which includes reviewing and escalating inquiries to appropriate team members.
• Responsible for reviewing, researching, answering and escalating ocrates inquiries.
• Analyze low risk firm rate proposal by calculating financial impact.
• Assist with all rate related reports
• Analyze yearly diversity report.
• Create yearly, monthly and upon request law firms 1-Pagers summaries.
• Prepare and review Local Counsel Analysis report.