Ashish Kumar Kollipara

• Created Power BI & Tableau visualization of Dashboards & Scorecards (KPI) for Finance Department

Tableau Work Experience:

• Data visualization, dashboard optimization, and transforming complex data into actionable insights.
• Expertise in working with Tableau Desktop, Tableau Server, and Tableau Prep for end-to-end reporting solutions.
  Skills.
• Expertise in creating interactive dashboards with filters, parameters, actions, and calculated fields.
• Proficient in connecting Tableau to diverse data sources like SQL, Excel, and cloud-based databases.
• Skilled in data cleaning and shaping using SQL.
• Experience in optimizing dashboard performance with efficient data modeling and best practices.
• Strong collaboration with stakeholders for gathering requirements and delivering tailored reporting solutions.
• Familiarity with SQL, Python (for advanced analytics), and cloud platforms like AWS or Azure.

Power BI Work Experience:

• Created SQL queries to pull data into power pivot model
• Worked on all types of transformations that are available in Power bi query editor
• Worked on all kind of reports such as Yearly, Quarterly, Monthly
• Integrated Custom Visuals based on business requirements using Power BI desktop
• Created SSIS packages to import data from Access, Excel, XML, OLE DB Source and Flat Files
• Filtered bad data using Derived column, Lookups, Fuzzy Lookups, Conditional split
• Good understanding on creating and using Star Schemas and Snow Flake Schema
• Designed SSIS packages to import and transform data between databases and external data sources using various transformations like Data conversion, File system task, Row counts, OLE DB Source, OLE DB Destination, OLE DB Command, Merge Join, Look up, Sort, Data flow task
• Extracted, transformed and loaded data from various heterogeneous data sources and destinations like Access, Excel, CSV, flat files using connectors, tasks and transformations provided by SSIS

SQL & PL/SQL Work Experience

• I’m part of BD & SLF Team providing service (L1) for IKEA team order solutions
• I’m the problem ticket coordinator and worked on the PRBs and resolved in time
• Strong Data base programming skills in PL/SQL on Oracle database
• Providing 24/7 Service Support
• Handling Incidents in Service Now
• Having knowledge in all facets of Software Development Life Cycle (Analysis, Design, Development, Testing and maintenance) using Agile methodology
• Good knowledge of Database Administration operations like Backup, Restore and creating schema’s and providing access to the users
• Database creation (DDL, DML, DCL), database tuning, SQL tuning, performance planning
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables
• Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required
• Good knowledge in Linux Server commands, Git & Git Hub