Summary
Overview
Work History
Education
Skills
Certification
Accomplishments
Technical Accomplishments
Timeline
Generic
Ashish Singh

Ashish Singh

Bangalore

Summary

Goal-driven Analyst polished in managing and breaking down large volumes of information. Proactive at heading off issues in operations, workflow and production by uncovering trends affecting business success. Over 16 years of experience in Information Technology and Finance industry in Data Analytics and Business Operations with specialization in following areas, but are not limited to: Data Analysis and Modeling, Project Management, User/Stakeholders Management, Business Intelligence, SDLC- Agile/Scrum Framework, Training and Development, Data Warehouse and ETL, Change Management, Team Building/leadership, Visualization & Reporting, Statistical Modeling, Test Driven Development, Business Analyst, Process Optimization, Customer Relationship Management.

Overview

17
17
years of professional experience
1
1
Certification

Work History

Technical Sys Analyst Staff

Juniper Networks India Private Limited
2021.08 - Current
  • The GS Analytics team provides world class data analytics and support to our stakeholders which allows them to measure performance and achieve business goals and expectation
  • We touch everything- SA, Contracts, RMA, SR, Revenue, Costs, Install Base, Customer Mater, Quotes, Opportunities, Service Logistics (External), Sales Orders, Shipments, Discounting, ACV/TCV and Product Master, OpenAir System Administration, SQ PRs and Contrail JIRA
  • Enable a world class Service Sales Operation by driving efficiencies and effectiveness across end-to-end service sales processes
  • I and my team own global services sales processes, application, data quality and related business transformation initiatives
  • My role to provide operational support to the theaters/regions to achieve their service sales objectives
  • We oversee global program management of service renewals sales vendors.

Assistant Vice president

JPMorgan Services India Pvt. Ltd.
2019.12 - 2021.08

Senior Consultant

Optimum Solutions Pvt Ltd
2018.09 - 2019.10

Assistant Vice president

JPMorgan Services India Pvt. Ltd.
2014.10 - 2018.08

Lead Consultant

Genpact Headstrong Capital Market
2013.08 - 2014.09

IT analyst

TATA Consultancy Services
2012.02 - 2013.07

Cognos Consultant

Steria India
2010.09 - 2012.02

Software Engineer

KPIT Cummins Infosystems Ltd. Pune
2007.09 - 2010.09

Education

MCA - Computer and Information Sciences

Bansal Institute of Science & Technology
06.2007

Bachelor of Science - Statistics

Awadhesh Pratap Singh University
Rewa
2001-06

Skills

  • Visualization/ Reporting: Tableau, Cognos 11.X/10.X/8.X, Business Object, OBIEE, Microsoft Excel, etc
  • Database: Oracle PL SQL, SQL Server, MySQL, User Defined Aggregated XML/Jason Data Engine
  • Programming and UI/Web: Python, Java Script, HTML, ASP, VB Script, Ajax
  • Big Data Framework/Data Modeling: SQL, PLSQL, Alteryx, CIS Composite, Python, Cognos Framework Manager, Cognos Designer (Cube Modeling), BO Designer
  • Business Application: JIRA, Confluence Wiki, HP ALM, HP QC, REGLA, OneSumX, Life Cycle Manager, Enterprise Deployment Tool

Certification

  • CSPO - Certified Scrum Product Owner (Scrum Alliance).
  • CSM - Certified Scrum Master (Scrum Alliance).
  • Certified Scrum master (Scrum-institute.org).
  • Certified Alteryx Advance Designer.
  • Certified Alteryx Core Designer.
  • Six Sigma Green Belt.
  • IBM Cognos BI OLAP Modeler.
  • IBM Cognos BI Reports Author.

Accomplishments

· Subject Matter Expert in Business Data Analysis to identify process gaps and bottlenecks and to provide insights which enables stakeholders and business to improve policies and operations.

· Expertise in defining scope of projects based on gathered business requirements including documentation of constraints, assumptions, business impacts & project risks.

· Performed extensive GAP analysis in transforming the regulatory documents to business rules.

· Generated $10,000 savings by optimizing processes and building in house analytical tools using Alteryx, Tableau, Cognos and Oracle.

· Generated $1.5 Million savings by automating manual user analysis (Microsoft Excel macros) using TABLEAU.

· Initiated a program in the firm which helped in increasing the Customer Satisfaction Score by 40%.

· Conducted walkthroughs for the stakeholder with simple PowerPoint explanations.

· Experienced in post-production support, Web Analysis, Repeat/Root Cause Analysis, Feedback/Customer Survey Analytics.

· Displaying enthusiasm with structured thought, strong aptitude for thorough analysis and creative implementation.

· Skilled consultant and strategist with skills in identifying business process needs, conceptualizing business solutions and implementing plans to achieve corporate goals and steering growth initiatives.

· Internally motivated, self-starter with ability to plan, organize and establish priorities to meet goals and achieve results.

Technical Accomplishments

· Requirement Analysis, Design, Development and Deployment of Alteryx, Tableau and Cognos solutions for corporate/regulatory reporting needs.

· Proactively migrated the projects to analytics platform using Tableau, Cognos, Alteryx, Composite, PL SQL and Big Data.

· Automated manual processes by creating dashboard/reports using Tableau /Cognos

· Data visualization experience using Tableau. Development of the Dashboard reports as per business requirements and engagement with global/internal stakeholders.

· Used Cognos and Tableau Rest API in order to automate user onboard process in the system.

· Integrated each tableau Dashboards and Cognos Report with business application portal by creating menu, keys, with user access security using Liferay portal management IDE tool.

· Developed Data model by writing logics and calculations in Cognos FM, Cognos Designer (Cube) and PLSQL to integrate and transform data as per reporting requirement.

· Developed mapping by writing SQL Query/scripts to map upstream source data to defined business products and or liquidity coverage ratio report lines for regulatory reports.

· Expertise in OLAP-DWH, Data modeling (Relational/DMR, MDX/Cube modeling) using Cognos Framework manager and Transformer/Cube designer.

· Expertise in ETL, SQL Stored procedure, SQL package, Load script, performance tuning, data cashing.

· Very good experience in data transformation from one form to another i.e. XSLT, XML, JSON, Tabular, Streaming, unstructured data etc.

· Graduate in Statisticsand experience in statistical analysis.

· Ability to learn new technologies quickly and deliver best as per business requirements and transform numbers to Business Insight.

· As Scrum master Ensures the team lives agile values/principles and follows the processes, practices that the team agreed they would use.

· Experience playing the Scrum Master role for more than 3 years for a software development team that is diligently applying Scrum principles, practices, and theory.

· Demonstrated understanding and practical experience with JIRA (and JIRA Portfolio).

Knowledge of well documented patterns and techniques for filling in the gaps left in the Scrum approach (example: Burndowntechniques, Retrospective formats etc)

Timeline

Technical Sys Analyst Staff

Juniper Networks India Private Limited
2021.08 - Current

Assistant Vice president

JPMorgan Services India Pvt. Ltd.
2019.12 - 2021.08

Senior Consultant

Optimum Solutions Pvt Ltd
2018.09 - 2019.10

Assistant Vice president

JPMorgan Services India Pvt. Ltd.
2014.10 - 2018.08

Lead Consultant

Genpact Headstrong Capital Market
2013.08 - 2014.09

IT analyst

TATA Consultancy Services
2012.02 - 2013.07

Cognos Consultant

Steria India
2010.09 - 2012.02

Software Engineer

KPIT Cummins Infosystems Ltd. Pune
2007.09 - 2010.09

MCA - Computer and Information Sciences

Bansal Institute of Science & Technology

Bachelor of Science - Statistics

Awadhesh Pratap Singh University
  • CSPO - Certified Scrum Product Owner (Scrum Alliance).
  • CSM - Certified Scrum Master (Scrum Alliance).
  • Certified Scrum master (Scrum-institute.org).
  • Certified Alteryx Advance Designer.
  • Certified Alteryx Core Designer.
  • Six Sigma Green Belt.
  • IBM Cognos BI OLAP Modeler.
  • IBM Cognos BI Reports Author.
Ashish Singh