SUMMARY

Lalitkumar Pandey

** ******* ***, ****** ****, NJ 07307 • 551-***-**** • ac1oy5@r.postjobfree.com linkedin.com/in/iamlalitpandey

• Expert in analyzing, discovering and visually depicting data patterns & trends using SQL, Tableau & Adv. Excel

• 4.5 years of experience in database management, ETL and BI report development with Teradata / SQL Server

• Awarded “Teradata Employee of the Quarter” for significant query tuning and performance optimization for PayPal EDUCATION

Masters in Computer Science, May 2017, Stevens Institute of Technology GPA: 3.76 Bachelor of Science in Computer Science, 2012, University of Mumbai SKILLS

Databases: MongoDB, Teradata, SQL Server, T-SQL Languages: C, SQL, Python, R, HTML, UNIX Visualization: Tableau, Qlik Sense Statistical Tools: Advanced Excel, RapidMiner Others: Microsoft SSIS/SSRS, Informatica, Erwin, JIRA, Google Analytics, Hive, Hadoop, Visio, Visual Studio PROFESSIONAL EXPERIENCE

Sogeti USA LLC – Business Intelligence Developer, NJ, US Jan 2017 – Present Business Intelligence Developer - Express Scripts

• Gather and translate business requirements into technical code, reports, dashboards and develop optimal solutions

• Developed ETL packages for cleansing, data movement and incremental loads in data warehouse using SSIS

• Developed and modify Tableau extracts, dashboards using Tableau Desktop, managing access permissions

• Performed Database modelling to invoke new data marts in the existing data warehouse environment

• Created and revised Python scripts used to generate custom reports, managing subscriptions and electronic delivery

• Worked in BI development team using agile methodologies to develop and maintain the exclusive reporting portal

• Developed complex statistical and forecasting reports using several R functions in Tableau workbooks

• Responsible for maintaining DEV/QA/Production reporting environments, data refresh and report optimization Business Intelligence Consultant - Johnson & Johnson

• Created impactful data visual blueprints for developing a BI dashboard on different KPIs for Johnson & Johnson

• Developed and maintained SQL queries and stored procedures for ad hoc reporting and recurring reports

• Optimizing SQL queries to improve runtime and utilize the system resources more efficiently

• Maintaining the Teradata data warehouse platform and solving data discrepancies, ETL and BI reporting issues. Teradata Corporation – Data Engineer, MH, India Jun 2012 – Dec 2015

• Identified problematic queries and optimized statistics, skew, indexes to save system resources

• Identified the security violations and defined the process to mitigate the business risks at PayPal

• Reporting performance issues and resource utilization trends using descriptive analytics in Tableau/Excel

• Performed trend analysis on historical data to forecast DB space requirements circumventing space exhaustion

• Recommended Hadoop solutions using the available Teradata infrastructure data at PayPal

• Implemented UNIX crontab alert scripts to monitor system resources and access failures

• Certified Teradata 12 SQL Specialist & Database Administrator ACADEMIC PROJECTS

Risk Assessment on Prudential Life Insurance Dataset – R, Machine learning Fall 2016

• Created a prediction model using Linear regression and Decision Tree and to determine Insurance risk

• Performed data cleansing, dimension reduction and evaluated the model performance using risk factors Social Graph mining for Yelp Dataset – Python, MongoDB Spring 2016

• Created and analyzed data model on Yelp dataset to identify the social circle influence on individual users.

• Implemented regression algorithm for predictive analytics, to find social relationships among users. Stock Trend Analysis in R – R, Shiny, GoogleVis Spring 2016

• Derived and visualized various financial metrics to measure a stock performance over time. Interview Question Tagger – Python Spring 2016

• Segregate most similar questions using LDA and K-means clustering algorithm with 76% cluster accuracy.