Summary
Overview
Work History
Education
Skills
Timeline
Generic

Sailaja Vutukuru

Beaverton,OR

Summary

  • Over 12 years of experience in Data Analysis, Data Modeling, ETL, Business Intelligence applications, in Banking, Healthcare and Consumer product domains.
  • Strong understanding of Software Development life cycle (SDLC) Phases such as Requirement analysis, Design, Development, Testing and Deployment of Business Intelligence and Database Platforms.
  • Prudent Business Intelligence Analyst with 12+ years of experience, providing employers with valuable and actionable data to drive profit growth. Practiced at filtering information to find and highlight vital metrics and revelatory findings.
  • Keen support business growth by leveraging intelligence assets to predict and reveal optimal business strategies.
  • Prodigious Data Analyst accomplished at processing large-scale stores of disorganized data into harmonious and accessible Business Intelligence tools.
  • Deft at providing easily understood dashboards and tools. Noted creator of media accessible to anyone from senior executives to customer service personnel.
  • Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals.

Overview

12
12
years of professional experience

Work History

Lead/Sr. BI Developer

Deloitte
01.2023 - Current
  • Working in Campaign Analytics team, creating data sources in Account 360 for Campaign Engagement and moving all the Tableau dashboards to point to the Account 360 DB
  • Creating new Visualizations by interacting with the Business Users
  • Worked in Migration project – Migrating tables and views required for Analytics team for some dashboards, from Teradata to Snowflake schema for further use in the Tableau dashboards
  • Collaborating with the Indian team and working in IST time zones to get information for Campaign related questions etc
  • Migrating PDW into GCP using GCS Buckets and SQL Server Instance
  • Scheduling through GCP
  • Working in 3rd party project - where by leading the team – getting the data from Linkedin API through Python scripts and massaging the data with respect to the business needs and identifying the joins and connecting with the cubes in Account 360 and preparing data for the Tableau dashboards.

Sr. Business Data Analyst

TD Bank
11.2021 - 01.2023
  • Lead the team in the Migration project – migrating data from Oracle and flat files to Salesforce (nCino) for Business Banking
  • Created one time collision report for 27 Regulatory reports in both Salesforce and Oracle platforms which ran before and after the migration to avoid duplicates without interrupting the regular frequency of the reports which are important to the Business
  • Created Tableau dashboards for Process Study Projects
  • Gathered nosiness requirements from the Process Study team and implemented them in the dashboards
  • Acting as a lead- gathered and clarified the doubts with the Business team and communicated with the team
  • Prepared documentation for all the dashboards that we created
  • Working in SAS Migration project – Code change and saving in the temp file and working with the Manager in testing the code
  • Documenting the Migration done and saving in the shared folder for future use
  • Working with Loans and Mortgages teams, understanding their requests, converting into technical queries, and providing them with the solutions
  • Working with Data Governance team and creating Business documents and creating files as per executive’s requests in Credit DB.

Tech Lead

Express Scripts (Healthcare Domain)
03.2020 - 11.2021
  • Prepared Dashboards using calculations, parameters in Tableau and created calculated fields, groups, sets and hierarchies
  • Integrating the databases from Snowflake schemas to Teradata database and updating the dashboards with the new Teradata Database and validating against the original data
  • Creating datasets in Teradata using DBeaver in replicating the Datasets that ae in snowflake schema
  • Created advanced level of calculations and applied complex, compound calculations to large, complex data sets
  • Created datasets in Google Analytics workspace using Big Query and used those tables/views in Tableau
  • Used Oracle, SQL server as data sources for designing Tableau Reports and Dashboards
  • Provided customer support to Tableau users and wrote Custom SQL to support business requirements
  • Translated the business needs into system requirements by communicating with the business on non-technical level and with the System Analyst on technical level
  • Created new views/tables and integrated them using Informatica into OLAP and OLTP schemas
  • Optimized queries using SQL Developer and performed extensive GAP analysis in the project as there were numerous 'As-Is' and 'To-Be' conditions
  • Used Alteryx for data analysis and data set preparation that will be used in OBIEE and Tableau dashboards
  • Created bins and groups using Alteryx for age, income, distribution etc
  • Collaborated with other Business units in Express-Scripts to develop various products under ESI using Tableau application data governance framework which will allow the business and IT teams to engage effectively for the maintenance and support of this platform
  • Implemented Tableau reporting by integrating the current OBIEE Reports into Tableau environment
  • Configured tableau Server into Linux environment
  • Reporting to the Senior Director, Created and implemented all the OBIEE dashboards that are there in NIHB Pharmacy, Dental, Vision and MSE environments into Tableau environments along with the datasets, databases etc
  • Created user security and Access Governance processes utilizing Active Directory and new Access Governance System flows
  • Maintained Oracle, and Postgres DB's.

Senior BI/Data Analyst

Walmart
12.2017 - 02.2020
  • Created complex Power BI Dashboards for Vendor Deals, Pricing Teams using Power Query and Waterfall charts
  • Used style templates for copy and pasting feature for searching more than one Item Number in the filter
  • Created Tableau dashboards for PMT, Promo Sales and Markdown Business with advanced features like Waterfall charts, Extensions for writeback facility, Synchronized scrolling, and complex Date Calculations
  • Embedded the Tableau and Power BI dashboards in REACT application
  • Designed and developed many dashboards for the Ecom department for the Online Grocery, Online Merchandise, Logistics, Transportation departments
  • Built custom tools in python for generating email templates which are powerful enough to consume large amounts of data and convey the testing results in a simpler way
  • Assisted in developing Python based API (RESTful Web Service) to track sales and perform sales analysis
  • Responsible for collecting and aggregating planning and forecast data from multiple sources, including spreadsheets and databases, for the generation of planning and forecasting presentation materials to be utilized in monthly meetings with cross-functional departments
  • Involved in end-to-end implementation and enhancements on Mobile Sales Associate App data starting from requirement gathering and dashboards development in Tableau Desktop
  • Designed, created, published, and customized interactive Grocery Pickup and Delivery reports, dashboards, and scheduled using Tableau Server by Store Mangers to all regions in Canada
  • Created detailed level summary report using Trend lines, Statistics, log axes, groups, and hierarchies
  • Developed executive dashboards for the entire Merchandise operations department with more than 150 million of data
  • Created several visualizations for the Senior VPs with the plan and forecast numbers, variances, Graphs etc
  • Created Alteryx packages getting data from different data sources like Teradata, Oracle, STEP etc
  • Extensively used Informatica client tools to extract data from different sources like flat files and Oracle
  • Involved in Tableau server upgrade with tableau Admin team involving upgrading the TNS files, data backup, Active Directory set up etc
  • Integrated Power BI dashboards from Finance into Ecom Tableau dashboards
  • Created Black Friday dashboards, which will be updated in every minute and created, centralizes, and maintains Data Dictionary and Glossary of terms in collaboration with Data Stewards
  • Part of Data Governance Team and conducted all enterprise policies, guidelines and processes for governing data and metadata across the organization and created a framework for bottom-up-driven governance that balances user empowerment and collaboration with data regulatory/privacy compliance while managing data acquisition and data stewardship with agile methodologies.

Senior Data Consultant

CIBC
01.2014 - 12.2017
  • The goal of this project is to develop and integrate reports for BI and Analytics enablement team and preparing and analyzing the data from EDH source using Tableau, create ETL mappings using Informatica for data ingestion and workflows and alerts and also integrating OBIEE and Spotfire dashboards into Tableau
  • Designed and developed various self-serve analytics for different departments under CIBC like Consumer Deposits, Digital Channels, Special Segments, Marketing and Campaign Analytics using OBIEE and Tableau
  • Created mappings and sessions to implement technical enhancements for data warehouse by extracting data from sources like Oracle and Delimited Flat files
  • Extracted raw data from an Oracle database and used SAS/Access to read it and run statistical analysis
  • Developed and modified SAS macros for data cleaning, validation, analysis, and report generation
  • Worked with SAS and Proc SQL to extract Segment demographics from a Teradata data warehouse for model testing, segmentation, scoring, and list management purposes
  • Drew flowcharts indicating the input data sets, sorting and merging techniques
  • Created Style templates to accommodate logos, charts for regions, Tables etc
  • Wrote code using SAS/base and SAS/macros to extract clean and validate data from a flat file, excel file, RDBMS, access database, and Oracle database using SAS ETL and DB load processes
  • Extensively using do loops, array, and SAS/stat to manipulate numerical data and geographic data
  • Modified several of the existing mappings based on the user requirements and maintained existing mappings, sessions, and workflows
  • Provided batch SAS programming and support for weekly production reporting
  • Converted dashboards created using Spotfire into Tableau environment
  • Experience with integration of Tableau dashboards into ASP.net MVC application
  • Experience in Tableau JavaScript API
  • Lead a team for implementation of Tableau server and created a road map for the developers.

Senior Data Analyst/Reports Developer

Bank of Nova Scotia
07.2012 - 12.2013
  • Created Pixel perfect BI reports like Average and Spot Balance Sheet, Income Statements, Consolidated statements, Trending Yield Reports both Statutory and Management Reports, etc
  • For the Finance Dept
  • Implemented left outer, right outer, and inner joins in Oracle Admin Tool
  • Modified existing BMM layer by mapping columns from Physical layer to BMM layer
  • Setup Multiuser Development Environment (MUDE) in OBIEE
  • Gathered user requirements and then transformed them into Dimensions, Attributes and Members for Budgeting, Forecasting and Planning implementations
  • Developed business rules and calculated scripts to derive complex calculations such as YTD commitment, variance, forecast, trends, and balance statements
  • Created Repository Users/ Groups and Web Groups and assigned permissions to the user groups to define security in the repository
  • Data Modeling, Design Documents, and data warehouse
  • Included the custom mappings in DAC Execution plan
  • Responsible for Installation, Configuration of OBIEE, DAC, Informatica and TOAD
  • Monitored and provided support to workflows and provide expert knowledge on all workflow designs
  • Coordinated with various teams and raise support ticket for all issues, analyze root cause and assist in efficient resolution of all production processes
  • Extensively created KPIs and KPI Watchlists to represent Business Metrics for the Power Users
  • Created different Style and sub templates for generating different reports.

Senior Data Analyst

RBC
03.2012 - 06.2012
  • Gathered Business requirements by interacting with the business users, defined subject areas for analytical data requirements and Created mockup reports and dashboards for review by the business users
  • Customized the OBIEE Repository (physical, BMM, and presentation layers) and created connection pools, imported physical tables, and defined joins in the physical layer of the repository
  • Created dimension hierarchies, aggregates, and keys in the BMM layer
  • Modified Presentation Layer to add presentation tables and columns to meet the business user needs
  • Worked on repository and session variables and added materialized views and aggregates to improve performance
  • Customized reporting with OBIEE Answers and integrated them into the Dashboards
  • Generated Reports and Dashboards by using Report features like Pivot tables, charts, and view selector
  • Created dashboards with global prompts, column selectors, navigation, and automatic drill-down
  • Performed Data Validation of data in the reports and dashboards
  • Extensively used SQL Tuning to improve performance and performed unit, integration, and system testing for all components in OBIEE
  • Test cases have been prepared and documented the results
  • Worked on evaluation of Oracle BI Enterprise Edition and its new utilities including BI Server, Answers, Delivers and Publisher and used HPQC for defect tracking and test plans etc
  • Performed production support for the project and gave training to the Business Users.

Education

Skills

  • Languages: SQL, Python, MySQL, NoSQL, T-SQL
  • Version Controls: Git/Bit Bucket
  • Cloud: GCP BQ, AWS, MS Azure
  • Automation:J Jenkins, Jira
  • Project Management: Agile, Scrum, Confluence, Jira
  • Databases: Oracle, SQL Server, DB2, Teradata, MS Access, MariaDB, JSON, XML, GCP, Snowflake
  • BI Tools: Tableau (Desktop, Server, and Prep), Power Bi, Qlik View and Qlik Sense, OBIEE, BI Publisher, Google Charts, TIBCO Spotfire
  • ETL: SSIS, SSRS, Informatica, Alteryx, ODI, GCS buckets, DBeaver
  • Performance Metrics
  • Monitoring, Testing and Automation
  • Technical Application Support
  • Google Analytics Understanding
  • Troubleshooting and Performance Assessments
  • Tracking Procedures
  • Project Management
  • Requirements Gathering and Business Intelligence Roadmap Design
  • Report Writing Skills, Data Dashboard Design and Visualization Techniques
  • Performance Metrics Analysis
  • Maintenance and Production Support
  • Data Warehousing, Database Creation and Database Management

Timeline

Lead/Sr. BI Developer

Deloitte
01.2023 - Current

Sr. Business Data Analyst

TD Bank
11.2021 - 01.2023

Tech Lead

Express Scripts (Healthcare Domain)
03.2020 - 11.2021

Senior BI/Data Analyst

Walmart
12.2017 - 02.2020

Senior Data Consultant

CIBC
01.2014 - 12.2017

Senior Data Analyst/Reports Developer

Bank of Nova Scotia
07.2012 - 12.2013

Senior Data Analyst

RBC
03.2012 - 06.2012

Similar Profiles

CREATE PROFILE
Sailaja Vutukuru