We provide IT Staff Augmentation Services!

Sql Bi Developer Resume

Richardson, TX

SUMMARY

  • Experienced Business Intelligence Developer and Quality Assurance
  • Experienced Dashboards/visualization reports creation using Tableau Desktop
  • Tableau quick/context/global filters, data trend, interactive visualizations
  • Hands on experienced with SSRS Tablix and Matrix reporting
  • Experienced with Drill down, Drill Through, multi parameterized reporting
  • Developing and executing Unit/Systems/Functional/Regression test
  • SSIS packages execution and data consolidation from multiple sources.
  • Extensive experience with Agile and Waterfall SDLC methodology
  • Experienced working with overseas team on QA and new development projects.
  • Exceptional leadership, communication, presentation, analytical and problems solving skills

TECHNICAL SKILLS

BI Tools: SQL Server Reporting Services (2012, 2016), SQL Server Integration Services (SSIS/ETL), Visual Studio, SQL Query Analyzer, SQL server Management Studio (SSMS), Tableau, Power BI

Tools: Microsoft Visual Studio (2010, 2015), Microsoft Office, Jenkins, JIRA, Agile Rally

Cisco Tools: Electronics Document Control System (EDCS), Cisco Defect and Enhancement Tracking System (CDETS), Auto Test Setup (ATS), Modena, Automation Load Runner

Operating Systems: Windows, Linux, Unix

PROFESSIONAL EXPERIENCE

Confidential - Richardson, TX

SQL BI Developer

Responsibilities:

  • Designed and developed matrix and tabular reports with drill down, drill through, parameterized reports and linked reports using SSRS to track various cisco products with multiple unified communication clients.
  • Designed reports using various filters, single value parameters, multi value parameters and cascading parameters.
  • Developed dashboards/visualization reports using Tableau
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
  • Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
  • Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields
  • Generated several ad hoc reports using SQL queries and excel data.
  • Scheduled reports delivery in various format, provided user access and managed security on reporting server.
  • Gathered functional requirements from business leaders and translated to technical requirements for design & development of new reports.
  • Involved in planning until report delivery process using Agile development methodology
  • Wrote and executed unit and acceptance test plan to ensure that report satisfied the requirements as defined in functional documents.
  • Executed SSIS packages to transfer data from various data source like OLTP and Excel and loaded into SQL Server database.
  • Created Summary Reports, sub reports and detailed reports on the product, region and customer.
  • Built and modified reports using report builders 3.0
  • Generated Daily, Weekly, and Monthly Reports as per the customer requirement using SSRS.

Confidential - Richardson, TX 

Business Intelligence Quality Assurance

Responsibilities:

  • Performed database verification testing using SQL queries on multiple tables with various table joins, sub queries, grouping and data filtering.
  • Wrote unit test specification documents to ensure newly developed report functionalities and user interface align with the requirements.
  • Verified daily data upload using SSIS for duplication, data type mismatch and compatibilities with other tables.
  • Worked with BI developer team on requirements review, assisted in reproducing issues and collected required data for defects and verified new fixes.
  • Performed database testing such as data integrity, accuracy of stored data, data type, data size, data security, and database performance across multiple IP Phone clusters.

Confidential – Richardson, TX 

Project coordinator

Responsibilities:

  • Project coordinator for Cisco outsource team to manage technical requirements, scheduling and staffing for offshore teams.
  • Traveled onsite including India, England, Serbia and Ireland as needed for ongoing issues and meetings.
  • Designed and developed documents for high level planning and execution of all test effort on Cisco and 3rd party products.
  • Managed transition of lab equipment from Cisco sites in Ireland and Serbia.
  • Liaison between Cisco unified communication team and 3rd party vendor for all test planning and new developments effort.

Confidential – Richardson, TX

Quality Assurance 

Responsibilities:

  • Supported customers, Ernst & Young, JP Morgan and FedEx during Cisco IP contact center solution deployment including test verification, upgrade planning, reproduction of field issues and verification of defect fixes.
  • Assisted in the test planning process including estimated test effort, scheduling and type of testing to conducted and resources planning.
  • Prepared test case execution reports, issues tracking report and presented weekly progress status to management team.
  • Coordinated with cross-functional teams to ensured standard protocols are followed in all test execution and status update in test tracking systems.
  • Primary engineer for critical Interoperability testing of multiple products. Verified Cisco products interop well together with new software releases and with 3rd party products.
  • Developed and executed automated load tests. Analyzed results and investigated any discrepancies.
  • Performed Cisco Call Manager (CUCM) Release Lead tasks including interfacing with project team members in other organizations, determining the testing to be performed for the release and reporting of results to the CUCM Release Project Leadership team.
  • Created a strategy to reduce lab footprint resulting in $400k in annual BU cost savings.
  • Agile Scrum team member to perform and automate feature testing. This involves using the Rally tool for tracking User Stories, Tasks and Test Cases.
  • Worked with multiple internal teams on customer issues. Analyzed customer issues and testing procedures to cover any internal testing gaps.

Hire Now