Vikram Anandan Email & Phone Number

Milpitas, Ca, Us

Milpitas, Ca, Us

I work closely with cross functional teams to perform a key management and thought leadership role in the areas including Data Analysis, Design, and Modeling | Business Intelligence | Data Warehousing | Project Management | Database Administration, Optimization & Tuning | Reporting• Hands-on experience in writing complex, highly optimized SQL queries across large data sets• Architected and built an Insurance BI Product solution from the ground up to serve all customers across all lines of businesses• Designed & engineered high volume, time sensitive ETL pipelines that produce business critical data efficiently and reliably • Performed data cleansing, mapping, transformation as part of the data migration and integration process from new customers' legacy databases to our product's Cloud database• Was the point person and gatekeeper of the entire product's database schema design• Prepared and automated business critical financial reports, quarterly statements, and annual loss cost ratios• Developed complex SQL scripts for timely and consistent daily and monthly reports• Created extracts to move data from our database to serve as extract files for the customer's data warehouse• Serviced ad hoc query and report requests from different teams• Implemented the data archiving process of our data• Performed optimization and tuning of SQL Queries, which in one case led to 8 hours of time saved for a batch process• Monitored different environments, and proactively addressed potential issues• Led the effort to setup different database performance benchmarks• Created data testing reports to constantly monitor health of the system by data reconciliation to ensure data quality• Worked closely with senior executives & sales team to create different Proof of Concepts solutions• Successfully led teams, concurrently, both onsite and offshore• Supervised and reviewed technical design documents• Effectively managed a team of 5 in providing 24x7 production support

Paris, France, Fr

• Was part of the team which created business process workflows websites• Heavily involved in end-to-end design and analysis of solutions• Key member in designing, developing, and maintaining different databases • Resolved major data management maintenance issues by designing, developing, and maintaining SQL scripts that performed ETL functionality • Was a key member involved in creating a centralized reporting dashboard for all clients• Designed and built different report variations in SSRS• Improved the functionality of existing solutions by creating custom code in C#, and Java• Worked with Java and C# APIs to access data from different client secure locations• Performed UAT testing of services, and was in charge of deployment to Production• Presented playbacks to clients and Business Analysts, and assisted in subsequent requirements gathering• Documented the design, and mentored team members towards building highly reusable and maintainable applications

• Was in charge of managing disparate drug and physician databases, and unifying the data to a single database• Designed a new database to facilitate coherent extraction of information• Designed a process to migrate data from MS Access to MySQL• Created stored procedures, scripts and functions to update the different databases• Helped design a basic front end web interface and integrated with existing databases into a complete workflow process• Enhanced the Contact Management System as per the company’s requirements

• Designed, programmed, and tested 4 live, online advertising related applications. • Helped designed the database schema• Created and maintained stored procedures that were used to retrieve large volumes of data• Worked on Java APIs to retrieve data from remote server. • Created DTS packages to extract and merge data from different sources • Used C#.NET to create the front end of the applications.• Generated client reports, on the fly, using the XSLT support in the .NET framework

Masters, Computer Science

Bachelors, Computer Science