Vivek Neshti's Email Addresses & Phone Numbers

📖 Summary

Business Intelligence Intern @ Atlanta Police Foundation - Developed Tableau reports and visualizations for analyzing Crime Data to support Atlanta Police Department. From June 2016 to July 2016 (2 months) Greater Atlanta AreaBusiness Intelligence Developer/Research Assistant @ Georgia State University - Assistance to faculty in researching about latest tech in Analytics and AI domain. - Perform data analysis for Graduate Admissions Department using various analytics and reporting tools such as R, Tableau- Supervise undergraduate students working on assigned research projects under the faculty From August 2015 to July 2016 (1 year) Data Analyst @ EY As part of Enterprise Intelligence practice at EY, I design and develop ETL solutions for clients in the Insurance and banking domain. I am experienced in utilizing tools such as IBM Datastage, Informatica PowerCenter to develop ETL workflows for clients. Key Responsibilities:- Develop executive-level reports and presents complex, customized analytic findings to senior leadership team.- Deliver actionable and measurable insights that drive business for the clients- Gather specific requirements and research criteria.- Supporting all maintenance activities related to the ETL and Reporting- Interfacing between various business and technical teams to compile requirements and design solutions.- Work closely with customers to build relationships and continuously gaining a deeper understanding of relevant data and processes to build analytic solutions to meet business needs. - Responsible for gathering and assessing business information needs and preparing system and data requirements. - Performs analyses and profiling of the data, create detailed mapping documentation including transformation rules.- Production and development support for OLTP Web and Data Warehouse applications From July 2013 to July 2015 (2 years 1 month) Bengaluru Area, IndiaAssociate Data Analyst @ EY Key Responsibilities:- Installing, configuring, deploying, and tuning BI tools and analytic servers- Troubleshooting BI tool (Tableau, SAS) problems and tuning for performance- Developing multidimensional semantic layer, and BI query objects for end users- Creating reports and report templates- Helping business users select the appropriate BI tool(s) (Cognos, Tableau, Hyperion IR, and SAS)- Providing ETL tool (Informatica, Datastage) consultation to application development teams- Developing and managing BI training, documentation, and help desk capabilities- Working with business requirements analysts to identify and understand source data systems- Mapping source system data to data warehouse models- Developing and testing extraction, transformation, and load (ETL) processes- Defining and capturing metadata and rules associated with ETL processes From July 2011 to June 2013 (2 years) Bengaluru Area, IndiaBig Data Engineer @ EY - 7+ years of hands on experience with architecture and implementation of data lake and ETL solutions- Created data pipelines using Apache Spark + Python (Pyspark) leveraging the Databricks Unified Analytics platform- Experience in working with AWS Cloud platform (Redshift, Glue, EMR, Kinesis).- Advanced knowledge of SQL and NoSQL databases and the Hadoop ecosystem (HDFS, MapReduce, Hive, Pig, Impala, Spark, Kafka).- Lead the development workstream with onshore and offshore team of developers- Experience in working with Business Intelligence tools - Tableau, AWS QuickSight - Experience with Apache Airflow - Strong understanding of Conceptional, Logical and Physical Data modelling - Hands-on experience with relational database technologies, including SQL Server, Oracle DB- Exposure to Continuous Integration/Continuous Deployment & Test Driven Development- Business transformation of P&C insurance clients using Guidewire products - GW Policy Center and GW Claim Center. San Francisco Bay Area