Senior BI Developer with 12+ Years BI/ETL Expertise

SACHIN BASAPPA

SR. BUSINESS INTELLIGENCE DEVELOPER

LinkedIN: linkedin.com/in/sachin-basappa/

PROFESSIONAL SUMMARY:

Over TWELVE plus years of extensive experience in IT industry which includes extensive Functional and

Technical experience in Data Analyst, Data Modeling, Data Reconciliation, Data Warehousing, Business Intelligence (BI), Operational Data Store (ODS) and OLAP, ETL product development.

Successful career working in very complex organizations, start-up companies (MNsure) (Ryder) and with minimal work direction and guidance.

Experience in transportation, investment, health management data patterns and trends.

Data migration experience for over Ten years in different environments and source systems.

Outstanding Data Analysis skills including Data Profiling, Data Mapping, Data Mining from source to target database schemas, Data Cleansing, and processing, writing data extract scripts/programming of data conversion and researching complex data problems.

Excellent vendor management in exchanging files, catalogs, visualizations, setting up meetings, carrying out cadence, investigating updates and thorough product knowledge documentation.

Experience in data warehouses and data marts for business intelligence reporting and data mining along with developing and documenting process flows for businesses.

Strong understanding of dimensional data modeling, strong SQL optimization capabilities, Metadata Management (Connections, Data Model, VizQL Model).

Expertise in analysis, design and implementation of data warehousing applications using Tableau, Teradata, SAP BW, DataStage, SQL Server, UNIX, DB2, Oracle technologies.

Hands-on experience working with modeling tools such as ERwin, Power Designer, E-R Studio and Visio.

Highly Proficient in Agile, Test Driven, Iterative, Scrum and Waterfall software development life cycle.

Actively participated and conducted in JAD sessions with business users, technical leads and with development personnel in all aspects of the SDLC. Expert in documentation of business requirements and system functional

specifications, including BRD, FRD, FSD and end to end Traceability Matrix.

Proficient in creating Tableau scorecards, Tableau dashboards using advanced Tableau functions and Calculated fields, Sets, Groups, Parameters, Actions, LOD, Ad hoc Calculations.

Experience in development of Dashboard reports for the Key Performance Indicators for the top management.

Good experience in establishing best practices for Enterprise Tableau Environment - application intake and development processes.

EDUCATION:

Post Graduate Program - Data Science and Business Analytics, University of Texas, Austin, Texas - 2022

Master of Business, University of Central Oklahoma, Oklahoma - 2015

Bachelor of Commerce, Bangalore University, INDIA – 2010

TECHNICAL SKILLS

Reporting Tools

Tableau 9+ (Desktop/Server/Mobile/Public), SAP BO, Power BI (beginner)

ETL Tools

DataStage, SSIS, Teradata

Databases

Teradata, Oracle, Oracle IAM, MS SQL Server, DB2, SAP BO

Database Tools

TOAD, Teradata SQL Assistant, Data Studio, SQL Developer

Requirements Management

Requisite Pro, Microsoft Office (Project, Excel, Word, PowerPoint, Visio)

Languages

PYTHON, SQL, PL/SQL, VBA, JAVA API, HTML, XML

Data Modeling Tools

Power Designer, ERwin, ER Studio, MS Visio, Visual Studio

Design/Version Control

UML, Rational Rose, SVN

Operating Systems

Windows Server 2003/2008, Linux, Unix (AIX, HP-UX), OS 400

PROFESSIONAL EXPERIENCE:

Florida’s Turnpike Enterprise – (FDOT), Orlando, FL February 2018 – January 2026

SR. BI DEVELOPER

Description:

Migrate data and define data integrity from various source systems for data management; Identify patterns, trends and anomalies to develop business required reports, visualizations, dashboards and end-to-end automation; Configure, implement, administer and troubleshoot Business Intelligence (BI) reporting applications; Develop complex interactive live dashboards and update based on business and stakeholders requirements; Design high level architectural diagrams of process flows and documentation; Develop solution on Key Performance Indicators (KPI) for business intelligence reports.

• Create and query complex functions, stored procedures, and triggers by using SQL, based on business rules.

• Analyze, design, and develop Transportation system management and operations (TSM&O) data and visualization.

• Define key performance measures for TSMO project, build documentation, develop dashboards and visualization

• Create end to end data dashboarding and documentation for TSM&O, COVID-19 and all Ad-hoc reports per business.

• Query functions to extract Operational, Networking and Inventory source data to validate anomalies, neutralize duplicates and create integrity, and update data sets for Key Performance Indicators (KPI) Reporting project.

• Normalize Incident Management data for Traffic Operations, document process flow and design complex dashboard for business to make decisions.

• Design and create Asset Data Management process flows, Business Requirement Document, and proof of design for Data Reconciliation and KPI Reporting project.

• Implement Tableau - Enterprise BI Reporting Tool for new projects, design high level architectural diagrams.

• using MS Visio, set up environment for users and receive approvals from Senior Traffic Engineer Managers and stakeholders

• Gather, analyze, and develop Traffic Operation Incident Management KPI for Business Intelligence Reporting

• Design dashboard, interact with customers, build automation, implement tableau desktop, web and mobile dashboards, restricting data for users, and conduct root cause analysis.

• Develop best practices and visual analytics for Business Intelligence reporting services and configure master repository and work repository.

• Configure, maintain, and update tableau server in a cloud environment. Develop, Implement, and test upgrades and changes.

• Liaise with stakeholders, systems analysts, traffic engineers and managers, network managers, and contract managers to gather data and understand requirements to provide business intelligence reports on a regular basis and maintain documentation.

Environment: MS SQL Server, MS Access, MS OneDrive, EXCEL, SharePoint, Sun Guide, Oracle 10/11g, SolarWinds, OMS, Tableau, Power BI, MS Project, BlueToad, Milestone, ArcGIS, XProtect Smart Client, Visual Studio.

TIERPOINT, SAINT LOUIS, MO Oct 2017 – January 2018

Sr. (Lead) BUSINESS DATA ANALYST

Description:

Migrate enterprise level disparate data in creation of new CMDB and accountable for cadence and setting governance, strategy, standards, and execution driving an integrated quality culture across the company. Leader and liaison between CMDB, Master data and business teams, to oversee all deliverables and activities, provide management support and develop analytical dashboard reporting, and ensure process and methodology alignment to enterprise standards.

Responsibilities:

• Leverage and develop subject matter expertise in the knowledge of the company's data environment, the ability to access data, the use of analytical tools, and the application of an effective methodology.

• Develop and implement data collection systems and other strategies that optimize statistical efficiency and data quality.

• Acquire data from primary or secondary data sources and maintain databases/data systems identify, analyze, and interpret trends or patterns in complex data sets.

• Filter and "clean" data, and review computer reports, printouts, and performance indicators to locate and correct code problems.

• Assist in the design and management data migration related to existing projects.

• Assist in the preparation of data synchronization/migration plans including mitigation risks and project milestones.

• Performed gap analysis to find the data gaps and process gaps.

• Documented ‘Plan of Design’ for the enterprise level asset data management and held KT sessions.

• Built and updated capability matrix for customer service and enhanced performance.

• Perform quality assurance review, data migration audit, reconciliation, and exception reporting for each customer.

• Assisting with end-to-end user acceptance testing and documenting results to ensure the migration of data from the source to the target is accurate.

Environment: MS SQL Server, MS Access, EXCEL, Json, SAS, Python, EDI, NetSuite, SSIS, ServiceNow, Oracle IAM, IBM Infosphere, Compass, EM7, NetSuite, Agiloft, Project Insight.

DRC, Maple Grove, MN September 2016 – October 2017

Sr. (Lead) DATA ANALYST

Description:

Migrate the production data in QA platform and investigate ongoing test setup and strings and be accountable for SQA strategy, standards, execution, and governance driving a quality culture across the company. Acted as a liaison between various teams, to oversee all testing deliverables and activities, provide test reporting and metrics, and ensure process and methodology alignment to enterprise test standards.

Responsibilities:

• Performed analysis of complex business process/user stories and executed functional and data integrity test cases.

• Utilized technical and functional knowledge of applications and enterprise standards to evaluate and resolve complex testing risks/issues and managed through resolution.

• Partnered closely with BPMO, STAKEHOLDERS, Business partners to develop test strategies, end to end (integration) strategies and acceptance criteria.

• Consulted and partnered with vendors and clients to help them develop proposed solutions to satisfy their product references.

• Acted as Lead in the creation, preparation, and conduct of quality assurance reviews and the development and execution with testing of test plans and test scripts.

• Collaborating with data stewards that incorporated processes, policies, guidelines and administrating entire data with compliance.

• Have collaborated with reporting teams such as, tableau to understanding technical requirements and align with functional requirements.

• Used Excel VBA to perform statistical and quantitative analysis of wealth management products in terms of macro trends.

• Developed ad hoc Calculations, Statistical functions, Trend lines, Forecasting, Actions, Filters (Quick, Global, Context), Parameters, Groups and sets for various analytical reports and tableau dashboards.

• Created complex Dashboards using Tableau using the drill down, drill across, actions for business steering committee • Used XML file to outsource data and move to different sources.

• Collaborated with vendors for procurement purposes throughout the life cycle of the process and carried out cadence in timely fashion.

• Made XML file as a standard file format to share data among different vendors and data team members.

• Imported data from XML to editor and identified data elements for mining and to investigate test cases.

• Ability to coordinate troubleshooting activities across Lines of Business (LOB)

• Facilitated research and assisted in making recommendations for improvements in application performance management test strategy.

• Designed and developed various reports and dashboards that could be easily accessible through Tableau App in iPad, iPhones, and other smart mobile phones.

• Supported the incident management process relating to revenue and cost-impacting issues within DRC.

• Served as a mentor/lead and provided training to less experienced staff and assisted in the development of testing skills for all team members (onsite and offshore).

• Provided communication to project stakeholders and vendor companies in scoping and sizing work efforts.

• Experience with various types and levels of testing (e.g., unit, smoke integration, system, regression) and Test planning and execution is done in ALM and provided various reports using the Dashboard Module.

• Coordinated functional, regression testing efforts as well as coordinating with automation and business teams.

• UAT and defined test strategies, test plans, test cycles and test execution timelines with effective collaboration across, project teams, vendors, and business teams at all levels for planning, issue identification and resolution, risk mitigation and production implementation.

• Developed testing documents and leads meetings and/or presentations to communicate risks, change controls and testing decisions or recommendations.

• Experience tracking and reporting testing progress, key metrics and issues and follow-through on resolving project, application, testing and environmental issues.

Environment: MS SQL Server, MS Access, Teradata, Oracle 10g, Oracle 11g, Oracle IAM, SQL, SSIS, SAS, IVR, XML, MS Visio, MS Office Suite (Word, Excel, PowerPoint), BOEXI, TOAD, Salesforce, IBM CURAM

MNSURE, SAINT PAUL, MN November 2015 – August 2016

Sr. (Lead) DATA ANALYST

Description:

MNsure is Minnesota’s health insurance marketplace where individuals, families and small businesses can shop, compare and choose health insurance coverage. It’s the only place to apply for financial help to lower the cost of your health coverage. The project was to reconcile the 52+ data elements from carriers and compare against the MNsure data to identify orphans and discrepancy to build the record that doesn’t exist and provide bi-weekly dashboard.

Responsibilities:

• Analyze EDI 834 ST Enrollment data, check patterns, set in sequence and load.

• Source to target mapping and gather monthly reports in a repository for documentation.

• Reconciliation with the carriers and MNsure data and create test case scenarios.

• Solid experience in data migration from legacy to new source system and in creation of CMDB.

• Gather, analyze, and document EDI reconciliation business requirements.

• Hands on experience with EDIfecs encounter management solution.

• Successfully assisted the branch achieve the sales goals in terms of sales profit margin.

• Data Mining after reconciliation and to provide recommendations for the dashboard.

• Data cleanup and sorting after extract from the warehouse.

• Owned a reconciliation process and effectively migrated data from one source system to another.

• Understanding and experience in use of HIPAA EDI / claim standards and definitions.

• Extracted XML files from data warehouse and vendor companies, and converted, compared, and reconciled data to check orphan levels.

• Collaborated with metadata managers to oversee and manage data compliance issues within the organization.

• Conduct data profiling and gap analysis.

• Excellent vendor management skills and organizing meetings with key contributors.

• Experienced with metadata workbench administrator to prepare metadata for lineage and analysis, to help create log views, and run services to identify relationships between data sources and jobs.

• Understanding the technical aspect for the (tableau) reporting team and changed orders, test plans, scenarios on a timely basis and created business requirement and documented for management.

• Created context diagrams and flowcharts with various teams based on requirements.

• Pull the data from the warehouse in XML format and sort according to data elements for ETL processes.

• Tableau super user and have been involved in designing dashboard for Health insurance data and open enrollment data.

• Strong experience in Toad, SQL Server, and Excel.

• Utilize the tools built within the company and do manual ETL process if necessary.

• Created user stories and acceptance criteria for procurement purposes.

• Write queries, troubleshoot, performance tuning etc. other related work performed for greater results.

• Investigated orphans by drill down and gave recommendations for the source of carrier orphans.

• Extract data from the warehouse with the help of TOAD, SQL and SQL Server.

• Hands-on experience in BOEXI for reporting purposes.

• Extensively used advanced chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Waterfall charts, funnel charts etc., to assist business users in solving complex problems.

• Hands on experience in Oracle BI for deriving object-level and data-level security using duty roles.

• Worked on SAP BO for reporting daily enrollment and stored in the common repository.

• Check Data integrity, Sequence, and trends regularly to maintain consistency in the process.

• Implemented best practices such as naming convention, folder structure, source to target mapping and security.

Environment: SAP BO, MS SQL Server, MS Access, Teradata, Oracle 10g, Oracle 11g, Oracle IAM, PL/SQL, XML, MS Visio, MS Office Suite (Word, Excel, PowerPoint), SSIS, BOEXI, TOAD, Salesforce, IBM CURAM, HIPAA EDI.

Molina Healthcare, Long Beach, CA January 2015 – October 2015

(Lead) DATA ANALYST

Description:

Molina Healthcare is a FORTUNE 500 company that is focused exclusively on government-sponsored health care programs for families and individuals who qualify for government sponsored health care. The project was to integrate data from disparate sources in Enterprise Data warehouse to satisfy BI reporting needs.

Responsibilities:

• Performed data analysis on daily, weekly, and monthly scheduled data refreshes based on the business or system change that have happened to ensure that the developed dashboards are displaying accurate and up to date.

• Worked closely with the business users to identify various KPI’s and designed solutions to enhance business decision-making.

• Gather, analyze, and document business requirements.

• Actively involved as part of a team for gathering and analyzing the needs of End User Requirement and System Specifications.

• Developed ad hoc Calculations, Statistical functions, Trend lines, Forecasting, Actions, Filters (Quick, Global, Context), Parameters, Groups and sets for various analytical reports and dashboards.

• Created ad hoc SQL queries for user reports, executive management reports.

• Performed Data mining for the identification of unusual data records or data errors that require further investigation.

• Analyzed EDI Enrollment/ Claims data, check patterns, set in sequence and loaded.

• Participated in weekly meetings, reviews, and user group meetings as well as communicating with stakeholders and business groups.

• Experience in use of HIPAA EDI / claim standards and definitions.

• Developed and maintained a high-level overview of the data flows using MS Visio.

• Developed and modified Business Intelligence analytical reports/dashboards using Tableau Desktop.

• Extensively used advanced chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Waterfall charts, funnel charts etc., to assist business users in solving complex problems.

• Implemented advanced geographic mapping techniques and used custom images and geo coding to build spatial visualizations of non-geographic data.

• Utilized Tableau visual analytics and best practices like Dashboard structure, view orientation, Sizing and Layout,

• Data Emphasis, data mining, Highlighting, Color, Fonts, Tooltips, and performance improvement of complex dashboards/reports

• Created user stories and acceptance criteria and various reports like Master/Detail reports, Cross Tab reports, slice and dice reports, and drill down reports, Charts using Freehand SQL and Stored Procedure as data providers.

• Designed and developed various reports and dashboards that could be easily accessible through Tableau App in iPad, iPhones, and other smart mobile phones.

• Built complex calculations using advanced functions (LOD, ATTR, DATEDIFF, STR, Ifs, OR, Nested Ifs, NOT, AND SUMIFs, COUNTIF, LOOKUPs, RUNNING_SUM, RANK_DENSE, and QUICK TABLE Calculations).

• Performed Tableau type conversion functions when connected to relational and SAP BW data sources.

• Designed, developed, and modified Interactive Dashboards using actions (filter, highlight, URL) and created guided navigation links within Interactive Dashboards.

• Developed Standard Operating Procedures (SOP) for Monitoring and involved in license management SLAs with Tableau support. Defined best practices for Tableau report/ dashboard development.

• Extensively done ETL process and extracted the data from different source systems like Teradata, Salesforce, MS SQL Server, Flat files, XML. Created row level / user level filters and administered user, user groups, and scheduled instances for reports in Tableau.

• Mentored Power users in creating and modifying worksheets and data visualization dashboards.

• Used TabAdmin and TabCMD commands in creating backups and restoring backups of Tableau repository.

Environment: Tableau 9.x/8.x(Desktop/Server/Mobile), SAP BW, MS SQL Server, EDI, HIPAA EDI, Oracle IAM, Cognos,

MS Access, Teradata, PL/SQL, XML, Control-M, GitHub, MS Visio, MSOffice Suite (Word, Excel, PowerPoint)

Black & Decker, Towson, MD October 2013 – December 2014

Sr. BUSINESS/ DATA ANALYST

Description:

Black & Decker Corporation is a manufacturer of power tools and accessories, hardware and home improvement products, and technology based fastening systems. Black & Decker merged with Stanley Works to become Stanley Black & Decker. The project was to implement BI reporting solutions using Tableau to Supply chain and Marketing teams.

Responsibilities:

• Actively participated in interaction with users, team lead, DBA’s, and technical manager to fully understand the requirements of the system.

• Participated in the Business and Specifications requirements gathering sessions and converted it into Design specifications.

• Gather, analyze, and document business requirements.

• Developed functional and technical specifications.

• Performed Data mining for the identification of unusual data records or data errors that require further investigation.

• Created user stories and acceptance criteria.

• Created context diagrams and flowcharts with various teams based on requirements.

• Worked extensively with MS Visio and Rational tools to document requirements.

• Analyzed requirements for various reports, dashboards, scorecards and created proof of concept / prototype the same using Tableau desktop.

• Defined, created, and managed business and technical specifications, and other project documentation for applications development.

• Mentored business power users to create reports/dashboards using tableau desktop.

• Designed and deployed rich Graphic visualizations with Drill Down and Drop-down menu option and parameterized using Tableau.

• Involved in creating stored procedures, views, and custom SQL queries to import data from SQL server to Tableau.

• Blended data from multiple databases into one report by selecting primary keys from each database for data validation.

• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.

• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.

• Identified customer marketing opportunities by applying data mining models and writing advanced T-SQL stored procedures and queries.

• Utilized advanced chart visualizations in Tableau like Dual Axis, Box and Whisker Plots, Bullet Graphs, Tree maps, Bubble Charts, Waterfall charts, funnel charts etc., to assist business users in solving complex problems.

• Worked on Motion chart, Bubble chart, Drill down analysis using Tableau desktop.

• Developed storytelling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.

• Created Data Extracts (. TDE), published and scheduled data refreshes (Complete/Incremental) of the same on Tableau Server.

• Used different Mark types and Mark properties in views to provide better insights into large data sets.

• Worked collaboratively with a team of SQL Server developers to build ETL processes needed for reporting.

Environment: Tableau 8.x (Desktop/Server), SQL Server, SSIS, Oracle, Cognos, MS Access, MS Visio, SharePoint, Microsoft Office Suite (Word, Excel, Power Point)

Ryder, Miami, FL March 2012 – September 2013

Tableau / SQL/ Data Analyst/ Report Writer

Description:

Ryder System, Inc. is a provider of transportation and supply chain management products that is known for its fleet of rental trucks. The company divides its business into three segments: Fleet Management Solutions, Supply Chain Solutions, and Dedicated Contract Carriage. The project was to migrate reports existing in MicroStrategy to Tableau.

Responsibilities:

• Defined the scope of the project based on the gathered business requirements including documentation of constraints, assumptions, business impacts, project risks and scope exclusions.

• Analyzed existing reports and developed business, functional and/or technical requirement specifications adhering to standard requirement templates.

• Designed and developed analytical reports and dashboards using filters, parameters, sets, bins and implemented visualizations with complex calculations to manipulate the data.

• Interacted with business users and performed Gap Analysis of Client requirements.

• Elicited business solutions to develop SOX compliance into the existing procurement workflow executed through IT channels.

• Worked extensively with MS Visio and Rational tools to document requirements.

• Created AS-IS and TO-BE process flow diagrams.

• Drew upon a full range of Tableau platform technologies to design and implement proof of concept solutions and create advanced BI visualizations.

• Generated high detail-oriented views using multiple measures, Individual Axes, Dual Axes and Custom Geocoding. • Competent in using business intelligence tools of enterprise resource planning, online analytical processing, data mining, etc.

• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.

• Developed and maintained dashboards using Tableau Desktop and published it to Tableau Server to meet business specific challenges.

• Designed and developed workbooks and dashboards that are accessible in different environments like any browser or tablet.

• Developed dashboards for calendar year and fiscal year.

• Incorporated regional and national comparative / benchmark metrics to give context to Ryder performance.

• Created extensive custom joins for blending data from several different data sources.

• Prepared monthly status reports for Enhancement Requests to the project team that was used in efficient tracking and monitoring of open issues of the project.

• Created batch and incremental refreshes for data sources on Tableau server.

• Coordinated database middleware issues with DBA’s, system performance with System Architects.

• Involved in creating and developing test strategies, test cases and test plans for User Acceptance testing (UAT).

• Interacted extensively with the offshore development team to make sure that the developed system matches the requirements.

Environment: Tableau 7.x/ 8.x (Desktop/Server), Oracle, Teradata, SSIS, MicroStrategy, PL/SQL, MS SQL Server, MS Visio, ERwin, Cognos, MS Office Suite (Word, Excel, PowerPoint).

Anixter, Waukegan, IL January 2011 – February 2012

Data Analyst

Description:

Anixter International is a leading company which supplies communications and security products, electronic wire and cables, fasteners, and other small components. The project was to provide BI solution to satisfy reporting requirements from Management and Business Users using data feed from EDW (Teradata) and other multiple sources like SAP BW, MS SQL Server, Flat files, etc.

Responsibilities:

• Gathered Business and Specification Requirements from the Business users and technical team.

• Provided high level Conceptual Data Model to the Business Users once the Business Requirements are evaluated and finalized.

• Conducted user training to produce standard and ad hoc reports.

• Wrote SQL scripts for large data pulls and ad hoc reports for analysis.

• Assisted the IT team to develop service-oriented architecture (SOA), and data warehouse system to utilize data mining for data analysis.

• Created Conceptual Data Model (CDM), Logical Data Model (LDM) and Physical Data Models (PDM) using ERwin data modeling tool.

• Create a source to target mapping documents (design documents) involving the Business rules and transformation rules.

• Reviewed High Level Design (HLD) Documents and Design Specification Documents provided to the ETL technical team once the Logical Data Model is reviewed and approved by the business users.

• Developed SQL queries for extracting data from production databases and built data structures, reports.

• Worked with BA in updating the source to target mappings (Data Dictionary) including business rules and transformation logic.

• Performed Data Quality Framework (DQF) analysis to filter the source data which violates the defined Business rules. Performed Allowable values and Range Value Checks.

• Coordinated with Business Analysts/Developers/Architects and other team members, attended code reviews and design walkthroughs to get a grip of the whole end to end process and suggested changes wherever necessary.

• Added multiple checkpoints in the end-to-end DW process and performed checks to ensure the data flow is as expected, by running queries on the Oracle/SQL Server/Teradata.

• Extracted data from existing data stores, designed departmental reports for performance and response purposes by using Cognos.

• Designed and developed templates, standard reports, master detail reports like list reports, crosstab reports and chart reports in

Contact this candidate