Business Intelligence (bi) Developer Resume
0/5 (Submit Your Rating)
Watertown, MA
SUMMARY
- A Professional team player with 5+ years of strong experience as BI developer.
- Able to communicate with all level of people face to face or over the phone.
- Flexible and can do approach to work and aim to go always extra mile for an organization.
- Technical proficiencies include Microsoft Office (Excel, Word, Access, PowerPoint, Publisher, and Outlook), Adobe Photoshop, IBM Notes, ETL package transfers, SAP, SAS, Tableau (Desktop and server), Visualization report, QuickBooks, Reuters and HRP.
- 7+years of IT experiencein Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence and Database Platforms.
- 5+ years of Experience in Tableau (Desktop, Server) as a BI Developer. End to end involvement in designing and deploying data visualizations and creating Calculations, Formatting using Tableau Desktop
- Extensive experience in working with Tableau Desktop, Mobile, Tablet, Tableau Server, Tableau Online and Tableau Reader in various versions of Tableau 9.1,9.3,10,2018.2 & 2019.
- Add/Edit Sites and corresponding administration right to the site admin.
- End to end experience in designing and deploying data visualizations using Tableau.
- Participate in Projects from requirements gathering through design, development using Alteryx and deployment in Tableau and Alteryx Server and publish online.
- Created various types of charts like Heat Maps, Geocoding, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots, Bullet Graphs and Histograms in Table Desktop, Power BI, and Excel to provide better data visualization.
- Expertise in using advance Tableau features like Calculated fields, Sets, Groups, Parameters, context filters, quick filter, global filters, Actions, etc.
- Experienced in publishing and sharing workbooks, data sources with user filter to Tableau server.
- Experienced in using SQL for Tableau and in writing parametrized queries for generating tabular reports, formatting report layout, and expressions.
- Expert in Data Visualization, Data Analysis, Business Intelligence, IT Analysis/Design, and Client/Server System Architecture.
- Expertise in designing and developing analytical reports, dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices to convey the story inside the data by integrating data from multiple sources and help users to identify critical KPIs and facilitate strategic planning in the organization.
- As a Tableau Administrator, specializing in Server Worker Nodes Installation & Configuration. Setting up Tableau Primary and Worker Nodes (drivers, patches, command line utilities, etc.) UsedSQL Queriesat the custom SQL level to pull the data in tableau desktop.
- Presented data - based improvement and operational strategies to the executive team.
- Good Communication and Interpersonal skills, self-starter and excellent Team Player.
TECHNICAL SKILLS
Programming Languages: SQL
BI Reporting Tools: Tableau Desktop V2018.2/V10.5.0/V10/V9, Tableau Server V208.2/V10/V9, Tableau Online, Tableau Public, Tableau Reader, Alteryx v2019.2.1/v2019.3.0, Power BI
Databases: MySQL, Ms SQL Server, Oracle
Other: MedHok, CCMS, IBM Note, MS Excel, Visio, Monument Xpress, Cactus, Tahp Master
Software/Tools: Office, Jira, SSRS, SSIS
PROFESSIONAL EXPERIENCE
Confidential, Watertown, MA
Business Intelligence (BI) Developer
Responsibilities:
- Design and build high-performance, reusable, and reliable Alteryx workflows and predictive models
- Participate in Projects from requirements gathering through design, development using Alteryx and deployment in Tableau and Alteryx Server and publish online.
- Design and build Tableau visualizations, dashboards, and distributions.
- Analyze output in the context of business objectives and make recommendations.
- Build predictive models, “what-if” analyses and pro forma projections to support operational and investment decisions.
- Ensure the best possible quality/efficiency of work product.
- Act as a Tableau Sever Administrator and Maintain the server access Licenses, Scheduling task, provide dashboard permissions based on different level of management team.
- Learn against other future software applications and 3rd party products to support the business and processes.
- As a tableau server administrator Create user profile, provide Dashboard permission based on level of user and schedules task for extract data refresh.
- Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
- Working extensively using Excel to validate the data and use as the source data files.
- Identify new metrics and enhance the existing KPI's.
- Implement Alteryx Burst reporting to slice and dice the Tableau Report filtered by Collector and send an email to the collector at a schedule time every day
Confidential
BI Data Analyst
Responsibilities:
- Worked with Business Analyst to understand the user requirements, layout, and look and feel of the application to be developed.
- Data blending implemented on SQL Server database and generated interactive dashboards.
- Interacting with business stakeholders to understand their decision-making parameters, analyzing the available data to build Tableau Dashboards, and managing the delivery.
- Advises supervisor with systems performance of simple to moderate complexity and recommends improvements as needed.
- Extensive experience with the design and development of Tableau Mobile, Tablet and Desktop
- Design, develop and support complex performance and capacity charts and reports using Tableau Tool.
- Worked with other Database Administrator, System Analysts, and other Developers.
- Working closely with the clients to build the BRD.
- Create/Manage Groups, Workbooks and Projects, Database Views, Data Sources and Data Connections.
- Involved in adding users and providing permissions to sites, projects, and data source.
- Change the data source, validate the data, and modify the dashboard.
- Designs, implements, and maintains Dashboard.
- Develops business intelligence (BI) processes, data, interfaces, and interactivity to provide key performance indicators, dashboards, analytics, and decision support software. Analyzes user needs and reviews system specifications for circumstances requiring routine skill.
- Designs, builds and modifies specifications as required to meet changing business requirements.
- Tested dashboards to ensure the data, views and performance of the dashboard and created Test case & data mapping documents.
- Responsible for writing reports to support the launch and monitoring of strategic initiatives. This includes:
- Develop and maintain timely and accurate reports utilizing facilities Madhok, CCMS, Excel, Access, Tableau, Alteryx, SAS and SQL, and other report writing tools available.
Confidential, New York, NY
BI Developer
Responsibilities:
- Maintenance of databases objects, combining data from different sources for unified view.
- Develop databases that separates analysis workload from transaction workloads.
- Build packages for ETL for data organization for simplifies access for predefined and ad hoc queries.
- Examine data patterns to predict future trends for decision support.
- Contribute towards the Metadata repositories that possess business metadata, operational metadata, cleaning and purging data.
- Contribute towards identifying measures and dimensions for easy slicing and dicing of appropriate data.
- Create Data Marts with precise data for addressing specific user/ business requirements.
- Develop ETL Packages in SSIS for integrating data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data).
- Contribute towards developing dimensional modeling schemas and cubes.
- Utilize SSIS for defining workflows, retrieving data, performing transformations and for loading data.
- Utilize Report Builder for ad-hoc reporting against SSAS database.
- Generate reports utilizing Power BI for visualizing data sets and share across the users.