Tarun Mathur Email & Phone Number

Thousand Oaks, Ca, Us

•Lead technical design, development, testing, implementation, and support of key projects in data visualization, dashboards, and reporting. •Responsible for the design, development, testing, implementation, and support of key projects involving Business Intelligence (BI) technologies and integration technologies including data pipelines.•Collaborate with Business Partners, Data Architects, Data Scientists and Business Analysts to translate business requirements into technical requirements and understanding how data is being collected to help drive the analytics strategy supporting Safety.•Author documentation including design specification, flowcharts and diagrams for BI solutions.•Write SQL queries to manipulate and visualize data using data visualization tools.•Maintain knowledge of market trends and developments on Business Intelligence and related new technologies to provide recommendations for improvements.•Estimate level of effort and hours entail for each phase of a project.•Ensure projects work are completed on time and within budget.•Deliver results in an environment consisting of diverse global and matrixed partners including non- dedicated resources.

Thousand Oaks, Ca, Us

Thousand Oaks, Ca, Us

Teaneck, New Jersey, Us

Charlotte, North Carolina, Us

• Automated the daily process where Daily Customer reports are extracted from data warehouse and Converted to Excel sheet and emailed to specific members of E commerce project on daily basis using C# code in Visual Studio.• Designed Complex Stored Procedure on SQL Server to create Daily reports of Hotel Customers• Coordinated with various team members on the Agile Sprint Refinement meetings to create story points for the next Sprint• Performed Indexing on tables used in Stored Procedure to extract data , which reduced the response t. time of queries by 20 milliseconds.

Teaneck, New Jersey, Us

• Planned, coordinated analysis , design an extraction of encounter data from multiple source systems into the datawarehouse relational database (DB2) while ensuring data integrity• Identified issue and developed a procedure for correcting the problem which resulted in the improved quality of critical tables by eliminating the possibility of entering duplicates in DataWarehouse• Involved in monitoring and troubleshooting of different ETL workflows and automated them in Workflow Monitor to ensure smooth & timely delivery of processed data to target applications• Operated on Informatica Powercenter for Data Loading ,Performance Transformation , Creating & Scheduling Tasks and Reusability of Worklet and Maplet ensuring overall data productivity• Maintain daily Customer billing details in Datawarehouse by implementing slowly changing dimensions type -2 using transformations in Informatica• Design and implemented performance changes which slashed a long running job from 14 Hours to 6 Hours

Master Of Science, Management Information Systems, General

Bachelor Of Technology (B.Tech.), Electronics And Communication Engineering