Tejas Naik Email & Phone Number

Palo Alto, Ca, Us

- Maintain worldwide Corporate Enterprise Public Sector account database modeling capability to address stakeholder needs from PPS WW. - Created stored procedures, views to convert business rules and to parse and clean the data provided by regions for better analysis.- Pre validating the data by creating automated process of checking and analysis of historical vs current data. Generating automated Excel error reports of post validation after refreshing the region data.- Worked on Windows XP service & support migration project which was a 500M deal for HP WW. Developed a codebase to get SKU level details of all HP products using Windows XP and tracking Sales Reps level info to strike opportunities to sell HP products with upgraded Windows operating system.- Running Analytics around the CEP model by creating QlikView dashboard for better and more interactive data representation and limiting content restricted access to account level details for specific users.- Creating Database business strategy for the team and come up new innovation ideas of analyzing data by using new analytical tools and introducing Database SQL solutions for fast and error free analytical reports with more data points. - Maintain data integrity, quality and table structure of the model. Develop codebase to refresh all source data dynamically and automate it. Automate the entire process for faster runtime and avoid manual monitoring checks and email notification to the team of process completion and data readiness.- Improve speed of project delivery with greater accountability for specific project timelines. Develop a tighter customer feedback loop with key stakeholders on all projects. Increase ownership to validate numbers, to present findings with integrity and conviction.

- Worked on building a Scheduling Engine database for the Wachovia/ Wells Fargo Merger that would enable File Generation, Validation, ETL for source data refreshes, Production support, Testing and Reporting of enterprise wide consumer data.- Created stored procedures and functions to convert business rules specified by metadata into complex SQL used by scheduling engine and to parse and clean the data provided by product groups for better analysis.- Providing Subject matter expertise to business team for the Wholesale Merger Analytical database, including scheduling engine, exclusion rules, file generation.- Configured various DTS/SSIS packages to used database table driven SSIS configurations to optimized reliable execution on Production server for complete BCP failover and failback testing.

- Designed and implemented an in-house OLAP database for the company that would enable collection, consolidation and reporting of enterprise wide consumer data.- Designed complex ETL strategies to pull data from different sources, like SQL server, oracle, and flat files and load it to the destination database after using multiple transformations and optimization techniques.- Logged SSIS packages using custom logins and created XML and SQL Server package configurations for deployment to production servers.- Created linked reports, sub reports as well as click through reports in support of management and troubleshoot the deployment of reports in the test and production environment using SSRS.

- Provided customer relationship services for a credit card collections process department to clients and customers in North America and to provide 24/7 billing services and solutions.- Responsible for handling customer's issues specifically related to support/products and handle the tasks of sourcing potential customers and maintaining relationship with current customers.- Fulfilled the tasks of providing root-cause analysis and recommendations to improve product and support processes.- Demonstrated excellent customer service, which was recognized by appreciation certificate for best customer service.

Masters, Telecommunications

Bachelors, Electronics And Telecommunication Engineering

Diploma, Electronics & Telecommunications