Data Architect II / Tableau Analyst Resume Example
Love this resume?Build Your Own Now
DATA ARCHITECT II / TABLEAU ANALYST
Professional Summary
- Around 5 years of experience in gathering Business Requirements, Analysis, Design, Development, Testing and Implementation of Data Warehouse and Business Intelligence applications.
- 3 years of experience in Tableau 10/9.x/8.x/7.x in developing Performance Dashboards, Score cards, metrics, What if analysis, Prompts, Drills and Reports/Dashboards for all the functional areas including Finance/Business and Health care domains.
- Strong Business Analysis experience on Data Analysis, Business Requirement Documents, Data Migration Documents, User Requirement Gathering, User Requirement Analysis, Gap Analysis, Data Cleansing, Data Transformations & Impact Analysis.
- Expertise in data cleansing for analysis, perform data quality testing for gaps, and liaising with data origination teams.
- Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
- Extensive experience in creating rich visualizations in dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
- Experience in designing techniques like Snowflake schemas, Star schema, fact and dimension tables, logical and physical modeling.
- Expertise in the concepts of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact and Dimensional Tables.
- Expertise in Performance tuning and improved Reports performance in Tableau using extracts and context filters and custom SQL.
- Expertise in generating reports using SQL Server Reporting Services, Business Objects, Crystal Reports and MS Excel spreadsheets.
- Proficiency in creating different types of reports such as Cross-Tab, Drill-down, Top N, OLAP and Sub reports, and formatting them using SSRS.
- Extensive knowledge and Experience in dealing with RDBMS including Normalization, Web forms, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors.
- Results oriented, self-starter looking for challenges, ability to rapidly learn and apply new technologies.
- Strong ability to understand and analyze the client requirements with Excellent Communication, Analytical and Problem-solving skills.
Skills
|
|
Professional Experience
Data Architect II / Tableau Analyst01/2018 to Current
Company Name – City, State
Company Name – City, State
- Research, plan, recommend and implement dashboards and data visualization in Tableau to meet the organization's business requirements.
- Build and publish customized interactive Tableau reports and dashboards along with data refresh scheduling using Tableau Desktop and Tableau Server.
- Create Tableau Scorecards, Dashboards using stack bars, bar graphs, scattered plots, geographical maps, line/pie graphs and Gantt charts.
- Perform detailed data analysis; determine the structure, content, and quality of the data through examination of source systems and data samples.
- Effectively utilizes features and Best Practices of Tableau and visual analytics to maximize impact and utility of visualization products.
- Provide one-time load mapping details to map the JDA Brand tagging and TM1 SKU brand mapping tables to fetch the JDA Demand Brand name and its corresponding info.
- Gather Monthly Data Loads from GPL Finance Partners. Perform ETL Process to maintain systems nomenclature and load the files to server through FTP Protocol by placing in JDA S& OP MBOX.
- Work with the Business users to understand the reporting structure for the Tableau Dashboards.
- Add Users to Tableau server with necessary permissions.
- Identify issues in the JDA Demand and S&OP modules (JDA Applications), related to batch process that run as per the monthly cadence and check the functionality of the systems.
- Validate and provide integration support for multiple data inputs and extractions in the JDA modules.
- Perform functional testing and validate the systems (JDA Applications) for every change in the Software design.
- Extract various datasets for the JDA modules, maintain internal database to generate tableau dashboards for those datasets.
- Maintain the Master Data Hierarchy for locations, products, and the Statistical Modelling and the Net forecast based on the business requirement.
- Implement White Space management – establishing blank demand unit in JDA S&OP application when there is no forecast planning, but the product is not launched in the markets. Assign attributes to the blank demand units to populate in JDA S&OP Application.
- Manage the Stat Or Rev Table editor which is the key for the Forecast transfer from JDA S&OP module to JDA Demand module.
- Setup User Roles and Groups based on the markets and the business role they perform in the JDA S&OP Application.
- Create new measures and layouts as per the business requirement in the JDA S&OP Application.
- Environment: Tableau Desktop 10/2019.2, Tableau Server 10, Oracle 11g, MySQL, MS SQL Server 2008, Excel, TSQL, UNIX, SQL Server 2008, HP Quality Center, SVN, Service Now, MS Office
- Collaborated with team to define business requirements for organizational processes, achieve productivity standards and adhere to accuracy standards.
- Orchestrated smooth and effective flow of [Type] data to support [Type] users in [Action].
- Synthesized current business intelligence data to produce reports and polished presentations highlighting findings and recommending changes.
- Researched and resolved issues regarding integrity of data flow into [Type] databases.
- Interfaced with cross-functional team of business analysts, developers and technical support professionals to determine comprehensive list of requirement specifications for new applications.
- Mapped process activities to identify shortfalls and identify options to rectify operational inefficiencies.
- Managed testing cycles, including test plan creation, development of scripts and co-ordination of user acceptance testing for [Type] software and applications within [Type] industry.
- Applied honed problem-solving skills to analyze and resolve issues impacting business operations and goal achievement.
- Created workflow diagrams and Gantt charts to clearly demonstrate [Type] processes and timelines.
- Restructured procedures by coordinating with [Job title] to create and execute projects.
- Assisted in planning of [Type] and [Type] software and system testing efforts.
- Implemented business and technical client training on new systems and supervised software integration on client's website.
- Tested functional compliance of company products, including [Product] and [Product].
- Documented business processes and analyzed procedures to align with changing business needs.
- Met with stakeholders to [Action], [Action] and [Action].
- Mapped current business and operational processes and offered recommendations for improvement.
- Collaborated on all stages of systems development lifecycle, from requirements gathering to production releases.
Programmer Analyst Intern04/2017 to 12/2017
Company Name – City, State
Company Name – City, State
- Analyzed large amounts of data to find patterns of fraud and anomalies.
- Implemented system enhancements to propose, design and develop solutions to fulfill requests and address problem reports.
- Provided authentication and authorizations for databases.
- Designed and implemented TSQL queries for reporting and complex solution development.
Systems Analyst02/2015 to 07/2015
Company Name – City, State
Company Name – City, State
- Worked as a Business Intelligence Analyst for improving an existing reporting system with business intelligence modules and dashboards.
- Co-ordinate with cross functional teams and conducted in-depth analyses of existing reporting systems and suggested improvements.
- Led requirements review meetings and obtained necessary approvals from all stakeholders and baseline the requirements documents.
- Conducted meetings with subject Matter Experts (SME's) on a regular basis to gather requirements and identify KPI's.
- Conducted Gap Analysis and suggested process improvements.
- Experience working with OBIEE
- Have been working in agile environment and using scrum methodologies.
- Participated in white boarding sessions, release prioritization meetings, and team retrospectives.
- Developed UAT strategy and ensured execution of test cases and resolution of defects.
- Conveyed business vision and goals associated with feature sets clearly to the development team to ensure that delivery if focused on business value.
- Created numerous processes through MS Visual Studio (SSIS, SSAS, SSRS) and MS SQL Server 2008 to developed a data warehouse project.
- Visualize KPI's in Tableau dashboard and publish to website
- Have been using MS Visual Studio for adding requirements to stories
- Created Functional Requirements document for Business Requirements.
- Status reporting - Sent weekly status reports to the client
- Responsible for ETL operations using SQL Server Integration services (SSIS) and worked with users in training and support.
- Created various Use Cases, Activity diagrams, Sequence Diagrams and other UML diagrams by using MS Visio.
- Performed GAP analysis and created related GAP analysis document to estimate the project process by seeing the status of actual and expected state.
- Developed Test approach and test plan involving all the functional requirements that are been documented.
Environments: Agile, windows(XP/7/8), MS Office Suite (Word, Power Point, Excel, Outlook), MS project, Visio, UML, SharePoint 2013, Erwin, SQL Server Services, Tableau.
Education
Master of Science: Computer And Information Sciences12/2016Kent State University-
City,
State
Bachelor of Science: Computer Science 05/2015Jawaharlal Nehru Technological University-
City
DISCLAIMER
Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.
How this resume score could be improved?
Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:
Resume Strength
- Completeness
- Formatting
- Word choice
- Measurable results
- Strong summary
Resume Overview
School Attended
- Kent State University
- Jawaharlal Nehru Technological University
Job Titles Held:
- Data Architect II / Tableau Analyst
- Programmer Analyst Intern
- Systems Analyst
Degrees
- Master of Science : Computer And Information Sciences 12/2016
Bachelor of Science : Computer Science 05/2015
