Ankur Pandey

Background

About Ankur Pandey

PROFESSIONAL SUMMARY: Professional experience of 6+ years in the field of Data Analysis, Business Intelligence and Data Science. A data analyst & interpreter, business intelligence analyst & developer with a proven history of turning large data sets into progressive, action oriented and value creating insights for the business/project through the creation of clear, compelling infographics, data visualizations, reports and dashboards via Business Intelligence tools such as Power BI, Tableau etc leading to data driven decision making. Skilled in operating various database management systems like SQL and data warehouses like Snowflake in order to store, transform, clean, query, manipulate and analyze the data. Carried out extensive data mining for achieving meaningful business insights. Worked with informatics, apache kaka etc. Worked with ETL tools viz Alteryx and Integration tools like Informatica, gathered and streamlined data according to the requirement and represented key data trends through KPIs, charts and reporting/dashboarding the same via BI tools/platforms. Skilled in carrying out data analytics using mathematical and statistical techniques; aimed at identifying trends, patterns and variances in data. Experienced in Agile Project Management via tools like JIRA and Azure Portal. Prepared strong documentation for the reports and dashboards developed. Possess sound technical knowledge of PowerBI, AWS Quicksight, Qlik, Looker,Tableau, Cognos, SQL Server, MySQL, Snowflake, Alteryx, Impala, Linux, Data visualization with Python, Azure Devops Portal, JIRA, GIT. An IT professional with a positive attitude and passion for deciphering data and reporting/dashboarding key insights. Possess excellent communication skills both verbal and written to present points precisely and clearly.Skilled in:Languages: Python, R, Java, SQL Product Management: Github, Waterfall, Agile Development Experience.Web Development: HTML5, CSSMicrosoft Office suite: Advanced Excel knowledge; Experience with Pivot tables, VLOOKUP, MS PowerPoint, MS Word.Databases: MySQL, Netezza, SQL server, Oracle, MongoDB, Cassandra, Hadoop, Hive ETL tools: Informatica, Apache Spark, Apache Kafka,SSIS Data Visualization and Analysis Tools: MicroStrategy, Power BI, Tableau, Python libraries (Seaborn, Plotly, Matplotlib), R libraries (ggplot2) Packages: SciPy, Scikit-learn, Pandas, NumPy, Hadoop, Pyspark, flask Other tools: Anaconda Jupyter Notebook, Putty, R-Studio Cloud: Azure, AWS