SQL Server BI Developer Resume Birmingham, AL - Hire IT People (2024)

SUMMARY

• Senior Tableau Developer with 7+ years of extensive IT experience in Software Development, Integration, Implementation and Maintenance of Business Intelligence applications and the related Database Platforms.
• Extensive experience inTableau Desktop, Server, Reader, Public and Mobile in various versions of Tableau 6, Tableau 7 and Tableau 8.1/8.2 and Tableau 9.
• 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.
• Experience in creating dashboards with relational and multi-dimensional databases including SQL, MS Access at gathering and manipulating data from various sources.
• Strong understanding of project life cycle, SDLC methodologies including RUP, RAD, Waterfall and Agile.
• In-depth knowledge of creating use cases, functional design specifications, activity diagrams, logical, component and deployment views to extract business process flow.
• Expertise in Tracking, Documenting, Capturing, Managing and Communicating the requirements using Requirement Traceability Matrix (RTM)which helped in controlling numerous artifacts produced by the teams across the deliverables for a project.
• Excellent analytical, problem solving and Tableau and SQL debugging skills.
• Organized Joint Requirement Planning sessions,Interviews and Requirement Elicitation sessions with end-users,clients, Subject Matter Experts and the technology group.
• In depth understanding of the As-Is and To-Be (Gap Analysis) business processes and experience in converting these requirements into Technical Specifications for preparing Test Plans.
• Experience in designing the data conversion strategy, development of data mappings and the design of Extraction, Transformation and Load (ETL) routines for migrating data from non-relational or source relational to target relational.
• Experience in using various MS office tools for analyzing, arranging and presenting data.
• Excellent command in writing complex routines for Data Validations, Data Extraction, transformation and loading to target decision support systems using MS Excel on various environments.
• Proven skills in Data Cleansing, Data Archival, Data Migration, ad-hoc reporting and coding utilizing SAS on Windows
• Proficient in design and development of various dashboards, reports utilizing TableauVisualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to the end user requirement.
• Good working knowledge of Meta-data management in consolidating metadata from disparate tools and sources including Data warehouse, ETL, Relational Databases and third-party metadata into a single repository to get information on data usage and end-to-end change impact analysis.
• Expertise in designing and creating various analytical reports and Automated Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Experience in creating and implementing interactive charts, graphs, and other user interface elements.

TECHNICAL SKILLS

Specialties: Data Visualization, Business Intelligence (BI), Software Management, Data Collection.

BI Tools: Tableau 6.0/7.0/8.1/8.2/9, Tableau Desktop, Tableau Server, Cognos, Crystal Reports, Qlikview

Relational Databases: MS SQL Server 2005/2008/2012/2014, Oracle 7/8/8i/9i/10g/11g/12c, MS Access.

Tools: and Packages: SQL Server Management studio, Toad, Microsoft Visual Studio

Languages: SQL, PL/SQL, HTML, XML

Office suite: MS PowerPoint, MS Excel, MS Word, MS Visio, Star Office, Open Office

Operating Systems: Windows 2000/2003,2008 Server, Windows 95/98/2000/XP/7/8

PROFESSIONAL EXPERIENCE

Sr. Tableau Report Developer

Confidential, Birmingham, AL

Responsibilities:

• Involved in translating the business questions and business requirements to actual and final dashboard technical requirements
• Used Tableaufor the data / business predictive analysis, for trending, for finding the pattern of data over the period of time
• Building the customized and interactive dashboards using multiple data sources
• Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created worksheets and dashboards by using custom queries and multiple tables.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Effectively used data blending feature in tableau.
• Defined best practices for Tableau report development.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Executed and tested required queries and reports before publishing.
• Developing Standard and Create reports using Tableau Desktop.
• Developing Attributes, Facts, Metrics, Filters, Prompts and Hierarchies as per Specifications for developing reports.
• Creating DB views for the reporting purpose.
• Preparing Report Mapping Documents as per Specifications.
• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
• Analyzed requirements for various reports, dashboards, scorecards and created proof of concept / prototype the same using Tableau desktop.
• Mentored business power users to create reports/dashboards using tableau desktop.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems.
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Created Prompts, customized Calculations, Conditions and Filter (Local, Global), Parameters, Groups and sets for various analytical reports and dashboards.

Environment: BI Applications, Tableau 8.1/8.2/9.0, Windows 7, SQL Server 2012, Oracle 11g/12c, Excel, MS Access.

Senior Tableau Developer

Confidential, Austin, TX

Responsibilities:

• Developed various dashboards illustrating data visualizations using Tableau Desktop
• Proven experience in installation and maintenance of Tableau Server and administering users, user groups, projects and scheduling instances for dashboards in Tableau.
• Defined best practices for Tableau report development.
• Involved in creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Developed Dashboards using calculated fields, parameters, sets and actions in Tableau.
• Created drill through reports in dashboard.
• Involved in creating data blending in case of merging different data sources.
• Involved in creating a dual-axis bar charts with multiple measures, box plots, heat maps and background maps, trend lines statistics.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Worked on Datazen and had a good knowledge in creating the dashboard which best suites the requirement.
• Understanding of relational database structures, theories, principles, and practices.
• Monitored Application Server and Tableau Data server activity to track performance and system availability
• The ability to interact professionally with a diverse group, including executives, managers, and LOB.
• Working on creating various dashboards in Tableau Desktop by querying various ODBC connections such as Teradata, Oracle SQL Developer, SQL Server 2008.
• Found ways to make graphs and tables visually exciting, and aesthetically pleasing, while at the same time maintaining the accuracy of the core information content that is being communicated
• Involved in license management SLA's with Tableau support.
• Developed proof of concept for best practices in Tableau development & deployment, and ad-hoc reporting.

Environment: Tableau Desktop 8.0/8.1, Tableau server, Oracle SQL developer, SQL Server 2008/2012, Oracle 10g/11g, PL/SQL, T-SQL, MS Access, Windows 2007 server, Teradata, MS Office 2007

Tableau Developer

Confidential, Princeton, NJ

Responsibilities:

• Liaison for project managers, managers, directors, and stakeholders.
• Requirements gathering and analysis including data analysis, gap analysis (AS-IS to TO-BE), and documentation for end users.
• Conducted gap analysis for re-engineering, and upgrading the current system where ever necessary.
• Developed, derived and clarified functional specifications and Use cases.
• Analysis of Business requirements and site specifications to create Business Requirement Document (BRD) and Design Document (Functional and Technical).
• Eliciting and translating business and/or technical needs in to relevant documentation for assigned initiatives/projects.
• Designed the conceptual and business process models.
• Implementation of new systems including the integration of the new system with existing systems.
• Verifying installed systems to ensure that they adequately meet user requirements.
• Physical design of data record data files and databases.
• Developed mappings and workflows in Informatica to extract data files used as source for various Tableau reports.
• Involved in modifying Teradata stored procedures and performance tuning of various Teradata/Oracle tables, Informatica mappings to improve the performance of Tableau reports/Dashboards.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Involved in writing Test Cases, procedures, reports and approval of software release.
• Monitoring the project during Development phase and involved in User acceptance testing (UAT) once the change requests are released from system testing.
• Designed and Developed Complex Active reports and Dashboards with different data visualizations using Tableau desktop on customer data.
• Developed Technical requirements, design requirements and user acceptance documentation by placing Screen shots of actual Report and tested report in documentation.
• Deployment of defect free code while managing the timeline set for the project.

Environment: Tableau 7.0/8.0, Teradata, Oracle 11g, SQL Server 2008, TOAD, PLSQL Developer, SQL Developer, SAS, Informatica, MS VISIO, Microsoft (Word, Access, Excel, Outlook)

SQL Server BI Developer

Confidential

Responsibilities:

• Developed the project using agile methodologies in the team and take initiative to break down requirements.
• Developed packages in SSIS platform by using various tasks and transformations and configuring as per requirements.
• Involved in requirement gathering and analysis of source systems, database architecture of the HSN database
• Managing periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
• Created databases and database objects like tables, stored procedures, views, triggers, rules, defaults, user defined data types and functions.
• Created design of initial package, keeping in view and implementing appropriate SSIS controls.
• Created drill-through reports, parameterized reports and linked reports using SSRS 2005
• Generated reports in the form of tabular, matrix and chart forms.
• Rendered the reports in the form PDF, Excel, .CSV and XML formats

Environment: SQL Server 2008/2005 Enterprise Edition, SQL Server Data Tools, SQL Server BI (SSIS, SSRS, SSAS), TSQL, TFS, XML and Windows Server 2003

SQL Server BI Developer

Confidential

Responsibilities:

• Team member of the BI module and involved in analysis of business requirements template, decomposition matrix, dimensionality modelling and ETL strategy.
• Utilizing the Kimball- Star/Snowflake schemas and slowly changing dimensions.
• Worked on Microsoft SQL Server 2005 Tools-SQL Server Integration services (SSIS), SQL Server analysis services (SSAS) and SQL Server reporting services (SSRS).
• Responsible for extracting the data from different source feeds like Flat file, XML, OLE DB, and Excel.
• Created packages by using sources, destinations and transformations using SSIS designer.
• Connected to different types of sources to extract data and destinations to load data using Connection manager.
• Defined the data Sources, data Source views, dimensions, cubes within the Business Intelligence Development Studio (BIDS) using SSAS.
• Administration and development of data warehouse\data marts and OLAP cubes
• Used Business Intelligence Development Studio, Management Studio for developing SSIS, SSAS, and SSRS.
• Involved in the creation of SSRS reports using with\without wizards.
• Performed parameterized reports, reports bursting, and scorecards.
• Involved in performing drill down the data, calculations, sort the data, add groups, subtotals, and colour code the business data exceptions.
• Troubleshooting ETL, OLAP analysis and reporting process failures.

Environment: MS SQL Server 2008/2005, MySQL, Lotus Notes, MS Access, MS Office Suite (Word, PowerPoint, Excel).