Romita Sahoo
Peoria
Summary
12+ Years of experience in IT across all phases of SDLC/Agile in Banking and Financial Services, with the ability to assist and guide cross-functional teams. Experienced in requirement gathering/analysis, design, development, testing, and production rollover of reporting and analysis projects. Strong understanding of Data Visualization using tableau and Power BI. Strong Dashboard design experience and passionate practitioner of effective data visualization. Familiarity with best practices around visualization and design. Reports scheduling using Tableau Server. Good knowledge of ETL using Dremio. Good Knowledge of SQL and stored procedures. Strong Dashboard design experience and passionate practitioner of effective data visualization. Familiarity with best practices around visualization and design. Excellent competence in monitoring the progress of deliverables, identifying major project issues, and driving efficiency; analyzing strategic roadmaps to identify opportunities and risks and ensure business needs, release and support business processes for organizational change and governance. Prodigious 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.
Overview
17
17
years of professional experience
1
1
Certification
Work History
Sr BI Developer
USAA
07.2021 - Current
- Create workbooks, Dashboards, and Stories using Tableau Desktop Schedule and Publish reports using Tableau Server
- Use varied datasources like Snowflake, SQL Server, Oracle, DB2, Netezza, Salesforce.
Sr BI Developer
Upgrade Inc.
03.2020 - 06.2021
- Create workbooks, Dashboards, and Stories using Tableau Desktop and Lin Pack for Operations Department
- Schedule and Publish reports using Tableau Server
- Using GIT, AIrflow for version control and workflow management Work extensively on data warehousing concepts, visual and best practices
- Use concepts like Filters, Parameters, LODs, Sorting, Dual Axis, blended axis, Heat Maps, Sets, Groups, Forecasting, etc in Tableau.
Data Visualization Developer
Upworks
01.2017 - 01.2020
- Created Scorecards, Dashboards, and Stories using visual best practices using Tableau and Power BI
- Published Charts using Tableau Online
- Created Animations, Groups, and Sets
- Worked extensively on Level of Details, Blended Axis, and Dual Axis
- An active member of Phoenix Tableau User Group.
Data Analyst/Tableau Developer
American Express
11.2013 - 06.2016
- Created Tableau Scorecards, Dashboards, and Stories using visual best practices
- Involved in trouble-shooting of performance issues that were associated with Tableau reports
- Developed Tableau data visualization using Bar Graphs, Trend Lines, Heat maps, Scatter Plots, Geographic maps, Pie Charts, etc
- Worked with dynamic as well as static data in Tableau
- Worked on integrating Tableau with R
- Published Reports, Extracts on Tableau Server
- Scheduled workbooks and Extracts on Tableau Server
- Distributed Tableau reports using techniques like Packaged Workbooks
- Good at understanding the client requirements and giving the best solutions
- Build credibility, establish rapport, and maintain communication with stakeholders at multiple levels, including those external to the organization
- Tracked and reported status and other metrics against goals on an ongoing basis.
Data Analyst/Database Developer
Capital One
05.2011 - 11.2013
- Extracted data from Oracle and various flat files and loaded them into Oracle back using SQL loader
- Interpreted data, analyzed results using different techniques
- Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy
- Backup and recovery of tablespaces
- Responsible for creating Databases, Tables, Unique/Check Constraints Views, Stored Procedures, and Triggers in Oracle
- Employed Filtered Indexes to improve query performance and reduce the storage and maintenance cost
- Interacted with Business Analysts and Developers in identifying the requirements and designing and implementing the Database Schema
Database Developer
Infosys Technologies Ltd.
05.2007 - 05.2011
- Understanding the Business requirements based on Functional specification to design the ETL methodology
- Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) process using Informatica and SQL loader
- Experienced in integrating heterogeneous data sources like Oracle, DB2, and Flat Files into Staging Area
- Maintained source and target mappings, transformation logic, and processes to reflect the changing business environment over time
- Worked on the proposed database design, development, and creation of all file system layouts, database environments, and referential integrity relationships/constraints
- Created and maintained oracle databases and modified the schemas using TOAD
- Involved in Data migration, Data Conversions, Backup, and Recovery of DB2 tablespace in COBOL.
Education
Bachelors of Engineering - Electronics and Communication
National Institute of Science and Technology
01.2007
Skills
- Database: Snowflake, SQl Server, Db2, Oracle, Amazon Redshift Netezza, Hadoop/Hive
- ETL Tools: Dremio , Informatica
- BI Tools: Tableau, Microsoft Power BI
- Scripting: Python, Unix
- Programming Language: Python, Cobol
- Banking/Credit Card/ Omni Channel
Certification
- Oracle: OCA/DBA 9i Certified.
- Tableau: Tableau Desktop Qualified Associate.(Pvt)
- Scrum: Certified Scrum Master (CSM)
- Certified Product Owner(CSPO)
Tools Knowledge
- Toad, SQL Developer, SQL
- Loader, Alteryx, Tableau 9.x/10.x/2018/2019,2020.3, Power BI, Clarity, Rally/Version One
Personal Information
Title: Tableau Developer
Timeline
Sr BI Developer
USAA
07.2021 - Current
Sr BI Developer
Upgrade Inc.
03.2020 - 06.2021
Data Visualization Developer
Upworks
01.2017 - 01.2020
Data Analyst/Tableau Developer
American Express
11.2013 - 06.2016
Data Analyst/Database Developer
Capital One
05.2011 - 11.2013
Database Developer
Infosys Technologies Ltd.
05.2007 - 05.2011
Bachelors of Engineering - Electronics and Communication
National Institute of Science and Technology
Similar Profiles
Jeremy FalknerJeremy Falkner
Associate Auto Adjuster at USAAAssociate Auto Adjuster at USAA
Marcy CastilloMarcy Castillo
Claims Adjuster - Fire, Theft & Vandalism at USAAClaims Adjuster - Fire, Theft & Vandalism at USAA
Jordan HoffmannJordan Hoffmann
Insurance Professional at USAAInsurance Professional at USAA
Chris BiegeChris Biege
Sales and Service Representative at USAASales and Service Representative at USAA
Julian WrenJulian Wren
Warehouse Worker at AmazonWarehouse Worker at Amazon