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
Reporting Tools - Tableau Desktop (10,10.1,2019.2), SSRS, Business Objects.
ETL tools - Informatica, SSIS
Databases - My SQL, MS Access, MS SQL Server, Oracle
Languages - SQL, PL/SQL
Data Modeling Tools - Power Designer, ERwin, MS Visio.
Data Architect II / Tableau Analyst01/2018 to Current Johnson & Johnson Vision Care Inc. – Jacksonville, FL
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 Neo Prism Solutions, LLC. – Schaumburg, IL
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 InfoDelf IT Solutions – Hyderabad, India
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-
Kent,
OH
Bachelor of Science: Computer Science 05/2015Jawaharlal Nehru Technological University-
Hyderabad, INDIA
