Tableau Developer Business Analyst,snow flake,SSIS,SQL
Resume:
Navya Bolla
**********@*****.***
PROFESSIONAL SUMMARY
Over 5 years of IT experience in the Design, Analysis, Development, Implementation of
Data Warehousing applications and reporting for Financial & Asset Management.
Experience all phases of software development life cycle (SDLC) and agile methodologies.
Migrated adhoc reports to Tableau for ease of visualization.
Developed parameterized reports, drill down, drill through reports, sub reports as per the report specifications and functionality
Good knowledge in Tableau Advance Analysis features like Actions, Calculations, forecasting,
Parameters, trend lines and LOD's.
Used different Tableau functions like filter actions, parameters, table calculations.
Used Tableau joins, blending & cross Join features for different data sources.
Used clustering in tableau to classify the data.
Built a custom dashboard according to the user requirements using except all values in action filters.
Developed custom visualizations using user parameters to see the forecast trending.
Strong understanding of business processes with excellent writing and documentation skills for the management and development.
Strong Knowledge about Dimensional Modeling.
Experience with Snowflake Virtual Warehouses & In-depth knowledge of Snowflake Database, Schema and Table structures.
Good knowledge of SQL.
Strong in Data warehousing concepts and using Star Schema and Snowflakes methodologies.
Have knowledge on SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
Responsible for interacting with Business Analysts, BI Architects, Data Analysts, and business partners to identify information if business requirements are being met with the solutions being developed for reporting purposes.
TECHNICAL SKILLS
Reporting Tools: Tableau 2019.2 & 10.5
Relational Databases: SQL Server, DB2 & Oracle.
Cloud Technologies: Snowflake Database.
ETL Tools: SQL Server Integration Services (SSIS).
Other Tools: Power Apps, Power Automate, SharePoint, Microsoft Office 2003/2007/2010 and 2013, Excel.
Programming languages: SQL
Data Modeling: Physical and Logical Data Modeling
Data Warehousing & BI: Star Schema, Snowflake schema, Facts and Dimensions tables
Operating Systems: Windows XP/Vista/7/8 and 10; Windows 2003/2008R2/2012 Servers.
EDUCATION
M.Tech (Digital electronics & communications).
Postgrad in 2011.
PROFESSIONAL EXPERIENCE
Augmentar Inc, VA
Tableau Developer, Jun 2021– till now
Facility Management.
Facility Management Project is mainly the maintenance of the Organizations, buildings, and equipment’s. It gives the facility services such as building maintenance, building administration to our clients. In this project Created a dashboard which gives insights about Work orders based on the Volume analysis, Service providers performance, Invoice Awaiting Approvals, Employee Experience. Considering all Facility Management KPIs like Reactive Work orders, Emergency Work orders, Customer Satisfaction and Scheduled Work orders businesses need to complete all the Work orders on time to achieve ongoing growth.
Responsibilities:
Requirements Gathering and preparation of Technical Specifications, Test Cases and Design documents.
Participated in weekly status meetings and conducting internal and external reviews as well as formal walkthroughs among various teams and documenting the proceedings.
Developed parameterized reports, sub reports as per the report specifications and functionality.
Used different types of LOD functions, sets and groups.
Created dashboards using donut charts, Tree Maps, Dual axis Charts, filled maps, tables.
Created Work Orders Volume by Month, Volume by Specialty and Volume by Priority using Bar Graphs.
Created Custom KPIs for different Work Orders.
Environment
DBT (Data Build Tool), Snowflake, Tableau Desktop & Control M Schedular.
Augmentar Inc, Feb 2020– May 2021
Portfolio Project,
Tableau Developer.
The goal of the Portfolio Project Dashboard is to provide financial investments information (Occupancy and Lease Administration) Using map of properties and types of properties. Portfolio has the KPIs like Property Count, Area, Annual cost, Head Count, Seat Count. By Using occupancy and lease administration we can find occupancy by dimension, Occupancy efficiency, Lease events, Lease Financials, occupancy trend.
Responsibilities:
1.Working with business analyst to understand the requirements.
2.Identified opportunities to improve and innovate reporting and data for fast and dashboards performance.
3.Developed parameterized reports, sub reports as per the report specifications and functionality.
4.Used filled maps to create map of properties.
5.Created work orders for last 12 months Using LODs.
6.Created Occupancy by dimension by Using Bar graphs.
7.Used Different LODs in order find the Occupancy efficiency.
8.Used a variety of data sources including SQL Server, Oracle, etc. to fulfil client requirements.
Environment
Tableau, Windows XP, SQL developer.
Augmentar Inc, Feb 2019– Jan 2020
Lease Administration,
Tableau Developer.
The Lease administration Dashboard is to provide Number of properties are in lease, finding lease financials by knowing Annual lease cost (Gross) also finding the lease Expiration Details. Lease Financials include main lease, sub lease and lease expiration. Lease Administration has the KPIs like Property Count, Area, Annual cost, Head Count, Seat Count.
Responsibilities:
Working with business analyst to understand the requirements.
Identified opportunities to improve and innovate reporting and data for fast and dashboards performance.
Created Lease Events by Using Bar graphs. Created bins for the lease events.
Created Lease Financials using Bar graphs so that we can find Main lease and Sub lease activities.
Created Actuals and Secured Revenue Adjusted Pipeline as a stacked bar by month.
Used custom date in LODs to find the reactive cases.
Used Different LODs in order find the lease expirations.
Used a variety of data sources including SQL Server, Oracle, etc. to fulfill client requirements
Environment
Snowflake, Tableau, Control M Schedular.
Augmentar Inc, Feb 2018 – Jan 2019
Occupancy Project,
Tableau Developer.
The goal of the Occupancy Project Dashboard is to provide Occupancy Efficiency of the Properties. Occupancy which enables business to view Occupancy Trend, Occupancy by Dimension, and occupancy by efficiency. Occupancy has the KPIs like Property Count, Area, Annual cost, Head Count, Seat Count. By Using occupancy list, we can find top properties and find occupancy by dimension.
Responsibilities:
1.Working with business analyst to understand the requirements.
2.Identified opportunities to improve and innovate reporting and data for fast and dashboards performance.
3.Developed parameterized reports, sub reports as per the report specifications and functionality.
4.Used sets to find the top properties.
5.Created Occupancy by dimension by Using Bar graphs.
6.Used Different LODs in order find the Occupancy efficiency.
7.Used a variety of data sources including SQL Server, Oracle, etc. to fulfill client requirements.
Environment
Tableau, Windows XP, SQL developer.
Augmentar Inc, March 2012 – Feb 2014
Business/Data Analyst·
Performed requirement analysis by documenting the requirements and any supporting documentation like
workflow or design diagrams.
Assisted Business Analysts in the gathering of requirements specific to support complex technology initiatives.
Worked with other internal teams to ensure consistency, completeness, accuracy, and integrity in data
Documented system and data flow diagrams to support the design of software Defined multiple
projects requirements by identifying project milestones, phases, and elements.
Contact this candidate