Tarun Maheswaram
Canonsburg,PA
Summary
Meticulous and results-driven professional with 7+ years of expertise in BI operations, database designing, project lifecycle, data modelling and reporting solutions. Proficient in generating critical custom BI reports and applying detail-oriented process to improve application availability and performance. Competently works in development, test and production environments across multiple business domains. Highly organized leader with a big-picture understanding of business needs to support and boost profit growth.
Overview
10
10
years of professional experience
Work History
Tableau Developer
Pennsylvania Transformer Technology
06.2024 - Current
- Facilitated data-driven decision making through the creation of comprehensive executive-level dashboards highlighting key trends and insights.
- Worked closely with data engineers and business analysts to validate data sources and ensure accuracy in reporting.
- Empowered stakeholders with real-time access to actionable insights by developing dynamic visualizations tailored to their needs.
- Standardized metrics across various departments by establishing consistent definitions for KPIs used in Tableau reports.
- Conducted thorough quality assurance testing on all dashboards before deployment to guarantee accuracy and reliability of the presented data.
BI Developer
Blue Cross of Idaho
02.2021 - Current
- Spearheaded facets redesign project leveraging SSRS reporting platforms sourcing crystal repository
- Navigated across entire Microsoft BI suite of products including SQL Server, SSIS, SSAS, SSRS and Power BI SDLC from prototyping to deployment
- Transitioned ETL between homogenous and heterogeneous system using SQL tools (SSIS, DTS, Bulk Insert, BCP, and XML)
- Formulated and debugged stored procedures and triggers in SQL Server and PL/SQL
- Remodeled TABLEAU into a managed service offering for consumption across corporate treasury and corporate investments
- Implement advanced Tableau features such as calculated fields, parameters, and sets to provide interactive data exploration capabilities
- Converted SSRS reports to Tableau for optimization purposes
- Created Index, Views, Complex Stored Procedures and User-defined functions
- Integrated Power BI with various data sources, including SQL databases, Excel files, cloud platforms (such as Azure and AWS), and web services, to consolidate and transform data for analysis
- Developed multiple Power BI Reports based on SSAS Tabular Cube as Data Source (Connecting Live Mode)
- Worked with Data Modeling, Database Design, SQL Scripting, Development, and Implementation of Client-Server & Business Intelligence (SSIS, SSAS, SSRS) applications
- Wrote DAX and Complex queries in M Language and devised visuals using visuals (Bar, Pie, Waterfall, Line, Dotted etc.,) in Power BI
- Design and develop visually appealing dashboards and reports in Tableau to convey complex data insights to stakeholders
- Assessed platform statistics to create customized, data-intensive BI analytics
BI Developer
MWI Animal Health
09.2020 - 01.2021
- Orchestrated T-SQL programming, stored procedures, user-defined functions, cursors, views setup and management of linked servers to Non-SQL- Server databases
- Designed and documented functional and technical report templates and reporting standards for the developers to work on the report development
- Finalized On demand (Pull) and Event Based delivery (Push) of reports and created complex SSIS packages with proper control and data flow elements
- Created ETL packages and mined data to identify rules and patterns and manipulated multidimensional cube data through MDX Scripting
- Generated complex Drilldown, Parameterized, Linked, Ad-Hoc reports and Sub reports/filters/charts in SSRS
BI Developer
Blue Cross of Idaho
10.2017 - 06.2020
- Spearheaded Crystal to SSRS conversions project converting more than 600 Crystal reports to SSRS for project optimization
- Oversaw Query Optimization to boost performance and developed operational Drill-through and Drill-down reports
- Generated SSIS-ETL packages to load data into Data Warehouse using SSIS tasks like execute SQL Task, bulk insert, data flow, file system and execute package task
- Designed SSIS packages to Oracle, SQL Server instances in SSIS 2014
- Monitored and optimized Tableau Prep workflows to minimize processing time and resource utilization while maintaining data integrity
- Utilized Tableau Prep Builder to clean, reshape, and combine disparate data sources into unified datasets
- Optimize SQL queries and database performance by analyzing query plans, indexing strategies, and database statistics in PostgreSQL
- Utilize PostgreSQL's advanced indexing features such as GiST, GIN, and BRIN to optimize query performance on large datasets
- Developed multiple Power BI Reports based on SSAS Tabular Cube as Data Source (Connecting Live Mode)
- Implemented advanced data modeling techniques in Power BI, including creating relationships, calculated columns, measures, and DAX (Data Analysis Expressions) calculations to enable robust data analysis and visualization
- Wrote and optimized SQL statements to assist business intelligence practices
- Developed custom visuals and templates in Power BI to enhance dashboard aesthetics, usability, and user engagement, leveraging Power BI's extensibility and customization capabilities
- Collaborate with stakeholders to understand their data visualization requirements and translate them into effective Tableau Desktop solutions
SQL Server Developer
Syntel
12.2014 - 11.2015
- Monitored and deployed SSIS packages for Dynamic ETL flow to validate, extract, transform and load data into database
- Performed Full load & Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS
- Devised SSIS package to export and import data from SQL Server to Access, Text and Excel files and Configured SQL mail agent
- Utilize PostgreSQL features such as Foreign Data Wrappers (FDW) and PL/pgSQL for custom data integration solutions
- Utilize PostgreSQL's JSONB data type for flexible and efficient storage of semi-structured data
- Utilize PostgreSQL's array data type for storing and querying lists of values within the database
- Configured Connection Manager files for SSIS packages to dynamically execute on Quality Analysis server and Production server
- Designed Parameterized, Drill-through, and Drill-down Reports to get monthly customers account details and profits using SSRS
- Deployed, configured and managed reports using Report Manager and Report Builder
- Mitigated any deadlocks issues with the databases/servers on a real -time basis and devised reports using global variables and expressions
Education
Master of Science -
Valparaiso University
Valparaiso, INSkills
- Business Intelligence Roadmap Design
- Database Design & Development
- Client-server & BI Applications
- Project Lifecycle & Implementation
- Data Modeling
- SQL Scripting & Analytics
- ETL
- Performance Tuning
- BI Reporting Solutions
- Database Management
- SSRS
- SSAS
- SQL Server Management Studio
- Enterprise Manager
- BI Studio
- Profiler
- Performance Monitor
- Database Tuning Wizard
- Tableau
- Power BI
- Crystal Reports
- SSIS
- Erwin Data modeler
- SQL Azure
- OLAP
- Transact SQL
- C
- Visual Basic
- C
- DAX
- M
- SQL Query Analyzer
- MySQL
- Visual Studio
- Solution Explorer
- Windows
- UNIX
- Linux
- DOS
- Attention to Detail
- Teamwork
- Adaptability
- Interpersonal Skills
- Problem-Solving
- Decision-Making
- Time Management
Timeline
Tableau Developer
Pennsylvania Transformer Technology
06.2024 - Current
BI Developer
Blue Cross of Idaho
02.2021 - Current
BI Developer
MWI Animal Health
09.2020 - 01.2021
BI Developer
Blue Cross of Idaho
10.2017 - 06.2020
SQL Server Developer
Syntel
12.2014 - 11.2015
Master of Science -
Valparaiso University
Similar Profiles
Deven PettitDeven Pettit
Supervisor at Pennsylvania Transformer TechnologySupervisor at Pennsylvania Transformer Technology
Olando EdouardOlando Edouard
Electrical Assembly at Pennsylvania Transformer TechnologyElectrical Assembly at Pennsylvania Transformer Technology
Matthew PoshMatthew Posh
Programmer / Systems Analyst at Pennsylvania Transformer Technology, Inc. (PTTI)Programmer / Systems Analyst at Pennsylvania Transformer Technology, Inc. (PTTI)