We provide IT Staff Augmentation Services!

Data Analyst And Production Support Analyst Resume

Redwood City, CA

SUMMARY

  • 4 years of experience in Tableau reporting/data analyst as providing best quality, designing, creative technology and business solution in areas of Software Services and data driven products.
  • 8 years of production support analyst experience in IT with emphasis on analytics and testing of web based, client - server and E-Commerce applications, Slaesforce and SAP.
  • Strong understanding of data lifecycle (which includes RDBMS/Data Warehouse, ETL concepts, Data Visualization concepts, Tableau Reporting)
  • Strong foundation in Tableau 2019- 11.X, and 10.X using different data connections- Salesforce, Microsoft SQLserver, My SQL,Google analytic etc.
  • Worked on the development ofDashboard reports for the Key Performance Indicators for the top management.
  • End-to-end experience in designing and deploying data visualizations and reports using Tableau.
  • Designed rich graphic visualizations with Tableau drill down/across, drop down menu & parameterization.
  • Knowledgeable in hierarchies, filters, calculated fields, sets, groups, and parameters.
  • Analyzed user requirements, validated available data, designed and developed on Tableau server.
  • Experienced in connecting, extracting and combining data from different sources for blended views.
  • Implemented best practices of data visualization & Tableau combination charts using visualization reports
  • Participated in design reviews and communicated with different groups.
  • Excellent communication, interpersonal, and professional collaboration skills. Fast learner.
  • Expertise as SQL Server Developer in utilizing triggers, cursors, functions and stored procedures.
  • Created Performance Dashboards, Score Cards, and Metrics, using advance charts and calculated fields
  • Created complex formulae in sub reports, designed financial report templates, using graphs and charts.
  • Experience in PL/SQL and SQL and performance tuning SQL queries in TOAD.
  • Experienced in developing customized interactive reports and dashboards from multiple data sources.
  • Self-Motivated independent analytical thinker analyst - exceled as individual contributor and team leader.
  • Managed global team of 7 across US, Canada and India. Trained and mentored new team members.

TECHNICAL SKILLS

BI Tools: Tableau, Microsoft Power BI, Cognos

Database: SQL Server, MySQL, SQL Server Developer, Oracle 12c, Oracle - SQL*Plus, PL/SQL, Oracle Forms and Reports

Applications: Enterprise apps - Salesforce, SAP Finance, Sales Distribution

Operating Systems: UNIX, Linux, MS Windows 10

Testing/Tracking Tools: GUI testing, JIRA, SOAP UI, REST UI, Selenium, BugZilla, LoadRunner

Software Development Life cycle: Agile, Waterfall

Languages: SQL, Python, Java (JDK)

PROFESSIONAL EXPERIENCE

Confidential, Redwood City, CA

Data Analyst and Production Support Analyst

  • Analyzed and resolved more than 4000 customer facing production support issues annually.
  • Produced effective, timely, well organized reports for finance, operations and customer support business groups, using Tableau and Power BI on Salesforce, SAP apps, using SQL Server and Oracle databases.
  • Expertise in Agile software development lifecycle (SCRUM), Kanban and waterfall models.
  • Led production support issues triage, analytics, automated testing and report generation.
  • Generated Tableau combination charts and maps manually using custom geo-coding and WMS servers.
  • Excellent understanding of Software Dev Life Cycle (SDLC), Software Testing Life Cycle and Testing Methodologies including test strategy, test plan, and test case creation, test execution and bug tracking.
  • Tested large-scale enterprise apps, systems, databases, and technical products and services.
  • Excellent in understanding business needs and converting them into technical solutions.
  • Performed migrations from development to production, upgrades, installations, and configurations.
  • Worked with development teams to coordinate bug fixes and application roll outs.
  • Studied workflows to identify problems and make recommendations for resolution.
  • Worked with business analysts and clients to determine requirements and business user needs.
  • Developed project plans and managed implementation of solutions for department and business units.
  • Evaluated, diagnosed and solved complex software and hardware issues for over 300 end users.
  • Carried out API and web services testing using Soap UI, & backend testing of Oracle, MySQL & MSSQL.
  • Used Firebug and IE developer to look into the code for debugging and automation.
  • Carried out integration testing during Confidential and Confidential merger integration and consolidation of apps.
  • Managed testing with offshore teams from Confidential and companies that were bought by Confidential .
  • Provided excellent, dependable, and delightful analyst services for internal and external customers.
  • Improved customer service by redesigned and developing new business processes in analytics and BI.
  • Communicated with business leaders, engineering, product managers, marketing, sales, and customers.
  • Examples of types of interactive Tableau dashboards, stories, and worksheets, designed and created:
  • Dealers Car Sold: sales by products, stores, regions; unique sellers & buyers by channel, & salesperson

Confidential, Menlo Park, CA

Customer Support Test Engineer/Software Test Engineer

Responsibilities:

  • Responsible for automated and manual testing of software applications. Designed and developed test strategies, test cases and carried out web-apps functional, module, system, and regression testing.
  • Used WinRunner to carry out front-end verification test & back-end database manual/automated testing.
  • Designed and created reports using SQL, PL/SQL in Windows and Linux, UNIX.
  • Tested applications using Mercury’s Quick Test Pro (QTP) in Windows.

Confidential, San Francisco, CA

Software Test Engineer

Responsibilities:

  • Responsible for functional, module, system, and regression testing of web apps and non-web apps.
  • Developed test plan and test strategy for manual and automated testing of web-based apps.
  • Used WinRunner for front-end verification test and back-end database manual and automated testing.
  • Designed web based user interfaces using HTML, JavaScript, and HTTP.

Confidential, San Jose, CA

Responsibilities:

  • Responsible for testing, operation, admin, and maintenance of software apps on both UNIX and Windows.
  • Designed web based user interfaces using HTML, DHTML, JavaScript, and HTTP.
  • Tracked bugs and generated reports for web and client and server applications.
  • Executed test cases for user acceptance testing and conducted performance testing.
  • Carried out Black Box, White Box, Unit, Regression, Stress, Integration, and System Testing of apps.
  • Carried out functionality, and performance testing of GUI, and product provisioning apps.
  • Performed complete system tests using a multitude of events and various use cases.

Confidential, Naperville, IL

Responsibilities:

  • Responsible for all types of QA and testing of database apps through complete software product life cycles.
  • Worked on relational Oracle and Sybase databases, used embedded SQL in C in the UNIX environment.
  • Carried out data modeling, database design, created tables, created index, and put triggers.
  • Carried out database normalization, query optimization. Designed and created reports, and views.
  • Mapped input data into base relations. Reverse mapped to retrofit application.
  • Carried out conformance, interoperability, performance, and regression testing both manual & automated.
  • Created test procedures, test scripts, test cases and supported complete automation of the test process.
  • Handled International help desk - resolved field and help desk inquires. Mentored new hires.

Hire Now